ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Patch 4.8.4 + TB 21-Mar-2023Check here for updatesThanks to
2
3
OrangeChrisOriginal publisher up to v14.01
4
How To Use This CalculatorLasmrahCreating this calculator and initially maintaining it, up to and including v4.0
5
prop joeThe mods Give Weapon and Item Spawner
6
First of all, you're going to have to make a copy of this file in order to mess with the drop downs. So make sure you're signed into a Google account, then select File -> Make a copy (DO NOT click "Request Edit Access").

Next, go to the "Main" worksheet (on the bottom of your screen). There are three main groups of interactive elements. In the top left, select your career and weapon. You can also change the difficulty and input your current displayed hero power. To the right, the sheet will pull up a list of that career's relevant talents. For most talents, put a '1' in the box to turn it on. Input '0' to turn it back off. Any talent with other behavior has a note attached to the talent name - hover over it to read the description!

Below that are two rows of effects which every career can benefit from. "Other Talents" are talents which can help other teammates, not just the player that uses them. "Miscellaneous" are other effects such as some Traits. Like the career-specific talents, these buffs can usually be enabled by changing the 0 to a 1. Hover over the effect with your mouse to get a full description.

Once the table loads, each row shows one of your weapon's attacks. Headshots are orange and capitalized; crits have red text, crit headshots have both.

Each column represents one enemy. Its armor type and health is shown for reference.

The first number in each cell is how many hits it will take to kill that enemy with that attack. If a reasonable breakpoint exists, the cell will also show the new number of loops, and how much extra damage you need to achieve this breakpoint.

For example, a cell which displays "3 -> 2 (8%)" means it currently takes 3 hits to kill the enemy. But if you increase your damage by 8%, it will only take 2 hits.		AussiemonThe mod Creature Spawner, and the game's decompiled source code
7
grasmannThe mod Show Damage
8
ExantaDoing most of the work involved in testing console damage and health on PS4. (pre-WoM)
9
LordDragoFinding enemy health values during WoM Beta
10
Alistair_MacbainFinding errors in the spreadsheet. The spreadsheet is very complicated with an enormous number of input combinations. Bug reports from users are the only way I can guarantee its accuracy.
11
Anti-AliasingAlias
12
assagaroo
13
Azshadrahnor
14
boobiloo
15
Brood_Star
16
Brynbo96
17
Cool_Camera5902
18
dellaint
19
Emopillow
20
fimconte
21
giiiiiiiiiiiinger
22
Hotmann1
23
hubba_bubba_gump
24
intergalacticninja
25
JCdaSpy
26
Khalku
27
King_Sockenbart
28
Malacarr
29
MonorailBlindness
30
Custom CombosmoorhS_
31
mr_D4RK
32
The purple Custom Combo box, located under the talents, lets you combine multiple attacks. Input the attacks in the top row. In the bottom row, select whether that attack was a headshot and/or crit. The first line of the table will show you the breakpoints for the combo you created. To get rid of the custom combo, click on the attack and press Delete on your keyboard.

If a cell reads something like "Overkill: 2 hits", this means that the enemy was dead after only the first two attacks in the combo.		Nayre
33
Nolrach
34
OG_Shadowknight
35
Oxydo89
36
Pondering_Potato
37
Royale w/ Cheese
38
sb12837
39
FAQShad3slayer
40
Does Power vs. Armored work on Chaos Warriors?
Yes, Power vs. Armored affects both Armored and Super Armor.

How do Power vs. [armor] and Power vs. [faction] interact?
As of Patch 2.0, all Power vs. properties stack additively.

How do I calculate damage vs. the training dummies in the keep?
The unarmored dummies are considered a Chaos unit, and the armored enemies are considered Skaven. So the Fanatic and Stormvermin work identically to the dummies.

Why are some of the boxes empty?
The sheet doesn't display any values for attacks which do zero damage against that enemy. Additionally, in Breakpoint mode, the sheet doesn't display any values for attacks which would take more than twenty hits to kill the enemy.

Do you support console?
Not currently. Enemy health was changed in the Winds of Magic update, and I don't have a console so I have no way to find the new values on my own. If you'd like to see console support, you can help by doing the following on a console:
1. Just hit the dummy in the keep, and tell me how much damage was dealt and what buffs you were using. I only need bodyshot, crit, and crit headshot for a few weapons.
2. Find the enemy's health. This is harder, and might not be possible without a full team of 4 players. In a mission, have one player attack only a single enemy. Make sure no other players harm that enemy. Once the enemy has been killed, fail the mission. The scoreboard will tell you how much damage was dealt by that player, so that's the enemy's health. For each difficulty, I need all of the following:
a. One of the smaller horde units: Skavenslave, Ungor or Fanatic
b. An elite unit, such as a Stormvermin or Mauler
c. Either a special enemy or one of the larger horde enemies (Clan Rat, Gor or Raider)		Survival_Project
41
Tamren
42
terrorobe
43
trashk
44
Traveller_Guide
45
YeOldDrunkGoat
46
VernonKunUpdated spreadsheet from v14.01 to the current version.
47
∅.Helped calculating number of random DoT ticks and made a script for it.
48
WallcroftHelped testing friendly fire damage.
49
50
51
52
Some other stuff I've made
53
54
A List of Everything You Wish Fatshark Told You
55
A massive info-dump on most of the game's mechanics.
56
Damage Numbers
57
A mod for the game which displays damage numbers when you hit enemies. Only works in modded realm.
58
59
60
61
62
PayPal
63
64
65
66
If you're really interested in how this calculator works, select View->Hidden Sheets->README2 up at the top.
67
68