I have an interesting Excel based lottery template from my friend, Chua. I am sharing it with you all not because I support gambling, but because the template demonstrated that the use of Excel is not limited to business. It can be used in our daily lives too, in this case, matching of TOTO / lottery numbers.
Here is the reason why she created the template:
Using Excel’s conditional formatting function, Chua made the number on the lottery ticket (shown from row 8 onwards) highlighted in red automatically if it is one of the winning numbers. If the number is the additional number drawn, the cell will turn purple. To win money in the lottery, at least 4 numbers from the ticket must match one of the 7 winning numbers (including the additional number). If the numbers on the ticket match 3 of the winning numbers plus the additional number, the ticket would have won $20. So the purple colour will identify which prize group(s) the holder of the ticket is entitled to. See the picture below for more details
It is possible for the ticket to win more than one prize group. That’s what the next part of the template is set up to do. Using the above table as a guide, Chua has set up the template to show all the winning prize groups to help her calculate her winnings.
The template also matches the TOTO draw number and the date to make sure that the tickets are matching to the right set of winning numbers.
Chua has agreed to share the lottery / TOTO template with you. You can try to make use of the template to identify your winnings and/or enhance it further to make it more complete. You can request for a copy of the template by filling in the form below and we will have the worksheet send to you right away after you confirm your email address.
Keep up with our work!
PS: We need you to click on the link in our confirmation email to confirm your name and email address s we can verify you are a real person. Please look out for it.
Share this page:
Would you prefer to share this page with others by linking to it?
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft