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

Free Excel Programs

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

Page 1 of 5
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
Posted: November 25, 2007, 12:27 pm - IP Logged

I'm giving away these (3) FREE Pick 3 Excel Programs

You will need to create a new folder for each program.

You can name these 3 New folders anything you like. 

Download and unzip the 3 Zip Programs into the 3 New Folders.

Here are the links:

Pick 3 ExcelAlpha Program - "ABC" Pattern Excel Program

http://www.mediafire.com/?etndxgjgwxy

====================================================

Pick 3 Power Pairs - Excel Program


http://www.mediafire.com/?2vr4ymxsvbg

====================================================

Pick 3 All States - Excel Pairs Skip Charts (Midday - Evening - Combined)


http://www.mediafire.com/?5jxuzkac54m

 

=====================================================

I will explain how to use each program later.

    libra's avatar - chi
    Cleveland , Ohio
    United States
    Member #961
    December 27, 2002
    43688 Posts
    Offline
    Posted: November 25, 2007, 1:24 pm - IP Logged

    The last file Pick 3 all States - excel pairs Skip Charts ( Midday and Evening Combined) will not download. Keeps sending me somewhere else.

    Libra Dave

      bashley572's avatar - starwars14
      West Side of Sunny Florida
      United States
      Member #55048
      September 8, 2007
      3371 Posts
      Offline
      Posted: November 25, 2007, 4:00 pm - IP Logged

      I got the last one to load... and I must say

      THANKS!!!!!!

      Money won is twice as good as money earned!

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

        The last file Pick 3 all States - excel pairs Skip Charts ( Midday and Evening Combined) will not download. Keeps sending me somewhere else.

        Libra Dave

        Dave,

        Here are the links.  Had to split this into 4 zip files.

        Remember to first create a new folder and unzip the 4 zips into this new folder.

        You can name the folder anything you want. 

         

        http://www.mediafire.com/?9z2wm2xmxh1

        http://www.mediafire.com/?czde4yqylvm

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

        http://www.mediafire.com/?9njhfpzcldo

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

          Link to Instructions for using Pick 3 Power Pairs.

          http://www.mediafire.com/?cdjjhudm4vj 

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

            Link to Instructions for using Pick 3 Power Pairs.

            http://www.mediafire.com/?cdjjhudm4vj 

            Link to Instructions for using Pick 3 "All States" Pairs Program

            http://www.mediafire.com/?13nrmm20mmn

              spy153's avatar - maren

              United States
              Member #28409
              December 15, 2005
              1198 Posts
              Offline
              Posted: November 25, 2007, 9:24 pm - IP Logged

              It's very nice of you to share this with us winsumloosesum !!!  Big Smile

              voir-vous dans mes reves!Cool

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

                It's very nice of you to share this with us winsumloosesum !!!  Big Smile

                Your welcome.

                Hope it helps!! 

                  libra's avatar - chi
                  Cleveland , Ohio
                  United States
                  Member #961
                  December 27, 2002
                  43688 Posts
                  Offline
                  Posted: November 25, 2007, 10:05 pm - IP Logged

                  Thanks .Got them all and the instructions.

                  Libra Dave

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5387 Posts
                    Online
                    Posted: November 26, 2007, 6:58 am - IP Logged

                    Below are the links to the updated Pick 3 Excel Programs with Sunday's Draws

                    If downloading these for the first time make sure you create a new folder for each of these 2 Excel programs.

                    You can name the folders whatever you like. 



                    ABC Pattern Program

                    http://www.mediafire.com/?3twgc5lm7zh


                    Power Pairs Program

                    http://www.mediafire.com/?3dwyij7s2o0


                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5387 Posts
                      Online
                      Posted: November 26, 2007, 8:41 am - IP Logged

                      Update to: (Updated Sunday Drawings)

                      http://www.mediafire.com/?dzq00dczhdx

                      Pick 3 All States Pairs Program 

                       

                      Remember to first create a new folder and unzip the 4 zips into this new folder.

                      You can name the folder anything you want. 

                       

                      You don't need to download these 3 files if you already did previously.


                      http://www.mediafire.com/?czde4yqylvm

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

                      http://www.mediafire.com/?9njhfpzcldo

                        LottoChica23's avatar - Aquarius
                        Fughedaboutit (NY)
                        United States
                        Member #8160
                        October 26, 2004
                        6777 Posts
                        Offline
                        Posted: November 26, 2007, 7:17 pm - IP Logged

                        Thanks WSLS!!! Banana

                        Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

                        check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

                        You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

                          Fibonacci's avatar - Lottery-050.jpg
                          New York, NY
                          United States
                          Member #39471
                          May 16, 2006
                          2696 Posts
                          Offline
                          Posted: November 28, 2007, 12:59 pm - IP Logged

                          Thanks WSLS. I treat anything that comes from you very seriously. Thanks for all yr hard work in helping us be better players.

                          $$$

                            bashley572's avatar - starwars14
                            West Side of Sunny Florida
                            United States
                            Member #55048
                            September 8, 2007
                            3371 Posts
                            Offline
                            Posted: November 29, 2007, 7:12 am - IP Logged

                            Ok, since I am only interested in NY State, is there a way to adjust or change the program and drop all the other states?

                            Money won is twice as good as money earned!

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

                              Ok, since I am only interested in NY State, is there a way to adjust or change the program and drop all the other states?

                              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!!