First of all, thanks for this amazing tool. I have found what it seems a minor bug on Advanced Cards tab: first row, the next cell to the right of Cards to dmg points to an incorrect tab name.
And it should be:
Also, as a visual upgrade of Ascension & Challenge tab, I have added a conditional format to the challenges titles one by one (Rats, Fruits, and so on) so they change the background colour every time the Lowest theoretical incompletable challenge value changes from the one specified by the user. I have done for my own good because I found that it's hard to notice when I can jump to the next level unless it's a major change (say, from bronze to silver, or silver to gold).
Simple but effective. Kind regards.
Code:
=if(E2<>0,E2,C2)/If(Cards!D5<>0,Cards!D5,A2)
And it should be:
Code:
=if(E2<>0,E2,C2)/If('Cards and Timers'!D5<>0,'Cards and Timers'!D5,A2)
Also, as a visual upgrade of Ascension & Challenge tab, I have added a conditional format to the challenges titles one by one (Rats, Fruits, and so on) so they change the background colour every time the Lowest theoretical incompletable challenge value changes from the one specified by the user. I have done for my own good because I found that it's hard to notice when I can jump to the next level unless it's a major change (say, from bronze to silver, or silver to gold).
Code:
Apply to F25 custom formula:
=$F26<>$F27
Select preferred BG colour.
Simple but effective. Kind regards.