Summer Event.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Summer Event Calculator
3
CAA 2017/07/29
Release Notes:
4
5
Goal to Reach
Sun Pts
Notable Rewards
Sun PtsNotable Rewards
v1.0 - 29/7/17
Release of calculator
6
1,000,000
Target Points
1,800
Summer Chest
400,000
5 x Hexaanium (T3 mastery)
7
150,000
Current Sun Pts Obtained
12,000
Summer Chest
500,000Fire Colossus
8
850,000
Difference
30,000
Summer Chest
600,0005 Celestial Sphere
9
60,000
Cyclops Worshipper
800,000
5 x Hexaanium (T3 mastery)
10
Player Stats87,900
Summer Chest
5 x Decanium (T6 Mastery)
11
140
Player Level
105,000
T3 Fire Trinket
1,000,000Fire Colossus
12
164
Total Energy Capacity
165,000
Cyclops Guardian
13
8
VIP Level
198,000
Summer Chest
14
80
VIP Energy Rate
270,000
T4 Fire Trinket
15
12
(hours)
16
17
Time left (Event Mission)
LEGEND
18
DaysHoursMins50
Necessary Input from player (Number required)
19
2205Y
Necessary Input from player (selection from dropdown)
20
20
Input from player (but usually will not change)
21
4,085
Overall Total Time (in mins)
Formula inside (do not touch)
22
50
Value of interest to player (do not touch)
23
0
:00, Local Time when event started
Error in Cell
24
15
Specific Hour for new day (for time left)
25
26
N
Collected today's Daily bonuses?
27
YN
28
29
Energy Gain
Sun Pts
Energy
30
680
From Time Progression
90030
31
120
From Dailies (60 per day)
18,00050
32
400
From VIP Bonus
74,250100
33
380
From Event Reward
300,000200
34
0
Level up Refill
Net380
35
0
Other Sources (eg. Arena, WC Chests)
36
37
100
Current Energy
38
1680
Total Energy till end of event mission
39
40
Free Route
Difficulty
Energy
Sun PtsRate
41
Legend
Difficulty
Normal1530020
42
60
Energy per run
Hard2044022
43
28
No. of Runs w/o refills
Expert3070023.33
44
Epic451,10024.44
45
310.8
% Total WC Point Bonus
Legend601,60026.66
46
47
6,600
Sun pts per run
48
184,800
Total Sun pts w/o refills
49
50
NO
Able to meet target?
51
52
53
Paying Route
Sun Pts
Gems
54
6,047
Additional Energy needed
9,0005
55
36
Additional Energy Refills
22,50015
56
135,00025
57
10
Gems per refill
Net45
58
360
Gems needed
59
60
101
No. of additional runs w refills
61
129
Total No. of Manual Runs
62
63
1.5
Amount of time per run
64
193.5
Total time to spend (in mins)
65
66
1,000
Current No. of Gems
67
68
20
Gems from Dailies (10 per day)
69
45
Gems from event (see chart on right)
70
0
Gems from other sources (eg. ToE, WC)
71
72
0
Additional Gems to buy
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
Loading...
 
 
 
Sheet1
VIP Bonus Energy
 
 
Main menu