{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Admin","Instructions","Project Information","Guidelines Checklist","Results from eQuest","Results from EnergyPlus","Compliance Calculations","Quality Control Checks","Submittal Checklist","Revision Log","Reference","Ref_Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":118,"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":"Admin","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,4,1,21]]}
[null,null,null,null,"Admin"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Worksheet Protection On (Yes/No)","Yes"]
[]
[null,null,null,null,"Tab name","Tab Hidden?","Super Hidden?","Hide Rows?"]
[null,null,null,null,"Admin","X","X"]
[null,null,null,null,"Instructions",null,null,"X"]
[null,null,null,null,"Project Information",null,null,"X"]
[null,null,null,null,"Guidelines Checklist",null,null,"X"]
[null,null,null,null,"Results from eQuest","X"]
[null,null,null,null,"Results from EnergyPlus","X"]
[null,null,null,null,"Compliance Calculations",null,null,"X"]
[null,null,null,null,"Quality Control Checks",null,null,"X",null,null,"Release checklist"]
[null,null,null,null,"Submittal Checklist",null,null,"X",null,null,"1. Manually revise version # and release date on the Instructions tab"]
[null,null,null,null,"Reference","X","X",null,null,null,"2. Update Revision Log"]
[null,null,null,null,"Ref_Instructions","X","X",null,null,null,"3. Turn worksheet protection in cell F4 to \"Yes\""]
[null,null,null,null,"Revision Log",null,null,null,null,null,"4. Run macro to Protect All Sheets"]
[null,null,null,null,null,null,null,null,null,null,"5. Run macro to Protect Workbook"]
[null,null,null,null,null,null,null,null,null,null,"6. Run macro to Hide Rows for Publishing"]
[null,null,null,null,null,null,null,null,null,null,"7. Run macro to Hide Sheets for Publishing"]

{"sheet":"Instructions","index":1,"n_rows":67,"n_cols":28,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,4,1,21],[3,4,3,21],[5,4,5,21],[6,4,6,21],[7,4,7,21],[15,4,15,21],[14,4,14,21],[18,4,18,21],[17,4,17,21],[8,4,8,21],[9,4,9,21],[10,4,10,21],[11,4,11,21],[12,4,12,21],[16,4,16,21],[19,4,19,21],[21,4,21,21],[22,4,22,21],[23,4,23,21],[20,4,20,21],[25,4,25,21],[24,4,24,21],[27,4,27,21],[28,4,28,21],[29,4,29,21],[55,4,55,21],[50,4,50,21],[38,4,38,21],[26,4,26,21],[36,4,36,21],[37,4,37,21],[33,4,33,21],[53,4,53,21],[54,4,54,21],[30,4,30,21],[31,4,31,21],[32,4,32,21],[34,4,34,21],[35,4,35,21],[51,4,51,21],[52,4,52,21]]}
[null,null,null,null,"Instructions"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Version 1.1, Published 12/9/2024"]
[]
[null,null,null,null,"Table of Contents"]
[null,null,null,null,{"$f":"Instructions_GI_Header","v":"General Information"}]
[null,null,null,null,{"$f":"Instructions_How_To_Header","v":"How to use the TEDI Compliance Tool"}]
[null,null,null,null,{"$f":"Instructions_Productivity_Tips_Header","v":"Productivity Tips"}]
[null,null,null,null,{"$f":"Instructions_Cell_and_Font_Color_Legend_Header","v":"Cell and Font Color Legend"}]
[null,null,null,null,{"$f":"Instructions_Tab_Color_Legend_Header","v":"Tab Color Legend"}]
[null,null,null,null,{"$f":"Instructions_Acronyms_and_Abbreviations_Header","v":"Acronyms and Abbreviations"}]
[null,null,null,null,{"$f":"Instructions_Reference_Documents_Header","v":"Reference Documents"}]
[]
[null,null,null,null,"General Information"]
[null,null,null,null,"1. This TEDI Compliance Tool may be used to document compliance with Massachusetts Stretch Energy Code C407.1 Targeted Performance.\n2. This tool is designed to assist energy modelers in developing the energy model in accordance with Attachment C and documenting compliance. The Project Information tab should be completed prior to energy modeling to understand how to model and report different building area types."]
[null,null,null,null,"3. If you have any questions or comments regarding the TEDI Compliance Tool, please contact stretchcode@mass.gov."]
[null,null,null,null,"How to use the TEDI Compliance Tool"]
[null,null,null,null,"Step 1:  Enable macros\nIn order for the form to function correctly, when prompted with a Security Warning, enable macros by clicking Enable Content.  This tool is for use with Excel 2016 or later."]
[null,null,null,null,"Step 2: Complete Project Information tab\n1. Complete the Project Information tab before any other tabs as selections on this tab will trigger or hide project-specific information and tabs."]
[null,null,null,null,"Step 3: Review the Guidelines Checklist tab\n1. Review the Guidelines Checklist tab before and during energy modeling. This tab is designed to help ensure that the energy model is created following the Appendix C: Targeted Performance Simulation Guidelines."]
[null,null,null,null,"Step 4: Transfer simulation outputs into the Compliance Calculations tab\n1. Report the annual heating and cooling output of all systems in the building that maintain space temperature setpoints in Tables 1 and 2 on the Compliance Calculations tab.\n2. To perform automated quality control checks, the simulation results may be transferred from the  Building Energy Modeling (BEM) tool into the TEDI Compliance Tool by copying the standard reports generated by the BEM tool into the appropriate tab of the TEDI Compliance Tool. The appropriate tab (e.g. \"Results from eQUEST\" or \"Results from EnergyPlus\") will automatically become visible when the software tool is selected on the Project Information tab, and includes tool-specific instructions. \n2. On projects that used BEM tools which have not been pre-approved (i.e. not eQUEST or EnergyPlus), the simulation results must be manually entered on the Compliance Calculations tab. Although IESVE 2021.4.0.0+ is a pre-approved program, results from IESVE will need to be manually reported on the Compliance Calculations tab.\n\n"]
[null,null,null,null,"Step 5: Review Quality Control Checks tab\nReview and address all items that are flagged. Modify inputs in the TEDI Compliance Tool and/or the models as appropriate to address the flagged issues."]
[null,null,null,null,"Step 6: Fill out Submittal Checklist tab\nFill out the Submittal Checklist tab and ensure that all necessary project materials along with this TEDI Compliance Tool are included in the package submitted to the jurisdiction for review.\nStep 7: Generate Summary TEDI Compliance Report\nInformation entered in the TEDI Compliance Tool can be used to automatically generate a PDF report with high-level compliance information. The button and instructions for generating the summary compliance report are located on the Submittal Checklist tab."]
[null,null,null,null,"Productivity Tips"]
[null,null,null,null,"1. It is recommended for users to save the TEDI Compliance Tool often and to not use auto-recovered versions of the workbook.\n2. Help buttons are present throughout this tool to assist the user. If you are unsure of the meaning or intent of something, look for this button:"]
[null,null,null,null,"Cell and Font Color Legend"]
[null,null,null,null,"Tab headings"]
[null,null,null,null,"Table headings"]
[null,null,null,null,"Auto-populated cell, not editable."]
[null,null,null,null,"Editable cell requiring an input (unless otherwise noted)."]
[null,null,null,null,"Auto-populated editable cell in which text has not been overridden."]
[null,null,null,null,"Auto-populated editable cell in which overridden text is shown as bold orange."]
[null,null,null,null,"Tab Color Legend"]
[null,null,null,null,"Informative tabs"]
[null,null,null,null,"Tabs with modeler inputs related to the energy model"]
[null,null,null,null,"Tabs with simulation tool outputs and results"]
[null,null,null,null,"Tabs with checklists and quality control features"]
[null,null,null,null,"Acronyms and Abbreviations"]
[null,null,null,null,{"$f":"AA44","v":"AHJ"},{"$f":"AB44","v":"Authority having jurisdiction"},null,null,null,null,{"$f":"AA55","v":"HVAC"},{"$f":"AB55","v":"Heating, ventilation, and air conditioning"},null,null,null,null,{"$f":"AA66","v":"W"},{"$f":"AB66","v":"Watt"}]
[null,null,null,null,{"$f":"AA45","v":"BEM"},"Building energy modeling",null,null,null,null,{"$f":"AA56","v":"HW"},"Hot water",null,null,null,null,{"$f":"AA67","v":"WB"},"Wet-bulb"]
[null,null,null,null,{"$f":"AA46","v":"bhp"},"Break horsepower",null,null,null,null,{"$f":"AA57","v":"Misc."},"Miscellaneous"]
[null,null,null,null,{"$f":"AA47","v":"CFM"},"Cubic feet per minute",null,null,null,null,{"$f":"AA58","v":"NFRC"},"National Fenestration Rating Council"]
[null,null,null,null,{"$f":"AA48","v":"CHW"},"Chilled water",null,null,null,null,{"$f":"AA59","v":"OA"},"Outdoor air",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AHJ","Authority having jurisdiction"]
[null,null,null,null,{"$f":"AA49","v":"COP"},"Coefficient of performance",null,null,null,null,{"$f":"AA60","v":"PD"},"Pressure drop",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEM","Building energy modeling"]
[null,null,null,null,{"$f":"AA50","v":"CRRC"},"Cool Roof Rating Council",null,null,null,null,{"$f":"AA61","v":"PV"},"Photovoltaics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bhp","Break horsepower"]
[null,null,null,null,{"$f":"AA51","v":"DB"},"Dry-bulb",null,null,null,null,{"$f":"AA62","v":"sf"},"Square feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CFM","Cubic feet per minute"]
[null,null,null,null,{"$f":"AA52","v":"DOAS"},"Direct outside air system",null,null,null,null,{"$f":"AA63","v":"SHGC"},"Solar heat gain coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHW","Chilled water"]
[null,null,null,null,{"$f":"AA53","v":"EFLH"},"Equivalent full load hours",null,null,null,null,{"$f":"AA64","v":"TEDI"},"Thermal Energy Demand Intensity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP","Coefficient of performance"]
[null,null,null,null,{"$f":"AA54","v":"EUI"},"Energy Use Intensity",null,null,null,null,{"$f":"AA65","v":"VT"},"Visible transmittance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CRRC","Cool Roof Rating Council"]
[null,null,null,null,"Reference Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DB","Dry-bulb"]
[null,null,null,null,"Massachusetts Stretch Energy Code - 2023 Commercial amendments to IECC 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOAS","Direct outside air system"]
[null,null,null,null,"TEDI Schedule and Loads Guidelines Supplement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EFLH","Equivalent full load hours"]
[null,null,null,null,"Massachusetts Stretch Energy Codes 2023 Technical Guidance Document",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUI","Energy Use Intensity"]
[null,null,null,null,"Attachment C: Targeted Performance Simulation Guidelines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC","Heating, ventilation, and air conditioning"]
[null,null,null,null,"Attachment A: Envelope Performance and Thermal Bridging",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HW","Hot water"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc.","Miscellaneous"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NFRC","National Fenestration Rating Council"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OA","Outdoor air"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PD","Pressure drop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PV","Photovoltaics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sf","Square feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHGC","Solar heat gain coefficient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEDI","Thermal Energy Demand Intensity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT","Visible transmittance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W","Watt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WB","Wet-bulb"]

{"sheet":"Project Information","index":2,"n_rows":68,"n_cols":40,"rows_kept":68,"cut":false,"hidden":false,"merged":[[61,4,61,11],[65,4,65,5],[64,4,64,5],[66,4,66,5],[8,4,8,13],[39,4,39,13],[27,12,27,13],[28,12,28,13],[29,12,29,13],[49,6,50,6],[49,8,50,8],[43,4,43,13],[49,12,49,13],[49,7,50,7],[49,11,50,11],[35,12,35,13],[7,4,7,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[55,4,55,12],[30,12,30,13],[31,12,31,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[49,9,50,9],[49,10,50,10],[54,4,54,5],[51,4,51,5],[52,4,52,5],[53,4,53,5],[46,4,46,13],[42,4,42,10],[49,4,50,5],[0,4,1,10],[18,6,18,8],[19,6,19,8],[25,4,25,10],[11,4,11,10],[21,4,21,10],[15,6,15,8],[16,6,16,8],[17,6,17,8],[22,4,22,13],[4,4,4,13],[5,4,5,13],[6,4,6,13]]}
[null,null,null,null,"Project Information"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Table of Contents"]
[null,null,null,null,{"$f":"Proj_Info_Gen_Header","v":"General Information"}]
[null,null,null,null,{"$f":"Proj_Info_Table1_Header","v":"Table 1: Building Areas"}]
[null,null,null,null,{"$f":"Proj_Info_Table2_Header","v":"Table 2: Thermal Block Types and Standardized Model Inputs"}]
[null,null,null,null,{"$f":"Proj_Info_Default_HVAC_Sys_Header","v":"Table 3: Default HVAC System Configuration"}]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Instructions\n1. Complete the Project Information tab before completing any other tabs, as certain inputs on this tab influence the selections on subsequent tabs."]
[]
[null,null,null,null,"General Information"]
[]
[null,null,null,null,"Project name"]
[null,null,null,null,"Energy model based on",null,null,null,null,"<Specify docs date>"]
[null,null,null,null,"Simulation Program",null,null,null,null,"<Specify version>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default"]
[null,null,null,null,"Name of simulation weather file",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USA_MA_Boston-Logan.Intl.AP.725090_TMYx.2004-2018"]
[null,null,null,null,"Were external calculations used?",null,null,null,null,{"$f":"IF(G20=\"Yes\",\"Please submit documentation of the external calculations for review. See the Submittal Checklist tab for documentation requirements.\",\"\")","v":""}]
[]
[null,null,null,null,"Notes\nPlease include applicable notes as needed."]
[]
[]
[null,null,null,null,"Table 1: Building Areas"]
[null,null,null,null,"Instructions\n1. Enter the building area types, floor areas, and HVAC modeling method. Areas with different HVAC Modeling Methods, such as those with yet-to-be designed HVAC systems, should be reported on separate rows.\n2. Add additional rows using the \"Add Row(s)\" button below Table 1. Rows may also be removed using the \"Remove Row(s)\" button."]
[]
[null,null,null,null,"Building Area Type(s)","Floor Area That is Both Heated and Cooled (ft2)","Heated-Only Floor Area (ft2)","Unconditioned Floor Area (ft2)","Conditioned Floor Area (ft2)","Total, ft2","# of Above and Below Grade Floors","HVAC Design \nStatus","HVAC Modeling Method",null,null,null,null,null,null,null,null,null,null,null,null,null,"TEDI Space Use Type","Unique TEDI Space Uses","Sum Space Use Conditioned Areas","Percent of total conditioned floor area","Predominant?","Flag >10%?","TEDI Predominant Space type","Area to subtract from total conditioned (for calculating cooling TEDI)","Default HVAC Systems Flag","# As-designed","# Default as-designed","#As-designed methods","HVAC method flag, 1=flag","As-Designed HVAC Systems Flag"]
[null,null,1,null,null,null,null,null,{"$f":"IFERROR(F29+G29,\"-\")","v":0},{"$f":"IFERROR(I29+H29,\"-\")","v":0},null,null,{"$f":"IF(L29=\"Yet-to-be designed\",\"Default HVAC System Configuration\",\"\")","v":""},null,{"$f":"IF(N29=\"Yet-to-be designed\",\"Default HVAC System Configuration\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E29,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB28, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},{"$f":"SUMIF($AA$29:$AA$38,AB29,$I$29:$I$38)","v":0},{"$f":"AC29/$I$39","v":{"$error":"#DIV/0!"}},{"$f":"IF(AD29=MAX($AD$29:$AD$38),\"X\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(AE29<>\"X\",AD29>0.1),\"X\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"INDEX($AB$29:$AB$38,MATCH(\"X\",$AE$29:$AE$38,0),)","v":{"$error":"#N/A"}},{"$f":"IF(AND(M29=\"As-designed HVAC Systems\",AD29>0.1),G29,0)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(M29:N38,\"Default HVAC System Configuration\")","v":0},{"$f":"COUNTIF(L29:L38,\"Designed\")","v":0},{"$f":"COUNTIFS(L29:L38,\"Designed\",M29:M38,\"Default HVAC System Configuration\")","v":0},{"$f":"COUNTIFS(L29:L38,\"Designed\",M29:M38,\"As-designed HVAC Systems\")","v":0},{"$f":"IF(AND(AK29<>AJ29,AL29<>AJ29),1,0)","v":0},{"$f":"COUNTIF(M29:N38,\"As-Designed HVAC Systems\")","v":0}]
[null,null,1,null,null,null,null,null,{"$f":"IFERROR(F30+G30,\"-\")","v":0},{"$f":"IFERROR(I30+H30,\"-\")","v":0},null,null,{"$f":"IF(L30=\"Yet-to-be designed\",\"Default HVAC System Configuration\",\"\")","v":""},null,{"$f":"IF(N30=\"Yet-to-be designed\",\"Default HVAC System Configuration\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E30,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB29, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},{"$f":"SUMIF($AA$29:$AA$38,AB30,$I$29:$I$38)","v":0},{"$f":"AC30/$I$39","v":{"$error":"#DIV/0!"}},{"$f":"IF(AD30=MAX($AD$29:$AD$38),\"X\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(AE30<>\"X\",AD30>0.1),\"X\",\"\")","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"5 / 0","v":{"$error":"#DIV/0!"}},null,null,null,null,null,0,0,null,null,{"$f":"IF(L31=\"Yet-to-be designed\",\"Default HVAC System Configuration\",\"\")","v":""},null,{"$f":"IF(N31=\"Yet-to-be designed\",\"Default HVAC System Configuration\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E31,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB30, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}},null,null,null,null,null,0,0,null,null,{"$f":"IF(L32=\"Yet-to-be designed\",\"Default HVAC System Configuration\",\"\")","v":""},null,{"$f":"IF(AND(L32=\"Designed\",$AM$29=1),\"The selected approach shall be the same for all designed areas.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E32,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB31, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,0,0,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E33,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB32, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,0,0,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E34,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB33, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,0,0,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E35,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB34, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,0,0,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E36,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB35, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,0,0,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E37,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB36, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,0,0,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Type,MATCH(E38,TEDI_Bldg_Area_Type,0),),\"\")","v":""},{"$f":"IFERROR(INDEX($AA$29:$AA$38, MATCH(0, IF($AA$29:$AA$38<>\"\", COUNTIF($AB$28:AB37, $AA$29:$AA$38), \"\"), 0)), \"\")","v":""},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,null,null,"Total",{"$f":"SUM(F29:F38)","v":0},0,0,0,0,0,"-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(AH29:AH38)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(E40=\"\",5/0,1)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(COUNTIF(AF29:AF38,\"X\")<>0,\"One or more building area types comprises more than 10% of the total space conditioned area. Per C407.1.1.6 any use type with more than 10% of the total space conditioned area must separately and individually show compliance for that respective use type.\"&\" Please submit the non-predominant building area types that exceed 10% of the total space conditioned area in a separate TEDI Compliance Tool.\"&\" Use types that do not exceed 10% will be treated as the majority use type in TEDI calculations.\",\"\")","v":""}]
[]
[]
[null,null,null,null,"Notes\nPlease include applicable notes as needed."]
[]
[]
[null,null,null,null,"Table 2: Thermal Block Types and Standardized Model Inputs"]
[null,null,null,null,"Instructions\n1. Enter the thermal block types and gross floor areas. This information will be used to determine the standardized model inputs and perform automated quality control checks on the Quality Control Checks tab.\n2. Red filled cells in the \"Gross Floor Area (ft²) column indicates that the total reported thermal block floor area is more than 5% different from the total floor area reported in Table 1 and should be revised.\n3. Red filled cells in the \"Thermal Block Type\" column indicates that the selected thermal blocks do not match the building type. Resolve by selecting the appropriate thermal blocks in the dropdown."]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"Reference!BM3","v":1},{"$f":"Reference!BN3","v":2},{"$f":"Reference!BO3","v":3},{"$f":"Reference!BP3","v":4},{"$f":"Reference!BQ3","v":5},{"$f":"Reference!BR3","v":6},{"$f":"Reference!BS3","v":7}]
[null,null,null,null,"Thermal Block Type",null,"Gross Floor Area (ft2)","Schedule Index from Supplement","Misc. Loads*\nW/ft²","Lighting Power\nW/ft²","Ventilation Rate**\nCFM/ft²","Occupant Density\nft²/person","Occupant Heat Gain\nBtu/h-person"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sensible","Latent",null,null,null,null,null,null,null,null,null,null,null,null,"Row","Lighting EFLH","Lighting kWh","Misc EFLH","Misc kWh","Lgt Peak Fraction Sch","Misc Peak Fraction Sch","K-12 Cafeteria Area","Lighting W","Misc W","Lighting kWh","Misc kWh","SF Thermal Blocks"]
[null,null,1,null,null,null,null,{"$f":"IF($E52=\"\",\"\",INDEX(Inputs_Table,$AA52,H$49))","v":""},{"$f":"IF($E52=\"\",\"\",INDEX(Inputs_Table,$AA52,I$49))","v":""},{"$f":"IF($E52=\"\",\"\",INDEX(Inputs_Table,$AA52,J$49))","v":""},{"$f":"IF($E52=\"\",\"\",INDEX(Inputs_Table,$AA52,K$49))","v":""},{"$f":"IF($E52=\"\",\"\",INDEX(Inputs_Table,$AA52,L$49))","v":""},{"$f":"IF($E52=\"\",\"\",INDEX(Inputs_Table,$AA52,M$49))","v":""},{"$f":"IF($E52=\"\",\"\",INDEX(Inputs_Table,$AA52,N$49))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(Inputs_Thermal_Block_Lookup=E52),--(Inputs_Min_Area<Proj_Info_Cond_SF),--(Inputs_Max_Area>Proj_Info_Cond_SF),Inputs_Row)","v":0},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H52,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$AZ$3),\"\")","v":""},{"$f":"IFERROR(J52*G52/1000*AB52,\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H52,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BC$3),\"\")","v":""},{"$f":"IFERROR(I52*G52/1000*AD52,\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H52,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BD$3),\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H52,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BG$3),\"\")","v":""},{"$f":"SUMIF($E$52:$E$55,\"K-12 Cafeteria\",$G$52:$G$55)","v":0},{"$f":"SUMPRODUCT(G52:G55,J52:J55)","v":0},{"$f":"SUMPRODUCT(G52:G55,I52:I55)","v":0},{"$f":"SUM(AC52:AC55)","v":0},{"$f":"SUM(AE52:AE55)","v":0},{"$f":"SUM(G52:G55)","v":0}]
[null,null,{"$f":"5 / 0","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF($E53=\"\",\"\",INDEX(Inputs_Table,$AA53,H$49))","v":""},{"$f":"IF($E53=\"\",\"\",INDEX(Inputs_Table,$AA53,I$49))","v":""},{"$f":"IF($E53=\"\",\"\",INDEX(Inputs_Table,$AA53,J$49))","v":""},{"$f":"IF($E53=\"\",\"\",INDEX(Inputs_Table,$AA53,K$49))","v":""},{"$f":"IF($E53=\"\",\"\",INDEX(Inputs_Table,$AA53,L$49))","v":""},{"$f":"IF($E53=\"\",\"\",INDEX(Inputs_Table,$AA53,M$49))","v":""},{"$f":"IF($E53=\"\",\"\",INDEX(Inputs_Table,$AA53,N$49))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(Inputs_Thermal_Block_Lookup=E53),--(Inputs_Min_Area<Proj_Info_Cond_SF),--(Inputs_Max_Area>Proj_Info_Cond_SF),Inputs_Row)","v":0},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H53,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$AZ$3),\"\")","v":""},{"$f":"IFERROR(J53*G53/1000*AB53,\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H53,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BC$3),\"\")","v":""},{"$f":"IFERROR(I53*G53/1000*AD53,\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H53,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BD$3),\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H53,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BG$3),\"\")","v":""}]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"IF($E54=\"\",\"\",INDEX(Inputs_Table,$AA54,H$49))","v":""},{"$f":"IF($E54=\"\",\"\",INDEX(Inputs_Table,$AA54,I$49))","v":""},{"$f":"IF($E54=\"\",\"\",INDEX(Inputs_Table,$AA54,J$49))","v":""},{"$f":"IF($E54=\"\",\"\",INDEX(Inputs_Table,$AA54,K$49))","v":""},{"$f":"IF($E54=\"\",\"\",INDEX(Inputs_Table,$AA54,L$49))","v":""},{"$f":"IF($E54=\"\",\"\",INDEX(Inputs_Table,$AA54,M$49))","v":""},{"$f":"IF($E54=\"\",\"\",INDEX(Inputs_Table,$AA54,N$49))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(Inputs_Thermal_Block_Lookup=E54),--(Inputs_Min_Area<Proj_Info_Cond_SF),--(Inputs_Max_Area>Proj_Info_Cond_SF),Inputs_Row)","v":0},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H54,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$AZ$3),\"\")","v":""},{"$f":"IFERROR(J54*G54/1000*AB54,\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H54,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BC$3),\"\")","v":""},"",{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H54,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BD$3),\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H54,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BG$3),\"\")","v":""}]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"IF($E55=\"\",\"\",INDEX(Inputs_Table,$AA55,H$49))","v":""},{"$f":"IF($E55=\"\",\"\",INDEX(Inputs_Table,$AA55,I$49))","v":""},{"$f":"IF($E55=\"\",\"\",INDEX(Inputs_Table,$AA55,J$49))","v":""},{"$f":"IF($E55=\"\",\"\",INDEX(Inputs_Table,$AA55,K$49))","v":""},{"$f":"IF($E55=\"\",\"\",INDEX(Inputs_Table,$AA55,L$49))","v":""},{"$f":"IF($E55=\"\",\"\",INDEX(Inputs_Table,$AA55,M$49))","v":""},{"$f":"IF($E55=\"\",\"\",INDEX(Inputs_Table,$AA55,N$49))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(Inputs_Thermal_Block_Lookup=E55),--(Inputs_Min_Area<Proj_Info_Cond_SF),--(Inputs_Max_Area>Proj_Info_Cond_SF),Inputs_Row)","v":0},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H55,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$AZ$3),\"\")","v":""},{"$f":"IFERROR(J55*G55/1000*AB55,\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H55,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BC$3),\"\")","v":""},"",{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H55,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BD$3),\"\")","v":""},{"$f":"IFERROR(INDEX(EFLH_SchFraction_Lookup,MATCH(H55,INDEX(EFLH_SchFraction_Lookup,,Reference!$AY$3),0),Reference!$BG$3),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(Proj_Info_Predominant_Type=AA57,AA56,IF(Proj_Info_Predominant_Type=AB57,AB56,IF(Proj_Info_Predominant_Type=AC57,AC56,IF(Proj_Info_Predominant_Type=AD57,AD56,\"\")))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Use a sensible fraction of 1.0 and a latent fraction of 0.0 for all thermal blocks with the exception that Residential should be modeled with a latent fraction of 0.14.","* Use a sensible fraction of 1.0 and a latent fraction of 0.0 for all thermal blocks except model Cafeteria with a 0.25 latent and 0.75 sensible fraction.","* Use a sensible fraction of 1.0 and a latent fraction of 0.0 for all thermal blocks.","* Use a sensible fraction of 1.0 and a latent fraction of 0.0 for all thermal blocks."]
[null,null,null,null,"** The designed ventilation rate is required to be modeled when it exceeds the rate shown in Table 2 AND the designed rate exceeds minimum code requirements by more than 135%.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential","K-12","Misc","Other"]
[]
[]
[]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag=0,5/0,1)","v":{"$error":"#DIV/0!"}},null,"Table 3: Default HVAC System Configuration"]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag=0,5/0,1)","v":{"$error":"#DIV/0!"}},null,"Instructions\n1. For buildings and areas of buildings following Section 13.2 (Default HVAC System Configuration), model the configurations shown in Table 3. Model specific system parameters, including but not limited to fan power and system efficiencies, according to Section 13.2 of the Simulation Guidelines."]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"Reference!D3","v":2},{"$f":"Reference!E3","v":3},{"$f":"Reference!F3","v":4},{"$f":"Reference!G3","v":5},{"$f":"Reference!H3","v":6}]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag=0,5/0,1)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag=0,5/0,1)","v":{"$error":"#DIV/0!"}},null,"Building Type",null,"Heating/Cooling System Number and Type","System Type","Fan Control","Cooling Type","Heating Type","Mechanical Ventilation System Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row"]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag=0,5/0,1)","v":{"$error":"#DIV/0!"}},null,{"$f":"Comp_Calcs_Use_Type","v":""},null,{"$f":"INDEX(Default_HVAC_Config,$AA$66,G63)","v":{"$error":"#N/A"}},{"$f":"INDEX(Default_HVAC_Config,$AA$66,H63)","v":{"$error":"#N/A"}},{"$f":"INDEX(Default_HVAC_Config,$AA$66,I63)","v":{"$error":"#N/A"}},{"$f":"INDEX(Default_HVAC_Config,$AA$66,J63)","v":{"$error":"#N/A"}},{"$f":"INDEX(Default_HVAC_Config,$AA$66,K63)","v":{"$error":"#N/A"}},"DOAS de-coupled from the heating and cooling system",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(E66,INDEX(Default_HVAC_Config,,Reference!$C$3),0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag=0,5/0,IF(Proj_Info_Predominant_Type=\"K-12\",1,5/0))","v":{"$error":"#DIV/0!"}},null,"K-12 school cafeterias (including dining and food preparation areas), auditoriums, and gymnasiums",null,"-","Single zone","Variable Volume",{"$f":"J66","v":{"$error":"#N/A"}},{"$f":"K66","v":{"$error":"#N/A"}},"System provides mechanical ventilation to the thermal block"]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag=0,5/0,1)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Guidelines Checklist","index":3,"n_rows":138,"n_cols":13,"rows_kept":138,"cut":false,"hidden":false,"merged":[[27,5,27,9],[36,12,36,18],[37,12,37,18],[38,10,38,11],[39,10,39,11],[31,5,31,9],[35,5,35,9],[36,5,36,9],[19,4,19,18],[33,4,33,18],[29,4,29,18],[30,5,30,9],[30,12,30,18],[34,5,34,9],[34,10,34,11],[34,12,34,18],[27,10,27,11],[30,10,30,11],[27,12,27,18],[31,10,31,11],[35,10,35,11],[31,12,31,18],[35,12,35,18],[36,10,36,11],[37,10,37,11],[87,4,87,18],[53,5,53,9],[53,10,53,11],[53,12,53,18],[52,5,52,9],[52,10,52,11],[52,12,52,18],[39,5,39,9],[47,5,47,9],[51,10,51,11],[43,12,43,18],[63,12,63,18],[38,12,38,18],[39,12,39,18],[47,12,47,18],[51,12,51,18],[62,12,62,18],[61,5,61,9],[37,5,37,9],[38,5,38,9],[43,5,43,9],[43,10,43,11],[41,4,41,18],[0,4,1,18],[21,4,21,18],[25,4,25,18],[23,4,23,18],[26,5,26,9],[26,10,26,11],[4,4,4,18],[5,4,5,18],[26,12,26,18],[17,4,17,18],[16,4,16,18],[15,4,15,18],[6,4,6,18],[7,4,7,18],[8,4,8,18],[9,4,9,18],[10,4,10,18],[11,4,11,18],[12,4,12,18],[13,4,13,18],[14,4,14,18],[18,4,18,18],[57,5,57,9],[47,10,47,11],[56,5,56,9],[58,5,58,9],[55,5,55,9],[54,5,54,9],[42,5,42,9],[42,10,42,11],[42,12,42,18],[45,4,45,18],[49,4,49,18],[60,4,60,18],[65,4,65,18],[46,10,46,11],[50,10,50,11],[61,10,61,11],[66,10,66,11],[55,10,55,11],[54,10,54,11],[56,10,56,11],[57,10,57,11],[58,10,58,11],[46,12,46,18],[50,12,50,18],[61,12,61,18],[55,12,55,18],[54,12,54,18],[56,12,56,18],[57,12,57,18],[58,12,58,18],[51,5,51,9],[46,5,46,9],[50,5,50,9],[62,10,62,11],[63,10,63,11],[62,5,62,9],[63,5,63,9],[67,12,67,18],[70,10,70,11],[71,10,71,11],[66,5,66,9],[73,10,73,11],[66,12,66,18],[70,12,70,18],[71,12,71,18],[72,12,72,18],[73,12,73,18],[69,12,69,18],[73,5,73,9],[69,5,69,9],[68,5,68,9],[67,5,67,9],[67,10,67,11],[72,5,72,9],[68,12,68,18],[70,5,70,9],[71,5,71,9],[72,10,72,11],[68,10,68,11],[69,10,69,11],[75,12,75,18],[76,12,76,18],[76,10,76,11],[74,10,74,11],[75,10,75,11],[75,5,75,9],[76,5,76,9],[84,5,84,9],[84,10,84,11],[79,10,79,11],[79,12,79,18],[80,5,80,9],[80,10,80,11],[80,12,80,18],[77,5,77,9],[77,10,77,11],[77,12,77,18],[78,5,78,9],[78,10,78,11],[78,12,78,18],[79,5,79,9],[74,5,74,9],[74,12,74,18],[90,5,90,9],[90,10,90,11],[90,12,90,18],[89,5,89,9],[89,10,89,11],[89,12,89,18],[81,5,81,9],[81,10,81,11],[81,12,81,18],[85,5,85,9],[85,10,85,11],[85,12,85,18],[84,12,84,18],[88,5,88,9],[88,10,88,11],[88,12,88,18],[83,4,83,18],[92,4,92,18],[95,5,95,9],[95,10,95,11],[95,12,95,18],[99,5,99,9],[99,10,99,11],[99,12,99,18],[93,5,93,9],[93,10,93,11],[93,12,93,18],[94,5,94,9],[94,10,94,11],[94,12,94,18],[97,4,97,18],[98,5,98,9],[98,10,98,11],[98,12,98,18],[102,5,102,9],[102,10,102,11],[102,12,102,18],[103,5,103,9],[103,10,103,11],[103,12,103,18],[100,5,100,9],[100,10,100,11],[100,12,100,18],[101,5,101,9],[101,10,101,11],[101,12,101,18],[106,5,106,9],[106,10,106,11],[106,12,106,18],[107,5,107,9],[107,10,107,11],[107,12,107,18],[104,5,104,9],[104,10,104,11],[104,12,104,18],[105,5,105,9],[105,10,105,11],[105,12,105,18],[110,5,110,9],[110,10,110,11],[110,12,110,18],[111,5,111,9],[111,10,111,11],[111,12,111,18],[108,5,108,9],[108,10,108,11],[108,12,108,18],[109,5,109,9],[109,10,109,11],[109,12,109,18],[112,5,112,9],[112,10,112,11],[112,12,112,18],[113,5,113,9],[113,10,113,11],[113,12,113,18],[114,5,114,9],[114,10,114,11],[114,12,114,18],[115,5,115,9],[115,10,115,11],[115,12,115,18],[116,5,116,9],[116,10,116,11],[116,12,116,18],[117,5,117,9],[117,10,117,11],[117,12,117,18],[126,12,126,18],[124,5,124,9],[118,5,118,9],[118,10,118,11],[118,12,118,18],[119,5,119,9],[119,10,119,11],[119,12,119,18],[120,5,120,9],[120,10,120,11],[120,12,120,18],[129,4,129,18],[130,5,130,9],[130,10,130,11],[130,12,130,18],[136,5,136,9],[136,10,136,11],[136,12,136,18],[122,4,122,18],[123,5,123,9],[123,10,123,11],[123,12,123,18],[127,5,127,9],[127,10,127,11],[127,12,127,18],[131,5,131,9],[131,10,131,11],[131,12,131,18],[125,5,125,9],[124,10,124,11],[124,12,124,18],[125,10,125,11],[125,12,125,18],[126,5,126,9],[126,10,126,11],[137,5,137,9],[137,10,137,11],[137,12,137,18],[135,5,135,9],[135,10,135,11],[135,12,135,18],[134,4,134,18],[132,5,132,9],[132,10,132,11],[132,12,132,18]]}
[null,null,null,null,"Guidelines Checklist"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Table of Contents"]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table1_Header","v":"Table 1: Simulation Guidelines Checklist - Section 2"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table2_Header","v":"Table 2: Simulation Guidelines Checklist - Section 3"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table3_Header","v":"Table 3: Simulation Guidelines Checklist - Section 4"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table4_Header","v":"Table 4: Simulation Guidelines Checklist - Section 6"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table5_Header","v":"Table 5: Simulation Guidelines Checklist - Section 7"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table6_Header","v":"Table 6: Simulation Guidelines Checklist - Section 8"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table7_Header","v":"Table 7: Simulation Guidelines Checklist - Section 9"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table8_Header","v":"Table 8: Simulation Guidelines Checklist - Section 10"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table9_Header","v":"Table 9: Simulation Guidelines Checklist - Section 11"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table10_Header","v":"Table 10: Simulation Guidelines Checklist - Section 12"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table11_Header","v":"Table 11: Simulation Guidelines Checklist - Section 13.1"}]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag<>0,1,5/0)","v":{"$error":"#DIV/0!"}},null,{"$f":"Guidelines_Checklist_Table12_Header","v":"Table 12: Simulation Guidelines Checklist - Section 13.2 Default HVAC System Configuration"}]
[null,null,{"$f":"IF(Proj_Info_AsDesigned_HVAC_Flag<>0,1,5/0)","v":{"$error":"#DIV/0!"}},null,{"$f":"Guidelines_Checklist_Table13_Header","v":"Table 13: Simulation Guidelines Checklist - Section 13.3 As-designed HVAC Systems"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table14_Header","v":"Table 14: Simulation Guidelines Checklist - Section 13.4 Other HVAC Modeling Requirements"}]
[null,null,null,null,{"$f":"Guidelines_Checklist_Table15_Header","v":"Table 15: Simulation Guidelines Checklist - Section 14"}]
[]
[null,null,null,null,"This checklist shall be used to ensure that the project follows Appendix C: Targeted Performance Simulation Guidelines. It is recommended to consult this checklist throughout the energy modeling process to ensure that the project meets the guidelines."]
[]
[null,null,null,null,"Instructions\n1. In each of the below tables, mark whether each guideline requirement has been followed in the \"Complies?\" column. For some items, the outcome may auto-populate based on what has been reported elsewhere in the TEDI Compliance Tool. Revise model to comply with all guidelines prior to submission."]
[]
[null,null,null,null,"Table 1: Simulation Guidelines Checklist - Section 2"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,2,"The energy modeler meets the qualification requirements.",null,null,null,null,null,null,{"$f":"IF(K28=\"\",\"Incorporate into the energy model\",\"Please submit documentation per the \"\"Submittal Checklist\"\" tab.\")","v":"Incorporate into the energy model"}]
[]
[null,null,null,null,"Table 2: Simulation Guidelines Checklist - Section 3"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,3,"The simulation program is approved.",null,null,null,null,{"$f":"IF(AND(Proj_Info_Sim_Program_Version<>\"Other\",Proj_Info_Sim_Program_Version<>\"<Specify version>\"),\"✓\",\"\")","v":""},null,{"$f":"IF(K32=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[]
[null,null,null,null,"Table 3: Simulation Guidelines Checklist - Section 4"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,"4a","The MAStretch2023 or AHJ-approved weather file was used.",null,null,null,null,{"$f":"IF(Proj_Info_Weather_File<>\"\",\"✓\",\"\")","v":""},null,{"$f":"IF(K36=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,null,null,"4b","Ground temperatures from the weather file and/or software defaults shall be used in the model.",null,null,null,null,null,null,{"$f":"IF(K37=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,null,null,"4c","The modeled solar reflectance of the site ground surface equals 0.2.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"4d","No holidays shall be modeled.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"4e","Shading from adjacent structures, significant vegetation and topographical features shall be reflected in the simulation. All elements with height greater than their distance from a proposed building and whose width facing the proposed building is greater than one-third that of the proposed building shall be modeled.",null,null,null,null,null,null,{"$f":"IF(K40=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[]
[null,null,null,null,"Table 4: Simulation Guidelines Checklist - Section 6"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,6,"Unmet load hours shall not exceed 300 (of the 8760 hours simulated).",null,null,null,null,{"$f":"IF(Comp_Calcs_Unmet_Load_Hours<=300,\"✓\",\"\")","v":""},null,{"$f":"IF(K44=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[]
[null,null,null,null,"Table 5: Simulation Guidelines Checklist - Section 7"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,7,"The following systems and components shall be excluded from the simulation:\n1. Exterior lighting system power and controls\n2. Heating loads unrelated to maintaining indoor air related occupant comfort such as swimming pool water heaters, outdoor comfort heating (e.g., patio heaters and exterior fireplaces), gas-fired appliances (stoves and dryers), heat tracing. \n3. Renewable energy systems including but not limited to PV and solar thermal hot water collectors\n4. Other electricity generation systems such as Combined Heat and Power.\n5. Service water heating systems.",null,null,null,null,null,null,{"$f":"IF(K48=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[]
[null,null,null,null,"Table 6: Simulation Guidelines Checklist - Section 8"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,8.1,"Thermal blocks shall be modeled as prescribed in 90.1 2019 Appendix G Table G3.1, Proposed Building Performance column Row 9 for multifamily buildings and Row 7 for all other occupancy types.\n\nException: Projects that are modeled with the default HVAC systems following Section 13.2 are permitted to be modeled with the default thermal blocks as prescribed in Sections 8.2 and 8.3.",null,null,null,null,null,null,{"$f":"IF(K52=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag<>0,1,5/0)","v":{"$error":"#DIV/0!"}},null,8.1999999999999993,"Default thermal blocks have been modeled based on the building use types in Section 8.2.1. The modeled floor area of residential and nonresidential thermal blocks in residential buildings and cafeteria, gymnasium and auditorium thermal blocks in K-12 schools shall be within 5% of the actual design shown on construction documents. The exterior envelope area of each thermal block shall reflect construction documents.\n\nException: Thermal blocks based on the specified HVAC zones may be used for the “supporting spaces” and “nonresidential” thermal blocks in residential buildings, “school” thermal blocks in K-12 schools and “office” thermal blocks in offices, fire stations, libraries, police stations, post offices, and town halls. When more detailed thermal blocks are modeled following this exception, these thermal blocks are subject to all rules in these guidelines that are applicable to the corresponding aggregated thermal blocks, including but not limited to the standardized assumptions for miscellaneous loads, lighting, occupancy and schedules. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag<>0,1,5/0)","v":{"$error":"#DIV/0!"}},null,"8.3a","Thermal blocks of the same type shall be aggregated, except separate thermal blocks shall be assumed for interior and perimeter areas. Interior areas shall be those located greater than 15 feet from an exterior wall. Perimeter areas shall be those located within 15 feet of an exterior wall.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"8.3a Exception a","Residential, residential supporting, cafeteria, gymnasium and auditorium thermal blocks shall not be split into perimeter and core thermal blocks.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"8.3a Exception b","Separate thermal blocks shall be assumed for spaces adjacent to glazed exterior walls; a separate thermal block shall be provided for each orientation, except that orientations that differ by less than 45 degrees may be considered to be the same orientation. Each thermal block shall include all floor area that is 15 feet or less from a glazed perimeter exterior wall, except that floor area within 15 feet of glazed perimeter exterior walls having more than one orientation shall be divided proportionately between thermal blocks.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"8.3a Exception c","Residential, residential supporting, cafeteria, gymnasium and auditorium thermal blocks shall not be split into perimeter and core thermal blocks.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"8.3a Exception d","Separate thermal blocks shall be assumed for spaces having exterior ceiling or roof assemblies from spaces that do not share these features.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"8.3a Exception e","Spaces served by mechanical systems with exhaust air energy recovery shall not be aggregated into the same thermal block with spaces served by mechanical systems that do not have exhaust air energy recovery.",null,null,null,null,null,null,"Incorporate into the energy model"]
[]
[null,null,null,null,"Table 7: Simulation Guidelines Checklist - Section 9"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,"9a","The modeled exterior envelope geometry shall be consistent with construction documents, including proper accounting of fenestration and opaque building envelope types and areas. Each modeled thermal block shall reflect the total area, type and orientation of opaque surfaces (i.e., above and below-grade exterior walls, roof, above and below grade floors) and fenestration associated with the spaces included in the block.",null,null,null,null,null,null,{"$f":"IF(K63=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,null,null,"9b","The total modeled floor area of conditioned spaces shall be within 5% of the gross floor area shown on the architectural drawings unless justification is provided to AHJ.",null,null,null,null,null,null,{"$f":"IF(K64=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[]
[null,null,null,null,"Table 8: Simulation Guidelines Checklist - Section 10"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,"10.1a","All components of the building envelope shall be modeled as shown on architectural drawings and as described in Section 10.",null,null,null,null,null,null,{"$f":"IF(K68=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,null,null,"10.1b","Simulation shall account for thermal mass of the exterior surfaces.",null,null,null,null,null,null,{"$f":"IF(K69=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,null,null,10.199999999999999,"Exterior walls shall be modeled with the U-factors derated to account for thermal bridging using the derating methods described in Section C402.7.",null,null,null,null,null,null,{"$f":"IF(K70=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,null,null,10.3,"Exterior roof surfaces shall be modeled using the aged solar reflectance and thermal emittance determined by testing in accordance with CRRC S100. Where aged test data are unavailable, the roof surface shall be modeled with a reflectance of 0.30 and a thermal emittance of 0.90. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.4a","Modeled fenestration properties shall reflect performance of the complete assembly including frame and glazing and reflect U-factor, SHGC and VT established by a laboratory accredited by a nationally recognized accreditation organization, such as the National Fenestration Rating Council (NFRC) and as described in Section C402.4.6. Fenestration products that do not have such rating shall be modeled with the default properties from 90.1 Table A8.1 for unlabeled skylights and Table A8.2 for unlabeled vertical fenestration.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.4b","Manual fenestration shading devices, such as blinds or shades, are allowed to be modeled in the residential spaces. In all other space types, manual fenestration shading devices shall not be modeled.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.4c","Automatically controlled fenestration shades or blinds shall not be modeled.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.4d","Permanent shading devices, such as fins, overhangs, and light shelves shall be modeled.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.4e","Shading due to setting fenestration faces back from surround wall faces shall be modeled.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.4f"," Automatically controlled dynamic glazing may be modeled. Manually controlled dynamic glazing shall use the average of the minimum and maximum SHGC and VT.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.5a","The modeled air leakage rate of the building envelope shall be based on air leakage testing completed following Section C402.5.2. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.5b","The air leakage rate of the building envelope shall be converted to appropriate units for the simulation program using one of the methods in 90.1 Section G3.1.1.4.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.5c","The infiltration flow shall be assigned to the thermal blocks in proportion to the area of surfaces adjacent to exterior.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.5d","Infiltration modeling algorithm selected within simulation tool shall include adjustment for weather.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"10.5e","Infiltration schedule shall be as specified in the Schedules and Loads Guidelines Supplement for the appropriate thermal block type.",null,null,null,null,null,null,{"$f":"IF(K82=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[]
[null,null,null,null,"Table 9: Simulation Guidelines Checklist - Section 11"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,11,"The standardized assumptions prescribed in Table 1-6 in the Schedules and Loads Guidelines Supplement shall be modeled for each thermal block depending on the building use type, gross floor area and thermal block type.\n\nSee Table 2 on the Project Information tab for relevant modeling parameters for the reported thermal blocks.",null,null,null,null,null,null,{"$f":"IF(K86=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[]
[null,null,null,null,"Table 10: Simulation Guidelines Checklist - Section 12"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,"12a","Interior lighting power shall be modeled based on building use type, modeled floor area and thermal block use type as prescribed in Tables 1-6 in the Schedules and Loads Guideline Supplement.\n\nSee Table 2 on the Project Information tab for relevant modeling parameters for the reported thermal blocks.",null,null,null,null,null,null,{"$f":"IF(K90=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,null,null,"12b","Daylighting shall not be modeled in residential thermal blocks. In all other thermal blocks daylighting shall be modeled as follows: \n\n1. For thermal blocks with vertical fenestration, the daylight area shall be modeled as directly adjacent to the vertical fenestration with a width equal to the width of the vertical fenestration and a depth equal to the head height of the vertical fenestration. A photosensor shall be modeled as located at the center of the width of the daylight area, at the depth of the daylight area and at a height of 3 feet.\n\n2. In each nonresidential zone associated with skylights, the daylight area under skylights shall be modeled as bounded, in each direction, by the edge of the skylight area plus 10 feet or the distance to the edge of the zone, whichever is less. A photosensor shall be modeled as located at the center of the horizontal plane of the skylight and at a height of 5 feet.",null,null,null,null,null,null,{"$f":"IF(K91=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[]
[null,null,null,null,"Table 11: Simulation Guidelines Checklist - Section 13.1"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,"13.1a","Buildings and areas within the building for which HVAC systems are not designed and are not shown on the construction documents shall be modeled with the default HVAC systems following Sections 13.2 and 13.4.",null,null,null,null,null,null,{"$f":"IF(K95=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,null,null,"13.1b","Buildings and areas within the building for which HVAC systems are designed shall be modeled following either of the following options:\n\n1. With the specified systems following Sections 13.3 and 13.4\n\n2. With the default HVAC systems following Section 13.1(a).     \n\nThe selected approach shall be followed for the entire project.",null,null,null,null,null,null,{"$f":"IF(K96=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag<>0,1,5/0)","v":{"$error":"#DIV/0!"}},null,"Table 12: Simulation Guidelines Checklist - Section 13.2 Default HVAC System Configuration"]
[null,null,{"$error":"#DIV/0!"},null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.1","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, the modeled heating and cooling system types shall be determined using Table 1 based on the building type and the total modeled floor area. Table 2 provides additional details for each system type.\n\nExceptions:\na. K-12 school cafeterias (including dining and food preparation areas), auditoriums, and gymnasiums shall be modeled with variable volume single zone system that has same heating and cooling type as the remainder of the building.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.2a","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, air economizer shall only be modeled for the single zone systems modeled following Section 13.2.1 Exception (a). ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.2b","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, air economizers shall be modeled with a differential dry bulb temperature control to set the outdoor airflow to minimum ventilation requirements when the dry-bulb temperature of outdoor air is higher than the dry-bulb temperature of the return air with a low temperature minimum temperature setpoint cutoff of 45F. Modeled air economizer systems shall be capable of and configured to modulate outdoor air and return air dampers to provide up to 100% of the design supply air quantity as outdoor air for cooling.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.2c","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, the exhaust air recovery shall be locked out during air economizer operation if applicable. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.3a","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, mechanical ventilation shall be provided by a dedicated outdoor air system (DOAS), de-coupled from the system that provides heating and cooling. \n\nException: Single zone systems modeled following Section 13.2.1 Exception (a) shall be modeled as also providing mechanical ventilation to the thermal block.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.3b","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, demand control ventilation shall not be modeled.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.3c","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, exhaust air energy recovery effectiveness shall be modeled as specified. The modeled controls shall allow bypassing energy recovery to permit air economizer operation and allow free cooling when outdoor air conditions are favorable. Controls shall be modelled to prevent overheating or overcooling of the mixed/supply air by the system.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.3d","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, DOAS systems shall be modeled with preheating and precooling coils of the same type as modeled for the space conditioning heating and cooling systems. \n\nException: Projects modeling System 3 to provide heating and cooling shall model the DOAS system(s) providing minimum outdoor air requirements with an electric resistance heating coil and DX cooling coil.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.3e","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, the DOAS shall not heat supply air above 60°F when representative building loads or outdoor air temperature indicate that the majority of zones require cooling. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.3f","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, the DOAS shall not cool supply air below 70°F when representative building loads or outdoor air temperature indicate that the majority of zones require heating. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.3g","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, no dehumidification controls shall be modeled.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag<>0,IF(Proj_Info_Default_HVAC_Type=\"System 1 ASHP\",1,5/0),5/0)","v":{"$error":"#DIV/0!"}},null,"13.2.4a","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, air source heat pumps shall be modeled with a cooling efficiency of 3.74 COPnfcooling and a heating efficiency of 3.66 COPnfheating at 47F DB. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag<>0,IF(Proj_Info_Default_HVAC_Type=\"System 3 WSHP\",1,5/0),5/0)","v":{"$error":"#DIV/0!"}},null,"13.2.4b","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, water source heat pumps shall be modeled with a cooling efficiency of 4.4 COPnfcooling at an entering water temperature of 86F and a heating efficiency of 5.0 COPnfheating at an entering water temperature of 68F.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.5","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, heating and cooling coil capacities shall be auto sized based on sizing runs and shall be oversized by 15% for cooling and 25% for heating. The following design day conditions shall be used in the sizing runs:\na. Space temperature design setpoints\n• Summer: 75F DB\n• Winter: 70F DB \nb. Outdoor ambient design conditions \n• Summer: 87F DB; 71F WB \n• Winter: 7F DB\nc. Design day schedules included in the Schedules and Loads Guidelines Supplement shall be used.",null,null,null,null,null,null,{"$f":"IF(K113=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,{"$error":"#DIV/0!"},null,"13.2.6a","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, supply airflow rates for system 1 through 3 shall be auto sized and based on a supply-air-to-room temperature set-point difference of 20°F, or the minimum outdoor airflow rate, whichever  is greater. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.7a","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, heating and cooling system fans that do not provide outside air to meet minimum ventilation requirements shall cycle on and off to meeting heating and cooling loads. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.7b","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, DOAS fans shall operate continuously during occupied hours and remain off during unoccupied hours.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.7c","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, heating and cooling system fans in single zone systems modeled following Section 13.2 Exception a that provide outside air to meet minimum ventilation requirements (e.g., systems serving cafeterias, auditoriums, and gymnasiums) shall operate continuously during occupied hours and shall cycle to meet heating and cooling loads during unoccupied hours. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.8a, b","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, design fan power shall be modeled per Table 3 and Table 4 in the Simulation Guidelines based on the building type, areas served, and the system type.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.2.8c","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, ventilation systems serving thermal blocks for which exhaust air energy recovery other than a coil runaround loop is specified in the proposed design shall be modeled with additional fan power determined as follows: \n\n1. For each airstream determine the pressure drop (PD) through the specified energy recovery device based on design documents and or manufacturer specification. \n2. Calculate the additional brake horsepower to be modeled \n(bhp) = sum of (PD × cfmD/4131)\ncfmD = the cfm of each applicable air stream\n3. Convert bhp to kW =  bhp × 0.746/fan motor efficiency\n\nFan motor efficiency = the efficiency from ASHRAE 90.1 2019 Section 10 for the next motor size greater than the bhp.",null,null,null,null,null,null,{"$f":"IF(K119=\"\",\"Incorporate into the energy model\",\"None\")","v":"Incorporate into the energy model"}]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag<>0,IF(Proj_Info_Default_HVAC_Type=\"System 2 FCU\",1,5/0),5/0)","v":{"$error":"#DIV/0!"}},null,"13.2.9","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, system 2 chilled and hot water plants have been modeled as described in Section 13.2.9 subsections a and b.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$f":"IF(Proj_Info_DefaultHVAC_Flag<>0,IF(Proj_Info_Default_HVAC_Type=\"System 3 WSHP\",1,5/0),5/0)","v":{"$error":"#DIV/0!"}},null,"13.2.9","For buildings and areas within buildings modeled with default HVAC systems following Sections 13.2 and 13.4, system 3 WSHP has been modeled as described in Section 13.2.9 subsections c and d.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"IF(Proj_Info_AsDesigned_HVAC_Flag<>0,1,5/0)","v":{"$error":"#DIV/0!"}},null,"Table 13: Simulation Guidelines Checklist - Section 13.3 As-designed HVAC Systems"]
[null,null,{"$error":"#DIV/0!"},null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,{"$error":"#DIV/0!"},null,"13.3a","For buildings and areas within buildings modeled with as-designed HVAC systems following Sections 13.3 and 13.4, where an HVAC system has been designed and submitted with design documents, the HVAC model shall be consistent with design documents including all components and controls except as prescribed in Section 13.4 and in the Schedule and Loads Guidelines Supplement. \n\nException: System air flows and heating and cooling capacities shall be auto sized per Section 13.2.4.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.3b","For buildings and areas within buildings modeled with as-designed HVAC systems following Sections 13.3 and 13.4, where efficiency ratings include supply fan energy, the efficiency rating shall be adjusted to remove the supply fan energy from the efficiency rating. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.3c","For buildings and areas within buildings modeled with as-designed HVAC systems following Sections 13.3 and 13.4, the systems shall be modeled using manufacturers’ full- and part load data for the HVAC system without fan power. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"},null,"13.3d","For buildings and areas within buildings modeled with as-designed HVAC systems following Sections 13.3 and 13.4, demand control ventilation shall be modeled per Section 13.3d.",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,"Table 14: Simulation Guidelines Checklist - Section 13.4 Other HVAC Modeling Requirements"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,"13.4.1","The minimum ventilation flow rate shall be modeled using the OA CFM/sf rate from Tables 1-6 of the Schedules and Loads Guidelines Supplement for the building use type.\n\nException: The specified rate shall be modeled when both of the following applies: \na. The specified ventilation rate exceeds the minimum requirements of applicable codes and standards by more than 135% and \nb. The specified ventilation rate exceeds the OA CFM/sf value from Tables 1-6 of the Schedules and Loads Guidelines Supplement for the building use type.\n\nMinimum required outdoor air and specified ventilation rates shall be documented as described in Section C103.2 #16. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,"13.4.2","Piping and ductwork losses shall not be modeled.",null,null,null,null,null,null,"Incorporate into the energy model"]
[]
[null,null,null,null,"Table 15: Simulation Guidelines Checklist - Section 14"]
[null,null,null,null,"Simulation Guidelines Section","Guideline",null,null,null,null,"Complies?",null,"Required Action"]
[null,null,null,null,14.1,"For projects in which systems and components that must be modeled as designed following these guidelines have not yet been designed, those yet-to-be-designed features shall be modeled to comply with but not exceed the requirements of the most current version of 225 CMR 23: Massachusetts Commercial Stretch Energy Code. Core and shell buildings where the details of the building occupancy is not known shall be categorized as an office building. \n\nFor initial tenant fit-out projects, existing unmodified systems and components shall be modeled as- built. Section C401.2 does not apply to subsequent tenant fit-out projects. Tenant fit-outs after the initial tenant fit-out shall be treated as alterations or change of use as appropriate. ",null,null,null,null,null,null,"Incorporate into the energy model"]
[null,null,null,null,14.2,"Following C502.1, large additions which are either more than 100% of the size of the existing building or equal to or greater than 20,000-sf require conformance to C401.2. If the addition use type is office, dormitory, fire station, library, office, school, police station, post office, or town hall, the addition must show compliance with the Targeted Performance Compliance (C401.2 Part 2). In this scenario, the existing building shall be excluded from the model so that only the addition is modeled. Surfaces separating the addition from existing building shall be modeled as adiabatic. ",null,null,null,null,null,null,"Incorporate into the energy model"]

{"sheet":"Results from eQuest","index":4,"n_rows":8,"n_cols":76,"rows_kept":8,"cut":false,"hidden":true,"merged":[[6,62,6,63],[6,64,6,65],[6,66,6,69],[6,70,6,75],[0,0,1,17],[4,0,4,23],[6,11,6,23],[6,24,6,35],[6,36,6,48],[6,49,6,61]]}
["Results from eQuest"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[]
["Instructions\n1. Generate the parms.csv file for the energy model. \n     a. To create this file, create a parametric run by going to Tools > Parametric Runs > Click \"OK\" > Create Parametric Run > Create Parametric Component > Component Type: Building Parameters > Category: Build Parameters > Keyword: Azimuth > \n          Value: 0.0000 > Done\n     b. Perform simulation and select the baseline and parametric runs\n2) Open the parms.csv file and copy the Base Design from the appropriate parms.csv file and paste values into row 9 below. \n     a. If modeling fuels other than natural gas (fuel oil, coal, propane, etc.), be sure to choose therms as the associated energy units on the Compliance Calculations tab in Table 3 as these are the reported units in the Parms.csv file regardless of the \n          fuel type. \n     b.  If modeling district HW, district steam, or district chilled water, manual entries will need to be made in Table 3 on the Compliance Calculations tab to capture the usage associated with these meters as it is not included in the Parms.csv \n          file. "]
[null,null,null,null,null,null,null,null,null,null,null,"Interior lightingElectricitykWh","Interior lightingElectricitykWh","Misc equipmentElectricitykWh","Space heatingElectricitykWh","Space coolingElectricitykWh","Heat rejectionElectricitykWh","PumpsElectricitykWh","Fans - interior ventilationElectricitykWh","Misc equipmentElectricitykWh","Heat pump supplemental heaterElectricitykWh","Service water heatingElectricitykWh","Exterior lightingElectricitykWh",null,"Interior lightingElectricitykW","Interior lightingElectricitykW","Misc equipmentElectricitykW","Space heatingElectricitykW","Space coolingElectricitykW","Heat rejectionElectricitykW","PumpsElectricitykW","Fans - interior ventilationElectricitykW","Misc equipmentElectricitykW","Heat pump supplemental heaterElectricitykW","Service water heatingElectricitykW","Exterior lightingElectricitykW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc equipmentNatural Gastherm","Space heatingNatural Gastherm","Space coolingNatural Gastherm",null,null,null,null,null,"Service water heatingNatural Gastherm"]
[null,null,null,null,null,null,null,null,null,null,null,"Electric Usage:",null,null,null,null,null,null,null,null,null,null,null,null,"Non-Coincident Peak Demand:",null,null,null,null,null,null,null,null,null,null,null,"Coincident Peak Demand:",null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Usage:",null,null,null,null,null,null,null,null,null,null,null,null,"Source Energy:",null,"TDV Energy:",null,"Annual Utility Costs:",null,null,null,"Hours Outside Throttling Range:"]
["Run Type","Internal Loads","Case #s","Short Name","Carry Fwd","Incremental First Cost ($)","Incremental Annual Maint. ($)","Date & Time of Run","File Name","Case Description","SS-D\nPeak Cooling Coil Load\nkBtu","PS-E\nAmbient Lights\nkWh","PS-E\nTask Lights\nkWh","PS-E\nMisc Equip\nkWh","PS-E\nSpace Heating\nkWh","PS-E\nSpace Cooling\nkWh","PS-E\nHeat Reject\nkWh","PS-E\nPumps & Aux\nkWh","PS-E\nVentilation Fans\nkWh","PS-E\nRefrig Display\nkWh","PS-E\nHeat Pump Supplement\nkWh","PS-E\nDomestic Hot Water\nkWh","PS-E\nExterior Usage\nkWh","PS-E\nTotal\nkWh","PS-E\nAmbient Lights\nkW","PS-E\nTask Lights\nkW","PS-E\nMisc Equip\nkW","PS-E\nSpace Heating\nkW","PS-E\nSpace Cooling\nkW","PS-E\nHeat Reject\nkW","PS-E\nPumps & Aux\nkW","PS-E\nVentilation Fans\nkW","PS-E\nRefrig Display\nkW","PS-E\nHeat Pump Supplement\nkW","PS-E\nDomestic Hot Water\nkW","PS-E\nExterior Usage\nkW","PS-E\nAmbient Lights\nkW","PS-E\nTask Lights\nkW","PS-E\nMisc Equip\nkW","PS-E\nSpace Heating\nkW","PS-E\nSpace Cooling\nkW","PS-E\nHeat Reject\nkW","PS-E\nPumps & Aux\nkW","PS-E\nVentilation Fans\nkW","PS-E\nRefrig Display\nkW","PS-E\nHeat Pump Supplement\nkW","PS-E\nDomestic Hot Water\nkW","PS-E\nExterior Usage\nkW","PS-E\nBldg Total\nkW","PS-E\nAmbient Lights\nTherms","PS-E\nTask Lights\nTherms","PS-E\nMisc Equip\nTherms","PS-E\nSpace Heating\nTherms","PS-E\nSpace Cooling\nTherms","PS-E\nHeat Reject\nTherms","PS-E\nPumps & Aux\nTherms","PS-E\nVentilation Fans\nTherms","PS-E\nRefrig Display\nTherms","PS-E\nHeat Pump Supplement\nTherms","PS-E\nDomestic Hot Water\nTherms","PS-E\nExterior Usage\nTherms","PS-E\nTotal\nTherms","BEPS\nBldg Energy\nMbtu","BEPS\nBldg EUI\nkBtu/sf/yr","TDV1\nBldg Energy\nTDV-Mbtu","TDV1\nBldg EUI\nTDV-kBtu/sf/yr","ES-E\nTotal Electric\n$","ES-E\nTotal Fuel\n$","ES-E\nElectric kWh\n$","ES-E\nElectric kW\n$","BEPS\nZone Outsd Thrtlng Rng\n% hrs","BEPS\nPlant Ld Not Met\n% hrs","SS-E\nHours Fan On\n# hrs","\nZone Outsd Thrtlng Rng\n# hrs","BEPS\nCool Loads Not Met\n# hrs","BEPS\nHeat Loads Not Met\n# hrs"]

{"sheet":"Results from EnergyPlus","index":5,"n_rows":10,"n_cols":30,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,0,1,31],[4,0,4,31]]}
["Results from EnergyPlus"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[]
["Instructions\n1) Set the “OutputControl:Table:Style” Unit Conversion to “InchPound”\n2) In the EnergyPlus eplustbl.html result file, navigate to the “LEED Summary” report.  Output results are found in tables:\n     a. ‘EAp2-4/5. Performance Rating Method Compliance’ contains energy and coincident peak demand for each end-use subcategory. (Copy to Table 1 below)\n     b. ‘EAp2-2. Advisory Messages’ contains occupied unmet hours (Copy to Table 2 below)\n3) Map each end-use in Table 1 below to an end-use on the Compliance Calculations tab in column A (choose from the list box). \n4) Revise the units in Table 3 on the Compliance Calculations tab for additional fuel to match the units in the output report, if necessary.\n\nTip: If you are having trouble pasting with all values pasting into the same cell. Right click-->click \"Paste Special\" and paste as \"Text\""]
[]
[]
[null,null,null,"ElectricitykWh","ElectricityW","Natural Gastherm","Natural GasBtu/h",null,null,null,null,null,null,"Additional FuelkBtu","Additional FuelBtu/h",null,null,null,null,null,null,null,null,"District CoolingTon-Hours","District Coolington","District HeatingkBtu","District HeatingBtu/h"]
[null,null,"Table 1: EAp2-4/5. Performance Rating Method Compliance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 2: EAp2-2. Advisory Messages"]
["End-use Mapping to Table 3 Column E on the Compliance Calculations tab",null,null,"Electricity Energy Use [kWh]","Electricity Demand [W]","Natural Gas Energy Use [therm]","Natural Gas Demand [Btu/h]","Gasoline Use [therm]","Gasoline Demand [Btu/h]","Diesel Use [kBtu]","Diesel Demand [Btu/h]","Coal Use [kBtu]","Coal Demand [Btu/h]","Additional Fuel Energy Use [kBtu]","Additional Fuel Demand [Btu/h]","Fuel Oil No 2 Use [kBtu]","Fuel Oil No 2 Demand [Btu/h]","Propane Use [kBtu]","Propane Demand [Btu/h]","Other Fuel 1 Use [kBtu]","Other Fuel 1 Demand [Btu/h]","Other Fuel 2 Use [kBtu]","Other Fuel 2 Demand [Btu/h]","District Cooling Use [ton-hrs]","District Cooling Demand [ton]","District Heating Use [kBtu]","District Heating Demand [Btu/h]",null,null,"Data"]

{"sheet":"Compliance Calculations","index":6,"n_rows":52,"n_cols":45,"rows_kept":52,"cut":false,"hidden":false,"merged":[[26,37,26,38],[26,33,26,36],[47,4,47,5],[0,4,1,9],[4,4,4,9],[5,4,5,9],[6,4,6,9],[7,4,7,9],[45,4,45,9],[8,4,8,9],[17,4,17,9],[24,4,24,9],[11,4,11,9],[26,31,26,32]]}
[null,null,null,null,"Compliance Calculations"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Table of Contents"]
[null,null,null,null,{"$f":"Comp_Calcs_Table1_Header","v":"Table 1: Heating TEDI Calculations"}]
[null,null,null,null,{"$f":"Comp_Calcs_Table2_Header","v":"Table 2: Cooling TEDI Calculations"}]
[null,null,null,null,{"$f":"Comp_Calcs_Table3_Header","v":"Table 3: Modeled Energy by End-use"}]
[null,null,null,null,{"$f":"Comp_Calcs_Table4_Header","v":"Table 4: Unmet Load Hours"}]
[]
[null,null,null,null,"Table 1: Heating TEDI Calculations"]
[null,null,null,null,"Instructions\n1. Report the annual heating output of all systems in the building that maintain space temperature setpoints and heat ventilation air including the heating coils of the central air systems (e.g., make-up air units and air handling units) and terminal equipment (e.g., fan coils, heat pumps and unit heaters) in column G."]
[]
[null,null,null,null,"Use Type","Modeled Floor Area (ft2)","∑Space and Ventilation Heating Output (kBtu)","Heating TEDI (kBtu/ft2)","Heating TEDI Limit (kBtu/ft2)","Heating TEDI Outcome",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row"]
[null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Long,AA15,),\"\")","v":""},{"$f":"Proj_Info_Cond_SF","v":0},null,{"$f":"IF(G15=\"\",\"-\",ROUND(G15/F15,1))","v":"-"},{"$f":"IFERROR(ROUND(INDEX(TEDI_Heating_Lookup,AA15,),1),\"-\")","v":"-"},{"$f":"IF(G15=\"\",\"In Progress\",IF(H15<=I15,\"Pass\",\"Fail\"))","v":"In Progress"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(TEDI_Space_Use_Lookup=Proj_Info_Predominant_Type),--(TEDI_Min_Area<Proj_Info_Cond_SF),--(TEDI_Max_Area>Proj_Info_Cond_SF),TEDI_Row)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"Table 2: Cooling TEDI Calculations"]
[null,null,null,null,"Instructions\n1. Report the annual cooling output of all HVAC systems that maintain space temperature setpoints and cool ventilation air, including but not limited to the cooling coils of the central air systems (e.g., make-up air units, air handling units.) and terminal equipment (e.g., fan coils and heat pumps) in column G."]
[]
[null,null,null,null,"Use Type","Modeled Floor Area (ft2)","∑Space and Ventilation Cooling Output (kBtu)","Cooling TEDI (kBtu/ft2)","Cooling TEDI Limit (kBtu/ft2)","Cooling TEDI Outcome",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row cooling sf","Row"]
[null,null,null,null,{"$f":"IFERROR(INDEX(TEDI_Space_Use_Long,AB21,),\"\")","v":""},{"$f":"Proj_Info_Cond_SF","v":0},null,{"$f":"IF(G21=\"\",\"-\",ROUND(G21/IFERROR((F21-Proj_Info_Heated_Only_Cooling_TEDI),0),0))","v":"-"},{"$f":"IFERROR(ROUND(INDEX(TEDI_Cooling_Lookup,AB21,),0),\"-\")","v":"-"},{"$f":"IF(G21=\"\",\"In Progress\",IF(H21<=I21,\"Pass\",\"Fail\"))","v":"In Progress"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(TEDI_Space_Use_Lookup=Proj_Info_Predominant_Type),--(TEDI_Min_Area<Proj_Info_Cond_SF-Proj_Info_Heated_Only_Cooling_TEDI),--(TEDI_Max_Area>Proj_Info_Cond_SF-Proj_Info_Heated_Only_Cooling_TEDI),TEDI_Row)","v":{"$error":"#N/A"}},{"$f":"AA15","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"Table 3: Modeled Energy by End-use"]
[null,null,null,null,"Instructions"]
[null,null,null,null,{"$f":"IF(OR(Proj_Info_Sim_Program=\"eQuest\",Proj_Info_Sim_Program=\"EnergyPlus\"),AA27,AB27)","v":"1. Enter simulation results manually in Table 3. Information in this table will be used for reviewer quality control."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supported","Not Supported"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}},null,1,2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"1. Populate Table 3 with results from \"&Proj_Info_Sim_Program&\" simulation reports by navigating to the \"\"Results from \"&Proj_Info_Sim_Program&\"\"\" tab and following the instructions on that tab to copy the standard simulation output reports. Information in this table will be used for reviewer quality control.\"","v":"1. Populate Table 3 with results from  simulation reports by navigating to the \"Results from \" tab and following the instructions on that tab to copy the standard simulation output reports. Information in this table will be used for reviewer quality control."},"1. Enter simulation results manually in Table 3. Information in this table will be used for reviewer quality control.",null,null,null,"Energy Consumption",null,"Energy Types",null,null,null,"Non-Coincident Peak Demand"]
[null,null,null,null,"End Use","Energy Type","Energy Use Units","Modeled Site Energy Use",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Energy Type","Default Energy Use Units","Default Energy Demand Units","Lookup - Consumption","Lookup - Demand","eQuest","EnergyPlus","Energy Types","eQuest","EnergyPlus","Software Energy","eQuest","EnergyPlus","kBtu","kBtu/h","Lighting kBtu","Lighting kBtu/h","Misc kBtu","Misc kBtu/h"]
[null,null,null,null,"Interior lighting",{"$f":"AA29","v":"Electricity"},{"$f":"AB29","v":"kWh"},{"$f":"IFERROR(IF(Proj_Info_Sim_Program=\"eQuest\",AF29,IF(Proj_Info_Sim_Program=\"EnergyPlus\",AG29,\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},{"$f":"E29&AK29&G29","v":"Interior lightingElectricitykWh"},"Not Used",{"$f":"IFERROR(SUMIF(INDEX(Results_eQuest_Lookup,1,),$AD29,INDEX(Results_from_eQuest_Data,,)),0)","v":0},{"$f":"IFERROR(SUMIF(INDEX(Results_from_EnergyPlus_EndUse_Lookup,,1),$E29,INDEX(Results_from_EnergyPlus_Data,,MATCH($AK29&$G29,Results_from_EnergyPlus_Fuel_Lookup,0))),0)","v":0},"Electricity","Electricity","Electricity",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F29,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H29*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F29&G29,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G29,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used",{"$f":"SUMIF(E29:E42,\"Interior lighting\",AN29:AN42)","v":0},"Not Used",{"$f":"SUMIF(E29:E42,\"Misc equipment\",AN29:AN42)","v":0},"Not Used"]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}},null,"Exterior lighting","Electricity","kWh","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},{"$f":"E30&AK30&G30","v":"Exterior lightingElectricitykWh"},"Not Used",0,{"$f":"IFERROR(SUMIF(INDEX(Results_from_EnergyPlus_EndUse_Lookup,,1),$E30,INDEX(Results_from_EnergyPlus_Data,,MATCH($AK30&$G30,Results_from_EnergyPlus_Fuel_Lookup,0))),0)","v":0},"Natural Gas","Natural Gas","Natural Gas",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F30,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H30*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F30&G30,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G30,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,null,null,"Space heating","Electricity","kWh","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},"Space heatingElectricitykWh","Not Used",0,0,"District Cooling",null,"District Cooling",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F31,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H31*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F31&G31,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G31,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,null,null,"Space heating","Natural Gas","therm","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas","therm",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"Btu/hr\",\"kBtu/hr\")","v":"kBtu/hr"},"Space heatingNatural Gastherm","Not Used",0,0,"District Hot Water",null,"District Heating",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F32,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Natural Gas"},"Not Used","Not Used",{"$f":"IFERROR(H32*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F32&G32,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G32,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,null,null,"Heat pump supplemental heater","Electricity","kWh","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},"Heat pump supplemental heaterElectricitykWh","Not Used",0,0,"District Steam",null,"District Heating",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F33,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H33*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F33&G33,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G33,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,null,null,"Space cooling","Electricity","kWh","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},"Space coolingElectricitykWh","Not Used",0,0,"Fuel Oil / Diesel",null,"Additional Fuel",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F34,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H34*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F34&G34,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G34,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,null,null,"Space cooling","Natural Gas","therm","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas","therm",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"Btu/hr\",\"kBtu/hr\")","v":"kBtu/hr"},"Space coolingNatural Gastherm","Not Used",0,0,"Propane",null,"Additional Fuel",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F35,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Natural Gas"},"Not Used","Not Used",{"$f":"IFERROR(H35*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F35&G35,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G35,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,null,null,"Pumps","Electricity","kWh","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},"PumpsElectricitykWh","Not Used",0,0,"Fuel Oil (No. 5 & No.6)",null,"Additional Fuel",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F36,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H36*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F36&G36,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G36,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,null,null,"Heat rejection","Electricity","kWh","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},"Heat rejectionElectricitykWh","Not Used",0,0,"Kerosene",null,"Additional Fuel",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F37,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H37*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F37&G37,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G37,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,null,null,"Fans - interior ventilation","Electricity","kWh","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},"Fans - interior ventilationElectricitykWh","Not Used",0,0,"Coal (anthracite)",null,"Additional Fuel",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F38,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H38*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F38&G38,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G38,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}},null,"Service water heating","Electricity","kWh","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},"Service water heatingElectricitykWh","Not Used",0,0,"Coal (bituminous)",null,"Additional Fuel",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F39,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H39*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F39&G39,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G39,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}},null,"Service water heating","Natural Gas","therm","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas","therm",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"Btu/hr\",\"kBtu/hr\")","v":"kBtu/hr"},"Service water heatingNatural Gastherm","Not Used",0,0,"Coke",null,"Additional Fuel",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F40,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Natural Gas"},"Not Used","Not Used",{"$f":"IFERROR(H40*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F40&G40,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G40,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,null,null,"Misc equipment","Electricity","kWh","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity","kWh",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"W\",\"kW\")","v":"kW"},"Misc equipmentElectricitykWh","Not Used",0,0,"Wood",null,"Additional Fuel",{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F41,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Electricity"},"Not Used","Not Used",{"$f":"IFERROR(H41*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F41&G41,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G41,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}},null,"Misc equipment","Natural Gas","therm","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas","therm",{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",\"Btu/hr\",\"kBtu/hr\")","v":"kBtu/hr"},"Misc equipmentNatural Gastherm","Not Used",0,0,null,null,null,{"$f":"IFERROR(INDEX($AI$29:$AJ$41,MATCH(F42,$AH$29:$AH$41,0),IF(Proj_Info_Sim_Program=\"eQuest\",1,2)),\"\")","v":"Natural Gas"},"Not Used","Not Used",{"$f":"IFERROR(H42*IFERROR(INDEX(Ref_Energy_Conversion_kBtu,MATCH(F42&G42,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3),INDEX(Ref_Energy_Conversion_kBtu,MATCH(\"All\"&G42,INDEX(Ref_Energy_Conversion_kBtu,,Reference!$AE$3),0),Reference!$AF$3)),0)","v":0},"Not Used"]
[]
[null,null,null,null,"Table 4: Unmet Load Hours"]
[null,null,null,null,"Instructions"]
[null,null,null,null,{"$f":"IF(OR(Proj_Info_Sim_Program=\"eQuest\",Proj_Info_Sim_Program=\"EnergyPlus\"),AA49,AB49)","v":"1. Enter unmet load hours manually in Table 4."}]
[]
[null,null,null,null,"Unmet Loads Modeled ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supported","Not Supported"]
[null,null,null,null,"Number of heating loads not met",{"$f":"IF(Proj_Info_Sim_Program=\"eQuest\",AA51,IF(Proj_Info_Sim_Program=\"EnergyPlus\",AB51,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"1. Populate Table 4 with results from \"&Proj_Info_Sim_Program&\" simulation reports by navigating to the \"\"Results from \"&Proj_Info_Sim_Program&\"\"\" tab and following the instructions on that tab to copy the standard simulation output reports.\"","v":"1. Populate Table 4 with results from  simulation reports by navigating to the \"Results from \" tab and following the instructions on that tab to copy the standard simulation output reports."},"1. Enter unmet load hours manually in Table 4."]
[null,null,null,null,"Number of cooling loads not met",{"$f":"IF(Proj_Info_Sim_Program=\"eQuest\",AA52,IF(Proj_Info_Sim_Program=\"EnergyPlus\",AB52,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"eQuest","EnergyPlus"]
[null,null,null,null,"Total",{"$f":"IFERROR(IF(F49+F50=0,\"\",F49+F50),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Results from eQuest'!$BX$9","v":0},{"$f":"'Results from EnergyPlus'!$AD$11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Results from eQuest'!$BW$9","v":0},{"$f":"'Results from EnergyPlus'!$AD$12","v":0}]

{"sheet":"Quality Control Checks","index":7,"n_rows":42,"n_cols":30,"rows_kept":42,"cut":false,"hidden":false,"merged":[[19,12,19,21],[12,6,12,7],[13,6,13,7],[14,6,14,7],[20,12,20,21],[16,4,16,21],[12,8,12,9],[13,8,13,9],[21,12,21,21],[22,12,22,21],[20,5,20,9],[0,4,1,21],[9,4,9,21],[19,10,19,11],[19,5,19,9],[17,4,17,21],[4,4,4,21],[6,4,6,21],[7,4,7,21],[11,4,11,21],[12,4,12,5],[13,4,13,5],[14,4,14,5],[5,4,5,21],[41,4,41,7],[34,8,34,9],[34,10,34,11],[37,8,37,9],[37,10,37,11],[40,8,40,9],[40,10,40,11],[41,8,41,9],[41,10,41,11],[36,10,36,11],[40,4,40,7],[39,4,39,7],[40,12,40,13],[38,12,38,13],[39,8,39,9],[39,10,39,11],[39,12,39,13],[36,12,36,13],[39,14,39,21],[35,12,35,13],[34,14,34,21],[38,4,38,7],[35,4,35,7],[36,4,36,7],[37,4,37,7],[35,14,35,21],[36,14,36,21],[37,14,37,21],[38,14,38,21],[36,8,36,9],[34,4,34,7],[35,8,35,9],[35,10,35,11],[28,4,28,21],[32,8,32,13],[33,8,33,9],[33,10,33,11],[33,12,33,13],[32,4,33,7],[30,4,30,7],[30,8,30,13],[32,14,33,21],[21,5,21,9],[22,5,22,9],[40,14,40,21],[41,14,41,21],[14,8,14,9],[27,4,27,21],[24,4,24,10],[25,4,25,21],[20,10,20,11],[21,10,21,11],[22,10,22,11],[41,12,41,13],[37,12,37,13],[38,8,38,9],[38,10,38,11],[34,12,34,13]]}
[null,null,null,null,"Quality Control Checks"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Table of Contents"]
[null,null,null,null,{"$f":"QC_Table1_Header","v":"Table 1: Modeled vs Standardized Inputs Energy Consumption"}]
[null,null,null,null,{"$f":"QC_Table3_Header","v":"Table 2: Schedules and Loads Guideline Supplement Checks"}]
[null,null,null,null,{"$f":"QC_Table4_Header","v":"Table 3: Modeled vs Benchmark Energy Use Intensity (EUI) by End-Use"}]
[]
[null,null,null,null,"This tab performs automatic quality control checks for modeled unmet loads, lighting, and miscellaneous equipment based on the information reported in Table 3 and Table 4 on the Compliance Calculations tab and the thermal blocks reported in Table 2 on the Project Information tab. Table 3 on this tab also performs quality control checks on the modeled energy use intensity (EUI) by end use compared to the models used to establish the TEDI targets."]
[]
[null,null,null,null,"Table 1: Modeled vs Standardized Inputs Energy Consumption"]
[null,null,null,null,"-",null,"Annual Lighting Use [kWh] ",null,"Annual Miscellaneous Use [kWh] "]
[null,null,null,null,"Modeled",null,{"$f":"IFERROR(Modeled_Lighting_kBtu/3.412,\"0\")","v":0},null,{"$f":"IFERROR(Modeled_Misc_kBtu/3.412,\"0\")","v":0}]
[null,null,null,null,"Standardized Inputs",null,{"$f":"Proj_Info_Lighting_kWh","v":0},null,{"$f":"Proj_Info_Misc_kWh","v":0}]
[]
[null,null,null,null,"Table 2: Schedules and Loads Guideline Supplement Checks"]
[null,null,null,null,"Instructions\n1. Review flagged QC checks. Update the model and/or inputs in this tool as appropriate to address the \"Fail\" outcomes before submitting the package for review to the AHJ."]
[]
[null,null,null,null,"#","Review Check",null,null,null,null,"Review Outcome",null,"Required Action"]
[null,null,null,null,1,"Unmet load hours do not exceed 300 of the 8760 hours simulated.",null,null,null,null,{"$f":"IF(Comp_Calcs_Unmet_Load_Hours=\"\",\"In Progress\",IF(Comp_Calcs_Unmet_Load_Hours>300,\"Fail\",\"Pass\"))","v":"In Progress"},null,{"$f":"IF(K21=\"In Progress\",\"Report the unmet load hours in Table 4 on the Compliance Calculations tab.\",IF(K21=\"Fail\",\"Revise the energy model so that the unmet load hours do not exceed 300.\",\"None\"))","v":"Report the unmet load hours in Table 4 on the Compliance Calculations tab."},null,null,null,null,null,null,null,null,null,null,null,null,null,"Margin Less","Margin Greater","% diff from standardized inputs","Pass/Fail/Review Inputs"]
[null,null,null,null,2,"Modeled interior lighting energy consumption aligns with the Schedules and Loads Guideline Supplement.",null,null,null,null,{"$f":"IF(OR(G14=0,G15=0),\"In Progress\",AD22)","v":"In Progress"},null,{"$f":"IF(K22=\"In Progress\",\"Report the modeled interior lighting consumption on the Compliance Calculations tab and report the thermal block types and areas on the Project Information tab.\",IF(K22=\"Review Inputs\", \"Modeled interior lighting consumption is lower than expected based on the Schedules and Loads Guideline Supplement. However, this may be due to daylighting controls. Please review model inputs related to interior lighting.\",IF(K22=\"Fail\",\"Modeled interior lighting consumption is higher than expected based on the Schedules and Loads Guideline Supplement. Please review and revise model inputs related to interior lighting.\",\"None\")))","v":"Report the modeled interior lighting consumption on the Compliance Calculations tab and report the thermal block types and areas on the Project Information tab."},null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,0.03,{"$f":"(G15-G14)/G15","v":{"$error":"#DIV/0!"}},{"$f":"IF(AC22>0,IF(ABS(AC22)>AA22,\"Review Inputs\",\"Pass\"),IF(ABS(AC22)>AB22,\"Fail\",\"Pass\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,3,"Modeled miscellaneous equipment energy consumption aligns with the Schedules and Loads Guideline Supplement.",null,null,null,null,{"$f":"IF(OR(I14=0,I15=0),\"In Progress\",AD23)","v":"In Progress"},null,{"$f":"IF(K23=\"In Progress\",\"Report the modeled miscellaneous equipment energy consumption on the Compliance Calculations tab and report the thermal block types and areas on the Project Information tab.\",IF(K23=\"Fail\",IF(AC23<0,\"Modeled miscellaneous equipment energy consumption is higher than expected based on the Schedules and Loads Guideline Supplement. Please review and revise model inputs related to miscellaneous equipment. \"&\"Note that gas-fired appliances (stoves and dryers) should be excluded from the model per Section 7 of the Simulation Guidelines.\",\"Modeled miscellaneous equipment energy consumption is lower than expected based on the Schedules and Loads Guideline Supplement. Please review and revise model inputs related to miscellaneous equipment.\"),\"None\"))","v":"Report the modeled miscellaneous equipment energy consumption on the Compliance Calculations tab and report the thermal block types and areas on the Project Information tab."},null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,0.03,{"$f":"(I15-I14)/I15","v":{"$error":"#DIV/0!"}},{"$f":"IF(ABS(AC23)>AA23,\"Fail\",\"Pass\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Notes\nPlease include applicable notes as needed."]
[]
[]
[null,null,null,null,"Table 3: Modeled vs Benchmark Energy Use Intensity (EUI) by End-Use"]
[null,null,null,null,"Instructions\n1. If prompted, select the sample model benchmark. Note that there are no sample models for offices or schools between 75,000-sf and 125,000-sf.\n2. Review flagged end uses indicated with blue cell fill. Update the model and/or inputs in this tool as appropriate to address the flags before submitting the package for review to the AHJ, or provide an explanation for the flagged end uses. Note that flagged end uses do not indicate an issue with the model; it only means that the modeled parameters for that end use should be reviewed and verified since they differ significantly (by more than 25%) from the sample models."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default","Model Row","% Difference Flag"]
[null,null,null,null,"Sample Model Benchmark",null,null,null,{"$f":"IFERROR(IF(INDEX(Sample_Models_EUIs,MATCH(Comp_Calcs_Use_Type,INDEX(Sample_Models_EUIs,,Reference!$M$3),0),Reference!$N$3)=0,\"<Please select benchmark>\",INDEX(Sample_Models_EUIs,MATCH(Comp_Calcs_Use_Type,INDEX(Sample_Models_EUIs,,Reference!$M$3),0),Reference!$N$3)),\"Please complete the Project Information tab\")","v":"Please complete the Project Information tab"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(Sample_Models_EUIs,MATCH(Comp_Calcs_Use_Type,INDEX(Sample_Models_EUIs,,Reference!$M$3),0),Reference!$N$3)=0,\"<Please select benchmark>\",INDEX(Sample_Models_EUIs,MATCH(Comp_Calcs_Use_Type,INDEX(Sample_Models_EUIs,,Reference!$M$3),0),Reference!$N$3))","v":{"$error":"#N/A"}},{"$f":"MATCH($I$31,INDEX(Sample_Models_EUIs,,Reference!$N$3),0)","v":{"$error":"#N/A"}},0.25]
[]
[null,null,null,null,"End Use",null,null,null,"Site Energy Use Intensity (kBtu/sf/yr)",null,null,null,null,null,"Modeler Explanation"]
[null,null,null,null,null,null,null,null,"Modeled",null,"Benchmark",null,"% Difference",null,null,null,null,null,null,null,null,null,null,null,null,null,"End Use Column"]
[null,null,null,null,"Interior lighting",null,null,null,{"$f":"IFERROR(SUMIF(Comp_Calcs_End_Uses,E35,Comp_Calcs_kBtu)/Proj_Info_Cond_SF,\"-\")","v":"-"},null,{"$f":"IFERROR(INDEX(Sample_Models_EUIs,$AB$31,AA35),\"-\")","v":"-"},null,{"$f":"IFERROR(IF(OR(I35=0,K35=0),\"-\",(K35-I35)/K35),\"-\")","v":"-"},null,{"$f":"IFERROR(IF(ABS(M35)<=$AC$31,\"N/A\",\"\"),\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Reference!O3","v":3}]
[null,null,null,null,"Space heating",null,null,null,"-",null,{"$f":"IFERROR(INDEX(Sample_Models_EUIs,$AB$31,AA36),\"-\")","v":"-"},null,{"$f":"IFERROR(IF(OR(I36=0,K36=0),\"-\",(K36-I36)/K36),\"-\")","v":"-"},null,{"$f":"IFERROR(IF(ABS(M36)<=$AC$31,\"N/A\",\"\"),\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Reference!P3","v":4}]
[null,null,null,null,"Heat pump supplemental heater",null,null,null,"-",null,{"$f":"IFERROR(INDEX(Sample_Models_EUIs,$AB$31,AA37),\"-\")","v":"-"},null,"-",null,"N/A",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Reference!Q3","v":5}]
[null,null,null,null,"Space cooling",null,null,null,"-",null,{"$f":"IFERROR(INDEX(Sample_Models_EUIs,$AB$31,AA38),\"-\")","v":"-"},null,"-",null,"N/A",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Reference!R3","v":6}]
[null,null,null,null,"Pumps",null,null,null,"-",null,{"$f":"IFERROR(INDEX(Sample_Models_EUIs,$AB$31,AA39),\"-\")","v":"-"},null,"-",null,"N/A",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Reference!S3","v":7}]
[null,null,null,null,"Heat rejection",null,null,null,"-",null,{"$f":"IFERROR(INDEX(Sample_Models_EUIs,$AB$31,AA40),\"-\")","v":"-"},null,"-",null,"N/A",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Reference!T3","v":8}]
[null,null,null,null,"Fans - interior ventilation",null,null,null,"-",null,{"$f":"IFERROR(INDEX(Sample_Models_EUIs,$AB$31,AA41),\"-\")","v":"-"},null,"-",null,"N/A",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Reference!U3","v":9}]
[null,null,null,null,"Misc equipment",null,null,null,"-",null,{"$f":"IFERROR(INDEX(Sample_Models_EUIs,$AB$31,AA42),\"-\")","v":"-"},null,"-",null,"N/A",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Reference!V3","v":10}]

{"sheet":"Submittal Checklist","index":8,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,4,43,21],[29,12,29,13],[30,12,30,13],[4,4,4,21],[10,4,10,21],[5,4,5,21],[30,14,30,21],[11,4,11,21],[13,5,13,11],[14,5,14,11],[15,5,15,11],[24,5,24,11],[25,5,25,11],[26,5,26,11],[21,5,21,11],[15,12,15,13],[28,14,28,21],[0,4,1,21],[8,4,8,21],[13,12,13,13],[13,14,13,21],[14,12,14,13],[6,4,6,21],[16,12,16,13],[17,12,17,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[19,14,19,21],[40,5,40,11],[35,5,35,11],[21,12,21,13],[29,14,29,21],[14,14,14,21],[15,14,15,21],[16,14,16,21],[17,14,17,21],[18,14,18,21],[27,12,27,13],[28,12,28,13],[23,14,23,21],[24,14,24,21],[25,14,25,21],[26,14,26,21],[27,14,27,21],[34,14,34,21],[35,14,35,21],[36,14,36,21],[34,4,40,4],[27,5,27,11],[32,5,32,11],[33,5,33,11],[28,5,28,11],[39,5,39,11],[36,5,36,11],[37,5,37,11],[29,5,29,11],[30,5,30,11],[31,4,31,11],[34,5,34,11],[38,5,38,11],[31,12,31,21],[40,12,40,13],[39,12,39,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[32,12,32,13],[33,12,33,13],[32,14,32,21],[33,14,33,21],[39,14,39,21],[40,14,40,21],[37,14,37,21],[38,14,38,21],[34,12,34,13],[35,12,35,13],[20,14,20,21],[21,14,21,21],[22,14,22,21],[23,12,23,13],[22,12,22,13],[22,5,22,11],[23,5,23,11],[16,5,16,11],[17,5,17,11],[18,5,18,11],[19,5,19,11],[20,5,20,11]]}
[null,null,null,null,"Submittal Checklist"]
[]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Table of Contents"]
[null,null,null,null,{"$f":"Submittal_Checklist_Table1_Header","v":"Table 1: Submittal Checklist"}]
[null,null,null,null,{"$f":"Submittal_Checklist_Report_Gen_Header","v":"TEDI Tool Compliance Report Generation"}]
[]
[null,null,null,null,"This tab lists documentation that must be submitted to the authority having jurisdiction to document compliance in addition to the completed TEDI Compliance Tool. The requirements are based on Massachusetts Stretch Energy Code and Attachment C. In addition to the standard items that must be provided for all projects, the supporting information is requested where appropriate based on the project information reported on other tabs."]
[]
[null,null,null,null,"Table 1: Submittal Checklist"]
[null,null,null,null,"Instructions\n1. Once the required documentation has been submitted, change the \"Submitted?\" column to \"Yes\" and report the file or document name where the required documentation is found. "]
[]
[null,null,null,null,"#","Required Documentation",null,null,null,null,null,null,"Submitted?",null,"File or document name where information is found, and locations of the information within the document if applicable"]
[null,null,null,null,1,"Modeler resume documenting years of full-time modeling experience.",null,null,null,null,null,null,"No"]
[null,null,null,null,2,"Completed COMcheck submittal: COMcheck envelope, lighting, and mechanical compliance certificates, and plan review inspection checklist.",null,null,null,null,null,null,"No"]
[null,null,null,null,3,"PE stamped thermal bridging calculations following Attachment A.",null,null,null,null,null,null,"No"]
[null,null,null,null,4,"Maintenance and system commissioning plan in accordance with C408.",null,null,null,null,null,null,"No"]
[null,null,null,null,5,"Average ventilation rate calculations, similar to what is required by Section C103.2 #16.",null,null,null,null,null,null,"No"]
[null,null,{"$f":"IF(Proj_Info_External_Calcs=\"Yes\",1,5/0)","v":{"$error":"#DIV/0!"}},null,6,"Supporting calculations for external calculations in accordance with 90.1 2019 Section G2.5 (a) - (e).",null,null,null,null,null,null,"No"]
[null,null,{"$f":"5/0","v":{"$error":"#DIV/0!"}},null,7,"Completed mandatory requirements checklist.",null,null,null,null,null,null,"No"]
[null,null,null,null,8,"All applicable sections of this TEDI Tool are fully filled out.",null,null,null,null,null,null,"No"]
[null,null,null,null,9,"TEDI Tool compliance report (see \"TEDI Tool Compliance Report Generation\" below Table 1).",null,null,null,null,null,null,"No"]
[null,null,null,null,10,"A site plan showing all adjacent buildings and topography that may shade the proposed building, with the estimated height or number of stories.",null,null,null,null,null,null,"No"]
[null,null,null,null,11,"Design documens that the submittal is based on.",null,null,null,null,null,null,"No"]
[null,null,null,null,12,"A diagram showing the thermal blocks used in the computer simulation.",null,null,null,null,null,null,"No"]
[null,null,null,null,13,"An explanation of any significant modeling assumptions, such as systems and components that could not be explicitly modeled in the simulation tool and required work-arounds.",null,null,null,null,null,null,"No"]
[null,null,null,null,14,"Fenestration documentation in accordance with C402.4.6.",null,null,null,null,null,null,"No"]
[null,null,null,null,15,"An explanation of any error messages noted in the simulation program output.",null,null,null,null,null,null,"No"]
[null,null,null,null,16,"Addressed all quality control checks in Table 3 on the \"Quality Controls Checks\" tab in this TEDI Tool.",null,null,null,null,null,null,"No"]
[null,null,null,null,17,"Air leakage testing reports in accordance with Section C402.5.2.",null,null,null,null,null,null,"No"]
[null,null,null,null,"Simulation Files and Reports"]
[null,null,{"$f":"IF(Proj_Info_Sim_Program=\"eQuest\",1,5/0)","v":{"$error":"#DIV/0!"}},null,"eQuest","<project name>.SIM file with the complete set of simulation reports.",null,null,null,null,null,null,"No"]
[null,null,{"$f":"IF(Proj_Info_Sim_Program=\"EnergyPlus\",1,5/0)","v":{"$error":"#DIV/0!"}},null,"EnergyPlus","Complete set of simulation reports in the HTML format (See Annex 1 of the Appendix C: Targeted Performance Simulation Guidelines for instructions).",null,null,null,null,null,null,"No"]
[null,null,{"$f":"IF(Proj_Info_Sim_Program=\"IESVE\",1,5/0)","v":{"$error":"#DIV/0!"}},null,"IESVE","Room Loads Report",null,null,null,null,null,null,"No"]
[null,null,{"$error":"#DIV/0!"},null,null,"Zone Loads Report",null,null,null,null,null,null,"No"]
[null,null,{"$error":"#DIV/0!"},null,null,"Space Loads & Ventilation Report",null,null,null,null,null,null,"No"]
[null,null,{"$error":"#DIV/0!"},null,null,"System Loads Report",null,null,null,null,null,null,"No"]
[null,null,{"$error":"#DIV/0!"},null,null,"Energy Model Output Report",null,null,null,null,null,null,"No"]
[null,null,{"$error":"#DIV/0!"},null,null,"Unmet Hours Report",null,null,null,null,null,null,"No"]
[null,null,{"$error":"#DIV/0!"},null,null,"Detailed Simulation Report",null,null,null,null,null,null,"No"]
[]
[null,null,null,null,"TEDI Tool Compliance Report Generation"]
[null,null,null,null,"Instructions\n1. Click the button below to generate a PDF report of this TEDI Compliance Tool. The PDF report will appear in the folder where this workbook is located."]

{"sheet":"Revision Log","index":9,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,1,3]]}
[null,"Revision Log"]
[]
[]
[null,"Version #, the changes listed are included in the associated version number","Date Changes Made","Description of Revisions"]
[null,1.1000000000000001,"2024-12-09","1. Fixed typo on the Project Information tab that had occupant density in CFM/sf instead of sf/person.\n2. Adjusted allowable miscellaneous equipment deviation before flagging to be 3%+- the standardized inputs, instead of 15%, on the Quality Control Checks tab.\n3. Adjusted allowable lighting consumption deviation before flagging to be 3% greater or 15% less (to account for daylight dimming controls) than the standardized inputs on the Quality Control Checks tab.\n4. Fixed formatting bug in Table 3 on the Quality Control Checks tab that was only highlighting end uses that were less than the benchmark by the allowable margin. The formatting was updated so that positive and negative deviations from the benchmark above the allowable margin are flagged.\n5. Fixed bug that was not accounting for school summer schedules for lighting and miscellaneous equipment when calculating the standardized inputs in Table 1 on the Quality Control Checks tab. The schedules now use the schedules in R3 of the Schedule and Loads Guideline Supplement, including summer schedules for schools."]

{"sheet":"Reference","index":10,"n_rows":43,"n_cols":105,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Phase","Simulation Software","Yes or No","Building Area Types","HVAC_Modeling_Method","HVAC_Modeling_Method_Default_Only","Thermal_Block_Options","eQuest_Version","EnergyPlus_Version","IESVE_Version","Other_Version","Weather_File_Options","Yes_No_NA_Blank","End_Use_List","Checkmark_NA_Blank","Energy Types","Sample_Model_Types"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proj_Phase","Sim_Software","Yes_No","Bldg_Area_Type","HVAC_Modeling_Method","HVAC_Modeling_Method_Default_Only","Thermal_Block_Options","eQuest_Version","EnergyPlus_Version","IESVE_Version","Other_Version","Weather_File_Options","Yes_No_NA_Blank","End_Use_List","Checkmark_NA_Blank","Energy_Types","Sample_Model_Types"]
[null,"Default HVAC Parameters",1,2,3,4,5,6,7,null,null,"kBtu/sf",1,2,3,4,5,6,7,8,9,10,null,1,2,3,null,null,1,2,3,4,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,null,null,null,null,null,1,2,3,4,5,6,7,null,null,"Table C407.1.1.5 Thermal Energy Demand Intensity (TEDI) Limits",null,null,null,null,null,null,null,null,"Thermal Blocks","Thermal Block Building Catergory","Building Area Type","Space Use Category for TEDI",null,null,"90% Construction Documents","eQuest","Yes","Office","Default HVAC System Configuration","Default HVAC System Configuration",{"$f":"_xlfn.UNIQUE(_xlfn.VSTACK(IFERROR(_xlfn._xlws.FILTER($CE$4:$CE$12,$CF$4:$CF$12=Proj_Info_Predominant_Type,\"\"),\"\")))","v":""},"3.65+ DOE2.3","9.3.0+","2021.4.0.0+","Other","USA_MA_Boston-Logan.Intl.AP.725090_TMYx.2004-2018","Yes","Interior lighting","✓","Electricity","Large Office >= 125,000-sf"]
[null,"Row","Use Type","Heating/Cooling System Type","System Type","Fan Control","Cooling Type","Heating Type","Fan Power of Heating/Cooling Eqp",null,null,"Row","Use Type","Model","Interior lighting","Space heating","Heat pump supplemental heater","Space cooling","Pumps","Heat rejection","Fans - interior ventilation","Misc equipment",null,"Demand_Units","Demand_Units_Long","Demand_Multiplier_to_MBH",null,null,"Energy_Type","Energy_Units","Energy_Units_Lookup","Energy_Content_kBtu_Unit","Energy_Units_Long",null,null,null,"Electricity","Natural Gas","District Cooling","District Hot Water","District Steam","Fuel Oil / Diesel","Propane","Fuel Oil (No. 5 & No.6)","Kerosene","Coal (anthracite)","Coal (bituminous)","Coke","Wood",null,"Schedule","Lighting EFLH","Misc EFLH (D, F, G <= 75000)","Misc EFLH (D, F, G > 75000)","Misc EFLH for Project","Peak lighting fraction","Peak misc fraction (D, F, G <= 75000)","Peak misc fraction (D, F, G > 75000)","Peak misc project",null,"Row","Minimum Floor Area","Maximum Floor Area","Thermal block Type","Schedule index","misc loads (w/sf)","lighting power (W/sf)","ventilation rate (CFM/sf)","occupant density (sf/person)","sensible occupant heat gain (Btu/h-person)","latent occupant heat gain (Btu/h-person)",null,"Row","Use Type","Heating TEDI (kBtu/sf-yr)","Cooling TEDI (kBtu/sf-yr)","Heating TEDI Calculated","Cooling TEDI Calculated","Minimum Floor Area","Maximum Floor Area","Space Use Category",null,"Residential Building: Residential","Residential","Office","Misc",null,null,"100% Construction Documents","EnergyPlus","No","Fire Station","As-designed HVAC Systems",null,null,"Other","Other","Other",null,"Other - AHJ approved (describe below)","No","Exterior lighting","N/A","Natural Gas","Small Office <= 75,000-sf"]
[null,1,"Office, fire station, library, police station, post office, town hall >= 125,000-sf","System 2 FCU","4-Pipe fan coil units with CHW and HW","Constant Volume","Chilled water","Hot-water electric boiler",2.4000000000000001E-4,null,null,1,"Office, fire station, library, police station, post office, town hall >= 125,000-sf","Large Office >= 125,000-sf",4.4514097999172018,1.0371040404196183,0,2.6839329254040418,2.521396874885375,1.3531299828951746,3.2511860379734703,11.48951149981689,null,"kW","Kilowatt",3.4119999999999999,null,null,"All","kWh",{"$f":"AC5&AD5","v":"AllkWh"},3.4119999999999999,"Kilowatt hour",null,null,null,"kWh","therm","Btu","Btu","Lbs.","Liters","Liters","Liters","Liters","Lbs.","Lbs.","Lbs.","Lbs.",null,"A",854.10000000000025,2116.9999999999991,2116.9999999999991,{"$f":"BB5","v":2116.9999999999991},0.217,0.5,0.5,{"$f":"BF5","v":0.5},null,1,75000,10000000,"Residential Building: Residential","A",1.74,0.41,9.6000000000000002E-2,245,257,166,null,1,"Office, fire station, library, police station, post office, town hall >= 125,000-sf",1.5,23,{"$f":"BW5","v":1.5},{"$f":"BX5","v":23},125000,10000000,"Misc",null,"Residential Building: Supporting Spaces","Residential","Fire Station","Misc",null,null,"As-built Construction Documents","IESVE",null,"Library",null,null,null,null,null,null,null,null,"N/A","Space heating",null,"District Cooling","Large School >= 125,000-sf"]
[null,2,"Office, fire station, library, police station, post office,town hall between 75,000 and 125,000-sf","System 2 FCU","4-Pipe fan coil units with CHW and HW","Constant Volume","Chilled water","Hot-water electric boiler",2.4000000000000001E-4,null,null,2,"Office, fire station, library, police station, post office,town hall between 75,000 and 125,000-sf",null,5.2746305262576945,0.36335046456438047,0,3.6403757832858257,0,0,2.6258285937176042,10.110615956134501,null,"MW","Megawatt",3412,null,null,"All","MWh",{"$f":"AC6&AD6","v":"AllMWh"},3412,"Megawatt hour",null,null,null,"MWh","cf","kBtu","kBtu","kLbs.","Gallons","Gallons","Gallons","Gallons","kLbs.","kLbs.","kLbs.","Tons",null,"B",6361.5120000000006,3285,3285,{"$f":"BB6","v":3285},0.72619999999999996,0.9,0.9,{"$f":"BF6","v":0.9},null,2,75000,10000000,"Residential Building: Supporting Spaces","B",0.2,0.46,7.8E-2,1000,257,166,null,2,"Office, fire station, library, police station, post office,town hall between 75,000 and 125,000-sf","4 - 0.00002 * Area (sf)","18 + 0.00004 * Area (sf)",{"$f":"4-0.00002*Proj_Info_Cond_SF","v":4},{"$f":"18+0.00004*(Proj_Info_Cond_SF-Proj_Info_Heated_Only_Cooling_TEDI)","v":{"$error":"#DIV/0!"}},75000,125000,"Misc",null,"Residential Building: Nonresidential","Residential","Library","Misc",null,null,"Other - Please describe below","Other (Describe in notes section below)",null,"Police Station",null,null,null,null,null,null,null,null,null,"Heat pump supplemental heater",null,"District Hot Water","Small School <= 75,000-sf"]
[null,3,"Office, fire station, library, police station, post office, town hall <= 75,000-sf","System 1 ASHP","Air source heat pump","Constant Volume","Direct expansion","Electric heat pump",2.4000000000000001E-4,null,null,3,"Office, fire station, library, police station, post office, town hall <= 75,000-sf","Small Office <= 75,000-sf",5.2746305262576945,0.36335046456438047,0,3.6403757832858257,0,0,2.6258285937176042,10.110615956134501,null,"Btu/hr","British thermal unit per hour",1E-3,null,null,"All","kBtu","AllkBtu",1,"(British thermal unit) x 1,000",null,null,null,"Btu","ccf","MMBtu","MMBtu","Mlbs.","Btu","Btu","Btu","Btu","MLbs.","MLbs","MLbs","Btu",null,"C",4380.0000000000009,3284.9999999999995,3284.9999999999995,3284.9999999999995,0.8,0.74077669902912613,0.74077669902912613,0.74077669902912613,null,3,75000,10000000,"Residential Building: Nonresidential","C",1.1499999999999999,0.66,0.11,200,257,166,null,3,"Office, fire station, library, police station, post office, town hall <= 75,000-sf",2.5,21,{"$f":"BW7","v":2.5},{"$f":"BX7","v":21},0,75000,"Misc",null,"K-12 Cafeteria","K-12","Police Station","Misc",null,null,null,null,null,"Post Office",null,null,null,null,null,null,null,null,null,"Space cooling",null,"District Steam","Multifamily Tower"]
[null,4,"K-12 School >= 125,000-sf","System 2 FCU","4-Pipe fan coil units with CHW and HW","Constant Volume","Chilled water","Hot-water electric boiler",2.4000000000000001E-4,null,null,4,"K-12 School >= 125,000-sf","Large School >= 125,000-sf",5.7622070795902953,2.1668843612297208,0,3.3679244683631353,4.6990734120308506,1.4343260199086689,5.5584291322170634,9.7417880913645778,null,"W","Watt",{"$f":"Z5/1000","v":3.4120000000000001E-3},null,null,"All","therm","Alltherm",100,"therm",null,null,null,"kBtu","kcf","therm","therm","Btu","kBtu","kBtu","kBtu","kBtu","Tons","Tons","Tons","kBtu",null,"D",2775.5544000000009,3699.6239999999989,2933.0399999999991,{"$f":"IF(Proj_Info_Cond_SF>75000,BB8,BA8)","v":3699.6239999999989},0.9,0.95,0.74,{"$f":"IF(Proj_Info_Cond_SF>75000,BF8,BE8)","v":0.95},null,4,0,75000,"Residential Building: Residential","A",1.74,0.41,9.6000000000000002E-2,245,257,166,null,4,"K-12 School >= 125,000-sf",2.2000000000000002,12,{"$f":"BW8","v":2.2000000000000002},{"$f":"BX8","v":12},125000,10000000,"K-12",null,"K-12 Gymnasium","K-12","Post Office","Misc",null,null,null,null,null,"Town Hall",null,null,null,null,null,null,null,null,null,"Pumps",null,"Fuel Oil / Diesel","Multifamily Podium"]
[null,5,"K-12 School between 75,000 and 125,000-sf","System 2 FCU","4-Pipe fan coil units with CHW and HW","Constant Volume","Chilled water","Hot-water electric boiler",2.4000000000000001E-4,null,null,5,"K-12 School between 75,000 and 125,000-sf",null,5.5431737939230228,0.83098624301284163,0,3.8041571775159007,0,0,5.2783643306625132,15.58675257094302,null,"kBtu/hr","(British thermal unit per hour) x 1,000",1,null,null,"All","MMBtu","AllMMBtu",1000,"(British thermal unit) x 1,000,000",null,null,null,"MMBtu","Mcf","Ton-Hours","kWh","kBtu","MMBtu","MMBtu","MMBtu","MMBtu","Btu","Btu","Btu","MMBtu",null,"E",3623.570400000001,1016.4000000000003,1016.4000000000003,{"$f":"BB9","v":1016.4000000000003},0.9,0.25,0.25,{"$f":"BF9","v":0.25},null,5,0,75000,"Residential Building: Supporting Spaces","B",0.2,0.46,7.8E-2,1000,257,166,null,5,"K-12 School between 75,000 and 125,000-sf","2.7 - 0.000004 * Area (sf)","32 - 0.00016 * Area (sf)",{"$f":"2.7-0.000004*Proj_Info_Cond_SF","v":2.7},{"$f":"32-0.00016*(Proj_Info_Cond_SF-Proj_Info_Heated_Only_Cooling_TEDI)","v":{"$error":"#DIV/0!"}},75000,125000,"K-12",null,"K-12 Auditorium","K-12","Town Hall","Misc",null,null,null,null,null,"K-12 School",null,null,null,null,null,null,null,null,null,"Heat rejection",null,"Propane","Small Multifamily"]
[null,6,"K-12 School <= 75,000-sf","System 1 ASHP","Air source heat pump","Constant Volume","Direct expansion","Electric heat pump",2.4000000000000001E-4,null,null,6,"K-12 School <= 75,000-sf","Small School <= 75,000-sf",5.5431737939230228,0.83098624301284163,0,3.8041571775159007,0,0,5.2783643306625132,15.58675257094302,null,"MMBtu/hr","(British thermal unit per hour) x 1,000,000",1000,null,null,"All","MJ","AllMJ",0.94799999999999995,"(Joules) x 1,000,000",null,null,null,"Ton-Hours","Btu","kWh","MWh","MMBtu","therm","therm","therm","therm","kBtu","kBtu","kBtu","therm",null,"F",3215.3304000000007,3699.6239999999989,2658,{"$f":"IF(Proj_Info_Cond_SF>75000,BB10,BA10)","v":3699.6239999999989},0.76500000000000001,0.95,0.67,{"$f":"IF(Proj_Info_Cond_SF>75000,BF10,BE10)","v":0.95},null,6,0,75000,"Residential Building: Nonresidential","C",1.1499999999999999,0.66,0.11,200,257,166,null,6,"K-12 School <= 75,000-sf",2.4,20,{"$f":"BW10","v":2.4},{"$f":"BX10","v":20},0,75000,"K-12",null,"K-12 School","K-12","K-12 School","K-12",null,null,null,null,null,"Residential multifamily",null,null,null,null,null,null,null,null,null,"Fans - interior ventilation",null,"Fuel Oil (No. 5 & No.6)"]
[null,7,"Residential multifamily and dormitory >= 125,000-sf","System 3 WSHP","Water source heat pump","Constant Volume","Direct expansion","Electric heat pump, condenser water loop served by electric boiler",1.7000000000000001E-4,null,null,7,"Residential multifamily and dormitory >= 125,000-sf","Multifamily Tower",2.7542936385449424,2.5666915344757983,0,4.5482841596955499,0.15404312702811584,4.9023822420727406E-2,2.7943753626967096,11.277460026829257,null,"therm/hr","therm per hour",100,null,null,"Electricity","Ton-Hours","ElectricityTon-Hours",12,"Ton Hours",null,null,null,null,"kBtu","MWh",null,"kWh","kWh","kWh","kWh","kWh","MMBtu","MMBtu","MMBtu","kWh",null,"G",3215.3304000000007,3699.6239999999989,2658,{"$f":"IF(Proj_Info_Cond_SF>75000,BB11,BA11)","v":3699.6239999999989},0.76500000000000001,0.95,0.67,{"$f":"IF(Proj_Info_Cond_SF>75000,BF11,BE11)","v":0.95},null,7,75000,10000000,"K-12 Cafeteria","E",{"$f":"IF(Proj_Info_K12_Cafe_sf>9040,(140120+((Proj_Info_K12_Cafe_sf-9040)*2.33))/Proj_Info_K12_Cafe_sf,15.5)","v":15.5},{"$f":"IF(Proj_Info_K12_Cafe_sf>9040,(4700+((Proj_Info_K12_Cafe_sf-9040)*0.48))/Proj_Info_K12_Cafe_sf,0.52)","v":0.52},{"$f":"IF(Proj_Info_K12_Cafe_sf>9040,(10761+((Proj_Info_K12_Cafe_sf-9040)*0.45))/Proj_Info_K12_Cafe_sf,1.19)","v":1.19},{"$f":"IF(Proj_Info_K12_Cafe_sf>9040,(122075+((Proj_Info_K12_Cafe_sf-9040)*58.9))/Proj_Info_K12_Cafe_sf,13.5)","v":13.5},250,159.5,null,7,"Residential multifamily and dormitory >= 125,000-sf",2.8,22,{"$f":"BW11","v":2.8},{"$f":"BX11","v":22},125000,10000000,"Residential",null,"Office, Fire Station, Library, Police Station, Post Office, Town Hall, and Other","Misc","Residential multifamily","Residential",null,null,null,null,null,"Dormitory",null,null,null,null,null,null,null,null,null,"Service water heating",null,"Kerosene"]
[null,8,"Residential multifamily and dormitory between 75,000 and 125,000-sf","System 1 ASHP","Air source heat pump","Constant Volume","Direct expansion","Electric heat pump",1.2E-4,null,null,8,"Residential multifamily and dormitory between 75,000 and 125,000-sf","Multifamily Podium",2.1888674711172897,1.2037196676389179,0,2.0114772181717244,0,0,2.8249760778784418,11.540582520947085,null,"ton","ton",12,null,null,"District Cooling","Ton-Hours","District CoolingTon-Hours",12,"Ton Hours",null,null,null,null,"MMBtu",null,null,"MWh","MWh","MWh","MWh","MWh","therm","therm","therm","MWh",null,"H",2135.0920000000001,4493.9000000000005,4493.9000000000005,{"$f":"BB12","v":4493.9000000000005},0.6120000000000001,0.9,0.9,{"$f":"BF12","v":0.9},null,8,75000,10000000,"K-12 Gymnasium","F",0.46,0.85,0.5,143,250,159.5,null,8,"Residential multifamily and dormitory between 75,000 and 125,000-sf","3.8 - 0.000008 * Area (sf)","4.5 + 0.00014 * Area (sf)",{"$f":"3.8-0.000008*Proj_Info_Cond_SF","v":3.8},{"$f":"4.5*0.00014*(Proj_Info_Cond_SF-Proj_Info_Heated_Only_Cooling_TEDI)","v":{"$error":"#DIV/0!"}},75000,125000,"Residential",null,"Office, Fire Station, Library, Police Station, Post Office, Town Hall, and Other","Other","Dormitory","Residential",null,null,null,null,null,"All Other (Describe in notes)",null,null,null,null,null,null,null,null,null,"Misc equipment",null,"Coal (anthracite)"]
[null,9,"Residential multifamily and dormitory <= 75,000-sf","System 1 ASHP","Air source heat pump","Constant Volume","Direct expansion","Electric heat pump",1.2E-4,null,null,9,"Residential multifamily and dormitory <= 75,000-sf","Small Multifamily",2.5589353409341462,1.2897943204906626,0,2.2207987491613266,0,0,2.8224317621984034,11.270218256649525,null,null,null,null,null,null,"All","Btu","AllBtu",{"$f":"1/1000","v":1E-3},"British thermal unit",null,null,null,null,"kWh",null,null,null,null,null,null,null,"kWh","kWh","kWh",null,null,"I",2776.5648000000001,4711.74,4711.74,{"$f":"BB13","v":4711.74},0.6120000000000001,1,1,{"$f":"BF13","v":1},null,9,75000,10000000,"K-12 Auditorium","G",0.46,0.61,1.26,6.7,250,159.5,null,9,"Residential multifamily and dormitory <= 75,000-sf",3.2,15,{"$f":"BW13","v":3.2},{"$f":"BX13","v":15},0,75000,"Residential",null,null,null,"All Other (Describe in notes)","Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal (bituminous)"]
[null,10,"All other >= 125,000-sf","System 2 FCU","4-Pipe fan coil units with CHW and HW","Constant Volume","Chilled water","Hot-water electric boiler",2.4000000000000001E-4,null,null,10,"All other >= 125,000-sf",{"$f":"N5","v":"Large Office >= 125,000-sf"},{"$f":"O5","v":4.4514097999172018},{"$f":"P5","v":1.0371040404196183},0,2.6839329254040418,2.521396874885375,1.3531299828951746,3.2511860379734703,11.48951149981689,null,null,null,null,null,null,"Natural Gas","cf","Natural Gascf",1.0289999999999999,"cubic feet",null,null,null,null,"MWh",null,null,null,null,null,null,null,"MWh","MWh","MWh",null,null,"* Calculated based on R3 of supplement with no holidays per guidelines",null,null,null,null,null,null,null,null,null,10,75000,10000000,"K-12 School","D",0.89,0.63,0.38,66,250,159.5,null,10,"All other >= 125,000-sf",1.5,23,{"$f":"BW14","v":1.5},{"$f":"BX14","v":23},125000,10000000,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke"]
[null,11,"All other between 75,000 and 125,0000-sf","System 2 FCU","4-Pipe fan coil units with CHW and HW","Constant Volume","Chilled water","Hot-water electric boiler",2.4000000000000001E-4,null,null,11,"All other between 75,000 and 125,0000-sf",null,{"$f":"O6","v":5.2746305262576945},0.36335046456438047,0,3.6403757832858257,0,0,2.6258285937176042,10.110615956134501,null,null,null,null,null,null,"Natural Gas","ccf","Natural Gasccf",102.9,"(cubic feet) x 100",null,null,null,"W","W","W","W","W","W","W","W","W","W","W","W","W",null,null,null,null,null,null,null,null,null,null,null,11,0,75000,"K-12 Cafeteria","E",{"$f":"IF(Proj_Info_K12_Cafe_sf>5200,(61350+((Proj_Info_K12_Cafe_sf-5200)*4.16))/Proj_Info_K12_Cafe_sf,11.8)","v":11.8},{"$f":"IF(Proj_Info_K12_Cafe_sf>5200,(3016+((Proj_Info_K12_Cafe_sf-5200)*0.48))/Proj_Info_K12_Cafe_sf,0.58)","v":0.57999999999999996},{"$f":"IF(Proj_Info_K12_Cafe_sf>5200,(5667+((Proj_Info_K12_Cafe_sf-5200)*0.484))/Proj_Info_K12_Cafe_sf,1.09)","v":1.0900000000000001},{"$f":"IF(Proj_Info_K12_Cafe_sf>5200,(72273+((Proj_Info_K12_Cafe_sf-5200)*53.5))/Proj_Info_K12_Cafe_sf,13.9)","v":13.9},250,159.5,null,11,"All other between 75,000 and 125,0000-sf","4 - 0.00002 * Area (sf)","18 + 0.00004 * Area (sf)",{"$f":"4-0.00002*Proj_Info_Cond_SF","v":4},{"$f":"18+0.00004*(Proj_Info_Cond_SF-Proj_Info_Heated_Only_Cooling_TEDI)","v":{"$error":"#DIV/0!"}},75000,125000,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood"]
[null,12,"All other <= 75,000-sf","System 1 ASHP","Air source heat pump","Constant Volume","Direct expansion","Electric heat pump",2.4000000000000001E-4,null,null,12,"All other <= 75,000-sf",{"$f":"N7","v":"Small Office <= 75,000-sf"},{"$f":"O7","v":5.2746305262576945},0.36335046456438047,0,3.6403757832858257,0,0,2.6258285937176042,10.110615956134501,null,null,null,null,null,null,"Natural Gas","kcf","Natural Gaskcf",1029,"(cubic feet) x 1,000",null,null,null,"kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW",null,null,null,null,null,null,null,null,null,null,null,12,0,75000,"K-12 Gymnasium","F",0.46,0.85,0.5,143,250,159.5,null,12,"All other <= 75,000-sf",2.5,21,{"$f":"BW16","v":2.5},{"$f":"BX16","v":21},0,75000,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas","Mcf","Natural GasMcf",1029000,"(cubic feet) x 1,000,000",null,null,null,"MW","MW","MW","MW","MW","MW","MW","MW","MW","MW","MW","MW","MW",null,null,null,null,null,null,null,null,null,null,null,13,0,75000,"K-12 Auditorium","G",0.46,0.61,1.26,6.7,250,159.5]
[null,null,"Fan power in gym, cafeteria, auditorium is 0.00050 kW/CFM for heating/cooling equipment",null,null,null,null,null,null,null,null,null,"All Other = offices",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District Steam","Lbs.","District SteamLbs.",1.194,"Pounds (District Steam)",null,null,null,"Btu/hr","Btu/hr","Btu/hr","Btu/hr","Btu/hr","Btu/hr","Btu/hr","Btu/hr","Btu/hr","Btu/hr","Btu/hr","Btu/hr","Btu/hr",null,null,null,null,null,null,null,null,null,null,null,14,0,75000,"K-12 School","D",1.1399999999999999,0.63,0.41,60,250,159.5]
[null,null,null,null,null,null,null,null,null,null,null,null,"EUIs were calculated based on the \"FINAL\" EnergyPlus results for the sample models on the DOER website on January 29, 2024.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District Steam","kLbs.","District SteamkLbs.",1194,"(Pounds) x 1,000",null,null,null,"kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr","kBtu/hr",null,null,null,null,null,null,null,null,null,null,null,15,75000,10000000,"Office, Fire Station, Library, Police Station, Post Office, Town Hall, and Other","H",0.75,0.64,0.18,205,250,159.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District Steam","Mlbs.","District SteamMlbs.",1194000,"(Pounds) x 1,000,000",null,null,null,"MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr","MMBtu/hr",null,null,null,null,null,null,null,null,null,null,null,16,0,75000,"Office, Fire Station, Library, Police Station, Post Office, Town Hall, and Other","I",0.63,0.64,0.18,179,250,159.5]
[null,null,null,null,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 Oil / Diesel","Liters","Fuel Oil / DieselLiters",{"$f":"138.6905/3.846104","v":36.059997337565491},null,null,null,null,"ton","ton","ton","ton","ton","ton","ton","ton","ton","ton","ton","ton","ton"]
[null,null,null,null,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 Oil / Diesel","Gallons","Fuel Oil / DieselGallons",138.69049999999999,null,null,null,null,null,"therm/hr","therm/hr","therm/hr","therm/hr","therm/hr","therm/hr","therm/hr","therm/hr","therm/hr","therm/hr","therm/hr","therm/hr"]
[null,null,null,null,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 Oil (No. 5 & No.6)","Liters","Fuel Oil (No. 5 & No.6)Liters",{"$f":"149.69/3.846104","v":38.919904401961048}]
[null,null,null,null,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 Oil (No. 5 & No.6)","Gallons","Fuel Oil (No. 5 & No.6)Gallons",149.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Propane","Gallons","PropaneGallons",91.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Propane","Liters","PropaneLiters",{"$f":"91.65/3.846","v":23.829953198127924}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal (anthracite)","Lbs.","Coal (anthracite)Lbs.",12.545,"Pounds (Anthracite Coal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal (anthracite)","kLbs.","Coal (anthracite)kLbs.",12545,"(Pounds Anthracite Coal) x 1,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal (anthracite)","MLbs.","Coal (anthracite)MLbs.",12545000,"(Pounds Anthracite Coal) x 1,000,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal (anthracite)","Tons","Coal (anthracite)Tons",24800,"Tons (Anthracite Coal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal (bituminous)","Lbs.","Coal (bituminous)Lbs.",12.465,"Pounds (Bituminous Coal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal (bituminous)","kLbs.","Coal (bituminous)kLbs.",12465,"(Pounds Bituminous Coal) x 1,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal (bituminous)","MLbs","Coal (bituminous)MLbs",12465000,"(Pounds Bituminous Coal) x 1,000,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal (bituminous)","Tons","Coal (bituminous)Tons",24930,"Tons (Bituminous Coal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","Lbs.","CokeLbs.",12.4,"Pounds (coke)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","kLbs.","CokekLbs.",12400,"(Pounds coke) x 1,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","MLbs","CokeMLbs",12400000,"(Pounds coke) x 1,000,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","Tons","CokeTons",24800,"Tons (coke)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood","Lbs.","WoodLbs.",7.69,"Pounds (wood)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood","Tons","WoodTons",15380,"Tons (wood)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All","MMBtu","AllMMBtu",1000,"(British thermal unit) x 1,000,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kerosene","Gallons","KeroseneGallons",138.69049999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kerosene","Liters","KeroseneLiters",{"$f":"138.6905/3.846104","v":36.059997337565491}]

{"sheet":"Ref_Instructions","index":11,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["Tab Name","Button name","Find","Title","2023 TEDI","Blank","Blank","Height","Width","Height","Width","Left","Top",null,1,"Column"]
["Project Information","Button 1",{"$f":"A2&B2","v":"Project InformationButton 1"},"Project Information Help","Targeted Performance Simulation Guidelines, Section 3\n\nThe following simulation programs are pre-approved: eQUEST version 3.65 or higher using DOE2.3 engine, EnergyPlus version 9.3.0 or higher, IESVE version 2021.4.0.0 or higher.\n\neQuest version 3.65 or higher may be used with DOE2.2 engine for projects that do not include HVAC systems and designs that require workarounds in DOE2.2 but are explicitly supported in DOE2.3, such as variable refrigerant flow heat pumps and dedicated outdoor air systems.",null,null,330,368.25,249.75,342,{"$f":"I2-98","v":270.25},{"$f":"H2-65","v":265}]
["Project Information","Button 2",{"$f":"A3&B3","v":"Project InformationButton 2"},"Project Information Help","Targeted Performance Simulation Guidelines, Section 4a\n\nProjects shall use the MAStretch 2023 weather file included in the Schedules and Loads Guidelines Supplement Package unless permitted by the AHJ to use a local weather file.",null,null,330,368.25,249.75,342,{"$f":"I3-98","v":270.25},{"$f":"H3-65","v":265}]
["Project Information","Button 3","Project InformationButton 3","Project Information Help","The building area types are used to determine the applicable category from Table C407.1.1.5 in order to calculate the heating and cooling TEDI limits. The building area types selected will also affect the thermal block options in Table 2.\n\nIf selecting \"All Others\" please describe the building area type in the notes section below Table 1.",null,null,330,368.25,249.75,342,270.25,265]
["Project Information","Button 4","Project InformationButton 4","Project Information Help","Targeted Performance Simulation Guidelines, Section 5\n\nReport the enclosed heated and cooled floor area of the building area type. Report spaces that are both directly and indirectly conditioned. Do not report unenclosed spaces. ",null,null,330,368.25,249.75,342,270.25,265]
["Project Information","Button 5","Project InformationButton 5","Project Information Help","Targeted Performance Simulation Guidelines, Section 5\n\nReport the enclosed heated-only floor area of the building area type. Report spaces that are both directly and indirectly conditioned. Do not report unenclosed spaces.\n\nIf modeling as-designed HVAC systems per Sections 13.1 and 13.3 and heated only thermal zone floor area accounts for more than 10% of the modeled floor area then the heated only floor area shall be subtracted from the modeled floor area for the purposes of determining the Cooling TEDI.",null,null,330,368.25,249.75,342,270.25,265]
["Project Information","Button 6","Project InformationButton 6","Project Information Help","Targeted Performance Simulation Guidelines, Section 1\n\nAn unconditioned space is an enclosed space within a building that is not a conditioned space. ",null,null,330,368.25,249.75,342,270.25,265]
["Project Information","Button 7","Project InformationButton 7","Project Information Help","Targeted Performance Simulation Guidelines, Section 13.1\n\nThe heating, ventilation and air-conditioning systems, their components and controls shall be modeled as follows:\na. Buildings and areas within the building for which HVAC systems are not designed and are not shown on the construction documents shall be modeled with the default HVAC systems following Sections 13.2 and 13.4.\nb. Buildings and areas within the building for which HVAC systems are designed shall be modeled following either of the following options:\n1. With the specified systems following Sections 13.3 and 13.4\n2. With the default HVAC systems following Section 13.1(a).\nThe selected approach shall be followed for the entire project. ",null,null,330,368.25,249.75,342,{"$f":"I8-98","v":270.25},{"$f":"H8-65","v":265}]
["Project Information","Button 8","Project InformationButton 8","Project Information Help","Targeted Performance Simulation Guidelines, Section 11\n\nEach thermal block shall be modeled using the standardized assumptions prescribed in Table 1-6 in the Schedules and Loads Guidelines Supplement. The schedule indices shown in this table are described in the Schedules and Loads Guidelines Supplement and shall be used in the energy model.",null,null,330,368.25,249.75,342,{"$f":"I9-98","v":270.25},{"$f":"H9-65","v":265}]
["Instructions","Button 1","InstructionsButton 1","Instructions Help","Help text will display in a box like this.",null,null,330,368.25,249.75,342,270.25,265]
["Compliance Calculations","Button 1","Compliance CalculationsButton 1","Compliance Calculations Help","∑Space and Ventilation Heating Output (kBtu) = the annual heating output of all systems in the building that maintain space temperature setpoints and heat ventilation air including the heating coils of the central air systems (e.g., make-up air units and air handling units) and terminal  equipment (e.g., fan coils, heat pumps and unit heaters).",null,null,330,368.25,249.75,342,270.25,265]
["Compliance Calculations","Button 2",{"$f":"A12&B12","v":"Compliance CalculationsButton 2"},"Compliance Calculations Help","∑Space and Ventilation Cooling Output (kBtu) = the annual cooling output of all HVAC systems that maintain space temperature setpoints and cool ventilation air, including but not limited to the cooling coils of the central air systems (e.g., make-up air units, air handling units.) and terminal equipment (e.g., fan coils and heat pumps).",null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]
[null,null,"",null,null,null,null,330,368.25,249.75,342,270.25,265]