Jump to content


All tank guns in one spreadsheet

damage dpm guns

  • Please log in to reply
150 replies to this topic

CptCheez #101 Posted 10 September 2015 - 07:50 PM

    This Space Intentionally Left Blank

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

View PostGORDONYZ, on 10 September 2015 - 03:39 PM, said:

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

 

All of the above things have been noted.  I couldn't find a clean way to represent different ammo types.  If people want to see HE/Premium dmg & pen, this is not the intended resource for that information.  Upgraded turrets can change ROF, and I've stated that this spreadsheet is only intended to represent the upgraded turret info.  Again, no clean way to display both.

 

I started building this sheet when I was a new player here, simply because I had gotten to the KV-1 and could not decide on the best gun from the way the info was displayed in the game.  I shared it with a few people when it only had 8-9 tanks on it and was eventually convinced to fill it out for all tanks and post it publicly.

 

Cost of ammo is not and was never the intended purpose for this spreadsheet so was not included.

 

If you want to create your own resource that includes ALL of that stuff, please, be my guest. :)


Edited by CptCheez, 10 September 2015 - 07:51 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."


GORDONYZ #102 Posted 10 September 2015 - 08:27 PM

    Lance-corporal

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

View PostCptCheez, on 10 September 2015 - 07:50 PM, said:

 

All of the above things have been noted.  I couldn't find a clean way to represent different ammo types.  If people want to see HE/Premium dmg & pen, this is not the intended resource for that information.  Upgraded turrets can change ROF, and I've stated that this spreadsheet is only intended to represent the upgraded turret info.  Again, no clean way to display both.

 

I started building this sheet when I was a new player here, simply because I had gotten to the KV-1 and could not decide on the best gun from the way the info was displayed in the game.  I shared it with a few people when it only had 8-9 tanks on it and was eventually convinced to fill it out for all tanks and post it publicly.

 

Cost of ammo is not and was never the intended purpose for this spreadsheet so was not included.

 

If you want to create your own resource that includes ALL of that stuff, please, be my guest. :)

 

O7 to you! You must have tried hard to show more info. I agree it is not clean if you consider turret, but how about this?

Gun Ammo Types ROF Damage Pen DPM Ammo Cost Ammo Capacity Dispersion Aiming Time
105 mm M4 HE/HEAT 8.02 400/250 30/102 3208/2005 166/4000 xx 0.55 2.3
90 mm Gun M3 AP/APCR/HE 8.49 225/225/270 160/243/45 1910/1910/2292 255/4400/255 70 0.38 2.3


Stealth_T49 #103 Posted 14 September 2015 - 01:07 PM

    Junior Sergeant

  • Players
  • 79038 battles
  • 161
  • [MASHU]
  • Member since:
    10-23-2014
 Always wondered why I could not penetrate I have the wrong gun.......

[MASHU] TEAMSPEAK  mashu.teamspeak3.com:3736  come visit

 

 


putnamJavi #104 Posted 14 September 2015 - 04:44 PM

    Senior Sergeant

  • Players
  • 18946 battles
  • 935
  • Member since:
    06-28-2014

View PostCptCheez, on 10 September 2015 - 02:50 PM, said:

 

All of the above things have been noted.  I couldn't find a clean way to represent different ammo types.  If people want to see HE/Premium dmg & pen, this is not the intended resource for that information.  Upgraded turrets can change ROF, and I've stated that this spreadsheet is only intended to represent the upgraded turret info.  Again, no clean way to display both.

 

I started building this sheet when I was a new player here, simply because I had gotten to the KV-1 and could not decide on the best gun from the way the info was displayed in the game.  I shared it with a few people when it only had 8-9 tanks on it and was eventually convinced to fill it out for all tanks and post it publicly.

 

Cost of ammo is not and was never the intended purpose for this spreadsheet so was not included.

 

If you want to create your own resource that includes ALL of that stuff, please, be my guest. :)

 

Actually, it's already been created for you.  LINK HERE

 

Simply select your tank type, tier, and nation and then click on the Blue button. 

 

It will display all the tanks at that option.  So for example, tier 5 US medium will display 2 premiums and the M4 with up to 30 unique configurations.  Click the configuration you're interested in and it will take you to a more detailed view with specific info.  Applies to ammo effects as well as you can see with the Tier 9 Conqueror using top gun and HESH rounds



CptCheez #105 Posted 14 September 2015 - 05:01 PM

    This Space Intentionally Left Blank

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

View PostputnamJavi, on 14 September 2015 - 12:44 PM, said:

Actually, it's already been created for you.  LINK HERE

 

Simply select your tank type, tier, and nation and then click on the Blue button. 

 

It will display all the tanks at that option.  So for example, tier 5 US medium will display 2 premiums and the M4 with up to 30 unique configurations.  Click the configuration you're interested in and it will take you to a more detailed view with specific info.  Applies to ammo effects as well as you can see with the Tier 9 Conqueror using top gun and HESH rounds

 

Thanks for linking that, PJ.  That's a lot more complicated than I wanted my spreadsheet to be, which is why I created it as simplistic as I did.  But more resources with more info is always good!


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


hson_hson #106 Posted 25 September 2015 - 05:51 AM

    Sergeant

  • Players
  • 1092 battles
  • 320
  • [EUREF]
  • Member since:
    11-01-2014

Aim time for IS-7 is 2.9

RoF for Maus and E100  with 128mm gun is 4.62 


Spy from EU server, member of clan Valiant


CptCheez #107 Posted 27 September 2015 - 01:05 AM

    This Space Intentionally Left Blank

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

View Posthson_hson, on 25 September 2015 - 01:51 AM, said:

Aim time for IS-7 is 2.9

RoF for Maus and E100  with 128mm gun is 4.62 

 

Those are indeed true statements, and accurately reflected on the spreadsheet.  Not sure why you posted them here though...


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


hson_hson #108 Posted 27 September 2015 - 06:47 AM

    Sergeant

  • Players
  • 1092 battles
  • 320
  • [EUREF]
  • Member since:
    11-01-2014
Strange, at the time when I posted it they were not correct in the spreadsheet...

Spy from EU server, member of clan Valiant


CptCheez #109 Posted 07 October 2015 - 04:42 PM

    This Space Intentionally Left Blank

  • Players
  • 15398 battles
  • 6,798
  • Member since:
    07-08-2014
Updated spreadsheet to reflect all of the Patch Note changes in update 2.2.

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


flamingsword1 #110 Posted 08 November 2015 - 03:53 AM

    First Sergeant

  • Players
  • 10734 battles
  • 1,367
  • [KIND]
  • Member since:
    05-16-2015
Thank you do much for this! It's super useful

Join us on discord for epic countdowns, top-notch strategy, and a chill community! 


PrairieGunner #111 Posted 14 December 2015 - 04:23 PM

    Sergeant

  • Players
  • 27591 battles
  • 369
  • [III-R]
  • Member since:
    11-06-2014
Hey Cheese any chance of getting the new AC-1 Sentinel in the spreadsheet under UK mediums? :)

Edited by PrairieGunner, 14 December 2015 - 04:28 PM.


CptCheez #112 Posted 14 December 2015 - 07:55 PM

    This Space Intentionally Left Blank

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

View PostPrairieGunner, on 14 December 2015 - 12:23 PM, said:

Hey Cheese any chance of getting the new AC-1 Sentinel in the spreadsheet under UK mediums? 

 

Sure.  Send me a PM with a screenshot of the gun name/details.

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


SERIOUSLY04 #113 Posted 20 December 2015 - 11:31 PM

    Private

  • Players
  • 6405 battles
  • 3
  • [CCCP]
  • Member since:
    10-16-2015
I need help. I bought 2900 gold, and it didn't show up. Suggestions?


bg2b #114 Posted 19 January 2016 - 11:11 AM

    M4 Lifestyle

  • Players
  • 21070 battles
  • 2,350
  • [SPUD]
  • Member since:
    12-10-2015

Did the (tier V Russian) T-34 57mm gun get nerfed?  I was going to upgrade to it, but the game is showing me 12.55 as the rate of fire, not the 18.68 in the spreadsheet.

 

Edit: Sorry, I needed to upgrade the turret first.  After that it's showing 18.68.


Edited by bg2b, 19 January 2016 - 11:50 AM.


Static2k #115 Posted 12 February 2016 - 03:13 PM

    Senior Sergeant

  • Players
  • 28943 battles
  • 938
  • [SRT-]
  • Member since:
    07-02-2014
Hey Cheez! Any chance you can update with the new German lights?

 


CptCheez #116 Posted 12 February 2016 - 06:17 PM

    This Space Intentionally Left Blank

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

View PostStatic2k, on 12 February 2016 - 11:13 AM, said:

Hey Cheez! Any chance you can update with the new German lights?

 

Done!

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


Flying_Cod #117 Posted 17 February 2016 - 03:56 AM

    Senior Sergeant

  • Players
  • 27109 battles
  • 809
  • [III-C]
  • Member since:
    12-30-2014

Cheez,

 

Thanks for keeping this up.  I use it all the time.  Just wanted to let you know that your work is appreciated.  


 


ItsAsylum #118 Posted 06 March 2016 - 03:05 AM

    Lance-corporal

  • Players
  • 221 battles
  • 85
  • Member since:
    08-06-2015
Awesome stuff, dude.  Thank you for this.. 

MarBearCat #119 Posted 14 March 2016 - 01:47 AM

    Pennsylvania's Favorite Cat!

  • Players
  • 22553 battles
  • 12,257
  • [SDWA]
  • Member since:
    11-13-2015

View PostCptCheez, on 21 January 2015 - 01:17 PM, said:

Sheet has been updated with all the new British Heavy tanks.

 

Don't see the Excelsior here

 

 

Heavy Is The Cat That's Carried!


CptCheez #120 Posted 16 March 2016 - 02:08 AM

    This Space Intentionally Left Blank

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

View PostMarBearCat, on 13 March 2016 - 09:47 PM, said:

Don't see the Excelsior here

 

Yep, that's because it's a Premium.  I can't add Premiums unless it's a tank I bought, and I didn't buy the Excelsior.  If someone would like to send me a screenshot of the Gun, including name and all of its stats, I'd be happy to add it.

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






Also tagged with damage, dpm, guns

1 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users