Latest version (will probably be my last)
= = =
(v5)
Coming ... in a while
(mathing guild stuff... might take a while longer xD)
- includes better treasure upgrade maths
- option to vary party upgrades (scale upgrades that depend on parties, 1.4, 2, 3, 4, etc)
- pet arena and pet upgrades
- more math to include higher upgrade levels (still trying to collect data on lvl 100+ upgrades)
- dps calculations
- abilities calculations
- ascension points stuff
- zone and challenge suggestions
- effect of partying (and if they also you, calculator, allows for accurate analysis)
- option to customize and vary emphasis on xp, gold, card and treasure loot
- probably overkill and after this i will just stop updating it xD
(ps a lot of stuff most of you can avoid if you want.. i will colour code it.
I'm just tired of always doing things in my head so I'll add options for me
and if you want to try use it.. go for it... if not, I will leave a tab for default and you can copy the old formulas back in.)
= = =
Older stuff
slightly modified version of my upgrade calculator for estimates of which upgrade to do next
it assumes you are in party.. (and adjust maths accordingly.. to some extent)
it does not include click/clix upgrades... since it makes it messier..
(nor does it include my other calculators like abilities, asc skills, wood, mining, expeditions, etc )
(I think) there are 4 upgrades which affect party so after lvl 25, I suggest if you have a permanent party partner,
to specialise in two of the 4 upgrades
- time extend
- hp reduction
- treasure hunter
- easy loot
if you wish to delete or ignore an upgrade... either increase their price, delete their efficiency boxes or hmm.
crit % = crit chance
crit dmg = crit multiplier
and yes I did not include challenge point or level since I found a way to math without it
(and that way I remove huge source of human error), yay me
BUT make sure you add in the idle+10% dmg
= = =
second file (v2) is updated to account for the new event bonuses (EP)
note, it still calculates dmg correctly, but new challenge bonus gives much more dmg (CP)
hence upgrades will be less effective
= = =
third file (v3) is updated to allow for gold prices to be calculated from current upgrade level ...
(just gold not AP or the upgrade values)
= = =
fourth file (v4)
moved notes to the top
fixed damage calculation (event and asc. buffs are added not multiplied)
fixed triple loot calculation (way under leveled)
made everything automatic, far less input (dmg, buffs and upgrade levels)
but I took a shortcut, so file size is huge in comparison (12 kB -> 62kB)
(v4b)
exactly the same as 4 but only recently noticed that v4 is no longer compatible with google spreadsheets
so changed the formula/functions so now it should work
to upload you need gmail then..
https://docs.google.com/spreadsheets/
go into a spread sheet
file -> import -> upload -> create new spreadsheet
= = =
(v5)
Coming ... in a while
(mathing guild stuff... might take a while longer xD)
- includes better treasure upgrade maths
- option to vary party upgrades (scale upgrades that depend on parties, 1.4, 2, 3, 4, etc)
- pet arena and pet upgrades
- more math to include higher upgrade levels (still trying to collect data on lvl 100+ upgrades)
- dps calculations
- abilities calculations
- ascension points stuff
- zone and challenge suggestions
- effect of partying (and if they also you, calculator, allows for accurate analysis)
- option to customize and vary emphasis on xp, gold, card and treasure loot
- probably overkill and after this i will just stop updating it xD
(ps a lot of stuff most of you can avoid if you want.. i will colour code it.
I'm just tired of always doing things in my head so I'll add options for me
and if you want to try use it.. go for it... if not, I will leave a tab for default and you can copy the old formulas back in.)
= = =
Older stuff
slightly modified version of my upgrade calculator for estimates of which upgrade to do next
it assumes you are in party.. (and adjust maths accordingly.. to some extent)
it does not include click/clix upgrades... since it makes it messier..
(nor does it include my other calculators like abilities, asc skills, wood, mining, expeditions, etc )
(I think) there are 4 upgrades which affect party so after lvl 25, I suggest if you have a permanent party partner,
to specialise in two of the 4 upgrades
- time extend
- hp reduction
- treasure hunter
- easy loot
if you wish to delete or ignore an upgrade... either increase their price, delete their efficiency boxes or hmm.
crit % = crit chance
crit dmg = crit multiplier
and yes I did not include challenge point or level since I found a way to math without it
(and that way I remove huge source of human error), yay me
BUT make sure you add in the idle+10% dmg
= = =
second file (v2) is updated to account for the new event bonuses (EP)
note, it still calculates dmg correctly, but new challenge bonus gives much more dmg (CP)
hence upgrades will be less effective
= = =
third file (v3) is updated to allow for gold prices to be calculated from current upgrade level ...
(just gold not AP or the upgrade values)
= = =
fourth file (v4)
moved notes to the top
fixed damage calculation (event and asc. buffs are added not multiplied)
fixed triple loot calculation (way under leveled)
made everything automatic, far less input (dmg, buffs and upgrade levels)
but I took a shortcut, so file size is huge in comparison (12 kB -> 62kB)
(v4b)
exactly the same as 4 but only recently noticed that v4 is no longer compatible with google spreadsheets
so changed the formula/functions so now it should work
to upload you need gmail then..
https://docs.google.com/spreadsheets/
go into a spread sheet
file -> import -> upload -> create new spreadsheet