While the equations for calculating the effect of penetration are easily accessible, the process is very tedious, and I've often found myself wasting time doing so manually. So I decided to put-together this calculator, to provide a quick and convenient way to simulate the effect of adding penetration into a build. Happy theorycrafting!
Link to calculator: https://docs.google.com/spreadsheets/d/1uWYAk6ljkvUhYbv8NuT957l-gPbT0aspOdhJ6iisRC8/edit?usp=sharing
Edited by TheYKcid on July 23, 2018 11:45AM
Note: the sheet is read-only. Copy to your own Google drive or download it in order to edit.
1. Getting started
Input your parameters in the yellow boxes, starting with the section in the top half of the sheet. The calculator will tally-up all your penetration sources, then output results in the adjacent green boxes. You should get something like this:
2. Understanding Target Mitigation Coefficient (TMC)
TMC is really just a term I made up to facilitate easier calculations—it simply represents the proportion of incoming damage that one receives, after armor reductions have been applied. So, taking reference from the above example, say you hit the target with a 10k Dawnbreaker—they would only lose 8230 HP because their armor protected them. This will come in handy subsequently.
3. Calculating actual DPS gained from an increase in penetration
In the following example, I simulate the effect of debuffing a heavy armor target with Major Fracture/Breach (with no other penetration besides 35 points into the relevant CP star). First, record the initial TMC value, and then once again after adding the additional source of penetration, as such:
Next, plug these before-and-after TMC values into the second calculator in the sheet, and receive an answer for how much extra DPS the additional penetration has given you!
- Always account for opportunity cost when comparing two builds. For example, when replacing Hunding's > NMG, you gain Major Fracture, but lose 1096 stam + 170 WepDmg. This calculator can only simulate the DPS gain from Fracture, but not the DPS loss from reduced stats (I highly recommend the UESP Skill Browser for that)
- Penetration may perform very differently in a real scenario due to numerous drawbacks (doesn't work on shields, wasted against over-penetrated targets, etc.)
- When simulating a player target, the calculator is only valid for CP160+ players
- The % DPS increase from additional penetration starts to plateau as your targets armor gets lower, so it's advisable not to stack too much penetration
Graph of diminishing returns:
's brilliant Sorcerer arithmagic
article on Tamriel Foundry
's in-depth post on mace/maul performance
's article on the Crusher enchant and its modifiers
, from his website
PC/NA_ — _Daggerfall Covenant_ — _Vivec
Kaladin Chalhoub — Redguard Stamblade
Kalaron Caemor — Altmer Magsorc