{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Admin","Monthly Data","OLS Model","Predicted Monthly Data","Predicted Monthly Data Summ","PredictedAnnualDataSumm","PredictedAnnualDataSumm2","Normalized Monthly Data","Normalized Monthly Data Summ","NormalizedAnnualDataSumm","NormalizedAnnualDataSumm2"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":3},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Admin","index":0,"n_rows":37,"n_cols":28,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Month"]
["Model","GSgt50_kWh_excl_Customer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1995,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1996,2]
["Actual","Year","Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1997,3]
["From Date",2009,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1998,4]
["To Date",2013,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000,6]
["Forecast Term",2,"Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2001,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2002,8]
["Forecast","Year","Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2003,9]
["From Date",2014,1,null,"Months",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2004,10]
["To Date",2015,12,null,{"$f":"MyMonthsCount(B11,C11,B12,C12)","v":24},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2005,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2027]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2028]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2029]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2030]

{"sheet":"Monthly Data","index":1,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Date","GSgt50_kWh_excl_Customer","HDD_Lond","CDD_Lond","GSgtCust","PeakDays","RecessionD"]
["2009-01-01",10041072.189999999,849.6,0,189,21,1]
["2009-02-01",9069400.7899999991,612.70000000000005,0,188,19,1]
["2009-03-01",9776173.8699999992,533.29999999999995,0,188,22,1]
["2009-04-01",9109897.5600000005,307,3.2,188,20,1]
["2009-05-01",8687283.8300000001,156.9,3.1,188,20,1]
["2009-06-01",9451017.7899999991,49.7,35.5,188,22,1]
["2009-07-01",9742232.9700000007,20.2,29.4,188,22,0]
["2009-08-01",10469757.689999999,17.899999999999999,71.900000000000006,188,20,0]
["2009-09-01",10182474.18,71.2,15.9,188,21,0]
["2009-10-01",9994234.6699999999,301.2,0,188,21,0]
["2009-11-01",9668749.4299999997,356.7,0,188,21,0]
["2009-12-01",9993430.7300000004,637.29999999999995,0,190,21,0]
["2010-01-01",10564708.060000001,733.1,0,187,20,0]
["2010-02-01",9623559.5700000003,633.4,0,193,19,0]
["2010-03-01",10034192.17,450.2,0,192,23,0]
["2010-04-01",9603845.4299999997,236.4,0,191,20,0]
["2010-05-01",10306144.42,121.1,34.9,190,20,0]
["2010-06-01",10753297.439999999,23.6,57.5,193,22,0]
["2010-07-01",10794881.210000001,5.6,129.69999999999999,189,21,0]
["2010-08-01",10882484.279999999,6,121.7,192,21,0]
["2010-09-01",10115723.83,87.9,24.1,192,21,0]
["2010-10-01",9906643.8599999994,239.5,0,192,20,0]
["2010-11-01",9794566.3000000007,413.6,0,193,22,0]
["2010-12-01",9975886.3399999999,713.5,0,192,21,0]
["2011-01-01",10489464.5,798.8,0,191,20,0]
["2011-02-01",9582988.7699999996,677.8,0,193,19,0]
["2011-03-01",10507121.9,599.6,0,192,23,0]
["2011-04-01",9565988.370000001,330.4,0,194,19,0]
["2011-05-01",9950497.4600000009,126.4,17.399999999999999,194,21,0]
["2011-06-01",10402840.51,27,39.6,195,22,0]
["2011-07-01",10822110.18,0,160.9,194,20,0]
["2011-08-01",11178847.140000001,1.5,82.9,194,22,0]
["2011-09-01",10387464.109999999,71.900000000000006,29,194,21,0]
["2011-10-01",10194048.25,234.6,0,195,20,0]
["2011-11-01",9920993.7899999991,347.9,0,195,22,0]
["2011-12-01",9785536.8599999994,548.4,0,195,20,0]
["2012-01-01",10452458.27,644.79999999999995,0,195,21,0]
["2012-02-01",9937260,553,0,195,20,0]
["2012-03-01",10462882.84,331.1,2.2000000000000002,195,22,0]
["2012-04-01",9640008.1400000006,334.6,0,195,19,0]
["2012-05-01",10514005.859999999,87.2,28.5,195,22,0]
["2012-06-01",10767424.07,28.2,81.7,194,21,0]
["2012-07-01",11168128.789999999,0,161,194,21,0]
["2012-08-01",11224504.99,7.8,79.599999999999994,193,22,0]
["2012-09-01",10345375.720000001,103.4,27.7,193,19,0]
["2012-10-01",10172714.949999999,250.5,0.7,193,22,0]
["2012-11-01",9950896.8000000007,420.4,0,193,22,0]
["2012-12-01",9898195.3300000001,535.9,0,194,19,0]
["2013-01-01",10741569.73,657.4,0,194,22,0]
["2013-02-01",9835940.1199999992,657,0,194,19,0]
["2013-03-01",10432388.58,581.9,0,194,20,0]
["2013-04-01",9763308.4700000007,362.2,0,166,21,0]
["2013-05-01",9966896.9100000001,122.2,27,147,22,0]
["2013-06-01",9797708.6400000006,41.1,52.7,142,20,0]
["2013-07-01",10075728.880000001,7.1,108.8,142,22,0]
["2013-08-01",10530715.739999995,18.399999999999999,57.5,141,21,0]
["2013-09-01",9892268.5600000024,94.9,26,141,20,0]
["2013-10-01",9811835.0600000042,184,2.6,142,22,0]
["2013-11-01",9620672.120000001,492.1,0,142,21,0]
["2013-12-01",9553363.3200000022,675.7,0,142,20,0]

{"sheet":"OLS Model","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Model 1: OLS, using observations 2009:01-2013:12 (T = 60)"]
["Dependent variable: GSgt50_kWh_excl_Customer"]
[]
[null,"coefficient","std. error","t-ratio","p-value"]
["const",5375930.4823210305,862060.27591937606,6.2361422193914198,7.1145076364834895E-8]
["HDD_Lond",498.56581467285599,200.25871734368999,2.4896085488113902,1.58997558697276E-2]
["CDD_Lond",8653.1424465668006,1224.7697226175601,7.0651178640123904,3.2295408239215201E-9]
["GSgtCust",7669.7568605763399,2194.7390910598001,3.4946098567337098,9.5651527491360697E-4]
["PeakDays",144250.539969593,35372.0871067349,4.0780895833010504,1.50380314497017E-4]
["RecessionD",-713277.00203167403,125930.294381794,-5.6640620553873298,5.8598999053021E-7]
[]
["Mean dependent var",10098096.872333299,"S.D. dependent var",514918.64504044101]
["Sum squared resid",4498000400435.9902,"S.E. of regression",288610.99028238299]
["R-squared",0.71246531373912003,"Adjusted R-squared",0.68584173167792695]
["F(5, 54)",26.7606857747978,"P-value(F)",1.6826124555758999E-13]
["Log-likelihood",-836.34559688034801,"Akaike criterion",1684.6911937606999]
["Schwarz criterion",1697.2572611340299,"Hannan-Quinn",1689.60647351784]
["rho",-5.9257560942847003E-2,"Durbin-Watson",2.06370812778948]
["Theil's U",0.49608999999999998]

{"sheet":"Predicted Monthly Data","index":3,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Date","GSgt50_kWh_excl_Customer","HDD_Lond","CDD_Lond","GSgtCust","PeakDays","RecessionD",null,"Const","HDD_Lond","CDD_Lond","GSgtCust","PeakDays","RecessionD","Predicted Value"]
["2009-01-01",10041072.189999999,849.6,0,189,21,1,null,{"$f":"const","v":5375930.4823210305},{"$f":"HDD_Lond*C2","v":423581.51614605845},{"$f":"CDD_Lond*D2","v":0},{"$f":"GSgtCust*E2","v":1449584.0466489282},{"$f":"PeakDays*F2","v":3029261.339361453},{"$f":"RecessionD*G2","v":-713277.00203167403},{"$f":"SUM(I2:N2)","v":9565080.3824457955}]
["2009-02-01",9069400.7899999991,612.70000000000005,0,188,19,1,null,5375930.4823210305,305471.27465005888,0,1441914.2897883519,2740760.2594222669,-713277.00203167403,9150799.3041500337]
["2009-03-01",9776173.8699999992,533.29999999999995,0,188,22,1,null,5375930.4823210305,265885.14896503405,0,1441914.2897883519,3173511.8793310458,-713277.00203167403,9543964.7983737867]
["2009-04-01",9109897.5600000005,307,3.2,188,20,1,null,5375930.4823210305,153059.70510456679,27690.055829013763,1441914.2897883519,2885010.7993918601,-713277.00203167403,9170328.3304031491]
["2009-05-01",8687283.8300000001,156.9,3.1,188,20,1,null,5375930.4823210305,78224.976322171104,26824.741584357082,1441914.2897883519,2885010.7993918601,-713277.00203167403,9094628.2873760965]
["2009-06-01",9451017.7899999991,49.7,35.5,188,22,1,null,5375930.4823210305,24778.720989240945,307186.55685312144,1441914.2897883519,3173511.8793310458,-713277.00203167403,9610044.9272511173]
["2009-07-01",9742232.9700000007,20.2,29.4,188,22,0,null,5375930.4823210305,10071.02945639169,254402.38792906393,1441914.2897883519,3173511.8793310458,0,10255830.068825886]
["2009-08-01",10469757.689999999,17.899999999999999,71.900000000000006,188,20,0,null,5375930.4823210305,8924.3280826441223,622160.94190815301,1441914.2897883519,2885010.7993918601,0,10333940.84149204]
["2009-09-01",10182474.18,71.2,15.9,188,21,0,null,5375930.4823210305,35497.886004707347,137584.96490041213,1441914.2897883519,3029261.339361453,0,10020188.962375956]
["2009-10-01",9994234.6699999999,301.2,0,188,21,0,null,5375930.4823210305,150168.02337946423,0,1441914.2897883519,3029261.339361453,0,9997274.1348503008]
["2009-11-01",9668749.4299999997,356.7,0,188,21,0,null,5375930.4823210305,177838.42609380774,0,1441914.2897883519,3029261.339361453,0,10024944.537564643]
["2009-12-01",9993430.7300000004,637.29999999999995,0,190,21,0,null,5375930.4823210305,317735.9936910111,0,1457253.8035095045,3029261.339361453,0,10180181.618882999]
["2010-01-01",10564708.060000001,733.1,0,187,20,0,null,5375930.4823210305,365498.59873667074,0,1434244.5329277755,2885010.7993918601,0,10060684.413377337]
["2010-02-01",9623559.5700000003,633.4,0,193,19,0,null,5375930.4823210305,315791.58701378695,0,1480263.0740912335,2740760.2594222669,0,9912745.4028483182]
["2010-03-01",10034192.17,450.2,0,192,23,0,null,5375930.4823210305,224454.32976571977,0,1472593.3172306572,3317762.4193006391,0,10390740.548618045]
["2010-04-01",9603845.4299999997,236.4,0,191,20,0,null,5375930.4823210305,117860.95858866315,0,1464923.5603700809,2885010.7993918601,0,9843725.8006716352]
["2010-05-01",10306144.42,121.1,34.9,190,20,0,null,5375930.4823210305,60376.320156882859,301994.67138518131,1457253.8035095045,2885010.7993918601,0,10080566.076764459]
["2010-06-01",10753297.439999999,23.6,57.5,193,22,0,null,5375930.4823210305,11766.153226279403,497555.69067759102,1480263.0740912335,3173511.8793310458,0,10539027.279647179]
["2010-07-01",10794881.210000001,5.6,129.69999999999999,189,21,0,null,5375930.4823210305,2791.9685621679932,1122312.5753197139,1449584.0466489282,3029261.339361453,0,10979880.412213294]
["2010-08-01",10882484.279999999,6,121.7,192,21,0,null,5375930.4823210305,2991.3948880371358,1053087.4357471797,1472593.3172306572,3029261.339361453,0,10933863.969548358]
["2010-09-01",10115723.83,87.9,24.1,192,21,0,null,5375930.4823210305,43823.935109744045,208540.73296225991,1472593.3172306572,3029261.339361453,0,10130149.806985145]
["2010-10-01",9906643.8599999994,239.5,0,192,20,0,null,5375930.4823210305,119406.512614149,0,1472593.3172306572,2885010.7993918601,0,9852941.111557696]
["2010-11-01",9794566.3000000007,413.6,0,193,22,0,null,5375930.4823210305,206206.82094869326,0,1480263.0740912335,3173511.8793310458,0,10235912.256692003]
["2010-12-01",9975886.3399999999,713.5,0,192,21,0,null,5375930.4823210305,355726.70876908273,0,1472593.3172306572,3029261.339361453,0,10233511.847682225]
["2011-01-01",10489464.5,798.8,0,191,20,0,null,5375930.4823210305,398254.37276067736,0,1464923.5603700809,2885010.7993918601,0,10124119.214843649]
["2011-02-01",9582988.7699999996,677.8,0,193,19,0,null,5375930.4823210305,337927.90918526176,0,1480263.0740912335,2740760.2594222669,0,9934881.7250197921]
["2011-03-01",10507121.9,599.6,0,192,23,0,null,5375930.4823210305,298940.06247784448,0,1472593.3172306572,3317762.4193006391,0,10465226.281330172]
["2011-04-01",9565988.370000001,330.4,0,194,19,0,null,5375930.4823210305,164726.1451679116,0,1487932.8309518099,2740760.2594222669,0,9769349.7178630196]
["2011-05-01",9950497.4600000009,126.4,17.399999999999999,194,21,0,null,5375930.4823210305,63018.718974649004,150564.67857026233,1487932.8309518099,3029261.339361453,0,10106708.050179204]
["2011-06-01",10402840.51,27,39.6,195,22,0,null,5375930.4823210305,13461.276996167111,342664.44088404533,1495602.5878123862,3173511.8793310458,0,10401170.667344674]
["2011-07-01",10822110.18,0,160.9,194,20,0,null,5375930.4823210305,0,1392290.6196525982,1487932.8309518099,2885010.7993918601,0,11141164.732317299]
["2011-08-01",11178847.140000001,1.5,82.9,194,22,0,null,5375930.4823210305,747.84872200928396,717345.50882038777,1487932.8309518099,3173511.8793310458,0,10755468.550146282]
["2011-09-01",10387464.109999999,71.900000000000006,29,194,21,0,null,{"$f":"const","v":5375930.4823210305},{"$f":"HDD_Lond*C34","v":35846.882074978348},{"$f":"CDD_Lond*D34","v":250941.13095043722},{"$f":"GSgtCust*E34","v":1487932.8309518099},{"$f":"PeakDays*F34","v":3029261.339361453},{"$f":"RecessionD*G34","v":0},{"$f":"SUM(I34:N34)","v":10179912.665659709}]
["2011-10-01",10194048.25,234.6,0,195,20,0,null,5375930.4823210305,116963.54012225202,0,1495602.5878123862,2885010.7993918601,0,9873507.4096475281]
["2011-11-01",9920993.7899999991,347.9,0,195,22,0,null,5375930.4823210305,173451.04692468658,0,1495602.5878123862,3173511.8793310458,0,10218495.996389151]
["2011-12-01",9785536.8599999994,548.4,0,195,20,0,null,5375930.4823210305,273413.49276659422,0,1495602.5878123862,2885010.7993918601,0,10029957.362291873]
["2012-01-01",10452458.27,644.79999999999995,0,195,21,0,null,5375930.4823210305,321475.2373010575,0,1495602.5878123862,3029261.339361453,0,10222269.646795927]
["2012-02-01",9937260,553,0,195,20,0,null,5375930.4823210305,275706.89551408938,0,1495602.5878123862,2885010.7993918601,0,10032250.765039366]
["2012-03-01",10462882.84,331.1,2.2000000000000002,195,22,0,null,5375930.4823210305,165075.14123818264,19036.913382446965,1495602.5878123862,3173511.8793310458,0,10229157.004085094]
["2012-04-01",9640008.1400000006,334.6,0,195,19,0,null,5375930.4823210305,166820.12158953762,0,1495602.5878123862,2740760.2594222669,0,9779113.4511452205]
["2012-05-01",10514005.859999999,87.2,28.5,195,22,0,null,5375930.4823210305,43474.939039473044,246614.55972715383,1495602.5878123862,3173511.8793310458,0,10335134.44823109]
["2012-06-01",10767424.07,28.2,81.7,194,21,0,null,5375930.4823210305,14059.555973774539,706961.73788450763,1487932.8309518099,3029261.339361453,0,10614145.946492575]
["2012-07-01",11168128.789999999,0,161,194,21,0,null,5375930.4823210305,0,1393155.933897255,1487932.8309518099,3029261.339361453,0,11286280.586531548]
["2012-08-01",11224504.99,7.8,79.599999999999994,193,22,0,null,5375930.4823210305,3888.8133544482766,688790.13874671725,1480263.0740912335,3173511.8793310458,0,10722384.387844475]
["2012-09-01",10345375.720000001,103.4,27.7,193,19,0,null,5375930.4823210305,51551.705237173315,239692.04576990037,1480263.0740912335,2740760.2594222669,0,9888197.5668416042]
["2012-10-01",10172714.949999999,250.5,0.7,193,22,0,null,5375930.4823210305,124890.73657555043,6057.19971259676,1480263.0740912335,3173511.8793310458,0,10160653.372031458]
["2012-11-01",9950896.8000000007,420.4,0,193,22,0,null,5375930.4823210305,209597.06848846865,0,1480263.0740912335,3173511.8793310458,0,10239302.504231777]
["2012-12-01",9898195.3300000001,535.9,0,194,19,0,null,5375930.4823210305,267181.4200831835,0,1487932.8309518099,2740760.2594222669,0,9871804.9927782901]
["2013-01-01",10741569.73,657.4,0,194,22,0,null,5375930.4823210305,327757.16656593553,0,1487932.8309518099,3173511.8793310458,0,10365132.359169822]
["2013-02-01",9835940.1199999992,657,0,194,19,0,null,5375930.4823210305,327557.74024006637,0,1487932.8309518099,2740760.2594222669,0,9932181.3129351735]
["2013-03-01",10432388.58,581.9,0,194,20,0,null,5375930.4823210305,290115.44755813491,0,1487932.8309518099,2885010.7993918601,0,10038989.560222834]
["2013-04-01",9763308.4700000007,362.2,0,166,21,0,null,5375930.4823210305,180580.53807450843,0,1273179.6388556724,3029261.339361453,0,9858951.9986126646]
["2013-05-01",9966896.9100000001,122.2,27,147,22,0,null,5375930.4823210305,60924.742553023003,233634.84605730363,1127454.258504722,3173511.8793310458,0,9971456.2087671235]
["2013-06-01",9797708.6400000006,41.1,52.7,142,20,0,null,5375930.4823210305,20491.054983054382,456020.60693407041,1089105.4742018403,2885010.7993918601,0,9826558.4178318568]
["2013-07-01",10075728.880000001,7.1,108.8,142,22,0,null,5375930.4823210305,3539.8172841772775,941461.89818646782,1089105.4742018403,3173511.8793310458,0,10583549.551324561]
["2013-08-01",10530715.739999995,18.399999999999999,57.5,141,21,0,null,5375930.4823210305,9173.6109899805488,497555.69067759102,1081435.717341264,3029261.339361453,0,9993356.8406913187]
["2013-09-01",9892268.5600000024,94.9,26,141,20,0,null,5375930.4823210305,47313.895812454037,224981.70361073682,1081435.717341264,2885010.7993918601,0,9614672.598477345]
["2013-10-01",9811835.0600000042,184,2.6,142,22,0,null,5375930.4823210305,91736.109899805509,22498.170361073684,1089105.4742018403,3173511.8793310458,0,9752782.1161147952]
["2013-11-01",9620672.120000001,492.1,0,142,21,0,null,5375930.4823210305,245344.23740051244,0,1089105.4742018403,3029261.339361453,0,9739641.5332848355]
["2013-12-01",9553363.3200000022,675.7,0,142,20,0,null,5375930.4823210305,336880.92097444879,0,1089105.4742018403,2885010.7993918601,0,9686927.6768891811]

{"sheet":"Predicted Monthly Data Summ","index":4,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Date","Year","GSgt50_kWh_excl_Customer","Predicted Value","Absolute % Error"]
["2009-01-01",{"$f":"YEAR(A2)","v":2009},10041072.189999999,9565080.3824457955,{"$f":"ABS(D2-C2)/C2","v":4.7404480173765591E-2}]
["2009-02-01",2009,9069400.7899999991,9150799.3041500337,8.9750707940689251E-3]
["2009-03-01",2009,9776173.8699999992,9543964.7983737867,2.3752551326730084E-2]
["2009-04-01",2009,9109897.5600000005,9170328.3304031491,6.6335290825321426E-3]
["2009-05-01",2009,8687283.8300000001,9094628.2873760965,4.6889737384820357E-2]
["2009-06-01",2009,9451017.7899999991,9610044.9272511173,1.6826456238330519E-2]
["2009-07-01",2009,9742232.9700000007,10255830.068825886,5.2718622148273768E-2]
["2009-08-01",2009,10469757.689999999,10333940.84149204,1.2972301034023205E-2]
["2009-09-01",2009,10182474.18,10020188.962375956,1.5937699890543111E-2]
["2009-10-01",2009,9994234.6699999999,9997274.1348503008,3.0412182129608959E-4]
["2009-11-01",2009,9668749.4299999997,10024944.537564643,3.6839832301315829E-2]
["2009-12-01",2009,9993430.7300000004,10180181.618882999,1.8687365123008001E-2]
["2010-01-01",2010,10564708.060000001,10060684.413377337,4.7708241795245909E-2]
["2010-02-01",2010,9623559.5700000003,9912745.4028483182,3.0049778436433361E-2]
["2010-03-01",2010,10034192.17,10390740.548618045,3.5533341655947653E-2]
["2010-04-01",2010,9603845.4299999997,9843725.8006716352,2.49775334703232E-2]
["2010-05-01",2010,10306144.42,10080566.076764459,2.1887752979454285E-2]
["2010-06-01",2010,10753297.439999999,10539027.279647179,1.9925995867628537E-2]
["2010-07-01",2010,10794881.210000001,10979880.412213294,1.7137678369440152E-2]
["2010-08-01",2010,10882484.279999999,10933863.969548358,4.7213198959344905E-3]
["2010-09-01",2010,10115723.83,10130149.806985145,1.426094388061735E-3]
["2010-10-01",2010,9906643.8599999994,9852941.111557696,5.4208821071219365E-3]
["2010-11-01",2010,9794566.3000000007,10235912.256692003,4.5060285792542204E-2]
["2010-12-01",2010,9975886.3399999999,10233511.847682225,2.5824823870459687E-2]
["2011-01-01",2011,10489464.5,10124119.214843649,3.4829736556747065E-2]
["2011-02-01",2011,9582988.7699999996,9934881.7250197921,3.6720585139514109E-2]
["2011-03-01",2011,10507121.9,10465226.281330172,3.9873543933880125E-3]
["2011-04-01",2011,9565988.370000001,9769349.7178630196,2.1258791041475884E-2]
["2011-05-01",2011,9950497.4600000009,10106708.050179204,1.5698771926444276E-2]
["2011-06-01",2011,10402840.51,10401170.667344674,1.6051795216125142E-4]
["2011-07-01",2011,10822110.18,11141164.732317299,2.948173202920569E-2]
["2011-08-01",2011,11178847.140000001,10755468.550146282,3.7873188939026754E-2]
["2011-09-01",{"$f":"YEAR(A34)","v":2011},10387464.109999999,10179912.665659709,{"$f":"ABS(D34-C34)/C34","v":1.9980954171526906E-2}]
["2011-10-01",2011,10194048.25,9873507.4096475281,3.1443920265187282E-2]
["2011-11-01",2011,9920993.7899999991,10218495.996389151,2.9987137648349597E-2]
["2011-12-01",2011,9785536.8599999994,10029957.362291873,2.4977730480070268E-2]
["2012-01-01",2012,10452458.27,10222269.646795927,2.2022438861559114E-2]
["2012-02-01",2012,9937260,10032250.765039366,9.5590499835332618E-3]
["2012-03-01",2012,10462882.84,10229157.004085094,2.2338569540448577E-2]
["2012-04-01",2012,9640008.1400000006,9779113.4511452205,1.4429999344919635E-2]
["2012-05-01",2012,10514005.859999999,10335134.44823109,1.7012679482081777E-2]
["2012-06-01",2012,10767424.07,10614145.946492575,1.4235356805021351E-2]
["2012-07-01",2012,11168128.789999999,11286280.586531548,1.0579372673186082E-2]
["2012-08-01",2012,11224504.99,10722384.387844475,4.4734320364494332E-2]
["2012-09-01",2012,10345375.720000001,9888197.5668416042,4.4191546593572772E-2]
["2012-10-01",2012,10172714.949999999,10160653.372031458,1.1856793420267353E-3]
["2012-11-01",2012,9950896.8000000007,10239302.504231777,2.8982885666322684E-2]
["2012-12-01",2012,9898195.3300000001,9871804.9927782901,2.6661766455269588E-3]
["2013-01-01",2013,10741569.73,10365132.359169822,3.5044912456214931E-2]
["2013-02-01",2013,9835940.1199999992,9932181.3129351735,9.7846460796849923E-3]
["2013-03-01",2013,10432388.58,10038989.560222834,3.7709390976037219E-2]
["2013-04-01",2013,9763308.4700000007,9858951.9986126646,9.7962211177236285E-3]
["2013-05-01",2013,9966896.9100000001,9971456.2087671235,4.5744415822631112E-4]
["2013-06-01",2013,9797708.6400000006,9826558.4178318568,2.9445433510927673E-3]
["2013-07-01",2013,10075728.880000001,10583549.551324561,5.0400390619141033E-2]
["2013-08-01",2013,10530715.739999995,9993356.8406913187,5.1027766067938338E-2]
["2013-09-01",2013,9892268.5600000024,9614672.598477345,2.8061911162130575E-2]
["2013-10-01",2013,9811835.0600000042,9752782.1161147952,6.0185422527077228E-3]
["2013-11-01",2013,9620672.120000001,9739641.5332848355,1.2366018901892943E-2]
["2013-12-01",2013,9553363.3200000022,9686927.6768891811,1.3980872747670079E-2]
[null,null,null,null,{"$f":"AVERAGE(E2:E61)","v":2.2392444194725865E-2}]

{"sheet":"PredictedAnnualDataSumm","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Annual Predicted vs. Actual GSgt50_kWh_excl_Customer"]
[null,"GSgt50_kWh_excl_Customer ","Predicted Value ","Absolute % Error  "]
[2009,116185725.7,116947206.1939918,6.553993525486859E-3]
[2010,122355932.91000001,123193748.92660569,6.847367321549812E-3]
[2011,122787901.83999999,122999962.37303235,1.7270474521886147E-3]
[2012,124533855.75999999,123380694.6720484,9.2598199976554364E-3]
[2013,120022396.13000001,119364200.1743215,5.4839428048544794E-3]
[null,null,"Mean Absolute Percentage Error (Annual)",{"$f":"AVERAGE(D4:D8)","v":5.9744342203470408E-3}]
[null,null,"Mean Absolute Percentage Error (Monthly)",2.2392444194725865E-2]

{"sheet":"PredictedAnnualDataSumm2","index":6,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"GSgt50_kWh_excl_Customer ","Predicted Value "]
[2009,116185725.7,116947206.1939918]
[2010,122355932.91000001,123193748.92660569]
[2011,122787901.83999999,122999962.37303235]
[2012,124533855.75999999,123380694.6720484]
[2013,120022396.13000001,119364200.1743215]

{"sheet":"Normalized Monthly Data","index":7,"n_rows":85,"n_cols":15,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Date","GSgt50_kWh_excl_Customer","HDD_Lond","CDD_Lond","GSgtCust","PeakDays","RecessionD",null,"Const","HDD_Lond","CDD_Lond","GSgtCust","PeakDays","RecessionD","Normalized Value"]
["2009-01-01",10041072.189999999,716.23,0,189,21,1,null,{"$f":"const","v":5375930.4823210305},{"$f":"HDD_Lond*C2","v":357087.79344313964},{"$f":"CDD_Lond*D2","v":0},{"$f":"GSgtCust*E2","v":1449584.0466489282},{"$f":"PeakDays*F2","v":3029261.339361453},{"$f":"RecessionD*G2","v":-713277.00203167403},{"$f":"SUM(I2:N2)","v":9498586.6597428769}]
["2009-02-01",9069400.7899999991,650.25,0,188,19,1,null,5375930.4823210305,324192.42099102458,0,1441914.2897883519,2740760.2594222669,-713277.00203167403,9169520.450491]
["2009-03-01",9776173.8699999992,533.91,0.22,188,22,1,null,5375930.4823210305,266189.27411198453,1903.6913382446962,1441914.2897883519,3173511.8793310458,-713277.00203167403,9546172.6148589831]
["2009-04-01",9109897.5600000005,312.88,0.32,188,20,1,null,5375930.4823210305,155991.27209484318,2769.0055829013763,1441914.2897883519,2885010.7993918601,-713277.00203167403,9148338.847147312]
["2009-05-01",8687283.8300000001,145.96,16.98,188,20,1,null,5375930.4823210305,72770.666309650071,146930.35874270427,1441914.2897883519,2885010.7993918601,-713277.00203167403,9209279.594521923]
["2009-06-01",9451017.7899999991,30.95,59.64,188,22,1,null,5375930.4823210305,15430.611964124893,516073.41551324399,1441914.2897883519,3173511.8793310458,-713277.00203167403,9809583.6768861245]
["2009-07-01",9742232.9700000007,6,109.95,188,22,0,null,5375930.4823210305,2991.3948880371358,951413.01200001978,1441914.2897883519,3173511.8793310458,0,10945761.058328483]
["2009-08-01",10469757.689999999,11.72,76.849999999999994,188,20,0,null,5375930.4823210305,5843.1913479658724,664993.99701865856,1441914.2897883519,2885010.7993918601,0,10373692.759867867]
["2009-09-01",10182474.18,72.849999999999994,24.35,188,21,0,null,5375930.4823210305,36320.519598917555,210704.01857390162,1441914.2897883519,3029261.339361453,0,10094130.649643654]
["2009-10-01",9994234.6699999999,241.64,3.42,188,21,0,null,5375930.4823210305,120473.44345754891,29593.747167258458,1441914.2897883519,3029261.339361453,0,9997173.3020956423]
["2009-11-01",9668749.4299999997,414.34,0,188,21,0,null,5375930.4823210305,206575.75965155114,0,1441914.2897883519,3029261.339361453,0,10053681.871122386]
["2009-12-01",9993430.7300000004,630.9,0,190,21,0,null,5375930.4823210305,314545.17247710482,0,1457253.8035095045,3029261.339361453,0,10176990.797669092]
["2010-01-01",10564708.060000001,716.23,0,187,20,0,null,5375930.4823210305,357087.79344313964,0,1434244.5329277755,2885010.7993918601,0,10052273.608083807]
["2010-02-01",9623559.5700000003,650.25,0,193,19,0,null,5375930.4823210305,324192.42099102458,0,1480263.0740912335,2740760.2594222669,0,9921146.2368255556]
["2010-03-01",10034192.17,533.91,0.22,192,23,0,null,5375930.4823210305,266189.27411198453,1903.6913382446962,1472593.3172306572,3317762.4193006391,0,10434379.184302557]
["2010-04-01",9603845.4299999997,312.88,0.32,191,20,0,null,5375930.4823210305,155991.27209484318,2769.0055829013763,1464923.5603700809,2885010.7993918601,0,9884625.1197607163]
["2010-05-01",10306144.42,145.96,16.98,190,20,0,null,5375930.4823210305,72770.666309650071,146930.35874270427,1457253.8035095045,2885010.7993918601,0,9937896.1102747507]
["2010-06-01",10753297.439999999,30.95,59.64,193,22,0,null,5375930.4823210305,15430.611964124893,516073.41551324399,1480263.0740912335,3173511.8793310458,0,10561209.463220678]
["2010-07-01",10794881.210000001,6,109.95,189,21,0,null,5375930.4823210305,2991.3948880371358,951413.01200001978,1449584.0466489282,3029261.339361453,0,10809180.275219468]
["2010-08-01",10882484.279999999,11.72,76.849999999999994,192,21,0,null,5375930.4823210305,5843.1913479658724,664993.99701865856,1472593.3172306572,3029261.339361453,0,10548622.327279765]
["2010-09-01",10115723.83,72.849999999999994,24.35,192,21,0,null,5375930.4823210305,36320.519598917555,210704.01857390162,1472593.3172306572,3029261.339361453,0,10124809.67708596]
["2010-10-01",9906643.8599999994,241.64,3.42,192,20,0,null,5375930.4823210305,120473.44345754891,29593.747167258458,1472593.3172306572,2885010.7993918601,0,9883601.7895683553]
["2010-11-01",9794566.3000000007,414.34,0,193,22,0,null,5375930.4823210305,206575.75965155114,0,1480263.0740912335,3173511.8793310458,0,10236281.195394861]
["2010-12-01",9975886.3399999999,630.9,0,192,21,0,null,5375930.4823210305,314545.17247710482,0,1472593.3172306572,3029261.339361453,0,10192330.311390245]
["2011-01-01",10489464.5,716.23,0,191,20,0,null,5375930.4823210305,357087.79344313964,0,1464923.5603700809,2885010.7993918601,0,10082952.635526111]
["2011-02-01",9582988.7699999996,650.25,0,193,19,0,null,5375930.4823210305,324192.42099102458,0,1480263.0740912335,2740760.2594222669,0,9921146.2368255556]
["2011-03-01",10507121.9,533.91,0.22,192,23,0,null,5375930.4823210305,266189.27411198453,1903.6913382446962,1472593.3172306572,3317762.4193006391,0,10434379.184302557]
["2011-04-01",9565988.370000001,312.88,0.32,194,19,0,null,5375930.4823210305,155991.27209484318,2769.0055829013763,1487932.8309518099,2740760.2594222669,0,9763383.8503728509]
["2011-05-01",9950497.4600000009,145.96,16.98,194,21,0,null,5375930.4823210305,72770.666309650071,146930.35874270427,1487932.8309518099,3029261.339361453,0,10112825.677686648]
["2011-06-01",10402840.51,30.95,59.64,195,22,0,null,5375930.4823210305,15430.611964124893,516073.41551324399,1495602.5878123862,3173511.8793310458,0,10576548.976941831]
["2011-07-01",10822110.18,6,109.95,194,20,0,null,5375930.4823210305,2991.3948880371358,951413.01200001978,1487932.8309518099,2885010.7993918601,0,10703278.519552756]
["2011-08-01",11178847.140000001,11.72,76.849999999999994,194,22,0,null,5375930.4823210305,5843.1913479658724,664993.99701865856,1487932.8309518099,3173511.8793310458,0,10708212.380970512]
["2011-09-01",10387464.109999999,72.849999999999994,24.35,194,21,0,null,{"$f":"const","v":5375930.4823210305},{"$f":"HDD_Lond*C34","v":36320.519598917555},{"$f":"CDD_Lond*D34","v":210704.01857390162},{"$f":"GSgtCust*E34","v":1487932.8309518099},{"$f":"PeakDays*F34","v":3029261.339361453},{"$f":"RecessionD*G34","v":0},{"$f":"SUM(I34:N34)","v":10140149.190807112}]
["2011-10-01",10194048.25,241.64,3.42,195,20,0,null,5375930.4823210305,120473.44345754891,29593.747167258458,1495602.5878123862,2885010.7993918601,0,9906611.0601500832]
["2011-11-01",9920993.7899999991,414.34,0,195,22,0,null,5375930.4823210305,206575.75965155114,0,1495602.5878123862,3173511.8793310458,0,10251620.709116014]
["2011-12-01",9785536.8599999994,630.9,0,195,20,0,null,5375930.4823210305,314545.17247710482,0,1495602.5878123862,2885010.7993918601,0,10071089.042002382]
["2012-01-01",10452458.27,716.23,0,195,21,0,null,5375930.4823210305,357087.79344313964,0,1495602.5878123862,3029261.339361453,0,10257882.202938009]
["2012-02-01",9937260,650.25,0,195,20,0,null,5375930.4823210305,324192.42099102458,0,1495602.5878123862,2885010.7993918601,0,10080736.290516302]
["2012-03-01",10462882.84,533.91,0.22,195,22,0,null,5375930.4823210305,266189.27411198453,1903.6913382446962,1495602.5878123862,3173511.8793310458,0,10313137.914914692]
["2012-04-01",9640008.1400000006,312.88,0.32,195,19,0,null,5375930.4823210305,155991.27209484318,2769.0055829013763,1495602.5878123862,2740760.2594222669,0,9771053.6072334275]
["2012-05-01",10514005.859999999,145.96,16.98,195,22,0,null,5375930.4823210305,72770.666309650071,146930.35874270427,1495602.5878123862,3173511.8793310458,0,10264745.974516816]
["2012-06-01",10767424.07,30.95,59.64,194,21,0,null,5375930.4823210305,15430.611964124893,516073.41551324399,1487932.8309518099,3029261.339361453,0,10424628.680111663]
["2012-07-01",11168128.789999999,6,109.95,194,21,0,null,5375930.4823210305,2991.3948880371358,951413.01200001978,1487932.8309518099,3029261.339361453,0,10847529.059522349]
["2012-08-01",11224504.99,11.72,76.849999999999994,193,22,0,null,5375930.4823210305,5843.1913479658724,664993.99701865856,1480263.0740912335,3173511.8793310458,0,10700542.624109935]
["2012-09-01",10345375.720000001,72.849999999999994,24.35,193,19,0,null,5375930.4823210305,36320.519598917555,210704.01857390162,1480263.0740912335,2740760.2594222669,0,9843978.3540073484]
["2012-10-01",10172714.949999999,241.64,3.42,193,22,0,null,5375930.4823210305,120473.44345754891,29593.747167258458,1480263.0740912335,3173511.8793310458,0,10179772.626368117]
["2012-11-01",9950896.8000000007,414.34,0,193,22,0,null,5375930.4823210305,206575.75965155114,0,1480263.0740912335,3173511.8793310458,0,10236281.195394861]
["2012-12-01",9898195.3300000001,630.9,0,194,19,0,null,5375930.4823210305,314545.17247710482,0,1487932.8309518099,2740760.2594222669,0,9919168.7451722119]
["2013-01-01",10741569.73,716.23,0,194,22,0,null,5375930.4823210305,357087.79344313964,0,1487932.8309518099,3173511.8793310458,0,10394462.986047026]
["2013-02-01",9835940.1199999992,650.25,0,194,19,0,null,5375930.4823210305,324192.42099102458,0,1487932.8309518099,2740760.2594222669,0,9928815.9936861321]
["2013-03-01",10432388.58,533.91,0.22,194,20,0,null,5375930.4823210305,266189.27411198453,1903.6913382446962,1487932.8309518099,2885010.7993918601,0,10016967.078114931]
["2013-04-01",9763308.4700000007,312.88,0.32,166,21,0,null,5375930.4823210305,155991.27209484318,2769.0055829013763,1273179.6388556724,3029261.339361453,0,9837131.738215901]
["2013-05-01",9966896.9100000001,145.96,16.98,147,22,0,null,5375930.4823210305,72770.666309650071,146930.35874270427,1127454.258504722,3173511.8793310458,0,9896597.6452091523]
["2013-06-01",9797708.6400000006,30.95,59.64,142,20,0,null,5375930.4823210305,15430.611964124893,516073.41551324399,1089105.4742018403,2885010.7993918601,0,9881550.7833921015]
["2013-07-01",10075728.880000001,6,109.95,142,22,0,null,5375930.4823210305,2991.3948880371358,951413.01200001978,1089105.4742018403,3173511.8793310458,0,10592952.242741972]
["2013-08-01",10530715.739999995,11.72,76.849999999999994,141,21,0,null,5375930.4823210305,5843.1913479658724,664993.99701865856,1081435.717341264,3029261.339361453,0,10157464.727390371]
["2013-09-01",9892268.5600000024,72.849999999999994,24.35,141,20,0,null,5375930.4823210305,36320.519598917555,210704.01857390162,1081435.717341264,2885010.7993918601,0,9589401.5372269731]
["2013-10-01",9811835.0600000042,241.64,3.42,142,22,0,null,5375930.4823210305,120473.44345754891,29593.747167258458,1089105.4742018403,3173511.8793310458,0,9788615.0264787227]
["2013-11-01",9620672.120000001,414.34,0,142,21,0,null,5375930.4823210305,206575.75965155114,0,1089105.4742018403,3029261.339361453,0,9700873.0555358753]
["2013-12-01",9553363.3200000022,630.9,0,142,20,0,null,5375930.4823210305,314545.17247710482,0,1089105.4742018403,2885010.7993918601,0,9664591.9283918366]
["2014-01-01",null,716.23,0,142,22,0,null,5375930.4823210305,357087.79344313964,0,1089105.4742018403,3173511.8793310458,0,9995635.6292970553]
["2014-02-01",null,650.25,0,142,19,0,null,5375930.4823210305,324192.42099102458,0,1089105.4742018403,2740760.2594222669,0,9529988.6369361617]
["2014-03-01",null,533.91,0.22,142,21,0,null,5375930.4823210305,266189.27411198453,1903.6913382446962,1089105.4742018403,3029261.339361453,0,9762390.2613345534]
["2014-04-01",null,312.88,0.32,142,20,0,null,5375930.4823210305,155991.27209484318,2769.0055829013763,1089105.4742018403,2885010.7993918601,0,9508807.0335924756]
["2014-05-01",null,145.96,16.98,142,21,0,null,{"$f":"const","v":5375930.4823210305},{"$f":"HDD_Lond*C66","v":72770.666309650071},{"$f":"CDD_Lond*D66","v":146930.35874270427},{"$f":"GSgtCust*E66","v":1089105.4742018403},{"$f":"PeakDays*F66","v":3029261.339361453},{"$f":"RecessionD*G66","v":0},{"$f":"SUM(I66:N66)","v":9713998.320936678}]
["2014-06-01",null,30.95,59.64,142,21,0,null,5375930.4823210305,15430.611964124893,516073.41551324399,1089105.4742018403,3029261.339361453,0,10025801.323361693]
["2014-07-01",null,6,109.95,143,22,0,null,5375930.4823210305,2991.3948880371358,951413.01200001978,1096775.2310624167,3173511.8793310458,0,10600621.999602549]
["2014-08-01",null,11.72,76.849999999999994,143,20,0,null,5375930.4823210305,5843.1913479658724,664993.99701865856,1096775.2310624167,2885010.7993918601,0,10028553.701141931]
["2014-09-01",null,72.849999999999994,24.35,143,21,0,null,5375930.4823210305,36320.519598917555,210704.01857390162,1096775.2310624167,3029261.339361453,0,9748991.5909177195]
["2014-10-01",null,241.64,3.42,143,22,0,null,5375930.4823210305,120473.44345754891,29593.747167258458,1096775.2310624167,3173511.8793310458,0,9796284.7833392993]
["2014-11-01",null,414.34,0,143,20,0,null,5375930.4823210305,206575.75965155114,0,1096775.2310624167,2885010.7993918601,0,9564292.2724268585]
["2014-12-01",null,630.9,0,143,21,0,null,5375930.4823210305,314545.17247710482,0,1096775.2310624167,3029261.339361453,0,9816512.2252220046]
["2015-01-01",null,716.23,0,143,21,0,null,5375930.4823210305,357087.79344313964,0,1096775.2310624167,3029261.339361453,0,9859054.8461880405]
["2015-02-01",null,650.25,0,143,19,0,null,5375930.4823210305,324192.42099102458,0,1096775.2310624167,2740760.2594222669,0,9537658.3937967382]
["2015-03-01",null,533.91,0.22,143,22,0,null,5375930.4823210305,266189.27411198453,1903.6913382446962,1096775.2310624167,3173511.8793310458,0,9914310.5581647232]
["2015-04-01",null,312.88,0.32,143,20,0,null,5375930.4823210305,155991.27209484318,2769.0055829013763,1096775.2310624167,2885010.7993918601,0,9516476.7904530521]
["2015-05-01",null,145.96,16.98,143,20,0,null,5375930.4823210305,72770.666309650071,146930.35874270427,1096775.2310624167,2885010.7993918601,0,9577417.5378276631]
["2015-06-01",null,30.95,59.64,143,22,0,null,5375930.4823210305,15430.611964124893,516073.41551324399,1096775.2310624167,3173511.8793310458,0,10177721.620191863]
["2015-07-01",null,6,109.95,144,22,0,null,5375930.4823210305,2991.3948880371358,951413.01200001978,1104444.987922993,3173511.8793310458,0,10608291.756463125]
["2015-08-01",null,11.72,76.849999999999994,144,20,0,null,5375930.4823210305,5843.1913479658724,664993.99701865856,1104444.987922993,2885010.7993918601,0,10036223.458002508]
["2015-09-01",null,72.849999999999994,24.35,144,21,0,null,5375930.4823210305,36320.519598917555,210704.01857390162,1104444.987922993,3029261.339361453,0,9756661.3477782961]
["2015-10-01",null,241.64,3.42,144,21,0,null,5375930.4823210305,120473.44345754891,29593.747167258458,1104444.987922993,3029261.339361453,0,9659704.0002302844]
["2015-11-01",null,414.34,0,144,21,0,null,5375930.4823210305,206575.75965155114,0,1104444.987922993,3029261.339361453,0,9716212.5692570284]
["2015-12-01",null,630.9,0,144,21,0,null,5375930.4823210305,314545.17247710482,0,1104444.987922993,3029261.339361453,0,9824181.9820825811]

{"sheet":"Normalized Monthly Data Summ","index":8,"n_rows":85,"n_cols":4,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Date","Year","GSgt50_kWh_excl_Customer","Normalized Value"]
["2009-01-01",{"$f":"YEAR(A2)","v":2009},10041072.189999999,9498586.6597428769]
["2009-02-01",2009,9069400.7899999991,9169520.450491]
["2009-03-01",2009,9776173.8699999992,9546172.6148589831]
["2009-04-01",2009,9109897.5600000005,9148338.847147312]
["2009-05-01",2009,8687283.8300000001,9209279.594521923]
["2009-06-01",2009,9451017.7899999991,9809583.6768861245]
["2009-07-01",2009,9742232.9700000007,10945761.058328483]
["2009-08-01",2009,10469757.689999999,10373692.759867867]
["2009-09-01",2009,10182474.18,10094130.649643654]
["2009-10-01",2009,9994234.6699999999,9997173.3020956423]
["2009-11-01",2009,9668749.4299999997,10053681.871122386]
["2009-12-01",2009,9993430.7300000004,10176990.797669092]
["2010-01-01",2010,10564708.060000001,10052273.608083807]
["2010-02-01",2010,9623559.5700000003,9921146.2368255556]
["2010-03-01",2010,10034192.17,10434379.184302557]
["2010-04-01",2010,9603845.4299999997,9884625.1197607163]
["2010-05-01",2010,10306144.42,9937896.1102747507]
["2010-06-01",2010,10753297.439999999,10561209.463220678]
["2010-07-01",2010,10794881.210000001,10809180.275219468]
["2010-08-01",2010,10882484.279999999,10548622.327279765]
["2010-09-01",2010,10115723.83,10124809.67708596]
["2010-10-01",2010,9906643.8599999994,9883601.7895683553]
["2010-11-01",2010,9794566.3000000007,10236281.195394861]
["2010-12-01",2010,9975886.3399999999,10192330.311390245]
["2011-01-01",2011,10489464.5,10082952.635526111]
["2011-02-01",2011,9582988.7699999996,9921146.2368255556]
["2011-03-01",2011,10507121.9,10434379.184302557]
["2011-04-01",2011,9565988.370000001,9763383.8503728509]
["2011-05-01",2011,9950497.4600000009,10112825.677686648]
["2011-06-01",2011,10402840.51,10576548.976941831]
["2011-07-01",2011,10822110.18,10703278.519552756]
["2011-08-01",2011,11178847.140000001,10708212.380970512]
["2011-09-01",{"$f":"YEAR(A34)","v":2011},10387464.109999999,10140149.190807112]
["2011-10-01",2011,10194048.25,9906611.0601500832]
["2011-11-01",2011,9920993.7899999991,10251620.709116014]
["2011-12-01",2011,9785536.8599999994,10071089.042002382]
["2012-01-01",2012,10452458.27,10257882.202938009]
["2012-02-01",2012,9937260,10080736.290516302]
["2012-03-01",2012,10462882.84,10313137.914914692]
["2012-04-01",2012,9640008.1400000006,9771053.6072334275]
["2012-05-01",2012,10514005.859999999,10264745.974516816]
["2012-06-01",2012,10767424.07,10424628.680111663]
["2012-07-01",2012,11168128.789999999,10847529.059522349]
["2012-08-01",2012,11224504.99,10700542.624109935]
["2012-09-01",2012,10345375.720000001,9843978.3540073484]
["2012-10-01",2012,10172714.949999999,10179772.626368117]
["2012-11-01",2012,9950896.8000000007,10236281.195394861]
["2012-12-01",2012,9898195.3300000001,9919168.7451722119]
["2013-01-01",2013,10741569.73,10394462.986047026]
["2013-02-01",2013,9835940.1199999992,9928815.9936861321]
["2013-03-01",2013,10432388.58,10016967.078114931]
["2013-04-01",2013,9763308.4700000007,9837131.738215901]
["2013-05-01",2013,9966896.9100000001,9896597.6452091523]
["2013-06-01",2013,9797708.6400000006,9881550.7833921015]
["2013-07-01",2013,10075728.880000001,10592952.242741972]
["2013-08-01",2013,10530715.739999995,10157464.727390371]
["2013-09-01",2013,9892268.5600000024,9589401.5372269731]
["2013-10-01",2013,9811835.0600000042,9788615.0264787227]
["2013-11-01",2013,9620672.120000001,9700873.0555358753]
["2013-12-01",2013,9553363.3200000022,9664591.9283918366]
["2014-01-01",2014,null,9995635.6292970553]
["2014-02-01",2014,null,9529988.6369361617]
["2014-03-01",2014,null,9762390.2613345534]
["2014-04-01",2014,null,9508807.0335924756]
["2014-05-01",{"$f":"YEAR(A66)","v":2014},null,9713998.320936678]
["2014-06-01",2014,null,10025801.323361693]
["2014-07-01",2014,null,10600621.999602549]
["2014-08-01",2014,null,10028553.701141931]
["2014-09-01",2014,null,9748991.5909177195]
["2014-10-01",2014,null,9796284.7833392993]
["2014-11-01",2014,null,9564292.2724268585]
["2014-12-01",2014,null,9816512.2252220046]
["2015-01-01",2015,null,9859054.8461880405]
["2015-02-01",2015,null,9537658.3937967382]
["2015-03-01",2015,null,9914310.5581647232]
["2015-04-01",2015,null,9516476.7904530521]
["2015-05-01",2015,null,9577417.5378276631]
["2015-06-01",2015,null,10177721.620191863]
["2015-07-01",2015,null,10608291.756463125]
["2015-08-01",2015,null,10036223.458002508]
["2015-09-01",2015,null,9756661.3477782961]
["2015-10-01",2015,null,9659704.0002302844]
["2015-11-01",2015,null,9716212.5692570284]
["2015-12-01",2015,null,9824181.9820825811]

{"sheet":"NormalizedAnnualDataSumm","index":9,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Annual Actual vs. Normalized GSgt50_kWh_excl_Customer"]
[null,"GSgt50_kWh_excl_Customer ","Normalized Value "]
[2009,116185725.7,118022912.28237535]
[2010,122355932.91000001,122586355.29840672]
[2011,122787901.83999999,122672197.46425441]
[2012,124533855.75999999,122839457.27480574]
[2013,120022396.13000001,119449424.74243098]
[2014,null,118091877.77810898]
[2015,null,118183914.8604359]

{"sheet":"NormalizedAnnualDataSumm2","index":10,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Annual Actual vs. Normalized GSgt50_kWh_excl_Customer"]
[null,"GSgt50_kWh_excl_Customer ","% Change","Normalized Value ","% Change"]
[2009,116185725.7,null,118022912.28237535]
[2010,122355932.91000001,{"$f":"B5/B4-1","v":5.3106413656458296E-2},122586355.29840672,{"$f":"D5/D4-1","v":3.8665738099337155E-2}]
[2011,122787901.83999999,{"$f":"B6/B5-1","v":3.5304289683910639E-3},122672197.46425441,{"$f":"D6/D5-1","v":7.0025873302714814E-4}]
[2012,124533855.75999999,1.4219266669081909E-2,122839457.27480574,1.3634695881279413E-3]
[2013,120022396.13000001,-3.622677224974391E-2,119449424.74243098,-2.7597260746527685E-2]
[2014,null,null,118091877.77810898,-1.1365035597695639E-2]
[2015,null,null,118183914.8604359,7.7936843802128841E-4]