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

winsumloosesum — Sun, 27 Dec 2009 01:21:26 GMT

NeighborsCalc worksheet continued...

This next section of the worksheet display the movement of Neighbor digits for each position.

Cell P20 is the Neighbor combo 124 for the drawing of 249 on December 25th 2009 Georgia Midday drawing

Cell S20 contains the 1st Neighbor digit which is a 1

Cell AE20 contains the 2nd Neighbor digit which is a 2

Cell AQ20 contains the 3rd Neighbor digit which is a 4

What we are calculating is the movement from one drawing to the next for each position.

Notice in cell P21 the previous Neighbor combo was 004 for the drawing 118 drawn on December 24 2009 Georgia Midday drawing

The movement for Position 1 in cell AC20 is +1 ( 0 to 1 = +1) which is highlighted in cell Y20

The movement for Position 2 in cell AO20 is +2 (0 to 2 = +2) which is highlighted in cell AL20

The movement for Position 3 in cell BA20 is 0 ( 4 to 4 = 0) which is highlighted in cell AV20

So now we have a movement of +1, +2, and 0

The idea is to look at a set amount of previous drawings to track the best movement by position for each Neighbor combo so that we can choose combinations to play based on the top movements.

I will explain this later in a different posting. But I wanted to show what each area of this spreadsheet represents as we go forward.

More to com in the next post.....

... [ More ]