{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Disclaimer","LDCcomments","Definitions","General Input","Checklist","Host Organization Goals","Budget","Goals","Decision Makers","System","Policies","EM Team","EMP","QR","Utility Data","Dashboard","Executive Summary","Baseline Model","Project Business Case","ExecSummaryCalculation","Non-Incented Template","DropDownLists","Revision Note","LDCs","Input Data","Version Log"],"not_rendered":{"charts":11,"images":0,"macros":1,"external_links":0,"defined_names":94,"comments":1,"pivot_tables":2},"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":"Disclaimer","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"LDCcomments","index":1,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Originator","EMP Template","Issues/Items Requiring Clarification => Version 2.1?","Guide","EM Support Services","Action Items","Status"]
["Kyle Ohearn","First Principles for EM plan;\nMust be Useful to the EMs and their companies\nNot a bible/book\nNo plan element is mandatory\nPhase 1 plan should be considered the first 6 month plan with Year 2 and 3 plans updated/ continually improved\nPlan to document yearly kW and kWh targets \nPlan to pull project title, kW & kWh savings, cost from QR’s (make sure QR has appropriate fields for EM plan tab)\nUse non energy language for CFO and other executive audience\nFormatted to be a good printable executive document\n","All addressed or in progress "]
["Kyle Ohearn","Executive Summary\n- Energy Efficiency Targets\no Year 1 Target \n kW and kWh\no Year 2 Target \n kW and kWh\no Year 3 Target\n kW and KWh","Addressed"]
["Kyle Ohearn","Check list questions: \n\nWho are the executive approvers ? \nDo you have the utility account numbers, utility contact names, utility data, other meter information ? links?\nWhat are the corporate hurdle rates for capital projects?  NPV? Simple payback, IRR?, etc??","Incorporated but in slightly different format per Kyle's direction"]
["Kyle Ohearn","Energy Management Goals (policy, targets, goals)\nDoes your corporation have an Energy Savings plan/policy/ Sustainability plan/policy. If Yes,  Link to policy or copy into an appendix tab?\n\nDo the corporate plans have identified SMARTER metrics/ goals? (SMARTER plan/policies ? => specific (kW, kWh?, measurable, attainable, relevant, time-bound, evaluate, re-evaluate)\nDoes your company have Energy dashboards for executives? If yes link what do they look like\nDo you have procurement rules for energy saving equipment? : rephrase as a question about energy procurement policies?","Somewhat addressed per Kyle's direction"]
["Kyle Ohearn","Energy Management Team (accountability)\n- List Executive/Management Sponsor\n- List Energy Champion\n- Other team members\n- Meeting schedule \n- Meeting agenda","Addressed"]
["Kyle Ohearn","Corporate hurdle rate for capital projects? What are parameters to have your capital projects approved?\nDo you know the approval parameters to get O&M projects approved?\nDo you know if your executives have KPI’s? If Yes, what are they?\nDo you have dedicated budgets?\nWhat are the budget cycles?","Addressed"]
["Kyle Ohearn","Best Practice Questions:\nAre you able to chart your energy/use profile?\nDo you need any assistance to collect the information? \nCan you spot trends with your utility data?\nDo you know your main energy uses/ systems?\nAre they sub-metered?\nDo you know how your facility is metered?","Addressed"]
["Kyle Ohearn","Best Practice Tab\n\nAre you able to chart your energy/use profile?\nDo you need any assistance to collect the information? \nCan you spot trends with your utility data\nDo you know your main energy uses/ systems?\nAre they sub-metered?\nDo you know how your facility is metered?\nIs there a sub-meter plan?\nEnergy Modelling","Partially addressed"]
["Kyle Ohearn","Measurement and Evaluation (what’s available & how to evaluate success?)\n- Consider for Phase 2","not addressed"]
["Kyle Ohearn","Energy Baseline Model (SEM best practice for O&M savings) \n- Consider for Phase 2","tab in progress for phase 2"]
["Kyle Ohearn","Year 1 target kW and kWh plan project listing\nCompleted Project L: Project Title, Project Cost, kW and kWh savings? Project class (capital? Non incented? O&M ?) Dollars saved?\n Pull from QR\nPipe line Project Title, costs \n Pull from QR\n\nDifference ( calculate delta)\n\nHow much money is planned to save in Year 1? How much money was saved?\n\nYear 2 target kW and kWh\nCompleted\nPipe line\nDifference\n\nHow much money is planned to save in Year 2? How much money was saved?\n\nYear 3 target kW and kWh \nCompleted\nPipe line\nDifference\n\nHow much money is planned to save in Year 3? How much money was saved?","Addressed and added General Info (Intro) Tab"]
["Kyle Ohearn","Energy Efficiency Opportinity Identification\no Energy scans\no Kaizen events\no Employee engagement program\n\nCommunication Strategy\no Dashboard\no Newsletter\no Case studies/project highlights\no Other\n\nContinous Improvement\no Energy Management Plan Maintenance\no Lessons Learnt\n                                                                                                                                                                                                                                                                What worked, What did not?\n Course corrections\n Non enenergy benefits\n\nBEST PRACTICES","Removed from EMP per Kyle's direction"]
["Gord Davies","1. Add an additional tab to the workbook to provide an area for workbook / worksheet description. Have a sort description of the content function and value of each tab, and provide an overview of how the worksheets are related. Highlight the total information the workbook provides. Describe use on quarterly, annual and continued use. Include an email address and a contact name for an Energy Manager to ask questions","- intros and descriptions will be added to top of each tab\n- navigation buttons and intro tab flow chart describes process\n- TR contact to be added to the intro tab"]
["Gord Davies","2. Include a brief description at the top of each tab which provides and overview of the information presented.","partially complete but intent is there to provide"]
["Gord Davies","3. In the energy management plan tab allow an area for the EM to write the answer to the question asked to allow for explanations if warranted","EMP restructured per Kyle's comments"]
["Gord Davies","4. In the quarterly report tab provide a line that specifies the exact timeframe that a given quarterly report covers. For example (April 1 to June 30th 2016) ","CR can add this as part off their tech review"]
["Gord Davies","5. In the Energy Manager Dashboard link what quarter this is to identify how up to date the information is that is presented.","Dashboard will be flexible so that EM can choose Q# or Term# or cummulative"]
["Gord Davies","6. In the executive tab define how calculations are done.   i.e. (what rates are used and why).","Will do - phase 2"]
["Gord Davies","7. In the executive tab capture other valuable savings to an organization gas etc.","Will do - phase 2"]
["Mike Pardal","Do we need a financial target up front in the annual goals section? MWh is really the only goal","No, per Kyle's direction"]
[null,"Should we put an anniversary date, term and deliverables with due dates based on start date in that section – keep it top of mind - i.e. Q Reports, EMP etc.","Deliverable tracker added to Intro tab. Automatic based on EM start date."]
[null,"Aside from adding projects in the report how can we capture other accomplishments or activities planned to evaluate performance and potential","Potential to add a planned activities section (i.e. Employee Enagagement, Energy Scans, etc) to EMP tab"]
[null,"Do we want a notes section or somewhere for them to document the answers to these questions – document the action taken and capture critical customer info - it can be passed on to the utility or another resource should the EM leave","- customer info captured in intro tab\n- moved away from a question fromat per Kyle's direction"]
[null,"Project evaluation can be production based or outside the standard financial metrics"," - good point, flexibility needed. This section is moved to tips per Kyle's direction. Opportunity to reverse decision and improve EMP."]
[null,"Quarterly report – applications type doesn’t have option for prescriptive or M&T or audit etc.","- CR to add"]
["Dan Roberts",null,"• Coordination with new IS\n• EMP Template ( Underway)\n• Access to TR services (This topic)\n• Coordination with IESO EM strategy\n• EM Rules 2.0 R1"]
["Dan Roberts",null,"Participant Agreements:\n1. Should LDCs be customizing these things?\n2. If they do customize them is Anna available to assist?\n3. Should edits lead to a revised provincial standard PA? If so how?"]
["Kyle Ohearn",null,"Verification’ as used here in the program rules ‘gross verified savings as verified by the Technical Reviewer and based on projects placed into service in the contract year’. \n\nBased on the highlights below ( see 2.1.2) , there are 4 conditions:\n\n1. Gross verified savings \n2. as verified by the Technical Reviewer\n3. and based on Projects placed into service\n4. in the contract year"]
["Kyle Ohearn",null,"1. What will be the ‘gross savings’ for incented projects:  \na. QR reported data on incented projects? \nb. or Approved Post Project data as approved by the LDC ?\nc. or submitted Post Project data?\nd. Other?"]
["Kyle Ohearn",null,"2.  It is uncertain if the Technical Reviewer (TR) will have access to CDM-IS, so how does the TR confirm QR reported savings, in-service dates and other project details if they do not have access to application information?\na. Can the TR have the LDC confirm the incented gross savings and if so how is it documented?\nb. Does the EM submit the post project application documents to the TR for each project?\nc. Do we apply cost effective thresholds such as Post Project savings over XXX kWh only require LDC confirmation, and post project savings with less than XXX kWh QR reporting is suffice. \n"]
["Kyle Ohearn",null,"3. What happens if a large custom project requires a year of M&V before it is approved for final payment, does the TR wait for a whole year for the M&V results? \n4. What happens if projects in service dates happen just past the end of a contract year?\n5. How does the TR collaborate with LDCs to confirm gross savings?\n6. How does the LDC document their confirmation of the incented project gross savings?\n7. Are discounted project evaluated savings for custom projects considered gross savings?"]
["Kyle Ohearn",null,"2.1.2 Performance Based Incentive \nThe Performance Based Participant Incentive amount is $40 per MWh of delivered electricity savings to a maximum incentive of $150,000 (CAD) per 12-month period. The minimum electricity savings (“Annual Savings Target”) required to be eligible for the Performance Based Incentive is 1000 MWh annually. The achievement of the Annual Savings Target is measured based on gross verified savings as verified by the Technical Reviewer and based on projects placed into service in the contract year, and of which at least 10% of the Annual Savings Target must be attributable to new projects not receiving any incentives from the IESO or the LDC or the Province of Ontario or the Government of Canada. \nWhere a Participant fails to achieve their Annual Savings Target in any given year, the LDC shall have full discretion not to extend the Participant Agreement for a subsequent year, terminate a multi-year contract, or to revise the Annual Savings Target specified in the Participant Agreement."]
["Kyle Ohearn",null,"Here is what I am using.  Same as the Provincial PA with a small 60 day requirement added to 5 (C ).\n\nI would have thought that CLEAResults Annual Review Report would be used to verify the savings and LDCs would spot check in the field.  I do agree that we need to firm up this requirement and process for both CR and LDCs.  \n"]
["CLEAResult",null,"1)      Clarify the meaning of Verified Annual Electricity Savings (currently in the PAs… “the electricity savings verified as in service in the agreement term and persisting until December 31, 2020 by the Technical Reviewer”)\na.       PSU capital projects  we recommend verified to mean savings results from the Q1 M&V Report\nb.      Retrofit  Post-project approval savings value \nc.       Non-incented  working on a review criteria document with IESO’s evaluation group. Do you (LDC EM working group) want to be actively involved or just kept in the loop? \n2)      CLEAResult’s role in verifying Retrofit savings"]
["CLEAResult",null,"a.       Currently we (CLEAResult) have no looking glass into iCon to reconcile Retrofit savings EMs claim vs what is actually approved in post-project"]
["Brian Baxter (HONE - Brampton)",null,null,"Energy tracking & monitoring – provide a database and an energy tracking and monitoring system for each facility /process that captures current monthly energy consumption and an electrical load inventory of major equipment. The Energy Manager will develop and deliver training to the Participant’s staff on the energy tracking and monitoring system.\n\nDoes this requirement preclude the participant from participating in the M&T program?"]
["Bill Whiting (Horizon)",null,null,"Regarding the Rules for the Energy Manager program, there was a proposal by IESO a few months ago to not allow projects that received gas utility incentives to be counted to a Non-Incented 10% savings target\n\nCan you clarify back to me, was that amendment accepted in the end or not, and thus, what is the current rule in this regard on eligibility of non-incented projects with gas incentives only?\n"]
["Kyle Ohearn",null,null,null,"My vendor management strategy is to strive for an approximate 50-50 split between the annual budgets assigned for OA and assigned for EM training & project work. If OA requests are too much to bear for our annual budget then we will reserve the right to decline OA’s as a defensive strategy to ensure we have lots of training and projects on the go.\n\nBTW, should funded EM’s use the OA service? CLEAResult have a convincing argument that OA’s identified project savings for funded EM’s have the highest success rate for implementation. Personally, I believe OA is part of their duties as per the Primary assessment clause in Appendix 1 section 2 \n"]
["Kyle Ohearn",null,null,null,"Could you help me understand what you mean by Application Review? What application are you referring to?\n\nI’m going to ask Geeth about the highlighted tasks in the table below. If not covered under the Technical Review contract then I’ll add to the RFP for EM Support Services.\n\nEM  Task Technical Review  EM Support Services\n·         Application Review on LDC request ?  \n·         Quarterly Report Review and Review Report ü  \n·         EMP review annually and Review Report ü  \n·         Hub support   ü\n·         Training support   ü\n·         Program trend data ?  \n·         Program evaluation data ?  \n·         Helpdesk   ü\n"]

{"sheet":"Definitions","index":2,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,0,6,0]]}
[]
[]
["Version 1.1"]
["Project Status"]
["Inactive:","Project has been canceled or abandoned."]
["Investigation Stage:","Project has been identified but has not yet been started. No binding commitment has not been made (i.e. Purchase Order not issued)."]
[]
["Underway:","Project has started and/or binding commitment has been made (ie. Purchase Order/Letter of Intent issued)."]
["Completed:","Project is in service. The Project has been installed, is operational and delivering electricity savings. Only savings associated with completed projects will contribute towards the Energy Manager's Annual Savings Target."]
[]
["Defined Terms/Abbreviations"]
["EM","Energy Manager",null,"For more program specific definitions, please review Section 8 of this document."]
["CFF","Conservation First Framework",null,"Information on MSC Energy Managers can be found here."]
["QR","Quarterly Report",null,"Information on IAP Energy Managers can be found here."]
["EMP","Energy Management Plan",null,"Information on NAICS can be found here."]
["SOE","Save on Energy"]
["IAP","Industrial Accelerator Program"]
["MSC","Multi-Site Customer"]
["CF","Collaboration Fund"]
["TR","Technical Reviewer"]
["NAICS","North American Industry Classification System"]
["CCHP","Conservation Combined Heat and Power"]
["WER","Waste Energy Recovery"]
[]
["Example of a Quarterly Report"]
["Incentive Type","Incentive Program","Project Title","Project Description","Additional Comments","Measure Term","Application Number","Project Cost","Capital Incentive","Estimated Peak Demand Savings (kW)","Estimated Electricity Savings (MWh)","Estimated Completion Date","Actual Peak Demand Savings (kW)","Actual Electricity Savings (MWh)","Project Payback (Yr)","In Service Date","Project Status","Measure Type","Technology"]
["Incented","Retrofit - Prescriptive","Cooling System VFD Upgrade","The cooling system operates continuously, 8,760 hours per year, and is comprised of 4 x 100 hp pumps, using on/off control. Investigation identified excess system cooling capacity. The project involves installation of VFDs to provide speed control for the cooling pump motors. The VFD control capability will enable the cooling system to operate more efficiently by balancing the system’s cooling capacity with cooling load to avoid excess cooling capacity.","VFD project began in early 2013 and was put on hold temporarilly. Project resumed near the end of 2013 and was completed by the end of February 2014.",1,987654,500000,10000,50,450,"2014-03-01",null,430,2,"2015-03-01","Completed","Upgrade","HVAC"]
["Non-Incented","Non-Incented","ABC Facility AC shutdown","Through site assessments it was discovered that many units serving the office building have been set to run 24/7 non stop. A control system will be implemented to shut down the AC in the off hours and control the operation during the cooling days.","Building A: Has begun installing thermostats to control the AC operation based on outdoor temperature",2,null,null,null,0,550,"2016-03-02",null,550,null,"2016-03-02","Completed","Conservation","Behavioural"]
["Non-Incented","Non-Incented","Project 12345","A sample investigation was conducted on the compressed air system and it was discovered that there were significant amount of air leaks in the system. Therefore, comressed air leak audit will be conducted throughout the entire building. Leak repairs will occur simultaneously with the audit. ","Building B: Contractors will be hired by the end of the year and will conduct audit. Leaks are scheduled to be repaired during the plant shutdown period.",2,null,10000,null,60,500,"2016-03-31",null,null,2,null,"Underway","O&M and Behavioural","Pumps"]
["Incented","Process and Systems - SCP","Co generation project at XYZ facility","There exists a sufficient base load thermal demand to support a load displacement cogeneration system between 1 MW to 1.5 MW. Based on the results from a feasibility study, it was determined that the implementation of 1 MW internal Combustion Engine is the most cost effective solution. ","Detail engineering study completed and proceeding with the project.",2,null,2000000,1000000,570,3500,"2017-07-31",null,null,3,null,"Investigation Stage","Upgrade","Gen-Non NG"]
["Non-Incented","Non-Incented","Lighting Overhaul at XYZ facility","The interior lighting in this building was primarily provided by linear fluorescent fixtures (offices, hallways, etc.) as well as incandescent and halogen. The lamps are being replaced with LED.","Decided not to pursue this project due to very low return on investment.",2,null,null,null,null,null,null,null,null,null,null,"Inactive","Upgrade","Lighting"]
["Incented","Retrofit - Custom","Electric Motor Consumption Reduction at XYZ facility","The facility houses over 100 motors, ranging from 1 HP to 450 HP in capacity with a cumulative capacity exceeding 3,000 HP. DES applied to investigate the feasibility of the installation of VFDs and ultra-high efficiency motors.","This pipeline project went through PSUI detailed engineering study and is expected to proceed to Project phase",3,null,170000,40000,320,280,"2017-03-31",null,null,null,null,"Investigation Stage","Optimization","Motors (other)"]

{"sheet":"General Input","index":3,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[11,0,11,4],[37,0,37,4],[11,8,11,9],[38,0,38,5],[10,6,10,9],[22,6,22,9],[23,6,23,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[21,6,21,9],[17,8,17,9],[16,8,16,9],[10,0,10,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[16,2,16,4],[17,2,17,4],[21,0,21,4],[24,6,25,9],[25,2,25,4],[28,2,28,4],[34,2,34,4],[35,2,35,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[27,0,27,4]]}
[]
[]
["This tab is designed to collect information that is used throughout the workbook to avoid data entry repetition. "]
["All information is treated as confidential. "]
[]
[]
[]
[]
[]
[]
["GENERAL INFORMATION",null,null,null,null,null,"DELIVERABLE MILESTONES"]
["Energy Manager Information",null,null,null,null,null,"Term:",null,{"$f":"CEILING(CEILING((TODAY()-'General Input'!$C$19)/365*12/3,1)*3/12,1)","v":1}]
["Name:",null,"John Smith",null,null,null,"Quarterly Report:"]
["Phone Number:",null,"416-658-8712",null,null,null,"Q1",null,{"$f":"DATE(YEAR('General Input'!$C$19)+$I$12-1,MONTH($C$19)+3,DAY('General Input'!$C$19))","v":"2016-04-01"}]
["Email Address:",null,"john.smith@company.com",null,null,null,"Q2",null,{"$f":"DATE(YEAR('General Input'!$C$19)+$I$12-1,MONTH($C$19)+6,DAY('General Input'!$C$19))","v":"2016-07-01"}]
["Program Type:",null,"SOE",null,null,null,"Q3",null,{"$f":"DATE(YEAR('General Input'!$C$19)+$I$12-1,MONTH($C$19)+9,DAY('General Input'!$C$19))","v":"2016-10-01"}]
["Contract Type:",null,"Performance Based",null,null,null,"Q4",null,{"$f":"DATE(YEAR('General Input'!$C$19)+$I$12,MONTH($C$19),DAY('General Input'!$C$19))","v":"2017-01-01"}]
["Contract Length (years):",null,null,null,null,null,"EMP Due Date:",null,{"$f":"IF($I$12=1,'General Input'!$C$19+6/12*365,'General Input'!$C$19+($I$12+1)*365)","v":"2016-07-01T12:00:00"}]
["Contract Start Date:",null,"2016-01-01"]
["Employment Start Date:",null,"2016-01-01"]
[]
["Lead Utility Contact Information",null,null,null,null,null,"Tips to get you started"]
["Utility Name:",null,null,null,null,null,"1) Click on Table Headers to open tool tips on how to complete each section."]
["Utility Representative Name:",null,"Joanna Smith ",null,null,null,"2) EM Hub - contact your Utility or Technical Reviewer to get access"]
["Utility Representative Email:",null,"Joanna.Smith@utility.com",null,null,null,"3) If you have completed the EMP, you can press the 'Export Reports' button to export in a PDF format."]
["Utility Rep. Phone Number:"]
[]
["Host Organization/Facility Information",null,null,null,null,null,"General Input'!A1",null,"General Input'!I29"]
["Name:",null,"XYZ Industries Inc."]
["Address:"]
["Postal Code:"]
["City:"]
["Contact Name:"]
["Phone Number:"]
["Email:"]
["Sector:"]
[]
["For Energy Managers with multiple Organizations and/or Facilties"]
["Facility/Facilities Information"]
["Organization","Facility Name","Facility Address","Postal Code","City","Utility"]
["Organization 1","Facility 1","123 Avenue",123456]
["Organization 1","Facility 2","456 Street",789123]

{"sheet":"Checklist","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,0,2,4],[7,6,7,9],[8,6,8,9],[2,6,2,9],[3,6,4,9],[6,6,6,9],[5,6,5,9]]}
["Definitions","General Input","Checklist","EMP","QR","Utility Data","EM Dashboard","Executive Summary"]
[]
["Energy Manager Checklist",null,null,null,null,null,"Tips"]
[null,null,null,null,null,null,"1) You are required to complete the CEM course by the end of your first term, unless you are already a CEM."]
[null,"I have completed the Certified Energy Manager (CEM) course in my first term"]
[null,{"$f":"\"Your first term end date is: \"&TEXT(DATE(YEAR('General Input'!$C$19)+1,MONTH('General Input'!$C$19),DAY('General Input'!$C$19)),\"mm/dd/yyyy\")","v":"Your first term end date is: 01/01/2017"},null,null,null,null,"CIET CEM Course Information"]
[null,null,null,null,null,null,"IESO's CEM Course Funding Info"]
[null,"I am a CEM or Energy Manager in Training (EMIT)"]
[null,null,null,null,null,null,"2) Continuing Training"]
[null,"I have attended the following Continuing Training activities this term",null,null,null,null,"- Attend your EM Regional Meeetings "]
[null,null,null,null,null,null,"- Consider courses required to retain your accreditations (e.g. CEM)"]
[null,"Training","Provided By ","Completed Date",null,null,"- Consider training offered by IESO and/or your utility"]
[null,null,null,null,null,null,"- Don’t forget about sales skills training!"]
[null,null,null,null,null,null,"IESO Training Incentives Information"]

{"sheet":"Host Organization Goals","index":5,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":true,"merged":[[20,8,21,10],[17,8,18,10],[12,8,13,10],[2,0,2,6],[3,8,3,10],[4,8,5,10],[7,8,8,10],[9,8,10,10],[11,8,11,10],[16,1,16,5]]}
[]
[]
["Host Organization Details & Goals"]
[null,null,null,null,null,null,null,null,"Tips"]
["Provide your Organization's/Facility's Annual Electricity Consumption & Savings Targets",null,null,null,null,null,null,null,"1) Obtain your Facility/Facilities Electricity Consumption Data"]
[]
[null,"Annual Electricity Consumption","Annual Electricity Billing (all-in)","Billing Peak Demand (kW)","Annual Savings Target (%)","Annual Electricity Savings Target (MWh)","Annual Utility Bill Savings Target ($)",null,"Host Organization Goals'!I7"]
[{"$f":"A9-1","v":2014},2000,220000,100,null,null,null,null,"Use the Utility Data Tab to store and analyze your interval electricity consumption data"]
[{"$f":"A10-1","v":2015},7000,770000,250]
[{"$f":"YEAR('General Input'!$C$19)","v":2016},null,null,null,0.05,350,{"$f":"IFERROR(F10*$K$15,\"\")","v":38500},null,"Determine the metering & supply points that capture electrical use at your facility/facilities.\nObtain interval consumption data from your utility and import it into the Utility Data tab."]
[{"$f":"A10+1","v":2017},null,null,null,null,null,{"$f":"IFERROR(F11*$K$15,\"\")","v":0}]
[{"$f":"A11+1","v":2018},null,null,null,null,null,0,null,"Plot and analyze your electricity consumption data."]
[{"$f":"A12+1","v":2019},null,null,null,null,null,0,null,"If interval data is not available, obtain monthly consumption data from your utility bills."]
[{"$f":"A13+1","v":2020},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Your average electricity cost per MWh is:",null,{"$f":"IFERROR(VLOOKUP(YEAR(TODAY())-1,$A$8:$C$14,3)/VLOOKUP(YEAR(TODAY())-1,$A$8:$C$14,2),\"\")","v":110}]
["For multiple facilities, provide the savings target for each facility (Optional)"]
[null,"Target Savings (MWh)"]
["Facility Name","2016","2017","2018","2019","2020",null,null,"This average electricity cost is used to calculate Annual Savings in dollars per project in your Quarterly Report."]
["Facility 1",2000,2000,2000,2000,2000]
["Facility 1"]
["Facility 1",null,null,null,null,null,null,null,"Click on the table header to read about how to add/remove rows."]

{"sheet":"Budget","index":6,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":true,"merged":[[19,0,19,1],[20,0,20,1],[21,0,21,1],[11,8,12,10],[17,8,18,10],[17,0,17,1],[18,0,18,1],[2,0,2,6],[3,8,3,10],[5,8,6,10],[15,8,16,10],[7,8,10,10]]}
[]
[]
["Organization Budget"]
[null,null,null,null,null,null,null,null,"Tips"]
["Determine your Organization's Annual CAPEX and Operating & Maintenance Budgets",null,null,null,null,null,null,null,"2) Energy Efficiency Budgets"]
[null,null,null,null,null,null,null,null,"Discussing with management the potential for an annual budget for energy efficiency projects. Leverage your Energy Policy, if one exists."]
[null,"Annual CAPEX Budget ($)","Annual O&M  Budget ($)","Other Budget ($)"]
[{"$f":"A9-1","v":2014},null,null,null,null,null,null,null,"If you are in a Performance Based Contract, consider discussing with management the potential for investing generated revenue from your annual over-performance into future terms' efficiency projects.  "]
[{"$f":"A10-1","v":2015}]
[{"$f":"YEAR('General Input'!$C$19)","v":2016}]
[{"$f":"A10+1","v":2017}]
[{"$f":"A11+1","v":2018},null,null,null,null,null,null,null,"If your organization operates commercial properties, consider lookng into Capital Reserve accounts. "]
[{"$f":"A12+1","v":2019}]
[{"$f":"A13+1","v":2020}]
[null,null,null,null,null,null,null,null,"3) Consider your budget cycle in project planning"]
["Determine your Organization's Project Budget Cycle",null,null,null,null,null,null,null,"Ensure that your projects are proposed in advance or early in the budget cycle."]
[]
["Start Budget Planning Date:",null,null,null,null,null,null,null,"Do not leave money on the table by not being aware of left-over budget."]
["Submit Budget Date:"]
["Budget Approval Date:"]
["Budget Cycle End Date:"]
["Budget Reconciliation Due Date:"]

{"sheet":"Goals","index":7,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":true,"merged":[[10,0,10,1],[10,8,10,9],[2,0,2,6],[3,8,3,10],[4,8,5,10],[6,0,6,1],[6,8,6,10],[7,0,7,1],[7,8,7,9],[8,0,8,1],[8,8,8,9],[9,0,9,1],[9,8,9,9],[16,0,16,1],[23,8,24,10],[17,0,17,1],[11,0,11,1],[14,8,14,9],[12,0,12,1],[13,0,13,1],[20,8,22,10],[15,0,15,1],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[11,8,11,9],[12,8,12,9]]}
[]
[]
["Energy Manager Goals & Results"]
[null,null,null,null,null,null,null,null,"Tips"]
["Provide your Annual Savings Target",null,null,null,null,null,null,null,"4) Know your organization's hurdle rates and financial metrics used to evaluate Energy Efficiency Projects"]
[]
["EM Term",null,1,2,3,4,5,null,"If available, provide the information in the table below."]
["Term End Date",null,{"$f":"DATE(YEAR('General Input'!$C$19)+C$7,MONTH('General Input'!$C$19),DAY('General Input'!$C$19)-1)","v":"2016-12-31"},{"$f":"DATE(YEAR('General Input'!$C$19)+D$7,MONTH('General Input'!$C$19),DAY('General Input'!$C$19)-1)","v":"2017-12-31"},{"$f":"DATE(YEAR('General Input'!$C$19)+E$7,MONTH('General Input'!$C$19),DAY('General Input'!$C$19)-1)","v":"2018-12-31"},{"$f":"DATE(YEAR('General Input'!$C$19)+F$7,MONTH('General Input'!$C$19),DAY('General Input'!$C$19)-1)","v":"2019-12-31"},{"$f":"DATE(YEAR('General Input'!$C$19)+G$7,MONTH('General Input'!$C$19),DAY('General Input'!$C$19)-1)","v":"2020-12-31"},null,"Cost of Capital/Hurdle Rate",null,0.12]
["Annual Savings Target",null,2000,2000,2000,2000,2000,null,"IRR",null,{"$f":"ExecSummaryCalculation!$G$44","v":"N/A"}]
["Non-Incented Target",null,{"$f":"C9*0.1","v":200},{"$f":"D9*0.1","v":200},{"$f":"E9*0.1","v":200},{"$f":"F9*0.1","v":200},{"$f":"G9*0.1","v":200},null,"MIRR",null,{"$f":"ExecSummaryCalculation!$G$43","v":"N/A"}]
["Organization Target",null,{"$f":"VLOOKUP(YEAR(C$8),'Host Organization Goals'!$A$8:$F$14,6,FALSE)","v":350},{"$f":"VLOOKUP(YEAR(D$8),'Host Organization Goals'!$A$8:$F$14,6,FALSE)","v":0},{"$f":"VLOOKUP(YEAR(E$8),'Host Organization Goals'!$A$8:$F$14,6,FALSE)","v":0},{"$f":"VLOOKUP(YEAR(F$8),'Host Organization Goals'!$A$8:$F$14,6,FALSE)","v":0},{"$f":"VLOOKUP(YEAR(G$8),'Host Organization Goals'!$A$8:$F$14,6,FALSE)","v":0},null,"Simple Payback",null,{"$f":"ExecSummaryCalculation!I40","v":""}]
["EM vs. Organization Target",null,{"$f":"IFERROR(C9/C11,\"\")","v":5.7142857142857144},{"$f":"IFERROR(D9/D11,\"\")","v":""},{"$f":"IFERROR(E9/E11,\"\")","v":""},{"$f":"IFERROR(F9/F11,\"\")","v":""},{"$f":"IFERROR(G9/G11,\"\")","v":""},null,"Adjusted Payback",null,{"$f":"ExecSummaryCalculation!I41","v":""}]
["Gross Verified Savings achieved",null,{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],C$7)","v":0},{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],D$7)","v":0},{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],E$7)","v":0},{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],F$7)","v":0},{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],G$7)","v":0},null,"Return on Investment (%)",null,{"$f":"ExecSummaryCalculation!$G$41","v":""}]
["% of Annual Savings Target Achieved",null,{"$f":"IFERROR(C13/C9,\"\")","v":0},{"$f":"IFERROR(D13/D9,\"\")","v":0},{"$f":"IFERROR(E13/E9,\"\")","v":0},{"$f":"IFERROR(F13/F9,\"\")","v":0},{"$f":"IFERROR(G13/G9,\"\")","v":0},null,"Net Present Value (NPV)"]
[null,null,null,null,null,null,null,null,"NPV Project Term (years)",null,10]
["Cumulative Target",null,{"$f":"C9","v":2000},{"$f":"C16+D9","v":4000},{"$f":"D16+E9","v":6000},{"$f":"E16+F9","v":8000},{"$f":"F16+G9","v":10000},null,"NPV Inflation %",null,0.05]
["Cumulative Savings (MWh)",null,{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],\"<=\"&C$7)","v":0},{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],\"<=\"&D$7)","v":0},{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],\"<=\"&E$7)","v":0},{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],\"<=\"&F$7)","v":0},{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Project Status],\"Completed\",QRTable[Measure Term],\"<=\"&G$7)","v":0},null,"NPV Interest Rate",null,0.05]
["Cumulative Savings ($)",null,{"$f":"C17*'Host Organization Goals'!$K$15","v":0},{"$f":"D17*'Host Organization Goals'!$K$15","v":0},{"$f":"E17*'Host Organization Goals'!$K$15","v":0},{"$f":"F17*'Host Organization Goals'!$K$15","v":0},{"$f":"G17*'Host Organization Goals'!$K$15","v":0},null,"MIRR Finance Rate (%)",null,0.1]
[null,null,null,null,null,null,null,null,"MIRR Interest Rate (%)",null,0.1]
[]
[null,null,null,null,null,null,null,null,"The above financial metrics will be used to populate the Executive Summary report, which can be used to present to the management/executive sponsors."]

{"sheet":"Decision Makers","index":8,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[[2,0,2,6],[3,8,3,10]]}
[]
[]
["Decision Makers"]
[null,null,null,null,null,null,null,null,"Tips"]
["Determine the Project Decision-makers at your Organization?"]
["Capital Projects"]
["Facility Name","Name","Title","Role","Email","Phone Number"]
["Facility 1"]
["Facility 1"]
["Facility 2"]
["Facility 3"]
[]
[]
[]
[]
["O&M Projects"]
["Facility Name","Name","Title","Role","Email","Phone Number"]
["Facility 1"]
["Facility 1"]
["Facility 2"]
["Facility 3"]

{"sheet":"System","index":9,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":true,"merged":[[13,16,14,18],[7,16,8,18],[15,16,15,18],[2,0,2,14],[2,16,2,18],[4,16,6,18],[9,16,10,18],[11,16,12,18]]}
[]
[]
["Identify Major Energy Users/Systems at your Facility/Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tips"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6) Identifying Large Energy Users"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Identify largest energy use systems/equipment by consulting your equipment/motor list or obtaining available sub-metered supporting data."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Using the inventory list of equipment and their operating schedules, you can estimate their total energy use."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If these large users are not sub-metered, consider installing power meters to track consumption of each."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact your utility provider to find out about the Monitoring and Targeting Program"]
["Electricity Consumption",null,null,null,"Gas Consumption",null,null,null,"Water Consumption",null,null,null,"Other"]
["System","Annual Consumption","% of Consumption",null,"System","Annual Consumption","% Consumption",null,"System","Annual Consumption","% Consumption",null,"System","Annual Consumption","% Consumption",null,"Consider applying for M&T through Retrofit Custom incentive program."]
["Compressed Air",25,{"$f":"LargestSystemElec322[[#This Row],[Annual Consumption]]/SUM(LargestSystemElec322[Annual Consumption])","v":0.25},null,"Furnace",30,{"$f":"LargestSystemGas[[#This Row],[Annual Consumption]]/SUM(LargestSystemGas[Annual Consumption])","v":0.3},null,"Process",70,{"$f":"LargestSystemWater[[#This Row],[Annual Consumption]]/SUM(LargestSystemWater[Annual Consumption])","v":0.7},null,"Furnace",30,{"$f":"LargestSystemOther[[#This Row],[Annual Consumption]]/SUM(LargestSystemOther[Annual Consumption])","v":0.3}]
["HVAC",20,{"$f":"LargestSystemElec322[[#This Row],[Annual Consumption]]/SUM(LargestSystemElec322[Annual Consumption])","v":0.2},null,"Boilers",30,{"$f":"LargestSystemGas[[#This Row],[Annual Consumption]]/SUM(LargestSystemGas[Annual Consumption])","v":0.3},null,"Process Cooling",20,{"$f":"LargestSystemWater[[#This Row],[Annual Consumption]]/SUM(LargestSystemWater[Annual Consumption])","v":0.2},null,"Boilers",30,{"$f":"LargestSystemOther[[#This Row],[Annual Consumption]]/SUM(LargestSystemOther[Annual Consumption])","v":0.3},null,"Plot available data and assess if there are any notable patterns with your largest users' energy consumption profile."]
["Lighting",10,{"$f":"LargestSystemElec322[[#This Row],[Annual Consumption]]/SUM(LargestSystemElec322[Annual Consumption])","v":0.1},null,"CHP",40,{"$f":"LargestSystemGas[[#This Row],[Annual Consumption]]/SUM(LargestSystemGas[Annual Consumption])","v":0.4},null,"Miscellaneous",10,{"$f":"LargestSystemWater[[#This Row],[Annual Consumption]]/SUM(LargestSystemWater[Annual Consumption])","v":0.1},null,"CHP",40,{"$f":"LargestSystemOther[[#This Row],[Annual Consumption]]/SUM(LargestSystemOther[Annual Consumption])","v":0.4}]
["Process Cooling",10,{"$f":"LargestSystemElec322[[#This Row],[Annual Consumption]]/SUM(LargestSystemElec322[Annual Consumption])","v":0.1}]
["Pumping",10,{"$f":"LargestSystemElec322[[#This Row],[Annual Consumption]]/SUM(LargestSystemElec322[Annual Consumption])","v":0.1}]
["Process",25,{"$f":"LargestSystemElec322[[#This Row],[Annual Consumption]]/SUM(LargestSystemElec322[Annual Consumption])","v":0.25}]

{"sheet":"Policies","index":10,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[[11,3,13,5],[14,3,15,5],[2,0,2,1],[3,3,3,5],[5,3,7,5],[8,3,10,5]]}
[]
[]
["Energy Policy"]
[null,null,null,"Tips"]
["Identify your Organisation's Energy Policy",null,null,"8) Creating an Energy Policy"]
[null,null,null,"If an Energy Policy does not exist at your organization, consider creating an Energy Policy with your Annual Savings Target as the goal."]
["Policy","Date"]
["XYZ Company Inc. is commited to reducting electricity use at the facility by 25% by 2020."]
["XYZ Company Inc. is commited…",null,null,"Obtain management support in developing an Energy Policy so you can leverage it in future energy efficiency project proposals."]
[]
[]
[null,null,null,"Consider proposing creation of procurement policies to management. If adopted, it may hasten subsequent procurement procedures for the particular equipment. "]
[]
[]
["Identify your Organization's Energy Efficiency Equipment Procurement Policy",null,null,"When building your business case, consider a life cycle analysis and additional benefits, not just simple pay back."]
[]
["Proposed Procurement Policy","System/Equipment",null,"Here is a sample of an energy policy statement"]
["T8 bulbs less than X Watts are replaced with Y Watt LED lamps manufactured by Z.","Lighting"]

{"sheet":"EM Team","index":11,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[[10,6,11,8],[2,0,2,4],[3,6,3,8],[5,6,5,8],[6,6,6,8],[7,6,8,8]]}
[]
[]
["Energy Management Team"]
[null,null,null,null,null,null,"Tips"]
["Identify or Create your Energy Management Team"]
["Position","Name","Role","Telephone Number","Email",null,"9) Create and Energy Team with an executive sponsor"]
["Executive Sponsor",null,null,null,null,null,"Identify the individuals suitable for your Energy Team."]
["Team Member #1",null,null,null,null,null,"Create a meeting agenda and schedule regular team meetings."]
["Team Member #2"]
["Team Member #3",null,null,null,null,null,"Read this article on the EM Hub on the value of the team"]
["Team Member #4",null,null,null,null,null,"Read this article on the EM Hub on how to engage an executive sponsor"]
["Team Member #5"]

{"sheet":"EMP","index":12,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[[8,1,8,4],[2,0,2,9],[8,6,8,9],[26,0,26,8],[9,2,9,3]]}
["Definitions","General Input","Checklist","EMP","QR","Utility Data","Dashboard","Executive Summary"]
[]
["Energy Management Plan (EMP)"]
[]
[]
[]
[]
[]
["Host Organization:",{"$f":"'General Input'!$C$29","v":"XYZ Industries Inc."},null,null,null,"EM Name: ",{"$f":"'General Input'!$C$13","v":"John Smith"}]
["Energy Management Plan Due Date:",null,{"$f":"'General Input'!$I$18","v":"2016-07-01T12:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Insert Company Logo"]
[]
[]
[]
[]
["Energy Management Plan"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Date:","2016-07-01"]
[null,"Prepared by:",{"$f":"'General Input'!$C$13","v":"John Smith"}]
[null,null,"Name 2"]
[null,null,"Name 3"]
[null,null,"Department"]
[]
[]
[null,null,{"$f":"'General Input'!$C$29","v":"XYZ Industries Inc."}]

{"sheet":"QR","index":13,"n_rows":9,"n_cols":39,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"'General Input'!$C$29","v":"XYZ Industries Inc."},null,null,null,{"$f":"'General Input'!$C$13","v":"John Smith"}]
["LDC Reviewed","Chart","Energy Manager Name","Type","NAICS","Sector","Project Participant","Facility Name","Utility","Measure Address","City","Measure Postal Code","Incentive Type","Incentive Program","Project Title","Project Description","Additional Comments","Measure Term","Application Number","Project Cost","Capital Incentive","Estimated Peak Demand Savings (kW)","Estimated Electricity Savings (MWh)","Estimated Completion Date","Actual Peak Demand Savings (kW)","Actual Electricity Savings (MWh)","Project Payback (Yr)","In Service Date","Project Status","Measure Type","Technology","Technical Reviewer Comments","Energy Manager Comments","Framework","Natural Gas Savings","Water Savings","Other Benefits ($)","Year of Completion","Annual $ Savings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(QRTable[[#This Row],[In Service Date]]=\"\",\"\",YEAR(QRTable[[#This Row],[In Service Date]]))","v":""},{"$f":"QRTable[[#This Row],[Estimated Electricity Savings (MWh)]]*'Host Organization Goals'!$K$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(QRTable[[#This Row],[In Service Date]]=\"\",\"\",YEAR(QRTable[[#This Row],[In Service Date]]))","v":""},{"$f":"QRTable[[#This Row],[Estimated Electricity Savings (MWh)]]*'Host Organization Goals'!$K$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(QRTable[[#This Row],[In Service Date]]=\"\",\"\",YEAR(QRTable[[#This Row],[In Service Date]]))","v":""},{"$f":"QRTable[[#This Row],[Estimated Electricity Savings (MWh)]]*'Host Organization Goals'!$K$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(QRTable[[#This Row],[In Service Date]]=\"\",\"\",YEAR(QRTable[[#This Row],[In Service Date]]))","v":""},{"$f":"QRTable[[#This Row],[Estimated Electricity Savings (MWh)]]*'Host Organization Goals'!$K$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(QRTable[[#This Row],[In Service Date]]=\"\",\"\",YEAR(QRTable[[#This Row],[In Service Date]]))","v":""},{"$f":"QRTable[[#This Row],[Estimated Electricity Savings (MWh)]]*'Host Organization Goals'!$K$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(QRTable[[#This Row],[In Service Date]]=\"\",\"\",YEAR(QRTable[[#This Row],[In Service Date]]))","v":""},{"$f":"QRTable[[#This Row],[Estimated Electricity Savings (MWh)]]*'Host Organization Goals'!$K$15","v":0}]

{"sheet":"Utility Data","index":14,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Electricity Consumption (\"&B21&\")\"","v":"Electricity Consumption (MWh)"},null,null,null,null,{"$f":"\"Gas Consumption (\"&G21&\")\"","v":"Gas Consumption (m3)"},null,null,null,{"$f":"\"Water Consumption (\"&K21&\")\"","v":"Water Consumption (Litre)"},null,null,{"$f":"\"Other Consumption (\"&N21&\")\"","v":"Other Consumption (Other)"}]
["Date","MWh","Billing Demand (kW)","Billing Amount ($)",null,"Date","m3","Billing Amount ($)",null,"Date","Litre",null,"Date","Other"]
["2014-11-01",1000,100,110000,null,"2014-11-01",500,null,null,"2016-01-01",1000,null,"2016-01-01",1000]
["2014-12-01",1000,100,110000,null,"2014-12-01",500,null,null,"2016-01-02",1000,null,"2016-01-02",1000]
["2015-01-01",2000,200,220000,null,"2015-01-01",500,null,null,"2016-01-03",1000,null,"2016-01-03",1000]
["2015-02-01",2500,250,275000,null,"2015-02-01",500,null,null,"2016-01-04",1000,null,"2016-01-04",1000]
["2015-03-01",2500,250,275000,null,"2015-03-01",500,null,null,"2016-01-05",1000,null,"2016-01-05",1000]

{"sheet":"Dashboard","index":15,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,2,15,3],[17,3,17,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Incentive Program","(All)"]
[null,null,"Show All",null,null,null,null,null,"Project Status","(All)"]
[null,null,{"$f":"IF($C$16=\"Show All\",\"*\",$C$16)","v":"*"},null,null,null,null,null,"Chart","Y",null,null,"Incentive Type","(All)"]
[null,null,null,"Total Electricity Savings (MWh)"]
[null,null,"Term","Completed","Underway","Investigation Stage","Target",null,"Technology","MWh Savings",null,null,"Sum of Estimated Electricity Savings (MWh)","Incentive Program"]
[null,null,1,{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Measure Term],Table16[Term],QRTable[Project Status],\"Completed\",QRTable[Incentive Type],$C$17,QRTable[Incentive Program],\"<>*ES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[Incentive Program],\"<>FIT*\")","v":0},{"$f":"SUMIFS(QRTable[Estimated Electricity Savings (MWh)],QRTable[Measure Term],Table16[Term],QRTable[Project Status],\"Underway\",QRTable[Incentive Type],$C$17,QRTable[Incentive Program],\"<>*ES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[Incentive Program],\"<>FIT*\")","v":0},{"$f":"SUMIFS(QRTable[Estimated Electricity Savings (MWh)],QRTable[Measure Term],Table16[Term],QRTable[Project Status],\"Investigation Stage\",QRTable[Incentive Type],$C$17,QRTable[Incentive Program],\"<>*ES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[Incentive Program],\"<>FIT*\")","v":0},{"$f":"IF($C$16=\"Non-Incented\",HLOOKUP(Table16[[#This Row],[Term]],Goals!$C$7:$G$10,4,FALSE),HLOOKUP(Table16[[#This Row],[Term]],Goals!$C$7:$G$10,3,FALSE))","v":2000},null,"Behavioural",550,null,null,"Measure Term","Non-Incented","Process and Systems - SCP","Retrofit - Custom","Retrofit - Prescriptive"]
[null,null,2,{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Measure Term],Table16[Term],QRTable[Project Status],\"Completed\",QRTable[Incentive Type],$C$17,QRTable[Incentive Program],\"<>*ES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[Incentive Program],\"<>FIT*\")","v":0},{"$f":"SUMIFS(QRTable[Estimated Electricity Savings (MWh)],QRTable[Measure Term],Table16[Term],QRTable[Project Status],\"Underway\",QRTable[Incentive Type],$C$17,QRTable[Incentive Program],\"<>*ES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[Incentive Program],\"<>FIT*\")","v":0},{"$f":"SUMIFS(QRTable[Estimated Electricity Savings (MWh)],QRTable[Measure Term],Table16[Term],QRTable[Project Status],\"Investigation Stage\",QRTable[Incentive Type],$C$17,QRTable[Incentive Program],\"<>*ES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[Incentive Program],\"<>FIT*\")","v":0},{"$f":"IF($C$16=\"Non-Incented\",HLOOKUP(Table16[[#This Row],[Term]],Goals!$C$7:$G$10,4,FALSE),HLOOKUP(Table16[[#This Row],[Term]],Goals!$C$7:$G$10,3,FALSE))","v":2000},null,"Gen-Non NG",3500,null,null,1,null,null,null,450]
[null,null,3,{"$f":"SUMIFS(QRTable[Actual Electricity Savings (MWh)],QRTable[Measure Term],Table16[Term],QRTable[Project Status],\"Completed\",QRTable[Incentive Type],$C$17,QRTable[Incentive Program],\"<>*ES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[Incentive Program],\"<>FIT*\")","v":0},{"$f":"SUMIFS(QRTable[Estimated Electricity Savings (MWh)],QRTable[Measure Term],Table16[Term],QRTable[Project Status],\"Underway\",QRTable[Incentive Type],$C$17,QRTable[Incentive Program],\"<>*ES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[Incentive Program],\"<>FIT*\")","v":0},{"$f":"SUMIFS(QRTable[Estimated Electricity Savings (MWh)],QRTable[Measure Term],Table16[Term],QRTable[Project Status],\"Investigation Stage\",QRTable[Incentive Type],$C$17,QRTable[Incentive Program],\"<>*ES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[Incentive Program],\"<>FIT*\")","v":0},{"$f":"IF($C$16=\"Non-Incented\",HLOOKUP(Table16[[#This Row],[Term]],Goals!$C$7:$G$10,4,FALSE),HLOOKUP(Table16[[#This Row],[Term]],Goals!$C$7:$G$10,3,FALSE))","v":2000},null,"HVAC",450,null,null,2,1050,3500]
[null,null,null,null,null,null,null,null,"Lighting",null,null,null,3,null,null,280]
[null,null,null,null,null,null,null,null,"Motors (other)",280,null,null,"Grand Total",1050,3500,280,450]
[null,null,null,null,null,null,null,null,"Pumps",500]
[null,null,null,null,null,null,null,null,"Grand Total",5280]

{"sheet":"Executive Summary","index":16,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[[40,8,41,9],[40,10,41,10],[42,10,43,10],[49,0,49,6],[44,0,44,1],[45,0,45,1],[46,0,46,1],[43,4,43,5],[44,4,44,5],[48,0,48,9],[45,2,45,3],[45,4,45,5],[46,4,46,5],[46,2,46,3],[42,8,43,9],[46,8,46,9],[44,8,45,9],[43,0,43,1],[43,2,43,3],[50,0,50,6],[44,2,44,3],[51,0,51,6],[52,0,52,6],[53,0,53,6],[54,0,54,6],[57,0,57,6],[64,0,64,10],[65,0,69,10],[58,0,58,6],[59,0,59,6],[60,0,60,6],[61,0,61,6],[62,0,62,6],[2,0,2,10],[3,0,3,5],[6,0,11,10],[5,0,5,10],[38,8,39,9],[38,10,39,10],[36,8,37,9],[36,10,37,10],[3,6,3,10],[12,1,12,2],[32,8,32,9],[35,8,35,9],[33,8,34,9],[33,10,34,10],[5,12,5,13],[6,12,6,13],[7,12,7,13],[9,12,9,13],[10,12,10,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Display Charts from",null,"Input Year"]
[]
["ENERGY MANAGER EXECUTIVE SUMMARY",null,null,null,null,null,null,null,null,null,null,null,"Input Year",null,2015]
[{"$f":"\"Organization: \"&'General Input'!$C$29","v":"Organization: XYZ Industries Inc."},null,null,null,null,null,{"$f":"\"Energy Manager: \"&'General Input'!$C$13","v":"Energy Manager: John Smith"},null,null,null,null,null,"Year",null,{"$f":"IF($O$1=\"EM Start Year\",YEAR('General Input'!$C$19),$O$3)","v":2015}]
[]
["Energy Management Highlights",null,null,null,null,null,null,null,null,null,null,null,"Display Equivalent Unit/Production",null,"Yes"]
["Provide 3 energy management talking points for senior management that highlight successes and would make for good messages to share with employees to increase awareness. Make sure your highlights are current, and include results with metrics where possible.\n(Please overwrite this message)",null,null,null,null,null,null,null,null,null,null,null,"Production Unit",null,"Units"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O7=\"Enter Unit\",\"Marginal Profit per …\",\"Marginal Profit per \"&O7)","v":"Marginal Profit per Units"},null,2500]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cost of Capital/Hurdle Rate",null,{"$f":"Goals!$K$8","v":0.12}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Years - Cash Flow",null,11]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Cost of Capital/Hurdle Rate",null,{"$f":"ExecSummaryCalculation!$I$44","v":0.12}]
[]
[null,null,null,null,null,null,null,null,"Return on Investment",null,{"$f":"ExecSummaryCalculation!$G$41","v":""}]
[null,null,null,null,null,null,null,null,"NPV - 10 Yrs",null,{"$f":"ExecSummaryCalculation!$G$40","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"MIRR with Incentive - \"&$O$11&\" Yr\"","v":"MIRR with Incentive - 11 Yr"},null,{"$f":"ExecSummaryCalculation!$G$43","v":"N/A"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"MIRR w/o Incentive - \"&$O$11&\" Yr\"","v":"MIRR w/o Incentive - 11 Yr"},null,{"$f":"ExecSummaryCalculation!$G$42","v":"N/A"}]
[]
[null,null,null,null,null,null,null,null,"Break-even year \nw/o Incentive Is:",null,{"$f":"ExecSummaryCalculation!$G$36","v":"N/A"}]
[]
[null,null,null,null,null,null,null,null,"Break-even year \nw/ Incentive Is:",null,{"$f":"ExecSummaryCalculation!$G$37","v":"N/A"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"YEAR(TODAY())&\" Facility Consumption\"","v":"2016 Facility Consumption"},null,{"$f":"INDEX('Host Organization Goals'!$B$8:$B$14,MATCH(YEAR(TODAY()),'Host Organization Goals'!$A$8:$A$14,0),1)","v":0}]
[]
["Top 5 Completed Projects with Largest Savings"]
[{"$f":"ExecSummaryCalculation!B48","v":"Project Title"},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C48","v":"MWh Savings"},{"$f":"ExecSummaryCalculation!D48","v":"Dollars Saved"},{"$f":"ExecSummaryCalculation!E48","v":"Project Cost"},{"$f":"ExecSummaryCalculation!F48","v":"Incentive"}]
[{"$f":"ExecSummaryCalculation!B49","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C49","v":""},{"$f":"ExecSummaryCalculation!D49","v":""},{"$f":"ExecSummaryCalculation!E49","v":""},{"$f":"ExecSummaryCalculation!F49","v":""}]
[{"$f":"ExecSummaryCalculation!B50","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C50","v":""},{"$f":"ExecSummaryCalculation!D50","v":""},{"$f":"ExecSummaryCalculation!E50","v":""},{"$f":"ExecSummaryCalculation!F50","v":""}]
[{"$f":"ExecSummaryCalculation!B51","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C51","v":""},{"$f":"ExecSummaryCalculation!D51","v":""},{"$f":"ExecSummaryCalculation!E51","v":""},{"$f":"ExecSummaryCalculation!F51","v":""}]
[{"$f":"ExecSummaryCalculation!B52","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C52","v":""},{"$f":"ExecSummaryCalculation!D52","v":""},{"$f":"ExecSummaryCalculation!E52","v":""},{"$f":"ExecSummaryCalculation!F52","v":""}]
[{"$f":"ExecSummaryCalculation!B53","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C53","v":""},{"$f":"ExecSummaryCalculation!D53","v":""},{"$f":"ExecSummaryCalculation!E53","v":""},{"$f":"ExecSummaryCalculation!F53","v":""}]
[]
["Top 5 Pipeline Projects with Largest Savings"]
[{"$f":"ExecSummaryCalculation!B56","v":"Project Title"},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C56","v":"MWh Savings"},{"$f":"ExecSummaryCalculation!D56","v":"Dollars Saved"},{"$f":"ExecSummaryCalculation!E56","v":"Project Cost"},{"$f":"ExecSummaryCalculation!F56","v":"Incentive"}]
[{"$f":"ExecSummaryCalculation!B57","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C57","v":""},{"$f":"ExecSummaryCalculation!D57","v":""},{"$f":"ExecSummaryCalculation!E57","v":""},{"$f":"ExecSummaryCalculation!F57","v":""}]
[{"$f":"ExecSummaryCalculation!B58","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C58","v":""},{"$f":"ExecSummaryCalculation!D58","v":""},{"$f":"ExecSummaryCalculation!E58","v":""},{"$f":"ExecSummaryCalculation!F58","v":""}]
[{"$f":"ExecSummaryCalculation!B59","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C59","v":""},{"$f":"ExecSummaryCalculation!D59","v":""},{"$f":"ExecSummaryCalculation!E59","v":""},{"$f":"ExecSummaryCalculation!F59","v":""}]
[{"$f":"ExecSummaryCalculation!B60","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C60","v":""},{"$f":"ExecSummaryCalculation!D60","v":""},{"$f":"ExecSummaryCalculation!E60","v":""},{"$f":"ExecSummaryCalculation!F60","v":""}]
[{"$f":"ExecSummaryCalculation!B61","v":""},null,null,null,null,null,null,{"$f":"ExecSummaryCalculation!C61","v":""},{"$f":"ExecSummaryCalculation!D61","v":""},{"$f":"ExecSummaryCalculation!E61","v":""},{"$f":"ExecSummaryCalculation!F61","v":""}]
[]
["Energy Manager Comments"]

{"sheet":"Baseline Model","index":17,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Placeholder. Phase 2 Item"]

{"sheet":"Project Business Case","index":18,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Placeholder. Phase 2 Item"]

{"sheet":"ExecSummaryCalculation","index":19,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["This sheet calculates metrics used to display the charts in the Executive Summary report. "]
[]
[]
["Term Savings vs Target Table (#N/A cells allow charts to dynamically display only the years wanted)"]
["Term","$ Savings","Internal Target","Expected Savings in $","$ Savings in Investigation","# Units Sold","Year","Index","Dummy Year"]
[{"$f":"IF(termsavtgttable[[#This Row],[Year]]>YEAR(TODAY()),NA(),termsavtgttable[[#This Row],[Year]]-YEAR('General Input'!$C$19)+1)","v":0},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[In Service Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":0},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIF('Host Organization Goals'!$A$8:$A$14,\"<=\"&termsavtgttable[Year],'Host Organization Goals'!$G$8:$G$14))","v":0},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Underway\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":0},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Investigation Stage\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":0},{"$f":"termsavtgttable[[#This Row],[$ Savings]]/'Executive Summary'!$O$8","v":0},{"$f":"IF('Host Organization Goals'!$A$8+termsavtgttable[[#This Row],[Index]]-1<=YEAR(TODAY()),'Executive Summary'!$O$4+termsavtgttable[[#This Row],[Index]]-1,NA())","v":2015},1,{"$f":"DATE(termsavtgttable[[#This Row],[Year]],12,31)","v":42369}]
[{"$f":"IF(termsavtgttable[[#This Row],[Year]]>YEAR(TODAY()),NA(),termsavtgttable[[#This Row],[Year]]-YEAR('General Input'!$C$19)+1)","v":1},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[In Service Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":0},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIF('Host Organization Goals'!$A$8:$A$14,\"<=\"&termsavtgttable[Year],'Host Organization Goals'!$G$8:$G$14))","v":38500},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Underway\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":0},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Investigation Stage\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":0},{"$f":"termsavtgttable[[#This Row],[$ Savings]]/'Executive Summary'!$O$8","v":0},{"$f":"IF('Host Organization Goals'!$A$8+termsavtgttable[[#This Row],[Index]]-1<=YEAR(TODAY()),'Executive Summary'!$O$4+termsavtgttable[[#This Row],[Index]]-1,NA())","v":2016},2,{"$f":"DATE(termsavtgttable[[#This Row],[Year]],12,31)","v":42735}]
[{"$f":"IF(termsavtgttable[[#This Row],[Year]]>YEAR(TODAY()),NA(),termsavtgttable[[#This Row],[Year]]-YEAR('General Input'!$C$19)+1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[In Service Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIF('Host Organization Goals'!$A$8:$A$14,\"<=\"&termsavtgttable[Year],'Host Organization Goals'!$G$8:$G$14))","v":false},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Underway\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Investigation Stage\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"termsavtgttable[[#This Row],[$ Savings]]/'Executive Summary'!$O$8","v":{"$error":"#N/A"}},{"$f":"IF('Host Organization Goals'!$A$8+termsavtgttable[[#This Row],[Index]]-1<=YEAR(TODAY()),'Executive Summary'!$O$4+termsavtgttable[[#This Row],[Index]]-1,NA())","v":2017},3,{"$f":"DATE(termsavtgttable[[#This Row],[Year]],12,31)","v":43100}]
[{"$f":"IF(termsavtgttable[[#This Row],[Year]]>YEAR(TODAY()),NA(),termsavtgttable[[#This Row],[Year]]-YEAR('General Input'!$C$19)+1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[In Service Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIF('Host Organization Goals'!$A$8:$A$14,\"<=\"&termsavtgttable[Year],'Host Organization Goals'!$G$8:$G$14))","v":false},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Underway\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Investigation Stage\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"termsavtgttable[[#This Row],[$ Savings]]/'Executive Summary'!$O$8","v":{"$error":"#N/A"}},{"$f":"IF('Host Organization Goals'!$A$8+termsavtgttable[[#This Row],[Index]]-1<=YEAR(TODAY()),'Executive Summary'!$O$4+termsavtgttable[[#This Row],[Index]]-1,NA())","v":{"$error":"#N/A"}},4,{"$f":"DATE(termsavtgttable[[#This Row],[Year]],12,31)","v":{"$error":"#N/A"}}]
[{"$f":"IF(termsavtgttable[[#This Row],[Year]]>YEAR(TODAY()),NA(),termsavtgttable[[#This Row],[Year]]-YEAR('General Input'!$C$19)+1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[In Service Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIF('Host Organization Goals'!$A$8:$A$14,\"<=\"&termsavtgttable[Year],'Host Organization Goals'!$G$8:$G$14))","v":false},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Underway\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Investigation Stage\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"termsavtgttable[[#This Row],[$ Savings]]/'Executive Summary'!$O$8","v":{"$error":"#N/A"}},{"$f":"IF('Host Organization Goals'!$A$8+termsavtgttable[[#This Row],[Index]]-1<=YEAR(TODAY()),'Executive Summary'!$O$4+termsavtgttable[[#This Row],[Index]]-1,NA())","v":{"$error":"#N/A"}},5,{"$f":"DATE(termsavtgttable[[#This Row],[Year]],12,31)","v":{"$error":"#N/A"}}]
[{"$f":"IF(termsavtgttable[[#This Row],[Year]]>YEAR(TODAY()),NA(),termsavtgttable[[#This Row],[Year]]-YEAR('General Input'!$C$19)+1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[In Service Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIF('Host Organization Goals'!$A$8:$A$14,\"<=\"&termsavtgttable[Year],'Host Organization Goals'!$G$8:$G$14))","v":false},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Underway\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Investigation Stage\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"termsavtgttable[[#This Row],[$ Savings]]/'Executive Summary'!$O$8","v":{"$error":"#N/A"}},{"$f":"IF('Host Organization Goals'!$A$8+termsavtgttable[[#This Row],[Index]]-1<=YEAR(TODAY()),'Executive Summary'!$O$4+termsavtgttable[[#This Row],[Index]]-1,NA())","v":{"$error":"#N/A"}},6,{"$f":"DATE(termsavtgttable[[#This Row],[Year]],12,31)","v":{"$error":"#N/A"}}]
[{"$f":"IF(termsavtgttable[[#This Row],[Year]]>YEAR(TODAY()),NA(),termsavtgttable[[#This Row],[Year]]-YEAR('General Input'!$C$19)+1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[In Service Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIF('Host Organization Goals'!$A$8:$A$14,\"<=\"&termsavtgttable[Year],'Host Organization Goals'!$G$8:$G$14))","v":false},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Underway\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Investigation Stage\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"termsavtgttable[[#This Row],[$ Savings]]/'Executive Summary'!$O$8","v":{"$error":"#N/A"}},{"$f":"IF('Host Organization Goals'!$A$8+termsavtgttable[[#This Row],[Index]]-1<=YEAR(TODAY()),'Executive Summary'!$O$4+termsavtgttable[[#This Row],[Index]]-1,NA())","v":{"$error":"#N/A"}},7,{"$f":"DATE(termsavtgttable[[#This Row],[Year]],12,31)","v":{"$error":"#N/A"}}]
[{"$f":"IF(termsavtgttable[[#This Row],[Year]]>YEAR(TODAY()),NA(),termsavtgttable[[#This Row],[Year]]-YEAR('General Input'!$C$19)+1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[In Service Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIF('Host Organization Goals'!$A$8:$A$14,\"<=\"&termsavtgttable[Year],'Host Organization Goals'!$G$8:$G$14))","v":false},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Underway\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Investigation Stage\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"termsavtgttable[[#This Row],[$ Savings]]/'Executive Summary'!$O$8","v":{"$error":"#N/A"}},{"$f":"IF('Host Organization Goals'!$A$8+termsavtgttable[[#This Row],[Index]]-1<=YEAR(TODAY()),'Executive Summary'!$O$4+termsavtgttable[[#This Row],[Index]]-1,NA())","v":{"$error":"#N/A"}},8,{"$f":"DATE(termsavtgttable[[#This Row],[Year]],12,31)","v":{"$error":"#N/A"}}]
[{"$f":"IF(termsavtgttable[[#This Row],[Year]]>YEAR(TODAY()),NA(),termsavtgttable[[#This Row],[Year]]-YEAR('General Input'!$C$19)+1)","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[In Service Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIF('Host Organization Goals'!$A$8:$A$14,\"<=\"&termsavtgttable[Year],'Host Organization Goals'!$G$8:$G$14))","v":false},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Underway\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(termsavtgttable[[#This Row],[Term]]),SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"=Investigation Stage\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&termsavtgttable[[#This Row],[Dummy Year]]),NA())","v":{"$error":"#N/A"}},{"$f":"termsavtgttable[[#This Row],[$ Savings]]/'Executive Summary'!$O$8","v":{"$error":"#N/A"}},{"$f":"IF('Host Organization Goals'!$A$8+termsavtgttable[[#This Row],[Index]]-1<=YEAR(TODAY()),'Executive Summary'!$O$4+termsavtgttable[[#This Row],[Index]]-1,NA())","v":{"$error":"#N/A"}},9,{"$f":"DATE(termsavtgttable[[#This Row],[Year]],12,31)","v":{"$error":"#N/A"}}]
[]
["Savings/Cost/Incentive Table"]
["Year","Scenario 1 Savings","Scenario 1 Project Cost","Net of Annual Savings and Costs","Net Saving Cost Incentive","Scenario 1 Incentive ","Return w/o Incentive","Return w/ Incentive","Display","Marker 1","Marker 2","Slope","Column1","w/o Incen A","B","C","D","Actual Mwh","Actual Cost/Incentive","Actual Return"]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A17+1)","v":2014},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(ISNUMBER(G17/1),B18+G17+C18,B18+C18)","v":0},{"$f":"IF(ISNUMBER(H17/1),B18+H17+C18+F18,B18+C18+F18)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2014},{"$f":"IF(AND(H18>0,H17<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H18)+ABS(H17))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H17)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G18>0,G17<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G18)+ABS(G17))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G17)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T17/1),R18+T17+S18,R18+S18))","v":0}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A18+1)","v":2015},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2015},{"$f":"IF(AND(H19>0,H18<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H19)+ABS(H18))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H18)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G19>0,G18<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G19)+ABS(G18))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G18)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T18/1),R19+T18+S19,R19+S19))","v":0}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A19+1)","v":2016},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2016},{"$f":"IF(AND(H20>0,H19<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H20)+ABS(H19))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H19)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G20>0,G19<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G20)+ABS(G19))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G19)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T19/1),R20+T19+S20,R20+S20))","v":0}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A20+1)","v":2017},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2017},{"$f":"IF(AND(H21>0,H20<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H21)+ABS(H20))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H20)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G21>0,G20<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G21)+ABS(G20))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G20)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T20/1),R21+T20+S21,R21+S21))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A21+1)","v":2018},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2018},{"$f":"IF(AND(H22>0,H21<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H22)+ABS(H21))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H21)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G22>0,G21<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G22)+ABS(G21))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G21)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T21/1),R22+T21+S22,R22+S22))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A22+1)","v":2019},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2019},{"$f":"IF(AND(H23>0,H22<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H23)+ABS(H22))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H22)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G23>0,G22<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G23)+ABS(G22))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G22)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T22/1),R23+T22+S23,R23+S23))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A23+1)","v":2020},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2020},{"$f":"IF(AND(H24>0,H23<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H24)+ABS(H23))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H23)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G24>0,G23<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G24)+ABS(G23))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G23)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T23/1),R24+T23+S24,R24+S24))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A24+1)","v":2021},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2021},{"$f":"IF(AND(H25>0,H24<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H25)+ABS(H24))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H24)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G25>0,G24<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G25)+ABS(G24))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G24)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T24/1),R25+T24+S25,R25+S25))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A25+1)","v":2022},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2022},{"$f":"IF(AND(H26>0,H25<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H26)+ABS(H25))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H25)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G26>0,G25<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G26)+ABS(G25))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G25)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T25/1),R26+T25+S26,R26+S26))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A26+1)","v":2023},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2023},{"$f":"IF(AND(H27>0,H26<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H27)+ABS(H26))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H26)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G27>0,G26<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G27)+ABS(G26))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G26)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T26/1),R27+T26+S27,R27+S27))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A27+1)","v":2024},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2024},{"$f":"IF(AND(H28>0,H27<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H28)+ABS(H27))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H27)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G28>0,G27<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G28)+ABS(G27))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G27)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T27/1),R28+T27+S28,R28+S28))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A28+1)","v":2025},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2025},{"$f":"IF(AND(H29>0,H28<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H29)+ABS(H28))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H28)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G29>0,G28<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G29)+ABS(G28))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G28)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T28/1),R29+T28+S29,R29+S29))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A29+1)","v":2026},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":2026},{"$f":"IF(AND(H30>0,H29<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H30)+ABS(H29))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H29)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G30>0,G29<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G30)+ABS(G29))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G29)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T29/1),R30+T29+S30,R30+S30))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A30+1)","v":2027},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},0,0,{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":{"$error":"#N/A"}},{"$f":"IF(AND(H31>0,H30<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H31)+ABS(H30))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H30)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G31>0,G30<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G31)+ABS(G30))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G30)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T30/1),R31+T30+S31,R31+S31))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A31+1)","v":2028},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(ISNUMBER(G31/1),B32+G31+C32,B32+C32)","v":0},{"$f":"IF(ISNUMBER(H31/1),B32+H31+C32+F32,B32+C32+F32)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":{"$error":"#N/A"}},{"$f":"IF(AND(H32>0,H31<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H32)+ABS(H31))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H31)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G32>0,G31<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G32)+ABS(G31))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G31)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T31/1),R32+T31+S32,R32+S32))","v":{"$error":"#N/A"}}]
[{"$f":"IF(ROW()=18,'Host Organization Goals'!$A$8,A32+1)","v":2029},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"<>Inactive\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]","v":0},{"$f":"cumulativetable[[#This Row],[Scenario 1 Project Cost]]+cumulativetable[[#This Row],[Scenario 1 Savings]]+cumulativetable[[#This Row],[Scenario 1 Incentive ]]","v":0},{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"<>Inactive\",QRTable[Estimated Completion Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31),QRTable[Estimated Completion Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(ISNUMBER(G32/1),B33+G32+C33,B33+C33)","v":0},{"$f":"IF(ISNUMBER(H32/1),B33+H32+C33+F33,B33+C33+F33)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>'Executive Summary'!$O$4+'Executive Summary'!$O$11,NA(),cumulativetable[[#This Row],[Year]])","v":{"$error":"#N/A"}},{"$f":"IF(AND(H33>0,H32<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 1]]=MAX(cumulativetable[Marker 1]),cumulativetable[[#This Row],[Marker 1]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,(ABS(H33)+ABS(H32))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[Marker 2]]<>0,ABS(H32)/cumulativetable[[#This Row],[Slope]],0)/10","v":0},{"$f":"IF(AND(G33>0,G32<0),cumulativetable[[#This Row],[Year]]-1,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[w/o Incen A]]=MAX(cumulativetable[w/o Incen A]),cumulativetable[[#This Row],[w/o Incen A]],0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,(ABS(G33)+ABS(G32))/12,0)","v":0},{"$f":"IF(cumulativetable[[#This Row],[B]]<>0,ABS(G32)/cumulativetable[[#This Row],[C]],0)/10","v":0},{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\",QRTable[Incentive Program],\"<>*PES\",QRTable[Incentive Program],\"<>*DES\",QRTable[Incentive Program],\"<>Audit*\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]]-1,12,31))","v":0},{"$f":"-SUMIFS(QRTable[Project Cost],QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]],1,1))+SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\",QRTable[In Service Date],\"<=\"&DATE(cumulativetable[[#This Row],[Year]],12,31),QRTable[In Service Date],\">=\"&DATE(cumulativetable[[#This Row],[Year]]-1,1,1))","v":0},{"$f":"IF(cumulativetable[[#This Row],[Year]]>YEAR(TODAY()),NA(),IF(ISNUMBER(T32/1),R33+T32+S33,R33+S33))","v":{"$error":"#N/A"}}]
[]
[]
[null,"Scenario 1: Only completed projects",null,null,"Return w/o Incentive is",{"$f":"SUM(cumulativetable[B],cumulativetable[D])","v":0},{"$f":"IF(ISERROR(TEXT(DATE(INT(F36),(INT((F36-INT(F36))*12)),1),\"mmmm, yyyy\")),\"N/A\",TEXT(DATE(INT(F36),(INT((F36-INT(F36))*12)),1),\"mmmm, yyyy\"))","v":"N/A"}]
[null,"Scenario 2: All projects except inactive",null,null,"Return w/ Incentive is",{"$f":"SUM(cumulativetable[Marker 2],cumulativetable[Column1])","v":0},{"$f":"IF(ISERROR(TEXT(DATE(INT(F37),(INT((F37-INT(F37))*12)),1),\"mmmm, yyyy\")),\"N/A\",TEXT(DATE(INT(F37),(INT((F37-INT(F37))*12)),1),\"mmmm, yyyy\"))","v":"N/A"}]
[null,"Average rate of return"]
[null,"Sum of Project Costs (Non-Incented)",{"$f":"SUMIFS(QRTable[Project Cost],QRTable[Incentive Type],\"Non-Incented\",QRTable[Project Status],\"Completed\")","v":0},"Sum of $ Saved (Non-Incented)",{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Incentive Type],\"Non-Incented\",QRTable[Project Status],\"Completed\")","v":0},null,null,"Non-Incented Simple Payback",{"$f":"IFERROR(C39/E39,\"\")","v":""}]
[null,"Sum of Project Costs (Total)",{"$f":"SUMIFS(QRTable[Project Cost],QRTable[Project Status],\"Completed\")","v":0},"Sum of $ Saved (Total)",{"$f":"SUMIFS(QRTable[Annual $ Savings],QRTable[Project Status],\"Completed\")","v":0},"NPV",{"$f":"NPV(Goals!$K$16*(1+Goals!$K$17),NPVRange)","v":0},"Total Simple Payback",{"$f":"IFERROR(C40/E40,\"\")","v":""}]
[null,"Sum of Incentive (Completed)",{"$f":"SUMIFS(QRTable[Capital Incentive],QRTable[Project Status],\"Completed\")","v":0},null,null,"ROI",{"$f":"IFERROR(H27/(-SUM(C18:C27)),\"\")","v":""},"Payback w/ Incentive",{"$f":"IFERROR((C40-C41)/E40,\"\")","v":""}]
[null,null,null,null,null,"MIRR w/o Incen for chosen yrs",{"$f":"IF(ISERROR(MIRR(MIRRNoIncenRange,Goals!$K$18,Goals!$K$19)),\"N/A\",MIRR(MIRRNoIncenRange,Goals!$K$18,Goals!$K$19))","v":"N/A"},"MIRR w/o Incen",{"$f":"IFERROR(MIRR(MIRRNoIncenRange,Goals!$K$18,Goals!$K$19),\"\")","v":""}]
[null,null,null,null,null,"MIRR w/ Incen for chosen yrs",{"$f":"IF(ISERROR(MIRR(MIRRIncenRange,Goals!$K$18,Goals!$K$19)),\"N/A\",MIRR(MIRRIncenRange,Goals!$K$18,Goals!$K$19))","v":"N/A"},"MIRR",{"$f":"IFERROR(MIRR(MIRRIncenRange,Goals!$K$18,Goals!$K$19),\"\")","v":""}]
[null,null,null,null,null,"IRR",{"$f":"IF(ISERROR(IRR(MIRRIncenRange)),\"N/A\",IRR(MIRRIncenRange))","v":"N/A"},"Target Interest rate",{"$f":"'Executive Summary'!$O$10","v":0.12}]
[null,"Year of Term 1 ",{"$f":"YEAR('General Input'!$C$19)","v":2016}]
[]
["Top 5 Largest Projects"]
[null,"Project Title","MWh Savings","Dollars Saved","Project Cost","Incentive","Status"]
[1,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A49),QRTable[Actual Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Actual Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A49),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A49),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A49),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A49),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A49),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]
[2,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A50),QRTable[Actual Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Actual Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A50),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A50),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A50),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A50),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A50),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]
[3,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A51),QRTable[Actual Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Actual Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A51),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A51),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A51),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A51),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A51),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]
[4,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A52),QRTable[Actual Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Actual Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A52),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A52),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A52),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A52),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A52),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]
[5,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A53),QRTable[Actual Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Actual Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Actual Electricity Savings (MWh)]),$A53),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A53),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A53),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A53),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]=\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A53),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]
[]
["Top 5 Largest Pipeline Projects"]
[null,"Project Title","MWh Savings","Dollars Saved","Project Cost","Incentive","Status"]
[1,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A57),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Estimated Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A57),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A57),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A57),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A57),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A57),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]
[2,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A58),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Estimated Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A58),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A58),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A58),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A58),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A58),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]
[3,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A59),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Estimated Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A59),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A59),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A59),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A59),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A59),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]
[4,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A60),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Estimated Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A60),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A60),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A60),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A60),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A60),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]
[5,{"$f":"IFERROR(INDEX(QRTable[Project Title],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A61),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Estimated Electricity Savings (MWh)],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A61),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Annual $ Savings],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A61),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Cost],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A61),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Capital Incentive],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A61),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(QRTable[Project Status],MATCH(LARGE(IF(QRTable[Project Status]<>\"Completed\",QRTable[Estimated Electricity Savings (MWh)]),$A61),QRTable[Estimated Electricity Savings (MWh)],0)),\"\")","v":""}]

{"sheet":"Non-Incented Template","index":20,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,1]]}
["Program Enabled Savings Claim Template – Project"]
["*Copy this table to columns to the right to expand"]
["Project Contact (name)","Insert name"]
["Project Location – Address","Insert address."]
["Phone No.","xxx-xxx-xxxx"]
["Email Address","name@company.com"]
["Describe the Project","Provide details on the proposed or implemented change in equipment or change in operating practice and why it is an energy efficiency improvement."]
["Details on the Baseline Condition","Provide details on the base case equipment or the base case operating practice."]
["Details on the Energy Efficient Condition","Provide details on the energy efficient equipment or energy efficient change in operating practice."]
["Annual kW Savings Estimate","kW"]
["Annual kWh Savings Estimate","kWh"]
["Expected Useful Life of the Energy Efficient Condition","years"]
["Estimate of Project Costs","$ xx.xx."]
["Project Completion Date","Click here to enter a date."]
["Operating Schedules","Describe the typical weekday, weekend, and holiday schedules.  A table will be sufficient."]
["Description of the Influence of saveONenergy had on the development and implementation of the project(s)","Describe the marketing, outreach, or any other energy management activity that had a direct influence on the initiation, approval and/or completion etc. of the project.  Be as detailed as possible.  Provide evidence of the influence. (Emails, logs, meeting minutes, audit reports, participant statements)"]
["Attach all supporting documentation (assumptions, calculations, meter data, M&V reports)"]

{"sheet":"DropDownLists","index":21,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Performance Based"]
["Salary Based",1,"Incented",null,null,null,null,1]
[null,2,"Non-Incented",null,"Completed",null,null,2]
["Single",3,null,null,"Underway",null,null,3]
["Multi-Site",4,null,null,"Investigation Stage",null,null,4]
[null,null,null,null,"Inactive"]
[]
[]
[]
[null,null,null,null,"Yes",null,null,null,null,"Non-Incented"]
["Upgrade","Behavioural",null,null,"No",null,null,null,null,"Demand Response"]
["Optimization","Compressed Air",null,null,null,null,null,null,null,"Retrofit Program"]
["Conservation","Demand Response",null,null,null,null,null,null,null,"Retrofit - Custom"]
["Controls","Electrochemical",null,null,null,null,null,null,null,"Retrofit - Engineered"]
["O&M and Behavioural","Fans/Blowers",null,null,null,null,null,null,null,"Retrofit - Prescriptive"]
["Other","CCHP",null,null,null,null,null,null,null,"Audit Funding"]
["Generation","WER",null,null,null,null,null,null,null,"High Performance New Construction"]
["Process or Building Re-Design","Renewable",null,null,null,null,null,null,null,"Existing Building Commissioning"]
[null,"HVAC",null,null,null,null,null,null,null,"Process and Systems - PES"]
[null,"Lighting",null,null,null,null,null,null,null,"Process and Systems - DES"]
[null,"Motors (other)",null,null,null,null,null,null,null,"Process and Systems - SCP"]
[null,"Other",null,null,null,null,null,null,null,"Process and Systems - Project"]
[null,"Process Cooling",null,null,null,null,null,null,null,"FIT/mFIT"]
[null,"Process Heating",null,null,null,null,null,null,null,"Monitoring & Targeting"]
[null,"Process Specific",null,null,null,null,null,null,null,"Other"]
[null,"Pumps"]

{"sheet":"Revision Note","index":22,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Rev","Note","Date"]
[0,"• Completion Date column has a conditional formatting with red font or background when:\no Completion date is past today yet status is Complete\no Completion date is prior to today’s date while the status is NOT Complete\no Completion date is earlier than EM start date\no MWh is greater than 10,000 MWh as a warning\no MWh or kW value is NOT a numeric value (i.e. actually typing in ‘500 MWh’ will flag it)\n• Guide comments per column changed to text box, such that it extends/shrinks with the column width. Prior to this, comment box remained in the same place regardless of what happened.\n• Changed the ‘Example’ columns to ‘Additional’ columns with added description ‘EMs may include, but will not be imported into the database’\n• Added ‘Retrofit – Program’ under Application Type column to prevent compatibility issues with old templates\n","2014-09-05"]
[0.1,"More conditional formatting added for 'Completed' status without a date\nID column added to keep track of projects\nRevision note tab added","2014-10-16"]
[0.2,"Technical Reviewer comment column added","2014-10-22"]
[1,"Revised the version date in the intro sheet","2014-10-31"]
[1.1000000000000001,"Revised a spelling error in the definition tab\nRevision Note tab hidden\nApplication Type 'Retrofit - Program' revised to 'Retrofit Program'","2014-11-07"]
[2,"Several changes over the year\n• Colour theme update\n• Executive Summary added\n• LDC name convention updated \n• Footer revised to reflect IESO\n• EM Employment Start date option added","2015-08-19"]

{"sheet":"LDCs","index":23,"n_rows":80,"n_cols":1,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
["LDCs"]
["Algoma Power Inc."]
["Atikokan Hydro Inc."]
["Attawapiskat First Nation"]
["Attawapiskat Power Corporation"]
["Bluewater Power Distribution Corporation"]
["Brantford Power Inc."]
["Burlington Hydro Inc."]
["Canadian Niagara Power Inc."]
["Centre Wellington Hydro Ltd."]
["Chapleau Public Utilities Corporation"]
["COLLUS PowerStream Corp."]
["Cooperative Hydro Embrun Inc."]
["Cornwall Street Railway Light and Power Company Limited"]
["Dubreuil Lumber Inc."]
["E.L.K. Energy Inc."]
["Energy+ Inc."]
["Enersource Hydro Mississauga Inc."]
["Entegrus Powerlines Inc."]
["EnWin Utilities Ltd."]
["Erie Thames Powerlines Corporation"]
["Espanola Regional Hydro Distribution Corporation"]
["Essex Powerlines Corporation"]
["Festival Hydro Inc."]
["Fort Albany First Nation"]
["Fort Albany Power Corporation"]
["Fort Frances Power Corporation"]
["Greater Sudbury Hydro Inc."]
["Grimsby Power Inc."]
["Guelph Hydro Electric Systems Inc."]
["Haldimand County Hydro Inc."]
["Halton Hills Hydro Inc."]
["Hearst Power Distribution Company Limited"]
["Horizon Utilities Corporation"]
["Hydro 2000 Inc."]
["Hydro Hawkesbury Inc."]
["Hydro One Brampton Networks Inc."]
["Hydro One Networks Inc."]
["Hydro Ottawa Limited"]
["IESO"]
["Innpower Corporation"]
["Kashechewan First Nation"]
["Kashechewan Power Corporation"]
["Kenora Hydro Electric Corporation Ltd."]
["Kingston Hydro Corporation"]
["Kitchener-Wilmot Hydro Inc."]
["Lakefront Utilities Inc."]
["Lakeland Power Distribution Ltd."]
["London Hydro Inc."]
["Midland Power Utility Corporation"]
["Milton Hydro Distribution Inc."]
["Newmarket-Tay Power Distribution Ltd."]
["Niagara Peninsula Energy Inc."]
["Niagara-on-the-Lake Hydro Inc."]
["North Bay Hydro Distribution Limited"]
["Northern Ontario Wires Inc."]
["Oakville Hydro Electricity Distribution Inc."]
["Orangeville Hydro Limited"]
["Orillia Power Distribution Corporation"]
["Oshawa PUC Networks Inc."]
["Ottawa River Power Corporation"]
["Peterborough Distribution Incorporated"]
["PowerStream Inc."]
["PUC Distribution Inc."]
["Renfrew Hydro Inc."]
["Rideau St. Lawrence Distribution Inc."]
["Sioux Lookout Hydro Inc."]
["St. Thomas Energy Inc."]
["Thunder Bay Hydro Electricity Distribution Inc."]
["Tillsonburg Hydro Inc."]
["Toronto Hydro-Electric System Limited"]
["Veridian Connections Inc."]
["Wasaga Distribution Inc."]
["Waterloo North Hydro Inc."]
["Welland Hydro-Electric System Corp."]
["Wellington North Power Inc."]
["West Coast Huron Energy Inc."]
["Westario Power Inc."]
["Whitby Hydro Electric Corporation"]
["Woodstock Hydro Services Inc."]

{"sheet":"Input Data","index":24,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[[0,0,0,10],[7,7,7,8],[5,1,6,1],[5,2,6,2],[9,7,9,8],[8,7,8,8],[7,4,8,4],[7,5,8,5],[5,7,5,8],[6,7,6,8],[1,0,2,10]]}
["ENERGY MANAGER EXECUTIVE SUMMARY INPUT FORM"]
["Disclaimer: Executive Summary results are based on information entered into the Quarterly Report and the Executive Summary input tab, and are subject to all limitations, assumptions, and qualifications contained herein. In addition, financial or other projections contained herein are based upon assumptions and entries made by the Energy Manager."]
[]
[null,"Input cells","Calculated values"]
[]
[null,"Blended Electricity Rate ($/MWh)",100,null,"Type of Facility Load:","Fixed",null,"Display Equivalent Unit/Production",null,"No"]
[null,null,null,null,"Annual Facility Load:",85000,null,"Production Unit",null,"Units"]
[null,"Display Charts from","Input Year",null,"Type of Internal Target: ","Custom Target",null,{"$f":"IF(J7=\"Enter Unit\",\"Marginal Profit per …\",\"Marginal Profit per \"&J7)","v":"Marginal Profit per Units"},null,2500]
[null,"Input Year",2015,null,null,null,null,"Opportunity Cost of Capital",null,0.12]
[null,"Year",{"$f":"IF($C$8=\"EM Start Year\",YEAR('General Input'!$C$19),$C$9)","v":2015},null,"% of Facility Load",2.5000000000000001E-2,null,"Number of Years - Cash Flow",null,10]
[]
[null,"Year","Facility Load (Fixed)","Facility Load (Manual Input)","Internal Target (% of Facility Load)","Custom Internal Target (MWh)","Custom Internal Target ($)","Internal Target","Term"]
[null,{"$f":"C10","v":2015},{"$f":"$F$7","v":85000},75000,{"$f":"IF($F$6=\"Fixed\",$F$10*$F$7*$C$6,D13*$F$10*$C$6)","v":212500},2000,{"$f":"F13*$C$6","v":200000},{"$f":"IF($F$8=\"Custom Target\",G13,E13)","v":200000},{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B13","v":0}]
[null,{"$f":"B13+1","v":2016},85000,80000,212500,1750,{"$f":"F14*$C$6","v":175000},175000,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B14","v":1}]
[null,{"$f":"B14+1","v":2017},85000,78000,212500,1750,175000,175000,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B15","v":2}]
[null,{"$f":"B15+1","v":2018},85000,76000,212500,1750,175000,175000,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B16","v":3}]
[null,2019,85000,74000,212500,1750,175000,175000,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B17","v":4}]
[null,2020,85000,0,212500,0,0,0,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B18","v":5}]
[null,2021,85000,0,212500,0,0,0,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B19","v":6}]
[null,2022,85000,0,212500,0,0,0,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B20","v":7}]
[null,2023,85000,0,212500,0,0,0,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B21","v":8}]
[null,2024,85000,0,212500,0,0,0,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B22","v":9}]
[null,{"$f":"B22+1","v":2025},85000,0,212500,0,0,0,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B23","v":10}]
[null,2026,85000,0,212500,0,0,0,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B24","v":11}]
[null,2027,85000,0,212500,0,0,0,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B25","v":12}]
[null,2028,85000,0,212500,0,0,0,{"$f":"1-YEAR('General Input'!$C$19)+'Input Data'!B26","v":13}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"\"Equivalent Production (\"&$J$7&\")\"","v":"Equivalent Production (Units)"}]

{"sheet":"Version Log","index":25,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Version","Changes","Date"]
[0.1,"Initial draft","2016-05-20"]
[0.2,"Review with the stakeholders. Restructuring of the blueprint","2016-05-24"]
[0.3,"Final blueprint draft before the Regional Meetings. Introduction page, EMP revisions, utility data tab revisions","2016-05-26"]
[0.4,"Revised overall structure of the document as per meeting with the stakeholders.\nChanges to the input tab into three different sections.\nAddition of EM Checklist\nTip panel in the EMP blueprint\nRemoval of action items","2016-05-30"]
["Beta",null,"2016-07-14"]
[1,"First official release. Feedback from beta testers implemented.","2016-08-02"]
[1.1000000000000001,"QR table's auto-population of Facility address information caused an error when multiple cells were copy/pasted. The code was revised to resolve this. Also, the feature did not enable events following the error. Event enabler was added.\nRevised Technology drop down column. Gen-NG -> CCHP, Gen-Non NG -> WER & Renewable.\nFramework column added to the QR.","2016-08-03"]