150 replies to this topic

[CptCheez]

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

[GORDONYZ]

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

 Always wondered why I could not penetrate I have the wrong gun.......

[putnamJavi]

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

putnamJavi, 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!

[hson_hson]

Aim time for IS-7 is 2.9

RoF for Maus and E100  with 128mm gun is 4.62 

[CptCheez]

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

[hson_hson]

Strange, at the time when I posted it they were not correct in the spreadsheet...

[CptCheez]

Updated spreadsheet to reflect all of the Patch Note changes in update 2.2.

[flamingsword1]

Thank you do much for this! It's super useful

[PrairieGunner]

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]

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

[SERIOUSLY04]

I need help. I bought 2900 gold, and it didn't show up. Suggestions?

[bg2b]

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]

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

[CptCheez]

Static2k, on 12 February 2016 - 11:13 AM, said:

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

 

Done!

[Flying_Cod]

Cheez,

 

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

[ItsAsylum]

Awesome stuff, dude.  Thank you for this.. 

[MarBearCat]

CptCheez, 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

[CptCheez]

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