A month of readings in one file
The problem: Readings arrive in an Excel sheet and get retyped meter by meter.
- 1What comes inXLSXreadings-october.xlsx9 rows · one reading per rowE-11342280E-11418616W-0311245.6…6 more rows
Readings come from a CSV or Excel file, or are pasted from a spreadsheet.
- 2What Haldivo does
Meter Reading Status E-113 42,280 Ready E-114 18,616 Ready E-115 16,286 Ready W-031 1,245.6 Blocked W-031: reading is below the previous (1,254.2)8 ready · 0 warnings · 1 blockedEvery row is ready, warned or blocked. A reading below the last one never reaches the billing.
- 3The result9 / 9 readingsOctober ready to splitW-031 corrected1,268.4 · +14.2 m³Blocked rows0
The month’s readings are complete and checked, ready for the cost split.