Welcome Guest
Log In | Register )
You last visited January 23, 2017, 2:32 am
All times shown are
Eastern Time (GMT-5:00)

(Poll) Converting numbers from the web to Excel

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

Page 2 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 9, 2006, 6:54 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.

Sounds as though you might be on a similar track to one that's intrigued me, on and off.  Those bonus balls surely do some wierd things, eh? 

You've just given me an idea I don't believe I've ever thought of before about how a person might figure them out.

Gracias, amogo

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

 

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

    Jack - so you are able to convert your draws into Excel easily?

    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, 2:23 pm - IP Logged

      Jack - so you are able to convert your draws into Excel easily?

      Hi cps10:

      I'd be lying if I answered yes.  But it's knocked out one step in the process.

      I've not yet whupped the other aspects people have posted.  They might make it simpler, also.

      But it's always going to cumpersome, thinks I, until there's a way just to cut and paste directly to Excel.

      Maybe there's a better spreadsheet out there that will allow it.

      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

       

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

        I do believe there are programs out there that allow you to import to Excel directly.

        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, 2:32 pm - IP Logged

          I do believe there are programs out there that allow you to import to Excel directly.

          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

           This one posted by John sounds as though it does.

          I just can't be spending money on software at the moment.

          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

           

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

            I've got a trial version downloading, but it's 7.7 Mg.... says it's going to take hmmm another hour and two minutes and a smattering of seconds to get it all downloaded.

            Looking forward to trying it out for a month on their nickle before I have to give it back.

            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

             

              Fibonacci's avatar - Lottery-050.jpg
              New York, NY
              United States
              Member #39471
              May 16, 2006
              2698 Posts
              Offline
              Posted: July 9, 2006, 3:15 pm - IP Logged

              Maybe someone else has said it --I have not read every response. But I simply highlight, copy and paste into Excel as follows:

              Must have Excel open before 

              1. Highlight (from web)

              2. Copy (from web page)

              3. Right click in Excel

              4. Choose "Paste Special" 

              5. Choose "Unicode Text" 

              $$$

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

                Maybe someone else has said it --I have not read every response. But I simply highlight, copy and paste into Excel as follows:

                Must have Excel open before 

                1. Highlight (from web)

                2. Copy (from web page)

                3. Right click in Excel

                4. Choose "Paste Special" 

                5. Choose "Unicode Text" 

                Nobody's said that, but as soon as I finish this download (68 percent complete - another 23 minutes) I'm going to give it a try.

                Thanks a bunch,

                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

                 

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

                  Maybe someone else has said it --I have not read every response. But I simply highlight, copy and paste into Excel as follows:

                  Must have Excel open before 

                  1. Highlight (from web)

                  2. Copy (from web page)

                  3. Right click in Excel

                  4. Choose "Paste Special" 

                  5. Choose "Unicode Text" 

                  I just tried it.

                  Yep, surely does paste.  Trouble is, all the numbers are in the same cell.

                  I'd forgotten I knew that already and that was the reason I had to find another way.... some means of getting them into text format, getting the hyphens, commas, trash out and a TAB between each number so's it could be pasted into Excel.

                  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 9, 2006, 5:09 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:

                    That's an awfully cool program.  I downloaded the free trial version and am super impressed, though it's going to take some learning.

                    Seems a bit unforgiving, however.  The 'undo' button doesn't let a person back up from, say, the cool sort he just did ...... if it isn't saved or backed up, how it was before is lost.

                    But I've only been playing with it half an hour.  Might just be a matter of learning it more thouroughly.

                    Thanks again,

                    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

                     

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

                      Completely amazing.  All the Pick 5 draws from yesterday in the blink of an eye:


                       Jul 8, 2006  01 18 27 28 36
                       Jul 8, 2006  02 12 20 33 40
                       Jul 8, 2006  02 13 22 23 27
                       Jul 8, 2006  03 07 09 27 35
                       Jul 8, 2006  03 11 13 27 30  21
                       Jul 8, 2006  03 15 17 23 30
                       Jul 8, 2006  03 26 28 35 36
                       Jul 8, 2006  04 05 06 20 28
                       Jul 8, 2006  04 08 26 30 37
                       Jul 8, 2006  04 09 10 14 15
                       Jul 8, 2006  04 10 24 27 31
                       Jul 8, 2006  04 14 19 26 27
                       Jul 8, 2006  04 20 34 80 85
                       Jul 8, 2006  05 25 28 32 37
                       Jul 8, 2006  06 13 18 26 31
                       Jul 8, 2006  07 09 14 25 32
                       Jul 8, 2006  07 17 29 30 31  01
                       Jul 8, 2006  08 10 19 26 33
                       Jul 8, 2006  08 11 19 31 34
                       Jul 8, 2006  09 13 28 29 36
                       Jul 8, 2006  09 15 16 21 30
                       Jul 8, 2006  09 18 31 34 35
                       Jul 8, 2006  11 14 23 31 37
                       Jul 8, 2006  12 13 19 21 23
                       Jul 8, 2006  12 15 17 28 35
                       Jul 8, 2006  12 16 20 31 36
                       Jul 8, 2006  13 19 20 21 23
                       Jul 8, 2006  13 19 24 31 34
                       Jul 8, 2006  20 21 23 33 38  11
                       Jul 8, 2006  24 31 32 35 37
                       Jul 8, 2006  25 26 27 36 38

                      UltraEdit-32 folks..... she's a humdinger

                      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

                       

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

                        Will take a look at that as well.

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

                        Stooges

                          Avatar
                          NASHVILLE, TENN
                          United States
                          Member #33372
                          February 20, 2006
                          1044 Posts
                          Offline
                          Posted: July 9, 2006, 9:44 pm - IP Logged

                          Man, am I that far behind the times!?  All ya'll go using computer programs, cutting and pasting, unicoding it here and there.  Ya'll got me beat 9 ways from Sunday.  I use my fingers and type the numbers into Excel.

                           

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

                            Man, am I that far behind the times!?  All ya'll go using computer programs, cutting and pasting, unicoding it here and there.  Ya'll got me beat 9 ways from Sunday.  I use my fingers and type the numbers into Excel.

                             

                            Gasmeterguy:

                            I don't believe in unicoding stuff because I don't know what it is.

                            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

                             

                              johnph77's avatar - avatar
                              CA
                              United States
                              Member #2987
                              December 10, 2003
                              832 Posts
                              Offline
                              Posted: July 9, 2006, 10:38 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:

                              That's an awfully cool program.  I downloaded the free trial version and am super impressed, though it's going to take some learning.

                              Seems a bit unforgiving, however.  The 'undo' button doesn't let a person back up from, say, the cool sort he just did ...... if it isn't saved or backed up, how it was before is lost.

                              But I've only been playing with it half an hour.  Might just be a matter of learning it more thouroughly.

                              Thanks again,

                              J

                              Jack -

                              yqw - glad to pass the word.

                              The software's capability to handle files as large as 2Gb doesn't hurt, either, although in files that large, moving from place to place will produce unexxpected results at the top of the screen. It'll seem disconcerting at first. Takes getting used to.

                              For what it does, it's still a bargain.

                              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.

                               =^.^=