-
Excel workbook preview
Testing, Specifications and Shelf Life
Water and Ice Microbiological Testing Log
3 downloads per free account, no card needed.
Who this is for
A QA manager whose auditor asked for proof that water and ice touching food are tested and safe, or whose ice machine just failed.
What is inside
- 10 worked results across 7 sample points, including an ice machine coliform fail and a UV failure
- Status formula: FAIL for any E. coli, enterococci or coliforms, Investigate for abnormal counts
- Colony count judged against each point's own baseline, as the Directive sets no number
- Sample Points sheet with location, use, frequency and baseline, looked up by point ID
- Limits sheet with the EU 2020/2184 values and 21 CFR 117.37 for US plants
- Corrective action turns red until it is written for every FAIL
How to use it: List your sample points and baselines, then log each laboratory result by point ID; status and flags work themselves out.
Files & formats
- XLSXwater-and-ice-microbiological-testing-log.xlsx15 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 $7.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 law or guidance named here. They are not legal advice and are not endorsed by the regulator or publisher.



