Corsair Calculator

It doesn't work with Excel for me.

Did you re-download it after I said to?

very nice, i especially like the hits to kill part, said i 2hko skeles 99.99% and ohko them 0.01% lol... seams a little more than once per 10K tho >.>

Thank you. After you said this, I spent a while thinking about what might be wrong with that, because I had noticed a similar problem with 2HKOing Oblivion monks, but I didn't think anything of it. After some investigation, I figured out what the problem is and fixed it accordingly. I'm working on applying it to all my stuff and I'll have the corrected version up as soon as I finish.

What I had been doing is taking a base chance to KO the monster (In this case, the % of your damage range that's over the amount each hit needs to do) and putting it to the power of a modifier for that number to account for multiple hits being subject to the Law of Large Numbers. The problem is that I was using this modifier even if the attack was only hitting once (e.g. the first Air Strike on a monster).

 Math for those interested

Key
hits = The number of hits the attack does. For example, Burst Fire is always 3.
attacks = The number of the attack on the monster. If you've hit the monster once already this is your second attack, so it would be 2.
b10 = monsterHP/(hits*attacks)
All references to damage are the min, max, and average damage for that skill, not from your damage range.

Old Formula(this is all one line)
=IF(minDmg*hits*attacks<monsterHP; IF(maxDmg*hits*attacks>=monsterHP; IF((B10-minDmg)/(avgDmg-minDmg)<1; 1-(((B10-minDmg)/(avgDmg-minDmg))^(hits*attacks))*(B10-minDmg)/(maxDmg-minDmg); ((1-((B10-minDmg)/(avgDmg-minDmg)-1))^(hits*attacks))*(B10-minDmg)/(maxDmg-minDmg));0);1)

New Formula
=IF(minDmg*hits*attacks<monsterHP; IF(maxDmg*hits*attacks>=monsterHP; IF((B10-minDmg)/(avgDmg-minDmg)<1; 1-(((B10-minDmg)/(avgDmg-minDmg))^(hits*attacks-1))*(B10-minDmg)/(maxDmg-minDmg); ((1-((B10-minDmg)/(avgDmg-minDmg)-1))^(hits*attacks-1))*(B10-minDmg)/(maxDmg-minDmg));0);1)

I bolded what I changed to fix it.

Anyway, the change I'm about to make will affect Torpedo the most. More specifically, you'll see all numbers below 50% increase, and all numbers above 50% decrease (for all skills).


EDIT
Okay, I fixed it. The first post was updated with the link. Sorry to all who just re-downloaded it, you'll have to re-re-enter your stats/equips.
Corsair Calcs v1.41 (Open Office)
Corsair Calcs v1.41 (Excel)