Korak
First Post
Upgrade complete
I have the expected damage formula corrected now to account for the situations where a 20 auto hits, and a 17-20 will confirm, and to properly handle the situations where a 20 autohits, and only a true 20 will confirm. It will take me a few minutes to propagate it through the whole spreadsheet and redo the results. Thanks for the extra sets of eyes. When you get stuck in those formulas you can sometimes forget an important detail.
Here it is. In the case mentioned above, the difference was minimal: the power critical build lost 4 points on average on the hasted full attack, still a significant upgrade. I also plugged in a level 8 melee with +17 to hit and +11 to damage with a keen greataxe versus an ac 23 target, subject to crits of course: w/o power critical, avg dmg = 44 on hasted full attack... with power critical, avg dmg = 58.
I'll parse out the part of the formula that adds critical hit damage. Threat Range for this formula = the lowest number that will crit i.e. 18 for a scimitar.
If AC-AtkBonus > 23, then add (0.0025 * additional crit damage) + expected average damage,
else if AC-AtkBonus > 19, then if PowerCritical = Yes, add ((0.05 * ((25-(AC-AtkBonus)) * 0.05)) * additional crit damage) + expected average damage,
else add (0.0025 * additional crit damage) + expected average damage,
else if AC-AtkBonus < 3, then add (0.95 * ((21-ThreatRange)*0.05)) * additional crit damage + expected average damage,
else add ((1-((AC-AtkBonus)/20))*(((21+(4*PowerCritical[0 or 1])-ThreatRange)*0.05) * additional crit damage) + expected average damage
I also have a factor in there that will set additional crit damage to 0 if the target is not subject to crits.
Play around, let me know if I missed anything.
I have the expected damage formula corrected now to account for the situations where a 20 auto hits, and a 17-20 will confirm, and to properly handle the situations where a 20 autohits, and only a true 20 will confirm. It will take me a few minutes to propagate it through the whole spreadsheet and redo the results. Thanks for the extra sets of eyes. When you get stuck in those formulas you can sometimes forget an important detail.
Here it is. In the case mentioned above, the difference was minimal: the power critical build lost 4 points on average on the hasted full attack, still a significant upgrade. I also plugged in a level 8 melee with +17 to hit and +11 to damage with a keen greataxe versus an ac 23 target, subject to crits of course: w/o power critical, avg dmg = 44 on hasted full attack... with power critical, avg dmg = 58.
I'll parse out the part of the formula that adds critical hit damage. Threat Range for this formula = the lowest number that will crit i.e. 18 for a scimitar.
If AC-AtkBonus > 23, then add (0.0025 * additional crit damage) + expected average damage,
else if AC-AtkBonus > 19, then if PowerCritical = Yes, add ((0.05 * ((25-(AC-AtkBonus)) * 0.05)) * additional crit damage) + expected average damage,
else add (0.0025 * additional crit damage) + expected average damage,
else if AC-AtkBonus < 3, then add (0.95 * ((21-ThreatRange)*0.05)) * additional crit damage + expected average damage,
else add ((1-((AC-AtkBonus)/20))*(((21+(4*PowerCritical[0 or 1])-ThreatRange)*0.05) * additional crit damage) + expected average damage
I also have a factor in there that will set additional crit damage to 0 if the target is not subject to crits.
Play around, let me know if I missed anything.
Attachments
Last edited: