ArundRainger's Magician Damage Calculator

[ArundRainger]

ArundRainger's Magician Damage Calculator [v5.1]

Download v5.1!
be sure to take out the underscore (_) in the link
*Note: I have compressed the calculator to allow for faster downloads.

v5.1 Updates:

1 Updated Monster Database.
2 Fixed minor formula & cosmetic issues (Switched W.ATK With M.ATK & Same for the DEF's)
3 Added a Monsters Hit Chance (Formula Ceiling 98%, Floor 20% Hit Chance)
4 Added 'Rings' to the equipment list *If multiple rings add stats then add those rings together before inputing*
5 Added 'Class Path' Drop Down Box
6 Added Conditional formatting to show only Class Attack Damage

v5 Updates:

1 Updated Monster Database.
2 Fixed minor formula & cosmetic issues
3 Changed "2x Exp" to "Exp Multiplier" with corresponding input.
4 Adjusted Maple Warrior to a Lv30 cap
5 Added Parameter Inputs for: HP,MP, Equipment STR, DEX, W.Atk, W.Def, M.Def, Acc, & Avoid
6 Added more Character Enchantments: Stat Buffs, Passive/Suportive Skills, & Party Skills
7 Added Physical Accuracy, & Weapon Damage for those playing a STR/DEX Mage
8 Increase Amount of Monster Data Shown in Monster Stats Table

Other useful calculators:

Banditcom's Night Road/Hermit/Assassin Damage & Training Calculator
Ah Jeffs Warrior Damage Calculator
Sybaris' Bowman Damage Calculator

Requirements:

> Microsoft Excel
> winRAR
*Both need to be installed on your PC to work.

Microsoft Excel is not freeware, but part of the Microsoft Office suite.
winRAR is freeware and can be downloaded.
Click here to download [winRAR English]

NOTE:

> Any new ideas would be welcomed and then tested.
> This calculator may have many problems, because I am not the best at excel, but I will try fix them asap.

[MilkmanAl]

Great stuff, thanks. :)

If anyone knows how to incorporate m.def into the magic damage formula, please tell me.

I tried to figure it out quite a while ago with limited results. It's not a linear dependence. That's about all I could tell you.

[cavalier911]

May I ask what formula you use?
There were two formulas developed, one of which was slightly more accurate.

[ArundRainger]

Originally Posted by MilkmanAl

Great stuff, thanks. :)

I tried to figure it out quite a while ago with limited results. It's not a linear dependence. That's about all I could tell you.

Thanks for letting me know, so i guess that is a no go. I'll leave the M.DEF of the monster there just so you guys know.

Originally Posted by cavalier911

May I ask what formula you use?
There were two formulas developed, one of which was slightly more accurate.

I used this formula:

Maximum Damage=(Magic*3.3+Magic*Magic*0.003365+INT*0.5)*(S pell*Amp/100)*Elemental Effect

Minimum Damage=(Magic*3.3*Mastery*0.9+Magic*Magic*0.003365 +INT*0.5)*(Spell*Amp/100)*Elemental Effect

Because people found it more accurate. And with this formula:

Max Power = (.005979 * Magic) squared + (.0359 * Magic)

Min Power = (.005979 * Magic) squared + (.0359 * Magic * Spell Mastery)

It didn't seem right as it does not incorporate INT or LUK, and i didn't know how to incorporate Amp and the Elemental Effect.

------------

So do you think i should add anything?

And does anyone know how to make any decimal round up/round down in excel because you can't attack 1.1 times, lol. and you can't hit 5436.3.

[TheNuke]

whats the password?

[ArundRainger]

Originally Posted by TheNuke

whats the password?

why do you want the password?
And i made it password protected so if you have any ideas, i could input them into the calculator then update so everyone can have the same thing....

btw, i re-updated with some minor changes, nothing big.

[cavalier911]

Alright, thanks for telling me.
I've been looking for a calculator using that formula, but there were none.
He needs the password so he can input his stats.
I'd like it too.

[ArundRainger]

Originally Posted by cavalier911

Alright, thanks for telling me.
I've been looking for a calculator using that formula, but there were none.
He needs the password so he can input his stats.
I'd like it too.

Hold up, you can't input stats?

EDIT: fixed sorry about that....

[TheNuke]

i got office 2007 and it wont let me edit the yellow boxes , thats why i need the password .... probably compability problem , fck microsoft.

another thing , you should just let ppl edit the magic directly , since there are itmes that add magic attack too , like earrings / shoes / gloves...

[USPS]

Originally Posted by ArundRainger

Hold up, you can't input stats?

EDIT: fixed sorry about that....

it still asks for a password when i try to edit the yellow boxes