Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When we buy a large qty of Lotto tickets, is there a way to read all those numbers into a spreadsheet so that they can be checked against the winning numbers thru formulas/macros?

I am looking for an OCR application that can read the scanned PDF/JPG file and dump them into a file. (This might apply not only to Lotto, but also to other scanned documents.) As for checking for winning numbers, I know how to do it once I have them in a CSV/XLS file.

share|improve this question

migrated from stackoverflow.com Mar 18 '10 at 21:00

This question came from our site for professional and enthusiast programmers.

2  
read them from what? paper tickets? website? email? text message? Sky box? –  Steven Robbins Oct 7 '09 at 20:26
1  
Only if you win. –  Freddy Oct 7 '09 at 20:27
1  
I am looking for an OCR application that can read the scanned PDF/JPG file and dump them into a file (This might apply not only to Lotto, but also to other scanned documents). As for checking for winning numbers, I know how to do it once I have them in a CSV/XLS file. Now you may decide if this is a REAL question or not. –  neiling Oct 8 '09 at 20:13
2  
@ neiling - Re-write your question with the text you put in that comment. –  J. Polfer Oct 9 '09 at 16:44
1  
Any plan that starts with "When we buy a large qty of Lotto tickets" is doomed to failure IMO. Have you even looked at the probability of winning? Better off to donate half of what you would have spent to charity and call it a day. –  micmcg Mar 18 '10 at 21:45

4 Answers 4

You can scan them and use an OCR software to get the data from the tickets if they're clearly readable. Typereader 2008 by expervision is a great one that I've personally used before. Wikipedia offers alot of information on the subject.

As for the formulae, you could possible extract the average and median amount of times a number is represented in a given sequence and time frame and continue doing some calculations with that.

share|improve this answer
    
Beat me to the OCR suggestion +1 –  Robert Greiner Oct 7 '09 at 20:31

If you read them in to Excel from some format (OCR, type them in), you can just use the Excel search function to search for the winning number.

share|improve this answer

I have had a spreadsheet for many years now that will automatically tally the winning tickets once the numbers are entered. The tickets must all be entered by hand, though.

If you play the same numbers every time, you only need to enter them once.

share|improve this answer

Unless you have a automated scanner, it would probably be quicker and less effort on your part to type the lotto numbers in by hand.

If you do this a lot and want to justify your effort:

  1. Buy an automated scanner, with some sort of feeder.
  2. Hopefully scanner will dump all the scanned files into a destination folder.
  3. Run a script that will trigger OCR on each file in the folder.
  4. Create a CSV file from the OCR dump
  5. Import CSV into excel.

Several of these steps could be merged.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.