Getting past data in a spreadsheet

Reply #8

guesser — Thu, 23 Nov 2006 20:22:21 GMT

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.

Reply #7

LottoHackJack — Thu, 23 Nov 2006 10:06:10 GMT

...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

Reply #6

payne — Thu, 23 Nov 2006 04:17:10 GMT

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

Reply #5

winsumloosesum — Wed, 22 Nov 2006 23:18:30 GMT

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

Reply #4

winsumloosesum — Wed, 22 Nov 2006 23:01:40 GMT

payne,

How many past VA Drawings are you trying to add

Reply #3

payne — Wed, 22 Nov 2006 21:18:04 GMT

Thanks guys for the suggestions

Reply #2

Raven62 — Wed, 22 Nov 2006 12:58:49 GMT

Download the previous results and import them into Excel.

Reply #1

Todd — Tue, 21 Nov 2006 23:15:35 GMT

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.

Getting past data in a spreadsheet

payne — Tue, 21 Nov 2006 19:31:35 GMT

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