IOU MultiCalc v10.6.0

	A	B	C	D	E	F	G	H	I	J	L	O	P
2		Please read this page! Only takes 2 minutes, saves hours!
3
4					Fire Clan's IOU MultiCalc
5					Fire Clan's IOU MultiCalc
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.										Engi Notation
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.										E-3	0.001 - 0.999
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.										E0	1 - 999
12		• If you don't know what to do, there are usually instructions and explanations (mostly hovertext) on each page. Please read them.										E3	K
13												E6	M
14						This megaproject has taken 1000s of hours to create, improve, expand, and maintain.						E9	B
15						I always preferred to keep money out of it, but now after all this time invested I've finally decided to add the option to contribute.						E12	T
16			or			Obviously, you should feel no obligation or pressure to donate.						E15	Qa
17						The MultiCalc is a free tool for everyone in the community to use, and this has been its mission from the start.						E18	Qi
18				Click the Button or this Text		However, if you'd like to pitch in, that ability has finally been added after all these years.						E21	Sx
19						Any support is tremendously appreciated!						E24	Sp
20		PayPal QR				Volunteering time, code, or calculations is also an option!						E27	Oc
21												E30	No
22			(MOSTLY) RELATED LINKS				Auto Stone Reset Tool:	https://drive.google.com/file/d/1c7LiS_arhfaCBYilr5htgWcWXBo48_CG/edit				E33	Dc
23			FC's Guild Tools:	https://bit.ly/GuildTools			ShipArena PathViewer:	https://bit.ly/PathViewer				E36	Ud
24			Stone Push Guide:	https://bit.ly/StoneGuide			Ship Push Video:	https://www.youtube.com/watch?v=RmOEYCcZn1w				E39	Dd
25			FC Ship Sheet Guide:	https://bit.ly/ShipSheetGuide			AlreadyTaken's PetSolver:	https://drive.google.com/open?id=1tB_OcABnMP3bA37FS7eI-0MzB0f-dWZw				E42	Td
26												E45	Qad
27		Feel free to hide this tab. Report any issues to GameInSky/porkbob/jiecut please! Best way to contact us is generally Discord.										E48	Qid
28												E51	Sxd
29				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...	E54	Spd
30				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		E57	Ocd
31									If you need a card counter, one is available at	https://bit.ly/1QV3n63		E60	Nod
32		Credits:										E63	Vg
33		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.										E66	Uvg
34		All original code was hand-written by Padd1ngton_Bear (Zilla).										E69	Dvg
35		Starting from version 3.Alpha, maintenance of the sheet was handed off to GameInSky.										E72	Tvg
36		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!										E75	Qavg
37		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).										E78	Qivg
38	From around version 4.3, the sheet has been maintained mostly by porkbob, and starting with version 5.0b momo1925 has helped a bit.	Beginning around version 4.3 until present day, the sheet has been maintained mostly by porkbob, with occasional contributions from jiecut and GameInSky.										E81	Sxvg
39		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!										E84	Spvg
40		Thanks to Zornitsa for the art used here!										E87	Ocvg
41		Huge thanks to IndigoFerret for putting a ton of time and effort into the original iteration of the Pet Map Optimizer!										E90	Novg
42		Many thanks to Edu for scripting the Auto Import feature, and Ultraschall for assisting him in testing and matching up data!										E100	Googol
43		A ton of thanks to Koin & momo1925 for doing much of the original work for the Ship Arena Calc!										To quick convert in your head:
44		Thanks to Level for coding a filter for /export and hosting it on his website! (No longer used, but still very appreciated!)										Subtract exponent by 3
45		Thanks to Stella and Chaos for sharing their Auto Stone Reset Tool!										then divide by 3
46		Thanks to Zeruel, momo1925, celestior, Koin, WalrusRajere, DarkLordKelvin, Bloodsicle, & ‖ for either coding small features or inspiring them with examples.										Ex: E21
47		Math support provided by Nyima, lucasftw, Aghannor, HeroSlayer27, Julus, Dankaati, Firen, Tahllian, ‖, and jays!										21-3 = 18
48		Also shoutouts to quixorbl & Koin for many bug reports over the years of the MultiCalc's lifespan. =)										18/3 = 6
49		Thank you to testers, bug reporters, and everyone who helped make this tool possible! (And anyone we forgot.) =P										so E21 = Sextillion, because 6
50
51		Changelog	You can ignore this if it's your first time.
52		⬅(unhide here to see the rest of the changelog)
365
366		v10.3.0 - 2021/Feb/06 - Formatted the FC Guild Tools sheet for a public release, and linked it on the Cover and Guild tabs - Removed the number suffix system (and script) and reformatted the whole sheet to display in engineering format (including the way you enter party DPS & desired card milestones) - Added new XP hindrance above lvl 75k - Fixed that there was a roughly static offset for XP requirements above level 20k - Added a new toggle for Daily Income SOs—if on, it will pull SOs from the Fish tab instead of what you enter on the Orb tab - Fixed a bug with the /cmd parsemap script—locked center nodes wont be added to the command anymore - Total Artifact XP won't show wrong values and will stay static - Added a chart to the Cover tab, comparing engineering notation to the corresponding number suffixes v10.3.0 Notes: If you're using the Export/Import Grid, be aware that you will need to update your DPSes and Card Milestone goals (Party & Cards tabs) so that they are correctly using engi notation. I know that using engineering notation instead of suffixes will take some adjustment. The script's sluggishness and the frequency at which it got hung was just unacceptable though. Seems google's fault, but no idea how to work around it. Suffixes become meaningless the higher the you go, anyway. Also unacceptable was me having to find every single cell and update the suffixes each time it needed to be expanded. Finally I should never have to touch it again now. Lastly, the Guild Tools sheet should be very useful for new guilds to be able to do good pushes. So I hope you guys enjoy that!
367		v10.4.0 - 2021/Apr/26 - Extended Pet Multistrike support from 5 additional hits to 9 additional hits, which seems to be the limit in the game - Extended Inferno Calc support from 250K to 1M by adding a new tier of Sort 100k to make future expansions easier - Linked Chaos's Auto Stone Reset Tool script here on the Cover tab and also on the Guild tab - Fixed that Match 3 Artifact +3 comparison with GLogs had one of its references looking at the incorrect Data tab - Fixed that the SD re-calculations on the Points tab that used the old calculation method weren't built to handle more than 2 Splat cycles, and so with enough cooldown reduction they could cause the SD gain to be a small negative amount if the upgrade was really weak (i.e., Click Ascension above 100)
368		v10.4.1 - 2021/Apr/27 - Fixed a set of errors where the Inferno Calc was looking at empty cells to calculate the optimal inferno tiers, breaking the whole system
369		v10.5.0 - 2021/May/09 - Added a Pet Map AutoBuy button that will upgrade the best DPS nodes until you run out of PP (Thanks, WalrusRajere!) - Fixed that Best XP Tier in the Inferno Calc was adding 100 per step in the 1k step - Implemented a workaround for google not interpretting most values above 1e16 as numbers in the Cards tab, for whatever reason
370		v10.5.0a - 2021/May/09 - Made the Cards tab skip over the errors caused by the previous workaround
371		v10.5.0b - 2021/Aug/20 - Excluded new mining and world upgrades from Auto Import - Increased costs of pet tier ups after 37
372		v10.6.0 - 2021/Sep/26 - Fixed that there was more or less a typo in how the XP requirements per player level were functioning above level 75k - Pet Map AutoBuy script should now buy the center nodes as well (Thanks, internet!) - Made a minor tweak to the way average Fish Quality is calculated. This doesn't actually change the end result, but would be a bit easier for someone to follow the logic if looking for the first time. v10.6.0 Notes: I spent hours looking at Fish Quality based on code Ray gave me many months ago. It simply does not work in the game the way it should based on the code Ray has. Clean NRG Artifact would be worthless at any upgrade level based on the way he has it, but clearly it is roughly as good as the sheet has it as long as you don't go above ~150-200%. I have no idea how the game is bugged, but it is clearly happening outside of the code Ray has for these base calculations. This might be the last update I do; I have very little interest in the game.
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395