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

HEY WSLS:

 With these programs what do you personally look for in it?? I'm new at this so please understand just tryin to absorb as much info as possible

 

Thanks

Saveyah,

Since you have the Virginia program click the Tab labeled ComboWheels.

This system is based on a post from the Versabet Forum with a few variations.

The system is based on the following:

1.  Digits Ranking is as follows:

Position 1 = Cold 1,2,3 - (Column AE - ComboWheels Tab)

Position 2 = Warm  1,2,3 - (Colum AF -Combo Wheels Tab)

Position 3 = Hot 1,2,3,4  - (Column AG - Combo Wheels Tab)

Wheeled into 36 Combinations Boxed and Straight (See column Ai 7 AJ)

 

2. Pairs Ranking:

Any Pair (Front, Back, and Side) out 30 or more skips. (See column AW - ComboWheels Tab)

You can reduse the 36 Wheeled combinations by only playing the combinations that include any Pair that is 30 or more draws out.

You can also reduce the combinations by eliminating combinations that equal  sums of 0 through 5 and sums  22 through 27.

The last draw I used was last Sunday Evening November 25.

Every draw since last Sunday November 25th I look for boxed plays and straight plays.

Look at the ComboWheel Tab and scroll over to Cell Column BE and BF.  Any number highlighted in RED indicates either a Straight Hit and or a Boxed hit.

See combos 134 and 379 hit boxed (highlighted in RED).

So these 2 combos hit boxed since Sunday's last drawing.

You could stop playing once you hit a Boxed or Straight combo and wait again after Sunday when you recalculate the darws. See Below 

After you enter this Sunday's Evening drawing you would start the process all over again.

Make sure you also click the Pairs Tab and click the Toolbar to sort all the Pairs.

Click the AlphaPatterns Tab and cklick the big Toolbar to sort all the digits and VTRAC digits.

Click the ComboWheels Tab and in cells AB & AC click the Toolbar that says Click after Sunday's Draws.  This will copy and paste all the information from cell range B:T to AE:AW.

 

There are other Tabs that I will explain later!!

Good Luck!!! 

    mybolade's avatar - praying hands.jpg
    Detroit, MI
    United States
    Member #8705
    November 15, 2004
    1396 Posts
    Offline
    Posted: November 30, 2007, 7:02 pm - IP Logged

    Winsumloosesum,

    Thanks again for the files. Today I took the first step and updated the games for all the states. Then I tried something new. I used the midday pair file and tried CA for the first time. I played 5 numbers that corresponded to the top pairs and vtracs and hit the midday boxed. It wasn't a lot of money, but it beats what I started with and I used your pair chart.

    Bolade'

    "Excellence is the result of
     Caring more than others think is wise;
     Risking more than others think is safe,
     Dreaming more than others think is practical, and
     Expecting more than others think is possible."  Author Unknown

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Online
      Posted: November 30, 2007, 9:29 pm - 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.

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

        Daily sequence of instructions:

        DAILY:

        1. Open the P3Draws Excel file first. 

         2.  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.

        3. Now while the P3Draws Excel file is open.  Open the 2nd Excel file Pairs1State. 

         4.  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.

        5.  Now click the next Tab labeled "Alpha Patterns"

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

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

        SUNDAY: (eve draw)

        1. Open the P3Draws Excel file first. 

         2.  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.

        3. Now while the P3Draws Excel file is open.  Open the 2nd Excel file Pairs1State. 

         4.  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.

        5.  Now click the next Tab labeled "Alpha Patterns"

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

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

        8.  Click the Pairs Tab and click the Toolbar to sort all the Pairs.

        9.  Click the ComboWheels Tab and in cells AB & AC click the Toolbar that says Click after Sundays Draws. This will copy and past the information from cell range B:T to AE:AW. Now you are ready for the 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
          Online
          Posted: December 2, 2007, 11:17 am - IP Logged

          Here are some other tidbits of information:

          1.  Click the "Sums" Tab in your Pairs1State Excel file.

          In column C8 through C11.  The total sum is highlighted as Odd or Even.

          Look for 4 straight Odd or 4 Straight Even.  If for example 4 straight Odd in cell range C8 through C11 flip and play Even Sum.  Meaning look for an even Sum(s) to come out.  

           

          2.  Click the "VDigitsLongOut" Tab in your Pairs1State Excel file.  VDigits Long Out is a list of skips for VTRAC Digits.

          VTRAC 1 = Digits 0 & 5

          VTRAC 2 = Digits 1 & 6

          VTRAC 3 = Digits 2 & 7

          VTRAC 4 = Digits 3 & 8

          VTRAC 5 = Digits 4 & 9 

          In columns B3 through C7.  Look in columns C3 through C7 for any VTRAC Digits at 5 skips or more.  For example, if VTRAC 4 in cell column  B3 through B7 is at 5.  Look for Digits 4 & 9 to be good digits to include in your next pick.

           

          3.  In the Pairs1State Excel file click the tab labeled "VDigitsLongOut".  In cell range F13, F14, and F15 you can enter a Alpha VTRAC Pattern that you feel will be drawn next.  For example, enter the letter "A" in cell F13, enter the letter "B" in cell F14, and finally enter the letter "C" in cell F15.

          Next click the Tab labeled "VTRAC Pattern Combos".  Look in cell AA6.  You now have 8 combinations to play in the next drawing based on the VTRAC Alpha Pattern you entered cells F13, F14, and F15 in the tab labeled "VDigitsLongOut".

          One thing to always enter in cells F13, F14, and F15.  Always enter the letter "A" in cell F13.  Then select a combination of "B", "C", or "D" to enter in cells F14 and F15. Go to the tab labeled "VTRAC Patern Combos" to obtain your 8 "BOXED" combinations. 

          One thing to always enter in cells F13, F14, and F15.  Always enter the letter "E" in cell F15.  Then select a combination of "B", "C", or "D" to enter in cells F13 and F14. Go to the tab labeled "VTRAC Patern Combos" to obtain your 8 "BOXED" combinations. 

          Now you have 16 "Boxed" combinations for your next draw.

          Good Luck!!! 

            Avatar
            New Member
            Woodbridge
            United States
            Member #56664
            November 28, 2007
            13 Posts
            Offline
            Posted: December 2, 2007, 11:54 am - IP Logged

            Here are some other tidbits of information:

            1.  Click the "Sums" Tab in your Pairs1State Excel file.

            In column C8 through C11.  The total sum is highlighted as Odd or Even.

            Look for 4 straight Odd or 4 Straight Even.  If for example 4 straight Odd in cell range C8 through C11 flip and play Even Sum.  Meaning look for an even Sum(s) to come out.  

             

            2.  Click the "VDigitsLongOut" Tab in your Pairs1State Excel file.  VDigits Long Out is a list of skips for VTRAC Digits.

            VTRAC 1 = Digits 0 & 5

            VTRAC 2 = Digits 1 & 6

            VTRAC 3 = Digits 2 & 7

            VTRAC 4 = Digits 3 & 8

            VTRAC 5 = Digits 4 & 9 

            In columns B3 through C7.  Look in columns C3 through C7 for any VTRAC Digits at 5 skips or more.  For example, if VTRAC 4 in cell column  B3 through B7 is at 5.  Look for Digits 4 & 9 to be good digits to include in your next pick.

             

            3.  In the Pairs1State Excel file click the tab labeled "VDigitsLongOut".  In cell range F13, F14, and F15 you can enter a Alpha VTRAC Pattern that you feel will be drawn next.  For example, enter the letter "A" in cell F13, enter the letter "B" in cell F14, and finally enter the letter "C" in cell F15.

            Next click the Tab labeled "VTRAC Pattern Combos".  Look in cell AA6.  You now have 8 combinations to play in the next drawing based on the VTRAC Alpha Pattern you entered cells F13, F14, and F15 in the tab labeled "VDigitsLongOut".

            One thing to always enter in cells F13, F14, and F15.  Always enter the letter "A" in cell F13.  Then select a combination of "B", "C", or "D" to enter in cells F14 and F15. Go to the tab labeled "VTRAC Patern Combos" to obtain your 8 "BOXED" combinations. 

            One thing to always enter in cells F13, F14, and F15.  Always enter the letter "E" in cell F15.  Then select a combination of "B", "C", or "D" to enter in cells F13 and F14. Go to the tab labeled "VTRAC Patern Combos" to obtain your 8 "BOXED" combinations. 

            Now you have 16 "Boxed" combinations for your next draw.

            Good Luck!!! 

            WSLS

            I've been working with the Combo tab feature that you explained yesterday and I'm going to try working with this one today. With all these data tables what type of hit average should I be generating  to let me know that I am using it right? This is real overwhelming I think I have a lil trouble trying to read everything at once.

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

              saveyah,

              I would Demo this for 2 weeks for your particular state.

              Every state is different so you need to TEST (Demo) to see if it is profitable.

              Good Luck!! 

              Steve 

                lottogloria's avatar - DiscoBallGlowing
                cleveland
                United States
                Member #35045
                March 11, 2006
                40 Posts
                Offline
                Posted: December 4, 2007, 5:39 am - IP Logged

                Can you please post ohio if you can

                                     thanks
                                   lottogloria

                  takeitez's avatar - japheth
                  Carters Lake, Ga.
                  United States
                  Member #5313
                  June 29, 2004
                  1065 Posts
                  Offline
                  Posted: December 4, 2007, 7:29 am - IP Logged

                  WTG  !!!

                  ez

                            No Pity!Guitar  Drum ........ in the long run........

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

                    Can you please post ohio if you can

                                         thanks
                                       lottogloria

                    Ohio Combined Draws Only - Excel Program Link:

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

                    *****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.

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

                      Steve, this is simply amazing

                      Yesterdays results: Tn Mid 093 box hit  Tn Eve 052 box hit

                      Today results: Ky Mid 871 box hit    Tn Mid 391 box hit

                      "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 4, 2007, 3:23 pm - IP Logged

                        Steve, this is simply amazing

                        Yesterdays results: Tn Mid 093 box hit  Tn Eve 052 box hit

                        Today results: Ky Mid 871 box hit    Tn Mid 391 box hit

                        For everyone information; Tn and Ky are the only two states that i track; thats why i posted the above info. I have been testing this program for only about 6 days. This past weekend Ky had 1 box hit and Tn had 1 str and 3 box hits. Great results so far!!!!!!

                        "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
                          Online
                          Posted: December 4, 2007, 3:52 pm - IP Logged

                          For everyone information; Tn and Ky are the only two states that i track; thats why i posted the above info. I have been testing this program for only about 6 days. This past weekend Ky had 1 box hit and Tn had 1 str and 3 box hits. Great results so far!!!!!!

                          Mike, 

                          Keep testing!!

                          As long as you make a profit thats the key. 

                          Looks like it works in Ohio also.  (Combined Draws) 

                           

                                                                                                                                                                                                  
                          Sun-Dec-02-2007M308Sun5    
                          Sun-Dec-02-2007E109Sun4    
                          Mon-Dec-03-2007M825Mon082525800
                          Mon-Dec-03-2007E974Mon097447901
                          Tue-Dec-04-2007M053Tue005303501

                          Sunday Evening drawings was the last draw for analysis.

                          479 boxed Monday 12/3 Eve

                          035 boxed Tuesday 12/4 Midday (05 Pairs was out 30 or more draws) 

                          Nice to see this working in more than 1 state. 

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

                            Its hard to hold back when you see these kinds of results Steve, but you are right; need to keep testing; so far this is really great if you play online.

                            "As Quoted by the Genius One:"

                                    "Life i$ Good "   

                             $$$$ I FEEL LUCKY $$$$                                                               

                             *lay off and it pays off*

                              Omniscient's avatar - Lottery-017.jpg
                              Florida
                              United States
                              Member #46570
                              September 14, 2006
                              558 Posts
                              Offline
                              Posted: December 4, 2007, 4:07 pm - IP Logged

                              Oh no .. No Florida ??Unhappy

                               See full size image                                               

                               Don't Play more, Play Smarter!