ArundRainger's Magician Damage Calculator [v2.7]

Thanks for the sticky!

Download v2.7 here
*Note: I have compressed the calculator to allow for faster downloads.


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]


Updates:
1. Elemental Weapons Added
2. Pendants Section Added
3. Various glitches have been fixed.


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


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.

Great stuff, thanks.


Quote:
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.
__________________
IGN: SOJUGIEB (main), DoomBang (store mule)

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

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.

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.

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

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.

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

Hold up, you can't input stats?

EDIT: fixed sorry about that....
__________________

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