Jump to content

Crapinon

Legacy Members
  • Posts

    1118
  • Joined

  • Last visited

Posts posted by Crapinon

  1. 1 hour ago, BehoId, The Underminer! said:

    I bet cardio decides it.  Tyson will still have old man strength and if he can hit him early, it'll be lights out (fingers crossed).  If Paul can clench and jump around the ring for a few rounds, there is no way a grandpa can keep doing that forever.

    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. 

  2. 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?  

     

  3. 11 hours ago, ROFL BOX said:

    I watched her park - the white vehicle to the L was already there.

    20240501_150506.jpg

    20240501_150532.jpg

    IDK....if everyone put there wheels on the parking lot line, cars would be spaced perfectly. Maybe she's trying to start a trend.

  4. 17 hours ago, Dahobbs said:

    My main concern would be that your vendor part list may have duplicates of parts numbers for some reason or another. Personally, I've always used Index Match rather than a lookup function because it is more flexible. Frankly, I wasn't aware of xlookup until recently and haven't played with it. But my understanding is that it addresses some of the limitations of vlookup. 

    Anyway, based on your description, it would look something like this:

    =index(table2,match([@[part number]], table2[part number],0),3)

    First, I'm assuming you've turned your sheets from ranges into a table (select the data and press control 't'). There are a few reasons to do this, including that it prevents sorting from fucking up your data and that it makes these formulas easier and more readable.

    I'm also assuming the Vendor sheet table is named table2. And I'm assuming your web products sheet is also a table, but the name isn't important for the formula.

    Finally, I'm assuming the name you provided above for the columns is the actual column header. If it isn't, just adjust the formula to match the header column wording. 

    This formula compares the part number in your web product sheet to the part number list in the vendor sheet. When it finds an exact match, it outputs the third column (list price) from your vendor sheet. 

    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! 

  5. 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!

  6. 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. 

  7. 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. 

  8. 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.     

  9. 18 minutes ago, 52-80 said:

    Bald white man in the black pyjamas. Worthy fucking adversary. 

    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. 

  10. On 4/19/2024 at 9:25 PM, Thetexashammer said:

    OK I have a story to tell. It is time to come clean. This is a from a few years ago, but I am only now beginning to heal the emotional scars.

    So I do a loop around Dallas on my bike. It's maybe 40 miles. I am on a road bike, Spandexed out, I have to take some actual surface streets in addition to bike paths, including Hillcrest north of Highway 12. I go through White Rock Lake, down to the AAC, and then up the Katy Trail and past SMU.

    The last bit is the relevant part. Highland park is residential, mostly. So I am going north on Hillcrest past SMU, having a grand old time. Feeling great. And I feel and hear The Gurgle. Pressure. I know there are only private homes. Rich people who do NOT want to talk to me. My gut told me I was fighting a lost cause. Fecal urgency soon turned into a lack of fecal urgency. And that's when I discovered how lucky I was.

    Now the key here is my outfit. I have boxer briefs, of the polyester variety. On top of that, spandex. Two layers. It formed a container of sorts. If you can imagine. Biker shorts are tight on the legs, so the don't slide while riding. All black, so I'm good there. After proceeding a bit, I was confident that I was watertight. Had to be at least a liter of fluid like substance back there.

    This of course created a small difficulty, in that there is a seat on the bike. I could not imagine that squishy feeling of sitting on it. Worried I might lose containment, I refused to sit , I stood on the pedals the whole way home. Like the rape scene in 300, I did not enjoy it, and it was not over quickly. I had like five miles to go with a couple major intersections.

    The piece de resistance of the entire glorious event was the shower scene. You really haven't lived until you enter a room with a liter of poop in your undies. After rushing past others so they would hopefully not find out what happened (I did not make eye contact), I walked fully clothed into the shower. It was fairly emotional. I do not like poop, it makes me dry heave. But there was waffle stomping that day, believe me. It was like something out of The Shining. The shower was of the straight down sort, so the pieces got all spread out and I had to really focus on getting all the stray bits. There wasn't merely a crime, there was also the coverup.

    Something like that really changes your perspective on things. I have other stories that shall not be told. 

     

  11. 2 hours ago, nnm said:

    That’s because you are a sheep. You probably inhaled some chemtrails and are controlled by the microchip that’s been surreptitiously implanted in you. 

    You forgot to mention being activated by 5G cell tower.

    • Prepare your anus 1
  12. 18 hours ago, Vic Mackey said:

    Some women like the thrill of sneaking around, having someone "forbidden" and being that 'other woman'. No idea if that story is true but absolutely women out there like that. 

    Yeah, I worked with a woman like that. She was always dating married men or guys 20+ years younger than her. I think she loved the thought of stealing someone's husband and the power it gave her. A friend of mine left his wife for her and she dropped him immediately. She loved to tell other women she stole their man. And if you pulled the fake wedding ring trick on her, I have no doubt that she would stalk you until you were really married and then call your wife up and lie through her teeth about you cheating with her. 

    • Like 1
  13. 10 minutes ago, tbone_ said:

    Just learned today that the presumed successor to our current CEO is aggy. Fuck me. And here I thought the future looked really good.

    In the 80's I worked for an industrial supply company that was about 75% (red ass) aggy upper management, including several football players. The group think was unbelievable. Once we got an aggy president and ceo, the sales trajectory looked like the aggy rollercoaster in October. It took them about 8 years to destroy a 90 year old company. You might have the unicorn that can run a company. But if he starts bringing in other aggy's, you're toast. 

    • Hook 'Em 3
  14. On 3/17/2024 at 1:04 PM, Dewey said:

    Just like everything else he railed against, if Bama can figure out a way to keep up with the big boys, Saban will stop having a problem with it. Dude paid his players and their families big and then said it was pale grants 😂

    Get back on the pontoon, drive around moonshine lake and stfu. 

    Is pale grants another way of saying under the table payments by old Bama grads?

  15. 14 hours ago, High Plains Drifter said:

     

    WIth my wife its shoes. 

     

    I bought a new pair of hiking boots about a year ago, then maybe a month later, I bought a new pair of steel-toed work boots. Literally been over a decade since I had bought a pair of either. She asked me why I needed both types of boots. I didn't say anything, just pointed to the 20 pairs of shoes (all hers, except one pair of mine and one pair of my daugther's) stacked in the hallway next to the door. 

     

    Mine too. I offered to but her nicer purses (Kate Spade, Coach) for gifts but she says she won't spend more than $20 for a purse. And she buys one once every 2 or 3 years. But shoes are a different story. She doesn't buy anything expensive but she has more than she can ever wear. 2 hanging racks in her closet and a 3 layer shoe shelf next to the bed. I have 2 pair of dress shoes, a pair of steel toed boots, 1 pair of hiking boots and 2 pair of tennis shoes. Newest purchase was a couple of years ago. 

    On another note, we had our 41st anniversary last week. I bought her roses and offered to take her out to dinner and go look for a gift. She said she wanted to stay home because there were TV 2 shows she wanted to watch. So she watched her shows and FB videos. She never got out of her chair that evening, so I handed her a card while she watched TV. I never got her a gift but she got me a hoe. And not the fun kind. Who says romance is dead?

    • Haha 3
×
×
  • Create New...