Check out the Drawing Contest going on in the Artwork Center! Deadline extended to April 20th! If you have submitted something, you may resubmit something else on the next deadline! 
  Calculate experience required for level  
 
Author  Message 

rpfeltz ☆
Join date : 20130312 Posts : 6
 Subject: Calculate experience required for level Tue Mar 12, 2013 7:30 am  
 A while ago, I was bored and attempted to create a formula which allows one to calculate the amount of experience (XP) required to reach a certain level (Lvl). Unfortunately, I overlooked some exceptions to it and failed. However, I have now constructed a formula which takes these exceptions into account: XP = 93¾Lvl²−12043¾Lvl+558675+√((Lvl−22)²)×(2½Lvl−52½)+√((Lvl−42)²)×(2½Lvl−102½)+√((Lvl−62)²)×(7½Lvl−457½)+√((Lvl−82)²)×(12½Lvl−1012½)+√((Lvl−101)²)×(43¾Lvl−4375) For example, the amount of experience required to reach level 80 from level 1 is 93¾×80²−12043¾×80+558675+√((80−22)²)×(2½×80−52½)+√((80−42)²)×(2½×80−102½)+√((80−62)²)×(7½×80−457½)+√((80−82)²)×(12½×80−1012½)+√((80−101)²)×(43¾×80−4375) = 191600, and the amount of experience required to reach level 70 from level 1 is 93¾×70²−12043¾×70+558675+√((70−22)²)×(2½×70−52½)+√((70−42)²)×(2½×70−102½)+√((70−62)²)×(7½×70−457½)+√((70−82)²)×(12½×70−1012½)+√((70−101)²)×(43¾×70−4375) = 141100. Thus, the amount of experience required to reach level 80 from level 70 is 191600−141100 = 50500. I'll write a small calculator in ActionScript (as it's the only language supported by the version of BBS used on this forum) and put it here. Here it is:
Last edited by rpfeltz on Wed Mar 20, 2013 3:02 pm; edited 3 times in total 
   Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Calculate experience required for level Tue Mar 12, 2013 7:49 am  
 Hi rpfeltz, welcome to the forums! Did you read the topic about Enhancement Calculator and formulas in the Encyclopedia section? This post in particular is interesting:  kyaaya wrote:
 luxionmk2 wrote:
 There's way more data collected, and there doesn't seem to be any formula to find *when* the pattern for XP per level increases, nor by how much.
Actually there is some pattern to the increase in tonextlevel xp needed (TNL). (added column E to XP table sheet in the googledoc calculator to highlight this)
First value is 50 at level 2 (100 xp for level 2 and 150 xp for level 3), and it remains constant for the next 20 levels till the next jump, 60 at level 22, then constant for another 20 levels and jumps again, 70 at level 42, then constant for another 20 levels and jumps again, 100 at level 62, then constant for another 20 levels and jumps again, 150 at level 82, , then constant for another 19 levels and jumps again, 325 at level 101, and remains constant till 120.
The last jump at 101 breaks the pattern slightly and might be wrong. Good to collect some data points on that but I doubt I will get a 6* for a long time to come.
Your formula confirms the values that kyaaya provides for the first 22 levels. However, your formula doesn't take into account the jump in stepsize that kyaaya explains happens at the benchmark points of levels 22, 42, 62, 82 and 101. Would you care to comment on this please? I am rather impressed with your formula, by the way. I have a spreadsheet myself where I calculate the XP needed for levels 1120 using kyaaya's numbers, but I need 2 columns to be able to calculate it  one for the XP going up 1 level and another one adding that up to the total amount of XP  because I couldn't come up with the formula you just provided. 
   rpfeltz ☆
Join date : 20130312 Posts : 6
 Subject: Re: Calculate experience required for level Tue Mar 12, 2013 8:14 am  
 I assumed that the amount of XP required to level up is the current level × 50 + 50. Then I used the deratives at midlevel XP quantities to determine a function. If there are any exceptions to the amount of XP required to level up, my current formula won't work. It should not be very hard to fix though. I'll look into it now.  kyaaya wrote:
 First value is 50 at level 2 (100 xp for level 2 and 150 xp for level 3), and it remains constant for the next 20 levels till the next jump,
60 at level 22, then constant for another 20 levels and jumps again, 70 at level 42, then constant for another 20 levels and jumps again, 100 at level 62, then constant for another 20 levels and jumps again, 150 at level 82, , then constant for another 19 levels and jumps again, 325 at level 101, and remains constant till 120.
When exactly does the jump occur? Before or after reaching level 22? 
   Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Calculate experience required for level Tue Mar 12, 2013 8:34 am  
  rpfeltz wrote:
 When exactly does the jump occur? Before or after reaching level 22?
After. I should tell you that I never took the time to confirm kyaaya's numbers. Perhaps we should make it our personal project to confirm the exact thresholds and XP jumps? I've kinda made it my mission in life to figure out stuff like this, so I'm probably going to try to confirm them even if you don't care for it. 
   rpfeltz ☆
Join date : 20130312 Posts : 6
 Subject: Re: Calculate experience required for level Tue Mar 12, 2013 8:55 am  
 That's the spirit! I'm currently generating a polynomial that generates the correct values. 
   Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Calculate experience required for level Wed Mar 13, 2013 9:56 am  
 I've checked the amount of EXP required to go from level 68 to level 69. In this instance, kyaaya's numbers check out 100%. First, I'll explain my method: I had a Rose at level 67, that was close to level 68. When she was almost there, I played Quest 28 where I waited to deploy Rose until the last second, so she could only kill 1 goblin. That gives her exactly 1 EXP. I repeated this proces until she leveled up. I now had a Rose at level 68 with no EXP towards the next level. Then I logged all EXP I gained with her. I aimed to end up at a round 4400 EXP, because that's what Kyaaya's numbers suggested should be the next level. Log: 1) 154 EXP GET (event boss) 2) 308 EXP GET (27) 3) 308 EXP GET (27) 4) 308 EXP GET (27) 5) 308 EXP GET (27) 6) 308 EXP GET (27) 7) 308 EXP GET (27) 8] 308 EXP GET (27) 9) 308 EXP GET (27) 10) 308 EXP GET (27) 11) 308 EXP GET (27) 12) 308 EXP GET (27) 13) 308 EXP GET (27) 14) 308 EXP GET (27) 15) 182 EXP GET (23) 16) 20 EXP GET (28] 17) 20 EXP GET (28] 18) 15 EXP GET (44) 19) 4 EXP GET (28] 20) 1 EXP GET (28] As you can see, I slowed her progress at the end in order to get a precise result  and it worked. She leveled up to level 69 with that last 1 EXP. Since Kyaaya's numbers check out, her total EXP should be 136,650 at this point. I'll keep track of her EXP until she reaches level 100. By the way, if you want to log EXP too, my notes might prove useful so I'll copy them here: 11: 0 BT (7 monsters, 2 allies) – 100120 XP (Goblin) 12: 0 BT (7 monsters, 2 allies) – 110132 XP (Rabid Wolf) 13: 0 BT (10 monsters, 2 allies) – 120144 XP (Goblin) 14: 0 BT (13 monsters, 3 allies) – 130169 XP (Rabid Wolf) 15: 0 BT (8 monsters, 3 allies) – 180234 XP (Goblin, Troll) 21: 0 BT (12 monsters, 3 allies) – 120156 XP (Killer Bee) 22: 0 BT (16 monsters, 3 allies) – 130169 XP (Goblin, Killer Bee) 23: 0 BT (13 monsters, 3 allies) – 140182 XP (Rabid Wolf, Killer Bee) 24: 0 BT (19 monsters, 3 allies) – 150195 XP (Killer Bee) 25: 0 BT (19 monsters, 3 allies) – 160208 XP (Killer Bee, Rabid Wolf) 26: 0 BT (19 monsters, 3 allies) – 170221 XP (Goblin, Killer Bee) 27: 0 BT (12 monsters, 4 allies) – 220308 XP (Killer Bee, Lizard Man) 28: 0 BT (15 monsters, 0 allies) – 20 XP (Goblin) 210: 0 BT (30 monsters, 0 allies) – 200 XP (Goblin, Killer Bee, Lizard Man, Rabid Wolf) 31: 0 BT (7 monsters, 3 allies) – 130169 XP (Scorpion) 32: 0 BT (12 monsters, 3 allies) – 140182 XP (Goblin, Scorpion) 33: 0 BT (16 monsters, 3 allies) – 150195 XP (Scorpion, Killer Bee) 34: 0 BT (13 monsters, 3 allies) – 160208 XP (Scorpion, Killer Bee) 35: 0 BT (20 monsters, 3 allies) – 170221 XP (Killer Bee, Scorpion, Goblin) 36: 0 BT (18 monsters, 3 allies) – 180234 XP (Rabid Wolf, Scorpion, Killer Bee) 37: 0 BT (14 monsters, 3 allies) – 230299 XP (Scorpion, Treant) 38: 0 BT (18 monsters, 0 allies) – 25 XP (Killer Bee) 310: 0 BT (23 monsters, 0 allies) – 180 XP (Killer Bee, Rabid Wolf, Goblin, Treant, Lizard Man, Troll) 41: 0 BT (16 monsters, 3 allies) – 140182 XP (Toad, Imp) 42: 0 BT (10 monsters, 3 allies) – 150195 XP (Scorpion, Toad, Imp) 43: 0 BT (13 monsters, 3 allies) – 160208 XP (Scorpion, Imp) 44: 0 BT (17 monsters, 3 allies) – 170221 XP (Scorpion, Killer Bee, Imp) 45: 0 BT (16 monsters, 3 allies) – 180234 XP (Toad, Imp, Treant) 46: 0 BT (14 monsters, 3 allies) – 190247 XP (Rabid Wolf, Scorpion, Killer Bee, Toad) 47: 0 BT (44 monsters, 3 allies) – 240312 XP (Killer Bee, Toad, Imp, Goblin, Scorpion, Rabid Wolf, Treant) 48: 0 BT (11 monsters, 0 allies) – 30 XP (Toad, Scorpion) 410: 0 BT (21 monsters, 0 allies) – 240 XP (Rabid Wolf, Toad, Scorpion, Imp, Treant, Troll) For small steps: 1 EXP: kill last goblin in 28 2 EXP: kill last 2 bees in 38 3 EXP: kill last 2 goblins in 28 4 EXP: kill last 3 goblins in 28 5 EXP: kill last bee in 36 (no allies) 10 EXP: kill last goblin in 13 (no allies) 15 EXP: kill last imp in 44 (no allies) Each mission has an exprange, because you gain more EXP if you deploy allies. 10% of the original EXP is added to the total for every ally you deploy. Oh and the reason it reads "0 BT" for every mission is because I plan on extending this list for all chapters, including those where you gain BT during events. But you should ignore that for now. EDIT: it checks out 100% for the next 2 levels too. I'm going to stop logging now until she reaches level 80. 
   Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Calculate experience required for level Mon Mar 18, 2013 8:08 am  
 Kyaaya's numbers check out for levels above 82 too! I logged my Rose's EXP gain from level 83 to level 84 and it adds up to exactly 6000 EXP points. Log: 1) 273 EXP GET (event boss) 2) 281 EXP GET (event boss) 3) 261 EXP GET (event boss) 4) 308 EXP GET (27) 5) 308 EXP GET (27) 6) 265 EXP GET (event boss) 7) 277 EXP GET (event boss) 8] 340 EXP GET (event boss) 9) 308 EXP GET (27) 10) 308 EXP GET (27) 11) 308 EXP GET (27) 12) 308 EXP GET (27) 13) 308 EXP GET (27) 14) 308 EXP GET (27) 15) 308 EXP GET (27) 16) 308 EXP GET (27) 17) 308 EXP GET (27) 18) 308 EXP GET (27) 19) 308 EXP GET (27) 20) 198 EXP GET (36) 21) 100 EXP GET (11) 22) 1 EXP GET (28] Total = 6000 EXP from level 83 to level 84. Conclusion: the thresholds [level 22], [level 42], [level 62] and [level 82] are correct. Sadly, I cannot confirm the final [level 101] threshold, because I don't have any 6* cards. 
   rpfeltz ☆
Join date : 20130312 Posts : 6
 Subject: Re: Calculate experience required for level Wed Mar 20, 2013 10:52 am  
 Sorry it's taking so long, I'm simplifying this monstrous formula. I'll just keep updating this post as I make progress. f(x) = 25x²+25x−50+5(½(√((x−22)²)+x−22))²+5(½(√((x−22)²)+x−22))+5(½(√((x−42)²)+x−42))²+5(½(√((x−42)²)+x−42))+15(½(√((x−62)²)+x−62))²+15(½(√((x−62)²)+x−62))+25(½(√((x−82)²)+x−82))²+25(½(√((x−82)²)+x−82))+87½(½(√((x−101)²)+x−101))²+87½(½(√((x−101)²)+x−101)) = 25x²+25x−50+1¼(√((x−22)²)+x−22)²+2½(√((x−22)²)+x−22)+1¼(√((x−42)²)+x−42)²+2½(√((x−42)²)+x−42)+3¾(√((x−62)²)+x−62)²+7½(√((x−62)²)+x−62)+6¼(√((x−82)²)+x−82)²+12½(√((x−82)²)+x−82)+21⅞(√((x−101)²)+x−101)²+43¾(√((x−101)²)+x−101) = 25x²+25x−50+1¼((x−22)²+x²+(22)²+2((x−22)×√((x−22)²)−22x))+2½√((x−22)²)+2½x−2½×22+1¼((x−42)²+x²+(42)²+2((x−42)×√((x−42)²)−42x))+2½√((x−42)²)+2½x−2½×42+3¾((x−62)²+x²+(62)²+2((x−62)×√((x−62)²)−62x))+7½√((x−62)²)+7½x−7½×62+6¼((x−82)²+x²+(82)²+2((x−82)×√((x−82)²)−82x))+12½√((x−82)²)+12½x−12½×82+21⅞((x−101)²+x²+(101)²+2((x−101)×√((x−101)²)−101x))+43¾√((x−101)²)+43¾x−43¾×101 = 25x²+25x−50+2½x²−107½x+2½√((x−22)²)×x+1155−52½√((x−22)²)+2½x²−207½x+2½√((x−42)²)×x+4305−102½√((x−42)²)+7½x²−922½x+7½√((x−62)²)×x+28365−457½√((x−62)²)+12½x²−2037½x+12½√((x−82)²)×x+83025−1012½√((x−82)²) +43¾x²−8793¾x+43¾√((x−101)²)×x+441875−4375√((x−101)²) = 93¾x²−12043¾x+558675+2½√((x−22)²)×x−52½√((x−22)²)+2½√((x−42)²)×x−102½√((x−42)²)+7½√((x−62)²)×x−457½√((x−62)²)+12½√((x−82)²)×x−1012½√((x−82)²) +43¾√((x−101)²)×x−4375√((x−101)²) = 93¾x²−12043¾x+558675+√((x−22)²)×(2½x−52½)+√((x−42)²)×(2½x−102½)+√((x−62)²)×(7½ x−457½)+√((x−82)²)×(12½x−1012½)+√((x−101)²)×(43¾x−4375) Alright, I can't think of a way to simplify it even more. Neither can I think of a way to make an inverse function for this (yet). Neither have I tested this on actual data. I'll put it in the first post anyway. 
   Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Calculate experience required for level Thu Mar 21, 2013 4:39 am  
 Great work, rpfeltz! I tested your formula in my Excel spreadsheet and it checks out perfectly. I'll share the Excel form of the formula with others, in case they also want to use it this way:
=93.75*A1^212043.75*A1+558725+SQRT((A122)^2)*(2.5*A152.5)+SQRT((A142)^2)*(2.5*A1102.5)+SQRT((A162)^2)*(7.5*A1457.5)+SQRT((A182)^2)*(12.5*A11012.5)+SQRT((A1101)^2)*(43.75*A14375)
where A1 is the level of the unit.
Thanks for this! Now if we could just verify the EXP Pts required for levels above 100, we'd be done.
EDIT
simplified Excel formula, thanks to rpfeltz's comment in the next post:
=93.75*A1^212043.75*A1+558725+ABS(A122)*(2.5*A152.5)+ABS(A142)*(2.5*A1102.5)+ABS(A162)*(7.5*A1457.5)+ABS(A182)*(12.5*A11012.5)+ABS(A1101)*(43.75*A14375)
Last edited by Colaleon on Mon Mar 25, 2013 4:41 am; edited 1 time in total 
   rpfeltz ☆
Join date : 20130312 Posts : 6
 Subject: Re: Calculate experience required for level Thu Mar 21, 2013 7:49 am  
 Note that the parts that take the square root of squares are just for computing the absolute value (turning negative numbers positive). If you wish, you can replace SQRT((...)^2) by ABS(...). As you can see in the unsimplified version, I use the sum of the actual value and the absolute value and divide that by two to truncate negative numbers to zero. For example, "5(½(√((x−22)²)+x−22))²+5(½(√((x−22)²)+x−22))" is zero if x is less than or equal to 22, but if x is greater than 22, it's the difference caused by the increased increase in the amount of XP after level 22. In other words, it allows me to turn the derative into a chaotic abomination 
   luxionmk2 ☆
Join date : 20121026 Posts : 36
 Subject: Re: Calculate experience required for level Wed Mar 27, 2013 9:45 am  
 If we sharing formulas, this is the one I came up with for my google doc spreadsheet a while back, using kyaaya's notes to figure the steps. I could have shorthanded some of the calculations, but it was easier for me to see how the numbers worked out, at each step. Also, I use IF statements to determine when to add in the "increases", making my formula a true monstrosity rpfeltz's logic would have definitely cleaned it up, like it did for Colaleon. B10 = Starting Level B11 = End Level =(IF(AND(B11>=1,B11<=22),(B11*(B11+1)*50/2)50,IF(B11>=23,(22*23*50/2)50,))+IF(AND(B11>=23,B11<=42),(B11*(B11+1)*50/2)(22*23*50/2)+((B1122)*(B1121)*5),IF(B11>=23,(42*43*50/2)(22*23*50/2)+(20*21*10/2),))+IF(AND(B11>=43,B11<=62),(B11*(B11+1)*50/2)(42*43*50/2)+((B1142)*200)+((B1142)*(B1141)*10),IF(B11>=43,(62*63*50/2)(42*43*50/2)+(20*21*20/2)+4000,))+IF(AND(B11>=63,B11<=82),(B11*(B11+1)*50/2)(62*63*50/2)+((B1162)*600)+((B1162)*(B1161)*25),IF(B11>=63,(82*83*50/2)(62*63*50/2)+(20*21*50/2)+12000,))+IF(AND(B11>=83,B11<=101),(B11*(B11+1)*50/2)(82*83*50/2)+((B1182)*1600)+((B1182)*(B1181)*50),IF(B11>=83,(101*102*50/2)(82*83*50/2)+(20*21*100/2)+28400,))+IF(B11>=102,(B11*(B11+1)*50/2)(101*102*50/2)+((B11101)*3775)+((B11101)*(B11102)*275/2),))(IF(AND(B10>=1,B10<=22),(B10*(B10+1)*50/2)50,IF(B10>=23,(22*23*50/2)50,))+IF(AND(B10>=23,B10<=42),(B10*(B10+1)*50/2)(22*23*50/2)+((B1022)*(B1021)*5),IF(B10>=23,(42*43*50/2)(22*23*50/2)+(20*21*10/2),))+IF(AND(B10>=43,B10<=62),(B10*(B10+1)*50/2)(42*43*50/2)+((B1042)*200)+((B1042)*(B1041)*10),IF(B10>=43,(62*63*50/2)(42*43*50/2)+(20*21*20/2)+4000,))+IF(AND(B10>=63,B10<=82),(B10*(B10+1)*50/2)(62*63*50/2)+((B1062)*600)+((B1062)*(B1061)*25),IF(B10>=63,(82*83*50/2)(62*63*50/2)+(20*21*50/2)+12000,))+IF(AND(B10>=83,B10<=101),(B10*(B10+1)*50/2)(82*83*50/2)+((B1082)*1600)+((B1082)*(B1081)*50),IF(B10>=83,(101*102*50/2)(82*83*50/2)+(20*21*100/2)+28400,))+IF(B10>=102,(B10*(B10+1)*50/2)(101*102*50/2)+((B10101)*3775)+((B10101)*(B10102)*275/2),)) 
   Kadaan ☆☆☆
Join date : 20121030 Posts : 308
 Subject: Re: Calculate experience required for level Wed Mar 27, 2013 4:47 pm  
 It looks like at least levels 120+ are incorrect. I'm keeping track of exp gained going from 120>140 and I'll update as I go.
Using your formula, I get 563900 for level 120 and 578950 for level 121, so 120>121 should be 15050 exp.
I've gained 5852 exp so far which should be 5852/15050 = 38.88%, but my card says it's at 40%.
edit: Assuming the display percent is using floor() and not round(), it looks like level 120121 takes 14400 and not 15050.
edit: Confirmed. It took 14400 exp to go from 120>121 (40x308+3x630+169+15+5+1)
Last edited by Kadaan on Thu Mar 28, 2013 10:14 pm; edited 2 times in total 
   Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Calculate experience required for level Thu Mar 28, 2013 2:14 am  
 Thanks Kadaan, that's very helpful! I will be level breaking one of my 5* units soon, so I will be able to doublecheck the XP required to level up for levels above 100 too. 
   Sabin76 ☆☆☆
Join date : 20130106 Posts : 330
 Subject: Re: Calculate experience required for level Thu Mar 28, 2013 11:19 am  
 I've been using the IFmonstrosity from the previous calculator in the google doc and I wanted to add a piece to account for progress in the current level. It doesn't work, but I've been over it 3 times and can't find out where my typo is. Full code (B10 = current level, B11 = current EXP in level expressed as a percent, B12 = target level):  Spoiler:

=((IF(AND(B12>=1,B12<=22),(B12*(B12+1)*50/2)50,IF(B12>=23,(22*23*50/2)50,))+IF(AND(B12>=23,B12<=42),(B12*(B12+1)*50/2)(22*23*50/2)+((B1222)*(B1221)*5),IF(B12>=23,(42*43*50/2)(22*23*50/2)+(20*21*10/2),))+IF(AND(B12>=43,B12<=62),(B12*(B12+1)*50/2)(42*43*50/2)+((B1242)*200)+((B1242)*(B1241)*10),IF(B12>=43,(62*63*50/2)(42*43*50/2)+(20*21*20/2)+4000,))+IF(AND(B12>=63,B12<=82),(B12*(B12+1)*50/2)(62*63*50/2)+((B1262)*600)+((B1262)*(B1261)*25),IF(B12>=63,(82*83*50/2)(62*63*50/2)+(20*21*50/2)+12000,))+IF(AND(B12>=83,B12<=101),(B12*(B12+1)*50/2)(82*83*50/2)+((B1282)*1600)+((B1282)*(B1281)*50),IF(B12>=83,(101*102*50/2)(82*83*50/2)+(20*21*100/2)+28400,))+IF(B12>=102,(B12*(B12+1)*50/2)(101*102*50/2)+((B12101)*3775)+((B12101)*(B12102)*275/2),))(IF(AND(B10>=1,B10<=22),(B10*(B10+1)*50/2)50,IF(B10>=23,(22*23*50/2)50,))+IF(AND(B10>=23,B10<=42),(B10*(B10+1)*50/2)(22*23*50/2)+((B1022)*(B1021)*5),IF(B10>=23,(42*43*50/2)(22*23*50/2)+(20*21*10/2),))+IF(AND(B10>=43,B10<=62),(B10*(B10+1)*50/2)(42*43*50/2)+((B1042)*200)+((B1042)*(B1041)*10),IF(B10>=43,(62*63*50/2)(42*43*50/2)+(20*21*20/2)+4000,))+IF(AND(B10>=63,B10<=82),(B10*(B10+1)*50/2)(62*63*50/2)+((B1062)*600)+((B1062)*(B1061)*25),IF(B10>=63,(82*83*50/2)(62*63*50/2)+(20*21*50/2)+12000,))+IF(AND(B10>=83,B10<=101),(B10*(B10+1)*50/2)(82*83*50/2)+((B1082)*1600)+((B1082)*(B1081)*50),IF(B10>=83,(101*102*50/2)(82*83*50/2)+(20*21*100/2)+28400,))+IF(B10>=102,(B10*(B10+1)*50/2)(101*102*50/2)+((B10101)*3775)+((B10101)*(B10102)*275/2),)))(IF(AND(B10>=1,B10<=22),(B10+1)*50*(B11/100),IF(AND(B10>=23,B10<=42),(B10+1)*60*(B11/100),IF(AND(B10>=43,B10<=62),(B10+1)*70*(B11/100),IF(AND(B10>=63,B10<=82),(B10+1)*100*(B11/100),IF(AND(B10>=83,B10<=102),(B10+1)*150*(B11/100),(B10+1)*325*(B11/100)))))))
The part I underlined is the part I added. Even better if you can incorporate that into your Polynomial. BTW: I am amazed and very happy to know that there are still people out there that think this is fun. Even better if you guys are youngins . I teach High School Physics and Math and it's very rare to get a student that is actually enthusiastic about numbers and creating formulas through observed data. 
   luxionmk2 ☆
Join date : 20121026 Posts : 36
 Subject: Re: Calculate experience required for level Thu Mar 28, 2013 5:51 pm  
 120+ is new to me. I don't have the data to adjust my formulas yet. I'm no youngin, but this is the stuff that makes me want to keep playing these "tap tap tap collect" games Oh, I use to take into account partial level progress, but that was during simpler times, before I learned about the steppedincrements in XP 
   Kadaan ☆☆☆
Join date : 20121030 Posts : 308
 Subject: Re: Calculate experience required for level Thu Mar 28, 2013 10:14 pm  
 It was only 300xp difference between 121 and 122 so I'm not sure if the 325 jump at 101 has been confirmed, was just a guess, or if the exp jump actually goes down after 120. 
   Sabin76 ☆☆☆
Join date : 20130106 Posts : 330
 Subject: Re: Calculate experience required for level Fri Mar 29, 2013 10:40 am  
 Interesting... the XP required to level from 120 to 121 is exactly the amount given by Loki in this current event... 
   Kadaan ☆☆☆
Join date : 20121030 Posts : 308
 Subject: Re: Calculate experience required for level Sat Mar 30, 2013 10:01 pm  
 I hope someone else is keeping track of 121140, I somehow misplaced a full level somewhere but the numbers still don't add up. Argh. 120121  14400   121122  14700  +300  122123  15550  +850  123124  15900  +350  124125  16300  +400  125126  16700  +400  126127  17100  +400 
That's what I have written in my spreadsheet for the totals, but I just noticed my card is level 128... The 122123 level doesn't make much sense either. 
   D75 ☆
Join date : 20121212 Posts : 25
 Subject: Re: Calculate experience required for level Wed Apr 03, 2013 8:26 am  
 Man you guys have too much time on your hands Thanks for the time and effort you have put into this I'm sure it will be very helpful 
   veritable ☆
Join date : 20130112 Posts : 135
 Subject: Re: Calculate experience required for level Fri Apr 05, 2013 8:32 pm  
 I have a fresh 6* Paris I have Level Broken to 140. I know how tedious it is to grind the higher levels so I would like to Enhance her all in one shot. I've gone through the forums and calculators but I still can't find what exactly I need to level her all the way to 140.
Also, I see that it's best to level 2*s to lvl 4 and 3*s to level 10. Is it still best to level 4*s to level 38 as Colaleon discovered?
Does the XP calculator make the correct calculations for 1  140 enhancement? 
   Sabin76 ☆☆☆
Join date : 20130106 Posts : 330
 Subject: Re: Calculate experience required for level Fri Apr 05, 2013 11:16 pm  
 Level 38 4*s aren't efficient in the sense that lvl 4 2*s and lvl 10 3*s are. The argument was that it was less than half the effort to raise a 4* to 38 compared to maxing it and gave enough XP to justify selling at just under half the going max price. The difference is that the 4*s are feeders you intend to SELL. The 2*s and 3*s at level 4 and 10 respectively can be raised to any level if you intend to sell them. As for the calculator, it looks like they are still gathering data on the 121140 level range, so that won't get worked in until they are done. If Kadaan's data is to be trusted (it looks a little fishy, I do admit) then it will take 19 maxed 4*s just to get to level 127. You are either going to have to wait for the data gathering to finish, or be a part of the data gathering team . 
   Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Calculate experience required for level Wed May 08, 2013 3:12 am  
  Colaleon wrote:
 Kyaaya's numbers check out for levels above 82 too! I logged my Rose's EXP gain from level 83 to level 84 and it adds up to exactly 6000 EXP points.
[...]
Conclusion: the thresholds [level 22], [level 42], [level 62] and [level 82] are correct. Sadly, I cannot confirm the final [level 101] threshold, because I don't have any 6* cards. NEWSFLASH!!!Thanks to ambrosia fruit, I have finally been able to test the [level 101] threshold, and it turns out the information we were given was seriously flawed! This was the information we were working with:  kyaaya wrote:
 First value is 50 at level 2 (100 xp for level 2 and 150 xp for level 3), and it remains constant for the next 20 levels till the next jump,
60 at level 22, then constant for another 20 levels and jumps again, 70 at level 42, then constant for another 20 levels and jumps again, 100 at level 62, then constant for another 20 levels and jumps again, 150 at level 82, , then constant for another 19 levels and jumps again, 325 at level 101, and remains constant till 120.
Whoever provided the info for the last threshold (I believe kyaaya never confirmed it himself, he just got it from someone else) must have just been GUESSING, because they make no sense. I can't believe nobody else has ever bothered to test this and I'm the first to discover this mistake. People are so lazy. :S This is the correct information:  Quote :
 150 at level 82, , then constant for another 20 levels and jumps again,
300 at level 102, and remains constant till ???.
So far, I can only confirm it remains constant until level 109 because I'm still in the process of leveling up the Camille I'm testing this with, but I suspect it will keep increasing by 300 until level 122. Sadly since I don't have any 6* units, I can only confirm this up to level 120. I'll get back to you once my Camille reaches 120 to let you know if it indeed took 14100 EXP to go from level 119 to 120. 
   rpfeltz ☆
Join date : 20130312 Posts : 6
 Subject: Re: Calculate experience required for level Wed May 08, 2013 4:14 am  
 I will change the formula according to the information Colaleon posted when I find the time. Hopefully, that will be later today. I will assume the rate to change to 400 per level at level 122 according to the vague information Kadaan posted. 
   Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Calculate experience required for level Wed May 08, 2013 4:19 am  
 Great, thanks! I was trying to work it out myself, but it's hurting my head. Oh and I just realized that Kadaan has already confirmed my theory!  kadaan wrote:
 120121 : 14400 EXP
121122 : 14700 EXP
This is in accordance with my previous post. 
   Kadaan ☆☆☆
Join date : 20121030 Posts : 308
 Subject: Re: Calculate experience required for level Wed May 08, 2013 10:57 am  
  Colaleon wrote:
 Great, thanks! I was trying to work it out myself, but it's hurting my head.
Oh and I just realized that Kadaan has already confirmed my theory!
 kadaan wrote:
 120121 : 14400 EXP
121122 : 14700 EXP
This is in accordance with my previous post.
It also does some weird stuff after 120, but somehow my numbers got messed up so I'm not 100% confident in them. I do know that at some point after level 122, the exp needed goes up by 400 per level instead of 300. 
   Sponsored content
 Subject: Re: Calculate experience required for level  
 
    Calculate experience required for level  

Similar topics  

 Permissions in this forum:  You cannot reply to topics in this forum
 
 
 
