Reply to thread

Message

<blockquote data-quote="DrSpunj" data-source="post: 1338600" data-attributes="member: 994">Nope, I *think* that's what I did, though admittedly not as elegantly as your single equation. Still, I wanted to be able to alter the Crit Range and Multiplier easily to look at different scenarios.&nbsp;Now, I do wish I knew how to put Power Critical (from CW, gives a +4 to confirm a threat) into the equation. That was the single CW feat I chose for the 2HF (I figured the Archer had IRS, so why not) originally, but wasn't sure how to alter the equation to account for an increased chance to confirm.&nbsp;Any help there? Any problems with the way I did it in my spreadsheet? BTW, I know the damage calculation at the bottom is UGLY, but I worked several examples out by hand, and I believe it's functional. If I decide to put a lot more time in this I'll break down each IF formula into it's own cell on another Sheet and just bring over the total to the front one.&nbsp;Thanks.&nbsp;DrSpunj</blockquote>

[QUOTE="DrSpunj, post: 1338600, member: 994"] Nope, I *think* that's what I did, though admittedly not as elegantly as your single equation. Still, I wanted to be able to alter the Crit Range and Multiplier easily to look at different scenarios. Now, I do wish I knew how to put Power Critical (from CW, gives a +4 to confirm a threat) into the equation. That was the single CW feat I chose for the 2HF (I figured the Archer had IRS, so why not) originally, but wasn't sure how to alter the equation to account for an increased chance to confirm. Any help there? Any problems with the way I did it in my spreadsheet? BTW, I know the damage calculation at the bottom is [b][i]UGLY[/i][/b], but I worked several examples out by hand, and I believe it's functional. If I decide to put a lot more time in this I'll break down each IF formula into it's own cell on another Sheet and just bring over the total to the front one. Thanks. DrSpunj [/QUOTE]

Verification