COH2.ORG » Forums » Parlor Room » COH2 Central » COH2 Gameplay » Scatter This! - Your trusty scatter calculator

Scatter This! - Your trusty scatter calculator

New topic

New Reply

Posts: 999 | Subs: 1

Hey Everyone!

Since the community has recently been provided with an immensely useful tool to simulate tank vs tank combat by Hannibal, I've decided to follow his lead and proudly present you Scatter This! - an Excel-based calculator to analyze scatter and AoE-based anti-infantry performance of tanks and indirect fire units.

Now many of you will probably say "Wth is this and what would I ever need this for?", so let's start with a brief explanation what this spreadsheet does and why, before glancing over on how to use it and for what purpose:

1) What does Scatter This! do?

Most of you will probably be familiar with how accuracy (i.e. the product of base accuracy, target size and received accuracy modifiers) determines if a fired round hits its target an deals damage, or misses and scatters off somewhere into the wilderness. And while these scatter shots may still connect with something on their path to deal damage, their contribution to the overall damage output is usually quite small in regular tank vs tank combat, simply due to the fact that tanks already have a pretty low chance to miss each other to begin with.

However, in tank vs infantry fights accuracy plays a much lesser role for damage output, as the target size of an infantry model is much smaller than that of a tank. As a result, most tank guns only have a 1:25 to 1:50 chance to score a direct hit against infantry, making accuracy almost irrelevant for damage calculations.

This is where scatter and AoE profiles come in as an additional layer of RNG in the game - and, unfortunately, one that is much more obscure and less well understood by most players.
Scatter basically determines how far away (horizontally and vertically) a round will impact from its intended target and, luckily, a great and extensive overview of how scatter works can be found here for all of you interested in the detailed mechanics behind this. Hence, we only need to briefly cover the impact of the AoE profile on the damage calculation.

As the name implies, the AoE profile of a weapon determines how much damage is dealt to entities caught within its blast radius and typically declines the farther away the point of impact is from the target. Taking the AoE profiles of the Tiger and 75mm Sherman HE round as an example (see image below), you can clearly see that an infantry model has to stand pretty close to the center of impact to receive lethal damage (which is anything higher than 80 for most infantry models out of heavy cover), but will still receive small amounts of chip damage from impacts much farther away. The actual damage at a given distance is determined by the shape or slope of the curve, and may vary greatly between different tanks.

AoE curves of Tiger and 75mm Sherman with HE rounds

Therefore, knowing how far away a scatter shot lands from a given target and how much, if any, damage is dealt according to this distance is all what is needed to calculate the anti-infantry performance of a weapon.

This is in essence what Scatter This! does.

2) How to use Scatter This!?

2.1) Setup

In order to use the calculator, you'll obviously need to download and unzip it first, after which you should be all set... unless of course you don't have MS Office or some Excel analog installed on your computer, although I doubt anyone can live without this.

2.2) Input

After opening the spreadsheet, quickly navigate to the "Scatter Sim" tab which contains the main calculator and should resemble the image below:

Main window

This is where you can set the parameters of the simulation and view the results from a couple of tables and handy graphs for visualization:

You'll notice that, due to the way Excel handles volatile functions, the sheet will update automatically whenever you change any cell value. This happens quite quickly on my 3yo laptop, but could take significantly longer on older machines due to the unoptimized cell logic (sorry). For those who feel this is slightly annoying there is a button to toggle the calculation mode to manual, which lets you update the sheet only when you want it by pressing F9.

To start a scatter simulation, first select a shooter from the dropdown menu (L2:M2, J2:K2 to select specific categories) and set the parameters for distance to target (D2), max number of shots (A2, must be between 1 and 500) and one-hit kill threshold (E2, should typically be 80 HP, but can be set to lower or higher numbers to simulate cover or damage reduction). If desired, additional modifiers for firing into the FoW (G2) or on the move (H2) can also be enabled or disabled.

Next, the number and formation of the target entities can be selected from the "Formation" menu (N5), with the option of either using one of the 6 formation presets (big thanks for Hannibal for measuring and providing the in-game templates 4-6) or generating your own squad formation using the custom builder or the formation randomizer.

With these set, the targeting mode (N7) can be adjusted to either randomly pick a model to target ("random"), pick the entities with the lowest number first ("fixed") or fire at the center of the template instead (this disables target switching and should be chosen for barrage-type weapons).

Automatic target switching after a model dies can be enabled (N11) or disabled to target specific models only.

Lastly, the "Position" dropdown menu changes how the simulation handles the position of the shooting entity and the target. Choosing "relative" keeps the distance and angle between shooter and every entity targeted constant. As a result, the shooter is 'teleported' each time another model in the formation is targeted.
A more realistic option can be selected by choosing "absolute", which locks the position of the shooting entity in place and only changes the firing angle upon switching targets. However, since in this case the true distance between shooter and each entity in the formation may be greater or smaller than the respective minimum and maximum range of the shooter, the distance set in cell D2 may need to be adjusted accordingly.

Difference between "relative" and "absolute" position mode

2.3) Results

Using the input variables, the calculator will simulate shots fired at the target squad until the last model has received fatal damage. For each shot, an accuracy roll first determines if a natural hit of the targeted model occurs or if the shot scatters to a random point within the scatter cone. Then, the distance between point of impact and each model is calculated to check if and how much AoE damage is dealt. If the targeted model dies, the model with the next-highest priority is selected and targeted for the following shots until the simulation ends.

Detailed results and timestamps can be viewed in the table from columns T:AU and should look something like this:

Main calculation table

Alternatively, the main results are summarized in the leftmost table (A5:H10), showing the number of natural hits, one-hit kills, shots required to kill, and, in case not all models died within the set limit of fired shots, the entities and respective HP left after the simulation finished.

For visualization, the two upmost graphs provide information on the shot distribution (i.e. where each shot landed with respect to the target formation), while the 3rd graph displays the area of the scatter cone and size of the AoE circle. Last but not least, the AoE curve can be seen in the last graph.

Numbered shot distribution display indicating shot sequence

Color-coded shot distribution display indicating targeted entity

AoE and scatter area representation

AoE curve display

2.4) Enumeration, a.k.a. increase sample size

Now being able to see the results of a simulated fight is neat and all, but it still doesn't give any more information on the overall performance than an isolated test in-game would provide.
However, in contrast to in-game testing, firing 50 simulated shots at a target using the spreadsheet is a good deal faster (hopefully) than any in-game test would allow, so we can use this to our advantage to conduct hundreds or thousands of simulated runs in mere minutes as opposed to hours or days.

Still, copying a result and hitting F9 thousands of times in a row to get a statistically relevant result can be quite tedious and unnerving to say the least.
Fortunately, the "Scatter Enum" tab is there to save the day (literally), allowing to repeat a simulated fight for up to 10k iterations and further queue up other simulations to be processed one after another.
All you need to do is to select a range, entity, formation combination in rows 1:3, set the number of iterations of each simulation (BT4), the number of columns to process (BT5), and, most importantly, the desired result to iterate from the dropdown menu (BS3).
With this all set, start the iteration with the "Run calc" and wait (this could take quite long, depending on the number of iterations and the speed of your rig, so proceed with caution) for the macro to finish.

Enumeration calculator interface

Afterwards, you can use the "Analyze" buttons for each dataset on the right side to perform a basic analysis, giving the minimum, maximum, average and standard deviation over all repetitions in the upper panel, as well as the probability distribution for each event in the dataset (i.e. how many times the simulation ended after 10, 11, 12, etc.. fired shots).

Analyzer for Enumeration results

3) Why would I want to use Scatter This!?

Well, I'm glad you asked! While Scatter This! won't offer any answers to mankind's most burning questions, such as "Are we alone in the Universe?", it will surely come in handy if you want to bring some solid numbers to back up your arguments in any scatter- or AoE-damage related balance thread!
To back this up, let's have a look at the following two examples and how Scatter This! can be utilized therein:

3.1) Case study #1: The state of the Tiger

Undoubtedly, the Winter Balance Patch brought a bit of fresh wind into stale heavy tank meta, not least due to nerfs to the AoE damage profile of the Pershing , IS-2 and Tiger. And while all three heavies have been on the receiving end of this, some people feel the Tiger has indeed been hit quite a bit harder by the nerf bat. Justified or not? Well, lets run the numbers to see how much truth there is to this assessment.

To judge the impact of the changes, we'll do a head-to-head comparison of live version of the Tiger, its pre-WBP counterpart, the Vet 2 version of the latter still benefiting from the 20% scatter reduction, and last but not least the Ostheer PzIV to put things into perspective.

Looking at the size of the scatter cone and the AoE area - here in particular the OHK area - in the graph below, you can easily see the extent of the OHK radius reduction between the live and pre-WBP Tiger, as well as the reduced scatter area of the Vet 2 pre-WBP Tiger.

Scatter/AoE area comparison for Tiger, pre WBP Tiger (Vet 0 and Vet 2) and Ostheer PzIV, wide formation

Now the question is of course: How much does that impact the anti infantry performance?

To answer this, let's consider the number of shots required to kill (S2K) a full-health, 6-man squad at a distance of 20 m in a spread-out formation for each tank. Using a sample size of 1,000 iterations we get the following average S2K and T2K (time to kill) values:

Comparison of absolute and relative S2K and T2K values for different tanks versus a full-health, 6-man squad in a wide formation at 20 m distance

While the live Tiger needed 9.5 shots or 45.7 s on average, the pre-WBP version would take about 13% less shots or 15% less time to kill the squad under the same conditions. The the Vet 2 scatter bonus unsurprisingly yielded an even greater performance gain, resulting roughly 25% lower S2K and 28% lower T2K between the old Vet 2 Tiger and its live counterpart.
Still, owing to its superior scatter and despite the much smaller OHK radius the live Tiger remains vastly superior to the PzVI in terms of AI performance, which on average takes more than double the time (~115% more) to wipe all 6 models of the targeted squad.

Considering one objective of the patch was to decrease the OHK potential of heavy tanks, let's crunch the numbers on that one too while we're at it.

Comparison of one-hit kill performance for different tanks versus a full-health, 6-man squad in a wide formation at 20 m distance

As you can see from the graph obtained by again running 1,000 iterations and, this time, recording the number of OHKs per run (i.e. the number of models dropped from 80 to 0 HP in a single shot), the live Tiger did not snipe any model in a single hit in 74% of all cases and OHKed 1 model in the remaining 26%. One-hit wipes of 2 or more models did not happen at all, which of course isn't too surprising given the large maximum AoE and tiny OHK radius of the live 88mm shell in conjunction with the relatively large distance between each squad member.
In contrast, the old Tiger used to wipe at least one entity per hit in more than half the occasions due to the larger OHK radius.

Now of course the recent performance nerfs should be most obvious for clumped-up formations, in which the inter-unit distances get small enough to fit almost the entire squad into the OHK area, so let's see how things change when moving from a spread-out to a much more densely packed formation:

Scatter/AoE area comparison for Tiger, pre WBP Tiger (Vet 0 and Vet 2) and Ostheer PzIV, clumped formation

Since the bunched up model template now conveniently fits into the OHK area of all tanks bar the live Tiger, not only the S2K and T2K values should be considerably smaller than for the wide formation but also one-hit wipes of up to all 6 models should occur much more frequently.
Performance-wise, we find the S2K and T2K of the live Tiger indeed to drop to only 3.9 and 15.4 s, respectively, as seen in the graph below.

Comparison of absolute and relative S2K and T2K values for different tanks versus a full-health, 6-man squad in a clumped formation at 20 m distance

Also in line with our expectation the pre-WBP Tiger performs significantly better than the live Tiger due to the larger AOE near and mid radius together with higher AOE near damage multiplier. As a result, the S2K and T2K are now 19% and 25% lower on average than for the live Tiger, which has to be considered quite significant indeed. Comparing the live Vet 2 Tiger with the pre WBP analog, this performance difference even reaches up to 40% - so it is quite safe to say that complaints about the new Tiger having gotten its fangs pulled are not unjustified in my personal view.

This can also be seen from the OHK performance of the new Tiger, which is now roughly on par with that of the PzIV, albeit without the occasional one-hit squad wipes the PzIV is still capable of due to its relatively large OHK radius.

Comparison of one-hit kill performance for different tanks versus a full-health, 6-man squad in a clumped formation at 20 m distance

In conclusion, I think these results not only show how Scatter This! can serve as a valuable tool to compare the anti-infantry performance of different tanks under different conditions, but also shows that the Tiger tank may indeed suffer a bit more from the recent nerfs to heavy tanks than intended.
Some of you may also remember me posting a similar, yet more condensed analysis a few weeks ago here, which came to a slightly different conclusion. However, somehow i missed the AoE near range reduction from 1.5 to 1 m in back then, which made the Tiger look a bit better than it actually is. Nonetheless, the general conclusion that heavies remained almost as lethal as before the patch still stands, even though the Tiger may be a bit of an outlier here.

3.2) Case study #2: PM-41 vs HM-120 - Duel of the mortars.

In the second example, we're gonna tackle another subject that has come up a couple of times in the recent months: Which of the two soviet mortars is better, the trusty non-doc 81mm or the doctrinal 120mm heavy weight contender?
Of course a comparison of the anti infantry performance can only partially answer this question due to the sheer number of other factors, such as price, availability and utility playing a major role as well. Still, this particular aspect is notoriously hard to quantify and opinions on that remained divided as a result. Luckily, this is where Scatter This! steps in again to bring a bit more light into the dark.

Similar to the Tiger example, a quick look at the S2K and T2K numbers for both mortars can provide a good first impression of which one pulls ahead, so let's find out how the averages over 1,000 iterations for the auto-attack of both mortars against a spread-out or clumped 6-men squad at 80 m distance compare.

S2K and T2K values for the soviet PM-41 and HM-120 mortars at 80 m versus clumped and spread-out squad formations

As visible from the charts above, the autofire of the HM-120 is clearly superior to its smaller 81mm cousin, despite the fact that the heavy mortar has a longer delay between shots than the PM-41. The reason for this is that both mortars have a similarly sized scatter area at 80 m range while the 120mm has far superior AoE damage beyond 1 m distance to impact (see graphs below).

Autofire AoE and scatter area vs distance for the HM-120 and PM-41

However - as most of you will probably interject at this point - in a real in-game scenario no one except players with a ranking having more digits than your zip code will leave a squad in the firing cone of a mortar until death. Also, the only real saving grace for any mortar is its barrage, so let's focus instead on a slightly different approach to gauge the performance of the two mortars.

This time, we'll simulate using the barrage into the FoW against a static clumped or spread-out squad - same distance, same conditions except we now limit the number of shots fired each time (in the main calculator, cell A2) from 1 to the maximum number of shots fired per barrage (4 for the PM-41 and 6 for the HM-120), enable the FoW multiplier (cell G2) and keep the center of the firing cone in the center of the formation template (by selecting "center" in cell N7). Furthermore, we record the HP left after each simulation by switching the category in cell BS3 in the "Scatter Enum" tab to "HP left".

After again running 1,000 iterations for each case (i.e. 1, 2, 3 and 4 shots fired for the 81mm; 1, 2, 3, 4, 5 and 6 shots fired for the 120mm mortar), we get the following results:

Remaining HP of a full-health, 6-man squad in clumped or wide formation after n barrage shells fired by the PM-41 or HM-120 mortar.

Interestingly, the PM-41 now seems to be on par with bigger cousin in terms of HP drained during the first 4 shells dropped on the spread-out squad, and even pulls ahead in case of the tightly clumped squad. Coupled with the longer delay between shells launched for the 120mm mortar, the HM-120's only saving grace is its greater number of shots peer barrage, which allows it to eventually catch up with and overtake the PM-41 in terms of damage dealt.
As you might have guessed already, the reason for this quite unexpected divergence in performance lies again in the size of the respective scatter cones of the two mortars (the AoE profiles remained roughly the same as in the autofire example).

Barrage AoE and scatter area vs distance for the HM-120 and PM-41

As visible from the second panel in the graph above, the scatter area for the PM-41 in barrage mode at 80 m distance is much smaller than that of the HM-120 (thanks to a distance_scatter_max value of only 4 essentially capping horizontal scatter for distances greater 25 m in case of the former). And since we've been firing into the FoW, the true discrepancy between both mortars is even greater than displayed here.

So, the answer to the question to which of the mortar is better is... indeed quite difficult to answer, as it depends quite heavily on the circumstances under which they are used.

For barraging into the FoW, the PM-41 performs equally or better than the HM-120 at max range, but due to the way the scatter area depends on distance, the situation is likely reversed at closer range.
Using autofire, the HM-120 can get the job done in about half the time.

Congratulations if you've made it so far without falling asleep! While these two examples may already serve as a ground for further discussion by themselves, I hope even more that you're now eager to explore Scatter This! on your own and use it to generate some theoretical data yourself for that next balance thread!

4) Where to get Scatter This!?

Easy peasy, you're just one click (well, maybe a couple more than one) away. Download it here, no installation or setup required other than starting Excel and loading it! Be aware though that the spreadsheet contains some macros that are required in order for all functions to run properly.

This project is kind of a work-in-progress, so please feel free to check back on possible updates every now and then. Also, any comments and suggestions are highly welcome, and if you find any errors (likely!) in the data sheet, let me know so I can fix them.

Last but not least, big shout out to Vipper and especially Hannibal for the fruitful discussion and suggestions regarding the scatter model used in the simulation over the last weeks.

Best
-MMX-

UPDATE 5/18/2020 New version of the Spreadsheet is ~~available~~!

Fixed non-functional OHK and natural hit counters in the main result table
Added an info box displaying the chance and damage for a natural hit (accuracy roll), as well as the respective chances to deal highest possible and lowest possible amount of AoE damage vs a single target.
Corrected some errors in the data sheet and added profiles for rocket artillery pieces
Fixed the orientation of the in-game formation templates (preset 4-6) by rotating 90° clockwise. Thanks again to Hannibal for pointing out the error!

UPDATE 2/4/2021 It's been quite a while since I've last revisited the spreadsheet, but a revamped version with tons of new features is now ~~available here~~!

Complete overhaul of the calculator that now not only simulates the damage of main gun projectiles, but also offers a crude approximation of MG damage output. Ever wondered if that pintle MG on top of the PzVI is even worth the munitions? Test out how much of a difference it actually makes with the simulator!
Revamped Simulator tab that now calculates the average damage and kills dealt (total, by MG and by main gun) after each shot for each model in a squad over 100s or 1,000s of repetitions.
Graphical interface that allows quick and easy visualization and comparison of results
New templates for rocket artillery and various off-map arty strikes
A number of bugfixes, especially for the unit stats in the Data tab

UPDATE 2/19/2021 A couple of bugfixes and a new interface with fancy graphs ready to ~~download here~~!

Added a new graphical interface tab that allows comparison of up to 4 datasets and shows damage/kills over time, the contribution of MGs and the main gun to overall damage and model kills, as well as plots comparing the respective AoE and scatter area curves
Included option to export/import datasets to/from .txt
Fixed the damage reduction multiplier not correctly applying to machine gun damage
Fixed an error in the TBS (time between shots) calculation affecting weapons with cooldown

UPDATE 1/12/2022 It's been a while since the last update to the spreadsheet, so I figured it's time to bring back ScatterThis! with updated unit stats reflecting the most-recent patches and a number of new features. Get the newest version here!

Updated MG damage calculation model: While the previous solution allowed a crude approximation of the DPS/KPS the tank-mounted MGs add to the overall AI performance, it wasn't really suited to capture the variance, or "hit-and-miss" nature, usually observed in-game (who doesn't love chasing a retreating squad across the map while constantly missing the last, lethal hit?). The new randomized model does just that by taking the number of fired bullets, targeting delays and accuracy into account when randomizing the damage output in a more realistic fashion
Improved simulation algorithm: A couple of tweaks to the VBA code tremendously increased the speed of the simulation, meaning that results are generated in about 1/10 of the time it took previously.
Up-to-date unit stats (sort of): While some remaining errors are likely, most of the recent balance changes should have made it into the unit stats tab of the spreadsheet by now. Unfortunately, some new abilities (e.g. the 105mm Sherman's and leFH's new barrage abilities) are still missing as there's currently no way of extracting the stats from the game.
New unit templates: A couple of light and ultra-light vehicles are now implemented (including the SdKfz 222 AC; thanks to Klement Pikhtura for the suggestion).
Improved simulator tab: The simulator tab has received some additional functionality and most relevant options (e.g. FoW and moving penalties, % uptime of tank-mounted MGs, etc) can now be set directly in the simulator tab.
Overhauled comparison tab: The graphical interface for plotting and comparison of the simulation results has been revamped to allow more data sets (6) to be displayed at a time. Other plotting options, such as switching between continuous or stepwise graphs and different color schemes have been added as well (again many thanks to Klement Pikhtura for the valuable feedback).
Damage distribution plots: The new damage distribution tab offers a more in-depth way to analyze how much and how reliable a unit delivers its damage over time. The 3D datasets produced in this tab display the probability distribution of how much damage / how many model kills are scored with each successive shot. This can give a pretty good impression of the variance (or reliability) of the DPS/KPS output as well as the alpha-damage capabilities, both of which are otherwise hard to capture using 2D plots.

Posts: 13496 | Subs: 1

Nice work.
Thanks for credits.

Posts: 1273

Wow, very well done! That is a nice neatly complex implementation, big thumbs-up for doing the most difficult part and time-intensive part of the work which is the coding & thoughtful academic design! Well done to you MMX for all of that and to Hannibal for laying the coding ground work - I also really like the clear and distinct examples of how you use the file. Excellent.

edit: giving it a go right now, that is proper good stuff!

Posts: 3114 | Subs: 2

Very great work!
You put plenty of time into this. The text of the post alone... wow!

I think this will be especially useful for balance team to determine scatter and AoE changes on units. But obviously this will clear up a lot of questions and discussions about AI performance. Let's see how forum discussions go from here on onwards, I hope less toxic.

4 May 2020, 12:56 PMJohnSmith

Wow, very well done! That is a nice neatly complex implementation, big thumbs-up for doing the most difficult part and time-intensive part of the work which is the coding & thoughtful academic design! Well done to you MMX for all of that and to Hannibal for laying the coding ground work - I also really like the clear and distinct examples of how you use the file. Excellent.

edit: giving it a go right now, that is proper good stuff!

I want to point out that I have provided nothing other than discussion and some of the spacing presets for this. I had nothing to do with the coding, that is all MMX's work.

Posts: 3114 | Subs: 2

Finally I can look up how long my SU85 needs to take out that damn Volks squad.
What a happy day

Posts: 2358

Great work man! Thank you so much!

Posts: 8154 | Subs: 2

My controls weren't working
And if they were, you were playing dishonorably,
And if you weren't, you were playing without skill,
And if you were, it's not fun to play that way,
And if it is, you only care about winning.

Bible of Scrublord, Psalt 3:16.

Multi Quote

Posts: 999 | Subs: 1

thanks a lot for all the kind words, guys!

4 May 2020, 12:56 PMJohnSmith

edit: giving it a go right now, that is proper good stuff!

great to hear you're giving it a try. let me know if you run into any errors or need some more info on some of the features/settings.

4 May 2020, 15:07 PMHannibal

Finally I can look up how long my SU85 needs to take out that damn Volks squad.
What a happy day

haha, i wonder if the hard-coded 500 max shots the sim can handle will be enough in this case...

Posts: 3114 | Subs: 2

5 May 2020, 03:39 AMMMX

haha, i wonder if the hard-coded 500 max shots the sim can handle will be enough in this case...

I remember that a friggin Jackson once sniped my last Sturmpio model on retreat and thereby wiped the squad. RNG was strong that game.

There seems to be an issue though with some counters in the summary table. At least for me natural hits (and I think the OHKs) were not counted properly and always showed 0, although the shot table registered them.

Posts: 1273

4 May 2020, 15:00 PMHannibal

Very great work!

I want to point out that I have provided nothing other than discussion and some of the spacing presets for this. I had nothing to do with the coding, that is all MMX's work.

Oh, I was mostly referring to your DeCoHde 2.0 project and the detailed Python script you published. I am confident it helped a lot of people to get into creating more adjacent CoH2 content (including this!)

Posts: 999 | Subs: 1

5 May 2020, 08:17 AMHannibal

I remember that a friggin Jackson once sniped my last Sturmpio model on retreat and thereby wiped the squad. RNG was strong that game.

There seems to be an issue though with some counters in the summary table. At least for me natural hits (and I think the OHKs) were not counted properly and always showed 0, although the shot table registered them.

oh, that's strange. worked for me last time i checked. i'll investigate what's going wrong there!

Posts: 3114 | Subs: 2

5 May 2020, 10:29 AMMMX

oh, that's strange. worked for me last time i checked. i'll investigate what's going wrong there!

I mean the counting formula looked fine on first glance, but I did not have a deeper look. Just noticed that although the detailed table reported a natural hit, the summary did not.

Posts: 999 | Subs: 1

5 May 2020, 14:35 PMHannibal

I mean the counting formula looked fine on first glance, but I did not have a deeper look. Just noticed that although the detailed table reported a natural hit, the summary did not.

Just had a quick look and, indeed, you're absolutely correct, thanks a lot for the hint! The array function counting the OHKs seem to work... sometimes, but not consistently for whatever reason. I've switched it out against a non-array version that seems to have no issues.
However, I couldn't reproduce the counting error for natural hits in any way. Do you consistently get this or only once in a while?

Posts: 3114 | Subs: 2

5 May 2020, 15:44 PMMMX

Just had a quick look and, indeed, you're absolutely correct, thanks a lot for the hint! The array function counting the OHKs seem to work... sometimes, but not consistently for whatever reason. I've switched it out against a non-array version that seems to have no issues.
However, I couldn't reproduce the counting error for natural hits in any way. Do you consistently get this or only once in a while?

I think I used the sheet only twice (Excel starts) by now without PC restart, but it did not work on any of these occasions.
I will retry tomorrow and write you. Or maybe someone else can post in the meantime.

Posts: 999 | Subs: 1

5 May 2020, 15:50 PMHannibal

I think I used the sheet only twice (Excel starts) by now without PC restart, but it did not work on any of these occasions.
I will retry tomorrow and write you. Or maybe someone else can post in the meantime.

hmm, no idea what's going on there... at least the naural hit tally should work just fine. anyway, thanks a lot for the troubleshooting, that's very much appreciated!. anyone else that had a shot at it yet experienced the same problem?

Posts: 3114 | Subs: 2

6 May 2020, 08:25 AMMMX

hmm, no idea what's going on there... at least the naural hit tally should work just fine. anyway, thanks a lot for the troubleshooting, that's very much appreciated!. anyone else that had a shot at it yet experienced the same problem?

Tested the sheet yesterday (release version):

Natural hits and OHKs do not work and are not counted, at least not for me.This is a minor issue though since it seems to work for others.
The natural hits are not that important, especially not for AoE calculations. Since you you said you fixed the OHK counter, all the important information is visible.

Posts: 999 | Subs: 1

8 May 2020, 15:37 PMHannibal

Tested the sheet yesterday (release version):

Natural hits and OHKs do not work and are not counted, at least not for me.This is a minor issue though since it seems to work for others.
The natural hits are not that important, especially not for AoE calculations. Since you you said you fixed the OHK counter, all the important information is visible.

thanks a lot for testing again. maybe it's related to the excel version you use? i've tested it with the office 2013 and 2016 version, but maybe some functions got changed in more recent or earlier versions.
anyway, i'll upload an updated version that fixes the OHK bug at least on my side and contains data for rocket artillery as well soon...

Posts: 930

Does movement affects scatter? if so how much?

Posts: 17914 | Subs: 8

10 May 2020, 21:15 PMzerocoh

Does movement affects scatter? if so how much?

Yes, increases it by 50%.

25 Nov 2015, 11:09 AM$nuffy

Maybe it's 'cause the Axis players aren't a bunch of forum crybabies, and they keep their cool and fight the uphill battle, unlike some of their "allied" counterparts.

Good Stuff here

Multi Quote

Posts: 999 | Subs: 1

10 May 2020, 21:15 PMzerocoh

Does movement affects scatter? if so how much?

10 May 2020, 21:21 PMKatitof

Yes, increases it by 50%.

The moving penalty is actually even worse. It's a straight multiplier of 2 to both angular and distance scatter that is not capped by distance_scatter_max.

So as a rule of thumb, shots will scatter double as far in the left/right and up/down direction when moving.

New topic

New Reply

1 user is browsing this thread: 1 guest

Subscribe to thread

COH2.ORG » Forums » Parlor Room » COH2 Central » COH2 Gameplay » Scatter This! - Your trusty scatter calculator

Livestreams

	tightrope				79
	BadmanLarry				24
	Velmarg				6
	BobisWinning				5
	1337Cammy				1
	VindicareX				1
	bioodhound				1

Ladders Top 10
						
						
							UKF
						
					

						
						
							USF
						
					

						
						
							OKW
						
					

						
						
							SOV
						
					

						
						
							OST
						
					
1v1
2v2
3v3
4v4

					#
Steam Alias
W
L
%
Streak

				

                        1.
-虎贲-快樂的小蝸牛-HOI-
1819
455
.800
+1
2.
michciopuwu.ttv^^
185
60
.755
+30
3.
ker_141
525
217
.708
+3
4.
hoijimmy890.ttv
1543
537
.742
+4
5.
Rei
1228
500
.711
+10
6.
逼罗，逼罗 你妈很滑很润
6870
2504
.733
+5
7.
蓝色天线宝宝
211
105
.668
+9
8.
Valerian
462
276
.626
+2
9.
VonIvan
1625
589
.734
+18
10.
红色卫兵
137
44
.757
+4

                    

                        1.
DIRTY_FINISHER
2181
903
.707
+5
2.
Zirty Zoggy
122
24
.836
+5
3.
✠Kaiser✠ PERVITIN
448
297
.601
+3
4.
【Clannad】
264
89
.748
+4
5.
Flap
676
349
.660
+4
6.
The Angry Dutchman
349
200
.636
+2
7.
Farlion
353
190
.650
+3
8.
Rogue
109
25
.813
+5
9.
NiteNite
672
409
.622
+11
10.
gardening lelic
297
140
.680
+4

                    

                        1.
Thales
1495
743
.668
+21
2.
Perun777
362
220
.622
-1
3.
★Osas
479
218
.687
+5
4.
Muhhdock
427
131
.765
+1
5.
[ѕєѕ] dpvta
586
425
.580
+2
6.
BATTLEDANNY1
140
53
.725
-1
7.
Yox
821
469
.636
+1
8.
Saugstauber
311
178
.636
+9
9.
Cooper47
200
123
.619
+2
10.
Jerry
119
53
.692
-1

                    

                        1.
SoE-Sturmpanther
900
246
.785
+8
2.
Misaki
345
108
.762
+3
3.
loser
862
463
.651
+2
4.
ukill
320
189
.629
+1
5.
Jax
591
255
.699
-1
6.
BATTLEDANNY1
708
339
.676
+4
7.
Ogreon
939
586
.616
+1
8.
King of Lee
1519
998
.603
+4
9.
Bulbasaur
385
167
.697
+7
10.
WTFD=
121
34
.781
+11

                    

                        1.
Marcel
189
29
.867
+5
2.
逼罗，逼罗 你妈很滑很润
2900
1043
.735
+2
3.
Zirty Zoggy
562
114
.831
+22
4.
vonLewinski
548
194
.739
+29
5.
Bober
948
378
.715
-1
6.
hoijimmy890.ttv
1362
445
.754
+16
7.
红色卫兵
136
27
.834
+12
8.
michciopuwu.ttv^^
166
56
.748
+1
9.
[-✰-81] Cc
866
342
.717
+3
10.
T.R. Stormjäger
354
187
.654
+1

                    

                        1.
DIRTY_FINISHER
3101
1521
.671
+1
2.
Zirty Zoggy
152
34
.817
-1
3.
铁甲小兔
384
216
.640
+11
4.
[SVO] ✠Kaiser✠ tushkan
346
176
.663
+6
5.
[虎贲] Leng Mo
210
98
.682
+2
6.
Witchdoctor`
1415
965
.595
-1
7.
gardening lelic
1312
788
.625
+7
8.
KIROV | BIH/QC |
862
493
.636
+13
9.
TheMeowGamer
260
127
.672
+2
10.
~SOK-St{o}cky~
988
537
.648
+3

                    

                        1.
Thales
789
376
.677
+3
2.
Yox
533
301
.639
+10
3.
[NS]Hell March
434
170
.719
-1
4.
Nika
166
57
.744
-1
5.
Jerry
115
33
.777
+4
6.
White8===D
359
266
.574
-1
7.
[Dengue]™Alexandro
260
93
.737
+4
8.
Restzeit
1025
547
.652
+1
9.
BlackNyasher
186
123
.602
+4
10.
XL
122
52
.701
+4

                    

                        1.
Bulbasaur
750
398
.653
-3
2.
BlackNyasher
274
213
.563
-3
3.
Misaki
333
181
.648
-1
4.
p1
583
391
.599
+3
5.
昂撒猪猪拳
470
373
.558
+5
6.
BATTLEDANNY1
461
320
.590
+3
7.
[Dengue]™Alexandro
1267
757
.626
+1
8.
WTFD=
86
36
.705
+5
9.
GruZ
437
363
.546
+3
10.
男儿何不带吴钩
1115
1162
.490
+3

                    

                        1.
Bober
1839
774
.704
+15
2.
hoijimmy890.ttv
1393
537
.722
+1
3.
ker_141
484
223
.685
+1
4.
vonLewinski
661
206
.762
+16
5.
蓝色天线宝宝
584
286
.671
+4
6.
红色卫兵
155
63
.711
+6
7.
TRI1091
74
20
.787
+2
8.
Он - Спаситель всей Евразии...
585
324
.644
+3
9.
✠ Kaiser Friedrich ✠
720
384
.652
+1
10.
-虎贲-快樂的小蝸牛-HOI-
4250
971
.814
+4

                    

                        1.
DIRTY_FINISHER
1490
644
.698
+1
2.
✠ Kaiser Friedrich ✠
1634
1172
.582
+1
3.
Falko_nero22
666
345
.659
+12
4.
★Osas
180
68
.726
+6
5.
아리스킨충
374
193
.660
+4
6.
[SVO] ✠Kaiser✠ tushkan
718
453
.613
+1
7.
André
670
257
.723
+2
8.
Flap
527
286
.648
+1
9.
-AL- Nimahfrosch
1052
573
.647
+1
10.
Zirty Zoggy
146
38
.793
-1

                    

                        1.
Vertsu
500
182
.733
-1
2.
★Osas
647
294
.688
+5
3.
Kilder
872
392
.690
+6
4.
Artyom
254
70
.784
-1
5.
Richmond
255
115
.689
-1
6.
Cow
236
86
.733
+2
7.
.OneTwo
1186
851
.582
+2
8.
Lieutenant
374
261
.589
-1
9.
[Dengue]™Alexandro
245
70
.778
-1
10.
DesTo
524
301
.635
+1

                    

                        1.
DesTo
865
505
.631
+5
2.
Shrimp
675
313
.683
-1
3.
黎霏洺
745
306
.709
+4
4.
King of Lee
3413
1984
.632
+13
5.
碧桂园五星上将
439
189
.699
+1
6.
SpacePig
381
185
.673
+1
7.
BATTLEDANNY1
971
475
.672
+4
8.
iiooppkl
365
146
.714
+4
9.
フンッ！逃げるつもりかい！！
992
546
.645
+7
10.
Tilly'edenan of the Spring
1498
819
.647
+3

                    

                        1.
GiantDwarf2
258
34
.884
+20
2.
vonLewinski
409
151
.730
+11
3.
TRI1091
260
79
.767
+11
4.
Zirty Zoggy
250
45
.847
+62
5.
SKELETRON
2028
686
.747
+32
6.
GiantDwarf
659
178
.787
-1
7.
逼罗，逼罗 你妈很滑很润
1185
447
.726
-1
8.
night_raven0203
3516
1734
.670
+4
9.
蓝色天线宝宝
192
88
.686
+15
10.
红色卫兵
165
48
.775
+15

                    

                        1.
DIRTY_FINISHER
2656
1446
.647
+7
2.
TRI1091
465
191
.709
+5
3.
☞ ps3YES ☜
851
361
.702
+4
4.
Pioneer
184
93
.664
+1
5.
godjaemin
165
63
.724
+2
6.
IncaUna
221
112
.664
-1
7.
BatON
1161
776
.599
+5
8.
Zirty Zoggy
75
21
.781
+3
9.
William H. Harrison
485
205
.703
+1
10.
gardening lelic
873
465
.652
+4

                    

                        1.
SFC. LEE ッ
3117
1005
.756
+3
2.
Jerry
95
16
.856
+18
3.
Restzeit
643
336
.657
+9
4.
Mr.Brightside
702
366
.657
+4
5.
Nika
257
104
.712
+1
6.
JOE
1202
732
.622
+1
7.
Riiiiina
446
163
.732
-1
8.
Rusovsky
44
13
.772
+6
9.
CAuMOH
387
182
.680
-2
10.
Cid
89
25
.781
+1

                    

                        1.
ranger中文
1219
1049
.537
+3
2.
Bulbasaur
501
316
.613
+1
3.
傻卵死全家开图挂壁们拉闸了吧
424
287
.596
-1
4.
King of Lee
746
566
.569
+1
5.
Shi Ku Liao
873
621
.584
+1
6.
玛丽猫猫
875
739
.542
-1
7.
Jax
160
67
.705
-1
8.
黎霏洺
366
234
.610
+3
9.
godjaemin
345
255
.575
+6
10.
Cid
152
96
.613
-1

                    

                        1.
逼罗，逼罗 你妈很滑很润
655
231
.739
+15
2.
-虎贲-快樂的小蝸牛-HOI-
842
223
.791
+5
3.
MoronPark_Cat YE
351
57
.860
+16
4.
Krakenn
599
234
.719
+7
5.
Bober
934
410
.695
-1
6.
ker_141
278
108
.720
+29
7.
vonLewinski
307
114
.729
+3
8.
I'm YE and I Don't eat beef
64
5
.928
+5
9.
红色卫兵
106
29
.785
+7
10.
TRI1091
52
7
.881
+18

                    

                        1.
☞ ps3YES ☜
2016
1084
.650
-1
2.
Flap
474
214
.689
+1
3.
IncaUna
583
358
.620
-1
4.
DIRTY_FINISHER
1681
923
.646
+4
5.
André
329
140
.701
+6
6.
[虎贲] Leng Mo
119
50
.704
-1
7.
HazardousMoose
429
272
.612
+1
8.
【Clannad】
214
68
.759
+12
9.
TheMeowGamer
102
37
.734
-1
10.
✠Kaiser✠ PERVITIN
191
103
.650
+2

                    

                        1.
Thales
771
291
.726
+4
2.
Remder
612
179
.774
-1
3.
Jerry
170
49
.776
-1
4.
Nika
216
90
.706
+19
5.
Restzeit
1015
554
.647
+6
6.
André
1003
437
.697
-1
7.
★Osas
361
155
.700
+2
8.
NoPlayWithAsiaSync/Maphack
606
410
.596
+8
9.
Ovidiu
1499
749
.667
-2
10.
BATTLEDANNY1
83
22
.790
-1

                    

                        1.
玛丽猫猫
575
416
.580
+5
2.
Shrimp
246
127
.660
-1
3.
Tharrats
779
624
.555
-1
4.
BATTLEDANNY1
398
286
.582
-1
5.
ukill
195
157
.554
+11
6.
Rodinho
510
384
.570
+1
7.
Wagggggggh!哈哈
227
164
.581
-1
8.
フンッ！逃げるつもりかい！！
477
378
.558
+1
9.
King of Lee
281
205
.578
-2
10.
WTFD=
53
10
.841
+11

                    

						Data provided by 
						
						 Relic Entertainment
					