Fire Clan IOU Multicalc

[JourneyOver]

(08-19-2016, 03:42 AM)k3rb3r05 Wrote: 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

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))

MAIN!V11 to:

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

haha it didn't shoot through the roof for me, it's still lower than my DPS (running 5 minutes on dps timer) in game still :x

Current damage in-game is averaging between 2.35M to 2.55M
Current damage on sheet says average is around 2.27M