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

skip counting in excel

Topic closed. 4 replies. Last post 9 years ago by virgosat.

Page 1 of 1
PrintE-mailLink
Avatar
New Member
waldorf maryland
United States
Member #53603
July 13, 2007
3 Posts
Offline
Posted: July 29, 2007, 1:30 am - IP Logged

hello everyone i have been working on a system for pick five game 1/39 the bonus match five.....if some one here could help me i would really like to find a way to automate the process of counting the skips between a number hits using excel i have done about 1/3rd  by hand and i am about to go nuts

thanks in advance plaz

    SirMetro's avatar - center
    East of Atlanta
    United States
    Member #6191
    August 11, 2004
    1389 Posts
    Offline
    Posted: July 29, 2007, 10:46 am - IP Logged

    perhaps something like this?

     

    4,092 ABCDE12345678910111213141516
    Since Last Hit610194842023262621793
    30 Games Skip Pattern541272491084191364308156
    365 Games Skip Pattern8969976678966778
    1/2 All Games History8767777677786777
    Fantasy Five   X   OO XOOX  
     30 Game Skip 1 Year Ago16196375544451654788
     30 Game Skip 5 Years Ago885125825614212554710
     30 Game Skip 10 Years Ago115631283175163912698
    Max Skips54633541634854424458486556536145
                           
    7/19/20070322242526  1             
    7/18/20071020252935         8      
    7/17/20070316343536  0            2
    7/16/20070305072130  2 10 0         
    7/15/20070718192937      14         
    7/14/2007011116172454         2    17
    7/13/20070314212428  14          2  

     

    I only posted a snippet because to post the entire thing would shut me down.

      SirMetro's avatar - center
      East of Atlanta
      United States
      Member #6191
      August 11, 2004
      1389 Posts
      Offline
      Posted: July 29, 2007, 10:49 am - IP Logged

      This sheet that I have is roughly 99% automated

      The only thing I have not bothered to automate is the new number set entry

      Still, all said and done, it really has not been that beneficial, then again, perhaps I just don't know how to read some of what I can create

        SirMetro's avatar - center
        East of Atlanta
        United States
        Member #6191
        August 11, 2004
        1389 Posts
        Offline
        Posted: July 29, 2007, 10:58 am - IP Logged

        The sheet will also produce this chart as well, again, still has not generated much for me

         

        No30GHLSOut30D
        322 504 258(17)(10)
        035 581 97(2)(3)
        392 280 1715(2)(2)
        235 531 880 (2)
        213 563 127(5)(2)
        382 302 1614(2)(1)
        176 543 682 (1)
        363 297 11143 (1)
        295 565 770 (1)
        246 561 671 (1)
        255 528 781 (1)
        226 531 484 1
        207 576 374 1
        145 491 385 3
        184 593 572 3
        199 569 077 3
        335 550 275 4
        376 331 11211 4
        115 553 275 4
        104 568 473 4
        285 561 275 4
        162 563 117(4)4
        024 557 374 5
        263 545 583 5
        053 532 583 5
        303 541 583 5
        075 580 176 5
        275 571 176 5
        343 525 484 6
        355 553 077 6
        315 573 077 6
        063 561 374 7
        132 564 671 9
        153 556 176 9
        083 580 077 10
        041 537 178(9)13
        012 546 286 13
        122 511 088 15
        091 537 385 27
          Avatar

          Croatia
          Member #15231
          May 12, 2005
          18 Posts
          Offline
          Posted: July 31, 2007, 7:25 am - IP Logged

          Hello,

          I wish to have this sheet  because I don't know how make Excel to automate this proces. Can you send me your file ?

           

          Thank you very much,

          Virgosat