- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 5:31 am
You last visited
April 26, 2024, 1:13 am
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...
Comments
This Blog entry currently has no comments.
Post a Comment
Please Log In
To use this feature you must be logged into your Lottery Post account.
Not a member yet?
If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.
Register