winsumloosesum's Blog

Pick 3 VTRAC / Neighbors Excel Program - Part 1

Below is a download link for a Pick 3 Excel program that was shared on another forum a number of years ago.

I updated the Excel Program for all Pick 3 states.

The Excel files are in Excel 2002.  Not sure how they will work in older and newer versions of Excel.

Before you download the zip file:

1.  Create a new folder on your computer (C:\) and name it: Pick3NeighborsSystem

2.  Download the zip file from the link below into this new folder

3.  Unzip the 4 Excel files into this new folder

http://www.box.net/shared/fimfjim1al

 

Post any questions or comments pertaining to Part 1

More information to come in next Blog posting.....

Entry #125

Neighbor Odd / Even

Courtesy of MikeK

Even Odd NeighborNumbers List with only BoxedNumbers

What are Neighbor Numbers?

Digits - Neighbor
0,1         0
2,3         1
4,5         2
6,7         3
8,9         4

Neighbor Number Excel Formula?
=INT(Digit*.5)  - for example if your first position digit is in cell a1 is 8 and wanted to enter this formula in cell e1 =INT(a1*.5) this would give you the "Neighbor Digit" of 4 (see chart above)

When you are looking at a EvenOddNeighborNumbers List with only BoxedNumbers you see that there really three types of EvenOddNeighborNumbers:
1. with 4 BoxedNumbers,
2. with 6 BoxedNumbers, and
3. with 8 BoxedNumbers.

This gives you a much better tracking system for
Boxed numbers than Vtracs provides.

EvenOddNeighborNumbers:
000(4)
000,001,011,111
EvenOddNeighborNumbers:
111(4)
222,223,233,333
EvenOddNeighborNumbers:
222(4)
444,445,455,555
EvenOddNeighborNumbers:
333(4)
666,667,677,777
EvenOddNeighborNumbers:
444(4)
888,889,899,999
EvenOddNeighborNumbers:
001(6)
002,003,012,013,112,113
EvenOddNeighborNumbers:
002(6)
004,005,014,015,114,115
EvenOddNeighborNumbers:
003(6)
006,007,016,017,116,117
EvenOddNeighborNumbers:
004(6)
008,009,018,019,118,119
EvenOddNeighborNumbers:
011(6)
022,023,033,122,123,133
EvenOddNeighborNumbers:
022(6)
044,045,055,144,145,155
EvenOddNeighborNumbers:
033(6)
066,067,077,166,167,177
EvenOddNeighborNumbers:
044(6)
088,089,099,188,189,199
EvenOddNeighborNumbers:
112(6)
224,225,234,235,334,335
EvenOddNeighborNumbers:
113(6)
226,227,236,237,336,337
EvenOddNeighborNumbers:
114(6)
228,229,238,239,338,339
EvenOddNeighborNumbers:
122(6)
244,245,255,344,345,355
EvenOddNeighborNumbers:
133(6)
266,267,277,366,367,377
EvenOddNeighborNumbers:
144(6)
288,289,299,388,389,399
EvenOddNeighborNumbers:
223(6)
446,447,456,457,556,557
EvenOddNeighborNumbers:
224(6)
448,449,458,459,558,559
EvenOddNeighborNumbers:
233(6)
466,467,477,566,567,577
EvenOddNeighborNumbers:
244(6)
488,489,499,588,589,599
EvenOddNeighborNumbers:
334(6)
668,669,678,679,778,779
EvenOddNeighborNumbers:
344(6)
688,689,699,788,789,799
EvenOddNeighborNumbers:
012(8)
024,025,034,035,124,125,134,135
EvenOddNeighborNumbers:
013(8)
026,027,036,037,126,127,136,137
EvenOddNeighborNumbers:
014(8)
028,029,038,039,128,129,138,139
EvenOddNeighborNumbers:
023(8)
046,047,056,057,146,147,156,157
EvenOddNeighborNumbers:
024(8)
048,049,058,059,148,149,158,159
EvenOddNeighborNumbers:
034(8)
068,069,078,079,168,169,178,179
EvenOddNeighborNumbers:
123(8)
246,247,256,257,346,347,356,357
EvenOddNeighborNumbers:
124(8)
248,249,258,259,348,349,358,359
EvenOddNeighborNumbers:
134(8)
268,269,278,279,368,369,378,379
EvenOddNeighborNumbers:
234(8)
468,469,478,479,568,569,578,579

No. of Results   : 220
No. of Selections: 35

Entry #124

Pick 3 Excel Formula Digit Returns

Special thanks to Excel experts at mrexcel.

Excel formula for calculating the number of digit returns from the previous drawing.

For example:

if in cells a1, b1, c1

2 0 0

if in cells

0 2 2

In cell d1 enter the following formula:

=SUMPRODUCT(IF(COUNTIF(A1:C1,{0,1,2,3,4,5,6,7,8,9}) <COUNTIF(A2:C2,{0,1,2,3,4,5,6,7,8,9}),COUNTIF(A1:C1,{0,1,2,3,4,5,6,7,8,9}),COUNTIF(A2:C2,{0,1,2,3,4,5,6,7,8,9})))

Then press the following keys at the same time (Control - Shift - Enter) on your keyboard.  You should see { } at the beginning and end of the formula.

Entry #123

Create an Excel UDF (User Defined Function)

Instructions for creating a UDF (User Defined Function) in Excel

How to Create Excel User Defined Functions

  1. Open up a new workbook.
  2. Get into VBA (Press Alt+F11)
  3. Insert a new module (Insert > Module)
  4. Copy and Paste the Excel user defined function examples -
  5. Get out of VBA (Press Alt+Q)
  6. Use the functions (They will appear in the Paste Function dialog box, Shift+F3, under the "User Defined" category)
Entry #122

Carbobs Excel Skip Formula

Thanks Carbob.  Have not tested yet.

=MATCH(TRUE,($B$11:$B$953=$H37)*($B$12:$B$954=I$36)>0,0)-1

Entry #121

Excel Formula - Boxed Pairs

This is a handy formla for creating a boxed pair

For example:

In cell P21 you have the pair 76 and you wanted the boxed pair 67 in cell Q21 below is the formula.

 

=CONCATENATE((MIN(LEFT(P21),RIGHT(P21))),,(MAX(LEFT(P21),RIGHT(P21))))

Entry #120

3 Digit and 4 Digit Excel Formulas

Creating Boxed Numbers from inividual cells:

Pick 3 - Digit 1 = Cell A1

            Digit 2 = Cell B1

            Digit 3 = Cell C1

Formula in Cell D1 - =VALUE(SMALL(A1:C1,1)&SMALL(A1:C1,2)&SMALL(A1:C1,3))

Format Cell D1 > Right Click Cell D1 > Format Cells > Number Tab > Custom > enter 3 zeroes (000) in Type Box > Click OK

 

===============================================================================

 

Creating Boxed Numbers from inividual cells:

Pick 4 - Digit 1 = Cell A1

            Digit 2 = Cell B1

            Digit 3 = Cell C1

            Digit 4 = Cell D1

Formula in Cell E1 - =VALUE(SMALL(A2:D2,1)&SMALL(A2:D2,2)&SMALL(A2:D2,3)&SMALL(A2:D2,4))

Format Cell E1 > Right Click Cell E1 > Format Cells > Number Tab > Custom > enter 4 zeroes (0000) in Type Box > click OK

Entry #119

LottoPro DOS Version 1987's - Pick 3

Believe it or not I have my old DOS Version 6.10 of LottoPro by MicroMedia Cascade Sierra.

Nice thing about it is that it still works on Windows Vista.

I spent hours on this DOS program trying to beat the Pennsylvania Pick 3 game.

I lost all my notes on how I set the program up.

Trying to recall what I did back in 1989 through 1997.  Coming back to me gradually.

I won straight bets with regularity using a system of past draws.

Past draws were 10, 20, 30, 40, 50, and 60.

Each set of draws that the program calculates will produce "stacks" reports.

1. Hot 1

2. Hot 2

3. Hot 3

4. Points

5. S.D. (Standard Deviation)

6. Mean

7. Hits

8. Since

So I would have a total of 42 pick 3 combinations.  I would NOT play these combinations but see how many times each digit occured in each positions 1 through 3.

The I would wheel the highest 2 to 3 numbers in each position.

So I would end up with 24 to 27 combinations.

Again, I would not play these.  I would look at previous days combos and look for re-occuring combinations and play those.

I though it would be interesting to post the Pick 3 combos for Pennsylvania Evening draws for Saturday, July 18, 2008.

Sometimes a straight combination will repeat even though it was drawn in the last few drawings.

 

002 102 212 302
007 107   307
012 112   312
017 117   317

The combination 312 actually appeared in the 3 previous calculations.

Lets see what happens Saturday Evening!!

Entry #116

Digit Combos to VTRAC - Excel Formulas

Pick 4 Digit Combo to VTRAC Combo

In cell A1 enter your Pick 4 Digit Combo

Example: 0012

Make sure you format the cell (Right Click cell A1> Select Format Cells > Click Custom in Category List > Enter 4 zeroes in the Type Box > Click OK

In cell B1 copy and paste this formula:

=SUMPRODUCT((MOD(MID(TEXT(A1,"0000"),ROW($1:$4),1),5)+1)*(10^(4-ROW($1:$4))))

The Pick 4 VTRAC Combo will now be in cell B1.

========================================================================

Pick 3 Digit Combo to VTRAC Combo

In cell A1 enter your Pick 3 Digit Combo

Example: 001

Makesure you format the cell (Right Click cell A1> Select Format Cells> Click Custom in Category List > Enter 3 zeroes in the Type Box> Click OK

In cell B1 copy and paste this formula:

=VALUE(CONCATENATE(MOD(VALUE(LEFT(TEXT(A1,"000"),1)),5)+1,MOD( VALUE(MID(TEXT(A1,"000"),2,1)),5)+1,MOD(VALUE(RIGHT(A1,1)),5)+1))

The Pick 3 VTRAC Combo will now be in cell B1.

Special thanks to members at MrExcel Forum for all their help!!!

Entry #115

Tuesday Evening - 11/6 - Power Pairs

10 States Power Pairs

==================================== 

Georgia-Kentucky-Maryland-Michigan-New Jersey

New York-Ohio-South Carolina-Tri-States-Virginia

====================================

Power Pairs

14_    9_8

29_    3_7

Key Pair to watch: *** 9_8

=====================================

Digit Combinations:

908, 918, 928, 938, 948, 958, 968, 978, 988, 998  ***Key Pair 9_8

307, 317, 327, 337, 347, 357, 367, 377, 387, 397

===================================== 

140, 141, 142, 143, 144, 145, 146, 147, 148, 149

290, 291, 292, 293, 294, 295, 296, 297, 298, 299

=====================================
Entry #114

Tuesday - Midday - 11/6 - Power Pairs

10 States Power Pairs

==================================== 

Georgia-Kentucky-Maryland-Michigan-New Jersey

New York-Ohio-South Carolina-Tri-States-Virginia

====================================

Power Pairs

5_8    9_8

29_    3_7

Key Pair to watch: *** 9_8

=====================================

Digit Combinations:

908, 918, 928, 938, 948, 958, 968, 978, 988, 998  ***Key Pair 9_8

307, 317, 327, 337, 347, 357, 367, 377, 387, 397

===================================== 

508, 518, 528, 538, 548, 558, 568, 578, 588, 598

290, 291, 292, 293, 294, 295, 296, 297, 298, 299

=====================================
Entry #113

Monday Eve - 11/5/07 - Power Pairs

10 States Power Pairs

==================================== 

Georgia-Kentucky-Maryland-Michigan-New Jersey

New York-Ohio-South Carolina-Tri-States-Virginia

====================================

Power Pairs

5_8    9_8

29_    3_7

Key Pair to watch: *** 9_8

=====================================

Digit Combinations:

908, 918, 928, 938, 948, 958, 968, 978, 988, 998  ***Key Pair 9_8

307, 317, 327, 337, 347, 357, 367, 377, 387, 397

===================================== 

508, 518, 528, 538, 548, 558, 568, 578, 588, 598

290, 291, 292, 293, 294, 295, 296, 297, 298, 299

=====================================
Entry #112

Monday - Midday - 11/5 - Power Pairs

10 States Power Pairs

==================================== 

Georgia-Kentucky-Maryland-Michigan-New Jersey

New York-Ohio-South Carolina-Tri-States-Virginia

====================================

Power Pairs

5_8    9_8

29_    10_

Key Pair to watch: *** 9_8

=====================================

Digit Combinations:

908, 918, 928, 938, 948, 958, 968, 978, 988, 998  ***Key Pair 9_8

100, 101, 102, 103, 104, 105, 106, 107, 108, 109

===================================== 

508, 518, 528, 538, 548, 558, 568, 578, 588, 598

290, 291, 292, 293, 294, 295, 296, 297, 298, 299

=====================================
Entry #111