Bopper's CoH Tools and Formulas

[Bopper 2446]

Bopper's CoH Tools and Formulas

 

Over the past year I have written numerous guides and I have read numerous guides. And from those guides I developed tools that I use to do calculations fairly quickly. One of my tools I shared previously (The Survivability Tool), but I decided to share the rest of them in a single Google Sheets document. So, over the past month I ported them into a Google Spreadsheet and I think it’s cleaned up enough to share with the community. Most of these tools are from guides I posted, but a handful of them are tools created from information learned by others. Links to these guides will be embedded below.

The contents of the Bopper's CoH Tools and Formulas spreadsheets include:

Proc Probability Calculator

Recharge Calculator

Pylon DPS/Time Calculator

Assault Hybrid Comparator

Cancel-On-Miss DoT Calculator

Resistance/Debuff Calculator

Survivability Tool

Design Formulas

HP/Regeneration Proc Cheat Sheet

Edited July 26, 2020 by Bopper

[Bopper 2446]

Revision History:

2020 Jul 24:  Initial Document

2020 Aug 1:  Minor updates to some of the tools

• Corrected Formatting on Cancel-On-Miss to better handle 100% probability to tick. Also extended max ticks from 30 to 75.
• Corrected a bug in Recharge Calculator that would result in a broken formula if there are no Temporary Buffs. Should be working now.

2020 Aug 3:  Added chart to Proc Probability Calculator (PPM) to show damage for Regular and Epic Damage Procs from levels 1-50.

2020 Aug 8:  Added new calculator to PPM. The Proc or DMG Enhancement calculator will calculate the equivalent amount of added damage a proc provides to help you determine if it's more optimal to slot the proc or to slot a damage enhancement. Thanks @Replacement for the addition.

 

2020 Sep 1:  Various Bug Fixes

• Corrected the Resistance/Debuff Calculator to properly calculate Final Resistance when Unresistable Resistance Debuffs are applied. Thank you @Elmyder for bringing this to my attention.
• Corrected the Survivability Tool and HP/Regeneration Proc Cheat Sheet to properly reflect the fact Arachnos have a base regeneration of 10 seconds as opposed to 12 seconds. Thank you @macskull, @Gulbasaurand @Vandenfor your assistance with this.

2020 Sep 5:  Added two new fields to the Proc Probability Calculator (PPM)

• (Input) Desired Proc Probability - User inputs the amount they want their Proc to perform at (typically this is 90%, the max)
• (Output) Desired Allowed Recharge - The amount of recharge to slot to achieve the Desired Proc Probability.

2020 Dec 13:  Updated the Survivability Tool to v3.0

• Added Mastermind's Bodyguard Mode to reflect spreading damage across pets.
• Incorporated Purple Patch to modify the strength of enemy damage, to-hit debuffs, and damage debuffs. Previously, it was assumed the numbers entered in the spreadsheet to be post-purple patch. Now it is pre-purple patch.

Edited December 14, 2020 by Bopper

[Bopper 2446]

(reserved)

[senseichen 10]

Awesome, looks great!

I was just throwing together a basic PPM spreadsheet to point people to.

 

It would be cool if you could add info on the damage proc amount for each type/level ( or just level 30 and level 50?) so people can compare proc damage vs damage enhancements.

[Bopper 2446]

2 hours ago, senseichen said:

Awesome, looks great!

I was just throwing together a basic PPM spreadsheet to point people to.

 

It would be cool if you could add info on the damage proc amount for each type/level ( or just level 30 and level 50?) so people can compare proc damage vs damage enhancements.

Thanks. Do you mean the scaled damage for a proc at various levels? I only know of the 107.1 damage and 71.75 damage (level 50 values). Are you wanting to see how much damage they do from level 1 to 50? 

[senseichen 10]

Just having the 107.1 and 71.75 as a note on that proc page would help people plan/compare I think.  If we have the data for other levels, that would be great, but the level 50 values are enough.

[Bopper 2446]

1 hour ago, senseichen said:

Just having the 107.1 and 71.75 as a note on that proc page would help people plan/compare I think.  If we have the data for other levels, that would be great, but the level 50 values are enough.

Ok, take a look at the update. Let me know if that does what you're looking for. 

[senseichen 10]

Awesome!  Thanks.

 

I really like the "force a copy" link into Google Sheets/Docs, too.  I'm going to start using that. 🙂

[Bopper 2446]

New addition to the suite of tools. @Replacement has added the Proc or DMG Enhancement Calculator that allows you to compare the benefits of slotting a damage proc by putting its contributions in terms of equivalent damage enhancement percentages.

 

Steps for using the new calculator:

1. The user first inputs the base damage of their attack power. This should be the unenhanced damage for your character at the level you want to analyze.
2. Select your character's level. This will lookup the correct Proc damage at that level and will compare to the base damage the user input (see step 1).
3. The user inputs the PPM of the Standard and/or Epic Damage Proc they want to analyze. This does not need to be the same PPM used in the PPM calculators. So if you were looking up proc probabilities for a Force Feedback proc (2PPM), this calculator will still use the parameters in the calculator (cast, recharge, etc) but will swap the FF proc's PPM with this new PPM.
4. The tool will then take the parameters from the Click-Power, Auto/Toggle/Pseudopet, and Chain-Power calculators and use the PPM values for Standard and Epic (see step 3) to calculate the correct proc probabilities and convert it to an equivalent damage enhancement percentage.

 

*Note, this is still early and changes may occur on this tool (as I have updated the tool while writing this post). I'll keep this post updated with any changes that may occur.

Edited August 8, 2020 by Bopper

[Bopper 2446]

New update. Added various bug fixes.

[Bopper 2446]

Updated the Survivability Tool to version 3.0 and incorporated it into the CoH Tools and Formulas spreadsheet. Please let me know if there are any bugs, as the formulas have gotten quite busy and I may have missed a variable in a formula somewhere.