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

Excel File - Golden Oldies Georgia

Topic closed. 5 replies. Last post 7 years ago by mybolade.

Page 1 of 1
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: November 1, 2009, 9:12 pm - IP Logged

Below is a link to the Golden Oldies Excel file for a single state. In this example, Georgia Pick 3.

http://rapidshare.com/files/301163952/GoldenOldies.xls

The first 3 Tabs are:

1. "M" = Midday

2. "E" = Evening

3. "C" = Combined

Each one of the above Tabs has 2 Toolbars.  There is a Toolbar for Adding a new drawing and second Toolbar for deleting the most recent drawing.

So, if you want to add a new drawing just click the Toolbar labeled "Click To Add New Drawing".  You just need to add your new drawing in cell "E20"

Next, go to the Tab lableled "States".  Their are 3 Toolbars at the very top.

1.  "Click To Copy 1000 Midday Draws"

2.  "Click To Copy 1000 Evening Draws"

3.  "Click To Copy 1000 Combined Draws"

Click any one of the above Toolbars (Midday, Evening, or Combined).  This will copy 1000 draws into the "States" Tab.

Next, click the Toolbar labeled "Click To Copy 1000 Draws To "Calculations" Tab". 

This will calculate the 1000 draws. 

Once the calculations are completed you will be taken to the "GoldenOldiesSkipChart"

Cell range C5 through S5 and also cell range E8 through S8 will show the skips for the Golden Oldies which are any draws that occur where a Pick 3 combination was over 1000 draws or older.

In cell range U4 through U13 (Doubles), cell range U16 through U25 (No-Match), and U28 Triples.  This numbers in these cells are the total number of combinations, by beginning digit 0 through 9, that are over 1000 draws or more.  In cell column "X" you will see the corresponding double combinations that are 1000 draws old.  So for example, you will notice in cell U4 there is a number 16, in cell V4 you see the number "0" and in cell X4 you see all 16 double combinations that begin with the number "0".  001, 002, 003, 005 etc., etc.

If scroll down further to cell X34 you will see all the combinations that have hit in the last 1000 draws.

This Excel file has Georgia Midday, Evening, and Combined draws.  You can replace the draws with your states drawings.  Of course if you don't have a Midday draw you can just use the evening "E" tab andonly use the "Evening" Toolbar in the States Tab.

    Avatar
    columbus, GA
    United States
    Member #67676
    December 2, 2008
    2870 Posts
    Offline
    Posted: November 1, 2009, 10:06 pm - IP Logged

    thank! got anything else for ga?

      mybolade's avatar - praying hands.jpg
      Detroit, MI
      United States
      Member #8705
      November 15, 2004
      1396 Posts
      Offline
      Posted: November 2, 2009, 4:44 am - IP Logged

      Below is a link to the Golden Oldies Excel file for a single state. In this example, Georgia Pick 3.

      http://rapidshare.com/files/301163952/GoldenOldies.xls

      The first 3 Tabs are:

      1. "M" = Midday

      2. "E" = Evening

      3. "C" = Combined

      Each one of the above Tabs has 2 Toolbars.  There is a Toolbar for Adding a new drawing and second Toolbar for deleting the most recent drawing.

      So, if you want to add a new drawing just click the Toolbar labeled "Click To Add New Drawing".  You just need to add your new drawing in cell "E20"

      Next, go to the Tab lableled "States".  Their are 3 Toolbars at the very top.

      1.  "Click To Copy 1000 Midday Draws"

      2.  "Click To Copy 1000 Evening Draws"

      3.  "Click To Copy 1000 Combined Draws"

      Click any one of the above Toolbars (Midday, Evening, or Combined).  This will copy 1000 draws into the "States" Tab.

      Next, click the Toolbar labeled "Click To Copy 1000 Draws To "Calculations" Tab". 

      This will calculate the 1000 draws. 

      Once the calculations are completed you will be taken to the "GoldenOldiesSkipChart"

      Cell range C5 through S5 and also cell range E8 through S8 will show the skips for the Golden Oldies which are any draws that occur where a Pick 3 combination was over 1000 draws or older.

      In cell range U4 through U13 (Doubles), cell range U16 through U25 (No-Match), and U28 Triples.  This numbers in these cells are the total number of combinations, by beginning digit 0 through 9, that are over 1000 draws or more.  In cell column "X" you will see the corresponding double combinations that are 1000 draws old.  So for example, you will notice in cell U4 there is a number 16, in cell V4 you see the number "0" and in cell X4 you see all 16 double combinations that begin with the number "0".  001, 002, 003, 005 etc., etc.

      If scroll down further to cell X34 you will see all the combinations that have hit in the last 1000 draws.

      This Excel file has Georgia Midday, Evening, and Combined draws.  You can replace the draws with your states drawings.  Of course if you don't have a Midday draw you can just use the evening "E" tab andonly use the "Evening" Toolbar in the States Tab.

      Thanks Winsomeloosesum for all your hard work.

      Is there suppose to be a formula in cell E20 down on the calculations tab. Where are those numbers suppose to come from? Because there is nothing in the E20, E21, etc column, I am getting a lot of errors and blank cells on the calculations tab. Is this correct?

      P.S. I still have the files from 2007, I read somewhere that you could not find them.

      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
        Offline
        Posted: November 2, 2009, 8:30 am - IP Logged

        Thanks Winsomeloosesum for all your hard work.

        Is there suppose to be a formula in cell E20 down on the calculations tab. Where are those numbers suppose to come from? Because there is nothing in the E20, E21, etc column, I am getting a lot of errors and blank cells on the calculations tab. Is this correct?

        P.S. I still have the files from 2007, I read somewhere that you could not find them.

        Thanks for discovering the error. 

        I just uploaded and corrected the file.

        This is the link to Georgia Golden Oldies:

        http://rapidshare.com/files/301366969/GoldenOldiesGeorgiaPick3.xls

          CARBOB's avatar - FL LOTTERY_LOGO.png
          ORLANDO, FLORIDA
          United States
          Member #4924
          June 3, 2004
          5893 Posts
          Offline
          Posted: November 2, 2009, 1:17 pm - IP Logged

          Steve, nicely done, was hoping you would create one for single state. Very much appreciated.

            mybolade's avatar - praying hands.jpg
            Detroit, MI
            United States
            Member #8705
            November 15, 2004
            1396 Posts
            Offline
            Posted: November 3, 2009, 4:02 am - IP Logged

            Thanks for discovering the error. 

            I just uploaded and corrected the file.

            This is the link to Georgia Golden Oldies:

            http://rapidshare.com/files/301366969/GoldenOldiesGeorgiaPick3.xls

            Thanks again. This is great, MI hit the 004 yesterday. I did not play still researching and trying to understand everything you have done on the sheets.

            Thanks,

            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