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

(Poll) Converting numbers from the web to Excel

Topic closed. 32 replies. Last post 10 years ago by Rip Snorter.

Page 1 of 3
PrintE-mailLink

Is this the way you do it?

I ain't saying [ 0 ]  [0.00%]
Yes [ 4 ]  [36.36%]
No [ 5 ]  [45.45%]
The question doesn't make sense [ 2 ]  [18.18%]
Total Valid Votes [ 11 ]  
Discarded Votes [ 3 ]  
Avatar
New Mexico
United States
Member #12305
March 10, 2005
2984 Posts
Offline
Posted: July 8, 2006, 5:52 pm - IP Logged

 I posted the question on the Lottery Systems Forum, but I can see it's going to fall off the page without any response.

Maybe it will do better here.... maybe it needs a poll to spice it up:

 

Stefan's thread,

New Tool Timesaver

got me wondering whether I'm doing things upside-down and backward, which I tend to do.

It took me several months to jury-rig and patch together a means of taking draw results from this site, the NM site, and others, and working on them on the software I use.

Here's a for instance:

Unless I'm doing something wrong, the Daily Result on a Single Page on LP  won't convert directly to Excel, and it won't show up in a single cut-and-paste on MS Word to convert the Results to something I can work with.

Here's what I end up doing:

  1. Select all and Copy from the RESULTS page to Notepad
  2. Select all and Copy from Notepad to MS Word
  3. Go through a series of steps in MS Word replacing, say, 2006, with 2006(TAB), hyphen with (TAB), , powerball: with (TAB), , Power play: with (TAB), , bonus: with (TAB), and so on.
  4. Select all and Copy from MS Word to Notepad
  5. Select all and Copy from Notepad to Excel

Then, when I've got things worked up and want to wheel some numbers, I flip back and forth and back and forth trying to remember as many numbers as I can and plug them individually into the wheel-maker accurately.

Now, I usually make some refinements on the LP wheels I've generated.  So I need to get it back into Excel. Soooooooo

  1. Select all and Copy from the RESULTS page to Notepad
  2. Select all and Copy from Notepad to MS Word
  3. Go through a series of steps in MS Word replacing, say, 2006, with 2006(TAB), hyphen with (TAB), , powerball: with (TAB), , Power play: with (TAB), , bonus: with (TAB), and so on.
  4. Select all and Copy from MS Word to Notepad
  5. Select all and Copy from Notepad to Excel

 Hokay.  Now I want to post a prediction for a 5+1 game wheel.

I ain't even going to describe what I go through to do that.

I'm not complaining.  I figure I am just really stupid and that I've cobbled something together that eventually gets me through, gotten used to it, and probably am doing something about ten times as tedious and time consuming as anyone with a lick of sense would do.

IS there an easy way to get all this done that someone can describe to me here?

I've been looking on TuDogs.com hoping to find a notepad type editor with some enhanced abilities that might cut out some steps, but maybe it's something can be done with what I already have.

Anyone who knows a better way and will tell me will have me grovelling and drooling.

Gracias,

Jack

Absorb the good, ignore the bad, weigh the ugly.

It's about number behavior.

Egos don't count.

 

Dedicated to the memory of Big Loooser

 

    LottoChica23's avatar - Aquarius
    Fughedaboutit (NY)
    United States
    Member #8160
    October 26, 2004
    6777 Posts
    Offline
    Posted: July 8, 2006, 6:12 pm - IP Logged

    Jack,

    I replied to your post on the other Forum... 

    Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

    check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

    You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

      Avatar
      New Mexico
      United States
      Member #12305
      March 10, 2005
      2984 Posts
      Offline
      Posted: July 8, 2006, 6:17 pm - IP Logged

      Thanks for the reply over there, and thank you here, also.

      Thankyouthankyouthankyouthankyou.

      I'm your slave.

      J

      Absorb the good, ignore the bad, weigh the ugly.

      It's about number behavior.

      Egos don't count.

       

      Dedicated to the memory of Big Loooser

       

        LottoChica23's avatar - Aquarius
        Fughedaboutit (NY)
        United States
        Member #8160
        October 26, 2004
        6777 Posts
        Offline
        Posted: July 8, 2006, 6:29 pm - IP Logged

        Thanks for the reply over there, and thank you here, also.

        Thankyouthankyouthankyouthankyou.

        I'm your slave.

        J

        You're welcome. You sure about that? LOL

        Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

        check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

        You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

          Avatar
          New Mexico
          United States
          Member #12305
          March 10, 2005
          2984 Posts
          Offline
          Posted: July 8, 2006, 6:46 pm - IP Logged

          Thanks for the reply over there, and thank you here, also.

          Thankyouthankyouthankyouthankyou.

          I'm your slave.

          J

          You're welcome. You sure about that? LOL

          Yeah.

          But I feel comfortable I can convince you I ain't worthy of you if it comes to it.

          I have a lot of experience along those lines.

          Thanks again.  You are a saint.

          J

          Absorb the good, ignore the bad, weigh the ugly.

          It's about number behavior.

          Egos don't count.

           

          Dedicated to the memory of Big Loooser

           

            Pogo's avatar - wfl
            NC
            United States
            Member #29378
            January 1, 2006
            552 Posts
            Offline
            Posted: July 8, 2006, 7:48 pm - IP Logged

            Sorry to vote NO, but that's not the way I do it... Well, my way might not be any better though, so here goes:

            -Copy & Paste data to Notepad

            -Save Notepad file

            -Go into Excel & import data right from notepad file & you're done 

            I like this method, because when you import a notepad file into Excel; you get a chance to tell Excel exactly how you want it imported. I.E. use the spaces as columns or use the ;'s for columns or use a tab for columns or whatever you want to define as your column "delimiter" 

            Hope this helps & Here's a shout out to PowerPlayer & HyperSoniq - Miss hearing from you guys online...

            POGO 

              RJOh's avatar - chipmunk
              mid-Ohio
              United States
              Member #9
              March 24, 2001
              19825 Posts
              Offline
              Posted: July 8, 2006, 8:44 pm - IP Logged

              I don't use Excel, but I do use a program that imports ASCII files with .EXT(extension) *.LOT.  For the file to be readable each line(record) has to have the following format:

               MO,DA,YR,N1,N2,N3,N4,N5,N6,N7

              I usually copy and past the data from a website to NotePad and use the editing tools in NotePad to change the file before saving it with an appropriate name for my program. N6 is for pick6 games and N7 is for games with a bonus number, the program knows which it is by its importing instructions.  For example if each line in the file has the format:

               06/15/2006 - 01 05 10 20 30 40

              I use the "find and replace all" editing tool:
              "/" to ","
              " - " to ","
              " " to ","
              "200" to "0"
              The end of each line has an invisible CR(carriage return) which is recognized as an EOR(end of record)by my program and the line becomes:

               06,15,06,01,05,10,20,30,40

              I now save the file to the appropriate directory with a file name and .EXT that the program will recognize.
               

               * you don't need to buy more tickets, just buy a winning ticket * 
                 
                           Evil Looking       

                johnph77's avatar - avatar
                CA
                United States
                Member #2987
                December 10, 2003
                832 Posts
                Offline
                Posted: July 8, 2006, 8:47 pm - IP Logged

                RS -

                I use UltraEdit as my text editor. With its columnar editing capability it's the best thing for editing columns of numbers, creating ".csv" files, making HTML tables, anything of this sort you'd care to name. I believe the price on it now is $40 but when I purchased it, it was $35. Best investment in computer software I've ever made.

                www.ultraedit.com

                gl

                j

                Blessed Saint Leibowitz, keep 'em dreamin' down there..... 

                Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

                 =^.^=

                  Avatar
                  New Mexico
                  United States
                  Member #12305
                  March 10, 2005
                  2984 Posts
                  Offline
                  Posted: July 8, 2006, 8:50 pm - IP Logged

                  Sorry to vote NO, but that's not the way I do it... Well, my way might not be any better though, so here goes:

                  -Copy & Paste data to Notepad

                  -Save Notepad file

                  -Go into Excel & import data right from notepad file & you're done 

                  I like this method, because when you import a notepad file into Excel; you get a chance to tell Excel exactly how you want it imported. I.E. use the spaces as columns or use the ;'s for columns or use a tab for columns or whatever you want to define as your column "delimiter" 

                  Hope this helps & Here's a shout out to PowerPlayer & HyperSoniq - Miss hearing from you guys online...

                  POGO 

                  Thanks Pogo.

                  I'm obliged.

                  Jack

                  Absorb the good, ignore the bad, weigh the ugly.

                  It's about number behavior.

                  Egos don't count.

                   

                  Dedicated to the memory of Big Loooser

                   

                    Avatar
                    New Mexico
                    United States
                    Member #12305
                    March 10, 2005
                    2984 Posts
                    Offline
                    Posted: July 8, 2006, 8:51 pm - IP Logged

                    RS -

                    I use UltraEdit as my text editor. With its columnar editing capability it's the best thing for editing columns of numbers, creating ".csv" files, making HTML tables, anything of this sort you'd care to name. I believe the price on it now is $40 but when I purchased it, it was $35. Best investment in computer software I've ever made.

                    www.ultraedit.com

                    gl

                    j

                    John:

                    Thanks.

                    Next time I'm ahead enough to afford it I'll get me one of those doomsday machines.

                    Gracias,

                    Jack

                    Absorb the good, ignore the bad, weigh the ugly.

                    It's about number behavior.

                    Egos don't count.

                     

                    Dedicated to the memory of Big Loooser

                     

                      Avatar
                      New Mexico
                      United States
                      Member #12305
                      March 10, 2005
                      2984 Posts
                      Offline
                      Posted: July 8, 2006, 8:55 pm - IP Logged

                      I don't use Excel, but I do use a program that imports ASCII files with .EXT(extension) *.LOT.  For the file to be readable each line(record) has to have the following format:

                       MO,DA,YR,N1,N2,N3,N4,N5,N6,N7

                      I usually copy and past the data from a website to NotePad and use the editing tools in NotePad to change the file before saving it with an appropriate name for my program. N6 is for pick6 games and N7 is for games with a bonus number, the program knows which it is by its importing instructions.  For example if each line in the file has the format:

                       06/15/2006 - 01 05 10 20 30 40

                      I use the "find and replace all" editing tool:
                      "/" to ","
                      " - " to ","
                      " " to ","
                      "200" to "0"
                      The end of each line has an invisible CR(carriage return) which is recognized as an EOR(end of record)by my program and the line becomes:

                       06,15,06,01,05,10,20,30,40

                      I now save the file to the appropriate directory with a file name and .EXT that the program will recognize.
                       

                      RJOH:

                      I'm obliged, though I'm going to have to study your post a while to understand it.

                      Some of what you have there is reminescent of some of the stuff the comp threw at me when I was trying to get it to help me by using MS Access.  I finally set that one aside thinking maybe someday I'll get younger and try understanding it again.

                      I'm going to study your post.

                      Gracias,

                      Jack

                      Absorb the good, ignore the bad, weigh the ugly.

                      It's about number behavior.

                      Egos don't count.

                       

                      Dedicated to the memory of Big Loooser

                       

                        lottaloot's avatar - AvatarZ56
                        Redford/MI
                        United States
                        Member #3396
                        January 18, 2004
                        4867 Posts
                        Offline
                        Posted: July 8, 2006, 11:07 pm - IP Logged

                        Sorry to vote NO, but that's not the way I do it... Well, my way might not be any better though, so here goes:

                        -Copy & Paste data to Notepad

                        -Save Notepad file

                        -Go into Excel & import data right from notepad file & you're done 

                        I like this method, because when you import a notepad file into Excel; you get a chance to tell Excel exactly how you want it imported. I.E. use the spaces as columns or use the ;'s for columns or use a tab for columns or whatever you want to define as your column "delimiter" 

                        Hope this helps & Here's a shout out to PowerPlayer & HyperSoniq - Miss hearing from you guys online...

                        POGO 

                        I do it this way to. 

                        But I got to know excel better I was making it long and drawn out too.

                        L ttaL   T

                          cps10's avatar - Lottery-004.jpg
                          The Carolinas - Charlotte
                          United States
                          Member #21627
                          September 12, 2005
                          4138 Posts
                          Offline
                          Posted: July 8, 2006, 11:13 pm - IP Logged

                          Interesting post, Jack. Thanks for bringing it up.

                          The North Carolina Education Lottery - so much a joke that here are their mascots:

                          Stooges

                            Avatar
                            New Mexico
                            United States
                            Member #12305
                            March 10, 2005
                            2984 Posts
                            Offline
                            Posted: July 9, 2006, 12:47 am - IP Logged

                            Interesting post, Jack. Thanks for bringing it up.

                            It was a selfish thing for me to do, cps10. 

                            This whole issue of getting numbers off the web and into Excel's had me chewing my mustache almost from the day 1.  Out of hunger I eventually came up with the thing I described in the top post. 

                            But that was after I'd already hanged myself half a dozen times and jumped off three cliffs.  One patch of the area between my left nostril and my upper lip went spang bald on me out of anger and rebellion from all the gnawing it was getting.

                            Gracias,

                            J

                            Absorb the good, ignore the bad, weigh the ugly.

                            It's about number behavior.

                            Egos don't count.

                             

                            Dedicated to the memory of Big Loooser

                             


                              United States
                              Member #16612
                              June 2, 2005
                              3493 Posts
                              Offline
                              Posted: July 9, 2006, 12:52 am - IP Logged

                              Rip Snorter, my vote is yes. I think you can convert numbers into Excel. I have some lotto history from CA SLP, Washington Lotto Plus, Texas Lotto with Bonus Ball, Powerball, and Mega Millions in my word document. I have their frequency recorded on Excel.