VehicleCombinationCalculator.xlsx

	A	B	C	E	F	G	H	I	J	K	L	M	N	O
1	TOTK Vehicle Duration Calculator [Author: Paradox_Guardian] \| Sheet v1.2.1 Game v1.1.2 (6/20/2023)
2
3
4	Enter your current number of wells here (You start the game with 3)-->:		3	LINK TO UPDATED VERSION: DepletionCalculator2.xlsx
5	How many pieces of Zonaite armor are you wearing?-->:		0
6				Compare designs here! For each design, indicate whether it's on rails/in water and enter the quantity of each component in its corresponding row.
7	README! THIS DESIGN IS OUTDATED. PLEASE USE THE VERSION 2 LINKED ABOVE		Add design titles, notes or whatever in this row -->	Example: 2 fan hoverbike
8				Is this design in the water or on the rails? Enter 0 for No or 1 for Yes below.
9				0	0	0	0	0
10	Zonai Part	Base Depletion Rate (wl/s) [Fixed well loss/capacity in case of rocket and batteries]	Combination Rule	Design 1 Components	Design 2 Components	Design 3 Components	Design 4 Components	Design 5 Components		These cells are used as variables for calculation. They contain component-weighted consumption rates. Rockets and Batteries are calculated in a separate stage
11	Fan (not touching rails/water)	0.156	Standard	2	0	0	0	0		0.234	0	0	0	0
12	Rocket	-0.54	Standard	0	0	0	0	0		0	0	0	0	0
13	Flame Emitter	0.18	Standard	0	0	0	0	0		0	0	0	0	0
14	Frost Emitter	0.18	Standard	0	0	0	0	0		0	0	0	0	0
15	Shock Emitter	0.18	Standard	0	0	0	0	0		0	0	0	0	0
16	Beam Emitter	0.18	Standard	0	0	0	0	0		0	0	0	0	0
17	Hydrant	0.03	Standard	0	0	0	0	0		0	0	0	0	0
18	Big Wheel	0.015	Wheel	0	0	0	0	0		0	0	0	0	0
19	Small Wheel	0.015	Wheel	0	0	0	0	0		0	0	0	0	0
20	Battery	4.5	Multiply	0	0	0	0	0		0	0	0	0	0
21	Big Battery	63	Multiply	0	0	0	0	0		0	0	0	0	0
22	Cannon	0.3	Standard	0	0	0	0	0		0	0	0	0	0
23	Stabilizer	0.03	Odd	0	0	0	0	0		0	0	0	0	0
24	Hoverstone	0.03	Odd	0	0	0	0	0		0	0	0	0	0
25	Light	0.03	Odd	0	0	0	0	0		0	0	0	0	0
26	Homing Cart	0.03	Odd	0	0	0	0	0		0	0	0	0	0
27	Construct Head	0.03	Odd	0	0	0	0	0		0	0	0	0	0
28				Design 1 Results	Design 2 Results	Design 3 Results	Design 4 Results	Design 5 Results
29		Design Total Depletion Rate (wl/s):		0.234	0	0	0	0		Rocket and Battery Fixed Well Constants
30		Design Specific Duration (s/wl):		4.273504274	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!		0	0	0	0	0
31		Time to deplete 3 Wells [not counting rockets] (s):		12.82051282	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!		0	0	0	0	0
32		Time to deplete current number of Wells [including rockets, batteries, and zonaite armor effects] (s):		12.82051282	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!		0	0	0	0	0
33		Above quantity converted into minutes:seconds (What you're looking for)		00:13	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
34
35				These are the Lookup Tables for combination rules. If you don't understand this, look at the video linked above
36	Armor Effect LUT			Standard		Wheel		Misc.
37	Pieces	Multiplier		Standard Count	Neq	Wheel Count	Neq	Misc Count	Neq
38	0	1		0	0	0	0	0	0
39	1	0.8		1	1	1	1	1	1
40	2	0.65		2	1.5	2	1.466666667	2	1.533333333
41	3	0.5		3	2	3	2	3	2
42				4	2.5	4	2.4	4	2.533333333
43				5	3	5	3	5	3
44				6	3.5	6	3.6	6	3.6
45				7	4	7	4.2	7	3.966666667
46				8	4.5	8	4.266666667	8	4.533333333
47				9	5	9	4.8	9	5.1
48				10	5.5	10	5.333333333	10	5.666666667
49				11	6
50				12	6.5
51				13	7
52				14	7.5
53				15	8
54				16	8.5
55				17	9
56				18	9.5
57				19	10
58				20	10.5
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100