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

You like Straights ...Right? Me too, and so...

Topic closed. 79 replies. Last post 7 years ago by winsumloosesum.

Page 4 of 6
56
PrintE-mailLink
CARBOB's avatar - FL LOTTERY_LOGO.png
ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5903 Posts
Offline
Posted: October 28, 2009, 6:26 am - IP Logged

Thanks Steve. Files with macros have to be saved as a *.XLSM format, see macro for Fla below, the ext has to be changed, then all is well. Fantastic job!!!!

Sub FL3C()

Windows("P3StateDraws.xlsm!").Activate
Sheets("FL3C").Select
Range("E20:E1019").Select
Selection.Copy
       
Windows("GoldenOldiesCombined.xlsm!").Activate
Sheets("Calculations").Select
Range("E20").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
     
Sheets("Combos").Select
    Application.Run "GoldenOldiesCombined.xlsm!ReSortCombos"
   
    Application.Run "GoldenOldiesCombined.xlsm!SortCombos"
   
    Sheets("Playlist").Select
    Application.Run "GoldenOldiesCombined.xlsm!CopyPastCombos"
   
    Range("BW31:BW56").Select
    Selection.Copy
    Sheets("Stats").Select
    Range("K4").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
       
    Sheets("Playlist").Select
    Range("BZ42").Select

End Sub

 

These Excel files are in Excel 2002.  I'm not sure if there are any problems using newer versions of Excel.  Carbob has informed me that he had problems using Excel 2007.  Not sure if it was a compatability issue.  You think newer versions of Excel would be backward compatible.

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

    Thanks Steve. Files with macros have to be saved as a *.XLSM format, see macro for Fla below, the ext has to be changed, then all is well. Fantastic job!!!!

    Sub FL3C()

    Windows("P3StateDraws.xlsm!").Activate
    Sheets("FL3C").Select
    Range("E20:E1019").Select
    Selection.Copy
           
    Windows("GoldenOldiesCombined.xlsm!").Activate
    Sheets("Calculations").Select
    Range("E20").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
         
    Sheets("Combos").Select
        Application.Run "GoldenOldiesCombined.xlsm!ReSortCombos"
       
        Application.Run "GoldenOldiesCombined.xlsm!SortCombos"
       
        Sheets("Playlist").Select
        Application.Run "GoldenOldiesCombined.xlsm!CopyPastCombos"
       
        Range("BW31:BW56").Select
        Selection.Copy
        Sheets("Stats").Select
        Range("K4").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
           
        Sheets("Playlist").Select
        Range("BZ42").Select

    End Sub

     

    These Excel files are in Excel 2002.  I'm not sure if there are any problems using newer versions of Excel.  Carbob has informed me that he had problems using Excel 2007.  Not sure if it was a compatability issue.  You think newer versions of Excel would be backward compatible.

    Thanks Bob for your help!!

    Here is the link for this morning.  All draw files have been updated from Tuesday Oct 27 2009

    Here is the link to the zip file.

    Just unzip into the folder that has the Golden Oldies files.

    You will be prompted to be asked to replace the existing file.  Just click yes.

    Here is the link:

    http://rapidshare.com/files/299045397/P3StateDrawsWedOct28.ZIP

    If anyone has any ideas or suggestions to add or change let me know!!

    Good Luck!!!

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: October 28, 2009, 11:14 am - IP Logged

      Midday States Skip Chart

      Golden Oldies Midday Skip Chart

      Column B = State

      Column C = Current Skip ( a zero (0) represents a state that just hit a combo that was over 1000 draws

      Columns E through S = Last 15 skips for each state.

      Column U = Average Skip for each state

      Column W = Highest Skip for each state

      Notice Texas, Tr-State and Virginia all have a current skip of 4.

        WIN  D's avatar - q05Q0
        Stone Mountain*Georgia
        United States
        Member #828
        November 2, 2002
        10491 Posts
        Offline
        Posted: October 28, 2009, 11:54 am - IP Logged

        Steve .... you amaze me. This is a lot more advanced than anything going and has many surprises. Thanks for working this out for us.

         

         

        The only real failure .....is the failure to try.                               

                                      Luck is a very rare thing....... Odds not so much. 

                                      Odds never change .....but probability does. 

                                                                                               Win d    

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: October 28, 2009, 12:13 pm - IP Logged

          Steve .... you amaze me. This is a lot more advanced than anything going and has many surprises. Thanks for working this out for us.

          Hi Chaz,

          Always a pleasure. 

          Combined Skip Chart

          Golden Oldies Combined Draws

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5387 Posts
            Offline
            Posted: October 28, 2009, 12:23 pm - IP Logged

            Below is the updated zip file download link for Golden Oldies Midday and Evening Excel files.

            Download and Unzip into your folder.

            When prompted to replace existing files click YES.

            Enjoy!!

            http://rapidshare.com/files/299147117/GoldenOldiesMiddayand_CombinedUpdate.ZIP

             

            Working on the Evening Excel file.  Should be finished within the hour.

              CARBOB's avatar - FL LOTTERY_LOGO.png
              ORLANDO, FLORIDA
              United States
              Member #4924
              June 3, 2004
              5903 Posts
              Offline
              Posted: October 28, 2009, 12:51 pm - IP Logged

              Midday States Skip Chart

              Golden Oldies Midday Skip Chart

              Column B = State

              Column C = Current Skip ( a zero (0) represents a state that just hit a combo that was over 1000 draws

              Columns E through S = Last 15 skips for each state.

              Column U = Average Skip for each state

              Column W = Highest Skip for each state

              Notice Texas, Tr-State and Virginia all have a current skip of 4.

              Steve, a fantastic piece of work.

                winsumloosesum's avatar - Lottery-060.jpg
                Pennsylvania
                United States
                Member #2218
                September 1, 2003
                5387 Posts
                Offline
                Posted: October 28, 2009, 1:23 pm - IP Logged

                Evening Skip Charts (part 1)

                Evening Chart

                  CARBOB's avatar - FL LOTTERY_LOGO.png
                  ORLANDO, FLORIDA
                  United States
                  Member #4924
                  June 3, 2004
                  5903 Posts
                  Offline
                  Posted: October 28, 2009, 1:24 pm - IP Logged

                  Hi Chaz,

                  Always a pleasure. 

                  Combined Skip Chart

                  Golden Oldies Combined Draws

                  Steve, Chaz is correct. This just may be your "Van Gogh" in Excel. The De and Texas combined is very inviting. Let's see what happens today. I would love to see this in Lotsoft, to have the entire history of skips. I do have a suggestion for all users. For the Florida combined , I would only use the draws starting in 5/19/08, the start of the Mid draws.

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5387 Posts
                    Offline
                    Posted: October 28, 2009, 1:25 pm - IP Logged

                    Evening Chart (part 2)

                    Evening Chart Part 2

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5387 Posts
                      Offline
                      Posted: October 28, 2009, 1:36 pm - IP Logged

                      Ok here is the link to all the updates to download in 1 zip file.

                      http://rapidshare.com/files/299174056/Golden_Oldies_All_Files_Updated.ZIP

                       

                      Download and unzip the 4 Excel files into your folder.  When program requests replacing existing files just click yes or accept.

                       

                      Have fun!!

                        CARBOB's avatar - FL LOTTERY_LOGO.png
                        ORLANDO, FLORIDA
                        United States
                        Member #4924
                        June 3, 2004
                        5903 Posts
                        Offline
                        Posted: October 28, 2009, 1:45 pm - IP Logged

                        Fla Mid results 278

                        One of the missing! I played 791, 971, looking for the digit 1 to repeatin P3.

                        179 197 278 296 368 386 476 548 593 638 647 683 728 746 782 791 809 836 845 863 908 926 953 971 980

                          CARBOB's avatar - FL LOTTERY_LOGO.png
                          ORLANDO, FLORIDA
                          United States
                          Member #4924
                          June 3, 2004
                          5903 Posts
                          Offline
                          Posted: October 28, 2009, 3:28 pm - IP Logged

                          Evening Skip Charts (part 1)

                          Evening Chart

                          Mi 10/28 Eve

                           

                          Results:  6 box combination groups  (30 straight combinations)

                          Tier 6
                          056(065,506,560,605,650) 267(276,627,672,726,762) 456(465,546,564,645,654) 678(687,768,786,867,876)

                           

                          Tier 3
                          966(669,696) 366(636,663)

                           

                            Kbones's avatar - Lottery-061.jpg
                            Georgia
                            United States
                            Member #77365
                            July 21, 2009
                            54 Posts
                            Offline
                            Posted: October 28, 2009, 4:07 pm - IP Logged

                            Hi, carbob
                            could you do this for GA, this eve 10-28 please.
                            Thaks in advance

                              CARBOB's avatar - FL LOTTERY_LOGO.png
                              ORLANDO, FLORIDA
                              United States
                              Member #4924
                              June 3, 2004
                              5903 Posts
                              Offline
                              Posted: October 28, 2009, 5:23 pm - IP Logged

                              Hi, carbob
                              could you do this for GA, this eve 10-28 please.
                              Thaks in advance

                              Kbones, I wouldn't be expecting a hit from this system tonight with all the hits lately, 4 of the last 5 draws .

                              These are some very good choices.

                              Tier 2
                              608(680) 628(682) 619(691)