Jump to content

Crapinon

Legacy Members
  • Posts

    1343
  • Joined

  • Last visited

Everything posted by Crapinon

  1. Since they're all 1920's genuine gobbledy gook, how about this? Applesauce Applesauce Bunk Corn-shredder Hotsy-Totsy Hooey Whoopee A&M https://www.yourdictionary.com/articles/1920s-slang
  2. I've never sailed on the open sea but a friend of mine who does is worried about this. Though it won't eat you after it hits you. https://www.yachtingworld.com/news/could-a-floating-shipping-container-sink-your-yacht-is-the-danger-to-sailors-real-or-imagined-107508
  3. My wife came home with an old worn out exercise someone was donating to Gooodwill. She had to have it so she could exercise at home. It remained in the corner of the bedroom 10 days before the first piece of clothing was draper over the handle bars.
  4. Crapinon

    Getting old sucks

    Years ago, I was getting on a small regional carrier and had a panic attack while boarding. It was only a 30 minute flight so I was going to tough it out, but the longer it took to take off, the worse it got. Right before we were supposed to leave, they announced that there were problems with the plane and we were going to have to disembark for another plane. When I got on the next plane, I had no problems whatsoever. I think this was going to happen. .
  5. I was able to get a spreadsheet with both sets of part numbers. Now it will work like I need it to work. Thanks for the help in finding the correct functions. XLOOKUP works great.
  6. I had tried that, adding ,2,1 to the end of the formula. But it is returning the wrong info. The search criteria is on sheet 1 is SK-A-050. I would like it to find A-050 on sheet 2. But the info it finds on sheet 2 is SET-900009. I thought it went to the first "S" it found but there are other parts that begin with S before it. I found this on a Microsoft page but I can't figure out how to put it in the formula: Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria. Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set". Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started". Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".
  7. "I carry a 365. Wish I had gone with the XL or slightly larger option. It’s a small gun, very easy to carry/conceal, not so great at the range. Small guns are hard to shoot effectively." Our church has no restrictions on carrying firearms, though no one open carries. We have a security team headed by retired LEO's. Once a year we have a meeting to see who is carrying and trying to go over scenarios with everyone. It's not perfect but it is what it is. At our last yearly meeting, 40-50 people showed up. At least 20% of them were 70+yo women who carried small pocket pistols in their purses. I told my wife if there ever was an active shooter situation, the safest place would be on the ground, because shots are going to be flying everywhere, most of them flying wild.
  8. OK, I've figured xlookup out with one caveat. The part numbers on our website master sheet have our vendor prefix before the part number. Our vendor price list do not. So in sheet 1 the part number is SK-A-050 and on sheet 2 it's A-050 (no prefix). I've tried "*"&{column/cell}&"*" to see if it would just pick up the A-050 but it doesn't work. If I add the SK- to sheet 2 part numbers, it works perfect. But I've got 1000's of parts with different prefixes and can't add to all of them. Is there anyway to have xlookup look for a partial match in the part numbers, no 2 letter prefix?
  9. CEO is easy. Fire people and make people do double duty, drive the short term company profits up and cash out your stock options.
  10. I don't think so. It means more padding and the heavier the glove the more energy you have to exert to move it. "A heavier glove does not hit harder, nor does it hurt the opponent more. Choosing a heavier glove is more about ensuring the safety of you and your partner than about inflicting damage on an opponent. Heavier gloves have more padding, designed to better soften the blow of a hard hit as you leverage your body weight into a punch. To hit harder, work on improving your technique - not sizing up your gloves." https://blog.joinfightcamp.com/boxing-equipment/boxing-glove-ounces-explained/
  11. Bobby Riggs was a tennis hustler deluxe. I know he had a angle to make money, even while losing.
  12. They're wearing 16 oz gloves. While I have no doubt me being hit by Tyson wearing them would kill me, in the world of boxing it's akin to being hit by a pillow.
  13. Since it's aggy related... An random aggy Instagram man-whore claims to have had an affair with Nick Saban's married daughter, Kristen. Said he's being blackmailed by some random person who has questionable sourced pics of them hugging each other, while he's wearing a t-shirt with Saban wearing a crown. WTH and who cares?
  14. IDK....if everyone put there wheels on the parking lot line, cars would be spaced perfectly. Maybe she's trying to start a trend.
  15. Thanks! I'll play with it this afternoon. Duplicate parts numbers will be almost nil. I'll let you know how it works and thanks again!
  16. I'll try to get e screenshot but basically what I'm trying to do is this: We have a master sheet of our web products on sheet 1 of an excel file, in alphabetical order by part number. Column A contains the part numbers, B the description, C UOM, D Main category location and E secondary category location. I imported our vendors spread sheet on sheet 2 of the same excel file. On that sheet (2) column A is part number, column B Description and Column C is the list price. I would like to get sheet 1, column A to find the corresponding part number on sheet 2, column A and bring the list price from sheet 2, to a new column F on sheet 1. Not all the part numbers are from the same vendor so I thought I could import each different vendor price list to a different sheet and repeat the process. I tried using the VLOOKUP function, but the formulas I found on the internet wouldn't work the way I wanted and always returned a null value or "incomplete formula". Thanks again for the help!
  17. I need some help with Excel functions. I have to update pricing on our website by pulling list price from vendor supplied price list. I can get the website content list sent to me in Excel. I would like to set the website content Excel sheet to find part numbers on Excel sheets supplied by our vendors, then import the list price for each item from that sheet to our website sheet. It seems like it should be easy to do but I've searched all day trying to figure out how to do it. I'm sure I'm not putting the correct terms in the search engine. Any help or direction to help would be appreciated.
  18. Right now I'm just looking for some good range ammo to shoot.
  19. I'm trying to buy some .308 ammo for my SFAR. I'm always looking for a deal and know a lot of the sites to check. A lot of the vendors are selling cheaper ammo made by companies I have never heard of (Bullets 1st, Igman, Veterans Ammo) and some from overseas makers (GGG). But seeing Brat's picture of the split in half .357 makes me nervous about buying from a manufacturer I'm not familiar with. Does anyone have any insight or sources that list the quality of ammo offered? Other than social media, which is too easily manipulated.
  20. Hey, this thread is for AI, not real photography.
  21. All the gun deals and Walther talk helped me remember this (they have some good Walther deals right now). If not allowed I'll take it down. A friend of mine is GM for this company: https://www.cdnnsports.com . At one time they were the largest firearms accessory dealer in the country. The owner has contacts all over the world and has a keen sense of what's coming concerning firearms. He will list some unbelievable deals to stay ahead of the curve if he thinks he'll get hung with inventory. All firearms must go through an FFL but accessories are shipped straight to you. And you might catch him selling one of his .45/70 gatling guns (they're legal to own) if you have an extra 18K laying around.
  22. I read that originally Brando was supposed to be in special forces shape (or at least thin) to fit the role. But he showed up at the filming 90 lbs overweight and he never read the script or the book Heart of Darkness. Coppola knew how difficult Brando was to work with so instead of fighting him on it, he decided to film it with him in black clothes and in the shadows. It worked.
  23. Blind date saw the original cut at the theater. I watched Redux last night. And after watching it again I realized it would be best seen on the big screen.
  24. Watching Apocalypse Now. I took a blind date to see it when it first came out. I learned it wasn't a first date/chick movie.
×
×
  • Create New...