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

winsumloosesum — Sat, 26 Dec 2009 21:03:47 GMT

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.

Column:

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

... [ More ]