Originally Posted by narlith
Could not check with SND glyph, got a weird error with #VALUE! screaming everywhere.
|
I have now encountered the same error.
I
think this happens when your minimum SnD size undershoots 1. With my current gear my "Max SnD Size Needed" in the Calcs sheet is 0.984738794. Which is then floored to 0 in the next row, which then results in a #VALUE error in the subsequent calculations.
I'm not sure if my fix is actually correct, but I simply added a
MAX(1,-current formula-) around the formula in the following whole rows in the Calcs sheet:
Row 375
Row 376
Row 633
Row 634
Row 899
Basically all the "Floor Size" and "Low Size" rows (except the last one, which worked without changing).
Doing this sets the minimum SnD size to be used to 1 combo point instead of trying to use 0 combo points (at least I assume so).
Now if this change doesn't break any calculations, it shows the SnD glyph to be inferior to Rupture and therefore shouldn't be used.
Meaning the glyph recommendation for a rupture based spec remains TotT, Killing Spree and Rupture.