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

Excel Users - Pick 3 & Pick 4

Topic closed. 23 replies. Last post 11 years ago by time*treat.

Page 2 of 2
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: December 14, 2005, 4:19 pm - IP Logged

Code also good for Pick 3, Pick 4, Pick 5, Pick 6, Pick 7, Pick 8, Pick 9, Pick 10 LOL

    lottaloot's avatar - AvatarZ56
    Redford/MI
    United States
    Member #3396
    January 18, 2004
    4867 Posts
    Offline
    Posted: December 14, 2005, 4:39 pm - IP Logged

    Thanks WSLS :=)

    L ttaL   T

      CARBOB's avatar - FL LOTTERY_LOGO.png
      ORLANDO, FLORIDA
      United States
      Member #4924
      June 3, 2004
      5912 Posts
      Offline
      Posted: December 14, 2005, 4:55 pm - IP Logged

      LL,

      =SUM((MID(A3,{1,2,3},1)+0))

       

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: December 14, 2005, 7:52 pm - IP Logged

        Thanks Carbob

         

        L ttaL   T

          lottaloot's avatar - AvatarZ56
          Redford/MI
          United States
          Member #3396
          January 18, 2004
          4867 Posts
          Offline
          Posted: December 14, 2005, 7:55 pm - IP Logged

          That's shorter than the one I attempted to make. 

          I sure wish I knew how to make short formulas--but I guess it is going to come with time. 

          L ttaL   T

            lottaloot's avatar - AvatarZ56
            Redford/MI
            United States
            Member #3396
            January 18, 2004
            4867 Posts
            Offline
            Posted: December 14, 2005, 8:00 pm - IP Logged

            I am designing my (all states) spreadsheet to look like this.  All on 1 page.

            In the end, I hope to figure out formulas that will apply a conditional format for all the filters that Lantern has taught in his tutorials.

             

             DateCA3H/LE/OROOTSUMLDR
            12/12Mon  966HHHOEE3211
            12/13Tues  683HHLEEO8177
            12/14Wed  219LLHEOO3122


            L ttaL   T

              time*treat's avatar - radar

              United States
              Member #13130
              March 30, 2005
              2171 Posts
              Offline
              Posted: December 14, 2005, 11:52 pm - IP Logged

              Pokefor powerplayer,

              if you're just looking for the number of skips between every instance of e.g. 123 in one state, it's basically an if-then inside a for-next loop inside a do-while(while-wend). If 2 numbers have the same lowform value, the skip is (draw A - draw B - 1). Set draw B as your new start point (new draw A) and look for the next instance of lowform. Do that until you run out of numbers. You'll just need a few vars to track the positions of A and B, but you have all the parts here. If you want something more complicated, you'll have to describe it in more detail.

               

              In neo-conned Amerika, bank robs you.
              Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

                powerplayer's avatar - Lottery-022.jpg

                United States
                Member #17834
                June 28, 2005
                2083 Posts
                Offline
                Posted: December 15, 2005, 4:15 am - IP Logged

                Thank you time*treat & WSLS

                I belive this will help. Going to work on it tonight.

                I want to do more then just one state also. I want to track the movement of a combination through each state.

                Example # 120:

                Tue, Dec 13, 2005KentuckyPick 31-2-0
                Mon, Dec 12, 2005OhioMidday Pick 31-0-2
                Sun, Dec 11, 2005CaliforniaMidday 30-1-2
                Sun, Dec 11, 2005Washington, D.C.Midday Lucky Numbers0-2-1


                This # has come out 4 times since Dec. 11th.

                I want the formula to do a hit and skip tracking from washington to cali to ohio to kentucky and give off the amount of skip and hit in a cell next to the # 120 seperate worksheet or the same one.

                The goal is to know how many days out a # has gone between states.

                It's a idea of mine ..not sure if any one tried it yet.

                So the cell for the answer would be like this:

                012:skip:hit

                021: skip:hit

                102

                120

                201

                210

                I have a sheet set up with all 1,000 combination typed out in each cell like the 012.

                It took awhile to do but, it's done...thank god for copy and paste.

                Maybe a macro can do this?

                One last thing....thinking in the future I will add a name reference to this also so I can cordinate the # with the state and see what state hits what combination the most while tracking the hits and skips of a state on a certain combination.

                I know the tools here on LP can do it. I have used them but, I'm trying to do this for my program with a lot of other things intergrated into it with out always having to go on LP to do it.

                Any help would be great!!


                Powerplayer

                Good luck to everyone!!!

                  time*treat's avatar - radar

                  United States
                  Member #13130
                  March 30, 2005
                  2171 Posts
                  Offline
                  Posted: December 15, 2005, 4:53 am - IP Logged

                  A macro will let you interact across multiple worksheets and across multiple workbooks. Each has it's advantages.

                  It looks like you want to track the number first, and the state second.

                  You could set the states next to each other by column, or put each one on a seperate sheet, making sure that e.g. Dec. 11 is on the same row in each sheet. Then, when you do a row comparison, you would add an extra loop that would let you check that row for each state.

                  Sort of saying:

                  check row 500 of every sheet and look for #120. 

                  If you use a select-case/end-select, you can edit your list of states very easily (literally changing a few lines) and the program will work just fine. Just adding these few things allows you do much more complex analysis.

                  In neo-conned Amerika, bank robs you.
                  Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.