Welcome Guest
The time is now 12:57 am
You last visited June 26, 2017, 11:30 pm
All times shown are
Eastern Time (GMT-5:00)

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

Published:

In the next section of the "NeighborCalc" Tab is the calculations of the "movements" for each "neighbor" 0, 1, 2, 3, and 4

In cell BH1 you see the zero (0) and to the right the "movements" (-4, -3, -2, -1, 0 , 1, 2, 3, 4) (see image above)

So in this section we are calculating the movements for "neighbor" 0 (zero) the top chart in cell range BI1 through BR4 calculates or totals the number of times each movement has occured.  For example in cell BR1 you see the movement "4" and below you see in cell BR2 the number 9.  This means that in the last 125 drawings (in which the calculations are based) a "movement" of 4 (BR1) has occured 9 times in the last 125 drawings.  In the chart below in cell range Bi8 through BR12 the calculations are based on the last 1000 drawings.

The calculations from the above chart are taken from the following:

On line 14 you see the "Movement = 0" (zero)

In cell column BI 20 you see the number 1.  Scroll over to the left to cell H21.  You see the "neighbor" digit of 0 (zero).  The "neighbor" digit 0 (zero) is from the previous drawing on Thurs Dec 24, 2009 Florida Midday drawing.  The drawing was 1-1-8.  Using the "neighbor" chart in the 1st Position the drawn digit was a 1 and the "neighbor" equivalent is a "neighbor" 0 (zero).  Now look at the most current drawing on December 25 2009 you see the 1st Position neighbor digit in cell H20 is the "neighbor" digit 1.  So the difference or spread between the 0 (zero) and the 1 equals +1 (0 to 1 = +1).  So in cell BI20 you see the "movement" number 1.  Look at cell BJ20 you see the "movement" of 2.  Scroll back over again to cell E21 you see the 2nd Position for the drawn combinaton  118 on Dec 24th 2009 is a "1" and again the "Neighbor" digit is again a 0 (zero) in cell i21.  The difference or spread between the 0 (zero) in cell i21 and i20 equals 2.  So in cell BJ20 you see the "movement" of 2.

Remember this area of the spreadsheet is for "Neighbor" digit 0 (zero) "movement" calculations.  If you scroll to the right of this worksheet you will see the charts for "Neighor" digits 1, 2, 3, and 4.

The chart in cell range BT1 through CD12 are the calculations for the "movements for "Neighbor" digit 1 starting in cell columns BM20, BN20, and BD 20.

The chart in cell range CF1 through CP12 are the calculations for the"movements for "Neighbor" digit 2 starting in cell columns BQ20, BR20,and BS 20.

The chart in cell range CR1 through DB12 are the calculations for the"movements for "Neighbor" digit 3 starting in cell columns BU20, BV20,and BW 20.

The chart in cell range DD1 through DN12 are the calculations for the"movements for "Neighbor" digit 4 starting in cell columns BY20, BZ20,and CA 20.

Scroll over to cell range BY20 through CA20 (see image below)

You see in cell CA20 the number 0 (zero).  The 0 (zero) represents the "movement" of 0 (zero) from the previous "Neighbor" digit  "4" drawing from Dec 24 2009.  If you scroll to the left to cell range J20 and J21 you see in the 3rd Position in cell J21 the "neighbor" digit was a 4 and in cell J20 the "neighbor" digit was a 4.  So the movement would be 0 (zero).

More to come in Part 4 - E......

Entry #131