Format 1Interval kWh or numeric value e.g. Orsis/NavitronA – “Description” B – “Name” C – “Unique Identifier” D – Date and Time (DD/MM/YY HH:MM:SS) E – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option1.csv
|
|
Format 2Interval kWh or numeric valueA – Unique Identifier B – Date and Time (YYYY-MM-DD HH:MM:SS) C – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option2.csv
|
|
Format 3Interval kWh or numeric valueA – Unique Identifier B – Date and Time (DD/MM/YY HH:MM:SS) C – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option3.csv
|
|
Format 4Tab separated Interval kWh or numeric valueA – Unique Identifier B – Date and Time (MM/DD/YYYY HH:MM) C – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option4.csv
|
|
Format 5kWh readings (interval) e.g. Automated Meter Reading (AMR) – StarkA – Unique Identifier B – Date (DD/MM/YY) C – Description/Name D – 00:00 to 00:30 – Interval kWh or numeric value E – 00:30 to 01:00 – Interval kWh or numeric value F – 01:00 to 01:30 – Interval kWh or numeric value G – 01:30 to 02:00 – Interval kWh or numeric value etc until 23:30 to 24:00 – Interval kWh or numeric valueFile Name: CSV-Template-Interval-48columns-30mn-option1.csv
|
|
Format 6kWh readings (interval) e.g. Automated Meter Reading (AMR) – STCEnergyA – Code B – Location Name C – Meter MPAN D – Meter serial E – Read Date F – 00:00 to 00:30 – Interval kWh or numeric value G – 00:30 to 01:00 – Interval kWh or numeric value H – 01:00 to 01:30 – Interval kWh or numeric value I – 01:30 to 02:00 – Interval kWh or numeric value etc until 23:30 to 24:00 – Interval kWh or numeric valueFile Name: CSV-Template-Interval-48columns-30mn-option2.csv
|
|
Format 7kWh readings (accumulated and interval) e.g. Automated Meter Reading (AMR) – Total Gas & Power LtdA – Consumer Name B – MPRN C – MPRN Alias D – Site E – AMR Schedule F – Read Date (DD-Month-YYYY) G – Accumulated Reading H – Consumption Profile Date (DD-Month-YYYY) I – Profile Date Consumption J – 00:00 to 00:30 – Interval kWh or numeric value K – 00:30 to 01:00 – Interval kWh or numeric value L – 01:00 to 01:30 – Interval kWh or numeric value M – 01:30 to 02:00 – Interval kWh or numeric value etc until 23:30 to 24:00 – Interval kWh or numeric value Z – Reporting UnitFile Name: CSV-Template-AccumulatedandInterval-48columns-30mn.csv
|
|
Format 8kWh readings (accumulated and interval) e.g. Automated Meter Reading (AMR) – ASL HoldingsA – Description/Name B – Unique Identifier C – Time and Date (HH:MM:SS DD/MM/YY) D – Accumulated total on Channel 1 E – Accumulated total on Channel 2 F – 00:00 to 00:30 – Channel 1 interval kWh or numeric value G – 00:30 to 01:00 – Channel 2 interval kWh or numeric value H – 01:00 to 01:30 – Channel 1 interval kWh or numeric value I – 01:30 to 02:00 – Channel 2 interval kWh or numeric value etc until 23:30 to 24:00 – Interval kWh or numeric valueFile Name: CSV-Template-2Channels-AccumulatedandInterval-48columns-30mn.csv
|
CSV File Formats for FTP Integration
How to Calculate Maximum Peak Demand From kWh and kW
Reducing energy costs starts by understanding what’s driving your energy use. Very often a daily or monthly kWh figure does not reflect what’s…
Read moreGood indoor air quality and optimized energy consumption: now possible with Wattics and Kaiterra
The Covid-19 pandemic has thrust into the spotlight the need to examine indoor air quality to identify harmful, unseen airborne pollutants or…
Read moreTechnology Update
Check out our latest offering: