2012-06-09, 06:06 PM
For my Paladin, the excel calculator goes:
min =(4*C27+D27)/100*E27*G$27*F$27
max =(4*C27+D27)/100*F$27*(E27)
(note that I'm not rounding in these calculations - both are rounded normally though, not with 'floor')
C27: total str =FLOOR(SUM(B2:B23)*(1+SUM(E2:E23)/100),1)
- B is str from gear & base, E is %str from gear
D27: total dex =FLOOR(SUM(C2:C23)*(1+SUM(F2:F21)/100),1)
- C is dex from gear & base, F is %dex from gear (rather %all, mostly)
E27: total attack =FLOOR(SUM(D2
23)*(SUM(G2:G23)/100+1),1)
- D is atk from gear & passives, G is %atk from gear
F$27: weapon multiplier =1.34
G$27: weapon mastery =0.66 it's less than normal cause my Paladin has level 18 mastery unbuffed (lolCObuild)
MW calculation just changes C27 and D27
C27 =FLOOR((SUM(B2:B22)+FLOOR(B28*B23,1))*(1+SUM(E2:E23)/100),1)
- B2:B22 are gear str, B23 is base str, B28 is MW's percentage, that is, 1.15 or whatever
min =(4*C27+D27)/100*E27*G$27*F$27
max =(4*C27+D27)/100*F$27*(E27)
(note that I'm not rounding in these calculations - both are rounded normally though, not with 'floor')
C27: total str =FLOOR(SUM(B2:B23)*(1+SUM(E2:E23)/100),1)
- B is str from gear & base, E is %str from gear
D27: total dex =FLOOR(SUM(C2:C23)*(1+SUM(F2:F21)/100),1)
- C is dex from gear & base, F is %dex from gear (rather %all, mostly)
E27: total attack =FLOOR(SUM(D2
23)*(SUM(G2:G23)/100+1),1)- D is atk from gear & passives, G is %atk from gear
F$27: weapon multiplier =1.34
G$27: weapon mastery =0.66 it's less than normal cause my Paladin has level 18 mastery unbuffed (lolCObuild)
MW calculation just changes C27 and D27
C27 =FLOOR((SUM(B2:B22)+FLOOR(B28*B23,1))*(1+SUM(E2:E23)/100),1)
- B2:B22 are gear str, B23 is base str, B28 is MW's percentage, that is, 1.15 or whatever
Spoiler


![[Image: y7OsB.png]](http://i.imgur.com/y7OsB.png)