Upgrade your account to a Community Supporter account and remove most of the site ads.
Enchanted Trinkets Complete--a hardcover book containing over 500 magic items for your D&D games!

Reply to thread

Message: <blockquote data-quote="Korak" data-source="post: 1348667" data-attributes="member: 9781">Here is my average damage formula for an attack.  The logic part of it is expressed in an excel "if" statement, but I changed all the cell references to represent what each quantity is.  Hopefully the logic of the formula will become apparent with that change.=(IF((AC-(Attack Bonus-Power Attack))>2,(IF((AC-(Attack Bonus-Power Attack))>19,0.05,(1-((AC-(Attack Bonus-Power Attack))/20)))) ,0.95))*(Average Weapon Damage + Damage Bonus(Strength + Weapon Specialization + Divine Favor, etc) + Power Attack*Power Attack Multiplier + (Average Sneak Attack Damage and other types… e.g. elemental, if applicable) + (IF((AC-(Attack Bonus – Power Attack))>19,0.0025,(IF((AC-(Attack Bonus – Power Attack))<3,(0.95*(1.05-(Threat Range (expressed as the first number in the x-20 range e.g. 17 if the threat range is 17-20)*0.05))),((1-((AC-(Attack Bonus – Power Attack))/20))*((21-Threat Range)*0.05)))))*((Critical Multiplier - 1) * Subject_to_Crits? (1 if yes, 0 if no) * (Damage Bonus (as defined above) + Power Attack*Power Attack Multiplier + Average Weapon Damage)))As for power critical, you need simply make the following changes...=(IF((AC-(Attack Bonus-Power Attack))>2,(IF((AC-(Attack Bonus-Power Attack))>19,0.05,(1-((AC-(Attack Bonus-Power Attack))/20)))) ,0.95))*(Average Weapon Damage + Damage Bonus(Strength + Weapon Specialization + Divine Favor, etc) + Power Attack*Power Attack Multiplier + (Average Sneak Attack Damage and other types… e.g. elemental, if applicable) + (IF((AC-(Attack Bonus – Power Attack))>19,.05*.25,(IF((AC-(Attack Bonus – Power Attack))<3,(0.95*(1.25-(Threat Range*0.05))),((1-((AC-(Attack Bonus – Power Attack))/20))*((25-Threat Range)*0.05)))))*((Critical Multiplier - 1) * Subject_to_Crits? (1 if yes, 0 if no) * (Damage Bonus (as defined above) + Power Attack*Power Attack Multiplier + Average Weapon Damage)))The bolded changes take care of the increased chance to confirm.1.25-(Threat Range*0.05) is an equivalent expression to (25-Threat Range)*0.05 ...no real reason for having it appear in two different forms in the overall formula, I just felt like it, I suppose.  That is what happens when you add new features to old formulas over time <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile    :)"  data-smilie="1"data-shortname=":)" /> .My formula runs an if statement to divide attack rolls into those that hit on a 2+, those that hit only on a 20, and those that require rolls of 3-19.  Then it figures average damage for the basic hit.  Next it figures the chance for a crit, and the increase in damage for that crit.  It only applies the extra damage to the total if the user indicates that the target is subject to crits.The basic flow of the equation is this:=(IF ( ( AC - (Attack Bonus)) > 2 , (IF ((AC - (Attack Bonus)) > 19 , 0.05 , (1 - ((AC - (Attack Bonus)) / 20)))) , 0.95)) * (Average Damage + (IF ((AC - (Attack Bonus)) > 19, 0.0025 , (IF ((AC - (Attack Bonus)) < 3 , (0.95 * (1.05 -(Threat Range * 0.05))) , ((1 - ((AC - (Attack Bonus)) / 20)) * ((21 - Threat Range) * 0.05))))) * ((Critical Multiplier - 1) * Subject_to_Crits? * (Average Damage)))Here it is in more simplified terms:Avg Dmg = Chance to hit * Avg Dmg + Chance to Crit * Dmg on crit above a normal hit*** To make the changes for power critical into something the user can toggle... you just need to add a 0,1 flag and change the following.05*.25 to .05*((PowerCriticalFlag*.20)+.05)1.25-(Threat Range*0.05) to (1.05+(PowerCriticalFlag*.2))-(Threat Range*0.05)and(25-Threat Range)*0.05 to ((21+(PowerCriticalFlag*4))-Threat Range)*0.05***</blockquote>

Verification