{% extends "base.html" %} {% block title %} » DC Contracts » {{contract.name}} » HH Data Imports {% endblock %} {% block nav %} DC Contracts » {{contract.name}} » HH Data Imports {% endblock %} {% block content %}
Below are all the HH data formats accepted by Chellow. Chellow recognizes them by their filename extension. The files may be compressed as zip files.
File extension .simple.csv
. A CSV file with the following
columns:
Name | Description |
---|---|
MPAN Core | |
Channel Type | 'ACTIVE', 'REACTIVE_IMP' or 'REACTIVE_EXP' |
Time | Half-hour starting yyyy-MM-dd hh:mm |
Value | |
Status | 'A' - actual, 'E' - estimate, 'C' - padding. |
Here's an example:
MPAN core, Channel Type, Time, Value, Status 99 9999 9999 999, ACTIVE, 2006-01-01 00:30, 218.4 , E 99 9999 9999 999, ACTIVE, 2006-01-01 01:00, 220.4 , E 99 9999 9999 999, ACTIVE, 2006-01-01 01:30, 221.8 , E 99 9999 9999 999, ACTIVE, 2006-01-01 02:00, 223.4 , E 99 9999 9999 999, ACTIVE, 2006-01-01 02:30, 224.6 , E 99 9999 9999 999, ACTIVE, 2006-01-01 03:00, 226.8 , E 99 9999 9999 999, ACTIVE, 2006-01-01 03:30, 203.8 , E 99 9999 9999 999, ACTIVE, 2006-01-01 04:00, 155.2 , E 99 9999 9999 999, ACTIVE, 2006-01-01 04:30, 169.0 , E 99 9999 9999 999, ACTIVE, 2006-01-01 05:00, 171.0 , E
File extension .df2
. The data file is of the form:
#F2 #O 99 9999 9999 999 #S 2 27/07/05,00:30,95.4,A 27/07/05,01:00,93.8,A 27/07/05,01:30,91.9,A
Number | Meaning |
---|---|
1 | Import kWh |
2 | Export kWh |
3 | Import kVArh |
4 | Export kVArh |
and the status character on the end is optional. For the newer six-channel meters the channels are mapped to the DF2 format as follows:
Import Related | Export Related | |
---|---|---|
Active kWh |
#O mpan_core #S 1 |
#O mpan_core #S 2 |
Reactive Import kVArh |
#O import_mpan_core #S 3 |
#O export_mpan_core #S 3 |
Reactive Export kVArh |
#O import_mpan_core #S 4 |
#O export_mpan_core #S 4 |
File extension .bg.csv
. A CSV file with the following
columns:
Name | Description |
---|---|
MPAN core | |
Meter Serial Number | |
Date | dd/MM/yy |
HH 1 | kWh in 1st HH |
HH 2 | kWh in 2nd HH |
HH 3 | kWh in 3rd HH |
... | ... |
HH 48 | kWh in 48th HH |
Here's an example:
9999999999999,E04M00872,06/07/2008,0.262,0.26,0.252,0.246,0.249,0.251,0.25,0.249,0.244,0.239,0.255,0.255,0.286,0.289,0.356,0.489,0.576,0.585,0.496,0.411,0.457,0.463,0.436,0.447,0.436,0.431,0.439,0.396,0.455,0.453,0.377,0.314,0.341,0.338,0.418,0.45,0.446,0.442,0.464,0.366,0.314,0.386,0.395,0.444,0.346,0.288,0.263,0.255,0,0 9999999999999,E04M00872,07/07/2008,0.247,0.216,0.211,0.227,0.237,0.233,0.229,0.204,0.225,0.267,0.301,0.324,0.466,0.471,0.475,0.546,0.505,0.382,0.362,0.434,0.387,0.395,0.35,0.378,0.348,0.356,0.301,0.34,0.337,0.396,0.386,0.388,0.369,0.325,0.356,0.36,0.367,0.429,0.427,0.466,0.404,0.403,0.319,0.359,0.299,0.294,0.264,0.29,0,0 9999999999999,E04M00872,08/07/2008,0.312,0.31,0.254,0.237,0.222,0.226,0.218,0.211,0.225,0.263,0. 262,0.283,0.423,0.495,0.561,0.569,0.496,0.41,0.381,0.355,0.323,0.366,0.4,0.363,0.381,0.396, 0.392,0.369,0.317,0.301,0.378,0.311,0.391,0.345,0.344,0.382,0.436,0.384,0.353,0.34,0.335,0.352,0.388,0.394,0.389,0.346,0.284,0.258,0,0 9999999999999,E04M00872,09/07/2008,0.246,0.246,0.257,0.266,0.251,0.24,0.229,0.236,0.232,0.245,0.268,0.289,0.424,0.46, 0.513,0.481,0.459,0.441,0.368,0.348,0.401,0.403,0.413,0.412,0.371,0.396,0.381,0.321,0.321,0.276,0.303,0.311,0.348,0.33,0.381,0.398,0.372,0.38,0.322,0.342,0.349,0.331,0.439,0.41,0.368,0.326,0.274,0.257,0,0 9999999999999,E04M00872,10/07/2008,0.247,0.247,0.242,0.251,0.243,0.254,0.25,0.243,0.245,0.246,0.252,0.336,0.378,0.49,0.443, 0.467,0.544,0.467,0.375,0.387,0.403,0.347,0.415,0.404,0.422,0.42,0.375,0.385,0.371, 0.371,0.359,0.397,0.402,0.384,0.393,0.389,0.365,0.381,0.498,0.402,0.355,0.326,0.311,0.31,0.342,0.274,0.293,0.313,0,0 9999999999999,E04M00872,11/07/2008,0.303,0.303,0.277,0.244,0.254,0.24,0.249,0.256,0.318,0.318,0.305, 0.299,0.421,0.529,0.547,0.452,0.458,0.423,0.433,0.377,0.344,0.401,0.417,0.392,0.364,0.373,0.367,0.376,0.387,0.378,0.521,0.525,0.413,0.42,0.377,0.42,0.367,0.371,0.336,0.341,0.336,0.4,0.413,0.401,0.407,0.376,0.353,0.338,0,0 9999999999999,E04M00872,12/07/2008,0.324,0.319,0.31,0.31,0.312,0.282,0.232,0.244,0.246,0.252,0.268,0.286,0.329, 0.378,0.547,0.444,0.447,0.535,0.631,0.556,0.473,0.503,0.47,0.402,0.419,0.443,0.442, 0.409,0.378,0.366,0.384,0.392,0.403,0.406,0.481,0.541,0.486,0.405,0.366,0.364, 0.364,0.43,0.436,0.386,0.402,0.322,0.279,0.291,0,0 9999999999999,E04M00872,13/07/2008,0.268,0.272,0.261,0.25,0.311,0.306,0.267,0.259,0.26,0.3,0.333,0.326,0.362, 0.37,0.448,0.458,0.567,0.664,0.781,0.609,0.529,0.566,0.464,0.366,0.388,0.423,0.357,0.41, 0.352,0.357,0.486,0.547,0.52,0.516,0.558,0.639,0.607,0.65,0.637,0.483,0.457,0.51,0.444,0.422,0.442,0.4,0.314,0.347,0,0 9999999999999,E04M00872,14/07/2008,0.32,0.344,0.261,0.304,0.309,0.239,0.302,0.312,0.26,0.334,0.265,0.444,0.488, 0.552,0.543,0.58,0.599,0.501,0.497,0.48,0.334,0.376,0.409,0.405,0.314,0.303, 0.329,0.369,0.299,0.436,0.48,0.527,0.499,0.549,0.37,0.373,0.347,0.339,0.348, 0.412,0.425,0.385,0.423,0.376,0.373,0.353,0.281,0.27,0,0 9999999999999,E04M00872,15/07/2008,0.314,0.309,0.298,0.29,0.291,0.236,0.244,0.24,0.239,0.246,0.265,0.308, 0.414,0.428,0.504,0.527,0.472,0.35,0.483,0.485,0.543,0.519,0.45,0.345,0.347, 0.375,0.455,0.509,0.498,0.469,0.304,0.329,0.413,0.397,0.445,0.534,0.506,0.405, 0.447,0.422,0.48,0.42,0.431,0.418,0.387,0.365,0.281,0.263,0,0 9999999999999,E04M00872,16/07/2008,0.279,0.313,0.316,0.314,0.311,0.311,0.303,0.287,0.239,0.261,0.269, 0.342,0.446,0.491,0.445,0.556,0.503,0.463,0.412,0.407,0.472,0.445,0.417,0.394, 0.391,0.368,0.403,0.384,0.37,0.316,0.39,0.353,0.442,0.424,0.555,0.477,0.525, 0.476,0.39,0.464,0.465,0.399,0.427,0.432,0.428,0.371,0.333,0.269,0,0{% if processes|length > 0 %}