Heroes of Might and Magic Community
visiting hero! Register | Today's Posts | Games | Search! | FAQ/Rules | AvatarList | MemberList | Profile


Age of Heroes Headlines:  
5 Oct 2016: Heroes VII development comes to an end.. - read more
6 Aug 2016: Troubled Heroes VII Expansion Release - read more
26 Apr 2016: Heroes VII XPack - Trial by Fire - Coming out in June! - read more
17 Apr 2016: Global Alternative Creatures MOD for H7 after 1.8 Patch! - read more
7 Mar 2016: Romero launches a Piano Sonata Album Kickstarter! - read more
19 Feb 2016: Heroes 5.5 RC6, Heroes VII patch 1.7 are out! - read more
13 Jan 2016: Horn of the Abyss 1.4 Available for Download! - read more
17 Dec 2015: Heroes 5.5 update, 1.6 out for H7 - read more
23 Nov 2015: H7 1.4 & 1.5 patches Released - read more
31 Oct 2015: First H7 patches are out, End of DoC development - read more
5 Oct 2016: Heroes VII development comes to an end.. - read more
[X] Remove Ads
LOGIN:     Username:     Password:         [ Register ]
HOMM1: info forum | HOMM2: info forum | HOMM3: info mods forum | HOMM4: info CTG forum | HOMM5: info mods forum | MMH6: wiki forum | MMH7: wiki forum
Heroes Community > Heroes 7 - Falcon's Last Flight > Thread: Creature Stats Excel Sheet
Thread: Creature Stats Excel Sheet
Ravel
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.

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
MeTaNoV
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!


 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
ChrisD1
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).
____________

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Elvin
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!

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Maurice
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 .

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
alcibiades
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?

 Send Instant Message | Send E-Mail | View Profile | PP | Quote Reply | Link
malax83
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....


 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Elvin
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!

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
MeTaNoV
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! )


 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
MeTaNoV
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...

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Maurice
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.

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
MeTaNoV
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?)

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
alcibiades
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?

 Send Instant Message | Send E-Mail | View Profile | PP | Quote Reply | Link
Steyn
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

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Ravel
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.

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
MeTaNoV
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...

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Ravel
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.

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
WhiteRider
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.

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Jump To: « Prev Thread . . . Next Thread »
Post New Poll    Post New Topic    Post New Reply

Page compiled in 0.0375 seconds