Pick3 Lottery Spreadsheet

blitzed

Member
JUNAXCUBE said:
Good day.... can you please explain a little on how we could come up on a probable bet?

thanks...

hiya JUNXACUBE,

when you update the spreadsheet with draws from your pick3 lottery game, look at the M_A or E_A sheets...they give a bird's eye view of which numbers have hit in each ball slot, and which have been "Absent".

one basic strategy is to look on current M_A sheet, and for example look at the POS#3 which represents the last ballslot, 10columns AD to AM track number distribution by position. for example, XX2 has not been draw in the last 34 draws.

looking at the P sheet, probability of a digit being drawn none times at 35draws is only 2.50%, so XX2 has to fall sometime.

also, say 9 is a favorite digit I want to play...and for example say 45draws is the game history interval I want to watch...looking at columns AX to BB...I see NINE 3|5|1|9. it is the least drawn number at the 45draw interval...so XX9 would be the most probable way to play a 9.

looking at M_A sheet, 453 was most recent DRaW...sometimes MIRror digits within last few weeks of draws will contain the next draw or indicators for a pair...for example, looking at ME_A, both my midday & evening games are analyzed as one game...last midday draw is 453, and it can be found in the MIRror cells: F8 E9 E8.

a static matrix is sometimes useful in conjunction with other strategies. for example, on the E_M sheet, on row #3 IJK shows a draw 489...which is clustered in the matrix cells at A5 B5 A4. the next draw was 165, neatly clustered near the 489...spinning off from the 6 at B4.

another thing to explain playing within probability...on M_A sheet, AX to BB tracks how many times each digit fell into each ballslot over the last 45draws. I can crossref with the P sheet...A22:B23, highlight B25:B29, statusbar at bottom right shows 78.91%, probability that in any ballslot, a digit will be drawn two to six times in 45draws ...sooo back on M_A, AX to BB...a strategy could be to focus on the bulk of probability...play a digit in a slot, if it has been drawn 1 to 5 times, and your playfield represents where the draw numbers come from 78.91% of the time.

conditional formatting could even be added to highlight the ballslots which are most probable for you to play the digit in.

wow it is 3:30am:eek: I hope this basic explanation makes sense:spiny: time for sleep.

cheers!
blitzed:thumb:
 

JUNAXCUBE

Member
Thanks blitzed..... i'll try to understand more through analyzing the spreadsheet...

again thanks for your further explanation.....
 

blitzed

Member
JUNAXCUBE said:
Thanks blitzed..... i'll try to understand more through analyzing the spreadsheet...

again thanks for your further explanation.....

Hi JUNXACUBE, you are most welcome...I hope that the spreadsheet will help you gain some insight into your game.

I do not know spreadsheets well, but managed to figure out enough to do basic number tracking. Perhaps an expert on mathematics & spreadsheets could modify it, resulting in something even more useful.

Anyway, if you have any more questions, or even suggestions, just let me know.

good luck!
blitzed:thumb:
 

Sidebar

Top