Login

russian armor

The Grand Tank-AoE Damage Compendium

MMX
23 May 2020, 11:57 AM
#1
avatar of MMX

Posts: 999 | Subs: 1

Hey everyone,

some of you may remember the release of my little spreadsheet to calculate the AoE damage of ballistic and explosive weapons a couple of weeks ago. Kind of as an extension of this project, I've decided to compile a comprehensive dataset with the main gun AoE performance of the majority of the tanks in the game (excluding tank destroyers) versus infantry to serve as a easy tool for reference and comparison.

Who's the target audience:
Literally anyone - be it modders that want to test the impact of AoE or scatter changes to the total damage output of a unit, or players who, for instance, simply want to compare different units in terms of anti infantry performance.

What's included:
The spreadsheet contains the data for the average number of shots / average time required to kill a full-health 6-man squad in 3 clumped or spread-out formations and at different ranges (5, 20, 40 and 70 m (if applicable)) for a variety of tanks, as well as an easy-to-use interface to plot and compare the data.

For those of you who like to get lost in endless arrays of numbers (honestly, who doesn't?), the "Results Table" tab contains an overview of all simulation results in a handy table for - more or less - quick reference.


Results tab

A slightly more accessible representation can be found in the "Performance Graphs" tab, which contains a bar charts with the average S2K (left) and T2K (right) +/- SD for all units in the dataset, arranged in groups (heavies, mediums, lights, AA tanks, self-propelled assault guns and heavy tank destroyers).


Performance Graphs tab

The most important and hopefully most useful feature is accessible via the "Data Comparison" tab - an interface that allows a head-to-head comparison of up to 4 different units and offers a handful of graphs to help analyze and interpret the data.


Data Comparison tab


How to read/interpret the data:

Now most of the numbers in the spreadsheet, especially the "Results Table" and "Performance Graphs" tabs should be pretty much self-explanatory. The S2K and T2K values are the number averages +/- standard deviation from 5,000 repetitions for each tank x formation x range combination and should give a pretty accurate impression of the average performance and variance for each tank.

However, the graphs and some functions of the "Data Comparison" tab might need a little more explanation for those not too familiar with statistics:



Where to get the file:

The spreadsheet can be downloaded here!



As always, if you have any questions/suggestions or find errors let me know in the comments!

And, last but not least, special thanks to Hannibal for the fruitful discussions over the course this project.

-MMX-

EDIT 06/14:

- The ROF of the preWBP Pershing is currently too high since I forgot to set the proper winddown of 1 sec in the 'Data' sheet. Will be fixed in a future release.
23 May 2020, 12:03 PM
#2
avatar of Vipper

Posts: 13496 | Subs: 1

great work would it possible to add off map artillery also?
MMX
23 May 2020, 12:13 PM
#3
avatar of MMX

Posts: 999 | Subs: 1

jump backJump back to quoted post23 May 2020, 12:03 PMVipper
great work would it possible to add off map artillery also?


Thanks a lot! Yeah that's definitely possible. I actually planned to add the data for off-maps to the scatter calc for a while, but in the end didn't have the time (or motivation) to sift through the editor and add everything manually. However, with Stein Grenadier having compiled most of the data already in his speadsheet this might not be much of a problem anymore.
23 May 2020, 12:37 PM
#4
avatar of Hannibal
Senior Moderator Badge

Posts: 3118 | Subs: 2

That's all nice an such, but could you please redo all the data for all the infantry in all the formations? :snfPeter:

Just kidding, nice work! I am sure that it will serve as a good reference to check how vehicles perform against infantry.
MMX
23 May 2020, 12:53 PM
#5
avatar of MMX

Posts: 999 | Subs: 1

That's all nice an such, but could you please redo all the data for all the infantry in all the formations? :snfPeter:

Just kidding, nice work! I am sure that it will serve as a good reference to check how vehicles perform against infantry.


thanks man! oh and sry the t2k data for the su85 vs volks at max range didn't make it into the release... bc the calc is still running :D
23 May 2020, 13:00 PM
#6
avatar of Hannibal
Senior Moderator Badge

Posts: 3118 | Subs: 2

jump backJump back to quoted post23 May 2020, 12:53 PMMMX


thanks man! oh and sry the t2k data for the su85 vs volks at max range didn't make it into the release... bc the calc is still running :D

SU85 UP confirmed, balance team please buff.
24 May 2020, 15:44 PM
#7
avatar of Descolata

Posts: 486

Mmmm.... data.....
1 user is browsing this thread: 1 guest

SHOUT IT OUT!

No ProfanityNumber of ShoutsRefresh Shout Box
dasheepeh: no comic sans font for april 1st this year?
Today, 19:56 PM
Willy Pete: @Lady Xenarra this you? https://i.imgflip.com/3e4thi.jpg
Today, 02:53 AM
Lady Xenarra: Does anyone else think that USF needs buffs? It feels like they’re on life support sometimes
Today, 02:36 AM
Willy Pete: @Rosbone Ahh I missed that memo. I still think its a bad decision though. Adds frustration for players and isnt gonna make them that much money
Last Thursday, 15:46 PM
Rosbone: It is also good they left it free until after the free to play weekend. Points for that.
Last Thursday, 09:34 AM
Rosbone: But I agree, the cost to get a full decent Coh game pushing $115 US is not the best idea. Especially when it needs so much more work for casuals.
Last Thursday, 09:32 AM
Rosbone: To be fair, it was a thank you to early fans right? They said it was not free for long and it would become a pay DLC at some point.
Last Thursday, 09:30 AM
Willy Pete: Re-releasing free DLC so they can charge new players money for it. Brilliant marketing strategy :clap:
Last Thursday, 04:31 AM
Soheil: Coh2 still broken server ?
25 Mar 2025, 18:27 PM
Rosbone: Congrats to Relic. Looks like Coh3 has finally usurped Coh2 s the popular Coh. You smell terrific. :snfQuinn:.
24 Mar 2025, 02:46 AM
Nickbn: and again someone else replies. I mean come on guys. Give @adamírcz a chance
22 Mar 2025, 14:00 PM
Willy Pete: @Nickbn you didn't ask a question, and this is a chat box...
20 Mar 2025, 13:11 PM
Nickbn: @Rosbone it's incredibly rude to speak on someone elses behalf, especially when a question is directly adressed to them. I understand your passion for the subject at hand but I want to hear from him.
20 Mar 2025, 10:16 AM
Rosbone: @Nickbn No, I am just saying people should not be using any Relic owned forum since they have proven they ban anyone who says true things about Coh3.
18 Mar 2025, 19:01 PM
Nickbn: @Rosbone do you speak on his behalf? I didn't know. In that case keep us updated please.
18 Mar 2025, 16:47 PM
Rosbone: #RelicModdedEchoChamber
16 Mar 2025, 17:54 PM
Rosbone: @Nickbn True except, the only people on the Relic Discord/Reddit/Steam are brain washed monkey zealots. They wont even understand what @adamírcz is talking about. Anyone else is banned.
16 Mar 2025, 17:54 PM
Nickbn: @adamírcz might be a better idea to voice this to relic directly than to voice it here, in a shoutbox of a nearly deade fansite #justsaying...
16 Mar 2025, 16:36 PM
webdesign-muenchen-w: @Rosbone it is sick
14 Mar 2025, 22:09 PM
aerafield: @adamírcz aren't the first two disconnects free every day?
14 Mar 2025, 19:26 PM

Ladders Top 10

  • #
    Steam Alias
    W
    L
    %
    Streak
Data provided by Relic Relic Entertainment

Replay highlight

VS
  • U.S. Forces flag cblanco ★
  • The British Forces flag 보드카 중대
  • Oberkommando West flag VonManteuffel
  • Ostheer flag Heartless Jäger
uploaded by XXxxHeartlessxxXX

Board Info

472 users are online: 1 member and 471 guests
Rosbone
2 posts in the last 24h
11 posts in the last week
81 posts in the last month
Registered members: 53134
Welcome our newest member, Cuegbnc64
Most online: 2043 users on 29 Oct 2023, 01:04 AM