Idle Planet Miner.xlsx

	A	B	C	D	E	F	G	J	K	L	M	O	P	Q	R
1
2	Total Multiplers
3		Craft speed	Smith Speed	Item Price	Alloy Price	Smelting Item Reduction	Craft Item Reduction
4	Station	1.65	1.15	1.98	1.98	-	-
5	Mothership	4.3	4.1	2.5	2.5	0.5	0.5
6	Purchases	3	3	2	2	-	-
7	Managers	16.015	11.395	-	-	-	-
8	Research	1	1	1	1	1	1
9
10	Total Multiplier	340.879275	161.182275	9.9	9.9	0.5	0.5	Optimal Station Crafting Upgrade				Intermediate Calcs
11		0	0	0	0			Thing	Improvement	Price Of Upgrade	Improvement Per Price	New Manager Multiplier	new craft time	new price	new price per time
12								craft 1	0.606	32	18.9		0.1749550606	99000	9430.993275
13		raw item price ($)	10000		raw alloy price ($)	120000		craft 2	0.606	23	26.3		0.1749550606	99000	9430.993275
14		raw item time (s)	60		raw alloy time (s)	180		craft 3	0.606	20	30.3		0.1749550606	99000	9430.993275
15		Current item Time (s)	0.1760153943		Current alloy Time (s)	1.116748104		craft 4	1.212	37	32.8		0.1739074255	99000	9487.806488
16		Current item Price ($)	99000		Current alloy Price ($)	1188000		craft 5	2.424	36	67.3		0.1718493495	99000	9601.432913
17		Current item Price per min ($/min)	9374.180063		Current alloy Price per min ($/min)	17730.05025							0.1760153943	100800	9544.6197
18
19		Misc Inputs
20		Market Multiplier						Sale 1	1.818		0
21								Sale 2	4.04		0		0.1760153943	103000	9752.934813
22		Station Inputs						Sale 3	4.04		0		0.1760153943	103000	9752.934813
23		Crafting						Sale 4	1.01	100	10.1		0.1760153943	100000	9468.86875
24		Name	Level	Upgrade per level	Total			Sale 6	3.788	200	18.9		0.1760153943	102750	9729.262641
25		craft 1	4	0.01	0.04			managers 1	0.974		0	16.171	0.1743173916	99000	9465.492713
26		craft 2	4	0.01	0.04			managers 2	4.465	665	6.7	16.73	0.1684929193	99000	9792.696375
27		craft 3	5	0.01	0.05			managers 3	4.465	665	6.7	16.73	0.1684929193	99000	9792.696375
28		craft 4	12	0.02	0.24			manager 4	-93.35	50	-1867	1.065	2.646841821	99000	623.3844375
29		craft 5	7	0.04	0.28			manager 5	-93.35	50	-1867	1.065	2.646841821	99000	623.3844375
30		Multiplier	1.65					manager 6	-93.35	50	-1867	1.065	2.646841821	99000	623.3844375
31		Smithing						Best Upgrade	craft 5
32		Name	Level	Upgrade per level	Total
33		smith 1	3	0.01	0.03			Optimal Station Smithing Upgrade
34		smith 2	3	0.01	0.03			Thing	Improvement	Price Of Upgrade	Improvement Per Price
35		smith 3	3	0.01	0.03			smelting 1	202.609	20	10130.5		0.3690403217	1188000	53652.6738
36		smith 4	1	0.02	0.02			smelting 2	202.609	16	12663.1		0.3690403217	1188000	53652.6738
37		smith 5	1	0.04	0.04			smelting 3	202.609	15	13507.3		0.3690403217	1188000	53652.6738
38		Multiplier	1.15					smelting 4	205.217	16	12826.1		0.3658861309	1188000	54115.19685
39		Item/Alloy Price						smelting 5	210.435	30	7014.5		0.3597367842	1188000	55040.24295
40		Name	Level	Upgrade per level	Total			Best Upgrade	smelting 3
41		Sale 1	5	0.036	0.18
42		Sale 2	5	0.08	0.4			Optimal Mothership Crafting Upgrade
43		Sale 3	5	0.08	0.4			Thing	Improvement	Price Of Upgrade	Improvement Per Price	New Manager Multiplier	new craft time	new price	new price per time
44		Sale 4	0	0.02	0			Workshop	2.326	4616	0.504		0.1720150444	99000	9592.18425
45		Sale 6	0	0.075	0			Sales	2	3297	0.607		0.1760153943	100980	9561.663664
46		Multiplier	1.98					Lounge	2	2385	0.839
47		Manager						Classroom	1.875	3400	0.551	16.3153	0.1727756486	99000	9549.956914
48		Name	Level	Upgrade per level	Total			Best Upgrade	Sales
49		managers 1	5	0.012	0.06			Only upgrade credits if credits upgrade is X% better than other upgrades:			25
50		managers 2	0	0.055	0					Lounge/Max =	38
51		managers 3	0	0.055	0
52		managers 4	0	0.005	0
53		managers 5	0	0.005	0
54		managers 6	0	0.005	0
55		manager 7	1	0.06	0.06
56		manager 8	7	0.005	0.035
57		Multiplier	1.155
58
59
60		Mothership Inputs
61		Crafting
62		Room	Level	Improvement Per level	Multiplier
63		Workshop	32	0.1	4.3
64		Dorms	11	0.04	0.5
65		Item/Alloy Price
66		Sales	28	0.05	2.5
67		Lounge	28	0.05	2.5
68		Smithing
69		Underforge	11	0.04	0.5
70		Forge	30	0.1	4.1
71		Manager
72		Classroom	28	0.05	2.5
73		Other
74		Marketing	19	0.1	3.1
75		Engineering	31	0.15	5.75	2.608695652
76
77		Purchased Ships
78		Ship	Ship Multipler	Purchased (Yes Or No)	Your Multipler
79		Elder Ship Craft/Smelt speed multipler	1.5		1.5
80		Merchant ship price multiplier	2		2
81		Thunder Horse Craft/Smelt speed multipler	2		2
82		aurora manager multipler	2		2
83		daughter ship (mine rate)	1.5		1.5
84		Exodus Ship (Credits multiplier)	2		1
85					8.632
86		Manager Inputs
87		Crafting
88		stars	3	4	5	6
89		Num Managers	0	0	1	6	0
90		Base improvement per manager	0.050	0.100	0.200	0.400	0.700
91		Total base Improvement	2.6
92		Total Manager Crafting Multipler	16.015
93		Smithing
94		Stars	3	4	5	6
95		Num Managers	0	0	1	4
96		Base improvement per manager	0.050	0.100	0.200	0.400
97		Total base Improvement	1.8
98		Total Manager Multipler	11.395
99
100