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

Need help with Excel

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

Page 1 of 1
51
PrintE-mailLink
theo1946's avatar - spherewall
Bakersfield, Ca
United States
Member #89877
April 17, 2010
201 Posts
Online
Posted: December 23, 2014, 3:04 pm - IP Logged

I am in need of some help my excel data. What I would like to do is find out how many times a specific number is followed by a specific number.

Example would be; how many times was the number 5 followed by number 6.

 

 

Thank you all,

Merry Christmas,

Ted

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

    Here you go:

    https://app.box.com/s/on4qzn08h1oyzg5425df

     

    Instructions:

    Excel file contains 4 Tabs at the bottom.

    Use the Tabs for CA3D (California Midday Draws), CA3E (California Evening Draws), and CA3C (California Combined Draws)

    I'll use the CA3D Tab as the example.  Same applies to the other 2 Tabs CA3E and CA3C

    Click the Tab labeled CA3D

    Notice there are 2 Toolbars in cell Column B1:B13

    Toolbar 1 "Click To Add New Drawing".  Clicking this toolbar will add a new date on Row 20.  Just enter your new Pick 3 draw in cell F20

    Toolbar 2 "Click To Delete Last Drawing".  Clicking this toolbar will delete the most current entry on Row 20

    In cell X2 you see the number 3091.  This represents the total number of California Midday Pick 3 draws.  I did not include every drawing.  You can adjust the number in cell X2 to whatever you like.  Example, 100, 200, 300, etc.  This number will represent how many drawings to analyze.

    In cell H14 notice the number 6.  If you click cell H14 you will notice a drop down arrow to the right.  You can select any number from 0 through 9.  I chose the number 6 since it was the last digit drawn for Position 1 in cell H20.  Notice the selections made in cells K14 and N14

    In cell range Q1 through U15 are the Totals based on what you selected in Cells H14, K14, and N14. (6, 3, 2)

    Cell range S13 through S15 are the 3 highest total number of Hits.  So for example, in Position 1 the highest totals are 39, 35, and 34. If you go to cell S5 you will see the number 39.  The 39 tells us that the number "3" (cell Q5) has hit a total of 39 times when a 6 is drawn.  The remaining digits would be 8 and 9.  You would look at the remaining Positions 2 and 3 using the same example.

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

      California Combined Draws

      Tab = CA3C

      Updated the Midday drawing 9-8-1 by clicking the toolbar "Add New Drawing"

      Entered 981 in cell F20

       

      Total Draws Used = 6183  (Cell X3)

      Last Draw Midday 12/23/2014 9-8-1

      Select 9 cell H14

      Select 8 cell K14

      Select 1 cell N14

      Top Digits - Note: Numbers in parenthesis are the total number of hits

      (9) Top 3 Digits Position 1 = 0, 4, 5 (72), (72), (72)

      (8) Top 3 Digits Position 2 = 6, 4, 8 (75), (64), (60)

      (1) Top 3 Digits Position 3 = 8, 4, 5 (77), (75), (69)

       

      Also updated the CA3D Tab > Add New Drawing > entered 981 in cell F20

        theo1946's avatar - spherewall
        Bakersfield, Ca
        United States
        Member #89877
        April 17, 2010
        201 Posts
        Online
        Posted: December 23, 2014, 6:49 pm - IP Logged

        Here you go:

        https://app.box.com/s/on4qzn08h1oyzg5425df

         

        Instructions:

        Excel file contains 4 Tabs at the bottom.

        Use the Tabs for CA3D (California Midday Draws), CA3E (California Evening Draws), and CA3C (California Combined Draws)

        I'll use the CA3D Tab as the example.  Same applies to the other 2 Tabs CA3E and CA3C

        Click the Tab labeled CA3D

        Notice there are 2 Toolbars in cell Column B1:B13

        Toolbar 1 "Click To Add New Drawing".  Clicking this toolbar will add a new date on Row 20.  Just enter your new Pick 3 draw in cell F20

        Toolbar 2 "Click To Delete Last Drawing".  Clicking this toolbar will delete the most current entry on Row 20

        In cell X2 you see the number 3091.  This represents the total number of California Midday Pick 3 draws.  I did not include every drawing.  You can adjust the number in cell X2 to whatever you like.  Example, 100, 200, 300, etc.  This number will represent how many drawings to analyze.

        In cell H14 notice the number 6.  If you click cell H14 you will notice a drop down arrow to the right.  You can select any number from 0 through 9.  I chose the number 6 since it was the last digit drawn for Position 1 in cell H20.  Notice the selections made in cells K14 and N14

        In cell range Q1 through U15 are the Totals based on what you selected in Cells H14, K14, and N14. (6, 3, 2)

        Cell range S13 through S15 are the 3 highest total number of Hits.  So for example, in Position 1 the highest totals are 39, 35, and 34. If you go to cell S5 you will see the number 39.  The 39 tells us that the number "3" (cell Q5) has hit a total of 39 times when a 6 is drawn.  The remaining digits would be 8 and 9.  You would look at the remaining Positions 2 and 3 using the same example.

        Hi win,

        Thank you, exactly what I had in mind.

        Merry Christmas,

        Ted

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

          Hi win,

          Thank you, exactly what I had in mind.

          Merry Christmas,

          Ted

          Your welcome!!

          These 2 Excel files include all states draws.

          https://app.box.com/s/wbi688upw1ewcwxymnpp

          https://app.box.com/s/hxdykstj1nz78mfi1h7c

           

          I post a video later on how to use the Excel files.

            Avatar

            United States
            Member #80378
            September 25, 2009
            21 Posts
            Offline
            Posted: December 24, 2014, 9:07 am - IP Logged

            Your welcome!!

            These 2 Excel files include all states draws.

            https://app.box.com/s/wbi688upw1ewcwxymnpp

            https://app.box.com/s/hxdykstj1nz78mfi1h7c

             

            I post a video later on how to use the Excel files.

            Thank you Steve.

            Merry Christmas

            Neener