- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 2:58 am
You last visited
April 18, 2024, 1:56 am
All times shown are
Eastern Time (GMT-5:00)
Pick 3 VTRAC / Neighbors Excel Program - Part 2
Published:
Updated:
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.......
Comments
Post a Comment
Please Log In
To use this feature you must be logged into your Lottery Post account.
Not a member yet?
If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.
Register