Job Safety Analysis (JSA) Library for Hotel and Outlet Tasks: Job Safety Analysis Library with Risk Scoring, Training Records and Review Tracker

Full description

For safety officers, executive chefs, chief stewards and department heads who need a working JSA library, not a blank template. The main workbook has 40 tasks and 203 steps across general, kitchen, stewarding, banquets, bar and restaurant, housekeeping and engineering. Each step carries a hazard, a control, a control type and likelihood and severity before and after controls. The register finds each task's highest score, shows whether the controls moved the band, sets the next review date and flags overdue reviews. Training records count competent staff against staff in role, and the sign-off column shows High tasks without a general manager date. The companion workbook is a one-page JSA form that scores your own tasks and keeps a form log, and the guide teaches how to walk a task, score it and train from it.

What is inside

• JSA_Library_Hotel_and_Outlet_Tasks.xlsx: 11 tabs, 4,119 formulas, 2 native charts, 17 drop-down and input rules, 10 integrity checks
• Step Analysis: 203 steps in 40 tasks with hazard, control, control type, likelihood and severity before and after, scores, bands, flags and a top-ten residual list
• JSA Register: 40 tasks in seven departments with PPE, owner, last review, highest score before and after, band, target met, next review and review status
• Training Records, Task Controls: trainee records with competence test, coverage against the target, general manager sign-off for High tasks, lift limit check and open items
• Risk Matrix and Department View: scales, 5 x 5 grids counting steps before and after controls, results by department and control type
• JSA_Form_and_Risk_Scoring_Sheet.xlsx: 5 tabs, 298 formulas; a one-page JSA form that scores 14 steps, a form log with next review and signature status, and 7 checks
• JSA_Library_Guide.docx and PDF: 10 pages covering the method, scoring equations, control hierarchy, review and sign-off, training, a worked example, the dashboard and a printable blank form
• README.txt and LICENSE-and-Terms.txt

How it works

1. Set the band limits, review interval, training target and report date on Assumptions.
2. Walk each real task and edit the steps, hazards, controls and scores on Step Analysis.
3. Update the register with the owner, last review and any change since the review.
4. Record demonstrations and signatures on Training Records and set the staff in role.
5. Review the Dashboard and Department View, then fix overdue reviews, training gaps and missing sign-offs.

Details

• Formats: 2 Excel workbooks (.xlsx), 1 guide in Word (.docx) and PDF, English
• Software: Excel 2016 or later, or LibreOffice Calc 7 or later; any word processor for the guide
• No macros, no external links, no data tables, no array formulas
• 4 files plus README and license; instant digital download

Good to know

• Sample data is illustrative. Replace it with your own tasks and figures.
• Scores, lift limits and intervals are examples. Verify local safety requirements.
• Not a substitute for a risk assessment by a competent person.
• Single-user license. Do not redistribute.

FAQ

Are the 40 tasks ready to use as they are?

They are a starting point. Walk each task with the people who do it, then edit the steps, hazards, controls and scores.

Can I change the risk bands and the review interval?

Yes. The band limits, review months, training target, pass score and lift limit are inputs on Assumptions.

How is the task score calculated?

Each step is scored likelihood times severity. The task takes the highest step score, before and after controls.

What does the companion workbook do?

It is a one-page JSA form that scores up to 14 steps, finds the highest score and band, sets the next review date, and keeps a form log.

Do I need macros?

No. Every result is a standard worksheet formula.