Hotel Pool Operations Log & Safety Checklist: Pool Water Test Log and Safety Checklist Pack

Full description

For hotel and resort pool supervisors, front office or engineering managers who run a pool without a dedicated aquatics team. The workbook records every water test and checks it against the limits you set for each pool, tracks chemical deliveries and doses with a running stock balance, plans the lifeguard and attendant roster with a certificate check, schedules cleaning and logs incidents. The Word and PDF pack gives your team the daily opening and closing checklists, the safety rules sign text, 8 emergency procedures and a weekly inspection form.

Save with a bundle: this template is also in the Hotel Rooms, Guest Experience & Spa Bundle, 16 templates for $39 instead of $112. All 141 templates are in the All-Access Hospitality Template Library for $79.

What is inside

• Pool_Operations_Log.xlsx: 7 tabs, 2,609 formulas, 2 native charts, 31 drop-down or number rules.
• Settings: 7 general inputs including close-pool triggers, editable limits for 3 example pools (chlorine, combined chlorine, pH, alkalinity, temperature), 3 shift times, a staff register with certificate expiry (14 rows), 7 chemicals with reorder levels (10 rows), 4 cleaning frequencies and 10 drop-down lists.
• Water_Tests: room for 1,500 tests (124 sample rows). Each reading turns red when it is outside the limits for that pool, and a Result column shows OK, Adjust or Close pool.
• Chemical_Use: room for 400 movements (48 sample rows) with handler, protective equipment check and stock after each row.
• Duty_Plan: 7-day roster for 3 shifts with a certificate check on every shift, and a cleaning schedule with 24 example tasks, next-due dates and overdue flags.
• Incidents: room for 200 events (9 sample rows) with type, severity, first aid, closure minutes, follow-up and status.
• Dashboard: pick a period. 12 KPI tiles, a chemical stock table, a daily free chlorine chart and a chemical use chart.
• Pool_Opening_Closing_Safety_Procedures.docx and .pdf, 10 A4 pages: opening checklist (23 checks), closing checklist (18 checks), 7-step water testing routine, safety rules sign text (16 rules), 8 emergency procedures (41 steps) with a contacts table, weekly inspection form (40 checks in 6 areas) with an action table, drill and training record.
• README.txt and LICENSE-and-Terms.txt.

How it works

1. Enter your pools, limits and close-pool triggers on Settings, then your staff codes, certificate dates and chemicals.
2. Log every water test and chemical movement as it happens. Act on any red reading.
3. Plan the week on Duty_Plan and update the cleaning dates as tasks are done.
4. Print the opening and closing checklists every day and the inspection form every week.
5. Log incidents the same day and review the Dashboard weekly.

Details

• Formats: Excel workbook (.xlsx, no macros), Word (.docx) and PDF.
• Language: English. A4 print layout.
• Software: Excel 2016 or later, or a spreadsheet program that opens .xlsx files; Word or any word processor that opens .docx files; any PDF reader.
• Delivery: instant digital download. Nothing is shipped.

Good to know

• Sample tests, chemicals, staff codes and incidents are illustrative. Replace them with your own records.
• Water quality limits, closure times, lifeguard rules and signage differ by country and region. The values shown are examples. Verify local requirements with your health authority and insurer.
• This pack supports your records and routines. It is not legal, medical or safety certification advice.
• Single-user license. Do not share or resell the files.

FAQ

Can I change the water limits for each pool?

Yes. Edit the limits table on Settings. The red flags and the Result column follow your values.

Does it work for an indoor pool or a spa pool?

Yes. Each pool has its own limits and type. The sample includes an outdoor main pool, a kids pool and an indoor spa pool.

Does it work in Google Sheets?

It opens in Google Sheets and the formulas calculate. Check the drop-downs and colour flags after import.

Can I edit the checklists and sign text?

Yes. The Word file is fully editable. Replace the [bracketed] fields with your hours, numbers and limits.

Is this a physical product?

No. It is a digital download. Refund terms follow the store policy at the time of purchase.