ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Vespaisan's "General Calaculator" V4 (additional work by Cranz)
2
3
Version
4
Version 5. Dragon refines for more accurate results. RTB and STG added. All General Tabs hidden (cleaner)
5
6
Spreadsheed Tabs
7
There are a number of hidden tabs; these are just lookup tabs used to collect and then distribute all the information; I am in two minds about locking: But do not fuck with them.
8
General Lookup: This contains all the basic information that makes a general, from Name, to base stats/multipliers to Unique Skill (US) and Specials.
9
Dragon Lookup: Contains all information surrounding Dragons, skill, buff and stat increase per level.
10
Base Speciality: Each general has 3 base specials, Spec 1 has a special that increase 2 stats from 1 troop type. Spec 2 and 3 further split "purpsoe" of general up, but tend to follow a rule "base", "in city", "attack", "Sub" and/or Duty Officer
11
Strings: Just contains some forumlae backups in case I cock up.
12
13
Generals and Comparions
14
Every General has its own tab, that contains an "effective" version of them. SB, Dragons, Level and Star can each be changed if you wish. Everything else will be locked (In most versions).
15
Additionally, there are two Addition tabs, "My General 1" and "My General 2"; Type in the name in the name cell, all basic info will load in; and input whats mentioned above, as well as the SB buffs and Percentage Buffs.
16
The Comparison tabs are split by "Main City", "Attacking", "Reinforce" and "Sub City"; it takes from the relevant stats column, from each general tab, and you can sort however you want
17
When sorting out averages on these columns, there are some in as default, however, if you want to average certain cells here is how "=AVERAGE(Cell 1, Cell 2, Cell 3,…)", drag this down to encompass all generals. "Self Average" Column is for this.
18
I have all generals in all comparions. You can filter as you wish.
19
All 3 comparison tabs have the SBs and Dragon/Beast to their left.
20
21
Notes and other information
22
I say it every time, Defence* stat can be up to ~1% higher or lower, this is an evony thing, that math just can't determine
23
I am only human, there is potential for errors, just let me know if you think there is one.
24
To my knowledge this is the absolute most accurate calculator, but Evony… is Evony. And so it may be completely wrong (Doesn't seem to be though)
25
I have merged cells and borders in such a way it should be easy to hide columns you have no interest in e.g. hide everything except In City stats if you are looking at Wall Gens.
26
*I haven't checked again for a while, but it seemed to be Attack on Alfred, I'll double check when I remember
27
On Attacking PvP, Debuffs are shown as positives, this is done to keep averages consistent
28
29
30
31
32
33
34
35
36
37
38
39
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