Check your past Lotto and LottoPlus tickets against all the past draws

I have recently started purchasing Lotto tickets but didn't keep up with the draw results each week. Then later, I decided to check if I had won anything. To my amazement, the Lotto web site didn't allow me to enter my set of numbers and auto-check if I was a winner on any of the previous draws! [updated on 21Nov2008]

So, I decided to write my own "calculators".
Download it from here:
Lotto Calculator: Zipped 300KB: LottoSouthAfricaCalculator.zip {updated on 19May2009}
LottoPLUS Calculator: Zipped 400KB: LottoPLUSSouthAfricaCalculator.zip {updated on 19May2009}

It allows you to check your numbers in 2 ways:

1) If you are a person that purchases a constant (favorite) set of numbers each week, then use the "Lookup1_TicketAgainstALLresults" worksheet.
Note: this worksheet searches through all draws

2) If you are a person that purchases lots of different numbers in a week, then use the "Lookup_20_TicketsAgainstONEdraw" worksheet. Note: this worksheet searches through one draw's results

It now shows the actual prize money paid out per win.


Note: the "Lookup1_TicketAgainstALLresults" worksheet uses the list of results in the "lotto_export_to_excel" worksheet. To update this list, download the spreadsheet from http://www.nationallottery.co.za/downloads/downloads.asp and then cut and paste the list over the existing numbers.

Good luck! I think it's a sign of the times that we're turning to the Lotto in an attempt to beat the rising inflation and cost of living......

Update on 30Apr 2012: I found a site that does an online search (on a per draw basis) and checks your numbers and winnings: http://www.lottoshop.co.za

Free Excel templates and spreadsheets including calendar, loan, mortgage, budget, invoice, timeline, timesheet, gantt, and schedule templates

Download free Excel templates and spreadsheets from Vertex42 including calendar, loan, mortgage, budget, invoice, timeline, timesheet, gantt, and schedule templates. What's the catch?: Free to download, but there's a fee to get the unlock code to see the formulas and edit the templates.

List of Excel Templates
* The templates marked with the " * " work in Open Office.

Calendars & Schedules
* Excel Calendar Template
* Yearly Calendar
* Monthly Calendar
* Weekly Calendar Template
* Work Schedule *
* Weekly Schedule *
* Shift Schedule *
* Daily Planner
* Weekly Planner
* Monthly Planner Template
* New Year's Resolution Calendar

Budgets
* Personal Budget *
* Personal Monthly Budget *
* Family Budget Planner *
* Household Budget Worksheet (monthly) *
* Home Budget Worksheet (yearly)
* Wedding Budget Template *
* Checkbook *
* Expense Tracker

Invoice & Inventory
* Service Invoice Template *
* Sales Invoice Template *
* Purchase Order *
* Billing Statement *
* Asset Tracking
* Home Inventory *

Timesheets & HR
* Employee Time Sheet *
* Timesheet with Breaks *
* Timecard *
* Expense Report *
* Vacation Tracking

Education
* Class Schedule *
* Class Attendance Tracking *
* School Calendar
* Academic Calendar

Project Management
* Gantt Chart
* To Do List*
* Timeline Template
* Timeline Examples

Loan Calculators
* Amortization Schedule
* Car Loan Calculator
* Simple Loan Calculator *
* Amortization Table
* Simple Interest Calculator
* Interest Only Loan
* Balloon Loan Mortgage Calculator
* Boat Loan Calculator

Mortgage Calculators
* Home Mortgage Calculator
* Mortgage Payment Calculator *
* ARM Loan Calculator
* Home Equity Loan Calculator
* Extra Payments
* Canadian Mortgage Calculator
* Simple Interest Mortgage
* More Mortgage Spreadsheets

Retirement & Savings
* Simple Savings Interest Calculator
* Retirement Savings Calculator

Personal Finance
* Debt Reduction Snowball Calculator
* Credit Card Payoff Calculator
* Home Expense Calculator
* Stock Quotes

Financial Statements
* Balance Sheet *
* Income Statement *
* Cash Flow Statement *
* Break Even Point
* Net Worth Statement *

Exercise / Health
* Weight Loss Log
* Food Log
* Weight Chart
* Exercise Chart
* Exercise Log
* Weight Lifting Chart
* Weight Lifting Log
* Body Mass Index Chart
* Grocery Shopping List
* Menu Planner *

Other Templates
* Gas Mileage Log & Calculator
* Blank Sudoku Grid
* Wedding Checklist Template *
* Sign In Sheet *

Directory of Other Free Excel Templates:

Free Excel Templates - Main Category Accounting and Reporting :: Income statements, balance sheets, expense reports ... Business Finance :: Real option valuation, risk analysis, financial modeling ... Business Plans :: Startup expenses, finance statements, break-even analysis ... Calendars and Planners :: Yearly and weekly calendars, planners ... Education :: Gradebooks, weekly schedules, attendance logs ... Gradebook and Grade Tracking Music and Graph Paper Engineering Templates :: Modeling, units, design ... General Excel Templates :: Templates for demonstrating Excel techniques ... Home and Health :: Home inventory, workout logs, meal planning ... Medicine and Biology :: Diagnostics ... Orders and Inventory :: Invoices, packing slips, price lists ... Payroll and Scheduling :: Timesheets, payroll, shift schedules ... Personal Finance :: Loans, budgets, checkbooks, investments ... Project Management and Planning :: Budgets, cash flow, timelines, projects ... Real Estate :: Amortization, mortgages, renting, closing costs ... Sports :: Scorecards, rosters, tournament brackets ... Statistics :: Data analysis, statistics examples ... Travel :: Mileage logs, expense reports, itineraries ...

Thanks Vertex42