Import validation
import-v1Accepted timestamps: ISO-8601 with or without UTC offset, or Unix seconds/milliseconds. Timestamps without an offset are interpreted in the facility's IANA time zone and the count is reported.
Rows are rejected for unparseable timestamps, non-numeric or negative values, or a meter column that does not match the selected meter. Duplicate intervals keep the first value; conflicting values are reported.
Unit conversion to kWh uses exact factors: Wh ×0.001, MWh ×1000, MJ ÷3.6, GJ ×277.78, therm ×29.3071, MMBtu ×293.071. Volume units are not accepted because they need a supplier calorific value.
Gaps are runs of missing intervals. Completeness = valid intervals ÷ expected intervals between first and last reading. Quality score = 100 × (0.6 × completeness + 0.4 × valid rows ÷ total rows).