Welcome Guest
Log In | Register )
The time is now 10:44 am
You last visited April 23, 2014, 10:41 am
All times shown are
Eastern Time (GMT-5:00)

Ohio 5/39 Excel File

Topic closed. 5 replies. Last post 3 years ago by Neener.

Page 1 of 1
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
4141 Posts
Online
Posted: September 2, 2011, 12:48 pm - IP Logged

Here is the download link to Ohio 5/39 Excel file.

http://www.box.net/shared/l6y35n4p5al89q8teab2

I've already updated the drawings through Thursday Sept 1, 2011

Open the Excel file.  You will be prompted to "Enable Macros"  Just click Yes.

Go to the first tab at the bottom labeled "Draws"

At the top you will see 2 Toolbars.  Top Toolbar is to add a new drawing (September 2 for example).  The 2nd Toolbar is to delete the most recent drawing.

All current drawings will always be on line 20.  All you need to do is enter in the winning numbers.  The date will automatically be entered.

Next, click the next Tab at the bottom labeled "NumberHistSkips".  This chart represent the hits/skips for all 39 numbers (1 through 39).

When you add a new drawing you will need to click the Toolbar labeled "COPY".

Then you can click any of the other 3 Toolbars (SORT HITS, SORT SKIPS, SORT DIGITS).  Depending on what you want to look at hits, skips, digits.

The actual sorting (Hits, Digits, Sips)takes place in cell range HD9 through HF48 (if you scroll over to cells HD through HF)

If you look at cell range J1 through AV1 you will also see the Hits, Skips, Digits.  This will change when you click the Toolbars "Sort Hits", "Sort Skips", or "Sort Digits"

    lakerben's avatar - Lottery-017.jpg
    New Mexico
    United States
    Member #86100
    January 29, 2010
    7792 Posts
    Offline
    Posted: September 2, 2011, 1:00 pm - IP Logged

    Here is the download link to Ohio 5/39 Excel file.

    http://www.box.net/shared/l6y35n4p5al89q8teab2

    I've already updated the drawings through Thursday Sept 1, 2011

    Open the Excel file.  You will be prompted to "Enable Macros"  Just click Yes.

    Go to the first tab at the bottom labeled "Draws"

    At the top you will see 2 Toolbars.  Top Toolbar is to add a new drawing (September 2 for example).  The 2nd Toolbar is to delete the most recent drawing.

    All current drawings will always be on line 20.  All you need to do is enter in the winning numbers.  The date will automatically be entered.

    Next, click the next Tab at the bottom labeled "NumberHistSkips".  This chart represent the hits/skips for all 39 numbers (1 through 39).

    When you add a new drawing you will need to click the Toolbar labeled "COPY".

    Then you can click any of the other 3 Toolbars (SORT HITS, SORT SKIPS, SORT DIGITS).  Depending on what you want to look at hits, skips, digits.

    The actual sorting (Hits, Digits, Sips)takes place in cell range HD9 through HF48 (if you scroll over to cells HD through HF)

    If you look at cell range J1 through AV1 you will also see the Hits, Skips, Digits.  This will change when you click the Toolbars "Sort Hits", "Sort Skips", or "Sort Digits"

    Can you make one for the New Mexico Roadunnercash

    1-37 with no bonus numbers?


    US Flag

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      4141 Posts
      Online
      Posted: September 2, 2011, 2:58 pm - IP Logged

      Can you make one for the New Mexico Roadunnercash

      1-37 with no bonus numbers?


      US Flag

      Info PR: n/a I: 728,000 L: 0 LD: 23,379 I: 146,000 Rank: 19278 Age: October 18, 2000 I: 0 whoissourceRobo: yesSitemap: yes Rank: 2150 Price: 52396 Links: 224|14(1) Density

      Here you go:

      http://www.box.net/shared/pbc8aq2n0txe5hpmrhte

      Forgot to mention in the 1st post.

      In the Tab labeled "NumberSkip<snip>s", in cell B2 you can change total number.  For example, in the New Mexico Excel file the current number is 571 in cell B2.  If you want to analyze less than 571 previous draws you can change the number to for example 250.

      Good Luck!!

      This post has been automatically changed by the Lottery Post computer system to remove inappropriate content and/or spam.

        Avatar
        bgonçalves
        Brasil
        Member #92566
        June 9, 2010
        1362 Posts
        Offline
        Posted: September 2, 2011, 3:24 pm - IP Logged
        Info PR: n/a I: 728,000 L: 0 LD: 23,379 I: 146,000 Rank: 19278 Age: October 18, 2000 I: 0 whoissourceRobo: yesSitemap: yes Rank: 2150 Price: 52396 Links: 224|14(1) Density

        Here you go:

        http://www.box.net/shared/pbc8aq2n0txe5hpmrhte

        Forgot to mention in the 1st post.

        In the Tab labeled "NumberSkip<snip>s", in cell B2 you can change total number.  For example, in the New Mexico Excel file the current number is 571 in cell B2.  If you want to analyze less than 571 previous draws you can change the number to for example 250.

        Good Luck!!

        This post has been automatically changed by the Lottery Post computer system to remove inappropriate content and/or spam.

        Hello, Winsun, I am not able to download your file at internet explorer 9    I tried downloading mozila also is not! How do I download, thanks

          lakerben's avatar - Lottery-017.jpg
          New Mexico
          United States
          Member #86100
          January 29, 2010
          7792 Posts
          Offline
          Posted: September 3, 2011, 12:40 pm - IP Logged
          Info PR: n/a I: 728,000 L: 0 LD: 23,379 I: 146,000 Rank: 19278 Age: October 18, 2000 I: 0 whoissourceRobo: yesSitemap: yes Rank: 2150 Price: 52396 Links: 224|14(1) Density

          Here you go:

          http://www.box.net/shared/pbc8aq2n0txe5hpmrhte

          Forgot to mention in the 1st post.

          In the Tab labeled "NumberSkip<snip>s", in cell B2 you can change total number.  For example, in the New Mexico Excel file the current number is 571 in cell B2.  If you want to analyze less than 571 previous draws you can change the number to for example 250.

          Good Luck!!

          This post has been automatically changed by the Lottery Post computer system to remove inappropriate content and/or spam.

          Thanks a million!!!!!!!!!!!

           

          US Flag

            Avatar
            New Member

            United States
            Member #80378
            September 25, 2009
            14 Posts
            Offline
            Posted: September 13, 2011, 7:56 pm - IP Logged

            Thank you