 Kadaan's Easy Enhancing Calculator  

Author  Message 

Kadaan ☆☆☆
Join date : 20121030 Posts : 308
 Subject: Kadaan's Easy Enhancing Calculator Tue May 07, 2013 8:07 pm  
 Are the other enhancing calculators too complicated for you? Do you often wish someone else would just answer your question of "How many level 10 3* would it take to level my 5* from 85100?". Well the wait is over! Kadaan's Easy Enhancing CalculatorUse it asis, or make a copy of it from "File>Make a copy..." so other people aren't editing cells out from under your nose! All you do is edit the grey cells and the answer you're looking for appears as if by magic right below! _________________ Visit the FANTASICA WIKI!  kik:kadaan 


 
Colaleon ☆☆☆
Join date : 20130107 Posts : 368
 Subject: Re: Kadaan's Easy Enhancing Calculator Wed May 08, 2013 2:58 am  
 That's quite impressive Kadaan! It's incredibly easy to use and provides a very helpful service. I also like the clear calculations I see in the "Scratch" tab. I've been using a spreadsheet I designed myself for some time now, perhaps this would be a good time to share what that looks like:  Spoiler:

Fields with green backgrounds are the only ones I change. As you can see, it's much more confusing than the clear and simple sheet you created. However in return, I can create slightly more complicated queries. I can make calculations with different types of cards (in this example, a combination of level 6 2* units and level 7 3* units) and I can input how many of those cards have the same type as the card I'm enhancing. It also takes into account how much experience points the card has already gained on its way to its next levelup.
There seems to be a slight glitch in my formulas though, because I end up needing to sacrifice just one or two more cards in the end when I sacrifice a large batch of cards, even though my spreadsheet tells me it should be enough. Maybe I'm rounding some number the wrong way? I'll run some comparisons with your spreadsheet to see if I can find any flaws. By the way, are you using the formula from the "Calculate experience required for level" topic to calculate the "Exp Start" and "Exp End"? If so, you should know that I just (15 minutes ago) discovered that the formula is flawed for levels above 101. I'm just about to write a post concerning this in the topic, so keep an eye on it for changes to the formula. 

 
tales ☆
Join date : 20130211 Posts : 31
 Subject: Re: Kadaan's Easy Enhancing Calculator Wed May 08, 2013 9:53 am  
 Thanks for the calculator Kaldaan.
However, when I try to export the excel to a file, the spreadsheet goes haywire.
In tab stratch, cells B7  B9 are all with 'name.
When I check the formula in cell B7 of the excel spreadsheet, it goes:
=(((((((93.75*POW(Calculator!E1,2)) ( 12043.75*Calculator!E1)) + 558675)+(ABS((Calculator!E122))*((2.5*Calculator!E1)52.5)))+(ABS((Calculator!E142))*((2.5*Calculator!E1)102.5)))+(ABS((Calculator!E162))*((7.5*Calculator!E1)457.5)))+(ABS((Calculator!E182))*((12.5*Calculator!E1)1012.5)))+(ABS((Calculator!E1101))*((43.75*Calculator!E1)4375))
This is different from what i see in the online copy of:
=93.75*POW(Calculator!E1,2)  12043.75*Calculator!E1 + 558675+ABS(Calculator!E122)*(2.5*Calculator!E152.5)+ABS(Calculator!E142)*(2.5*Calculator!E1102.5)+ABS(Calculator!E162)*(7.5*Calculator!E1457.5)+ABS(Calculator!E182)*(12.5*Calculator!E11012.5)+ABS(Calculator!E1101)*(43.75*Calculator!E14375)
Same goes for cell B8. 

 
Kadaan ☆☆☆
Join date : 20121030 Posts : 308
 Subject: Re: Kadaan's Easy Enhancing Calculator Wed May 08, 2013 10:52 am  
  tales wrote:
 Thanks for the calculator Kaldaan.
However, when I try to export the excel to a file, the spreadsheet goes haywire..
It looks like the syntax is the same, it just added a ton of extra parenthesis. You can try just copying the formula from the google spreadsheet and pasting it into excel to see if that works. I don't have a copy of excel so I can't test it myself . I _think_ if you install Google Drive you can save offline copies of Google Spreadsheets; that might be an alternative as well if you don't want to use the online version._________________ Visit the FANTASICA WIKI!  kik:kadaan 


 
tales ☆
Join date : 20130211 Posts : 31
 Subject: Re: Kadaan's Easy Enhancing Calculator Wed May 08, 2013 11:40 am  
 It doesn't work when I copied and pasted the google formula to the excel spreadsheet.
Anyhow, no worries, I will just rely on the online version.
Thank you so much once again for making this calculator which helps answer so many questions! 

 
fady1wu ☆
Join date : 20130330 Posts : 120
 Subject: Re: Kadaan's Easy Enhancing Calculator Tue May 14, 2013 9:10 am  
 Well made, well made indeed! 

 
susounet ☆
Join date : 20130516 Posts : 2
 Subject: Re: Kadaan's Easy Enhancing Calculator Thu May 16, 2013 8:47 am  
 Hello, I'm new here and I wanted to know where I could find your calculator ?
Thanks. 

 
Kadaan ☆☆☆
Join date : 20121030 Posts : 308
 Subject: Re: Kadaan's Easy Enhancing Calculator Thu May 16, 2013 5:59 pm  
 Just click the big "Kadaan's Easy Enhancing Calculator" link _________________ Visit the FANTASICA WIKI!  kik:kadaan 


 
themadmanazn Gingerbreadian [SPECIAL]
Join date : 20121126 Posts : 1716
 Subject: Re: Kadaan's Easy Enhancing Calculator Thu May 16, 2013 6:02 pm  
 Kadaan... the simplicity... amazing... *high five* _________________ My Albuming and Trading Corner Quote :
 [19:59:06] Varis : madman is correct
 Quote :
 [15:09:58] hereticloki : madman is fair
 Quote :
 [12:39:12] @ Crowex : Azn is right.


 
Cam ☆☆☆☆
Join date : 20120926 Posts : 743
 Subject: Re: Kadaan's Easy Enhancing Calculator Thu May 16, 2013 6:14 pm  
 How am I just finding this over a week later?
Kadaan you are once again a wizard. Thanks! 

 
supremeJD ☆☆☆
Join date : 20130517 Posts : 352
 Subject: Re: Kadaan's Easy Enhancing Calculator Thu May 23, 2013 10:09 am  
 I just wanted to say that this is super awesome. Thanks Kadaan! 

 
lmnseason ☆☆☆☆☆
Join date : 20121122 Posts : 941
 Subject: Re: Kadaan's Easy Enhancing Calculator Fri May 24, 2013 2:02 am  
 

 
deshimaru ☆
Join date : 20130126 Posts : 10
 Subject: Re: Kadaan's Easy Enhancing Calculator Thu Jul 04, 2013 1:19 am  
 thank you for making this. Very easy to use indeed! 

 
Chzzt ☆
Join date : 20130807 Posts : 1
 Subject: Re: Kadaan's Easy Enhancing Calculator Wed Aug 07, 2013 4:48 am  
 THX,This is helpful newbie as me. 

 
bluerexx ☆☆
Join date : 20130723 Posts : 276
 Subject: Re: Kadaan's Easy Enhancing Calculator Wed Aug 07, 2013 10:11 am  
 I should look under this section more often.
Thanks for the simple spreadsheet, no more guess work for me 

 
VodkaMartini ☆
Join date : 20130813 Posts : 98
 Subject: Re: Kadaan's Easy Enhancing Calculator Thu Aug 22, 2013 4:06 am  
 if you have problem to use the offline (downloaded version) this trick might help you (I'm using excel 2010) 1. click on the big link  Kadaan's Easy Enhancing Calculator at 1st post 2. download to your pc we just need to do these things : Calculator Sheet Cell B6  B9 : change the CONCAT formula to CONCATENATE  calculator sheet:

Scratch Sheet Cell B7  B8 : change the POW formula to POWER  scratch sheet:

and you're done. thanks Kadaan, for your superb calculator 

 
krissy06k ☆☆
Join date : 20130501 Posts : 166
 Subject: Re: Kadaan's Easy Enhancing Calculator Fri Aug 30, 2013 11:26 am  
 This is amazing. Made my day! 

 
Sponsored content
 Subject: Re: Kadaan's Easy Enhancing Calculator  
 

 
