File gntpnz200101.csv appears to be damaged. At the start, the sixteenth line is missing - the sequence is ABY0111,ALPE,GN,TPNZ,kWh,X,F,1/01/2001,993,1029,911,848,794,761,727,711,672,676,687,730,695,582,0,0,0,0,0,0,0,99,884,904,742,673,930,876,769,721,730,746,689,824,1123,884,0,0,0,0,0,0,0,0,0,0,591,912,23913 ABY0111,ALPE,GN,TPNZ,kWh,X,F,2/01/2001,802,744,700,656,607,602,579,540,549,553,577,588,598,510,0,0,0,0,0,0,0,109,913,911,929,891,1160,1118,989,911,906,925,860,860,944,899,0,0,0,0,0,0,0,0,0,112,1158,1146,24346 ABY0111,ALPE,GN,TPNZ,kWh,X,F,3/01/2001,918,941,828,762,707,676,657,629,611,610,617,656,679,616,0,0,0,0,0,0,0,110,920,929,936,893,1123,1114,1036,1002,996,981,902,915,932,1059,1122,986,0,0,0,0,0,0,0,117,1143,1165,28288 ABY0111,ALPE,GN,TPNZ,kWh,X,F,4/01/2001,995,934,827,764,720,683,658,649,630,641,655,695,729,629,0,0,0,0,0,0,0,124,917,951,976,1011,1131,1277,1179,1053,1026,989,943,900,910,973,1025,863,0,0,0,0,0,0,0,129,1219,1152,28957 ABY0111,ALPE,GN,TPNZ,kWh,X,F,5/01/2001,988,912,825,748,725,695,683,687,669,677,689,680,705,614,0,0,0,0,0,0,0,131,948,970,994,934,1101,1167,1092,1042,1047,1025,952,947,982,1019,1097,891,0,0,0,0,0,0,0,144,1331,1201,29312 ABY0111,ALPE,GN,TPNZ,kWh,X,F,6/01/2001,1050,957,875,826,763,737,726,717,699,699,725,701,721,622,0,0,0,0,0,463,1087,1047,1026,1005,1002,917,1008,1094,992,936,909,894,839,845,862,914,943,761,0,0,0,0,0,0,0,263,1585,1346,31556 ABY0111,ALPE,GN,TPNZ,kWh,X,F,7/01/2001,1203,1065,980,912,868,808,785,746,733,735,749,712,744,585,0,0,0,0,0,0,0,149,996,997,1034,980,980,1210,1201,1083,1036,1025,1004,961,924,962,1000,825,0,0,0,0,0,0,0,206,1222,1051,30471 ABY0111,ALPE,GN,TPNZ,kWh,X,F,8/01/2001,947,862,836,787,747,727,713,714,715,729,717,768,776,654,0,0,0,0,0,0,0,145,952,986,1004,944,1212,1143,1039,1022,1004,1015,907,933,979,1067,1123,922,0,0,0,0,0,0,0,153,1208,1186,29636 ABY0111,ALPE,GN,TPNZ,kWh,X,F,9/01/2001,1027,917,875,842,779,752,737,733,710,722,749,801,798,665,0,0,0,0,0,0,0,153,992,1031,1044,1029,1259,1227,1144,1107,1122,1135,1125,888,0,0,0,0,0,0,0,0,0,0,0,155,1202,1176,26896 ABY0111,ALPE,GN,TPNZ,kWh,X,F,10/01/2001,1046,947,886,832,795,772,743,732,732,731,747,751,755,618,0,0,0,0,0,0,0,162,1010,1041,1028,964,1182,1165,1056,998,1008,998,971,991,1020,1128,1189,904,0,0,0,0,0,0,0,200,1102,974,30178 ABY0111,ALPE,GN,TPNZ,kWh,X,F,11/01/2001,881,806,749,718,677,669,640,625,612,588,636,680,712,614,0,0,0,0,0,0,0,157,908,919,924,870,1107,1073,992,940,928,928,876,890,962,812,0,0,0,0,0,0,0,0,0,0,1119,1144,25156 ABY0111,ALPE,GN,TPNZ,kWh,X,F,12/01/2001,982,874,793,751,724,691,685,655,660,628,681,731,778,805,9,0,0,0,0,0,0,0,849,931,923,872,1121,1077,977,932,908,921,882,872,923,941,947,961,7,0,0,0,0,0,0,0,1140,1101,27732 ABY0111,ALPE,GN,TPNZ,kWh,X,F,13/01/2001,963,860,773,736,706,687,666,634,609,618,634,664,632,669,26,0,0,0,0,0,0,0,939,998,1035,976,1174,1100,1027,994,951,959,940,950,1027,1078,1098,1072,6,0,0,0,0,0,0,0,1090,1069,28360 ABY0111,ALPE,GN,TPNZ,kWh,X,F,14/01/2001,929,818,753,683,669,642,606,593,576,585,594,611,587,619,0,0,0,0,0,0,0,0,827,875,858,830,1075,1043,947,864,815,824,781,766,805,850,907,886,2,0,0,0,0,0,0,0,1023,1030,25273 ABY0111,ALPE,GN,TPNZ,kWh,X,F,15/01/2001,878,768,703,652,640,603,590,585,565,583,604,652,683,743,1,0,0,0,0,0,0,0,0,0,795,788,1039,988,891,873,867,877,877,849,904,967,10,0,0,0,0,0,0,0,0,0,1066,1076,22117 ABY0111,ALPE,GN,TPNZ,kWh,X,F,17/01/2001,968,865,818,760,719,693,687,676,656,649,689,729,774,836,3,0,0,0,0,0,0,0,0,0,910,865,1132,1115,992,924,904,888,849,857,914,933,4,0,0,0,0,0,0,0,0,0,1005,1081,23895 ABY0111,ALPE,GN,TPNZ,kWh,X,F,18/01/2001,985,861,777,743,697,650,640,633,615,617,638,686,717,783,2,0,0,0,0,0,0,0,0,0,913,892,1094,1142,1040,965,952,971,992,924,988,1085,6,0,0,0,0,0,0,0,0,0,1199,1182,24389 ABY0111,ALPE,GN,TPNZ,kWh,X,F,19/01/2001,1045,971,900,858,805,770,764,745,713,746,767,738,770,813,0,0,0,0,0,0,0,0,0,0,977,985,1249,1198,1125,1075,1064,1036,1023,1043,1074,1139,5,0,0,0,0,0,0,0,0,0,840,1182,26420 but, thousands of lines later, tagged on at the end of the file is ,ALPE,GN,TPNZ,kWh,X,F,16/01/2001,953,864,791,731,696,670,644,637,636,645,639,682,731,780,5,0,0,0,0,0,1,0,0,0,885,849,1083,1012,966,933,913,909,872,891,937,1002,10,0,0,0,0,0,0,0,0,0,979,1116,23462 which rather looks as if it should start ABY0111. The CD gives the same result when read on two different computers. How has this been achieved? Prior to CTCT's takeover of the SECOND station at Stratford, series SFD2201.CTCT.GG.CTCT.kWh.X(&I).F represents its operation of the FIRST station at Stratford and zero values past the demise of the FIRST station up until the end of 3/3/2003 are spurious and conflict with non-zero values representing the operation of the SECOND station but not by CTCT. Likewise with series SFD0331.CTCT.GD.CTCT.kWh.X.F. At the Redvale Landfill, WMGT takes over from MRPL with the onset of 4/5/2007. Presumably the zero values for MRPL on 4/5/2007 are some sort of drag on, and are to be ignored. RDV0111,MRPL,EG,MRPL,kWh,I,F,3/05/2007,3360,3361,3359,3357,3357,3357,3355,3353,3353,3352,3347,3345,3348,3349,3348,3342,3343,3334,3330,3321,3321,3322,3321,3320,3317,3318,3310,3304,3305,3304,3304,3307,3306,3306,3308,3311,3317,3319,3316,3323,3325,3325,3324,3326,1355,3155,3357,3346,157743 RDV0111,MRPL,EG,MRPL,kWh,I,F,4/05/2007,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 RDV0111,WMGT,EG,TRUS,kWh,I,F,4/05/2007,3392,3394,3394,3395,3392,3395,3394,3395,3396,3396,3394,3392,3388,3385,3387,3379,3370,3363,3353,3338,3339,3339,3342,3339,3342,3341,3335,3334,3336,3300,2830,2832,2833,2846,3235,3347,3359,2977,3266,3365,3362,3364,3369,3373,3376,3377,3379,3379,158908 RDV0111,WMGT,EG,TRUS,kWh,I,F,5/05/2007,3378,3378,3378,3379,3379,3381,3378,3377,3377,3377,3371,3372,3373,3373,3370,3369,3366,3365,3367,3363,3358,3346,2889,2885,2885,2885,2885,2884,2885,2882,2884,3211,3349,3352,3354,3352,3354,3213,3343,3353,3363,3358,3355,3356,3362,3366,3367,3370,156917 RDV0111,WMGT,EG,TRUS,kWh,I,F,6/05/2007,3372,3371,3373,3374,3376,3375,3373,3372,3374,3376,3375,3377,3372,3377,3373,3375,3373,3367,3364,3363,3357,3355,3355,3350,3352,3352,3352,3349,3347,3349,3349,3349,3350,3348,3349,3352,3356,3356,3357,3362,3366,3369,3374,3374,3375,3374,3375,3376,161481 At the Whitford Landfill, WMGT takes over from MRPL with the onset of 4/5/2007. But, there are non-zero data for both on that day. Is one to be preferred? Are both to be added (unlikely values!) Did MRPL's series indeed quit with 4/5/2007? Why are the values for its last day larger? WHT0111,MRPL,EG,MRPL,kWh,I,F,3/05/2007,998,998,998,997,998,997,997,997,998,997,997,998,997,998,996,995,996,994,991,990,989,987,988,987,980,964,973,975,963,964,975,990,991,992,995,995,996,996,995,995,995,994,995,996,995,996,996,996,47580 WHT0111,MRPL,EG,MRPL,kWh,I,I,4/05/2007,1375,1374,1375,1375,1376,1376,1376,1376,1376,1376,1376,1376,1376,1376,1375,1375,1373,1360,1355,1350,1355,1355,1354,1354,1359,1363,1359,1359,1358,1358,1365,1367,1373,1374,1376,1376,1378,1378,1378,1378,1379,1380,1379,1380,1380,1380,1380,1380,65802 WHT0111,WMGT,EG,TRUS,kWh,I,F,4/05/2007,997,997,997,998,997,997,997,996,997,996,997,997,997,998,998,998,997,996,982,968,968,979,991,969,965,965,972,964,963,972,964,961,977,994,994,995,996,996,996,995,996,996,997,997,997,998,998,998,47450 WHT0111,WMGT,EG,TRUS,kWh,I,F,5/05/2007,998,998,999,999,999,999,999,999,999,999,999,999,999,999,999,999,998,973,971,983,972,973,991,991,991,990,990,991,990,992,993,992,992,994,996,996,996,995,996,996,997,997,997,998,997,998,998,998,47704 WHT0111,WMGT,EG,TRUS,kWh,I,F,6/05/2007,998,999,999,999,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,999,998,997,996,993,993,991,992,992,991,991,990,990,990,992,991,992,993,996,996,996,996,996,986,965,969,995,997,997,998,979,976,47708 Both are in file Gen2007m05gg.csv, which was eggg200705.csv on the CD. KL2\L030501-030930L.csv SFD2201,CTCT,GG,CTCT,kWh,I,F,08/05/03,176680,176320,176500,176610,176440,175890,176250,176130,176080,175760,176020,175820,176500,178940,179670,181130,181490,180280,177900,176990,173400,172120,172420,172120,172180,172180,172180,172110,172180,172120,172180,172180,172110,172180,165540,175350,177470,174680,175340,176990,175650,177170,178510,177470,177470,177280,177040,176640,8421660 Gen2003m05-2003m06.csv SFD2201,CTCT,GG,CTCT,kWh,I,F,08/05/03,176680,176320,176500,176610,176440,175890,176250,176130,176080,175760,176020,175820,176500,178940,179670,181130,181490,180280,177900,176990,173400,172120,172420,172120,172180,172180,172180,172110,172180,172120,172180,172180,172110,172180,165540,175350,177470,174680,175340,176990,175650,177170,178510,177470,177470,177280,177040,176640,8421660 Gen1998m10-2003m12.csv SFD2201,CTCT,GG,CTCT,kWh,I,F, 8/05/2003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 KLz\L030501-031231E.csv SFD2201,CTCT,GG,CTCT,kWh,I,F,08/05/03, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 Gen2003m05gg.csv SFD2201,CTCT,GG,CTCT,kWh,I,F, 8/05/2003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 KL2\L030501-030930L.csv SFD2201,CTCT,GG,CTCT,kWh,I,F,02/06/03,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 Gen2003m05-2003m06.csv SFD2201,CTCT,GG,CTCT,kWh,I,F,02/06/03,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 Gen1998m10-2003m12.csv SFD2201,CTCT,GG,CTCT,kWh,I,F, 2/06/2003,120080,82210,75260,75250,75260,75260,75260,75190,75260,75260,75260,75250,75200,75260,75260,75260,109350,120090,120020,120030,119960,120030,120080,98570,91490,87650,82100,83810,81800,120690,129960,130020,130020,129960,139340,139840,139900,139830,139950,106860,100640,100640,78750,75750,76490,76730,76790,75990,4718910 KLz\L030501-031231E.csv SFD2201,CTCT,GG,CTCT,kWh,I,F,02/06/03, 120080,82210,75260,75250,75260,75260,75260,75190,75260,75260,75260,75250,75200,75260,75260,75260,109350,120090,120020,120030,119960,120030,120080,98570,91490,87650,82100,83810,81800,120690,129960,130020,130020,129960,139340,139840,139900,139830,139950,106860,100640,100640,78750,75750,76490,76730,76790,75990,4718910 Gen2003m05gg.csv SFD2201,CTCT,GG,CTCT,kWh,I,F, 2/06/2003,120080,82210,75260,75250,75260,75260,75260,75190,75260,75260,75260,75250,75200,75260,75260,75260,109350,120090,120020,120030,119960,120030,120080,98570,91490,87650,82100,83810,81800,120690,129960,130020,130020,129960,139340,139840,139900,139830,139950,106860,100640,100640,78750,75750,76490,76730,76790,75990,4718910