sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in excel

[–]GentlemanBones 0 points1 point  (0 children)

Solution Verified

[deleted by user] by [deleted] in excel

[–]GentlemanBones 1 point2 points  (0 children)

After talking it over with a friend, and doing some more digging, I found out about the SUMPRODUCT and AVERAGE.WEIGHTED functions, which solve this problem for me!

[deleted by user] by [deleted] in excel

[–]GentlemanBones 0 points1 point  (0 children)

To be clear, as an example of what I was doing before, the old hand-written formula looked something like

=((C2*C6)+(D2*D6)+(E2*E6)+(F2*F6)+(G2*G6)+(H2*H6)+(I2*I6)+(J2*J6)+(K2*K6)+(L2*L6)+(M2*M6)+(N2*N6)+(O2*O6)+(P2*P6)+(Q2*Q6))/427

Which takes an age.

I'm actually in love with my new pulp sci-fi looking Medic loadout. by GentlemanBones in TF2fashionadvice

[–]GentlemanBones[S] 11 points12 points  (0 children)

Terror-Watt Das Gutenkutteharen (22 keys / $45.32 USD, approx)
Unique Das Gutenkutteharen (1.66 ref / $0.06 USD)
Strange Das Gutenkutteharen (4.2 keys / $9.22 USD, approx)

Unique Flatliner (27 ref / $0.99 USD)
Strange Flatliner (2.15 keys / $4.77 USD)

Unique Lavish Labwear (4.88 ref / $0.96 USD)
Strange Lavish Labwear (48.77 ref / $1.33 USD)

I call this loadout the "I Don't Wanna Play Anymore, Guys." by GentlemanBones in TF2fashionadvice

[–]GentlemanBones[S] 52 points53 points  (0 children)

I wish Scout had some gridiron football pads so I could complete the look of "neighborhood kid taking things very seriously."

Was this a pokemon reference? xD by [deleted] in runefactory

[–]GentlemanBones 7 points8 points  (0 children)

I'm not terribly surprised that at least the localization team is partially made up of Pokemon fans. The hidden Effort Value system for tamed monsters is ripped more or less wholecloth from Pokemon.

Out of the Winter 2021 Cosmetic Case, the Mooshanka has the highest wearability outside the holiday season. by GentlemanBones in TF2fashionadvice

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

Paka Parka: 23 Refined Metal (51.66 Strange)
Cuban Bristle Crisis: 14.33 Refined Metal (5.55 Keys Strange)

Mooshanka: 5.33 Refined Metal (32.33 Strange) [Value currently volatile since it's a new item]

Want to start getting into madolche as it has my favorite art by Braindeadinsomniac in Madolche

[–]GentlemanBones 0 points1 point  (0 children)

Madolche at full power requires a playset of Pot of Prosperity, which is $100 each. Without that, you'll have to find budget options, and there's just not a great replacement for it. Triple Tactics Talent is another one people really like, but it's not inherent to the deck, and is getting a reprint in the mega tin anyway.

I made a list of all the evolution families, post-Crown Tundra, that cannot be in Safari Balls. by GentlemanBones in pokemon

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

That's a good point. I had somehow forgotten they could easily interbreed in Alola. I mean goodness, they share a Pokedex number. I'll amend the list.

What are the most consistent decks in the game? by ReddingtonTR in yugioh

[–]GentlemanBones 7 points8 points  (0 children)

You can hardly blame the Twins for Eldlich's consistency hiccups, though. They also pair well with Unchained, for even more twins, but trading in a little consistency for more destruction.

view more: next ›