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

winsumloosesum — Sat, 26 Dec 2009 19:05:57 GMT

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

... [ More ]