{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Guidelines and Overview","Summary","Input Sheet - Device Type 1","Input Sheet - Device Type 2","Input Sheet - Device Type 3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Guidelines and Overview","index":0,"n_rows":66,"n_cols":2,"rows_kept":66,"cut":false,"hidden":false,"merged":[[7,1,22,1],[25,1,29,1]]}
[]
[null,"Distributed Energy Systems Demonstrations FOA"]
[null,"Techno-Economic Analysis Workbook"]
[null,"Guidelines and Overview"]
[null,"DE-FOA-0003139"]
[]
[null,"Guidelines"]
[null,"1. The intent of this workbook is to supplement the TEA discussions in the technical volume by providing quantitative and qualitative measures of system performance, cost, revenue, and benefits to assess the technical performance of the asset, as well as financial viability and/or defensibility of the project.\n\n2. Below are the categories A through E for the data to be provided. These should encompass all the incremental system build and costs required to implement the DES and provide commercial energy services, and the incremental associated revenue and benefits. Please list only systems/costs/revenues/benefits that are additional to the base function of the proposed DES (transport, HVAC, controller, electrolyzer, etc.). Power generation assets that are pre-existing and connected to the new DES asset should be treated as sunk costs/non-incremental systems for the purposes of this assessment.\n\n3. Categories A through C below contain illustrative examples of the line items that should be provided as quantitative data, with sources and derivation methodologies cited where applicable.\n\n4. Please note for Category B, in the case of a utility applicant, the applicant should indicate whether the cost is recoverable and can be included in the rate-base.\n\n4. Category D should be quantified where data is available, but a qualitative assessment or discussion should be provided if quantitative metrics are not available.\n\n5. Category E is an open-ended category where any other quantitative or qualitative measures of value provided by the DES should be added.\n\n6. Rows and line items should be added and modified as required to fit the applicant's specific operating and business model."]
{"$rows_empty":16}
[null,"Input Sheets - Device Type"]
[null,"Three initial input sheets are provided, each for a discrete device type if the project uses multiple types of devices or DER/DES (refer to FOA Table 3 - EV fleet, stationary battery storage, VPP, etc.). Each sheet should contain the TEA for the aggregate or total number of units for each device type (for example all EVs in an EV fleet).\n\nNot all sheets need to be used if the project only uses a single device type, and more tabs can be added if required. Please add the totals to the summary tab if additional tabs are used."]
[]
[]
[]
[]
[]
[null,"Data Overview with Illustrative Data Fields"]
[]
[null,"A. Technical Parameters (Quantitative)"]
[null,"# of Devices"]
[null,"# of Customer Accounts Participating"]
[null,"Flexible Capacity per DER"]
[null,"Total Flexible Capacity of the System"]
[null,"Number of Events per Year"]
[null,"Average Power Delivered per Event"]
[null,"Total Annual Delivered Energy"]
[]
[null,"B1. Capital Expenditures(Quantitative)"]
[null,"Project implementation costs: DER Management Systems, associated IT and personnel costs, administrative costs."]
[null,"Participant acquisition costs: Marketing, consumer education, recruitment; potential DER subsidies; potential DER software integration fees paid to DER manufacturers."]
[]
[null,"B2. Operational Expenditures (Quantitative)"]
[null,"Administrative costs, operational costs"]
[null,"Participant incentives: One-time, periodic, or per-kWh payments to participants."]
[]
[null,"C. Revenue Value (Quantitative)"]
[null,"Energy: Payment per MWh delivered (avoided, shifted, or exported), measured using contractually agreed-upon measurement and verification protocols that vary by DER type."]
[null,"Capacity: Payment per MW of energy option procured (capacity product specifications vary by market; for example energy efficiency product specifications are different from demand response products)."]
[null,"Ancillary services: Payment for services such as frequency regulation, ramping, etc."]
[null,"Additional Benefits"]
[]
[null,"D. Avoided Cost (Counterfactual) Value (Quantitative and/or Qualitative)"]
[null,"Avoided Generation Capacity"]
[null,"Avoided Energy Costs"]
[null,"Avoided costs: Payment proportional to the avoided cost of infrastructure upgrades (compensation varies by market)."]
[null,"T&D Deferral"]
[null,"Avoided Emissions"]
[null,"Reliability"]
[null,"Resiliency"]
[]
[null,"E. Total Value (Open-Ended)"]

{"sheet":"Summary","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,1,6,6]]}
[]
[null,"Distributed Energy Systems Demonstrations FOA"]
[null,"Techno-Economic Analysis Workbook"]
[null,"TEA Summary"]
[null,"DE-FOA-0003139"]
[]
[null,"Summary"]
[]
[null,null,"Total Annual Energy Delivered",null,null,{"$f":"SUM('Input Sheet - Device Type 1'!F102,'Input Sheet - Device Type 2'!F102,'Input Sheet - Device Type 3'!F102)","v":0}]
[]
[{"$nulls":4},"Total","Annualized","Annualized"]
[null,null,"Capital Expenditures",null,{"$f":"SUM('Input Sheet - Device Type 1'!E105,'Input Sheet - Device Type 2'!E105,'Input Sheet - Device Type 3'!E105)","v":0},{"$f":"SUM('Input Sheet - Device Type 1'!F105,'Input Sheet - Device Type 2'!F105,'Input Sheet - Device Type 3'!F105)","v":0}]
[null,null," "]
[null,null,"Operating Expenditures",null,null,{"$f":"SUM('Input Sheet - Device Type 1'!F107,'Input Sheet - Device Type 2'!F107,'Input Sheet - Device Type 3'!F107)","v":0}]
[null,null,"Fixed",null,null,{"$f":"SUM('Input Sheet - Device Type 1'!F108,'Input Sheet - Device Type 2'!F108,'Input Sheet - Device Type 3'!F108)","v":0}]
[null,null,"Variable",null,null,{"$f":"SUM('Input Sheet - Device Type 1'!F109,'Input Sheet - Device Type 2'!F109,'Input Sheet - Device Type 3'!F109)","v":0}]
[]
[null,null,"Revenues",null,null,{"$f":"SUM('Input Sheet - Device Type 1'!F111,'Input Sheet - Device Type 2'!F111,'Input Sheet - Device Type 3'!F111)","v":0}]

{"sheet":"Input Sheet - Device Type 1","index":2,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[[43,1,43,6],[50,1,50,6],[99,1,99,6],[5,5,5,6],[44,1,44,6],[82,2,86,5],[10,1,10,3],[60,1,60,3],[20,1,20,3],[70,1,70,3],[42,1,42,3],[89,1,89,3],[92,2,96,5]]}
[]
[null,"Distributed Energy Systems Demonstrations FOA"]
[null,"Techno-Economic Analysis Workbook"]
[null,"TEA Input Worksheet - Device Type 1"]
[null,"DE-FOA-0003139"]
[{"$nulls":5},"Key"]
[null,null,"Control Number:",null,null,null,"Applicant provided data"]
[null,null,"Applicant Name:",null,null,null,"Calculated value"]
[null,null,"Device Type (e.g. stationary energy storage, electric vehicles, etc.):"]
[]
[null,"A. Technical Parameters (Quantitative)",null,null,"Input Values","Calculated Values","Units"]
[null,"A.1","# of Devices",null,0,null,"#"]
[null,"A.2","Flexible Capacity per Device",null,0,null,"kW"]
[null,"A.3","Total Flexible Capacity of the System","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E12*E13","v":0},"kW"]
[null,"A.4","Number of Events per Year",null,0,null,"#"]
[null,"A.5","Average Power Delivered per Event per Device",null,0,null,"kW"]
[null,"A.6","Average Duration per Event",null,0,null,"hr"]
[null,"A.7","Total Annual Delivered Energy","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E12*E15*E16*E17","v":0},"kWh"]
[null,null,null,"Add rows as necessary"]
[]
[null,"B1. Capital Expenditures (Quantitative)",null,null,"Input Values","Annualized Value","Units"]
[]
[null,"B1.1","Project Lifetime",null,0,null,"Years"]
[null,"B1.2","Cost of Capital",null,0,null,"%"]
[null,"B1.3","Capital Recovery Factor",null,null,{"$f":"IFERROR((E24*(1+E24)^E23)/((1+E24)^E23-1),0)","v":0}]
[]
[null,"B1.4","Project Implementation Costs","If utility applicant, recoverable and rate-baseable? (Y/N)",null,{"$f":"SUM(F28:F30)","v":0},"Total Cost $"]
[null,"B1.5","IT System Integration",null,0,{"$f":"E28*$F$25","v":0},"Total Cost $"]
[null,"B1.6","Hardware",null,0,{"$f":"E29*$F$25","v":0},"Total Cost $"]
[null,"B1.5","Labor",null,0,{"$f":"E30*$F$25","v":0},"Total Cost $"]
[null,null,null,"Add rows as necessary"]
[]
[null,"B1.1","Estimated Average Customer Lifespan",null,0,null,"Years"]
[]
[null,"B1.7","Customer Acquisition Costs (CAC)","If utility applicant, recoverable and rate-baseable? (Y/N)",null,{"$f":"F40","v":0},"Total Cost $"]
[null,null,"# of Customers",null,0,null,"#"]
[null,null,"One-Time CAC: Marketing & Recruitment (per Customer)",null,0,null,"$/Customer"]
[null,null,"One-Time CAC: Equipment & Installation (per Customer)",null,0,null,"$/Customer"]
[null,null,"One-Time CAC: Upfront Incentive (per Customer)",null,0,null,"$/Customer"]
[null,null,"Subtotal CAC",null,{"$f":"SUM(E37:E39)*E36","v":0},{"$f":"E40*F25","v":0},"Total Cost $"]
[null,null,null,"Add rows as necessary"]
[]
[null,"B2. Operating Expenditures",null,null,"Input Values","Calculated Values","Measurement Unit"]
[]
[null,"Fixed"]
[null,"B2.1","Operating Costs",null,null,{"$f":"SUM(E47:E48)","v":0},"Total Annual Operating Costs"]
[null,"B2.2","Annual Software Costs",null,0,null,"$/Year"]
[null,"B2.3","Annual Administrative Costs",null,0,null,"$/Year"]
[null,null,null,"Add rows as necessary"]
[]
[null,"Variable"]
[null,"O.","Customer Costs","Comments",null,{"$f":"SUM(F54,F56)","v":0},"Total Annual Customer Costs"]
[null,"O.1","Average Activation Incentive (per Event)",null,0,null,"$/Event"]
[null,"O.2","Total Activation Cost per Year","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E53*E15","v":0}]
[null,"O.3","Energy Export Credit Cost ($/Unit Energy)",null,0,null,"$/kWh"]
[null,"O.5","Annual Energy Export Credit Cost","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E55*E18","v":0},"$/Year"]
[null,"O.6","Ongoing CAC (Churn)"]
[null,null,null,"Add rows as necessary"]
[]
[]
[null,"C. Revenues (Quantitative)",null,null,"Input Values","Calculated Values","Units"]
[]
[null,"C","Total Revenue","Comments",null,{"$f":"SUM(E65,E67,E68)","v":0},"Total Annual Revenue"]
[null,"C.1","Energy Sales Price",null,0,null,"$/kWh"]
[null,"C.2","Energy Revenue","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E64*E18","v":0},"$/Year"]
[null,"C.3","Capacity Price or Equivalent",null,0,null,"$/kW-yr"]
[null,"C.4","Capacity Revenue or Equivalent",null,0,{"$f":"E66*E14","v":0},"$/Year"]
[null,"C.5","Ancillary Services","If revenue is generated from ancillary services, please provide additional details around the types of service, frequency of event, unit price, etc.",0,null,"$/Year"]
[null,null,null,"Add rows as necessary"]
[]
[null,"D. Avoided Costs (Quantitative and/or Qualitative)",null,null,null,"Total Incentives"]
[]
[null,"L.","Avoided Costs","Methodology","Quantitative","Qualitative"]
[null,null,"Avoided Generation Capacity"]
[null,null,"Avoided Energy Costs"]
[null,null,"Avoided Infrastructure Upgrades"]
[null,null,"T&D Deferral"]
[null,null,"Reliability"]
[null,null,"Resilience"]
[null,null,null,"Add rows as necessary"]
[]
[null,null,"Avoided Cost Narrative"]
{"$rows_empty":7}
[null,"E. Total Value (Open Ended)"]
[]
[null,null,"Total Value Narrative"]
{"$rows_empty":7}
[null,"Summary"]
[]
[null,null,"Total Annual Energy Delivered",null,null,{"$f":"F18","v":0}]
[]
[{"$nulls":4},"Total","Annualized","Annualized"]
[null,null,"Capital Expenditures",null,{"$f":"SUM(E28:E30,E40)","v":0},{"$f":"SUM(F27,F35)","v":0}]
[null,null," "]
[null,null,"Operating Expenditures",null,null,{"$f":"F46","v":0}]
[null,null,"Fixed",null,null,{"$f":"F46","v":0}]
[null,null,"Variable",null,null,{"$f":"F52","v":0}]
[]
[null,null,"Revenues",null,null,{"$f":"F63","v":0}]

{"sheet":"Input Sheet - Device Type 2","index":3,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[[99,1,99,6],[50,1,50,6],[60,1,60,3],[70,1,70,3],[82,2,86,5],[89,1,89,3],[92,2,96,5],[44,1,44,6],[5,5,5,6],[10,1,10,3],[20,1,20,3],[42,1,42,3],[43,1,43,6]]}
[]
[null,"Distributed Energy Systems Demonstrations FOA"]
[null,"Techno-Economic Analysis Workbook"]
[null,"TEA Input Worksheet - Device Type 2"]
[null,"DE-FOA-0003139"]
[{"$nulls":5},"Key"]
[null,null,"Control Number:",null,null,null,"Applicant provided data"]
[null,null,"Applicant Name:",null,null,null,"Calculated value"]
[null,null,"Device Type (e.g. stationary energy storage, electric vehicles, etc.):"]
[]
[null,"A. Technical Parameters (Quantitative)",null,null,"Input Values","Calculated Values","Units"]
[null,"A.1","# of Devices",null,0,null,"#"]
[null,"A.2","Flexible Capacity per Device",null,0,null,"kW"]
[null,"A.3","Total Flexible Capacity of the System","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E12*E13","v":0},"kW"]
[null,"A.4","Number of Events per Year",null,0,null,"#"]
[null,"A.5","Average Power Delivered per Event per Device",null,0,null,"kW"]
[null,"A.6","Average Duration per Event",null,0,null,"hr"]
[null,"A.7","Total Annual Delivered Energy","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E12*E15*E16*E17","v":0},"kWh"]
[null,null,null,"Add rows as necessary"]
[]
[null,"B1. Capital Expenditures (Quantitative)",null,null,"Input Values","Annualized Value","Units"]
[]
[null,"B1.1","Project Lifetime",null,0,null,"Years"]
[null,"B1.2","Cost of Capital",null,0,null,"%"]
[null,"B1.3","Capital Recovery Factor",null,null,{"$f":"IFERROR((E24*(1+E24)^E23)/((1+E24)^E23-1),0)","v":0}]
[]
[null,"B1.4","Project Implementation Costs","If utility applicant, recoverable and rate-baseable? (Y/N)",null,{"$f":"SUM(F28:F30)","v":0},"Total Cost $"]
[null,"B1.5","IT System Integration",null,0,{"$f":"E28*$F$25","v":0},"Total Cost $"]
[null,"B1.6","Hardware",null,0,{"$f":"E29*$F$25","v":0},"Total Cost $"]
[null,"B1.5","Labor",null,0,{"$f":"E30*$F$25","v":0},"Total Cost $"]
[null,null,null,"Add rows as necessary"]
[]
[null,"B1.1","Estimated Average Customer Lifespan",null,0,null,"Years"]
[]
[null,"B1.7","Customer Acquisition Costs (CAC)","If utility applicant, recoverable and rate-baseable? (Y/N)",null,{"$f":"F40","v":0},"Total Cost $"]
[null,null,"# of Customers",null,0,null,"#"]
[null,null,"One-Time CAC: Marketing & Recruitment (per Customer)",null,0,null,"$/Customer"]
[null,null,"One-Time CAC: Equipment & Installation (per Customer)",null,0,null,"$/Customer"]
[null,null,"One-Time CAC: Upfront Incentive (per Customer)",null,0,null,"$/Customer"]
[null,null,"Subtotal CAC",null,{"$f":"SUM(E37:E39)*E36","v":0},{"$f":"E40*F25","v":0},"Total Cost $"]
[null,null,null,"Add rows as necessary"]
[]
[null,"B2. Operating Expenditures",null,null,"Input Values","Calculated Values","Measurement Unit"]
[]
[null,"Fixed"]
[null,"B2.1","Operating Costs",null,null,{"$f":"SUM(E47:E48)","v":0},"Total Annual Operating Costs"]
[null,"B2.2","Annual Software Costs",null,0,null,"$/Year"]
[null,"B2.3","Annual Administrative Costs",null,0,null,"$/Year"]
[null,null,null,"Add rows as necessary"]
[]
[null,"Variable"]
[null,"O.","Customer Costs","Comments",null,{"$f":"SUM(F54,F56)","v":0},"Total Annual Customer Costs"]
[null,"O.1","Average Activation Incentive (per Event)",null,0,null,"$/Event"]
[null,"O.2","Total Activation Cost per Year","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E53*E15","v":0}]
[null,"O.3","Energy Export Credit Cost ($/Unit Energy)",null,0,null,"$/kWh"]
[null,"O.5","Annual Energy Export Credit Cost","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E55*E18","v":0},"$/Year"]
[null,"O.6","Ongoing CAC (Churn)"]
[null,null,null,"Add rows as necessary"]
[]
[]
[null,"C. Revenues (Quantitative)",null,null,"Input Values","Calculated Values","Units"]
[]
[null,"C","Total Revenue","Comments",null,{"$f":"SUM(E65,E67,E68)","v":0},"Total Annual Revenue"]
[null,"C.1","Energy Sales Price",null,0,null,"$/kWh"]
[null,"C.2","Energy Revenue","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E64*E18","v":0},"$/Year"]
[null,"C.3","Capacity Price or Equivalent",null,0,null,"$/kW-yr"]
[null,"C.4","Capacity Revenue or Equivalent",null,0,{"$f":"E66*E14","v":0},"$/Year"]
[null,"C.5","Ancillary Services","If revenue is generated from ancillary services, please provide additional details around the types of service, frequency of event, unit price, etc.",0,null,"$/Year"]
[null,null,null,"Add rows as necessary"]
[]
[null,"D. Avoided Costs (Quantitative and/or Qualitative)",null,null,null,"Total Incentives"]
[]
[null,"L.","Avoided Costs","Methodology","Quantitative","Qualitative"]
[null,null,"Avoided Generation Capacity"]
[null,null,"Avoided Energy Costs"]
[null,null,"Avoided Infrastructure Upgrades"]
[null,null,"T&D Deferral"]
[null,null,"Reliability"]
[null,null,"Resilience"]
[null,null,null,"Add rows as necessary"]
[]
[null,null,"Avoided Cost Narrative"]
{"$rows_empty":7}
[null,"E. Total Value (Open Ended)"]
[]
[null,null,"Total Value Narrative"]
{"$rows_empty":7}
[null,"Summary"]
[]
[null,null,"Total Annual Energy Delivered",null,null,{"$f":"F18","v":0}]
[]
[{"$nulls":4},"Total","Annualized","Annualized"]
[null,null,"Capital Expenditures",null,{"$f":"SUM(E28:E30,E40)","v":0},{"$f":"SUM(F27,F35)","v":0}]
[null,null," "]
[null,null,"Operating Expenditures",null,null,{"$f":"F46","v":0}]
[null,null,"Fixed",null,null,{"$f":"F46","v":0}]
[null,null,"Variable",null,null,{"$f":"F52","v":0}]
[]
[null,null,"Revenues",null,null,{"$f":"F63","v":0}]

{"sheet":"Input Sheet - Device Type 3","index":4,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[[99,1,99,6],[50,1,50,6],[60,1,60,3],[70,1,70,3],[82,2,86,5],[89,1,89,3],[92,2,96,5],[44,1,44,6],[5,5,5,6],[10,1,10,3],[20,1,20,3],[42,1,42,3],[43,1,43,6]]}
[]
[null,"Distributed Energy Systems Demonstrations FOA"]
[null,"Techno-Economic Analysis Workbook"]
[null,"TEA Input Worksheet - Device Type 3"]
[null,"DE-FOA-0003139"]
[{"$nulls":5},"Key"]
[null,null,"Control Number:",null,null,null,"Applicant provided data"]
[null,null,"Applicant Name:",null,null,null,"Calculated value"]
[null,null,"Device Type (e.g. stationary energy storage, electric vehicles, etc.):"]
[]
[null,"A. Technical Parameters (Quantitative)",null,null,"Input Values","Calculated Values","Units"]
[null,"A.1","# of Devices",null,0,null,"#"]
[null,"A.2","Flexible Capacity per Device",null,0,null,"kW"]
[null,"A.3","Total Flexible Capacity of the System","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E12*E13","v":0},"kW"]
[null,"A.4","Number of Events per Year",null,0,null,"#"]
[null,"A.5","Average Power Delivered per Event per Device",null,0,null,"kW"]
[null,"A.6","Average Duration per Event",null,0,null,"hr"]
[null,"A.7","Total Annual Delivered Energy","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E12*E15*E16*E17","v":0},"kWh"]
[null,null,null,"Add rows as necessary"]
[]
[null,"B1. Capital Expenditures (Quantitative)",null,null,"Input Values","Annualized Value","Units"]
[]
[null,"B1.1","Project Lifetime",null,0,null,"Years"]
[null,"B1.2","Cost of Capital",null,0,null,"%"]
[null,"B1.3","Capital Recovery Factor",null,null,{"$f":"IFERROR((E24*(1+E24)^E23)/((1+E24)^E23-1),0)","v":0}]
[]
[null,"B1.4","Project Implementation Costs","If utility applicant, recoverable and rate-baseable? (Y/N)",null,{"$f":"SUM(F28:F30)","v":0},"Total Cost $"]
[null,"B1.5","IT System Integration",null,0,{"$f":"E28*$F$25","v":0},"Total Cost $"]
[null,"B1.6","Hardware",null,0,{"$f":"E29*$F$25","v":0},"Total Cost $"]
[null,"B1.5","Labor",null,0,{"$f":"E30*$F$25","v":0},"Total Cost $"]
[null,null,null,"Add rows as necessary"]
[]
[null,"B1.1","Estimated Average Customer Lifespan",null,0,null,"Years"]
[]
[null,"B1.7","Customer Acquisition Costs (CAC)","If utility applicant, recoverable and rate-baseable? (Y/N)",null,{"$f":"F40","v":0},"Total Cost $"]
[null,null,"# of Customers",null,0,null,"#"]
[null,null,"One-Time CAC: Marketing & Recruitment (per Customer)",null,0,null,"$/Customer"]
[null,null,"One-Time CAC: Equipment & Installation (per Customer)",null,0,null,"$/Customer"]
[null,null,"One-Time CAC: Upfront Incentive (per Customer)",null,0,null,"$/Customer"]
[null,null,"Subtotal CAC",null,{"$f":"SUM(E37:E39)*E36","v":0},{"$f":"E40*F25","v":0},"Total Cost $"]
[null,null,null,"Add rows as necessary"]
[]
[null,"B2. Operating Expenditures",null,null,"Input Values","Calculated Values","Measurement Unit"]
[]
[null,"Fixed"]
[null,"B2.1","Operating Costs",null,null,{"$f":"SUM(E47:E48)","v":0},"Total Annual Operating Costs"]
[null,"B2.2","Annual Software Costs",null,0,null,"$/Year"]
[null,"B2.3","Annual Administrative Costs",null,0,null,"$/Year"]
[null,null,null,"Add rows as necessary"]
[]
[null,"Variable"]
[null,"O.","Customer Costs","Comments",null,{"$f":"SUM(F54,F56)","v":0},"Total Annual Customer Costs"]
[null,"O.1","Average Activation Incentive (per Event)",null,0,null,"$/Event"]
[null,"O.2","Total Activation Cost per Year","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E53*E15","v":0}]
[null,"O.3","Energy Export Credit Cost ($/Unit Energy)",null,0,null,"$/kWh"]
[null,"O.5","Annual Energy Export Credit Cost","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E55*E18","v":0},"$/Year"]
[null,"O.6","Ongoing CAC (Churn)"]
[null,null,null,"Add rows as necessary"]
[]
[]
[null,"C. Revenues (Quantitative)",null,null,"Input Values","Calculated Values","Units"]
[]
[null,"C","Total Revenue","Comments",null,{"$f":"SUM(E65,E67,E68)","v":0},"Total Annual Revenue"]
[null,"C.1","Energy Sales Price",null,0,null,"$/kWh"]
[null,"C.2","Energy Revenue","If input and calculated values do not match, please provide a reconciliation.",0,{"$f":"E64*E18","v":0},"$/Year"]
[null,"C.3","Capacity Price or Equivalent",null,0,null,"$/kW-yr"]
[null,"C.4","Capacity Revenue or Equivalent",null,0,{"$f":"E66*E14","v":0},"$/Year"]
[null,"C.5","Ancillary Services","If revenue is generated from ancillary services, please provide additional details around the types of service, frequency of event, unit price, etc.",0,null,"$/Year"]
[null,null,null,"Add rows as necessary"]
[]
[null,"D. Avoided Costs (Quantitative and/or Qualitative)",null,null,null,"Total Incentives"]
[]
[null,"L.","Avoided Costs","Methodology","Quantitative","Qualitative"]
[null,null,"Avoided Generation Capacity"]
[null,null,"Avoided Energy Costs"]
[null,null,"Avoided Infrastructure Upgrades"]
[null,null,"T&D Deferral"]
[null,null,"Reliability"]
[null,null,"Resilience"]
[null,null,null,"Add rows as necessary"]
[]
[null,null,"Avoided Cost Narrative"]
{"$rows_empty":7}
[null,"E. Total Value (Open Ended)"]
[]
[null,null,"Total Value Narrative"]
{"$rows_empty":7}
[null,"Summary"]
[]
[null,null,"Total Annual Energy Delivered",null,null,{"$f":"F18","v":0}]
[]
[{"$nulls":4},"Total","Annualized","Annualized"]
[null,null,"Capital Expenditures",null,{"$f":"SUM(E28:E30,E40)","v":0},{"$f":"SUM(F27,F35)","v":0}]
[null,null," "]
[null,null,"Operating Expenditures",null,null,{"$f":"F46","v":0}]
[null,null,"Fixed",null,null,{"$f":"F46","v":0}]
[null,null,"Variable",null,null,{"$f":"F52","v":0}]
[]
[null,null,"Revenues",null,null,{"$f":"F63","v":0}]