Now that you downloaded the zip file and unzipped the 4 Excel files into the folder you named "Pick3NeighborSystem" I will explain how the Excel files work.
There are 4 Excel files:
1. "P3StateDraws" - this Excel file has all the drawings of all the States and Canadian Midday, Evening, and Combined drawings.
2. "Pick3Neighbors" - this Excel file will calculate "Neighbors" digits similar to VTRAC digits. (See previous Blog post on Neighbor Digits)
3. "Pick3VTRAC" - this Excel file will calculate "VTRAC" digits. (for more information about VTRACs see PERDUE's post in the Systems forum. VTRAC For Dummies)
4. "StateToolbars" - this Excel file has all the Toolbars for each state and Canadian draws. There are 3 Tabs at the bottom "MiddayStates", "CombinedStates", and "EveningStates"
For this Program to work correctly you will need have all 4 Excel files open.
Open any one of the 4 Excel files listed below. Once you have 1 of the above Excel files above opened just go to the Main Menu (Top) and choose File > Open then browse to the folder "Pick3NeighborSystem" and select any one of the remaining Excel files from the list above. Follow the same procedure until all 4 Excel files are open.
Once you have all 4 Excel files open we want to use the Excel file called "StateToolbars"
If your having a problem locating "StateToolbars" just look at the Taskbar at the bottom of your desktop and you should see all 4 Excel files. Just click the Excel file "StateToolbars"
The "StateToolbars" has 3 Tabs at the bottom. "MiddayStates", "CombinedStates", and "EveningStates" Tabs. Of course Midday and Combined are for those states that have 2 drawings per day.
Let's run a Midday state as an example. We will use Georgia Midday drawings only. So all we do is click the Tab at the bottom named "MiddayStates". Important: Remember all 4 Excel files shoould be open for this to work correctly.
So we are in the Tab labeled "MiddayStates" and we want to look at Georgia Pick 3 Midday Drawing only. Look for "GA3M" in cell column D (next to the number 6). Click the Toolbar "GA3M". When you click this Toolbar it will transfer 1001 Georgia Midday drawings from the Excel file "P3StateDraws" to 2 other Excel files named "Pick3VTRAC" and "Pick3Neighbors". This should take a few seconds. Once the transfer of draws is completed go the the Excel file named "Pick3Neighbors" by clicking the file name at the bottom of your Taskbar on your Desktop.
I will explain the "Pick3Neighbors" Excel file in Part 3 of the next Blog post.......