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

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
WC Challenge Calculator
2
Version 2.0 - Added multiplier bonus
3
4
5
6
0
Base Statistics & Targets
Legend
7
Target1,000,000VP
Requires numerical input
8
Current5,000VP
Formula inside (Do not delete!)
9
Difference995,000VP
Semi-important output, used as reference
10
1500
Requires input (but most likely not going to change)
11
Level130
[Need Input] Current Level
500
Important Output
12
Energy Max154
How much energy do you get at your Current Level
13
14
VPEnergy
15
Rate160060
16
Multiplier350%
[Need Input] Maximum is 400%
17
Per Run7200
Assuming you play manually
18
Attempts left139
19
20
21
1
As a Free Player
22
1.1
Energy Calculation
23
Time left (hrs)96
[Need Input] No of hours left till end of the event
24
Natural Gain960
based on the rate of 10 energy every 1 hr
25
VIP Gain1280
based on VIP rank 8, where you get 80 energy every 6 hrs
26
Additional Gain0
[Need Input] Energy rewarded from the WC event
27
Misc Gain240
From daily bonus, based on the time left (assuming 60 energy from daily quests)
28
Level up Gain0
[Need Input] How much energy gained for a full refill upon level up
29
30
1.2Free VP
31
Free VP66,133
Amount of VP which you can get without buying refills
32
Diff to target928,867
33
34
35
2
Pay-to-Play
36
2.1Refills Left
37
Current energy154
[Need Input] How much energy do you have now?
38
Energy needed34,679
39
Refills to go226
40
41
2.2
Gems Calculation
42
Current Gems100
[Need Input] How many gems do you have now?
43
Additional Gems
40
Gems From daily bonus, based on the time left
44
Extra gems212010
Gems per energy refill
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
Loading...
 
 
 
Sheet1
 
 
Main menu