Jump to content


All tank guns in one spreadsheet

damage dpm guns

  • Please log in to reply
150 replies to this topic

CptCheez #81 Posted 26 March 2015 - 02:30 PM

    This Space Intentionally Left Blank

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

View Postalejo1965, on 25 March 2015 - 10:09 PM, said:

The T62A is crap has no firepower whole game is a farce all tanks loe take away power and shielding is pure business money and more money should want to improve the tanks I am very decilicionado

 

Aside from the T-62A having the highest Damage Per Minute rating of any other Tier X tank in the game...

 


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


mehliveat #82 Posted 31 March 2015 - 04:36 AM

    First Sergeant

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

Another stealth update.

 

The Crusader's ROF is now 18.75 for the MK5.  Thats like the highest DPM for tier 5 bar the derp guns.  Its just ever so slightly higher than the 57 on the T-34.

 

2.3 aim time and 0.34 accuracy, spam a few gold, and its better than the TDs lol.


Edited by mehliveat, 31 March 2015 - 04:51 AM.


CptCheez #83 Posted 31 March 2015 - 06:13 AM

    This Space Intentionally Left Blank

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

View Postmehliveat, on 30 March 2015 - 11:36 PM, said:

Another stealth update.

 

The Crusader's ROF is now 18.75 for the MK5.  Thats like the highest DPM for tier 5 bar the derp guns.  Its just ever so slightly higher than the 57 on the T-34.

 

2.3 aim time and 0.34 accuracy, spam a few gold, and its better than the TDs lol.

 

That wasn't actually a stealth update, that was an error in my spreadsheet. I accidentally entered the same value from the Mk. III gun twice.  It's fixed now.

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


mehliveat #84 Posted 31 March 2015 - 08:30 AM

    First Sergeant

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

View PostCptCheez, on 31 March 2015 - 04:13 PM, said:

 

That wasn't actually a stealth update, that was an error in my spreadsheet. I accidentally entered the same value from the Mk. III gun twice.  It's fixed now.

 

Are you sure?  I seem to remember the difference between the Mk3 and 5 were just the extra pen and accuracy? Just like how it is currently on Cromwell, ROF of 17.8 for both the Mk3 and Mk5. 

 

Either way, the Crusader's DPM is pretty awesome.  Top of tier 5 and on par with Cromwell's DPM.



Overload_ed #85 Posted 15 April 2015 - 11:54 PM

    Junior Sergeant

  • Players
  • 10621 battles
  • 115
  • [DREAD]
  • Member since:
    06-28-2014

Churchill VII.  75mm Vickers HV has a rate of fire of 9.5, not 8.5.  (With top turret)

 

 



CptCheez #86 Posted 16 April 2015 - 02:03 AM

    This Space Intentionally Left Blank

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

View PostOverload_ed, on 15 April 2015 - 07:54 PM, said:

Churchill VII.  75mm Vickers HV has a rate of fire of 9.5, not 8.5.  (With top turret)

 

Thanks, hadn't updated it with the turret upgrade info.  Fixed.


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


Tit_for_Tat #87 Posted 20 April 2015 - 01:06 PM

    Junior Sergeant

  • Players
  • 45919 battles
  • 127
  • [III-S]
  • Member since:
    08-15-2014

View PostCptCheez, on 30 October 2014 - 02:11 AM, said:

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!

 

EDIT: Also if there's enough demand for it, I can go back and add the aiming time for each gun too, since that's not in there (yet).

 

Wow super cool new discovery, thanks Cpt Cheez for putting that together, very useful, good work

Gil - Montreal    "Have Great tanks, TC and crew noob often - working on it" Also known as "Crinkles Fluffernut" the fearless tanker

"Do not protect yourself with a fence but rather with your friends."

 

 


PrairieGunner #88 Posted 25 May 2015 - 07:12 AM

    Sergeant

  • Players
  • 21634 battles
  • 369
  • [III-S]
  • Member since:
    11-06-2014
Seems like the numbers are still off since the patch. Also the Churchhill III is missing from Russian line still.

CptCheez #89 Posted 25 May 2015 - 01:20 PM

    This Space Intentionally Left Blank

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

View PostPrairieGunner, on 25 May 2015 - 03:12 AM, said:

Seems like the numbers are still off since the patch. Also the Churchhill III is missing from Russian line still.

 

What numbers?

 

The Churchill III is listed on both Russian Heavy tabs.


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


jasonmartincanada #90 Posted 03 June 2015 - 08:12 AM

    Junior Sergeant

  • Players
  • 13244 battles
  • 150
  • Member since:
    12-26-2014
This is great!!! Thank you

Tuberculosis_Victim #91 Posted 03 July 2015 - 09:47 AM

    Sergeant

  • Players
  • 6562 battles
  • 269
  • [_TT_]
  • Member since:
    12-13-2014

The damage per shot for the german heavy (maus) tier 2 and 3 tanks, 35 and 38 (t),  2cm guns still say 7 and 12. They were changed to 9 and 15 a long time ago. That has been bugging me for a while. Thanks.

 



CptCheez #92 Posted 06 July 2015 - 01:57 PM

    This Space Intentionally Left Blank

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

View PostTuberculosis_Victim, on 03 July 2015 - 05:47 AM, said:

The damage per shot for the german heavy (maus) tier 2 and 3 tanks, 35 and 38 (t),  2cm guns still say 7 and 12. They were changed to 9 and 15 a long time ago. That has been bugging me for a while. Thanks.

 

No need for anything to bug you for a while, just mention it and I'll fix it.  Thanks for pointing this out, I missed it a few patches ago.  All fixed now!

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


_Remi #93 Posted 08 July 2015 - 01:52 AM

    Lance-corporal

  • Players
  • 30835 battles
  • 24
  • [COD]
  • Member since:
    06-30-2014

I want a graph with y-axis being angle and x-axis being armour to find effective armour value, and have that be colour coded and placed on an exel sheet where you type in a calibre and a avg pen value, and the graph will show penetration probabilities. It is complicated I know, but if you do this, I will be really greatful.

 

I currently have a M48, T110e5, T110e4, T110e3, Tiger 2, Ferdiand, Ceanarvon, Comet. Looking forwards to introduction of FV215B183



CptCheez #94 Posted 08 July 2015 - 04:27 PM

    This Space Intentionally Left Blank

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

View Postjellyfishbelly, on 07 July 2015 - 09:52 PM, said:

I want a graph with y-axis being angle and x-axis being armour to find effective armour value, and have that be colour coded and placed on an exel sheet where you type in a calibre and a avg pen value, and the graph will show penetration probabilities. It is complicated I know, but if you do this, I will be really greatful.

 

I currently have a M48, T110e5, T110e4, T110e3, Tiger 2, Ferdiand, Ceanarvon, Comet. Looking forwards to introduction of FV215B183

 

There's already an app that does this, called Armor Inspector.

 

Apple: https://itunes.apple.com/us/app/armor-inspector-for-wot-pc/id905734645?mt=8

Android: https://play.google.com/store/apps/details?id=com.dreamfarmgames.wot.armorinspector.android2&hl=en


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


TitlessChicken #95 Posted 08 July 2015 - 06:18 PM

    Private

  • Players
  • 1935 battles
  • 3
  • Member since:
    05-07-2015

Now we have proof that ze Germans have the best turrets, thanks.

 



CptCheez #96 Posted 15 July 2015 - 01:15 AM

    This Space Intentionally Left Blank

  • Players
  • 15398 battles
  • 6,798
  • Member since:
    07-08-2014
Sheet has been updated with all of the 1.11 changes (new tanks, changes to existing tanks, etc.).

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


BoomMfer #97 Posted 25 July 2015 - 11:22 AM

    This space for rent

  • Players
  • 62317 battles
  • 1,690
  • Member since:
    01-13-2013
Thanks for keeping this updated Cpt!

CptCheez #98 Posted 09 September 2015 - 01:00 AM

    This Space Intentionally Left Blank

  • Players
  • 15398 battles
  • 6,798
  • Member since:
    07-08-2014
Sheet updated with the new British TD line.  The nerfs/buffs to existing tanks will be edited in tomorrow.

Edited by CptCheez, 09 September 2015 - 01:01 AM.

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


Bravo_2719 #99 Posted 09 September 2015 - 01:57 AM

    Private

  • Players
  • 9079 battles
  • 8
  • Member since:
    06-27-2014
Thats a really great spreadsheet man! May I suggest you add what type of ammunition each gun uses (e.g. KV-1 122 mm U-11 uses HE and HEAT shells only)  

 

                                                                                                                                                                                                                                                                                                                                                                                                                                                             


GORDONYZ #100 Posted 10 September 2015 - 07:39 PM

    Lance-corporal

  • Players
  • 14408 battles
  • 24
  • [OBDS]
  • Member since:
    12-01-2014

I hope whoever owns this sheet know that I appreciate this spreadsheet, but it has the below problem:

 

  1. Every gun's damage and penetration vary ±25% from average value. It has become redundant to list high/low pen and dmg, as well as DPM. One only need an average number.
  2. Only one type of ammo is listed -- people will expect to know HE dmg, HE pen and Pammo pen/dmg too.
  3. Different turret give you different ROF, dispersion and aiming time.
  4. Cost of ammo is not listed

I have research almost every tank and I can gather the above information and make it better.

 

I want to contribute to this forum. Pls. let me know your thoughts and if you agree, I will start the change.







Also tagged with damage, dpm, guns

2 user(s) are reading this topic

0 members, 2 guests, 0 anonymous users