08-27-2016, 02:52 AM
(08-26-2016, 10:12 AM)k3rb3r05 Wrote: Great work on pet sheet... a minor edit though: HJ39:ID39 have to be re-numbered, because cells contain dups and instead of going up to CriC21, they go up to CriC10.
Also, in Ascension & challenge sheet, could you make the following changes? (also minor)
C52: =if(C12="Yes",8,0)
C59: =1*((C19*(C19+1)/2))
C60: =1*((C20*(C20+1)/2))
In Challenge Data sheet, is there any way to mark finished challenges as done, or apply conditional formating on them, based on "Ascension & challenge"!F26:N26 ? (edit: when there is code in it (not "ok" or "done") like s3d)
Thanks. I fixed those Critical Chance cells.
(08-26-2016, 10:43 AM)jiecut Wrote:(08-26-2016, 10:12 AM)k3rb3r05 Wrote: Also, in Ascension & challenge sheet, could you make the following changes? (also minor)
C52: =if(C12="Yes",8,0)
C59: =1*((C19*(C19+1)/2))
C60: =1*((C20*(C20+1)/2))
Those are zero because it assumes you respec to do training or woodcutting. And if you don't respect and just leave it on, it's not that big of a problem.
It's not much of a problem, however, at the higher levels, you do end up slowing activating all of these permanently. I think it is worth making the minor change to allow these to be turned on and calculate properly into Ascension Pts Remaining in cells C25 and D25.