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

Getting past data in a spreadsheet

Topic closed. 8 replies. Last post 10 years ago by guesser.

Page 1 of 1
PrintE-mailLink
Avatar
Hampton,VA
United States
Member #32721
February 15, 2006
88 Posts
Offline
Posted: November 21, 2006, 2:31 pm - IP Logged

I'm sure this has been done already but how can I get past results into Excel without having to input them all by hand? By the way I'm refering to VA results.

 

Thank you 

    Todd's avatar - Cylon 2.gif
    Chief Bottle Washer
    New Jersey
    United States
    Member #1
    May 31, 2000
    23352 Posts
    Online
    Posted: November 21, 2006, 6:15 pm - IP Logged

    Lottery Post Gold and Platinum members get full access to the Lottery Post results database, which includes all games in the USA, Canada, and UK.  There is no direct to Excel function, but it is very easy to copy and paste on page at a time.  Years of data could easily be completed within an hour or less.

     

    Check the State Lottery Report Card
    What grade did your lottery earn?

     

    Sign the Petition for True Lottery Drawings
    Help eliminate computerized drawings!

      Raven62's avatar - binary
      New Jersey
      United States
      Member #17843
      June 28, 2005
      51255 Posts
      Offline
      Posted: November 22, 2006, 7:58 am - IP Logged

      Download the previous results and import them into Excel.

      A mind once stretched by a new idea never returns to its original dimensions!

        Avatar
        Hampton,VA
        United States
        Member #32721
        February 15, 2006
        88 Posts
        Offline
        Posted: November 22, 2006, 4:18 pm - IP Logged

        Thanks guys for the suggestionsSmile

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5397 Posts
          Online
          Posted: November 22, 2006, 6:01 pm - IP Logged

          payne,

          How many past VA Drawings are you trying to add??

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5397 Posts
            Online
            Posted: November 22, 2006, 6:18 pm - IP Logged

            Payne,

            Virgina Pick 3 drawings 

            Virginia Pick 3 Excel file

            3 Tabs

            Tab 1: Combined (Midday & Evening)

            Tab 2: Midday Drawings

            Tab 3: Evening Drawings



            Download links:


            Virginia Pick 3 Files - Unzipped

            http://www.orbitfiles.com/download/id1054274344

            or

            Virginia Pick 3 Files - zipped

            http://www.orbitfiles.com/download/id1054281377

            Hope this helps!! 

              Avatar
              Hampton,VA
              United States
              Member #32721
              February 15, 2006
              88 Posts
              Offline
              Posted: November 22, 2006, 11:17 pm - IP Logged

              Payne,

              Virgina Pick 3 drawings 

              Virginia Pick 3 Excel file

              3 Tabs

              Tab 1: Combined (Midday & Evening)

              Tab 2: Midday Drawings

              Tab 3: Evening Drawings



              Download links:


              Virginia Pick 3 Files - Unzipped

              http://www.orbitfiles.com/download/id1054274344

              or

              Virginia Pick 3 Files - zipped

              http://www.orbitfiles.com/download/id1054281377

              Hope this helps!! 

              Thank you Winsome I'll work on it this weekend.

                LottoHackJack's avatar - leaf
                Leamington, Ontario
                Canada
                Member #2995
                December 11, 2003
                59 Posts
                Offline
                Posted: November 23, 2006, 5:06 am - IP Logged

                  ...payne...The fastest way to do what you want is to send me an email at ricci@mnsi.net

                  Let me know which game you want .xls files for. I have all of them...well...most of them...in DBIV format, which I can easily convert to .xls or text format to get you hacking at your game.

                 

                LottoHackJack

                  guesser's avatar - Lottery-017.jpg

                  United States
                  Member #41383
                  June 16, 2006
                  1969 Posts
                  Offline
                  Posted: November 23, 2006, 3:22 pm - IP Logged

                  Depending on the format of the file you want to download, you can copy/paste it into a .TXT document (NOT a word .Doc), save it, then go to Excel and import that .txt document, but choose the delimiter to be a blank, space, comma, or whatever the format it is. 

                   

                  The intermediary .Txt document is what will build the delimiter for you, it's hard to cut/paste into an Excel file and have things go into individual columns unless you have a known delimiter.