{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Enabling Form Macros","Instructions","Requirements for Participation","Application Authorization Form","Fuel Use Summary (Consolidate)","Lighting","HVAC - Cooling Plant","HVAC - Heating Plant","Insulation","Windows Replacement","Dishwasher - Energy Star","Pipe Insulation-Gas","Pipe Insulation-Electric","Dishwasher Calcs","Dishwasher - Other","Motor Upgrade","Thermostat","Windows U-Value","Fuel Use Summary (2)","Fuel Use Summary (3)","Fuel Use Summary (4)","Fuel Use Summary (5)","Fuel Use Summary (6)","Fuel Use Summary (7)","Fuel Use Summary (8)","Fuel Use Summary (9)","Fuel Use Summary (10)","Sheet1","Fuel Use Summary","ECM Summary","DNR-DE STAFF ONLY"],"not_rendered":{"charts":0,"images":34,"macros":1,"external_links":1,"defined_names":28,"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":"Enabling Form Macros","index":0,"n_rows":64,"n_cols":3,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ENABLING FORM MACROS"]
[null,"Microsoft recently changed the default behavior of their Office applications to block macros in files downloaded from the "]
[null,"internet. Depending on your security settings, you may receive different warning messages with this application."]
[]
[null,"Scenario 1: When opening this application file for the first time, you may get the following warning:"]
[]
[]
[]
[null,null,"If you want more information, click the link in the message. To proceed, click “Enable Content”."]
[]
[null,null,"If you then receive the following message, choose “Yes” and the application can be completed with macros enabled."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Scenario 2: If you get the following message, your security settings are higher:"]
[null," "]
[]
[]
[null,null,"To proceed, you will need to close the downloaded file, right click on the file (in the folder where you saved it), "]
[null,null,"choose “Properties”, select the “Unblock” checkbox (on the “General” tab, as shown below), then select “Apply”."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"When you open the application document. You should get the following message. Click “Enable Content”."]
[]
[]
[]
[null,null,"If you then get the following message, Select “Yes” and the application can be completed with macros enabled."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In either scenario, be sure to save the file with macros enabled, especially if you do not plan to complete it right away. If "]
[null,"you need additional assistance, please contact us at energy@dnr.mo.gov or 855-522-2796."]

{"sheet":"Instructions","index":1,"n_rows":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":false,"merged":[[48,2,48,13],[50,2,50,13],[52,2,52,13],[36,2,36,13],[38,2,38,13],[40,2,40,13],[42,2,42,13],[44,2,44,13],[77,2,77,13],[13,2,13,13],[76,2,76,12],[8,2,8,13],[56,2,57,13],[75,2,75,13],[18,2,18,14],[20,1,20,14],[22,2,22,13],[24,2,24,13],[26,2,26,13],[28,2,28,13],[30,2,30,13],[32,2,32,13],[34,2,34,13],[46,2,46,13]]}
[]
[null,"APPLICATION INSTRUCTIONS"]
[]
[null,null,"You can navigate through this application by clicking the tabs at the bottom of the page as shown below."]
[]
[]
[]
[]
[null,null,"Please read the instructions below on how to use the Energy Loan Program (ELP) application."]
[]
[null,null,"Step 1: Refer to our webpage for detailed requirements for participation."]
[null,null,"Step 2: Complete the Application Authorization form."]
[null,null,"Step 3: Complete the Fuel Use Summary form."]
[null,null,"Step 4: Complete the Energy Conservation Measure (ECM) worksheet(s) below for your project(s) to calculate the savings."]
[null,null,"Step 5: Complete the ECM Summary form."]
[null,null,"Step 6: Copy or scan the most recent 12 months utility bills to include with application."]
[null,null,"Step 7: Submit the application as stated on our webpage."]
[]
[null,null,"Please contact us at 855-522-2796 or energyloanprogram@dnr.mo.gov for assistance."]
[]
[null,"ECM WORKSHEET DESCRIPTIONS"]
[]
[null,null,"The ECM Worksheets are a set of worksheets to qualify ECMs for funding approval that have been proven cost-effective over time and, generally, do not require a more comprehensive analysis. "]
[]
[null,null,"For the ELP Application, at minimum, the following items must be submitted: Application Authorization form, Fuel Use Summary, most recent 12 months utility bills, ECM Summary and applicable ECM Worksheets."]
[]
[null,null,"Hand calculations or spreadsheets for simple ECMs may be accepted on a case-by-case basis.  Modeling is not required when ECM Worksheets are appropriate."]
[]
[null,null,"ECM worksheets provide line-by-line instructions to assist in their completion. The following is a brief description for each worksheet: "]
[]
[null,null,"·  The Motor Upgrade worksheet is used to estimate energy savings for more efficient motor replacement. The worksheet is only applicable to constant load and same size motors. The worksheet is not applicable to pulsating loads, VFDs, random loads or loads that cycle at rapidly repeating intervals. "]
[]
[null,null,"·  The Wall or Ceiling Insulation worksheet is used to estimate the savings for an area to be insulated that has a uniform R-value over the entire area and in which the R-value to be added will be applied uniformly over this same area.  If the R-value is not the same in all areas of the building or different R-values will be added to separate areas of the building, a worksheet must be used for each of the individual areas."]
[]
[null,null,"·  The Pipe Insulation worksheets (Natural Gas and Electric) are used to estimate the savings for insulating heating pipes that serve radiators or fan coil units.  Furnace rooms, crawlspaces, unheated areas and overheated rooms are typical for effective insulation applications.  A Heat Loss Factor Table follows the Pipe Insulation worksheet for reference. To use the worksheet, the heating and cooling distribution pipe must be in an area of constant temperature. The pipe distribution must be indoors."]
[]
[null,null,"·  The Programmable Setback Thermostat worksheet is used to estimate the savings as a result of setting the heating thermostat to a lower value during a building’s unoccupied hours."]
[]
[null,null,"·  The Lighting worksheet is used to estimate the savings from a reduction in the number of lamps, lamp or ballast wattage, hours of use per year or a change to new efficient fixtures."]
[]
[null,null,"·  The Windows worksheet is used to estimate the savings from replacing inefficient windows with more efficient models or for the addition of storm windows. The worksheet is also used to estimate the savings from windows reduction. Reduced infiltration and improved U-values are included in the worksheet’s computation method."]
[]
[null,null,"·  The  HVAC - Heating worksheet is used to estimate the savings when installing a new more efficient furnace or boiler or when changing the energy sources used for heating. ECMs that reduce the overall heat load, such as insulation or window replacement, should be considered in conjunction with heating plant replacement. Efficiency of an old heating plant is assumed at 65% unless field-tested."]
[]
[null,null,"·  The HVAC - Cooling worksheet is used to estimate the savings when installing new more efficient cooling units or when changing the energy sources used for cooling. ECMs that reduce the overall cooling load, such as insulation or window replacement, should be considered in conjunction with cooling plant replacement."]
[]
[null,null,"·  The Dishwasher - Energy Star® Upgrade worksheet is used to estimate savings when upgrading from a conventional dishwasher model to an ENERGY STAR® model. The worksheet is applicable for commercial-grade dishwashers with standard commercial rack size only. The worksheet is not applicable to residential units."]
[]
[null,null,"·  The Dishwasher - Other worksheet is used to estimate savings when upgrading to dishwashers that are not rated by ENERGY STAR®. The worksheet is applicable for commercial-grade dishwashers with standard commercial rack size, only. The worksheet is not applicable to residential units."]
[]
[null,null,"Vendor/Contractor quotes or other cost estimates can be used as a basis for ECM costs. Vendors/Contractors may assist in the completion of the worksheets. The worksheets are designed to provide conservative estimates of savings using a generalized computation approach."]
[]
[null,null,"The Department may request additional information, as needed, to determine the proposed project’s feasibility and estimated energy savings."]
[]
[null,"ECM WORKSHEETS"]
[]
[null,null,"To add worksheets, please click on the appropriate project button below. To add additional worksheets for the same project, simply repeat click the worksheet button.  The worksheets (and tabs) will be created and can be browsed by clicking the tabs at the bottom of the page. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"*Hand calculation friendly"]
[]
[]
[]
[]
[null,null,"Requirements:\nBy completing and signing this loan application, you have agreed to abide by all requirements of the Energy Loan Program. \n\n\n\n"]
[]
[null,null,"If the applicant provides any personal information as defined in §105.1500, RSMo concerning an entity exempt from federal income tax under Section 501(c) of the Internal Revenue Code of 1986, as amended, the applicant understands and agrees that it is voluntarily choosing to seek funding and providing such information for that purpose.  The state will treat such personal information in accordance with §105.1500, RSMo."]
[null,"MO 780-3070 (12-24)"]

{"sheet":"Requirements for Participation","index":2,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,1,28,3],[26,2,26,8],[24,2,24,13],[20,2,20,13],[4,2,4,13],[16,2,16,13],[13,2,14,13],[8,2,8,13],[12,2,12,13]]}
[]
[]
[null,"NOTICE OF FUNDING OPPORTUNITY"]
[]
[null,null,"Please refer to the website for notice of funding opportunity and detailed information regarding this loan offering."]
[]
[null,"ELIGIBLE ENTITIES - FY2025 CYCLE"]
[]
[null,null,"Public Schools (K-12)\nPublic Higher Education Institutions\nLocal Governments"]
[]
[null,"TERMS - FY2025 CYCLE"]
[]
[null,null,"The interest rate for this FY2025 cycle is 2.5% with a 1% administration fee."]
[null,null," Applications will be accepted for projects over $10,000 and up to $5,000,000."]
[]
[]
[null,null,"Loans (including interest and fees) are repaid within a 10-year period or less. Loans will not be made that have a payback period of less than six months."]
[]
[null,"SELECTION CRITERIA - FY2025 CYCLE"]
[]
[null,null,"Recipients of loan financing will be determined on a first-come, first-served basis from December 2, 2024 to March 31, 2025, or until all funds are obligated--whichever comes first. Applications will be marked as officially received on the date all information needed to determine the feasibility of the project is received."]
[]
[null,"FOR ASSISTANCE"]
[]
[null,null,"We are available to answer questions about the application process and technical requirements for submission of a loan application:"]
[null,null,"Telephone: 855-522-2796"]
[null,null,"dnr.mo.gov/energy/grants-loans/loan-program"]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Application Authorization Form","index":3,"n_rows":74,"n_cols":15,"rows_kept":74,"cut":false,"hidden":false,"merged":[[49,2,49,12],[52,2,52,12],[63,2,63,12],[51,2,51,12],[55,2,55,12],[61,2,61,12],[62,2,62,12],[13,1,13,5],[13,6,13,8],[14,6,14,8],[38,1,38,13],[36,1,36,11],[37,1,37,11],[33,7,33,13],[29,5,29,7],[19,1,19,13],[26,1,27,4],[28,1,29,4],[25,10,25,13],[22,1,23,4],[24,1,25,4],[25,5,25,7],[27,10,27,13],[11,6,11,8],[12,6,12,8],[14,1,14,5],[25,8,25,9],[2,9,2,13],[4,9,4,13],[10,1,10,5],[10,6,10,8],[10,9,10,13],[6,1,6,8],[6,9,6,13],[8,8,8,13],[8,1,8,7],[7,1,7,7],[12,1,12,5],[16,9,16,13],[71,2,71,5],[12,9,12,13],[14,9,14,13],[23,8,23,9],[23,10,23,13],[29,8,29,9],[18,1,18,8],[18,9,18,13],[21,1,21,4],[21,5,21,8],[21,9,21,13],[29,10,29,13],[23,5,23,7],[16,5,16,8],[27,5,27,7],[27,8,27,9],[39,1,39,13],[43,1,43,5],[35,1,35,11],[34,1,34,13],[31,1,31,13],[43,6,43,9],[43,10,43,13]]}
[]
[null,"SECTOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                      "]
[null,"HOW DID YOU FIND US? (CHECK ALL THAT APPLY)"]
[]
[null,"ORGANIZATION NAME",null,null,null,null,null,null,null,"FEDERAL TAX ID (EIN) NUMBER"]
[]
[null,"NUMBER OF PEOPLE (students, staff, patients, customers, general public)  THAT WOULD BENEFIT FROM THE IMPLEMENTATION OF THIS ENERGY PROJECT",null,null,null,null,null,null,"MAILING ADDRESS (HEADQUARTERS)"]
[]
[null,"COUNTY",null,null,null,null,"CITY",null,null,"ZIP+4"]
[]
[null,"CONTACT NAME",null,null,null,null,"TITLE",null,null,"TELEPHONE NUMBER WITH AREA CODE "]
[]
[null,"EMAIL ADDRESS",null,null,null,null,"TOTAL PROPOSED PROJECT COST",null,null,"TOTAL LOAN AMOUNT REQUESTED"]
[]
[null,"PROJECT TYPE",null,null,null,"ESTIMATED START DATE",null,null,null,"ESTIMATED PROJECT COMPLETION DATE"]
[]
[null,"PROJECT LOCATION (ATTACH LIST OR MAP FOR MULTIPLE LOCATIONS)",null,null,null,null,null,null,null,"ESTIMATED ANNUAL ENERGY COST SAVINGS"]
[]
[null,"BUILDING SPECIFIC INFORMATION--FOR MULTIPLE BUILDINGS, USE ADDITIONAL PAGES AND INCLUDE ALL INFORMATION LISTED BELOW"]
[null,"TOTAL BUILDING AREA IN SQUARE FEET",null,null,null,"TOTAL AFFECTED BUILDING AREA IN SQUARE FEET",null,null,null,"APPROXIMATE NO. OF BUILDING OCCUPANTS"]
[]
[null,"FOR ORIGINAL BUILDING",null,null,null,"YEAR OF CONSTRUCTION",null,null,"HEATED AREA IN SQUARE FEET",null,"COOLED AREA IN SQUARE FEET"]
[]
[null,"FOR ADDITION #1",null,null,null,"YEAR OF CONSTRUCTION",null,null,"HEATED AREA IN SQUARE FEET",null,"COOLED AREA IN SQUARE FEET"]
[]
[null,"FOR ADDITION #2",null,null,null,"YEAR OF CONSTRUCTION",null,null,"HEATED AREA IN SQUARE FEET",null,"COOLED AREA IN SQUARE FEET"]
[]
[null,"FOR ADDITION #3",null,null,null,"YEAR OF CONSTRUCTION",null,null,"HEATED AREA IN SQUARE FEET",null,"COOLED AREA IN SQUARE FEET"]
[]
[null,"ENERGY ANALYST OR OTHER WHO PREPARED ENERGY SAVINGS CALCULATIONS--INCLUDE NAME, TITLE, COMPANY AND TELEPHONE NUMBER  "]
[]
[null,"BUSINESS TYPE NAMED ABOVE"]
[]
[null,"OPTIONAL QUESTIONS REGARDING MILITARY SERVICE"]
[null,"1. Have you ever served on active duty in the Armed Forces of the United States and separated from such service under conditions other than dishonorable?"]
[null,"2. Would you like to receive information and assistance regarding veterans benefits and services?"]
[null,"3. May the agency share your contact information with the Missouri Veterans Commission to provide such information?"]
[null,"AUTHORIZATION"]
[null,"The governing board or body has reviewed the ECM Summary and agrees that the building or system information is correct and the project and associated energy conservation measures have been correctly described. Any scanned or photocopied version of the signed original Application Authorization Form shall be considered original, and the governing board or body hereby waives any applicable objection on this basis. The governing board or body authorizes the contact person, named above, to provide any additional information relevant to the review and/or approval of this application. By signing this form, you agree to all requirements of the Energy Loan Program."]
[null,"The building, facility or system is owned and operated by the applicant. "]
[null,"Is the completion of this project contingent on Energy Loan Program financing? "]
[null,"PRINT NAME AND TITLE OF AUTHORIZED OFFICIAL",null,null,null,null,"SIGNATURE OF AUTHORIZED OFFICIAL",null,null,null,"DATE"]
[]
[]
[]
[null,"AUTHORIZATION FORM INSTRUCTIONS"]
[]
[]
[null,null,"Below are instructions for selected Application Authorization form fields."]
[null,null,"Enter the information for the organization’s administrative office location."]
[null,null,"Enter the contact person’s information. The contact person is the individual who can answer the majority of the questions related to this application."]
[null,null,"Enter the total project cost for all energy conservation measures. This can include reasonable fees for design and commissioning."]
[null,null,"Select the project type. If selecting “System,” give a short description, such as motors or traffic signals."]
[null,null,"Enter the planned start and completion dates of construction activities."]
[null,null,"Some projects may include several building and/or system locations. Enter the total number of buildings or locations that will be directly affected by the proposed project. If a list or map is needed, enter “see attached.”"]
[null,null,"Enter the estimated annual energy cost savings calculated on the Energy Conservation Measure (ECM) Summary."]
[null,null,"Enter the total area of the building that is served by the utility meters on the Fuel Use Summary."]
[null,null,"Enter the area of the building that will be affected by energy conservation measures."]
[null,null,"Enter the contact information for those who provided the technical documentation."]
[null,null,"Select the business type of the energy analyst identified above. If selecting “Other,” please describe."]
[null,null,"An authorized official must sign and date the application. An authorized official is an individual with authority to obligate an eligible entity by signature to a loan agreement and promissory note to repay the loan. Please understand that this is an application only, and it does not obligate your organization to accept a loan, if approved by the Department."]
[null,null,"U.S. Mail Submission: Print the completed Application Authorization Form and have an authorized official sign.  Print the completed Fuel Use Summary, ECM Summary, all ECM worksheets applicable to your project, and copy the previous 12 months of utility bills.  Mail the package to the address below.\n\nElectronic Submission: Print the completed Application Authorization Form, have an authorized official sign, and scan.  Email the scanned Application Authorization Form, Fuel Use Summary, ECM Summary, all ECM worksheets applicable to your project, and copies of your previous 12 months of utility bills to the email address below."]
[null,null,"For assistance, please call 855-522-2796."]
[]
[null,null,"Missouri Department of Natural Resources"]
[null,null,"Division of Energy"]
[null,null,"Attn: Energy Loan Program"]
[null,null,"PO Box 176"]
[null,null,"1101 Riverside Drive"]
[null,null,"Jefferson City, MO 65102"]
[null,null,"Email: energyloanprogram@dnr.mo.gov"]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Fuel Use Summary (Consolidate)","index":4,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Fuel Use Summary Selection",null,null,null,"List"]
["Worksheet","Building Name","Electricity ($/kWh)","Fuel ($/MMBtu)","Electricity ($/kWh)","Fuel ($/MMBtu)",null,null,"Dropdown Building"]
["Null",null,null,null,"Choose electricity rate","Choose fuel rate",null,null,{"$f":"$B$4:INDEX($B$4:$B$13,COUNTIF($B$4:$B$13,\"?*\"))","v":{"$error":"#VALUE!"}},null,{"$f":"VLOOKUP(J3,B4:C7,2,0)","v":{"$error":"#N/A"}}]
["Fuel Use Summary",{"$f":"IF('Fuel Use Summary'!$F$4=0,\"\",'Fuel Use Summary'!$F$4)","v":""},{"$f":"'Fuel Use Summary'!$E$25","v":""},{"$f":"'Fuel Use Summary'!$J$26","v":""},{"$f":"IF(C4=0,NA(),\"$\"&C4&\" - (\"&B4&\")\")","v":"$ - ()"},{"$f":"IF(D4=0,NA(),\"$\"&D4&\" - (\"&B4&\")\")","v":"$ - ()"},{"$f":"ROW(C4:C13)","v":4}]
["Fuel Use Summary (2)",{"$f":"IF('Fuel Use Summary (2)'!$F$4=0,\"\",'Fuel Use Summary (2)'!$F$4)","v":""},{"$f":"'Fuel Use Summary (2)'!$E$25","v":""},{"$f":"'Fuel Use Summary (2)'!$J$26","v":""},{"$f":"IF(C5=0,NA(),\"$\"&C5&\" - (\"&B5&\")\")","v":"$ - ()"},{"$f":"IF(D5=0,NA(),\"$\"&D5&\" - (\"&B5&\")\")","v":"$ - ()"}]
["Fuel Use Summary (3)",{"$f":"IF('Fuel Use Summary (3)'!$F$4=0,\"\",'Fuel Use Summary (3)'!$F$4)","v":""},{"$f":"'Fuel Use Summary (3)'!$E$25","v":""},{"$f":"'Fuel Use Summary (3)'!$J$26","v":""},{"$f":"IF(C6=0,NA(),\"$\"&C6&\" - (\"&B6&\")\")","v":"$ - ()"},"$ - ()"]
["Fuel Use Summary (4)",{"$f":"IF('Fuel Use Summary (4)'!$F$4=0,\"\",'Fuel Use Summary (4)'!$F$4)","v":""},{"$f":"'Fuel Use Summary (4)'!$E$25","v":""},{"$f":"'Fuel Use Summary (4)'!$J$26","v":""},{"$f":"IF(C7=0,NA(),\"$\"&C7&\" - (\"&B7&\")\")","v":"$ - ()"},"$ - ()",null,{"$f":"ISBLANK(E7)","v":false},{"$f":"IF(OR(C7=\"\",ISBLANK(C1)),TRUE,FALSE)","v":true}]
["Fuel Use Summary (5)",{"$f":"IF('Fuel Use Summary (5)'!$F$4=0,\"\",'Fuel Use Summary (5)'!$F$4)","v":""},{"$f":"'Fuel Use Summary (5)'!$E$25","v":""},{"$f":"'Fuel Use Summary (5)'!$J$26","v":""},{"$f":"IF(C8=0,NA(),\"$\"&C8&\" - (\"&B8&\")\")","v":"$ - ()"},"$ - ()"]
["Fuel Use Summary (6)",{"$f":"IF('Fuel Use Summary (6)'!$F$4=0,\"\",'Fuel Use Summary (6)'!$F$4)","v":""},{"$f":"'Fuel Use Summary (6)'!$E$25","v":""},{"$f":"'Fuel Use Summary (6)'!$J$26","v":""},"$ - ()","$ - ()"]
["Fuel Use Summary (7)",{"$f":"IF('Fuel Use Summary (7)'!$F$4=0,\"\",'Fuel Use Summary (7)'!$F$4)","v":""},{"$f":"'Fuel Use Summary (7)'!$E$25","v":""},{"$f":"'Fuel Use Summary (7)'!$J$26","v":""},"$ - ()","$ - ()"]
["Fuel Use Summary (8)",{"$f":"IF('Fuel Use Summary (8)'!$F$4=0,\"\",'Fuel Use Summary (8)'!$F$4)","v":""},{"$f":"'Fuel Use Summary (8)'!$E$25","v":""},{"$f":"'Fuel Use Summary (8)'!$J$26","v":""},"$ - ()","$ - ()"]
["Fuel Use Summary (9)",{"$f":"IF('Fuel Use Summary (9)'!$F$4=0,\"\",'Fuel Use Summary (9)'!$F$4)","v":""},{"$f":"'Fuel Use Summary (9)'!$E$25","v":""},{"$f":"'Fuel Use Summary (9)'!$J$26","v":""},"$ - ()","$ - ()"]
["Fuel Use Summary (10)",{"$f":"IF('Fuel Use Summary (10)'!$F$4=0,\"\",'Fuel Use Summary (10)'!$F$4)","v":""},{"$f":"'Fuel Use Summary (10)'!$E$25","v":""},{"$f":"'Fuel Use Summary (10)'!$J$26","v":""},"$ - ()","$ - ()"]
[]
[]
[null,"IF('Fuel Use Summary'!E4=0,\"Baseline\",'Fuel Use Summary'!E4)",null,null,"Value"]
[null,null,null,null,{"$f":"$B$4:INDEX(B4:B13,0)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"\"\"","v":""}]

{"sheet":"Lighting","index":5,"n_rows":124,"n_cols":15,"rows_kept":124,"cut":false,"hidden":true,"merged":[[121,2,121,13],[67,2,82,13],[88,2,92,13],[101,2,105,13],[108,2,111,13],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[30,11,30,13],[34,11,34,13],[35,11,35,13],[33,11,33,13],[23,11,23,13],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[4,7,4,11],[4,12,4,14],[21,11,21,13],[22,11,22,13],[18,1,18,14],[1,13,1,14],[2,13,2,14],[59,11,59,13],[46,11,46,13],[113,2,113,4],[94,11,94,13],[95,2,95,4],[96,2,96,4],[97,2,97,4],[98,2,98,4],[42,11,42,13],[45,11,45,13],[51,11,51,13],[47,11,47,13],[55,11,55,13],[4,1,4,6]]}
[]
[]
[]
[null,"BUILDLING",null,null,null,null,null,"LOCATION",null,null,null,null,"DATE"]
[]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings when more efficient lighting is installed, the following information must be known: "]
[null,null,"The number of existing fixtures being changed.",null,null,null,null,null,null,"The number of new fixtures."]
[null,null,"The wattage of each existing fixture.",null,null,null,null,null,null,"The wattage of each new fixture."]
[null,null,"The number of hours of use per year in the past.",null,null,null,null,null,null,"The number of hours of use per year in the future."]
[null,null,"The cost per kilowatt hour of electricity."]
[]
[null,null,"Please Note:"]
[null,null,"If the projects involve several buildings or meters, please submit one worksheet per building or per meter."]
[null,null,"If the project involves several types of fixtures, please submit one worksheet per type."]
[null,null,"Please find example of hours of use under the Additional Instruction section (Page 2)."]
[]
[null,"ATTENTION"]
[null,"**The Division of Energy reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"SAVINGS CALCULATIONS"]
[]
[null,null,1,"Enter the number of existing fixtures being changed",null,null,null,null,null,null,null,null,null,null,"Fixtures"]
[null,null,2,"Enter the wattage of each existing fixture (Input wattages)",null,null,null,null,null,null,null,null,null,null,"Watts"]
[null,null,3,"Enter the hours of use below:"]
[null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","# Weeks","Total"]
[null,null,"Normal Schedule",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M26=0,\"\",SUM(F26:L26)*M26)","v":""}]
[null,null,"Alternate Schedule 1",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M27=0,\"\",SUM(F27:L27)*M27)","v":""}]
[null,null,"Alternate Schedule 2",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M28=0,\"\",SUM(F28:L28)*M28)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(N26=\"\",\"\",SUM(N26:N28))","v":""},"Hours"]
[]
[null,null,4,"Multiply (line 1 x line 2) by the total of line 3",null,null,null,null,null,null,null,{"$f":"IF(N29=\"\",\"\",L22*L23*N29/1000)","v":""},null,null,"kWh/year"]
[]
[]
[null,null,5,"Enter the number of new fixtures",null,null,null,null,null,null,null,null,null,null,"Fixtures"]
[null,null,6,"Enter the wattage of each new fixture (Input wattages)",null,null,null,null,null,null,null,null,null,null,"Watts"]
[null,null,7,"Enter the new hours of use (reduced hours based on lighting controls if applicable)"]
[null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","# Weeks","Total"]
[null,null,"Normal Schedule",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M38=0,\"\",SUM(F38:L38)*M38)","v":""}]
[null,null,"Alternate Schedule 1",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M39=0,\"\",SUM(F39:L39)*M39)","v":""}]
[null,null,"Alternate Schedule 2",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M40=0,\"\",SUM(F40:L40)*M40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(N38=\"\",\"\",SUM(N38:N40))","v":""},"Hours"]
[]
[null,null,8,"Multiply (line 5 x line 6) by the total of line 7",null,null,null,null,null,null,null,{"$f":"IF(N41=\"\",\"\",L34*L35*N41/1000)","v":""},null,null,"kWh/year"]
[]
[]
[null,null,9,"Savings: Subtract line 8 from line 4",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(L43=\"\",\"\",L31-L43),\"\")","v":""},null,null,"kWh/year"]
[]
[null,null,10,"Enter the energy cost (Based on the Fuel Use Summary)",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:C13,2,0),\"\")","v":""},null,null,"$/kWh"]
[]
[null,"ANNUAL SAVINGS"]
[]
[null,null,11,"Multiply line 9 by line 10",null,null,null,null,null,null,null,{"$f":"IFERROR(L46*L48,\"\")","v":""},null,null,"$/Year"]
[]
[null,"PROJECT COST"]
[]
[null,null,12,"Enter the total cost of the project including material, labor and design"]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,null,13,"Divide line 12 by line 11",null,null,null,null,null,null,null,{"$f":"IFERROR(L56/L52,\"\")","v":""},null,null,"Years"]
[]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Lighting/Motion Sensor Energy Conservation Measure"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ADDITIONAL INSTRUCTION"]
[]
[null,null,"This additional instruction provides an example to fill out the hours of use schedule. "]
[]
[null,null,"Example: The school has a regular schedule to have the lights on from 7:30 AM - 4:30 PM (9 hours) the entire week for 36 weeks a year while in session. The school has an alternate schedule to have the lights on from 7:30 AM - 4:30 PM (9 hours) on Monday, Wednesday and Friday for 8 weeks a year in summer session. The school has another alternate schedule to have the lights on from 7:30 AM - 12:30 PM (5 hours) from Monday to Friday for 4 weeks a year during breaks. The hours of use can be entered below: "]
[]
[]
[]
[]
[]
[null,null,3,"Enter the hours of use below:"]
[null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","# Weeks","Total"]
[null,null,"Normal Schedule",null,null,9,9,9,9,9,9,9,36,{"$f":"SUM(F97:L97)*M97","v":2268}]
[null,null,"Alternate Schedule 1",null,null,9,0,9,0,9,0,0,8,{"$f":"SUM(F98:L98)*M98","v":216}]
[null,null,"Alternate Schedule 2",null,null,5,5,5,5,5,0,0,4,{"$f":"SUM(F99:L99)*M99","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N97:N99)","v":2584},"Hours"]
[]
[null,null,"The total calculation is a sum of each schedule multiplied by the number of weeks. Total number of weeks should be totaled for 52 weeks. All schedules are sub-totaled adding hours of use Monday - Sunday. For this example, the \"Normal Schedule\" total is calculated by (9 + 9 + 9 + 9 + 9 + 9 + 9) x 36 = 2,268 hours. The \"Alternate Schedule 1\" is calculated by (9 + 0 + 9 + 0 + 9 + 0 + 0) x 8 = 216 hours. The \"Alternate Schedule 2\" is calculated by (5 + 5 + 5 + 5 + 5 + 0 + 0) x 4 = 100 hours. The total for all schedules is 2,268 + 216 + 100 = 2,584 hours."]
[]
[]
[]
[]
[]
[]
[null,null,"The school plans to install motion sensors. The motion sensors help reduce the hours of use during the weekend while in session. The lights will only be on for cleaning and maintenance for a total of 1 hour each day during the weekend. To enter item 6 on the worksheet, the \"Normal Schedule\" is changed from 9 hours to 1 hour on Saturday and Sunday."]
[]
[]
[]
[null,null,6,"Enter the new hours of use (reduced hours based on lighting controls)"]
[null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","# Weeks","Total"]
[null,null,"Normal Schedule",null,null,9,9,9,9,9,1,1,36,{"$f":"SUM(F115:L115)*M115","v":1692}]
[null,null,"Alternate Schedule 1",null,null,9,0,9,0,9,0,0,8,{"$f":"SUM(F116:L116)*M116","v":216}]
[null,null,"Alternate Schedule 2",null,null,5,5,5,5,5,0,0,4,{"$f":"SUM(F117:L117)*M117","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N115:N117)","v":2008},"Hours"]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"HVAC - Cooling Plant","index":6,"n_rows":130,"n_cols":17,"rows_kept":130,"cut":false,"hidden":true,"merged":[[114,3,114,4],[114,5,114,8],[124,3,124,6],[117,3,117,4],[117,5,117,8],[115,3,115,4],[115,5,115,8],[116,3,116,4],[116,5,116,8],[123,3,123,6],[109,2,110,13],[112,3,112,8],[113,3,113,4],[4,7,4,12],[50,12,50,13],[54,12,54,13],[24,12,24,13],[28,12,28,13],[26,12,26,13],[36,12,36,13],[32,12,32,13],[44,12,44,13],[58,10,58,11],[113,5,113,8],[30,14,30,15],[19,1,19,16],[4,13,4,16],[6,2,7,14],[66,2,106,14],[15,2,15,14],[24,14,24,15],[22,14,22,15],[34,14,34,15],[40,14,40,15],[42,14,42,15]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,null,"DATE"]
[null,"BUILDING"]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings possible from a cooling plant replacement that is intended to increase the efficiency and/or change energy sources, the following information must be known:"]
[]
[null,null,"The annual cooling cost."]
[null,null,"The efficiency of the existing cooling plant [SEER, EER, COP or (1/kw per ton)]."]
[null,null,"The efficiency of the proposed cooling plant [SEER, EER, COP or (1/kw per ton)]. (Use same type rating as above.)"]
[null,null,"The existing energy cost ($/million Btu)."]
[null,null,"The proposed energy cost ($/million Btu)."]
[]
[null,null,"Please Note:"]
[null,null,"The worksheet is not applicable to estimate the savings for Variable Air Volume (VAV), Constant Air Volume (CAV) or other commercial building systems that perform cooling year round."]
[null,null,"Item 5. If the rating is SEER or EER, use the conversion table below (Page 2)."]
[]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"SAVINGS CALCULATIONS"]
[]
[null,null,1,"Total the four electric bills where cooling is included (e.g. June through September) and enter that amount",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,2,"Enter the amount of the neutral month (e.g., May) energy bill",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,3,"Multiply line 2 by 4.0",null,null,null,null,null,null,null,null,{"$f":"O25*4","v":0}]
[]
[null,null,4,"Subtract line 3 from line 1 - ANNUAL COOLING COST",null,null,null,null,null,null,null,null,{"$f":"O23-M27","v":0}]
[]
[null,null,5,"Enter the SEER, EER, COP, or (1/kw per ton) for the existing cooling plant"]
[]
[null,null,6,"Multiply line 4 by line 5",null,null,null,null,null,null,null,null,{"$f":"M29*O31","v":0}]
[]
[null,null,7,"Enter the SEER, EER, COP, or (1/kw per ton) for the proposed cooling plant (same type rating as line 5)"]
[]
[null,null,8,"Divide line 6 by line 7 - PROJECTED ANNUAL COOLING COST",null,null,null,null,null,null,null,null,{"$f":"IFERROR(M33/O35,0)","v":0}]
[]
[null,"AREAS AFFECTED"]
[]
[null,null,9,"Total area cooled by meter",null,null,null,null,null,null,null,null,null,null,null,null,"ft2"]
[]
[null,null,10,"Area affected by the proposed project",null,null,null,null,null,null,null,null,null,null,null,null,"ft2"]
[]
[null,null,11,"Divide line 9 by line 10",null,null,null,null,null,null,null,null,{"$f":"IFERROR(O43/O41,0)","v":0}]
[]
[]
[null,"ANNUAL SAVINGS"]
[]
[null,null,12,"Subtract line 8 from line 4 and multiply by line 11 - ANNUAL COOLING SAVINGS"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(M29-M37)*M45","v":0},null,"/Year"]
[]
[null,"PROJECT COST"]
[]
[null,null,13,"Enter the total cost for the proposed project including material, labor, and design",null,null,null,null,null,null,null,null,0]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,null,14,"Divide line 13 by line 12",null,null,null,null,null,null,{"$f":"IFERROR(M55/M51,0)","v":0},null,"Years"]
[]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Cooling Plant Replacement Energy Conservation Measure"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SEER RATING TABLE"]
[null,null,"If your SEER for cooling equipment is unknown, please use the estimated formula in the table to estimate your SEER rating. Based on a study published by Oak Ridge National Laboratory, the cooling efficiencies in SEER can be estimated by the manufactured date. "]
[]
[]
[null,null,null,"Central Air Conditioner or Heat Pump Cooling Efficiency (SEER)"]
[null,null,null,"1970 and earlier",null,"SEER = 6.0"]
[null,null,null,"1971 - 1996",null,"SEER = 9.5 + 0.1786 x (year manufactured - 1990)"]
[null,null,null,"1997 - 2002",null,"SEER = 10.75 + 0.0750 x (year manufactured - 1997)"]
[null,null,null,"2003 - 2007",null,"SEER = 11.2 + 0.3600 x (year manufactured - 2003)"]
[null,null,null,"2008 and later",null,"SEER = 13.0"]
[]
[null,null,null,"Reference: Oak Ridge National Laboratory, September 7, 2007"]
[]
[null,"COP CONVERSION TABLE"]
[]
[null,null,null,"Conversion Formula"]
[null,null,null,"COP = SEER x 0.293 = EER / 3.142"]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"HVAC - Heating Plant","index":7,"n_rows":136,"n_cols":17,"rows_kept":136,"cut":false,"hidden":true,"merged":[[72,3,132,14],[32,12,32,13],[4,1,4,6],[4,7,4,12],[18,14,18,15],[64,10,64,11],[28,12,28,13],[56,12,56,13],[15,1,15,16],[45,14,45,15],[47,14,47,15],[20,12,20,13],[20,14,20,15],[22,12,22,13],[24,12,24,13],[26,14,26,15],[35,14,35,15],[60,12,60,13],[4,13,4,16],[37,14,37,15],[39,12,39,13],[41,12,41,13],[49,12,49,13],[54,3,55,15],[30,14,30,15],[6,2,7,15]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,null,"DATE"]
[]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings possible from a heating plant replacement that is intended to increase the efficiency and/or change energy sources, the following information must be known:"]
[]
[null,null,"The annual heating cost."]
[null,null,"The efficiency of the existing heating plant (in percent)."]
[null,null,"The efficiency of the proposed heating plant (in percent)."]
[null,null,"The existing energy cost ($/million Btu)."]
[null,null,"The proposed energy cost ($/million Btu)."]
[]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"SAVINGS CALCULATIONS"]
[]
[null,null,1,"Total the seven energy bills where heating is included in (e.g. Oct. through April) and enter that amount"]
[]
[null,null,2,"Enter the amount of the neutral month (i.e., May) energy bill",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,3,"Multiply line 2 by 7.0",null,null,null,null,null,null,null,null,{"$f":"O21*7","v":0}]
[]
[null,null,4,"Subtract line 3 from line 1 - ANNUAL HEATING COST",null,null,null,null,null,null,null,null,{"$f":"O19-M23","v":0}]
[]
[null,null,5,"Enter the efficiency in percentage (use % symbol) or HSPF for the existing heating plant"]
[]
[null,null,6,"Multiply line 4 by line 5",null,null,null,null,null,null,null,null,{"$f":"M25*O27","v":0}]
[]
[null,null,7,"Enter the efficiency in percentage (use % symbol) or HSPF for the proposed heating plant"]
[]
[null,null,8,"Divide line 6 by line 7 - PROJECTED ANNUAL HEATING COST",null,null,null,null,null,null,null,null,{"$f":"IFERROR(M29/O31,0)","v":0}]
[]
[null,null,null,null,"If changing fuel source adjust PROJECTED ANNUAL HEATING COST as follows:"]
[null,null,null,null,"9.    Enter the existing energy cost ($/million BTU)",null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,"10.  Enter the proposed  energy cost ($/million BTU)",null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,"11.  Divide line 10 by line 9",null,null,null,null,null,null,null,{"$f":"IFERROR(O38/O36,0)","v":0}]
[]
[null,null,null,null,"12.  Multiply line 8 by line 11 - AMENDED PROJECTED HEATING COST",null,null,null,null,null,null,null,{"$f":"M33*M40","v":0}]
[]
[null,"AREAS AFFECTED"]
[]
[null,null,13,"Total area heated by meter",null,null,null,null,null,null,null,null,null,null,null,null,"ft2"]
[]
[null,null,14,"Area affected by the proposed project",null,null,null,null,null,null,null,null,null,null,null,null,"ft2"]
[]
[null,null,15,"Divide line 14 by line 13",null,null,null,null,null,null,null,null,{"$f":"IFERROR(O48/O46,0)","v":0}]
[]
[]
[null,"ANNUAL SAVINGS"]
[]
[null,null,16,"Subtract line 8 (if no change in energy source) or line 12 (if a change in fuel source) from line 4 and multiply by line 15 - ANNUAL HEATING SAVINGS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF(M42>0,M25-M42,M25-M33))*M50","v":0},null,"/Year"]
[]
[null,"PROJECT COST"]
[]
[null,null,17,"Enter the total cost for the proposed project including material, labor, and design",null,null,null,null,null,null,null,null,0]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,null,18,"Divide line 17 by line 16",null,null,null,null,null,null,{"$f":"IFERROR(M61/M57,0)","v":0},null,"Years"]
[]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Heating Plant Replacement Energy Conservation Measure"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Insulation","index":8,"n_rows":134,"n_cols":25,"rows_kept":134,"cut":false,"hidden":true,"merged":[[87,3,87,4],[88,3,88,4],[89,3,89,4],[24,11,24,13],[25,11,25,13],[26,11,26,13],[27,11,27,13],[28,11,28,13],[31,11,31,13],[34,11,34,13],[35,11,35,13],[37,11,37,13],[40,11,40,13],[41,11,41,13],[44,11,44,13],[46,11,46,13],[83,5,83,6],[83,3,84,4],[85,3,85,4],[86,3,86,4],[23,22,24,22],[61,11,61,13],[65,11,65,13],[50,11,50,13],[51,11,51,13],[52,11,52,13],[53,11,53,13],[57,11,57,13],[73,3,78,13],[23,23,23,24],[4,1,4,6],[4,7,4,11],[4,12,4,14],[23,19,23,20],[23,18,24,18],[6,12,6,13],[9,18,9,19],[14,9,15,13],[16,9,18,13],[21,1,21,14],[14,2,15,7],[16,2,19,7],[92,2,93,13],[95,3,95,8],[96,3,96,4],[97,3,97,4],[98,3,98,4],[96,5,96,8],[97,5,97,8],[98,5,98,8],[99,5,99,8],[100,5,100,8],[106,3,106,6],[107,3,107,6],[99,3,99,4],[100,3,100,4]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,"DATE"]
[]
[null,"CHECK THE TYPE OF INSULATION PROJECT UNDER CONSIDERATION"]
[]
[]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings of adding insulation to the ceiling or wall, the following information must be known:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of insulation install",null,"Combo Box Value","Value on the main sheet"]
[null,null,"The area of the insulation in square feet.",null,null,null,null,null,null,"The heating/cooling plant efficiency (percentage).",null,null,null,null,null,null,null,null,"Choose Type of Insulation",null,1,{"$f":"IF(U11=2,1,IF(U11=3,0.75,IF(U11=1,\"\")))","v":""}]
[null,null,"The old R-value and the new total R-value.",null,null,null,null,null,null,"The heating energy cost ($/million BTU)/cooling energy cost ($/kWh).",null,null,null,null,null,null,null,null,"Continous Insulation",null,"1 x gross area for continuous insulation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Continuous Insulation",null,"0.75 x gross area for non-continuous insulation"]
[null,null,"Please Note:"]
[null,null,"Multiple Buildings. If the project involves multiple buildings, please submit one worksheet per building.",null,null,null,null,null,null,"Item 10. For SEER and EER rating, please use the COP conversion (Page 2)."]
[]
[null,null,"Item 9. The efficiency can be obtained from the nameplate data including (but not limited to) AFUE, percentage from btu out/btu in or percentage ratio of efficiency. For example, if the percentage ratio efficiency is 80%, please enter 80.",null,null,null,null,null,null,"Item 13-14. Degree Days Table provides Heating Degree Days (HDD) and Cooling Degree Days (CDD) depending on location. If the HDD and CDD are known, the numbers may be entered."]
[]
[]
[]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"SAVINGS CALCULATIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City","Degree Days 65 F",null,"Combo Box List","Combo Box Value","Value on the main sheet"]
[null,null,1,"Enter the old R-value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heating","Cooling","Choose nearest city",null,"Heating","Cooling"]
[null,null,2,"Enter the R-value of the proposed insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Columbia",5078,1269,"Columbia",1,{"$f":"IF($W$26=2,T26,IF($W$26=1,\"\",IF($W$26=3,T27,IF($W$26=4,T28,IF($W$26=5,T29,IF($W$26=6,T30))))))","v":""},{"$f":"IF($W$26=2,U26,IF($W$26=1,\"\",IF($W$26=3,U27,IF($W$26=4,U28,IF($W$26=5,U29,IF($W$26=6,U30))))))","v":""}]
[null,null,3,"Subtract line 2 from line 1",null,null,null,null,null,null,null,{"$f":"IFERROR(L26-L25,\"\")","v":0},null,null,null,null,null,null,"Kansas City",5161,1421,"Kansas City"]
[null,null,4,"Multiply line 1 by line 2",null,null,null,null,null,null,null,{"$f":"IFERROR(L25*L26,\"\")","v":0},null,null,null,null,null,null,"St. Louis",4750,1475,"St. Louis"]
[null,null,5,"Divide line 3 by line 4 (U-Value of the insulation improvement)",null,null,null,null,null,null,null,{"$f":"IFERROR(((L26-L25)/(L25*L26)),\"\")","v":""},null,null,null,null,null,null,"St. Joseph",5435,1334,"St. Joseph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Springfield",4570,1382,"Springfield"]
[null,null,6,"Choose the characteristic of insulation installation"]
[null,null,7,"Enter characteristic of insulation installation factor",null,null,null,null,null,null,null,{"$f":"V11","v":""}]
[]
[]
[null,null,8,"Enter efficiency of the heating plant",null,null,null,null,null,null,null,null,null,null,"Percent"]
[null,null,9,"Enter COP of the cooling plant"]
[null,null,null,"If the rating is EER or SEER, use the conversion table below (page 2)."]
[null,null,10,"Enter subject area to be insulated (Attic, Crawl Space, Wall, Roof, others)",null,null,null,null,null,null,null,null,null,null,"ft2"]
[]
[null,null,11,"Choose the location nearest the building"]
[null,null,12,"Enter Heating Degree Days ( if unknown, Use Degree Days table)",null,null,null,null,null,null,null,{"$f":"IF($W$26=2,T26,IF($W$26=1,\"\",IF($W$26=3,T27,IF($W$26=4,T28,IF($W$26=5,T29,IF($W$26=6,T30))))))","v":""}]
[null,null,13,"Enter Cooling Degree Days (if unknown, Use Degree Days table)",null,null,null,null,null,null,null,{"$f":"IF($W$26=2,U26,IF($W$26=1,\"\",IF($W$26=3,U27,IF($W$26=4,U28,IF($W$26=5,U29,IF($W$26=6,U30))))))","v":""}]
[]
[]
[null,null,14,"Multiply (0.77 x line 5 x line 7 x line 10 x line 12 x 24) and divide by line 8, then by 1,000,000",null,null,null,null,null,null,null,{"$f":"IFERROR(0.77*L29*L32*L38*L41*24/L35/1000000,\"\")","v":""},null,null,"MMBtu/Year"]
[null,null,null,"(Heating Savings Reduction)"]
[null,null,15,"Multiply (line 5 x line 7 x line 10 x line 12 x 24) and divide by line 9, then by 3412",null,null,null,null,null,null,null,{"$f":"IFERROR(L29*L32*L38*L42*24/L36/3412,\"\")","v":""},null,null,"kWh/Year"]
[null,null,null,"(Cooling Savings Reduction)"]
[null,"ENERGY COST"]
[]
[null,null,16,"Enter energy cost for heating ($/MMBtu)",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,3,0),0)","v":0},null,null,"$/MMBtu"]
[null,null,17,"Enter energy cost for cooling ($/kWh)",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,2,0),0)","v":0},null,null,"$/kWh"]
[null,null,18,"Multiply line 14 by line 16 (Heating Cost Savings)",null,null,null,null,null,null,null,{"$f":"IFERROR(L45*L51,0)","v":0}]
[null,null,19,"Multiply line 15 by line 17 (Cooling Cost Savings)",null,null,null,null,null,null,null,{"$f":"IFERROR(L47*L52,0)","v":0}]
[]
[null,"ANNUAL SAVINGS"]
[]
[null,null,20,"Add line 18 and line 19 (Annual Cost Savings)",null,null,null,null,null,null,{"$f":"IF(ISERROR(+#REF!*#REF!),\"\",(+#REF!*#REF!))","v":""},{"$f":"IFERROR(L53+L54,\"\")","v":0},null,null,"$/Year"]
[]
[null,"PROJECT COST"]
[]
[null,null,21,"Enter the total cost of the project including material, labor, and design"]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,null,22,"Divide line 21 by line 20",null,null,null,null,null,null,{"$f":"IF(ISERROR(+L62/K58),\"\",(+L62/K58))","v":""},{"$f":"IFERROR(L62/L58,\"\")","v":""},null,null,"Years"]
[]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Wall or Ceiling Insulation Energy Conservation Measure"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DEGREE DAY TABLE"]
[null,null,"Please use this \"Degree Day Table\" to determine \"Degree Days\" for item 12 and 13 in the Wall or Ceiling Insulation Worksheet."]
[]
[null,null,null,"City",null,"Degree Days (65F)"]
[null,null,null,null,null,"Heating","Cooling"]
[null,null,null,"Columbia",null,5078,1269]
[null,null,null,"Kansas City",null,5161,1421]
[null,null,null,"St. Louis",null,4750,1475]
[null,null,null,"St. Joseph",null,5435,1334]
[null,null,null,"Springfield",null,4570,1382]
[]
[null,"SEER RATING TABLE"]
[null,null,"If your SEER for cooling equipment is unknown, please use the estimated formula in the table to estimate your SEER rating. Based on a study published by Oak Ridge National Laboratory, the cooling efficiencies in SEER can be estimated by the manufactured date. "]
[]
[]
[null,null,null,"Central Air Conditioner or Heat Pump Cooling Efficiency (SEER)"]
[null,null,null,"1970 and earlier",null,"SEER = 6.0"]
[null,null,null,"1971 - 1996",null,"SEER = 9.5 + 0.1786 x (year manufactured - 1990)"]
[null,null,null,"1997 - 2002",null,"SEER = 10.75 + 0.0750 x (year manufactured - 1997)"]
[null,null,null,"2003 - 2007",null,"SEER = 11.2 + 0.3600 x (year manufactured - 2003)"]
[null,null,null,"2008 and later",null,"SEER = 13.0"]
[]
[null,null,null,"Reference: Oak Ridge National Laboratory, September 7, 2007"]
[]
[null,"COP CONVERSION TABLE"]
[]
[null,null,null,"Conversion Formula"]
[null,null,null,"COP = SEER x 0.293 = EER / 3.142"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Windows Replacement","index":9,"n_rows":118,"n_cols":46,"rows_kept":118,"cut":false,"hidden":true,"merged":[[102,3,102,6],[103,3,103,6],[67,2,79,15],[96,3,96,4],[96,5,96,8],[87,2,89,15],[93,3,93,4],[93,5,93,8],[94,3,94,4],[94,5,94,8],[95,3,95,4],[95,5,95,8],[92,3,92,4],[92,5,92,8],[91,3,91,8],[83,2,85,15],[64,19,64,21],[64,22,64,24],[73,30,74,30],[73,20,73,21],[73,22,73,23],[64,26,64,28],[4,14,4,16],[40,2,41,5],[35,14,35,15],[36,14,36,15],[40,9,41,12],[20,6,20,7],[20,14,20,15],[30,4,30,5],[34,9,34,13],[34,14,34,16],[39,9,39,13],[39,14,39,16],[40,14,41,15],[40,13,41,13],[11,1,11,16],[50,9,50,11],[51,9,51,11],[46,9,46,11],[4,1,4,6],[4,7,4,13],[25,19,25,20],[25,29,26,29],[40,16,41,16],[59,9,59,11],[56,9,56,11],[35,9,35,11],[36,9,36,11],[37,9,37,11],[52,9,52,11],[53,9,53,11],[54,9,54,11],[57,9,57,11],[58,9,58,11],[47,9,47,11],[48,9,48,11],[49,9,49,11]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,null,null,"DATE"]
[]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings of windows/doors replacement/reduction, the following information must be known:"]
[null,null,"The R-Value of the new wall (Window reduction only). U-Value=1/R-Value",null,null,null,null,null,null,"The energy cost ($/million Btu)."]
[null,null,"Type of the existing and new window (See U-Value table below)",null,null,null,null,null,null,"The heating/cooling plant efficiency (in percent)."]
[null,null,"The total area of the windows being replaced (Square feet).",null,null,null,null,null,null,"For heating/cooling plant efficiency, see additional instruction section."]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"SAVINGS CALCULATIONS INPUT"]
[]
[null,null,"Existing Windows",null,null,null,null,null,null,null,"New Windows"]
[null,null,1,"Enter existing windows area",null,null,null,"sq.ft.",null,null,7,"Enter new windows area",null,null,null,"sq.ft."]
[null,null,2,null,null,null,null,null,null,null,8]
[null,null,3,null,null,null,null,null,null,null,9]
[null,null,4,null,null,null,null,null,null,null,10]
[null,null,5,null,null,null,null,null,null,null,11]
[null,null,6,"U-Value of existing windows",null,null,{"$f":"IF(OR(T67=1,U67=1,V67=1,AH27=1),\"Select items above\",U70)","v":"Select items above"},null,null,null,12,"U-Value of new windows",null,null,{"$f":"IF(OR(W67=1,X67=1,Y67=1,AH28=1),\"Select items above\",X70)","v":"Select items above"}]
[]
[]
[null,null,"New Wall (Window Reduction)",null,null,null,null,null,null,null,"Building Characteristics"]
[null,null,13,"Enter new wall area",null,null,null,"sq.ft.",null,null,18,"Enter average building height",null,null,null,"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leakage",null,null,null,null,"Energy consumption type","Control Value",null,null,"Heating Efficiency","Cooling Efficiency",null,"Building Energy fillable"]
[null,null,14,"Enter R-Value of the new wall frame",null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,"New Wall U-Value calculations",null,null,"Type of Buildings",null,null,null,"Control Value",null,"Leakage","In2/ft2",null,null,null,"Control Value","Value on the main sheet",null,null,null,"Select the energy consumption type",1,null,null,{"$f":"IF(OR(O29=\"\",O29=0),0.01,O29)","v":0.01},{"$f":"O30","v":""},null,{"$f":"IF(OR(AN26=1),TRUE,FALSE)","v":true}]
[null,null,15,"Enter R-Value of additional insulation",null,null,null,null,null,null,20,null,null,null,null,null,null,null,null,"U-Value of the new wall",{"$f":"(0.25*(1/3.5))+(0.75*(1/H26))","v":{"$error":"#DIV/0!"}},null,"Select the type of cooling/heating system ",null,null,null,1,null,"Select leakage level",null,null,null,"Exisiting Windows",2,{"$f":"IF(AH27=1,\"\",INDEX(AD28:AD32,AH27-1,1))","v":0.01},null,null,null,"Fuel heating / Electric cooling",null,"Enter heating plant efficiency","Percent"]
[null,null,16,null,null,null,null,null,null,null,21,null,null,null,null,null,null,null,null,"U-Value of the additional insulation",{"$f":"1/H27","v":{"$error":"#DIV/0!"}},null,"Individual units, Window units, radiant heater",null,null,null,null,null,"Tight - Construction supervised by air-sealing specialist",0.01,null,null,"New Windows",1,{"$f":"IF(AH28=1,\"\",INDEX(AD28:AD32,AH28-1,1))","v":""},null,null,null,"Electric heating / Electric cooling",null,"Enter the cooling plant COP",{"$f":"\"\"","v":""}]
[null,null,17,"Total U-Value of the new wall",null,null,null,null,null,null,null,{"$f":"IF(AN26=1,\"\",AO27)","v":""},null,null,{"$f":"IF(AN26=1,\"\",0)","v":""},{"$f":"IF(AN26=1,\"\",AP27)","v":""},null,null,null,"Total U-Value of the new wall",{"$f":"(U27*U28)/(U27+U28)","v":{"$error":"#DIV/0!"}},null,"Roof-top unit, Central HVAC system",null,null,null,null,null,"Good - Carefully sealed by professional builders",0.02,null,null,"New Walls",1,{"$f":"IF(AH29=1,\"\",INDEX(AD28:AD32,AH29-1,1))","v":""},null,null,null,"Fuel heating only",null,"Enter fuel cost per MMBtu","$/MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AN26=2,AN26=3),AO28,\"\")","v":""},null,null,{"$f":"IF(OR(AN26=1,AN26=4,AN26=5),\"\",0)","v":""},{"$f":"IF(OR(AN26=2,AN26=3),AP28,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Average - Typical current construction",0.04,null,null,null,null,null,null,null,null,"Electric heating only",null,"Enter electricity cost per kWh","$/kWh"]
[null,null,null,null,{"$f":"IF(OR(G25=\"\",H26=\"\",H27=\"\",AH29=1),\"Enter items above\",U29)","v":"Enter items above"},null,null,null,null,null,null,{"$f":"IF(OR(AN26=2,AN26=4),AO29,\"\")","v":""},null,null,{"$f":"IFERROR(IF(OR(AN26=1,AN26=3,AN26=5),\"\",VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,3,0)),\"\")","v":""},{"$f":"IF(OR(AN26=2,AN26=4),AP29,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Leaky - Typical 1970 construction ",0.08]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AN26=1,AN26=4),\"\",AO30)","v":""},null,null,{"$f":"IFERROR(IF(OR(AN26=1,AN26=4),\"\",VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,2,0)),\"\")","v":""},{"$f":"IF(OR(AN26=1,AN26=4),\"\",AP30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Very leaky - Original pre-1970 construction",0.15]
[]
[null,"ANNUAL SAVINGS"]
[null,null,null,null,null,null,null,null,null,"Energy unit savings",null,null,null,null,"Energy cost savings"]
[null,null,22,"Savings in Summer",null,null,null,null,null,{"$f":"IFERROR(INDEX(AJ86:AJ90,AN26,1),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(AK86:AK87,AN26,1),\"\")","v":""},null,{"$f":"IFERROR(INDEX(AN86:AN90,AN26,1),\"\")","v":""}]
[null,null,23,"Savings in Winter",null,null,null,null,null,{"$f":"IFERROR(INDEX(AL86:AL90,AN26,1),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(AM86:AM87,AN26,1),\"\")","v":""},null,{"$f":"IFERROR(INDEX(AO86:AO90,AN26,1),\"\")","v":""}]
[]
[null,"PROJECT COST AND SIMPLE PAYBACK"]
[null,null,"24 Enter the total cost (Including material, labor and design)",null,null,null,null,null,null,"Total Annual Savings",null,null,null,null,"Simple Payback"]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(O36+O37,\"\")","v":""},null,null,null,"years",{"$f":"IFERROR(C41/J41,\"\")","v":""},null,"years"]
[]
[]
[null,"ENERGY SAVINGS CALCULATION (DED/DE INTERNAL USE ONLY)"]
[null,null,"Leakage",null,null,null,null,null,null,"Existing Windows",null,null,null,"New Windows",null,"New Wall"]
[]
[null,null,25,"Unit Leakage Areas in2/ft2",null,null,null,null,null,{"$f":"AI27","v":0.01},null,null,null,{"$f":"AI28","v":""},null,{"$f":"AI29","v":""}]
[null,null,26,"Average Leakage, in2",null,null,null,null,null,{"$f":"IFERROR(G16*J47,\"\")","v":0},null,null,null,{"$f":"IFERROR(O16*N47,\"\")","v":""},null,{"$f":"IFERROR(G25*P47,\"\")","v":""}]
[null,null,"Summer"]
[null,null,27,"IDF",null,null,null,null,null,{"$f":"IFERROR((($AC$67+O25*($V$77-$V$76)*($AC$68+$AC$69*(0.016/J48)))/1000),\"\")","v":""},null,null,null,{"$f":"IFERROR(($AC$67+O25*($V$77-$V$76)*($AC$68+$AC$69*(0.016/N48)))/1000,\"\")","v":""},null,{"$f":"IFERROR(($AC$67+O25*($V$77-$V$76)*($AC$68+$AC$69*(0.016/P48)))/1000,\"\")","v":""}]
[null,null,28,"Infiltration airflow rate",null,null,null,null,null,{"$f":"IFERROR(J48*J50,\"\")","v":""},null,null,"CFM",{"$f":"IFERROR(N48*N50,\"\")","v":""},"CFM",{"$f":"IFERROR(P48*P50,\"\")","v":""},"CFM"]
[null,null,29,"Sensible heat loss through leaks",null,null,null,null,null,{"$f":"IFERROR(IF($AA$27=3,0,1.1*J51*($V$77-$V$76)),\"\")","v":""},null,null,"Btu/h",{"$f":"IFERROR(IF(AA27=3,0,1.1*N51*($V$77-$V$76)),\"\")","v":""},"Btu/h",{"$f":"IFERROR(IF(AA27=3,0,1.1*P51*($V$77-$V$76)),\"\")","v":""},"Btu/h"]
[null,null,30,"Latent heat loss through leaks",null,null,null,null,null,{"$f":"IFERROR(IF(AA27=3,0,4840*J51*($X$77-$X$76)),\"\")","v":""},null,null,"Btu/h",{"$f":"IFERROR(IF(AA27=3,0,4840*N51*($X$77-$X$76)),\"\")","v":""},"Btu/h",{"$f":"IFERROR(IF(AA27=3,0,4840*P51*($X$77-$X$76)),\"\")","v":""},"Btu/h"]
[null,null,31,"Calculate the energy loss total",null,null,null,null,null,{"$f":"IFERROR((((G21*G16*($V$77-$V$76))+J52+J53)*AK76*24)/($O$30*1000000*($V$77-$V$76))*$U$84,\"\")","v":""},null,null,"MMBtu",{"$f":"IFERROR((((O21*O16*($V$77-$V$76))+N52+N53)*AK76*24)/($O$30*1000000*($V$77-$V$76))*$U$84,\"\")","v":""},"MMBtu",{"$f":"IFERROR((((E31*G25*($V$77-$V$76))+P52+P53)*AK76*24)/($O$30*1000000*($V$77-$V$76))*$U$84,\"\")","v":""},"MMBtu"]
[]
[null,null,"Winter"]
[null,null,32,"IDF",null,null,null,null,null,{"$f":"IFERROR(($AB$67+O25*($U$76-$U$77)*($AB$68+$AB$69*(0.016/J48)))/1000,\"\")","v":""},null,null,null,{"$f":"IFERROR(($AB$67+O25*($U$76-$U$77)*($AB$68+$AB$69*(0.016/N48)))/1000,\"\")","v":""},null,{"$f":"IFERROR(($AB$67+O25*($U$76-$U$77)*($AB$68+$AB$69*(0.016/P48)))/1000,\"\")","v":""}]
[null,null,33,"Infiltration airflow rate",null,null,null,null,null,{"$f":"IFERROR(J48*J57,\"\")","v":""},null,null,"CFM",{"$f":"IFERROR(N48*N57,\"\")","v":""},"CFM",{"$f":"IFERROR(P48*P57,\"\")","v":""},"CFM"]
[null,null,34,"Sensible heat loss through leaks",null,null,null,null,null,{"$f":"IFERROR(IF(AA27=3,0,1.1*J58*($U$76-$U$77)),\"\")","v":""},null,null,"Btu/h",{"$f":"IFERROR(IF(AA27=3,0,1.1*N58*($U$76-$U$77)),\"\")","v":""},"Btu/h",{"$f":"IFERROR(IF(AA27=3,0,1.1*P58*($U$76-$U$77)),\"\")","v":""},"Btu/h"]
[null,null,35,"Calculate the energy loss total",null,null,null,null,null,{"$f":"IFERROR((((G21*G16*($U$76-$U$77))+J59)*AJ76*24)/(O29*1000000*($U$76-$U$77))*$U$84,\"\")","v":""},null,null,"MMBtu",{"$f":"IFERROR((((O21*O16*($U$76-$U$77))+N59)*AJ76*24)/($O$29*1000000*($U$76-$U$77))*$U$84,\"\")","v":""},"MMBtu",{"$f":"IFERROR((((E31*G25*($U$76-$U$77))+P59)*AJ76*24)/($O$29*1000000*($U$76-$U$77))*$U$84,\"\")","v":""},"MMBtu"]
[]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Windows/Doors Replacement/Reduction Energy Conservation Measure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control Value for Existing Windows",null,null,"Control Value for New Windows",null,null,null,"IDF Coefficient"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Type","Type of Windows","Storm Windows","Glass Type","Type of Windows","Storm Windows",null,null,"Winter 7.5 mph","Summer 15 mph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,1,1,1,1,null,"I0",343,698]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U-Value",{"$f":"INDEX('Windows U-Value'!G8:S55,'Windows Replacement'!T67-1,'Windows Replacement'!U67-1)","v":1.07},null,"U-Value",{"$f":"INDEX('Windows U-Value'!G8:S55,'Windows Replacement'!W67-1,'Windows Replacement'!X67-1)","v":{"$error":"#VALUE!"}},null,null,"I1",0.88,0.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U-Value Storm Windows",{"$f":"IF(V67=3,1.23,FALSE)","v":false},null,"U-Value Storm Windows",{"$f":"IF(Y67=3,1.23,FALSE)","v":false},null,null,"I2",0.28000000000000003,0.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U-Value Total",{"$f":"IF(U69=FALSE,U68,(U68*U69)/(U68+U69))","v":1.07},null,"U-Value Total",{"$f":"IF(X69=FALSE,X68,(X68*X69)/(X68+X69))","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature difference",null,"W",null,null,null,null,null,null,null,"City","Degree Days 65 F",null,"Combo Box List","Combo Box Value","Value on the main sheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter","Summer","Winter","Summer",null,null,null,null,null,null,null,"Heating","Cooling","Choose nearest city",null,"Heating","Cooling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design",68,75,{"$f":"30*0.000143","v":4.2900000000000004E-3},{"$f":"78*0.000143","v":1.1154000000000001E-2},null,null,null,null,null,null,"Columbia",5078,1269,"Columbia",1,{"$f":"IF(AI76=1,\"\",INDEX(AF76:AF80,AI76-1,1))","v":""},{"$f":"IF(AI76=1,\"\",INDEX(AG76:AG80,AI76-1,1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Missouri",7.4,91.4,1.1306000000000001E-3,{"$f":"129.8*0.000143","v":1.8561400000000002E-2},null,null,null,null,null,null,"Kansas City",5161,1421,"Kansas City"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Louis",4750,1475,"St. Louis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Joseph",5435,1334,"St. Joeseph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MMBtu Conversion",null,null,null,null,null,null,null,null,null,null,"Springfield",4570,1382,"Springfield"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"MMBtu",">",293.29722222200002,"kWh"]
[null,"ADDITIONAL INSTRUCTIONS"]
[]
[null,null,"Item 21. The efficiency can be from the nameplate data including (but not limited to) AFUE, COP, percentage from btu out/btu in, percentage ratio of efficiency. For example, if the percentage ratio efficiency is 80%, please enter 80. If the COP of the cooling plant efficiency is 2.5, please enter 250%.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD",0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer",null,"Winter",null,"cost summer","cost winter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select the energy consumption type",1,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","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,"Fuel heating / Electric cooling",2,{"$f":"IFERROR(IF(N54=\"\",J54-P54,IF(P54=\"\",J54-N54,(J54-N54-P54)))*W81,\"\")","v":""},"kWh",{"$f":"IFERROR(IF(P60=\"\",J60-N60,(IF(N60=\"\",J60-P60,J60-N60-P60))),\"\")","v":""},"MMBtu",{"$f":"IFERROR(AJ87*O32,\"\")","v":""},{"$f":"IFERROR(AL87*O31,\"\")","v":""}]
[null,null,"If your SEER for cooling equipment is unknown, please use the estimated formula in the table to estimate your SEER rating. Based on a study published by Oak Ridge National Laboratory, the cooling efficiencies in SEER can be estimated by the manufactured 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,"Electric heating / Electric cooling",3,{"$f":"IFERROR((IF(N54=\"\",J54-P54,IF(P54=\"\",J54-N54,(J54-N54-P54))))*W81,\"\")","v":""},"kWh",{"$f":"IFERROR(IF(P60=\"\",J60-N60,(IF(N60=\"\",J60-P60,J60-N60-P60)))*W81,\"\")","v":""},"kWh",{"$f":"IFERROR(AJ88*O32,\"\")","v":""},{"$f":"IFERROR(AL88*O32,\"\")","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,"Fuel heating only",4,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"IFERROR(IF(P60=\"\",J60-N60,(IF(N60=\"\",J60-P60,J60-N60-P60))),\"\")","v":""},"MMBtu",null,{"$f":"IFERROR(AL89*O31,\"\")","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,"Electric heating only",5,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"IFERROR(IF(P60=\"\",J60-N60,(IF(N60=\"\",J60-P60,J60-N60-P60)))*W81,\"\")","v":""},"kWh",null,{"$f":"IFERROR(AL90*O32,\"\")","v":""}]
[]
[null,null,null,"Central Air Conditioner or Heat Pump Cooling Efficiency (SEER)"]
[null,null,null,"1970 and earlier",null,"SEER = 6.0"]
[null,null,null,"1971 - 1996",null,"SEER = 9.5 + 0.1786 x (year manufactured - 1990)"]
[null,null,null,"1997 - 2002",null,"SEER = 10.75 + 0.0750 x (year manufactured - 1997)"]
[null,null,null,"2003 - 2007",null,"SEER = 11.2 + 0.3600 x (year manufactured - 2003)"]
[null,null,null,"2008 and later",null,"SEER = 13.0"]
[]
[null,null,null,"Reference: Oak Ridge National Laboratory, September 7, 2007"]
[]
[null,"COP CONVERSION TABLE"]
[]
[null,null,null,"Conversion Formula"]
[null,null,null,"COP = SEER x 0.293 = EER / 3.142"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Dishwasher - Energy Star","index":10,"n_rows":103,"n_cols":32,"rows_kept":103,"cut":false,"hidden":true,"merged":[[42,19,42,21],[28,22,28,23],[31,22,31,25],[31,26,31,29],[50,11,50,12],[46,11,46,12],[31,30,32,31],[32,22,32,23],[32,24,32,25],[32,26,32,27],[32,28,32,29],[16,22,16,23],[17,22,17,23],[22,22,22,23],[23,22,23,23],[27,22,27,23],[8,22,8,24],[9,23,9,24],[11,22,11,24],[12,22,12,23],[13,22,13,23],[58,2,99,13],[35,8,35,10],[24,9,24,10],[24,12,24,13],[4,1,4,6],[4,7,4,11],[4,12,4,14],[24,3,24,7],[20,1,20,14],[7,2,8,13],[15,2,15,13],[16,2,16,13],[27,12,27,13],[36,4,36,5],[36,6,36,7],[36,8,36,10],[27,9,27,10],[27,2,27,4],[30,6,30,7],[30,2,30,4],[35,4,35,5],[35,6,35,7],[34,4,34,10],[27,6,27,7]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,"DATE"]
[]
[null,"INSTRUCTIONS"]
[]
[null,null,"This sheet is for a dishwasher upgrade from a conventional model to an ENERGY STAR® model. To estimate the savings of dishwasher replacement, the following information must be known:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of dishwasher selected from the worksheet",null,null,null,"Building Water","Booster Water"]
[null,null,"Type of dishwasher.",null,null,null,null,null,"Average daily operations (hours).",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R24","v":1},{"$f":"INDEX('Dishwasher Calcs'!L6:L15,W10,1)","v":"List of dishwasher"},null,null,{"$f":"C28","v":0},{"$f":"G28","v":0}]
[null,null,"Number of racks washed per day.",null,null,null,null,null,"Quantity of dishwashers."]
[null,null,"Operating days per year.",null,null,null,null,null,"The electricity energy cost ($/kWh).",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallons of water consumed (Gallons)"]
[null,null,"Building hot water and booster heater fuel type.",null,null,null,null,null,"The natural gas energy cost ($/MMBtu).",null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional",null,"Energy Star"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W10<6,INDEX('Dishwasher Calcs'!F27:F30,W10-1,1),IF(W10>=6,INDEX('Dishwasher Calcs'!F32:F36,W10-5,1),\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(W10<6,INDEX('Dishwasher Calcs'!G27:G30,W10-1,1),IF(W10>=6,INDEX('Dishwasher Calcs'!G32:G36,W10-5,1),\"\"))","v":{"$error":"#VALUE!"}}]
[null,"Please Note:"]
[null,null,"If the project involves several dishwashers, please submit one sheet for each characteristic of use (i.e. different number of loads, operating days).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idle Power Draw (kW)"]
[null,null,"This worksheet is applicable for commercial-grade dishwashers with standard commercial rack size only. This worksheet is not applicable to residential units.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional",null,"Energy Star"]
[null,null,"High temperature dishwasher is with a booster. Low temperature dishwasher is without a booster.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($W$10<6,INDEX('Dishwasher Calcs'!H27:H30,$W$10-1,1),IF($W$10>=6,INDEX('Dishwasher Calcs'!H32:H36,$W$10-5,1),\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($W$10<6,INDEX('Dishwasher Calcs'!I27:I30,$W$10-1,1),IF($W$10>=6,INDEX('Dishwasher Calcs'!I32:I36,$W$10-5,1),\"\"))","v":{"$error":"#VALUE!"}}]
[]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appopriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"DISHWASHER HOT WATER SAVINGS CALCULATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typical Wash Time (Minutes)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional",null,"Energy Star"]
[null,null,"1. Select type of Dishwasher",null,null,null,null,null,null,"2. Racks washed per day",null,null,"3. Operating days per year",null,null,null,null,1,"Natural Gas",{"$f":"IF(R24<6,\"N/A\",\"Natural Gas\")","v":"N/A"},null,null,{"$f":"IF($W$10<6,INDEX('Dishwasher Calcs'!D27:D30,$W$10-1,1),IF($W$10>=6,INDEX('Dishwasher Calcs'!D32:D36,$W$10-5,1),\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($W$10<6,INDEX('Dishwasher Calcs'!E27:E30,$W$10-1,1),IF($W$10>=6,INDEX('Dishwasher Calcs'!E32:E36,$W$10-5,1),\"\"))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric",{"$f":"IF(R24<6,\"\",\"Electric\")","v":""}]
[]
[null,null,"4. Building hot water fuel type",null,null,null,"5. Booster water heater fuel type",null,null,"6. Average Daily Operation (hours)",null,null,"7. Number of Dishwashers",null,null,null,null,null,null,null,null,null,"Consumption of water from the worksheet (Gallons)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional",null,"Energy Star"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W14*J25*M25","v":{"$error":"#VALUE!"}},null,{"$f":"Y14*J25*M25","v":{"$error":"#VALUE!"}}]
[null,null,"8. Electric rate ($/kWh)",null,null,null,"9. Gas rate ($/MMBtu)"]
[null,null,{"$f":"IFERROR(VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,2,0),0)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,3,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Building Water Heater Energy Consumption",null,null,null,"Annual Booster Heater Energy Consumption",null,null,null,"Annual Idle Electricity Consumption (kWh)"]
[null,"ANNUAL SAVINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional",null,"ENERGY STAR",null,"Conventional",null,"ENERGY STAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric (kWh)","Gas (MMBtu)","Electric (kWh)","Gas (MMBtu)","Electric (kWh)","Gas (MMBtu)","Electric (kWh)","Gas (MMBtu)","Conventional","ENERGY STAR"]
[null,null,null,null,"Savings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA10=\"Electric\",W29*'Dishwasher Calcs'!C40,0)","v":0},{"$f":"IF(AA10=\"Natural Gas\",W29*'Dishwasher Calcs'!E40,0)","v":0},{"$f":"IF(AA10=\"Electric\",Y29*'Dishwasher Calcs'!C40,0)","v":0},{"$f":"IF(AA10=\"Natural Gas\",Y29*'Dishwasher Calcs'!E40,0)","v":0},{"$f":"IF(AB10=\"Electric\",W29*'Dishwasher Calcs'!C41,0)","v":0},{"$f":"IF(AB10=\"Natural Gas\",W29*'Dishwasher Calcs'!E41,0)","v":0},{"$f":"IF(AB10=\"Electric\",Y29*'Dishwasher Calcs'!C41,0)","v":0},{"$f":"IF(AB10=\"Natural Gas\",Y29*'Dishwasher Calcs'!E41,0)","v":0},{"$f":"W18*(M25*J28-M25*J25*W24/60)","v":{"$error":"#VALUE!"}},{"$f":"Y18*(M25*J28-M25*J25*Y24/60)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Electricity (kWh)",null,"Natural Gas (MMBtu)",null,"Annual Cost Savings"]
[null,null,null,null,{"$f":"IFERROR(T45,0)","v":0},null,{"$f":"IFERROR(U45,0)","v":0},null,{"$f":"IFERROR(V45,0)","v":0}]
[]
[null,null,"Assumption:"]
[null,null,1,"Water heater efficiency ratings are 98% for electric and 80% for natural gas."]
[null,null,2,"The inlet water temperature increase for the building water heater is at 70 oF."]
[null,null,3,"The inlet water temperature increase for the booster water heater is at 40 oF.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DED Worksheet calculation"]
[null,null,"Reference: http://www.energystar.gov/certified-products/detail/commercial_dishwashers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Savings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity (kWh)","Gas (MMBtu)","Total Savings"]
[null,"PROJECT COST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M28*((W35-Y35)+(AA35-AC35)+(AE35-AF35))","v":{"$error":"#VALUE!"}},{"$f":"M28*((X35-Z35)+(AB35-AD35))","v":0},{"$f":"C31*T45+G31*U45","v":{"$error":"#VALUE!"}}]
[]
[null,null,"10. Enter the total cost of the proposed project including material, labor, and design",null,null,null,null,null,null,null,null,0]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,null,"11. Estimated simple payback period",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(+L47/#REF!),\"\",(+L47/#REF!))","v":""},{"$f":"IFERROR(L47/I37,0)","v":0}]
[]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Dishwasher - Energy Star Energy® Conservation Measure"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Pipe Insulation-Gas","index":11,"n_rows":121,"n_cols":15,"rows_kept":121,"cut":false,"hidden":true,"merged":[[1,13,1,14],[2,13,2,14],[113,5,113,6],[114,5,114,6],[111,2,111,4],[112,2,112,4],[113,2,113,4],[114,2,114,4],[111,5,111,6],[112,5,112,6],[101,5,101,6],[102,5,102,6],[103,5,103,6],[104,5,104,6],[105,5,105,6],[106,5,106,6],[107,5,107,6],[108,5,108,6],[109,5,109,6],[110,5,110,6],[106,2,106,4],[107,2,107,4],[108,2,108,4],[109,2,109,4],[110,2,110,4],[101,2,101,4],[102,2,102,4],[103,2,103,4],[104,2,104,4],[105,2,105,4],[98,2,100,4],[98,5,100,6],[99,7,99,13],[98,7,98,13],[51,11,51,13],[55,11,55,13],[59,11,59,13],[66,2,93,13],[47,11,47,13],[29,11,29,13],[35,11,35,13],[41,11,41,13],[45,11,45,13],[37,11,37,13],[39,11,39,13],[43,11,43,13],[4,1,4,6],[4,7,4,11],[4,12,4,14],[33,11,33,13],[31,11,31,13],[25,11,25,13],[27,11,27,13],[22,1,22,14]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,"DATE"]
[]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings of adding insulation to the outside of heat distribution pipes, the following information must be known:"]
[null,null,"The interior pipe diameter.",null,null,null,null,null,null,"Bare pipe heat loss factor (use Heat Loss Factor Table)."]
[null,null,"The total length (feet) of pipe to be insulated.",null,null,null,null,null,null,"Thickness of added insulation."]
[null,null,"The pipe fluid temperature (°F).",null,null,null,null,null,null,"Insulated pipe heat loss factor (use Heat Loss Factor Table)."]
[null,null,"The pipe room temperature (°F).",null,null,null,null,null,null,"Heating plant efficiency (in percent)."]
[null,null,"The hours of use per day.",null,null,null,null,null,null,"The energy cost ($/MMBtu)."]
[]
[null,null,"Please Note:"]
[null,null,"To use this worksheet, the heating and cooling distribution pipe must be at a constant temperature. The pipe distribution must be indoors."]
[null,null,"If the project involves several buildings, please submit one worksheet per building."]
[null,null,"If more than one pipe condition is used in summer and winter, please submit one worksheet per season."]
[null,null,"Item 5. Please enter interior temperature or the thermostat setpoint. "]
[null,null,"Item 10. The efficiency can be from the boiler nameplate data including (but not limited to) AFUE percentage,"]
[null,null,"percentage from btu out/btu in or percentage ratio of efficiency. For example, if the percentage ratio efficiency is 80%, please enter 80."]
[]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"SAVINGS CALCULATIONS"]
[]
[null,null,1,"Enter the bare pipe heat loss factor (use Heat Loss Factor Table)",null,null,null,null,null,null,null," "]
[]
[null,null,2,"Enter the insulated pipe heat loss factor  (use Heat Loss Factor Table)"]
[]
[null,null,3,"Subtract line 2 from line 1",null,null,null,null,null,null,null,{"$f":"IF(L28>0,L26-L28,\"\")","v":""}]
[]
[null,null,4,"Enter the pipe fluid temperature (°F)",null,null,null,null,null,null,null,null,null,null,"°F"]
[]
[null,null,5,"Enter the pipe room temperature (°F)",null,null,null,null,null,null,null,null,null,null,"°F"]
[]
[null,null,6,"Subtract line 5 from line 4",null,null,null,null,null,null,null,{"$f":"IF(L34>0,L32-L34,\"\")","v":""},null,null,"°F"]
[]
[null,null,7,"Enter the total length (feet) of pipe to be insulated",null,null,null,null,null,null,null,null,null,null,"Feet"]
[]
[null,null,8,"Enter the hours of use per year",null,null,null,null,null,null,null,null,null,null,"Hours"]
[]
[null,null,9,"Multiply line 3 by line 6 by line 7 by line 8 then divide by 1,000,000",null,null,null,null,null,null,null,{"$f":"IFERROR(L30*L36*L38*L40/1000000,\"\")","v":""},null,null,"MMBtu"]
[]
[null,null,10,"Enter the heating plant efficiency (percentage)",null,null,null,null,null,null,null,null,null,null,"Percent"]
[]
[null,null,11,"Divide line 9 by line 10 and multiply by 100",null,null,null,null,null,null,null,{"$f":"IFERROR(L42/L44,\"\")","v":""},null,null,"MMBtu"]
[]
[null,null,12,"Enter the energy cost ($/million Btu)",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,3,0),\"\")","v":""},null,null,"/MMBtu"]
[]
[null,"ANNUAL SAVINGS"]
[]
[null,null,13,"Multiply line 11 by line 12",null,null,null,null,null,null,null,{"$f":"IFERROR(L46*L48,0)","v":0},null,null,"/Year"]
[]
[null,"PROJECT COST"]
[]
[null,null,14,"Enter the total cost to insulate the pipe including material, labor and design",null,null,null,null,null,null,null,0]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,null,15,"Divide line 14 by line 13",null,null,null,null,null,null,null,{"$f":"IFERROR(L56/L52,\"\")","v":""},null,null,"Years"]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Pipe Insulation Energy Conservation Measure - Natural Gas"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Heat Loss Factor Table"]
[]
[null,null,"INTERIOR PIPE DIAMETER",null,null,"BARE PIPE FACTOR",null,"INSULATED PIPE FACTOR"]
[null,null,null,null,null,null,null,"INSULATION THICKNESS (INCHES)"]
[null,null,null,null,null,null,null,"½","¾",1,"1 ¼","1 ½","1 ¾",2]
[null,null,"½",null,null,0.63,null,0.16300000000000001,0.13500000000000001,0.11600000000000001,0.105,9.8000000000000004E-2,9.0999999999999998E-2,8.5999999999999993E-2]
[null,null,"¾",null,null,0.76,null,0.191,0.155,0.13500000000000001,0.12,0.11,0.10299999999999999,9.6000000000000002E-2]
[null,null,1,null,null,0.93,null,0.21099999999999999,0.17899999999999999,0.153,0.13600000000000001,0.125,0.115,0.108]
[null,null,"1 ¼",null,null,1.1399999999999999,null,0.26300000000000001,0.21,0.17799999999999999,0.158,0.14299999999999999,0.13200000000000001,0.122]
[null,null,"1 ½",null,null,1.27,null,0.28699999999999998,0.23200000000000001,0.19400000000000001,0.17199999999999999,0.154,0.14199999999999999,0.13200000000000001]
[null,null,2,null,null,1.53,null,0.34499999999999997,0.27100000000000002,0.22900000000000001,0.19800000000000001,0.17799999999999999,0.16300000000000001,0.151]
[null,null,"2 ¼",null,null,1.87,null,0.42499999999999999,0.32500000000000001,0.27,0.23699999999999999,0.21,0.19,0.17499999999999999]
[null,null,3,null,null,2.15,null,0.48699999999999999,0.36799999999999999,0.309,0.251,0.214,0.21099999999999999,0.19500000000000001]
[null,null,4,null,null,2.65,null,0.6,0.44700000000000001,0.375,0.30499999999999999,0.27900000000000003,0.252,0.23100000000000001]
[null,null,5,null,null,3.2,null,0.66300000000000003,0.5,0.40699999999999997,0.34599999999999997,0.30499999999999999,0.27100000000000002,0.245]
[null,null,6,null,null,3.7,null,0.85199999999999998,0.628,0.53600000000000003,0.432,0.379,0.34100000000000003,0.30499999999999999]
[null,null,8,null,null,4.75,null,1.0900000000000001,0.82799999999999996,0.65,0.54900000000000004,0.48599999999999999,0.433,0.38800000000000001]
[null,null,10,null,null,5.75,null,1.341,0.99,0.77800000000000002,0.67800000000000005,0.57999999999999996,0.51100000000000001,0.45700000000000002]
[null,null,12,null,null,6.75,null,1.55,1.1519999999999999,0.92,0.80200000000000005,0.66400000000000003,0.60399999999999998,0.54100000000000004]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Pipe Insulation-Electric","index":12,"n_rows":124,"n_cols":15,"rows_kept":124,"cut":false,"hidden":true,"merged":[[94,3,94,6],[66,2,76,13],[93,3,93,6],[79,2,80,13],[82,3,82,8],[87,3,87,4],[87,5,87,8],[86,3,86,4],[86,5,86,8],[85,3,85,4],[85,5,85,8],[83,3,83,4],[83,5,83,8],[84,3,84,4],[84,5,84,8],[1,13,1,14],[2,13,2,14],[28,11,28,13],[4,1,4,6],[4,7,4,11],[4,12,4,14],[24,11,24,13],[26,11,26,13],[21,1,21,14],[59,11,59,13],[30,11,30,13],[32,11,32,13],[34,11,34,13],[36,11,36,13],[38,11,38,13],[40,11,40,13],[42,11,42,13],[45,11,45,13],[47,11,47,13],[51,11,51,13],[55,11,55,13],[98,2,100,4],[98,5,100,6],[98,7,98,13],[99,7,99,13],[101,2,101,4],[101,5,101,6],[102,2,102,4],[102,5,102,6],[103,2,103,4],[103,5,103,6],[104,2,104,4],[104,5,104,6],[105,2,105,4],[105,5,105,6],[106,2,106,4],[106,5,106,6],[107,2,107,4],[107,5,107,6],[108,2,108,4],[108,5,108,6],[109,2,109,4],[109,5,109,6],[110,2,110,4],[110,5,110,6],[114,2,114,4],[114,5,114,6],[111,2,111,4],[111,5,111,6],[112,2,112,4],[112,5,112,6],[113,2,113,4],[113,5,113,6]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,"DATE"]
[]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings of adding insulation to the outside of heat distribution pipes, the following information must be known:"]
[null,null,"The interior pipe diameter.",null,null,null,null,null,null,"Bare pipe heat loss factor (use Heat Loss Factor Table)."]
[null,null,"The total length (feet) of pipe to be insulated.",null,null,null,null,null,null,"Thickness of added insulation."]
[null,null,"The pipe fluid temperature (°F).",null,null,null,null,null,null,"Insulated pipe heat loss factor (use Heat Loss Factor Table)."]
[null,null,"The pipe room temperature (°F).",null,null,null,null,null,null,"Heating plant efficiency (in percent)."]
[null,null,"The hours of use per day.",null,null,null,null,null,null,"The energy cost ($/kWh)."]
[]
[null,null,"Please Note:"]
[null,null,"To use this worksheet, the heating and cooling distribution pipe must be at a constant temperature. The pipe distribution must be indoors."]
[null,null,"If the project involves several buildings, please submit one worksheet per building."]
[null,null,"If more than one pipe condition is used in summer and winter, please submit one worksheet per season."]
[null,null,"Item 5. Please enter interior temperature or the thermostat setpoint. "]
[null,null,"Item 10. If the rating is SEER or EER, use the conversion table below (Page 2)."]
[]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"SAVINGS CALCULATIONS"]
[]
[null,null,1,"Enter the bare pipe heat loss factor (use Heat Loss Factor Table)"]
[]
[null,null,2,"Enter the insulated pipe heat loss factor  (use Heat Loss Factor Table)"]
[]
[null,null,3,"Subtract line 2 from line 1",null,null,null,null,null,null,null,{"$f":"IF(L27>0,L25-L27,\"\")","v":""}]
[]
[null,null,4,"Enter the pipe fluid temperature (°F)",null,null,null,null,null,null,null,null,null,null,"°F"]
[]
[null,null,5,"Enter the pipe room temperature (°F)",null,null,null,null,null,null,null,null,null,null,"°F"]
[]
[null,null,6,"Subtract line 5 from line 4",null,null,null,null,null,null,null,{"$f":"IF(L33>0,L31-L33,\"\")","v":""},null,null,"°F"]
[]
[null,null,7,"Enter the total length (feet) of pipe to be insulated",null,null,null,null,null,null,null,null,null,null,"Feet"]
[]
[null,null,8,"Enter the hours of use per year",null,null,null,null,null,null,null,null,null,null,"Hours"]
[]
[null,null,9,"Multiply line 3 by line 6 by line 7 by line 8 then divide by 3,412",null,null,null,null,null,null,null,{"$f":"IFERROR((L29*L35*L37*L39/3412),\"\")","v":""},null,null,"kWh"]
[]
[null,null,10,"Enter COP of the cooling plant"]
[null,null,null,"If the rating is SEER or EER, use the conversion table below (Page 2)."]
[]
[null,null,11,"Divide line 9 by line 10 and multiply by 100",null,null,null,null,null,null,null,{"$f":"IFERROR(L41/L43,\"\")","v":""},null,null,"kWh"]
[]
[null,null,12,"Enter the energy cost ($/kWh)",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,2,0),\"\")","v":""},null,null,"/kWh"]
[]
[null,"ANNUAL SAVINGS"]
[]
[null,null,13,"Multiply line 11 by line 12",null,null,null,null,null,null,null,{"$f":"IFERROR(L46*L48,0)","v":0},null,null,"/Year"]
[]
[null,"PROJECT COST"]
[]
[null,null,14,"Enter the total cost to insulate the pipe including material, labor and design",null,null,null,null,null,null,null,0]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,null,15,"Divide line 14 by line 13",null,null,null,null,null,null,null,{"$f":"IFERROR(L56/L52,\"\")","v":""},null,null,"Years"]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Pipe Insulation Energy Conservation Measure - Electric"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SEER RATING TABLE"]
[null,null,"If your SEER for cooling equipment is unknown, please use the estimated formula in the table to estimate your SEER rating. Based on a study published by Oak Ridge National Laboratory, the cooling efficiencies in SEER can be estimated by the manufactured date. "]
[]
[]
[null,null,null,"Central Air Conditioner or Heat Pump Cooling Efficiency (SEER)"]
[null,null,null,"1970 and earlier",null,"SEER = 6.0"]
[null,null,null,"1971 - 1996",null,"SEER = 9.5 + 0.1786 x (year manufactured - 1990)"]
[null,null,null,"1997 - 2002",null,"SEER = 10.75 + 0.0750 x (year manufactured - 1997)"]
[null,null,null,"2003 - 2007",null,"SEER = 11.2 + 0.3600 x (year manufactured - 2003)"]
[null,null,null,"2008 and later",null,"SEER = 13.0"]
[]
[null,null,null,"Reference: Oak Ridge National Laboratory, September 7, 2007"]
[]
[null,"COP CONVERSION TABLE"]
[]
[null,null,null,"Conversion Formula"]
[null,null,null,"COP = SEER x 0.293 = EER / 3.142"]
[]
[null,"HEAT LOSS FACTOR TABLE"]
[]
[null,null,"INTERIOR PIPE DIAMETER",null,null,"BARE PIPE FACTOR",null,"INSULATED PIPE FACTOR"]
[null,null,null,null,null,null,null,"INSULATION THICKNESS (INCHES)"]
[null,null,null,null,null,null,null,"½","¾",1,"1 ¼","1 ½","1 ¾",2]
[null,null,"½",null,null,0.63,null,0.16300000000000001,0.13500000000000001,0.11600000000000001,0.105,9.8000000000000004E-2,9.0999999999999998E-2,8.5999999999999993E-2]
[null,null,"¾",null,null,0.76,null,0.191,0.155,0.13500000000000001,0.12,0.11,0.10299999999999999,9.6000000000000002E-2]
[null,null,1,null,null,0.93,null,0.21099999999999999,0.17899999999999999,0.153,0.13600000000000001,0.125,0.115,0.108]
[null,null,"1 ¼",null,null,1.1399999999999999,null,0.26300000000000001,0.21,0.17799999999999999,0.158,0.14299999999999999,0.13200000000000001,0.122]
[null,null,"1 ½",null,null,1.27,null,0.28699999999999998,0.23200000000000001,0.19400000000000001,0.17199999999999999,0.154,0.14199999999999999,0.13200000000000001]
[null,null,2,null,null,1.53,null,0.34499999999999997,0.27100000000000002,0.22900000000000001,0.19800000000000001,0.17799999999999999,0.16300000000000001,0.151]
[null,null,"2 ¼",null,null,1.87,null,0.42499999999999999,0.32500000000000001,0.27,0.23699999999999999,0.21,0.19,0.17499999999999999]
[null,null,3,null,null,2.15,null,0.48699999999999999,0.36799999999999999,0.309,0.251,0.214,0.21099999999999999,0.19500000000000001]
[null,null,4,null,null,2.65,null,0.6,0.44700000000000001,0.375,0.30499999999999999,0.27900000000000003,0.252,0.23100000000000001]
[null,null,5,null,null,3.2,null,0.66300000000000003,0.5,0.40699999999999997,0.34599999999999997,0.30499999999999999,0.27100000000000002,0.245]
[null,null,6,null,null,3.7,null,0.85199999999999998,0.628,0.53600000000000003,0.432,0.379,0.34100000000000003,0.30499999999999999]
[null,null,8,null,null,4.75,null,1.0900000000000001,0.82799999999999996,0.65,0.54900000000000004,0.48599999999999999,0.433,0.38800000000000001]
[null,null,10,null,null,5.75,null,1.341,0.99,0.77800000000000002,0.67800000000000005,0.57999999999999996,0.51100000000000001,0.45700000000000002]
[null,null,12,null,null,6.75,null,1.55,1.1519999999999999,0.92,0.80200000000000005,0.66400000000000003,0.60399999999999998,0.54100000000000004]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Dishwasher Calcs","index":13,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":true,"merged":[[10,1,10,8],[17,1,19,1],[3,1,4,1],[3,2,3,4],[3,5,3,9],[5,1,5,9],[6,9,9,9],[17,2,18,3],[17,4,19,4],[18,6,18,7],[19,6,19,7],[23,9,24,9],[25,1,25,9],[23,1,24,1],[23,2,24,2],[23,3,23,4],[23,5,23,6],[23,7,23,8],[58,2,58,3],[70,2,70,5],[30,1,30,9],[42,1,43,1],[42,2,42,4],[44,1,44,4],[49,1,49,4]]}
["Reference: http://www.energystar.gov/certified-products/detail/commercial_dishwashers"]
["Dishwasher Calculations for the ENERGY STAR Commercial Kitchen Equipment Calculator"]
[" Inputs - to edit these values go to the INPUTS tab"]
[null,null,"DEFAULT",null,null,"USER ENTRY"]
[null,null,"Annual days of operation","Racks washed per day","Incremental cost","Annual days of operation","Racks washed per day","Incremental cost","Building hot water fuel type","Booster water heater fuel type",null,"List of dishwasher"]
[null,"Low Temperature",null,null,null,null,null,null,null,null,null,"List of dishwasher"]
[null,"Under Counter",365,75,50,365,75,50,null,"N/A",null,{"$f":"$B$6&\" - \"&B7","v":"Low Temperature - Under Counter"}]
[null,"Stationary Single Tank Door",365,280,0,365,280,0,null,null,null,{"$f":"$B$6&\" - \"&B8","v":"Low Temperature - Stationary Single Tank Door"}]
[null,"Single Tank Conveyor",365,400,0,365,400,0,null,null,null,{"$f":"$B$6&\" - \"&B9","v":"Low Temperature - Single Tank Conveyor"}]
[null,"Multi Tank Conveyor",365,600,970,365,600,970,null,null,null,{"$f":"$B$6&\" - \"&B10","v":"Low Temperature - Multi Tank Conveyor"}]
[null,"High Temperature",null,null,null,null,null,null,null,null,null,{"$f":"$B$11&\" - \"&B12","v":"High Temperature - Under Counter"}]
[null,"Under Counter",365,75,120,365,75,120,null,null,null,{"$f":"$B$11&\" - \"&B13","v":"High Temperature - Stationary Single Tank Door"}]
[null,"Stationary Single Tank Door",365,280,770,365,280,770,null,null,null,{"$f":"$B$11&\" - \"&B14","v":"High Temperature - Single Tank Conveyor"}]
[null,"Single Tank Conveyor",365,400,2050,365,400,2050,null,null,null,{"$f":"$B$11&\" - \"&B15","v":"High Temperature - Multi Tank Conveyor"}]
[null,"Multi Tank Conveyor",365,600,970,365,600,970,null,null,null,{"$f":"$B$11&\" - \"&B16","v":"High Temperature - Pot, Pan, and Utensil"}]
[null,"Pot, Pan, and Utensil",365,280,1710,365,280,1710]
[" Assumptions - users can edit the highlighted values to modify the assumptions"]
[null,null,"Water Heater Efficiency",null,"Inlet Water Temperature Increase (oF)"]
[null,null,null,null,null,null,"Specific Heat of Water",null,1,"Btu/pound/oF"]
[null,null,"Electric","Gas",null,null,"Density of Water",null,{"$f":"61.4/7.48","v":8.2085561497326189},"pounds/gallon"]
[null,"Building Water Heater",0.98,0.8,70]
[null,"Booster Water Heater",0.98,0.8,40]
[]
[null,null,"Average daily operation (hours)","Typical Wash Time (minutes)",null,"Water Use per Rack (gallons)",null,"Idle Power Draw (kW)",null,"Equipment lifetime (years)"]
[null,null,null,"Conventional","ENERGY STAR","Conventional","ENERGY STAR","Conventional","ENERGY STAR"]
[null,"Low Temperature"]
[null,"Under Counter",18,2,2,1.73,1.19,0.5,0.5,10]
[null,"Stationary Single Tank Door",18,1.5,1.5,2.1,1.18,0.6,0.6,15]
[null,"Single Tank Conveyor",18,0.3,0.3,1.31,0.79,1.6,1.5,20]
[null,"Multi Tank Conveyor",18,0.3,0.3,1.04,0.54,2,2,20]
[null,"High Temperature"]
[null,"Under Counter",18,2,2,1.0900000000000001,0.86,0.76,0.5,10]
[null,"Stationary Single Tank Door",18,1,1,1.29,0.89,0.87,0.7,15]
[null,"Single Tank Conveyor",18,0.3,0.3,0.87,0.7,1.93,1.5,20]
[null,"Multi Tank Conveyor",18,0.2,0.2,0.97,0.54,2.59,2.25,20]
[null,"Pot, Pan, and Utensil",18,3,3,0.7,0.57999999999999996,1.2,1.2,10]
[" Calculations"]
[null,"Water Heating Energy","Electric","Gas","Gas"]
[null,null,"kWh/gallon","therm/gallon","MMBtu/Gallon"]
[null,"Building Water Heater",{"$f":"E21*I19*I20/C21/3412","v":0.17184215687767163},{"$f":"E21*I19*I20/D21/100000","v":7.1824866310160416E-3},{"$f":"E21*I19*I20/D21/1000000","v":7.1824866310160411E-4}]
[null,"Booster Water Heater",{"$f":"E22*I19*I20/C22/3412","v":9.819551821581235E-2},{"$f":"E22*I19*I20/D22/100000","v":4.1042780748663087E-3},{"$f":"E22*I19*I20/D22/1000000","v":4.1042780748663094E-4}]
[]
[null,null," Annual Water Consumption (gallons)"]
[null,null,"Conventional","ENERGY STAR","Savings"]
[null,"Low Temperature"]
[null,"Under Counter",{"$f":"F27*G7*F7","v":47358.75},{"$f":"G27*G7*F7","v":32576.25},{"$f":"C46-D46","v":14782.5}]
[null,"Stationary Single Tank Door",{"$f":"F28*G8*F8","v":214620},{"$f":"G28*G8*F8","v":120595.99999999999},{"$f":"C47-D47","v":94024.000000000015}]
[null,"Single Tank Conveyor",{"$f":"F29*G9*F9","v":191260},{"$f":"G29*G9*F9","v":115340},{"$f":"C48-D48","v":75920}]
[null,"Multi Tank Conveyor",{"$f":"F30*G10*F10","v":227760},{"$f":"G30*G10*F10","v":118260},{"$f":"C49-D49","v":109500}]
[null,"High Temperature"]
[null,"Under Counter",{"$f":"F32*G12*F12","v":29838.75},{"$f":"G32*G12*F12","v":23542.5},{"$f":"C51-D51","v":6296.25}]
[null,"Stationary Single Tank Door",{"$f":"F33*G13*F13","v":131838},{"$f":"G33*G13*F13","v":90958},{"$f":"C52-D52","v":40880}]
[null,"Single Tank Conveyor",{"$f":"F34*G14*F14","v":127020},{"$f":"G34*G14*F14","v":102200},{"$f":"C53-D53","v":24820}]
[null,"Multi Tank Conveyor",{"$f":"F35*G15*F15","v":212430},{"$f":"G35*G15*F15","v":118260},{"$f":"C54-D54","v":94170}]
[null,"Pot, Pan, and Utensil",{"$f":"F36*G16*F16","v":71540},{"$f":"G36*G16*F16","v":59275.999999999993},{"$f":"C55-D55","v":12264.000000000007}]
[]
[]
[" References"]
[null,"Equipment specifications:","- ENERGY STAR specification"]
[null,null,"- EPA/Food Service Technology Center (FSTC) research on available models, 2013"]
[null,"Operating hours:","- EPA/FSTC research on average use, 2009"]
[null,"Incremental equipment cost:","- Difference between a similar ENERGY STAR and non-qualifying model, EPA research using AutoQuotes, 2012"]
[null,"Equipment lifetime:","- EPA/FSTC research on available models, 2013"]
[null,"Water heater specifications:","- Federal standard: Title 10 Part 431 - Energy Efficiency Program for Certain Commercial and Industrial Equipment; Subpart G"]
[null,"Water properties:","- Cengel & Turner, Fundamentals of Thermal Fluid Science, Table A-15E"]
[]
[]
[]
[]
[null,"do not modify -         quantity:",{"$f":"[1]INPUTS!E13","v":0},{"$f":"[1]INPUTS!E14","v":0},{"$f":"[1]INPUTS!E15","v":0},{"$f":"[1]INPUTS!E16","v":0},{"$f":"[1]INPUTS!E17","v":0},{"$f":"[1]INPUTS!E18","v":0},{"$f":"[1]INPUTS!E19","v":0},{"$f":"[1]INPUTS!E20","v":0},{"$f":"[1]INPUTS!E21","v":0}]
[null,null,{"$f":"SUM(C70:F70)","v":0}]

{"sheet":"Dishwasher - Other","index":14,"n_rows":123,"n_cols":25,"rows_kept":123,"cut":false,"hidden":true,"merged":[[12,22,12,23],[13,22,13,23],[12,2,12,13],[28,7,28,8],[34,7,34,8],[21,9,21,10],[61,11,61,12],[65,10,65,11],[47,7,47,8],[53,7,53,8],[51,9,51,10],[4,1,4,6],[4,7,4,11],[4,12,4,14],[15,1,15,14],[73,2,119,13],[19,9,19,10],[23,9,23,10],[25,9,25,10],[30,9,30,10],[32,9,32,10],[38,9,38,10],[40,9,40,10],[42,9,42,10],[44,9,44,10],[49,9,49,10],[57,9,57,10]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,"DATE"]
[]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings of dishwasher replacement, the following information must be known:"]
[null,null,"Incoming water temperature (degrees F).",null,null,null,null,null,"The electricity energy cost ($/kWh)."]
[null,null,"Final water temperature (degrees F).",null,null,null,null,null,"The natural gas energy cost ($/therm)."]
[null,null,"Amount of water saved (gallon)."]
[null,null,"Please Note:"]
[null,null,"If the project involves several dishwashers, please submit one sheet for each.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idle Power Draw (kW)"]
[null,null,"This worksheet is applicable for commercial-grade dishwashers with standard commercial rack size only. This worksheet is not applicable to residential units.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional",null,"Energy Star"]
[null,null,"High temperature dishwasher is with a booster. Low temperature dishwasher is without a booster.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($W$10<6,INDEX('Dishwasher Calcs'!H23:H26,$W$10-1,1),IF($W$10>=6,INDEX('Dishwasher Calcs'!H28:H32,$W$10-5,1),\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($W$10<6,INDEX('Dishwasher Calcs'!I23:I26,$W$10-1,1),IF($W$10>=6,INDEX('Dishwasher Calcs'!I28:I32,$W$10-5,1),\"\"))","v":{"$error":"#VALUE!"}}]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"DISHWASHER HOT WATER SAVINGS CALCULATION"]
[]
[null,"STAGE 1"]
[null,"Incoming water temperature (degrees F) ",null,null,null,null,null,null,null,null,null,"°F"]
[]
[null,"Final water temperature (degrees F) ",null,null,null,null,null,null,null,null,null,"°F"]
[]
[null,"Amount of water saved (gal.) ",null,null,null,null,null,null,null,null,null,"Gal.",null,null,null,null,"Water Heater Efficiency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas"]
[null,"Water heater efficiency  ",null,null,null,null,null,null,null,{"$f":"IF(R26=1,0.8,0.98)","v":0.98},null,null,null,null,null,null,"Electricity",2]
[null,"   (assume 0.80 for gas & 0.98 for electricity)"]
[]
[null,"Stage 1 Energy use (MMBTUs)",null,null,null,null,null,{"$f":"+((J22-J20)*(J24*8.33))/(J26*1000000)","v":0}]
[]
[null,{"$f":"IF(R26=2,\"Enter cost of electricity ($/kWh) -\",\"Enter cost of Natural Gas ($/MMBtu) -\")","v":"Enter cost of electricity ($/kWh) -"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(R26=2,VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,2,0),VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,3,0)),\"\")","v":""},null,{"$f":"IF(R26=2,\"$/kWh\",\"$/MMBtu\")","v":"$/kWh"}]
[]
[null,"Energy cost per MMBtu",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(R26=2,J31*293,J31),\"\")","v":""},null,"$/MMBtu"]
[]
[null,"Stage 1 Savings ($)",null,null,null,null,null,{"$f":"IFERROR((H29*J33),0)","v":0}]
[]
[]
[null,"STAGE 2"]
[null,"Incoming water temperature (degrees F) ",null,null,null,null,null,null,null,null,null,"°F"]
[]
[null,"Final water temperature (degrees F) ",null,null,null,null,null,null,null,null,null,"°F"]
[]
[null,"Amount of water saved (gal.) ",null,null,null,null,null,null,null,null,null,"Gal."]
[]
[null,"Water heater efficiency  ",null,null,null,null,null,null,null,{"$f":"IF(R52=1,0.8,0.98)","v":0.8}]
[null,"   (assume 0.80 for gas & 0.98 for electricity)"]
[]
[null,"Stage 2 Energy use (MMBTUs)",null,null,null,null,null,{"$f":"+((J41-J39)*(J43*8.33))/(J45*1000000)","v":0}]
[]
[null,{"$f":"IF(R52=2,\"Enter cost of electricity ($/kWh) -\",\"Enter cost of natural gas ($/MMBtu) -\")","v":"Enter cost of natural gas ($/MMBtu) -"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(R52=2,VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,2,0),VLOOKUP(B5,'Fuel Use Summary (Consolidate)'!B4:D13,3,0)),\"\")","v":""},null,{"$f":"IF(R52=2,\"$/kWh\",\"$/MMBtu\")","v":"$/MMBtu"},null,null,null,null,"Water Heater Efficiency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas"]
[null,"Energy cost per MMBtu",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(R52=2,J50*293,J50),\"\")","v":""},null,"$/MMBtu",null,null,null,null,"Electricity",1]
[]
[null,"Stage 2 Savings ($)",null,null,null,null,null,{"$f":"IFERROR(H48*J52,0)","v":0}]
[]
[null,"ANNUAL SAVINGS"]
[]
[null,"TOTAL SAVINGS",null,null,null,null,null,null,null,{"$f":"IFERROR(+H35+H54,\"\")","v":0},null,"/Year"]
[]
[null,"PROJECT COST"]
[]
[null,"Enter the total cost of the proposed project including material, labor, and design",null,null,null,null,null,null,null,null,null,0]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,"PROJECT COST/ANNUAL SAVINGS",null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(+L62/J58),\"\",(+L62/J58))","v":""},null,"Years"]
[]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Dishwasher - Other Energy Conservation Measure"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Motor Upgrade","index":15,"n_rows":93,"n_cols":13,"rows_kept":93,"cut":false,"hidden":true,"merged":[[30,7,30,9],[24,2,24,4],[24,6,24,7],[23,2,23,4],[17,1,17,14],[23,9,23,10],[23,12,23,13],[20,2,20,4],[20,11,20,12],[23,6,23,7],[4,1,4,6],[4,7,4,11],[4,12,4,14],[31,10,31,12],[47,2,90,13],[40,11,40,12],[21,2,21,4],[21,8,21,9],[21,11,21,12],[24,9,24,10],[24,12,24,13],[31,7,31,9],[30,4,30,6],[31,4,31,6],[29,4,29,12],[36,11,36,12]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,"DATE"]
[]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings of a motor upgrade, the following information must be known:"]
[null,null,"Motor horsepower (HP).",null,null,null,null,null,"Motor load (in percent)."]
[null,null,"Operating hours of motor (hours).",null,null,null,null,null,"Monthly demand charge ($kW)."]
[null,null,"Efficiency of existing motor (in percent).",null,null,null,null,null,"The electricity charge per tailblock ($/kWh)."]
[null,null,"Efficiency of new motor (in percent)."]
[]
[null,null,"Please Note:"]
[null,null,"This worksheet is only applicable to constant load and same size motors."]
[null,null,"This worksheet is not applicable to pulsating loads, VFDs, random loads, or loads that cycle at rapidly repeating intervals."]
[]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"MOTOR SAVINGS CALCULATION"]
[]
[null,null,"1. Motor horsepower (HP)",null,null,null,"2. Quantity",null,"3. Motor load (%)",null,null,"4. Operating hours of motor (hours)"]
[]
[]
[null,null,"5. Efficiency of existing motor (%)",null,null,null,"6. Efficiency of new motor (%)",null,null,"7. Monthly demand charge ($/kW)",null,null,"8. Electricity charge per tailblock ($/kWh)"]
[]
[]
[]
[null,"ANNUAL SAVINGS"]
[]
[null,null,null,null,"Savings"]
[null,null,null,null,"Electricity Usage Savings (kWh)",null,null,"Demand Savings (kW)",null,null,"Annual Cost Savings"]
[null,null,null,null,{"$f":"IFERROR(C22*G22*I22*0.7457*L22*((1/C25)-(1/G25)),0)","v":0},null,null,{"$f":"IFERROR(C22*G22*I22*0.7457*((1/C25)-(1/G25)),0)","v":0},null,null,{"$f":"IFERROR((E32*M25)+(H32*J25),0)","v":0}]
[]
[]
[null,"PROJECT COST"]
[]
[null,null,"9. Enter the total cost of the proposed project including material, labor, and design",null,null,null,null,null,null,null,null,0]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,null,"10. Estimated simple payback period",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(+L37/#REF!),\"\",(+L37/#REF!))","v":""},{"$f":"IFERROR(L37/K32,0)","v":0}]
[]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Motor Upgrade Energy Conservation Measure"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Thermostat","index":16,"n_rows":126,"n_cols":17,"rows_kept":126,"cut":false,"hidden":true,"merged":[[29,2,30,15],[62,2,122,14],[32,14,32,15],[33,12,33,13],[34,12,34,13],[40,14,40,15],[41,14,41,15],[42,12,42,13],[46,12,46,13],[50,12,50,13],[54,10,54,11],[35,12,35,13],[36,12,36,13],[4,13,4,16],[33,14,33,15],[14,2,14,15],[15,2,15,15],[17,1,17,16],[26,12,26,13],[20,12,20,13],[22,12,22,13],[21,10,21,11],[23,10,23,11],[24,10,24,11],[25,10,25,11],[27,10,27,11],[4,1,4,6],[4,7,4,12],[13,2,13,15]]}
[]
[]
[]
[null,"BUILDING",null,null,null,null,null,"LOCATION",null,null,null,null,null,"DATE"]
[]
[null,"INSTRUCTIONS"]
[null,null,"To estimate the savings possible from a night setback, the following information must be known:"]
[null,null,"Total estimated weekday setback hours.",null,null,null,null,null,null,"Energy bills."]
[null,null,"Total estimated weekend setback hours.",null,null,null,null,null,null,"Area of the building."]
[null,null,"Average setback temperature difference.",null,null,null,null,null,null,"Area of the proposed project."]
[null,null,"The annual heating cost."]
[]
[null,null,"Please Note:"]
[null,null,"This worksheet is applicable for a setback no greater than an average of 5oF temperature difference. "]
[null,null,"Item 1. The setback hours should be one or two hours before and after the building schedule. For example, if the building is occupied from 8 AM - 5 PM, weekday setback hours would be from 7 PM - 6 AM. The setback schedule should ensure the space is conditioned and comfortable for the occupants."]
[null,null,"Item 3. If the building is unoccupied during the weekends, please enter \"24\" hrs/day, as the building is vacant."]
[null,"ATTENTION"]
[null,"**The Department reserves the right to determine if the worksheet is appropriate for the project and may request additional information. An Energy Conservation Measure (ECM) has the potential of affecting other areas within your facility or system.**"]
[null,"SAVINGS CALCULATIONS"]
[]
[null,null,1,"Enter the estimated weekday setback hours",null,null,null,null,null,null,null,null,null,null,"hrs/day"]
[null,null,2,"Multiply line 1 by 5",null,null,null,null,null,null,{"$f":"M21*5","v":0},null,"Hours"]
[null,null,3,"Enter the estimated weekend setback hours",null,null,null,null,null,null,null,null,null,null,"hrs/day"]
[null,null,4,"Multiply line 3 by 2",null,null,null,null,null,null,{"$f":"M23*2","v":0},null,"Hours"]
[null,null,5,"Add line 2 and line 4",null,null,null,null,null,null,{"$f":"K22+K24","v":0},null,"Hours"]
[null,null,6,"Divide line 5 by168 hours",null,null,null,null,null,null,{"$f":"IF(K25>0,K25/168,\"\")","v":""}]
[null,null,7,"Enter the average setback temperature difference",null,null,null,null,null,null,null,null,null,null,"oF"]
[null,null,8,"Multiply (line 6 x line 7) by 0.0105",null,null,null,null,null,null,{"$f":"IFERROR(K26*M27*0.0105,\"\")","v":""}]
[]
[null,null,"If the heating energy source is not used for any other purposes and the cost for heating the building is known, then skip lines 9 through 12 and enter the value on line 13. If the energy source supplies heating as well as other needs of the building, go to line 9."]
[]
[]
[null,null,9,"Total the seven energy bills in which heating is included (e.g. Oct. through April) and enter that amount",null,null,null,null,null,null,null,null,null,null,0]
[null,null,10,"Enter the amount of the neutral month (i.e., May) energy bill",null,null,null,null,null,null,null,null,null,null,0]
[null,null,11,"Multiply line 10 by 7",null,null,null,null,null,null,null,null,{"$f":"O34*7","v":0}]
[null,null,12,"Subtract line 10 from line 9 AND ENTER THIS VALUE ON LINE 13 BELOW",null,null,null,null,null,null,null,null,{"$f":"IF(O34>0,O33-M35,0)","v":0}]
[null,null,13,"ANNUAL HEATING COST ",null,null,null,null,null,null,null,null,{"$f":"M36","v":0}]
[]
[null,"AREAS AFFECTED"]
[]
[null,null,14,"Total area heated by meter",null,null,null,null,null,null,null,null,null,null,null,null,"ft2"]
[null,null,15,"Area affected by the propose project",null,null,null,null,null,null,null,null,null,null,null,null,"ft2"]
[null,null,16,"Divide line 9 by line 10",null,null,null,null,null,null,null,null,{"$f":"IFERROR(O42/O41,0)","v":0}]
[]
[null,"ANNUAL SAVINGS"]
[]
[null,null,17,"Multiply (line 8 x line 13) by line 16",null,null,null,null,null,null,null,null,{"$f":"IFERROR(K28*M37*M43,\"\")","v":""},null,"/Year"]
[]
[null,"PROJECT COST"]
[]
[null,null,18,"Enter the total cost for the proposed project including material, labor, and design",null,null,null,null,null,null,null,null,0]
[]
[null,"SIMPLE PAYBACK"]
[]
[null,null,19,"Divide line 18 by line 17",null,null,null,null,null,null,{"$f":"IFERROR(M51/M47,0)","v":0},null,null,"Years"]
[]
[]
[]
[null,"DESCRIPTION PAGE"]
[null,"Programmable Setback Thermostat Energy Conservation Measure"]
[null,"Describe the existing system and the proposed energy conservation measure (use additional sheets if necessary):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Windows U-Value","index":17,"n_rows":57,"n_cols":34,"rows_kept":57,"cut":false,"hidden":true,"merged":[[0,0,0,9],[55,0,55,27],[56,0,57,27],[4,22,5,22],[4,23,5,23],[4,24,5,24],[4,25,5,25],[4,26,5,26],[4,27,5,27],[4,16,5,16],[4,17,5,17],[4,18,5,18],[4,19,5,19],[4,20,5,20],[4,21,5,21],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[3,25,3,27],[4,0,4,2],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[2,0,3,2],[2,4,3,5],[2,6,2,18],[2,19,2,27],[3,6,3,10],[3,11,3,15],[3,16,3,18],[3,19,3,20],[3,21,3,24]]}
["Table 4. U-Factors for Various Fenestration Products in Btu/h · ft2 · °F"]
[]
["Product Type",null,null,null,"Glass Only",null,"Vertical Installation",null,null,null,null,null,null,null,null,null,null,null,null,"Sloped Installation"]
[null,null,null,null,null,null,"Operable (including sliding and swinging glass doors)",null,null,null,null,"Fixed",null,null,null,null,"Curtain Wall",null,null,"Glass Only (Skylights)",null,"Manufactured Skylight",null,null,null,"Site-Assembled Sloped/Overhead Glazing"]
["Frame Type",null,null,null,"Center of Glass","Edge of Glass","Aluminum Without Thermal Break","Aluminum with Thermal Break","Reinforced Vinyl/Aluminum Clad Wood","Wood/Vinyl","Insulated Fiberglass/Vinyl","Aluminum Without Thermal Break","Aluminum with Thermal Break","Reinforced Vinyl/Aluminum Clad Wood","Wood/Vinyl","Insulated Fiberglass/Vinyl","Aluminum Without Thermal Break","Aluminum with Thermal Break","Structural Glazing","Center of Glass","Edge of Glass","Aluminum Without Thermal Break","Aluminum with Thermal Break","Reinforced Vinyl/Aluminum Clad Wood","Wood/Vinyl","Aluminum Without Thermal Break","Aluminum with Thermal Break","Structural Glazing"]
["ID",null,"Glazing Type","Glass Type"]
[null,null,null,"Select the glass 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,"Select type of windows",null,"Select storm window"]
[1,"Single Glazing","1/8 in. glass",{"$f":"B8&\" - \"&C8","v":"Single Glazing - 1/8 in. glass"},1.04,1.04,1.23,1.07,0.93,0.91,0.85,1.1200000000000001,1.07,0.98,0.98,1.04,1.21,1.1000000000000001,1.1000000000000001,1.19,1.19,1.77,1.7,1.61,1.42,1.35,1.34,1.25,null,"Operable","Aluminum Without Thermal Break",{"$f":"AD8&\" - \"&AE8","v":"Operable - Aluminum Without Thermal Break"},null,"No storm window"]
[2,"Single Glazing","1/4 in. acrylic/polycarbonate",{"$f":"B9&\" - \"&C9","v":"Single Glazing - 1/4 in. acrylic/polycarbonate"},0.88,0.88,1.1000000000000001,0.94,0.81,0.8,0.74,0.98,0.92,0.84,0.84,0.88,1.06,0.96,0.96,1.03,1.03,1.6,1.54,1.45,1.31,1.2,1.2,1.1000000000000001,null,"Operable","Aluminum with Thermal Break",{"$f":"AD9&\" - \"&AE9","v":"Operable - Aluminum with Thermal Break"},"Storm Window","With storm window"]
[3,"Single Glazing","1/8 in. acrylic/polycarbonate","Single Glazing - 1/8 in. acrylic/polycarbonate",0.96,0.96,1.17,1.01,0.87,0.86,0.79,1.05,0.99,0.91,0.91,0.96,1.1299999999999999,1.03,1.03,1.1100000000000001,1.1100000000000001,1.68,1.62,1.53,1.39,1.27,1.27,1.18,null,"Operable","Reinforced Vinyl/Aluminum Clad Wood","Operable - Reinforced Vinyl/Aluminum Clad Wood","Storm Window"]
[4,"Double Glazing","1/4 in. air space","Double Glazing - 1/4 in. air space",0.55000000000000004,0.64,0.81,0.64,0.56999999999999995,0.55000000000000004,0.5,0.68,0.62,0.56000000000000005,0.56000000000000005,0.55000000000000004,0.77,0.67,0.63,0.57999999999999996,0.66,1.1000000000000001,0.96,0.92,0.84,0.8,0.83,0.66,null,"Operable","Wood/Vinyl","Operable - Wood/Vinyl","Storm Window"]
[5,"Double Glazing","1/2 in. air space","Double Glazing - 1/2 in. air space",0.48,0.59,0.76,0.57999999999999996,0.52,0.5,0.45,0.62,0.56000000000000005,0.5,0.5,0.48,0.71,0.61,0.56999999999999995,0.56999999999999995,0.65,1.0900000000000001,0.95,0.91,0.84,0.79,0.82,0.65,null,"Operable","Insulated Fiberglass/Vinyl","Operable - Insulated Fiberglass/Vinyl","Storm Window"]
[6,"Double Glazing","1/4 in. argon space","Double Glazing - 1/4 in. argon space",0.51,0.61,0.78,0.61,0.54,0.52,0.47,0.65,0.59,0.53,0.52,0.51,0.74,0.63,0.59,0.53,0.63,1.05,0.91,0.87,0.8,0.76,0.8,0.62,null,"Fixed","Aluminum Without Thermal Break","Fixed - Aluminum Without Thermal Break","Storm Window"]
[7,"Double Glazing","1/2 in. argon space","Double Glazing - 1/2 in. argon space",0.45,0.56999999999999995,0.73,0.56000000000000005,0.5,0.48,0.43,0.6,0.53,0.48,0.47,0.45,0.68,0.57999999999999996,0.54,0.53,0.63,1.05,0.91,0.87,0.8,0.76,0.8,0.62,null,"Fixed","Aluminum with Thermal Break","Fixed - Aluminum with Thermal Break","Storm Window"]
[8,"Double Glazing, e = 0.60","1/4 in. air space","Double Glazing, e = 0.60 - 1/4 in. air space",0.52,0.62,0.79,0.61,0.55000000000000004,0.53,0.48,0.66,0.59,0.54,0.53,0.52,0.74,0.64,0.6,0.54,0.63,1.06,0.92,0.88,0.81,0.77,0.8,0.63,null,"Fixed","Reinforced Vinyl/Aluminum Clad Wood","Fixed - Reinforced Vinyl/Aluminum Clad Wood"]
[9,"Double Glazing, e = 0.60","1/2 in. air space","Double Glazing, e = 0.60 - 1/2 in. air space",0.44,0.56000000000000005,0.72,0.55000000000000004,0.49,0.48,0.43,0.59,0.53,0.47,0.47,0.44,0.68,0.56999999999999995,0.53,0.53,0.63,1.05,0.91,0.87,0.8,0.76,0.8,0.62,null,"Fixed","Wood/Vinyl","Fixed - Wood/Vinyl"]
[10,"Double Glazing, e = 0.60","1/4 in. argon space","Double Glazing, e = 0.60 - 1/4 in. argon space",0.47,0.57999999999999996,0.75,0.56999999999999995,0.51,0.5,0.45,0.61,0.55000000000000004,0.49,0.49,0.47,0.7,0.6,0.56000000000000005,0.49,0.6,1.01,0.87,0.83,0.76,0.72,0.77,0.57999999999999996,null,"Fixed","Insulated Fiberglass/Vinyl","Fixed - Insulated Fiberglass/Vinyl"]
[11,"Double Glazing, e = 0.60","1/2 in. argon space","Double Glazing, e = 0.60 - 1/2 in. argon space",0.41,0.54,0.7,0.53,0.47,0.45,0.41,0.56000000000000005,0.5,0.44,0.44,0.41,0.65,0.55000000000000004,0.51,0.49,0.6,1.01,0.87,0.83,0.76,0.72,0.77,0.57999999999999996,null,"Curtain Wall",{"$f":"AE8","v":"Aluminum Without Thermal Break"},"Curtain Wall - Aluminum Without Thermal Break"]
[12,"Double Glazing, e = 0.40","1/4 in. air space","Double Glazing, e = 0.40 - 1/4 in. air space",0.49,0.6,0.76,0.59,0.53,0.51,0.46,0.63,0.56999999999999995,0.51,0.51,0.49,0.72,0.62,0.57999999999999996,0.51,0.61,1.03,0.89,0.85,0.78,0.74,0.78,0.6,null,"Curtain Wall",{"$f":"AE9","v":"Aluminum with Thermal Break"},"Curtain Wall - Aluminum with Thermal Break"]
[13,"Double Glazing, e = 0.40","1/2 in. air space","Double Glazing, e = 0.40 - 1/2 in. air space",0.4,0.54,0.69,0.52,0.47,0.45,0.4,0.55000000000000004,0.49,0.44,0.43,0.4,0.64,0.54,0.5,0.5,0.61,1.02,0.88,0.84,0.77,0.73,0.78,0.59,null,"Curtain Wall","Structural Glazing","Curtain Wall - Structural Glazing"]
[14,"Double Glazing, e = 0.40","1/4 in. argon space","Double Glazing, e = 0.40 - 1/4 in. argon space",0.43,0.56000000000000005,0.72,0.54,0.49,0.47,0.42,0.57999999999999996,0.52,0.46,0.46,0.43,0.67,0.56000000000000005,0.52,0.44,0.56000000000000005,0.96,0.83,0.78,0.72,0.68,0.74,0.54]
[15,"Double Glazing, e = 0.40","1/2 in. argon space","Double Glazing, e = 0.40 - 1/2 in. argon space",0.36,0.51,0.66,0.49,0.44,0.42,0.37,0.52,0.46,0.4,0.4,0.36,0.61,0.5,0.46,0.46,0.57999999999999996,0.98,0.85,0.8,0.74,0.7,0.75,0.56000000000000005]
[16,"Double Glazing, e = 0.20 ","1/4 in. air space","Double Glazing, e = 0.20  - 1/4 in. air space",0.45,0.56999999999999995,0.73,0.56000000000000005,0.5,0.48,0.43,0.6,0.53,0.48,0.47,0.45,0.68,0.57999999999999996,0.54,0.46,0.57999999999999996,0.98,0.85,0.8,0.74,0.7,0.75,0.56000000000000005]
[17,"Double Glazing, e = 0.20 ","1/2 in. air space","Double Glazing, e = 0.20  - 1/2 in. air space",0.35,0.5,0.65,0.48,0.43,0.41,0.37,0.51,0.45,0.39,0.39,0.35,0.6,0.5,0.45,0.46,0.57999999999999996,0.98,0.85,0.8,0.74,0.7,0.75,0.56000000000000005]
[18,"Double Glazing, e = 0.20 ","1/4 in. argon space","Double Glazing, e = 0.20  - 1/4 in. argon space",0.38,0.52,0.68,0.51,0.45,0.43,0.39,0.54,0.47,0.42,0.42,0.38,0.62,0.52,0.48,0.39,0.53,0.91,0.78,0.74,0.68,0.64,0.7,0.5]
[19,"Double Glazing, e = 0.20 ","1/2 in. argon space","Double Glazing, e = 0.20  - 1/2 in. argon space",0.3,0.46,0.61,0.45,0.39,0.38,0.33,0.47,0.41,0.35,0.35,0.3,0.55000000000000004,0.45,0.41,0.4,0.54,0.92,0.79,0.75,0.68,0.64,0.71,0.51]
[20,"Double Glazing, e = 0.10","1/4 in. air space","Double Glazing, e = 0.10 - 1/4 in. air space",0.42,0.55000000000000004,0.71,0.54,0.48,0.46,0.41,0.56999999999999995,0.51,0.45,0.45,0.42,0.66,0.56000000000000005,0.51,0.44,0.56000000000000005,0.96,0.83,0.78,0.72,0.68,0.74,0.54]
[21,"Double Glazing, e = 0.10","1/2 in. air space","Double Glazing, e = 0.10 - 1/2 in. air space",0.32,0.48,0.63,0.46,0.41,0.39,0.34,0.49,0.42,0.37,0.37,0.32,0.56999999999999995,0.47,0.43,0.44,0.56000000000000005,0.96,0.83,0.78,0.72,0.68,0.74,0.54]
[22,"Double Glazing, e = 0.10","1/4 in. argon space","Double Glazing, e = 0.10 - 1/4 in. argon space",0.35,0.5,0.65,0.48,0.43,0.41,0.37,0.51,0.45,0.39,0.39,0.35,0.6,0.5,0.45,0.36,0.51,0.88,0.75,0.71,0.65,0.61,0.68,0.47]
[23,"Double Glazing, e = 0.10","1/2 in. argon space","Double Glazing, e = 0.10 - 1/2 in. argon space",0.27,0.44,0.59,0.42,0.37,0.36,0.31,0.44,0.38,0.33,0.32,0.27,0.53,0.43,0.38,0.38,0.52,0.9,0.77,0.73,0.67,0.63,0.69,0.49]
[24,"Double Glazing, e = 0.05","1/4 in. air space","Double Glazing, e = 0.05 - 1/4 in. air space",0.41,0.54,0.7,0.53,0.47,0.45,0.41,0.56000000000000005,0.5,0.44,0.44,0.41,0.65,0.55000000000000004,0.51,0.42,0.55000000000000004,0.94,0.81,0.76,0.7,0.66,0.72,0.52]
[25,"Double Glazing, e = 0.05","1/2 in. air space","Double Glazing, e = 0.05 - 1/2 in. air space",0.3,0.46,0.61,0.45,0.39,0.38,0.33,0.47,0.41,0.35,0.35,0.3,0.55000000000000004,0.45,0.41,0.43,0.56000000000000005,0.95,0.82,0.77,0.71,0.67,0.73,0.53]
[26,"Double Glazing, e = 0.05","1/4 in. argon space","Double Glazing, e = 0.05 - 1/4 in. argon space",0.33,0.48,0.64,0.47,0.42,0.4,0.35,0.49,0.43,0.38,0.37,0.33,0.57999999999999996,0.48,0.44,0.34,0.49,0.86,0.73,0.69,0.63,0.59,0.66,0.45]
[27,"Double Glazing, e = 0.05","1/2 in. argon space","Double Glazing, e = 0.05 - 1/2 in. argon space",0.25,0.42,0.56999999999999995,0.41,0.36,0.34,0.3,0.43,0.36,0.31,0.31,0.25,0.51,0.41,0.37,0.36,0.51,0.88,0.75,0.71,0.65,0.61,0.68,0.47]
[28,"Triple Glazing","1/4 in. air spaces","Triple Glazing - 1/4 in. air spaces",0.38,0.52,0.67,0.49,0.43,0.43,0.38,0.53,0.47,0.42,0.42,0.38,0.61,0.51,0.46,0.39,0.53,0.9,0.75,0.71,0.64,0.62,0.69,0.48]
[29,"Triple Glazing","1/2 in. air spaces","Triple Glazing - 1/2 in. air spaces",0.31,0.47,0.61,0.44,0.38,0.38,0.34,0.47,0.41,0.36,0.36,0.31,0.55000000000000004,0.45,0.4,0.36,0.51,0.87,0.72,0.68,0.61,0.6,0.67,0.45]
[30,"Triple Glazing","1/4 in. argon spaces","Triple Glazing - 1/4 in. argon spaces",0.34,0.49,0.63,0.46,0.41,0.4,0.36,0.5,0.44,0.38,0.38,0.34,0.57999999999999996,0.48,0.43,0.35,0.5,0.86,0.71,0.67,0.6,0.59,0.66,0.44]
[31,"Triple Glazing","1/2 in. argon spaces","Triple Glazing - 1/2 in. argon spaces",0.28999999999999998,0.45,0.59,0.42,0.37,0.36,0.32,0.45,0.4,0.34,0.34,0.28999999999999998,0.53,0.43,0.38,0.33,0.48,0.84,0.69,0.65,0.59,0.56999999999999995,0.65,0.42]
[32,"Triple Glazing, e = 0.20","1/4 in. air spaces","Triple Glazing, e = 0.20 - 1/4 in. air spaces",0.33,0.48,0.62,0.45,0.4,0.39,0.35,0.49,0.43,0.37,0.37,0.33,0.56999999999999995,0.47,0.42,0.34,0.49,0.85,0.7,0.66,0.59,0.57999999999999996,0.65,0.43]
[33,"Triple Glazing, e = 0.20","1/2 in. air spaces","Triple Glazing, e = 0.20 - 1/2 in. air spaces",0.25,0.42,0.56000000000000005,0.39,0.34,0.33,0.28999999999999998,0.42,0.36,0.31,0.31,0.25,0.5,0.4,0.35,0.31,0.47,0.82,0.67,0.63,0.56999999999999995,0.56000000000000005,0.63,0.41]
[34,"Triple Glazing, e = 0.20","1/4 in. argon spaces","Triple Glazing, e = 0.20 - 1/4 in. argon spaces",0.28000000000000003,0.45,0.57999999999999996,0.41,0.36,0.36,0.31,0.45,0.39,0.33,0.33,0.28000000000000003,0.53,0.43,0.37,0.28000000000000003,0.45,0.8,0.64,0.6,0.54,0.53,0.61,0.38]
[35,"Triple Glazing, e = 0.20","1/2 in. argon spaces","Triple Glazing, e = 0.20 - 1/2 in. argon spaces",0.22,0.4,0.54,0.37,0.32,0.31,0.27,0.39,0.33,0.28000000000000003,0.28000000000000003,0.22,0.47,0.37,0.32,0.27,0.44,0.79,0.63,0.59,0.53,0.52,0.6,0.37]
[36,"Triple Glazing, e = 0.20","1/4 in. air spaces","Triple Glazing, e = 0.20 - 1/4 in. air spaces",0.28999999999999998,0.45,0.59,0.42,0.37,0.36,0.32,0.45,0.4,0.34,0.34,0.28999999999999998,0.53,0.43,0.38,0.28999999999999998,0.45,0.81,0.65,0.61,0.55000000000000004,0.54,0.62,0.39]
[37,"Triple Glazing, e = 0.20","1/2 in. air spaces","Triple Glazing, e = 0.20 - 1/2 in. air spaces",0.2,0.39,0.52,0.35,0.31,0.3,0.26,0.38,0.32,0.26,0.26,0.2,0.46,0.36,0.3,0.27,0.44,0.79,0.63,0.59,0.53,0.52,0.6,0.37]
[38,"Triple Glazing, e = 0.20","1/4 in. argon spaces","Triple Glazing, e = 0.20 - 1/4 in. argon spaces",0.23,0.41,0.54,0.37,0.33,0.32,0.28000000000000003,0.4,0.34,0.28999999999999998,0.28999999999999998,0.23,0.48,0.38,0.33,0.24,0.42,0.76,0.6,0.56999999999999995,0.5,0.49,0.57999999999999996,0.35]
[39,"Triple Glazing, e = 0.20","1/2 in. argon spaces","Triple Glazing, e = 0.20 - 1/2 in. argon spaces",0.17,0.36,0.49,0.33,0.28000000000000003,0.28000000000000003,0.24,0.35,0.28999999999999998,0.24,0.24,0.17,0.43,0.33,0.28000000000000003,0.22,0.4,0.74,0.57999999999999996,0.55000000000000004,0.49,0.48,0.56999999999999995,0.33]
[40,"Triple Glazing, e = 0.10","1/4 in. air spaces","Triple Glazing, e = 0.10 - 1/4 in. air spaces",0.27,0.44,0.57999999999999996,0.4,0.36,0.35,0.31,0.44,0.38,0.32,0.32,0.27,0.52,0.42,0.37,0.27,0.44,0.79,0.63,0.59,0.53,0.52,0.6,0.37]
[41,"Triple Glazing, e = 0.10","1/2 in. air spaces","Triple Glazing, e = 0.10 - 1/2 in. air spaces",0.18,0.37,0.5,0.34,0.28999999999999998,0.28000000000000003,0.25,0.36,0.3,0.25,0.25,0.18,0.44,0.34,0.28999999999999998,0.25,0.42,0.77,0.61,0.56999999999999995,0.51,0.5,0.59,0.36]
[42,"Triple Glazing, e = 0.10","1/4 in. argon spaces","Triple Glazing, e = 0.10 - 1/4 in. argon spaces",0.21,0.39,0.53,0.36,0.31,0.31,0.27,0.38,0.33,0.27,0.27,0.21,0.46,0.36,0.31,0.21,0.39,0.73,0.56999999999999995,0.54,0.48,0.47,0.56000000000000005,0.32]
[43,"Triple Glazing, e = 0.10","1/2 in. argon spaces","Triple Glazing, e = 0.10 - 1/2 in. argon spaces",0.14000000000000001,0.34,0.47,0.3,0.26,0.26,0.22,0.32,0.27,0.21,0.21,0.14000000000000001,0.4,0.3,0.25,0.2,0.39,0.72,0.56000000000000005,0.53,0.47,0.46,0.55000000000000004,0.31]
[44,"Quadruple Glazing, e = 0.10","1/4 in. air spaces","Quadruple Glazing, e = 0.10 - 1/4 in. air spaces",0.22,0.4,0.54,0.37,0.32,0.31,0.27,0.39,0.33,0.28000000000000003,0.28000000000000003,0.22,0.47,0.37,0.32,0.22,0.4,0.74,0.57999999999999996,0.55000000000000004,0.49,0.48,0.56999999999999995,0.33]
[45,"Quadruple Glazing, e = 0.10","1/2 in. air spaces","Quadruple Glazing, e = 0.10 - 1/2 in. air spaces",0.15,0.35,0.48,0.31,0.27,0.26,0.23,0.33,0.27,0.22,0.22,0.15,0.41,0.31,0.26,0.19,0.38,0.71,0.55000000000000004,0.52,0.46,0.45,0.54,0.3]
[46,"Quadruple Glazing, e = 0.10","1/4 in. argon spaces",{"$f":"B53&\" - \"&C53","v":"Quadruple Glazing, e = 0.10 - 1/4 in. argon spaces"},0.17,0.36,0.49,0.33,0.28000000000000003,0.28000000000000003,0.24,0.35,0.28999999999999998,0.24,0.24,0.17,0.43,0.33,0.28000000000000003,0.18,0.37,0.7,0.54,0.51,0.45,0.44,0.54,0.28999999999999998]
[47,"Quadruple Glazing, e = 0.10","1/2 in. argon spaces","Quadruple Glazing, e = 0.10 - 1/2 in. argon spaces",0.12,0.32,0.45,0.28999999999999998,0.25,0.24,0.2,0.31,0.25,0.2,0.2,0.12,0.39,0.28999999999999998,0.23,0.16,0.35,0.68,0.52,0.49,0.43,0.42,0.52,0.28000000000000003]
[48,"Quadruple Glazing, e = 0.10","1/4 in. krypton spaces","Quadruple Glazing, e = 0.10 - 1/4 in. krypton spaces",0.12,0.32,0.45,0.28999999999999998,0.25,0.24,0.2,0.31,0.25,0.2,0.2,0.12,0.39,0.28999999999999998,0.23,0.13,0.33,0.65,0.49,0.46,0.4,0.4,0.5,0.25]
[]
["Notes:"]

{"sheet":"Fuel Use Summary (2)","index":18,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,1,7,3],[6,4,6,6],[6,7,7,8],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,1,8,2],[8,4,8,6],[8,9,8,10],[9,1,10,2],[9,3,10,3],[9,7,10,7],[9,8,10,8],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[47,2,47,9],[23,1,23,3],[24,1,25,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[26,4,27,6],[26,7,27,10],[28,1,28,3],[28,4,28,6],[28,7,28,10],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility providing Fuel",null,null,"SERVICE DATES",null,"Utility providing Fuel",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a fuel use summary for each meter by clicking a button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains information for the various fuels necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/Kwh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Fuel Use Summary (3)","index":19,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,1,7,3],[6,4,6,6],[6,7,7,8],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,1,8,2],[8,4,8,6],[8,9,8,10],[9,1,10,2],[9,3,10,3],[9,7,10,7],[9,8,10,8],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[47,2,47,9],[23,1,23,3],[24,1,25,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[26,4,27,6],[26,7,27,10],[28,1,28,3],[28,4,28,6],[28,7,28,10],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility providing Fuel",null,null,"SERVICE DATES",null,"Utility providing Fuel",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a fuel use summary for each meter by clicking a button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains information for the various fuels necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/Kwh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Fuel Use Summary (4)","index":20,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,1,7,3],[6,4,6,6],[6,7,7,8],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,1,8,2],[8,4,8,6],[8,9,8,10],[9,1,10,2],[9,3,10,3],[9,7,10,7],[9,8,10,8],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[47,2,47,9],[23,1,23,3],[24,1,25,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[26,4,27,6],[26,7,27,10],[28,1,28,3],[28,4,28,6],[28,7,28,10],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility providing Fuel",null,null,"SERVICE DATES",null,"Utility providing Fuel",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a fuel use summary for each meter by clicking a button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains information for the various fuels necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/Kwh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Fuel Use Summary (5)","index":21,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,1,7,3],[6,4,6,6],[6,7,7,8],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,1,8,2],[8,4,8,6],[8,9,8,10],[9,1,10,2],[9,3,10,3],[9,7,10,7],[9,8,10,8],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[47,2,47,9],[23,1,23,3],[24,1,25,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[26,4,27,6],[26,7,27,10],[28,1,28,3],[28,4,28,6],[28,7,28,10],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility providing Fuel",null,null,"SERVICE DATES",null,"Utility providing Fuel",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a fuel use summary for each meter by clicking a button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains information for the various fuels necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/Kwh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Fuel Use Summary (6)","index":22,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,1,7,3],[6,4,6,6],[6,7,7,8],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,1,8,2],[8,4,8,6],[8,9,8,10],[9,1,10,2],[9,3,10,3],[9,7,10,7],[9,8,10,8],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[47,2,47,9],[23,1,23,3],[24,1,25,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[26,4,27,6],[26,7,27,10],[28,1,28,3],[28,4,28,6],[28,7,28,10],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility providing Fuel",null,null,"SERVICE DATES",null,"Utility providing Fuel",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a fuel use summary for each meter by clicking a button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains information for the various fuels necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/Kwh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Fuel Use Summary (7)","index":23,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,1,7,3],[6,4,6,6],[6,7,7,8],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,1,8,2],[8,4,8,6],[8,9,8,10],[9,1,10,2],[9,3,10,3],[9,7,10,7],[9,8,10,8],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[47,2,47,9],[23,1,23,3],[24,1,25,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[26,4,27,6],[26,7,27,10],[28,1,28,3],[28,4,28,6],[28,7,28,10],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility providing Fuel",null,null,"SERVICE DATES",null,"Utility providing Fuel",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a fuel use summary for each meter by clicking a button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains information for the various fuels necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/Kwh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Fuel Use Summary (8)","index":24,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,1,7,3],[6,4,6,6],[6,7,7,8],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,1,8,2],[8,4,8,6],[8,9,8,10],[9,1,10,2],[9,3,10,3],[9,7,10,7],[9,8,10,8],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[47,2,47,9],[23,1,23,3],[24,1,25,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[26,4,27,6],[26,7,27,10],[28,1,28,3],[28,4,28,6],[28,7,28,10],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility providing Fuel",null,null,"SERVICE DATES",null,"Utility providing Fuel",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a fuel use summary for each meter by clicking a button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains information for the various fuels necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/Kwh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Fuel Use Summary (9)","index":25,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,1,7,3],[6,4,6,6],[6,7,7,8],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,1,8,2],[8,4,8,6],[8,9,8,10],[9,1,10,2],[9,3,10,3],[9,7,10,7],[9,8,10,8],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[47,2,47,9],[23,1,23,3],[24,1,25,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[26,4,27,6],[26,7,27,10],[28,1,28,3],[28,4,28,6],[28,7,28,10],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility providing Fuel",null,null,"SERVICE DATES",null,"Utility providing Fuel",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a fuel use summary for each meter by clicking a button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains information for the various fuels necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/Kwh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Fuel Use Summary (10)","index":26,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,1,7,3],[6,4,6,6],[6,7,7,8],[6,9,6,10],[7,4,7,6],[7,9,7,10],[8,1,8,2],[8,4,8,6],[8,9,8,10],[9,1,10,2],[9,3,10,3],[9,7,10,7],[9,8,10,8],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[47,2,47,9],[23,1,23,3],[24,1,25,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[26,4,27,6],[26,7,27,10],[28,1,28,3],[28,4,28,6],[28,7,28,10],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility providing Fuel",null,null,"SERVICE DATES",null,"Utility providing Fuel",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a fuel use summary for each meter by clicking a button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains information for the various fuels necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/Kwh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"Sheet1","index":27,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Fuel Use Summary","index":28,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":false,"merged":[[28,1,28,3],[9,3,10,3],[9,7,10,7],[9,8,10,8],[28,4,28,6],[28,7,28,10],[26,7,27,10],[8,9,8,10],[8,4,8,6],[0,5,0,10],[1,5,1,10],[2,5,2,10],[3,5,3,10],[4,5,4,7],[4,8,4,10],[5,5,5,7],[5,8,5,10],[6,7,7,8],[6,9,6,10],[7,9,7,10],[6,1,7,3],[24,4,24,5],[25,4,25,5],[26,1,27,3],[24,1,25,3],[26,4,27,6],[23,1,23,3],[6,4,6,6],[7,4,7,6],[47,2,47,9],[8,1,8,2],[9,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[34,2,34,9]]}
[null,null,null,null,null,"Applicant Organization Name"]
[null,null,null,null,null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""}]
[null,null,null,null,null,"Specific Building or System Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Units","MMBTU conversion Factor"]
[null,null,null,null,null,"Total Area Cooled in Square Feet",null,null,"Total Area Heated in Square Feet",null,null,null,null,"CCF",10,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Therm",10,"MMBtu"]
[null,"SERVICE DATES",null,null,"Utility Provider",null,null,"SERVICE DATES",null,"Utility Provider",null,null,null,"MMBtu",1,"MMBtu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallon Propane",10.9,"MMBtu"]
[null,"FROM",null,"TO","ELECTRICITY",null,null,"FROM","TO","FUEL\nNatural Gas/\nFuel Oil / LPG / Other",null,null,null,"Gallon Oil",7.2,"MMBtu"]
[null,"MM/DD/YYYY",null,"MM/DD/YYYY","USAGE","DEMAND","COST","MM/DD/YYYY","MM/DD/YYYY","USAGE","COST",null,null,"Ton Coal",4.4999999999999998E-2,"MMBtu"]
[null,null,null,null,"(kWh)","(kW)","($)",null,null,"CCF","($)",null,null,"Cord Wood",4.4999999999999998E-2,"MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANNUAL TOTAL",null,null,{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[null,"AVERAGE UNIT COST",null,null,{"$f":"IFERROR(G24/E24,\"\")","v":""},null,"$/kWh",null,null,{"$f":"IFERROR(K24/J24,\"\")","v":""},{"$f":"\"$ per \"&J11","v":"$ per CCF"}]
[null,null,null,null,{"$f":"IFERROR(E25*1000000/3412,\"\")","v":""},null,"$/MMBtu",null,null,{"$f":"IFERROR(J25*VLOOKUP(J11,N5:O9,2,FALSE),\"\")","v":""},"$/MMBtu"]
[null,"ACCOUNT NUMBER"]
[]
[null,"METER NUMBER"]
[]
[]
[null,"FUEL USE SUMMARY - INSTRUCTION"]
[]
[null,null,"Please complete an individual Fuel Use Summary for each meter with proposed energy conservation measures.  "]
[null,null,"Please complete the Fuel Use Summary using data from the most recent 12 months of energy bills. Copies of those energy bills must be submitted with the application."]
[]
[null,"FUEL USE SUMMARY FOR MULTIPLE METERS"]
[]
[null,null,"If the project involves more than one meter, please fill out a Fuel Use Summary for each meter by clicking the button below."]
[]
[]
[]
[]
[]
[]
[null,"CONVERSION TABLE"]
[]
[null,null,"The table below contains conversion information necessary to compute the cost of a million Btu (MMBtu) for each fuel.  To use the table, find the relevant fuel type, determine the cost per unit of that fuel and multiply by the appropriate conversion number to obtain the cost per MMBtu."]
[]
[null,null,null,"Fuel Type","Abbreviation","Multiply","By","To Obtain"]
[]
[null,null,null,"Electricity","E","$/kWh",293,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/Therm",10,"$/MMBtu"]
[]
[null,null,null,"Natural Gas","NG","$/CCF",10,"$/MMBtu"]
[]
[null,null,null,"Propane","LPG","$/Gallon",10.9,"$/MMBtu"]
[]
[null,null,null,"Oil","Oil","$/Gallon",7.2,"$/MMBtu"]
[]
[null,null,null,"Coal","Coal","$/Ton",4.4999999999999998E-2,"$/MMBtu"]
[]
[null,null,null,"Wood","Wood","$/Cord",4.4999999999999998E-2,"$/MMBtu"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"ECM Summary","index":29,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,10],[19,1,20,1],[19,2,20,4],[19,5,20,5],[23,1,24,1],[23,2,24,4],[23,5,24,5],[23,9,24,10],[23,8,24,8],[19,9,20,10],[21,1,22,1],[21,2,22,4],[21,5,22,5],[21,9,22,10],[19,8,20,8],[21,8,22,8],[15,9,16,10],[17,1,18,1],[17,2,18,4],[17,5,18,5],[17,9,18,10],[15,8,16,8],[17,8,18,8],[15,1,16,1],[15,2,16,4],[15,5,16,5],[11,1,12,1],[11,2,12,4],[11,5,12,5],[11,9,12,10],[13,1,14,1],[13,2,14,4],[13,5,14,5],[13,9,14,10],[11,8,12,8],[13,8,14,8],[7,9,8,10],[9,1,10,1],[9,2,10,4],[9,5,10,5],[9,9,10,10],[7,8,8,8],[9,8,10,8],[27,1,27,2],[3,1,3,10],[25,1,26,4],[25,5,26,5],[25,8,26,8],[25,9,26,10],[4,2,4,4],[4,9,4,10],[5,1,6,1],[5,2,6,4],[5,5,6,5],[5,9,6,10],[5,8,6,8],[7,1,8,1],[7,2,8,4],[7,5,8,5]]}
[]
[null,"Enter the list of proposed energy conservation measures on this sheet. "]
[null,"APPLICANT ORGANIZATION NAME",null,null,null,null,null,null,null,null,null,null,null,null,null,"MMBtu"]
[null,{"$f":"IF('Application Authorization Form'!B7=0,\"\",'Application Authorization Form'!B7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"CCF"]
[null,"#","ECM Description",null,null,"Project Cost \n(a)","Annual\nFuel Savings\n(b)","Fuel Type","Annual\nCost Savings\n(c)","Simple Payback\n(a) ÷ (c)"]
[null,1,null,null,null,null,null,"kWh",null,{"$f":"IFERROR(F6/I6,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,2,null,null,null,0,null,"kWh",0,{"$f":"IFERROR(F8/I8,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,3,null,null,null,0,null,"kWh",0,{"$f":"IFERROR(F10/I10,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,4,null,null,null,0,null,"kWh",0,{"$f":"IFERROR(F12/I12,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,5,null,null,null,0,null,"kWh",0,{"$f":"IFERROR(F14/I14,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,6,null,null,null,0,null,"kWh",0,{"$f":"IFERROR(F16/I16,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,7,null,null,null,0,null,"kWh",0,{"$f":"IFERROR(F18/I18,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,8,null,null,null,0,null,"kWh",0,{"$f":"IFERROR(F20/I20,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,9,null,null,null,0,null,"kWh",0,{"$f":"IFERROR(F22/I22,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,10,null,null,null,0,null,"kWh",0,{"$f":"IFERROR(F24/I24,\"\")","v":""},null,null,null,null," "]
[null,null,null,null,null,null,null,"MMBtu"]
[null,"Summary",null,null,null,{"$f":"SUM(F6:F25)","v":0},{"$f":"IF(G6>0,(G6+G8+G10+G12+G14+G16+G18+G20+G22+G24),\"\")","v":""},"kWh",{"$f":"SUM(I6:I25)","v":0},{"$f":"IFERROR(F26/I26,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(G7>0,G7+G9+G11+G13+G15+G17+G19+G21+G23+G25,\"\")","v":""},"MMBtu"]
[null,{"$f":"Instructions!$B$79","v":"MO 780-3070 (12-24)"}]

{"sheet":"DNR-DE STAFF ONLY","index":30,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"merged":[[2,1,2,8],[2,9,2,16]]}
[]
[]
[null,"USER UI",null,null,null,null,null,null,null,"DNR-DE VIEW ONLY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"This page is for DNR-DE Internal use only."]