You last visited June 19, 2013, 3:37 pm All times shown are Eastern Time (GMT-5:00) | NJ Pick 3 System - Answer 4 CorrectNew Jersey United States Member #2256 September 1, 2003 3718 Posts Online | | Posted: January 17, 2013, 2:59 am - IP Logged | |
Steve as always so very impressed by your thought process and skills using Excel! Thank you so much for thinking of us here at Lottery Post! Great Job and please keep the great work and Ideas coming. Oh by the way........ I don't see a sheet for Georgia? Can we get one as well??  What version of Excel are you using? | | |
Taichung Taiwan Member #114138 July 24, 2011 2383 Posts Offline | | Posted: January 17, 2013, 3:09 am - IP Logged | |
Hi Steve
Havent had too much time on it but i have looked at it and im still trying to get the hang of it.
Thanks again. Jack of all Games, Master of None! | | |
ORLANDO, FLORIDA United States Member #5011 June 3, 2004 3547 Posts Offline | | Posted: January 17, 2013, 5:38 am - IP Logged | |
9With a Standard membership, I don't think you can do it. Open Lotsoft, click the yellow button," Administrate Own Series". Click the "add Series for AllStates", you get this screenshot, 
To get the structures, goto Excel workbook. In column AB, enter the values for P7,P8,P9,P10, filter for each structure the values will be in Column A. | | |
New Jersey United States Member #2256 September 1, 2003 3718 Posts Online | | Posted: January 17, 2013, 1:47 pm - IP Logged | |
Steve as always so very impressed by your thought process and skills using Excel! Thank you so much for thinking of us here at Lottery Post! Great Job and please keep the great work and Ideas coming. Oh by the way........ I don't see a sheet for Georgia? Can we get one as well??  Here are the download links to the Georgia Pick 3 Excel files: Excel 2012 Version: https://www.box.com/s/bk00rb1yecg7t8d20sho Excel 1997 - 2003 Version: https://www.box.com/s/vdkyy8salylegf4d0dqb | | |
United States Member #111738 May 31, 2011 101 Posts Offline | | Posted: January 17, 2013, 3:56 pm - IP Logged | |
Hello, stern, it's just an idea, I do not want to mess up your good work L = 1, 2.3 M = 4, 5, 6.7 H = 8, 9.0 | LLL | 27 | 2,70 | 37,0370 | 2 | LLM | 36 | 3,60 | 27,7778 | 3 | LLH | 27 | 1 | 37,0370 | 4 | LML | 36 | 3,60 | 27,7778 | 5 | LMM | 48 | 4,80 | 20,8333 | 6 | LMH | 36 | 3,60 | 27,7778 | 7 | LHL | 27 | 2,70 | 37,0370 | 8 | LHM | 36 | 3,60 | 27,7778 | 9 | LHH | 27 | 2,70 | 37,0370 | 10 | MLL | 36 | 3,60 | 27,7778 | 11 | MLM | 48 | 4,80 | 20,8333 | 12 | MLH | 36 | 3,60 | 27,7778 | 13 | MML | 48 | 4,80 | 20,8333 | 14 | MMM | 64 | 6,40 | 15,6250 | 15 | MMH | 48 | 4,80 | 20,8333 | 16 | MHL | 36 | 3,60 | 27,7778 | 17 | MHM | 48 | 4,80 | 20,8333 | 18 | MHH | 36 | 3,60 | 27,7778 | 19 | HLL | 27 | 2,70 | 37,0370 | 20 | HLM | 36 | 3,60 | 27,7778 | 21 | HLH | 27 | 2,70 | 37,0370 | 22 | HML | 36 | 3,60 | 27,7778 | 23 | HMM | 48 | 4,80 | 20,8333 | 24 | HMH | 36 | 3,60 | 27,7778 | 25 | HHL | 27 | 2,70 | 37,0370 | 26 | HHM | 36 | 3,60 | 27,7778 | 27 | HHH | 27 | 2,70 | 37,0370 |
Not a result example = 458 = MMH Then 27 possibility or permutaçoes How is Steve = Stern? | | |
Ontario Canada Member #109268 April 9, 2011 7125 Posts Online | | Posted: January 17, 2013, 7:37 pm - IP Logged | |
LottoBux, Can you explain how you came up with the XBXB ?? Thanks CG Carli, It Was More Observational Than Mathematical. I noticed in Row 10 that the B was due,then in the Hit/Skip chart,the xBxB had a good hit ratio(Not the Highest,Nor the lowest) but had skipped 37 draws(Again,not the highest nor the lowest) I don't always go with the The Hottest or Coldest choice. If I had a second choice I probably would have went with BxxB

| | |
Florida United States Member #67077 October 30, 2008 3260 Posts Online | | Posted: January 17, 2013, 7:43 pm - IP Logged | |
Carli, It Was More Observational Than Mathematical. I noticed in Row 10 that the B was due,then in the Hit/Skip chart,the xBxB had a good hit ratio(Not the Highest,Nor the lowest) but had skipped 37 draws(Again,not the highest nor the lowest) I don't always go with the The Hottest or Coldest choice. If I had a second choice I probably would have went with BxxB

Thanks for the explanation . Sometimes Im a little slow catching on, but I get there eventually . Really appreciate it. Carlig | | |
Ontario Canada Member #109268 April 9, 2011 7125 Posts Online | | Posted: January 17, 2013, 7:48 pm - IP Logged | |
Hi Steve, Any Chance Of You Doing Up A File For Ontario? I Have Excel 2010 Thanks In Advance...LB | | |
New Jersey United States Member #2256 September 1, 2003 3718 Posts Online | | Posted: January 17, 2013, 11:18 pm - IP Logged | |
Hi Steve, Any Chance Of You Doing Up A File For Ontario? I Have Excel 2010 Thanks In Advance...LB LottoBux Here is the Ontario Excel 2010 version: https://www.box.com/s/0u0ghz5uwcup758fbmhu | | |
New Jersey United States Member #2256 September 1, 2003 3718 Posts Online | | Posted: January 17, 2013, 11:38 pm - IP Logged | |
I updated Excel program today. I still need to update some of the other states / requests from previous days. I will try and update the following states in the next couple days. In the mean time you can use the Georgia or Ontario Excel file as an example. Western Canada, Texas, Tennessee, Taiwan, Pennsylvania, New Mexico, North Carolina, Minnesota
I received a suggestion to add Even/Odd and Low/High.
You can use the Pick 3 sets that DO NOT have All Even, All Odd, All Low, All High.
I had this thought this morning of just picking the positions 7, 8, and 9 and not select the position 10.
Here is my idea:
1. Select Positions 7, 8, and 9
2. Click the Tab at the bottom labeled "StakesWorkoutStraightsEVEN". Enter your Position 7, 8, 9 selections is cells AC2, AD2, AE2
3. Click the Tab at the bottom labeled "StakesWorkoutStraightsODD". Enter your Position 7, 8, 9 selections is cells AC2, AD2, AE2
4. Click the Tab at the bottom labeled "StakesWorkoutStraightsEVEN". You have a few options as far as filtering Sets, Short Sums, Short Sums High, Short Sums Low, All Low/All High, All Even / All Odd. 5. Click the Tab at the bottom labeled "StakesWorkoutStraightsODD". You have a few options as far as filtering Sets, Short Sums, Short Sums High, Short Sums Low, All Low/All High, All Even / All Odd.
One last thing I wanted to show you is that I created a new Tab labeled "1000Numbers3"
In this Tab will show you what numbers are out the longest based on how many past draws you want to use.
Click the Tab labeled "1000Numbers3"
Go to cell K12. You should see 2000
2000 represents the total number of draws to analyze.
You can change this to whatever number you want 2000, 1000, 500, etc.
Scroll over to cell columns CJ:CQ.
These are the Pick 3 numbers that have NOT been drawn based on what you entered in cell K12 (2000, 1000, 500 etc.) Of corse the lower the number in cell K12 the more Pick 3 sets will appeat in these columns
In cell range CJ2 through CQ2 show how many Pick 3 sets are in each column.
Cell columns CJ through CQ are the Pick 3 sets with the 3rd position being an even digit
Cell columns CS through CZ are the Pick 3 sets with the 3rd position being an odd digit.
It would be interesting to see how many numbers are drawn over the course of the upcoming draws are over 2000, 1000 draws.
Let me know if you have any questions.
Steve | | |
Ontario Canada Member #109268 April 9, 2011 7125 Posts Online | | Posted: January 18, 2013, 1:31 am - IP Logged | |
Thanks Steve Really Appreciate All The Work That You Put Into This.It's getting late;I'll wait til 2morrow to dig into this program. LB | | |
New Jersey United States Member #2256 September 1, 2003 3718 Posts Online | | Posted: January 18, 2013, 9:03 am - IP Logged | |
Tennessee Updates Update later today | | |
ORLANDO, FLORIDA United States Member #5011 June 3, 2004 3547 Posts Offline | | Posted: January 18, 2013, 4:09 pm - IP Logged | |
I updated Excel program today. I still need to update some of the other states / requests from previous days. I will try and update the following states in the next couple days. In the mean time you can use the Georgia or Ontario Excel file as an example. Western Canada, Texas, Tennessee, Taiwan, Pennsylvania, New Mexico, North Carolina, Minnesota
I received a suggestion to add Even/Odd and Low/High.
You can use the Pick 3 sets that DO NOT have All Even, All Odd, All Low, All High.
I had this thought this morning of just picking the positions 7, 8, and 9 and not select the position 10.
Here is my idea:
1. Select Positions 7, 8, and 9
2. Click the Tab at the bottom labeled "StakesWorkoutStraightsEVEN". Enter your Position 7, 8, 9 selections is cells AC2, AD2, AE2
3. Click the Tab at the bottom labeled "StakesWorkoutStraightsODD". Enter your Position 7, 8, 9 selections is cells AC2, AD2, AE2
4. Click the Tab at the bottom labeled "StakesWorkoutStraightsEVEN". You have a few options as far as filtering Sets, Short Sums, Short Sums High, Short Sums Low, All Low/All High, All Even / All Odd. 5. Click the Tab at the bottom labeled "StakesWorkoutStraightsODD". You have a few options as far as filtering Sets, Short Sums, Short Sums High, Short Sums Low, All Low/All High, All Even / All Odd.
One last thing I wanted to show you is that I created a new Tab labeled "1000Numbers3"
In this Tab will show you what numbers are out the longest based on how many past draws you want to use.
Click the Tab labeled "1000Numbers3"
Go to cell K12. You should see 2000
2000 represents the total number of draws to analyze.
You can change this to whatever number you want 2000, 1000, 500, etc.
Scroll over to cell columns CJ:CQ.
These are the Pick 3 numbers that have NOT been drawn based on what you entered in cell K12 (2000, 1000, 500 etc.) Of corse the lower the number in cell K12 the more Pick 3 sets will appeat in these columns
In cell range CJ2 through CQ2 show how many Pick 3 sets are in each column.
Cell columns CJ through CQ are the Pick 3 sets with the 3rd position being an even digit
Cell columns CS through CZ are the Pick 3 sets with the 3rd position being an odd digit.
It would be interesting to see how many numbers are drawn over the course of the upcoming draws are over 2000, 1000 draws.
Let me know if you have any questions.
Steve After looking at the Fl eve draws, you may not need anything but P789 and either Odd or Even. The pkg is about as evenly split as you will get. You will have to filter for single, doubles or trips. | P789 | PKG | HITS | MED | MAX | DUE | AVG | SKIP | | BXXO | 63 | 121 | 10 | 66 | 0 | 14.12 | 2 | | BXBO | 63 | 118 | 12 | 48 | 1 | 14.47 | 10 | | BBBO | 63 | 117 | 11 | 73 | 1 | 14.60 | 8 | | XXXO | 62 | 117 | 12 | 56 | 1 | 14.60 | 16 | | BBBE | 63 | 112 | 10 | 66 | 0 | 15.25 | 0 | | BBXO | 63 | 111 | 11 | 80 | 2 | 15.39 | 26 | | BXXE | 63 | 110 | 11 | 76 | 2 | 15.53 | 27 | | XBXE | 62 | 108 | 11 | 89 | 1 | 15.81 | 21 | | XXXE | 62 | 108 | 11 | 74 | 0 | 15.81 | 1 | | XXBO | 62 | 106 | 10 | 112 | 0 | 16.11 | 3 | | BBXE | 63 | 103 | 11 | 84 | 1 | 16.58 | 13 | | XBBE | 62 | 102 | 11 | 96 | 0 | 16.75 | 4 | | XBXO | 62 | 99 | 13 | 83 | 4 | 17.25 | 68 | | BXBE | 63 | 92 | 12 | 116 | 0 | 18.57 | 6 | | XXBE | 62 | 92 | 13 | 74 | 2 | 18.57 | 29 | | XBBO | 62 | 89 | 15 | 71 | 0 | 19.19 | 5 |

| | |
|