ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Make a copy of this spreadsheet so you can edit values. Do not download the sheet to use with a spreadsheet program. This is version 8. The latest version can be found at https://docs.google.com/spreadsheets/d/1mhL_dGtsjEheiSP-f_mSCVb4xoz6sN__8B6-PnAdaLw/edit?usp=sharing
2
GoblinsThe Goblins sheet has the costs for goblins. If the appropriate constants are set, it will automatically populate with the approximate cost of every goblin through level 24.
3
GraphsThe graphs sheet has a graph showing the production per minute vs cost of all the mines. You can change the card levels in the income sheet and the graph will update. Zooming in is done by editing the graph properties and changing the horizontal and vertical axis range.
There is also a graph showing the time to recover the cost of a mine upgrade. This is how long it will take for an upgrade to pay for itself, not the time it will take a mine to earn enough to pay for the next upgrade. When this goes above 1000 or so, the upgrade will never pay for itself, but might be worth it if other mines are producing more and you want to gather the elixir (or if you are going through a level to get to a big boost). The cost level where the lowest mine in the graph crosses through about 1000 is the highest level of money that you can get with your current card levels. This graph ignores any deliveries boost, because I haven't figured out how those work yet.
4
OptimalThe optimal tab will calculate the optimal shaft upgrade sequence, using a simplistic algorithm. It sorts the shaft upgrades by cost and has a column that indicates when an upgrade is above the maximum shaft income and another column to show when it is above 10% (or whatever number you set) of the maximum income. You can set a filter to show only the shaft upgrades that increase income. The card levels can be set for each mine in the income sheet to show you what you should do based on your current cards. Click on one of the filter buttons and press ok to update the filtering after changing card levels.
5
IncomeThe income sheet calculates your current income. It performs the adjustments necessary based on how many checkpoints you have cleared and your rare card levels. The income calculations work for any mine level, even levels between boosts. It also shows you your total mine income, both for your automated mines and for all your mines, as well as what percentage of that income comes from each shaft.
6
ConstantsThe constants sheet has details about the mine. These can be updated to produce a sheet for a different mine. Do not edit this unless you know what you are doing
7
Shaft DataThe shaftdata sheet has the upgrade costs and boosts for each mine. They are grouped so that the details for each mine are in consecutive columns, to make it easier to copy mine formulas. This is more useful for the computer than a person.
8
Shaft DetailsDetailed calculations with the shaft data, mostly useful for calculating and verifying the constants. If you don't know what to do here, do nothing.
9
10
Anywhere that you can set card levels, set the card level to -1 or anything that is not a number to indicate that a mine has not been unlocked.
11
12
13
Ads2 goblins, 1 elixir
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
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