| Gates of Arimyth http://forum.arimyth.com/ |
|
| Skill tables http://forum.arimyth.com/viewtopic.php?f=10&t=279 |
Page 1 of 1 |
| Author: | Shantu [ Sat Sep 19, 2009 4:58 pm ] |
| Post subject: | Skill tables |
I started HU some days ago and.. I have a question. Are there any skill tables on the internet for HU? I tried google but nothing (except for an outdated druid one). It would come handy sometimes.  Thanks in advance. ----------- Edit: Download skill tables for all 7 classes to help you plan ahead your character and to see skill progression. If you have any questions, ideas, problems, do not hesitate to post. |
|
| Author: | Shantu [ Wed Sep 23, 2009 2:47 pm ] |
| Post subject: | Re: Skill tables |
Hmm, I will take it as a no. So then, is there any demand for excel skill tables? It could be put on the Critterkiller site too, maybe. The paladin one is almost ready. |
|
| Author: | blue_myriddn [ Wed Sep 23, 2009 2:56 pm ] |
| Post subject: | Re: Skill tables |
ya - I don't think there are any out there. Would be a cool chunk of info though if you want to put it together. |
|
| Author: | Shantu [ Thu Sep 24, 2009 2:14 pm ] |
| Post subject: | Re: Skill tables |
Here is the paladin one; tell me if I should change anything or made an error/typo/something. Enjoy! Necro is the next. [removed link because there is a newer one] |
|
| Author: | blue_myriddn [ Sat Sep 26, 2009 4:12 pm ] |
| Post subject: | Re: Skill tables |
nice work! thanks for putting that together. I will get it up on the servers |
|
| Author: | Shantu [ Mon Sep 28, 2009 1:30 pm ] |
| Post subject: | Re: Skill tables |
The necromancer tables are ready! I also did a few changes to the paladin ones - changed the blessed hammer and fist of the heavens damage to unsynergised damage (the damage listed now is without the prerequisite-synergies.) + tried to make it look a bit better. Anyways, the links are edited in the first post so they are easy to find. Sorc is the next one, I think. Criticism is welcome. And of course, tell me if I am wrong about or mistyped something. |
|
| Author: | Brevan [ Mon Sep 28, 2009 2:00 pm ] |
| Post subject: | Re: Skill tables |
Please attach the files to your post directly, instead of going through a file server. The .xls extention is not allowed by the forum server, but I think a good solution would be to compress all the skill tables into one .zip or something, and then attach that. Do you have access to any character-editor software that would enable you to generate data for skill levels up to 50? If not, perhaps you could get access to the .txt files that define the skill tier progression, and then just create the skill tables from that
|
|
| Author: | Shantu [ Mon Sep 28, 2009 2:36 pm ] |
| Post subject: | Re: Skill tables |
Ah, good idea! I wanted to attach it to my post, but couldn't because of the .xls format. But the .zip format is a very good idea, didn't think about it.  I have hero editor, so it would be no problem. But.. wouldn't it be way too long in excel, 50 levels? I feel like these 20 levels are way too long already and hard to read. Maybe I could make 2 tables of each class, one of them from lvl1-20, the other one from 21-50. Or just continue it and make it long? |
|
| Author: | Hflame [ Mon Sep 28, 2009 3:36 pm ] |
| Post subject: | Re: Skill tables |
just do every 5 after 20, so 25 and 30 and so on to 50 or every 3 skills to 50, to see it progress. if you could also include a table where their is one with each synergy to it, at like 1 point into the synergy and 10 and 20 as well. if there is more than 1 synergy, example 2 synergies. do 1, 10, 20, and 2, 20, 40. if 3 synergies do with 3 30 60 as well and so on. depending if they add to the same thing of course. |
|
| Author: | Shantu [ Mon Sep 28, 2009 3:51 pm ] |
| Post subject: | Re: Skill tables |
The 5 levels after 20 is a great idea! I will see how much time will I have, but first I will do the base 20 levels of each class, then everything else. The synergies though, are something that everyone should be able to calculate out easily, but I'll see. |
|
| Author: | Brevan [ Mon Sep 28, 2009 4:18 pm ] |
| Post subject: | Re: Skill tables |
Your skill levels went horizontally, so it would be another 30 columns, which is probably alright. However, if you want, you could use the text file's Tier progression descriptions, and use Excel formulas to generate the damage/benefit for a given level. E.G. FireBolt Level = input Damage = MIN(Level,8)*Tier1 + MIN(MAX(Level-8,0),8)*Tier2 + MIN(MAX(Level-16,0),8)*Tier3 + MIN(MAX(Level-24,0),8)*Tier4 + MAX(Level-32,0)*Tier5 Actual Calculation for Level 20 Damage = MIN(20,8)*Tier1 + MIN(MAX(20-8,0),8)*Tier2 + MIN(MAX(20-16,0),8)*Tier3 + MIN(MAX(20-24,0),8)*Tier4 + MAX(20-32,0)*Tier5 = 8*Tier1 + MIN(MAX(12,0),8)*Tier2 + MIN(MAX(4,0),8)*Tier3 + MIN(MAX(-4,0),8)*Tier4 + MAX(-12,0)*Tier5 = 8*Tier1 + MIN(12,8)*Tier2 + MIN(4,8)*Tier3 + MIN(0,8)*Tier4 + 0 = 8*Tier1 + 8*Tier2 + 4*Tier3 + 0 + 0 Sorry if it's still a little confusing, I didn't want to drag out the example too much. The end result might be about 3 cells per skill, 1 for the input level, 1 or more for input synergy levels, and 1 or more for the damage output. I think this would save you a lot of time over using a character-editor to view the data, and then producing large tables for each skill. If you wanted to be especially fancy, then you could try this: 1) Create 1 Workbook (1 .xls file) for each class 2) Create 3 worksheets in the Excel Workbook, one for each skill tab 3) On each worksheet, arrange the cells for each skill similarly to the skill tab layout, e.g. Firebolt and Warmth would be at the top of the worksheet, below Firebolt would be Fireball, and to the left of FireBall is Inferno while to the right is blank, etc. 4) For each skill, have the damage-output cell reference the level-input of synergies from the other worksheets. |
|
| Author: | Shantu [ Mon Sep 28, 2009 4:46 pm ] |
| Post subject: | Re: Skill tables |
Huhh... Sorry, but those calculations are a bit high for me. But if I get you right, you mean some kind of skill calculator in excel? It sounds very nice, but my excel skills don't go that far.
|
|
| Author: | Brevan [ Mon Sep 28, 2009 5:26 pm ] |
| Post subject: | Re: Skill tables |
You can almost copy-paste the formula I've supplied, you just need to fill in numbers for Tier1 to Tier5. If you're not too experienced with Excel, then you could split up the damage across two cells, with one for the min and one for the max damage in a range. For example, if FireBolt did 100-150 damage in the end, then you could use one cell to calculate the 100, while the other calculated the 150. In Excel (and I'm sure every other spreadsheet program), the function MIN() returns the smallest of some numbers, while MAX() returns the largest of some numbers. The rest of the formula is just addition (+) and multiplication (*). For now though, the tables you've already started creating, especially with the addition of every 5 levels after 20, will be a great reference for those not familiar with HU
|
|
| Author: | Hflame [ Mon Sep 28, 2009 6:57 pm ] |
| Post subject: | Re: Skill tables |
its easy to edit in excel, you just apply the percentage to the given table and have it display with a header that says the amount of synergies it is. |
|
| Author: | Shantu [ Tue Sep 29, 2009 2:02 pm ] |
| Post subject: | Re: Skill tables |
I think I'll finish my orignal idea first, skill tables somewhat like the ones on Arreat Summit. Then I'll see what can I do for this skill calculator.
|
|
| Author: | Shantu [ Thu Oct 08, 2009 2:37 pm ] |
| Post subject: | Re: Skill tables |
Sorry for the slowness; I have been quite busy and tired lately. Pala and necro skill tables got extended to level 25/30/35/40/45/50 and skill trees were added. Check first post for them. Sorc coming soon. If you find any error, please tell me. |
|
| Author: | Brevan [ Thu Oct 08, 2009 4:12 pm ] |
| Post subject: | Re: Skill tables |
The presentation of the skill trees and tables looks good to me Things I noticed: 1) Necromancer.xls contains "junk" in cells: V72, T89, T101, U113 2) Paladin.xls Vengeance Synergies should include 1% Pierce for each of HolyFire (1% Pierce Enemy Fire Resistance), HolyFreeze (1% Cold Pierce), HolyShock (1% Lightning Pierce). |
|
| Author: | Shantu [ Fri Oct 09, 2009 7:49 am ] |
| Post subject: | Re: Skill tables |
Thanks. I removed the junk and added the pierce.
|
|
| Author: | Shantu [ Thu Oct 22, 2009 9:58 am ] |
| Post subject: | Re: Skill tables |
Sorceress tables are ready! Took long, I know - a bit of laziness, a bit of tiredness and almost no motivation.. Anyway, enjoy and tell me if you find anything wrong. (look at first post for it.) Barbarian coming next. |
|
| Author: | scump [ Thu Oct 22, 2009 10:26 am ] |
| Post subject: | Re: Skill tables |
wow! what helpful skill tables! just gazing at them quickly i worked out its useless to max golem mast... after 25 the diminishing returns is MASSIVE. so aslong as you have +skills, safe to assume you will have 10 ish, only need say 15 points in it eh. |
|
| Author: | Shantu [ Thu Oct 22, 2009 11:21 am ] |
| Post subject: | Re: Skill tables |
Oh my god, what the --- :S Only the speed has diminishing returns, the others don't. :/ No idea how did it happen. Fixed now, very sorry. |
|
| Author: | Shantu [ Thu Oct 29, 2009 3:18 am ] |
| Post subject: | Re: Skill tables |
Barbarian ready. - Check first post for the new file. Druid next. |
|
| Author: | PureRage-DoD [ Sat Oct 31, 2009 10:40 pm ] |
| Post subject: | Re: Skill tables |
paladins off auras - holy fire - level 50 is listed as 1560-1372, should be 1360-1372 small error, if it was me i would want to know about it, may be my OCD though  great work on those, perhaps they could be added to the items/rw index at some point. |
|
| Author: | Shantu [ Sun Nov 01, 2009 4:45 am ] |
| Post subject: | Re: Skill tables |
Thank you, I will fix it when I finish the druid one! |
|
| Author: | Shantu [ Wed Nov 04, 2009 11:16 am ] |
| Post subject: | Re: Skill tables |
A question about Dire Wolves: what do they give to the other summons? Spirit wolves give defense and attack, grizzly damage.. but what about dire wolves? They used to give life if I remember correctly, but they don't seem to, here. Oh and btw, Holy fire level 50 damage: 1560-1572 (not 1360-1372). |
|
| Author: | PureRage-DoD [ Wed Nov 04, 2009 11:53 am ] |
| Post subject: | Re: Skill tables |
my bad, dires give grizly 10% damage per point, grizzly gives dire and spirit 10% damage per point |
|
| Author: | Shantu [ Wed Nov 04, 2009 12:01 pm ] |
| Post subject: | Re: Skill tables |
Thank you! So dire gives nothing to spirit wolves, right? |
|
| Author: | PureRage-DoD [ Wed Nov 04, 2009 1:34 pm ] |
| Post subject: | Re: Skill tables |
yeh thats right, |
|
| Author: | svirflin [ Wed Nov 04, 2009 8:10 pm ] |
| Post subject: | Re: Skill tables |
Meteor damage is incorrect. Level 1 2 3 4 5 6 7 Fire Damage 80-100 14-22 21-30 28-38 35-46 42-54 49-62 Looks like its off by a factor of ten? |
|
| Author: | scump [ Thu Nov 05, 2009 1:42 am ] |
| Post subject: | Re: Skill tables |
you sure it doesnt look more like you have one point in both fire ball and fire bolt (its pre-requisites and synergies???)
|
|
| Author: | svirflin [ Thu Nov 05, 2009 2:07 am ] |
| Post subject: | Re: Skill tables |
No, because if the level 1 damage is 80-100, how can lvl 2 dmg be 14-22? |
|
| Author: | Brevan [ Thu Nov 05, 2009 10:04 am ] |
| Post subject: | Re: Skill tables |
It's just a copy-paste error with the FireBall row. |
|
| Author: | Shantu [ Thu Nov 05, 2009 10:42 am ] |
| Post subject: | Re: Skill tables |
Ahh.. forgot to fill that row, as it seems. Gonna fix that too! |
|
| Author: | Shantu [ Sat Nov 07, 2009 3:03 pm ] |
| Post subject: | Re: Skill tables |
Druid out! Holy fire and meteor fixed as well. Chech first post. Assassin next, I think. |
|
| Author: | svirflin [ Sun Nov 15, 2009 2:34 pm ] |
| Post subject: | Re: Skill tables |
Paladin table, Conversion, % chance to convert at skill lvl 9 is incorrect. |
|
| Author: | Shantu [ Mon Nov 16, 2009 2:55 am ] |
| Post subject: | Re: Skill tables |
Eww, thanks. It should be 59, will be fixed with the assassin. |
|
| Author: | Shantu [ Thu Jul 08, 2010 7:59 am ] |
| Post subject: | Re: Skill tables |
With the "new" patch.. I think some of my tables are out of date. I might fix them and finish the two remaining classes when I am bored. |
|
| Author: | Shantu [ Fri Jul 09, 2010 2:28 pm ] |
| Post subject: | Re: Skill tables |
I am sorry for the triple-post, but if I edit, no one will know about it. Assassin is ready, and updated the older tables (new file in first post). I hope these help planning ahead your character.. Also a question: Which skills were changed with the last patches? Since I don't have the patience to go through every skill again, I checked only the ones mentioned in the 1.21x patch notes (If they are not mentioned there, they shouldn't have changed, right?) This means: War cry for Singer Barbs Vengeance for Avengers Fire skills & Rabies for Druids + the conviction synergy for the holy auras. Assassin is ready, Amazon is coming. |
|
| Author: | blue_myriddn [ Fri Jul 09, 2010 2:29 pm ] |
| Post subject: | Re: Skill tables |
just FYI - there may be another balance patch coming out within the month so you may want to hold out. |
|
| Author: | Shantu [ Fri Jul 09, 2010 2:38 pm ] |
| Post subject: | Re: Skill tables |
Bah. -_- Well, I will still make the amazon one.. at least I feel like doing it now. But thanks for telling me.
|
|
| Author: | Shantu [ Tue Aug 03, 2010 3:05 am ] |
| Post subject: | Re: Skill tables |
I am glad to announce (if anyone cares) that the Amazon tables are ready! Check first post for the new file. So that is all, they are all ready. If I made any mistakes (which I hope I did not), please tell me and I will fix it as soon as possible. Edit: seems like I can't upload anymore on the forum ("Sorry, the board attachment quota has been reached."). :/ I uploaded it to Mediafire instead. |
|
| Author: | Brevan [ Tue Aug 03, 2010 10:18 am ] |
| Post subject: | Re: Skill tables |
Excellent, thanks Shantu. I see that your first post in this thread has been updated with the link to the new .rar file. Good stuff. |
|
| Page 1 of 1 | All times are UTC - 5 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|