-
Excel workbook preview
Food Safety (HACCP, FSMA, ISO 22000)
CCP Decision Tree Worksheet
3 downloads per free account, no card needed.
Who this is for
A HACCP team member who has finished the hazard analysis and must show, hazard by hazard, why each step is or is not a critical control point.
What is inside
- Four-question decision tree logic in one formula: Outcome updates from the Yes / No answers
- 10 worked rows: 3 CCPs, PRP-controlled hazards, a later-step CCP and a modify-the-process case
- Amber warning when a CCP has no CCP number yet
- Decision Tree sheet with each question and its Yes and No routes in plain words
- Counts of CCPs found and steps needing modification
- Built on the example decision tree in Codex CXC 1-1969 (revised 2022)
How to use it: Copy each significant hazard from your hazard analysis into a row and answer only the questions the previous answer sends you to; number every CCP.
Files & formats
- XLSXccp-decision-tree-worksheet-template.xlsx11 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public regulation or guidance named here. They are not legal advice and are not endorsed by the regulator or publisher.



