ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Step 1:
Create a copy if you'd like to save and utilize your own variables, otherwise read only, I will be updating this sheet
2
Step 2:
Input battle data to find a drop rate estimate
3
Step 3:
Input [green] Galactic Chase Variables to match current event. Leave [red] alone
4
Step 4:
Follow star chart to determine best course of action for your account
5
Step 5:
@Egnards Beer Tip Jar
6
7
BattlesShardsEnergy/BattleTotal Energy% per Energy SpentGalactic Chase Variables7 Stars6 Stars
8
101101001.00%Energy Needed27,000.00Energy Needed17,000.00
9
07 Stars280Energy/Day6,750.00Est RefreshEnergy/Day4,250.00Est Refresh
10
06 Stars180
Refresh Energy/Day
6,585.0055.00Refresh Energy/Day4,085.0034.00
11
05 Stars95Total Refresh Cost9,000.00Total Refresh Cost9,000.00
12
04 Stars30
13
0Number of Days4Shards to Cover0.00Shards to Cover0.20
14
0Energy TypecantinaCost to Cover0.00Cost to Cover33.48
15
0Free Energy/Day165Total Cost9,000.00Total Cost9,033.48
16
0Preload [Energy]1000
17
0Shard Pack Cost12995 Stars4 Stars
18
0Average Shards7.76Energy Needed8,500.00Energy Needed2,000.00
19
0Cost of Preload0Energy/Day2,125.00Est RefreshEnergy/Day500.00Est Refresh
20
0
Refresh Energy/Day
1,960.0016.50Refresh Energy/Day335.003.00
21
0Marquee Bonus Variables Total Refresh Cost9,000.00Total Refresh Cost600.00
22
0Previous shards50
23
0Shards to Cover0.00Shards to Cover0.00
24
0Cost to Cover0.00Cost to Cover0.00
25
0Total Cost9,000.00Total Cost600.00
26
0
27
0Notes
28
0
1) "Est Refreshes" are rounded into .5 increments. If Est Refresh is 0, but "Refresh Energy/Day" is above 0, it'll be cheaper to buy a single refresh than cover with packs
29
0
2) Drop rates are not guarunteed, and it makes sense to reassess your farm each day to determine if you are on track to finish a farm
30
0
3) Seriously, a huge special thank you to Rymas1 on reddit for cleaning up my Caveman math and making this more sophisticated
31
0
32
0
33
0
34
0
35
0
36
0
37
0
38
0
39
0
40
0
41
0
42
0
43
0
44
0
45
0
46
0
47
0
48
0
49
0
50
0
51
0
52
0
53
0
54
0
55
0
56
0
57
0
58
0
59
0
60
0
61
0
62
0
63
0
64
0
65
0
66
0
67
0
68
0
69
0
70
0
71
0
72
0
73
0
74
0
75
0
76
0
77
0
78
0
79
0
80
0
81
0
82
0
83
0
84
0
85
0
86
0
87
0
88
0
89
0
90
0
91
0
92
0
93
0
94
0
95
0
96
0
97
0
98
0
99
0
100
0