Jump to content

40acredropout

Burnt Ends
  • Posts

    1272
  • Joined

  • Last visited

Posts posted by 40acredropout

  1. @Serak The Preparer@Dahobbs

    Thanks guys-  both of these get the job job and I'm going to roll with it.  It's annoying to me because it seems like it should be easier than it is.  I think about the way you can use an index(match,match) function to find a value across both an array with both row and column conditions... seems like you should easily be able to use that same functionality to include a sumif / maxif/ averageif/ whatever function over an array selected by said condition but....  I'm stumped and cannot find an example of doing that anywhere.

    Anyways, thanks again for taking a look and helping me get what I needed.  

  2. 45 minutes ago, Serak The Preparer said:

    When you say 200 columns, do you mean you have Stat 1, Stat 2, ..., Stat 200 for example? So that in your actual data set you are trying to figure out which Stat is the largest for a given city/year?

    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. 

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

    image.png.344c234e276a8600c21b649512130df8.png

    formula example.xlsx

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

  5. On 2/14/2021 at 8:10 PM, troph said:

    Happy to look. Just seeing this.  Non-compete/nonsolicitation are the provisions to focus on unless it’s exec level then termination, severance etc.  if equity is involved then vesting, termination rights, buy back, and tax matter too.  rest of it matters but there is only so much you can do with confidentiality etc.  most PE management teams are transactional meaning they’ll come after you if it makes sense, so assume they will enforce. 

    I'm super late to the game here but going to PM you. 

    • Hook 'Em 1
  6. 7 minutes ago, Johnny Sack said:

    North Dakota has a high death rate but did not ruin their economy and the finances of their residents. Other states have a high death rate, high unemployment rate, and fucked over every retail business that isn't a big chain or Amazon. I suspect the latter will have higher excess deaths when you factor in suicides and substance abuse caused by the ineffective mitigation mandates.

    And North Dakota's governor did not get an Emmy or write a book about her successful Covid response.

    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.

  7. 16 minutes ago, FunkSoulBrother said:

    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.  

  8. 4 hours ago, Dbeasy said:

    Bumping this just to say patio/cover companies suck. After giving up for a few months in trying to find a reliable patio company that can quote the job and simply follow-up, I gave it one more shot. I reached out to another firm and at first it was awesome.

    I gave them drawings of what to build, and they came out to look and drew up a quote within a day. They then provided two references which were solid. I sent them an email to send me their final quote to address a few open items. Ghosted. 

    This now makes something like 7 firms that just simply have blown us off, even though they say they want the work, can do the work, and I didn't even negotiate them down on price at all. And instead of just saying they are too busy, they just never got back to us. And no, our requirements are not unusual or unreasonable and we aren't dickheads.  It's just a bunch of terribly run companies.  Amazing.

    So, we are back looking at boats.  If I can't get a patio/cover built, I might as well have some other recreational activity to do this summer.

    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.  

  9. 13 hours ago, DonkeyCigars said:

    I'm thinking hard about doing some passive, apartment and/or mobile home syndication investment. Total return in the apartment syndication industry I think is benchmarked at 12-15% annually, but with mobile homes it can be up to 30% which is pretty insane for being silent partner and not having to do any of the work or go out to Kansas/Iowa/Nebraska.

    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.

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

  11. 3 hours ago, Dijon Robinson said:

    Seek therapy. If BMDs wanted to donate to save jobs in the athletic department I'm sure CDC would have taken the money. Blame the fat cats, not him.

    This... I thought the buyout was funded entirely by BMD donations for that specific purpose?  

×
×
  • Create New...