Jump to content

capnamerca

Certifiably Surly
  • Posts

    761
  • Joined

Posts posted by capnamerca

  1. 4 minutes ago, demos said:


    I see lettuce. It qualifies.

    And honestly, pretty damn healthy. Good protein, I don't see rice or quinoa so should be low-carb, ain't nothing wrong with some hard boiled eggs and OG shredded cheddar. A-, would eat.

    • Hook 'Em 2
    • Like 1
  2. Who was it on the old site that used to do game breakdowns each like? The mini film study really helped guys like me who never played football beyond 7th grade. He'd use clips from a replay and make a few of them into gifs with lines drawn on them, and then explain what the key players were looking for, what the key concepts were, and why it worked or didn't work. And it was awesome because it wasn't all sunshine pumping - he'd show plays where the opposition just straight up beat our D, or where our O overcame a missed block or a blown assignment to still make a play. Really helped my understanding not just of that particular game, but of how our team fit together and what our coaches were doing.

     

    I'd happily contribute to a fund or a charity or something if someone were to take this back up.

  3. 9 minutes ago, Porterhouse said:

    I guess. I’m not sure with Casey, Card, our OL, and our terrible front 7 that 9-3 was ever a real possibility. We shit the bed last year because we were a very mediocre team, at best. Our lines and linebackers were unquestionably bottom 10% in P5. 

    When the announcers called out that Brockermeyer had just entered the game at MLB, and then he fails to scrape to the hole and watches the RB waltz through for a TD, it was just #chefskiss.

    • Hook 'Em 2
    • Like 2
    • Haha 2
  4. can't this weekend - taking care of that whole "able to father children" thing on Friday.

     

    next week after work is a maybe. Aside from it being 9000 degrees outside, it's the first week of school.  Maybe next Friday morning for an hour or so? 830-930, something like that?

  5. 55 minutes ago, Murfdogg21 said:

    LOL that was a shot at myself for not hitting the cutoff man, not a shot at you. The first time I did it by accident and you let me hear about. The second time I did it for the LOLZ and would have got the runner out at home if ROFLBOX or whoever was playing catcher could catch. 

    I remember that I started laughing when the ball wasn't even to you yet, because I knew the hero shot was coming and that throw wasn't going anywhere close to me lololol

  6. On 7/14/2022 at 7:19 PM, Murfdogg21 said:

    The shaggybevo softball team that played down at Riverside and Pleasant Valley back in the day wasn’t terrible. I’d say I’m sorry we didn’t play again, except I bet y’all did play again and didn’t invite me because I refused to utilize Captain America as a cutoff man. 

    I finally find this thread, and come to find out I'm already catching strays. Brutal, guys - just brutal.

     

    I could be convinced to take some BP and play some catch ... can't this weekend, but could do something after work basically any night next week?

    • Hook 'Em 1
    • Haha 1
  7. You never realize you're in the golden age until it goes away. We did a buddies trip in 2007, maybe 2008. 8 guys. The Casino Royale on the strip still had a tub table, and we managed to snag every seat. $2 minimums with 3x odds if you wanted to play low stakes, $5 min unlocked 20x odds (or maybe 100x). We played for 12 hours straight. 

     

    During that same timeframe, you could pretty regularly find $2/2x tables (the others at the CR were this, but also at the IP and Stratosphere), and $5/345x tables were everywhere.  Man, those were good times.

  8. I swear I've used this phrase so many fucking times in the last year, and I hate it. I hate it.

     

    "I NEVER THOUGHT THE LEOPARDS WOULD EAT *MY* FACE!" shouts supporter of the leopards-eating-face party.

  9. 6 minutes ago, davidg said:


    Flush and sanitize your water system. Drain and flush the water heater (and inspect/replace the anode if it has one)

    Inspect all the tires, air them up to recommended pressure (or close to max. I run my trailer tires 5lbs less than max cold.). Check the spare too.

    Inspect the roof tears/holes and for cracks in the sealant. Re-seal as necessary.

    Inspect/re-pack the wheel bearings if it has set up a while or a lot of miles since last done. Check/adjust trailer brakes while the wheels are off. Torque the wheel lugnuts to mfr spec. Re-torque after 100-200 miles. Important if you have aliminum wheel.

    Inspect the suspension for cracks, bent parts or missing bolts.

    Check battery water levels/top off with distilled water.

    Great stuff. 

    Had a full re-seal late last year so I'm confident there. 

    Sanitize water system - love that.

    tire check - great call. 

  10. Pulling the rig out of storage and to my in-laws place where they have full hookups. Going to give her a full once-over - aside from the obvious things like water lines/pressure, checking lights / switches, battery charge, smoke alarms, tire and trailer integrity, general shell integrity, the pumps, and the water heater, what other items are usually on your pre-season checklist?

  11. 4 minutes ago, Dahobbs said:

    I don't believe this is possible in Excel or Google Docs, at least absent some custom VBA code. What you've done to move everything over is the correct answer.  

    My old days as a firmware programmer in college pop up in weird ways sometimes :). All I want to build is a translation lookaside table (reference to a reference). But yes, moving 24 rows around and joining them with 12 rows in the top table is a drastically simpler way to do things lol. Thanks again.

    • Hook 'Em 1
  12. Apologies for going down a rabbit hole here :).

     

    I"m building out a list of matchups for a golf tournament. The player pool is divided - three teams of twelve. We're currently moving teams around, playing with matchups, etc. As we move players around, I want their handicaps to follow. I"m not skilled enough to figure out index+match when the data is in three separate tables. But what I do know is that handicap is always one call to the right of the player name, and so what I really want is an indirect reference that references another reference (lol).

     

    image.png.fb8fa2dea13df75dbe04c5dc76b0bd69.png

     

    In the table above ... two separate tables of players. Building the matchups on the right. G5 contains "=b4", and so gets populated with 'Bill'. What I was gunning for was something I could put into H5 that would say "ah, I see you referenced cell b4, I'll get the value from one to the right of b4" and then it would resolve itself to a reference of "=b5", and thus populate itself with '5'. 

     

    I think from what you said above that Index can handle searching across multiple tables. I think that's the official answer. What I've done is moved to one large player table, and am now using index+match, and all is well.

     

    It's also hard to explain things in writing, and we've now officially spent more time messing with this than it's taken me to just rearrange the data into one big table :). I really do appreciate ya'lls suggestions.

     

     

  13. The former. 

    6 hours ago, 40acredropout said:

    Are you saying that all you need to do is refer to Player X in a cell and have his handicap pop up in the next?  Easiest way to do that would be index / match combination.

    If you’re saying you want to refer to Player X and have a formula to automatically determine Player Y by some criteria (closest handicap?), that would take an extra step.  

     

  14. This seems to be a relatively recent Excel thread. I have a non-emergency question that is bothering the shit out of me. Also, I'm technically working in Google Sheets (it sucks), and for now that isn't changeable.

     

    I have data in two columns - Player and Handicap. We're using this table to put together matchups for a tournament. Without getting into why I'm using the data the way I am, I need the following:

    * In a separate section, I reference the main players/handicaps table to build matchups.

    * When I reference a PLAYER (i.e. "=A1") in a cell ... I want the next cell over to reference that players handicap.

    *Ideally, I could do something like "=A1+1" which would resolve to "=A2"

    *The behavior is to allow me to change player references and have handicaps follow me around.

    *The table of player/handicaps cannot be alphabetized (for reasons, this isn't negotiable), otherwise I could just VLOOKUP it.

     

    I've already spent WAY more time on this than Ishould, and now it's mostly professional curiosity to see if I can get it to work. 

     

    I've looked at INDIRECT and OFFSET, as well as playing around with TEXT() options, and nothing gets me what I want. 

×
×
  • Create New...