SantaClaws cant post here so im posting for him, if you have any questions/suggestions/corrections, either pm him on this forum(his username is NejTilSvampe or go to www.twitch.tv/bitey and ask him there.
Spreadsheet in question
https://docs.google.com/spreadsheets/d/1yYDiX77THpjA-hImu2eRLio-ayOvGnDEeorZgHAieVQ/edit#gid=0
I was listening to the stream www.twitch.tv/bitey, (Feel free to stop by and say Hi to BiteyBot). Bitey and Petire were discussing the efficiency of the Multibow in particular. I decided I would make a comprehensive chart so that we can actually reference some hard numbers rather than appeal to intuition or experiences.
I have shown the chart to some people, and some of them were a bit confused or sceptical about the numbers. So I made a post in an attempt to:
Adequately explain my methodology.
Allow you guys to help me find any potential errors.
Convince you that my numbers are correct.
Provide this information to anyone who might find it useful.
Just sharing a fun little math exercise with whomever might appreciate it.
The methodology used can be found here if you are interested.
This paper is an adaptation of the nosgoth spreadsheet wrt dirty bomb.
In short; this spreadsheet doesn’t just display the raw stats like damage and firerates of each gun in dirtybomb, it also calculates time-to-kill, amount of bullets, time spent reloading and more. Play around with the configurations.
Keep in mind: Your accuracies with each gun are likely not the same, as they all have different spreads and recoil, that’s why when comparing weapons you can adjust each individual weapons accuracy.
Many people when comparing weapons, simply start off by calculating the damage per second (DPS) of the weapons. I’d just like to start off by saying that for most purposes this is a good approximation. By no means am I saying that it is necessary to take the math any further than that. But for the sake of the exercise we will in this paper - and some of you may or may not find some of the findings interesting or surprising.
Special thanks to Xennma’s awesome help and advice and Syku’s tireless work of gathering all the information!
-SantaClaws