• Preview of Sampling Plan Calculator (two-class and three-class attributes plans)Excel workbook preview

Testing, Specifications and Shelf Life

Sampling Plan Calculator (two-class and three-class attributes plans)

$17.99 Free XLSX
Excel workbook · 19 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.