Reply to thread

Message

<blockquote data-quote="DrSpunj" data-source="post: 1338368" data-attributes="member: 994">Okay, I've probably done something wrong with this, but here's the Excel sheet I threw together this morning. It starts out with Nail's basic assumptions and 100% Full Attacks for both the Melee Master &amp; the Archer. However, it also allows you to manipulate a few things like the percentage of Single Attacks vs Charge Attacks (Assumption: the +2 AB you get from Charging you convert with Power Attack to +4 damage) vs Full Attacks so you can see how the numbers change.&nbsp;I've added a relatively &quot;basic&quot; critical damage component (like a range of 19-20/x2 gets you double damage 10% of the time), and the formulas at the bottom that figure out damage won't take into account more than 2 base attacks (though I'll probably go back and add a 3rd and 4th base attack to account for BABs greater than 9 at some point), but I added enough function that you can change the Ability scores, Magic Items/Weapons, how much to Power Attack, +/- WF/WS/GWF, Average Weapon Damage, Crit Range, Crit Damage, whether or not PBS is included in the Archer calculations (though it's either in or out of all of them), etc.&nbsp;It's not very pretty, and doesn't use menus and such, but I *think* it works. Please let me know if you find errors. I've highlighted the cells in gray that you can change, the rest of them are formulas or alter my basic assumptions.&nbsp;I did use this to compare a lot of situations, and I don't think IRS is overpowered, but that's a gestalt. As Nail posted above, this is currently set up to compare a Greatsword wielder with Improved Critical to an Archer with IRS. You can change it to look at a variety of Melee Masters and the outcome doesn't change much: Melee Master better at low ACs, Archer better at high ACs (usually &gt;30).&nbsp;Thanks.&nbsp;DrSpunj</blockquote>

[QUOTE="DrSpunj, post: 1338368, member: 994"] Okay, I've probably done something wrong with this, but here's the Excel sheet I threw together this morning. It starts out with Nail's basic assumptions and 100% Full Attacks for both the Melee Master & the Archer. However, it also allows you to manipulate a few things like the percentage of Single Attacks vs Charge Attacks (Assumption: the +2 AB you get from Charging you convert with Power Attack to +4 damage) vs Full Attacks so you can see how the numbers change. I've added a relatively "basic" critical damage component (like a range of 19-20/x2 gets you double damage 10% of the time), and the formulas at the bottom that figure out damage won't take into account more than 2 base attacks (though I'll probably go back and add a 3rd and 4th base attack to account for BABs greater than 9 at some point), but I added enough function that you can change the Ability scores, Magic Items/Weapons, how much to Power Attack, +/- WF/WS/GWF, Average Weapon Damage, Crit Range, Crit Damage, whether or not PBS is included in the Archer calculations (though it's either in or out of all of them), etc. It's not very pretty, and doesn't use menus and such, but I *think* it works. Please let me know if you find errors. I've highlighted the cells in gray that you can change, the rest of them are formulas or alter my basic assumptions. I did use this to compare a lot of situations, and I don't think IRS is overpowered, but that's a gestalt. As Nail posted above, this is currently set up to compare a Greatsword wielder with Improved Critical to an Archer with IRS. You can change it to look at a variety of Melee Masters and the outcome doesn't change much: Melee Master better at low ACs, Archer better at high ACs (usually >30). Thanks. DrSpunj [/QUOTE]

Verification