ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Thanks:
3
HUGE shoutout to Richard and his Item spreadsheet. Copying Item / Chest data from there made this sheet a lot easier to complete.
4
5
6
7
8
9
Known Bugs:
10
Wisdom Ocarina isn't in Chest Recipies
11
12
13
14
15
16
Things I'd like to include in the future:
17
18
Currently +Power to Green is just a subtraction formulae. I'd like to take into account Item Power bonus / Party bonus to get a more accurate number.
19
Break Chances for all items may be in the far future. Its just not as important now.
20
Obviously once we get the data on the new building upgrades I'll include that.
21
22
23
24
25
26
27
28
29
30
31
cleaning up for google sheets use - internetz.
32
using autofill import data from
33
richards sheet
34
hero equip query
35
36
37
Have built hero equips ranges; have built auto importing skilled table; have built auto importing items table; have built auto importing hero equips table. need to update with new hero info
38
Also need new quest data from last patch still
39
all calculated hero power data has now been added. probably want to set a flag with a calculation for things that affect base hero power...
40
41
42
43
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