Welcome Guest
Log In | Register )
The time is now 9:50 am
You last visited October 22, 2014, 9:47 am
All times shown are
Eastern Time (GMT-5:00)

Excel help (dates and draws)

Topic closed. 33 replies. Last post 2 years ago by alchemist7.

Page 1 of 3
PrintE-mailLink
Avatar

United States
Member #65711
October 4, 2008
30 Posts
Offline
Posted: October 26, 2012, 9:42 pm - IP Logged

I wanted to know if anyone in the forum has developed a system that can tell you dates of a combination of the number that was drawn. Below is an example off my state lottery web site for tonights drawn number.  If no one has a system, can someone point me in the right direction of getting started? I was trying to have this for a large group of numbers not just one or enter just one at a time.

 

Thanks for any help!

Digit1Digit2Digit3Digit4DrawDate
4492Evening10/26/12
4429Midday09/18/09
2494Midday07/21/08
4294Midday02/03/06
9442Evening02/25/05
9424Midday07/26/03
    Avatar
    Florida
    United States
    Member #66575
    October 30, 2008
    3544 Posts
    Offline
    Posted: October 26, 2012, 9:51 pm - IP Logged

    I wanted to know if anyone in the forum has developed a system that can tell you dates of a combination of the number that was drawn. Below is an example off my state lottery web site for tonights drawn number.  If no one has a system, can someone point me in the right direction of getting started? I was trying to have this for a large group of numbers not just one or enter just one at a time.

     

    Thanks for any help!

    Digit1Digit2Digit3Digit4DrawDate
    4492Evening10/26/12
    4429Midday09/18/09
    2494Midday07/21/08
    4294Midday02/03/06
    9442Evening02/25/05
    9424Midday07/26/03

    Can you be a little more specific as to what your looking for  ?

    As I understand you want to enter a draw and have it find all instances boxed and straight and the dates they hit.

    Is that correct  ??

    Do you have excel ? Which version ?

    Can you run macros  ?

    What state are you playing ??

    CG

      Avatar

      United States
      Member #65711
      October 4, 2008
      30 Posts
      Offline
      Posted: October 26, 2012, 11:21 pm - IP Logged

      Can you be a little more specific as to what your looking for  ?

      As I understand you want to enter a draw and have it find all instances boxed and straight and the dates they hit.

      Is that correct  ??

      Do you have excel ? Which version ?

      Can you run macros  ?

      What state are you playing ??

      CG

      Hi CarliG,

      Yes you are correct and I have 2010, yes i can run macros and the state is currently SC.

      thanks!

        Pogo's avatar - wfl
        NC
        United States
        Member #29378
        January 1, 2006
        533 Posts
        Offline
        Posted: October 26, 2012, 11:24 pm - IP Logged

        Can you be a little more specific as to what your looking for  ?

        As I understand you want to enter a draw and have it find all instances boxed and straight and the dates they hit.

        Is that correct  ??

        Do you have excel ? Which version ?

        Can you run macros  ?

        What state are you playing ??

        CG

        CarliG, you are working that excel with gusto. This is a multi-variable sheet that could become an animal fast. You're braver than me... Good Luck let me know, if you want to bounce some ideas around... Pogo Thumbs Up "Go For It!"

          Avatar
          Florida
          United States
          Member #66575
          October 30, 2008
          3544 Posts
          Offline
          Posted: October 26, 2012, 11:33 pm - IP Logged

          CarliG, you are working that excel with gusto. This is a multi-variable sheet that could become an animal fast. You're braver than me... Good Luck let me know, if you want to bounce some ideas around... Pogo Thumbs Up "Go For It!"

          LOL  Yeah but sometimes I bite off more than I can chew  lol

          I have a sheet that looks up draws via macro and gives me what came before and after . I was thinking maybe I could alter it ..

          Not sure ..

          Carlig

            Avatar

            United States
            Member #65711
            October 4, 2008
            30 Posts
            Offline
            Posted: October 26, 2012, 11:40 pm - IP Logged

            I have a macro that looks up numbers before and after a number on rows and columns.... I was thinking i can changed to do what I want but I don't know how to do it with out using up the percentage of thel cpu, on a big scale.

              Pogo's avatar - wfl
              NC
              United States
              Member #29378
              January 1, 2006
              533 Posts
              Offline
              Posted: October 26, 2012, 11:41 pm - IP Logged

              LOL  Yeah but sometimes I bite off more than I can chew  lol

              I have a sheet that looks up draws via macro and gives me what came before and after . I was thinking maybe I could alter it ..

              Not sure ..

              Carlig

              I couldn't think of the words "more than you can chew" - lol

              That sounds great with the macro... I love modifying things.... Well, coming up them from scratch is nice too, but since i haven't done many macros... Yes, modify that thing!

              Loving it & Staying tuned,

              Pogo

                Avatar
                Florida
                United States
                Member #66575
                October 30, 2008
                3544 Posts
                Offline
                Posted: October 26, 2012, 11:49 pm - IP Logged

                I have a macro that looks up numbers before and after a number on rows and columns.... I was thinking i can changed to do what I want but I don't know how to do it with out using up the percentage of thel cpu, on a big scale.

                Well heck, sounds like you may know more than me ..

                Cause I dont know anything about making sure macro doesnt use up percentage of CPU ..

                Like I said, sometimes I bite off more than I can chew ..

                Ill back off and hope someone else can do it.

                Carlig

                  Avatar

                  United States
                  Member #65711
                  October 4, 2008
                  30 Posts
                  Offline
                  Posted: October 26, 2012, 11:55 pm - IP Logged

                  Well heck, sounds like you may know more than me ..

                  Cause I dont know anything about making sure macro doesnt use up percentage of CPU ..

                  Like I said, sometimes I bite off more than I can chew ..

                  Ill back off and hope someone else can do it.

                  Carlig

                  No I don't know more than you.  I know when I run certain macros it shows in the window how much of the cpu its using.  And the macros i use are just altered ones of somebody elses that i tried to tweak to my purpose (most likely its wrong but it gets the job done). 


                  Thanks for your help anyways!

                    Avatar
                    Florida
                    United States
                    Member #66575
                    October 30, 2008
                    3544 Posts
                    Offline
                    Posted: October 26, 2012, 11:56 pm - IP Logged

                    I couldn't think of the words "more than you can chew" - lol

                    That sounds great with the macro... I love modifying things.... Well, coming up them from scratch is nice too, but since i haven't done many macros... Yes, modify that thing!

                    Loving it & Staying tuned,

                    Pogo

                    If you know how to modify, Ill be happy to give you what I have

                    Ill reading excel help forum now  lol

                    CG

                      Avatar

                      United States
                      Member #65711
                      October 4, 2008
                      30 Posts
                      Offline
                      Posted: October 27, 2012, 12:00 am - IP Logged

                      If you know how to modify, Ill be happy to give you what I have

                      Ill reading excel help forum now  lol

                      CG

                      I think the writer of this is turtle047 (not sure of if the name is correct)   this is what I'm trying to modify and I know there are much simpler loops than the ones I've written but i just couldn't get it to work!  i would be glad for what you can provide!

                       

                       

                       

                      Sub Macro1()
                       
                      Ln = 50

                      Range("A1:u46").Select 'selects range of cells

                      Selection.Interior.ColorIndex = 0 ' removes any color you might have had

                      c1 = Cells(48, 1)
                      c2 = Cells(48, 2)
                      c3 = Cells(48, 3)
                      c4 = Cells(48, 4)
                      c5 = Cells(48, 5)
                      c6 = Cells(48, 6)

                      'type = 1, for integers'

                      Cells(48, 1).Value = c1 ' these lines serve no purpose. you are puting the value you just picked up back into the same cell


                      For x = 1 To 47 ' ROW 1 THRU 47

                      For y = 1 To 21 ' COL BCDE

                      If c1 = Cells(x, y) Then Cells(x, y).Interior.ColorIndex = 3: GoSub capture_numbers


                      Next y

                      Next x

                      Exit Sub

                      capture_numbers: ' pick up the numbers suronding the target # x is the row y is the col

                      ' what you were looking for was row -1 y-1 y y+1 same row y-1 y+1 row +1 y-1 y y+1 total of 8 numbers

                      ' i would set up a couple of loops but to help ou understand the process i will code each location

                      If x = 1 Or y = 1 Then n1 = " " Else n1 = Cells(x - 1, y - 1)

                      If x = 1 Then n2 = " " Else n2 = Cells(x - 1, y)

                      If x = 1 Then n3 = " " Else n3 = Cells(x - 1, y + 1)

                      If y = 1 Then n4 = " " Else n4 = Cells(x, y - 1)

                      n5 = Cells(x, y + 1)

                      If y = 1 Then n6 = " " Else n6 = Cells(x + 1, y - 1)

                      n7 = Cells(x + 1, y)

                      n8 = Cells(x + 1, y + 1)

                      If n1 > 38 Then n1 = " " Else n1 = n1
                      If n1 = c1 Then n1 = " " Else n1 = n1
                      If n1 = c2 Then n1 = " " Else n1 = n1
                      If n1 = c3 Then n1 = " " Else n1 = n1
                      If n1 = c4 Then n1 = " " Else n1 = n1
                      If n1 = c5 Then n1 = " " Else n1 = n1
                      If n1 = c6 Then n1 = " " Else n1 = n1


                      If n2 > 38 Then n2 = " " Else n2 = n2
                      If n2 = c1 Then n2 = " " Else n2 = n2
                      If n2 = c2 Then n2 = " " Else n2 = n2
                      If n2 = c3 Then n2 = " " Else n2 = n2
                      If n2 = c4 Then n2 = " " Else n2 = n2
                      If n2 = c5 Then n2 = " " Else n2 = n2
                      If n2 = c6 Then n2 = " " Else n2 = n2

                      If n3 > 38 Then n3 = " " Else n3 = n3
                      If n3 = c1 Then n3 = " " Else n3 = n3
                      If n3 = c2 Then n3 = " " Else n3 = n3
                      If n3 = c3 Then n3 = " " Else n3 = n3
                      If n3 = c5 Then n3 = " " Else n3 = n3
                      If n3 = c4 Then n3 = " " Else n3 = n3
                      If n3 = c6 Then n3 = " " Else n3 = n3

                      If n4 > 38 Then n4 = " " Else n4 = n4
                      If n4 = c1 Then n4 = " " Else n4 = n4
                      If n4 = c2 Then n4 = " " Else n4 = n4
                      If n4 = c3 Then n4 = " " Else n4 = n4
                      If n4 = c4 Then n4 = " " Else n4 = n4
                      If n4 = c5 Then n4 = " " Else n4 = n4
                      If n4 = c6 Then n4 = " " Else n4 = n4

                      If n5 > 38 Then n5 = " " Else n5 = n5
                      If n5 = c1 Then n5 = " " Else n5 = n5
                      If n5 = c2 Then n5 = " " Else n5 = n5
                      If n5 = c3 Then n5 = " " Else n5 = n5
                      If n5 = c4 Then n5 = " " Else n5 = n5
                      If n5 = c5 Then n5 = " " Else n5 = n5
                      If n5 = c6 Then n5 = " " Else n5 = n5

                      If n6 > 38 Then n6 = " " Else n6 = n6
                      If n6 = c1 Then n6 = " " Else n6 = n6
                      If n6 = c2 Then n6 = " " Else n6 = n6
                      If n6 = c3 Then n6 = " " Else n6 = n6
                      If n6 = c4 Then n6 = " " Else n6 = n6
                      If n6 = c5 Then n6 = " " Else n6 = n6
                      If n6 = c6 Then n6 = " " Else n6 = n6

                      If n7 > 38 Then n7 = " " Else n7 = n7
                      If n7 = c1 Then n7 = " " Else n7 = n7
                      If n7 = c2 Then n7 = " " Else n7 = n7
                      If n7 = c3 Then n7 = " " Else n7 = n7
                      If n7 = c4 Then n7 = " " Else n7 = n7
                      If n7 = c5 Then n7 = " " Else n7 = n7
                      If n7 = c6 Then n7 = " " Else n7 = n7

                      If n8 > 38 Then n8 = " " Else n8 = n8
                      If n8 = c1 Then n8 = " " Else n8 = n8
                      If n8 = c2 Then n8 = " " Else n8 = n8
                      If n8 = c3 Then n8 = " " Else n8 = n8
                      If n8 = c4 Then n8 = " " Else n8 = n8
                      If n8 = c5 Then n8 = " " Else n8 = n8
                      If n8 = c6 Then n8 = " " Else n8 = n8


                      'display i 'll start at line 50 look back to the top of this routine ln=50

                      Cells(Ln, 1) = n1: Cells(Ln, 2) = n2: Cells(Ln, 3) = n3: Cells(Ln, 4) = n4

                      Cells(Ln, 5) = n5: Cells(Ln, 6) = n6: Cells(Ln, 7) = n7: Cells(Ln, 8) = n8


                      Ln = Ln + 1

                      Return
                      '
                      End Sub

                        MzDuffleBaglady's avatar - platinum 20rose.jpg
                        3-4-3
                        United States
                        Member #81314
                        October 16, 2009
                        10764 Posts
                        Offline
                        Posted: October 27, 2012, 12:09 am - IP Logged

                        History of  492 in  any order

                        Number

                        Draw Date

                        How many draws ago

                        Draws between draws

                        Time between draws

                         

                        294

                        Sunday, September 08, 2002(EVE)

                        6615

                        185

                        6m 1d (from start date)

                        942

                        Wednesday, September 18, 2002(EVE)

                        6605

                        10

                        10d

                        492

                        Thursday, January 02, 2003(EVE)

                        6499

                        106

                        3m 15d

                        294

                        Thursday, February 13, 2003(EVE)

                        6457

                        42

                        1m 11d

                        942

                        Wednesday, April 16, 2003(EVE)

                        6395

                        62

                        2m 3d

                        249

                        Wednesday, July 16, 2003(DAY)

                        6291

                        104

                        3m

                        249

                        Saturday, October 11, 2003(EVE)

                        6128

                        163

                        2m 25d

                        492

                        Friday, November 28, 2003(EVE)

                        6039

                        89

                        1m 17d

                        249

                        Friday, January 09, 2004(DAY)

                        5963

                        76

                        1m 12d

                        492

                        Sunday, August 15, 2004(EVE)

                        5556

                        407

                        7m 6d

                        249

                        Thursday, September 23, 2004(DAY)

                        5484

                        72

                        1m 8d

                        924

                        Friday, November 12, 2004(DAY)

                        5391

                        93

                        1m 20d

                        492

                        Tuesday, April 05, 2005(EVE)

                        5124

                        267

                        4m 24d

                        249

                        Thursday, May 05, 2005(EVE)

                        5068

                        56

                        1m

                        249

                        Saturday, June 11, 2005(EVE)

                        4999

                        69

                        1m 6d

                        924

                        Thursday, June 30, 2005(DAY)

                        4965

                        34

                        19d

                        924

                        Wednesday, July 27, 2005(DAY)

                        4915

                        50

                        27d

                        429

                        Thursday, November 24, 2005(DAY)

                        4692

                        223

                        3m 28d

                        942

                        Tuesday, January 03, 2006(EVE)

                        4617

                        75

                        1m 10d

                        249

                        Wednesday, January 04, 2006(EVE)

                        4615

                        2

                        1d

                        492

                        Saturday, February 18, 2006(EVE)

                        4531

                        84

                        1m 14d

                        942

                        Sunday, March 26, 2006(EVE)

                        4465

                        66

                        1m 8d

                        942

                        Friday, April 28, 2006(EVE)

                        4403

                        62

                        1m 2d

                        294

                        Friday, June 02, 2006(EVE)

                        4338

                        65

                        1m 5d

                        924

                        Monday, June 12, 2006(DAY)

                        4321

                        17

                        10d

                        492

                        Wednesday, December 06, 2006(EVE)

                        3991

                        330

                        5m 24d

                        492

                        Tuesday, February 27, 2007(EVE)

                        3837

                        154

                        2m 21d

                        294

                        Saturday, March 31, 2007(EVE)

                        3777

                        60

                        1m 4d

                        924

                        Wednesday, August 01, 2007(EVE)

                        3549

                        228

                        4m 1d

                        942

                        Sunday, August 26, 2007(EVE)

                        3503

                        46

                        25d

                        429

                        Monday, October 22, 2007(DAY)

                        3398

                        105

                        1m 26d

                        924

                        Friday, February 15, 2008(DAY)

                        3183

                        215

                        3m 24d

                        294

                        Monday, June 09, 2008(EVE)

                        2969

                        214

                        3m 25d

                        942

                        Monday, September 15, 2008(EVE)

                        2787

                        182

                        3m 6d

                        294

                        Friday, January 09, 2009(EVE)

                        2572

                        215

                        3m 25d

                        429

                        Saturday, January 24, 2009(DAY)

                        2545

                        27

                        15d

                        942

                        Monday, May 11, 2009(DAY)

                        2347

                        198

                        3m 17d

                        492

                        Friday, May 29, 2009(EVE)

                        2312

                        35

                        18d

                        429

                        Thursday, June 04, 2009(DAY)

                        2302

                        10

                        6d

                        429

                        Thursday, November 25, 2010(DAY)

                        1302

                        1000

                        1y 5m 21d

                        924

                        Wednesday, March 23, 2011(DAY)

                        1084

                        218

                        3m 26d

                        429

                        Tuesday, April 05, 2011(EVE)

                        1059

                        25

                        13d

                        942

                        Wednesday, July 20, 2011(DAY)

                        863

                        196

                        3m 15d

                        492

                        Tuesday, December 20, 2011(EVE)

                        578

                        285

                        5m

                        The number 492 has been drawn 45 times in any order. The last time it was drawn was on Tuesday, December 20, 2011(EVE), that is, 10m 6d ago (or 578 draws ago)

                         

                        Analysis:  The examination and evaluation of the relevant information to select the best course of action from among various alternatives.Type

                        “If the future doesn't come toward you, you have to go fetch it”

                         

                          Avatar

                          United States
                          Member #65711
                          October 4, 2008
                          30 Posts
                          Offline
                          Posted: October 27, 2012, 12:12 am - IP Logged

                          History of  492 in  any order

                          Number

                          Draw Date

                          How many draws ago

                          Draws between draws

                          Time between draws

                           

                          294

                          Sunday, September 08, 2002(EVE)

                          6615

                          185

                          6m 1d (from start date)

                          942

                          Wednesday, September 18, 2002(EVE)

                          6605

                          10

                          10d

                          492

                          Thursday, January 02, 2003(EVE)

                          6499

                          106

                          3m 15d

                          294

                          Thursday, February 13, 2003(EVE)

                          6457

                          42

                          1m 11d

                          942

                          Wednesday, April 16, 2003(EVE)

                          6395

                          62

                          2m 3d

                          249

                          Wednesday, July 16, 2003(DAY)

                          6291

                          104

                          3m

                          249

                          Saturday, October 11, 2003(EVE)

                          6128

                          163

                          2m 25d

                          492

                          Friday, November 28, 2003(EVE)

                          6039

                          89

                          1m 17d

                          249

                          Friday, January 09, 2004(DAY)

                          5963

                          76

                          1m 12d

                          492

                          Sunday, August 15, 2004(EVE)

                          5556

                          407

                          7m 6d

                          249

                          Thursday, September 23, 2004(DAY)

                          5484

                          72

                          1m 8d

                          924

                          Friday, November 12, 2004(DAY)

                          5391

                          93

                          1m 20d

                          492

                          Tuesday, April 05, 2005(EVE)

                          5124

                          267

                          4m 24d

                          249

                          Thursday, May 05, 2005(EVE)

                          5068

                          56

                          1m

                          249

                          Saturday, June 11, 2005(EVE)

                          4999

                          69

                          1m 6d

                          924

                          Thursday, June 30, 2005(DAY)

                          4965

                          34

                          19d

                          924

                          Wednesday, July 27, 2005(DAY)

                          4915

                          50

                          27d

                          429

                          Thursday, November 24, 2005(DAY)

                          4692

                          223

                          3m 28d

                          942

                          Tuesday, January 03, 2006(EVE)

                          4617

                          75

                          1m 10d

                          249

                          Wednesday, January 04, 2006(EVE)

                          4615

                          2

                          1d

                          492

                          Saturday, February 18, 2006(EVE)

                          4531

                          84

                          1m 14d

                          942

                          Sunday, March 26, 2006(EVE)

                          4465

                          66

                          1m 8d

                          942

                          Friday, April 28, 2006(EVE)

                          4403

                          62

                          1m 2d

                          294

                          Friday, June 02, 2006(EVE)

                          4338

                          65

                          1m 5d

                          924

                          Monday, June 12, 2006(DAY)

                          4321

                          17

                          10d

                          492

                          Wednesday, December 06, 2006(EVE)

                          3991

                          330

                          5m 24d

                          492

                          Tuesday, February 27, 2007(EVE)

                          3837

                          154

                          2m 21d

                          294

                          Saturday, March 31, 2007(EVE)

                          3777

                          60

                          1m 4d

                          924

                          Wednesday, August 01, 2007(EVE)

                          3549

                          228

                          4m 1d

                          942

                          Sunday, August 26, 2007(EVE)

                          3503

                          46

                          25d

                          429

                          Monday, October 22, 2007(DAY)

                          3398

                          105

                          1m 26d

                          924

                          Friday, February 15, 2008(DAY)

                          3183

                          215

                          3m 24d

                          294

                          Monday, June 09, 2008(EVE)

                          2969

                          214

                          3m 25d

                          942

                          Monday, September 15, 2008(EVE)

                          2787

                          182

                          3m 6d

                          294

                          Friday, January 09, 2009(EVE)

                          2572

                          215

                          3m 25d

                          429

                          Saturday, January 24, 2009(DAY)

                          2545

                          27

                          15d

                          942

                          Monday, May 11, 2009(DAY)

                          2347

                          198

                          3m 17d

                          492

                          Friday, May 29, 2009(EVE)

                          2312

                          35

                          18d

                          429

                          Thursday, June 04, 2009(DAY)

                          2302

                          10

                          6d

                          429

                          Thursday, November 25, 2010(DAY)

                          1302

                          1000

                          1y 5m 21d

                          924

                          Wednesday, March 23, 2011(DAY)

                          1084

                          218

                          3m 26d

                          429

                          Tuesday, April 05, 2011(EVE)

                          1059

                          25

                          13d

                          942

                          Wednesday, July 20, 2011(DAY)

                          863

                          196

                          3m 15d

                          492

                          Tuesday, December 20, 2011(EVE)

                          578

                          285

                          5m

                          The number 492 has been drawn 45 times in any order. The last time it was drawn was on Tuesday, December 20, 2011(EVE), that is, 10m 6d ago (or 578 draws ago)

                           

                          Hi Mzdufflebaglady,

                           

                          This would be great! I think i can tweak to work on a larger scale!

                            MzDuffleBaglady's avatar - platinum 20rose.jpg
                            3-4-3
                            United States
                            Member #81314
                            October 16, 2009
                            10764 Posts
                            Offline
                            Posted: October 27, 2012, 12:18 am - IP Logged

                            Hi Mzdufflebaglady,

                             

                            This would be great! I think i can tweak to work on a larger scale!

                            O.K.

                            I would be playing that number in your state, it's due.

                             

                            Good Luck.

                            Analysis:  The examination and evaluation of the relevant information to select the best course of action from among various alternatives.Type

                            “If the future doesn't come toward you, you have to go fetch it”

                             

                              Avatar

                              United States
                              Member #65711
                              October 4, 2008
                              30 Posts
                              Offline
                              Posted: October 27, 2012, 12:29 am - IP Logged

                              Mzduffle,


                              Could you tell me how to make a sheet like the one that you have pictured?