{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Valuation Framework","Dashboard","Deferral Value Calculation","Bridge to Wires Calculation","EJ Impacts Calculation","ICE Calculator Results","Reference Utility Data","Mappings"],"not_rendered":{"charts":4,"images":9,"macros":1,"external_links":0,"defined_names":40,"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":"Cover","index":0,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Grid Services Valuation Model"]
[]
[]
[null,"Prepared for","Prepared by"]
[]
[]
[]
[]
[]
[]
[null,"September 2025"]
[]
[null,"Instructions"]
[]
[null,"View the Valuation Calculator Tool training on the Grid Services Study website."]
[null,"Start with the green tabs and work through each blue calculation tab, entering user inputs."]
[null,"Review each blue calculation tab to understand how each value streams are calculated."]
[null,"Explore the \"Dashboard\" tab to understand how the selected value streams inform an example compensation structure."]
[]
[]
[null,"Table of Contents"]
[]
[]
[null,"Sheet","Description"]
[null,"Valuation Framework","Diagram of the valuation framework to illustrate how each value stream flows into the compensation."]
[null,"Dashboard","Dashboard for User Inputs and Compensation calculations. Valuation user inputs for project-specific data applicable to all valuation calculations. Compensation user inputs to determine customer compensation levels, which are provided as an output in this tab."]
[null,"Deferral Value Calculation","Calculations for Deferral Value. Deferral Value reflects benefits of delaying investments related to the time value of money."]
[null,"Bridge to Wires Calculation","Calculations for Bridge to Wires Value. Bridge-to-Wires solutions are designed to bridge the gap between an imminent capacity constraint and the time it takes to complete construction of a traditional infrastructure solution."]
[null,"EJ Impacts Calculation","Calculations for Environmental Justice Value. Environmental Justice values include an EJ Participant adder to encourage participation by EJ customers and an Air Quality adder to value the benefits of reducing air pollution from backup diesel generation in EJ-designated communities."]
[null,"ICE Calculator Results","Results from DOE's Interruptible Cost Estimate calculator applied to Bridge to Wires calculation."]
[null,"Reference Utility Data","Utility-specific data that is  applied in the valuation calculations."]
[null,"Mappings","Dropdown input selections"]
[null,"*Optionality Value is calculated in a separate model and will not feed into the compensation calculation in the pilot Grid Services offerings."]
[]
[null,"Cell Style Legend"]
[]
[null,"Cells in this Valuation Model are color-coded to indicate intent:"]
[]
[null,"User Inputs"]
[null,"Dropdown User Inputs"]
[null,"Hard-coded input - Do not modify"]
[null,"Calculations or Fixed Values - Do not modify"]
[null,"Calculations (different formula than neighboring cells) - Do not modify"]
[null,"Outputs - Do not modify"]
[]
[null,"Table Headers"]
[null,"Table Sub-Headers"]
[null,"Table Index (Row Descriptions)"]

{"sheet":"Valuation Framework","index":1,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,5,43,14]]}
[]
[]
[]
[null,"Valuation Framework"]
[]
[null,"Rate Impact value streams provide the primary basis for determining valuing grid services and establishing baseline compensation"]
[null,"Separate EJ Participant and Air Quality Adders may be considered in compensation design to further support EJ participation or benefits"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"*Other rate impact and non-rate impact value streams may be assessed in the future when better data and quantification methods are made available. Other value steams may include optionality value, the value of accelerated interconnections, or avoided construction-related impacts."]

{"sheet":"Dashboard","index":2,"n_rows":65,"n_cols":31,"rows_kept":65,"cut":false,"hidden":false,"merged":[[34,1,34,11],[32,4,32,16]]}
[]
[]
[]
[null,"Valuation User Inputs"]
[]
[null,"Project-Specific Planning Inputs",null,"Explanation"]
[null,"In-Service Date of Planned Upgrade (by Jan 1)",2032,"Planned in-service year for a traditional asset upgrade if no deferral solution is implemented. A non-blank user input overrides use of the specified load forecast and capacity limit"]
[null,"Adjusted Plant-in-service Year (by Jan 1)",2035,"The new required in-service year for the traditional asset upgrade once a deferral solution has been implemented. A non-blank user input overrides use of the specified load forecast and capacity limit plus DER impact"]
[null,"Years of Deferral",3]
[]
[null,"Capacity Need for Load Relief (MW)",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
[null,"Annual Capacity Need",null,null,null,null,null,null,null,1.4343285985331846,4.8101373902930504,8.2703414018469061]
[null,"Forecasted capacity need at deferral or bridge-to-wires project location"]
[]
[]
[null,"Example - Grid Services Compensation User Inputs & Calculations"]
[]
[null,"The compensation user inputs and calculations take the outputs from the valuation calculation to determine what the total compensation for DERs would be for the example location."]
[]
[null,"Compensation Structure Inputs",null,"Explanation"]
[null,"Capacity Constraint Scenario","Deferral","Is this a deferral or bridge-to-wires solution?"]
[null,"EJ Customer Participation (% of Capacity)",0.12,"How much capacity is enrolled to EJ customers? -- EJ participation adder will apply to these participants for Deferral and Bridge-to-Wires solutions"]
[null,"Localized EJ Impact","Yes","Is the project in an Air Quality district? -- If yes, localized EJ impact adder will be applied to Bridge-to-Wires solutions"]
[null,"Reservation Payment","Yes","Would you like to provide a reservation payment, i.e., a payment for years before the solution's capacity is needed? In this example, the reservation payment stops when activation payment begins. In practice, structures may vary"]
[null,"Reservation % of Total Value",0.1,"Used to set a theoretical reservation payment as a % of the total compensation."]
[null,"Reservation Payment Start Year",2027,"Must be before \"Adjusted plant-in-service start year\""]
[null,"Enrollment Reserve Margin",0.25,"How much more capacity should be enrolled over the capacity need? This input is only applied within the Compensation Calculation"]
[]
[null,"Total Compensation","Guideline Ceiling","User Input Compensation"]
[null,"Total Grid Service Compensation Available",{"$f":"_xlfn.IFS($C$21=\"Deferral\",'Deferral Value Calculation'!$C$62,$C$21=\"Bridge-to-Wires\",(('Bridge to Wires Calculation'!$E$57+IF($C$23=\"Yes\",'EJ Impacts Calculation'!$E$25))*MIN(IF(Dashboard!$D$12:$AC$12>0, Dashboard!$D$12:$AC$12))*1000))","v":4176884.5755459666},{"$f":"SUM(D31:D32)","v":1253065.3726637899}]
[null,"Value allocated to all non-EJ Participants (Total $)",{"$f":"C30-C32","v":3589510.1821098151},{"$f":"D33*(MAX(Dashboard!$C$12:$AB$12)*(1+$C$27)*Dashboard!$C$9*1000)*(1-$C$22)","v":1076853.0546329445}]
[null,"Value allocated to all EJ Participants (Total $)",{"$f":"C30/(1+(1-C22)/((1+'EJ Impacts Calculation'!$E$8)*C22))","v":587374.39343615156},{"$f":"D34*(MAX(Dashboard!$C$12:$AB$12)*(1+$C$27)*Dashboard!$C$9*1000)*$C$22","v":176212.31803084546}]
[null,"Baseline (Non-EJ Participant) Incentive ($/kW-yr)",{"$f":"C31/(MAX(Dashboard!$C$12:$AB$12)*(1+$C$27)*(1-$C$22)*Dashboard!$C$9*1000)","v":131.52182060733153},{"$f":"C33*0.3","v":39.45654618219946},"User should input a value in the yellow cell which is between zero and the Guideline Ceiling for the Baseline incentive, less any expected costs for program administration. This will form the present value basis for compensation. The actual dollar value issued in individual years will vary from this input due to discounting and any reservation payments."]
[null,"EJ Participant Incentive ($/kW-yr)",{"$f":"C33*(1+'EJ Impacts Calculation'!$E$8)","v":157.82618472879784},{"$f":"D33*(1+'EJ Impacts Calculation'!$E$8)","v":47.347855418639348},"Calculated as the Baseline Incentive * (1 + EJ Participant adder).  Incentives shown in this table do not account for enrollment reserve margins"]
[null,"The guideline ceiling is to be regarded as an upper bound and is based on the value provided to the distribution grid, adjusted for EJ adders. To avoid a cost shift, actual compensation must be lower than this value, minus program and sunk costs.\nCost shifts may still occur if the Value of Lost Load is applied in B2W scenarios and the guideline ceiling is used"]
[]
[null,"Net Benefit Shared with Ratepayers"]
[null,"Total $",{"$f":"C30-D30","v":2923819.2028821767},"This core output value (less costs of administration) reflects the net benefit that DER grid services would be providing to ratepayers"]
[null,"High positive values put downward pressure on rates. Low or negative values would indicate that ratepayers are subsidizing the program (when factoring in additional program administration or sunk costs)"]
[]
[]
[null,"Example - Grid Services Compensation Calculation",null,null,"The below represents one potential compensation structure designed around the user inputs above. This does not reflect an actual grid services offering"]
[]
[null,null,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
[null,"Discounting Index",{"$f":"1/(1+discount_rate_nom)^(C$44-$C$44)","v":1},0.92592592592592582,0.85733882030178321,0.79383224102016958,0.73502985279645328,0.68058319703375303,0.63016962688310452,0.58349039526213387,0.54026888450197574,0.50024896713145905,0.46319348808468425,0.42888285933767062,0.39711375864599124,0.36769792467221413,0.34046104136316119,0.31524170496588994,0.29189046756100923,0.27026895144537894,0.25024902911609154,0.23171206399638106,0.21454820740405653,0.19865574759634863,0.18394050703365611,0.17031528429042234,0.1576993373059466,0.1460179049129135]
[null,"Reservation Payment Years",{"$f":"IF(AND(C$44>=$C$26, C$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(D$44>=$C$26, D$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(E$44>=$C$26, E$44<Dashboard!$C$7),1,0)","v":1},{"$f":"IF(AND(F$44>=$C$26, F$44<Dashboard!$C$7),1,0)","v":1},{"$f":"IF(AND(G$44>=$C$26, G$44<Dashboard!$C$7),1,0)","v":1},{"$f":"IF(AND(H$44>=$C$26, H$44<Dashboard!$C$7),1,0)","v":1},{"$f":"IF(AND(I$44>=$C$26, I$44<Dashboard!$C$7),1,0)","v":1},{"$f":"IF(AND(J$44>=$C$26, J$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(K$44>=$C$26, K$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(L$44>=$C$26, L$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(M$44>=$C$26, M$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(N$44>=$C$26, N$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(O$44>=$C$26, O$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(P$44>=$C$26, P$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(Q$44>=$C$26, Q$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(R$44>=$C$26, R$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(S$44>=$C$26, S$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(T$44>=$C$26, T$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(U$44>=$C$26, U$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(V$44>=$C$26, V$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(W$44>=$C$26, W$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(X$44>=$C$26, X$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(Y$44>=$C$26, Y$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(Z$44>=$C$26, Z$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(AA$44>=$C$26, AA$44<Dashboard!$C$7),1,0)","v":0},{"$f":"IF(AND(AB$44>=$C$26, AB$44<Dashboard!$C$7),1,0)","v":0}]
[null,"Activation Payment Years",{"$f":"IF(C$44>=Dashboard!$C$7,IF(C$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(D$44>=Dashboard!$C$7,IF(D$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(E$44>=Dashboard!$C$7,IF(E$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(F$44>=Dashboard!$C$7,IF(F$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(G$44>=Dashboard!$C$7,IF(G$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(H$44>=Dashboard!$C$7,IF(H$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(I$44>=Dashboard!$C$7,IF(I$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(J$44>=Dashboard!$C$7,IF(J$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":1},{"$f":"IF(K$44>=Dashboard!$C$7,IF(K$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":1},{"$f":"IF(L$44>=Dashboard!$C$7,IF(L$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":1},{"$f":"IF(M$44>=Dashboard!$C$7,IF(M$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(N$44>=Dashboard!$C$7,IF(N$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(O$44>=Dashboard!$C$7,IF(O$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(P$44>=Dashboard!$C$7,IF(P$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(Q$44>=Dashboard!$C$7,IF(Q$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(R$44>=Dashboard!$C$7,IF(R$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(S$44>=Dashboard!$C$7,IF(S$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(T$44>=Dashboard!$C$7,IF(T$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(U$44>=Dashboard!$C$7,IF(U$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(V$44>=Dashboard!$C$7,IF(V$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(W$44>=Dashboard!$C$7,IF(W$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(X$44>=Dashboard!$C$7,IF(X$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(Y$44>=Dashboard!$C$7,IF(Y$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(Z$44>=Dashboard!$C$7,IF(Z$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(AA$44>=Dashboard!$C$7,IF(AA$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0},{"$f":"IF(AB$44>=Dashboard!$C$7,IF(AB$44<=Dashboard!$C$7+Dashboard!$C$9-1,1,0),0)","v":0}]
[null,"Capacity Enrolled*",{"$f":"IF(OR(C$46=1, C$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(D$46=1, D$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(E$46=1, E$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":10.337926752308633},{"$f":"IF(OR(F$46=1, F$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":10.337926752308633},{"$f":"IF(OR(G$46=1, G$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":10.337926752308633},{"$f":"IF(OR(H$46=1, H$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":10.337926752308633},{"$f":"IF(OR(I$46=1, I$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":10.337926752308633},{"$f":"IF(OR(J$46=1, J$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":10.337926752308633},{"$f":"IF(OR(K$46=1, K$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":10.337926752308633},{"$f":"IF(OR(L$46=1, L$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":10.337926752308633},{"$f":"IF(OR(M$46=1, M$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(N$46=1, N$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(O$46=1, O$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(P$46=1, P$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(Q$46=1, Q$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(R$46=1, R$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(S$46=1, S$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(T$46=1, T$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(U$46=1, U$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(V$46=1, V$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(W$46=1, W$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(X$46=1, X$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(Y$46=1, Y$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(Z$46=1, Z$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(AA$46=1, AA$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0},{"$f":"IF(OR(AB$46=1, AB$47=1), MAX(Dashboard!$C$12:$AB$12), 0)*(1+$C$27)","v":0}]
[null,"*Capacity enrolled reflects the maximum capacity need + the enrollment reserve margin. This ensures that the location has sufficient capacity to avoid a shortfall and results in equal payments for reservation or activation payments across years rather than diminishing the $/kW payment. If less capacity is actually enrolled, the lower payout  will result in ratepayer savings."]
[]
[]
[]
[null,"Example Compensation Structure"]
[]
[null,"Non- EJ Participant "]
[null,"Reservation paid ($)",{"$f":"IF(C46,\n$C$25*$D$31/SUMPRODUCT($C$45:$AB$45,$C46:$AB46),\n0)","v":0},{"$f":"IF(D46,\n$C$25*$D$31/SUMPRODUCT($C$45:$AB$45,$C46:$AB46),\n0)","v":0},29128.118200506218,29128.118200506218,29128.118200506218,29128.118200506218,29128.118200506218,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Check NPV of spend = Max spend"]
[null,"Activation Paid ($)",{"$f":"IF(C47,\n(1-$C$25)*$D$31/SUMPRODUCT($C$45:$AB$45,$C47:$AB47),\n0)","v":0},{"$f":"IF(D47,\n(1-$C$25)*$D$31/SUMPRODUCT($C$45:$AB$45,$C47:$AB47),\n0)","v":0},0,0,0,0,0,596775.1401646497,596775.1401646497,596775.1401646497,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(NPV(discount_rate_nom,$C$56:$AB$56)*(1+discount_rate_nom)+NPV(discount_rate_nom,$C$57:$AB$57)*(1+discount_rate_nom))","v":1076853.0546329443},{"$f":"IF(ROUND(AD57, 1)=ROUND($D$31, 1), \"Yes\", \"Error\")","v":"Yes"}]
[null,"Reservation Payment ($/kW)",{"$f":"IF(C$46,C56/(C$48*(1-$C$22)*1000),0)","v":0},0,{"$f":"IF(E$46,E56/(E$48*(1-$C$22)*1000),0)","v":3.2018155198638114},3.2018155198638114,3.2018155198638114,3.2018155198638114,3.2018155198638114,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"NPV('Deferral Value Calculation'!$C$53,$C56:$AB56)*(1+'Deferral Value Calculation'!$C$53)","v":107685.30546329443},{"$f":"AD58/$D$31","v":9.9999999999999978E-2}]
[null,"Activation Payment ($/kW)",{"$f":"IF(C$47,C57/(C$48*(1-$C$22)*1000),0)","v":0},0,0,0,0,0,0,65.598604499444448,65.598604499444448,65.598604499444448,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"NPV('Deferral Value Calculation'!$C$53,$C57:$AB57)*(1+'Deferral Value Calculation'!$C$53)","v":969167.74916964979},{"$f":"AD59/$D$31","v":0.89999999999999969}]
[]
[null,"EJ Participant "]
[null,"Reservation paid ($)",{"$f":"IF(C46,\n$C$25*$D$32/SUMPRODUCT($C$45:$AB$45,$C46:$AB46),\n0)","v":0},0,4766.4193419010171,4766.4193419010171,4766.4193419010171,4766.4193419010171,4766.4193419010171,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Check NPV of spend = Max spend"]
[null,"Activation Paid ($)",{"$f":"IF(C47,\n(1-$C$25)*$D$32/SUMPRODUCT($C$45:$AB$45,$C47:$AB47),\n0)","v":0},0,0,0,0,0,0,97654.113845124491,97654.113845124491,97654.113845124491,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"((1+discount_rate_nom)*NPV(discount_rate_nom,$C$62:$AB$62)\n+(1+discount_rate_nom)*NPV(discount_rate_nom,$C$63:$AB$63))","v":176212.3180308454},{"$f":"IF(((1+discount_rate_nom)*NPV(discount_rate_nom,$C$62:$AB$62)\n+(1+discount_rate_nom)*NPV(discount_rate_nom,$C$63:$AB$63))=$D$32,\"Yes\",\"Error\")","v":"Yes"}]
[null,"Reservation Payment ($/kW)",{"$f":"IF(C$46,C62/(C$48*$C$22*1000),0)","v":0},0,3.8421786238365727,3.8421786238365727,3.8421786238365727,3.8421786238365727,3.8421786238365727,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"NPV('Deferral Value Calculation'!$C$53,$C62:$AB62)*(1+'Deferral Value Calculation'!$C$53)","v":17621.231803084545},{"$f":"AD64/$D$32","v":9.9999999999999992E-2}]
[null,"Activation Payment ($/kW)",{"$f":"IF(C$48,C63/(C$48*$C$22*1000),0)","v":0},0,0,0,0,0,0,78.71832539933331,78.71832539933331,78.71832539933331,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"NPV('Deferral Value Calculation'!$C$53,$C63:$AB63)*(1+'Deferral Value Calculation'!$C$53)","v":158591.08622776085},{"$f":"AD65/$D$32","v":0.89999999999999969}]

{"sheet":"Deferral Value Calculation","index":3,"n_rows":93,"n_cols":63,"rows_kept":93,"cut":false,"hidden":false,"merged":[[41,1,41,5],[5,1,5,5],[92,1,93,5]]}
[]
[]
[null,"Deferral Value Stream"]
[]
[]
[null,"Deferral Value reflects benefits of delaying investments related to the time value of money."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Deferral Value Calculation"]
[]
[null,"ILLUSTRATIVE INPUTS. All inputs included are illustrative only, used to indicate calculation methodology rather than actual deferral value inputs and results. Approaches applied by each EDC may vary slightly and EDC inputs will be aligned to approved filings."]
[]
[null,"Note: The 'Counterfactual' investment or upgrade refers to the investment that is being deferred through the use of DERs to provide grid services."]
[null,"Project Inputs",null,"User Input (Override)","Example 1","Example 2","Example 3",null,"Explanation"]
[null,"Project Example","Example 1",null,null,null,null,null,"Selection of the capital cost value to use. If any value is entered in cell D17, this selection will be overridden"]
[null,"Capital cost",{"$f":"IF(D47<>\"\",D47,INDEX($E47:$G47, , MATCH($C$46, $E$45:$G$45, 0)))","v":100000000},null,100000000,40000000,400000000,null,"Capital cost of a counterfactual investment to be deferred at a given location. Examples are intended to provide an illustrative range of potential costs. Users may use one of these example values or input their own in column D"]
[null,"Useful life (years)",{"$f":"IF(D48<>\"\", D48, 40)","v":40},null,null,null,null,null,"Useful life of the original utility asset. This is used to determine depreciation and the year of equipment replacement. The default value is 40 years, representing average life of utility equipment, but may be overridden in column D"]
[null,"Depreciation rate",{"$f":"(C47/C48)/C47","v":2.5000000000000001E-2},"Calculation - no input",null,null,null,null,"Allocation of the capital cost over the useful life of the asset, based on expected Useful life."]
[null,"Annual revenue requirement % allocator",{"$f":"IF(D50<>\"\", D50, 12.5%)","v":0.125},null,null,null,null,null,"Utility Annualized Revenue Requirement Value. Default is set to 12.5%"]
[null,"Distribution Line Loss Factor",{"$f":"IF(D51<>\"\", D51, 9.77%)","v":9.7699999999999995E-2},null,null,null,null,null,"Marginal distribution line losses. The default value is 9.77%, based on multiplying the average line loss factors for each EDC by 1.5 to estimate marginal losses"]
[null,"Escalation Rate (Nominal)",{"$f":"IF(D52<>\"\", D52, 6%)","v":0.06},null,null,null,null,null,"E3 recommends a range from 2% - 6%. The Handy-Whitman index has recently indicated utility capital costs escalating at ~6%/yr."]
[null,"Discount Rate (Nominal)",{"$f":"IF(D53<>\"\", D53, 8%)","v":0.08},null,null,null,null,null,"Representative weighted average cost of capital (WACC) for EDCs. Default is set to 8% nominal"]
[null,"In-Service Date of Planned Upgrade",{"$f":"Dashboard!$C$7","v":2032},"Entered on Dashboard Tab"]
[null,"Adjusted Plant-in-service Year",{"$f":"Dashboard!C8","v":2035},"Entered on Dashboard Tab"]
[null,"Years of Deferral",{"$f":"Dashboard!C9","v":3},"Calculation - no input"]
[null,"Original Asset Install Year",{"$f":"IF(D57<>\"\", D57, 2015)","v":2015},null,null,null,null,null,"Year the original utility asset was installed. This is used alongside the Useful life to determine the year of equipment replacement. The default value is 2015 but may be overridden in column D"]
[null,"Year of Existing Equipment Replacement (if any)",{"$f":"'Deferral Value Calculation'!C57+'Deferral Value Calculation'!C48","v":2055},"Calculation - no input",null,null,null,null,"The year that the existing utility asset at a given location would require replacement if no upgrade were necessary"]
[null,"Max No. of Deferral Years",{"$f":"IF(C58=\"\", \"\",C58-C54)","v":23},"Calculation - no input",null,null,null,null,"The maximum number of years a deferral could possibly provide value by delaying the cost of an upgrade. This is the difference between In-Service Date of a counterfactual planned upgrade and the year of existing equipment replacement"]
[]
[]
[null,"Total Deferral Value ($)",{"$f":"SUMIFS($D$66:$D$91, $B$66:$B$91, $C$56)","v":4176884.5755459666}]
[null,"Unitized Deferral Value ($/kW-yr)",{"$f":"SUMIFS($F$66:$F$91, $B$66:$B$91, $C$56)","v":168.34793037738433},null,null,null,null,"Revenue Requirement"]
[]
[null,"Years of Deferral","NPV of Revenue Requirement","Total Deferral Value ($)","Capacity Provided by DERs (MW)*","Unitized Deferral Value ($/kW-yr)",null,2025,{"$f":"H65+1","v":2026},2027,2028,2029,{"$f":"L65+1","v":2030},2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,{"$f":"AN65+1","v":2058},2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080]
[null,0,{"$f":"NPV($C$53,I66:BK66)+H66","v":76593566.181875303},{"$f":"IF(B66<=$C$59, $C$66-C66, 0)","v":0},{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B66+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},{"$f":"IFERROR(D66/E66/B66/1000, 0)","v":0},null,{"$f":"IF(H$65<($C$54+$B66),0,IF((H$65-($C$54+$B66))<$C$48,$C$47*((1+$C$52)^$B66)*(1-($C$49*(H$65-($C$54+$B66))))*$C$50/(1-$C$51),0))","v":0},{"$f":"IF(I$65<($C$54+$B66),0,IF((I$65-($C$54+$B66))<$C$48,$C$47*((1+$C$52)^$B66)*(1-($C$49*(I$65-($C$54+$B66))))*$C$50/(1-$C$51),0))","v":0},0,0,0,0,0,13853485.536961099,13507148.398537071,13160811.260113044,12814474.121689018,12468136.98326499,12121799.844840962,11775462.706416935,11429125.567992907,11082788.429568879,10736451.291144852,10390114.152720824,10043777.014296798,9697439.8758727703,9351102.7374487426,9004765.599024713,8658428.4606006872,8312091.3221766595,7965754.1837526308,7619417.0453286059,7273079.9069045763,6926742.7684805496,6580405.6300565219,6234068.4916324941,5887731.3532084664,5541394.2147844387,5195057.0763604119,4848719.9379363852,4502382.7995123565,4156045.6610883288,3809708.5226643016,3463371.3842402748,3117034.2458162471,2770697.1073922194,2424359.9689681912,2078022.8305441637,1731685.6921201374,1385348.5536961097,1039011.4152720819,692674.27684805403,346337.13842402626,0,0,0,0,0,0,0,0,0]
[null,1,{"$f":"NPV($C$53,I67:BK67)+H67","v":75175166.80813688},{"$f":"IF(B67<=$C$59, $C$66-C67, 0)","v":1418399.373738423},{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B67+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":1.4343285985331846},{"$f":"IFERROR(D67/E67/B67/1000, 0)","v":988.89429883009268},null,{"$f":"IF(H$65<($C$54+$B67),0,IF((H$65-($C$54+$B67))<$C$48,$C$47*((1+$C$52)^$B67)*(1-($C$49*(H$65-($C$54+$B67))))*$C$50/(1-$C$51),0))","v":0},0,0,0,0,0,0,0,14684694.669178765,14317577.302449297,13950459.935719827,13583342.568990357,13216225.202260889,12849107.835531419,12481990.468801951,12114873.102072481,11747755.735343013,11380638.368613543,11013521.001884075,10646403.635154605,10279286.268425135,9912168.9016956668,9545051.534966195,9177934.1682367288,8810816.8015072588,8443699.4347777888,8076582.0680483216,7709464.7013188507,7342347.3345893826,6975229.9678599136,6608112.6011304436,6240995.2344009746,5873877.8676715055,5506760.5009420374,5139643.1342125675,4772525.7674830975,4405408.4007536285,4038291.034024159,3671173.6672946913,3304056.3005652218,2936938.9338357528,2569821.5671062828,2202704.2003768138,1835586.8336473457,1468469.4669178764,1101352.1001884069,734234.73345893726,367117.36672946787,0,0,0,0,0,0,0,0]
[null,{"$f":"B67+1","v":2},{"$f":"NPV($C$53,I68:BK68)+H68","v":73783034.089467645},2810532.0924076587,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B68+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":4.8101373902930504},292.14675843556631,null,0,0,0,0,0,0,0,0,0,15565776.349329494,15176631.940596256,14787487.531863019,14398343.123129781,14009198.714396544,13620054.305663306,13230909.896930071,12841765.488196831,12452621.079463596,12063476.670730358,11674332.26199712,11285187.853263883,10896043.444530644,10506899.03579741,10117754.62706417,9728610.2183309346,9339465.8095976952,8950321.4008644577,8561176.992131222,8172032.5833979826,7782888.174664747,7393743.7659315094,7004599.357198271,6615454.9484650334,6226310.5397317959,5837166.1309985602,5448021.7222653218,5058877.3135320852,4669732.9047988476,4280588.4960656092,3891444.0873323735,3502299.6785991355,3113155.2698658979,2724010.8611326604,2334866.4523994229,1945722.0436661867,1556577.634932949,1167433.2261997114,778288.81746647367,389144.4087332359,0,0,0,0,0,0,0]
[null,{"$f":"B68+1","v":3},72416681.606329337,4176884.5755459666,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B69+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":8.2703414018469061},168.34793037738433,null,0,0,0,0,0,0,0,0,0,0,16499722.930289265,16087229.857032033,15674736.783774802,15262243.71051757,14849750.637260338,14437257.564003108,14024764.490745876,13612271.417488642,13199778.344231414,12787285.270974182,12374792.19771695,11962299.124459716,11549806.051202485,11137312.977945255,10724819.904688021,10312326.831430791,9899833.7581735589,9487340.6849163268,9074847.6116590966,8662354.5384018626,8249861.4651446324,7837368.3918874012,7424875.3186301682,7012382.2453729371,6599889.172115704,6187396.0988584748,5774903.0256012427,5362409.9523440106,4949916.8790867785,4537423.8058295464,4124930.7325723162,3712437.6593150841,3299944.586057852,2887451.5128006199,2474958.4395433883,2062465.3662861581,1649972.293028926,1237479.2197716942,824986.14651446219,412493.07325723016,0,0,0,0,0,0]
[null,4,71075631.946952894,5517934.2349224091,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B70+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,17489706.30610662,17052463.648453955,16615220.990801288,16177978.333148625,15740735.67549596,15303493.017843293,14866250.360190628,14429007.702537961,13991765.044885296,13554522.387232631,13117279.729579967,12680037.0719273,12242794.414274635,11805551.75662197,11368309.098969301,10931066.441316638,10493823.783663971,10056581.126011306,9619338.4683586434,9182095.8107059747,8744853.1530533098,8307610.4954006439,7870367.837747979,7433125.1800953131,6995882.5224426463,{"$f":"IF(AR$65<($C$54+$B70),0,IF((AR$65-($C$54+$B70))<$C$48,$C$47*((1+$C$52)^$B70)*(1-($C$49*(AR$65-($C$54+$B70))))*$C$50/(1-$C$51),0))","v":6558639.8647899833},6121397.2071373174,5684154.5494846506,5246911.8918319847,4809669.2341793198,4372426.5765266549,3935183.9188739895,3497941.2612213232,3060698.6035686573,2623455.9459159919,2186213.2882633274,1748970.6306106616,1311727.972957996,874485.31530532986,437242.657652664,0,{"$f":"IF(BH$65<($C$54+$B70),0,IF((BH$65-($C$54+$B70))<$C$48,$C$47*((1+$C$52)^$B70)*(1-($C$49*(BH$65-($C$54+$B70))))*$C$50/(1-$C$51),0))","v":0},0,0,0]
[null,5,69759416.540527865,6834149.6413474381,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B71+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,18539088.684473019,18075611.467361193,17612134.250249367,17148657.033137545,{"$f":"IF(X$65<($C$54+$B71),0,IF((X$65-($C$54+$B71))<$C$48,$C$47*((1+$C$52)^$B71)*(1-($C$49*(X$65-($C$54+$B71))))*$C$50/(1-$C$51),0))","v":16685179.816025717},16221702.598913893,15758225.381802067,15294748.164690241,14831270.947578417,14367793.730466591,13904316.513354765,13440839.296242939,12977362.079131113,12513884.862019289,12050407.644907461,11586930.427795637,11123453.210683813,10659975.993571987,10196498.776460163,9733021.5593483336,{"$f":"IF(AN$65<($C$54+$B71),0,IF((AN$65-($C$54+$B71))<$C$48,$C$47*((1+$C$52)^$B71)*(1-($C$49*(AN$65-($C$54+$B71))))*$C$50/(1-$C$51),0))","v":9269544.3422365095},8806067.1251246836,8342589.9080128577,7879112.6909010326,7415635.4737892067,6952158.2566773826,6488681.0395655567,6025203.8224537307,5561726.6053419057,5098249.3882300789,4634772.1711182548,4171294.9540064288,3707817.7368946034,3244340.5197827774,2780863.3026709515,2317386.0855591274,1853908.8684473017,1390431.6513354757,926954.43422364979,463477.21711182385,0,0,0,0]
[null,6,68467575.493481025,8125990.6883942783,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B72+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,19651434.005541403,19160148.155402869,18668862.305264331,18177576.455125798,17686290.604987264,17195004.75484873,16703718.904710194,16212433.054571658,15721147.204433125,15229861.354294589,14738575.504156053,14247289.654017517,13756003.803878982,13264717.953740448,12773432.10360191,12282146.253463376,11790860.403324842,11299574.553186307,10808288.703047773,10317002.852909235,9825717.0027707014,9334431.1526321657,8843145.30249363,8351859.4523550952,7860573.6022165595,7369287.7520780265,6878001.9019394908,6386716.0518009551,5895430.2016624203,5404144.3515238846,4912858.5013853507,4421572.651246815,3930286.8011082797,3439000.950969744,2947715.1008312088,2456429.2506926754,1965143.4005541399,1473857.5504156044,982571.70027706877,491285.85013853334,0,0,0]
[null,7,67199657.428786963,9393908.7530883402,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B73+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20830520.045873892,20309757.044727046,19788994.043580197,19268231.042433351,18747468.041286502,18226705.040139657,17705942.038992807,17185179.037845958,16664416.036699114,16143653.035552267,15622890.03440542,15102127.03325857,14581364.032111723,14060601.030964877,13539838.029818026,13019075.028671181,12498312.027524335,11977549.026377488,11456786.025230642,10936023.024083791,10415260.022936946,9894497.0217900984,9373734.0206432492,8852971.0194964018,8332208.0183495553,7811445.0172027098,7290682.0160558615,6769919.0149090132,6249156.0137621658,5728393.0126153184,5207630.0114684729,4686867.0103216246,4166104.0091747777,3645341.0080279298,3124578.006881082,2603815.0057342364,2083052.0045873888,1562289.003440541,1041526.0022936933,520763.00114684546,0,0]
[null,8,65955219.328253821,10638346.853621483,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B74+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,22080351.248626322,21528342.467410665,20976333.686195001,20424324.904979348,19872316.123763688,19320307.342548031,18768298.561332375,18216289.780116715,17664280.998901058,17112272.217685401,16560263.436469741,16008254.655254081,15456245.874038424,14904237.092822766,14352228.311607106,13800219.530391451,13248210.749175791,12696201.967960134,12144193.186744478,11592184.405528815,11040175.624313161,10488166.843097501,9936158.061881844,9384149.2806661837,8832140.4994505271,8280131.7182348706,7728122.9370192122,7176114.1558035528,6624105.3745878944,6072096.593372236,5520087.8121565804,4968079.030940922,4416070.2497252636,3864061.4685096042,3312052.6872939463,2760043.9060782902,2208035.1248626318,1656026.3436469731,1104017.5624313145,552008.78121565608,0]
[null,9,64733826.377730608,11859739.804144695,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B75+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,23405172.323543899,22820043.015455298,22234913.707366705,21649784.399278104,21064655.091189511,20479525.78310091,19894396.47501231,19309267.166923717,18724137.858835116,18139008.550746519,17553879.242657922,16968749.934569325,16383620.626480727,15798491.318392131,15213362.010303531,14628232.702214936,14043103.394126339,13457974.08603774,12872844.777949145,12287715.469860544,11702586.161771949,11117456.853683352,10532327.545594752,9947198.2375061549,9362068.9294175562,8776939.6213289611,8191810.3132403633,7606681.0051517654,7021551.6970631676,6436422.3889745697,5851293.0808859747,5266163.7727973759,4681034.4647087781,4095905.1566201807,3510775.8485315829,2925646.5404429873,2340517.232354389,1755387.9242657914,1170258.6161771934,585129.3080885954]
[null,10,63526718.315756939,13066847.866118364,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B76+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,24809482.662956536,24189245.596382622,23569008.529808708,22948771.463234797,22328534.396660887,21708297.330086969,21088060.263513055,20467823.196939141,19847586.13036523,19227349.06379132,18607111.997217402,17986874.930643488,17366637.864069574,16746400.797495663,16126163.730921745,15505926.664347835,14885689.597773923,14265452.531200007,13645215.464626096,13024978.398052178,12404741.331478268,11784504.264904354,11164267.19833044,10544030.131756525,9923793.0651826132,9303555.9986087009,8683318.9320347868,8063081.8654608727,7442844.7988869585,6822607.7323130453,6202370.665739134,5582133.5991652198,4961896.5325913066,4341659.4660173925,3721422.3994434783,3101185.332869567,2480948.2662956533,1860711.1997217392,1240474.1331478253]
[null,11,62332630.587428898,14260935.594446406,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B77+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,26298051.622733932,25640600.332165584,24983149.041597232,24325697.751028892,23668246.46046054,23010795.169892192,22353343.879323844,21695892.588755492,21038441.298187144,20380990.007618796,19723538.717050452,19066087.4264821,18408636.135913752,17751184.845345408,17093733.554777056,16436282.264208708,15778830.97364036,15121379.68307201,14463928.392503664,13806477.101935312,13149025.811366966,12491574.520798616,11834123.23023027,11176671.93966192,10519220.64909357,9861769.3585252259,9204318.067956876,8546866.777388528,7889415.4868201781,7231964.1962518292,6574512.905683483,5917061.615115135,5259610.3245467851,4602159.0339784361,3944707.7434100872,3287256.4528417415,2629805.1622733925,1972353.8717050436]
[null,12,61150232.053732209,15443334.128143094,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B78+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,27875934.72009797,27179036.352095522,26482137.98409307,25785239.616090626,25088341.248088174,24391442.880085725,23694544.512083273,22997646.144080825,22300747.776078377,21603849.408075925,20906951.04007348,20210052.672071029,19513154.30406858,18816255.936066128,18119357.568063676,17422459.200061232,16725560.832058782,16028662.464056334,15331764.096053885,14634865.728051433,13937967.360048985,13241068.992046535,12544170.624044085,11847272.256041635,11150373.888039185,10453475.52003674,9756577.1520342901,9059678.7840318382,8362780.416029389,7665882.0480269389,6968983.6800244926,6272085.3120220425,5575186.9440195924,4878288.5760171432,4181390.2080146931,3484491.8400122463,2787593.4720097962]
[null,13,59978119.0244378,16615447.157437503,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B79+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29548490.803303849,28809778.533221252,28071066.263138656,27332353.993056063,26593641.722973466,25854929.452890869,25116217.182808269,24377504.912725672,23638792.642643079,22900080.372560482,22161368.102477886,21422655.832395293,20683943.562312696,19945231.292230103,19206519.022147499,18467806.752064906,17729094.481982309,16990382.211899713,16251669.94181712,15512957.671734517,14774245.401651924,14035533.131569328,13296820.861486731,12558108.591404134,11819396.321321538,11080684.051238943,10341971.781156348,9603259.5110737495,8864547.2409911528,8125834.9709085552,7387122.7008259622,6648410.4307433655,5909698.1606607689,5170985.8905781712,4432273.6204955745,3693561.3504129811]
[null,14,58814808.861488573,17778757.32038673,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B80+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,31321400.251502082,30538365.245214529,29755330.238926973,28972295.232639428,28189260.226351872,27406225.22006432,26623190.213776767,25840155.207489215,25057120.201201662,24274085.194914114,23491050.188626561,22708015.182339005,21924980.176051456,21141945.169763904,20358910.163476352,19575875.157188799,18792840.150901247,18009805.144613694,17226770.138326146,16443735.13203859,15660700.125751041,14877665.119463487,14094630.113175934,13311595.106888382,12528560.100600829,11745525.094313281,10962490.088025728,10179455.081738176,9396420.0754506215,8613385.0691630691,7830350.0628755204,7047315.0565879671,6264280.0503004147,5481245.0440128623,4698210.0377253089]
[null,15,57658733.12195047,18934833.059924833,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B81+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,33200684.266592216,32370667.159927413,31540650.053262603,30710632.946597803,29880615.839932993,29050598.73326819,28220581.62660338,27390564.519938577,26560547.413273774,25730530.306608967,24900513.199944165,24070496.093279354,23240478.986614551,22410461.879949745,21580444.773284938,20750427.666620135,19920410.559955329,19090393.453290522,18260376.346625719,17430359.239960909,16600342.133296108,15770325.026631301,14940307.919966495,14110290.813301688,13280273.706636883,12450256.599972082,11620239.493307276,10790222.386642469,9960205.2799776625,9130188.1733128559,8300171.0666480539,7470153.9599832473,6640136.8533184417,5810119.746653636]
[null,16,56508230.207451709,20085335.974423595,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B82+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35192725.322587743,34312907.189523049,33433089.05645835,32553270.923393663,31673452.790328965,30793634.657264274,29913816.524199579,29033998.391134884,28154180.258070193,27274362.125005502,26394543.991940804,25514725.858876113,24634907.725811418,23755089.592746727,22875271.459682029,21995453.326617338,21115635.193552643,20235817.060487952,19355998.927423257,18476180.794358563,17596362.661293872,16716544.528229175,15836726.395164482,14956908.262099788,14077090.129035093,13197271.995970402,12317453.862905709,11437635.729841014,10557817.59677632,9677999.463711625,8798181.3306469359,7918363.1975822411,7038545.0645175464]
[null,17,55361537.484739304,21232028.697136,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B83+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,37304288.841943003,36371681.620894425,35439074.399845853,34506467.178797282,33573859.957748704,32641252.736700129,31708645.515651554,30776038.294602975,29843431.073554404,28910823.852505829,27978216.631457254,27045609.410408676,26113002.189360101,25180394.96831153,24247787.747262951,23315180.526214376,22382573.305165801,21449966.084117226,20517358.863068655,19584751.642020073,18652144.420971502,17719537.199922927,16786929.978874352,15854322.757825773,14921715.536777198,13989108.315728627,13056501.09468005,12123893.873631475,11191286.652582899,10258679.431534322,9326072.2104857508,8393464.9894371759]
[null,18,54216782.839527845,22376783.342347458,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B84+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,39542546.172459587,38553982.518148094,37565418.863836601,36576855.209525123,35588291.55521363,34599727.900902145,33611164.246590652,32622600.592279159,31634036.937967673,30645473.283656184,29656909.629344691,28668345.975033198,27679782.320721712,26691218.666410226,25702655.01209873,24714091.35778724,23725527.703475751,22736964.049164262,21748400.394852776,20759836.740541279,19771273.086229794,18782709.431918301,17794145.777606815,16805582.123295322,15817018.468983833,14828454.814672345,13839891.160360856,12851327.506049365,11862763.851737874,10874200.197426384,9885636.5431148969]
[null,19,53071975.623197481,23521590.558677822,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B85+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,41915098.942807168,40867221.469236985,39819343.995666809,38771466.522096626,37723589.048526451,36675711.574956268,35627834.101386093,34579956.62781591,33532079.154245734,32484201.680675555,31436324.207105372,30388446.733535193,29340569.259965014,28292691.786394838,27244814.312824655,26196936.83925448,25149059.365684301,24101181.892114118,23053304.418543942,22005426.944973759,20957549.471403584,19909671.997833405,18861794.524263225,17813917.050693043,16766039.577122863,15718162.103552686,14670284.629982507,13622407.156412328,12574529.682842147,11526652.209271967]
[null,20,51924996.949098736,24668569.232776567,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B86+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S$65<($C$54+$B86),0,IF((S$65-($C$54+$B86))<$C$48,$C$47*((1+$C$52)^$B86)*(1-($C$49*(S$65-($C$54+$B86))))*$C$50/(1-$C$51),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,44430004.879375599,43319254.757391207,42208504.635406815,41097754.51342243,39987004.391438045,38876254.269453645,37765504.14746926,36654754.025484867,35544003.903500475,34433253.78151609,33322503.659531694,32211753.537547309,31101003.415562917,29990253.293578532,28879503.171594135,27768753.049609751,26658002.927625358,25547252.805640966,24436502.683656581,23325752.561672185,{"$f":"IF(BC$65<($C$54+$B86),0,IF((BC$65-($C$54+$B86))<$C$48,$C$47*((1+$C$52)^$B86)*(1-($C$49*(BC$65-($C$54+$B86))))*$C$50/(1-$C$51),0))","v":22215002.4396878},21104252.317703407,19993502.195719015,18882752.073734626,17772001.951750234,16661251.829765847,15550501.707781458,14439751.585797068,13329001.463812677]
[null,21,50773589.292233504,25819976.889641799,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B87+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,{"$f":"IF(H$65<($C$54+$B87),0,IF((H$65-($C$54+$B87))<$C$48,$C$47*((1+$C$52)^$B87)*(1-($C$49*(H$65-($C$54+$B87))))*$C$50/(1-$C$51),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,47095805.172138147,45918410.042834692,44741014.913531236,43563619.784227781,{"$f":"IF(AN$65<($C$54+$B87),0,IF((AN$65-($C$54+$B87))<$C$48,$C$47*((1+$C$52)^$B87)*(1-($C$49*(AN$65-($C$54+$B87))))*$C$50/(1-$C$51),0))","v":42386224.654924326},41208829.52562087,40031434.396317422,38854039.267013967,37676644.137710519,36499249.008407064,35321853.879103608,34144458.749800153,32967063.620496701,31789668.49119325,30612273.361889787,29434878.232586343,28257483.103282884,27080087.973979428,25902692.844675981,24725297.715372521,23547902.586069074,22370507.456765618,21193112.327462163,20015717.198158711,18838322.068855252,17660926.939551804,16483531.810248351,15306136.680944894]
[null,22,49615345.342889659,26978220.838985644,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B88+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},{"$f":"IFERROR(D88/E88/B88/1000, 0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,49921553.482466429,48673514.645404764,47425475.808343105,46177436.971281447,44929398.134219781,43681359.29715813,42433320.460096464,41185281.623034798,39937242.785973147,38689203.948911481,37441165.111849822,36193126.274788164,34945087.437726498,33697048.600664839,32449009.763603173,31200970.926541518,29952932.089479856,28704893.252418198,27456854.415356535,26208815.57829487,24960776.741233215,23712737.904171553,22464699.06710989,21216660.230048228,19968621.39298657,18720582.555924911,17472543.718863249]
[null,23,48447696.06139823,28145870.120477073,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B89+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AI$65<($C$54+$B89),0,IF((AI$65-($C$54+$B89))<$C$48,$C$47*((1+$C$52)^$B89)*(1-($C$49*(AI$65-($C$54+$B89))))*$C$50/(1-$C$51),0))","v":0},0,0,52916846.691414431,51593925.52412907,50271004.356843702,48948083.189558342,47625162.022272982,46302240.854987629,44979319.687702261,43656398.520416901,42333477.35313154,41010556.185846187,39687635.018560819,38364713.851275459,37041792.683990099,35718871.516704738,34395950.34941937,33073029.182134017,31750108.014848657,30427186.847563293,29104265.68027794,27781344.512992568,26458423.345707215,25135502.178421851,23812581.011136487,22489659.843851127,21166738.676565766,19843817.50928041]
[null,24,47267897.877540857,0,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B90+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56091857.492899284,54689561.055576801,53287264.618254319,51884968.180931836,50482671.743609361,49080375.306286879,47678078.868964396,46275782.431641914,44873485.994319439,43471189.556996949,42068893.119674467,40666596.682351984,39264300.245029502,37862003.807707027,36459707.370384529,35057410.933062054,33655114.495739572,32252818.058417086,30850521.621094614,29448225.183772121,28045928.746449642,26643632.309127159,25241335.871804673,23839039.434482191,22436742.997159708]
[null,25,46073018.974249825,0,{"$f":"IFERROR(INDEX(Dashboard!$C$12:$AB$12, , MATCH($B91+$C$54-1, Dashboard!$C$11:$AB$11, 0)), 0)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,59457368.94247324,57970934.718911409,56484500.495349579,54998066.271787755,53511632.048225917,52025197.824664086,50538763.601102255,49052329.377540417,47565895.153978594,46079460.930416763,44593026.706854932,43106592.483293101,41620158.25973127,40133724.03616944,38647289.812607601,37160855.589045778,35674421.36548394,34187987.141922109,32701552.918360285,31215118.694798447,29728684.47123662,28242250.247674789,26755816.024112958,25269381.80055112]
[]
[null,"*Entered on Dashboard tab as Annual Capacity Need. If DERs provide the annual capacity need, then the traditional asset can be deferred."]

{"sheet":"Bridge to Wires Calculation","index":4,"n_rows":136,"n_cols":26,"rows_kept":136,"cut":false,"hidden":false,"merged":[[5,1,6,5],[114,2,114,3],[41,3,41,7],[80,2,80,3],[91,2,91,3],[97,2,97,3],[49,2,49,4],[53,2,53,4]]}
[]
[]
[null,"Bridge-to-Wires Solution"]
[]
[]
[null,"Bridge-to-Wires solutions are designed to bridge the gap between an imminent capacity constraint and the time it takes to complete construction of a traditional infrastructure solution."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bridge-to-Wires Value Stream Calculation"]
[]
[null,null,null,"ILLUSTRATIVE INPUTS. All inputs included are illustrative only, used to indicate calculation methodology rather than actual bridge-to-wires value inputs and results. Approaches applied by each EDC may vary slightly and EDC inputs should align with approved filings."]
[]
[]
[]
[null,null,"Value Stream Inputs",null,null,"Explanation"]
[null,null,"Rate Impact Value Stream Selection",null,"Weighted Average of Avoided Backup Solutions","Selection for how to calculate Bridge-to-Wires Value"]
[null,null,"Example Equipment Cost Range",null,"Medium","Applies to backup Diesel and Storage values"]
[null,null,"Value of Lost Load Customer Risk Profile*",null,"Medium","Value of Lost Load depends on the risk profile of the customers behind a feeder. High: higher proportion of C&I customers; Medium: current statewide customer proportions; Low: higher proportion of residential customers"]
[null,null,"Battery Storage Cost Multipliers"]
[null,null,null,"High",2,"Intended to reflect cost premiums for servicing islands with battery storage"]
[null,null,null,"Medium",1.25,"Intended to reflect cost premiums to service Eastern Massachusetts and urban areas with battery storage"]
[null,null,null,"Low",0.75,"Intended to reflect cost difference for servicing for Western Massachusetts and rural areas with battery storage"]
[null,null,"Probability of Backup Solution being Deployed (without use of DERs)",null,null,"How probable is it that a given backup solution would otherwise be deployed for the selected location if DERs are not used? Probabilities must sum to 100%.",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E55:E56)=1,\"\",\"ERROR - Probabilities do not sum to 100%!\")","v":""}]
[null,null,null,"Backup Diesel Generator",0.9,"User-input assumption for probability that a diesel generator backup would be deployed if DERs were not used as a solution"]
[null,null,null,"Backup Energy Storage",0.1,"User-input assumption for probability that utility-owned backup energy storage would be deployed if DERs were not used as a solution"]
[null,null,"Bridge-to-Wires Rate Impact Value ($/kW-yr)",null,{"$f":"_xlfn.IFS($E$47=$B$114, $E$115, $E$47=$B$80, $E$93, $E$47=$B$97, $E$110*SUMIFS($E$51:$E$53, $D$51:$D$53, $E$48))","v":117.55588235294118}]
[null,null,"*Value of Lost Load is a Non-Rate Impact and is not reflected within the Bridge-to-Wires value output"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart Helper Data (Do not edit)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighted Average",null,{"$f":"E115","v":117.55588235294118}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avoided Backup Diesel Generator",null,{"$f":"E93","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avoided Backup Energy Storage",null,{"$f":"$E$110*SUMIFS($E$51:$E$53, $D$51:$D$53, $E$48)","v":275.55882352941177}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value of Lost Load",null,{"$f":"E136","v":68.952713787085514}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High",null,{"$f":"F93","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",null,{"$f":"G93","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",null,{"$f":"H93","v":57.98}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High",null,{"$f":"$E$110*E51","v":440.89411764705881}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",null,{"$f":"$E$110*E52","v":275.55882352941177}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",null,{"$f":"$E$110*E53","v":165.33529411764704}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High",null,{"$f":"'ICE Calculator Results'!P26","v":105.69634380453752}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",null,{"$f":"'ICE Calculator Results'!P23","v":68.952713787085514}]
[null,null,"*Avoided Backup Energy Storage does not factor the Priority Multiplier in the graph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",null,{"$f":"'ICE Calculator Results'!P20","v":54.212783595113436}]
[]
[]
[null,"Rate Impact Value Streams - Avoided Cost of Backup Solutions"]
[]
[null,{"$f":"Mappings!F5","v":"Avoided Backup Diesel Generator"},null,null,{"$f":"E48","v":"Medium"},"High","Medium","Low","Reference",null,"Assumption"]
[null,1,"Backup Generator Size (kW)",null,{"$f":"INDEX($F81:$H81, ,MATCH($E$80, $F$80:$H$80, 0))","v":1000},1000,1000,1000,null,null,"Examples sourced from past costs for backup power to cover Bridge-to-Wire outage risk events. Island: cost premiums of servicing backup power to islands. High: cost premium of servicing backup power to Eastern Massachusetts and urban areas. Low: cost discount of servicing backup power to Western Massachusetts and rural areas."]
[]
[null,null,"Operating Expenses"]
[null,2,null,"Generator Rental Cost, including setup/breakdown ($ / year)",{"$f":"INDEX($F84:$H84, ,MATCH($E$80, $F$80:$H$80, 0))","v":100000},200000,100000,32300,null,null,"Generator rental costs, including setup and breakdown, correspond to example."]
[]
[null,3,null,"Days of Usage per year",{"$f":"INDEX($F86:$H86, ,MATCH($E$80, $F$80:$H$80, 0))","v":30},30,30,30]
[null,4,null,"Hours of Usage per day",{"$f":"INDEX($F87:$H87, ,MATCH($E$80, $F$80:$H$80, 0))","v":8},8,8,8,null,null,"Default assumption that generator is run 8 hours per day to minimize risk of equipment failure"]
[null,5,null,"Fuel Cost ($/hour)",{"$f":"INDEX($F88:$H88, ,MATCH($E$80, $F$80:$H$80, 0))","v":0},0,0,107,null,null,"Assumed usage based on EDC backup power examples"]
[null,6,null,"Fuel Cost ($ / year)",{"$f":"INDEX($F89:$H89, ,MATCH($E$80, $F$80:$H$80, 0))","v":0},{"$f":"F87*F88*F86","v":0},{"$f":"G87*G88*G86","v":0},{"$f":"H87*H88*H86","v":25680},"[3] * [4] * [5]",null,"Fuel costs/hour * Hours/day *days/yr of outages"]
[]
[null,7,"Annual Operating Expenses ($ / year)",null,{"$f":"INDEX($F91:$H91, ,MATCH($E$80, $F$80:$H$80, 0))","v":100000},{"$f":"SUM(F84,F89)","v":200000},{"$f":"SUM(G84,G89)","v":100000},{"$f":"SUM(H84,H89)","v":57980},"[2] + [6]",null,"Sum of all operating costs"]
[null,null," "]
[null,8,"Backup Capacity Annualized Marginal Cost ($ / kW-year)",null,{"$f":"INDEX($F93:$H93, ,MATCH($E$80, $F$80:$H$80, 0))","v":100},{"$f":"F91/F81","v":200},{"$f":"G91/G81","v":100},{"$f":"H91/H81","v":57.98},"[7] / [1]",null,"Annual operating costs divided by backup generator size"]
[]
[]
[]
[null,{"$f":"Mappings!F6","v":"Avoided Backup Energy Storage"},null,null,null,"Reference","Assumption"]
[null,1,"Backup Storage Size (kW)",null,500,null,"Example sourced from past costs for backup storage to cover Bridge-to-Wire outage risk events. 500 kW size includes several 8-hr and 4-hr batteries."]
[]
[null,null,"Operating Expenses"]
[null,2,null,"Annual Rental Cost ($ / year)",105000,null,"Backup energy storage rental costs, including setup and breakdown costs"]
[null,3,null,"Rental Cost ($ / kW)",{"$f":"E101/E98","v":210},"[2] / [1]","Rental cost / battery storage size"]
[]
[null,4,null,"Days of Usage per year",30,null,"Default assumption that backup storage is run 8 hours per day to minimize risk of equipment failure"]
[null,5,null,"Hours of Usage per day",8,null,"Assumed usage based on EDC backup power examples"]
[null,6,null,"Battery Roundtrip Efficiency",0.85,null,"Assumed roundtrip efficiency from charge to dispatch"]
[null,7,null,"Electricity Price ($/kWh)",3.6999999999999998E-2,null,"Assumed average offpeak wholesale price of electricity during summer months. Average price may differ during other seasons."]
[null,8,null,"Electricity Cost ($ / kW)",{"$f":"E104*E105/$E$106*$E$107","v":10.447058823529412},"[4] * [5] / [6] * [7]","Electricity cost/hour * Hours/day *days/yr of outages / Battery Roundtrip Efficiency"]
[]
[null,9,"Backup Capacity Annualized Marginal Cost ($ / kW-year)",null,{"$f":"E102+E108","v":220.4470588235294},"[3] + [8]","Summed operating costs"]
[]
[]
[]
[null,{"$f":"Mappings!F4","v":"Weighted Average of Avoided Backup Solutions"}]
[null,null,"Total Bridge-to-Wires Value ($/kW-year)",null,{"$f":"(E93*E55)+(E110*E56*SUMIFS($E$51:$E$53, $D$51:$D$53, $E$48))","v":117.55588235294118},null,"Weighted average of all B2W calculations based on selected probability of occurrence"]
[]
[]
[]
[null,"Non-Rate Impact Value Streams"]
[]
[null,{"$f":"Mappings!F7","v":"Value of Load"},null,null,null,"Reference","Assumption"]
[null,null,"ICE Calculator Inputs - Customer Counts",null,null,null,"Customer counts depend on Value of Lost Load Customer Risk selection. EDCs will determine risk based on customer make-up at a B2W location."]
[null,null,null,"Residential",{"$f":"INDEX('ICE Calculator Results'!$L$8:$N$9, MATCH('Bridge to Wires Calculation'!$D123, 'ICE Calculator Results'!$B$8:$B$9, 0), MATCH('Bridge to Wires Calculation'!$E$49, 'ICE Calculator Results'!$L$7:$N$7, 0))","v":2249176.0111725689}]
[null,null,null,"Non-Residential",{"$f":"INDEX('ICE Calculator Results'!$L$8:$N$9, MATCH('Bridge to Wires Calculation'!$D124, 'ICE Calculator Results'!$B$8:$B$9, 0), MATCH('Bridge to Wires Calculation'!$E$49, 'ICE Calculator Results'!$L$7:$N$7, 0))","v":54689.011172569059}]
[null,null,"ICE Calculator Inputs - Reliability Metrics"]
[null,null,null,"SAIFI (IEEE) - Outage events per year",1,null,"Assumes one 12-hour outage as an example value"]
[null,null,null,"SAIDI (IEEE) - Average outage duration (minutes)",720,null,"12 hours * 60 minutes"]
[null,null,null,"CAIDI (IEEE) - Average outage duration per customer (minutes)",720,null,"CAIDI = SAIDI/SAIFI"]
[]
[null,null,"ICE Calculator Results"]
[null,1,null,"Cost Per Event (2025 $)",{"$f":"SUMIFS(INDEX('ICE Calculator Results'!$N$18:$T$26, , MATCH('Bridge to Wires Calculation'!$D131, 'ICE Calculator Results'!$N$17:$T$17, 0)), 'ICE Calculator Results'!$L$18:$L$26, 'Bridge to Wires Calculation'!$E$49, 'ICE Calculator Results'!$M$18:$M$26, \"All Customers\")","v":211.69003490401397},null,"ICE calculator output - see ICE Calculator Results tab"]
[null,2,null,"Cost Per Average kW (2025 $)",{"$f":"SUMIFS(INDEX('ICE Calculator Results'!$N$18:$T$26, , MATCH('Bridge to Wires Calculation'!$D132, 'ICE Calculator Results'!$N$17:$T$17, 0)), 'ICE Calculator Results'!$L$18:$L$26, 'Bridge to Wires Calculation'!$E$49, 'ICE Calculator Results'!$M$18:$M$26, \"All Customers\")","v":68.952713787085514},null,"ICE calculator output - see ICE Calculator Results tab"]
[null,3,null,"Cost Per Unserved kWh (2025 $)",{"$f":"SUMIFS(INDEX('ICE Calculator Results'!$N$18:$T$26, , MATCH('Bridge to Wires Calculation'!$D133, 'ICE Calculator Results'!$N$17:$T$17, 0)), 'ICE Calculator Results'!$L$18:$L$26, 'Bridge to Wires Calculation'!$E$49, 'ICE Calculator Results'!$M$18:$M$26, \"All Customers\")","v":5.7451745200698081},null,"ICE calculator output - see ICE Calculator Results tab"]
[null,4,null,"Total Cost of Sustained Interruptions (2025 $)",{"$f":"SUMIFS(INDEX('ICE Calculator Results'!$N$18:$T$26, , MATCH('Bridge to Wires Calculation'!$D134, 'ICE Calculator Results'!$N$17:$T$17, 0)), 'ICE Calculator Results'!$L$18:$L$26, 'Bridge to Wires Calculation'!$E$49, 'ICE Calculator Results'!$M$18:$M$26, \"All Customers\")","v":487704305.94213784},null,"ICE calculator output - see ICE Calculator Results tab"]
[]
[null,5,"Value of Lost Load ($/kW-year)",null,{"$f":"E132","v":68.952713787085514},"[2]"]

{"sheet":"EJ Impacts Calculation","index":5,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[6,2,6,3],[18,2,18,3],[24,2,24,3],[11,2,11,3],[17,2,17,3]]}
[]
[]
[null,"Environmental Justice - Non-Rate Impact Value Streams"]
[]
[]
[null,"EJ Participant Adder",null,null,null,null,"Explanation"]
[null,1,"EJ Participant adder",null,null,null,"Percent adder applied on top of the base Deferral or Bridge to Wires value to increase compensation for qualified Environmental Justice participants"]
[null,2,null,"EJ Participant Adder (%)",0.2,null,"e.g. an adder of 20% would mean that qualified EJ participants receive 120% of the base compensation selected for a given location"]
[null,null,null,null,null,null,"The initial default value of 20% is based on a review of similar or low-income participant adders in other jurisdictions. Please refer to the report for more detail"]
[]
[null,"Air Quality Adder*",null,null,null,"Reference","Explanation"]
[null,"1a","Air quality impacts of diesel generation"]
[null,"2a",null,"Diesel emissions factor","Uncontrolled Diesel Industrial Engines",null,"Selection of diesel engine type used for emissions factors"]
[null,"3a",null,"Air quality health impacts ($/kWh)",{"$f":"_xlfn.IFS($E$13=\"Uncontrolled Diesel Industrial Engines\", $G$39, $E$13=\"Large Stationary Diesel Engines\", $G$54)","v":0.49801099999999998},"COBRA output","Calculated below from COBRA depending on emission factor source; uses High value from COBRA calculator"]
[null,"4a",null,"Hours of usage per year (hours)",{"$f":"8*30","v":240},null,"Assumes 8 hrs* 30 days/yr "]
[null,"5a",null,"Probability of Backup Solution being Deployed (without use of DERs)",{"$f":"IF('Bridge to Wires Calculation'!$E$47 = Mappings!$F$5, 1, IF('Bridge to Wires Calculation'!$E$47= Mappings!$F$4, 'Bridge to Wires Calculation'!$E$55,0))","v":0.9},null,"If weighted average is selected for the Bridge to Wires Calculation, this uses the user-input weighting. Otherwise applies 100% to the selected counterfactual backup"]
[null,"6a",null,"Diesel generation air quality value ($/kW-yr)",{"$f":"E14*E15*E16","v":107.570376}," [3a] * [4a]* [5a]"]
[]
[null,"1b","Air quality impacts of battery storage"]
[null,"2b",null,"Air quality health impacts ($/kWh)",0,null,"Predetermined assumption that avoiding storage provides no air quality impact"]
[null,"3b",null,"Hours of usage per year (hours)",{"$f":"E15","v":240},null,{"$f":"G15","v":"Assumes 8 hrs* 30 days/yr "}]
[null,"4b",null,"Probability of Backup Solution being Deployed (without use of DERs)",{"$f":"IF('Bridge to Wires Calculation'!$E$47 = Mappings!$F$6, 1, IF('Bridge to Wires Calculation'!$E$47 = Mappings!$F$4, 'Bridge to Wires Calculation'!$E$56,0))","v":0.1},null,"If weighted average is selected for the Bridge to Wires Calculation, this uses the user-input weighting. Otherwise applies 100% to the selected counterfactual backup"]
[null,"5b",null,"Battery storage air quality value ($/kW-yr)",{"$f":"E20*8760*E21*E22","v":0},"[2b] * 8760 * [3b] * [4b]"]
[]
[null,7,"Weighted average air quality impacts ($/kW-yr)",null,{"$f":"SUM(E23,E17)","v":107.570376},"[5a] + [5b]"]
[null,"*Only applies to Bridge-to-Wires value"]
[]
[]
[null,"Diesel Generation - Emissions Factors for Uncontrolled Diesel Industrial Engines"]
[]
[]
[null,null,null,"Table 3.3-1: Emissions Factors for Uncontrolled Diesel Industrial Engines","Emission Factor (lb/hp-hr)","Emission Factor (lb/kWh)","Emission Factor (US tons/kWh)"]
[null,null,null,"NOx",3.1E-2,{"$f":"E33*0.7456998714","v":2.3116696013400002E-2},{"$f":"0.0005*F33","v":1.1558348006700002E-5}]
[null,null,null,"SOx",2.0500000000000002E-3,{"$f":"E34*0.7456998714","v":1.5286847363700001E-3},{"$f":"0.0005*F34","v":7.6434236818500003E-7}]
[]
[null,null,null,"COBRA Tool","Emission Factor (US tons/GWh) COBRA Inputs","COBRA Results ($2025/GWh) (High)","Health Impacts ($2025/kWh)","Health Impacts ($2025/kW-yr)"]
[null,null,null,"NOx",{"$f":"G33*1000000","v":11.558348006700003}]
[null,null,null,"SOx",{"$f":"G34*1000000","v":0.76434236818500001}]
[null,null,null,"All Pollutants",null,498011,{"$f":"F39/1000000","v":0.49801099999999998},{"$f":"G39*$E$15","v":119.52264}]
[null,null,null,null,null,"COBRA output"]
[]
[]
[null,"Diesel Generation - Emissions Factors for Large Stationary Diesel Engines"]
[]
[]
[null,null,null,"Table 3.4-1: Emissions Factors for Large Stationary Diesel Engines","Emission Factor (lb/hp-hr)","Emission Factor (lb/kWh)","Emission Factor (US tons/kWh)"]
[null,null,null,"NOx",2.4E-2,{"$f":"E47*0.7456998714","v":1.7896796913600001E-2},{"$f":"0.0005*F47","v":8.9483984567999998E-6}]
[null,null,null,"SOx",{"$f":"(0.00809)*0.05","v":4.0450000000000002E-4},{"$f":"E48*0.7456998714","v":3.0163559798130002E-4},{"$f":"0.0005*F48","v":1.5081779899065001E-7}]
[]
[null,null,null,"COBRA Tool","Emission Factor (US tons/GWh) COBRA Inputs","COBRA Results ($2025/GWh)","Health Impacts ($2025/kWh)","Health Impacts ($2025/kW-yr)"]
[null,null,null,"NOx",{"$f":"G47*1000000","v":8.9483984567999997}]
[null,null,null,"SOx",{"$f":"G48*1000000","v":0.15081779899065001}]
[]
[null,null,null,"All Pollutants - Low",null,310360,{"$f":"F54/1000000","v":0.31036000000000002},{"$f":"G54*$E$15","v":74.486400000000003}]
[null,null,null,"All Pollutants - High",null,373512,{"$f":"F55/1000000","v":0.37351200000000001},{"$f":"G55*$E$15","v":89.642880000000005}]
[null,null,null,null,null,"COBRA output"]

{"sheet":"ICE Calculator Results","index":6,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,1,16,1],[15,2,16,2],[15,11,16,11],[15,12,16,12]]}
[]
[null,"ICE Calculator Inputs and Outputs for Value of Lost Load"]
[null,"Users should not edit this tab directly; this is for informational purposes only. Changes to any values on this tab will require re-running the ICE Calculator to determine applicable inputs."]
[]
[null,"EDC Customer Counts",null,null,null,null,null,"Assumed Customer %",null,null,null,"Assumed Statewide Customer Count - ICE Inputs"]
[]
[null,null,"Unitil","National Grid","Eversource","Total EDC",null,"Low","Medium","High",null,"Low","Medium","High"]
[null,"Residential",26386,1210955,1362556,{"$f":"SUM(C8,D8,E8)","v":2599897},null,0.95,{"$f":"F8/$F$10","v":0.86510196795202621},0.7,null,{"$f":"H8*$F8","v":2469902.15},{"$f":"I8*$F8","v":2249176.0111725689},1819927.9]
[null,"Non-Residential",4166,183193,218051,{"$f":"SUM(C9,D9,E9)","v":405410},null,0.05,{"$f":"F9/$F$10","v":0.13489803204797379},0.3,null,{"$f":"H9*$F9","v":20270.5},54689.011172569059,121623]
[null,"Total",{"$f":"SUM(C8:C9)","v":30552},{"$f":"SUM(D8:D9)","v":1394148},1580607,{"$f":"SUM(C10:E10)","v":3005307},null,{"$f":"SUM(H8:H9)","v":1},{"$f":"SUM(I8:I9)","v":1},{"$f":"SUM(J8:J9)","v":1},null,3005307,3005307,3005307]
[null,"Non-Residential includes both Commercial and Industrial customers"]
[]
[]
[null,"ICE Calculator 2.0 Outputs - EDC Specific",null,null,null,null,null,null,null,null,null,"ICE Calculator 2.0 Outputs - Statewide"]
[]
[null,"EDC","Sector",null,null,null,null,null,null,null,null,"Value Range","Sector"]
[null,null,null,"No. of Customers","Cost Per Event (2025 $)","Cost Per Average kW (2025 $)","Cost Per Unserved kWh (2025 $)","Minute Interrupted (2025$)","Annual Cost (2025$)","Total Cost of Sustained Interruptions (2025 $)",null,null,null,"No. of Customers","Cost Per Event (2025 $)","Cost Per Average kW (2025 $)","Cost Per Unserved kWh (2025 $)","Minute Interrupted (2025$)","Annual Cost (2025$)","Total Cost of Sustained Interruptions (2025 $)"]
[null,"Eversource","Residential",1362556,36.51,46.524232111692847,3.876134380453752,5.3097731239092498E-2,36.51,49749311.623411864,null,"Low","Residential",2469902,36.51,46.524232111692847,3.876134380453752,5.3097731239092498E-2,36.51,90180458.097547993]
[null,"Eversource","Non-Residential",218051,7416.1707417102971,991.06915357766138,82.588211169284463,10.300959860383943,7416.1707417102971,1617103366.308054,null,"Low","Non-Residential",20271,7416.1707417102971,991.06915357766138,82.588211169284463,10.300959860383943,7416.1707417102971,150333189.66090748]
[null,"Eversource","All Customers",1580607,1054.5634205933682,176.82606457242582,14.739930191972077,1.4654973821989528,1054.5634205933682,1666852677.9208462,null,"Low","All Customers",2490173,96.584773123909244,54.212783595113436,4.5133071553228623,0.1380541012216405,96.584773123909244,240513647.75845549]
[null,"National Grid","Residential",1210955,36.51,46.524232111692847,3.876134380453752,5.3097731239092498E-2,36.51,44214092.966343805,null,"Medium","Residential",2249176,36.51,46.524232111692847,3.876134380453752,5.3097731239092498E-2,36.51,82121364.340924948]
[null,"National Grid","Non-Residential",183193,7416.1707417102971,991.06915357766138,82.588211169284463,10.300959860383943,7416.1707417102971,1358590499.3900697,null,"Medium","Non-Residential",54689,7416.1707417102971,991.06915357766138,82.588211169284463,10.300959860383943,7416.1707417102971,405582941.60121292]
[null,"National Grid","All Customers",1394148,1006.2126265270506,170.64548865619545,14.21957242582897,1.401780104712042,1006.2126265270506,1402804592.3564134,null,"Medium","All Customers",2303865,211.69003490401397,68.952713787085514,5.7451745200698081,0.29734729493891798,211.69003490401397,487704305.94213784]
[null,"Unitil","Residential",26386,36.51,46.524232111692847,3.876134380453752,5.3097731239092498E-2,36.51,963399.18246073299,null,"High","Residential",1819928,36.51,46.524232111692847,3.876134380453752,5.3097731239092498E-2,36.51,66448766.287303664]
[null,"Unitil","Non-Residential",4166,7416.1707417102971,991.06915357766138,82.588211169284463,10.300959860383943,7416.1707417102971,30895765.780750435,null,"High","Non-Residential",121623,7416.1707417102971,991.06915357766138,82.588211169284463,10.300959860383943,7416.1707417102971,901976889.44260025]
[null,"Unitil","All Customers",30552,1042.7863438045376,175.31808900523561,14.612495636998254,1.444258289703316,1042.7863438045376,31859164.963211168,null,"High","All Customers",1941551,498.78946771378708,105.69634380453752,8.8036038394415339,0.6902705061082024,498.78946771378708,968425655.72990394]

{"sheet":"Reference Utility Data","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
[]
[null,null,"Electricity Sales","Line Loss"]
[null,null,"Total Sales MWh)","Average Technical Line Loss","Marginal Line Loss*"]
[null,"EDC Average",{"$f":"AVERAGE(C5:C7)","v":8128978.333333333},{"$f":"SUMPRODUCT($C$5:$C$7, D$5:D$7)/SUM($C$5:$C$7)","v":6.5135940363149375E-2},{"$f":"SUMPRODUCT($C$5:$C$7, E$5:E$7)/SUM($C$5:$C$7)","v":9.7703910544724035E-2}]
[null,"Unitil",431532,3.3300000000000003E-2,{"$f":"D5*(1.5)","v":4.9950000000000008E-2}]
[null,"Eversource",22584860,6.5000000000000002E-2,{"$f":"D6*(1.5)","v":9.7500000000000003E-2}]
[null,"National Grid (combined)",1370543,{"$f":"AVERAGE(D8:D9)","v":7.7399999999999997E-2},{"$f":"D7*(1.5)","v":0.11609999999999999}]
[null,"National Grid: Massachusetts Electric Co.",1356226,6.9699999999999998E-2]
[null,"National Grid: Nantucket Electric Co.",14317,8.5099999999999995E-2]
[null,null,"*sourced from EIA Form 816, year 2023",null,"*calculated as Average Technical Line Loss x 1.5"]

{"sheet":"Mappings","index":8,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Valuation","EDCs","Deferral Value Selection","B2W Value Selection","B2W Calculation Selection","Diesel Generator Emissions Factor Selection","Capacity Selection","Compensation Selection","Yes/No"]
[null,"Deferral","Eversource","User Input","High","Weighted Average of Avoided Backup Solutions","Uncontrolled Diesel Industrial Engines","MW needed","% of compensation","Yes",1]
[null,"Bridge-to-Wires","National Grid","Example 1","Medium","Avoided Backup Diesel Generator","Large Stationary Diesel Engines","Technology Enrolled","Fixed value","No",2]
[null,null,"Unitil","Example 2","Low","Avoided Backup Energy Storage",null,null,null,null,3]
[null,null,null,"Example 3",null,"Value of Load",null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,10]