The "Power Attack Calculator" 3.11 MB zipped Excel spreadsheet compares the average melee attack damage/round of a 3.5 Edition Dungeons and Dragons character, wielding his or her choice of Player's Handbook (PHB) weapons, inflicted against armor class values 10-50. The "comparison" worksheet is the only one not hidden, and is where the character and weapons may be parameterized; these are the yellow fields.
The spreadsheet also determines the optimum Power Attack (PA) value which maximizes the average damage/round
Nearly all combat feats and class inherent abilities from PHB, PHBII, Complete Warrior, Complete Adventurer, and Miniatures Handbook directly affecting melee attack roll, damage, and # attacks are included in the calculation and can be selected as desired. Many additional feats and prestige classes offered in core and supplemental resources can be exactly modeled in the spreadsheet with proper parameterization. The opponent's Damage Reduction and immunity to critical hits, attack modes Standard Attack and Charge Attack, and number of Attacks of Opportunity can also be selected as desired.
The "Generalized PA Calculator" 5.38 MB zipped Excel spreadsheet does not explicitly handle any feats, abilities, fighting styles, and weapon qualities. Instead you'll have to do the work in setting 12 parameters for each of up to 20 attacks. In doing so, you can model any conceivable character with exactness. Though the original spreadsheet can model many class/prestige class/feat list/weapon wield combinations, it ultimately cannot deliver this level of flexibility. Optimum PA values can be taken up to 40 for Epic characters (valid or not), and the AC range for calculations is 10-65.
Please download these spreadsheets and modify them as you see fit. To view their brains, you'll need to "unhide" the other calculation sheets by selecting Unhide from the Format-Sheet dropdown menu. Future updates/corrections made by me will be implied in the file name as a version suffix, and will also be annotated below.
Thanks to Wizards of the Coast for a wonderful product. This is not an official site of Wizards of the Coast.
Email me with suggestions/questions
Update 2/8/07: Generalized PA Calculator sheet added. It's big. See text above.
Update 8/18/06: Added 12d4 calculations to the "Rolls" hidden worksheet to accommodate such scenarios as critically hitting with a 2d4 x3 weapon while utilizing Overpowering Attack.
Update 7/18/06: Corrected the Main-Hand Weapon # of Generic Extra Attacks/per AoO Attack. This parameter now adds to every AoO specified in Attack Description.
Update 7/15/06: Corrected the Overpowering Attack 2nd weapon = 0 None snafu
Update 7/12/06: Many changes from v6 including the implementation of several new feats and abilities, Attack of Opportunity incorporation, as well as fixes to Smite + Haste and Flurry of Blows + Two-Weapon Fighting. Henceforth the two character comparison worksheet is not available.