A while back I made a topic with a question. Now I make a topic with the result:

A Sorceress skill calculator in Excel!
With the help of Brevan (a thousand thanks!), I put together this little calculator.. It supports synergies, +skill damage, +skills and everything. I hope you'll like it.

You simply have to put in the levels of skills into the bold bordered cells.
If the base skill level exceeds 20, it will turn red, indicating that it is not possible in the game. Hard points and soft points are separated.
You will need a program that is capable of reading and editing excel files (OpenOffice.org works well if you don't have one).

If you find any abnormal thing, or an error, please tell me so that I can fix it as soon as possible. Any feedback is welcome!

Also, a question: Anyone knows why did I have to multiply by 3 the dps damage of Blaze/Fwall/Meteor to display the correct damage?

Edit: fixed Fire Mastery. Please redownload (or copy-paste Lightning Mastery's formula..).

Looks good. I use OOffice, and can say that it works without a flaw in it. If people aren't familiar with .rar files, I use the decompressor 7-Zip to deal with them (it's free and handles about 20 compression types).

I was glad to assist by supplying some of the formulas, but considering how little work was needed by me, this is definitely one of the easiest tasks I've undertaken.

Is anyone having problems opening this sorc calculator? The purpose of this thread is to make sure there are no problems before Shantu commits himself to creating another 6 files. It looks like they would take quite a while, so it would be a good idea to solve any problems now.

From what I can see, I'd say you can continue without changing your layout or file format.

Works well, no problems as far as I can see. Good work and keep em coming.

_________________

Thanks! I've started to work on the Necro one now.

Sorc skills bugs:
1) Energy Shield "Mana Loss per Damage" synergy is currently Teleport, but should be Telekinesis.
2) Hydra formula does not include FireBolt synergy (5%). Currently it includes Enchant and Warmth only.

Thanks, fixed.

A bit of revival here. I started working on this again.

I need some help with Raise Skeleton. I have some problems with its damage calculations, and I'd like to ask the help of those who know how they work. It's a bit weird, and I can't get a 100% accurate damage displayed.

1) The bonus percent to damage on Raise Skeleton is 10% less in the skill description ingame than in skills.txt. I'm not sure which is right, although I suppose skills.txt is. I am using the latter in the calculations right now.

Which means (par3 is 10%/lvl):
Lvl1-3: 0%
Lvl4: 20% (ingame: 10%)
Lvl5: 30% (ingame: 20%)
and so on.

2) I found 2 formulas connected to the damage of skellies:

(value of par2 is 2)
(damage value of item_normaldamage is 1)
However, edmn is quite strange here: the file lists min damage level of tiers only, no max damage.


From all these, I draw the conclusion that the formula should look like this:

This, however, does not work, or my excel calculations are screwed up.

So.. I would like to ask the help of someone experienced with these. Thank you!

Btw I could actually get min damage to display accurate damage from level 1-20, but I had to change the tier ranges in the formula and the Tier progression values, but this isn't an elegant way of doing it and I can't get max damage to work.

If you can code that type of calculator in HTML/PHP, I'll host it in an arimyth.com subdomain. So everyone will be able to use it online.

Problem is, I can't. I don't know any web programming languages.

Better start learning

I think it's a bit late now. You will have to do with an excel calc for now, I don't really have the time and energy to learn HTML or some other programming language.