Sheets
3
Lookup, standard data, instructions
Free Download
Công cụ tra cứu kế hoạch lấy mẫu AQL
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.
Nhập kích thước lô, cấp kiểm tra, mức nghiêm ngặt và giá trị AQL để trả về cỡ mẫu, số chấp nhận và số bác bỏ.
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
Xem trước nội dung của bản Excel trước
Mẫu workbook miễn phí giúp tra cứu cỡ mẫu, số chấp nhận và số bác bỏ từ kích thước lô, cấp kiểm tra, mức nghiêm ngặt và giá trị AQL.
File
AQL Sampling Plan Lookup Calculator.xlsx
File name：quality_management_aql_sampling_plan_calculator_template_vi.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
Cách sử dụng tra cứu AQL
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
Cách bảng lấy mẫu giấy trở thành tra cứu tự động
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.