IOU Complete MultiCalc v7.2.3
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
2
If this is your first time please read this page! Only takes 2 minutes.
3
4
Fire Clan's IOU Complete MultiCalc
5
6
General Sheet Instructions:
7
Go to the File menu (above) and select "Make a copy..." to edit this document.
You need a Google account in order to do this!
The master copy is not for public use! Make your own copy!
8
Edit cells of this color.Do not edit cells of this color.Hover over cells with triangles
9
NOTE: If you are manually entering your data, you will see equations in all of the yellow, typeable fields. Ignore them and type over them.
10
If you don't know what to do, there are usually instructions and explanations (mostly hovertext) on each page. Please read them.
11
You will have to delete the contents of drop menus the first time you change them each new sheet. This is so they can import and you don't have to repeatedly reselect them.
12
If this is your first time filling the MultiCalc, follow the instructions on the "Import" tab for /export, and most of your data will be filled in a matter of seconds.
13
14
Feel free to hide this page. Report any issues to GameInSky/porkbob/jiecut please! Best way to contact us is generally Discord.Note that any and all feature requests
to the MultiCalc will be coming...
15
16
The newest MultiCalc version can be found at:
http://bit.ly/2aui3Kd
The original (Zilla) template for this sheet can be found at:
http://bit.ly/1ZjPeTO
17
The forum thread for the MultiCalc is here:
http://bit.ly/2kgtngV
If you need a card counter, one is available here:
http://bit.ly/1QV3n63
18
Credits:
19
A big thank you to Brouwer in Discord for math and spreadsheet support on the earliest versions of the sheet, and providing the inspiration to make this tool.
20
All original code was hand-written by Padd1ngton_Bear (Zilla).
21
From version 3.Alpha onwards, the sheet was worked on by GameInSky.
22
Thanks to porkbob for being a wonderful tester for the alpha stages of 3.0. Also special thanks to jiecut for being so supportive in fixing some of these issues!
23
After version 3.5.1, most work on the sheet was done by jiecut and porkbob, fellow members with GameInSky of NICE (now merged into Fire Clan).
24
From around version 4.3, the sheet has been maintained mostly by porkbob, and starting with version 5.0b momo1925 has helped a bit.
From around version 4.3, the sheet has been maintained mostly by porkbob, with occasional help from jiecut, GameInSky, & momo1925.
25
Since version 6.8.0, Edu has also been assisting, with scripting for use of /export. And thanks to celestior for also occasionally helping with this!
26
Thanks to Zornitsa for the art used here!
27
Huge thanks to IndigoFerret for putting a ton of time and effort into the pet map optimizer!
28
Many thanks to Edu for scripting the Auto Import feature, and Ultraschall for assisting him in testing and matching up data!
29
Thanks to Level for coding a filter for /export and hosting it on his website! (No longer used, but still very appreciated!)
30
Thanks to Zeruel, momo1925, celestior, Koin, & ‖ for either coding small features or inspring them with examples.
31
Math support provided by Nyima, lucasftw, Aghannor, HeroSlayer27, Julus, Dankaati, Firen, Tahllian, ‖, and jays!
32
Also shoutouts to quixorbl & Koin for many bug reports over the many months of the MultiCalc's lifespan. =)
33
Thank you to testers, and everyone who helped make this tool possible (and anyone we forgot). =)
34
35
Changelog
You can ignore this if it's your first time.
36
(unhide here to see the rest of the changelog)
281
282
v7.2.0 - Pet Arena expansion, Added new Pet Arena Calc for optimizing Core lvls, Optimized performance of the Pet Arena Calc (possibly greatly but that could be offset by the addition of the extra calc), Relocated Pet Arena Trophy/Leg and related Optimizer to where the other Pet Arena Calcs are, Fixed that guild passive challenge wasn't being added to pets, Added custom number formatting for pet map dps/pp,
You shouldn't have the unsafe message anymore from the script (Thanks, Quia!), Changed default expedition points value coefficient from 0 to 0.01, Small fix for Ship B and Ship C drill upgrade calculation, Fixed pet tier up calculation regarding pet training weekly bonus, Fixed a bug with CS/SD Optimizer Calcs regarding Asc AD and Leg AD, Removed the ability to toggle next tier and single level for non-arena pet nodes (was really useless),
Separated pre-calculated treasure dmg AND comparedps from the inferno calc—to realize the goal of having the inferno calc not run each time you update dps throughout the sheet, Auto Import now uses the Lifetime Diamonds data for the Party tab
v 7.2.0 Note: The hover party text in-game that shows partymate dps now erroneously includes pet idle dmg while still excluding auto idle dmg. This also means that the comparedps command in the game will also be incorrect if you have idle bonus active. Currently I don't feel like making extra calculations to fix the game's mistakes so if you care about that 1-10% mistake then partymates will just have to use the MultiCalc
v 7.2.0 Important Note: I haven't been able to test the new pet arena calc, as the test servers have been down since I got it functional. So I have no way of knowing if there are any typos or bugs. User be aware! =P
283
v7.2.0a - Fixed that trophy costs for Pet Arena Trophy were looking at the wrong cell, Fixed that Riches claim didn't work because of an extra parentheses
284
v7.2.1 - Lowered Pet Arena mob HP & base amount of heals as per today's patch, Scaled up the values of efficiency for ap pet arena calc (so they won't become tiny so easily)
285
v7.2.2 - Fixed a couple bugs in the Pet Arena calc, Reflection in Pet Arena uses a much more complicated formula which more realistically represents its diminishing returns (only applicable with ratios between 0.35-0.875), Fixed a bug in Riches claim that showed too low resources, Fixed a bug in the card pack optimizer "Required Total" which made multiple packs at once not work correctly for 2nd & 3rd choice,
Optimized performance of the Pet Arena calc even more, Extended fed cost of pet tiers to t50, "Last Updated" date is now updated each time the sheet is edited instead of only when Auto Import is used
v7.2.2 Note: There is currently a bug in the game for Pet Arena where you get valor one stage earlier than you should & fight the opponent from one stage later than you should. So when using the Pet Arena calc and are looking at the AP amount you expect to spend, you want to look at one stage higher!
286
v7.2.2a - Reverted "Last Updated" to only work when using Auto Import (because google's onEdit function really fucks with its own ability to undo mistakes)
287
v7.2.3 - Max Wave for series is now overall more solid (improved interpolation & it also generates a mini-table with real HP amounts from the game to compare against), Mining Critical Trophy now realistically represents its dynamic returns due to crits not carrying over between tiles, Fixed that Spec Manager wasn't looking at the correct cells for abilities, Added a Fuel Purchase Calc on the Expedition tab (inspired by Edu),
Fixed that expedition pts orb was not being included in the calculations which account for weekly bonus only lasting until the end of the week, Pulled the "Reset Ship Bonuses" button out of the Build Manager & made it a standalone button on the ShipArena tab
v7.2.3 Note: Crit Chance for Auto & Click above 100% may not function. But Ray doesn't know if it works on not & I don't feel like testing to see, so I am just leaving it as if there's no cap for now. If there is any remaining discrepancy for Max Series, it should be related to your Crit Chance being above 100% during Abilities. (Also let me know if you do any testing about it.)
288
- Fixed that Asc Click Speed was looking at some wrong cells for CD/SD calculations, "Value/NRG" on the fish tab now accounts for multicatch chance (so it is more of an average value per nrg than strict value per catches remaining that it has always been), Supported costs of expedition parts up to 200 (still not supported for import/export grid, but you can use Auto Import just fine), Extended the number of rounds simulated in Ship Arena (so that the fight for stages >400 has enough time to finish)
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
Loading...
 
 
 
Instructions/Changelog
Main
Points
Guild
Challenge
Pets
Cards
Party
Fish
Expedition
ShipArena
ShipCombat
Import
Data
MedData
LongData
ShipData
Export
 
 
Main menu