Xmas Calculator (w dropdown).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
Xmas Event Calculator
3
CAA 2015/12/26
Release Notes:
4
v1.3 - 1/1/16
Updated daily ornament gain to 20 instead of 18
5
Goal to ReachChests
Notable Rewards
6
80
Target Chests
2
3 stamina
v1.2 - 26/12/15
Updated if chests opened exceeds 20 (decorated xmas chest)
7
17
Current Chests Opened
6
Kringle's Worker (Event exclusive Melee Striker)
it will convert to 200 ornaments to open instead of 100
8
63
Difference
9
30 energy
9
14
Snowball (Event exclusive Bracer) + 3 stamina
v1.1 - 24/12/15
Updated Ornaments per day to 18 instead of 10
10
Player Stats20
Changes to Decorated Chest + 50 energy
Included timings of the 20 ornaments/raid in UTC
11
113
Player Level
30
5 stamina
12
137
Total Energy Capacity
40
60 energy
v1.0 - 23/12/15
Release and upload of Calculator
13
6
VIP Level
80
Vile Kringle (Event exclusive Champion)
14
30
VIP Energy Rate
15
6(hours)
16
17
Time left (Event Mission)
End (UTC)
LEGEND
18
DaysHoursMins1/3/201650
Necessary Input from player (Number required)
19
42381:00PMY
Necessary Input from player (selection from dropdown)
20
20
Input from player (but usually will not change)
21
7,148
Overall Total Time (in mins)
Formula inside (do not touch)
22
50
Value of interest to player (do not touch)
23
Y
Collected today's Daily bonuses? (Y/N)
Error in Cell
24
25
26
Energy GainStamina Gain
27
1191
From Time Progression
119
From Time Progression
28
30
From Dailies (10 per day)
3
From Dailies (1 per day)
29
570
From VIP Bonus
30
80
From Xmas Rewards
11
From Xmas Rewards
31
0
Level up Refill
0
Level up Refill
32
0
Other Sources (eg. ToE, WC)
33
34
90
Current Energy
3
Current Stamina
35
1961
Total Energy till end of event mission
136
Total Stamina till end of event
36
37
Event Mission: Valenthian RooptopsStronghold Raid Bonus
38
Y
Include Event Bonus?
YNN
Include Raid Bonus?
39
*Special timings:
40
Normal
Difficulty:
NormalHardExpert
11PM - 2AM (UTC)
11AM - 2PM (UTC)
41
15
Energy per run
5
No. of Raids a day
42
130
No. of Runs w/o refills
20
Total Raids
43
44
4
Base Ornaments
20
Ornaments per run
45
7
Extra Ornaments (based on player)
50%
Raid Win Rate
46
11
Total Ornaments per run
47
48
1,430
Total Ornaments w/o refills
0
Total Ornaments w/o refills
49
50
Overall Result
51
80
Total Daily Ornaments (20 per day)
52
0
Total Daily Calendar Ornaments
53
54
1,510
Total Ornaments
55
9
More Chests Openable
56
26
Total Chests Openable by Mission End
57
58
NO
Able to meet target?
59
60
Pay-to-Win
61
54
No. of Chests to goal
62
5,400
Corresponding Ornaments
63
490
Additional Attempts
64
65
7,350
Additional Energy
66
53
Additional Energy Refills
67
68
10
Gems per refill
69
530
Gems needed
70
71
400
Current No. of Gems
72
73
15
Gems from Dailies (5 per day)
74
100
Gems from Xmas event
75
50
Gems from other sources (eg. ToE, WC)
76
77
0
Additional Gems
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