Tank DPS spreadsheet

[Hacked Exhale]

NEW SHEET: https://docs.google.com/spreadsheets/d/1FhcfDZ5Tp-iBtzn03JNTmspvDnVimazLQfEVOiwvodU/edit?usp=sharing

Here you ♥♥♥♥ing go Alex.

https://docs.google.com/spreadsheets/d/1xvjPQtSAd9rTK6VGueQS9XWVpLEiaQh02zmA2JpltWg/edit?usp=sharing

This list will show you what every weapon (with a stat change) will do in DPS to a tank with a 800 credit interval.

Testing was done with as big a damage output as possible without inflicting self-harm. This means that all classes but Soldier and Demo are touching the tank while shooting, while Soldier and Demo is just outside the splash radius of their weapons. Crossbow medic was at max range.

No setup time was issued in this testing, which means that demo didn't have a stickytrap ready before the timer actually starts, nor does soldier have a barrage ready. I also didn't account for refilling time in the sentry DPS or time it takes for the medic to refill his shield. Probably more but I don't remember ATM.

Testing was also done without damagespread or random crits on, but I have provided the sheet with "crit mechanic" and "crit chance" to give you an idea of how often the weapons actually crit and how.


Now let me get this out now.
You WILL see some numbers that make you go "WTF! how can the DPS be this?? It doesn't make sense!" and lemme tell you - Valve can not code worth ♥♥♥♥. Every single DPS you see is 99% correct, there might be a 0-2% error margin but this is pretty much what you get with these upgrades.

For example - 2nd firing speed upgrade for miniguns have the same DPS as the 1st upgrade and at max firing speed the heavy's DPS is actually roughly 70% bigger.
Sentry firing speed is another interesting one.

All in all the sheet should give you an idea how powerful these classes are against tanks with the upgrades listed. Most of the list can also be used to see DPS against the robots.


Tell me if you see a mistake but make sure you know that it is wrong. Like I said, it WILL look wrong but it is true.


Edit: Planning on adding Minicrit, Critical and other similiar things later.

[Spython]

With a quick glance I only managed to notice you making a slight error on Engineer's primaries and the amount of reload speed upgrades they have.

[Hell-met]

fat

[Megative]

If that's really true, I'm surprised that wrangled upgraded level 3 sentry has monstrous tank dps, beating everything expect pyro.

[Botspan]

Remember that raw DPS doesn't taking into account Engineer having to relocate and refill Sentry along the tank.

[Draekon]

Thanks for taking the time to do this. I knew that the in game results would differ from the wiki even though I got made fun of here for saying it. I am not as good at making custom maps, etc to do something like this. I have done some testing with Bavarian with dummy server settings. I can say for sure that a heavy should not upgrade projectile penetration with the giant medics because you tend to hit the patient by accident to set off their uber. I trying to figure out how damage is calculated with the whole debate about scottish resistance damage and crits, but I am not getting anywhere.

[VGFM]

For shotgun/explosive weapons were you reloading the entire clip in one go or firing each round as soon as you reloaded it?

[Hacked Exhale]

Originally posted by Draekon:

I can say for sure that a heavy should not upgrade projectile penetration with the giant medics because you tend to hit the patient by accident to set off their uber.

This video might interest you.
https://www.youtube.com/watch?v=F9I6YT7kcyY

Originally posted by Zigzag the Grand Vizier VGFM:

For shotgun/explosive weapons were you reloading the entire clip in one go or firing each round as soon as you reloaded it?

Full reload

[wux]

Surprised beggar's is so far ahead of grenade launcher/loch n load, always felt they were closer than that when playing.

Nice work.

[Alexander]

<3

[Radioactive Panda]

Originally posted by wux:

Surprised beggar's is so far ahead of grenade launcher/loch n load, always felt they were closer than that when playing.

Nice work.

beggar never has to reload.. pretty big advantage

[Fumo Bnnuy n Frends]

thank you op i love you for this, now it makes it easier to guess which weapon and class to use on mvm for the tanks

[Radioactive Panda]

lol vs grenade dps surprised me

lvl 3 sentry. 2 firing speed = max lols

[Radioactive Panda]

bushwaker + buff banner is one of the best ways to kill tank coming in at 390? lol

[TF Comics #7 actually came out w]

Let me explain the firing speed mystery.
+40% faster firing is incredibly misleading. It actually reduces your firing-delay by 40%.

So rather than firing 140% bullets in 100% time, (Which would give 140% DPS)
You fire 100% bullets in 60% time. (Which gives roughly 166% DPS)

[Botspan]

Originally posted by Soon?:

Let me explain the firing speed mystery.
+40% faster firing is incredibly misleading. It actually reduces your firing-delay by 40%.

So rather than firing 140% bullets in 100% time, (Which would give 140% DPS)
You fire 100% bullets in 60% time. (Which gives roughly 166% DPS)

You only explained the way most firing speed upgrade works, not the full mystery of Sentry's firing speed.
https://www.youtube.com/watch?v=2sOTKPhbqbY