Copy of Combat Scenario - Damage, Hit Chance and Enemy HP

This diagram uses a Google Sheet of weapon data from a shooter game to model a basic combat scenario. Its goal is to calculate the range of times each weapon takes to defeat the given enemy.