-
Excel workbook preview
Testing, Specifications and Shelf Life
Sampling Plan Calculator (two-class and three-class attributes plans)
3 downloads per free account, no card needed.
Who this is for
A food safety team leader asked by the boss or an auditor what five samples of 25 g can really prove, before trusting end-product testing as a control.
What is inside
- Two-class sheet: Pa for 12 lot qualities with BINOMDIST, plus the 95% and 10% acceptance points
- Operating characteristic curve drawn from a 61-point grid that updates with n and c
- Three-class sheet: share above m and M from the lot's log mean and SD, Pa for c from 0 to 3
- 9 worked lot scenarios on the EU 2073/2005 2.5.1 plan (n 5, c 2, m 100, M 1 000)
- Detection sheet: chance of finding a lot with 0.1% to 50% contaminated units, and n for 90, 95 and 99%
- Colour rules: Pa below 10% red, 95% or more green; formulas written out on the How to use sheet
How to use it: Enter n and c (and m and M for three-class plans) in the yellow cells and read how often lots of each quality pass.
Files & formats
- XLSXsampling-plan-calculator.xlsx19 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 law or guidance named here. They are not legal advice and are not endorsed by the regulator or publisher.



