Jump to content

40acredropout

Full Members
  • Posts

    1296
  • Joined

  • Last visited

Everything posted by 40acredropout

  1. Correct that here are ~200 columns of different statistics. But not trying to identify the statistic that is the largest in a given city / year. Trying to find the largest value in the specific statistic column that is defined in a dropdown assumption (cell C5 in the example) for that city in those years. So cell C6 is the answer I would be looking for, I just don't know how to write that formula. Hopefully that makes sense? Thanks for taking a look.
  2. Calling on the wizards. I'm usually able to find solutions with a google search but am running into a wall. Below is a simple example of what I'm trying to accomplish. I have a large set of data (200 columns, 25,000 rows) and I am trying to write a formula that will return the max value given the criteria of 1) time period, 2) city, and 3) statistic (column), which will all be selected from a dropdown; goal is for the formula to dynamically calculate based off these inputs and refresh to correct answer when assumptions change. . I was able to figure out how to do this for the sum and average but am stumped here. formula example.xlsx
  3. Just finally tried out Tony C's. Good draft beer selection (to me) and pretty good happy hour deals. Had the Primo and it was alright. It'd be hard for me to put the pizza close to Pinthouse, Home Slice and Buffalina. Cool space though.
  4. I'm super late to the game here but going to PM you.
  5. Comparing the response/resulting statistics of a state who's largest city is 100K to Texas or California or any state with highly concentrated metro centers isn't at all apples to apples. If LA or NYC didn't implement the "ineffective mitigation mandates" you really believe the resulting increase in deaths would be less than what they'll now be left with at the hands of suicides and substance abuse? Yeah right.
  6. Kids name is even Walker. They fucked with the wrong guy. Apparently Spencer Jones spent two years at Liberty before transferring to OU. No wonder he obviously had no experience in bar fights.
  7. Hoping all of your homes warm up like the DKR visitor locker room at halftime.
  8. Shit. I'm 78757- just on the other side of Mopac. Been good all day...
  9. I'm further up Burnet in North Shoal Creek neighborhood and we haven't lost power. Not sure what our link would be.
  10. Not a great week for us, my dudes. I still long for the day we take down the Tesla. I only own ~6% of the pool so I will make the most of my 1.8 days per month.
  11. Have you tried Cutters Landscaping? I haven't used them but I know the owner and have been impressed with some of the builds he's shown me that they've done.
  12. Can anyone point me in the direction of someone good/reasonably priced to review an 8 page employment agreement. Looking for a review on behalf of the employee (me) and in the PE/real estate industry.
  13. You might be surprised how competitive the mobile home space has gotten. Certainly more meat left on the bone out there than conventional MF but the sector has tightened up quite a bit in the last 5-10 years. I'd make sure you're investing with an operator with experience in the space... it seems simple enough (and it's not rocket science) but there really is a lot of shit that comes up operating a park than you can't imagine going in. Sidenote- Contrary to what my username may suggest, my experience isn't actually from living in one.
  14. 40acredropout

    Tacos

    Just had Veracruz today. The shrimp macha and al pastor tacos were both amazing. Consequently, I’m typing this from the seat of the toilet with a flaming butthole. The red salsa is too much for me.
  15. This... I thought the buyout was funded entirely by BMD donations for that specific purpose?
  16. No more perfect tickets. 63 ball did get us 3 more tickets (total of 5) up to 3 hits. No Tesla.... this week.
  17. Surly is probably one of the few corners of the internet where this guy is going to get props/support. Don't change.
  18. Happy to put it on a tee for you... very nice. My buddy played on an independent baseball team in California named after / sponsored by Dogecoin so I had some familiarity. Should've pulled the trigger when I started seeing it pop up this morning.
  19. Where'd you get in? Hit .05 a little bit ago, back down in the mid .04s now.
  20. Has anybody checked in on @Nicole44?
  21. In the APD Booking thread, why do many of the homeless people have such irregularly shaped heads/faces?
×
×
  • Create New...