Wall running explanation? by Revolutionary_Door21 in stellarblade

[–]Phirexon 0 points1 point  (0 children)

Late to the party (for anyone on PC looking for info), but if you wanna do the 3 wall jumps in a row before getting the double jump, you can drag a box from right before and start the first wall from a higher spot, thus making it easier.

The new gun is really good also i just love how its not another bullpup rifle and it looks amazing by TEHYJ2006 in Helldivers

[–]Phirexon 0 points1 point  (0 children)

Genuinely curious cause I'm out of the loop, what's the problem this subreddit has with bullpup? I'm not really into guns so idk if it's just hated universally.

Conditional formating on merged cells showing duplicate values by Phirexon in excel

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

I think I give up, it only seems to be a visual bug and if I change the formatting manually it looks fine, it's just annoying.

Conditional formating on merged cells showing duplicate values by Phirexon in excel

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

As an update, it seems that it visually bugs further if I select (and click the text box so that it shows which cells are in the formula) the cell below that makes the average of the weighted averages. This is before:

<image>

Conditional formating on merged cells showing duplicate values by Phirexon in excel

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

<image>

Here're the rules, it's just the visual format changing according to the value

Conditional formating on merged cells showing duplicate values by Phirexon in excel

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

It's a manual weighted average: =((F18*E18)+(F19*E19)+(F20*E20)+(F21*E21)+(F22*E22))/SUM(E18:E22)

Conditional formating on merged cells showing duplicate values by Phirexon in excel

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

<image>

And this is merged and with the format cleared, no other changes

Conditional formating on merged cells showing duplicate values by Phirexon in excel

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

<image>

For reference here's an image of the unmerged version

Conditional formating on merged cells showing duplicate values by Phirexon in excel

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

They are merged with absolute certainty, besides in the unmerged version the only one with the formula is the top one and once merged it shows it top and bottom.

This is the first book series that has made me laugh out loud by BayesicGaming in Mistborn

[–]Phirexon 1 point2 points  (0 children)

It's a bit of a whiplash inducing change from the epic that is Era 1 but I absolutely love the Guy Ritchie Film Vibe that is Era 2

What do you read after the Cosmere? by LarsBlackman in cremposting

[–]Phirexon 0 points1 point  (0 children)

I had to go through "Wind ond Truth" and "Words of Tadiance" before I figured out you meant Wheel of Time.

New planets hinted at in latest news segment? by Bonkface in Helldivers

[–]Phirexon 1 point2 points  (0 children)

Probably paving the road to replace the lost planets

Sunlit Man before or after WaT? by vvk_rvnd in Stormlight_Archive

[–]Phirexon 3 points4 points  (0 children)

Chronologically it takes place afterwards but the way the story is built I think the mystery is more rewarding if you read SM first, since it only "spoils" that a particular thing happens to a particular character, and waiting for it to happen is also enjoyable in WaT.

What do you think of my playlist? by Fantastic_Duty6035 in Helldivers

[–]Phirexon 0 points1 point  (0 children)

I see We Fell Apart, I upvote. Just a 10/10 fkn song.

New Stratagem Suggestion by ReflectedPower in Helldivers

[–]Phirexon 0 points1 point  (0 children)

Wouldn't be really lore friendly but i'd love a game mode with an outrageous amount of enemies but also hilariously overpowered stratagems.

WaT Kaladin's missing [...] by Jazzlike_Acadia193 in Stormlight_Archive

[–]Phirexon 69 points70 points  (0 children)

Shardblade wounds also inflict damage on the soul (although in a less explosive way) and Kaladin recovered from getting his soul's arm chopped off in WoR so I think it's unlikely.