ABCDEFGHI
1
Only fill in the green highlighted boxes.
File -> Make a Copy to edit the sheet for yourself
2
3
Base AR (minus flat gems)588
Incoming Attack Rating is ratio'd by Defense, based on the ratio, 1 of the 5 reduction formulas will be applied to create the Damage Reduction %
4
Attack Modifiers1.45If A/D ratio >= 1 and <= 2.5If A/D ratio >= 2.5 and < 8If A/D ratio >= 1 and >= 8If A/D ratio <= 0.12If A/D ratio > 0.12 and < 1
5
Flat gem AR30-21.8199788---
6
AR after mods883
7
Physical DEF stat234
8
Attack to Defense ratio3.8
9
Damage Reduction %21.820
10
Damage after Physical DEF690.017
11
Clothing DEF193
12
Damage after Clothing DEF557
13
Counter-hit (1.2x)
14
Open Foes (6% = 1.06x)1.06
15
Instability (1.4x)
16
Actual damage taken590
17
(This value will either be the above value, or the above value minus one.)
18
19
To calculate a % of damage you have taken:
Fill in the green box.
20
1. Take your max HP (1897 50 VIT w/ 2 Clock runes)
Max HP1897
21
2. Take your actual damage taken (cell B13). For this example we will use 557.
Damage taken590
22
3. 1897 - 557 = 1340HP after dam.1307
23
4. Take the result and divide by your original HP (1897)
% damage taken-31.12
24
4a. 1340 / 1897 = 0.7063
25
5. Subtract 1
26
5a. 0.7063 - 1 = -0.2935
27
6. Move the decimal 2 places over
28
6a. -29.35
29
7. You just took damage equal to 29.35% of your total HP.
30