You like Straights ...Right? Me too, and so...Previous TopicNext Topic

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

Midday States 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 .... 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

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.

Steve, a fantastic piece of work.

Evening Skip Charts (part 1)

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.

Evening Chart (part 2)

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

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

Mi 10/28 Eve

Results:  6 box combination groups  (30 straight combinations)

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)