Jump to content


All tank guns in one spreadsheet

damage dpm guns

  • Please log in to reply
150 replies to this topic

CptCheez #1 Posted 30 October 2014 - 07:11 AM

    This Space Intentionally Left Blank

  • Players
  • 15398 battles
  • 6,798
  • [III]
  • Member since:
    07-08-2014

*
POPULAR

Have you ever wanted to compare the different guns in a particular tank side-by-side to see which one is best to use?  Or compare different tier tank's guns?  Well, now's your chance because I've created a spreadsheet that does exactly this!  It is organized by tank type, so on one tab you'll see American Tank Destroyers, on another tab the American Mediums, etc.  Here's a link:

 

World of Tanks: Blitz tank guns spreadsheet

 

I included every tank in the Tech Tree, including the Premiums that can be purchased there.  I don't own any of the non-Tech Tree premium tanks (like the Fury, Ram, Super Pershing, etc.), so I don't have the info for those.  If you have one of those tanks and want to PM me the gun details, I'll be happy to add them in too.

 

Enjoy!


Edited by CptCheez, 07 October 2015 - 04:42 PM.

"When the going gets tough and the stomach acids flow, 
The cold wind of conformity is nipping at your nose.
When some trendy new atrocity has brought you to your knees
Come with us we'll sail the Seas of Cheese."


Panbun #2 Posted 30 October 2014 - 07:34 AM

    First Sergeant

  • Players
  • 8126 battles
  • 8,018
  • [PBKAC]
  • Member since:
    10-25-2012
Wow! That is a very impressive spreadsheet with details about all the guns - much better than the ones on the Blitz Wiki (which I believe are now outdated). Thanks for the hard work put into the spreadsheet. +1 and I'm following this for future reference. :honoring:


thunderthies #3 Posted 30 October 2014 - 07:45 AM

    Not a Hoax

  • Club Wargaming
  • 14051 battles
  • 3,865
  • Member since:
    07-02-2014
Wow, dude. Very impressive. It would be nice to see this pinned. 

Check out:   WoTB terms, phrases defined v. 2.0

Check out:    iMovie iOS video production tutorial

Check out:           WoTB beginner's guide, tactics

Check out:                   WoTB YouTube channels


mdana #4 Posted 30 October 2014 - 08:46 AM

    Sergeant

  • Players
  • 5259 battles
  • 300
  • Member since:
    06-28-2012

 

Nice work. Here's the stats for the KV-5 and the SuperPershing:


KV-5 (107mm ZiS-6M)

ROF: 6.50

Penetration: 125-209

Damage: 240-400

Dispersion: 0.43

Aiming Time: 2.9

 

SuperPershing (90mm T15E1)

ROF: 7.87

Penetration: 127-212

Damage: 169-281

Dispersion: 0.38

Aiming Time: 2.3

 

 


T18, T29, T34, T26E4 SuperPershing, M46 Patton, M103, T110E5

IS-3, IS-6, KV-4, KV-5, ST-I

Panther II, VK 45.02 B

Comet


Looney999 #5 Posted 30 October 2014 - 08:56 AM

    First Sergeant

  • Players
  • 6709 battles
  • 1,202
  • [III-Z]
  • Member since:
    06-30-2014

:great:Nice work!  

 

The Fury's gun is identical to the M1A2 76mm on the Easy 8. 

 

 


-Community Pledge Signer-

 

The only way I got to keep them Tigers busy is to LET THEM SHOOT HOLES IN ME!


_Obsidious #6 Posted 30 October 2014 - 09:51 AM

    Senior Sergeant

  • Players
  • 20192 battles
  • 908
  • [EPIC-]
  • Member since:
    06-16-2013
good work
 
"When I get home and people ask me,'Hey, Hoot, why do you do it, man? What are you? Some kind of war junkie? I won't say a goddamn word. Why? They won't understand. They won't understand why we do it. They won't understand that it's about the men next to you. And that's it. That's all it is."
 
You can not bleed with a man and not form a bond.

mehliveat #7 Posted 30 October 2014 - 09:54 AM

    First Sergeant

  • Players
  • 300 battles
  • 3,196
  • Member since:
    08-05-2014

Thanks, its gonna be real useful.

 

I cross posted this on SEA forums.

 

http://forum.wotblitz.asia/index.php?/topic/1066-all-tank-guns-in-one-spreadsheet/



mehliveat #8 Posted 30 October 2014 - 10:00 AM

    First Sergeant

  • Players
  • 300 battles
  • 3,196
  • Member since:
    08-05-2014

Pz.Kpfw. B2 740

German Heavy

4.7cm SA 35 L/34

ROF: 15.54

Penetration: 41-69

Damage: 45-75

Dispersion: 0.39

Aiming Time: 1.1

 

T-127

Russian Light

45mm 20KL 

ROF: 14.52

Penetration: 38-64

Damage: 41-69

Dispersion: 0.43

Aiming Time: 2.1

 

M3 Light

Russian Light

37mm M5

ROF: 15.67

Penetration: 36-60

Damage: 30-50

Dispersion: 0.46

Aiming Time: 1.9


Edited by mehliveat, 30 October 2014 - 10:28 PM.


generaldebris #9 Posted 30 October 2014 - 10:28 AM

    Lance-corporal

  • Players
  • 3907 battles
  • 25
  • [REDS]
  • Member since:
    06-26-2014

Awesome! Thanks, I was just trying to decide on gun for KV-1S and this really helps.



Radicalo #10 Posted 30 October 2014 - 10:31 AM

    First Sergeant

  • Players
  • 4808 battles
  • 1,630
  • Member since:
    07-31-2013

View Postmehliveat, on 30 October 2014 - 02:54 AM, said:

Thanks, its gonna be real useful.

 

I cross posted this on SEA forums.

 

http://forum.wotblitz.asia/index.php?/topic/1066-all-tank-guns-in-one-spreadsheet/

 

if you posted it on the SEA fourmes, you have to say:

 

1) I come from the NA server.

2) This is not mine, I got it off the NA server.

3) Do not give me credit for this the real owner is : CptCheez of the NA server.


Picture of stats not currently working, so I'll do this.

https://wotbstars.co...&geo=NA&lng=eng


Androyce #11 Posted 30 October 2014 - 10:44 AM

    First Sergeant

  • Players
  • 10107 battles
  • 3,557
  • Member since:
    07-02-2014
What about tanks where the turret used affects ROF and therefore DPM? They should have 2 sets of stats per gun. Are these stats with the initial or top turrets? Great stuff btw.


mehliveat #12 Posted 30 October 2014 - 10:55 AM

    First Sergeant

  • Players
  • 300 battles
  • 3,196
  • Member since:
    08-05-2014

View PostEpicMon6749, on 30 October 2014 - 09:31 PM, said:

 

if you posted it on the SEA fourmes, you have to say:

 

1) I come from the NA server.

2) This is not mine, I got it off the NA server.

3) Do not give me credit for this the real owner is : CptCheez of the NA server.

 

Did you even click on the link?

 

I linked it back here and mentioned CptCheez is the one who did it.



ApoC247 #13 Posted 30 October 2014 - 11:03 AM

    Senior Sergeant

  • Players
  • 13231 battles
  • 535
  • [VKILL]
  • Member since:
    06-15-2014
Great job very helpful.
A coward dies a thousand deaths,a hero only once! See you on the battlefield.

Fwarnt #14 Posted 30 October 2014 - 11:18 AM

    Grand Poobah

  • Players
  • 23637 battles
  • 99
  • [III-S]
  • Member since:
    06-27-2014
Well done CptCheez


 


 


microcarnage #15 Posted 30 October 2014 - 12:19 PM

    Sergeant

  • Players
  • 38777 battles
  • 335
  • [III-C]
  • Member since:
    07-09-2014
Awesome job cptn. 


someguyfromPitt #16 Posted 30 October 2014 - 12:37 PM

    Jeez Louise that one bounced

  • Players
  • 45347 battles
  • 4,227
  • [III-C]
  • Member since:
    07-12-2014

This is why your the Captain. Nice work. 

 

 

Lokks like like I should research a Russian medium next. Almost 3000 DPM on the 62A. 


Tier 10's: FV 183, T110E3, T110E4, T110E5, T57, M48, IS-4, IS-7, T-62a, Obj 140, Grille, BätChät 

 

There is only one TD and 183 is her name. 

I drive Joseph Stallon (IS) tanks for the win.


Guderian5266 #17 Posted 30 October 2014 - 12:58 PM

    Senior Sergeant

  • Players
  • 24771 battles
  • 541
  • [III-S]
  • Member since:
    07-07-2014

Well done CptCheez!

 


Community Pledge Signer


 


putnamJavi #18 Posted 30 October 2014 - 01:53 PM

    Senior Sergeant

  • Players
  • 18945 battles
  • 935
  • Member since:
    06-28-2014
Awesome job!  I def second this post to be permanently pinned.  :great:

Panzer_Leader_3 #19 Posted 30 October 2014 - 01:56 PM

    Sergeant

  • Players
  • 4643 battles
  • 323
  • [GTS]
  • Member since:
    02-22-2013

Two small errors in the GERMAN Heavies category:

E75's 128mm L55 isn't listed (Same gun as the E100, little bit worse ROF)

In the VK 30.01H, you have the Waffe listed as the 0724. It should be 0725.


 

I went to Closed Beta Testing, and all I got was this lame t-shirt.

Proud Signer of the Community Pledge.

...Sometimes, you make me ashamed of being that disembodied voice in your head.


sunbumy #20 Posted 30 October 2014 - 02:02 PM

    First Sergeant

  • Players
  • 22736 battles
  • 1,108
  • Member since:
    02-17-2012
What do you mean low DPM and high DPM, cause On most of thoose tier 10's the low and high DPM have almost a thousand damage diffrence 





Also tagged with damage, dpm, guns

1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users