Rogue Stat Calculator

[Asmiroth]

I made this (http://www.guildascendingdawn.com/download/RogueCalc.xls) to help me compile some numbers for my guild, check out what some different items can do.

Let me know what you think.

[hellspit]

I made this (http://www.guildascendingdawn.com/download/RogueCalc.xls) to help me compile some numbers for my guild, check out what some different items can do.

Let me know what you think.


R3 field should be =SUM(Items!B4:B30)+SUM(R5*2) instead
=SUM(Items!B4:B30)+SUM(R5*2.5)



R7
At lvl 60 as undead rogue i have based 2103 HP
so formula to calculate HP doesn't work good
=SUM(Items!F4:F30) + 1200 + SUM(R6*10)
modified
=SUM(Items!F4:F30) + 1343 + SUM(R6*10)

R8 is messed up
my based crit is 7.78%
with Malice ... to figure out what's wrong i have to drop all talents

R9
=SUM(Items!H4:H30) + SUM(R5/15) didn't work for me
not same number
=SUM(Items!H4:H30) + SUM(R5/14.5) worked

R10 Attack Power

=SUM(Items!I4:I30) + SUM((R4+R5)/0.75) show 207 ap and i have 307
so you could do two ways
=SUM(Items!I4:I30) + SUM((R4+R5)/0.75) + 100
or
=SUM(Items!I4:I30) + SUM((120+R4+R5)-20)

stupid formula but working...


then
at Race page
Mistakes at B14 , C14 , D14
just last part
twice B7 , C7, D7 , last part should be B8 , C8, D7

i looking forward to next oppinion

[Asmiroth]

R3 fixed

R7 fixed

*I have malice + 5%crit from items*
R8 It's supposed to be level/2, so 30AGI. I'm still off by 0.3 which puts the number at 29.98? Unless somehow at 0 agility you have 0.3crit chance...I then dropped my agility to 200 and crit went to 16.90, so the X turned into 28.98. I'm GUESSING that the base is always 0.3 after that...so that part is added.

R9 Another weird one. at 260agi and 2%doge from items, I'm at 20.34(sheet says 19.33). drop to 200agi, I get 16.20(sheet says 15.33). Apparently, my sword that gives +10def adds to dodge. So I took it off, dropped from 16.2 to 15.8. 10def = .4. Def at 60 = 300. That really messes up my calcs though and will need to do more work to figure it out. I'll keep it at 14.5 for the time being.

R10 490 (lists 464+26) in game from 104str/260agi +26ATK item. sheet lists 511.33 :/ so I'm about 21 off. Drop to 135/200 (26atk item) and ATK turns to 461. Sheet says 472.6, so off by 11 that time. Going 109/189 should give me 398...I get 398. Weird. I need to do more work on this one.

As for the RACES page, that's fixed. Gotta love copy and paste.

The page is update now.

[Asmiroth]

Woops, I realized the atk formula was written in some other are

clvl*2+str+agi-20

[hellspit]

Woops, I realized the atk formula was written in some other are

clvl*2+str+agi-20


thing changes from patch to patch.
to get correct formulas i need to monitor char every level
from 1 to 60

will continue to update my oppinions
:)
Thanks Asmi

[Asmiroth]

Online Calc (http://www.guildascendingdawn.com/modules.php?name=Roguecalc)

Now coded in JS. Going to add a few more fields (item name for one) so that people can "print" out their item sets.

[Asmiroth]

Actually, this link is better

Rogue Calc (http://rogue.worldofwar.net/files/RogueCalc/)

It allows printouts, of a sort.