In Part 4 - A I will explain the next Tab labeled "NeighborCalc"
You should still be in the Excel file called "Pick3Neighbors".
Click the Tab at the bottom labeled "NeighborCalc" (see image below"
The purpose of this Pick 3 Program is to calculate the movements of "Neighbor" digits. Neighbor digits are similar to VTRACs where 2 digits are represented by 1 "Neighbor" number. For example, if you look at the image above look at the chart in cell range B1 through D6. In cell B2 you see the digits 0 and 1 and in cell D2 the "Neighbor" 0. So the "Neighbor" 0 = the digits 0 and 1. Look at the rest of the column B3 through B6 the remaining digits and their "Neighbor" equivalent in cell range D3 through D6.
If you look at the last midday Georgia drawing in the image above in cell B20 you see 249. If you move over to cells H20, I20, and J20 you see the "Neighbor" equivalent of 124. The previous drawing on the 24th of December was 118 and the "Neighbor" equivalent in cells H21, I21, and J21 was 004. What we want to look for is the "movement" of digits from one drawing to the next.
First let me explain each of the columns.
A20 and below is the Drawing Dates - example Fri-Dec 29 2009
B20 would be the actual drawing - example 249
D20, E20, F20 - Position 1, Position 2, and Position 3 - example 2 - 4 - 9
G20 is how many Neighbor" digits returned from the previous drawing in cells H20 - I20 - J20 and H21 - I21 - J21. So in this example the "Neighbor" digit return was 1 since the "Neighbor" digit 4 returned from the previous drawing in cell J21
K20 is the "Neigbor" combination from cell range H20 - I20 - J20 - example 124
L20 is either a Double (D), Triple (T), or No-Match (NM) from the drawn number in cell B20 -- example "NM" for no-match combo of 249 in cell B20
M20 is either a Double (D), Triple (T), or No-Match (NM) from the drawnnumber in cell K20 -- example "NM" for no-match combo of 124 in cell K20
N20 is the drawn combination from cell B20 - example 249
O20 is the boxed ascending version of the drawn number in cell B20 - example B20 is 249 the boxed version is 249
P20 is the neighbor number from cell K20 - example 124
Q20 is the boxed ascending version of the "Neighbor" combination in cell K20 - example B20 is 124 the boxed version is 124
R20 is the SUM of the "Neighbor" combination in cell K20 - example 124 equals SUM 7 (1 + 2 + 4)
Scroll up to cell range H1 through J6 is the current skip chart for the "Neighbor" digit Positions (1 - 2 -3) in cell columns H - I - J
Cell range N1 through R11 is the current skip chart for the digit Positions (1 - 2 - 3) in cell columns D - E - F
In Part 4 - B I will explain the next range of cells in the "NeighborCalc" Tab.....