-
Posts
1272 -
Joined
-
Last visited
Content Type
Profiles
Forums
Store
Downloads
Recruiting - 2020
2019-2020 Football Season
Football
Entertainment
Sports
News and Business
Cloak Room
Transfer Portal
Recruiting
Events
Posts posted by 40acredropout
-
-
-
3 hours ago, Bottlecap said:
you should film this rant in your F-650
What do you drive?
-
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.
-
-
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.
-
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.
-
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.
-
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.
- 1
-
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.
-
All gas no brakes
- 1
- 3
- 1
-
16 minutes ago, FunkSoulBrother said:
Well, looks like the wrestlers just started a GoFundme account
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.
-
Hoping all of your homes warm up like the DKR visitor locker room at halftime.
- 3
- 1
- 2
-
7 minutes ago, CleverNickname said:
Power out 78759, Spicewood/183. We were lucky... until now.
Shit. I'm 78757- just on the other side of Mopac. Been good all day...
-
29 minutes ago, Michael Knight said:
Guessing you are on the same grid as the hospitals
I'm further up Burnet in North Shoal Creek neighborhood and we haven't lost power. Not sure what our link would be.
-
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.
-
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.
-
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 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.
-
-
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?
-
14 minutes ago, HRSchenker said:
My dogecoin collection is up 3k right now lmao
How about now?
-
No more perfect tickets. 63 ball did get us 3 more tickets (total of 5) up to 3 hits. No Tesla.... this week.
-
Surly is probably one of the few corners of the internet where this guy is going to get props/support. Don't change.
-
Just now, DonkeyCigars said:
Wasn’t going to gloat but I’m up 250% since that post.
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.
- 1
Austin Homeless Free for All Ordinance
in Cloak Room
Posted
Onus is on him to prove with pics whether his wife does or does not have a penis.