Welcome Guest
Log In | Register )
You last visited January 20, 2017, 7:00 pm
All times shown are
Eastern Time (GMT-5:00)

Pick 3 ALL States - VTRAC - Excel Program

Topic closed. 14 replies. Last post 2 years ago by winsumloosesum.

Page 1 of 1
52
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Online
Posted: August 26, 2014, 11:46 am - IP Logged

Note: You can only use Excel 2007, 2010, and 2013

Instructions:

Create a new folder and name it anything you want.  Example, Pick3VTRAC

Download the following 2 Excel files and place them into your new folder

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

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

Excel file #1 - P3StateDrawsVTRAC.xlsm

Excel file #2 - Step1.xlsm

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5396 Posts
    Online
    Posted: August 26, 2014, 11:52 am - IP Logged

    1st Open the Excel file P3StateDrawsVTRAC.xlsm

    Once this Excel file opens you will see a pop-up window reminding you to change the date in cell F1. 

    Since the draws have been updated through August 25, 2014 you can just close this window.

    I normally update this Excel file every morning and will post the update link from box.com

    You have the option however to update this file yourself.  You can update this Excel file after all the Midday draws are completed for August 26, 2014. (Since all the draws are already updated through August 25, 2014).  And then update the Evening draws for August 26, 2014.

    I will explain how to do this in a video and post the Youtube link in the next thread.....

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5396 Posts
      Online
      Posted: August 26, 2014, 1:33 pm - IP Logged

      Youtube Video 1 - P3StateDrawsVTRAC.xlsm "How to Update the Draw History"

      https://www.youtube.com/watch?v=xRVnLpqqkTA

      Recommendation is to use Google Chrome as your browser.

      Depending on your operating system (Windows 8, 7, Vista, XP, etc.) using the above browser should work OK when copy and pasting.

      I have Windows 7 and using Mozilla Firefox which works OK for me.

      Make sure you follow the instructions in the video.

        LottoBux's avatar - 2elh5if
        Ontario
        Canada
        Member #109243
        April 9, 2011
        31439 Posts
        Offline
        Posted: August 26, 2014, 1:41 pm - IP Logged

        Note: You can only use Excel 2007, 2010, and 2013

        Instructions:

        Create a new folder and name it anything you want.  Example, Pick3VTRAC

        Download the following 2 Excel files and place them into your new folder

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

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

        Excel file #1 - P3StateDrawsVTRAC.xlsm

        Excel file #2 - Step1.xlsm

        Thanks Steve And Have A Happy Birthday.

        Smiley

                               

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5396 Posts
          Online
          Posted: August 26, 2014, 2:32 pm - IP Logged

          Here is Youtube Video 2:

          https://www.youtube.com/watch?v=IGdRMnX3nx0

          This video explains the Draws tab worksheet located in the Step1.xlsm Excel file.

          One thing I should mention is when or if you update the draw histories for the P3StateDrawsVTRAC.xlsm Excel file do NOT have both Excel files opened. 

          Close the Step1.xlsm file and only keep the P3StateDrawsVTRAC.xlsm file open when updating draws.

          Next video 3 I will explain the "134Numbers" Tab.....

            LottoBux's avatar - 2elh5if
            Ontario
            Canada
            Member #109243
            April 9, 2011
            31439 Posts
            Offline
            Posted: August 26, 2014, 4:28 pm - IP Logged

            Here is Youtube Video 2:

            https://www.youtube.com/watch?v=IGdRMnX3nx0

            This video explains the Draws tab worksheet located in the Step1.xlsm Excel file.

            One thing I should mention is when or if you update the draw histories for the P3StateDrawsVTRAC.xlsm Excel file do NOT have both Excel files opened. 

            Close the Step1.xlsm file and only keep the P3StateDrawsVTRAC.xlsm file open when updating draws.

            Next video 3 I will explain the "134Numbers" Tab.....

            Hi winsum,See Ya!

             When I Open The Step 1 File I Noticed That None Of The Results From Aug 25th To Aug 9th Are Populated.

            I Don't See Any Dropdowns Where I Can Adjust The Amount Of Draws.

            In The Video They Are There.

            The Only Draws Showing Are From The 1st Of The Month To The 8th Of Each Of The Months.

                                   

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5396 Posts
              Online
              Posted: August 26, 2014, 6:25 pm - IP Logged

              Hi winsum,See Ya!

               When I Open The Step 1 File I Noticed That None Of The Results From Aug 25th To Aug 9th Are Populated.

              I Don't See Any Dropdowns Where I Can Adjust The Amount Of Draws.

              In The Video They Are There.

              The Only Draws Showing Are From The 1st Of The Month To The 8th Of Each Of The Months.

              Not sure why your data is incorrect.

              What version of Excel are you using?

              You have a number of empty cells that should have data.

              What is the date in cell B1.  That is what is the format?  MM/DD/YYYY

              I have 8/25/2014 in cell B1

              Your correct, you don't have any cells to adjust the day.

              Anyone else who downloaded and opened the Step1.xlsm Excel file show the same errors?

                LottoBux's avatar - 2elh5if
                Ontario
                Canada
                Member #109243
                April 9, 2011
                31439 Posts
                Offline
                Posted: August 26, 2014, 6:34 pm - IP Logged

                Not sure why your data is incorrect.

                What version of Excel are you using?

                You have a number of empty cells that should have data.

                What is the date in cell B1.  That is what is the format?  MM/DD/YYYY

                I have 8/25/2014 in cell B1

                Your correct, you don't have any cells to adjust the day.

                Anyone else who downloaded and opened the Step1.xlsm Excel file show the same errors?

                I'm Using Excel 2010

                At First I Had Them In The Same Folder (Pick3 System)As Most Of The Other Excel Files.

                I Then Created A New Folder Just With Those 2 Files(Not In The Pick3 System Folder)

                I Can Try Re Downloading The Pick3 VTrac State Draws File Since I D/L'ed It Before You Had The Started The Thread.

                It Was With The Pick 3 And Pick 4 Excel Files.

                EDIT..The Date In B1 Is 8/25/2014

                                       

                  winsumloosesum's avatar - Lottery-060.jpg
                  Pennsylvania
                  United States
                  Member #2218
                  September 1, 2003
                  5396 Posts
                  Online
                  Posted: August 26, 2014, 6:55 pm - IP Logged

                  OK,

                  I made a few enhancements to both Excel files.

                  Delete what you currently have and re-download using the same links from the opening thread.

                  Same as below:

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

                   

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

                    LottoBux's avatar - 2elh5if
                    Ontario
                    Canada
                    Member #109243
                    April 9, 2011
                    31439 Posts
                    Offline
                    Posted: August 26, 2014, 7:12 pm - IP Logged

                    OK,

                    I made a few enhancements to both Excel files.

                    Delete what you currently have and re-download using the same links from the opening thread.

                    Same as below:

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

                     

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

                    It Looks The Same As The Other File.Still No Data In Those Cells.

                    I Guess We'll Have To See If Anyone Else Has Downloaded The File.

                                           

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5396 Posts
                      Online
                      Posted: August 26, 2014, 7:46 pm - IP Logged

                      Not sure why your Excel files are showing incorrect data.  I just downloaded the same files and placed them in a 2nd test folder just to see if maybe the files became corrupt but opened and worked OK

                      I placed the 2 Excel files into a zip folder and uploaded them to box.com

                      Try downloading the zip file and see what happens:

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

                        LottoBux's avatar - 2elh5if
                        Ontario
                        Canada
                        Member #109243
                        April 9, 2011
                        31439 Posts
                        Offline
                        Posted: August 26, 2014, 8:13 pm - IP Logged

                        Not sure why your Excel files are showing incorrect data.  I just downloaded the same files and placed them in a 2nd test folder just to see if maybe the files became corrupt but opened and worked OK

                        I placed the 2 Excel files into a zip folder and uploaded them to box.com

                        Try downloading the zip file and see what happens:

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

                        No Difference.I'll Just Leave It For The Time Being.

                                               

                          Avatar
                          Horwood NL
                          Canada
                          Member #70613
                          February 6, 2009
                          299 Posts
                          Offline
                          Posted: August 26, 2014, 9:32 pm - IP Logged

                          OK,

                          I made a few enhancements to both Excel files.

                          Delete what you currently have and re-download using the same links from the opening thread.

                          Same as below:

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

                           

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

                          Just to let you know, I have downloaded the first set of excel files and your latest set of files and both work for me. Just waiting for next video.

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5396 Posts
                            Online
                            Posted: August 27, 2014, 3:23 am - IP Logged

                            OK,

                            I made a few enhancements to both Excel files.

                            Delete what you currently have and re-download using the same links from the opening thread.

                            Same as below:

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

                             

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

                            I updated the P2StateDrawsVTRAC.xlsm  with Tuesday's drawings and Step1.xlsm Excel files.

                            Use the same links in the reply.

                            I'll post a video 3 later today.

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5396 Posts
                              Online
                              Posted: August 28, 2014, 2:38 am - IP Logged

                              I updated the P2StateDrawsVTRAC.xlsm  with Wednesday's drawings.

                              Step1.xlsm Excel file has also been updated.

                              Delete any previous version you have.

                              Use the same links.

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

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

                               

                              I'll post a video 3 today.