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.