Welcome Guest
( Log In | Register )
The time is now 6:31 pm
You last visited December 13, 2017, 6:29 pm
All times shown are
Eastern Time (GMT-5:00)

Powerball and Match6 excel reworks

Published:

spent a few hours completely redesigning my powerball and match6 sheets....

issue 1. Replacing the INT function with ROUND for more accuracy.

      for example =INT(MEDIAN(C$2:C175))  becomes  =ROUND((MEDIAN(C$2:C175)),0) in this way a result of 27.7 becomes 28 rather than 27. I did this to my entire set of spreadsheets...

issue 2. Short Term trend data... copied the entire sort and draw stat pages and made new ones looking back from 3 to 11 draws rather than at the whole history

issue 3. combining Long Term and Short Term and determining weights... done by best pernormance over a total of the draw history... do better, get a higher weight.

the big tests will happen tuesday for match 6 and wednesday for powerball. one line for each draw... if this works out well, I will have reduced my regular lottery budget to $8 per week (2 draws each for M6 and PBall... including powerplay)... I will eventually try this with the cash5, but for now I must focus on fine tuning and implementing a back-testing method (to gather a final error-correction mask)

to do...

fine tune Match6 sheet to match fine tuning of powerball short term stats...

back-test

convert cash5 sheet to new protocol....

 

 

so far 8 copies of the NBey6 workout have been freely distributed ,a NEW feature has been added, TicTacToe... total picks for each drawing now stand at 16. TTT implementation was at user request...

Entry #4

Comments

This Blog entry currently has no comments.

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.