|
| Thread: Creature Stats Excel Sheet | |
|
Ravel
Hired Hero
|
posted October 22, 2015 04:37 AM |
|
Edited by Ravel at 04:39, 22 Oct 2015.
|
Creature Stats Excel Sheet
Hey all, just figured I'd share an excel sheet i've been working on which compiles a bunch of creature stats and abilities. All this information is available in-game, but sometimes having a side-by-side comparison is useful.
It doesn't indicate what type of movement a creature uses (walking vs flying) and I didn't include creature growth or cost, but might add them next since I know that they're important when considering how balanced one creature is with another. I might also add some conditional formatting to help highlight abnormally high/low attributes for a particular creature tier.
[url=https://drive.google.com/file/d/0B6DjoGC9WY04d3ZPSzhrc3FBSTA/view?usp=sharing]Here's[/url] the link.
Edit: Just realized that google will, by default, try to display the excel sheet rather than offer it as a download, but you can't see the ability icon tooltips that way. It's best viewed by downloading it and opening it in Excel.
|
|
MeTaNoV
Hired Hero
In Heroes We Trust!
|
|
posted October 22, 2015 05:46 AM |
|
|
That's great, I wanted to do the same this WE!
I'll do some other parts, and I am also compiling my bugs/features in such way already, to be able to follow what is corrected/implemented and give us some feedback feeling!
|
|
ChrisD1
Supreme Hero
|
|
posted October 22, 2015 06:47 AM |
|
Edited by ChrisD1 at 06:49, 22 Oct 2015.
|
From a quick glance, i can see that 7 tier system is back,with even more evident proof.
The bad news is that almost every creature has the exact same stats...It screams "sloppy work".
The whole creature growth/stats/abilities needs some serious work.
Coding wise it's a child's play, if ,even, we can mod those stats.
Concept wise, though, they should sit down and discuss every creature,and give it more character.
i.e. the x creature might be sturdier than the other tier 1 creatures but it might have less growth.
And to not go to extremes,i don't suggest to make completely different ALL of the tier 1(or whatever tier). There is so much numerical spectrum. Just make them feel slightly different.
And for asha's sake, those sentinels/legionnaires have huge speed (walking space).
____________
|
|
Elvin
Admirable
Omnipresent Hero
Endless Revival
|
|
posted October 22, 2015 07:30 AM |
|
|
Add growth and it's perfect 
____________
H5 is still alive and kicking, join us in the Duel Map discord server!
Map also hosted on Moddb
|
|
Maurice
Hero of Order
Part of the furniture
|
|
posted October 22, 2015 09:56 AM |
|
|
Ravel said:
Edit: Just realized that google will, by default, try to display the excel sheet rather than offer it as a download, but you can't see the ability icon tooltips that way. It's best viewed by downloading it and opening it in Excel.
When looking at it through the browser, it will clearly show page breaks. If I may make a suggestion, I would try and make each faction fit on its own page. Right now, you actually require two pages, because a few columns fall off on the right, onto the next page. There's room to be had, for instance you can put the name of the faction directly above the stats for that faction, instead of in its own column and columns like the Range column are wider than needed.
The compilation is a great piece of work, though .
|
|
alcibiades
Honorable
Undefeatable Hero
of Gold Dragons
|
|
posted October 22, 2015 10:02 AM |
|
|
Also, just a few suggestions for improvements: Since the spreadsheet is too wide to fit on one page (at least on my screen?), it might make sense to try to reduce the amounts of columns, or make them more narrow. The first column for instance, which only has the faction name, is quite redundant and can easily be fixed simply by colour-coding the background to each faction (blue for Haven, orange for Academy, green for Sylvan, etc.).
____________
What will happen now?
|
|
malax83
Famous Hero
Game ranger, HotA Player
|
|
posted October 22, 2015 10:26 AM |
|
|
Limbic should really have someone in charge of balance. This is really dirty, particulary Elite creatures....
|
|
Elvin
Admirable
Omnipresent Hero
Endless Revival
|
|
posted October 22, 2015 10:31 AM |
|
|
Yeah, they are wimpy.
____________
H5 is still alive and kicking, join us in the Duel Map discord server!
Map also hosted on Moddb
|
|
MeTaNoV
Hired Hero
In Heroes We Trust!
|
posted October 22, 2015 10:34 AM |
|
Edited by MeTaNoV at 10:35, 22 Oct 2015.
|
Maurice said:
Ravel said:
Edit: Just realized that google will, by default, try to display the excel sheet rather than offer it as a download, but you can't see the ability icon tooltips that way. It's best viewed by downloading it and opening it in Excel.
When looking at it through the browser, it will clearly show page breaks. If I may make a suggestion, I would try and make each faction fit on its own page. Right now, you actually require two pages, because a few columns fall off on the right, onto the next page. There's room to be had, for instance you can put the name of the faction directly above the stats for that faction, instead of in its own column and columns like the Range column are wider than needed.
The compilation is a great piece of work, though .
Here is a "commentable" version, not sure if you can also resize without editing capabilities, but it should be nicely displayed!
[url=https://docs.google.com/spreadsheets/d/1SFHPuclOApR5AqETnqCuSGNY0W_B1rSuJGpVsJtD6N4/edit?usp=sharing]MMH7 Creatures Stats[/url]
@Ravel, can I keep it like this? Or do you want me to make it private again? (or Editable by some/every one!  )
|
|
MeTaNoV
Hired Hero
In Heroes We Trust!
|
|
posted October 22, 2015 10:46 AM |
|
|
I just noticed that neutral creatures are also missing! 
Could also be useful.
Apart from balancing, consistency is sometimes not trivial...
Just an example, yesterday while playing, I was wondering by DMG type is changing from Apprentice to Disciple. Apprentice does not really throw fire like cabir...
|
|
Maurice
Hero of Order
Part of the furniture
|
|
posted October 22, 2015 11:16 AM |
|
Edited by Maurice at 11:16, 22 Oct 2015.
|
MeTaNoV said:
Apart from balancing, consistency is sometimes not trivial...
Just an example, yesterday while playing, I was wondering by DMG type is changing from Apprentice to Disciple. Apprentice does not really throw fire like cabir...
The piercing shot ability that they have is Fire Magic based. The Disciple gains a Nova ability, which deals Prime Magic damage. As such, Disciples have two different damage types, Fire and Prime.
|
|
MeTaNoV
Hired Hero
In Heroes We Trust!
|
|
posted October 22, 2015 11:36 AM |
|
Edited by MeTaNoV at 11:36, 22 Oct 2015.
|
Maurice said:
The piercing shot ability that they have is Fire Magic based. The Disciple gains a Nova ability, which deals Prime Magic damage. As such, Disciples have two different damage types, Fire and Prime.
Hmmm, I find this weird then... Marksmen have also Piercing Shot but the have physical DMG! (And, they are throwing some kind of blueish ball if I remember?)
|
|
alcibiades
Honorable
Undefeatable Hero
of Gold Dragons
|
|
posted October 22, 2015 12:41 PM |
|
|
I tried to do a few visual updates which I think makes it slightly more accessible. Feel free to save whatever you want, here is my edited version.
____________
What will happen now?
|
|
Steyn
Supreme Hero
|
|
posted October 22, 2015 01:02 PM |
|
|
I think something is wrong with the bone/spectral dragon damage.
The rest looks really good though
|
|
Ravel
Hired Hero
|
|
posted October 22, 2015 05:24 PM |
|
|
alcibiades said:
I tried to do a few visual updates which I think makes it slightly more accessible. Feel free to save whatever you want, [url=https://dl.dropboxusercontent.com/u/7790382/H7%20Creature%20Stats.xlsx]here[/url] is my edited version.
Looks really good - definitely an improvement.
Is there some way to make an excel sheet publicly editable (to make addtions/updates)? I know you can share one on google spreadsheets.., but doesn't that remove/alter some of the formatting?
Steyn said:
I think something is wrong with the bone/spectral dragon damage.
The rest looks really good though
Yeah, I noticed that while making this as well... i think it's a programming typo that they made the Bone Dragon deal dark damage with its melee attack and the Spectral Dragon deal dark damage with its melee attack.
|
|
MeTaNoV
Hired Hero
In Heroes We Trust!
|
|
posted October 22, 2015 05:29 PM |
|
|
Ravel said:
Is there some way to make an excel sheet publicly editable (to make addtions/updates)? I know you can share one on google spreadsheets.., but doesn't that remove/alter some of the formatting?
Did you checked the import I did of your file?
I think it was pretty neat, and afterwards, you can make it public, see the modifications history, and so on...
|
|
Ravel
Hired Hero
|
|
posted October 22, 2015 05:41 PM |
|
|
MeTaNoV said:
Ravel said:
Is there some way to make an excel sheet publicly editable (to make addtions/updates)? I know you can share one on google spreadsheets.., but doesn't that remove/alter some of the formatting?
Did you checked the import I did of your file?
I think it was pretty neat, and afterwards, you can make it public, see the modifications history, and so on...
Yeah, I think that works - would just need to change the table color schemes to be unique for each faction and make the ranged font color for non-range units less visible.
If I have time I'll try adding growth and cost columns today as well.
|
|
WhiteRider
Known Hero
death walks with me
|
|
posted October 30, 2015 02:34 AM |
|
|
|
Elegance is missing even from the creature stats. 68 damage, why not 70? Or 92 - why not 90 or 95? I am not convinced that "their" balance is so precise that they have to use exactly these numbers. It seems to me that the developers are many other things but not very bright.
|
|
|
|
