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

excel help please

Topic closed. 18 replies. Last post 5 years ago by LottoBoner.

Page 1 of 2
PrintE-mailLink

United States
Member #124493
March 14, 2012
7023 Posts
Offline
Posted: May 21, 2012, 2:40 pm - IP Logged

i recently tried to copy and paste from NYL website and an annoying thing occurred...some of the results popped up as dates.

i need help to get those dates back to the original number, this is the first time this has happenned to me and it didnt happen yesterday....i have posted an example of what i got below...interestingly the only numbers that stayed true were the ones having a zero in it. i have tried to use the format cells option...but i dont see the data reverting...help please...this data has become useless!!!

05/21/2012 Midday

1/7/2006

14

05/20/2012 Evening

0-1-4

5

05/20/2012 Midday

8/7/2005

20

05/19/2012 Evening

2/3/2005

10

05/19/2012 Midday

2/1/2003

6

05/18/2012 Evening

8/3/2007

18

05/18/2012 Midday

3/8/2008

19

05/17/2012 Evening

8/2/2002

12

05/17/2012 Midday

6/5/2008

19

05/16/2012 Evening

2/6/2009

17

05/16/2012 Midday

2/4/2009

15

05/15/2012 Evening

6/7/2003

16

05/15/2012 Midday

1-0-0

1

05/14/2012 Evening

6/4/2001

11

05/14/2012 Midday

9/7/2000

16

05/13/2012 Evening

8-0-4

12

05/13/2012 Midday

1-0-0

1

05/12/2012 Evening

5/4/2009

18

05/12/2012 Midday

5/4/2001

10

    Avatar
    Florida
    United States
    Member #66575
    October 30, 2008
    3549 Posts
    Offline
    Posted: May 21, 2012, 2:47 pm - IP Logged

    i recently tried to copy and paste from NYL website and an annoying thing occurred...some of the results popped up as dates.

    i need help to get those dates back to the original number, this is the first time this has happenned to me and it didnt happen yesterday....i have posted an example of what i got below...interestingly the only numbers that stayed true were the ones having a zero in it. i have tried to use the format cells option...but i dont see the data reverting...help please...this data has become useless!!!

    05/21/2012 Midday

    1/7/2006

    14

    05/20/2012 Evening

    0-1-4

    5

    05/20/2012 Midday

    8/7/2005

    20

    05/19/2012 Evening

    2/3/2005

    10

    05/19/2012 Midday

    2/1/2003

    6

    05/18/2012 Evening

    8/3/2007

    18

    05/18/2012 Midday

    3/8/2008

    19

    05/17/2012 Evening

    8/2/2002

    12

    05/17/2012 Midday

    6/5/2008

    19

    05/16/2012 Evening

    2/6/2009

    17

    05/16/2012 Midday

    2/4/2009

    15

    05/15/2012 Evening

    6/7/2003

    16

    05/15/2012 Midday

    1-0-0

    1

    05/14/2012 Evening

    6/4/2001

    11

    05/14/2012 Midday

    9/7/2000

    16

    05/13/2012 Evening

    8-0-4

    12

    05/13/2012 Midday

    1-0-0

    1

    05/12/2012 Evening

    5/4/2009

    18

    05/12/2012 Midday

    5/4/2001

    10

    Same thing happens to me all the time , even when I copy from LP, so I will be watching to see if anyone has a solution .

     

    Thanks

    Carlig

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: May 21, 2012, 2:54 pm - IP Logged

      Same thing happens to me all the time , even when I copy from LP, so I will be watching to see if anyone has a solution .

       

      Thanks

      Carlig

      Click Results > Daily Numbers Games

      There is an option to remove the dashes from the results.  Just uncheck this option.

      Then click the link for your state and copy and paste your results into Excel

        Avatar
        Florida
        United States
        Member #66575
        October 30, 2008
        3549 Posts
        Offline
        Posted: May 21, 2012, 3:09 pm - IP Logged

        Click Results > Daily Numbers Games

        There is an option to remove the dashes from the results.  Just uncheck this option.

        Then click the link for your state and copy and paste your results into Excel

        Now it cant be that simple, can it  lol

        Thanks Steve, gonna give it a try

        Okay, I tried....

        So the only way to get them is in this format ??

        its what I get when I uncheck the dash ,

        Im trying like get all the pick 3 in one column,

        I tried going to the actual state drawings instead of "Daily Number"

        and I dont see the option there to remove dashes

        Wed, May 16, 2012
        551
        783
        8387
        1855

         

        Carlig


          United States
          Member #124493
          March 14, 2012
          7023 Posts
          Offline
          Posted: May 21, 2012, 3:18 pm - IP Logged

          When I tried to paste special...there are three options.

          it comes up as

          HTML  this one converts data into dates

          Unicode Text and

          text

          Both unicode text and text paste the correct values...

          but then the data is not neatly displayed to be delimited...it would take forever to move the data into columns by cut and pasting...

          the only problem with search results with LP is that it is only for last month...

          i want to do to 2008 from NYL website...and they are making it very difficult for me...probably intentionally so as to keep the player with a severe disadvantage..


            United States
            Member #124493
            March 14, 2012
            7023 Posts
            Offline
            Posted: May 21, 2012, 3:20 pm - IP Logged

            removing the dashes is easy if you delimit in excel...but how to get from dates back to dashes?


              United States
              Member #124493
              March 14, 2012
              7023 Posts
              Offline
              Posted: May 21, 2012, 3:28 pm - IP Logged

              this is what it looks like pasting as text or unicode text...

              05/21/2012 Midday

              1

              7

              6

              14

              05/20/2012 Evening

              0

              1

              4

              5

                time*treat's avatar - radar

                United States
                Member #13130
                March 30, 2005
                2171 Posts
                Offline
                Posted: May 21, 2012, 3:50 pm - IP Logged

                Copying from the NY page into notepad came out like ...

                e.g.
                05/21/2012 Midday    1-7-6    14
                05/20/2012 Evening    0-1-4    05
                05/20/2012 Midday    8-7-5    20

                Then saved that as a text file.

                Opened excel and told it to import the text file (.txt)

                At step three, on the import wizard, highlighted column containing the triplets and set that column format as text.

                Clicked "Finish".

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


                  United States
                  Member #124493
                  March 14, 2012
                  7023 Posts
                  Offline
                  Posted: May 21, 2012, 3:56 pm - IP Logged

                  thanks T*T...i will let you know how it goes when i give it a whirl!!

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5387 Posts
                    Offline
                    Posted: May 21, 2012, 5:42 pm - IP Logged

                    The browser you are using may have something to do with how your data is formatted when you copy and paste into Excel.

                    I had to create a few variations for Microsoft Internet Explorer and Mozilla Firefox.  Micrsoft Internet Explorer will place all the data in 1 column whereas Mozilla Firefox will actually place all the data in the correct cells for my own Excel file(s).

                    The other thing that will affect how your data is copied is if you have previous settings for Data > Text to columns that are causing the data to go into the incorrect cell range(s).

                    Personally Mozilla Firefox cuts down the copy and paste a step or 2.

                    If you would like my Excel file I use to update all the State draws including the Canadian draws your welcome to use it. 

                    Draws are current through Sunday May 20, 2012

                    https://www.box.com/s/6097c8c41d299af340e5

                    This is the video on how to update the draws from Lotterypost into Excel via Microsoft Internet Explorer.  If you are using Mozilla Firefox you will need to copy and paste into the Tab labeled LP.

                    The video explains how to copy and paste Sunday only draws.  The Monday through Saturday draws require another video.  You may find a link in one of my older posts from this year.

                    Here is the video download:

                    https://www.box.com/s/a84661e08ac5f196658a

                    Let me know if you have any questions!!

                      Avatar
                      Florida
                      United States
                      Member #66575
                      October 30, 2008
                      3549 Posts
                      Offline
                      Posted: May 21, 2012, 5:46 pm - IP Logged

                      The browser you are using may have something to do with how your data is formatted when you copy and paste into Excel.

                      I had to create a few variations for Microsoft Internet Explorer and Mozilla Firefox.  Micrsoft Internet Explorer will place all the data in 1 column whereas Mozilla Firefox will actually place all the data in the correct cells for my own Excel file(s).

                      The other thing that will affect how your data is copied is if you have previous settings for Data > Text to columns that are causing the data to go into the incorrect cell range(s).

                      Personally Mozilla Firefox cuts down the copy and paste a step or 2.

                      If you would like my Excel file I use to update all the State draws including the Canadian draws your welcome to use it. 

                      Draws are current through Sunday May 20, 2012

                      https://www.box.com/s/6097c8c41d299af340e5

                      This is the video on how to update the draws from Lotterypost into Excel via Microsoft Internet Explorer.  If you are using Mozilla Firefox you will need to copy and paste into the Tab labeled LP.

                      The video explains how to copy and paste Sunday only draws.  The Monday through Saturday draws require another video.  You may find a link in one of my older posts from this year.

                      Here is the video download:

                      https://www.box.com/s/a84661e08ac5f196658a

                      Let me know if you have any questions!!

                      Thank You Steve

                      I didnt think to try using a different browser .

                      Gonna download your sheet and go from there .

                      As always, Thank You

                      Carlig

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5387 Posts
                        Offline
                        Posted: May 21, 2012, 6:32 pm - IP Logged

                        Thank You Steve

                        I didnt think to try using a different browser .

                        Gonna download your sheet and go from there .

                        As always, Thank You

                        Carlig

                        If your using Windows XP you will also get different results


                          United States
                          Member #124493
                          March 14, 2012
                          7023 Posts
                          Offline
                          Posted: May 21, 2012, 7:16 pm - IP Logged

                          Copying from the NY page into notepad came out like ...

                          e.g.
                          05/21/2012 Midday    1-7-6    14
                          05/20/2012 Evening    0-1-4    05
                          05/20/2012 Midday    8-7-5    20

                          Then saved that as a text file.

                          Opened excel and told it to import the text file (.txt)

                          At step three, on the import wizard, highlighted column containing the triplets and set that column format as text.

                          Clicked "Finish".

                          its not posting normal into notepad for me...its posting as follows...

                          05/01/2012 Evening

                          6-0-8

                          14

                           

                          05/01/2012 Midday

                          0-2-8

                          10

                           

                          04/30/2012 Evening

                          8-3-6

                          17

                           

                          04/30/2012 Midday

                          7-6-2

                          15

                            Avatar
                            Florida
                            United States
                            Member #66575
                            October 30, 2008
                            3549 Posts
                            Offline
                            Posted: May 21, 2012, 7:48 pm - IP Logged

                            Steve's sheet will work very well for me .

                            I havent checked the video yet , but he has all the states pick 3's already updated.

                            Well maybe not "All" but most of them.

                             

                            Thanks Steve

                             

                            Carlig

                              Avatar
                              Florida
                              United States
                              Member #66575
                              October 30, 2008
                              3549 Posts
                              Offline
                              Posted: May 21, 2012, 8:03 pm - IP Logged

                              Here is another idea and I just tried it and it worked for me.

                              I cant speak of the official Lottery site but for LP .

                              Instead of just copying the dates and numbers, I included a little of the text at the top in my copy. When I pasted into excel, I just deleted the text at top and everything is as it shoud be

                              Dates are Dates and numbers are lined up as they should be..

                              So I just delet the "junk at the top"

                              maybe something similar would work on New York official site

                              view.

                              Advanced options and tools:

                              Numbers MiddayNumbers EveningWin   4 MiddayWin 4 Evening

                              Drawing Date

                              Pick 3

                              Pick 4

                              Midday

                              Evening

                              Midday

                              Evening

                               

                              Mon, May 21, 2012

                              176

                              435

                              5379

                              1071

                              Sun, May 20, 2012

                              875

                              14

                              9009

                              8055

                              Sat, May 19, 2012

                              213

                              235

                              8925

                              2763

                              Fri, May 18, 2012

                              388

                              837

                              1240

                              5499

                              Thu, May 17, 2012

                              658

                              822

                              7265

                              9161

                              Wed, May 16, 2012

                              249

                              269

                              9536

                              4544

                              Tue, May 15, 2012

                              100

                              673

                              1138

                              805

                              Mon, May 14, 2012

                              970

                              641

                              3085

                              6883

                              Sun, May 13, 2012

                              100

                              804

                              9774

                              2880

                              Sat, May 12, 2012

                              541

                              549

                              5674

                              2906

                              Standard members are limited to   viewing the past 10 drawings for each game.