Weapon damage spreadsheet, versus distance and time
Jan 28, 2019 22:41:03 GMT -5
kukurukukuk, Koalabear, and 8 more like this
Post by KomodoPie on Jan 28, 2019 22:41:03 GMT -5
[EDIT April 13, 2019: New version for 4.8 is now posted here: war-robots-forum.freeforums.net/thread/32204/ultimate-weapon-comparison-tool-version]
Because the in-game info on weapon damage doesn't tell you how much damage a weapon does over time, or how that damage varies with distance, I used the awesome info from the wiki to make this spreadsheet:
www.dropbox.com/s/aznpuks79qqob7m/War Robots%20Weapon%20Damage%20Spreadsheet.xlsx?dl=0
It's been very useful to me in deciding which weapons to invest in, and in thinking about builds, so I thought I should share it with all of you.
Hopefully it's self-explanatory, but just in case:
1) Each sheet in the spreadsheet is for a different weapon. I don't have all the weapons in there yet, but I might be persuaded to expand it (it's especially lacking the 1100m weapons and the homing missiles, because I wasn't interested in running those when I made it).
2) Each column is for a different distance from 50 to 1100 m, and as you go down a column you see the instantaneous damage per second and the cumulative damage over time. So you can see how Orkans do a lot of damage in the first few seconds and then turn into pea shooters, or how Avengers limp through the first few seconds and then really get spinning, or how the reload cycle of the Shredder affects its DPM compared to a Halo.
I like to flip back and forth between sheets to compare which weapon does more damage in a given time at a given distance. For example, I was surprised to learn that a Viper is better than a Dragoon at 500 m and about as good as an Avenger at 200 m, if you're willing to wait 5 seconds for the corrosion to fully set in.
I hope you find it helpful!
Because the in-game info on weapon damage doesn't tell you how much damage a weapon does over time, or how that damage varies with distance, I used the awesome info from the wiki to make this spreadsheet:
www.dropbox.com/s/aznpuks79qqob7m/War Robots%20Weapon%20Damage%20Spreadsheet.xlsx?dl=0
It's been very useful to me in deciding which weapons to invest in, and in thinking about builds, so I thought I should share it with all of you.
Hopefully it's self-explanatory, but just in case:
1) Each sheet in the spreadsheet is for a different weapon. I don't have all the weapons in there yet, but I might be persuaded to expand it (it's especially lacking the 1100m weapons and the homing missiles, because I wasn't interested in running those when I made it).
2) Each column is for a different distance from 50 to 1100 m, and as you go down a column you see the instantaneous damage per second and the cumulative damage over time. So you can see how Orkans do a lot of damage in the first few seconds and then turn into pea shooters, or how Avengers limp through the first few seconds and then really get spinning, or how the reload cycle of the Shredder affects its DPM compared to a Halo.
I like to flip back and forth between sheets to compare which weapon does more damage in a given time at a given distance. For example, I was surprised to learn that a Viper is better than a Dragoon at 500 m and about as good as an Avenger at 200 m, if you're willing to wait 5 seconds for the corrosion to fully set in.
I hope you find it helpful!
![](https://i.imgur.com/tNa1VMh.png")
