{"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":10,"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","GSlt50kWh",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","GSlt50kWh","HDD_Lond","CDD_Lond","MonthDays","Shoulder1","GSltCust"]
["2009-01-01",3760655,849.6,0,31,0,1674]
["2009-02-01",3270545,612.70000000000005,0,28,0,1675]
["2009-03-01",3315389,533.29999999999995,0,31,1,1681]
["2009-04-01",2905547,307,3.2,30,1,1684]
["2009-05-01",2858350,156.9,3.1,31,1,1685]
["2009-06-01",2907459,49.7,35.5,30,0,1685]
["2009-07-01",3152443,20.2,29.4,31,0,1685]
["2009-08-01",3252321,17.899999999999999,71.900000000000006,31,0,1685]
["2009-09-01",2873707,71.2,15.9,30,1,1685]
["2009-10-01",2845616,301.2,0,31,1,1685]
["2009-11-01",2894664,356.7,0,30,1,1685]
["2009-12-01",3352350,637.29999999999995,0,31,0,1674]
["2010-01-01",3441514,733.1,0,31,0,1674]
["2010-02-01",3109778,633.4,0,28,0,1674]
["2010-03-01",3063802,450.2,0,31,1,1674]
["2010-04-01",2760595,236.4,0,30,1,1675]
["2010-05-01",2903907,121.1,34.9,31,1,1672]
["2010-06-01",3063123,23.6,57.5,30,0,1669]
["2010-07-01",3367995,5.6,129.69999999999999,31,0,1666]
["2010-08-01",3264268,6,121.7,31,0,1664]
["2010-09-01",2788591,87.9,24.1,30,1,1672]
["2010-10-01",2730965,239.5,0,31,1,1668]
["2010-11-01",2916635,413.6,0,30,1,1675]
["2010-12-01",3326888,713.5,0,31,0,1667]
["2011-01-01",3480300,798.8,0,31,0,1665]
["2011-02-01",3140091,677.8,0,28,0,1677]
["2011-03-01",3198659,599.6,0,31,1,1677]
["2011-04-01",2806404,330.4,0,30,1,1675]
["2011-05-01",2777768,126.4,17.399999999999999,31,1,1674]
["2011-06-01",2996203,27,39.6,30,0,1678]
["2011-07-01",3463081,0,160.9,31,0,1676]
["2011-08-01",3314369,1.5,82.9,31,0,1676]
["2011-09-01",2758253,71.900000000000006,29,30,1,1673]
["2011-10-01",2745121,234.6,0,31,1,1670]
["2011-11-01",2834235,347.9,0,30,1,1667]
["2011-12-01",3149387,548.4,0,31,0,1664]
["2012-01-01",3281279,644.79999999999995,0,31,0,1666]
["2012-02-01",3046678,553,0,29,0,1667]
["2012-03-01",2970504,331.1,2.2000000000000002,31,1,1667]
["2012-04-01",2680293,334.6,0,30,1,1667]
["2012-05-01",2807502,87.2,28.5,31,1,1667]
["2012-06-01",3105876,28.2,81.7,30,0,1669]
["2012-07-01",3478171,0,161,31,0,1654]
["2012-08-01",3240724,7.8,79.599999999999994,31,0,1660]
["2012-09-01",2834667,103.4,27.7,30,1,1651]
["2012-10-01",2761045,250.5,0.7,31,1,1659]
["2012-11-01",2908932,420.4,0,30,1,1659]
["2012-12-01",3144594,535.9,0,31,0,1658]
["2013-01-01",3333526.669999985,657.4,0,31,0,1664]
["2013-02-01",3075889.3099999987,657,0,28,0,1663]
["2013-03-01",3220272.9200000064,581.9,0,31,1,1663]
["2013-04-01",2945784.670000005,362.2,0,30,1,1693]
["2013-05-01",3078779.2099999925,122.2,27,31,1,1713]
["2013-06-01",3203064.9200000046,41.1,52.7,30,0,1714]
["2013-07-01",3624763.5200000121,7.1,108.8,31,0,1715]
["2013-08-01",3384970.7899999958,18.399999999999999,57.5,31,0,1716]
["2013-09-01",3137884.1800000072,94.9,26,30,1,1718]
["2013-10-01",3072349.9899999904,184,2.6,31,1,1719]
["2013-11-01",3250425.949999996,492.1,0,30,1,1721]
["2013-12-01",3647170.1100000041,675.7,0,31,0,1720]

{"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: GSlt50kWh"]
[]
[null,"coefficient","std. error","t-ratio","p-value"]
["const",-9137273.0194448903,1084773.29285748,-8.4232097891862594,2.05878870680469E-11]
["HDD_Lond",872.87828692234302,68.137709787833799,12.810502284862499,5.28972107996985E-18]
["CDD_Lond",4766.7594575903904,473.93038627338501,10.057931704004901,5.5717921489836203E-14]
["MonthDays",77001.9106060333,13125.9078496195,5.8664064602788697,2.7902901367400698E-7]
["Shoulder1",-166600.13966288301,28628.687376367499,-5.8193425871284896,3.3173071627414001E-7]
["GSltCust",5714.5017888762304,606.39290230720201,9.4237610089658208,5.3537460089682999E-13]
[]
["Mean dependent var",3100435.42066667,"S.D. dependent var",257743.26503208]
["Sum squared resid",342993107039.21899,"S.E. of regression",79697.705139043901]
["R-squared",0.91248978936660796,"Adjusted R-squared",0.90438699208573803]
["F(5, 54)",112.61416986464,"P-value(F)",2.69777592520889E-27]
["Log-likelihood",-759.13526076006303,"Akaike criterion",1530.2705215201299]
["Schwarz criterion",1542.83658889346,"Hannan-Quinn",1535.18580127727]
["rho",8.0402869211171804E-2,"Durbin-Watson",1.7177009662293701]
["Theil's U",0.27628999999999998]

{"sheet":"Predicted Monthly Data","index":3,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Date","GSlt50kWh","HDD_Lond","CDD_Lond","MonthDays","Shoulder1","GSltCust",null,"Const","HDD_Lond","CDD_Lond","MonthDays","Shoulder1","GSltCust","Predicted Value"]
["2009-01-01",3760655,849.6,0,31,0,1674,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C2","v":741597.3925692226},{"$f":"CDD_Lond*D2","v":0},{"$f":"MonthDays*E2","v":2387059.2287870324},{"$f":"Shoulder1*F2","v":0},{"$f":"GSltCust*G2","v":9566075.9945788104},{"$f":"SUM(I2:N2)","v":3557459.5964901764}]
["2009-02-01",3270545,612.70000000000005,0,28,0,1675,null,-9137273.0194448903,534812.52639731963,0,2156053.4969689324,0,9571790.4963676855,3125383.5002890471]
["2009-03-01",3315389,533.29999999999995,0,31,1,1681,null,-9137273.0194448903,465505.99041568552,0,2387059.2287870324,-166600.13966288301,9606077.5071009435,3154769.5671958877]
["2009-04-01",2905547,307,3.2,30,1,1684,null,-9137273.0194448903,267973.63408515928,15253.63026428925,2310057.3181809988,-166600.13966288301,9623221.0124675725,2912632.4358902471]
["2009-05-01",2858350,156.9,3.1,31,1,1685,null,-9137273.0194448903,136954.60321811563,14776.95431853021,2387059.2287870324,-166600.13966288301,9628935.5142564476,2863853.1414723536]
["2009-06-01",2907459,49.7,35.5,30,0,1685,null,-9137273.0194448903,43382.05086004045,169219.96074445886,2310057.3181809988,0,9628935.5142564476,3014321.8245970551]
["2009-07-01",3152443,20.2,29.4,31,0,1685,null,-9137273.0194448903,17632.141395831328,140142.72805315748,2387059.2287870324,0,9628935.5142564476,3036496.5930475798]
["2009-08-01",3252321,17.899999999999999,71.900000000000006,31,0,1685,null,-9137273.0194448903,15624.521335909938,342730.00500074908,2387059.2287870324,0,9628935.5142564476,3237076.2499352489]
["2009-09-01",2873707,71.2,15.9,30,1,1685,null,-9137273.0194448903,62148.934028870826,75791.475375687209,2310057.3181809988,-166600.13966288301,9628935.5142564476,2773060.0827342318]
["2009-10-01",2845616,301.2,0,31,1,1685,null,-9137273.0194448903,262910.94002100971,0,2387059.2287870324,-166600.13966288301,9628935.5142564476,2975032.523956717]
["2009-11-01",2894664,356.7,0,30,1,1685,null,-9137273.0194448903,311355.68494519976,0,2310057.3181809988,-166600.13966288301,9628935.5142564476,2946475.3582748724]
["2009-12-01",3352350,637.29999999999995,0,31,0,1674,null,-9137273.0194448903,556285.33225560922,0,2387059.2287870324,0,9566075.9945788104,3372147.5361765623]
["2010-01-01",3441514,733.1,0,31,0,1674,null,-9137273.0194448903,639907.0721427697,0,2387059.2287870324,0,9566075.9945788104,3455769.2760637235]
["2010-02-01",3109778,633.4,0,28,0,1674,null,-9137273.0194448903,552881.10693661205,0,2156053.4969689324,0,9566075.9945788104,3137737.5790394638]
["2010-03-01",3063802,450.2,0,31,1,1674,null,-9137273.0194448903,392969.80477243883,0,2387059.2287870324,-166600.13966288301,9566075.9945788104,3042231.8690305082]
["2010-04-01",2760595,236.4,0,30,1,1675,null,-9137273.0194448903,206348.42702844189,0,2310057.3181809988,-166600.13966288301,9571790.4963676855,2784323.0824693525]
["2010-05-01",2903907,121.1,34.9,31,1,1672,null,-9137273.0194448903,105705.56054629573,166359.90506990461,2387059.2287870324,-166600.13966288301,9554646.9910010565,2909898.5262965159]
["2010-06-01",3063123,23.6,57.5,30,0,1669,null,-9137273.0194448903,20599.927571367298,274088.66881144745,2310057.3181809988,0,9537503.4856344294,3004976.3807533532]
["2010-07-01",3367995,5.6,129.69999999999999,31,0,1666,null,-9137273.0194448903,4888.1184067651202,618248.70164947363,2387059.2287870324,0,9520359.9802678004,3393283.0096661821]
["2010-08-01",3264268,6,121.7,31,0,1664,null,-9137273.0194448903,5237.2697215340577,580114.62598875049,2387059.2287870324,0,9508930.9766900465,3344069.0817424729]
["2010-09-01",2788591,87.9,24.1,30,1,1672,null,-9137273.0194448903,76726.001420473956,114878.90292792842,2310057.3181809988,-166600.13966288301,9554646.9910010565,2752436.0544226831]
["2010-10-01",2730965,239.5,0,31,1,1668,null,-9137273.0194448903,209054.34971790115,0,2387059.2287870324,-166600.13966288301,9531788.9838455524,2824029.4032427138]
["2010-11-01",2916635,413.6,0,30,1,1675,null,-9137273.0194448903,361022.45947108109,0,2310057.3181809988,-166600.13966288301,9571790.4963676855,2938997.1149119912]
["2010-12-01",3326888,713.5,0,31,0,1667,null,-9137273.0194448903,622798.65771909175,0,2387059.2287870324,0,9526074.4820566755,3398659.3491179105]
["2011-01-01",3480300,798.8,0,31,0,1665,null,-9137273.0194448903,697255.17559356755,0,2387059.2287870324,0,9514645.4784789234,3461686.863414634]
["2011-02-01",3140091,677.8,0,28,0,1677,null,-9137273.0194448903,591636.90287596406,0,2156053.4969689324,0,9583219.4999454375,3193636.8803454433]
["2011-03-01",3198659,599.6,0,31,1,1677,null,-9137273.0194448903,523377.82083863689,0,2387059.2287870324,-166600.13966288301,9583219.4999454375,3189783.3904633345]
["2011-04-01",2806404,330.4,0,30,1,1675,null,-9137273.0194448903,288398.98599914211,0,2310057.3181809988,-166600.13966288301,9571790.4963676855,2866373.6414400535]
["2011-05-01",2777768,126.4,17.399999999999999,31,1,1674,null,-9137273.0194448903,110331.81546698416,82941.614562072791,2387059.2287870324,-166600.13966288301,9566075.9945788104,2842535.4942871267]
["2011-06-01",2996203,27,39.6,30,0,1678,null,-9137273.0194448903,23567.71374690326,188763.67452057946,2310057.3181809988,0,9588934.0017343145,2974049.6887379065]
["2011-07-01",3463081,0,160.9,31,0,1676,null,-9137273.0194448903,0,766971.59672629379,2387059.2287870324,0,9577504.9981565624,3594262.8042249978]
["2011-08-01",3314369,1.5,82.9,31,0,1676,null,-9137273.0194448903,1309.3174303835144,395164.35903424339,2387059.2287870324,0,9577504.9981565624,3223764.8839633316]
["2011-09-01",2758253,71.900000000000006,29,30,1,1673,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C34","v":62759.948829716472},{"$f":"CDD_Lond*D34","v":138236.02427012133},{"$f":"MonthDays*E34","v":2310057.3181809988},{"$f":"Shoulder1*F34","v":-166600.13966288301},{"$f":"GSltCust*G34","v":9560361.4927899335},{"$f":"SUM(I34:N34)","v":2767541.6249629958}]
["2011-10-01",2745121,234.6,0,31,1,1670,null,-9137273.0194448903,204777.24611198166,0,2387059.2287870324,-166600.13966288301,9543217.9874233045,2831181.3032145454]
["2011-11-01",2834235,347.9,0,30,1,1667,null,-9137273.0194448903,303674.35602028313,0,2310057.3181809988,-166600.13966288301,9526074.4820566755,2835932.9971501837]
["2011-12-01",3149387,548.4,0,31,0,1664,null,-9137273.0194448903,478686.4525482129,0,2387059.2287870324,0,9508930.9766900465,3237403.6385804024]
["2012-01-01",3281279,644.79999999999995,0,31,0,1666,null,-9137273.0194448903,562831.91940752673,0,2387059.2287870324,0,9520359.9802678004,3332978.109017469]
["2012-02-01",3046678,553,0,29,0,1667,null,-9137273.0194448903,482701.69266805571,0,2233055.4075749656,0,9526074.4820566755,3104558.5628548069]
["2012-03-01",2970504,331.1,2.2000000000000002,31,1,1667,null,-9137273.0194448903,289010.00079998781,10486.87080669886,2387059.2287870324,-166600.13966288301,9526074.4820566755,2908757.4233426219]
["2012-04-01",2680293,334.6,0,30,1,1667,null,-9137273.0194448903,292065.07480421598,0,2310057.3181809988,-166600.13966288301,9526074.4820566755,2824323.7159341173]
["2012-05-01",2807502,87.2,28.5,31,1,1667,null,-9137273.0194448903,76114.986619628311,135852.64454132612,2387059.2287870324,-166600.13966288301,9526074.4820566755,2821228.1828968907]
["2012-06-01",3105876,28.2,81.7,30,0,1669,null,-9137273.0194448903,24615.167691210074,389444.24768513493,2310057.3181809988,0,9537503.4856344294,3124347.1997468825]
["2012-07-01",3478171,0,161,31,0,1654,null,-9137273.0194448903,0,767448.27267205284,2387059.2287870324,0,9451785.9588012844,3469020.4408154786]
["2012-08-01",3240724,7.8,79.599999999999994,31,0,1660,null,-9137273.0194448903,6808.450637994275,379434.05282419507,2387059.2287870324,0,9486072.9695345424,3122101.6823388748]
["2012-09-01",2834667,103.4,27.7,30,1,1651,null,-9137273.0194448903,90255.614867770273,132039.23697525382,2310057.3181809988,-166600.13966288301,9434642.4534346573,2663121.4643509081]
["2012-10-01",2761045,250.5,0.7,31,1,1659,null,-9137273.0194448903,218656.01087404691,3336.7316203132732,2387059.2287870324,-166600.13966288301,9480358.4677456655,2785537.2799192844]
["2012-11-01",2908932,420.4,0,30,1,1659,null,-9137273.0194448903,366958.03182215296,0,2310057.3181809988,-166600.13966288301,9480358.4677456655,2853500.6586410431]
["2012-12-01",3144594,535.9,0,31,0,1658,null,-9137273.0194448903,467775.47396168363,0,2387059.2287870324,0,9474643.9659567904,3192205.6492606159]
["2013-01-01",3333526.669999985,657.4,0,31,0,1664,null,-9137273.0194448903,573830.18582274823,0,2387059.2287870324,0,9508930.9766900465,3332547.3718549367]
["2013-02-01",3075889.3099999987,657,0,28,0,1663,null,-9137273.0194448903,573481.03450797941,0,2156053.4969689324,0,9503216.4749011714,3095477.9869331922]
["2013-03-01",3220272.9200000064,581.9,0,31,1,1663,null,-9137273.0194448903,507927.87516011141,0,2387059.2287870324,-166600.13966288301,9503216.4749011714,3094330.4197405418]
["2013-04-01",2945784.670000005,362.2,0,30,1,1693,null,-9137273.0194448903,316156.51552327262,0,2310057.3181809988,-166600.13966288301,9674651.5285674576,2996992.2031639563]
["2013-05-01",3078779.2099999925,122.2,27,31,1,1713,null,-9137273.0194448903,106665.72666191032,128702.50535494054,2387059.2287870324,-166600.13966288301,9788941.5643449835,3107495.866041095]
["2013-06-01",3203064.9200000046,41.1,52.7,30,0,1714,null,-9137273.0194448903,35875.297592508301,251208.22341501358,2310057.3181809988,0,9794656.0661338586,3254523.8858774882]
["2013-07-01",3624763.5200000121,7.1,108.8,31,0,1715,null,-9137273.0194448903,6197.4358371486351,518623.42898583447,2387059.2287870324,0,9800370.5679227356,3574977.64208786]
["2013-08-01",3384970.7899999958,18.399999999999999,57.5,31,0,1716,null,-9137273.0194448903,16060.96047937111,274088.66881144745,2387059.2287870324,0,9806085.0697116107,3346020.9083445724]
["2013-09-01",3137884.1800000072,94.9,26,30,1,1718,null,-9137273.0194448903,82836.149428930352,123935.74589735015,2310057.3181809988,-166600.13966288301,9817514.0732893646,3030470.1276888708]
["2013-10-01",3072349.9899999904,184,2.6,31,1,1719,null,-9137273.0194448903,160609.60479371113,12393.574589735015,2387059.2287870324,-166600.13966288301,9823228.5750782397,3079417.8241409445]
["2013-11-01",3250425.949999996,492.1,0,30,1,1721,null,-9137273.0194448903,429543.40499448503,0,2310057.3181809988,-166600.13966288301,9834657.5786559917,3270385.1427237028]
["2013-12-01",3647170.1100000041,675.7,0,31,0,1720,null,-9137273.0194448903,589803.85847342724,0,2387059.2287870324,0,9828943.0768671166,3668533.1446826868]

{"sheet":"Predicted Monthly Data Summ","index":4,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Date","Year","GSlt50kWh","Predicted Value","Absolute % Error"]
["2009-01-01",{"$f":"YEAR(A2)","v":2009},3760655,3557459.5964901764,{"$f":"ABS(D2-C2)/C2","v":5.4031918245577862E-2}]
["2009-02-01",2009,3270545,3125383.5002890471,4.4384498519651268E-2]
["2009-03-01",2009,3315389,3154769.5671958877,4.844663259850121E-2]
["2009-04-01",2009,2905547,2912632.4358902471,2.4385893225086753E-3]
["2009-05-01",2009,2858350,2863853.1414723536,1.9252860819541345E-3]
["2009-06-01",2009,2907459,3014321.8245970551,3.6754714201319809E-2]
["2009-07-01",2009,3152443,3036496.5930475798,3.6779858336033436E-2]
["2009-08-01",2009,3252321,3237076.2499352489,4.6873448422683778E-3]
["2009-09-01",2009,2873707,2773060.0827342318,3.5023374778906886E-2]
["2009-10-01",2009,2845616,2975032.523956717,4.5479264931289745E-2]
["2009-11-01",2009,2894664,2946475.3582748724,1.7898919624133376E-2]
["2009-12-01",2009,3352350,3372147.5361765623,5.9055695785232174E-3]
["2010-01-01",2010,3441514,3455769.2760637235,4.1421525711426684E-3]
["2010-02-01",2010,3109778,3137737.5790394638,8.9908601319656171E-3]
["2010-03-01",2010,3063802,3042231.8690305082,7.0403149320653838E-3]
["2010-04-01",2010,2760595,2784323.0824693525,8.5952783618576875E-3]
["2010-05-01",2010,2903907,2909898.5262965159,2.0632638361063041E-3]
["2010-06-01",2010,3063123,3004976.3807533532,1.8982789540820517E-2]
["2010-07-01",2010,3367995,3393283.0096661821,7.5083275557659979E-3]
["2010-08-01",2010,3264268,3344069.0817424729,2.4446853549547079E-2]
["2010-09-01",2010,2788591,2752436.0544226831,1.2965309569354889E-2]
["2010-10-01",2010,2730965,2824029.4032427138,3.4077479294942911E-2]
["2010-11-01",2010,2916635,2938997.1149119912,7.6670940697040153E-3]
["2010-12-01",2010,3326888,3398659.3491179105,2.1573118517338272E-2]
["2011-01-01",2011,3480300,3461686.863414634,5.3481414203850192E-3]
["2011-02-01",2011,3140091,3193636.8803454433,1.7052333943647895E-2]
["2011-03-01",2011,3198659,3189783.3904633345,2.7747907909738087E-3]
["2011-04-01",2011,2806404,2866373.6414400535,2.1368855460601351E-2]
["2011-05-01",2011,2777768,2842535.4942871267,2.3316380017023269E-2]
["2011-06-01",2011,2996203,2974049.6887379065,7.3937951674480952E-3]
["2011-07-01",2011,3463081,3594262.8042249978,3.7880085457139973E-2]
["2011-08-01",2011,3314369,3223764.8839633316,2.7336761850194839E-2]
["2011-09-01",{"$f":"YEAR(A34)","v":2011},2758253,2767541.6249629958,{"$f":"ABS(D34-C34)/C34","v":3.3675754047927295E-3}]
["2011-10-01",2011,2745121,2831181.3032145454,3.1350276805483385E-2]
["2011-11-01",2011,2834235,2835932.9971501837,5.9910245628314355E-4]
["2011-12-01",2011,3149387,3237403.6385804024,2.7947228644940224E-2]
["2012-01-01",2012,3281279,3332978.109017469,1.5755779687575786E-2]
["2012-02-01",2012,3046678,3104558.5628548069,1.8997925890037244E-2]
["2012-03-01",2012,2970504,2908757.4233426219,2.0786565733416994E-2]
["2012-04-01",2012,2680293,2824323.7159341173,5.3736929482753312E-2]
["2012-05-01",2012,2807502,2821228.1828968907,4.8891088579422837E-3]
["2012-06-01",2012,3105876,3124347.1997468825,5.9471787498543219E-3]
["2012-07-01",2012,3478171,3469020.4408154786,2.6308537402334265E-3]
["2012-08-01",2012,3240724,3122101.6823388748,3.660364710512997E-2]
["2012-09-01",2012,2834667,2663121.4643509081,6.0516997463579296E-2]
["2012-10-01",2012,2761045,2785537.2799192844,8.8706558275161752E-3]
["2012-11-01",2012,2908932,2853500.6586410431,1.9055564502352369E-2]
["2012-12-01",2012,3144594,3192205.6492606159,1.5140793775163322E-2]
["2013-01-01",2013,3333526.669999985,3332547.3718549367,2.9377240442126859E-4]
["2013-02-01",2013,3075889.3099999987,3095477.9869331922,6.3684596417397047E-3]
["2013-03-01",2013,3220272.9200000064,3094330.4197405418,3.910926290665586E-2]
["2013-04-01",2013,2945784.670000005,2996992.2031639563,1.7383325293749714E-2]
["2013-05-01",2013,3078779.2099999925,3107495.866041095,9.3272865906816865E-3]
["2013-06-01",2013,3203064.9200000046,3254523.8858774882,1.6065539463834384E-2]
["2013-07-01",2013,3624763.5200000121,3574977.64208786,1.3734931296194441E-2]
["2013-08-01",2013,3384970.7899999958,3346020.9083445724,1.1506711304715124E-2]
["2013-09-01",2013,3137884.1800000072,3030470.1276888708,3.4231362966091416E-2]
["2013-10-01",2013,3072349.9899999904,3079417.8241409445,2.3004651696449776E-3]
["2013-11-01",2013,3250425.949999996,3270385.1427237028,6.140485287384213E-3]
["2013-12-01",2013,3647170.1100000041,3668533.1446826868,5.8574275502281661E-3]
[null,null,null,null,{"$f":"AVERAGE(E2:E61)","v":1.8713252851684809E-2}]

{"sheet":"PredictedAnnualDataSumm","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Annual Predicted vs. Actual GSlt50kWh"]
[null,"GSlt50kWh ","Predicted Value ","Absolute % Error  "]
[2009,37389046,36968708.410059981,1.1242265714402528E-2]
[2010,36738061,36986410.726756871,6.760011824164339E-3]
[2011,36663871,37018153.210784957,9.6629788705332505E-3]
[2012,36260265,36201680.369118996,1.615670235201095E-3]
[2013,38974882.240000002,38851172.523279846,3.1740882745552681E-3]
[null,null,"Mean Absolute Percentage Error (Annual)",{"$f":"AVERAGE(D4:D8)","v":6.4910029837712963E-3}]
[null,null,"Mean Absolute Percentage Error (Monthly)",1.8713252851684809E-2]

{"sheet":"PredictedAnnualDataSumm2","index":6,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"GSlt50kWh ","Predicted Value "]
[2009,37389046,36968708.410059981]
[2010,36738061,36986410.726756871]
[2011,36663871,37018153.210784957]
[2012,36260265,36201680.369118996]
[2013,38974882.240000002,38851172.523279846]

{"sheet":"Normalized Monthly Data","index":7,"n_rows":85,"n_cols":15,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Date","GSlt50kWh","HDD_Lond","CDD_Lond","MonthDays","Shoulder1","GSltCust",null,"Const","HDD_Lond","CDD_Lond","MonthDays","Shoulder1","GSltCust","Normalized Value"]
["2009-01-01",3760655,716.23,0,31,0,1674,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C2","v":625181.61544238974},{"$f":"CDD_Lond*D2","v":0},{"$f":"MonthDays*E2","v":2387059.2287870324},{"$f":"Shoulder1*F2","v":0},{"$f":"GSltCust*G2","v":9566075.9945788104},{"$f":"SUM(I2:N2)","v":3441043.8193633426}]
["2009-02-01",3270545,650.25,0,28,0,1675,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C3","v":567589.10607125354},{"$f":"CDD_Lond*D3","v":0},{"$f":"MonthDays*E3","v":2156053.4969689324},{"$f":"Shoulder1*F3","v":0},{"$f":"GSltCust*G3","v":9571790.4963676855},3158160.0799629819]
["2009-03-01",3315389,533.91,0.22,31,1,1681,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C4","v":466038.44617070811},{"$f":"CDD_Lond*D4","v":1048.687080669886},{"$f":"MonthDays*E4","v":2387059.2287870324},{"$f":"Shoulder1*F4","v":-166600.13966288301},{"$f":"GSltCust*G4","v":9606077.5071009435},3156350.7100315811]
["2009-04-01",2905547,312.88,0.32,30,1,1684,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C5","v":273106.15841226268},{"$f":"CDD_Lond*D5","v":1525.363026428925},{"$f":"MonthDays*E5","v":2310057.3181809988},{"$f":"Shoulder1*F5","v":-166600.13966288301},{"$f":"GSltCust*G5","v":9623221.0124675725},2904036.6929794895]
["2009-05-01",2858350,145.96,16.98,31,1,1685,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C6","v":127405.31475918519},{"$f":"CDD_Lond*D6","v":80939.575589884829},{"$f":"MonthDays*E6","v":2387059.2287870324},{"$f":"Shoulder1*F6","v":-166600.13966288301},{"$f":"GSltCust*G6","v":9628935.5142564476},2920466.4742847765]
["2009-06-01",2907459,30.95,59.64,30,0,1685,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C7","v":27015.582980246516},{"$f":"CDD_Lond*D7","v":284289.53405069088},{"$f":"MonthDays*E7","v":2310057.3181809988},{"$f":"Shoulder1*F7","v":0},{"$f":"GSltCust*G7","v":9628935.5142564476},3113024.9300234932]
["2009-07-01",3152443,6,109.95,31,0,1685,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C8","v":5237.2697215340577},{"$f":"CDD_Lond*D8","v":524105.20236206346},{"$f":"MonthDays*E8","v":2387059.2287870324},{"$f":"Shoulder1*F8","v":0},{"$f":"GSltCust*G8","v":9628935.5142564476},3408064.1956821885]
["2009-08-01",3252321,11.72,76.849999999999994,31,0,1685,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C9","v":10230.13352272986},{"$f":"CDD_Lond*D9","v":366325.46431582147},{"$f":"MonthDays*E9","v":2387059.2287870324},{"$f":"Shoulder1*F9","v":0},{"$f":"GSltCust*G9","v":9628935.5142564476},3255277.3214371428]
["2009-09-01",2873707,72.849999999999994,24.35,30,1,1685,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C10","v":63589.183202292683},{"$f":"CDD_Lond*D10","v":116070.59279232602},{"$f":"MonthDays*E10","v":2310057.3181809988},{"$f":"Shoulder1*F10","v":-166600.13966288301},{"$f":"GSltCust*G10","v":9628935.5142564476},2814779.4493242921]
["2009-10-01",2845616,241.64,3.42,31,1,1685,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C11","v":210922.30925191496},{"$f":"CDD_Lond*D11","v":16302.317344959134},{"$f":"MonthDays*E11","v":2387059.2287870324},{"$f":"Shoulder1*F11","v":-166600.13966288301},{"$f":"GSltCust*G11","v":9628935.5142564476},2939346.2105325824]
["2009-11-01",2894664,414.34,0,30,1,1685,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C12","v":361668.38940340356},{"$f":"CDD_Lond*D12","v":0},{"$f":"MonthDays*E12","v":2310057.3181809988},{"$f":"Shoulder1*F12","v":-166600.13966288301},{"$f":"GSltCust*G12","v":9628935.5142564476},2996788.0627330756]
["2009-12-01",3352350,630.9,0,31,0,1674,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C13","v":550698.91121930617},{"$f":"CDD_Lond*D13","v":0},{"$f":"MonthDays*E13","v":2387059.2287870324},{"$f":"Shoulder1*F13","v":0},{"$f":"GSltCust*G13","v":9566075.9945788104},3366561.1151402593]
["2010-01-01",3441514,716.23,0,31,0,1674,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C14","v":625181.61544238974},{"$f":"CDD_Lond*D14","v":0},{"$f":"MonthDays*E14","v":2387059.2287870324},{"$f":"Shoulder1*F14","v":0},{"$f":"GSltCust*G14","v":9566075.9945788104},3441043.8193633426]
["2010-02-01",3109778,650.25,0,28,0,1674,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C15","v":567589.10607125354},{"$f":"CDD_Lond*D15","v":0},{"$f":"MonthDays*E15","v":2156053.4969689324},{"$f":"Shoulder1*F15","v":0},{"$f":"GSltCust*G15","v":9566075.9945788104},3152445.5781741068]
["2010-03-01",3063802,533.91,0.22,31,1,1674,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C16","v":466038.44617070811},{"$f":"CDD_Lond*D16","v":1048.687080669886},{"$f":"MonthDays*E16","v":2387059.2287870324},{"$f":"Shoulder1*F16","v":-166600.13966288301},{"$f":"GSltCust*G16","v":9566075.9945788104},3116349.197509448]
["2010-04-01",2760595,312.88,0.32,30,1,1675,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C17","v":273106.15841226268},{"$f":"CDD_Lond*D17","v":1525.363026428925},{"$f":"MonthDays*E17","v":2310057.3181809988},{"$f":"Shoulder1*F17","v":-166600.13966288301},{"$f":"GSltCust*G17","v":9571790.4963676855},2852606.1768796025]
["2010-05-01",2903907,145.96,16.98,31,1,1672,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C18","v":127405.31475918519},{"$f":"CDD_Lond*D18","v":80939.575589884829},{"$f":"MonthDays*E18","v":2387059.2287870324},{"$f":"Shoulder1*F18","v":-166600.13966288301},{"$f":"GSltCust*G18","v":9554646.9910010565},2846177.9510293854]
["2010-06-01",3063123,30.95,59.64,30,0,1669,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C19","v":27015.582980246516},{"$f":"CDD_Lond*D19","v":284289.53405069088},{"$f":"MonthDays*E19","v":2310057.3181809988},{"$f":"Shoulder1*F19","v":0},{"$f":"GSltCust*G19","v":9537503.4856344294},3021592.9014014751]
["2010-07-01",3367995,6,109.95,31,0,1666,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C20","v":5237.2697215340577},{"$f":"CDD_Lond*D20","v":524105.20236206346},{"$f":"MonthDays*E20","v":2387059.2287870324},{"$f":"Shoulder1*F20","v":0},{"$f":"GSltCust*G20","v":9520359.9802678004},3299488.6616935413]
["2010-08-01",3264268,11.72,76.849999999999994,31,0,1664,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C21","v":10230.13352272986},{"$f":"CDD_Lond*D21","v":366325.46431582147},{"$f":"MonthDays*E21","v":2387059.2287870324},{"$f":"Shoulder1*F21","v":0},{"$f":"GSltCust*G21","v":9508930.9766900465},3135272.7838707417]
["2010-09-01",2788591,72.849999999999994,24.35,30,1,1672,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C22","v":63589.183202292683},{"$f":"CDD_Lond*D22","v":116070.59279232602},{"$f":"MonthDays*E22","v":2310057.3181809988},{"$f":"Shoulder1*F22","v":-166600.13966288301},{"$f":"GSltCust*G22","v":9554646.9910010565},2740490.9260689011]
["2010-10-01",2730965,241.64,3.42,31,1,1668,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C23","v":210922.30925191496},{"$f":"CDD_Lond*D23","v":16302.317344959134},{"$f":"MonthDays*E23","v":2387059.2287870324},{"$f":"Shoulder1*F23","v":-166600.13966288301},{"$f":"GSltCust*G23","v":9531788.9838455524},2842199.6801216872]
["2010-11-01",2916635,414.34,0,30,1,1675,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C24","v":361668.38940340356},{"$f":"CDD_Lond*D24","v":0},{"$f":"MonthDays*E24","v":2310057.3181809988},{"$f":"Shoulder1*F24","v":-166600.13966288301},{"$f":"GSltCust*G24","v":9571790.4963676855},2939643.0448443135]
["2010-12-01",3326888,630.9,0,31,0,1667,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C25","v":550698.91121930617},{"$f":"CDD_Lond*D25","v":0},{"$f":"MonthDays*E25","v":2387059.2287870324},{"$f":"Shoulder1*F25","v":0},{"$f":"GSltCust*G25","v":9526074.4820566755},3326559.6026181243]
["2011-01-01",3480300,716.23,0,31,0,1665,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C26","v":625181.61544238974},{"$f":"CDD_Lond*D26","v":0},{"$f":"MonthDays*E26","v":2387059.2287870324},{"$f":"Shoulder1*F26","v":0},{"$f":"GSltCust*G26","v":9514645.4784789234},3389613.3032634556]
["2011-02-01",3140091,650.25,0,28,0,1677,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C27","v":567589.10607125354},{"$f":"CDD_Lond*D27","v":0},{"$f":"MonthDays*E27","v":2156053.4969689324},{"$f":"Shoulder1*F27","v":0},{"$f":"GSltCust*G27","v":9583219.4999454375},3169589.0835407339]
["2011-03-01",3198659,533.91,0.22,31,1,1677,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C28","v":466038.44617070811},{"$f":"CDD_Lond*D28","v":1048.687080669886},{"$f":"MonthDays*E28","v":2387059.2287870324},{"$f":"Shoulder1*F28","v":-166600.13966288301},{"$f":"GSltCust*G28","v":9583219.4999454375},3133492.7028760752]
["2011-04-01",2806404,312.88,0.32,30,1,1675,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C29","v":273106.15841226268},{"$f":"CDD_Lond*D29","v":1525.363026428925},{"$f":"MonthDays*E29","v":2310057.3181809988},{"$f":"Shoulder1*F29","v":-166600.13966288301},{"$f":"GSltCust*G29","v":9571790.4963676855},2852606.1768796025]
["2011-05-01",2777768,145.96,16.98,31,1,1674,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C30","v":127405.31475918519},{"$f":"CDD_Lond*D30","v":80939.575589884829},{"$f":"MonthDays*E30","v":2387059.2287870324},{"$f":"Shoulder1*F30","v":-166600.13966288301},{"$f":"GSltCust*G30","v":9566075.9945788104},2857606.9546071393]
["2011-06-01",2996203,30.95,59.64,30,0,1678,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C31","v":27015.582980246516},{"$f":"CDD_Lond*D31","v":284289.53405069088},{"$f":"MonthDays*E31","v":2310057.3181809988},{"$f":"Shoulder1*F31","v":0},{"$f":"GSltCust*G31","v":9588934.0017343145},3073023.4175013602]
["2011-07-01",3463081,6,109.95,31,0,1676,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C32","v":5237.2697215340577},{"$f":"CDD_Lond*D32","v":524105.20236206346},{"$f":"MonthDays*E32","v":2387059.2287870324},{"$f":"Shoulder1*F32","v":0},{"$f":"GSltCust*G32","v":9577504.9981565624},3356633.6795823034]
["2011-08-01",3314369,11.72,76.849999999999994,31,0,1676,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C33","v":10230.13352272986},{"$f":"CDD_Lond*D33","v":366325.46431582147},{"$f":"MonthDays*E33","v":2387059.2287870324},{"$f":"Shoulder1*F33","v":0},{"$f":"GSltCust*G33","v":9577504.9981565624},3203846.8053372577]
["2011-09-01",2758253,72.849999999999994,24.35,30,1,1673,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C34","v":63589.183202292683},{"$f":"CDD_Lond*D34","v":116070.59279232602},{"$f":"MonthDays*E34","v":2310057.3181809988},{"$f":"Shoulder1*F34","v":-166600.13966288301},{"$f":"GSltCust*G34","v":9560361.4927899335},{"$f":"SUM(I34:N34)","v":2746205.427857778}]
["2011-10-01",2745121,241.64,3.42,31,1,1670,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C35","v":210922.30925191496},{"$f":"CDD_Lond*D35","v":16302.317344959134},{"$f":"MonthDays*E35","v":2387059.2287870324},{"$f":"Shoulder1*F35","v":-166600.13966288301},{"$f":"GSltCust*G35","v":9543217.9874233045},2853628.6836994393]
["2011-11-01",2834235,414.34,0,30,1,1667,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C36","v":361668.38940340356},{"$f":"CDD_Lond*D36","v":0},{"$f":"MonthDays*E36","v":2310057.3181809988},{"$f":"Shoulder1*F36","v":-166600.13966288301},{"$f":"GSltCust*G36","v":9526074.4820566755},2893927.0305333035]
["2011-12-01",3149387,630.9,0,31,0,1664,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C37","v":550698.91121930617},{"$f":"CDD_Lond*D37","v":0},{"$f":"MonthDays*E37","v":2387059.2287870324},{"$f":"Shoulder1*F37","v":0},{"$f":"GSltCust*G37","v":9508930.9766900465},3309416.0972514953]
["2012-01-01",3281279,716.23,0,31,0,1666,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C38","v":625181.61544238974},{"$f":"CDD_Lond*D38","v":0},{"$f":"MonthDays*E38","v":2387059.2287870324},{"$f":"Shoulder1*F38","v":0},{"$f":"GSltCust*G38","v":9520359.9802678004},3395327.8050523326]
["2012-02-01",3046678,650.25,0,29,0,1667,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C39","v":567589.10607125354},{"$f":"CDD_Lond*D39","v":0},{"$f":"MonthDays*E39","v":2233055.4075749656},{"$f":"Shoulder1*F39","v":0},{"$f":"GSltCust*G39","v":9526074.4820566755},3189445.976258005]
["2012-03-01",2970504,533.91,0.22,31,1,1667,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C40","v":466038.44617070811},{"$f":"CDD_Lond*D40","v":1048.687080669886},{"$f":"MonthDays*E40","v":2387059.2287870324},{"$f":"Shoulder1*F40","v":-166600.13966288301},{"$f":"GSltCust*G40","v":9526074.4820566755},3076347.6849873131]
["2012-04-01",2680293,312.88,0.32,30,1,1667,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C41","v":273106.15841226268},{"$f":"CDD_Lond*D41","v":1525.363026428925},{"$f":"MonthDays*E41","v":2310057.3181809988},{"$f":"Shoulder1*F41","v":-166600.13966288301},{"$f":"GSltCust*G41","v":9526074.4820566755},2806890.1625685925]
["2012-05-01",2807502,145.96,16.98,31,1,1667,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C42","v":127405.31475918519},{"$f":"CDD_Lond*D42","v":80939.575589884829},{"$f":"MonthDays*E42","v":2387059.2287870324},{"$f":"Shoulder1*F42","v":-166600.13966288301},{"$f":"GSltCust*G42","v":9526074.4820566755},2817605.4420850044]
["2012-06-01",3105876,30.95,59.64,30,0,1669,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C43","v":27015.582980246516},{"$f":"CDD_Lond*D43","v":284289.53405069088},{"$f":"MonthDays*E43","v":2310057.3181809988},{"$f":"Shoulder1*F43","v":0},{"$f":"GSltCust*G43","v":9537503.4856344294},3021592.9014014751]
["2012-07-01",3478171,6,109.95,31,0,1654,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C44","v":5237.2697215340577},{"$f":"CDD_Lond*D44","v":524105.20236206346},{"$f":"MonthDays*E44","v":2387059.2287870324},{"$f":"Shoulder1*F44","v":0},{"$f":"GSltCust*G44","v":9451785.9588012844},3230914.6402270254]
["2012-08-01",3240724,11.72,76.849999999999994,31,0,1660,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C45","v":10230.13352272986},{"$f":"CDD_Lond*D45","v":366325.46431582147},{"$f":"MonthDays*E45","v":2387059.2287870324},{"$f":"Shoulder1*F45","v":0},{"$f":"GSltCust*G45","v":9486072.9695345424},3112414.7767152376]
["2012-09-01",2834667,72.849999999999994,24.35,30,1,1651,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C46","v":63589.183202292683},{"$f":"CDD_Lond*D46","v":116070.59279232602},{"$f":"MonthDays*E46","v":2310057.3181809988},{"$f":"Shoulder1*F46","v":-166600.13966288301},{"$f":"GSltCust*G46","v":9434642.4534346573},2620486.3885025019]
["2012-10-01",2761045,241.64,3.42,31,1,1659,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C47","v":210922.30925191496},{"$f":"CDD_Lond*D47","v":16302.317344959134},{"$f":"MonthDays*E47","v":2387059.2287870324},{"$f":"Shoulder1*F47","v":-166600.13966288301},{"$f":"GSltCust*G47","v":9480358.4677456655},2790769.1640218003]
["2012-11-01",2908932,414.34,0,30,1,1659,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C48","v":361668.38940340356},{"$f":"CDD_Lond*D48","v":0},{"$f":"MonthDays*E48","v":2310057.3181809988},{"$f":"Shoulder1*F48","v":-166600.13966288301},{"$f":"GSltCust*G48","v":9480358.4677456655},2848211.0162222935]
["2012-12-01",3144594,630.9,0,31,0,1658,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C49","v":550698.91121930617},{"$f":"CDD_Lond*D49","v":0},{"$f":"MonthDays*E49","v":2387059.2287870324},{"$f":"Shoulder1*F49","v":0},{"$f":"GSltCust*G49","v":9474643.9659567904},3275129.0865182392]
["2013-01-01",3333526.669999985,716.23,0,31,0,1664,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C50","v":625181.61544238974},{"$f":"CDD_Lond*D50","v":0},{"$f":"MonthDays*E50","v":2387059.2287870324},{"$f":"Shoulder1*F50","v":0},{"$f":"GSltCust*G50","v":9508930.9766900465},3383898.8014745787]
["2013-02-01",3075889.3099999987,650.25,0,28,0,1663,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C51","v":567589.10607125354},{"$f":"CDD_Lond*D51","v":0},{"$f":"MonthDays*E51","v":2156053.4969689324},{"$f":"Shoulder1*F51","v":0},{"$f":"GSltCust*G51","v":9503216.4749011714},3089586.0584964678]
["2013-03-01",3220272.9200000064,533.91,0.22,31,1,1663,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C52","v":466038.44617070811},{"$f":"CDD_Lond*D52","v":1048.687080669886},{"$f":"MonthDays*E52","v":2387059.2287870324},{"$f":"Shoulder1*F52","v":-166600.13966288301},{"$f":"GSltCust*G52","v":9503216.4749011714},3053489.677831809]
["2013-04-01",2945784.670000005,312.88,0.32,30,1,1693,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C53","v":273106.15841226268},{"$f":"CDD_Lond*D53","v":1525.363026428925},{"$f":"MonthDays*E53","v":2310057.3181809988},{"$f":"Shoulder1*F53","v":-166600.13966288301},{"$f":"GSltCust*G53","v":9674651.5285674576},2955467.2090793746]
["2013-05-01",3078779.2099999925,145.96,16.98,31,1,1713,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C54","v":127405.31475918519},{"$f":"CDD_Lond*D54","v":80939.575589884829},{"$f":"MonthDays*E54","v":2387059.2287870324},{"$f":"Shoulder1*F54","v":-166600.13966288301},{"$f":"GSltCust*G54","v":9788941.5643449835},3080472.5243733125]
["2013-06-01",3203064.9200000046,30.95,59.64,30,0,1714,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C55","v":27015.582980246516},{"$f":"CDD_Lond*D55","v":284289.53405069088},{"$f":"MonthDays*E55","v":2310057.3181809988},{"$f":"Shoulder1*F55","v":0},{"$f":"GSltCust*G55","v":9794656.0661338586},3278745.4819009043]
["2013-07-01",3624763.5200000121,6,109.95,31,0,1715,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C56","v":5237.2697215340577},{"$f":"CDD_Lond*D56","v":524105.20236206346},{"$f":"MonthDays*E56","v":2387059.2287870324},{"$f":"Shoulder1*F56","v":0},{"$f":"GSltCust*G56","v":9800370.5679227356},3579499.2493484765]
["2013-08-01",3384970.7899999958,11.72,76.849999999999994,31,0,1716,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C57","v":10230.13352272986},{"$f":"CDD_Lond*D57","v":366325.46431582147},{"$f":"MonthDays*E57","v":2387059.2287870324},{"$f":"Shoulder1*F57","v":0},{"$f":"GSltCust*G57","v":9806085.0697116107},3432426.8768923059]
["2013-09-01",3137884.1800000072,72.849999999999994,24.35,30,1,1718,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C58","v":63589.183202292683},{"$f":"CDD_Lond*D58","v":116070.59279232602},{"$f":"MonthDays*E58","v":2310057.3181809988},{"$f":"Shoulder1*F58","v":-166600.13966288301},{"$f":"GSltCust*G58","v":9817514.0732893646},3003358.0083572092]
["2013-10-01",3072349.9899999904,241.64,3.42,31,1,1719,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C59","v":210922.30925191496},{"$f":"CDD_Lond*D59","v":16302.317344959134},{"$f":"MonthDays*E59","v":2387059.2287870324},{"$f":"Shoulder1*F59","v":-166600.13966288301},{"$f":"GSltCust*G59","v":9823228.5750782397},3133639.2713543745]
["2013-11-01",3250425.949999996,414.34,0,30,1,1721,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C60","v":361668.38940340356},{"$f":"CDD_Lond*D60","v":0},{"$f":"MonthDays*E60","v":2310057.3181809988},{"$f":"Shoulder1*F60","v":-166600.13966288301},{"$f":"GSltCust*G60","v":9834657.5786559917},3202510.1271326197]
["2013-12-01",3647170.1100000041,630.9,0,31,0,1720,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C61","v":550698.91121930617},{"$f":"CDD_Lond*D61","v":0},{"$f":"MonthDays*E61","v":2387059.2287870324},{"$f":"Shoulder1*F61","v":0},{"$f":"GSltCust*G61","v":9828943.0768671166},3629428.1974285655]
["2014-01-01",null,716.23,0,31,0,1719,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C62","v":625181.61544238974},{"$f":"CDD_Lond*D62","v":0},{"$f":"MonthDays*E62","v":2387059.2287870324},{"$f":"Shoulder1*F62","v":0},{"$f":"GSltCust*G62","v":9823228.5750782397},3698196.3998627719]
["2014-02-01",null,650.25,0,28,0,1722,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C63","v":567589.10607125354},{"$f":"CDD_Lond*D63","v":0},{"$f":"MonthDays*E63","v":2156053.4969689324},{"$f":"Shoulder1*F63","v":0},{"$f":"GSltCust*G63","v":9840372.0804448687},3426741.664040165]
["2014-03-01",null,533.91,0.22,31,1,1722,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C64","v":466038.44617070811},{"$f":"CDD_Lond*D64","v":1048.687080669886},{"$f":"MonthDays*E64","v":2387059.2287870324},{"$f":"Shoulder1*F64","v":-166600.13966288301},{"$f":"GSltCust*G64","v":9840372.0804448687},3390645.2833755063]
["2014-04-01",null,312.88,0.32,30,1,1729,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C65","v":273106.15841226268},{"$f":"CDD_Lond*D65","v":1525.363026428925},{"$f":"MonthDays*E65","v":2310057.3181809988},{"$f":"Shoulder1*F65","v":-166600.13966288301},{"$f":"GSltCust*G65","v":9880373.5929670017},3161189.2734789187]
["2014-05-01",null,145.96,16.98,31,1,1733,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C66","v":127405.31475918519},{"$f":"CDD_Lond*D66","v":80939.575589884829},{"$f":"MonthDays*E66","v":2387059.2287870324},{"$f":"Shoulder1*F66","v":-166600.13966288301},{"$f":"GSltCust*G66","v":9903231.6001225077},{"$f":"SUM(I66:N66)","v":3194762.5601508366}]
["2014-06-01",null,30.95,59.64,30,0,1734,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C67","v":27015.582980246516},{"$f":"CDD_Lond*D67","v":284289.53405069088},{"$f":"MonthDays*E67","v":2310057.3181809988},{"$f":"Shoulder1*F67","v":0},{"$f":"GSltCust*G67","v":9908946.1019113827},3393035.5176784284]
["2014-07-01",null,6,109.95,31,0,1729,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C68","v":5237.2697215340577},{"$f":"CDD_Lond*D68","v":524105.20236206346},{"$f":"MonthDays*E68","v":2387059.2287870324},{"$f":"Shoulder1*F68","v":0},{"$f":"GSltCust*G68","v":9880373.5929670017},3659502.2743927427]
["2014-08-01",null,11.72,76.849999999999994,31,0,1731,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C69","v":10230.13352272986},{"$f":"CDD_Lond*D69","v":366325.46431582147},{"$f":"MonthDays*E69","v":2387059.2287870324},{"$f":"Shoulder1*F69","v":0},{"$f":"GSltCust*G69","v":9891802.5965447556},3518144.4037254509]
["2014-09-01",null,72.849999999999994,24.35,30,1,1730,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C70","v":63589.183202292683},{"$f":"CDD_Lond*D70","v":116070.59279232602},{"$f":"MonthDays*E70","v":2310057.3181809988},{"$f":"Shoulder1*F70","v":-166600.13966288301},{"$f":"GSltCust*G70","v":9886088.0947558787},3071932.0298237232]
["2014-10-01",null,241.64,3.42,31,1,1731,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C71","v":210922.30925191496},{"$f":"CDD_Lond*D71","v":16302.317344959134},{"$f":"MonthDays*E71","v":2387059.2287870324},{"$f":"Shoulder1*F71","v":-166600.13966288301},{"$f":"GSltCust*G71","v":9891802.5965447556},3202213.2928208904]
["2014-11-01",null,414.34,0,30,1,1732,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C72","v":361668.38940340356},{"$f":"CDD_Lond*D72","v":0},{"$f":"MonthDays*E72","v":2310057.3181809988},{"$f":"Shoulder1*F72","v":-166600.13966288301},{"$f":"GSltCust*G72","v":9897517.0983336307},3265369.6468102587]
["2014-12-01",null,630.9,0,31,0,1729,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C73","v":550698.91121930617},{"$f":"CDD_Lond*D73","v":0},{"$f":"MonthDays*E73","v":2387059.2287870324},{"$f":"Shoulder1*F73","v":0},{"$f":"GSltCust*G73","v":9880373.5929670017},3680858.7135284506]
["2015-01-01",null,716.23,0,31,0,1727,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C74","v":625181.61544238974},{"$f":"CDD_Lond*D74","v":0},{"$f":"MonthDays*E74","v":2387059.2287870324},{"$f":"Shoulder1*F74","v":0},{"$f":"GSltCust*G74","v":9868944.5893892497},3743912.4141737819]
["2015-02-01",null,650.25,0,28,0,1730,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C75","v":567589.10607125354},{"$f":"CDD_Lond*D75","v":0},{"$f":"MonthDays*E75","v":2156053.4969689324},{"$f":"Shoulder1*F75","v":0},{"$f":"GSltCust*G75","v":9886088.0947558787},3472457.678351175]
["2015-03-01",null,533.91,0.22,31,1,1730,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C76","v":466038.44617070811},{"$f":"CDD_Lond*D76","v":1048.687080669886},{"$f":"MonthDays*E76","v":2387059.2287870324},{"$f":"Shoulder1*F76","v":-166600.13966288301},{"$f":"GSltCust*G76","v":9886088.0947558787},3436361.2976865163]
["2015-04-01",null,312.88,0.32,30,1,1738,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C77","v":273106.15841226268},{"$f":"CDD_Lond*D77","v":1525.363026428925},{"$f":"MonthDays*E77","v":2310057.3181809988},{"$f":"Shoulder1*F77","v":-166600.13966288301},{"$f":"GSltCust*G77","v":9931804.1090668887},3212619.7895788057]
["2015-05-01",null,145.96,16.98,31,1,1742,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C78","v":127405.31475918519},{"$f":"CDD_Lond*D78","v":80939.575589884829},{"$f":"MonthDays*E78","v":2387059.2287870324},{"$f":"Shoulder1*F78","v":-166600.13966288301},{"$f":"GSltCust*G78","v":9954662.1162223928},3246193.0762507217]
["2015-06-01",null,30.95,59.64,30,0,1743,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C79","v":27015.582980246516},{"$f":"CDD_Lond*D79","v":284289.53405069088},{"$f":"MonthDays*E79","v":2310057.3181809988},{"$f":"Shoulder1*F79","v":0},{"$f":"GSltCust*G79","v":9960376.6180112697},3444466.0337783154]
["2015-07-01",null,6,109.95,31,0,1738,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C80","v":5237.2697215340577},{"$f":"CDD_Lond*D80","v":524105.20236206346},{"$f":"MonthDays*E80","v":2387059.2287870324},{"$f":"Shoulder1*F80","v":0},{"$f":"GSltCust*G80","v":9931804.1090668887},3710932.7904926296]
["2015-08-01",null,11.72,76.849999999999994,31,0,1739,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C81","v":10230.13352272986},{"$f":"CDD_Lond*D81","v":366325.46431582147},{"$f":"MonthDays*E81","v":2387059.2287870324},{"$f":"Shoulder1*F81","v":0},{"$f":"GSltCust*G81","v":9937518.6108557638},3563860.418036459]
["2015-09-01",null,72.849999999999994,24.35,30,1,1739,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C82","v":63589.183202292683},{"$f":"CDD_Lond*D82","v":116070.59279232602},{"$f":"MonthDays*E82","v":2310057.3181809988},{"$f":"Shoulder1*F82","v":-166600.13966288301},{"$f":"GSltCust*G82","v":9937518.6108557638},3123362.5459236084]
["2015-10-01",null,241.64,3.42,31,1,1739,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C83","v":210922.30925191496},{"$f":"CDD_Lond*D83","v":16302.317344959134},{"$f":"MonthDays*E83","v":2387059.2287870324},{"$f":"Shoulder1*F83","v":-166600.13966288301},{"$f":"GSltCust*G83","v":9937518.6108557638},3247929.3071318986]
["2015-11-01",null,414.34,0,30,1,1741,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C84","v":361668.38940340356},{"$f":"CDD_Lond*D84","v":0},{"$f":"MonthDays*E84","v":2310057.3181809988},{"$f":"Shoulder1*F84","v":-166600.13966288301},{"$f":"GSltCust*G84","v":9948947.6144335177},3316800.1629101457]
["2015-12-01",null,630.9,0,31,0,1737,null,{"$f":"const","v":-9137273.0194448903},{"$f":"HDD_Lond*C85","v":550698.91121930617},{"$f":"CDD_Lond*D85","v":0},{"$f":"MonthDays*E85","v":2387059.2287870324},{"$f":"Shoulder1*F85","v":0},{"$f":"GSltCust*G85","v":9926089.6072780117},3726574.7278394606]

{"sheet":"Normalized Monthly Data Summ","index":8,"n_rows":85,"n_cols":4,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Date","Year","GSlt50kWh","Normalized Value"]
["2009-01-01",{"$f":"YEAR(A2)","v":2009},3760655,3441043.8193633426]
["2009-02-01",2009,3270545,3158160.0799629819]
["2009-03-01",2009,3315389,3156350.7100315811]
["2009-04-01",2009,2905547,2904036.6929794895]
["2009-05-01",2009,2858350,2920466.4742847765]
["2009-06-01",2009,2907459,3113024.9300234932]
["2009-07-01",2009,3152443,3408064.1956821885]
["2009-08-01",2009,3252321,3255277.3214371428]
["2009-09-01",2009,2873707,2814779.4493242921]
["2009-10-01",2009,2845616,2939346.2105325824]
["2009-11-01",2009,2894664,2996788.0627330756]
["2009-12-01",2009,3352350,3366561.1151402593]
["2010-01-01",2010,3441514,3441043.8193633426]
["2010-02-01",2010,3109778,3152445.5781741068]
["2010-03-01",2010,3063802,3116349.197509448]
["2010-04-01",2010,2760595,2852606.1768796025]
["2010-05-01",2010,2903907,2846177.9510293854]
["2010-06-01",2010,3063123,3021592.9014014751]
["2010-07-01",2010,3367995,3299488.6616935413]
["2010-08-01",2010,3264268,3135272.7838707417]
["2010-09-01",2010,2788591,2740490.9260689011]
["2010-10-01",2010,2730965,2842199.6801216872]
["2010-11-01",2010,2916635,2939643.0448443135]
["2010-12-01",2010,3326888,3326559.6026181243]
["2011-01-01",2011,3480300,3389613.3032634556]
["2011-02-01",2011,3140091,3169589.0835407339]
["2011-03-01",2011,3198659,3133492.7028760752]
["2011-04-01",2011,2806404,2852606.1768796025]
["2011-05-01",2011,2777768,2857606.9546071393]
["2011-06-01",2011,2996203,3073023.4175013602]
["2011-07-01",2011,3463081,3356633.6795823034]
["2011-08-01",2011,3314369,3203846.8053372577]
["2011-09-01",{"$f":"YEAR(A34)","v":2011},2758253,2746205.427857778]
["2011-10-01",2011,2745121,2853628.6836994393]
["2011-11-01",2011,2834235,2893927.0305333035]
["2011-12-01",2011,3149387,3309416.0972514953]
["2012-01-01",2012,3281279,3395327.8050523326]
["2012-02-01",2012,3046678,3189445.976258005]
["2012-03-01",2012,2970504,3076347.6849873131]
["2012-04-01",2012,2680293,2806890.1625685925]
["2012-05-01",2012,2807502,2817605.4420850044]
["2012-06-01",2012,3105876,3021592.9014014751]
["2012-07-01",2012,3478171,3230914.6402270254]
["2012-08-01",2012,3240724,3112414.7767152376]
["2012-09-01",2012,2834667,2620486.3885025019]
["2012-10-01",2012,2761045,2790769.1640218003]
["2012-11-01",2012,2908932,2848211.0162222935]
["2012-12-01",2012,3144594,3275129.0865182392]
["2013-01-01",2013,3333526.669999985,3383898.8014745787]
["2013-02-01",2013,3075889.3099999987,3089586.0584964678]
["2013-03-01",2013,3220272.9200000064,3053489.677831809]
["2013-04-01",2013,2945784.670000005,2955467.2090793746]
["2013-05-01",2013,3078779.2099999925,3080472.5243733125]
["2013-06-01",2013,3203064.9200000046,3278745.4819009043]
["2013-07-01",2013,3624763.5200000121,3579499.2493484765]
["2013-08-01",2013,3384970.7899999958,3432426.8768923059]
["2013-09-01",2013,3137884.1800000072,3003358.0083572092]
["2013-10-01",2013,3072349.9899999904,3133639.2713543745]
["2013-11-01",2013,3250425.949999996,3202510.1271326197]
["2013-12-01",2013,3647170.1100000041,3629428.1974285655]
["2014-01-01",2014,null,3698196.3998627719]
["2014-02-01",2014,null,3426741.664040165]
["2014-03-01",2014,null,3390645.2833755063]
["2014-04-01",2014,null,3161189.2734789187]
["2014-05-01",{"$f":"YEAR(A66)","v":2014},null,3194762.5601508366]
["2014-06-01",2014,null,3393035.5176784284]
["2014-07-01",2014,null,3659502.2743927427]
["2014-08-01",2014,null,3518144.4037254509]
["2014-09-01",2014,null,3071932.0298237232]
["2014-10-01",2014,null,3202213.2928208904]
["2014-11-01",2014,null,3265369.6468102587]
["2014-12-01",2014,null,3680858.7135284506]
["2015-01-01",2015,null,3743912.4141737819]
["2015-02-01",2015,null,3472457.678351175]
["2015-03-01",2015,null,3436361.2976865163]
["2015-04-01",2015,null,3212619.7895788057]
["2015-05-01",2015,null,3246193.0762507217]
["2015-06-01",2015,null,3444466.0337783154]
["2015-07-01",2015,null,3710932.7904926296]
["2015-08-01",2015,null,3563860.418036459]
["2015-09-01",2015,null,3123362.5459236084]
["2015-10-01",2015,null,3247929.3071318986]
["2015-11-01",2015,null,3316800.1629101457]
["2015-12-01",2015,null,3726574.7278394606]

{"sheet":"NormalizedAnnualDataSumm","index":9,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Annual Actual vs. Normalized GSlt50kWh"]
[null,"GSlt50kWh ","Normalized Value "]
[2009,37389046,37473899.0614952]
[2010,36738061,36713870.32357467]
[2011,36663871,36839589.362929948]
[2012,36260265,36185135.044559821]
[2013,38974882.240000002,38822521.483669996]
[2014,null,40662591.059688136]
[2015,null,41245470.242153525]

{"sheet":"NormalizedAnnualDataSumm2","index":10,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Annual Actual vs. Normalized GSlt50kWh"]
[null,"GSlt50kWh ","% Change","Normalized Value ","% Change"]
[2009,37389046,null,37473899.0614952]
[2010,36738061,{"$f":"B5/B4-1","v":-1.7411115544376243E-2},36713870.32357467,{"$f":"D5/D4-1","v":-2.0281549477232486E-2}]
[2011,36663871,{"$f":"B6/B5-1","v":-2.0194315644476157E-3},36839589.362929948,{"$f":"D6/D5-1","v":3.4242927331622486E-3}]
[2012,36260265,-1.1008275694620484E-2,36185135.044559821,-1.7764973217336499E-2]
[2013,38974882.240000002,7.4864793183392342E-2,38822521.483669996,7.2885908422405832E-2]
[2014,null,null,40662591.059688136,4.7396962013199762E-2]
[2015,null,null,41245470.242153525,1.4334531255270733E-2]