DPS shot through the roof after latest fix. MAIN!D8 changed from a 9 (old sheet) to a 13 (new sheet)
I am no genius in excel (as i told you a couple days ago in discord - brouwer's cards) but a simple workaround would be to keep MAIN!D8 formula as it was
AND change formulas
MAIN!V10 to:
MAIN!V11 to:
MAIN!V12 to
don't know what other changes you made that are affected by lineage , but this fixes the dps thigny
I am no genius in excel (as i told you a couple days ago in discord - brouwer's cards) but a simple workaround would be to keep MAIN!D8 formula as it was
Code:
=if(C8<4,0,if(C8<12,1,if(C8<20,2,if(C8<34,3,if(C8<56,4,if(C8<88,5,if(C8<132,6,if(C8<190,7,if(C8<240,8,if(C8<324,9,if(C8<428,10,if(C8<593,11,if(C8<782,12,if(C8<956,13,if(C8<1160,14,if(C8<1389,15,if(C8<1643,16,if(C8<1922,17,if(C8<2226,18,if(C8<2635,19,20))))))))))))))))))))
AND change formulas
MAIN!V10 to:
Code:
=Round((1.1*C43*(1+D6+'Asc & Cha'!E4)*(1+D7)*(1+C47))*(1+R4)*(1+D8*0.02))
Code:
=Round((C43*(1+D6+'Asc & Cha'!E4)*(1+D7)*(1+C47))*(1+R4)*(1+D8*0.02))
MAIN!V12 to
Code:
=round(C44*(1+D6+'Asc & Cha'!E7)*(1+D7)*(1+D8*0.02)*(1+C47)*(1+R7),0)
don't know what other changes you made that are affected by lineage , but this fixes the dps thigny