Your Cart
Loading

ASTM D4052 Density QC Workbook (Lite): Control Charts for Fuel Labs

On Sale
$0.00
Free Download
Added to cart

Stop charting density check standards by hand. Enter your results, and this free Excel workbook draws the control charts, flags anything out of control, and calculates the numbers your uncertainty budget needs.


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.

What it does

  • Plots each check-standard result on an individuals (X) chart with 2σ warning and 3σ control limits, plus a moving-range chart
  • Flags every result automatically: beyond 3σ, 7 in a row on one side of the center line, moving range too large, or beyond 2σ
  • Calculates within-lab reproducibility, bias against your certified value, and reference-standard uncertainty
  • Includes an out-of-control log for the investigation and corrective action behind every flag
  • Warns you when your data covers less than three months, or when your check standard's certificate has expired

What's in the download

  • Blank workbook, ready for your results
  • Example workbook with 30 fictional results, so you can see the flags and charts working before you start

Supports ISO/IEC 17025:2017: clause 7.7 (monitoring the validity of results) and the main inputs for 7.6 (measurement uncertainty).

Requirements: Microsoft Excel 2016 or later, or Excel for Microsoft 365 (Windows or Mac). No macros. Google Sheets is not supported.

Need records ready for an assessor? The full version ($79) adds a validation record for ISO/IEC 17025 clause 7.11 and document-control fields on every sheet and printout.

This workbook does not reproduce ASTM D4052. Use your licensed copy of the method.

You will get a ZIP (67KB) file