Welcome Guest
Log In | Register )
You last visited December 4, 2016, 1:15 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 2 of 3
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
Posted: November 1, 2013, 8:18 pm - IP Logged

Video 1: 

Creating your folders and placing the drawing Pick 3 text files in each of the 3 sub-folders.

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

 

Video 2:

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.

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

 

Video 3:

This video explains briefly about the "movements" of each positional VTRAC and calculating based on previous draws.

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

    kreative1's avatar - flower2
    NE PA
    United States
    Member #127838
    May 10, 2012
    1230 Posts
    Offline
    Posted: November 3, 2013, 10:33 am - IP Logged

    your videos are very informative!

    Is our state a pita or what though, I'm considering taking the 10 min drive to nj and playing there instead

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

      Nice explanation for the movements.

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

        Here are the download links to the Pick 3 VTRAC Excel files (2007 & 2010 Excel versions)

        Georgia (combined drawings)

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



        Texas (combined drawings)

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



        Florida (evening only)

        https://app.box.com/s/3xacpjedujtfhlbmvf08



        Pennyslvania (evening only)

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

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

          Ontario Canada Pick 3 - Combined Draws Excel File:

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

           

          Pennsylvania Pick 3 - Evening Draws Excel File:

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

            Avatar

            United States
            Member #141571
            April 18, 2013
            58 Posts
            Offline
            Posted: November 10, 2013, 5:12 pm - IP Logged

            Hello wsls,

            I no longer have a registered genuine working copy of Microsoft Office.

            Questions:

            Is the file Pick3VTRACSystem.xls , and the 3 state draw history sheets files, Only intended to work using the  genuine Microsoft Office 97-2003 for excel?

            Or can the files be used with the free Open Office Calc ver. 4.01 as well?

            This is what I get, After opening Pick3VTRACSystem.xls, using the latest Open Office calc ver. 4.01 (which seems to open Pick3VTRACSystem.xls with no problems) but whenI click any one of the 6 large boxed buttons, I'll get a open Office error box stating.

            " A scripting framework error occurred while running the UNKNOWN script UNKNOWN.

            Message: Incorrect format for Script URL:  OK "

            Any suggestions/help is appreciated.

              Avatar
              Jacksonville,IL
              United States
              Member #121124
              January 2, 2012
              34 Posts
              Offline
              Posted: December 10, 2013, 3:24 pm - IP Logged

              Hi there... I am stuck on the Excel Program. I have all my Folders in the correct space..How do I change my State to Illinois from Pennsylvania?

              Thanks

              Mike

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

                Hi there... I am stuck on the Excel Program. I have all my Folders in the correct space..How do I change my State to Illinois from Pennsylvania?

                Thanks

                Mike

                1. Open Pick3VTRACSystem Excel file

                2. Click the Tab at the bottom labeled "DrawImport"

                3. Click cell AB1.  Select/Enter the drive letter designation for your computer. 

                4. Go to cell O2.  Select the Type of game you want to import.  1 = Midday, 2 = Evening Only, 3 = Combined

                5. If you selected 3 in cell O2 for example, go to clcik cell R10 and from the drop-down list select your state.  You would select Illinois_Combined

                6. In cell range F7:G10 click the Toolbar labeled "Click to Import Dra Text File"

                7.  You should see the draws & dates staring in cell A20

                8.  Click the Toolbar "Copy Drawings to DrawHistory1 Tab


                  United States
                  Member #124493
                  March 14, 2012
                  7023 Posts
                  Offline
                  Posted: December 10, 2013, 5:00 pm - IP Logged

                  Are you tracking the LFF within the VTRACS?

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5387 Posts
                    Online
                    Posted: December 10, 2013, 5:13 pm - IP Logged

                    Are you tracking the LFF within the VTRACS?

                    "LFF"??

                      Avatar
                      Horwood NL
                      Canada
                      Member #70613
                      February 6, 2009
                      296 Posts
                      Offline
                      Posted: January 4, 2014, 1:53 pm - IP Logged

                      I just downloaded this and find it very interesting . How do I bring the history for the Ont. Pick 3 up to date?

                        Avatar
                        Horwood NL
                        Canada
                        Member #70613
                        February 6, 2009
                        296 Posts
                        Offline
                        Posted: January 7, 2014, 4:40 pm - IP Logged

                        I've updated the text files for the Ont pick 3 in the three folders but the Excel program does not pick them up. Does that meen I have to update the draws one at a time.

                          Avatar
                          Horwood NL
                          Canada
                          Member #70613
                          February 6, 2009
                          296 Posts
                          Offline
                          Posted: January 7, 2014, 5:41 pm - IP Logged

                          I've got the files to update .....  Thanks for the help!!!!

                            txwinr's avatar - Lottery-033.jpg
                            Texas
                            United States
                            Member #1998
                            August 6, 2003
                            28 Posts
                            Offline
                            Posted: January 8, 2014, 8:14 am - IP Logged

                            can you use this with the texas pick 3?

                              Avatar
                              Horwood NL
                              Canada
                              Member #70613
                              February 6, 2009
                              296 Posts
                              Offline
                              Posted: January 8, 2014, 9:23 am - IP Logged

                              Texas pick 3 is listed in the files so I would think you can