Required Experience and Food calculator for any hero

Perhaps @Coppersky knows the answer to this? I’m an Excel Philistine… :sob:

2 Likes

Could you write the XP formula here in the forum?

2 Likes

Formulas
A. Formula for how much EXP a hero at a certain level will provide to another hero of a different color.
B. Formula for how much EXP a hero at a certain level will provide to another hero of the same color.

Start with the current level at whatever ascension you are at (LV). The total level (TOTLV) can be determined by the following:
If first ascension it is just your level.
If second ascension it is your current level plus the max of the first ascension.
If third ascension it is your current level plus the max of the first and second ascension.
If fourth ascension it is your current level plus the max of the first and second and third ascension. See the end of this post for the max level at each ascension.

So if you are a 5 star 4th ascension at level 5 your level would be 5 + 50 + 60 + 70 = 185.
Formula A and B will tell how much experience this hero would provide to level up others. (Although that would be insane with this guy )

The Total Level (TOTLV) is ONLY used for formulas A and B. – how much feed exp does a hero provide.

C to F: Formulas for how much EXP is needed to take a hero from one level to the next.
For this formula the level (LV) is just the current level in the current ascension – no addition needed. (simple) - Just apply the correct formula based on stars and ascension.
1 Star
A. Round(TOTLV * 7 +143)
B. Round(1.2*(TOTLV * 7 +143))
C. If First Asc. Round(1.1959 *LV^2- 3.801 * LV +152.56)
D. If Second Asc. Round(0.4126 *LV^2 + 0.325 * LV +171.38)

2 Star
A. Round(TOTLV * 19 +371)
B. Round(1.2*(TOTLV * 19 +371))
C. If First Asc. Round(0.2752 *LV^2 + 0.7902 * LV +185.27)
D. If Second Asc. Round(0.1213 *LV^2 + 2.4757 * LV +214.37)
E. If Third Asc. Round(0.0997 *LV^2 + 3.602 * LV +242.13)

3 Star
A. Round(TOTLV * 31 +599)
B. Round(1.2*(TOTLV * 31 +599))
C. If First Asc. Round(0.1217 *LV^2+2.4671 * LV +249.39)
D. If Second Asc. Round(0.0994 *LV^2 + 3.6288 * LV +254.7)
E. If Third Asc. Round(0.1502 LV^2 + 4.3914 * LV +270.3)
4 Star
A. Round(TOTLV * 45 +855)
B. Round(1.2
(TOTLV * 45 +855))
C. If First Asc. Round(0.0808 *LV^2 + 3.6522 * LV +282.11)
D. If Second Asc. Round(0.1003 *LV^2 + 5.5797 * LV +288.26)
E. If Third Asc. Round(0.1501 *LV^2 + 7.3885 * LV +304.53)
F. If Fourth Asc. Round(0.2999 LV^2 + 10.813 * LV +316.42)
5 Star
A. Round(TOTLV * 60+1140)
B. Round(1.2
(TOTLV * 60 +1140))
C. If First Asc. Round(0.0988 *LV^2 + 4.6903 * LV +338.37)
D. If Second Asc. Round(0.1503 *LV^2 + 7.3779 * LV +404.45)
E. If Third Asc. Round(0.35 *LV^2 + 12.6 * LV +473.04)
F. If Fourth Asc. Round(0.4007 *LV^2 + 18.341 * LV +562.27)

Max Level at each Ascension (asX)
Stars = 1
as1 = 10 as2 = 20
Stars = 2
as1 = 20 as2 = 30 as3 = 40
Stars = 3
as1 = 30 as2 = 40 as3 = 50
Stars = 4
as1 = 40 as2 = 50 as3 = 60 as4 = 70
Stars = 5

10 Likes

Hopefully this is helpful and there are not too many typos…

1 Like

I didn’t look at the exp values as I typically just feed to max; however, the food costs are going to vary wildly dependent on what fodder you’re consuming… what was your premise on that part?

1 Like

Food Calculation
Use the current level in the current ascension.
Food per hero = Base + (LV-2) * slope
1 Star 1000 + (LV-2) *20
2 Star 1200 + (LV-2) *24
3 Star 2100 + (LV-2) *42
4 Star 3000 + (LV-2) *60
5 Star 5000 + (LV-2) *100

So a 5 Star 4th ascension going from level 23 to 24 will take 5000 + 2100 food = 7100
This is true regardless of what level hero you feed to hero you are trying to level up. - so it is 7100 if you feed a 5 star or a 1 star to another hero.

Another interesting fact - the food calc is the cost for one press of the level up button. If you give 10 heros to the food god (max) all 10 of them will cost the same amount - - it is true you might level up your hero by 13 levels - but each feeder hero costs the same! – if you fed them one at a time - the food cost would go up and be set by the current hero level when you press the initial level button.
So as a rule it saves food to always train with multiple heros.

5 Likes

Correction - the LV in this formula is the NEXT level you will acheive. So going from Level 1 to Level 2 you plug in 2 for LV in the formula.

Also I did not include the food required to Ascend - but that is a constant based on the level and the stars.

1 Like

Thank you very much for the EXP formulas. They work, almost always. :slight_smile: In the B formulas, you forgot an opening parenthesis. I think it goes before TOTLV and the B scores are just 20% more than the A scores (+/- some rounding).

But actually I was far more interested in the C-F formulas. My fodder heroes are almost always at 1.1 or 2.1 and I know how much EXP they provide by heart.

I’ve tested C-F with 9 heroes of 4* and 5*. For 8 of them the answer from formulas was correct. But I have a 4** Tiburtus at 4.21. The formula without rounding says 699.4576 . The game says 700 XP. Still, it doesn’t practically matter for me because I wanted to know how many thousands EXP I’ll need to fully level up my heroes.

2 Likes

True, training with multiple heroes saves a tiny bit of food but decreases a tiny bit the chances of improving the special skill. But those are tiny changes, more important is that training with multiple heroes saves taps/clicks. :slight_smile:

2 Likes

Third consecutive post. Sorry.

I’ve used Thrashina’s formulas to calculate the EXP needed from one ascension to the next. Hope I didn’t get anything very wrong. Here it is:

For 4* hero:
3.1 -> 3.60 = 42557
4.1 -> 4.70 = 83717

For 5* hero:
2.1 -> 2.60 = 48453
3.1 -> 3.70 = 104815
4.1 -> 4.80 = 173498

2 Likes

Thanks I fixed the typo in formula B.
The EXP to level formulas are correct but are subject to rounding error - I only put the first few decimal points in the post. So they could be 1 EXP off occasionally.

1 Like

I validated your calculations - they are all correct. Useful tables - then divide that by 150 for 1 star heros of a diff color and you know how many you need - very useful!

2 Likes

Actually I ran the math on if it is better to do 10 1% chance level ups independently (10 transactions) or one transaction with 10 heros - showing 10% chance. The probabilities are surprisingly identical. So on average you have a 10% chance of improvement. But if you do 10 1% independently you could possibly get more than one improvement - up to 10 really (7 max) but the chance is slim.

But over a large sample it works out to the same averages. (spent way too much time thinking about this…)

4 Likes

Oh indeed… :blush:

Because of

5 Likes

There’s some issues with your assessment.

You are correct that the cost is the same; however, you still have to fill the exp bar and the rate varies wildly. If I use 1* off color fodder, that will take more fodder (as you state, it is per individual fodder card) and therefore more food than even 1* on color… let alone 2* off/on color or higher tier cards.

As a result, it’s nowhere close to the same amount, it depends on what fodder you are using explicitly.

Also I’d note using 10 fodder heroes at a time is not necessarily optimal; really if you’re trying to be hardcore about it (I’m way too lazy and the savings is absurdly trivial) you want to come as close as possible to maxing out your current level, regardless of the number of feeds that takes, and then do a big 10 feed to minimize the food used.

Maybe we’re getting at two different things, exp is a full measurement, but you used an individual measurement for food costs… without looking I was assuming you were doing both full measurement, and you can’t really do that on the food side.

1 Like

Thanks for the clarification - you are correct that with the goal of actually leveling up your heros - you can’t know how much food it will take unless you somehow combine it with the amount of EXP. All it does confirm is for a given starting level it shows the cost of each hero you feed during that level up attempt.

1 Like

Some of us want to know the cost! :wink:

1 Like

Thanks for the XP formulas, @thrashina . I was working on my own leveling costs SS, and your work saved me a good bit of guessing/stumbling in the dark trying to do curve fitting!

If the macros survive intact when you import this to google docs, that version would be easily shared.

Even without the macros, those of us who are better with spreadsheets could probably put it to good use…

1 Like

agree with @BarryWuzHere. If you could just upload it to Google Sheets @thrashina, one of us can get it working there and shareable.

Here is the xlsm sheet uploaded to google sheets.

There was a macro button for the Hero calc from level A to Level B - but the macro did not translate - so here is the VBA code I wrote for the button:

Sub calcexp()
'From input data in BLUE
StartLev = Cells(1, 8)
EndLev = Cells(2, 8)
ASCENStart = Cells(3, 8)
ASCENEnd = Cells(4, 8)
Stars = Cells(5, 8)
Foodoffset = 5
If Stars = 1 Then
cr = 7 'Column of EXP data
as1 = 10 'Max Lev at Asc
as2 = 20
as3 = 0
as4 = 0
ElseIf Stars = 2 Then
cr = 26
as1 = 20
as2 = 30
as3 = 40
as4 = 0
ElseIf Stars = 3 Then
cr = 46
as1 = 30
as2 = 40
as3 = 50
as4 = 0
ElseIf Stars = 4 Then
cr = 68
as1 = 40
as2 = 50
as3 = 60
as4 = 70
ElseIf Stars = 5 Then
cr = 87
as1 = 50
as2 = 60
as3 = 70
as4 = 80
End If

If ASCENStart = 1 Then
EL = 0 'Extra Levels for Starting level
ElseIf ASCENStart = 2 Then
EL = as1
ElseIf ASCENStart = 3 Then
EL = as2 + as1
ElseIf ASCENStart = 4 Then
EL = as3 + as2 + as1
Else
EL = 0
End If
SL = EL + StartLev 'Start Level for Formula

If ASCENEnd = 1 Then
ELE = 0 'Extra Levels for Ending level
ElseIf ASCENEnd = 2 Then
ELE = as1
ElseIf ASCENEnd = 3 Then
ELE = as2 + as1
ElseIf ASCENEnd = 4 Then
ELE = as3 + as2 + as1
Else
ELE = 0
End If
EL = ELE + EndLev 'End Level for Formula

OffR = 18 ’ Offset rows to Get to start level

TotExp = Application.Sum(Range(Cells(SL + OffR, cr), Cells(EL + OffR, cr)))

TotFood = Application.Sum(Range(Cells(SL + OffR, cr + 1), Cells(EL + OffR, cr + 1))) 'Bad Estimate
TotFood1star = Application.Sum(Range(Cells(SL + OffR, cr + Foodoffset), Cells(EL + OffR, cr + Foodoffset)))
TotFood2star = Application.Sum(Range(Cells(SL + OffR, cr + Foodoffset + 2), Cells(EL + OffR, cr + Foodoffset + 2)))
TotFood3star = Application.Sum(Range(Cells(SL + OffR, cr + Foodoffset + 4), Cells(EL + OffR, cr + Foodoffset + 4)))

Cells(7, 7) = TotExp
'Cells(8, 7) = TotFood
Cells(9, 10) = TotFood1star
Cells(10, 10) = TotFood2star
Cells(11, 10) = TotFood3star
End Sub

6 Likes

Cookie Settings