Sheets
3
Lookup, standard data, instructions
Free Download
AQL Sampling Plan Lookup Calculator
Consultation
Want to connect sampling lookup to inspection records?
If you want sampling lookup, inspection records, supplier lots, and report numbers connected, we can tune the fields around your quality workflow.
Check the workbook against the standard version your company has adopted before rollout.
Enter lot size, inspection level, severity, and AQL value to return the sample size, acceptance number, and rejection number.
AQL lookup
Inspection level
Severity
Acceptance number
Rejection number
Inputs
4
Lot size, inspection level, severity
Output
Automatic
Sample size and decision numbers
Input example
AQL lookup flow
The example turns lot size, inspection level, and AQL value into an actionable sampling plan.
Lot size
1200
Inspection level
II
Severity
Normal
Output
Sample size and decision numbers
Free Download
AQL Sampling Plan Lookup Calculator
A free Excel template that returns sample size, acceptance number, and rejection number from lot size, inspection level, severity, and AQL value.
File
quality_management_aql_sampling_plan_calculator_template_en.xlsx
Sheets
3 sheets
Purpose
Sampling lookup, sample size calculation, acceptance decision
Lot sizes change often
Align inspection level
Multi-plant sharing
Check the workbook against the standard version your company has adopted before rollout.
Workflow
How to use the AQL lookup
Keep a clear path from lot size to decision numbers.
Step 1
Enter lot size
Enter the lot quantity and identify the lot range first.
Step 2
Choose conditions
Select inspection level and severity based on inspection risk.
Step 3
Lookup the plan
Select the AQL value and let the workbook locate the standard data table.
Step 4
Use the decision
Apply the sample size and decision numbers to the inspection record.