{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":1,"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":"Sheet1","index":0,"n_rows":77,"n_cols":6,"rows_kept":77,"cut":false,"hidden":false,"merged":[[62,0,62,5],[64,0,64,5],[66,0,66,5],[69,1,69,5],[76,0,76,5],[58,0,58,5],[20,0,20,5],[27,0,27,5],[35,0,35,5],[36,0,36,5],[38,0,38,5],[40,0,40,4],[43,0,43,1],[47,0,47,1],[49,0,49,5],[50,0,50,5],[52,0,52,5],[19,0,19,5],[8,0,8,5],[9,0,9,5],[13,0,13,5],[15,0,15,5],[17,0,17,5]]}
[null,null,null,null,"File Number:",{"$f":"EBNUMBER","v":"EB-2013-0160"}]
[null,null,null,null,"Exhibit:",3]
[null,null,null,null,"Tab:",2]
[null,null,null,null,"Schedule:",5]
[null,null,null,null,"Page:",1]
[]
[null,null,null,null,"Date:","2014-02-12"]
[]
["Appendix 2-I"]
["Load Forecast CDM Adjustment Work Form (2014)"]
[]
["Input the 2011-2014 CDM target in Cell B21."]
[]
["Input the measured results for 2011 CDM programs for each of the years 2011 and persistence into 2012, 2013 and 2014 into cells B29 to E29.  These results are taken from the final 2011 CDM Report issued by the OPA for that distributor in the fall of 2012."]
[]
["Measured results for 2012 CDM programs for each of the years 2012 and persistence into 2013 and 2014 are input into cells C30 to E30.  These results are taken from the final 2012 CDM Report issued by the OPA for that distributor in the fall of 2013.  Until that report is issued, the distributor should use the results from the preliminary 2012 CDM Report issued in the spring of 2013."]
[]
["\tBased on these inputs, the residual kWh to achieve the 4 year CDM target is allocated so that there is an equal incremental increase in each of the years 2012, 2013 and 2014.\r\n"]
[]
["4 Year (2011-2014) kWh Target:"]
[11820000]
[null,2011,2012,2013,2014,"Total"]
["2011 CDM Programs",{"$f":"'[2]CDM Data'!O6","v":9.8138747884940772E-2},{"$f":"'[2]CDM Data'!P6","v":9.560067681895093E-2},{"$f":"'[2]CDM Data'!Q6","v":9.560067681895093E-2},{"$f":"'[2]CDM Data'!R6","v":9.475465313028765E-2},{"$f":"SUM(B23:E23)","v":0.38409475465313025}]
["2012 CDM Programs",null,{"$f":"'[2]CDM Data'!P7","v":8.4602368866328256E-2},{"$f":"'[2]CDM Data'!Q7","v":7.6142131979695438E-2},{"$f":"'[2]CDM Data'!R7","v":7.6142131979695438E-2},{"$f":"SUM(B24:E24)","v":0.23688663282571915}]
["2013 CDM Programs",null,null,{"$f":"'[2]CDM Data'!Q8","v":0.12633953750705021},{"$f":"'[2]CDM Data'!R8","v":0.12633953750705021},0.25267907501410042]
["2014 CDM Programs",null,null,null,{"$f":"'[2]CDM Data'!R9","v":0.12633953750705021},0.12633953750705021]
["Total in Year",{"$f":"SUM(B23:B26)","v":9.8138747884940772E-2},{"$f":"SUM(C23:C26)","v":0.18020304568527917},0.29808234630569658,0.42357586012408344,{"$f":"SUM(B27:E27)","v":0.99999999999999989}]
["kWh"]
["2011 CDM Programs",{"$f":"'[2]CDM Data'!O12","v":1160000},{"$f":"'[2]CDM Data'!P12","v":1130000},{"$f":"'[2]CDM Data'!Q12","v":1130000},{"$f":"'[2]CDM Data'!R12","v":1120000},{"$f":"SUM(B29:E29)","v":4540000}]
["2012 CDM Programs",null,{"$f":"'[2]CDM Data'!P13","v":1000000},{"$f":"'[2]CDM Data'!Q13","v":900000},{"$f":"'[2]CDM Data'!R13","v":900000},{"$f":"SUM(B30:E30)","v":2800000}]
["2013 CDM Programs",null,null,{"$f":"'[2]CDM Data'!Q14","v":1493333.3333333335},{"$f":"'[2]CDM Data'!R14","v":1493333.3333333335},2986666.666666667]
["2014 CDM Programs",null,null,null,{"$f":"'[2]CDM Data'!R15","v":1493333.3333333335},1493333.3333333335]
["Total in Year",{"$f":"SUM(B29:B32)","v":1160000},{"$f":"SUM(C29:C32)","v":2130000},3523333.3333333335,5006666.666666667,{"$f":"A21","v":11820000}]
[]
[null,null,null,null,"Check",{"$f":"SUM(F29:F32)","v":11820000.000000002}]
["From each of the 2006-2010 CDM Final Report, 2011 CDM Final Report, and the 2012 CDM Final Report, issued by the OPA for the distributor, the distributor should input the \"gross\" and \"net\" results of the cumulative CDM savings for 2014 into cells D31 to E33.  The model will calculate the cumulative savings for all programs from 2006 to 2012 and determine the \"net\" to \"gross\" factor \"g\"."]
["The Board has determined that the \"net\" number should be used in its Decision and Order with respect to Centre Wellington Hydro Ltd.'s 2013 Cost of Service rates (EB-2012-0113).  This approach has also been used in Settlement Agreements accepted by the Board in other 2013 applications.  The distributor should select whether the adjustment is done on a \"net\" or \"gross\" basis, but must support a proposal for the adjustment being done on a \"gross\" basis."]
[]
["Net-to-Gross Conversion"]
[]
["Is CDM adjustment being done on a \"net\" or \"gross\" basis?",null,null,null,null,"net"]
[]
[null,null,"\"Gross\"","\"Net\"","Difference","\"Net-to-Gross\" Conversion Factor"]
["Persistence of Historical CDM programs to 2014",null,"kWh","kWh","kWh","('g')"]
["2006-2010 CDM programs",null,{"$f":"'[2]CDM Data'!$J$33","v":16402218.111356732},{"$f":"'[2]CDM Data'!$K$33","v":9965809.543160852},{"$f":"C45-D45","v":6436408.5681958795},{"$f":"E45/C45","v":0.39241086324412272}]
["2011 CDM program",null,{"$f":"'[2]CDM Data'!B8","v":5120585.2662061835},{"$f":"'[2]CDM Data'!C8","v":3065642.8522753869},{"$f":"C46-D46","v":2054942.4139307966},{"$f":"E46/C46","v":0.40131006654504814}]
["2012 CDM program",null,{"$f":"'[2]CDM Data'!B9","v":4972773.3822379196},{"$f":"'[2]CDM Data'!C9","v":3002780.7271086173},1969992.6551293023,0.39615572713726555]
["2006 to 2011 OPA CDM programs:  Persistence to 2013",null,{"$f":"SUM(C45:C47)","v":26495576.759800833},{"$f":"SUM(D45:D47)","v":16034233.122544855},{"$f":"C48-D48","v":10461343.637255978},{"$f":"IF(D48=0,0,IF(F41=\"net\",0,E48/D48))","v":0}]
[]
["The default values represent the factor that each year's CDM program is factored into the manual CDM adjustment.  Distributors can choose alternative weights of \"0\", \"0.5\" or \"1\" from the drop-down menu for each cell, but must support its alternatives."]
["These factors do not mean that CDM programs are excluded, but also reflect the assumption that impacts of 2011 and 2012 programs are already implicitly reflected in the actual data for those years that are the basis for the load forecast prior to any manual CDM adjustment."]
[]
["Weight Factor for Inclusion in CDM Adjustment to 2014 Load Forecast"]
[null,2011,2012,2013,2014]
["Weight Factor for each year's CDM program impact on 2014 load forecast",0,0.5,1,0.5,"Utility can select \"0\", \"0.5\", or \"1\" from drop-down list"]
["Default Value selection rationale.  ","Persistence of 2011 CDM programs for the full year of 2012 means that all of 2011 CDM impact is assumed to be in the base forecast before the CDM Adjustment","50% of 2012 CDM impact is assumed reflected in base forecast based on 1/2 year rule.","Full year impact of 2013 CDM programs on adjustment for 2014 load forecast","Only 50% of 2014 CDM impact is used based on a half year rule"]
[]
[]
["The Amount used for the CDM threshold of the LRAMVA is the kWh that will be used to determine the base amount for the LRAMVA balance for 2014, for assessing performance against the four-year target.  The base amount for 2011-2013 is 0 (zero) for 2014 Cost of Service applications, as the utility rebased prior to the 2011-2014 CDM programs, and there was no adjustment to reflect the impacts of the 2011-2014 programs on the load forecast used to determine their last cost of service-based rates."]
[]
["The proposed loss factor should correspond with the loss factor calculated in Appendix 2-R "]
[]
["The Manual Adjustment for the 2014 Load Forecast is the amount manually subtracted from the load forecast derived from the base forecast from historical data, and is intended to reflect the further CDM savings that the distributor needs to achieve assuming that they meet 100% of the 2011-2014 CDM target that is a condition of their target. "]
[]
["If the distributor has developed their load forecast on a system purchased basis, then the manual adjustment should be on system purchased basis, including the adjustment for losses.  If the load forecast has been developed on a billed basis, either on a system basis or on a class-specific basis, the manual adjustment should be on a billed basis, excluding losses."]
[]
["The distributor should determine the allocation of the savings to all customer classes in a reasonable manner, for both the LRAMVA and for the load forecast adjustment."]
[]
[null,2011,2012,2013,2014,"Total for 2014"]
[null,"kWh"]
["Amount used for CDM threshold for LRAMVA (2014)",{"$f":"E29","v":1120000},{"$f":"E30","v":900000},{"$f":"E31","v":1493333.3333333335},{"$f":"E32","v":1493333.3333333335},{"$f":"SUM(B71:E71)","v":5006666.666666667}]
[]
["Manual Adjustment for 2014 Load Forecast (billed basis)",{"$f":"B71*(1+F48)*B55","v":0},{"$f":"C71*(1+F48)*C55","v":450000},{"$f":"D71*(1+F48)*D55","v":1493333.3333333335},{"$f":"E71*(1+F48)*E55","v":746666.66666666674},{"$f":"SUM(B73:E73)","v":2690000}]
[]
["Proposed Loss Factor (TLF)",{"$f":"'[2]Rate Class Energy Model'!$F$20-1","v":4.8075541678928246E-2}," Format: X.XX%"]
["Manual Adjustment for 2014 Load Forecast (system purchased basis)",{"$f":"B73*(1+$B75)","v":0},{"$f":"C73*(1+$B75)","v":471633.9937555177},{"$f":"D73*(1+$B75)","v":1565126.1422405329},782563.07112026645,{"$f":"SUM(B76:E76)","v":2819323.207116317}]
["Manual adjustment uses \"gross\" versus \"net\" (i.e. numbers multiplied by (1 + g).  The Weight factor is also used calculate the impact of each year's program on the CDM adjustment to the 2014 load forecast."]