Welcome Guest
Log In | Register )
You last visited December 10, 2016, 11:28 am
All times shown are
Eastern Time (GMT-5:00)

Pennsylvania Pick 3 - VTRAC/ALPHA System - Excel Program

Topic closed. 62 replies. Last post 5 years ago by Harve$t Moon.

Page 1 of 5
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: January 17, 2012, 3:41 pm - IP Logged

Hi everyone.  I created this Excel program a few years ago but wanted to test this out in the next couple weeks to see if profiatble.

If you want to play along just create a new folder on your hard drive.  Example, C:\Pick 3 Pennsylvania Eve System

Download the following zip file from box.net and unzip into your newly named folder

http://www.box.com/s/4naqs70nc2y3ndgrleqe

The zip file contains 2 Excel files. 

I will explain more in the next few posts.  May even post a video on how to use the Excel files later today.

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: January 17, 2012, 4:07 pm - IP Logged

    The zip file contains 2 Excel files.  Excel 2002 version.

    The 1st Excel file:

    P3Draws.xls contains the Pennsylvania Pick 3 drawing history for the evening draws only (no Midday draws)

     

    The second Excel file:

    Pairs1State.xls contains all the calculations and other good stuff for the VTRAC/ALPHA Pick 3 System.

     

    I will try and post a video later today on how to use the 2 excel files using tonights Pennsylvania Pick 3 evening drawing for Tuesday January 17, 2012 at 7pm est.

      lakerben's avatar - spherewall
      New Mexico
      United States
      Member #86099
      January 29, 2010
      11120 Posts
      Offline
      Posted: January 17, 2012, 8:36 pm - IP Logged

      The zip file contains 2 Excel files.  Excel 2002 version.

      The 1st Excel file:

      P3Draws.xls contains the Pennsylvania Pick 3 drawing history for the evening draws only (no Midday draws)

       

      The second Excel file:

      Pairs1State.xls contains all the calculations and other good stuff for the VTRAC/ALPHA Pick 3 System.

       

      I will try and post a video later today on how to use the 2 excel files using tonights Pennsylvania Pick 3 evening drawing for Tuesday January 17, 2012 at 7pm est.

      Thanks, I'm going to try the pairs file for NM.

       

      US Flag

        retxx's avatar - mrthumbs
        BOSTON
        United States
        Member #48
        September 9, 2001
        3594 Posts
        Offline
        Posted: January 17, 2012, 8:38 pm - IP Logged

        when I opened the large chart it was read only

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: January 17, 2012, 8:41 pm - IP Logged

          Here is the link to the Excel 2010 version zip file

          http://www.box.com/s/muu8jr4p31z0rxrpne7h

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5387 Posts
            Offline
            Posted: January 17, 2012, 9:19 pm - IP Logged

            Here is a video from tonights winning drawing 3-2-5 on Tuesday January 13, 2012

            http://www.screencast.com/t/rEQTwwpa8y

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: January 17, 2012, 9:48 pm - IP Logged

              Here is the download link to the updated Excel files (zip file):

              http://www.box.com/s/cexrzy7lqokkuspq6osb

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

                This is a followup video with additional ideas:

                http://www.screencast.com/t/3I6bgSn1tF

                  Avatar
                  Florida
                  United States
                  Member #66575
                  October 30, 2008
                  3549 Posts
                  Offline
                  Posted: January 17, 2012, 10:35 pm - IP Logged

                  This is a followup video with additional ideas:

                  http://www.screencast.com/t/3I6bgSn1tF

                  Thanks Steve,

                  Is there an easy way to replace the draws for use with other states ??

                  didnt watch the video yet so maybe you addressed this question there ?

                  Thanks

                  CarliG

                    lakerben's avatar - spherewall
                    New Mexico
                    United States
                    Member #86099
                    January 29, 2010
                    11120 Posts
                    Offline
                    Posted: January 18, 2012, 12:41 pm - IP Logged

                    Thanks Steve,

                    Is there an easy way to replace the draws for use with other states ??

                    didnt watch the video yet so maybe you addressed this question there ?

                    Thanks

                    CarliG

                    I just manually deleated several draws and entered my states latest results.   The program is great just for the fp, bp and odd/even feature .  I've highlighted in red the recent pairs that have hit and the ones "due" in blue.  No pun intended.  This is great for the short term to see what has hit and what may hit next.  Try it!

                     

                    Hiding Behind Computer

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

                      I updated the Pennsylvania Pick 3 Evening Excel files.  Added Positional Tabs (Position 1, Position 2, Position 3) for the ALPHA's

                      http://www.box.com/s/3ugnsajuu2vygi6llak9

                       

                      I created another Excel program for Florida Pick 3 (Midday and Evening Draws)  The actual zip filename says evening but it is both Midday and Evening draws.

                      http://www.box.com/s/xoglnvlxlet9sr1advl6

                        Avatar
                        Florida
                        United States
                        Member #66575
                        October 30, 2008
                        3549 Posts
                        Offline
                        Posted: January 18, 2012, 8:41 pm - IP Logged

                        I updated the Pennsylvania Pick 3 Evening Excel files.  Added Positional Tabs (Position 1, Position 2, Position 3) for the ALPHA's

                        http://www.box.com/s/3ugnsajuu2vygi6llak9

                         

                        I created another Excel program for Florida Pick 3 (Midday and Evening Draws)  The actual zip filename says evening but it is both Midday and Evening draws.

                        http://www.box.com/s/xoglnvlxlet9sr1advl6

                        Thanks Steve

                        For Everything you do to try and help us all out

                        Going to grab that Florida

                         

                        CarliG

                          lakerben's avatar - spherewall
                          New Mexico
                          United States
                          Member #86099
                          January 29, 2010
                          11120 Posts
                          Offline
                          Posted: January 18, 2012, 8:43 pm - IP Logged

                          I updated the Pennsylvania Pick 3 Evening Excel files.  Added Positional Tabs (Position 1, Position 2, Position 3) for the ALPHA's

                          http://www.box.com/s/3ugnsajuu2vygi6llak9

                           

                          I created another Excel program for Florida Pick 3 (Midday and Evening Draws)  The actual zip filename says evening but it is both Midday and Evening draws.

                          http://www.box.com/s/xoglnvlxlet9sr1advl6

                          Can you do one for NM Steve?  Thanks!

                            retxx's avatar - mrthumbs
                            BOSTON
                            United States
                            Member #48
                            September 9, 2001
                            3594 Posts
                            Offline
                            Posted: January 18, 2012, 8:48 pm - IP Logged

                            how do I rid that read only from the file? thanks

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5387 Posts
                              Offline
                              Posted: January 18, 2012, 9:02 pm - IP Logged

                              how do I rid that read only from the file? thanks

                              Since the Excel file contain Macros you may have your "Enable Macro Security" settings set to High.  Try setting them to a lower setting.  I take it you are using Excel?  If so what version of Excel?