Opening = last month's closing · Closing = this month's raw End Read · Net = Closing − Opening
Used as the template. Its closing readings become this period's opening readings.
Its End Read values become this period's closing readings.
Every affected machine is flagged either way. A blank meter is never treated as a zero reading.
The template's =J−E formula runs against the empty cell, so every gap becomes a large negative net and the fleet totals fall below their minimum commitments. Only choose this if you intend to type in each missing reading by hand before billing.
=J−E
Validate
Generate billing report Start over