ASTM D4052 Density QC Workbook: Validated Control Charts for ISO 17025 Fuel Labs
Assessors don't just want to see your density control chart. They want to know the spreadsheet behind it was validated, and that the record is controlled. This workbook gives you both.
Developed by an industrial chemist who established an ISO 9001 and ISO/IEC 17025-accredited fuel testing laboratory and served as its QA manager, running Jet A-1 analysis to ASTM and IP methods. Built for labs running ASTM D4052 on a digital density meter.
Control charts and automatic flags
- Individuals (X) chart with 2σ warning and 3σ control limits, plus a moving-range chart
- Every result flagged automatically: beyond 3σ, 7 in a row on one side of the center line, moving range too large, or beyond 2σ
- Out-of-control log for the investigation, root cause and corrective action behind every flag
Inputs for your uncertainty budget
- Within-lab reproducibility from your own QC history
- Bias against your certified value, and its standard uncertainty
- Reference-standard uncertainty from the certificate
- Checks for data coverage under three months and expired check standards
Ready for your quality system
- Validation record for clause 7.11 of ISO/IEC 17025:2017. A 30-point test dataset that triggers all four flag rules, 19 checks against expected results calculated independently of the spreadsheet, automatic pass/fail, and a sign-off block. Validate in an afternoon instead of building the test yourself.
- Document control. Enter your document number, revision, effective date and approver once; they appear on every sheet and printout.
- Print-ready. Landscape, one page wide, headers repeated on every page, both charts on a single page.
- Protected formulas. Only the input cells can be edited. No password, so you can always inspect how a number is calculated.
What's in the download
- Blank template for your real results
- Example file with 30 fictional results
- 2-page Quick Start guide and one-page ISO/IEC 17025 clause map (PDF)
- License: one laboratory site
Supports ISO/IEC 17025:2017: clauses 7.7 (monitoring the validity of results), 7.11 (validated calculation tools), 7.5 (technical records) and 8.3 (document control), plus the main inputs for 7.6 (measurement uncertainty). A one-page clause map in the download shows which part supports each clause and what your laboratory provides.
Requirements: Microsoft Excel 2016 or later, or Excel for Microsoft 365 (Windows or Mac). No macros. Google Sheets is not supported.
Paying by purchase order? Email support@omniservetexas.com for an invoice.
Sales policy: All sales are final, since files can't be returned once downloaded. Please review the free preview before buying. If a file won't open or doesn't work as described in Excel 2016 or later, email support@omniservetexas.com and we'll fix or replace it.
This workbook does not reproduce ASTM D4052; use your licensed copy of the method. It supports QC and accreditation preparation but does not by itself demonstrate compliance with ISO/IEC 17025.