Excel template
AQL Sampling Calculator LITE
Sample size, Ac / Re and accept or reject decision in Excel
Enter your lot size, inspection level and AQL to get the code letter, sample size, accept number and reject number, and an instant ACCEPT / REJECT decision. Includes the OC curve with producer's risk, AOQ, AOQL and ATI. Single sampling, normal inspection, following ANSI/ASQ Z1.4 = ISO 2859-1.
- Code letter, sample size n, Ac and Re
- ACCEPT / REJECT from the defectives found
- OC curve, AOQ, AOQL, ATI and limiting quality
- Binomial or hypergeometric model
- No macros, Excel 2010+ and LibreOffice
What is inside
- 1
Start Here
Quick instructions in three steps and the comparison of LITE and FULL.
- 2
Calculator
Lot size, inspection level I, II or III and AQL 0.65 to 4.0 give the code letter, n, Ac and Re. Enter the defectives found to get ACCEPT or REJECT.
- 3
Risk snapshot
Probability of acceptance at the AQL, producer's risk, and acceptance probability at 2× and 4× the AQL.
- 4
OC Curve
Operating characteristic and AOQ curves, AOQL, ATI and limiting quality. Use the Calculator plan or enter any n, c and N by hand.
Sample size and decision in seconds
Lot size + inspection level + AQL = code letter, sample size, accept and reject number. Type the number of defective pieces you found and the sheet tells you ACCEPT or REJECT. Yellow cells are inputs, everything else is calculated.
Know the risk behind your plan
The OC curve shows how likely a lot is accepted at every defect level. You see the producer's risk at the AQL, the limiting quality, the average outgoing quality (AOQ and AOQL) and how many pieces you inspect on average (ATI).
LITE vs FULL version
LITE is free here. The FULL version is a paid download in our Etsy shop.
| Feature | LITE (free) | FULL ★ |
|---|---|---|
| Calculator: code letter, n, Ac, Re, decision | Yes | ✓ |
| Inspection levels | I, II, III | S-1 to S-4, I, II, III |
| AQL values | 0.65 to 4.0 (5) | 0.025 to 10 (14) |
| Normal inspection plans | Yes | ✓ |
| Tightened inspection, side-by-side | – | ✓ |
| Full plan tables and Table I | – | ✓ |
| OC curve, AOQ, AOQL, ATI, risks | Yes | ✓ |
| Lot log (200 lots) with automatic normal / tightened switching | – | ✓ |
| Dashboard with 4 charts | – | ✓ |
| Plan designer: c = 0 grid, custom n / c | – | ✓ |
| Variables (k-method) plan and inspection form | – | ✓ |
| German version | – | ✓ |
Details
- Format
- Microsoft Excel .xlsx
- Works in
- Excel 2010+ (Windows, Mac), LibreOffice
- Macros
- None
- Inspection
- Normal, single sampling
- Inspection levels
- I, II, III
- AQL values
- 0.65, 1.0, 1.5, 2.5, 4.0
- Standards
- Follows ANSI/ASQ Z1.4, ISO 2859-1
- Licence
- Free for use in your company
Frequently asked questions
›Is it really free?
Yes. The LITE version is free to download and use in your company, no sign-up and no e-mail needed.
›Which standard does it follow?
The plans follow the ANSI/ASQ Z1.4 = ISO 2859-1 = MIL-STD-105E single-sampling tables. It is not affiliated with or endorsed by ANSI, ASQ, ISO or the US Department of Defense. For contractual use, refer to the official standard.
›What is not included?
Reduced inspection, double and multiple sampling, AQL below 0.025 or above 10, and the tabulated values of ISO 3951-1 / ANSI/ASQ Z1.9 are not included in LITE or FULL.
›What does the full version add?
Tightened inspection, 14 AQL values and 7 inspection levels, the full tables, a lot log with automatic switching, a dashboard, a plan designer and a variables (k-method) plan. See the comparison above.
›Is there an online version?
Yes. The free AQL sampling plan tool on QM Bench gives the same sample size and Ac / Re in your browser, with a PDF report.
Start tracking first pass yield today
Free download, no sign-up. Delete the sample data and enter your own processes.
Download the free ExcelLike it? Support the author: more templates on Etsy →