Page 1 of 1

Damage Calculator & Heal Calculator

Posted: Wed Mar 05, 2025 8:47 pm
by leftayparxoun
Good evening,

I made a Damage Calculation tool that is able to accurately predict all important damage figures about any ability applied on any target(as long as both of them are level 40).

Link to the spreadsheet: Damage Calculator

Edit: Also made a Heal calculator (for non-lifetap heals) too: Heal Calculator

The results can at most be 1 or 2 damage points off due to the game rounding down numbers at various points in the actual calculation.
To use it, you have to manually plug in a handful of required stats for the attacker, the target and the ability used.
  • The attacker stats can be found by using the .getstats command in game
  • The target's stats can either be calculated manually (e.g. from killboard) with assumptions regarding tactics and renown points. Alternatively you can take them from the "Enemy Templates" sheet where I have compilled some indicative stats for engame wb builds of each role.
  • The ability information can be easily calculated for any skill by following the 11 step process described in the "How to fill in the Ability section" sheet (should take around a minute for one ability)
Other than that you just have to follow the instructions and fill out all input cells correctly in the ''Calculation'' sheet.
Here is an example of the results the tool provides:
Image
(The guard/detaunt and challenge are dynamic toggles to see how the damage changes if either or both of them are applied)

If you think anything is missing or have any other questions/suggestions then please leave a comment.
Enjoy

Re: Damage Calculator

Posted: Fri Mar 21, 2025 10:10 pm
by leftayparxoun
Updated the calculator with an extra toggle for proc damage calculation (in the Results section of the "Calculation" sheet)
Image

Procs are normally unaffected by damage% bonus modifiers, with the exception of damage% boosts from Gear set bonuses (because engine limitations did not allow it to be coded otherwise).
This basically only comes up for builds that include the Dps class Triumphant 6pc bonus and a couple other cases.

Example of a set bonus which boosts proc damage:
Image

To facilitate that calculation I had to split up the Damage Bonus% input cells and it does look less pretty, but it will allow for seamless calculation of proc damage in all cases without the need for manual correction of the results.

Image

Re: Damage Calculator

Posted: Fri Mar 21, 2025 10:48 pm
by Fey
He's a witch! Get an axe.

Re: Damage Calculator

Posted: Sat Mar 22, 2025 2:12 am
by NelsonPalmer
leftayparxoun wrote: Wed Mar 05, 2025 8:47 pm Good evening,

I made a Damage Calculation tool that is able to accurately predict all important damage figures about any ability applied on any target(as long as both of them are level 40).

Link to the spreadsheet: Damage Calculator

The results can at most be 1 or 2 damage points off due to the game rounding down numbers at various points in the actual calculation.
To use it, you have to manually plug in a handful of required stats for the attacker, the target and the ability used.
  • The attacker stats can be found by using the .getstats command in game
  • The target's stats can either be calculated manually (e.g. from killboard) with assumptions regarding tactics and renown points. Alternatively you can take them from the "Enemy Templates" sheet where I have compilled some indicative stats for engame wb builds of each role.
  • The ability information can be easily calculated for any skill by following the 11 step process described in the "How to fill in the Ability section" sheet (should take around a minute for one ability)
Other than that you just have to follow the instructions and fill out all input cells correctly in the ''Calculation'' sheet.
Here is an example of the results the tool provides:
Image
(The guard/detaunt and challenge are dynamic toggles to see how the damage changes if either or both of them are applied)

If you think anything is missing or have any other questions/suggestions then please leave a comment.
Enjoy
The level of detail and accuracy is really impressive, especially with the dynamic toggles for guard, detaunt, and challenge. Having the enemy templates for endgame builds is a great addition too. Thanks for sharing this. I'll definitely give it a try!

Re: Damage Calculator & Heal Calculator

Posted: Tue Apr 29, 2025 4:05 pm
by leftayparxoun
Also made a Heal calculator (for non-lifetap heals) too: Heal Calculator

Main post and title have been updated accordingly