Maintenance for the week of February 18:
• PC/Mac: No maintenance – February 18
• Xbox One: EU megaserver for maintenance – February 20, 4:00AM EST (9:00 UTC) - 12:00PM EST (17:00 UTC)
The Wrathstone DLC Game Pack and Update 21 base game patch are now available to test on the PTS! Read the full patch notes here: https://forums.elderscrollsonline.com/en/discussion/454456/

The Comprehensive [ Penetration Calculator ]

TheYKcid
TheYKcid
✭✭✭✭✭
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
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:
YV79VyP.png



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:

d86whVA.png?1

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!

MpSdjrT.png



4. Disclaimers
  • 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:
    fbDVznW.png



5. Sources/credits
@Asayre's brilliant Sorcerer arithmagic article on Tamriel Foundry
@Masel92's in-depth post on mace/maul performance
@Woeler's article on the Crusher enchant and its modifiers, from his website
Edited by TheYKcid on July 23, 2018 11:45AM
PC/NA__Daggerfall Covenant__Vivec
Kaladin Chalhoub — Redguard Stamblade
Kalaron Caemor — Altmer Magsorc
.
  • Turelus
    Turelus
    Community Ambassador
    Very useful and a fast way to help a lot of people who don't have access to internal guild sheets already being used. Thanks. :smile:
    @Turelus - EU PC Megaserver
    :: Unofficial Forums FAQ :: MissBizz ESO Guides :: AlcastHQ Guides :: Tamriel Foundry Forums :: UESP ESO Page :: ESO Sets :: Woeler Tank Guides :: ESO Community Discord ::
    "Don't count on others for help. In the end each of us is in this alone. The survivors are those who know how to look out for themselves."
  • Tyrion87
    Tyrion87
    ✭✭✭✭✭
    Really handy, thank you :)
  • Kikke
    Kikke
    ✭✭✭✭✭
    now just make it into an addon so I dont have to alt-tab xD
    Cleared Trials:
    - vAA HM - vHRC HM - vSO HM - vMoL HM - vHoF HM - vAS HM - vCR HM -

    "The journey of a thousand miles begins with one step, and a lot of bitching."
    -Someone said it, I guess.
  • Morgul667
    Morgul667
    ✭✭✭✭✭
    ✭✭✭
    Seems very nice

    Im just here to say i love the title
  • TheYKcid
    TheYKcid
    ✭✭✭✭✭
    kikkehs wrote: »
    now just make it into an addon so I dont have to alt-tab xD

    Would love to if I had the technical know-how, but Excel is the extent of my abilities unfortunately...
    Morgul667 wrote: »
    Seems very nice

    Im just here to say i love the title

    I had... several titles in mind, but I didn't want the thread locked.
    Edited by TheYKcid on July 20, 2018 11:11AM
    PC/NA__Daggerfall Covenant__Vivec
    Kaladin Chalhoub — Redguard Stamblade
    Kalaron Caemor — Altmer Magsorc
    .
  • Tyrion87
    Tyrion87
    ✭✭✭✭✭
    TheYKcid wrote: »
    kikkehs wrote: »
    now just make it into an addon so I dont have to alt-tab xD

    Would love to if I had the technical know-how, but Excel is the extent of my abilities unfortunately...
    Morgul667 wrote: »
    Seems very nice

    Im just here to say i love the title

    I had... several titles in mind, but I didn't want the thread locked.

    I propose changing it to: "Determine your Penetration with or without Lover".
Sign In or Register to comment.