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

winsumloosesum — Mon, 28 Dec 2009 15:23:14 GMT

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.....

... [ More ]