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

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
2
Please read this page! Only takes 2 minutes, saves hours!
3
4
Fire Clan's IOU 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
• 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.
10
• If you are manually entering your data without using /export, you will see equations in all of the yellow, typeable cells. Ignore those formulas and type over them.
11
• If you're not using /export, you'll have to type "true" or "false" over Check Box cells before you can click them. This is a google bug. Hopefully they fix it.
12
• If you don't know what to do, there are usually instructions and explanations (mostly hovertext) on each page. Please read them.
13
14
Stone Push Guide:
https://bit.ly/StoneGuide
ShipArena PathViewer:
https://bit.ly/PathViewer
15
FC Ship Sheet Guide:
https://bit.ly/ShipSheetGuide
Ship Push Video:
https://www.youtube.com/watch?v=RmOEYCcZn1w
16
AlreadyTaken's PetSolver:
https://drive.google.com/open?id=1tB_OcABnMP3bA37FS7eI-0MzB0f-dWZw
17
18
Feel free to hide this tab. Report any issues to GameInSky/porkbob/jiecut please! Best way to contact us is generally Discord.
19
20
The newest MultiCalc version can be found at
https://bit.ly/Multicalc
The older template for this sheet can be found at
https://bit.ly/2aui3Kd
Note that any and all feature requests
to the MultiCalc will be coming...
21
The forum thread for the MultiCalc is at
https://bit.ly/2kgtngV
The original (Zilla) template for this sheet can be found at
https://bit.ly/1ZjPeTO
22
If you need a card counter, one is available at
https://bit.ly/1QV3n63
23
Credits:
24
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.
25
All original code was hand-written by Padd1ngton_Bear (Zilla).
26
From version 3.Alpha onwards, the sheet was worked on by GameInSky.
27
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!
28
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).
29
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 sporadic but regular help from jiecut, and the occasional bug fix from GameInSky.
30
Since version 6.8.0, Edu has regularly assisted, with scripting for use of /export and other things. And thanks to celestior for also helping with this a couple times!
31
Thanks to Zornitsa for the art used here!
32
Huge thanks to IndigoFerret for putting a ton of time and effort into the original Pet Map Optimizer!
33
Many thanks to Edu for scripting the Auto Import feature, and Ultraschall for assisting him in testing and matching up data!
34
A ton of thanks to Koin & momo1925 for doing much of the original work for the Ship Arena Calc!
35
Thanks to Level for coding a filter for /export and hosting it on his website! (No longer used, but still very appreciated!)
36
Thanks to Zeruel, momo1925, celestior, Koin, WalrusRajere, DarkLordKelvin, Bloodsicle, & ‖ for either coding small features or inspiring them with examples.
37
Math support provided by Nyima, lucasftw, Aghannor, HeroSlayer27, Julus, Dankaati, Firen, Tahllian, ‖, and jays!
38
Also shoutouts to quixorbl & Koin for many bug reports over the years of the MultiCalc's lifespan. =)
39
Thank you to testers, bug reporters, and everyone who helped make this tool possible! (And anyone we forgot.) =P
40
41
Changelog
You can ignore this if it's your first time.
42
(unhide here to see the rest of the changelog)
326
327
v8.5.1 - 2019/Oct/28
- All trophies should now respect their hard caps, not allowing you to enter a higher bonus nor showing a DPS/bonus benefit for next lvl if you have it at cap
- Fixed that "Avg Dyna until next WH perso" cell was looking to a couple wrong values, causing the result to be wrong
- Added Fish Net Capacity upgrades (Subscription, VIP, Asc)
- Added a checkbox on the Main tab that you can toggle based on whether you have the subscription pack
- Current fish net cap can be seen on the Main tab statistics
- Time to cap fish nets includes bonus nets
- 1 Day whistle cycle should also account for needing to spend extra nets in 1 day to use any bonus net capacity you have
- Capped Pet Train trophy at lvl 60
- Fixed that Auto Import used the wrong cell to clear out the formula in the checkbox for Stone Push Calc's Spec Toggle
- On Stone Push Guide, added mention of the "dynamite needed until" next personal/virtue cells
v8.5.1 Note: I updated the flash's Auto Import as is applicable, but it simply does not contain the new Net Capacity upgrades, so they will not be filled in automatically if you still use flash.
328
v8.5.1a - 2019/Oct/29
- Fixed that MultiCatch trophy had 100x too high bonus
- Fixed that the new Asc upgrade cost wasn't being used when summing total points spent of all different Asc
329
v8.5.1b - 2019/Oct/29
- Fixed that the Pet Arena Trophy Optimizer was swapping shield/heals for the next lvl increase
- Fixed that the formulas connecting Artifact tiers to the Import Grid were somehow missing
330
v8.6.0 - 2019/Nov/07
- Added the 10 new fish (This also fixes Unity Auto Import)
- Added the Offline Fishing Simulation upgrades
- Added calculation support for estimation of gains with Offline Fishing on the Fish tab
- Rearranged Main tab to hide all the gold-related stuff & give Artifacts more room
- Made the comparisons for Match 3 Artifact more robust; the comparison table now changes modes automatically to give as much relevant info as possible for decision making for ALL possible tiers of Match 3 Artifact
- Added thre 3 new Space Lab upgrades (Crystal, Art XP, Gold)
- Expanded "Total Multipliers" section on the Main tab to include Crystal Yield and more fishing info
- Auto Import now sets party member dps to 1 if they have stopped ghosting
- Updated Auto Import to deal with the new window layouts for Unity AND Flash
- Updated the Stone Push Calc to handle the fact that a Crystal bonus now exists that doesn't apply to dynamite
- Updated the feature that limits Weekly Bonuses to the current week for time to upgrade virtue/unlock orb, so that it deals with the fact that Weekly Bonus is not the only Crystal bonus
- Added new Pet Arena Shield trophy cap, at lv 35
- Doubled effectiveness of Asc Net Cap upgrade
- Toggles for Auto/Click base dmg upgrades that cost gold now default to "Maxed"
- Fixed a possible issue where a non-full party in the /export could have caused the script to skip Auto Import of party data
- Experimental change to fish pool spawning
- Fixed that the script for Unity import never actually included the final available fish
- Added a toggle on the Main tab that will alter the Auto Import code for Space Lab upgrades, for when Ray changes the format in the next patch
v8.6.0 Note: When the next patch happens, the Auto Import will break again at Space Lab upgrades. I ADDED A TOGGLE ON THE MAIN TAB. If you toggle the checkbox when next patch happens, then the Auto Import will continue to function
331
- Updated Spec Manager to include the new Asc upgrades, and adjust to the change in position of Abilities on the Points tab
- Rewrote the Spec Manager & Build Manager so that in the future they should be more backwards compatible (if the lengths of the JSONs ever change)
- Updated which cells the "Reset Ship Bonuses" button on the ShipArena tab references
- Updated a bunch of references for the "Personal WH Calc" on the Points tab (Hopefully that fixes it)
- "Dyna til next Virtue" now also includes current Virtue XP, not just Crystal On-Hand
- Fixed that the Art XP Space Lab was giving 2.5% instead of 0.25% (It's not actually used anywhere in the sheet, so no functional difference)
- Fixed a typo that the caused fuel generation trophy upgrade to not import over from Unity /export
- Added the Auto Import skip of partymate data back in, for if there is an error encountered (Hopefully it only skips if the party is empty)
- Fixed that part of the new fishing calcs used some pearl info from older fishing calcs
- The calcs for "Long Term" pearls now average the minimum value with the value from +4 claims, instead of +1 claims
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
Loading...