Lv50 Character Stats Calculator R1.1 by sgTotoro

Download Link:

Lv50 Character Stats Calculator by sgTotoro

The stats calculator is made by sgTotoro.

The final damage calc and average damage calc are done by me.

* READ INSTRUCTION IN THE EXCEL SPREADSHEET BEFORE USING!

* ONLY FILL IN GREEN CELL

* ONLY ACCURATE FOR LVL50 CHAR
(lv50 char base stats is used in the calculation, however you can change it easily to the base stats at your level, provided u know what is the value.)

Known Bugs:* Tail stats cell (D104, D105) are not correct in this version
* Remedy: The 2% m.att or p.att should be included as the "fashion set effect" (L93,L94)

Development:
* Toto is still current working on the new stats calc, which has a database of various armor/weapon.
* If interested to help on the progress, leave him or me a PM or post here.


* HOW TO FIND OUT MY NAKED/BARE BASE STATS IF I AM NOT LVL50?

For a non-lvl50 character, you can find out the naked base stats as follows:

1. Hover your mouse over one of the 4 prime stats: Str, agi, int, vit

2. You will notice a number in bracket appearing beside the stats.

3. Naked base stats = the final stats  -  the number in bracket
Example: my naked base VIT stats = 1888 - 1708 = 180 (see picture below)

4. Only calculate the naked stats for the 4 PRIME STATS : STR AGI INT VIT, and key them into the spread sheet. DO NOT KEY IN ANYTHING FOR HP, MP, M. ATT , M DEF , ETC (they are derived automatically from the prime stats)

This is really good, thanks for this toto!

Reply 1#  Ace Of Spades

You are welcome, man, do test it and feedback if got any idea to improve.

Hi toto,

i have tested the excel sheet, heres some feedback for u :)

too many boxes to fill up lol! one suggestion from me (tedious work) which is to add lv50 items stat into it and allow user to select from a list of equipments. and those item can have IDs for easy reference so that equipment stats will be auto fill up based on lookup value. I know its quite time consuming for an excel format but its just a suggestion. If your interested in enhancing it further maybe we could develop it into an application instead.

Des

indeed , that's a very big project.

all the stats (enchantment and base stats) for all items can be found here:

http://dn.db.17173.com/items.php?cl=0

It would be interesting if it can be further developed into something that's is more user-friendly.

i've tested it, and calc is wrong on some of my stats by 1 point(it shows 1 less point of str, vit, def, mdef) and some by huge amount(ie - my dmg in calc is 200+ less than in game, though i double checked everything, and my hp in game is 3k+ more than in calc).
i'm sniper btw, and there was wrong value in base str too, so it's probably wrong in some base atk stats as well.

i'd love this calc to be useful, since i'm kinda curious should i look forward to 50S or to hell with it.

i think toto might not test on any archer, so probably he might get the wrong stats for them.

May i know what's your base stats at lv50.

You are a sniper right?

yeah, artillery should have a different base stats, though i don't have a way to check them atm.
for sniper they're -
str - 210 (it was 230 in calc)
agi - 330
int - 180
vit - 200

edit: my bad, got it now.
my crests are - lv40 crit, lv40 vit, and lv50 - hp, pdmg, mdmg, agi, int, fd.
(additional stats are all fd, no other).



seems like my base pdmg is - 308 and base mdmg is 162.. if i'm doing it right - -

ok changed the sniper base stats: str 210

i've changed it right away, but it doesn't make much difference.. some of my stats are still off by a large margin.

oh.. i think i get it now(the damage), it doesn't include stats from passive bow mastery.. which is 8%. but then it's still wrong - -
damn numbers messing up with me.

maybe i'm just sleepy.. then help me out here, what am i missing?..

Hmm, your 4 main stats match very well.

I suggest you check for the set bonus effect or anything that related to phy attack  (a tail maybe) to see if you miss anything.

i think off by 1 already means "not so well", cause.. there's formula out there, so they should be exact(though i understand that's not that big of a deal)..


and i've checked it one more time, and 2% pdmg from tail doesn't go into final stats, so it appears that there's more errors(still don't know why hp is off). - -

The calc is actually based on the so-call "formula out there".

Off by 1-2 is normal due to the truncation error done by the game.

For example, 5.8% is not the real value of the potential. Duowan has shown that the real multiplier is actually 5.745%.

However, the purpose of the calculator is not to predict the exact stats in game, but to produce something very close to it (with some minor error due to truncation), such that you can make a comparison when you want to change gear.

Actually i have just checked, tail phy % should be included in the calc. I think toto must have missed it.

FYI, i wrote my own calculator for Majesty (which is almost the same as his except the fashion part). Mine doesn't have this error. So i didn't spot it.

I will update the calc again tomolo.

Thanks for the feedback.

yeah, thanks for your and sgTotoro hard work, i appreciate it.

Remember to include your title.

ahm mr. sgTotoro can you pls include the final damage stats and also the damage increase by it and also the damage increase by the critical stats.. thanks.. ^^