Login | Register


All times are UTC - 5 hours


It is currently Sun Sep 15, 2019 6:02 pm




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Excel Skill Calculator
PostPosted: Mon Aug 30, 2010 5:02 am 
User avatar

Joined: Sat Sep 19, 2009 10:07 am
Posts: 237
Location: Hungary
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 254 times


Last edited by Shantu on Wed Sep 01, 2010 9:32 am, edited 1 time in total.
Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Mon Aug 30, 2010 4:08 pm 
User avatar

Joined: Mon Aug 31, 2009 11:28 am
Posts: 1125
Location: Vancouver, BC
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.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Mon Aug 30, 2010 5:07 pm 
Game Server Host
User avatar

Joined: Mon Aug 31, 2009 12:33 am
Posts: 4292
Works well, no problems as far as I can see. Good work and keep em coming. :)

_________________
Bron wrote:
There's no cure for being a cunt.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Tue Aug 31, 2010 2:48 pm 
User avatar

Joined: Sat Sep 19, 2009 10:07 am
Posts: 237
Location: Hungary
Thanks! I've started to work on the Necro one now.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Tue Aug 31, 2010 11:24 pm 
User avatar

Joined: Mon Aug 31, 2009 11:28 am
Posts: 1125
Location: Vancouver, BC
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.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Wed Sep 01, 2010 9:32 am 
User avatar

Joined: Sat Sep 19, 2009 10:07 am
Posts: 237
Location: Hungary
Thanks, fixed.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Tue Dec 07, 2010 1:37 pm 
User avatar

Joined: Sat Sep 19, 2009 10:07 am
Posts: 237
Location: Hungary
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.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Wed Dec 08, 2010 11:32 am 
Site Admin
User avatar

Joined: Thu Aug 06, 2009 7:26 pm
Posts: 327
Location: Quebec, Canada
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.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Wed Dec 08, 2010 11:35 am 
User avatar

Joined: Sat Sep 19, 2009 10:07 am
Posts: 237
Location: Hungary
Problem is, I can't. :( I don't know any web programming languages.


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Wed Dec 08, 2010 11:42 am 
Site Admin
User avatar

Joined: Thu Aug 06, 2009 7:26 pm
Posts: 327
Location: Quebec, Canada
Better start learning :)


Top
 Offline Profile  
Reply with quote  
 Post subject: Re: Excel Skill Calculator
PostPosted: Wed Dec 08, 2010 5:28 pm 
User avatar

Joined: Sat Sep 19, 2009 10:07 am
Posts: 237
Location: Hungary
:)
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.


Top
 Offline Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron