Hero Booklet - An Excel Database of Heroes, Classes, Stats, Specials etc

Hero Booklet

Current Version
Version 4.3

  • V31 Balance Changes (August 31)
  • Beta Changes to upcoming heroes

What Is It?

The Hero Booklet is an Excel Spreadsheet which Tabulates all the data for heroes currently in Empires & Puzzles.

The Sheet allows the user track which heroes are owned & to sort the entire booklet by:

  • Name
  • Colour/ Element
  • Class (Barbarian, Wizard etc…)
  • Family (inc. Costumed/ vanilla, event etc…)
  • Base Stats (Attack, Defence, Health, Power)
  • Special Skill (Sniper, Defence Debuff, Attack Buff etc…)
  • Special Skill Speed
  • Ownership

Why?

I initially built it for my own personal hero tracking & records. Wanting to know who’s the best hero for use in situations without having to click on every single card I have in my inventory etc…
Also allowed me to compare heroes when choosing who would be the next to level up.

Future Updates

Plan to maybe build in some additional stuff

  • Damage Calculator, to allow users to compare which hero’s special is going to be most effective
  • 2 & 1* Heroes. More for completion than anything as there isn’t really a use for these anymore now that tournaments are gone.
  • Personal Roster Sheet

Archives

Version 4.2

Version 4.2

  • New Valhalla Beta heroes (Thor, Odin, Gefjon Lord Loki)
  • New Beta HotM Heroes (Reuben, Zulag, Glenda)
Version 4.1

Version 4.1

  • New Valhalla 4* Heroes
  • New valhalla 5* heroes
  • Released version of Raffaele
  • Changes to Beta Heroes
Version 4.0

Version 4.0

  • Added in the second round of costumes
  • Added new springvale heroes
  • Added new Valhalla heroes
  • Added new HotM
  • Switched to a Google Sheet
  • Added a bunch of pre-built filters
  • All current Beta Heroes
29 Likes

Fantastic info gathering! Bookmarked and saved to my own GDrive! Kudos to you.

2 Likes

Thanks a million :heart:.
Bookmarked and will be used extensively
I like the format and seem to be easy to use.
Have a merry and happy.
Wolf9
:sunglasses:

3 Likes

@Guvnor, this is FANTASTIC!! Thank you for sharing!!

P.S You seem so familiar, I just can’t put my finger on who you remind me of :wink:

Thanks for your sheet @Guvnor. Guess many people will be happy that they don’t have to type in all the data!

1 Like

Thanks @Guvnor, I had started something similar for my personal use but yours is way more detailed and user friendly. Fansatic job! :+1:

1 Like

Good job @Guvnor, thank you, it’s really helpful!

I found a typo - two lines with name “Horghall - [+CB]” but the second one probably is “Lianna - [Cost]”

1 Like

Yeah it is. I thought that got fixed… I picked it up earlier but must have done it in another copy of the book and missed this one.

Hero Booklet now updated to V4 to include all new heroes added to the game including the second round of costumes

1 Like

Annnndddd Updated again to reflect the May 2020 Balance Changes

Annnnnddd finally caught up with inputting the new heroes in Beta. These are listed at the top as # BETA :slight_smile:

1 Like

I have been searching for something like this! Thanks a mil for sharing!

1 Like

Updated to reflect the new Season 3 heroes (3* and 4*) as well as the released version of Raffaele

:slight_smile:

1 Like

Hello @Guvnor, I create Hero Emblem cost organazer, because I search and did not find what I need.
Here is the Spreadsheet Link
I mean, the hero list come from… I copy paste from your spreadsheet hero.

Here is sample screenshot:


Thanks.

1 Like

Updated to Version 4.2 to include the New Beta Heroes (4x new S3 heroes & 3x new HotM)

2 Likes

Awesome!!! Thank you!!!
But, no 5* Sorcerers in BETA?

Thanks @Guvnor! I was inspired by this, and wanted to add some additional fields.

Here is my version:

Fields added:

  • Effects 1 - 5. I wanted the literal special text from each card. Pulled from the wiki wherever possible: https://empiresandpuzzles.fandom.com/f
  • Special. This is merely a concatenation of Effects 1-5.
  • Innate. For family, realm, and Gen 3 HOTM resists, etc.
  • Hero Image. All links sourced from images found at https://empiresandpuzzles.fandom.com/f
  • Fixed a few typos in hero names, and a couple Speed errors (Killhare and Raffaele)

From there I built a Google Data Studio Report to shine it up a bit:

The Data Studio filter controls are powerful, if a bit finicky due to case sensitivity and most options requiring exact matches. If you can google some basic regex you can write some powerful searches on the Special data without too much trouble.

In any case, I plan to keep up with the database and have some plans to build hero ownership and emblem/class tools on top of this. I’m trying to learn Python and this will be a good project for me.

It goes without saying, but if you (or anyone) feel what I’ve done is an advancement to your sheet feel free to use it!

1 Like

Great job @Guvnor, thank you!!

I also found 2 typo’s in hero names: Nodri->Nordri and Cochin->Chochin

1 Like

Updated the Hero Booklet :slight_smile:

Cookie Settings