ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This is a tool that calculates the damage of any single ability when applied on any specific target (both have to be level 40). You will have to change the ''Ability'' section for each different skill you want to check (according to the instructions on the ''How to fill in the Ability section'' sheet). For the ''Target Stats'' section, you can find some templates in the see ''Enemy templates'' sheet). You are advised to duplicate the ''Calculations'' sheet as many time as you'd like to make comparisons easy (without having to readjust the same sheet all the time).
2
3
4
5
6
LegendFormulas:
7
input cell, fill it according to instructions
8
calculation cell, DO NOT change it
9
final results
10
11
You have to copy / download this file if you want to use it!!!!
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Armor modifier is replaced by the Resistance modifier in case of non-Physical damage (elemental, corporeal, spiritual):
34
Resistance Modifier = 1 - Resistance/1680 if Resistance <= 672
35
36
Resistance Modifier = 1 - (Resistance+1344)/5040 if Resistance > 672
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