Gates of Arimyth
http://forum.arimyth.com/

Excel Skill Calculator
http://forum.arimyth.com/viewtopic.php?f=8&t=2140		 Page 1 of 1
Author:  Shantu [ Mon Aug 30, 2010 5:02 am ]
Post subject:  Excel Skill Calculator
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..).

Attachments:
File comment: Sorceress skill calculator for HU 1.21z.
SorceressCalc.rar [14.53 KiB]
Downloaded 529 times
Author:  Brevan [ Mon Aug 30, 2010 4:08 pm ]
Post subject:  Re: Excel Skill Calculator
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.
Author:  PureRage-DoD [ Mon Aug 30, 2010 5:07 pm ]
Post subject:  Re: Excel Skill Calculator
Works well, no problems as far as I can see. Good work and keep em coming. :)
Author:  Shantu [ Tue Aug 31, 2010 2:48 pm ]
Post subject:  Re: Excel Skill Calculator
Thanks! I've started to work on the Necro one now.
Author:  Brevan [ Tue Aug 31, 2010 11:24 pm ]
Post subject:  Re: Excel Skill Calculator
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.
Author:  Shantu [ Wed Sep 01, 2010 9:32 am ]
Post subject:  Re: Excel Skill Calculator
Thanks, fixed.
Author:  Shantu [ Tue Dec 07, 2010 1:37 pm ]
Post subject:  Re: Excel Skill Calculator
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.
Code:
damagepercent   ((lvl < 4) ? 0 : ((lvl-2)*par3))

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:
Code:
- damagepercent   ((lvl < 4) ? 0 : ((lvl-2)*par3))
- item_normaldamage   skill('Skeleton Mastery'.lvl) * skill('Skeleton Mastery'.par2) + edmn

(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.
Code:
EMin   EMinLev1   EMinLev2   EMinLev3   EMinLev4   EMinLev5
0   0   1   2   3   4


From all these, I draw the conclusion that the formula should look like this:
Code:
item_normaldamage + SMasteryLvl * SMastery.par2 + edmn
1 + SMasteryLvl * 2 + edmn

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.
Author:  DuFFBeeR [ Wed Dec 08, 2010 11:32 am ]
Post subject:  Re: Excel Skill Calculator
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.
Author:  Shantu [ Wed Dec 08, 2010 11:35 am ]
Post subject:  Re: Excel Skill Calculator
Problem is, I can't. :( I don't know any web programming languages.
Author:  DuFFBeeR [ Wed Dec 08, 2010 11:42 am ]
Post subject:  Re: Excel Skill Calculator
Better start learning :)
Author:  Shantu [ Wed Dec 08, 2010 5:28 pm ]
Post subject:  Re: Excel Skill Calculator
:)
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.
Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/