Jump to content


All tank guns in one spreadsheet

Started by CptCheez, Oct 30 2014 07:11 AM
damage dpm guns

  • Please log in to reply
150 replies to this topic

mmohaupt #21 Posted 30 October 2014 - 02:07 PM

    Junior Sergeant

  •
  • Players
  • 11857 battles
  • 152
  • [III-R]
  • Member since:
    07-03-2014

This is what being iii is all about. Giving back and spreading knowledge. Thanks CptCheeze. 

 


HBFT #22 Posted 30 October 2014 - 04:25 PM

    Lance-corporal

  •
  • Players
  • 35 battles
  • 66
  • Member since:
    12-21-2012
Super sweet spreadsheet!  Pinned!

    Please read the WoT: Blitz Forum rules

    Find us on Facebook & Twitter!

fugu_face #23 Posted 30 October 2014 - 04:25 PM

    Senior Sergeant

  •
  • Players
  • 5268 battles
  • 983
  • Member since:
    06-26-2014
Nice job! I bet you put a great deal of time and effort into this! Thanks for something as helpful as this <O

Proud community pledge signer

The master of extreme ping

Medium addict and gold spammer

"This brew is making me belch flame, hey I could use that!"

Delta256 #24 Posted 30 October 2014 - 04:29 PM

    First Sergeant

  •
  • Players
  • 10087 battles
  • 5,770
  • [IMPR]
  • Member since:
    12-09-2013

The T34 premium is so awesome, its entry is in the Russian KV heavies. May want to shove it back in with the American heavies.

 

:P


I sometimes drive Warships too.

Russ56 #25 Posted 30 October 2014 - 04:33 PM

    Sergeant

  •
  • Players
  • 10294 battles
  • 416
  • Member since:
    06-28-2014
Yes, great spreadsheet CptCheez!  

Community Pledge Signer,

 

MSgt USAF Retired

CptCheez #26 Posted 30 October 2014 - 06:15 PM

    This Space Intentionally Left Blank

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

Thanks for all the feedback guys! For those who posted premium tank stats, I'll add those in tonight after I get home from my flight. Do me a favor and also let me know what tier/country/type those tanks are. For example, "Fury is VI/American/med". That'll help me get it on the right tab. 

 

For those that pointed out any errors, thank you and I'll get those fixed tonight as well. 

 

And by "low" and "high" damage, what I mean there is if a gun says the damage is "120-200", 120 would be the low and 200 the high. So the "Low DPM" would be the low DMG * ROF. Same for the "high DPM". Another way to read that would be "If RNGesus hates or loves me" :)

 

Of course, this is all for AP ammo, except for the guns that don't use AP.  I couldn't figure out a decent way to represent HE and premium rounds without it looking super messy. 


"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."

Captain_Dread #27 Posted 30 October 2014 - 06:17 PM

    Sergeant

  •
  • Players
  • 44758 battles
  • 301
  • [III-C]
  • Member since:
    07-06-2014
Great job Cpt Cheese!

 

"It's not the size of the dog in the fight, it's the size of the fight in the dog."  Mark Twain

 

 

Redmach #28 Posted 30 October 2014 - 06:24 PM

    Junior Sergeant

  •
  • Players
  • 5216 battles
  • 190
  • Member since:
    10-02-2011
Excellent resource!

d4X6nsU.gif

Officer in [DFNT]

Current Garage: M4A3E8, T29, Panther II, Tiger II, LTP, T-54, IS-3, IS-6, ISU-152, Comet, Churchill VII

Future Garage: Pershing, T29, Tiger II, E-50, LTP, T-62a, T-54, IS-7, IS-3, IS-6, ISU-152, Centurion 7/1, Conqueror

 

Tanka1949 #29 Posted 30 October 2014 - 08:05 PM

    Senior Sergeant

  •
  • Players
  • 5240 battles
  • 648
  • [WAR1]
  • Member since:
    06-26-2014
Nice!

CptCheez #30 Posted 30 October 2014 - 09:52 PM

    This Space Intentionally Left Blank

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

View PostDelta256, on 30 October 2014 - 12:29 PM, said:

The T34 premium is so awesome, its entry is in the Russian KV heavies. May want to shove it back in with the American heavies.

 

Thats what happens when you're working on a spreadsheet at 3 AM and using shortcuts like copy/pasta. I'll fix it tonight. :)

 

And yes, the T34 *IS* awesome!


"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."

Looney999 #31 Posted 31 October 2014 - 02:39 AM

    First Sergeant

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

A-32:

Russian Medium

76mm L-10U

Standard Damage 120-200

Standard Pen 49-82

ROF 5.18/min

Aim Time 2.3s

Dispersion 0.53

View Range 230m


Edited by Looney999, 31 October 2014 - 02:40 AM.

-Community Pledge Signer-

 

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

Player10005008 #32 Posted 31 October 2014 - 05:42 AM

    Lance-corporal

  •
  • Players
  • 45517 battles
  • 66
  • [FSHS]
  • Member since:
    07-07-2014

Well done, Capt!

 

Thank you.

 


 

Community pledge signatory

Senior Technical Engineer: All tanks researched in all tech trees (the old fashion way-earned it thru grinding 1 tank at a time)

acahir #33 Posted 31 October 2014 - 06:52 AM

    Junior Sergeant

  •
  • Players
  • 26339 battles
  • 239
  • [HUNT_]
  • Member since:
    07-03-2014

Nice! One crucial piece of info I didn't see in the list is Aim time. That can be very important, and I often look at that before dispersion. 

 

Another suggestion...for each column group, you could use conditional formatting to bold or color the best result? Prob too many tabs to do this to now, in Excel I believe you can select cells across multiple sheets all at once.


CptCheez #34 Posted 31 October 2014 - 04:10 PM

    This Space Intentionally Left Blank

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

View Postacahir, on 31 October 2014 - 02:52 AM, said:

Nice! One crucial piece of info I didn't see in the list is Aim time. That can be very important, and I often look at that before dispersion. 

 

Another suggestion...for each column group, you could use conditional formatting to bold or color the best result? Prob too many tabs to do this to now, in Excel I believe you can select cells across multiple sheets all at once.

 

I think the "Best result" is going to be different for every person.  Sure, I could pick which gun I think is the "best", but that's not going to be what everyone else things.  There's a always going to be a gun per tank with the highest DPM, but that same gun probably won't have the best Penetration.

 

This sheet is merely meant to be informative data that lets you pick whichever gun YOU think is best.  There are no assumptions or opinions made here. :)


"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."

_TheMessiah #35 Posted 31 October 2014 - 04:14 PM

    First Sergeant

  •
  • Players
  • 22912 battles
  • 1,477
  • Member since:
    06-24-2014
:great:+1

Check out my YouTube Channel for Gameplay vids!

CptCheez #36 Posted 31 October 2014 - 04:56 PM

    This Space Intentionally Left Blank

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

View PostAndroyce, on 30 October 2014 - 06:44 AM, said:

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.

 

Example?  I looked through a bunch of turrets just now, and I couldn't find any turrets that change the ROF.  I pulled ROF straight from each gun's stats.

 

View PostPanzer_Leader_3, on 30 October 2014 - 09:56 AM, said:

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.

 

Both fixed now, thanks!

 

View PostDelta256, on 30 October 2014 - 12:29 PM, said:

The T34 premium is so awesome, its entry is in the Russian KV heavies. May want to shove it back in with the American heavies.

 

:P

 

Fixed!

 

View Postacahir, on 31 October 2014 - 02:52 AM, said:

Nice! One crucial piece of info I didn't see in the list is Aim time. That can be very important, and I often look at that before dispersion. 

 

I personally never use that for selecting a gun, so I hadn't added it before, but I understand other people do see this as crucial info.  Aiming Time has been added now!


CptCheez #37 Posted 31 October 2014 - 05:00 PM

    This Space Intentionally Left Blank

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

View Postmdana, on 30 October 2014 - 04:46 AM, said:

KV-5 (107mm ZiS-6M)

 

SuperPershing (90mm T15E1)

 

I know the KV-5 is Russian Heavy and the Super Pershing is American Medium, but what tier?

 

View Postmehliveat, on 30 October 2014 - 06:00 AM, said:

Pz.Kpfw. B2 740

German Heavy

 

T-127

Russian Light

 

M3 Light

Russian Light

 

What tier are these 3?

 

View PostLooney999, on 30 October 2014 - 10:39 PM, said:

A-32:

Russian Medium

 

Tier?

 


"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."

_AzorAhai #38 Posted 31 October 2014 - 05:10 PM

    The IT guy

  •
  • Players
  • 44407 battles
  • 1,777
  • [PURPL]
  • Member since:
    05-25-2012

Kv-5 tier VIII

Super Pershing tier VIII

M3-light i believe is tier 3 or 2

T-127 i believe is tier 3

B2 tier IV

A-32 is i think tier IV


​

LYE Discord: DUX2Pr4 | Void Discord: yNVEZSH | Blitz Discord sR2X6Hp  

 

Click Image for My YouTube Channel

GenClint10 #39 Posted 31 October 2014 - 07:39 PM

    First Sergeant

  •
  • Players
  • 5827 battles
  • 1,139
  • Member since:
    06-21-2013
The highest damage the Ferdinand can do is 575 not 200.

Verios44 #40 Posted 31 October 2014 - 09:17 PM

    Sergeant

  •
  • Players
  • 8395 battles
  • 338
  • Member since:
    06-28-2014
M3 Light is tier 3
 
Back to Player Guides and Information



Also tagged with damage, dpm, guns

1 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

  1. World of Tanks Blitz official forum
  2. → Game Discussion
  3. → General Discussion
  4. → Player Guides and Information