pattern and shift in even and odd lottery

[excelguy1234]

Hello,
Trying to found away to find next pattern or shift change using excel. please see below.

E-E-O-O-E
E-E-O-E-E
O-O-E-E-E
E-O-E-O-O
E-E-E-O-O
E-E-O-O-O
O-O-E-O-O
E-O-E-E-O
O-E-O-O-O
E-O-E-E-E
E-E-E-E-O
O-E-O-E-O
E-O-E-O-E
O-E-E-O-O
O-E-O-O-E
E-O-O-E-O
O-O-E-E-O
E-O-O-O-E
O-E-E-O-E
O-O-O-O-O
O-E-E-E-O

 

[Drrellik]

If you are working on a spreadsheet for guessing lottery numbers, it seems like you approach is; will the next number be odd or even? that only cuts your 'chances' in half you might want to look at likelihood of a range of numbers for the 'first' (lowest) ball, then 2nd, then 3rd, we already know that the 3rd number can not be a 2 and the chances of the 4th and 5th balls being 4 & 5 are very unlikely generally speaking the 5th number is usually 55+ and the first number is <15 I would think you look for patterns and probabilities in a range of numbers before you would just look for odd or even.