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! 

 Enhancement Calculator and formulas!  
 
Author  Message 

ladyaneara ☆
Join date : 20130108 Posts : 47
 Subject: Re: Enhancement Calculator and formulas! Thu Feb 28, 2013 4:04 pm  
 I have no clue how to use the spread sheet, nor do I understand all of what was said in the post... I'm sorry! When I go into the spreadsheet, it won't let me put my own values into the red cells... What am I doing wrong? 
   ladyaneara ☆
Join date : 20130108 Posts : 47
 Subject: Re: Enhancement Calculator and formulas! Thu Feb 28, 2013 5:03 pm  
 I downloaded it and figured it out! Thank you so much for having this up!!! 
   AlpineMirage ☆
Join date : 20130228 Posts : 28
 Subject: Re: Enhancement Calculator and formulas! Mon Mar 04, 2013 7:21 pm  
 The new calculator is AWESOME!!!!! Thank you so very much!!!! 
   luxionmk2 ☆
Join date : 20121026 Posts : 36
 Subject: Re: Enhancement Calculator and formulas! Wed Mar 06, 2013 4:29 pm  
 I like how users are creating copies of tabs and using it for themselves I'll clean up these extra tabs after the event. 
   Dmhlucky ☆☆
Join date : 20130307 Posts : 297
 Subject: Re: Enhancement Calculator and formulas! Thu Mar 07, 2013 6:55 am  
 I have a question about this then. I know its during the event, so the numbers may not be 100% accurate, but i am trying to find my own personal "ideal" enhance points.
I take a level 1* Baudouin to enhance a level 1** Mummy. The enhance gives 204 EXP and Brings the mummy to level 3. If the EXP to level is 100 for 1>2, and 150+100(250) to go from 1>3 then how is 204 exp bringing the unit to level 3?
Are the "bonusus" hidden, where you don't actually see the exp bonus listed in the 204 exp is says? ( i tried this exact enhance 2 times, both level 1* Bauduoins were 0 exp)
I just also did a bit more experimenting. I Fed a lv 1** Mummy an Ian(lv 1*) he gains 197 exp and goes from 1>2. I then Fed that same Mummy lv 2** a William lv 1* and it gained 119 exp and went from 2>4. This would suggest that levels 13 are 100 exp each.
I am aware that the whole system is very complex, and i am probably thinking too much about it.
I am just confused why 200 EXP brings a unit to level 3, and also why when i used Ian lv 1* to enhance it gave 197 exp, and then i used lv 1* William on a lv 2** Mummy, it only have 119 exp. Does efficiency actually go down if you feed into a higher level card?
I don't have any more level 1*, or lv 1** to play with right now, so i can't come up with additional data, this just threw me.
This can by all means wait til after the event, it was just something i noticed.
Also, i may just be reading too much into, it, so if thats the case, someone just tell me so.
Thanks,
Donny 
   Dmhlucky ☆☆
Join date : 20130307 Posts : 297
 Subject: Re: Enhancement Calculator and formulas! Thu Mar 07, 2013 8:39 am  
 Lets throw a few more monkey wrenches into the Mix. I took 3 lv 1* Williams to enhance a lv 1** Damien. The enhance gave 412 Exp and got Damien to level 5.
If you go by the theory that lv 12 is 100 exp, 23 is 250, 34 is 450, 45 is 700, then this makes no sence. (those numbers are total exp to level the individual levels are 100, 150, 200, 250) Also, if a lv 1* Card is supposed to grant 150 EXP, then how do 3 of them grant on average less than 150 each? (412/2 =137.333)
Are the calculations only for using 1 card to enhance a level 1 card?
Because even if you cut out the event Enhance boost, i have the skill enhance boost at 10%, so these 3 cards should have given 150(+15 for 10%) X3 =495 exp, which is not the exp listed. The base which should also be 450 (150X3) is not listed either, 412 was the exp it said the card gained.
Again, i may just be delving into this too much, or the bonuses are not listed, or the cards give less exp as the target card levels up (which may be the case based on what i wrote in my last post)
I don't mean to throw odd data at something youve worked so hard on, i am just cofused by the data i am looking at when i enhance cards. 
   Dmhlucky ☆☆
Join date : 20130307 Posts : 297
 Subject: Re: Enhancement Calculator and formulas! Thu Mar 07, 2013 10:17 am  
 And after some more testing i think i realized why things are working, and what the numbers actually mean.
The "EXP" earned with an Enhancement, the actual numbe you see once yuo have enhanced a card is the % of EXP they have recieved. Each 100 is 1 level, ie when i used 3 Cards which should have given 450 EXP Minimum, and i got 412, what that really meant was 4.12 levels gained, which is why the card went from 15.
This would also be why if you use a card to enhance a higher level card, you get a smaller number of "EXP" earned. That number is not the actual EXP, it is merely the % of exp per level gained. So if you took a card from 170, it would read 7000 exp, where the actual EXP earned would be more like 124,200.
Sorry for any confusion i may have thrown your way.

   phobia429669 ☆
Join date : 20121116 Posts : 8
 Subject: Re: Enhancement Calculator and formulas! Fri Mar 08, 2013 9:57 am  
 Can anyone provide a simple, bottomline recommendation for someone who wants to be more efficient in how they enhance their cards, but maybe not squeeze that extra 1% or 2% out of the process? For example, I have been taking my ** and feeding 8 * into them, to get them to level 8, then using those Lvl 8 ** to feed into all my other cards. What is a good level to get my ** feeders to that strikes a good balance between efficient use of XP, and not wasting a lot of unit space? Is it getting my ** to lvl 4? 8? 10? 20? before using them on my big guys? Thanks. 
   Possibly ☆☆☆
Join date : 20130219 Posts : 300
 Subject: Re: Enhancement Calculator and formulas! Fri Mar 08, 2013 10:10 am  
 Man, I've wasted sooo much exp. But now I know, and knowing is half the battle.
GI JOE! 
   Soggytoaster ☆☆☆
Join date : 20130114 Posts : 314
 Subject: Re: Enhancement Calculator and formulas! Fri Mar 08, 2013 10:00 pm  
  phobia429669 wrote:
 Can anyone provide a simple, bottomline recommendation for someone who wants to be more efficient in how they enhance their cards, but maybe not squeeze that extra 1% or 2% out of the process? For example, I have been taking my ** and feeding 8 * into them, to get them to level 8, then using those Lvl 8 ** to feed into all my other cards. What is a good level to get my ** feeders to that strikes a good balance between efficient use of XP, and not wasting a lot of unit space? Is it getting my ** to lvl 4? 8? 10? 20? before using them on my big guys? Thanks.
It depends on how much luna you are willing to spend in enhancement. Having higher level 2* cards means less are used to enhance over all which results in lower luna costs. Leveling a 2* card above level 4 will result in a loss of xp in regards to total cost to make the feeder.
Example:
Bonuses  10/10 Valk No bonus enhancement xp
XP when used in enhancement: lv1 1* = 165xp lv1 2* = 495xp lv4 2* = 990xp lv6 2* = 1320xp lv8 2* = 1650xp lv10 2* = 1980xp
It takes 3 x lv1 1* to create a lv4 2* feeder. We also factor in the 2* cards worth at lv1. 3 x lv1 1* = 495xp 1 x lv1 2* = 495xp Total = 990xp
Now 1 x lv4 2* = 990xp when it is used in enhancement. This means that you spent 990xp to create a 990xp card. There is no loss in xp with this setup.
Basically a lv4 2* gives the same amount of xp when used in enhancement as the parts needed to create it if they were used individually.
Now anything above lv4 with a 2* actually causes a diminished return in regards to the above.
For example:
It takes 5 x lv1 1* to create a lv5 2* feeder. We also factor in the 2* cards worth at lv1. 5 x lv1 1* = 825xp 1 x lv1 2* = 495xp Total = 1320xp
Now 1 x lv5 2* = 1153xp when it is used in enhancement. This means that you spent 1320xp to create a 1153xp card. There is a loss of 167xp with this setup. You would gain more xp if you used the individual cards compared to the one lv5 2* that was created.
Level 10 2* feeders are quite inefficient in regards to xp. They are used so much by people (including myself) because it saves a lot on luna costs when enhancing and it is easier to bank and store level 10 cards compared to huge amounts of level 1 cards.
In the end it is up to you as to what you do. 
   Nazantia ☆☆
Join date : 20130119 Posts : 228
 Subject: Re: Enhancement Calculator and formulas! Sat Mar 09, 2013 12:43 am  
 Anyone know what a Lv100 5* feeds for? 
   Soggytoaster ☆☆☆
Join date : 20130114 Posts : 314
 Subject: Re: Enhancement Calculator and formulas! Sat Mar 09, 2013 1:47 am  
 10/10 Valk No enhancement bonus lv100 5* = 84,150xp when fed to another card. 10/10 Valk No enhancement bonus lv100 5* = 126,225xp when fed to another card. Max cards are very xp inefficient when used in enhancement compared to how much xp it takes to level them to max. Try using the CARD ENHANCEMENT SPREADSHEET if you want to find out exact numbers for any enhancement 
   Nazantia ☆☆
Join date : 20130119 Posts : 228
    Soggytoaster ☆☆☆
Join date : 20130114 Posts : 314
 Subject: Re: Enhancement Calculator and formulas! Sat Mar 09, 2013 2:45 am  
 Haha definitely Fiona is a great feeder. 
   Hidingfox222 ☆
Join date : 20130307 Posts : 2
 Subject: Re: Enhancement Calculator and formulas! Sat Mar 16, 2013 8:20 pm  
 Now 364 gave 630 exp, more that 246. Will that be update later? 
   steakjuice ☆
Join date : 20121021 Posts : 100
 Subject: Re: Enhancement Calculator and formulas! Thu Mar 21, 2013 10:26 am  
 Thanks for the analysis! Man, all this time I've been wasting cards leveling my bears to 6... 
   Sabin76 ☆☆☆
Join date : 20130106 Posts : 330
 Subject: Re: Enhancement Calculator and formulas! Thu Apr 11, 2013 12:40 am  
 I've added some stuff to the end of the formula in cell B12 (which is now B13...I'll explain in a minute) to account for partial levels. First, I added a row between "Current Level" and "Target Level" and called it "Current Percentage." This is where you enter the number on your card from 099 in the XP category (representing the percentage of the current level completed). This moves both the target level cell and the XP needed cell down one, so that explains why the cells I'm talking about are different than those in the current spreadsheet. I then added a piece to the end of the formula for "XP Needed" to account for the XP already gained within the level. It isn't pretty, but then, neither is the original formula .  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),(((B1022+1)*60)+1100)*(B11/100),IF(AND(B10>=43,B10<=62),(((B1042+1)*70)+2300)*(B11/100),IF(AND(B10>=63,B10<=82),(((B1062+1)*100)+3700)*(B11/100),IF(AND(B10>=83,B10<=102),(((B1082+1)*150)+5700)*(B11/100),(((B10102+1)*325)+8875)*(B11/100)))))))
Just copy and paste this into what is now cell B13. I've tested it at a few of the level ranges and with various XP percentages and it seems to check out. Let me know if I missed anything. Alternatively, you can just paste this onto the end of the formula as it is (I didn't change anything).  Spoiler:

(IF(AND(B10>=1,B10<=22),(B10+1)*50*(B11/100),IF(AND(B10>=23,B10<=42),(((B1022+1)*60)+1100)*(B11/100),IF(AND(B10>=43,B10<=62),(((B1042+1)*70)+2300)*(B11/100),IF(AND(B10>=63,B10<=82),(((B1062+1)*100)+3700)*(B11/100),IF(AND(B10>=83,B10<=102),(((B1082+1)*150)+5700)*(B11/100),(((B10102+1)*325)+8875)*(B11/100)))))))

   SomelPT ☆
Join date : 20130428 Posts : 28
 Subject: Re: Enhancement Calculator and formulas! Mon Apr 29, 2013 8:57 pm  
 Hello, first of all many thx to luxionmk2 and everyone else who contributed to make this tool. Very handy!
I have some doubts, does anyone know what are the penalties, exp wise of, say,
enhance a unit from 150 then 5080, versus from 180 directly.
Kinda helps when making time/profit calculations xD

   meximan1390 ☆☆☆☆
Join date : 20130313 Posts : 714
 Subject: Re: Enhancement Calculator and formulas! Sat May 04, 2013 1:51 am  
 So does anyone know how much experience it takes to level a card from 120 to 140? 
   UnstbleAce ☆
Join date : 20130312 Posts : 15
 Subject: Re: Enhancement Calculator and formulas! Tue May 07, 2013 12:17 pm  
 In case the author hasn't noticed, there seems to be an error in line 29 I believe (see the comments on the spreadsheet  other people have been pointing it out there. I decided to bring attention on the topic in case that helps).
Not sure when it happened, because I copied the spreadsheet to my own Google Drive about a week ago (Apr 28) and the error does not seem to be on my version.
Cells D4/E4 point out the error are are copied here: "The formula in row 29 is WRONG  someone fix // The B30s in that should be B29"
EDIT: I want to point out, the error only seems to be in Calculator 1. So just use Calc 2 until it's fixed. 
   SyltGer ☆
Join date : 20130514 Posts : 42
 Subject: Re: Enhancement Calculator and formulas! Tue May 14, 2013 3:54 am  
 Thx to you guys! Now i can safe Luna 
   Cavemaneca ☆☆
Join date : 20130426 Posts : 256
 Subject: Re: Enhancement Calculator and formulas! Fri May 24, 2013 12:35 pm  
 I was wondering if anyone wants a java/javascript app for the calculator? I could make a good one pretty quick. 
   Keleos89 ☆☆
Join date : 20130531 Posts : 193
 Subject: Re: Enhancement Calculator and formulas! Thu Jun 06, 2013 4:08 pm  
 Noob recommendation but you may consider adding a cell for # of 27 runs for newer players as well as for those with time to grind constantly vs. the 5 minute cooldown 
   greatsopp ☆☆☆☆
Join date : 20130128 Posts : 523
 Subject: Re: Enhancement Calculator and formulas! Fri Jun 07, 2013 12:33 pm  
 Request: What is the formula for using 5*s as feeders??
5 prices has really crashed and my guess that within a month the cheapest will more regulary be used as feeders...
If a max4 is 4te, what should lv100 5* be based on the xp it gives...? 
   Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Enhancement Calculator and formulas! Sat Jun 08, 2013 5:14 am  
  greatsopp wrote:
 Request: What is the formula for using 5*s as feeders??
5 prices has really crashed and my guess that within a month the cheapest will more regulary be used as feeders...
If a max4 is 4te, what should lv100 5* be based on the xp it gives...? Interesting question.
I suspect a level 1 5* grants 1800 EXP and it gains 600 EXP for every level. However, this is untested. I don't have the luxury of using 5* units as enhancement food.
Without any bonuses, a level 80 4* grants 36,900 EXP. Without any bonuses, a level 100 5* grants 61,200 EXP. (only if my suspicions are right!)
So a max 5* grants 1.66 times the EXP that a max 4* grants. That would mean the price for a max 5* comes down to 67 TE, if you take 4 TE to be the price for a max 4*. It would be 89 TE if you take 5 TE to be the price for a max 4*. 
   Sponsored content
 Subject: Re: Enhancement Calculator and formulas! Today at 11:14 am  
 
   
Similar topics  

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