Well I don't follow all that nonsense, but I get the gist of it.
Well you can count how many of any colour fall in the same corner, e.g
16 20 34 56 57 work out at
YD YD YD YD ZC meaning four numbers are in the yellow zone AND in corner D, plus one other in the blue C corner.
If you plot where these numbers would fall in a table labelled
YA YB YC YD ZA ZB ZC ZD with a 1 for yes and a zero for No you would get
0 0 0 4 0 0 1 0.
This coding system can be used for all the draws. However this results in thousands of unique combinations of 0's and 1's which is no good for filtering. But removing the zeroes to create a 5 digit code ( the digits of which add to 5) reveals interesting results .
The above, for example reduces to 41.
From the results given only these codes are generated.
14
23
32
41
113
122
131
212
221
311
1112
1121
1211
2111
11111
Refer to the updated spreadsheet
https://www.mediafire.com/file/phx8jc5shupz3oj/Pasta2.xlsx/file
Using Autofilter in column
AG and setting the filter to count each ocurrence of the above codes, I have made a table (Planilha 2) of how common each code occurs, for the given number of 5642 draws.
it is clear that 11111 happens 50% of the time. This can mean a few things, such as all 4 corners A,b,c,d of one colour plus one in the blue, OR three corners in yellow, two in the blue, etc. it does not guarantee ALL corners A,b,c,d are covered over the 2 colour zones.
Much rarer are codes 14 or 23 or 32 or 41. with code 14 (favouring blue) one yellow corner, four in the same blue corner;- theres only 0.18% of them. Similarly 41 (favouring yellow) four in the same yellow corner and one blue;- there are only 0.41% of them in the results.
Cols W to AO are new on the spreadsheet and feature the above analysis. Planilha 2 cols O to Q feature
manually obained counts by using
Autofilter on column AG. Cell AG11 shows how many results satisfy the filter setting.
I trust you know how to use autofilter to verify those results.
Another thing to filter is how many zones or corners (A,B,C or D) are missing from
BOTH colours in a particular result. Thats what cols AJ to AO are looking at. For example 58% of those results have one zone letter missing in both colours. 16% have 2 zones missing. You can test this using the Autofilter in cell AN12, the count is also shown there. Note:- Use only one Auto filter at a time, results get double filtered if you use both at the same time.
There is also a table W1:AG7 which counts results in a specific corner, whether that be Yellow A, Blue C or whatever giving an average percentage of occurrences over history.
That concludes my work on this topic, Elvis has left the building.