In Part 3 I will explain how to use the Excel file "Pick3Neighbors"
To re-cap we opened all 4 Excel files and in the Excel file "StateToolbars" we clicked the Toolbar "GA3M" Georgia Midday. By clicking this Toolbar we transferred 1001 past Georgia Midday drawings to both the Excel files "Pick3Neighbors" and "Pick3VTRAC".
You should now be in the Excel file "Pick3Neighbors".
At the bottom of the of this Excel file there are many Tabs. Look for the "Arrows" at the bottom left hand corner of your screen. (see image below)
If you don not see the Tab labeled "DrawHistory" at the bottom you will need to click the arrows (see image above) in the left hand corner. The Tab labeled "DrawHistory" is the second Tab from the left.
Once you see the "DrawHistory" tab click it. If you scroll up to cell A1 you will see the very first drawing for Georgia Midday on Friday December 25, 2009 2-4-9.
Next, we want to run the calculations for Georgia Midday drawings.
Click the Tab labeled "Toolbars"
Click the Toolbar labeled "Copy Drawings To Neighbor Calc Sheet" (see image above). This should take a few seconds to calculate.
Next, we want to click the Toolbar labeled "Click To Sort Movement Charts". This will take about 5 to 10 seconds to calculate.
I will explain the calculations in Part 4......