Welcome Guest
The time is now 5:21 am
You last visited January 22, 2017, 5:09 am
All times shown are
Eastern Time (GMT-5:00)

# Pick 3 VTRAC / Neighbors Excel Program - Part 4 - E

Published:

In the next section of the "NeighborCalc" worksheet I will explain the "Movement" calculations.  The following charts are based on 125 past drawings and 1000 past drawings (if your state has 1000 past drawings then it will calculate what is in the data history)

Scroll over to cell EB1 in the "NeighborCalc" Tab

In the charts above these are the calculations for the "movements" of the "neighbor" digits.

The top 3 charts in cell range EB1 through EM6 are calculations based on 125 past draws

The middle charts in cell range EB8 through EM13 are custom charts for manual entries

The bottom charts in cell range EB15 through EM20 are calculations for 1000 past drawings (if your draw history has less than 1000 past draws the calculations are based on the number of draws in your states draw history)

We will concentrate on cell range EB1 through EM6 for now.

In cell EM2 through EM6 you see "N - Zero", "N - One", "N - Two", etc.  The "N" is short for "Neighbor" and the "zero" is the "Neighbor" digit.

In cells EC1, ED1, EE1 you see P1.  This represents "Position 1".  The reason for 3 P1's in cells EC1, ED1, and EE1 is that we are calculation the TOP 3 movements for each "Neighbor" digit.

So for example in cell EC2, the TOP "movement" for "neighbor" zero (0) is 4,  the 2nd for Position 1 for "neighbor" 0 (zero) in cell ED2 is 1, and finally the 3rd is for Position 1 for "neighbor" 0 (zero) is 3.

So for Position 1 for "Neighbor" 0 (zero) the TOP 3 "movements" are 4, 1, and 3.

Scroll over to the right to cell range EG1 through Ei6 you see the chart for Position 2, and fo cell range EK1 through EM6 for Position 3.

So for "neighbor" 1 (0) the TOP 3 "movements" for Position 1 are: 4, 1, 3, Position 2 are 0, 2, 4 and Position 3 are 0, 3, 1

To get the calculations for these charts you need to click the Tab at the bottom and look for the Tab labeled "WorkoutSheetZero".  This workheet is the calculations for "neighbor" 0 (zero)

In this Tab "WorkoutSheetZero" the top chart is calculations for the past 125 draws and the bottom is for calculations for 1000 past draws (if your state has this many draws)

Notice in cell M8, M9, and M10 you see the TOP 3 "movements' for "neighbor' 0 (zero) for Position 1 which are 4, 1, 3

Notice in cell P8, P9, and P10 you see the TOP 3 "movements' for "neighbor' 0 (zero) for Position 2 which are 0, 2, 4

Notice in cell S8, S9, and S10 you see the TOP 3 "movements' for "neighbor' 0 (zero) for Position 3 which are 0, 3, 1

These are the calculations from this worksheet that are in the "NeigborCalc" worksheet.

Notice in the image above there are additional worksheets for "WorkoutSheetOne", "WorkoutSheetTwo", "WorkoutSheetThree", and "WorkoutSheetFour".  These are used to calculate the "movements" for "neighbors" 1, 2, 3, and 4 in the "NeighborCalc" worksheet.

So for example, you click the worksheet "WorkoutSheetOne".  In cell range M8, M9, and M10 you will see TOP movements for Position 1 at 1, -1, and 0 (zero).  If you click the Tab labeled "NeighborCalc" and scroll over to cell range EC3 through EE3 you see for Position 1 1, -1, and 0 (zero)

So you can see how each "neigbor" movement for Positions 1, 2, and 3 are calculated using the other worksheets "WorkoutSheetZero", "WorkoutSheetOne", "WorkoutSheetTwo", "WorkoutSheetThree", and "WorkoutSheetFour".

In Part 4 - F I will explain how we take the TOP "movements" and convert them to "neighbor" combos.....

Entry #132