- Location
- The Maple Syrup Mountains
@Paperclipped, I'm looking at the Stagnancy widget in the character sheets and noticing that, if I want to check whether the next stagnancy barrier for a given domain is unlockable or not, I need to reference another value (the total XP) and do some basic arithmetic ("if the stagnancy threshold is greater than the XP total by at least X amount, the next threshold has already been cleared and no further unlocks are possible right now"). If this was handled automatically, it would let the widget display everything we need to know about stagnancy in one coherent package.
For instance, Hazou's Combat threshold is 14,000 and his total XP is 13,766. Subtract the latter from the former to get 234, which is less than 1000 and therefore unlockable. If Hazou then got a Combat unlock, his Combat threshold would become 15,000 (due to having two domains), and subtracting the total XP from the threshold would leave you with 1234, greater than 1000 and thus locked.
The same formula should work for his Sealing domain despite being offset by 500. For a one-domain ninja, you would ask whether or not the threshold is 500 higher than the total XP rather than 1000, and you'd use 1500 for a three-domain ninja.
If the problem is that there isn't enough horizontal space for an extra cell without the widget becoming flush with the Stunts box, this check could be embedded in a concatenate function in the domain cells. That is, the cell that says "Combat" could change to say "Combat (locked)" when it's not possible to further un-stagnate ourselves at this moment.
For Hazou's Combat cell, I think this would look like =CONCATENATE("Combat", IF($C52 - $S$1 > 1000, " (locked)", "")) with similar code for other cells in the widgets.
For instance, Hazou's Combat threshold is 14,000 and his total XP is 13,766. Subtract the latter from the former to get 234, which is less than 1000 and therefore unlockable. If Hazou then got a Combat unlock, his Combat threshold would become 15,000 (due to having two domains), and subtracting the total XP from the threshold would leave you with 1234, greater than 1000 and thus locked.
The same formula should work for his Sealing domain despite being offset by 500. For a one-domain ninja, you would ask whether or not the threshold is 500 higher than the total XP rather than 1000, and you'd use 1500 for a three-domain ninja.
If the problem is that there isn't enough horizontal space for an extra cell without the widget becoming flush with the Stunts box, this check could be embedded in a concatenate function in the domain cells. That is, the cell that says "Combat" could change to say "Combat (locked)" when it's not possible to further un-stagnate ourselves at this moment.
For Hazou's Combat cell, I think this would look like =CONCATENATE("Combat", IF($C52 - $S$1 > 1000, " (locked)", "")) with similar code for other cells in the widgets.