150 replies to this topic

[CptCheez]

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.

[Aivris]

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. 

[thunderthies]

Wow, dude. Very impressive. It would be nice to see this pinned. 

[mdana]

 

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

 

 

[Looney999]

Nice work!  

 

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

 

 

[_Obsidious]

good work

[mehliveat]

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]

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]

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

[Radicalo]

mehliveat, 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.

[Androyce]

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]

EpicMon6749, 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]

Great job very helpful.

[Fwarnt]

Well done CptCheez

[microcarnage]

Awesome job cptn. 

[someguyfromPitt]

This is why your the Captain. Nice work. 

 

 

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

[Guderian5266]

Well done CptCheez!

 

[putnamJavi]

Awesome job!  I def second this post to be permanently pinned.  

[Panzer_Leader_3]

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.

[__Karma]

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