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.
If you need team collaboration, mobile data entry, photo uploads, corrective action reminders, or dashboards, view the systemized version.
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
AQL Sampling Plan Lookup Calculator.xlsx
File name: 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.
Structure Mapping
How a paper sampling table becomes an automatic lookup
Split the paper sampling table into inputs, standard data, and outputs.
Excel element
System element
Notes
Excel element
Lookup sheet
System element
Sampling lookup form
Notes
Enter lot size, inspection level, severity, and AQL value in one place.
Excel element
Standard data
System element
Sampling rule master
Notes
Keep code letters, sample sizes, and decision numbers in the workbook.
Excel element
Output result
System element
Inspection task suggestion
Notes
Return sample size, acceptance number, and rejection number automatically.
Excel element
Instructions
System element
Rule explanation page
Notes
Explain when to choose each inspection level and severity setting.