School Canteen Roster Excel – Free Template (2026)
7
Free download
Payroll & HR
Download template
Surf club roster Excel - Free Template
Surf club roster Excel workbook with patrol shifts, member qualifications, attendance, hours and dashboard summaries for Australian clubs.
This surf club roster Excel spreadsheet records patrol dates, beaches, shifts, member assignments, roles, qualifications, attendance, hours and notes. It includes Roster, Members, Dashboard and Instructions sheets for coordinating Australian lifesaving patrols.
Enter members and patrol details once, then let the workbook calculate member names, qualifications, shift hours and patrol status. The Dashboard summarises shifts, hours, attendance, unconfirmed patrols and beach coverage, so your roster coordinator can see what needs attention.
The key benefits of this Excel template
- Plan up to 100 prepared patrol roster rows with dates, beaches, shifts and assigned Member IDs.
- Calculate patrol hours automatically from start and end times, such as 06:00 to 10:00 producing 4.00 hours.
- Pull member names and primary qualifications into the Roster sheet using VLOOKUP.
- Track Present, Absent, Late, Excused and Unconfirmed attendance with controlled lists.
- Flag unconfirmed attendance as Action Required through the calculated Patrol Status column.
- Compare completed patrols with each member's annual patrol target using calculated completion percentages.
- Review total shifts, patrol hours, attendance rate and location coverage on the Dashboard.
Step-by-step guide
- Add each lifesaver to the Members sheet, image 2, with a unique Member ID, contact details, qualification, emergency contact, active status and annual patrol target.
- Enter a roster ID, patrol date, location or beach, shift, start time and end time on the Roster sheet, image 1.
- Select a Member ID from the linked list and choose the role from the available role list. Member Name and Qualification fill from the Members sheet.
- Select attendance as Present, Absent, Late, Excused or Unconfirmed, then add notes about replacements, equipment checks or follow-up.
- Check the calculated Hours and Patrol Status columns after each patrol. An Unconfirmed entry becomes Action Required.
- Open the Dashboard, image 3, to review rostered shifts, total hours, average shift length, attendance rate, unconfirmed shifts and location summaries.
- Read the Instructions sheet, image 4, before handing the workbook to another roster coordinator, and save a backup after updating the member directory.
What is included
Roster sheet with Roster ID, Patrol Date, Day, Location / Beach, Shift, Start Time, End Time, Member ID, Member Name, Role, Qualification, Attendance, Hours, Patrol Status and Notes columns.
Members sheet with contact details, emergency contact information, active member status and annual patrol targets.
Drop-down lists for Member ID, six patrol roles and five attendance statuses.
Automatic VLOOKUP formulas for Member Name and Qualification across prepared roster rows.
Automatic hours calculation using the difference between End Time and Start Time multiplied by 24.
Dashboard formulas using SUM, AVERAGE and COUNTIF for patrol and attendance measures.
Three Dashboard charts covering location shifts, attendance status and patrol hours by date.
Who uses a surf club roster Excel spreadsheet in Australia
A volunteer roster coordinator at a surf lifesaving club will usually open this spreadsheet before the weekend patrol, during the summer holiday period and after each sign-on. It suits a Patrol Captain checking coverage, a club administrator updating member details and a committee volunteer preparing a record for the next club meeting.
Planning a weekend patrol
On the Roster sheet, image 1 shows 15 columns from Roster ID through Notes. A coordinator can enter RST-26001, 07/03/2026, Bondi Beach, Morning Patrol, 06:00 and 10:00, then assign SLS-26001. The workbook calculates 4.00 hours and brings across the member's name and qualification.
The same approach works for a Saturday patrol at Newcastle Beach or a dawn patrol at Surfers Paradise. If a club has four patrol teams and each team covers 4.5 hours, the planned roster represents 18 rostered hours before attendance is reviewed.
Keeping members and qualifications together
Image 2 shows the Members sheet with Member ID, Member Name, Mobile, Email, Primary Qualification, Emergency Contact, Emergency Contact Phone, Active Member?, Annual Patrol Target, Completed Patrols and Completion %. Entering a new lifesaver here gives the roster a single source for their contact and qualification information.
For example, a member with an annual patrol target of 12 and 9 roster appearances shows a 75.00% completion result. The COUNTIF formulas count that Member ID in the prepared Roster range, rather than requiring the coordinator to count shifts manually.
Checking coverage after the shift
Image 3 shows the Dashboard with total rostered shifts, total rostered hours, average shift length, Present attendance rate, Unconfirmed shifts and Coverage status. A committee treasurer or secretary can use those figures when reviewing volunteer participation, while the Patrol Captain deals with operational gaps.
Australian club rules and patrol records to check
This workbook is an administration aid, not a substitute for your club's patrol operations manual. The Instructions sheet, image 4, specifically tells clubs to verify current Surf Life Saving Australia, relevant state association, Fair Work and local beach safety requirements.
Qualifications are an operational control
The role list includes Patrol Captain, IRB Crew, First Aid Officer, Surf Rescue Technician, Bronze Medallion Lifesaver and Radio Operator. The qualification list includes Bronze Medallion, Silver Medallion, First Aid, CPR, IRB Crew, Radio Operator and Surf Rescue Technician.
Before a 06:30 patrol opens, confirm that the person assigned to first aid or IRB duties holds the current award required by your club and state association. A spreadsheet can display the recorded qualification, but it does not verify currency, practical competence or whether a member is authorised for a particular duty.
Attendance and safety records
Use the attendance list consistently: Present, Absent, Late, Excused or Unconfirmed. If 20 roster rows exist and 2 remain Unconfirmed, the Dashboard shows 10% of entries needing follow-up and the Coverage status changes to Follow Up Required.
Notes should identify practical matters such as an equipment check, a replacement, a safety briefing or a sign-on issue. A note reading IRB check completed before patrol is more useful than a vague entry such as done, particularly when the club reviews an incident weeks later.
Privacy and retention
The Members sheet stores mobile numbers, email addresses and emergency contact details. Keep access limited to people who need the information, follow your club's privacy procedures and handle the data consistently with the Privacy Act 1988 and Australian Privacy Principles.
Do not treat the workbook as proof that a patrol met every legal or association requirement. The practical position is to use it for coordination, then keep incident, training and official patrol records in the system your club or state body requires.
Where surf club rosters fall apart and what it costs
The expensive roster problems I see are rarely caused by Excel's arithmetic. They come from stale member records, inconsistent attendance updates and assigning a person by name when two volunteers have similar names.
Stale IDs and qualifications
If a former lifesaver leaves and their Member ID is reused for someone else, the Roster sheet can display the wrong name, emergency contact and qualification. That can waste 20 minutes of phone calls before a patrol and create a serious record problem if an incident occurs.
The Instructions sheet recommends deactivating former members rather than reusing an existing Member ID. Keep IDs unique, update the Active Member? field and check the primary qualification before assigning a role.
Unconfirmed attendance left open
An Unconfirmed entry is not the same as Present. The calculated Patrol Status returns Action Required, but only the coordinator can contact the member or Patrol Captain and update the attendance. Leaving 3 unconfirmed rows in a 30-shift month means 10% of the roster still needs a human check.
Late attendance also needs a note. In the sample data, a member arriving 15 minutes after sign-on is marked Late with that reason recorded. Without the note, the club loses the context needed to review coverage and handover timing.
Bad times and incomplete rows
Hours are calculated as (End Time - Start Time) * 24. A 07:00 to 11:30 shift therefore returns 4.50 hours. If either time is missing, the Hours formula stays blank; if a time is entered incorrectly, the total can misstate volunteer coverage.
Do not overwrite calculated Member Name, Qualification, Hours or Patrol Status cells with typed text. Enter the source fields, check the results and use Notes for exceptions. That keeps the 100 prepared roster rows consistent and prevents a manual correction from silently breaking the record.
How to make the roster part of your patrol routine
A roster works when it is attached to an existing club habit, not when someone remembers to update it at the end of the season. Set aside 15 minutes before the weekly roster meeting to confirm the next patrol date, beach, shift times and Member IDs.
Use a simple weekly rhythm
- Before publishing the roster, check every assigned role and qualification against the current member information.
- At sign-on, update Attendance immediately rather than relying on memory after the patrol.
- After pack-up, enter notes for late arrivals, replacements, equipment checks and follow-up matters.
- Open the Dashboard and clear every Unconfirmed entry before the next roster meeting.
For a club scheduling 8 patrol shifts a month, a five-minute attendance update after each shift takes about 40 minutes monthly. That is quicker than reconstructing a month of sign-on sheets when the committee asks why the attendance rate is 87.50%.
Protect the workbook from messy edits
Keep the Roster sheet's filters and frozen headings in place so the 15-column layout remains usable. Add members on the Members sheet first, use the Member ID list on Roster and avoid typing names directly into the calculated Member Name column.
Save a dated copy after each monthly review, such as Surf Club Roster - March 2026.xlsx. Restrict access because the Members sheet contains emergency contact details, and remove old copies according to the club's privacy and record-management process.
Know when to move on
This workbook is a good fit for a modest club with one prepared range of 100 roster rows and 100 member rows. If you are coordinating several hundred members, multiple concurrent beaches, automated SMS reminders or formal compliance reporting, move to club-management software or a system such as Xero or MYOB only where it actually supports the required operational workflow.
Frequently asked questions about this template
Download
File format
Excel (.xlsx)
Compatible software
Excel, Google Sheets, LibreOffice
Price
Free
Category
Payroll & HR
12 templates available