Sheets
7
Instructions, defect log, presets, tables, lookup records, and parameters
Free Download
AQL Sampling Plan Lookup Workbook for Quality Inspections
Consultation
Want to connect sampling lookup to inspection records?
If you want sampling lookups, inspection records, supplier lots, and report numbers connected, we can tailor the fields to your quality workflow.
If you need collaboration, mobile entry, photos, corrective-action reminders, or dashboards, we can discuss the requirements for a custom system.
Enter lot size, inspection level, strictness, and AQL, then manually select sample size and decision numbers from approved tables.
AQL lookup
Inspection level
Severity
Acceptance number
Rejection number
Inputs
4
Lot size, inspection level, strictness, and AQL
Output
Manual lookup
Sample size and decision numbers
Input example
AQL lookup flow
The example records lot size, inspection level, and AQL; verify and choose the sampling plan separately using approved tables.
Lot size
1200
Inspection level
II
Severity
Normal
Output
Sample size and decision numbers
Free Download
AQL Sampling Plan Lookup Calculator
Record lot size, inspection level, strictness, and AQL in one workbook. Manually find sample size and acceptance/rejection numbers in approved standard data, then record the result.
File
AQL Sampling Plan Lookup Calculator.xlsx
File name: quality_management_aql_sampling_plan_calculator_template_en.xlsx
Sheets
7 sheets
Purpose
Sampling conditions, manual plan lookup, defect logging, and decision records
Use it when lot sizes change often.
Keep inspection levels aligned across plants.
Share one lookup flow across multiple plants.
Before use, replace and verify the illustrative tables and decisions against your company's approved standard data. The workbook contains neither complete standard tables nor automatic lookup or decision formulas.
Workflow
How to use the AQL lookup
Keep a clear, reviewable path from lot size to the final decision numbers.
Step 1
Enter lot size
Enter the lot quantity and identify its range first.
Step 2
Choose conditions
Choose inspection level and strictness according to your company's adopted standard and internal rules.
Step 3
Lookup the plan
Select AQL and manually find the matching plan in approved standard tables; the workbook does not perform an automatic lookup.
Step 4
Use the decision
Record the verified sample size and acceptance/rejection numbers in the inspection record.
Structure Mapping
From a paper sampling table to a system lookup
Split the paper sampling table into clear inputs, standard data, and decision 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 approved code letters, sample sizes, and decision numbers in the workbook.
Excel element
Output result
System element
Inspection task suggestion
Notes
This workbook requires manual entry of sample size and acceptance/rejection numbers; a system could automate selection using approved rules.
Excel element
Instructions
System element
Rule explanation page
Notes
Explain inspection levels and strictness settings according to the adopted standard and internal rules.