Backyard Cricket Excel Template – Free Scorecard (2026)
0
Free download
Projects & Planning
Download template
Melbourne Cup Sweep Excel - Free Template
Run a Melbourne Cup office sweep with participant payments, horse assignments, prize calculations, race results and dashboard summaries for up to 100 entries.
This Melbourne Cup sweep Excel template helps you organise an Australian office, club or family sweep. It includes setup fields, 100 participant rows, horse assignments, payment tracking, finish results, automatic prize calculations and a summary dashboard.
Set the entry fee and prize percentages on Sweep Setup, then record names and payments on Participants. The workbook is prepared for the 2026 Melbourne Cup on 03/11/2026, with sample entries and horse data that you can replace when your own field is confirmed.
The key benefits of this Excel template
- Calculate the total sweep pool automatically from the entry fee and number of participant names.
- Split the pool into first, second and third prizes using editable percentage fields, with a Balanced or Check percentages result.
- Record up to 100 participant rows, including names, cities, contact details, payment dates and notes.
- Assign horse numbers from a drop-down list and automatically show the matching horse name and barrier.
- Track paid and outstanding entries, with a calculated payment status for every participant.
- Enter finish positions after the race and automatically calculate the result and prize amount.
- Review payment, prize, unassigned-horse and Australian city summaries on the Dashboard.
Step-by-step guide
- Open Sweep Setup and change the sweep name, race date, entry fee, organiser and location. The sample date is 03/11/2026 and the sample fee is $10.00.
- Set the first, second and third prize percentages in B7:B9. The standard sample split is 50%, 30% and 20%; check that Prize check shows Balanced.
- Go to Participants and replace the sample names with your entrants. Add each person's city, email or contact details, and any useful note in the editable fields.
- Select Yes or No in Paid? and enter the payment date when money arrives. Payment Status changes to Paid or Outstanding automatically.
- Update Horses with the official runner names, barriers and status. Use the horse number list in Participants to allocate a runner to each entry.
- After the race, enter each participant's finish position, from 1 to 24 or Did Not Finish. Result and Prize Amount then update from the configured prize values.
- Check Dashboard before drawing or paying prizes. Review the pool, payments, unassigned horses, prize amounts and city counts, then save a final copy of the completed workbook.
What is included
Sweep Setup sheet with sweep name, race date, entry fee, prize percentages, calculated pool and prize values.
Participants sheet with columns for entry number, participant name, city, contact details, payment, horse allocation, finish position, result, prize and notes.
Horses sheet with horse number, horse name, barrier, status, assigned participant and assigned indicator.
Drop-down validation for Yes or No payments, horse numbers 1 to 24 and finish positions 1 to 24 or Did Not Finish.
Automatic VLOOKUP links that bring the horse name and barrier into Participants.
Automatic INDEX, MATCH and COUNTIF checks showing which participant has each horse and whether it is assigned.
Dashboard with three charts covering payment status, prize position and participants by listed Australian city.
Who uses a Melbourne Cup sweep Excel template in Australia
A Melbourne Cup sweep is usually run by the person who already organises the morning tea, roster or social club collection. That might be an office manager at a tradie's business, a volunteer treasurer at a footy club, a workplace administrator or someone arranging a family lunch on the first Tuesday in November.
This workbook suits a small, manually managed sweep where you need a clear record rather than a betting platform. It has 100 prepared participant rows, while the sample data shows entries for people in Sydney, Melbourne, Brisbane and Perth. Those examples are workbook data only, so replace them with your actual entrants.
Before the race
Use Sweep Setup before collecting money. If 24 people each pay $10.00, the formula produces a total pool of $240.00. With the sample 50%, 30% and 20% split, the prizes are $120.00, $72.00 and $48.00. That makes the collection and payout easy to explain to everyone.
On Participants, you can record a name, city, email or contact detail, payment date, assigned horse number and notes. The entry number is calculated from the names entered, so you do not need to renumber the list as people are added.
After the Melbourne Cup
Once the official result is known, enter the finish position in column J. A finish position of 1 becomes Winner, 2 becomes Second and 3 becomes Third; other positions become No Prize. Prize Amount then draws from the three calculated prize cells on Sweep Setup.
The Dashboard is useful when the sweep is being run across several teams or locations. Its city summary includes listed locations such as Sydney, Melbourne, Brisbane, Perth, Adelaide, Gold Coast, Newcastle, Canberra, Hobart and Wollongong, while the charts give you a quick visual check of payments and prizes.
Australian rules for a workplace Melbourne Cup sweep
A private Melbourne Cup sweep can involve more than collecting ten-dollar notes, so set simple written conditions before entries close. State the entry fee, closing time, horse allocation method, prize split, treatment of scratchings and what happens if a participant has not paid. This Excel template records those decisions but does not create or enforce legal gambling conditions.
In Victoria, a workplace sweep connected with a race should be checked against the Victorian racing and gambling framework, including the Gambling Regulation Act 2003 and guidance from the Victorian Gambling and Casino Control Commission. A sweep is not automatically acceptable merely because the prize pool is small or the event is held at work. Do not treat this spreadsheet as approval to operate a public or commercial lottery.
Keep the money and rules transparent
For a $10.00 entry, show that the whole collection is $240.00 when there are 24 paid entries, then show the exact $120.00, $72.00 and $48.00 payouts. Sweep Setup's Prize check confirms that the percentages total 100%; if you enter 50%, 30% and 25%, it displays Check percentages instead of silently accepting an over-allocation.
Do not describe the collection as GST income or issue a tax invoice unless the organiser is actually supplying something in the course of an enterprise. GST is generally 10%, but a private social sweep is not automatically a taxable business sale. If a business is collecting entries as part of its enterprise, keep the money separate and have the tax treatment confirmed in the business records.
Privacy and records
Participants contains contact information, so limit access to the organiser and delete details that are no longer needed. Under the Privacy Act 1988, organisations covered by the Australian Privacy Principles must handle personal information appropriately; an email address should not be left on a shared screen or circulated with the final results unnecessarily.
Keep a dated final copy showing entries, payments, rules and payouts. The ATO record-keeping rule of 5 years applies to business tax records, not automatically to every private sweep, but retaining the working file until all disputes are settled is a sensible practical position.
Where Melbourne Cup sweep records fall apart
The first problem I see with office sweeps is an entry list that is different from the money collected. Someone writes names on a whiteboard, another person receives bank transfers, and the organiser later cannot tell whether 19 or 20 people paid. At $10.00 each, one missing entry creates a $10.00 discrepancy before any horse is drawn.
Unpaid entries and duplicate allocations
Participants separates Paid? from Payment Date and calculates Payment Status. If a person is marked No but still receives a horse, decide your rule before the draw: either hold the allocation until payment arrives or record that the organiser has accepted the risk. Do not quietly count an outstanding entry in the payout pool.
Horse numbers are selected from 1 to 24, and the Horses sheet shows Assigned Participant and Assigned?. A common failure is allocating horse 7 twice while horse 18 remains unused. The formula can show the participant attached to a horse, but it does not prevent every duplicate scenario, so sort and check the assignment columns before the race.
Wrong field and wrong results
The sample Horses sheet contains placeholder names such as Horse 1 – Confirmed Runner and barriers. Those are not a substitute for the official 2026 field. If you leave placeholders in place, the sweep may announce a result against the wrong horse name even though the horse number is correct.
Finish Position accepts numeric places 1 to 24 or Did Not Finish. Entering 7 for a horse that actually finished first changes the result to No Prize and leaves the winner unpaid. For a $240.00 pool, that can mean a $120.00 payout goes to the wrong person, followed by an awkward correction in front of the whole office.
Prize percentage errors
Changing the entry fee without checking the participant count is another easy trap. Ten entries at $20.00 create $200.00, not the $240.00 shown in the sample scenario. Check Total pool, Prize check and the Dashboard's Prize pool distributed together; if they do not tell the same story, stop before paying anyone.
Turning the sweep spreadsheet into a Melbourne Cup routine
The easiest way to keep this workbook alive is to attach it to an existing event. Set a reminder for the Friday before the race, collect payments during the usual Monday morning meeting and lock the participant list before the draw. A 10-minute check is much easier than reconstructing 40 entries from messages on race morning.
Use a short organiser checklist
- Check that every name in Participants is a real entrant and that blank rows remain blank.
- Filter Payment Status for Outstanding and follow up before horses are allocated.
- Compare the assigned horse numbers with the Horses sheet and investigate any horse marked No.
- Replace placeholder horse names, barriers and statuses when the official field is confirmed.
- Save a copy before entering finish positions, then save the results version separately.
Use the workbook's existing validation rather than typing variations such as Y, Paid or maybe. Selecting Yes or No keeps the COUNTIF formulas accurate. Likewise, use the horse-number and finish-position drop-downs so VLOOKUP, INDEX and MATCH continue to find the intended records.
Know when the file is no longer enough
This template is a good fit for a one-off sweep with up to 100 prepared participant rows. It is not a live payment system, random draw engine, bookmaker account or multi-user database. If 300 people are entering, several organisers need simultaneous access, or you are running regular paid events, use a controlled registration and payment system instead.
For a business that wants proper transaction records, Xero or MYOB can handle bank reconciliation and reporting, while this workbook can remain a simple event register. Keep the sweep funds and business sales separate, and do not rely on the Dashboard as formal accounting evidence.
Frequently asked questions about this template
Download
File format
Excel (.xlsx)
Compatible software
Excel, Google Sheets, LibreOffice
Price
Free