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