Original Blog Entry: Pick 3 VTRAC / Neighbors Excel Program - Part 4 - G

winsumloosesum — Tue, 29 Dec 2009 00:28:31 GMT

In this part we will show the area of the NeighborsCalc spreadsheet that has the suggested neighbors digit combinations to play for the next drawing.

This area of the NeighborCalc spreadsheet is based on 125 past draws.

In the image above in cell range CD19 through CF19 there is the TOP 3 neighbors digits for each position.

Cell CD19 the TOP 3 neighbor digits for Position 1 are 201

Cell CE19 the TOP 3 neighbor digits for Position 2 are 041

Cell CF19 the TOP 3 neighbor digits for Position 3 are 130

These are the suggested neighbor digits for the next drawing for December 26, 2009.

Let's look at the next line of suggested neighbor digits.

Cell CD20 the TOP 3 neighbor digits for Position 1 are 413

Cell CE20 the TOP 3 neighbor digits for Position 2 are 024

Cell CF20 the TOP 3 neighbor digits for Position 3 are 130

In the next cell CG20 you see the neighbor combo 124 converted from the actual drawing on December 25, 2009 which was 2-4-9

In cell CH20 you see the number 2. This represents the 2nd neighbor digit for Position 1 in cell CD20 which is 413.

In cell Ci20 you see the number 2. This represents the 2nd neighbor digit for Position 2 in cell CE20 which is 024.

In cell CJ20 the cell is blank because there were NO TOP 3 neighbor digits from cell CF20 which was 130. Remember the neighbor combo 124. The 4 (3rd Position) was not in the suggested picks or the TOP 3 movement neighbor digits of 130 in CF20.

Look at the image above at lines 46 and 47. You see a 1 in Position 1, Position 2, and Position 3. This means that the TOP movement neighbor digit was drawn in all 3 positions. So in cell CH46 you see the number 1, cell Ci46 has a number 1 , and cell CJ46 has a number 1 . The neighbor combo in cell CG46 was 4-3-1. The 4 was the 1st digit from cell CD46 (413), the 3 was the 1st digit from cell CE46 (310), and the 1 was the 1st digit from cell CF46 (142). In cell CL46 and CL47 you see 111. Also you see in cells CM46 and CM47 you see STRAIGHT in each cell.

Anytime you see a STRAIGHT in column CM the neighbor combo had 1 digit from each position drawn from the TOP 3 movements . Either a 1, 2, or 3.

So the key is to play a limited number of combinations. If you play just the TOP 1 neighbor digit in each position you end up playing 8 combinations. If you play the TOP 2 neighbor digits from each position you would be playing 64 combinations. All 3 from each position would be 216 combinations.

If you scroll over to cell columns DA19 through DJ20. This is the same information as explianed above. The only difference is that the neighbor digit selections are calculated from 1000 drawings (or the total of draw history for your state) In the Florida Midday draw history it would represent 585 Total Midday drawings not 1000.

If you scroll over to cell columns CO19 through CW20. The cells are blank. This is left blank if you want to create your own set of neighbor combos.

... [ More ]