Improved Hero Level Calculator

Player Guides
1

Hey

I have updated and improved the spreadsheet I made for working out hero level requirements

Now there are 4 tabs - the 1st is the same as before where you see what XP was left to go how much food you need and how many feeder heroes you need.

The other 3 tabs all contain information on how long it will take you to train heroes based on what training camp you are using and what level you hero is at/going to (one tab for each * hero). I have only done the main training camp for obvious reasons

If anyone has any questions please feel free to add me on line app my ID pro-gamer527

Enjoy :slight_smile:

12 Likes
2

Nice work… Many thanks!!! :smiling_face_with_three_hearts:

1 Like
3

No worries, happy to help the community :slight_smile:

1 Like
4

When i put rank 3 level 1 for 4 heroes as beggining and rank 4 level 70 as end it shows wrong value.
Dont have time to check fromulas but something is off

5

What value is wrong?

6

Total experience needed and all other values that base on it

7

Ok, I will take offline and have a look at it. Thanks

8

To level 4 star from rank 3 level 1 to rank 4 level 70 you need 126276 exp and your sheet shows 167597

9

@kaliope, try now, should be ok

10

Looks ok now ,thnx m8 really great tool

1 Like
11

No worries, thank you for highlighting the issue. I don’t want to accidentally give out the wrong info out :slight_smile:

12

There is some error with rank 4 now thou :slight_smile:
4 star 4.1 to 4.70 shows inccorect value

13

Don’t you love formula’s change one and another messes up :sweat_smile:

I have been through the 3/4/5 calculators now to make sure they are calculate like they should and they seem to be working.

Any other issues just let me know

1 Like
14

Hey,
Check now 4 star 3.1 to 3.60 is correct but 3.8 to 3.60 is wrong.

15

@kaliope, I’m so sorry for this… this was actually my very 1st effort into formulas, I have since learned much more and could probably rebuild this better now. That said I have been through the formula for the 4* calculator and believe I have found the issue (referenced wrong cell on the error).

Please try again now, hopefully I have actually fixed the issue rather than moving it around the sheet :crazy_face:

16

Hi everyone

I have just added hero academy training levels 1 and 3 onto the calculators

lvl1 is for 1* common heroes and lvl3 is for 2* uncommon heroes.

Any issues let me know :slight_smile:

DrS

1 Like
17

I checked only the Hero Academy 3, one 2* feeder every minute. What you use in your calculations:
1 x 2* feeder of same color = 468 points - correct
5 x 2* rainbow feeders = 5 * 468 * 0.8 = 5 * 374.40 = 1872 points - incorrect

Statistically, one of those feeders is of the “right” color thus counting with full 468 points.
formula should be 468 * (1 + 4 * 0.8) = 468 * 4.2 = 1965.60 points

If you used same logic about rainbow feeding in all your calculations then you’re off on all acounts.

18

you can’t say or guarantee what colour feeder heroes you will get from any training camp, at worst my calculations will over compensate for any non same colour heroes for the reasons you state above, thus saving people some feeders/food.

You could in theory get 20 feeders from say tc2 and not 1 red then next time get 20 and get 19 red

I’m happy with how I have done my calculations but thanks for the note :slight_smile: