{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1. Introduction","2. Evaluation","3. Narrative","4. Contact Information","5. Project Information","6. Project Summary","Macros Not Enabled","7. Loan Agreement","Project Information Template","Formula"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Introduction","index":0,"n_rows":66,"n_cols":52,"rows_kept":66,"cut":false,"hidden":true,"merged":[[0,26,5,35]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WHAT IS THE ENERGY EFFICIENT SCHOOLS INITIATIVE LOAN PROGRAM?"]
[null,"The Energy Efficient Schools Initiative (EESI) was established by the Tennessee General Assembly in 2008 with $90 million. Almost $100 million has been "]
[null,"approved for projects to improve the energy  efficiency in Tennessee’s public K-12 schools. The purpose of the Energy Efficient Schools Council, also"]
[null,"created by this legislation, include providing grants and loans for capital outlay projects and establish and support energy management programs. The "]
[null,"enabling legislation also created a twelve member council to approve guidelines, award grants and loans, verify energy efficiencies, and establish and "]
[null,"support energy management programs. The Council appointed a Technical Advisory Committee (TAC) and an Executive Director to oversee EESI "]
[null,"activities."]
[]
[null,"ADDITIONAL LOAN INFORMATION"]
[null,"Repayment Term: The repayment schedule and term are determined by the estimated annual energy cost savings from the aggregated project(s), "]
[null,"using energy costs and operating schedules at the time of loan approval. As part of the application process, the applicant must provide cost benefit and"]
[null,"return on investment calculations to substantiate the estimated energy cost avoidance on an annual basis. The term of the loan may be determined by"]
[null,"dividing the total cost of the project by the annual estimated cost avoidance to get the number of years of the term and adding up to two addtional years "]
[null,"not to exceed 12 years."]
[null,"Loan repayment terms cannot exceed the useful life of the loan funded equipment. The loan repayment term should not exceed the time it takes to "]
[null,"recover project costs (plus interest) in energy savings. In some cases due to economic hardship, EESI may allow a slightly longer term, but such "]
[null,"exceptions will be determined by the EESI Council based upon a recommendation from the TAC. "]
[]
[null,"Adherence to Program Rules Statement: A copy of the EESI Loan Program Rules is made available with this application. These rules set forth "]
[null,"project parameters and reporting requirements. Please review these rules.  If you have any questions, please contact the EESI staff. Please have the "]
[null,"appropriate district officer sign the certification at the bottom of the rules statement and return a copy with your application."]
[]
[null,"ENERGY EFFICIENCY PROJECT ELIGIBILITY AND CRITERIA"]
[null,"Energy efficiency projects installed in K-12 schools must meet the following criteria to be considered eligible for the EESI loan:"]
[null,"• Project must be part of an existing school facility; new construction projects are not considered"]
[null,"• Projects must be technically and economically feasible as evaluated by the EESI Technical Committee"]
[null,"• The loan can fund 100% of the project cost within a 12 year (maximum) payback based on the estimated first year’s energy cost savings"]
[null,"• Projects already funded or completed are ineligible"]
[null,"• Projects must apply for energy efficiency incentive funding from the TVA EnergyRight Solutions program to determine if additional funds are available"]
[null,"  to help offset the project cost.  Click here to learn more about the program and apply!"]
[null,"• Energy Efficiency Conservation Measures (ECMs) must meet or exceed: ASHRAE 90.1-2010 or TVA EnergyRight® Solutions Program requirements "]
[null,"Examples of Qualified Projects Include:"]
[null,"• Interior and exterior lighting systems"]
[null,"• Heating, ventilation and air conditioning (HVAC) equipment (i.e. boilers, cooling towers, chillers, heat recovery systems, etc.)"]
[null,"• Energy management systems and equipment controls"]
[null,"• Pumps and Motors (i.e. variable frequency drives (VFDs))"]
[null,"• Retro-Commissioning "]
[null,"• Any other related engineering or design costs when initiated after the loan award"]
[]
[null,"WHEN CAN PROJECTS BEGIN?"]
[null,"Once a loan agreement is fully executed (i.e. signed by the authorized EESI Council member and loan applicant), and project plans and specifications "]
[null,"have been submitted and approved by TAC, a \"Notice to Proceed\" will be issued. Applicants will have 12 months from the date of the \"Notice to "]
[null,"Proceed\" to complete the project. Any construction period change orders issued in the project must have TAC approval to be allowed. Only approved "]
[null,"project-related costs with invoices dated within the term of the executed agreement are eligible for reimbursement under the loan. If the loan is not "]
[null,"approved and executed, the EESI is not responsible for reimbursement of any costs."]
[]
[null,"APPLICATION SUBMISSION INSTRUCTIONS"]
[null,"To get started, fill out sections 2, 3, 4 and 5. To access the sections, click the blue bar at the top of the page.  You will also need to submit background  "]
[null,"information, i.e., engineering calculations for savings, assumptions, metered data, power bills, etc..  Information about applying for incentives with TVA's "]
[null,"EnergyRight® Solutions for Business/Industry Program is above in the Energy Efficiency Project Eligibility and Criteria section.  The EELP cannot be  "]
[null,"used to reimburse projects already completed prior to the date of this application."]
[null,"Please submit completed applications to Paul Cross at paul.cross@tn.gov and copy Barbara Floyd at barbara.floyd@tn.gov."]
[null,"Submission of detailed calculations that show how the energy savings were derived is mandatory."]
[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,"v2.18 TRM 2018"]

{"sheet":"2. Evaluation","index":1,"n_rows":41,"n_cols":52,"rows_kept":41,"cut":false,"hidden":true,"merged":[[36,1,37,26],[36,27,37,32],[30,1,35,13],[30,27,35,32],[31,14,31,26],[32,14,32,26],[33,14,33,26],[34,14,34,26],[35,14,35,26],[19,1,24,13],[19,27,24,32],[20,14,20,26],[21,14,21,26],[22,14,22,26],[25,1,29,13],[25,27,29,32],[26,14,26,26],[27,14,27,26],[28,14,28,26],[12,1,12,32],[13,1,13,32],[15,1,16,32],[17,1,18,13],[17,14,18,26],[17,27,18,32]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"LOAN APPLICATION EVALUATION CRITERIA          "]
[null,"Loan applications will be scored and ranked based on the criteria shown in this matrix. Descriptions of each of criteria are provided below."]
[]
[null,"EESI Loan Program Application Evaluation Criteria"]
[]
[null,"Item ",null,null,null,null,null,null,null,null,null,null,null,null,"Evaluation Criteria",null,null,null,null,null,null,null,null,null,null,null,null,"Maximum Points"]
[]
[null,"Energy Conservation Measure (ECM) \nSimple Payback",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,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≤  5 year  -  40 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≤  8 year  -  20 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≤ 10 year  -  10 pts"]
[]
[]
[null,"School Energy Utilization Index Reduction",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,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 30% - 30 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 20% - 20 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 10% - 10 pts"]
[]
[null,"Financial Need",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,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1st Quartile - 30 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd Quartile - 15 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," 3rd Quartile -   0 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       4th Quartile -   0 pts     "]
[]
[null,"Total Points",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,100]
[]
[]
[]
[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,"v2.18 TRM 2018"]

{"sheet":"3. Narrative","index":2,"n_rows":41,"n_cols":52,"rows_kept":41,"cut":false,"hidden":true,"merged":[[12,1,14,34],[15,1,38,34]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please provide an executive summary of the projects you are applying for an Energy Efficient Schools Initiative loan below. When emailing this application, please also attach a detailed description of the energy efficiency upgrade(s), what steps will be taken to implement, and engineering calculations files for the energy 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,"v2.18 TRM 2018"]

{"sheet":"4. Contact Information","index":3,"n_rows":66,"n_cols":52,"rows_kept":66,"cut":false,"hidden":true,"merged":[[28,1,28,7],[29,1,29,11],[29,13,29,23],[29,25,29,34],[25,1,25,7],[26,1,26,11],[26,13,26,23],[26,25,26,34],[27,1,27,7],[27,9,27,15],[27,17,27,23],[27,25,27,31],[62,1,62,7],[63,1,63,11],[63,13,63,23],[63,25,63,34],[60,1,60,11],[60,13,60,23],[60,25,60,34],[61,1,61,7],[61,9,61,15],[61,17,61,23],[61,25,61,31],[59,1,59,7],[50,1,50,7],[50,19,50,23],[50,25,50,31],[51,1,51,23],[51,25,51,34],[53,1,53,8],[54,1,54,34],[56,1,56,7],[57,1,57,14],[57,16,57,23],[57,25,57,34],[46,1,46,11],[46,13,46,23],[46,25,46,34],[39,1,39,7],[40,1,40,11],[40,13,40,23],[40,25,40,34],[42,1,42,8],[43,1,43,11],[43,13,43,23],[43,25,43,34],[44,1,44,7],[44,9,44,15],[44,17,44,23],[44,25,44,31],[45,1,45,7],[36,1,36,7],[37,1,37,11],[37,13,37,23],[37,25,37,34],[38,1,38,7],[38,9,38,15],[38,17,38,23],[38,25,38,31],[21,1,21,14],[21,16,21,23],[21,25,21,34],[14,1,14,7],[15,1,15,34],[17,1,17,8],[20,1,20,7],[17,25,17,32],[18,1,18,23],[18,25,18,34],[14,19,14,25]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[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,null,null,"Company Type"]
[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,null,null,"Engineering Firm"]
[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,null,null,"Architecture Firm"]
[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,null,null,"Contractor"]
[]
[]
[]
[]
[]
[]
[]
[null,"SCHOOL DISTRICT INFORMATION",null,null,null,null,null,null,null,null,"*Indicates required field "]
[]
[null,"School District Name *",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Have an Energy Manager?"]
[]
[]
[null,"School District Mailing Address *",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Building Square Footage *"]
[]
[]
[null,"City *",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State *",null,null,null,null,null,null,null,null,"Zip Code *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN"]
[]
[null,"ENERGY MANAGER"]
[]
[null,"First Name",null,null,null,null,null,null,null,null,null,null,null,"Last Name",null,null,null,null,null,null,null,null,null,null,null,"Title"]
[]
[]
[null,"Office Phone",null,null,null,null,null,null,null,null,null,null,null,"Cell Phone",null,null,null,null,null,null,null,null,null,null,null,"Email"]
[]
[]
[]
[]
[]
[null,"PROJECT CONTACT(S)"]
[]
[null,"Primary Contact First Name *",null,null,null,null,null,null,null,null,null,null,null,"Primary Contact Last Name *",null,null,null,null,null,null,null,null,null,null,null,"Title *"]
[]
[]
[null,"Office Phone *",null,null,null,null,null,null,null,null,null,null,null,"Cell Phone",null,null,null,null,null,null,null,null,null,null,null,"Email *"]
[]
[]
[null,"Secondary Contact First Name ",null,null,null,null,null,null,null,null,null,null,null,"Secondary Last Name ",null,null,null,null,null,null,null,null,null,null,null,"Title "]
[]
[]
[null,"Office Phone ",null,null,null,null,null,null,null,null,null,null,null,"Cell Phone",null,null,null,null,null,null,null,null,null,null,null,"Email "]
[]
[]
[null,"CONTRACTOR or PREFERRED PARTNERS NETWORK (PPN) CONTRACTOR"]
[]
[null,"Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To Be Determined",null,null,null,null,null,"Company Type"]
[]
[]
[null,"Mailing Address"]
[]
[]
[null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State",null,null,null,null,null,null,null,null,"Zip Code"]
[]
[]
[null,"First Name",null,null,null,null,null,null,null,null,null,null,null,"Last Name",null,null,null,null,null,null,null,null,null,null,null,"Title"]
[]
[]
[null,"Office Phone",null,null,null,null,null,null,null,null,null,null,null,"Cell Phone",null,null,null,null,null,null,null,null,null,null,null,"Email"]
[]
[]
[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,"v2.18 TRM 2018"]

{"sheet":"5. Project Information","index":4,"n_rows":195,"n_cols":52,"rows_kept":195,"cut":false,"hidden":true,"merged":[[190,11,190,27],[190,33,190,34],[184,11,184,27],[184,33,184,34],[188,1,188,9],[188,11,188,13],[188,15,188,17],[188,19,188,21],[188,23,188,25],[188,27,188,30],[188,32,188,34],[178,11,178,27],[178,33,178,34],[182,1,182,9],[182,11,182,13],[182,15,182,17],[182,19,182,21],[182,23,182,25],[182,27,182,30],[182,32,182,34],[172,11,172,27],[172,33,172,34],[176,1,176,9],[176,11,176,13],[176,15,176,17],[176,19,176,21],[176,23,176,25],[176,27,176,30],[176,32,176,34],[166,11,166,27],[166,33,166,34],[170,1,170,9],[170,11,170,13],[170,15,170,17],[170,19,170,21],[170,23,170,25],[170,27,170,30],[170,32,170,34],[160,11,160,27],[160,33,160,34],[164,1,164,9],[164,11,164,13],[164,15,164,17],[164,19,164,21],[164,23,164,25],[164,27,164,30],[164,32,164,34],[154,11,154,27],[154,33,154,34],[158,1,158,9],[158,11,158,13],[158,15,158,17],[158,19,158,21],[158,23,158,25],[158,27,158,30],[158,32,158,34],[148,11,148,27],[148,33,148,34],[152,1,152,9],[152,11,152,13],[152,15,152,17],[152,19,152,21],[152,23,152,25],[152,27,152,30],[152,32,152,34],[142,11,142,27],[142,33,142,34],[146,1,146,9],[146,11,146,13],[146,15,146,17],[146,19,146,21],[146,23,146,25],[146,27,146,30],[146,32,146,34],[136,11,136,27],[136,33,136,34],[140,1,140,9],[140,11,140,13],[140,15,140,17],[140,19,140,21],[140,23,140,25],[140,27,140,30],[140,32,140,34],[130,11,130,27],[130,33,130,34],[134,1,134,9],[134,11,134,13],[134,15,134,17],[134,19,134,21],[134,23,134,25],[134,27,134,30],[134,32,134,34],[124,11,124,27],[124,33,124,34],[128,1,128,9],[128,11,128,13],[128,15,128,17],[128,19,128,21],[128,23,128,25],[128,27,128,30],[128,32,128,34],[118,11,118,27],[118,33,118,34],[122,1,122,9],[122,11,122,13],[122,15,122,17],[122,19,122,21],[122,23,122,25],[122,27,122,30],[122,32,122,34],[112,11,112,27],[112,33,112,34],[116,1,116,9],[116,11,116,13],[116,15,116,17],[116,19,116,21],[116,23,116,25],[116,27,116,30],[116,32,116,34],[106,11,106,27],[106,33,106,34],[110,1,110,9],[110,11,110,13],[110,15,110,17],[110,19,110,21],[110,23,110,25],[110,27,110,30],[110,32,110,34],[100,11,100,27],[100,33,100,34],[104,1,104,9],[104,11,104,13],[104,15,104,17],[104,19,104,21],[104,23,104,25],[104,27,104,30],[104,32,104,34],[94,11,94,27],[94,33,94,34],[98,1,98,9],[98,11,98,13],[98,15,98,17],[98,19,98,21],[98,23,98,25],[98,27,98,30],[98,32,98,34],[88,11,88,27],[88,33,88,34],[92,1,92,9],[92,11,92,13],[92,15,92,17],[92,19,92,21],[92,23,92,25],[92,27,92,30],[92,32,92,34],[82,11,82,27],[82,33,82,34],[86,1,86,9],[86,11,86,13],[86,15,86,17],[86,19,86,21],[86,23,86,25],[86,27,86,30],[86,32,86,34],[76,11,76,27],[76,33,76,34],[80,1,80,9],[80,11,80,13],[80,15,80,17],[80,19,80,21],[80,23,80,25],[80,27,80,30],[80,32,80,34],[70,11,70,27],[70,33,70,34],[74,1,74,9],[74,11,74,13],[74,15,74,17],[74,19,74,21],[74,23,74,25],[74,27,74,30],[74,32,74,34],[64,11,64,27],[64,33,64,34],[68,1,68,9],[68,11,68,13],[68,15,68,17],[68,19,68,21],[68,23,68,25],[68,27,68,30],[68,32,68,34],[58,11,58,27],[58,33,58,34],[62,1,62,9],[62,11,62,13],[62,15,62,17],[62,19,62,21],[62,23,62,25],[62,27,62,30],[62,32,62,34],[52,11,52,27],[52,33,52,34],[56,1,56,9],[56,11,56,13],[56,15,56,17],[56,19,56,21],[56,23,56,25],[56,27,56,30],[56,32,56,34],[43,16,46,34],[46,1,46,3],[50,1,50,9],[50,11,50,13],[50,15,50,17],[50,19,50,21],[50,23,50,25],[50,27,50,30],[50,32,50,34],[39,27,39,29],[40,2,40,7],[40,8,40,10],[40,11,40,13],[40,14,40,16],[40,17,40,19],[40,20,40,22],[39,1,39,7],[39,8,39,10],[39,11,39,13],[39,14,39,16],[39,17,39,19],[39,20,39,22],[38,8,38,10],[38,11,38,13],[38,14,38,16],[38,17,38,19],[38,20,38,22],[38,26,38,30],[32,1,32,5],[33,1,33,5],[36,17,37,19],[36,20,37,22],[37,8,37,10],[37,11,37,13],[37,14,37,16],[23,1,23,6],[24,1,24,9],[24,11,24,18],[24,20,24,27],[24,29,24,34],[30,8,30,11],[30,20,30,28],[14,19,14,20],[14,26,16,34],[16,21,16,22],[18,12,18,13],[20,1,20,7],[21,1,21,27]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[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,null,null,null,null,null,null,null,null,null,null,null,"ECMs"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Lighting Systems"]
[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,null,null,null,null,null,null,null,null,null,null,null,"HVAC Equipment"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Retro-Commissioning (RCx)"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Energy Management Systems (EMS)"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Equipment Controls"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Pumps And Motors"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[]
[]
[]
[null,"PROJECT SITE INFORMATION"]
[]
[null,"Is the Project Site Information same as the School District Mailing Address?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*The Project Site is the facility at which the efficiency upgrades will take place."]
[]
[null,"Is the Project Site Information entered into the ENERGY STAR Portfolio Manager Tool?"]
[]
[null,"Are you tracking your energy usage and cost",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,null,"ENERGYSTAR Portfolio"]
[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,null,null,null,"Yes"]
[null,"Project Site Address *",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,null,"No"]
[]
[]
[null,"City *",null,null,null,null,null,null,null,null,null,"State *",null,null,null,null,null,null,null,null,"Zip Code *",null,null,null,null,null,null,null,null,"County *"]
[]
[]
[null,"SCHOOL BUILDING AND ENVELOPE CHARACTERISTICS"]
[]
[null,"Primary Function"]
[]
[null,null,"Elementary School",null,null,null,null,null,"Middle School",null,null,null,null,"High School",null,null,null,null,"Other "]
[]
[null,"Square Footage *"]
[]
[]
[null,"ANNUAL ENERGY BILL INFORMATION (12 months) *",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,null,{"$f":"SUM(R39:T41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Annual Cost",null,null,"EUI"]
[null,null,null,null,null,null,null,null,"Annual Usage",null,null,"Unit",null,null,"Cost / Unit"]
[null,null,null,null,null,null,null," Electricity Use (kWh)",null,null,null,"kWh",null,null,null,null,null,{"$f":"IF(OR(ISBLANK(I39),ISBLANK(O39)),\"\",I39*O39)","v":""},null,null,{"$f":"IFERROR(IF(OR(ISBLANK(I39),ISBLANK(B34)),\"\",VLOOKUP(L39,$AU$40:$AV$40,2,FALSE)*I39/1000/$B$34),\"Need Unit\")","v":""},null,null,null,null,null,"Facility EUI",null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas","btu","source","Propane","btu","source","Electricity","btu","source"]
[null,"Natural Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(I40),ISBLANK(O40)),\"\",I40*O40)","v":""},null,null,{"$f":"IFERROR(IF(OR(ISBLANK(I40),ISBLANK(B34)),\"\",VLOOKUP(L40,$AO$40:$AP$44,2,FALSE)*I40/1000/$B$34),\"Need Unit\")","v":""},null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,6,U39:W41)","v":0},null,null,"Kbtu/sqft",null,null,null,null,null,null,null,null,null,"btu",1,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8","cf",2488,"http://www.npga.org/files/public/Facts_About_Propane.pdf","kWh",3414,"http://www.eia.gov/totalenergy/data/monthly/pdf/sec13_6.pdf"]
[null,null,"Propane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(I41),ISBLANK(O41)),\"\",I41*O41)","v":""},null,null,{"$f":"IFERROR(IF(OR(ISBLANK(I41),ISBLANK(B34)),\"\",VLOOKUP(L41,$AR$40:$AS$42,2,FALSE)*I41/1000/$B$34),\"Need Unit\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cubic feet",1028,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8","pounds",21548,"http://www.npga.org/files/public/Facts_About_Propane.pdf"]
[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,null,null,null,"Ccf",102800,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8","gallons",91502]
[null,"ENERGY CONSERVATION MEASURES (ECMs)",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,null,"Mcf",1028000,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Engineering calculations are required to validate the energy savings associated with each ECM.  If engineering support is needed to determine the energy savings for the application, contact Paul Cross at 615-532-9643",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"therms",100000,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8"]
[null,"How many ECMs are you installing? *"]
[]
[null,1]
[]
[null,"ECM 1 *",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings *                ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost *",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X51/AG51,\"\")","v":""},null,null,null,null,{"$f":"L51*$O$39+P51*$O$40+T51*$O$41","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L51,P51,T51)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG51=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L51/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG51=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P51/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG51=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T51/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 2",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X57/AG57,\"\")","v":""},null,null,null,null,{"$f":"L57*$O$39+P57*$O$40+T57*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG57=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L57/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG57=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P57/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG57=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T57/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 3",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X63/AG63,\"\")","v":""},null,null,null,null,{"$f":"L63*$O$39+P63*$O$40+T63*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG63=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L63/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG63=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P63/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG63=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T63/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 4",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X69/AG69,\"\")","v":""},null,null,null,null,{"$f":"L69*$O$39+P69*$O$40+T69*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG69=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L69/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG69=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P69/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG69=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T69/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 5",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X75/AG75,\"\")","v":""},null,null,null,null,{"$f":"L75*$O$39+P75*$O$40+T75*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG75=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L75/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG75=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P75/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG75=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T75/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 6",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X81/AG81,\"\")","v":""},null,null,null,null,{"$f":"L81*$O$39+P81*$O$40+T81*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG81=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L81/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG81=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P81/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG81=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T81/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 7",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X87/AG87,\"\")","v":""},null,null,null,null,{"$f":"L87*$O$39+P87*$O$40+T87*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG87=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L87/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG87=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P87/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG87=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T87/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 8",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X93/AG93,\"\")","v":""},null,null,null,null,{"$f":"L93*$O$39+P93*$O$40+T93*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG93=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L93/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG93=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P93/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG93=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T93/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 9",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X99/AG99,\"\")","v":""},null,null,null,null,{"$f":"L99*$O$39+P99*$O$40+T99*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG99=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L99/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG99=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P99/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG99=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T99/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 10",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X105/AG105,\"\")","v":""},null,null,null,null,{"$f":"L105*$O$39+P105*$O$40+T105*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG105=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L105/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG105=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P105/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG105=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T105/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 11",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X111/AG111,\"\")","v":""},null,null,null,null,{"$f":"L111*$O$39+P111*$O$40+T111*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG111=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L111/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG111=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P111/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG111=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T111/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 12",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X117/AG117,\"\")","v":""},null,null,null,null,{"$f":"L117*$O$39+P117*$O$40+T117*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG117=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L117/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG117=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P117/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG117=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T117/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 13",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X123/AG123,\"\")","v":""},null,null,null,null,{"$f":"L123*$O$39+P123*$O$40+T123*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG123=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L123/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG123=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P123/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG123=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T123/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 14",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X129/AG129,\"\")","v":""},null,null,null,null,{"$f":"L129*$O$39+P129*$O$40+T129*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG129=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L129/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG129=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P129/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG129=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T129/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 15",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X135/AG135,\"\")","v":""},null,null,null,null,{"$f":"L135*$O$39+P135*$O$40+T135*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG135=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L135/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG135=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P135/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG135=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T135/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 16",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X141/AG141,\"\")","v":""},null,null,null,null,{"$f":"L141*$O$39+P141*$O$40+T141*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG141=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L141/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG141=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P141/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG141=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T141/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 17",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X147/AG147,\"\")","v":""},null,null,null,null,{"$f":"L147*$O$39+P147*$O$40+T147*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG147=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L147/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG147=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P147/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG147=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T147/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 18",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X153/AG153,\"\")","v":""},null,null,null,null,{"$f":"L153*$O$39+P153*$O$40+T153*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG153=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L153/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG153=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P153/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG153=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T153/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 19",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X159/AG159,\"\")","v":""},null,null,null,null,{"$f":"L159*$O$39+P159*$O$40+T159*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG159=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L159/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG159=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P159/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG159=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T159/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 20",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X165/AG165,\"\")","v":""},null,null,null,null,{"$f":"L165*$O$39+P165*$O$40+T165*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG165=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L165/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG165=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P165/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG165=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T165/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 21",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X171/AG171,\"\")","v":""},null,null,null,null,{"$f":"L171*$O$39+P171*$O$40+T171*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG171=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L171/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG171=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P171/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG171=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T171/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 22",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X177/AG177,\"\")","v":""},null,null,null,null,{"$f":"L177*$O$39+P177*$O$40+T177*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG177=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L177/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG177=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P177/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG177=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T177/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 23",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X183/AG183,\"\")","v":""},null,null,null,null,{"$f":"L183*$O$39+P183*$O$40+T183*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG183=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L183/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG183=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P183/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG183=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T183/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 24",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X189/AG189,\"\")","v":""},null,null,null,null,{"$f":"L189*$O$39+P189*$O$40+T189*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG189=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L189/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG189=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P189/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG189=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T189/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[]
[]
[null,"To access TVA's Technical Resource Manual for guidance in determining energy savings click here:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1. Introduction'!AI66","v":"v2.18 TRM 2018"}]

{"sheet":"6. Project Summary","index":5,"n_rows":282,"n_cols":52,"rows_kept":282,"cut":false,"hidden":true,"merged":[[264,2,264,3],[264,4,264,12],[264,13,264,15],[264,16,264,18],[264,19,264,21],[264,22,264,24],[264,25,264,27],[264,28,264,30],[265,2,265,3],[265,4,265,12],[265,13,265,15],[265,16,265,18],[265,19,265,21],[265,22,265,24],[265,25,265,27],[265,28,265,30],[261,2,261,3],[261,4,261,12],[261,13,261,15],[261,16,261,18],[261,19,261,21],[261,22,261,24],[261,25,261,27],[261,28,261,30],[262,2,262,3],[262,4,262,12],[262,13,262,15],[262,16,262,18],[262,19,262,21],[262,22,262,24],[262,25,262,27],[262,28,262,30],[263,2,263,3],[263,4,263,12],[263,13,263,15],[263,16,263,18],[263,19,263,21],[263,22,263,24],[263,25,263,27],[263,28,263,30],[258,2,258,3],[258,4,258,12],[258,13,258,15],[258,16,258,18],[258,19,258,21],[258,22,258,24],[258,25,258,27],[258,28,258,30],[259,2,259,3],[259,4,259,12],[259,13,259,15],[259,16,259,18],[259,19,259,21],[259,22,259,24],[259,25,259,27],[259,28,259,30],[260,2,260,3],[260,4,260,12],[260,13,260,15],[260,16,260,18],[260,19,260,21],[260,22,260,24],[260,25,260,27],[260,28,260,30],[255,2,255,3],[255,4,255,12],[255,13,255,15],[255,16,255,18],[255,19,255,21],[255,22,255,24],[255,25,255,27],[255,28,255,30],[256,2,256,3],[256,4,256,12],[256,13,256,15],[256,16,256,18],[256,19,256,21],[256,22,256,24],[256,25,256,27],[256,28,256,30],[257,2,257,3],[257,4,257,12],[257,13,257,15],[257,16,257,18],[257,19,257,21],[257,22,257,24],[257,25,257,27],[257,28,257,30],[252,2,252,3],[252,4,252,12],[252,13,252,15],[252,16,252,18],[252,19,252,21],[252,22,252,24],[252,25,252,27],[252,28,252,30],[253,2,253,3],[253,4,253,12],[253,13,253,15],[253,16,253,18],[253,19,253,21],[253,22,253,24],[253,25,253,27],[253,28,253,30],[254,2,254,3],[254,4,254,12],[254,13,254,15],[254,16,254,18],[254,19,254,21],[254,22,254,24],[254,25,254,27],[254,28,254,30],[249,2,249,3],[249,4,249,12],[249,13,249,15],[249,16,249,18],[249,19,249,21],[249,22,249,24],[249,25,249,27],[249,28,249,30],[250,2,250,3],[250,4,250,12],[250,13,250,15],[250,16,250,18],[250,19,250,21],[250,22,250,24],[250,25,250,27],[250,28,250,30],[251,2,251,3],[251,4,251,12],[251,13,251,15],[251,16,251,18],[251,19,251,21],[251,22,251,24],[251,25,251,27],[251,28,251,30],[246,2,246,3],[246,4,246,12],[246,13,246,15],[246,16,246,18],[246,19,246,21],[246,22,246,24],[246,25,246,27],[246,28,246,30],[247,2,247,3],[247,4,247,12],[247,13,247,15],[247,16,247,18],[247,19,247,21],[247,22,247,24],[247,25,247,27],[247,28,247,30],[248,2,248,3],[248,4,248,12],[248,13,248,15],[248,16,248,18],[248,19,248,21],[248,22,248,24],[248,25,248,27],[248,28,248,30],[243,2,243,3],[243,4,243,12],[243,13,243,15],[243,16,243,18],[243,19,243,21],[243,22,243,24],[243,25,243,27],[243,28,243,30],[244,2,244,3],[244,4,244,12],[244,13,244,15],[244,16,244,18],[244,19,244,21],[244,22,244,24],[244,25,244,27],[244,28,244,30],[245,2,245,3],[245,4,245,12],[245,13,245,15],[245,16,245,18],[245,19,245,21],[245,22,245,24],[245,25,245,27],[245,28,245,30],[239,1,239,2],[240,13,240,15],[240,16,240,18],[240,19,240,21],[240,22,240,24],[240,25,240,27],[240,28,240,30],[241,2,241,3],[241,13,241,15],[241,16,241,18],[241,19,241,21],[241,22,241,24],[241,25,241,27],[241,28,241,30],[242,2,242,3],[242,4,242,12],[242,13,242,15],[242,16,242,18],[242,19,242,21],[242,22,242,24],[242,25,242,27],[242,28,242,30],[206,2,206,3],[206,4,206,12],[206,13,206,15],[206,16,206,18],[206,19,206,21],[206,22,206,24],[206,25,206,27],[206,28,206,30],[207,2,207,3],[207,4,207,12],[207,13,207,15],[207,16,207,18],[207,19,207,21],[207,22,207,24],[207,25,207,27],[207,28,207,30],[204,2,204,3],[204,4,204,12],[204,13,204,15],[204,16,204,18],[204,19,204,21],[204,22,204,24],[204,25,204,27],[204,28,204,30],[205,2,205,3],[205,4,205,12],[205,13,205,15],[205,16,205,18],[205,19,205,21],[205,22,205,24],[205,25,205,27],[205,28,205,30],[202,2,202,3],[202,4,202,12],[202,13,202,15],[202,16,202,18],[202,19,202,21],[202,22,202,24],[202,25,202,27],[202,28,202,30],[203,2,203,3],[203,4,203,12],[203,13,203,15],[203,16,203,18],[203,19,203,21],[203,22,203,24],[203,25,203,27],[203,28,203,30],[200,2,200,3],[200,4,200,12],[200,13,200,15],[200,16,200,18],[200,19,200,21],[200,22,200,24],[200,25,200,27],[200,28,200,30],[201,2,201,3],[201,4,201,12],[201,13,201,15],[201,16,201,18],[201,19,201,21],[201,22,201,24],[201,25,201,27],[201,28,201,30],[198,2,198,3],[198,4,198,12],[198,13,198,15],[198,16,198,18],[198,19,198,21],[198,22,198,24],[198,25,198,27],[198,28,198,30],[199,2,199,3],[199,4,199,12],[199,13,199,15],[199,16,199,18],[199,19,199,21],[199,22,199,24],[199,25,199,27],[199,28,199,30],[196,2,196,3],[196,4,196,12],[196,13,196,15],[196,16,196,18],[196,19,196,21],[196,22,196,24],[196,25,196,27],[196,28,196,30],[197,2,197,3],[197,4,197,12],[197,13,197,15],[197,16,197,18],[197,19,197,21],[197,22,197,24],[197,25,197,27],[197,28,197,30],[194,2,194,3],[194,4,194,12],[194,13,194,15],[194,16,194,18],[194,19,194,21],[194,22,194,24],[194,25,194,27],[194,28,194,30],[195,2,195,3],[195,4,195,12],[195,13,195,15],[195,16,195,18],[195,19,195,21],[195,22,195,24],[195,25,195,27],[195,28,195,30],[192,2,192,3],[192,4,192,12],[192,13,192,15],[192,16,192,18],[192,19,192,21],[192,22,192,24],[192,25,192,27],[192,28,192,30],[193,2,193,3],[193,4,193,12],[193,13,193,15],[193,16,193,18],[193,19,193,21],[193,22,193,24],[193,25,193,27],[193,28,193,30],[190,2,190,3],[190,4,190,12],[190,13,190,15],[190,16,190,18],[190,19,190,21],[190,22,190,24],[190,25,190,27],[190,28,190,30],[191,2,191,3],[191,4,191,12],[191,13,191,15],[191,16,191,18],[191,19,191,21],[191,22,191,24],[191,25,191,27],[191,28,191,30],[188,2,188,3],[188,4,188,12],[188,13,188,15],[188,16,188,18],[188,19,188,21],[188,22,188,24],[188,25,188,27],[188,28,188,30],[189,2,189,3],[189,4,189,12],[189,13,189,15],[189,16,189,18],[189,19,189,21],[189,22,189,24],[189,25,189,27],[189,28,189,30],[186,2,186,3],[186,4,186,12],[186,13,186,15],[186,16,186,18],[186,19,186,21],[186,22,186,24],[186,25,186,27],[186,28,186,30],[187,2,187,3],[187,4,187,12],[187,13,187,15],[187,16,187,18],[187,19,187,21],[187,22,187,24],[187,25,187,27],[187,28,187,30],[176,28,176,30],[184,2,184,3],[184,4,184,12],[184,13,184,15],[184,16,184,18],[184,19,184,21],[184,22,184,24],[184,25,184,27],[184,28,184,30],[185,2,185,3],[185,4,185,12],[185,13,185,15],[185,16,185,18],[185,19,185,21],[185,22,185,24],[185,25,185,27],[185,28,185,30],[181,1,181,2],[182,13,182,15],[182,16,182,18],[182,19,182,21],[182,22,182,24],[182,25,182,27],[182,28,182,30],[183,2,183,3],[183,13,183,15],[183,16,183,18],[183,19,183,21],[183,22,183,24],[183,25,183,27],[183,28,183,30],[172,28,172,30],[177,2,177,3],[177,4,177,12],[177,13,177,15],[177,16,177,18],[177,19,177,21],[177,22,177,24],[177,25,177,27],[177,28,177,30],[178,2,178,3],[178,4,178,12],[178,13,178,15],[178,16,178,18],[178,19,178,21],[178,22,178,24],[178,25,178,27],[178,28,178,30],[175,2,175,3],[175,4,175,12],[175,13,175,15],[175,16,175,18],[175,19,175,21],[175,22,175,24],[175,25,175,27],[175,28,175,30],[176,2,176,3],[176,4,176,12],[176,13,176,15],[176,16,176,18],[176,19,176,21],[176,22,176,24],[176,25,176,27],[168,28,168,30],[173,2,173,3],[173,4,173,12],[173,13,173,15],[173,16,173,18],[173,19,173,21],[173,22,173,24],[173,25,173,27],[173,28,173,30],[174,2,174,3],[174,4,174,12],[174,13,174,15],[174,16,174,18],[174,19,174,21],[174,22,174,24],[174,25,174,27],[174,28,174,30],[171,2,171,3],[171,4,171,12],[171,13,171,15],[171,16,171,18],[171,19,171,21],[171,22,171,24],[171,25,171,27],[171,28,171,30],[172,2,172,3],[172,4,172,12],[172,13,172,15],[172,16,172,18],[172,19,172,21],[172,22,172,24],[172,25,172,27],[164,28,164,30],[169,2,169,3],[169,4,169,12],[169,13,169,15],[169,16,169,18],[169,19,169,21],[169,22,169,24],[169,25,169,27],[169,28,169,30],[170,2,170,3],[170,4,170,12],[170,13,170,15],[170,16,170,18],[170,19,170,21],[170,22,170,24],[170,25,170,27],[170,28,170,30],[167,2,167,3],[167,4,167,12],[167,13,167,15],[167,16,167,18],[167,19,167,21],[167,22,167,24],[167,25,167,27],[167,28,167,30],[168,2,168,3],[168,4,168,12],[168,13,168,15],[168,16,168,18],[168,19,168,21],[168,22,168,24],[168,25,168,27],[160,28,160,30],[165,2,165,3],[165,4,165,12],[165,13,165,15],[165,16,165,18],[165,19,165,21],[165,22,165,24],[165,25,165,27],[165,28,165,30],[166,2,166,3],[166,4,166,12],[166,13,166,15],[166,16,166,18],[166,19,166,21],[166,22,166,24],[166,25,166,27],[166,28,166,30],[163,2,163,3],[163,4,163,12],[163,13,163,15],[163,16,163,18],[163,19,163,21],[163,22,163,24],[163,25,163,27],[163,28,163,30],[164,2,164,3],[164,4,164,12],[164,13,164,15],[164,16,164,18],[164,19,164,21],[164,22,164,24],[164,25,164,27],[156,28,156,30],[161,2,161,3],[161,4,161,12],[161,13,161,15],[161,16,161,18],[161,19,161,21],[161,22,161,24],[161,25,161,27],[161,28,161,30],[162,2,162,3],[162,4,162,12],[162,13,162,15],[162,16,162,18],[162,19,162,21],[162,22,162,24],[162,25,162,27],[162,28,162,30],[159,2,159,3],[159,4,159,12],[159,13,159,15],[159,16,159,18],[159,19,159,21],[159,22,159,24],[159,25,159,27],[159,28,159,30],[160,2,160,3],[160,4,160,12],[160,13,160,15],[160,16,160,18],[160,19,160,21],[160,22,160,24],[160,25,160,27],[149,28,149,30],[157,2,157,3],[157,4,157,12],[157,13,157,15],[157,16,157,18],[157,19,157,21],[157,22,157,24],[157,25,157,27],[157,28,157,30],[158,2,158,3],[158,4,158,12],[158,13,158,15],[158,16,158,18],[158,19,158,21],[158,22,158,24],[158,25,158,27],[158,28,158,30],[155,2,155,3],[155,4,155,12],[155,13,155,15],[155,16,155,18],[155,19,155,21],[155,22,155,24],[155,25,155,27],[155,28,155,30],[156,2,156,3],[156,4,156,12],[156,13,156,15],[156,16,156,18],[156,19,156,21],[156,22,156,24],[156,25,156,27],[145,22,145,24],[145,25,145,27],[145,28,145,30],[152,1,152,2],[153,13,153,15],[153,16,153,18],[153,19,153,21],[153,22,153,24],[153,25,153,27],[153,28,153,30],[154,2,154,3],[154,13,154,15],[154,16,154,18],[154,19,154,21],[154,22,154,24],[154,25,154,27],[154,28,154,30],[149,2,149,3],[149,4,149,12],[149,13,149,15],[149,16,149,18],[149,19,149,21],[149,22,149,24],[149,25,149,27],[141,22,141,24],[141,25,141,27],[141,28,141,30],[146,2,146,3],[146,4,146,12],[146,13,146,15],[146,16,146,18],[146,19,146,21],[146,22,146,24],[146,25,146,27],[146,28,146,30],[147,2,147,3],[147,4,147,12],[147,13,147,15],[147,16,147,18],[147,19,147,21],[147,22,147,24],[137,28,137,30],[142,2,142,3],[142,4,142,12],[142,13,142,15],[142,16,142,18],[142,19,142,21],[142,22,142,24],[142,25,142,27],[142,28,142,30],[143,2,143,3],[143,4,143,12],[143,13,143,15],[143,16,143,18],[143,19,143,21],[143,22,143,24],[148,2,148,3],[148,4,148,12],[148,13,148,15],[148,16,148,18],[148,19,148,21],[148,22,148,24],[148,25,148,27],[148,28,148,30],[133,28,133,30],[138,2,138,3],[138,4,138,12],[138,13,138,15],[138,16,138,18],[138,19,138,21],[138,22,138,24],[138,25,138,27],[138,28,138,30],[139,2,139,3],[139,4,139,12],[139,13,139,15],[139,16,139,18],[139,19,139,21],[139,22,139,24],[147,25,147,27],[147,28,147,30],[144,2,144,3],[144,4,144,12],[144,13,144,15],[144,16,144,18],[144,19,144,21],[144,22,144,24],[144,25,144,27],[144,28,144,30],[145,2,145,3],[145,4,145,12],[145,13,145,15],[145,16,145,18],[145,19,145,21],[137,22,137,24],[137,25,137,27],[129,28,129,30],[134,2,134,3],[134,4,134,12],[134,13,134,15],[134,16,134,18],[134,19,134,21],[134,22,134,24],[134,25,134,27],[134,28,134,30],[135,2,135,3],[135,4,135,12],[135,13,135,15],[135,16,135,18],[135,19,135,21],[135,22,135,24],[143,25,143,27],[143,28,143,30],[140,2,140,3],[140,4,140,12],[140,13,140,15],[140,16,140,18],[140,19,140,21],[140,22,140,24],[140,25,140,27],[140,28,140,30],[141,2,141,3],[141,4,141,12],[141,13,141,15],[141,16,141,18],[141,19,141,21],[133,22,133,24],[133,25,133,27],[125,28,125,30],[130,2,130,3],[130,4,130,12],[130,13,130,15],[130,16,130,18],[130,19,130,21],[130,22,130,24],[130,25,130,27],[130,28,130,30],[131,2,131,3],[131,4,131,12],[131,13,131,15],[131,16,131,18],[131,19,131,21],[131,22,131,24],[139,25,139,27],[139,28,139,30],[136,2,136,3],[136,4,136,12],[136,13,136,15],[136,16,136,18],[136,19,136,21],[136,22,136,24],[136,25,136,27],[136,28,136,30],[137,2,137,3],[137,4,137,12],[137,13,137,15],[137,16,137,18],[137,19,137,21],[129,22,129,24],[129,25,129,27],[118,22,118,24],[118,25,118,27],[118,28,118,30],[126,2,126,3],[126,4,126,12],[126,13,126,15],[126,16,126,18],[126,19,126,21],[126,22,126,24],[126,25,126,27],[126,28,126,30],[127,2,127,3],[127,4,127,12],[127,13,127,15],[127,16,127,18],[135,25,135,27],[135,28,135,30],[132,2,132,3],[132,4,132,12],[132,13,132,15],[132,16,132,18],[132,19,132,21],[132,22,132,24],[132,25,132,27],[132,28,132,30],[133,2,133,3],[133,4,133,12],[133,13,133,15],[133,16,133,18],[133,19,133,21],[125,22,125,24],[125,25,125,27],[114,22,114,24],[114,25,114,27],[114,28,114,30],[119,2,119,3],[119,4,119,12],[119,13,119,15],[119,16,119,18],[119,19,119,21],[119,22,119,24],[119,25,119,27],[119,28,119,30],[120,2,120,3],[120,4,120,12],[120,13,120,15],[120,16,120,18],[131,25,131,27],[131,28,131,30],[128,2,128,3],[128,4,128,12],[128,13,128,15],[128,16,128,18],[128,19,128,21],[128,22,128,24],[128,25,128,27],[128,28,128,30],[129,2,129,3],[129,4,129,12],[129,13,129,15],[129,16,129,18],[129,19,129,21],[118,16,118,18],[118,19,118,21],[110,22,110,24],[110,25,110,27],[110,28,110,30],[115,2,115,3],[115,4,115,12],[115,13,115,15],[115,16,115,18],[115,19,115,21],[115,22,115,24],[115,25,115,27],[115,28,115,30],[116,2,116,3],[116,4,116,12],[116,13,116,15],[116,16,116,18],[127,19,127,21],[127,22,127,24],[127,25,127,27],[127,28,127,30],[123,1,123,2],[124,13,124,15],[124,16,124,18],[124,19,124,21],[124,22,124,24],[124,25,124,27],[124,28,124,30],[125,2,125,3],[125,13,125,15],[125,16,125,18],[125,19,125,21],[114,16,114,18],[114,19,114,21],[106,22,106,24],[106,25,106,27],[106,28,106,30],[111,2,111,3],[111,4,111,12],[111,13,111,15],[111,16,111,18],[111,19,111,21],[111,22,111,24],[111,25,111,27],[111,28,111,30],[112,2,112,3],[112,4,112,12],[112,13,112,15],[112,16,112,18],[120,19,120,21],[120,22,120,24],[120,25,120,27],[120,28,120,30],[117,2,117,3],[117,4,117,12],[117,13,117,15],[117,16,117,18],[117,19,117,21],[117,22,117,24],[117,25,117,27],[117,28,117,30],[118,2,118,3],[118,4,118,12],[118,13,118,15],[110,16,110,18],[110,19,110,21],[102,22,102,24],[102,25,102,27],[102,28,102,30],[107,2,107,3],[107,4,107,12],[107,13,107,15],[107,16,107,18],[107,19,107,21],[107,22,107,24],[107,25,107,27],[107,28,107,30],[108,2,108,3],[108,4,108,12],[108,13,108,15],[108,16,108,18],[116,19,116,21],[116,22,116,24],[116,25,116,27],[116,28,116,30],[113,2,113,3],[113,4,113,12],[113,13,113,15],[113,16,113,18],[113,19,113,21],[113,22,113,24],[113,25,113,27],[113,28,113,30],[114,2,114,3],[114,4,114,12],[114,13,114,15],[106,16,106,18],[106,19,106,21],[98,22,98,24],[98,25,98,27],[98,28,98,30],[103,2,103,3],[103,4,103,12],[103,13,103,15],[103,16,103,18],[103,19,103,21],[103,22,103,24],[103,25,103,27],[103,28,103,30],[104,2,104,3],[104,4,104,12],[104,13,104,15],[104,16,104,18],[112,19,112,21],[112,22,112,24],[112,25,112,27],[112,28,112,30],[109,2,109,3],[109,4,109,12],[109,13,109,15],[109,16,109,18],[109,19,109,21],[109,22,109,24],[109,25,109,27],[109,28,109,30],[110,2,110,3],[110,4,110,12],[110,13,110,15],[102,16,102,18],[102,19,102,21],[102,4,102,12],[102,13,102,15],[96,28,96,30],[270,1,272,34],[97,2,97,3],[97,4,97,12],[97,13,97,15],[97,16,97,18],[97,19,97,21],[97,22,97,24],[97,25,97,27],[97,28,97,30],[98,2,98,3],[98,4,98,12],[98,13,98,15],[108,19,108,21],[108,22,108,24],[108,25,108,27],[108,28,108,30],[105,2,105,3],[105,4,105,12],[105,13,105,15],[105,16,105,18],[105,19,105,21],[105,22,105,24],[105,25,105,27],[105,28,105,30],[106,2,106,3],[106,4,106,12],[106,13,106,15],[98,16,98,18],[98,19,98,21],[274,1,274,15],[274,16,274,27],[274,28,274,34],[99,2,99,3],[99,4,99,12],[99,13,99,15],[99,16,99,18],[99,19,99,21],[99,22,99,24],[99,25,99,27],[99,28,99,30]],"merged_total":1677,"flags":["merged_cut"]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[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,null,null,null,"No"]
[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,null,null,null,"Yes"]
[]
[]
[]
[]
[]
[]
[]
[null,"CONTACT INFORMATION"]
[]
[null,"School District"]
[null,{"$f":"'4. Contact Information'!B16:AI16","v":0}]
[]
[null,"Project Site Address"]
[null,{"$f":"'5. Project Information'!B22","v":0}]
[]
[null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State ",null,null,null,null,null,null,null,null,"Zip Code "]
[null,{"$f":"'5. Project Information'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!L25","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!U25","v":0}]
[]
[null,"Primary Contact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
[null,{"$f":"'4. Contact Information'!$B$38:$L$38","v":0},null,null,null,null,null,{"$f":"'4. Contact Information'!$N$38","v":0},null,null,null,null,null,null,null,null,{"$f":"'4. Contact Information'!$Z$41","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4. Contact Information'!$B$41","v":0}]
[]
[null,"Third Party Administrator"]
[null,{"$f":"'4. Contact Information'!B52","v":0}]
[]
[null,"Primary Contact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
[null,{"$f":"'4. Contact Information'!$B$61:$L$61","v":0},null,null,null,null,null,{"$f":"'4. Contact Information'!$N$61","v":0},null,null,null,null,null,null,null,null,{"$f":"'4. Contact Information'!$Z$64","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4. Contact Information'!$B$64","v":0}]
[]
[null,"Project Summary"]
[]
[null,"Site:",null,{"$f":"'5. Project Information'!$B$22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,"Est. Annual $ Savings",null,null,"Simple Payback",null,null,"EUI Reduction",null,null,"Financial Need",null,null,"Total Points"]
[null,null,"Include",null,null,null,null,null,null,null,null,null,"Site Totals:",{"$f":"_xlfn.AGGREGATE(9,5,AM38:AM61)","v":0},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AN38:AN61)","v":0},null,null,{"$f":"IFERROR(N37/Q37,\"\")","v":""},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AO38:AO61)","v":0},null,null,{"$f":"IF('5. Project Information'!$AD$25=\"\",\"\",VLOOKUP('5. Project Information'!$AD$25,Formula!$A$3:$D$97,4,FALSE)& \" Quartile\")","v":""},null,null,{"$f":"IF($T37=\"\",\"\",VLOOKUP('5. Project Information'!$AD$25,Formula!$A$3:$C$97,3,FALSE)+IF($W37>0.3,30,IF($W37>0.2,20,IF($W37>0.1,10,0)))+IF($T37<=5,40,IF($T37<=8,20,IF($T37<=10,10,0))))","v":""}]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$51","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$51","v":0},null,null,{"$f":"'5. Project Information'!$AG$51","v":0},null,null,{"$f":"'5. Project Information'!$AB$51","v":""},null,null,{"$f":"'5. Project Information'!$AH$53","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C38=\"Yes\",N38,0)","v":0},{"$f":"IF(C38=\"Yes\",Q38,0)","v":0},{"$f":"IF(C38=\"Yes\",W38,0)","v":""}]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$57","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$57","v":0},null,null,{"$f":"'5. Project Information'!$AG$57","v":0},null,null,{"$f":"'5. Project Information'!$AB$57","v":""},null,null,{"$f":"'5. Project Information'!$AH$59","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C39=\"Yes\",N39,0)","v":0},{"$f":"IF(C39=\"Yes\",Q39,0)","v":0},{"$f":"IF(C39=\"Yes\",W39,0)","v":""}]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$63","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$63","v":0},null,null,{"$f":"'5. Project Information'!$AG$63","v":0},null,null,{"$f":"'5. Project Information'!$AB$63","v":""},null,null,{"$f":"'5. Project Information'!$AH$65","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$69","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$69","v":0},null,null,{"$f":"'5. Project Information'!$AG$69","v":0},null,null,{"$f":"'5. Project Information'!$AB$69","v":""},null,null,{"$f":"'5. Project Information'!$AH$71","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$75","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$75","v":0},null,null,{"$f":"'5. Project Information'!$AG$75","v":0},null,null,{"$f":"'5. Project Information'!$AB$75","v":""},null,null,{"$f":"'5. Project Information'!$AH$77","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$81","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$81","v":0},null,null,{"$f":"'5. Project Information'!$AG$81","v":0},null,null,{"$f":"'5. Project Information'!$AB$81","v":""},null,null,{"$f":"'5. Project Information'!$AH$83","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$87","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$87","v":0},null,null,{"$f":"'5. Project Information'!$AG$87","v":0},null,null,{"$f":"'5. Project Information'!$AB$87","v":""},null,null,{"$f":"'5. Project Information'!$AH$89","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$93","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$93","v":0},null,null,{"$f":"'5. Project Information'!$AG$93","v":0},null,null,{"$f":"'5. Project Information'!$AB$93","v":""},null,null,{"$f":"'5. Project Information'!$AH$95","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$99","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$99","v":0},null,null,{"$f":"'5. Project Information'!$AG$99","v":0},null,null,{"$f":"'5. Project Information'!$AB$99","v":""},null,null,{"$f":"'5. Project Information'!$AH$101","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$105","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$105","v":0},null,null,{"$f":"'5. Project Information'!$AG$105","v":0},null,null,{"$f":"'5. Project Information'!$AB$105","v":""},null,null,{"$f":"'5. Project Information'!$AH$107","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$111","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$111","v":0},null,null,{"$f":"'5. Project Information'!$AG$111","v":0},null,null,{"$f":"'5. Project Information'!$AB$111","v":""},null,null,{"$f":"'5. Project Information'!$AH$113","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$117","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$117","v":0},null,null,{"$f":"'5. Project Information'!$AG$117","v":0},null,null,{"$f":"'5. Project Information'!$AB$117","v":""},null,null,{"$f":"'5. Project Information'!$AH$119","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$123","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$123","v":0},null,null,{"$f":"'5. Project Information'!$AG$123","v":0},null,null,{"$f":"'5. Project Information'!$AB$123","v":""},null,null,{"$f":"'5. Project Information'!$AH$125","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$129","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$129","v":0},null,null,{"$f":"'5. Project Information'!$AG$129","v":0},null,null,{"$f":"'5. Project Information'!$AB$129","v":""},null,null,{"$f":"'5. Project Information'!$AH$131","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$135","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$135","v":0},null,null,{"$f":"'5. Project Information'!$AG$135","v":0},null,null,{"$f":"'5. Project Information'!$AB$135","v":""},null,null,{"$f":"'5. Project Information'!$AH$137","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C52=\"Yes\",Q52,0)","v":0},""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$141","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$141","v":0},null,null,{"$f":"'5. Project Information'!$AG$141","v":0},null,null,{"$f":"'5. Project Information'!$AB$141","v":""},null,null,{"$f":"'5. Project Information'!$AH$143","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$147","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$147","v":0},null,null,{"$f":"'5. Project Information'!$AG$147","v":0},null,null,{"$f":"'5. Project Information'!$AB$147","v":""},null,null,{"$f":"'5. Project Information'!$AH$149","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$153","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$153","v":0},null,null,{"$f":"'5. Project Information'!$AG$153","v":0},null,null,{"$f":"'5. Project Information'!$AB$153","v":""},null,null,{"$f":"'5. Project Information'!$AH$155","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$159","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$159","v":0},null,null,{"$f":"'5. Project Information'!$AG$159","v":0},null,null,{"$f":"'5. Project Information'!$AB$159","v":""},null,null,{"$f":"'5. Project Information'!$AH$161","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$165","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$165","v":0},null,null,{"$f":"'5. Project Information'!$AG$165","v":0},null,null,{"$f":"'5. Project Information'!$AB$165","v":""},null,null,{"$f":"'5. Project Information'!$AH$167","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$171","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$171","v":0},null,null,{"$f":"'5. Project Information'!$AG$171","v":0},null,null,{"$f":"'5. Project Information'!$AB$171","v":""},null,null,{"$f":"'5. Project Information'!$AH$173","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$177","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$177","v":0},null,null,{"$f":"'5. Project Information'!$AG$177","v":0},null,null,{"$f":"'5. Project Information'!$AB$177","v":""},null,null,{"$f":"'5. Project Information'!$AH$179","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$183","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$183","v":0},null,null,{"$f":"'5. Project Information'!$AG$183","v":0},null,null,{"$f":"'5. Project Information'!$AB$183","v":""},null,null,{"$f":"'5. Project Information'!$AH$185","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!$B$189","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!$X$189","v":0},null,null,{"$f":"'5. Project Information'!$AG$189","v":0},null,null,{"$f":"'5. Project Information'!$AB$189","v":""},null,null,{"$f":"'5. Project Information'!$AH$191","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,"Est. Annual $ Savings",null,null,"Simple Payback"]
[null,"      App Totals:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($C68:$C270,$C68,N68:P270)","v":0},null,null,{"$f":"SUMIF($C68:$C270,$C68,Q68:S270)","v":0},null,null,{"$f":"IFERROR(N64/Q64,\"\")","v":""}]
[]
[null,"Site:",null,{"$f":"'5. Project Information'!B22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,"Est. Annual $ Savings",null,null,"Simple Payback",null,null,"EUI Reduction",null,null,"Financial Need",null,null,"Total Points"]
[null,null,"Include",null,null,null,null,null,null,null,null,null,"Site Totals:",{"$f":"_xlfn.AGGREGATE(9,5,AM69:AM92)","v":0},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AN69:AN92)","v":0},null,null,{"$f":"IFERROR(N68/Q68,\"\")","v":""},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AO69:AO92)","v":0},null,null,{"$f":"IF('5. Project Information'!$AD$25=\"\",\"\",VLOOKUP('5. Project Information'!$AD$25,Formula!$A$3:$D$97,4,FALSE)& \" Quartile\")","v":""},null,null,{"$f":"IF($T68=\"\",\"\",VLOOKUP('5. Project Information'!$AD$25,Formula!$A$3:$C$97,3,FALSE)+IF($W68>0.3,30,IF($W68>0.2,20,IF($W68>0.1,10,0)))+IF($T68<=5,40,IF($T68<=8,20,IF($T68<=10,10,0))))","v":""}]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B51","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X51","v":0},null,null,{"$f":"'5. Project Information'!AG51","v":0},null,null,{"$f":"'5. Project Information'!AB51","v":""},null,null,{"$f":"'5. Project Information'!AH53","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C69=\"Yes\",N69,0)","v":0},{"$f":"IF(C69=\"Yes\",Q69,0)","v":0},{"$f":"IF(C69=\"Yes\",W69,0)","v":""}]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B57","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X57","v":0},null,null,{"$f":"'5. Project Information'!AG57","v":0},null,null,{"$f":"'5. Project Information'!AB57","v":""},null,null,{"$f":"'5. Project Information'!AH59","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C70=\"Yes\",N70,0)","v":0},{"$f":"IF(C70=\"Yes\",Q70,0)","v":0},{"$f":"IF(C70=\"Yes\",W70,0)","v":""}]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B63","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X63","v":0},null,null,{"$f":"'5. Project Information'!AG63","v":0},null,null,{"$f":"'5. Project Information'!AB63","v":""},null,null,{"$f":"'5. Project Information'!AH65","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B69","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X69","v":0},null,null,{"$f":"'5. Project Information'!AG69","v":0},null,null,{"$f":"'5. Project Information'!AB69","v":""},null,null,{"$f":"'5. Project Information'!AH71","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B75","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X75","v":0},null,null,{"$f":"'5. Project Information'!AG75","v":0},null,null,{"$f":"'5. Project Information'!AB75","v":""},null,null,{"$f":"'5. Project Information'!AH77","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B81","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X81","v":0},null,null,{"$f":"'5. Project Information'!AG81","v":0},null,null,{"$f":"'5. Project Information'!AB81","v":""},null,null,{"$f":"'5. Project Information'!AH83","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B87","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X87","v":0},null,null,{"$f":"'5. Project Information'!AG87","v":0},null,null,{"$f":"'5. Project Information'!AB87","v":""},null,null,{"$f":"'5. Project Information'!AH89","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B93","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X93","v":0},null,null,{"$f":"'5. Project Information'!AG93","v":0},null,null,{"$f":"'5. Project Information'!AB93","v":""},null,null,{"$f":"'5. Project Information'!AH95","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B99","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X99","v":0},null,null,{"$f":"'5. Project Information'!AG99","v":0},null,null,{"$f":"'5. Project Information'!AB99","v":""},null,null,{"$f":"'5. Project Information'!AH101","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B105","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X105","v":0},null,null,{"$f":"'5. Project Information'!AG105","v":0},null,null,{"$f":"'5. Project Information'!AB105","v":""},null,null,{"$f":"'5. Project Information'!AH107","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B111","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X111","v":0},null,null,{"$f":"'5. Project Information'!AG111","v":0},null,null,{"$f":"'5. Project Information'!AB111","v":""},null,null,{"$f":"'5. Project Information'!AH113","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B117","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X117","v":0},null,null,{"$f":"'5. Project Information'!AG117","v":0},null,null,{"$f":"'5. Project Information'!AB117","v":""},null,null,{"$f":"'5. Project Information'!AH119","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B123","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X123","v":0},null,null,{"$f":"'5. Project Information'!AG123","v":0},null,null,{"$f":"'5. Project Information'!AB123","v":""},null,null,{"$f":"'5. Project Information'!AH125","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B129","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X129","v":0},null,null,{"$f":"'5. Project Information'!AG129","v":0},null,null,{"$f":"'5. Project Information'!AB129","v":""},null,null,{"$f":"'5. Project Information'!AH131","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B135","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X135","v":0},null,null,{"$f":"'5. Project Information'!AG135","v":0},null,null,{"$f":"'5. Project Information'!AB135","v":""},null,null,{"$f":"'5. Project Information'!AH137","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B141","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X141","v":0},null,null,{"$f":"'5. Project Information'!AG141","v":0},null,null,{"$f":"'5. Project Information'!AB141","v":""},null,null,{"$f":"'5. Project Information'!AH143","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B147","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X147","v":0},null,null,{"$f":"'5. Project Information'!AG147","v":0},null,null,{"$f":"'5. Project Information'!AB147","v":""},null,null,{"$f":"'5. Project Information'!AH149","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B153","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X153","v":0},null,null,{"$f":"'5. Project Information'!AG153","v":0},null,null,{"$f":"'5. Project Information'!AB153","v":""},null,null,{"$f":"'5. Project Information'!AH155","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B159","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X159","v":0},null,null,{"$f":"'5. Project Information'!AG159","v":0},null,null,{"$f":"'5. Project Information'!AB159","v":""},null,null,{"$f":"'5. Project Information'!AH161","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B165","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X165","v":0},null,null,{"$f":"'5. Project Information'!AG165","v":0},null,null,{"$f":"'5. Project Information'!AB165","v":""},null,null,{"$f":"'5. Project Information'!AH167","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B171","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X171","v":0},null,null,{"$f":"'5. Project Information'!AG171","v":0},null,null,{"$f":"'5. Project Information'!AB171","v":""},null,null,{"$f":"'5. Project Information'!AH173","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B177","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X177","v":0},null,null,{"$f":"'5. Project Information'!AG177","v":0},null,null,{"$f":"'5. Project Information'!AB177","v":""},null,null,{"$f":"'5. Project Information'!AH179","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B183","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X183","v":0},null,null,{"$f":"'5. Project Information'!AG183","v":0},null,null,{"$f":"'5. Project Information'!AB183","v":""},null,null,{"$f":"'5. Project Information'!AH185","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Yes",null,{"$f":"'5. Project Information'!B189","v":0},null,null,null,null,null,null,null,null,{"$f":"'5. Project Information'!X189","v":0},null,null,{"$f":"'5. Project Information'!AG189","v":0},null,null,{"$f":"'5. Project Information'!AB189","v":""},null,null,{"$f":"'5. Project Information'!AH191","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C92=\"Yes\",N92,0)","v":0},{"$f":"IF(C92=\"Yes\",Q92,0)","v":0},{"$f":"IF(C92=\"Yes\",W92,0)","v":""}]
[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,"k"]
[]
[null,"Site:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,"Est. Annual $ Savings",null,null,"Simple Payback",null,null,"EUI Reduction",null,null,"Financial Need",null,null,"Total Points"]
[null,null,"Include",null,null,null,null,null,null,null,null,null,"Site Totals:",{"$f":"_xlfn.AGGREGATE(9,5,AM98:AM121)","v":0},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AN98:AN121)","v":0},null,null,{"$f":"IFERROR(N97/Q97,\"\")","v":""},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AO98:AO121)","v":0},null,null,{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$D$97,4,FALSE)& \" Quartile\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF($T97=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$C$97,3,FALSE)+IF($W97>0.3,30,IF($W97>0.2,20,IF($W97>0.1,10,0)))+IF($T97<=5,40,IF($T97<=8,20,IF($T97<=10,10,0))))","v":""}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C98=\"Yes\",N98,0)","v":{"$error":"#REF!"}},{"$f":"IF(C98=\"Yes\",Q98,0)","v":{"$error":"#REF!"}},{"$f":"IF(C98=\"Yes\",W98,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C99=\"Yes\",N99,0)","v":{"$error":"#REF!"}},{"$f":"IF(C99=\"Yes\",Q99,0)","v":{"$error":"#REF!"}},{"$f":"IF(C99=\"Yes\",W99,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C112=\"Yes\",Q112,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C113=\"Yes\",Q113,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[null,"Site:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,"Est. Annual $ Savings",null,null,"Simple Payback",null,null,"EUI Reduction",null,null,"Financial Need",null,null,"Total Points"]
[null,null,"Include",null,null,null,null,null,null,null,null,null,"Site Totals:",{"$f":"_xlfn.AGGREGATE(9,5,AM127:AM150)","v":0},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AN127:AN150)","v":0},null,null,{"$f":"IFERROR(N126/Q126,\"\")","v":""},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AO127:AO150)","v":0},null,null,{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$D$97,4,FALSE)& \" Quartile\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF($T126=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$C$97,3,FALSE)+IF($W126>0.3,30,IF($W126>0.2,20,IF($W126>0.1,10,0)))+IF($T126<=5,40,IF($T126<=8,20,IF($T126<=10,10,0))))","v":""}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C127=\"Yes\",N127,0)","v":{"$error":"#REF!"}},{"$f":"IF(C127=\"Yes\",Q127,0)","v":{"$error":"#REF!"}},{"$f":"IF(C127=\"Yes\",W127,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C128=\"Yes\",N128,0)","v":{"$error":"#REF!"}},{"$f":"IF(C128=\"Yes\",Q128,0)","v":{"$error":"#REF!"}},{"$f":"IF(C128=\"Yes\",W128,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C141=\"Yes\",Q141,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C142=\"Yes\",Q142,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[null,"Site:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,"Est. Annual $ Savings",null,null,"Simple Payback",null,null,"EUI Reduction",null,null,"Financial Need",null,null,"Total Points"]
[null,null,"Include",null,null,null,null,null,null,null,null,null,"Site Totals:",{"$f":"_xlfn.AGGREGATE(9,5,AM156:AM179)","v":0},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AN156:AN179)","v":0},null,null,{"$f":"IFERROR(N155/Q155,\"\")","v":""},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AO156:AO179)","v":0},null,null,{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$D$97,4,FALSE)& \" Quartile\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF($T155=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$C$97,3,FALSE)+IF($W155>0.3,30,IF($W155>0.2,20,IF($W155>0.1,10,0)))+IF($T155<=5,40,IF($T155<=8,20,IF($T155<=10,10,0))))","v":""}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C156=\"Yes\",N156,0)","v":{"$error":"#REF!"}},{"$f":"IF(C156=\"Yes\",Q156,0)","v":{"$error":"#REF!"}},{"$f":"IF(C156=\"Yes\",W156,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C157=\"Yes\",N157,0)","v":{"$error":"#REF!"}},{"$f":"IF(C157=\"Yes\",Q157,0)","v":{"$error":"#REF!"}},{"$f":"IF(C157=\"Yes\",W157,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C170=\"Yes\",Q170,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C171=\"Yes\",Q171,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[null,"Site:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,"Est. Annual $ Savings",null,null,"Simple Payback",null,null,"EUI Reduction",null,null,"Financial Need",null,null,"Total Points"]
[null,null,"Include",null,null,null,null,null,null,null,null,null,"Site Totals:",{"$f":"_xlfn.AGGREGATE(9,5,AM185:AM208)","v":0},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AN185:AN208)","v":0},null,null,{"$f":"IFERROR(N184/Q184,\"\")","v":""},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AO185:AO208)","v":0},null,null,{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$D$97,4,FALSE)& \" Quartile\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF($T184=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$C$97,3,FALSE)+IF($W184>0.3,30,IF($W184>0.2,20,IF($W184>0.1,10,0)))+IF($T184<=5,40,IF($T184<=8,20,IF($T184<=10,10,0))))","v":""}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C185=\"Yes\",N185,0)","v":{"$error":"#REF!"}},{"$f":"IF(C185=\"Yes\",Q185,0)","v":{"$error":"#REF!"}},{"$f":"IF(C185=\"Yes\",W185,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C186=\"Yes\",N186,0)","v":{"$error":"#REF!"}},{"$f":"IF(C186=\"Yes\",Q186,0)","v":{"$error":"#REF!"}},{"$f":"IF(C186=\"Yes\",W186,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C199=\"Yes\",Q199,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C200=\"Yes\",Q200,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[null,"Site:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,"Est. Annual $ Savings",null,null,"Simple Payback",null,null,"EUI Reduction",null,null,"Financial Need",null,null,"Total Points"]
[null,null,"Include",null,null,null,null,null,null,null,null,null,"Site Totals:",{"$f":"_xlfn.AGGREGATE(9,5,AM214:AM237)","v":0},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AN214:AN237)","v":0},null,null,{"$f":"IFERROR(N213/Q213,\"\")","v":""},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AO214:AO237)","v":0},null,null,{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$D$97,4,FALSE)& \" Quartile\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF($T213=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$C$97,3,FALSE)+IF($W213>0.3,30,IF($W213>0.2,20,IF($W213>0.1,10,0)))+IF($T213<=5,40,IF($T213<=8,20,IF($T213<=10,10,0))))","v":""}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C214=\"Yes\",N214,0)","v":{"$error":"#REF!"}},{"$f":"IF(C214=\"Yes\",Q214,0)","v":{"$error":"#REF!"}},{"$f":"IF(C214=\"Yes\",W214,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C215=\"Yes\",N215,0)","v":{"$error":"#REF!"}},{"$f":"IF(C215=\"Yes\",Q215,0)","v":{"$error":"#REF!"}},{"$f":"IF(C215=\"Yes\",W215,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C228=\"Yes\",Q228,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C229=\"Yes\",Q229,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[null,"Site:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost",null,null,"Est. Annual $ Savings",null,null,"Simple Payback",null,null,"EUI Reduction",null,null,"Financial Need",null,null,"Total Points"]
[null,null,"Include",null,null,null,null,null,null,null,null,null,"Site Totals:",{"$f":"_xlfn.AGGREGATE(9,5,AM243:AM266)","v":0},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AN243:AN266)","v":0},null,null,{"$f":"IFERROR(N242/Q242,\"\")","v":""},null,null,{"$f":"_xlfn.AGGREGATE(9,5,AO243:AO266)","v":0},null,null,{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$D$97,4,FALSE)& \" Quartile\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF($T242=\"\",\"\",VLOOKUP(#REF!,Formula!$A$3:$C$97,3,FALSE)+IF($W242>0.3,30,IF($W242>0.2,20,IF($W242>0.1,10,0)))+IF($T242<=5,40,IF($T242<=8,20,IF($T242<=10,10,0))))","v":""}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C243=\"Yes\",N243,0)","v":{"$error":"#REF!"}},{"$f":"IF(C243=\"Yes\",Q243,0)","v":{"$error":"#REF!"}},{"$f":"IF(C243=\"Yes\",W243,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C244=\"Yes\",N244,0)","v":{"$error":"#REF!"}},{"$f":"IF(C244=\"Yes\",Q244,0)","v":{"$error":"#REF!"}},{"$f":"IF(C244=\"Yes\",W244,0)","v":{"$error":"#REF!"}}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C257=\"Yes\",Q257,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$f":"IF(C258=\"Yes\",Q258,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Yes",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[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,"k"]
[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,"k"]
[null,"Agreement & Signature (typing in signature is accepted) "]
[null,"Must agree to loan agreement terms by clicking button at top first"]
[]
[]
[]
[null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[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":"'1. Introduction'!AI66","v":"v2.18 TRM 2018"}]
[]
[]
[]
[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," "]

{"sheet":"Macros Not Enabled","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,2,8,8],[9,2,9,8],[10,2,10,8],[11,2,11,8]]}
[]
[]
[]
[]
[]
[]
[null,null,"This Application Uses Macros!"]
[]
[]
[null,null,"Macros are currently not enabled in Excel."]
[null,null,"Please enable macros/content to use the EESI Application."]

{"sheet":"7. Loan Agreement","index":7,"n_rows":11,"n_cols":52,"rows_kept":11,"cut":false,"hidden":true,"merged":[[6,4,8,13],[10,0,10,14],[11,0,11,14]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[]
[]
[]
[null,null,"Initials",null,"I have read, understand, and agree to the Energy Efficient Schools Initiative Loan Rules below and am confirming by putting my initials in the box to the left."]
[]
[]
[]
["To read the document below, double-click on the box and then scroll to read in its entirity. Once you are finished double click anywhere else on page:"]

{"sheet":"Project Information Template","index":8,"n_rows":195,"n_cols":49,"rows_kept":195,"cut":false,"hidden":true,"merged":[[190,11,190,27],[190,33,190,34],[184,11,184,27],[184,33,184,34],[188,1,188,9],[188,11,188,13],[188,15,188,17],[188,19,188,21],[188,23,188,25],[188,27,188,30],[188,32,188,34],[178,11,178,27],[178,33,178,34],[182,1,182,9],[182,11,182,13],[182,15,182,17],[182,19,182,21],[182,23,182,25],[182,27,182,30],[182,32,182,34],[172,11,172,27],[172,33,172,34],[176,1,176,9],[176,11,176,13],[176,15,176,17],[176,19,176,21],[176,23,176,25],[176,27,176,30],[176,32,176,34],[166,11,166,27],[166,33,166,34],[170,1,170,9],[170,11,170,13],[170,15,170,17],[170,19,170,21],[170,23,170,25],[170,27,170,30],[170,32,170,34],[160,11,160,27],[160,33,160,34],[164,1,164,9],[164,11,164,13],[164,15,164,17],[164,19,164,21],[164,23,164,25],[164,27,164,30],[164,32,164,34],[154,11,154,27],[154,33,154,34],[158,1,158,9],[158,11,158,13],[158,15,158,17],[158,19,158,21],[158,23,158,25],[158,27,158,30],[158,32,158,34],[148,11,148,27],[148,33,148,34],[152,1,152,9],[152,11,152,13],[152,15,152,17],[152,19,152,21],[152,23,152,25],[152,27,152,30],[152,32,152,34],[142,11,142,27],[142,33,142,34],[146,1,146,9],[146,11,146,13],[146,15,146,17],[146,19,146,21],[146,23,146,25],[146,27,146,30],[146,32,146,34],[136,11,136,27],[136,33,136,34],[140,1,140,9],[140,11,140,13],[140,15,140,17],[140,19,140,21],[140,23,140,25],[140,27,140,30],[140,32,140,34],[130,11,130,27],[130,33,130,34],[134,1,134,9],[134,11,134,13],[134,15,134,17],[134,19,134,21],[134,23,134,25],[134,27,134,30],[134,32,134,34],[124,11,124,27],[124,33,124,34],[128,1,128,9],[128,11,128,13],[128,15,128,17],[128,19,128,21],[128,23,128,25],[128,27,128,30],[128,32,128,34],[118,11,118,27],[118,33,118,34],[122,1,122,9],[122,11,122,13],[122,15,122,17],[122,19,122,21],[122,23,122,25],[122,27,122,30],[122,32,122,34],[112,11,112,27],[112,33,112,34],[116,1,116,9],[116,11,116,13],[116,15,116,17],[116,19,116,21],[116,23,116,25],[116,27,116,30],[116,32,116,34],[106,11,106,27],[106,33,106,34],[110,1,110,9],[110,11,110,13],[110,15,110,17],[110,19,110,21],[110,23,110,25],[110,27,110,30],[110,32,110,34],[100,11,100,27],[100,33,100,34],[104,1,104,9],[104,11,104,13],[104,15,104,17],[104,19,104,21],[104,23,104,25],[104,27,104,30],[104,32,104,34],[94,11,94,27],[94,33,94,34],[98,1,98,9],[98,11,98,13],[98,15,98,17],[98,19,98,21],[98,23,98,25],[98,27,98,30],[98,32,98,34],[88,11,88,27],[88,33,88,34],[92,1,92,9],[92,11,92,13],[92,15,92,17],[92,19,92,21],[92,23,92,25],[92,27,92,30],[92,32,92,34],[82,11,82,27],[82,33,82,34],[86,1,86,9],[86,11,86,13],[86,15,86,17],[86,19,86,21],[86,23,86,25],[86,27,86,30],[86,32,86,34],[76,11,76,27],[76,33,76,34],[80,1,80,9],[80,11,80,13],[80,15,80,17],[80,19,80,21],[80,23,80,25],[80,27,80,30],[80,32,80,34],[70,11,70,27],[70,33,70,34],[74,1,74,9],[74,11,74,13],[74,15,74,17],[74,19,74,21],[74,23,74,25],[74,27,74,30],[74,32,74,34],[64,11,64,27],[64,33,64,34],[68,1,68,9],[68,11,68,13],[68,15,68,17],[68,19,68,21],[68,23,68,25],[68,27,68,30],[68,32,68,34],[58,11,58,27],[58,33,58,34],[62,1,62,9],[62,11,62,13],[62,15,62,17],[62,19,62,21],[62,23,62,25],[62,27,62,30],[62,32,62,34],[52,11,52,27],[52,33,52,34],[56,1,56,9],[56,11,56,13],[56,15,56,17],[56,19,56,21],[56,23,56,25],[56,27,56,30],[56,32,56,34],[43,16,46,34],[46,1,46,3],[50,1,50,9],[50,11,50,13],[50,15,50,17],[50,19,50,21],[50,23,50,25],[50,27,50,30],[50,32,50,34],[39,27,39,29],[40,2,40,7],[40,8,40,10],[40,11,40,13],[40,14,40,16],[40,17,40,19],[40,20,40,22],[39,1,39,7],[39,8,39,10],[39,11,39,13],[39,14,39,16],[39,17,39,19],[39,20,39,22],[38,8,38,10],[38,11,38,13],[38,14,38,16],[38,17,38,19],[38,20,38,22],[38,26,38,30],[32,1,32,5],[33,1,33,5],[36,17,37,19],[36,20,37,22],[37,8,37,10],[37,11,37,13],[37,14,37,16],[23,1,23,6],[24,1,24,9],[24,11,24,18],[24,20,24,27],[24,29,24,34],[30,8,30,11],[30,20,30,28],[14,19,14,20],[14,26,16,34],[16,21,16,22],[18,12,18,13],[20,1,20,7],[21,1,21,27]]}
[]
[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,null,null,null,null,null,7,null,null,null,null,null,"ECMs"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Lighting Systems"]
[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,null,null,null,null,null,null,null,null,null,null,null,"HVAC Equipment"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Retro-Commissioning (RCx)"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Energy Management Systems (EMS)"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Equipment Controls"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Pumps And Motors"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[]
[]
[]
[null,"PROJECT SITE INFORMATION"]
[]
[null,"Is the Project Site Information same as the School District Mailing Address? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*The Project Site is the facility at which the efficiency upgrades will take place."]
[]
[null,"Is the Project Site Information entered into the ENERGY STAR Portfolio Manager Tool?"]
[]
[null,"Are you tracking your energy usage and cost",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,null,"ENERGYSTAR Portfolio"]
[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,null,null,null,"Yes"]
[null,"Project Site Address *",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,null,"No"]
[null,{"$f":"IF(T15=\"Yes\",'4. Contact Information'!B19:AI19,\"\")","v":""}]
[]
[null,"City *",null,null,null,null,null,null,null,null,null,"State *",null,null,null,null,null,null,null,null,"Zip Code *",null,null,null,null,null,null,null,null,"County *"]
[null,{"$f":"IF(T15=\"Yes\",'4. Contact Information'!B22,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(T15=\"yes\",'4. Contact Information'!Q22,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(T15=\"Yes\",'4. Contact Information'!Z22,\"\")","v":""}]
[]
[null,"SCHOOL BUILDING AND ENVELOPE CHARACTERISTICS"]
[]
[null,"Primary Function"]
[]
[null,null,"Elementary School",null,null,null,null,null,"Middle School",null,null,null,null,"High School",null,null,null,null,"Other "]
[]
[null,"Square Footage *"]
[]
[]
[null,"ANNUAL ENERGY BILL INFORMATION (12 months) *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Annual Cost",null,null,"EUI"]
[null,null,null,null,null,null,null,null,"Annual Usage",null,null,"Unit",null,null,"Cost / Unit"]
[null,null,null,null,null,null,null," Electricity Use (kWh)",null,null,null,"kWh",null,null,null,null,null,{"$f":"IF(OR(ISBLANK(I39),ISBLANK(O39)),\"\",I39*O39)","v":""},null,null,{"$f":"IFERROR(IF(OR(ISBLANK(I39),ISBLANK(B34)),\"\",VLOOKUP(L39,$AU$40:$AV$40,2,FALSE)*I39/1000/$B$34),\"Need Unit\")","v":""},null,null,null,null,null,"Facility EUI",null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas","btu","source","Propane","btu","source","Electricity","btu","source"]
[null,"Natural Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(I40),ISBLANK(O40)),\"\",I40*O40)","v":""},null,null,{"$f":"IFERROR(IF(OR(ISBLANK(I40),ISBLANK(B34)),\"\",VLOOKUP(L40,$AO$40:$AP$44,2,FALSE)*I40/1000/$B$34),\"Need Unit\")","v":""},null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,6,U39:W41)","v":0},null,null,"Kbtu/sqft",null,null,null,null,null,null,null,null,null,"btu",1,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8","cf",2488,"http://www.npga.org/files/public/Facts_About_Propane.pdf","kWh",3414,"http://www.eia.gov/totalenergy/data/monthly/pdf/sec13_6.pdf"]
[null,null,"Propane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(I41),ISBLANK(O41)),\"\",I41*O41)","v":""},null,null,{"$f":"IFERROR(IF(OR(ISBLANK(I41),ISBLANK(B34)),\"\",VLOOKUP(L41,$AR$40:$AS$42,2,FALSE)*I41/1000/$B$34),\"Need Unit\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cubic feet",1028,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8","pounds",21548,"http://www.npga.org/files/public/Facts_About_Propane.pdf"]
[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,null,null,null,"Ccf",102800,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8","gallons",91502]
[null,"ENERGY CONSERVATION MEASURES (ECMs)",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,null,"Mcf",1028000,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Engineering calculations are required to validate the energy savings associated with each ECM.  If engineering support is needed to determine the energy savings for the application, contact Paul Cross at 615-532-9643",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"therms",100000,"http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8"]
[null,"How many ECMs are you installing? *"]
[]
[null,1]
[]
[null,"ECM 1 *",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings *               ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost *",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X51/AG51,\"\")","v":""},null,null,null,null,{"$f":"L51*$O$39+P51*$O$40+T51*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG51=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L51/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG51=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P51/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG51=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T51/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 2",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X57/AG57,\"\")","v":""},null,null,null,null,{"$f":"L57*$O$39+P57*$O$40+T57*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG57=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L57/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG57=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P57/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG57=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T57/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 3",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X63/AG63,\"\")","v":""},null,null,null,null,{"$f":"L63*$O$39+P63*$O$40+T63*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG63=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L63/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG63=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P63/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG63=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T63/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 4",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X69/AG69,\"\")","v":""},null,null,null,null,{"$f":"L69*$O$39+P69*$O$40+T69*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG69=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L69/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG69=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P69/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG69=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T69/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 5",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X75/AG75,\"\")","v":""},null,null,null,null,{"$f":"L75*$O$39+P75*$O$40+T75*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG75=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L75/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG75=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P75/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG75=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T75/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 6",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X81/AG81,\"\")","v":""},null,null,null,null,{"$f":"L81*$O$39+P81*$O$40+T81*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG81=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L81/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG81=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P81/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG81=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T81/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 7",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X87/AG87,\"\")","v":""},null,null,null,null,{"$f":"L87*$O$39+P87*$O$40+T87*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG87=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L87/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG87=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P87/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG87=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T87/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 8",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X93/AG93,\"\")","v":""},null,null,null,null,{"$f":"L93*$O$39+P93*$O$40+T93*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG93=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L93/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG93=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P93/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG93=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T93/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 9",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X99/AG99,\"\")","v":""},null,null,null,null,{"$f":"L99*$O$39+P99*$O$40+T99*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG99=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L99/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG99=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P99/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG99=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T99/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 10",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X105/AG105,\"\")","v":""},null,null,null,null,{"$f":"L105*$O$39+P105*$O$40+T105*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG105=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L105/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG105=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P105/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG105=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T105/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 11",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X111/AG111,\"\")","v":""},null,null,null,null,{"$f":"L111*$O$39+P111*$O$40+T111*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG111=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L111/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG111=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P111/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG111=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T111/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 12",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X117/AG117,\"\")","v":""},null,null,null,null,{"$f":"L117*$O$39+P117*$O$40+T117*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG117=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L117/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG117=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P117/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG117=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T117/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 13",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X123/AG123,\"\")","v":""},null,null,null,null,{"$f":"L123*$O$39+P123*$O$40+T123*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG123=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L123/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG123=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P123/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG123=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T123/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 14",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X129/AG129,\"\")","v":""},null,null,null,null,{"$f":"L129*$O$39+P129*$O$40+T129*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG129=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L129/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG129=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P129/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG129=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T129/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 15",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X135/AG135,\"\")","v":""},null,null,null,null,{"$f":"L135*$O$39+P135*$O$40+T135*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG135=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L135/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG135=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P135/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG135=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T135/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 16",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X141/AG141,\"\")","v":""},null,null,null,null,{"$f":"L141*$O$39+P141*$O$40+T141*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG141=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L141/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG141=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P141/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG141=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T141/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 17",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X147/AG147,\"\")","v":""},null,null,null,null,{"$f":"L147*$O$39+P147*$O$40+T147*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG147=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L147/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG147=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P147/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG147=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T147/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 18",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X153/AG153,\"\")","v":""},null,null,null,null,{"$f":"L153*$O$39+P153*$O$40+T153*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG153=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L153/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG153=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P153/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG153=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T153/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 19",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X159/AG159,\"\")","v":""},null,null,null,null,{"$f":"L159*$O$39+P159*$O$40+T159*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG159=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L159/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG159=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P159/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG159=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T159/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 20",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X165/AG165,\"\")","v":""},null,null,null,null,{"$f":"L165*$O$39+P165*$O$40+T165*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG165=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L165/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG165=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P165/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG165=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T165/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 21",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X171/AG171,\"\")","v":""},null,null,null,null,{"$f":"L171*$O$39+P171*$O$40+T171*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG171=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L171/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG171=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P171/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG171=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T171/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 22",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X177/AG177,\"\")","v":""},null,null,null,null,{"$f":"L177*$O$39+P177*$O$40+T177*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG177=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L177/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG177=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P177/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG177=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T177/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 23",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X183/AG183,\"\")","v":""},null,null,null,null,{"$f":"L183*$O$39+P183*$O$40+T183*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG183=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L183/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG183=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P183/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG183=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T183/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[null,"ECM 24",null,null,null,null,null,null,null,null,null,"Estimated Annual Energy Savings                      ",null,null,null,null,null,null,null,null,null,null,null,"Total Cost ",null,null,null,"Estimated ",null,null,null,null,"Est. Annual"]
[null,null,null,null,null,null,null,null,null,null,null,"Electricity",null,null,null,"Natural Gas",null,null,null,"Propane",null,null,null,"(materials & labor)",null,null,null,"Payback (years)",null,null,null,null,"$ 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,{"$f":"IFERROR(X189/AG189,\"\")","v":""},null,null,null,null,{"$f":"L189*$O$39+P189*$O$40+T189*$O$41","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI Reduction",null,{"$f":"IFERROR((((IF(OR(ISBLANK($L$39),ISBLANK($B$34),AG189=\"\"),0,VLOOKUP($L$39,$AU$40:$AV$40,2,FALSE)*L189/1000)+IF(OR(ISBLANK($L$40),ISBLANK($B$34),AG189=\"\"),0,VLOOKUP($L$40,$AO$40:$AP$44,2,FALSE)*P189/1000)+IF(OR(ISBLANK($L$41),ISBLANK($B$34),AG189=\"\"),0,VLOOKUP($L$41,$AR$40:$AS$42,2,FALSE)*T189/1000))/$B$34))/$AB$40,\"\")","v":""}]
[]
[]
[]
[null,"To access TVA's Technical Resource Manual for guidance in determining energy savings click here:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRM",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1. Introduction'!AI66","v":"v2.18 TRM 2018"}]

{"sheet":"Formula","index":9,"n_rows":97,"n_cols":4,"rows_kept":97,"cut":false,"hidden":true,"merged":[]}
["Password:","EESItva1!"]
["County","Tier","Points","Quartile"]
["Anderson County",1,0,{"$f":"IF(B3=1,4&\"th\",IF(B3=2,3&\"rd\",IF(B3=3,2&\"nd\",1&\"st\")))","v":"4th"}]
["Bedford County",2,0,{"$f":"IF(B4=1,4&\"th\",IF(B4=2,3&\"rd\",IF(B4=3,2&\"nd\",1&\"st\")))","v":"3rd"}]
["Benton County",3,15,"2nd"]
["Bledsoe County",4,30,"1st"]
["Blount County",1,0,"4th"]
["Bradley County",2,0,"3rd"]
["Campbell County",4,30,"1st"]
["Cannon County",2,0,"3rd"]
["Carroll County",3,15,"2nd"]
["Carter County",3,15,"2nd"]
["Cheatham County",1,0,"4th"]
["Chester County",2,0,"3rd"]
["Claiborne County",4,30,"1st"]
["Clay County",3,15,"2nd"]
["Cocke County",4,30,"1st"]
["Coffee County",2,0,"3rd"]
["Crockett County",2,0,"3rd"]
["Cumberland County",2,0,"3rd"]
["Davidson County",1,0,"4th"]
["Decatur County",3,15,"2nd"]
["DeKalb County",2,0,"3rd"]
["Dickson County",2,0,"3rd"]
["Dyer County",2,0,"3rd"]
["Fayette County",1,0,"4th"]
["Fentress County",4,30,"1st"]
["Franklin County",2,0,"3rd"]
["Gibson County",2,0,"3rd"]
["Giles County",2,0,"3rd"]
["Grainger County",3,15,"2nd"]
["Greene County",3,15,"2nd"]
["Grundy County",4,30,"1st"]
["Hamblen County",2,0,"3rd"]
["Hamilton County",1,0,"4th"]
["Hancock County",4,30,"1st"]
["Hardeman County",4,30,"1st"]
["Hardin County",3,15,"2nd"]
["Hawkins County",2,0,"3rd"]
["Haywood County",3,15,"2nd"]
["Henderson County",3,15,"2nd"]
["Henry County",2,0,"3rd"]
["Hickman County",3,15,"2nd"]
["Houston County",3,15,"2nd"]
["Humphreys County",2,0,"3rd"]
["Jackson County",3,15,"2nd"]
["Jefferson County",2,0,"3rd"]
["Johnson County",4,30,"1st"]
["Knox County",1,0,"4th"]
["Lake County",4,30,"1st"]
["Lauderdale County",4,30,"1st"]
["Lawrence County",3,15,"2nd"]
["Lewis County",4,30,"1st"]
["Lincoln County",1,0,"4th"]
["Loudon County",1,0,"4th"]
["Macon County",2,0,"3rd"]
["Madison County",2,0,"3rd"]
["Marion County",2,0,"3rd"]
["Marshall County",2,0,"3rd"]
["Maury County",2,0,"3rd"]
["McMinn County",2,0,"3rd"]
["McNairy County",4,30,"1st"]
["Meigs County",3,15,"2nd"]
["Monroe County",3,15,"2nd"]
["Montgomery County",1,0,"4th"]
["Moore County",1,0,"4th"]
["Morgan County",4,30,"1st"]
["Obion County",2,0,{"$f":"IF(B68=1,4&\"th\",IF(B68=2,3&\"rd\",IF(B68=3,2&\"nd\",1&\"st\")))","v":"3rd"}]
["Overton County",3,15,"2nd"]
["Perry County",4,30,"1st"]
["Pickett County",4,30,"1st"]
["Polk County",2,0,"3rd"]
["Putnam County",2,0,"3rd"]
["Rhea County",4,30,"1st"]
["Roane County",1,0,"4th"]
["Robertson County",1,0,"4th"]
["Rutherford County",1,0,"4th"]
["Scott County",4,30,"1st"]
["Sequatchie County",2,0,"3rd"]
["Sevier County",1,0,"4th"]
["Shelby County",1,0,"4th"]
["Smith County",2,0,"3rd"]
["Stewart County",2,0,"3rd"]
["Sullivan County",1,0,"4th"]
["Sumner County",1,0,"4th"]
["Tipton County",1,0,"4th"]
["Trousdale County",1,0,"4th"]
["Unicoi County",3,15,"2nd"]
["Union County",3,15,"2nd"]
["Van Buren County",4,30,"1st"]
["Warren County",3,15,"2nd"]
["Washington County",1,0,"4th"]
["Wayne County",4,30,"1st"]
["Weakley County",3,15,"2nd"]
["White County",4,30,"1st"]
["Williamson County",1,0,"4th"]
["Wilson County",1,0,"4th"]