Download it
Excel .xlsx, no email and no sign-up. Every derived cell is a real formula rather than a number somebody typed.
- Deliveries — seals, density, temperature, dips before and after
- The volume correction factor computed per row from ASTM D1250 constants
- Constants — the published product-group values the correction uses
The format is argued for in the tanker delivery checklist.
The order is the control
A delivery is a sequence, and the log follows it: seals checked before anything is opened, density and temperature recorded from the tanker's own documents, a dip before decantation, and a dip after the tank has settled.
Taken out of order the record proves nothing. A dip taken while the tank is still filling is not a measurement, and a seal checked afterwards is not a check. The sheet is laid out in the order the work happens so that filling it in and doing it properly are the same activity.
- No dispensing from the receiving tank while it is being filled — a nozzle drawing during decantation makes the arithmetic unrecoverable.
- The second dip waits for the fuel to stop moving and for entrained air to release. Minutes, not seconds, and longer for a large drop into a nearly empty tank.
- Temperature is recorded at the second dip, because the correction is computed from it.
Why the temperature column is not optional
Fuel is invoiced in litres at 15°C and dipped at whatever the tank is, which in most of India is a long way above it. Comparing the two directly compares different things, and it goes wrong in both directions: a warm load reads as a surplus that is not one, and a cold load reads as a shortage that is not one.
The log records what a claim needs — invoice quantity, density, temperature, both dips — so the figure can be worked out the same day. Every supply agreement has a window, and the practical window is shorter still: a claim made on the day rests on measurements, and one made a week later rests on recollection. The tanker shortage calculator does the arithmetic.