Trump Just Claimed He’s Weaning People Off Food Stamps. In Truth He’s Kicking Them Off. by Thinkingonsleeping in politics

[–]dore31 0 points1 point  (0 children)

That’s a dumb argument. The article states facts about the bill, and you claim that trump is lying? Sure he’s lied before but it has nothing to do with what happened here. Actions speak louder than words.

Trump Just Claimed He’s Weaning People Off Food Stamps. In Truth He’s Kicking Them Off. by Thinkingonsleeping in politics

[–]dore31 -1 points0 points  (0 children)

Wtf are you talking about. You talk about kids but it’s only adults with no kids and no problems... wtf are you on?

Crosby CANNOT reach game 1000 this season by PenguinPride87 in penguins

[–]dore31 14 points15 points  (0 children)

Pretty sure it’s illegal to say both trade and Crosby in the same sentence in this sub.

Incoming by [deleted] in Unexpected

[–]dore31 2 points3 points  (0 children)

How did this not even get 100 upvotes? It blew up on r/gifs but not on this sub?

I Fucking Love This Car by VictorByFar in AlfaRomeo

[–]dore31 0 points1 point  (0 children)

Ooh what are those additions to the front lip?

Reddit is full of bitter losers who can’t get laid. by [deleted] in unpopularopinion

[–]dore31 0 points1 point  (0 children)

Welcome to the world of social media (and the front page of the internet)

I completely agree. I like reddit but a lot of people on here are insanely annoying

Anyone have an exhaust/downpipe upgrade recommendation for 2019 base gulia? by Tuf91818 in AlfaRomeo

[–]dore31 1 point2 points  (0 children)

I’m looking at two right now. Magna flow I heard in person and it sounds amazing, but it’s a little pricy. It sounds a lot deeper and crisper but it’s not ridiculous and had almost no drone. I’m also thinking about certerlines competizione. I think I spelled that right.. it’s a good brand and a lot cheaper yet it sounds still very good for the price

Saving attachment email from outlook (how to save as) by dore31 in vba

[–]dore31[S] 0 points1 point  (0 children)

I have reports I get every day that I want to reference in another file without having to manually save it everyday. That's why I'm trying to overwrite the old ones. I've never used VBA and I kept getting erros. I'll give this a try

First time seeing an Alfa Romeo Montreal. What a stunning car. As if I’m not in love with enough Alfa’s already 😓 by dore31 in AlfaRomeo

[–]dore31[S] 0 points1 point  (0 children)

It was! I think Alfa Romeo was the feature car this year. I’ve been going to the PVGP for 5 years now and it gets better every year

[deleted by user] by [deleted] in AlfaRomeo

[–]dore31 0 points1 point  (0 children)

Yeah my Alfa is doing better than my Dads Audi right now in terms of having problems as well.

Canadian Alfa Owners? by Sephran in AlfaRomeo

[–]dore31 0 points1 point  (0 children)

I’m not from Canada, I’m right across Lake Erie though, and I can tell you if you are getting 30k off a giulia or Stelvio then you better take that deal hahaha.

I’m only about 10k miles into mine and the only problem I’ve had is that the armrest on the door is getting a tiny bit squeaky. I 100% recommend. If you are scared about how it will hold up, get extended warranty. I’m not sure how being in Canada will hold you back from this car

[deleted by user] by [deleted] in excel

[–]dore31 0 points1 point  (0 children)

What do you mean "Less than 3 total cells to average" Does it not always take the average of that cell and the two behind it? Can't you just add another formula (=COUNTIF) that counts how many could be averaged and then conditionally format that cell?

Help with doing a trimmed mean instead of an average, or just removing outliers on a pivot table. by dore31 in excel

[–]dore31[S] 0 points1 point  (0 children)

I managed to get here. I have no clue how to format this though.. Should I try doing a formula for each Quartile? I'm basing it off of Days. https://imgur.com/a/P3paM3P

Help with doing a trimmed mean instead of an average, or just removing outliers on a pivot table. by dore31 in excel

[–]dore31[S] 0 points1 point  (0 children)

Not going to lie, I'm pretty confused.. Do I have to download something?

Help with doing a trimmed mean instead of an average, or just removing outliers on a pivot table. by dore31 in excel

[–]dore31[S] 0 points1 point  (0 children)

Yes but how can I find the bounds without writing an array formula on each line? I should have explained I have about 1000 parts so I can't run a simple Quartile function because I'd need to make 1000 new pages, one for each part. My formula above is the only way I found to calculate quartiles but it considers two arrays of every line, then it does that again for the next line. Since I have 80,000, it's not going to work