ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3*, 1 to 23*, 2 to 34*, 1 to 24*, 2 to 34*, 3 to 45*, 1 to 25*, 2 to 35*, 3 to 4
3
Red
4
Yellow
5
Green
6
Blue
7
Purple
8
9
10
3*, 1 to 23*, 2 to 34*, 1 to 24*, 2 to 34*, 3 to 45*, 1 to 25*, 2 to 35*, 3 to 4
11
Red00000000
12
Yellow00000000
13
Green00000000
14
Blue00000000
15
Purple00000000
16
17
18
Legend
19
Adjust cells with this color to your own situation.
20
Do not touch these cells; these are needed for correct calculations.
21
22
23
Instructions
Input the names of all ascension levels your heroes need to go through on this worklsheet. Separate names of heroes by a comma (","), otherwise they will not be counted correctly in your needed ascension materials.
Example:
You have a 4* Boril (Blue) at ascension level 1 and a 4* Kiril (Blue) at ascension level 3.
Boril has to ascend from level 1 to level 2, level 2 to level 3 and level 3 to level 4.
Kiril has to ascend from level 3 to level 4.
To calculate the items needed you enter the following input in this sheet:
In the column 4*, 1 to 2 and row Blue: Boril
In the column 4*, 2 to 3 and row Blue: Boril
In the column 4*, 3 to 4 and row Blue: Boril, Kiril

Do not change anything on the worksheet 'Ascension - Calculation of items needed'. Some items are entered based on assumptions as items needed are assigned systematically to colors and levels (which noted behind the item)

You will find the total needed ascension materials on worksheet 'Ascension - Total items needed'.
You can also input your current inventory to check the materials you'll still need to gather.
For each material the provinces with increased chances as well as starter provinces are shown.
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Short URL for this file: https://goo.gl/5iua6M
40
If you wish to use this file, please copy it to your own Google Drive (File -> Make a copy). You will be able to edit that version (if I'm correct).
41
42
Calculator created by Gune0303
43
Input for items needed based on Coppersky's sheet for high level ascensions, input from members of my alliance Down the rabbit hole, and own observations.
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