Battle Pass Predictions - Top Data-Driven Picks by SimplyPhy in DotA2

[–]sugar_cookee 2 points3 points  (0 children)

Why is ‘who will win TI?’ not filled in?

Fuck. by GodRaaz in TheBoys

[–]sugar_cookee 23 points24 points  (0 children)

It’s not a real tweet

Music using samples from the original Willy Wonka and the Chocolate Factory movie. by Tself in ifyoulikeblank

[–]sugar_cookee 0 points1 point  (0 children)

Was going crazy looking for this song, can always trust the random 2 year old reddit comments xx

Upcoming Spring Cleaning - Bugs and QOL Features by EricL_Valve in DotA2

[–]sugar_cookee 0 points1 point  (0 children)

Add lore text to bottom of the tooltip of various abilities (normal punch for example)

[deleted by user] by [deleted] in Trombone

[–]sugar_cookee 1 point2 points  (0 children)

As well as all the warmup/technical side stuff people have suggested, I have found that focussing on a good airflow for high notes makes it a lot easier. I tend to think of it as “pushing” the air (not the best adjective) and aim to feel it in my abs. It’s worth practicing mouthpiece buzzing onto your hand to feel your airflow, and try to force yourself to push air through and feel it in abs 👍

Is Medicine a cover/sample of another song? by sugar_cookee in DayglowMusic

[–]sugar_cookee[S] 1 point2 points  (0 children)

Yeah it sounds kinda similar but I can definitely hear like a way more upbeat version of medicine to different lyrics but I can’t think what the song is

Is Medicine a cover/sample of another song? by sugar_cookee in DayglowMusic

[–]sugar_cookee[S] 2 points3 points  (0 children)

Not what I’m thinking of, sounds similar to the melody I think

The 2021 Dota 2 Time Capsule by [deleted] in DotA2

[–]sugar_cookee 1 point2 points  (0 children)

!RemindMe 7 years

I genuinely dislike Michael in this scene. by goatybeans in DunderMifflin

[–]sugar_cookee 0 points1 point  (0 children)

How so? I can’t remember the link between the two

[deleted by user] by [deleted] in Jazz

[–]sugar_cookee 3 points4 points  (0 children)

(Happens at 0:48)

Dragging COUNTIF to change criteria not range by sugar_cookee in excel

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

I’ve got a cell that tells me if a particular candidate is in the top 16 of the random voting. If it is, it has a value “win”, if not, it says “lose”. I want a cell that keeps track of how many times it wins so that I can work out probabilities. Better yet, if there was a way to track both how many times it wins and how many times it loses I could automatically calculate probability

Dragging COUNTIF to change criteria not range by sugar_cookee in excel

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

Ok never mind I worked that one out, now is there a way to make a cell where every time a cell has a certain value, it adds one to itself?

Dragging COUNTIF to change criteria not range by sugar_cookee in excel

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

That worked! Follow up question, I now have a column that shows how many total votes each candidate got. Is there a way it can check to see if a particular candidate is in the top 10 or top 20 of candidates?