{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Admin","Load Forecast","OPA Results","CDM Target","OPA Total Results","Net To Gross Calculation","Load Forecast Adjustment","Adjustment To Load Forecast","LRAMVA Allocation","CDM Target By LDC","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":0,"comments":0,"pivot_tables":0},"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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Utility"]
[null,"Burlington Hydro Inc.   "]
[]
[null,"2014 Target"]
[null,"kWh",{"$f":"VLOOKUP(B5,'CDM Target By LDC'!B2:D83,3,0)*1000000","v":82370000}]
[null,"kW",{"$f":"VLOOKUP(B5,'CDM Target By LDC'!B2:D83,2,0)*1000","v":21950}]

{"sheet":"Load Forecast","index":1,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,1,1,8],[24,1,24,2],[35,1,35,2],[45,1,45,2]]}
[]
[null,"Load Forecast"]
[null,{"$f":"Admin!B5","v":"Burlington Hydro Inc.   "}]
[]
[null,"Customers or Connections"]
[]
[null,"Customer Class Name","2010 Board Appr","2010 Actual","2011 Actual","2012 Actual","2012 Actual Normalized","Bridge Year 2013 Normalized","Test Year 2014 Normalized"]
[null,"Residential",57218,57917,58488,59068,null,59375,59869]
[null,"General Service < 50 kW",4942,4988,5091,5138,null,5164,5224]
[null,"General Service > 50 to 4999 kW",976,996,987,998,null,1008,1012]
[null,"Unmetered Scattered Load",602,604,604,605,null,605,605]
[null,"Street Lighting ",14457,14652,15024,15083,null,15114,15272]
[null,"TOTAL",78195,79157,80194,80892,null,81266,81982]
[null,"  "]
[null,"Metered kWh"]
[]
[null,"Customer Class Name","2010 Board Appr","2010 Actual","2011 Actual","2012 Actual","2012 Actual Normalized","Bridge Year 2013 Normalized","Test Year 2014 Normalized"]
[null,"Residential",523950900,556896336,551353006,551839571,null,536784300,555449406.54854131]
[null,"General Service < 50 kW",172363092,172200325,174484065,174704767,null,174841485,174342370.28596878]
[null,"General Service > 50 to 4999 kW",879095420,906197008,908229110,903337846,null,895328520,899894473.08766222]
[null,"Unmetered Scattered Load",3487625,3512551,3296779,3353868,null,3160882,3160882]
[null,"Street Lighting ",9391179,9467387,9847280,9866380,null,10886911,11000298.735369794]
[null,"TOTAL",1588288216,1648273607,1647210240,1643102432,0,1621002098,1643847430.657542]
[]
[null,"Metered kWh (CDM Adjusted) "]
[]
[null,"Customer Class Name","2010 Board Appr","2010 Actual","2011 Actual","2012 Actual","2012 Actual Normalized","Bridge Year 2013 Normalized","Test Year 2014 Normalized"]
[null,"Residential",null,556896336,551353006,551839571,null,553523828,553858289.38939965]
[null,"General Service < 50 kW",null,172200325,174484065,174704767,null,173805678,173842956.41738418]
[null,"General Service > 50 to 4999 kW",null,906197008,908229110,903337846,null,897955770,897316672.9844203]
[null,"Unmetered Scattered Load",null,3512551,3296779,3353868,null,3353868,3151827.4695082433]
[null,"Street Lighting ",null,9467387,9847280,9866380,null,10006706,10968787.739287738]
[null,"TOTAL",0,1648273607,1647210240,1643102432,0,1638645850,1639138534]
[]
[null,"  "]
[null,"kW"]
[]
[null,"Customer Class Name","2010 Board Appr","2010 Actual","2011 Actual","2012 Actual","2012 Actual Normalized","Bridge Year 2013 Normalized","Test Year 2014 Normalized"]
[null,"Residential"]
[null,"General Service < 50 kW"]
[null,"General Service > 50 to 4999 kW",2353210,2403006,2396756,2423043,null,2421009.9043673403,2421009.9043673403]
[null,"Unmetered Scattered Load"]
[null,"Street Lighting ",25861,26416,27334,27457,null,27825,30612.565335720745]
[null,"TOTAL",2379071,2429422,2424090,2450500,0,2448834.9043673403,2451622.469703061]
[]
[null,"kW CDM Adjusted"]
[]
[null,"Customer Class Name","2010 Board Appr","2010 Actual","2011 Actual","2012 Actual","2012 Actual Normalized","Bridge Year 2013 Normalized","Test Year 2014 Normalized"]
[null,"Residential",0,0,0,0,null,0]
[null,"General Service < 50 kW",0,0,0,0,null,0]
[null,"General Service > 50 to 4999 kW",2353210,2403006,2396756,2423043,null,2421009.9043673403,2414075.1218246226]
[null,"Unmetered Scattered Load",0,0,0,0,null,0]
[null,"Street Lighting ",25861,26416,27334,27457,null,27825,30524.878175377045]
[null,"TOTAL",2379071,2429422,2424090,2450500,0,2448834.9043673403,2444599.9999999995]
[null,"  "]
[null,"Primary Metering Adjustment",0.99]
[null,"Customer Class Name","Proposed Loss Factor"]
[null,"Residential",1.037300017188596]
[null,"General Service < 50 kW",1.037300017188596]
[null,"General Service > 50 to 4999 kW",1.037300017188596]
[null,"Unmetered Scattered Load",1.037300017188596]
[null,"Street Lighting ",1.037300017188596]

{"sheet":"OPA Results","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Post 2010 OPA Final Results"]
[{"$f":"Admin!B5","v":"Burlington Hydro Inc.   "}]
[]
["Source: 2011 OPA Final Report",2011,2012,2013,2014,"Total"]
[]
["2011  Final kWh - Net",{"$f":"'[1]3.1.1 Summary - LDC'!$B$21*1000000","v":7350137.626871543},{"$f":"'[1]3.1.1 Summary - LDC'!$C$21*1000000","v":7301303.0768715432},{"$f":"'[1]3.1.1 Summary - LDC'!$D$21*1000000","v":7301303.0768715432},{"$f":"'[1]3.1.1 Summary - LDC'!$E$21*1000000","v":7238674.3407178121},{"$f":"SUM(B7:E7)","v":29191418.121332441}]
[]
["2011  Final kW - Net",{"$f":"'[1]3.1.1 Summary - LDC'!$B$7*1000","v":2932.3500068921639},{"$f":"'[1]3.1.1 Summary - LDC'!$C$7*1000","v":1768.5155068921636},{"$f":"'[1]3.1.1 Summary - LDC'!$D$7* 1000","v":1768.5155068921636},{"$f":"'[1]3.1.1 Summary - LDC'!$E$7*1000","v":1744.9173497003426}]
[]
["Source: 2012 OPA Final Report *",2011,2012,2013,2014]
[]
["2012  Final kWh - Net",0,8414807,{"$f":"8414807-46660","v":8368147},{"$f":"8414807-46660-225899","v":8142248},{"$f":"SUM(B13:E13)","v":24925202}]
[]
["2012  Final kW - Net",0,4739,1947,{"$f":"1947-74","v":1873}]
[]
["* Currently estimated using 2012 OPA Final Report values - Final Verified Results"]

{"sheet":"CDM Target","index":3,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,1,4,6],[5,1,5,6],[22,1,22,6],[23,1,23,6]]}
[]
[null,"Calculate proportionate CDM savings required to achieve CDMTarget"]
[null,{"$f":"Admin!B5","v":"Burlington Hydro Inc.   "}]
[null,"Schedule to achieve 4 Year kWH CDM Target"]
[null,"4 Year 2011 - 2014 kWh CDM Target"]
[null,{"$f":"Admin!C8","v":82370000}]
[null,"%",2011,2012,2013,2014,"Total"]
[null,"2011 Programs",{"$f":"C15/$G$19","v":8.9233187166098613E-2},{"$f":"D15/$G$19","v":8.8640319010216628E-2},{"$f":"E15/$G$19","v":8.8640319010216628E-2},{"$f":"F15/$G$19","v":8.7879984711883116E-2},{"$f":"SUM(C8:F8)","v":0.35439380989841501}]
[null,"2012 Programs",null,{"$f":"D16/$G$19","v":0.10215863785358748},{"$f":"E16/$G$19","v":0.10159216947917932},{"$f":"F16/$G$19","v":9.8849678280927528E-2},{"$f":"SUM(C9:F9)","v":0.30260048561369435}]
[null,"2013 Programs",null,null,{"$f":"E17/$G$19","v":0.11433523482929692},{"$f":"F17/$G$19","v":0.11433523482929692},0.22867046965859383]
[null,"2014 Programs",null,null,null,{"$f":"F18/$G$19","v":0.11433523482929692},0.11433523482929692]
[null,null,{"$f":"SUM(C8:C11)","v":8.9233187166098613E-2},{"$f":"SUM(D8:D11)","v":0.1907989568638041},0.30456772331869286,0.41540013265140446,1]
[]
[null,"kWh",2011,2012,2013,2014,"Total"]
[null,"2011 Programs",{"$f":"'OPA Results'!B7","v":7350137.626871543},{"$f":"'OPA Results'!C7","v":7301303.0768715432},{"$f":"'OPA Results'!D7","v":7301303.0768715432},{"$f":"'OPA Results'!E7","v":7238674.3407178121},{"$f":"SUM(C15:F15)","v":29191418.121332441}]
[null,"2012 Programs",null,{"$f":"'OPA Results'!C13","v":8414807},{"$f":"'OPA Results'!D13","v":8368147},{"$f":"'OPA Results'!E13","v":8142248},{"$f":"SUM(C16:F16)","v":24925202}]
[null,"2013 Programs",null,null,{"$f":"($G$20-$G$15-$G$16)/3","v":9417793.2928891871},{"$f":"($G$20-$G$15-$G$16)/3","v":9417793.2928891871},{"$f":"SUM(C17:F17)","v":18835586.585778374}]
[null,"2014 Programs",null,null,null,{"$f":"($G$20-$G$15-$G$16)/3","v":9417793.2928891871},9417793.2928891871]
[null,null,{"$f":"SUM(C15:C18)","v":7350137.626871543},{"$f":"SUM(D15:D18)","v":15716110.076871544},25087243.369760729,34216508.926496185,82370000]
[null,null,null,null,null,null,{"$f":"B6","v":82370000}]
[]
[null,"Schedule to achieve 4 Year kW CDM Target"]
[null,"4 Year 2011 - 2014 kW CDM Target"]
[null,{"$f":"Admin!C9","v":21950}]
[null,"%",2011,2012,2013,2014,"Total"]
[null,"2011 Programs",{"$f":"C33/$G$37","v":0.13359225543927855},{"$f":"D33/$G$37","v":8.0570182546340019E-2},8.0570182546340019E-2,7.9495095658329962E-2,{"$f":"SUM(C26:F26)","v":0.37422771619028855}]
[null,"2012 Programs",null,0.21589977220956719,8.8701594533029615E-2,8.5330296127562641E-2,{"$f":"SUM(C27:F27)","v":0.38993166287015946}]
[null,"2013 Programs",null,null,7.8613540313184002E-2,7.8613540313184002E-2,0.157227080626368]
[null,"2014 Programs",null,null,null,7.8613540313184002E-2,7.8613540313184002E-2]
[null,null,{"$f":"SUM(C26:C29)","v":0.13359225543927855},{"$f":"SUM(D26:D29)","v":0.29646995475590721},0.24788531739255365,0.32205247241226065,1]
[]
[null,"kWh",2011,2012,2013,2014,"Total"]
[null,"2011 Programs",{"$f":"'OPA Results'!B9","v":2932.3500068921639},{"$f":"'OPA Results'!C9","v":1768.5155068921636},{"$f":"'OPA Results'!D9","v":1768.5155068921636},{"$f":"'OPA Results'!E9","v":1744.9173497003426},{"$f":"SUM(C33:F33)","v":8214.2983703768332}]
[null,"2012 Programs",null,{"$f":"'OPA Results'!C15","v":4739},{"$f":"'OPA Results'!D15","v":1947},{"$f":"'OPA Results'!E15","v":1873},{"$f":"SUM(C34:F34)","v":8559}]
[null,"2013 Programs",null,null,{"$f":"($G$38-$G$33-$G$34)/3","v":1725.5672098743889},{"$f":"($G$38-$G$33-$G$34)/3","v":1725.5672098743889},{"$f":"SUM(C35:F35)","v":3451.1344197487779}]
[null,"2014 Programs",null,null,null,{"$f":"($G$38-$G$33-$G$34)/3","v":1725.5672098743889},{"$f":"SUM(C36:F36)","v":1725.5672098743889}]
[null,null,{"$f":"SUM(C33:C36)","v":2932.3500068921639},{"$f":"SUM(D33:D36)","v":6507.5155068921631},5441.082716766552,7069.0517694491209,{"$f":"SUM(C37:F37)","v":21950}]
[null,null,null,null,null,null,{"$f":"B24","v":21950}]

{"sheet":"OPA Total Results","index":4,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,0,0,19]]}
["Summary of OPA Final Results 2006 to 2012"]
[{"$f":"Admin!B5 & \" (kWh)\"","v":"Burlington Hydro Inc.    (kWh)"}]
[null,"2006 - 2010 Gross kWh","2011 Gross kWh","2012 Gross kWh","Total Gross kWh",null,"2006 - 2010 Net kWh","2011 Net kWh","2012 Net kWh","Total Net kWh",null,"2006 - 2010 Gross - Net","2011 Gross - Net","2012 Gross - Net","Total  Gross - Net",null,"2006 - 2010",2011,2012,"Total"]
[2006,{"$f":"'[2]Initiative Level - LDC'!$G$331*1000","v":5771014.0808791108},null,null,{"$f":"SUM(B4:D4)","v":5771014.0808791108},null,{"$f":"'[2]Initiative Level - LDC'!$G$167*1000","v":5167438.2766911807},null,null,{"$f":"SUM(G4:I4)","v":5167438.2766911807},null,{"$f":"B4-G4","v":603575.80418793019},null,null,{"$f":"SUM(L4:N4)","v":603575.80418793019},null,{"$f":"L4/G4","v":0.11680367947702174},0,null,{"$f":"O4/J4","v":0.11680367947702174}]
[2007,{"$f":"'[2]Initiative Level - LDC'!$H$331*1000","v":27552093.400315437},null,null,{"$f":"SUM(B5:D5)","v":27552093.400315437},null,{"$f":"'[2]Initiative Level - LDC'!$H$167*1000","v":9935709.405033052},null,null,{"$f":"SUM(G5:I5)","v":9935709.405033052},null,17616383.995282385,null,null,{"$f":"SUM(L5:N5)","v":17616383.995282385},null,{"$f":"L5/G5","v":1.7730373622198126},0,null,1.7730373622198126]
[2008,{"$f":"'[2]Initiative Level - LDC'!$I$331*1000","v":19658220.490221959},null,null,19658220.490221959,null,{"$f":"'[2]Initiative Level - LDC'!$I$167*1000","v":11642922.267121691},null,null,11642922.267121691,null,8015298.2231002674,null,null,8015298.2231002674,null,0.68842667151824688,0,null,0.68842667151824688]
[2009,{"$f":"'[2]Initiative Level - LDC'!$J$331*1000","v":28861543.722327568},null,null,28861543.722327568,null,{"$f":"'[2]Initiative Level - LDC'!$J$167*1000","v":19516778.466147497},null,null,19516778.466147497,null,9344765.2561800703,null,null,9344765.2561800703,null,0.47880674940225804,0,null,0.47880674940225804]
[2010,{"$f":"'[2]Initiative Level - LDC'!$K$331*1000","v":33971532.11663311},null,null,33971532.11663311,null,{"$f":"'[2]Initiative Level - LDC'!$K$167*1000","v":21547449.393191714},null,null,21547449.393191714,null,12424082.723441396,null,null,12424082.723441396,null,0.5765918042887711,0,null,0.5765918042887711]
[2011,{"$f":"'[2]Initiative Level - LDC'!$L$331*1000","v":31877404.276793193},{"$f":"'[1]2.5.2 Results - LDC'!$G$11","v":11420082.567430567},null,43297486.84422376,null,{"$f":"'[2]Initiative Level - LDC'!$L$167*1000","v":19422234.95707427},{"$f":"'[1]3.1.1 Summary - LDC'!$B$21*1000000","v":7350137.626871543},null,26772372.583945811,null,12455169.319718923,{"$f":"C9-H9","v":4069944.940559024},null,16525114.260277947,null,{"$f":"L9/G9","v":0.64128404106152093},0.55372363718464479,null,{"$f":"O9/J9","v":0.61724504275677516}]
[2012,{"$f":"'[2]Initiative Level - LDC'!$M$331*1000","v":30741594.184107628},{"$f":"[1]Sheet1!$C$73","v":11371248.017430568},{"$f":"C9","v":11420082.567430567},53532924.768968761,null,{"$f":"'[2]Initiative Level - LDC'!$M$167*1000","v":18853327.973227594},{"$f":"'[1]3.1.1 Summary - LDC'!$C$21*1000000","v":7301303.0768715432},{"$f":"H9","v":7350137.626871543},33504768.676970683,null,11888266.210880034,{"$f":"C10-H10","v":4069944.9405590249},{"$f":"D10-I10","v":4069944.940559024},20028156.091998085,null,0.63056592596075345,0.55742720137881363,{"$f":"N10/I10","v":0.55372363718464479},0.59777031398412039]
[2013,{"$f":"'[2]Initiative Level - LDC'!$N$331*1000","v":30453612.06899529},{"$f":"[1]Sheet1!$D$73","v":11371248.017430568},{"$f":"C10","v":11371248.017430568},53196108.103856422,null,{"$f":"'[2]Initiative Level - LDC'!$N$167*1000","v":18705307.670763351},{"$f":"'[1]3.1.1 Summary - LDC'!$D$21*1000000","v":7301303.0768715432},{"$f":"H10","v":7301303.0768715432},33307913.824506439,null,11748304.398231938,{"$f":"C11-H11","v":4069944.9405590249},{"$f":"D11-I11","v":4069944.9405590249},19888194.27934999,null,0.62807330438059017,0.55742720137881363,{"$f":"N11/I11","v":0.55742720137881363},0.59710116893352738]
[2014,{"$f":"'[2]Initiative Level - LDC'!$O$331*1000","v":28811951.517806482},{"$f":"[1]Sheet1!$E$73","v":11371248.017430568},11371248.017430568,51554447.552667618,null,{"$f":"'[2]Initiative Level - LDC'!$O$167*1000","v":17865939.839519329},{"$f":"'[1]3.1.1 Summary - LDC'!$E$21*1000000","v":7238674.3407178121},7301303.0768715432,32405917.257108685,null,10946011.678287152,{"$f":"C12-H12","v":4132573.676712756},4069944.9405590249,19148530.295558933,null,0.61267483136121692,0.5709020025209417,{"$f":"N12/I12","v":0.55742720137881363},0.5908961052894881]
[]
[]
[null,"2006 - 2010 Gross kW","2011 Gross kW","2012 Gross kW","Total Gross kW",null,"2006 - 2010 Net kW","2011 Net kW","2012 Net kW","Total Net kW",null,"2006 - 2010 Gross - Net","2011 Gross - Net","2012 Gross - Net","Total  Gross - Net",null,"2006 - 2010",2011,2012,"Total"]
[2006,{"$f":"'[2]Initiative Level - LDC'!$G$249*1000","v":4513.2172580262149},null,null,{"$f":"SUM(B16:D16)","v":4513.2172580262149},null,{"$f":"'[2]Initiative Level - LDC'!$G$85*1000","v":4467.0632232757334},null,null,{"$f":"SUM(G16:I16)","v":4467.0632232757334},null,{"$f":"B16-G16","v":46.154034750481514},null,null,{"$f":"SUM(L16:N16)","v":46.154034750481514},null,{"$f":"L16/G16","v":1.0332075559171601E-2},0,0,{"$f":"O16/J16","v":1.0332075559171601E-2}]
[2007,{"$f":"'[2]Initiative Level - LDC'!$H$249*1000","v":16038.971055460674},null,null,{"$f":"SUM(B17:D17)","v":16038.971055460674},null,{"$f":"'[2]Initiative Level - LDC'!$H$85*1000","v":6860.2868578993248},null,null,{"$f":"SUM(G17:I17)","v":6860.2868578993248},null,9178.6841975613497,null,null,{"$f":"SUM(L17:N17)","v":9178.6841975613497},null,{"$f":"L17/G17","v":1.337944664368151},0,0,1.337944664368151]
[2008,{"$f":"'[2]Initiative Level - LDC'!$I$249*1000","v":14892.973841952131},null,null,14892.973841952131,null,{"$f":"'[2]Initiative Level - LDC'!$I$85*1000","v":11306.958731271741},null,null,11306.958731271741,null,3586.0151106803896,null,null,3586.0151106803896,null,0.31715116291726797,0,0,0.31715116291726797]
[2009,{"$f":"'[2]Initiative Level - LDC'!$J$249*1000","v":15396.129906066946},null,null,15396.129906066946,null,{"$f":"'[2]Initiative Level - LDC'!$J$85*1000","v":12436.181636775273},null,null,12436.181636775273,null,2959.9482692916736,null,null,2959.9482692916736,null,0.23801101943853517,0,0,0.23801101943853517]
[2010,{"$f":"'[2]Initiative Level - LDC'!$K$249*1000","v":17173.203471519661},null,null,17173.203471519661,null,{"$f":"'[2]Initiative Level - LDC'!$K$85*1000","v":13055.061830607343},null,null,13055.061830607343,null,4118.1416409123176,null,null,4118.1416409123176,null,0.31544405490730143,0,0,0.31544405490730143]
[2011,{"$f":"'[2]Initiative Level - LDC'!$L$249*1000","v":11362.176079490975},{"$f":"'[1]2.5.2 Results - LDC'!$F$11","v":4124.8971129878746},null,15487.073192478849,null,{"$f":"'[2]Initiative Level - LDC'!$L$85*1000","v":7244.2215210182176},{"$f":"'[1]3.1.1 Summary - LDC'!$B$7*1000","v":2932.3500068921639},null,10176.571527910382,null,4117.9545584727575,{"$f":"C21-H21","v":1192.5471060957107},null,5310.5016645684682,null,0.56844680225818867,{"$f":"M21/H21","v":0.40668648124976919},0,0.5218360279789539]
[2012,{"$f":"'[2]Initiative Level - LDC'!$M$249*1000","v":11155.230151184709},{"$f":"[1]Sheet1!$C$36","v":2808.6971129878748},{"$f":"C21","v":4124.8971129878746},18088.824377160458,null,{"$f":"'[2]Initiative Level - LDC'!$M$85*1000","v":7142.6620478261875},{"$f":"'[1]3.1.1 Summary - LDC'!$C$7*1000","v":1768.5155068921636},{"$f":"H21","v":2932.3500068921639},11843.527561610515,null,4012.5681033585215,{"$f":"C22-H22","v":1040.1816060957112},{"$f":"D22-I22","v":1192.5471060957107},6245.2968155499429,null,0.56177487839841378,{"$f":"M22/H22","v":0.58816651708281398},{"$f":"N22/I22","v":0.40668648124976919},0.52731728643021714]
[2013,{"$f":"'[2]Initiative Level - LDC'!$N$249*1000","v":11108.013487166949},{"$f":"[1]Sheet1!$D$36","v":2808.6971129878748},{"$f":"C22","v":2808.6971129878748},16725.407713142697,null,{"$f":"'[2]Initiative Level - LDC'!$N$85*1000","v":7119.6077204202438},{"$f":"'[1]3.1.1 Summary - LDC'!$D$7* 1000","v":1768.5155068921636},{"$f":"H22","v":1768.5155068921636},10656.638734204571,null,3988.405766746705,{"$f":"C23-H23","v":1040.1816060957112},{"$f":"D23-I23","v":1040.1816060957112},6068.7689789381275,null,0.56020021374313644,{"$f":"M23/H23","v":0.58816651708281398},{"$f":"N23/I23","v":0.58816651708281398},0.56948247287948528]
[2014,{"$f":"'[2]Initiative Level - LDC'!$O$249*1000","v":10869.40133178217},{"$f":"[1]Sheet1!$E$36","v":2808.6971129878748},2808.6971129878748,16486.79555775792,null,{"$f":"'[2]Initiative Level - LDC'!$O$85*1000","v":6976.5104105365417},{"$f":"'[1]3.1.1 Summary - LDC'!$E$7*1000","v":1744.9173497003426},1768.5155068921636,10489.943267129047,null,{"$f":"B24-G24","v":3892.8909212456283},{"$f":"C24-H24","v":1063.7797632875322},1040.1816060957112,5996.8522906288727,null,{"$f":"L24/G24","v":0.55799972940142695},{"$f":"M24/H24","v":0.60964478545085055},0.58816651708281398,0.57167633207516177]

{"sheet":"Net To Gross Calculation","index":5,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[2,1,3,1],[15,1,16,1],[0,1,0,5]]}
[null,"NET to GROSS Calculation"]
[null,{"$f":"Admin!B5 & \" (kWh)\"","v":"Burlington Hydro Inc.    (kWh)"}]
[null,"Year","OPA 2006-2012 Final CDM Results (Gross)","OPA 2006-2012 Final CDM Results (Net)","Difference","% Difference of Net"]
[null,null,"(a)","(b)","(c) = (a) – (b)","(d) = (c) / (b)"]
[null,2006,{"$f":"'OPA Total Results'!E4","v":5771014.0808791108},{"$f":"'OPA Total Results'!J4","v":5167438.2766911807},{"$f":"C5-D5","v":603575.80418793019},{"$f":"E5/D5","v":0.11680367947702174}]
[null,2007,{"$f":"'OPA Total Results'!E5","v":27552093.400315437},{"$f":"'OPA Total Results'!J5","v":9935709.405033052},{"$f":"C6-D6","v":17616383.995282385},{"$f":"E6/D6","v":1.7730373622198126}]
[null,2008,{"$f":"'OPA Total Results'!E6","v":19658220.490221959},{"$f":"'OPA Total Results'!J6","v":11642922.267121691},8015298.2231002674,0.68842667151824688]
[null,2009,{"$f":"'OPA Total Results'!E7","v":28861543.722327568},{"$f":"'OPA Total Results'!J7","v":19516778.466147497},9344765.2561800703,0.47880674940225804]
[null,2010,{"$f":"'OPA Total Results'!E8","v":33971532.11663311},{"$f":"'OPA Total Results'!J8","v":21547449.393191714},12424082.723441396,0.5765918042887711]
[null,2011,{"$f":"'OPA Total Results'!E9","v":43297486.84422376},{"$f":"'OPA Total Results'!J9","v":26772372.583945811},16525114.260277949,0.61724504275677528]
[null,2012,{"$f":"'OPA Total Results'!E10","v":53532924.768968761},{"$f":"'OPA Total Results'!J10","v":33504768.676970683},20028156.091998078,0.59777031398412006]
[null,2013,{"$f":"'OPA Total Results'!E11","v":53196108.103856422},{"$f":"'OPA Total Results'!J11","v":33307913.824506439},19888194.279349983,0.59710116893352716]
[null,2014,{"$f":"'OPA Total Results'!E12","v":51554447.552667618},{"$f":"'OPA Total Results'!J12","v":32405917.257108685},{"$f":"C13-D13","v":19148530.295558933},{"$f":"E13/D13","v":0.5908961052894881}]
[]
[null,{"$f":"Admin!B5 & \" (kW)\"","v":"Burlington Hydro Inc.    (kW)"}]
[null,"Year","OPA 2006-2011 Final CDM Results (Gross)","OPA 2006-2011 Final CDM Results (Net)","Difference","% Difference of Net"]
[null,null,"(a)","(b)","(c) = (a) – (b)","(d) = (c) / (b)"]
[null,2006,{"$f":"'OPA Total Results'!E16","v":4513.2172580262149},{"$f":"'OPA Total Results'!J16","v":4467.0632232757334},{"$f":"C18-D18","v":46.154034750481514},{"$f":"E18/D18","v":1.0332075559171601E-2}]
[null,2007,{"$f":"'OPA Total Results'!E17","v":16038.971055460674},{"$f":"'OPA Total Results'!J17","v":6860.2868578993248},{"$f":"C19-D19","v":9178.6841975613497},{"$f":"E19/D19","v":1.337944664368151}]
[null,2008,{"$f":"'OPA Total Results'!E18","v":14892.973841952131},{"$f":"'OPA Total Results'!J18","v":11306.958731271741},3586.0151106803896,0.31715116291726797]
[null,2009,{"$f":"'OPA Total Results'!E19","v":15396.129906066946},{"$f":"'OPA Total Results'!J19","v":12436.181636775273},2959.9482692916736,0.23801101943853517]
[null,2010,{"$f":"'OPA Total Results'!E20","v":17173.203471519661},{"$f":"'OPA Total Results'!J20","v":13055.061830607343},4118.1416409123176,0.31544405490730143]
[null,2011,{"$f":"'OPA Total Results'!E21","v":15487.073192478849},{"$f":"'OPA Total Results'!J21","v":10176.571527910382},5310.5016645684664,0.52183602797895379]
[null,2012,{"$f":"'OPA Total Results'!E22","v":18088.824377160458},{"$f":"'OPA Total Results'!J22","v":11843.527561610515},6245.296815549942,0.52731728643021702]
[null,2013,{"$f":"'OPA Total Results'!E23","v":16725.407713142697},{"$f":"'OPA Total Results'!J23","v":10656.638734204571},6068.7689789381257,0.56948247287948517]
[null,2014,{"$f":"'OPA Total Results'!E24","v":16486.79555775792},{"$f":"'OPA Total Results'!J24","v":10489.943267129047},{"$f":"C26-D26","v":5996.8522906288727},{"$f":"E26/D26","v":0.57167633207516177}]

{"sheet":"Load Forecast Adjustment","index":6,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Load Forecast Adjustment Calculation"]
[null,{"$f":"Admin!B5","v":"Burlington Hydro Inc.   "}]
[]
[null,null,"2014 CDM Threshold \n(kWh of incremental CDM savings needed in 2014)","Application Factor\n1.0 Full Year\n0.5 Half Year","2014 Net kWh Load Forecast CDM Adjustment","2014 Net to Gross Adjustment","2014 Load Forecast CDM Adjustment "]
[null,null,"A","B","C = A * B","D","E = C * (1 + D)"]
[null,"Year"]
[null,2011,{"$f":"'CDM Target'!F15","v":7238674.3407178121},0,{"$f":"C8*D8","v":0},{"$f":"'Net To Gross Calculation'!F13","v":0.5908961052894881},{"$f":"E8*(1+F8)","v":0}]
[null,2012,{"$f":"'CDM Target'!F16","v":8142248},0,{"$f":"C9*D9","v":0},{"$f":"F8","v":0.5908961052894881},{"$f":"E9*(1+F9)","v":0}]
[null,2013,{"$f":"'CDM Target'!F17","v":9417793.2928891871},0,0,{"$f":"F9","v":0.5908961052894881},0]
[null,2014,{"$f":"'CDM Target'!F18","v":9417793.2928891871},0.5,4708896.6464445936,{"$f":"F10","v":0.5908961052894881},7491365.3350394359]
[null,null,{"$f":"SUM(C8:C11)","v":34216508.926496185},null,{"$f":"SUM(E8:E11)","v":4708896.6464445936},null,{"$f":"SUM(G8:G11)","v":7491365.3350394359}]
[]
[]
[null,null,"2014 CDM Threshold \n(kWh of incremental CDM savings needed in 2014)","Application Factor\n1.0 Full Year\n0.5 Half Year","2014 Net kW Load Forecast CDM Adjustment","2014 Net to Gross Adjustment","2014 Load Forecast CDM Adjustment "]
[null,null,"A","B","C = A * B","D","E = C * (1 + D)"]
[null,"Year"]
[null,2011,{"$f":"'CDM Target'!F33","v":1744.9173497003426},0,{"$f":"C18*D18","v":0},{"$f":"'Net To Gross Calculation'!F26","v":0.57167633207516177},{"$f":"E18*(1+F18)","v":0}]
[null,2012,{"$f":"'CDM Target'!F34","v":1873},0,{"$f":"C19*D19","v":0},{"$f":"F18","v":0.57167633207516177},{"$f":"E19*(1+F19)","v":0}]
[null,2013,{"$f":"'CDM Target'!F35","v":1725.5672098743889},0,0,{"$f":"F19","v":0.57167633207516177},0]
[null,2014,{"$f":"'CDM Target'!F36","v":1725.5672098743889},0.5,862.78360493719447,{"$f":"F20","v":0.57167633207516177},1356.0165715822752]
[null,null,{"$f":"SUM(C18:C21)","v":7069.0517694491209},null,{"$f":"SUM(E18:E21)","v":862.78360493719447},null,{"$f":"SUM(G18:G21)","v":1356.0165715822752}]

{"sheet":"Adjustment To Load Forecast","index":7,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,4,4,4],[2,6,4,6],[15,4,17,4],[15,6,17,6]]}
[null,"Adjustment To Load Forecast"]
[null,{"$f":"Admin!B5","v":"Burlington Hydro Inc.   "}]
[null,null,"Weather Normalized",null,"CDM Load Forecast Adjustment",null,"2014 CDM Adjusted Load Forecast"]
[null,"Retail","2014F"]
[null,"kWh","(Elenchus)"]
[null,null,"Source: Clarifying Question 7"]
[null,null,"A","C = A / B","E = D * C",null,"F = A - E"]
[null,"Residential (kWh)",555449406.54854131,{"$f":"C8/$C$13","v":0.33789596053105764},{"$f":"$E$13*D8","v":1591117.1553918722},null,{"$f":"C8-E8","v":553858289.39314938}]
[null,"GS<50 (kWh)",174342370.28596878,0.1060575130237187,{"$f":"$E$13*D9","v":499413.86740764277},null,{"$f":"C9-E9","v":173842956.41856113}]
[null,"GS>50 (kW)",899894473.08766222,0.54743187007793226,{"$f":"$E$13*D10","v":2577800.0971668675},null,897316672.99049532]
[null,"Street Lights (kW)",11000298.735369794,6.6918003034926749E-3,{"$f":"$E$13*D11","v":31510.996007793572},null,10968787.739362001]
[null,"USL (kWh)",3160882,1.9228560637988413E-3,{"$f":"$E$13*D12","v":9054.5304704180162},null,3151827.4695295822]
[null,"Total Customer (kWh)",{"$f":"SUM(C8:C12)","v":1643847430.657542},1,{"$f":"'Load Forecast Adjustment'!E12","v":4708896.6464445936},null,{"$f":"SUM(G8:G12)","v":1639138534.0110974},{"$f":"G13/C13-1","v":-2.8645582057216235E-3}]
[null,null,"B",null,"D"]
[]
[null,null,"Weather Normalized",null,"CDM Load Forecast Adjustment *",null,"2014 CDM Adjusted Load Forecast"]
[null,null,"2014F"]
[null,"kW","(Elenchus)"]
[null,null,"Source: Exhibit 10, Tab 1, Schedule 126"]
[null,null,"G","I = G / H","J = G / A * E",null,"K = G - J"]
[null,"Residential (kWh)",0,{"$f":"C21/$C$26","v":0},null,null,{"$f":"C21-E21","v":0}]
[null,"GS<50 (kWh)",0,0,null,null,{"$f":"C22-E22","v":0}]
[null,"GS>50 (kW)",2458215,0.98770000551179549,{"$f":"C23/C10*E10","v":7041.6999496781664},null,2451173.300050322]
[null,"Street Lights (kW)",30612.565335720745,1.2299994488204482E-2,{"$f":"C24/C11*E11","v":87.691475230630502},null,30524.873860490115]
[null,"USL (kWh)",0,0,null,null,0]
[null,"Total Customer (kWh)",{"$f":"SUM(C21:C25)","v":2488827.5653357208},1,{"$f":"SUM(E21:E25)","v":7129.3914249087966},null,{"$f":"SUM(G21:G25)","v":2481698.173910812},{"$f":"G26/C26-1","v":-2.8645582057217345E-3}]
[null,null,"H"]
[null,"* Note that CDM LF kW is the proportional LF kW over  LF kWh times kWH CDM LF adjustment."]

{"sheet":"LRAMVA Allocation","index":8,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,4,4,4],[14,4,16,4],[14,6,16,6]]}
[null,"LRAMVA Allocation"]
[null,{"$f":"Admin!B5","v":"Burlington Hydro Inc.   "}]
[null,null,"Weather Normalized",null,"LRAMVA (kWh)"]
[null,null,"2014F"]
[null,"kWh","(Elenchus)"]
[null,null,"A","C = A / B","E = D * C"]
[null,"Residential (kWh)",{"$f":"'Adjustment To Load Forecast'!C8","v":555449406.54854131},{"$f":"C7/$C$12","v":0.33789596053105764},{"$f":"$E$12*D7","v":11561620.149737936}]
[null,"GS<50 (kWh)",{"$f":"'Adjustment To Load Forecast'!C9","v":174342370.28596878},0.1060575130237187,{"$f":"$E$12*D8","v":3628917.8410980562}]
[null,"GS>50 (kW)",{"$f":"'Adjustment To Load Forecast'!C10","v":899894473.08766222},0.54743187007793226,{"$f":"$E$12*D9","v":18731207.469170067}]
[null,"Street Lights (kW)",{"$f":"'Adjustment To Load Forecast'!C11","v":11000298.735369794},6.6918003034926749E-3,{"$f":"$E$12*D10","v":228970.04481878699}]
[null,"USL (kWh)",{"$f":"'Adjustment To Load Forecast'!C12","v":3160882},1.9228560637988413E-3,{"$f":"$E$12*D11","v":65793.421671340373}]
[null,"Total Customer (kWh)",{"$f":"SUM(C7:C11)","v":1643847430.657542},1,{"$f":"'Load Forecast Adjustment'!C12","v":34216508.926496185}]
[null,null,"B",null,"D"]
[]
[null,null,"Weather Normalized",null,"Calculated (kW)",null,"LRAMVA (kW) * "]
[null,null,"2014F"]
[null,"kW","(Elenchus)"]
[null,null,"F","H = F / G","I = F / A * E",null,"K = J * H"]
[null,"Residential (kWh)",{"$f":"'Adjustment To Load Forecast'!C21","v":0},{"$f":"C19/$C$24","v":0}]
[null,"GS<50 (kWh)",{"$f":"'Adjustment To Load Forecast'!C22","v":0},0]
[null,"GS>50 (kW)",{"$f":"'Adjustment To Load Forecast'!C23","v":2458215},0.98770000551179549,{"$f":"C21/C9*E9","v":51167.483017023093},null,{"$f":"$G$24*D21","v":21680.01512098391}]
[null,"Street Lights (kW)",{"$f":"'Adjustment To Load Forecast'!C24","v":30612.565335720745},1.2299994488204482E-2,{"$f":"C22/C10*E10","v":637.19728214293741},null,{"$f":"$G$24*D22","v":269.98487901608837}]
[null,"USL (kWh)",{"$f":"'Adjustment To Load Forecast'!C25","v":0},0]
[null,"Total Customer (kWh)",{"$f":"SUM(C19:C23)","v":2488827.5653357208},1,{"$f":"SUM(E19:E23)","v":51804.68029916603},null,{"$f":"Admin!C9","v":21950}]
[null,null,"G",null,null,null,"J"]
[null,"* As Calculated (kW) exceeds the 2014 kW target therefore  LRAMVA is proposed to be the 2014 Target"]

{"sheet":"CDM Target By LDC","index":9,"n_rows":84,"n_cols":16,"rows_kept":84,"cut":false,"hidden":true,"merged":[[0,2,0,3]]}
[null,null,"Target",null,null,0.1,0.1,null,0.2,0.2,null,0.3,0.3,null,0.4,0.4]
[null,"Distributor","MW","MWh",null,"MW","MWh",null,"MW","MWh",null,"MW","MWh",null,"MW","MWh"]
[1,"Algoma Power Inc.   ",1.28,7.37,null,{"$f":"$C3*F$1","v":0.128},{"$f":"$D3*G$1","v":0.7370000000000001},null,{"$f":"$C3*I$1","v":0.25600000000000001},{"$f":"$D3*J$1","v":1.4740000000000002},null,{"$f":"$C3*L$1","v":0.38400000000000001},{"$f":"$D3*M$1","v":2.2109999999999999},null,{"$f":"$C3*O$1","v":0.51200000000000001},{"$f":"$D3*P$1","v":2.9480000000000004}]
[2,"Atikokan Hydro Inc.   ",0.2,1.1599999999999999,null,{"$f":"$C4*F$1","v":2.0000000000000004E-2},{"$f":"$D4*G$1","v":0.11599999999999999},null,{"$f":"$C4*I$1","v":4.0000000000000008E-2},{"$f":"$D4*J$1","v":0.23199999999999998},null,{"$f":"$C4*L$1","v":0.06},{"$f":"$D4*M$1","v":0.34799999999999998},null,{"$f":"$C4*O$1","v":8.0000000000000016E-2},{"$f":"$D4*P$1","v":0.46399999999999997}]
[3,"Attawapiskat Power Corporation   ",7.0000000000000007E-2,0.28999999999999998,null,7.000000000000001E-3,2.8999999999999998E-2,null,1.4000000000000002E-2,5.7999999999999996E-2,null,2.1000000000000001E-2,8.6999999999999994E-2,null,2.8000000000000004E-2,0.11599999999999999]
[4,"Bluewater Power Distribution Corporation  ",10.65,53.73,null,1.0650000000000002,5.3730000000000002,null,2.1300000000000003,10.746,null,3.1949999999999998,16.119,null,4.2600000000000007,21.492000000000001]
[5,"Brant County Power Inc.  ",3.3,9.85,null,0.33,0.98499999999999999,null,0.66,1.97,null,0.98999999999999988,2.9549999999999996,null,1.32,3.94]
[6,"Brantford Power Inc.   ",11.38,48.92,null,1.1380000000000001,4.8920000000000003,null,2.2760000000000002,9.7840000000000007,null,3.4140000000000001,14.676,null,4.5520000000000005,19.568000000000001]
[7,"Elenchus Hydro Inc.   ",21.95,82.37,null,2.1949999999999998,8.2370000000000001,null,4.3899999999999997,16.474,null,6.585,24.711000000000002,null,8.7799999999999994,32.948]
[7,"Burlington Hydro Inc.   ",21.95,82.37,null,2.1949999999999998,8.2370000000000001,null,4.3899999999999997,16.474,null,6.585,24.711000000000002,null,8.7799999999999994,32.948]
[8,"COLLUS Power Corporation   ",3.14,14.97,null,0.31400000000000006,1.4970000000000001,null,0.62800000000000011,2.9940000000000002,null,0.94199999999999995,4.4909999999999997,null,1.2560000000000002,5.9880000000000004]
[9,"Cambridge and North Dumfries Hydro Inc.",17.68,73.66,null,1.768,7.3659999999999997,null,3.536,14.731999999999999,null,5.3039999999999994,22.097999999999999,null,7.0720000000000001,29.463999999999999]
[10,"Canadian Niagara Power Inc.  ",4.07,15.81,null,0.40700000000000003,1.5810000000000002,null,0.81400000000000006,3.1620000000000004,null,1.2210000000000001,4.7430000000000003,null,1.6280000000000001,6.3240000000000007]
[11,"Centre Wellington Hydro Ltd.  ",1.64,7.81,null,0.16400000000000001,0.78100000000000003,null,0.32800000000000001,1.5620000000000001,null,0.49199999999999994,2.343,null,0.65600000000000003,3.1240000000000001]
[12,"Chapleau Public Utilities Corporation  ",0.17,1.21,null,1.7000000000000001E-2,0.121,null,3.4000000000000002E-2,0.24199999999999999,null,5.1000000000000004E-2,0.36299999999999999,null,6.8000000000000005E-2,0.48399999999999999]
[13,"Chatham-Kent Hydro Inc.   ",9.67,37.28,null,0.96700000000000008,3.7280000000000002,null,1.9340000000000002,7.4560000000000004,null,2.9009999999999998,11.183999999999999,null,3.8680000000000003,14.912000000000001]
[14,"Clinton Power Corporation   ",0.32,1.38,null,3.2000000000000001E-2,0.13799999999999998,null,6.4000000000000001E-2,0.27599999999999997,null,9.6000000000000002E-2,0.41399999999999998,null,0.128,0.55199999999999994]
[15,"Cooperative Hydro Embrun Inc.  ",0.34,1.1200000000000001,null,3.4000000000000002E-2,0.11200000000000002,null,6.8000000000000005E-2,0.22400000000000003,null,0.10200000000000001,0.33600000000000002,null,0.13600000000000001,0.44800000000000006]
[16,"E.L.K. Energy Inc.   ",2.69,8.25,null,0.26900000000000002,0.82500000000000007,null,0.53800000000000003,1.6500000000000001,null,0.80699999999999994,2.4750000000000001,null,1.0760000000000001,3.3000000000000003]
[17,"ENWIN Utilities Ltd.   ",26.81,117.89,null,2.681,11.789000000000001,null,5.3620000000000001,23.578000000000003,null,8.0429999999999993,35.366999999999997,null,10.724,47.156000000000006]
[18,"Enersource Hydro Mississauga Inc.  ",92.98,417.22,null,9.298,41.722000000000008,null,18.596,83.444000000000017,null,27.894000000000002,125.166,null,37.192,166.88800000000003]
[19,"Erie Thames Powerlines Corporation  ",4.28,18.600000000000001,null,0.42800000000000005,1.8600000000000003,null,0.85600000000000009,3.7200000000000006,null,1.284,5.58,null,1.7120000000000002,7.4400000000000013]
[20,"Espanola Regional Hydro Distribution Corporation ",0.52,2.76,null,5.2000000000000005E-2,0.27599999999999997,null,0.10400000000000001,0.55199999999999994,null,0.156,0.82799999999999996,null,0.20800000000000002,1.1039999999999999]
[21,"Essex Powerlines Corporation   ",7.19,21.54,null,0.71900000000000008,2.1539999999999999,null,1.4380000000000002,4.3079999999999998,null,2.157,6.4619999999999997,null,2.8760000000000003,8.6159999999999997]
[22,"Festival Hydro Inc.   ",6.23,29.25,null,0.62300000000000011,2.9250000000000003,null,1.2460000000000002,5.8500000000000005,null,1.869,8.7750000000000004,null,2.4920000000000004,11.700000000000001]
[23,"Fort Albany Power Corporation  ",0.05,0.24,null,5.000000000000001E-3,2.4E-2,null,1.0000000000000002E-2,4.8000000000000001E-2,null,1.4999999999999999E-2,7.1999999999999995E-2,null,2.0000000000000004E-2,9.6000000000000002E-2]
[24,"Fort Frances Power Corporation  ",0.61,3.64,null,6.0999999999999999E-2,0.36400000000000005,null,0.122,0.72800000000000009,null,0.183,1.0920000000000001,null,0.24399999999999999,1.4560000000000002]
[25,"Greater Sudbury Hydro Inc.  ",8.2200000000000006,43.71,null,0.82200000000000006,4.3710000000000004,null,1.6440000000000001,8.7420000000000009,null,2.4660000000000002,13.113,null,3.2880000000000003,17.484000000000002]
[26,"Grimsby Power Inc.   ",2.06,7.76,null,0.20600000000000002,0.77600000000000002,null,0.41200000000000003,1.552,null,0.61799999999999999,2.3279999999999998,null,0.82400000000000007,3.1040000000000001]
[27,"Guelph Hydro Electric Systems Inc. ",16.71,79.53,null,1.6710000000000003,7.9530000000000003,null,3.3420000000000005,15.906000000000001,null,5.0129999999999999,23.858999999999998,null,6.6840000000000011,31.812000000000001]
[28,"Haldimand County Hydro Inc.  ",2.85,13.3,null,0.28500000000000003,1.33,null,0.57000000000000006,2.66,null,0.85499999999999998,3.99,null,1.1400000000000001,5.32]
[29,"Halton Hills Hydro Inc.  ",6.15,22.48,null,0.6150000000000001,2.2480000000000002,null,1.2300000000000002,4.4960000000000004,null,1.845,6.7439999999999998,null,2.4600000000000004,8.9920000000000009]
[30,"Hearst Power Distribution Company Limited ",0.68,3.91,null,6.8000000000000005E-2,0.39100000000000001,null,0.13600000000000001,0.78200000000000003,null,0.20400000000000001,1.173,null,0.27200000000000002,1.5640000000000001]
[31,"Horizon Utilities Corporation   ",60.36,281.42,null,6.0360000000000005,28.142000000000003,null,12.072000000000001,56.284000000000006,null,18.108000000000001,84.426000000000002,null,24.144000000000002,112.56800000000001]
[32,"Hydro 2000 Inc.   ",0.19,1.04,null,1.9000000000000003E-2,0.10400000000000001,null,3.8000000000000006E-2,0.20800000000000002,null,5.6999999999999995E-2,0.312,null,7.6000000000000012E-2,0.41600000000000004]
[33,"Hydro Hawkesbury Inc.   ",1.82,9.2799999999999994,null,0.18200000000000002,0.92799999999999994,null,0.36400000000000005,1.8559999999999999,null,0.54600000000000004,2.7839999999999998,null,0.72800000000000009,3.7119999999999997]
[34,"Hydro One Brampton Networks Inc. ",45.61,189.54,null,4.5609999999999999,18.954000000000001,null,9.1219999999999999,37.908000000000001,null,13.683,56.861999999999995,null,18.244,75.816000000000003]
[35,"Hydro One Networks Inc.  ",213.66,1130.21,null,21.366,113.02100000000002,null,42.731999999999999,226.04200000000003,null,64.097999999999999,339.06299999999999,null,85.463999999999999,452.08400000000006]
[36,"Hydro Ottawa Limited   ",85.26,374.73,null,8.5260000000000016,37.473000000000006,null,17.052000000000003,74.946000000000012,null,25.577999999999999,112.419,null,34.104000000000006,149.89200000000002]
[37,"Innisfil Hydro Distribution Systems Limited ",2.5,9.1999999999999993,null,0.25,0.91999999999999993,null,0.5,1.8399999999999999,null,0.75,2.76,null,1,3.6799999999999997]
[38,"Kashechewan Power Corporation   ",7.0000000000000007E-2,0.33,null,7.000000000000001E-3,3.3000000000000002E-2,null,1.4000000000000002E-2,6.6000000000000003E-2,null,2.1000000000000001E-2,9.9000000000000005E-2,null,2.8000000000000004E-2,0.13200000000000001]
[39,"Kenora Hydro Electric Corporation Ltd. ",0.86,5.22,null,8.6000000000000007E-2,0.52200000000000002,null,0.17200000000000001,1.044,null,0.25800000000000001,1.5659999999999998,null,0.34400000000000003,2.0880000000000001]
[40,"Kingston Hydro Corporation   ",6.63,37.159999999999997,null,0.66300000000000003,3.7159999999999997,null,1.3260000000000001,7.4319999999999995,null,1.9889999999999999,11.147999999999998,null,2.6520000000000001,14.863999999999999]
[41,"Kitchener-Wilmot Hydro Inc.   ",21.56,90.29,null,2.1560000000000001,9.0290000000000017,null,4.3120000000000003,18.058000000000003,null,6.4679999999999991,27.087,null,8.6240000000000006,36.116000000000007]
[42,"Lakefront Utilities Inc.   ",2.77,13.59,null,0.27700000000000002,1.359,null,0.55400000000000005,2.718,null,0.83099999999999996,4.077,null,1.1080000000000001,5.4359999999999999]
[43,"Lakeland Power Distribution Ltd.  ",2.3199999999999998,10.18,null,0.23199999999999998,1.018,null,0.46399999999999997,2.036,null,0.69599999999999995,3.0539999999999998,null,0.92799999999999994,4.0720000000000001]
[44,"London Hydro Inc.   ",41.44,156.63999999999999,null,4.1440000000000001,15.664,null,8.2880000000000003,31.327999999999999,null,12.431999999999999,46.991999999999997,null,16.576000000000001,62.655999999999999]
[45,"Middlesex Power Distribution Corporation  ",2.4500000000000002,9.25,null,0.24500000000000002,0.92500000000000004,null,0.49000000000000005,1.85,null,0.73499999999999999,2.7749999999999999,null,0.98000000000000009,3.7]
[46,"Midland Power Utility Corporation  ",2.39,10.82,null,0.23900000000000002,1.0820000000000001,null,0.47800000000000004,2.1640000000000001,null,0.71699999999999997,3.246,null,0.95600000000000007,4.3280000000000003]
[47,"Milton Hydro Distribution Inc.  ",8.0500000000000007,33.5,null,0.80500000000000016,3.35,null,1.6100000000000003,6.7,null,2.415,10.049999999999999,null,3.2200000000000006,13.4]
[48,"Newmarket - Tay Power Distribution Ltd.",8.76,33.049999999999997,null,0.876,3.3049999999999997,null,1.752,6.6099999999999994,null,2.6279999999999997,9.9149999999999991,null,3.504,13.219999999999999]
[49,"Niagara Peninsula Energy Inc.  ",15.49,58.04,null,1.5490000000000002,5.8040000000000003,null,3.0980000000000003,11.608000000000001,null,4.6470000000000002,17.411999999999999,null,6.1960000000000006,23.216000000000001]
[50,"Niagara-on-the-Lake Hydro Inc.   ",2.42,8.27,null,0.24199999999999999,0.82699999999999996,null,0.48399999999999999,1.6539999999999999,null,0.72599999999999998,2.4809999999999999,null,0.96799999999999997,3.3079999999999998]
[51,"Norfolk Power Distribution Inc.  ",4.25,15.68,null,0.42500000000000004,1.5680000000000001,null,0.85000000000000009,3.1360000000000001,null,1.2749999999999999,4.7039999999999997,null,1.7000000000000002,6.2720000000000002]
[52,"North Bay Hydro Distribution Limited ",5.05,26.1,null,0.505,2.6100000000000003,null,1.01,5.2200000000000006,null,1.5149999999999999,7.83,null,2.02,10.440000000000001]
[53,"Northern Ontario Wires Inc.  ",1.06,5.88,null,0.10600000000000001,0.58799999999999997,null,0.21200000000000002,1.1759999999999999,null,0.318,1.764,null,0.42400000000000004,2.3519999999999999]
[54,"Oakville Hydro Electricity Distribution Inc. ",20.7,74.06,null,2.0699999999999998,7.4060000000000006,null,4.1399999999999997,14.812000000000001,null,6.21,22.218,null,8.2799999999999994,29.624000000000002]
[55,"Orangeville Hydro Limited   ",2.78,11.82,null,0.27799999999999997,1.1820000000000002,null,0.55599999999999994,2.3640000000000003,null,0.83399999999999996,3.5459999999999998,null,1.1119999999999999,4.7280000000000006]
[56,"Orillia Power Distribution Corporation  ",3.07,15.05,null,0.307,1.5050000000000001,null,0.61399999999999999,3.0100000000000002,null,0.92099999999999993,4.5149999999999997,null,1.228,6.0200000000000005]
[57,"Oshawa PUC Networks Inc.  ",12.52,52.24,null,1.252,5.2240000000000002,null,2.504,10.448,null,3.7559999999999998,15.672000000000001,null,5.008,20.896000000000001]
[58,"Ottawa River Power Corporation  ",1.61,8.9700000000000006,null,0.16100000000000003,0.89700000000000013,null,0.32200000000000006,1.7940000000000003,null,0.48299999999999998,2.6910000000000003,null,0.64400000000000013,3.5880000000000005]
[59,"PUC Distribution Inc.   ",5.58,30.83,null,0.55800000000000005,3.0830000000000002,null,1.1160000000000001,6.1660000000000004,null,1.6739999999999999,9.2489999999999988,null,2.2320000000000002,12.332000000000001]
[60,"Parry Sound Power Corporation  ",0.74,4.16,null,7.3999999999999996E-2,0.41600000000000004,null,0.14799999999999999,0.83200000000000007,null,0.222,1.248,null,0.29599999999999999,1.6640000000000001]
[61,"Peterborough Distribution Incorporated   ",8.7200000000000006,38.450000000000003,null,0.87200000000000011,3.8450000000000006,null,1.7440000000000002,7.6900000000000013,null,2.6160000000000001,11.535,null,3.4880000000000004,15.380000000000003]
[62,"Port Colborne Hydro Inc.  ",2.33,9.27,null,0.23300000000000001,0.92700000000000005,null,0.46600000000000003,1.8540000000000001,null,0.69899999999999995,2.7809999999999997,null,0.93200000000000005,3.7080000000000002]
[63,"PowerStream Inc.    ",95.57,407.34,null,9.5570000000000004,40.734000000000002,null,19.114000000000001,81.468000000000004,null,28.670999999999996,122.20199999999998,null,38.228000000000002,162.93600000000001]
[64,"Renfrew Hydro Inc.   ",1.05,4.8600000000000003,null,0.10500000000000001,0.48600000000000004,null,0.21000000000000002,0.97200000000000009,null,0.315,1.458,null,0.42000000000000004,1.9440000000000002]
[65,"Rideau St. Lawrence Distribution Inc. ",1.22,5.0999999999999996,null,0.122,0.51,null,0.24399999999999999,1.02,null,0.36599999999999999,1.5299999999999998,null,0.48799999999999999,2.04]
[66,"Sioux Lookout Hydro Inc.  ",0.51,3.32,null,{"$f":"$C69*F$1","v":5.1000000000000004E-2},{"$f":"$D69*G$1","v":0.33200000000000002},null,{"$f":"$C69*I$1","v":0.10200000000000001},{"$f":"$D69*J$1","v":0.66400000000000003},null,{"$f":"$C69*L$1","v":0.153},{"$f":"$D69*M$1","v":0.99599999999999989},null,{"$f":"$C69*O$1","v":0.20400000000000001},{"$f":"$D69*P$1","v":1.3280000000000001}]
[67,"St. Thomas Energy Inc.  ",3.94,14.92,null,0.39400000000000002,1.492,null,0.78800000000000003,2.984,null,1.1819999999999999,4.476,null,1.5760000000000001,5.968]
[68,"Thunder Bay Hydro Electricity Distribution Inc.",8.48,47.38,null,0.84800000000000009,4.7380000000000004,null,1.6960000000000002,9.4760000000000009,null,2.544,14.214,null,3.3920000000000003,18.952000000000002]
[69,"Tillsonburg Hydro Inc.   ",2.29,10.25,null,0.22900000000000001,1.0250000000000001,null,0.45800000000000002,2.0500000000000003,null,0.68699999999999994,3.0749999999999997,null,0.91600000000000004,4.1000000000000005]
[70,"Toronto Hydro-Electric System Limited  ",286.27,1303.99,null,28.626999999999999,130.399,null,57.253999999999998,260.798,null,85.880999999999986,391.197,null,114.508,521.596]
[71,"Veridian Connections Inc.   ",29.05,115.74,null,2.9050000000000002,11.574,null,5.8100000000000005,23.148,null,8.7149999999999999,34.721999999999994,null,11.620000000000001,46.295999999999999]
[72,"Wasaga Distribution Inc.   ",1.34,4.01,null,0.13400000000000001,0.40100000000000002,null,0.26800000000000002,0.80200000000000005,null,0.40200000000000002,1.2029999999999998,null,0.53600000000000003,1.6040000000000001]
[73,"Waterloo North Hydro Inc.  ",15.79,66.489999999999995,null,1.579,6.649,null,3.1579999999999999,13.298,null,4.7369999999999992,19.946999999999999,null,6.3159999999999998,26.596]
[74,"Welland Hydro-Electric System Corp.  ",5.56,20.6,null,0.55599999999999994,2.06,null,1.1119999999999999,4.12,null,1.6679999999999999,6.1800000000000006,null,2.2239999999999998,8.24]
[75,"Wellington North Power Inc.  ",0.93,4.5199999999999996,null,9.3000000000000013E-2,0.45199999999999996,null,0.18600000000000003,0.90399999999999991,null,0.27900000000000003,1.3559999999999999,null,0.37200000000000005,1.8079999999999998]
[76,"West Coast Huron Energy Inc. ",0.88,8.2799999999999994,null,8.8000000000000009E-2,0.82799999999999996,null,0.17600000000000002,1.6559999999999999,null,0.26400000000000001,2.4839999999999995,null,0.35200000000000004,3.3119999999999998]
[77,"West Perth Power Inc.  ",0.62,2.99,null,6.2E-2,0.29900000000000004,null,0.124,0.59800000000000009,null,0.186,0.89700000000000002,null,0.248,1.1960000000000002]
[78,"Westario Power Inc.   ",4.24,20.95,null,0.42400000000000004,2.0950000000000002,null,0.84800000000000009,4.1900000000000004,null,1.272,6.2849999999999993,null,1.6960000000000002,8.3800000000000008]
[79,"Whitby Hydro Electric Corporation  ",10.9,39.07,null,1.0900000000000001,3.907,null,2.1800000000000002,7.8140000000000001,null,3.27,11.721,null,4.3600000000000003,15.628]
[80,"Woodstock Hydro Services Inc.  ",4.49,18.88,null,0.44900000000000007,1.8879999999999999,null,0.89800000000000013,3.7759999999999998,null,1.347,5.6639999999999997,null,1.7960000000000003,7.5519999999999996]
[null,null,{"$f":"SUM(C3:C83)","v":1351.99},{"$f":"SUM(D3:D83)","v":6082.3399999999983},null,{"$f":"SUM(F3:F83)","v":135.19900000000007},{"$f":"SUM(G3:G83)","v":608.23400000000004},null,{"$f":"SUM(I3:I83)","v":270.39800000000014},{"$f":"SUM(J3:J83)","v":1216.4680000000001},null,{"$f":"SUM(L3:L83)","v":405.59699999999987},{"$f":"SUM(M3:M83)","v":1824.7020000000002},null,{"$f":"SUM(O3:O83)","v":540.79600000000028},{"$f":"SUM(P3:P83)","v":2432.9360000000001}]

{"sheet":"Sheet1","index":10,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
["Table 16 – Burlington Hydro Forecast Summary"]
[null,"Residential Class",null,null,null,null,"GS<50 kW Class"]
["Year","Actual kWh","%","Normalized kWh","%",null,"Actual kWh","%","Normalized kWh","%"]
[2010,556896336,6.3E-2,543050505,1.0999999999999999E-2,null,172200325,-1E-3,174251015,3.0000000000000001E-3]
[2011,551353006,-0.01,546837854,7.0000000000000001E-3,null,174484065,1.2999999999999999E-2,174045762,-1E-3]
[2012,551839571,1E-3,552064145,0.01,null,174704767,1E-3,174672454,4.0000000000000001E-3]
[2013,null,null,553523828,3.0000000000000001E-3,null,null,null,173805678,-5.0000000000000001E-3]
[2014,null,null,556904597,6.0000000000000001E-3,null,null,null,174117497,2E-3]
[]
[]
[null,"GS>50 kW Class",null,null,null,null,"GS>50 kW Class"]
["Year","Actual kWh","%","Normalized kWh","%",null,"Actual kW","%","Normalized kW","%"]
[2010,906197008,3.1E-2,900569510,3.0000000000000001E-3,null,2403006,2.1000000000000001E-2,2388083,-6.0000000000000001E-3]
[2011,908229110,2E-3,899364853,-1E-3,null,2396756,-3.0000000000000001E-3,2373364,-6.0000000000000001E-3]
[2012,903337846,-5.0000000000000001E-3,903067037,4.0000000000000001E-3,null,2423043,1.0999999999999999E-2,2422317,2.1000000000000001E-2]
[2013,null,null,897955770,-6.0000000000000001E-3,null,null,null,2408607,-6.0000000000000001E-3]
[2014,null,null,899785875,2E-3,null,null,null,2413515,2E-3]
[]
[null,"Streetlight",null,"Streetlight",null,null,null,null,"USL"]
["Year","kWh","%","kW","%",null,null,null,"kWh","%"]
[2010,9467387,8.0000000000000002E-3,26416,2.1000000000000001E-2,null,null,null,3512551,7.0000000000000001E-3]
[2011,9847280,0.04,27334,3.5000000000000003E-2,null,null,null,3296779,-6.0999999999999999E-2]
[2012,9866380,2E-3,27457,4.0000000000000001E-3,null,null,null,3353868,1.7000000000000001E-2]
[2013,10006706,1.4E-2,27848,1.4E-2,null,null,null,3353868,0]
[2014,10149029,1.4E-2,28244,1.4E-2,null,null,null,3353868,0]
[null,"Total Retail "]
["Year","Actual kWh","%","Norm/Forecast kWh","%"]
[2010,1648273607,3.7999999999999999E-2,1630850967,6.0000000000000001E-3]
[2011,1647210240,-1E-3,1633392528,2E-3]
[2012,1643102432,-2E-3,1643023884,6.0000000000000001E-3]
[2013,null,null,1638645849,-3.0000000000000001E-3]
[2014,null,null,1644310865,3.0000000000000001E-3]