HH Data Formats
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.
CSV Simple
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
Stark DF2
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 |
bGlobal CSV
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
-
{% for proc in processes %}
- {{proc.id}} {% endfor %}