Hello all,
as frequent readers of the forums have probably noticed, I'm very fond of unit stats to the point that I do rarely accept debate positions that are not based on hard stats. So I wanna share a project that I've been developing over the last few weeks. I've already posted an old version quite some time ago, which basically did not get any response at all. Might have been due to the very long text I put in front of it, maybe because it was too complex if you just look at it.
Still, since I've put in a decent amount of time so far, and the sheet logic is developing to my satisfaction, I thought some might be interested. I've named the tool DeCoHde, as it seemed fitting for me to better visualize the blackbox that is CoH2. Basically, DeCoHde needs to be fed with the unit game stats and then calculates basic analysis for you at the press of a button.
It started out as a tank-on-tank warfare comparison tool, and that's what it mainly still is.
So, what's in there at the moment?
There is a pen-chance calculator. Ever wanted to know how big the pen chance against a certain target is? DeCoHde calculates all the pen chances for almost every vehicle in the game.
While first versions could only calculate the pen chance at the unit's max range, I've recently implemented the logic of range dependency of penetration into Excel. What you need to do is enter the desired range and the unit (currently the 57mm AT gun of USF). The sheet autopicks the correct stats and compares them to the armor of all units below.
Secondly, basically the heart of the sheet, tank comparison. This tool is already outdated due to recent data by DerbyHat where I had to learn that scatter hits in tank warfare differ wildly from what I believed to be true. Still, there's some truth in at least many other calculations of this tool.
The tool can visualize the range dependent performance of a theoretical battle between two tanks. Again, you need to enter the desired range and the two unit names, the stats are auto picked for calculation. We can see that the T34 performes much better compared to the P4 at close range. The "hits to kill enemy" is the most important value here, since it is basically the number of times your tank must hit the enemy on average to kill it. Basically it's hits-to-kill normalized to pen chance. As we cann see, at 40 range the T34 is vastly inferior to the P4, but it gains a lot of performance from closing in (from 9 shots down to 6,86), while the P4 gains almost nothing (5,45 down to 5,11).
Short note: All values below that are faulty due to scatter hit or wrong time between shots (at first I only accounted for the reload time and neglected other factors, not fixed yet). Also, I attempted to make cost correction for performance analysis, which you can see in a brief excerpt below for range 15.
Lastly, and the most recent addition I implemented while also being the most visually appealing: AoE analysis.
Enter up to four units of your choice and get the result both as a table and a graph.
The red horizontal line currently represents 80 HP, the threshold to kill a full health infantry model. Below the table, the kill radius for the respective unit above is calculated. The graph scales itself and visualizes the damage curve from the center in a side-to-side comparison of all units. Below the table, we can see that the Sherman Bulldozer must land a shot within 0,867 meters of a model to insta-kill, while the Brummbär has a bigger radius of 1,106 meters. Also, the StuGE can't kill a full health model, so the output is "none". Finally, the area under the plot (= the integral) is roughly estimated as an indicator of the total potential AoE damage. Since more than 80 damage in our setup are overkill, it would scew the area comparison. Therefore, the "functional area under plot" estimates the area of each graph below the indicated threshold at currently 80 HP.
So far, I had fun writing the project and not letting my Excel skills get too rusty.
I hope you liked this short showcase of DeCoHde!
Hannibal
Showcasing DeCoHde - An Excel based CoH2 stat analyzer
22 Jul 2019, 18:41 PM
#1
Posts: 3114 | Subs: 2
22 Jul 2019, 19:22 PM
#2
Posts: 682
Very awesome. Thank you for doing something like this
PAGES (1)
1 user is browsing this thread:
1 guest
SHOUT IT OUT!
Rosbone: Hopefully we can look back and laugh in a couple years. But the Steam reviews are diving again so...
Last Thursday, 08:03 AM
Last Thursday, 08:03 AM
Rosbone: @donofsandiego The counts are up a little. Coh3 actually passes Coh2 for a short period now. So Coh3 is no longer shit. It has a way to go to be "good". But it is healing.
Last Thursday, 08:01 AM
Last Thursday, 08:01 AM
donofsandiego: Last time I was on here my good friend Rosbone told me that CoH 3 is shit because it doesn't have visible kill counts. Well, it has them now. Where are the players?
Last Thursday, 06:27 AM
Last Thursday, 06:27 AM
Rosbone: @Soheil Relic is in a hard spot. They need players for Coh3 so it hurts their Coh3 sales to make Coh2 even better than it already is. So we are all lost waiting for Coh3 to get finished to our liking.
Last Thursday, 02:50 AM
Last Thursday, 02:50 AM
Soheil: Coh3 neither has realistic graphic nor diversity anyway , The big issue im coh2 is cheaters . Developers do not care about these map hackers or sync hackers who most of them are chinese
Last Wednesday, 21:56 PM
Last Wednesday, 21:56 PM
Rosbone: @DIRTY_FINISHER My guess is none of those people play coh3 and are mostly gone from the community
Last Wednesday, 07:17 AM
Last Wednesday, 07:17 AM
DIRTY_FINISHER: Whens the “player council” going to accept some responsibility for the failure that is COH3. Considering they had influence on development and impact to in game units/mechanics
Last Tuesday, 15:46 PM
Last Tuesday, 15:46 PM
Reverb: relic should stop coh3 and do hing with coh2 again and make new maps and balance and units and make player base 10000 again
14 Dec 2024, 23:34 PM
14 Dec 2024, 23:34 PM
Osinyagov: Since it's the only coh-related source left in my list (funny and sad at the same time)
08 Dec 2024, 07:56 AM
08 Dec 2024, 07:56 AM
Osinyagov: @Gbpirate I am visiting site from time to time, see some content here would be great
08 Dec 2024, 07:55 AM
08 Dec 2024, 07:55 AM
Livestreams
18 | |||||
23 | |||||
6 | |||||
6 | |||||
2 | |||||
1 | |||||
1 |
Ladders Top 10
-
#Steam AliasWL%Streak
- 1.655231.739+15
- 2.842223.791+5
- 3.35258.859+1
- 4.599234.719+7
- 5.936410.695+2
- 6.278108.720+29
- 7.307114.729+3
- 8.645.928+5
- 9.10629.785+7
- 10.527.881+18
Replay highlight
VS
- cblanco ★
- 보드카 중대
- VonManteuffel
- Heartless Jäger
Einhoven Country
Honor it
11
Download
1262
Board Info
248 users are online:
248 guests
1 post in the last 24h
13 posts in the last week
28 posts in the last month
13 posts in the last week
28 posts in the last month
Registered members: 49972
Welcome our newest member, rockytiki
Most online: 2043 users on 29 Oct 2023, 01:04 AM
Welcome our newest member, rockytiki
Most online: 2043 users on 29 Oct 2023, 01:04 AM