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