Welcome Guest
Log In | Register )
You last visited December 7, 2016, 1:12 pm
All times shown are
Eastern Time (GMT-5:00)

Pick 3 VTRAC Movement System - Excel

Topic closed. 33 replies. Last post 3 years ago by Gwoof.

Page 1 of 3
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: October 26, 2013, 8:13 am - IP Logged

This is an Excel file that I updated from another lottery forum called elotteryuniverse.  There was a member compulotto who also was a member here for a short while explaining how to use VTRAC's.

The Excel file I'm going to share will enable you to import a Pick 3 text file from you Pick 3 game into the Excel file.  I will provide the links to the zip files later today.  I just finished work at 6:30 am.

I'll also post some video on how to use the Excel file.

Here is the link to the Excel file for versions 2007 & 2010.  I'm not sure how version 2013 will work since I don't have the upgrade yet.

https://app.box.com/s/l9leekw2qydbbvm5huer

 

Excel version 1997 through 2003

https://app.box.com/s/ft597pc9bwas0itiy8ws

 

Here is what you need to do to get this set up correctly.

1.  Create a new folder on you computer.  The name of the folder MUST be named "Pick3System" (without the quotes)

So if your hard drive designation is the letter C:\ the new folder would be C:\Pick3System

2.  After you created the new folder called Pick3System you will need to open the new folder and create 3 sub-folders.  Again the 3 sub-folders must be named as follows:

Sub-folder 1:  MiddayDraws

Sub-folder 2: EveningDraws

Sub-folder 3: CombinedDraws

Once you have the Main folder and the 3 sub-folders created download the Excel file from the link provided above and save the file in the Pick3System folder.

More in the next post.....

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: October 26, 2013, 8:28 am - IP Logged

    Next,

    Here are the links to the folder containing the 3 zip files:

    https://app.box.com/s/puz7m6oedpuonegga6l6

     

    The 3 zip file are as follows:

    Zip File 1: Midday Draws

    Zip File 2: Evening Draws

    Zip File 3: Combined Draws

    Download each of the 3 zip files.

    1. Unzip the drawing text files for Midday Zip files into the MiddayDraws folder you created from the 1st post.

    2. Unzip the drawing text files for Evening Zip files into the EveningDraws folder you created from the 1st post.

    3. Unzip the drawing text files for Combined Zip files into the CombinedDraws folder you created from the 1st post.

    The reason I created all the drawing text files is to eliminate making 40 to 50 different Excel files for every state.

    NOTE: Make sure when you unzip the contents of each of the zip file the zip program does not create a new folder name.

    I'll post a couple screen shots in the next post on how the folders should look like and the text files in each of the 3 sub-folders.....

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: October 26, 2013, 8:50 am - IP Logged

      Here is a screen shot of the Main Folder "Pick3System" and the Sub Folders:

      My hard drive is the letter C.  Yours may be a different letter.  As long as you name the Mian folder and Sub-folders exactly as below.

      Folders 1

       

      Here is a screen shot of the Sub Folder "MiddayDraws" and the text files that were unzipped into this folder.

      Folder 2

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: October 26, 2013, 8:52 am - IP Logged

        This should get you started. 

        I will post some videos on how to use the Excel file and import a sample text file later today.

        I will be using the Pennsylvania Evening draws....

          CARBOB's avatar - FL LOTTERY_LOGO.png
          ORLANDO, FLORIDA
          United States
          Member #4924
          June 3, 2004
          5896 Posts
          Offline
          Posted: October 27, 2013, 7:05 am - IP Logged

          This should get you started. 

          I will post some videos on how to use the Excel file and import a sample text file later today.

          I will be using the Pennsylvania Evening draws....

          Just saw this thread. Downloaded programs, took a quick look, waiting for instructions.

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5387 Posts
            Offline
            Posted: October 27, 2013, 6:02 pm - IP Logged

            I updated both the Pick 3 text files and also the 2 Excel files:

            Here is the link to the folder that contains the 3 zip files for the Midday, Evening, and Combined draw history text files:

            https://app.box.com/s/unhfwgunczkefu4c7wyy

             

            Here is the link to the folder that contains the 2 Excel files: 1997 through 2003 and 2007 & 2010 versions:

            https://app.box.com/s/whi3ak3t9xnd6xw8mmjo

             

            You can delete the previous files downloaded from the 1st post.

            Use the same folders.

            I post some videos this evening...

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: October 27, 2013, 6:45 pm - IP Logged

              Video 1:  Creating your folders and draws text files in each of the 3 sub-folders

              http://www.youtube.com/watch?v=XbwIqFzDH6Q

                CARBOB's avatar - FL LOTTERY_LOGO.png
                ORLANDO, FLORIDA
                United States
                Member #4924
                June 3, 2004
                5896 Posts
                Offline
                Posted: October 28, 2013, 5:23 am - IP Logged

                Thanks Steve!!

                  winsumloosesum's avatar - Lottery-060.jpg
                  Pennsylvania
                  United States
                  Member #2218
                  September 1, 2003
                  5387 Posts
                  Offline
                  Posted: October 28, 2013, 4:40 pm - IP Logged

                  Here are the updated Pick 3 drawings.  Updated through Sunday October 27 2013

                  Download link to the folder containing the 3 zip files.  Midday, Evening, and Combined.

                  You can unzip the updated draw text files into the folders created in the previous post.

                  https://app.box.com/s/9l2ry02sdhkyvhjwlrsz

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5387 Posts
                    Offline
                    Posted: October 30, 2013, 6:35 am - IP Logged

                    Here are the updated Pick 3 drawings.  Updated through Tuesday October 29 2013

                    Download link to the folder containing the 3 zip files.  Midday, Evening, and Combined.

                    You can unzip the updated draw text files into the folders created in the previous post.

                    https://app.box.com/s/lybagj2hr3hgmpkp2emc

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5387 Posts
                      Offline
                      Posted: November 1, 2013, 7:49 am - IP Logged

                      I updated the drawing text files through Thursday Oct 31, 2013

                      Here is the link to the folder containing the 3 zip files:

                      https://app.box.com/s/lybagj2hr3hgmpkp2emc

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5387 Posts
                        Offline
                        Posted: November 1, 2013, 7:56 am - IP Logged

                        I also updated the P3VTRACSystem Excel file.

                        I created a file for Texas combined draws and Pennsylvania evening only draws.

                        You can only open 1 of the 2 since they both have the same file name.

                        Pennsylvaia Excel file:

                        https://app.box.com/s/1ri99dxvjge92e3qfxjj

                         

                        Texas Excel file:

                        https://app.box.com/s/zuach9suhqk6l54t6qc9

                         

                        I posted picks in the Pick 3 for Texas and Pennsylvania thread using the calculations from each of the 2 files.

                        I

                        I'll try and post some videos later today on how to use the Excel files.

                          winsumloosesum's avatar - Lottery-060.jpg
                          Pennsylvania
                          United States
                          Member #2218
                          September 1, 2003
                          5387 Posts
                          Offline
                          Posted: November 1, 2013, 3:09 pm - IP Logged

                          Video 1:  Creating your folders and draws text files in each of the 3 sub-folders

                          http://www.youtube.com/watch?v=XbwIqFzDH6Q

                          Here is the Youtube link for Video 2:

                          http://www.youtube.com/watch?v=iOAt4ygOH28

                          This video explains how to select the correct drive letter to import the drawing text files into Excel.  Also, how to select your Pick 3 game.

                            SergeM's avatar - slow icon.png
                            Economy class
                            Belgium
                            Member #123700
                            February 27, 2012
                            4035 Posts
                            Offline
                            Posted: November 1, 2013, 5:07 pm - IP Logged

                            Can you give the meaning of movement?

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5387 Posts
                              Offline
                              Posted: November 1, 2013, 6:20 pm - IP Logged

                              Can you give the meaning of movement?

                              I'm in the process of rendering a new video 3 that gives an explanation of the "Movements".