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
Good 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 moreHow 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 more