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

Free Excel Programs

Topic closed. 72 replies. Last post 9 years ago by mglsr.

Page 4 of 5
51
PrintE-mailLink
mglsr's avatar - candle
Tennessee
United States
Member #2369
September 23, 2003
3072 Posts
Offline
Posted: December 4, 2007, 4:11 pm - IP Logged

Oh no .. No Florida ??Unhappy

Page 3

"As Quoted by the Genius One:"

        "Life i$ Good "   

 $$$$ I FEEL LUCKY $$$$                                                               

 *lay off and it pays off*

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

    Page 3

    Florida

    http://www.badongo.com/file/5366723 

    Check with Carbob

    He might have an up-to-date copy.

    Make sure you create a new folder. (Name it whatever you like e.g One State FL)

    Unzip the 2 Excel files into this new folder.

    Make sure both Excel files are open at the smae time when updating draws.

    Good Luck!! 

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

      Georgia (Combined Draws) Excel Program Link:

       

      http://www.badongo.com/file/5423254 

       

      *****Remeber to create a new folder. (Name it whatever you like)******

       

      Unzip the 2 files into this new folder

      See previous posts for instructions

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: December 4, 2007, 5:03 pm - IP Logged

        Bashley,

        Here is download link for New York State. (1 State Program)

        http://www.mediafire.com/?0zgjvjwwv2z 

         

        There is 1 Zip file but it contains 2 Excel files.

        Create a new folder (name it whatever you like e.g New York Pick 3)and unzip the Excel files into this new folder.

        Open the P3Draws Excel file first.  You will notice that it has combined draws Midday and Evening.

        Notice the 3 Toolbars.  

        1.  Add a new drawing when you need to add a draw click this toolbar. ALL new drawings will be entered on line 20. Combo will be entered in cell E20.

        2.  Delete draw - click this toolbar if you need to delete a drawing on line 20.

        Now while the P3Draws Excel file is open.  Open the 2nd Excel file Pairs1State.  You should now have 2 Excel files opened at the same time. 

        Make sure you P3Draws Excel file is the active file now.

        3.  The last Toolbar "Click To Copy Drawings".  By clicking this Toolbar it will copy 365 past draws from the Pick3Draws Excel file into the Pairs1State Excel file > Pick3Draws Tab.

        Now click the next Tab labeled "Alpha Patterns"

        I only tracked 10 states using the Alpha Patterns.  Luckily New York was one of them. 

        Click the Toolbar labeled "Click To Add Line".  This will add a new line and will enter the last Alpha Pattern on line 20.

        Now click the larger Toolbar labeled "Click To Sort & Rank Digits & VTRAC Positions"

        This will sort all the Positional Digits in the way they were drawn. This is more or less places aranges all the positions into a Skip  Chart. 

        There are additional Tabs that will give you charts for Sums, Digits, VTRAC Digits, Pairs (Front, Back, and Side Pairs). 

        There is a Tab labeled "ComboWheels".  This takes the Digits Hottest to Coldest along with any Boxed Pairs (Front, Back & Side) that are 30 Draws Out (skips) or more and wheels them into 36 combinations.  Any combination highlighted in RED (See Column F) will contain a Pair that is 30 skips or more.  For example in New York there are a Total of 36 combinations but based on the number of Pairs that are at 30 skips or more (see column T) you have 9 Pairs at 30 skips or more.  In cell F39 you will see the number "21" which represents 21 combinations that contain a Pair from column "T".  A possible strategy that was on the versabet forum is after Sundays last drawing play the rest of the week using the 21 or whatever number of combinations.    If you use this make sure you click all the Toolbars in all the remaining Tabs first.  Especially the Tab labeled "Pairs".  

        I did not cover everything here. 

        If you have any questions let me know.

        If anyone wants their state post here or PM me.

        Good Luck!!  

        Here is an updated download link for New York Combined Draw Program.

         

        http://www.badongo.com/file/5423403 

         

        Remeber to create a new folder (E.G.  One State NY)

        Unzip the 2 Excel files into this new folder.

        Both Excel files need to open at the same time to copy draws.

        Good Luck!! 

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: December 4, 2007, 5:14 pm - IP Logged

          Florida Excel Program Link:

          http://www.badongo.com/file/5363531 

          *****Remeber to create a new folder. (Name it whatever you like)******

          Unzip the 2 files into this new folder

          See previous posts for instructions.  

          The Alpha VTRAC Pattern Chart only has 3 entries.

          Trying to automate this instead of draw by draw.

          Hereis the updated Florida Link:  Includes Monday Eve 12/3 drawing.

          http://www.badongo.com/file/5423547 

           

          Good Luck!! 

            mglsr's avatar - candle
            Tennessee
            United States
            Member #2369
            September 23, 2003
            3072 Posts
            Offline
            Posted: December 8, 2007, 11:33 am - IP Logged

            Still testing Steve, looks like after a few hits, you need to wait till next week

            "As Quoted by the Genius One:"

                    "Life i$ Good "   

             $$$$ I FEEL LUCKY $$$$                                                               

             *lay off and it pays off*

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

              Mike,

              You can actually test 2 ways.

              1. The usual way of using your Sunday draws (evening) will be your last darw and follow the steps of copy and pasting all the combos over to the next range of cells.  Make sure after Sundays draw that you sort (Toolbar) the Pairs (Pairs Tab) and  Sort the Digits and VTRAC Digits in the Tab labeled AlpaPatterns before you copy and paste.

              2.  Starting Monday through Sunday, look at both lists in the ComboWheels, when you copy and paste the updated drawing to the Pairs1State in columns G (look for highlighted numbers they are winners) and over to column BE and BF.  After you checked the ComboWheels sort (ToolbaR) the Pairs (Pairs Tab) and  Sort the Digits and VTRAC Digits in the Tab labeled AlpaPatterns.  

              You are correct that combos normally hit within a couple draws.  When they do stop playing or you can wait till after the following Sunday's draw. 

              Good Luck!! 

                mglsr's avatar - candle
                Tennessee
                United States
                Member #2369
                September 23, 2003
                3072 Posts
                Offline
                Posted: December 8, 2007, 11:24 pm - IP Logged

                Mid and Eve picks for the week: KY

                025 - 028 - 029 - 178 - 278 - 378 - 678

                Ky Eve 678 str tonight

                "As Quoted by the Genius One:"

                        "Life i$ Good "   

                 $$$$ I FEEL LUCKY $$$$                                                               

                 *lay off and it pays off*

                  mglsr's avatar - candle
                  Tennessee
                  United States
                  Member #2369
                  September 23, 2003
                  3072 Posts
                  Offline
                  Posted: December 9, 2007, 9:52 pm - IP Logged

                  Georgia (Combined Draws) Excel Program Link:

                   

                  http://www.badongo.com/file/5423254 

                   

                  *****Remeber to create a new folder. (Name it whatever you like)******

                   

                  Unzip the 2 files into this new folder

                  See previous posts for instructions

                  Steve, take a look at Ga file, i couldn't get it to cooperate tonight under Combo Wheels (BE & BF columns) did not post the number, but it was red

                  "As Quoted by the Genius One:"

                          "Life i$ Good "   

                   $$$$ I FEEL LUCKY $$$$                                                               

                   *lay off and it pays off*

                    mglsr's avatar - candle
                    Tennessee
                    United States
                    Member #2369
                    September 23, 2003
                    3072 Posts
                    Offline
                    Posted: December 9, 2007, 11:21 pm - IP Logged

                    Mid and Eve picks for the week: KY

                    025 - 028 - 029 - 178 - 278 - 378 - 678

                    Ky Eve 678 str tonight

                    Ky eve 837 box

                    "As Quoted by the Genius One:"

                            "Life i$ Good "   

                     $$$$ I FEEL LUCKY $$$$                                                               

                     *lay off and it pays off*

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

                      Georgia (Combined Draws) Excel Program Link:

                       

                      http://www.badongo.com/file/5423254 

                       

                      *****Remeber to create a new folder. (Name it whatever you like)******

                       

                      Unzip the 2 files into this new folder

                      See previous posts for instructions

                      Updated Georgia Excel Program

                       

                      One State GA Version 2 Update

                      http://www.badongo.com/file/5535149

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

                        Pennsylvania Evening Draws Only - Excel Program Link:

                        http://www.badongo.com/file/5368854

                        *****Remeber to create a new folder. (Name it whatever you like)******

                        Unzip the 2 files into this new folder

                        See previous posts for instructions.  

                        The Alpha VTRAC Pattern Chart only has 3 entries.

                        Trying to automate this instead of draw by draw.

                        Updated Pennsylvania Evening Excel Program

                        One State PA Evening Only Update

                        http://www.badongo.com/file/5535175

                          mglsr's avatar - candle
                          Tennessee
                          United States
                          Member #2369
                          September 23, 2003
                          3072 Posts
                          Offline
                          Posted: December 10, 2007, 9:59 am - IP Logged

                          Steve, i keep getting error message that the Ga update file will not unzip

                          "As Quoted by the Genius One:"

                                  "Life i$ Good "   

                           $$$$ I FEEL LUCKY $$$$                                                               

                           *lay off and it pays off*

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5387 Posts
                            Offline
                            Posted: December 10, 2007, 10:25 am - IP Logged

                            Steve, i keep getting error message that the Ga update file will not unzip

                            Mike,

                            Thanks.  

                            I will update this soon. 

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5387 Posts
                              Offline
                              Posted: December 10, 2007, 12:34 pm - IP Logged

                              Below are updates to the Excel Programs.

                              1.  Make sure you create a new folder for each state.  You can name the folder anything you like

                              2.  Unzip the 2 Excel Files into this new folder.

                              If links or zips do not work let me know.

                              Download Links - Excel Programs:


                              Pennsylvania - Evening Draws
                              http://www.badongo.com/file/5538572


                              Georgia - Combined Draws
                              http://www.badongo.com/file/5538594


                              Florida - Evening Draws
                              http://www.badongo.com/file/5538615


                              Virginia - Combined Draws
                              http://www.badongo.com/file/5538638


                              New York - Combined Draws
                              http://www.badongo.com/file/5538659


                              Ohio - Combined Draws
                              http://www.badongo.com/file/5538681


                              Tennessee - Combined Draws
                              http://www.badongo.com/file/5538704


                              South Carolina - Combined Draws
                              http://www.badongo.com/file/5538720

                               

                              If links or zips do not work let me know.