HomeFAQCalendarSearchMemberlistUsergroupsRegisterLog in
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!

Share
 

 Kadaan's Easy Enhancing Calculator

Go down 
AuthorMessage
Kadaan
☆☆☆
Kadaan

Join date : 2012-10-30
Posts : 308

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeTue 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 85-100?".

Well the wait is over!

Kadaan's Easy Enhancing Calculator

Use it as-is, 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!

Kadaan's Easy Enhancing Calculator G8IV8k5

_________________
Visit the FANTASICA WIKI!
kik:kadaan
Back to top Go down
View user profile http://www.fantasicawiki.com/
Colaleon
☆☆☆
Colaleon

Join date : 2013-01-07
Posts : 368

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeWed 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:
 
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.
Back to top Go down
View user profile
tales



Join date : 2013-02-11
Posts : 31

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeWed 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!E1-22))*((2.5*Calculator!E1)-52.5)))+(ABS((Calculator!E1-42))*((2.5*Calculator!E1)-102.5)))+(ABS((Calculator!E1-62))*((7.5*Calculator!E1)-457.5)))+(ABS((Calculator!E1-82))*((12.5*Calculator!E1)-1012.5)))+(ABS((Calculator!E1-101))*((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!E1-22)*(2.5*Calculator!E1-52.5)+ABS(Calculator!E1-42)*(2.5*Calculator!E1-102.5)+ABS(Calculator!E1-62)*(7.5*Calculator!E1-457.5)+ABS(Calculator!E1-82)*(12.5*Calculator!E1-1012.5)+ABS(Calculator!E1-101)*(43.75*Calculator!E1-4375)

Same goes for cell B8.
Back to top Go down
View user profile
Kadaan
☆☆☆
Kadaan

Join date : 2012-10-30
Posts : 308

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeWed 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 Sad. 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
Back to top Go down
View user profile http://www.fantasicawiki.com/
tales



Join date : 2013-02-11
Posts : 31

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeWed 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!
Back to top Go down
View user profile
fady1wu

fady1wu

Join date : 2013-03-30
Posts : 120

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeTue May 14, 2013 9:10 am

Well made, well made indeed!
Back to top Go down
View user profile
susounet

susounet

Join date : 2013-05-16
Posts : 2

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeThu May 16, 2013 8:47 am

Hello, I'm new here and I wanted to know where I could find your calculator ?

Thanks.
Back to top Go down
View user profile
Kadaan
☆☆☆
Kadaan

Join date : 2012-10-30
Posts : 308

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeThu May 16, 2013 5:59 pm

Just click the big "Kadaan's Easy Enhancing Calculator" link Very Happy

_________________
Visit the FANTASICA WIKI!
kik:kadaan
Back to top Go down
View user profile http://www.fantasicawiki.com/
themadmanazn
Gingerbreadian [SPECIAL]
themadmanazn

Join date : 2012-11-26
Posts : 1716

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeThu 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.
Back to top Go down
View user profile
Cam
☆☆☆☆
Cam

Join date : 2012-09-26
Posts : 743

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeThu May 16, 2013 6:14 pm

How am I just finding this over a week later?

Kadaan you are once again a wizard. Thanks!
Back to top Go down
View user profile
supremeJD
☆☆☆
supremeJD

Join date : 2013-05-17
Posts : 352

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeThu May 23, 2013 10:09 am

I just wanted to say that this is super awesome. Thanks Kadaan!
Back to top Go down
View user profile
lmnseason
☆☆☆☆☆
lmnseason

Join date : 2012-11-22
Posts : 941

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeFri May 24, 2013 2:02 am

sweet
Back to top Go down
View user profile
deshimaru



Join date : 2013-01-26
Posts : 10

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeThu Jul 04, 2013 1:19 am

thank you for making this. Very easy to use indeed! cheers 
Back to top Go down
View user profile
Chzzt



Join date : 2013-08-07
Posts : 1

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeWed Aug 07, 2013 4:48 am

THX,This is helpful newbie as me.
Back to top Go down
View user profile
bluerexx
☆☆
bluerexx

Join date : 2013-07-23
Posts : 276

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeWed 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
Back to top Go down
View user profile
VodkaMartini



Join date : 2013-08-13
Posts : 98

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeThu 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 cheers
Back to top Go down
View user profile
krissy06k
☆☆
krissy06k

Join date : 2013-05-01
Posts : 166

Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitimeFri Aug 30, 2013 11:26 am

This is amazing. Made my day! Smile
Back to top Go down
View user profile http://www.fantasicaunofficial.com/t6717-s-mlbmorticia-max-5s-mf
Sponsored content




Kadaan's Easy Enhancing Calculator Empty
PostSubject: Re: Kadaan's Easy Enhancing Calculator   Kadaan's Easy Enhancing Calculator I_icon_minitime

Back to top Go down
 
Kadaan's Easy Enhancing Calculator
Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
 :: Fantasica :: Fantasica Encyclopedia-
Jump to: