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

View previous topic View next topic Go down 
AuthorMessage
Kadaan
☆☆☆


Join date : 2012-10-30
Posts : 308

PostSubject: 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 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!


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


Join date : 2013-01-07
Posts : 368

PostSubject: 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:
 
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

PostSubject: 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!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
☆☆☆


Join date : 2012-10-30
Posts : 308

PostSubject: 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 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

PostSubject: 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!
Back to top Go down
View user profile
fady1wu



Join date : 2013-03-30
Posts : 120

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

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



Join date : 2013-05-16
Posts : 2

PostSubject: 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.
Back to top Go down
View user profile
Kadaan
☆☆☆


Join date : 2012-10-30
Posts : 308

PostSubject: Re: Kadaan's Easy Enhancing Calculator   Thu 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]


Join date : 2012-11-26
Posts : 1716

PostSubject: 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.
Back to top Go down
View user profile
Cam
☆☆☆☆


Join date : 2012-09-26
Posts : 743

PostSubject: 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!
Back to top Go down
View user profile
supremeJD
☆☆☆


Join date : 2013-05-17
Posts : 352

PostSubject: 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!
Back to top Go down
View user profile
lmnseason
☆☆☆☆☆


Join date : 2012-11-22
Posts : 941

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

sweet
Back to top Go down
View user profile
deshimaru



Join date : 2013-01-26
Posts : 10

PostSubject: Re: Kadaan's Easy Enhancing Calculator   Thu 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

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

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


Join date : 2013-07-23
Posts : 276

PostSubject: 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
Back to top Go down
View user profile
VodkaMartini



Join date : 2013-08-13
Posts : 98

PostSubject: 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 cheers
Back to top Go down
View user profile
krissy06k
☆☆


Join date : 2013-05-01
Posts : 166

PostSubject: Re: Kadaan's Easy Enhancing Calculator   Fri 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




PostSubject: Re: Kadaan's Easy Enhancing Calculator   Today at 2:43 pm

Back to top Go down
 
Kadaan's Easy Enhancing Calculator
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» the calculator question
» Easy Way To Do Plugs?
» Critical hits – easy fix (?)
» A Simple Paper Dragon (easy to do)
» Self-publishing made easy with e-Book conversion

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