Hi, can you help? Take a look at this! Given a list of 800 draws, what is the appearance percentage for each Pick 3 number?

[Frank]

you obviously dont understand what Im telling you. you have to change that link to make it work. Look at it!

 

[jack]

Try sending an email to julceubianchett@gmail.com—you need to combine the parts of the email address (write it all as one word) for it to work.

 

[Frank]

you have 5 minutes to download this then i will delete
https://www.mediafire.com/file/cqs33aqtc9id5qx/pick3_analysis_.xlsm/file

 

[Frank]

you have 5 minutes to download this then i will delete
https://www.mediafire.com/file/cqs33aqtc9id5qx/pick3_analysis_.xlsm/file

 

[Frank]

Time up file deleted. Where were you?

 

[jack]

I was in the bathroom, Frank; you can start the 7-minute countdown from now.

 

[Frank]

deleted link

 

[jack]

Okay, Frank—that’s a lot of work. Can I swap the draws for the ones from my Pick 3 lottery? Because those 800 entries were just to get the spreadsheet working. Now I have a lot of reading to do and bets to plan out. Thanks, Frank.

 

[Frank]

Okay, Frank—that’s a lot of work. Can I swap the draws for the ones from my Pick 3 lottery? Because those 800 entries were just to get the spreadsheet working. Now I have a lot of reading to do and bets to plan out. Thanks, Frank.

Yes you can delete the 800 and replace with other numbers. There are formulas to cope with up to 1500 draws. The latest draw is assumed to be at the bottom!

 

[jack]

Okay, 1,500—that's a good number of draws. Okay, thanks Frank!

 

[Frank]

Okay, 1,500—that's a good number of draws. Okay, thanks Frank!

Well, you’ve had it a week Jack. Any feedback, how are you getting on with this?