Talk:Damage Calculator/@comment-15871805-20130901233514/@comment-15871805-20130906094132

I think I have finished my Hits to Kill formula. The damage order in the formula is based off of the results I posted on the Damage Order Research page. It includes everything, even Acrid DOT. All 4 seconds of DOT are accounted for, meaning the Hits to Kill represents exactly what would happen if you shot an enemy with an Acrid and waited for the DOT to end before shooting again.

The entire formula is enormous, 15 lines, even though most of it is array formulas. The Hits to Kill is different for medium Grineer, MOAs, and Other. Which means that it will not be as easy to maintain as the other formulas, but it was necessary becasue the damage order can be completely different for each of those groups of enemies. This also required 7x10 and 4x27 tables on a seperate sheet. I moved some the misc hidden calculations from the main sheet to that sheet as well.