- 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 2:36 am
You last visited
May 13, 2024, 2:13 am
All times shown are
Eastern Time (GMT-5:00)
Plain excel Pick-3 wheel and hit/skip statistics for few statesPrev TopicNext Topic
-
Hi,
I was posting about skip/hit statistics tracking under state Pick-3 and Pick-4 threads. I thought of posting them under one Post to get feed back. You can also PM me if you want report for another state or so.
You can see what's hot, cold and due. In addition you can see actual dueness and math dueness. I know these have been discussed in lot of threads. I wanted to start fresh with these charts to identify some pattern or so.
I put a word document in the same drive folder "Pick3_And_Pick4_Statistics_Guide.docx". There is clear explanation in this document about what's there in each sheet and how to interpret.
Here are
Pick-3 IL hit and Hit/Skip statistics as excels 03/16/2017
https://drive.google.com/open?id=0B4Qt2_2g3zs5STZ4enNnOXdJNG8
Pick 3 and Pick 4 NJ Hit/Skip statistics as excels 03/15/2017:
https://drive.google.com/open?id=0B4Qt2_2g3zs5ajRLMUlQN1FvemM
Pick 3 and Pick 4 IA Hit/Skip statistics as excels 03/15/2017:
https://drive.google.com/open?id=0B4Qt2_2g3zs5bGgxR2hNVDRpZFE
Draw files are named as Pick3C_ or Pick4C_ and IA/IL/NJ the state 2 letter code is suffixed to it.
Pick3C_IA.xlsx - Iowa Pick-3 draw file
Pick4C_IA.xlsx - Iowa Pick-4 draw file
Pick3Charts.xlsx - Pick-3 pairs and combo charts
Pick4Charts.xlsx - Pick-4 pairs and combo charts - also refer to above Pick3Charts file for triplet combo information
Statistics files:
file name interpretation:
Stat_PICK3_IA_02-19-2017_E_MAXDR_1_REP_E_P_90.xlsx
02-19-2017 Evening draw report based on just Evening Draws with 90 days(draws) used for statistics.
Note : Pick-4 statistics includes all 4 triplets statistics too XXX_, _XXX, X_XX, XX_X : front, back, split one, split two triplets
I know that the Pick-3 statistics posted above won't be fully useful without a wheel. I am going to work on a pick-3/4 wheel so that we can add new features.
For now, use this excel sheet to filter and pick combinations. For each statistics sheet's index(the value being analyzed e.g., digit 1) there is a corresponding column in this workbook.
If you want to filter root sum, short sum or sum or any of the classification in the statistics, you can use this excel sheet to filter out(also you can use excel's filtering feature to include few and exclude few - like a filter). All 1000 number's digits, sums, pairs, pair sums, classifications as boxes and straights, etc.,... everything is presented as separate column.
https://drive.google.com/open?id=0B4Qt2_2g3zs5Yzl2dDAtZkROVUk
Now you can use the statistics file and pick whatever you think will come(most out, most due or most frequent/hot) and then filter it out in this spreadsheet and pick your combinations... You can move around the columns - reorder them as per your need and even remove the ones you don't want.
For time being use this to filter combos. I will post a similar sheet for Pick-4 also.
Most of these sheet data and calculations are derived from discussions from various posts and threads started by following users : MonEL, Garyo, Paruths(Ricky), Steve(Winsumloosesum), Libra(index tool), Tntea and Blackapple's posts. And the reports resemble that of LotSoftPro/Versabet as it does the same calculations.
Note: there are no macros or any calculations in the sheet. The sheets are all output from program.
Thanks and Good Luck
-
Here is the Link to Word document with details : https://drive.google.com/open?id=0B4Qt2_2g3zs5S2xmRm1KRTBhaWs
Here are the details about hit/skip work books shared for Pick-3 and Pick-4 for Iowa:
The drive link includes Iowa draws files, pick 3 and pick 4 sums and other miscellaneous information as charts
Pick3C_IA.xlsx - Iowa Pick-3 draw file
Pick4C_IA.xlsx - Iowa Pick-4 draw file
Pick3Charts.xlsx - Pick-3 pairs and combo charts
Pick4Charts.xlsx - Pick-4 pairs and combo charts - also refer to above Pick3Charts file for triplet combo information
Statistics files:
File name interpretation:
Stat_PICK3_IA_02-19-2017_E_MAXDR_1_REP_E_P_90.xlsx
02-19-2017 Evening draw report based on just Evening Draws with 90 days(draws) used for statistics.
Note: Pick-4 statistics includes all 4 triplets statistics too XXX_, _XXX, X_XX, XX_X : front, back, split one, split two triplets
PICK -3 SHEETS
Here is a brief description of what's there in each sheet:
1. SHORT SUM - pick 3 short sums
2. ROOT SUM - pick 3 root sums
3. SUM - pick 3 sums
4. VTRACS SHORT SUM - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - short sum of vtracs digits
5. VTRACS ROOT SUM - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - root sum of vtracs digits
6. VTRACS SUM - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - sum of vtracs digits
7. FIRST DIGIT - pick 3 positional first drawn digit
8. SECOND DIGIT - pick 3 positional second drawn digit
9. THIRD DIGIT - pick 3 positional third drawn digit
10. COMBINED THREE DIGITS - pick 3 all 3 position digits together
11. FIRST VTRACS DIGIT - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - positional first drawn digit
12. SECOND VTRACS DIGIT - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - positional second drawn digit
13. THIRD VTRACS DIGIT - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - positional third drawn digit
14. COMBINED THREE VTRACS DIGITS - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - all 3 position digits together
15. FRONT PAIR WIDTH - pick 3 XX_ pair width
16. BACK PAIR WIDTH - pick 3 _XX pair width
17. SPLIT PAIR WIDTH - pick 3 X_X pair width
18. COMBINED THREE PAIR WIDTHS - pick 3 all XX_, _XX, X_X pairs widths
19. LOWMIDDLE PAIR WIDTH - pick 3 box arranged box combo (small to large) XX_ pair width
20. MIDDLEHIGH PAIR WIDTH - pick 3 box arranged box combo (small to large) _XX pair width
21. LOWHIGH PAIR WIDTH - pick 3 box arranged box combo (small to large) X_X pair width
22. COMBINED LOWMIDDLEHIGH THREE PAIR WIDTHS - pick 3 box arranged box combo (small to large) - all XX_, _XX, X_X pairs widths
23. BOX PAIR - pick 3 box form of each straight pair - all XX_, _XX, X_X pairs together
24. STRAIGHT PAIR - pick 3 all XX_, _XX, X_X straight pairs together
25. BOX COMBO - pick 3 box arranged box combo (small to large - sorted)
26. STRAIGHT COMBO - pick 3 straight combos (as such)
27. FRONT PAIR - pick 3 XX_ pair straight
28. BACK PAIR - pick 3 _XX pair straight
29. SPLIT PAIR - pick 3 X_X pair straight
30. FRONT PAIR BOX GROUP - pick 3 XX_ pair box form group (Consecutive, Double, Even, Ghost, Mirror and Odd)
31. BACK PAIR BOX GROUP - pick 3 _XX pair box form group (Consecutive, Double, Even, Ghost, Mirror and Odd)
32. SPLIT PAIR BOX GROUP - pick 3 X_X pair box form group (Consecutive, Double, Even, Ghost, Mirror and Odd)
33. COMBINED THREE PAIR BOX GROUPS - pick 3 all XX_, _XX, X_X pairs box form group (Consecutive, Double, Even, Ghost, Mirror and Odd)
34. BOX VTRACS PAIR - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - box form of each straight pairs - all XX_, _XX, X_X pairs together
35. STRAIGHT VTRACS PAIR - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - straight pairs - all XX_, _XX, X_X pairs together
36. BOX VTRACS COMBO - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - boxed - note this is box of the vtracs combo....
37. STRAIGHT VTRACS COMBO - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - straight converted.
38. FRONT VTRACS PAIR - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - XX_ pair.
39. BACK VTRACS PAIR - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - _XX pair.
40. SPLIT VTRACS PAIR - pick 3 vtracs (1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - X_X pair.
41. LOW-MIDDLE PAIR - pick 3 box arranged box combo (small to large) XX_ pair
42. MIDDLE-HIGH PAIR - pick 3 box arranged box combo (small to large) _XX pair
43. LOW-HIGH PAIR - pick 3 box arranged box combo (small to large) X_X pair; Note the box pair stats and these are different :-)
44. FRONT PAIR SHORT SUM - pick 3 XX_ pair straight short sum
45. FRONT PAIR ROOT SUM - pick 3 XX_ pair straight root sum
46. FRONT PAIR SUM - pick 3 XX_ pair straight sum
47. BACK PAIR SHORT SUM - pick 3 _XX pair straight short sum
48. BACK PAIR ROOT SUM - pick 3 _XX pair straight root sum
49. BACK PAIR SUM - pick 3 _XX pair straight sum
50. SPLIT PAIR SHORT SUM - pick 3 X_X pair straight short sum
51. SPLIT PAIR ROOT SUM - pick 3 X_X pair straight root sum
52. SPLIT PAIR SUM - pick 3 X_X pair straight sum
53. COMBINED PAIRS SHORT SUM - pick 3 XX_, XX_, X_X combined pairs straight short sum
54. COMBINED PAIRS ROOT SUM - pick 3 XX_, XX_, X_X combined pairs straight root sum
55. COMBINED PAIRS SUM - pick 3 XX_, XX_, X_X combined pairs straight sum
56. EVEN DIGITS SUM - pick 3 sum of all even digits in the combo
57. ODD DIGITS SUM - pick 3 sum of all odd digits in the combo
58. LOW NUMBERS SUM - pick 3 (L:0-4; H:5-9) sum of L numbers
59. HIGH NUMBERS SUM - pick 3 (L:0-4; H:5-9) sum of H numbers
60. PRIME NUMBERS COUNT - pick 3 total number of prime digits in the combo
61. FIRST NUMBER PRIME - pick 3 is first digit prime in the combo
62. SECOND NUMBER PRIME - pick 3 is second digit prime in the combo
63. THIRD NUMBER PRIME - pick 3 is third digit prime in the combo
64. VTRACS NUMBER TYPE - pick 3 vtracs combo number type (Single, Double, Triple)
65. NUMBER TYPE - pick 3 combo number type (Single, Double, Triple)
66. EVEN ODD TYPE BOX - pick 3 (E:0,2,4,6,8; O:1,3,5,7,9) EEE - boxed classification
67. HIGH LOW TYPE BOX - pick 3 (L: n <5; H: n>4) HHH - boxed classification
68. LOW MIDDLE HIGH TYPE BOX - pick 3 (L: 0,1,2 M: 3,4,5,6; H: 7,8,9) LMH - boxed classification
69. OPEN CLOSED STRAIGHT TYPE BOX - pick 3 Open closed straight (O: 2, 3, 5; C: 0, 6, 8, 9; S: 1, 4, 7) OCS - boxed classification
70. IN OUT TYPE BOX - pick 3 In Out (I: 3, 4, 5, 6, 7; O: 0, 1, 2, 8, 9) In/Out - boxed classification
71. BALA NCED TYPE BOX - pick 3 Bala Nced(B : 1, 2, 4, 5, 8; N: 0, 3, 6, 7, 9) BN - boxed classification
72. EVEN ODD TYPE STRAIGHT - pick 3 (E:0,2,4,6,8; O:1,3,5,7,9) EEE - straight classification
73. HIGH LOW TYPE STRAIGHT - pick 3 (L : n <5; H:n>4) HHH - straight classification
74. LOW MIDDLE HIGH TYPE STRAIGHT - pick 3 (L : 0,1,2 M : 3,4,5,6; H : 7,8,9 ) LMH - straight classification
75. OPEN CLOSED STRAIGHT TYPE STRAIGHT - pick 3 Open closed straight( O : 2, 3, 5; C: 0, 6, 8, 9; S : 1, 4, 7) OCS - straight classification
76. IN OUT TYPE STRAIGHT - pick 3 In Out(I : 3, 4, 5, 6, 7; O: 0, 1, 2, 8, 9) In/Out - straight classification
77. BALA NCED TYPE STRAIGHT - pick 3 Bala Nced(B : 1, 2, 4, 5, 8; N: 0, 3, 6, 7, 9) BN - straight classification
78. ROOT SUM EVEN ODD CLASSIFICATION - pick 3 group root sum of combo as E/O
79. ROOT SUM LOW MIDDLE HIGH CLASSIFICATION - pick 3 group root sum of combo as (L:0, 1, 2, 3; M:4, 5, 6; H: 7, 8, 9)
80. ROOT SUM ANONYMOUS THREE GROUP CLASSIFICATION - pick 3 group root sum of combo as (G1:0, 1, 4, 7; G2:2, 5, 8; G3: 3, 6, 9)
81. SUM LAST DIGIT EVEN ODD CLASSIFICATION - pick 3 group Short sum of combo as E/O
82. SUM LAST DIGIT LOW MIDDLE HIGH CLASSIFICATION - pick 3 group Short sum of combo as (L:0, 1, 2, 3; M:4, 5, 6; H: 7, 8, 9)
83. SUM LAST DIGIT ANONYMOUS THREE GROUP CLASSIFICATION - pick 3 group Short sum of combo as (G1:0, 1, 4, 7; G2:2, 5, 8; G3: 3, 6, 9)
84. CONSECUTIVE DIGITS - Pick 3 how many consecutive digits are present in the combo
85. DIGIT RETURN - pick 3 how many digits returned : 0,1,2,3
86. POSITIONAL DIGIT ANY POSITION RETURN - pick 3 positional digits 1,2,3 returned in any of the positions.
87. POSITIONAL DIGIT SAME POSITION RETURN - pick 3 positional digits 1,2,3 returned in the position (here it’s the position itself).
88. MIRROR RETURN - pick 3 how many mirror digits returned: 0,1,2,3
89. POSITIONAL MIRROR ANY POSITION RETURN - pick 3 positional digits 1,2,3 returned in any of the positions.
90. POSITIONAL MIRROR SAME POSITION RETURN - pick 3 positional digits 1,2,3 returned in the position (here it’s the position itself).
91. VTRACS DIGIT RETURN - Pick 3 did the vtracs return (note: this is bit different from mirror because this one would include self (same digit) and also, it's mirror)
92. BOX PAIR RETURN - pick 3 XX_,_XX,X_X boxed pairs return : 0,1,2,3
93. STRAIGHT PAIR RETURN - pick 3 XX_,_XX,X_X straight pairs return : 0,1,2,3
94. POSITIONAL BOX PAIR ANY POSITION RETURN - pick 3 XX_,_XX,X_X boxed pairs returned in any of the other 3 positions
95. POSITIONAL STRAIGHT PAIR ANY POSITION RETURN - pick 3 XX_,_XX,X_X straight pairs returned in any of the other 3 positions
96. POSITIONAL BOX PAIR SAME POSITION RETURN - pick 3 XX_,_XX,X_X boxed pairs returned in same position
97. POSITIONAL STRAIGHT PAIR SAME POSITION RETURN - pick 3 XX_,_XX,X_X straight pairs returned in same position
98. BOX MIRROR PAIR RETURN - pick 3 XX_,_XX,X_X mirror pair of boxed pairs return : 0,1,2,3
99. STRAIGHT MIRROR PAIR RETURN - pick 3 XX_,_XX,X_X mirror pair of straight pairs return : 0,1,2,3
100. POSITIONAL BOX MIRROR PAIR ANY POSITION RETURN - pick 3 XX_,_XX,X_X mirror pair of boxed pairs returned in any of the other 3 positions
101. POSITIONAL STRAIGHT MIRROR PAIR ANY POSITION RETURN - pick 3 XX_,_XX,X_X mirror pair of straight pairs returned in any of the other 3 positions
102. POSITIONAL BOX MIRROR PAIR SAME POSITION RETURN - pick 3 XX_,_XX,X_X mirror pair of boxed pairs returned in same position
103. POSITIONAL STRAIGHT MIRROR PAIR SAME POSITION RETURN - pick 3 XX_,_XX,X_X mirror pair of straight pairs returned in same position
104. COMBO RETURN - pick 3 - Did the previous draw combo return as box or straight....If you use LotSoft pro or have gone through MonEL, Garyo, Paruths, Steve(Winsumloosesum), Libra(index tool) and Blackapple's posts, you can figure out most of these are derived from the threads were people have discussed...
NUMBER
TIMES COUNTED
TIMES OCCURED
HIT PERCENTILE
CURRENT SKIP
AVERAGE SKIP
MEDIAN SKIP
MAX SKIP
DUENESS
MATH AVERAGE SKIP
MATH DUENESS
CALCULATED DUENESS
SKIP AND HIT
SKIP AND HIT COUNTER
The value for which statistics is printed
Number of times the particular value was counted as part of hits
Real number of times the value occurred: difference is that even if a number occurred more than once, we will see +2 here for it rather than +1 in the previous column
this is just times/overall count of all rows...
how many draws this event didn’t show up(didn't occur)
this is average of all skips
this is median of all skips
what's the max number of time this event skipped
how much due is it : current skip/average skip
this is the actual average skip in a hypothetical game of pick-3 where all 1000 numbers are drawn and the game closed with 1000 draws...
how much mathematically due this event is : current skip/math average skip
this is to facilitate usage of math average due if an event hasn't occurred but we also don’t want to set the dueness as 1 for it. Instead we will use math due for all events that didnt occur i.e., times counted=0
this is the sum of skips in exact order
this is the actual plotting of X/O for each occurrence
Hope you people got the needed info.
One more additional thing to note:
The math avg skip might look wrong in the following sheets:
PICK 3:
BOX PAIR
BOX VTRACS PAIR
COMBINED LOWMIDDLEHIGH THREE PAIR WIDTHS
COMBINED PAIRS ROOT SUM
COMBINED PAIRS SHORT SUM
COMBINED PAIRS SUM
COMBINED THREE DIGITS
COMBINED THREE PAIR BOX GROUPS
COMBINED THREE PAIR WIDTHS
COMBINED THREE VTRACS DIGITS
STRAIGHT PAIR
STRAIGHT VTRACS PAIRPICK 4:
BOX PAIR
BOX VTRACS PAIR
COMBINED FOUR DIGITS
COMBINED FOUR VTRACS DIGITS
COMBINED PAIRS ROOT SUM
COMBINED PAIRS SHORT SUM
COMBINED PAIRS SUM
COMBINED SIX PAIR BOX GROUPS
COMBINED SIX PAIR WIDTHS
STRAIGHT PAIR
STRAIGHT VTRACS PAIRIf you note, we are looking at hits and everything (average, median, dueness calculations) are based on hit(e.g., If I plot 112, the pairs are 11,12,11 - when I tick I will tick 11,12; the total occurrence of 11 is 2 and hit of 11 - 1 time).
Waiting for feedback about what else can be added or what improvements can be done...
PICK - 4 SHEETS
Here is a brief description of what's there in each sheets:
1. SHORT SUM - pick 4 short sums
2. ROOT SUM - pick 4 root sums
3. SUM - pick 4 sums
4. VTRACS SHORT SUM - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - short sum of vtracs digits
5. VTRACS ROOT SUM - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - root sum of vtracs digits
6. VTRACS SUM - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - sum of vtracs digits
7. FIRST DIGIT - pick 4 positional first drawn digit
8. SECOND DIGIT - pick 4 positional second drawn digit
9. THIRD DIGIT - pick 4 positional third drawn digit
10. FOURTH DIGIT - pick 4 positional fourth drawn digit
11. COMBINED FOUR DIGITS - pick 4 all 4 position digits together
12. FIRST VTRACS DIGIT - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - positional first drawn digit
13. SECOND VTRACS DIGIT - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - positional second drawn digit
14. THIRD VTRACS DIGIT - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - positional third drawn digit
15. FOURTH VTRACS DIGIT - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - positional fourth drawn digit
16. COMBINED FOUR VTRACS DIGITS - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - all 4 position digits together
17. FRONT PAIR WIDTH - pick 4 XX__ pair width
18. BACK PAIR WIDTH - pick 4 __XX pair width
19. SIDE PAIR WIDTH - pick 4 X__X pair width
20. SPLITONE PAIR WIDTH - pick 4 X_X_ pair width
21. SPLITTWO PAIR WIDTH - pick 4 _X_X pair width
22. MIDDLE PAIR WIDTH - pick 4 _XX_ pair width
23. COMBINED SIX PAIR WIDTHS - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ pairs width
24. LOWMIDDLE PAIR WIDTH - pick 4 box arranged box combo(small to large) XX__ pair width
25. LOWHIGH PAIR WIDTH - pick 4 box arranged box combo(small to large) X_X_ pair width
26. LOWUP PAIR WIDTH - pick 4 box arranged box combo(small to large) X__X pair width
27. MIDDLEHIGH PAIR WIDTH - pick 4 box arranged box combo(small to large) _XX_ pair width
28. MIDDLEUP PAIR WIDTH - pick 4 box arranged box combo(small to large) _X_X pair width
29. HIGHUP PAIR WIDTH - pick 4 box arranged box combo(small to large) __XX pair width
30. BOX PAIR - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ pairs - boxed
31. STRAIGHT PAIR - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ pairs - straight
32. BOX THREE DIGIT COMBO - pick 4 triads : XXX_, _XXX, X_XX, XX__X - together in boxed mode
33. STRAIGHT THREE DIGIT COMBO - pick 4 triads : XXX_, _XXX, X_XX, XX__X - together in straight mode
34. BOX COMBO - pick 4 box arranged box combo(small to large - sorted)
35. STRAIGHT COMBO - pick 4 straight combo(as such)
36. FRONT PAIR - pick 4 XX__ pair
37. BACK PAIR - pick 4 __XX pair
38. SIDE PAIR - pick 4 X__X pair
39. SPLITONE PAIR - pick 4 X_X_ pair
40. SPLITTWO PAIR - pick 4 _X_X pair
41. MIDDLE PAIR - pick 4 _XX_ pair
42. FRONT PAIR BOX GROUP - pick 4 XX__ pair box form group(Consecutive, Double, Even, Ghost, Mirror and Odd)
43. BACK PAIR BOX GROUP - pick 4 __XX pair box form group(Consecutive, Double, Even, Ghost, Mirror and Odd)
44. SIDE PAIR BOX GROUP - pick 4 X__X pair box form group(Consecutive, Double, Even, Ghost, Mirror and Odd)
45. SPLITONE PAIR BOX GROUP - pick 4 X_X_ pair box form group(Consecutive, Double, Even, Ghost, Mirror and Odd)
46. SPLITTWO PAIR BOX GROUP - pick 4 _X_X pair box form group(Consecutive, Double, Even, Ghost, Mirror and Odd)
47. MIDDLE PAIR BOX GROUP - pick 4 _XX_ pair box form group(Consecutive, Double, Even, Ghost, Mirror and Odd)
48. COMBINED SIX PAIR BOX GROUPS - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ pairs box form group(Consecutive, Double, Even, Ghost, Mirror and Odd)
49. BOX VTRACS PAIR - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - box form of each straight pairs - all XX__, __XX, X__X, X_X_, _X_X, _XX_ pairs together
50. STRAIGHT VTRACS PAIR - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - straight pairs - all XX__, __XX, X__X, X_X_, _X_X, _XX_ pairs together
51. BOX THREE DIGITS VTRACS COMBO - pick 4 triads vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - XXX_, _XXX, X_XX, XX__X - together in boxed mode
52. STRAIGHT THREE DIGITS VTRACS COMBO - pick 4 triads vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - XXX_, _XXX, X_XX, XX__X - together in straight mode
53. BOX VTRACS COMBO - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - boxed - note this is box of the vtracs combo....
54. STRAIGHT VTRACS COMBO - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - straight converted..
55. FRONT VTRACS PAIR - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - XX__ pair
56. BACK VTRACS PAIR - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - __XX pair
57. SIDE VTRACS PAIR - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - X__X pair
58. SPLITONE VTRACS PAIR - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - X_X_ pair
59. SPLITTWO VTRACS PAIR - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - _X_X pair
60. MIDDLE VTRACS PAIR - pick 4 vtracs(1-0,5; 2-1,6; 3-2,7; 4-3,8; 5-4,9) - _XX_ pair
61. LOWMIDDLE PAIR - pick 4 box arranged box combo(small to large) - XX__ pair
62. LOWHIGH PAIR - pick 4 box arranged box combo(small to large) - __XX pair
63. LOWUP PAIR - pick 4 box arranged box combo(small to large) - X__X pair
64. MIDDLEHIGH PAIR - pick 4 box arranged box combo(small to large) - X_X_ pair
65. MIDDLEUP PAIR - pick 4 box arranged box combo(small to large) - _X_X pair
66. HIGHUP PAIR - pick 4 box arranged box combo(small to large) - _XX_ pair ; Note the box pair stats and these are different :-)
67. FRONT PAIR SHORT SUM - pick 4 XX__ pair straight short sum
68. FRONT PAIR ROOT SUM - pick 4 XX__ pair straight root sum
69. FRONT PAIR SUM - pick 4 XX__ pair straight sum
70. BACK PAIR SHORT SUM - pick 4 __XX pair straight short sum
71. BACK PAIR ROOT SUM - pick 4 __XX pair straight root sum
72. BACK PAIR SUM - pick 4 __XX pair straight sum
73. SIDE PAIR SHORT SUM - pick 4 X__X pair straight short sum
74. SIDE PAIR ROOT SUM - pick 4 X__X pair straight root sum
75. SIDE PAIR SUM - pick 4 X__X pair straight sum
76. SPLITONE PAIR SHORT SUM - pick 4 X_X_ pair straight short sum
77. SPLITONE PAIR ROOT SUM - pick 4 X_X_ pair straight root sum
78. SPLITONE PAIR SUM - pick 4 X_X_ pair straight sum
79. SPLITTWO PAIR SHORT SUM - pick 4 _X_X pair straight short sum
80. SPLITTWO PAIR ROOT SUM - pick 4 _X_X pair straight root sum
81. SPLITTWO PAIR SUM - pick 4 _X_X pair straight sum
82. MIDDLE PAIR SHORT SUM - pick 4 _XX_ pair straight short sum
83. MIDDLE PAIR ROOT SUM - pick 4 _XX_ pair straight root sum
84. MIDDLE PAIR SUM - pick 4 _XX_ pair straight sum
85. COMBINED PAIRS SHORT SUM - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ pairs straight sum
86. COMBINED PAIRS ROOT SUM - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ pairs straight short sum
87. COMBINED PAIRS SUM - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ pairs straight sum
88. EVEN DIGITS SUM - pick 4 sum of all even digits in the combo
89. ODD DIGITS SUM - pick 4 sum of all odd digits in the combo
90. LOW NUMBERS SUM - pick 4 (L:0-4; H:5-9) sum of L numbers
91. HIGH NUMBERS SUM - pick 4 (L:0-4; H:5-9) sum of H numbers
92. PRIME NUMBERS COUNT - pick 4 number of prime digits in the combo
93. FIRST NUMBER PRIME - pick 4 is first digit prime in the combo
94. SECOND NUMBER PRIME - pick 4 is second digit prime in the combo
95. THIRD NUMBER PRIME - pick 4 is third digit prime in the combo
96. FOURTH NUMBER PRIME - pick 4 is fourth digit prime in the combo
97. VTRACS NUMBER TYPE - pick 4 vtracs combo number type ( Single, Double, Double-Double, Triple, Quad)
98. NUMBER TYPE - pick 4 combo number type ( Single, Double, Double-Double, Triple, Quad)
99. EVEN ODD TYPE BOX - pick 4 (E:0,2,4,6,8; O:1,3,5,7,9) EEEE - boxed classification
100. HIGH LOW TYPE BOX - pick 4 (L : n <5; H:n>4) HHHH - boxed classification
101. LOW MIDDLE HIGH TYPE BOX - pick 4 (L : 0,1,2 M : 3,4,5,6; H : 7,8,9 ) LLLL - boxed classification
102. OPEN CLOSED STRAIGHT TYPE BOX - pick 4 Open closed straight( O : 2, 3, 5; C: 0, 6, 8, 9; S : 1, 4, 7) OCSO - boxed classification
103. IN OUT TYPE BOX - pick 4 In Out(I : 3, 4, 5, 6, 7; O: 0, 1, 2, 8, 9) In/Out - boxed classification
104. BALA NCED TYPE BOX - pick 4 Bala Nced(B : 1, 2, 4, 5, 8; N: 0, 3, 6, 7, 9) BN - boxed classification
105. EVEN ODD TYPE STRAIGHT - pick 4 (E:0,2,4,6,8; O:1,3,5,7,9) EEEE - straight classification
106. HIGH LOW TYPE STRAIGHT - pick 4 (L : n <5; H:n>4) HHHH - straight classification
107. LOW MIDDLE HIGH TYPE STRAIGHT - pick 4 (L : 0,1,2 M : 3,4,5,6; H : 7,8,9 ) LLLL - straight classification
108. OPEN CLOSED STRAIGHT TYPE STRAIGHT - pick 4 Open closed straight( O : 2, 3, 5; C: 0, 6, 8, 9; S : 1, 4, 7) OCSO - straight classification
109. IN OUT TYPE STRAIGHT - pick 4 In Out(I : 3, 4, 5, 6, 7; O: 0, 1, 2, 8, 9) In/Out - straight classification
110. BALA NCED TYPE STRAIGHT - pick 4 Bala Nced(B : 1, 2, 4, 5, 8; N: 0, 3, 6, 7, 9) BN - straight classification
111. ROOT SUM EVEN ODD CLASSIFICATION - pick 4 group root sum of combo as E/O
112. ROOT SUM LOW MIDDLE HIGH CLASSIFICATION - pick 4 group root sum of combo as (L:0, 1, 2, 3; M:4, 5, 6; H: 7, 8, 9)
113. ROOT SUM ANONYMOUS FOUR GROUP CLASSIFICATION - pick 4 group root sum of combo as (G1:0, 1, 4, 7; G2:2, 5, 8; G3: 3, 6, 9)
114. SUM LAST DIGIT EVEN ODD CLASSIFICATION - pick 4 group Short sum of combo as E/O
115. SUM LAST DIGIT LOW MIDDLE HIGH CLASSIFICATION - pick 4 group Short sum of combo as (L:0, 1, 2, 3; M:4, 5, 6; H: 7, 8, 9)
116. SUM LAST DIGIT ANONYMOUS FOUR GROUP CLASSIFICATION - pick 4 group Short sum of combo as (G1:0, 1, 4, 7; G2:2, 5, 8; G3: 3, 6, 9)
117. CONSECUTIVE DIGITS - pick 4 how many consecutive digits are present in the combo
118. DIGIT RETURN - pick 4 how many digits returned : 0,1,2,3,4
119. POSITIONAL DIGIT ANY POSITION RETURN - pick 4 positional digits 1,2,3,4 returned in any of the positions.
120. POSITIONAL DIGIT SAME POSITION RETURN - pick 4 positional digits 1,2,3,4 returned in the position(here its the position itself).
121. MIRROR RETURN - pick 4 how many mirror digits returned : 0,1,2,3,4
122. POSITIONAL MIRROR ANY POSITION RETURN - pick 4 positional digits 1,2,3,4 returned in any of the positions.
123. POSITIONAL MIRROR SAME POSITION RETURN - pick 4 positional digits 1,2,3,4 returned in the position(here its the position itself).
124. VTRACS DIGIT RETURN - pick 4 did the vtracs return(note : this is bit different from mirror because this one would include self(same digit) and also it's mirror)
125. BOX PAIR RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ boxed pairs return : 0,1,2,3,4,5,6
126. STRAIGHT PAIR RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ straight pairs return : 0,1,2,3,4,5,6
127. POSITIONAL BOX PAIR ANY POSITION RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ boxed pairs returned in any of the other 6 positions
128. POSITIONAL STRAIGHT PAIR ANY POSITION RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ straight pairs returned in any of the other 6 positions
129. POSITIONAL BOX PAIR SAME POSITION RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ boxed pairs returned in same position
130. POSITIONAL STRAIGHT PAIR SAME POSITION RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ straight pairs returned in same position
131. BOX MIRROR PAIR RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ mirror pair of boxed pairs return : 0,1,2,3,4,5,6
132. STRAIGHT MIRROR PAIR RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ mirror pair of straight pairs return : 0,1,2,3,4,5,6
133. POSITIONAL BOX MIRROR PAIR ANY POSITION RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ mirror pair of boxed pairs returned in any of the other 6 positions
134. POSITIONAL STRAIGHT MIRROR PAIR ANY POSITION RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ mirror pair of straight pairs returned in any of the other 6 positions
135. POSITIONAL BOX MIRROR PAIR SAME POSITION RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ mirror pair of boxed pairs returned in same position
136. POSITIONAL STRAIGHT MIRROR PAIR SAME POSITION RETURN - pick 4 all XX__, __XX, X__X, X_X_, _X_X, _XX_ mirror pair of straight pairs returned in same position
137. COMBO RETURN - pick 4 - Did the previous draw combo return as box or straight....If you use LotSoft pro or have gone through MonEL, Garyo, Paruths, Steve(Winsumloosesum), Libra(index tool) and Blackapple's posts, you can figure out most of these are derived from the threads were people have discussed...
NUMBER
TIMES COUNTED
TIMES OCCURED
HIT PERCENTILE
CURRENT SKIP
AVERAGE SKIP
MEDIAN SKIP
MAX SKIP
DUENESS
MATH AVERAGE SKIP
MATH DUENESS
CALCULATED DUENESS
SKIP AND HIT
SKIP AND HIT COUNTER
The value for which statistics is printed
Number of times the particular value was counted as part of hits
Real number of times the value occurred: difference is that even if a number occurred more than once, we will see +2 here for it rather than +1 in the previous column
this is just times/overall count of all rows...
how many draws this event didn’t show up(didn't occur)
this is average of all skips
this is median of all skips
what's the max number of time this event skipped
how much due is it: current skip/average skip
this is the actual average skip in a hypothetical game of pick-3 where all 1000 numbers are drawn and the game closed with 1000 draws...
how much mathematically due this event is: current skip/math average skip
this is to facilitate usage of math avg due if an event hasn't occurred but we also don’t want to set the dueness as 1 for it. Instead we will use math due for all events that didnt occur i.e., times counted=0
this is the sum of skips in exact order
this is the actual plotting of X/O for each occurrence
Hope you people got the needed info.
One more additional thing to note:
The math average skip might look wrong in the following sheets:
PICK 3:
BOX PAIR
BOX VTRACS PAIR
COMBINED LOWMIDDLEHIGH THREE PAIR WIDTHS
COMBINED PAIRS ROOT SUM
COMBINED PAIRS SHORT SUM
COMBINED PAIRS SUM
COMBINED THREE DIGITS
COMBINED THREE PAIR BOX GROUPS
COMBINED THREE PAIR WIDTHS
COMBINED THREE VTRACS DIGITS
STRAIGHT PAIR
STRAIGHT VTRACS PAIRPICK 4:
BOX PAIR
BOX VTRACS PAIR
COMBINED FOUR DIGITS
COMBINED FOUR VTRACS DIGITS
COMBINED PAIRS ROOT SUM
COMBINED PAIRS SHORT SUM
COMBINED PAIRS SUM
COMBINED SIX PAIR BOX GROUPS
COMBINED SIX PAIR WIDTHS
STRAIGHT PAIR
STRAIGHT VTRACS PAIRIf you note, we are looking at hits and everything (average, median and dueness calculations) are based on hit (e.g., If I plot 112, the pairs are 11,12,11 - when I tick I will tick 11,12; the total occurrence of 11 is 2 and hit of 11 - 1 time).
Hope some of you like these and let me know if you need for some other state.
Thanks and Good Luck
-
Pick 3 Wheel excel has been modified -
It was missing LMH box and Open closed Straight box classifications
https://drive.google.com/open?id=0B4Qt2_2g3zs5MjFRWDNzZUJoTFU
Good Luck
-
I took a look, great work, thanks for sharing.
I like the one for Illinois.
Happy winning!
Missouri pick 3, giving out humble pies!
-
Quote: Originally posted by MzDuffleBaglady on Mar 18, 2017
I took a look, great work, thanks for sharing.
I like the one for Illinois.
Happy winning!
Thanks MzDuffleBagLady
-
Quote: Originally posted by thamizhpayan on Mar 18, 2017
Pick 3 Wheel excel has been modified -
It was missing LMH box and Open closed Straight box classifications
https://drive.google.com/open?id=0B4Qt2_2g3zs5MjFRWDNzZUJoTFU
Good Luck
Here is Pick 4 wheel excel:
https://drive.google.com/open?id=0B4Qt2_2g3zs5TlJEcGtwSUdlNE0
If you are following this thread and find any issues with opening excel statistics sheets, let me know. One issue I found so far is that the skip/hit counter column can grow to a string that's too long as each hit/skip generates a 0 or 1. Excel easily recovers those... This happens only in the stats excels which are run for extended period - especially combined and all draws... In case you cant recover those sheets let me know. I will put a fix to split that column data to two equal length strings and move the split content to next cell.
Also if there is any issue in the wheels let me know. I will fix.
Thanks
-
I added date last occurred in the report now:
Here are Iowa Hit/Skip charts generated today : 03/19/2017
https://drive.google.com/open?id=0B4Qt2_2g3zs5NU1jQnFudzlydDA
Combine this information with the Excel wheel and enhance your predictions.
Thanks and Good Luck
-
Talk about keys to the Pick3-4 Kingdom...this is it
-
Quote: Originally posted by Blackapple on Mar 19, 2017
Talk about keys to the Pick3-4 Kingdom...this is it
Hi Black Apple,
Thank you
-
-
-
Here are latest Pick 3 sheets for SC: 03/19/2017 ; draws till 03/18/2017
https://drive.google.com/open?id=0B4Qt2_2g3zs5bXBERUFDMGJ0S0E
I will share Pick -4 sheets also in the same location. I might upload them when the program completes
-
Quote: Originally posted by thamizhpayan on Mar 19, 2017
Here are latest Pick 3 sheets for SC: 03/19/2017 ; draws till 03/18/2017
https://drive.google.com/open?id=0B4Qt2_2g3zs5bXBERUFDMGJ0S0E
I will share Pick -4 sheets also in the same location. I might upload them when the program completes
SC Pick-4 sheets are also available now.
PM me in case you track separate state(need for another state) or if you have some improvements.
Thanks
-
Quote: Originally posted by thamizhpayan on Mar 19, 2017
Here are the latest NM files:
https://drive.google.com/open?id=0B4Qt2_2g3zs5OTdQVnY4R1VWMDg
Thanks!
-
Quote: Originally posted by lakerben on Mar 19, 2017
Thanks!
You are welcome
Hope people are liking it
Few are really able to experiment and use
Let me know if you need any enhancements