Fuel quality check log

Download it

Excel .xlsx, no email and no sign-up. Every derived cell is a real formula rather than a number somebody typed.

Download fuel quality check log

• Quality checks — 28 rows, date, product, nozzle, reading, temperature, filter paper and water
• The correction to 15°C computed in two visible columns, so a supplier can see what was applied
• Constants — the ASTM D1250 coefficients the lookup uses, stated rather than buried

The format is argued for in answering a quality challenge.

Built for the routine check, not the complaint

A log that only exists when somebody complained reads, correctly, as a log kept for complaints, and it is worth much less at the moment it matters.

This one is laid out for the check nobody asked for — date, product, nozzle, reading, temperature — with 'prompted by' as one column on the same rows rather than a separate form. A dated run of routine checks is what turns a later dispute from your word against theirs into a record, and it is the first thing an inspection asks for.

It corrects the reading before comparing it

This is the piece people get wrong, and getting it wrong produces failures that are not failures. Density is quoted at 15°C. The fuel in an Indian tank is not at 15°C. A raw hydrometer reading compared against the invoice figure routinely looks out of tolerance when nothing whatsoever is wrong.

The sheet applies the ASTM D1250 correction in visible helper columns rather than one opaque formula, so a supplier or an inspector can see what was applied and you can check it against a printed table. It iterates twice, because the coefficient depends on the density being solved for — one pass is out by up to 1.1 kg/m³ for petrol on a hot day, which is more than enough to matter on a sheet whose job is deciding whether a reading sits inside a tolerance.