{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["ReadMe","PROJ-SUM","ENV-SUM","ENV-REQUIREMENTS","ENV-PRESCRIPTIVE","ENV-UA","TA1","Target Area Adjustments","ENV-SHGC","ENV-CHK"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":130,"comments":1,"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":"ReadMe","index":0,"n_rows":44,"n_cols":2,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,0,1,1],[5,0,6,0],[9,0,10,0],[13,0,19,0],[43,0,43,1],[27,0,27,1],[29,0,30,0],[31,0,32,0],[37,0,40,0],[41,0,42,0],[34,0,35,0]]}
["Instructions for Electronic Forms, pg 1"]
["2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "]
[null,"Revised Aug 2019"]
[null,"     Commercial Provision Chapters 1 - 6 of the 2015 Seattle Energy Code apply to all commercial occupancies, R-2, R-3 & R4 occupancies greater than 3 stories above grade, and R-1 occupancy (all building heights)."]
["Intro","     This file, ENVSEC15-v4.XLSM, has electronic compliance forms for general project information including Section C406, and envelope provisions as defined in Sections C101, C303, C402, C406, Chapter 5 (existing buildings) and Appendix A (default values) for Climate Zones 4c. "]
["Energy Code ","    This form is a compliance aid and is not a substitute for the full energy code text or specific jurisdiction compliance requirements. Users should refer to the code text and contact the Seattle SDCI for complete information. The full 2015 Seattle Energy Code text is available for download from the SDCI website:"]
[null,"http://www.seattle.gov/sdci/codes/codes-we-enforce-(a-z)/energy-code"]
["Training ","There are no explicit training materials for these forms. Refer to the NEEC website for instruction on how to complete all of the 2015 WSEC Compliance Forms which are very similar."]
["Start-up","Select this file from the Seattle SDCI website to download to your computer.  When opening the file be sure to Enable Macros and if applicable Enable Content. "]
["Overview ","     This file is an Excel workbook that contains multiple compliance forms and resources in Excel worksheets. Each worksheet is indicated by a tab at the bottom of the screen. You may visit each worksheet by selecting it's tab. If you cannot see these tabs, select \"Full Screen\" in Excel."]
[null,"     Most calculations are automated. Cells that display informational text and the results of calculations are write-protected and cannot be edited. "]
["Save Files ","This file is saved in the same manner as any standard Excel file.   "]
["Getting Around","     Some forms have two or more pages. Both pages are available on screen when you select the tab for a form (worksheet). Use the scroll bars to find the second page located below the first page."]
["Input Cells ","     All general project information and the date are entered once on PROJ-SUM. This information is automatically replicated on all other ENV forms. The PROJ-SUM form accompanies all other ENV forms."]
[null,"     Only input cells are accessible. If you try to edit a write-protected cell an error message will appear requesting a password.  A password IS NOT required to complete these forms. You may use the TAB key to move to the next input cell. If the TAB doesn't take you where you want to go, use your mouse to move around the form. "]
[null,"     Avoid excessively long text strings when entering information. In some cases, text that extends beyond the available space will not be visible. In most cases the text will wrap within the cell. This may force part of the form onto a new page."]
[null,"     To enter the date, use this format: mm/dd/yyyy.  For example, you would enter 7/1/2018 or 12/21/2018."]
[null,"     Check boxes can be checked or unchecked by clicking in the box with your mouse. Radio buttons (circles) allow only one in a set to be selected."]
[null,"     Drop-down lists have an arrow at the right side of the cell. Click on the arrow with your mouse and select the appropriate option. Use the delete button on your computer to clear a drop-down entry."]
[null,"     When a form has a space for notes or explanation, click anywhere in the space to edit. "]
["Personalizing","     You can personalize the forms with your company name, address, phone, or any other information. This is done by editing the header or footer in Excel."]
["Adding Lines and","     Many tables, such as for listing envelope assembly types, have a certain number of lines available for entering data. You may need more lines to enter all your information. Where this feature is available, you can add additional lines to the table by selecting the \"+\" button on the right hand side of the table with your mouse. If you can't see the \"+\" button, scroll to the right or increase the View Zoom setting for the worksheet.  "]
["Removing","     To remove lines that you have added, select the \"-\" button with your mouse. You cannot remove lines that were not added; an error message will appear if you try."]
[null,"     If you add additional lines with this method, the pagination may be affected forcing the forms to carry additional lines over to other pages.  Be sure to submit all pages to the plans examiner."]
["Target Insulation Allowance","    You must select an Target Insulation Allowance on ENV-SUM (line 18) to enable the forms."]
["Compliance Path","    You must select a Compliance Path on ENV-SUM (line 19) to activate the correct input method for Window-to-Wall and Skylight-to-Roof ratios."]
["Instructions for Electronic Forms, pg 2"]
[{"$f":"A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "}]
[null,{"$f":"B3","v":"Revised Aug 2019"}]
["Fenestration Area ","     For projects complying via the Prescriptive Path, enter the vertical fenestration area, net wall area (includes everything except vertical fenestration), skylight area and net roof area (includes everything except skylights) directly into the Vertical Fenestration and Skylight Area Calculation input cells on the ENV-SUM form. The form will calculate the Window-to-Wall and Skylight-to-Roof ratios.  "]
[null,"     For projects complying via the Component Performance Path, the Vertical Fenestration and Skylight Area inputs in the ENV-SUM form are write protected. Enter all applicable envelope information in the ENV-UA form. The resulting Window-to-Wall and Skylight-to-Roof ratios will auto fill into the ENV-SUM form from the ENV-UA form."]
["Vertical Fenestration Alternates ","     The prescriptive vertical fenestration target area is 30%. This target increases to 40% if the project complies with the requirements of C402.4.1.1 in buildings < 3 stories with 50% floor area in the daylight zone, C402.4.1.1 in buildings with ≥ 3 stories with 25% of net floor area in the daylight zone, C402.4.1.3 high performance vertical fenestration, or C402.4.1.4 dedicated outdoor air system (DOAS). "]
[null,"     If the project is eligible for one of these alternates, select the corresponding button on Line 38-43 of the ENV-SUM form. This will re-calculate the prescriptive target area in the ENV-SUM and ENV-UA forms based on 40%. "]
["Street Level Retail","    For projects utilizing the Street Level Retail (SLR) exception in Section C402.3.1, indicate the SLR on ENV-SUM.  Enter the gross wall area qualifying for the SLR exception.  Enter the fenestration area within the SLR wall.  The glazing allowance that must be transferred from other building areas to the SLR, if any, is automatically calculated.  Do NOT include SLR wall area or SLR fenestration area in the ENV-SUM Vertical Fenestration calculation or on ENV-UA.  The SLR wall and fenestration must meet prescriptive code requirements, and may not use the component performance option.   "]
["Component Performance Calculation Adjustments","     If the project is a Change of Occupancy (per C503.2) or Space Conditioning (per C505) and the project will comply via component performance, then select checkbox in Line 20 of ENV-SUM to adjust UA calculation to allow proposed UA to be 10% higher than the Code target UA. "]
[null,"      If the project will comply with the Enhanced Envelope additional efficiency package option per C406.8, then an ENV-UA form to demonstrate component performance compliance is required. Select checkbox in Line 20 of ENV-SUM to adjust component performance calculation to test whether the proposed UA is 15% lower than the Code target UA."]
["Target Area Adjustment","     Target Area Adjustment is required if the project exceeds the prescriptive target area for vertical fenestration or skylights. Adjusted target areas are automatically calculated in the ENV-UA form using envelope assembly areas you enter for your project. Adjusted target areas will appear in the Target UA column in the ENV-UA form. Refer to Target Area Adjustment worksheet for the supporting calculations."]
["Printing ","     The forms should print on any printer supported by your operating system. You will need to have the following TrueType fonts installed under Windows:  Arial, Times New Roman, Courier New and Wingdings.  These are all standard Windows fonts."]
[null,"     If you are losing form details when printing, you may have a shortage of printer memory. Try printing problem pages individually."]
[null,"     By default, only the active worksheet is printed. To print more than one worksheet at a time, open your print set-up menu and select either the page range you wish to print or Entire Workbook."]
[null,"     Forms (worksheets) in a workbook may not be deleted because the file is locked."]
["Blank Forms ","     DPD does not recommend completing these compliance forms by hand. Most worksheets run various calculations and compliance checks. To print blank forms to fill out by hand, delete all of the heading information at the beginning of ENV-SUM."]
[null,"     For each radio button group there is a button labeled \"Clear.\" Clicking this button will clear the other buttons so that they will print as empty circles.  The \"Clear\" button will not print."]
["End of Instructions for Electronic Forms"]

{"sheet":"PROJ-SUM","index":1,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[17,4,17,5],[16,4,16,5],[19,0,19,1],[13,0,14,1],[16,0,17,1],[29,1,29,2],[31,0,40,1],[42,0,42,1],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2]]}
["Project Summary",null,null,null,null,"PROJ-SUM"]
[{"$f":"ReadMe!A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Aug 2019"}]
["General Info","Project Title:",null,"1 - This title will copy onto other forms","Date","2019-01-01"]
[null,"Project Street Address:",null,null,"For SDCI Use"]
[null,"Project City, County, Zip:"]
[null,"Project Owner or Rep:"]
[null,"Jurisdiction:"]
[]
[]
["Project Description",null,null,null,null,null,null,null,4]
[]
["Occupancy Type",null,null,null,null,null,null,null,4]
[]
[]
[]
[]
["Floor Area and Stories",null,"Floors Above Grade","Building Gross Conditioned Floor Area","Project Gross Conditioned Floor Area"]
[]
[]
["General Compliance Path",null,null,null,null,null,null,null,"linked"]
[]
[]
[]
[]
[]
[]
[]
["Project Summary, pg 2",null,null,null,null,"PROJ-SUM"]
[{"$f":"A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"F2","v":"Revised Aug 2019"}]
["General Info","Project Title:",null,{"$f":"IF('PROJ-SUM'!$D$3=\"1 - This title will copy onto other forms\",\"1 - Fill this out on line 3 above \",'PROJ-SUM'!$D$3)","v":"1 - Fill this out on line 3 above "},"Date",{"$f":"F3","v":"2019-01-01"}]
[]
["C406 Additional Efficiency Package Options Summary",null,"  Building level efficiency options:",null,"Current Scope","Previous Projects"]
[null,null,"     C406.8 Enhanced envelope performance"]
[null,null,"     C406.9 Reduced air infiltration"]
[null,null,"     C406.5 On-site renewable energy"]
[null,null,"  Building area level efficiency options"]
[null,null,"     C406.2 More efficient HVAC equipment"]
[null,null,"     C406.6 Dedicated outside air systems (DOAS)"]
[null,null,"     C406.7 Reduced energy use in service water heating"]
[null,null,"     C406.3 Reduced lighting power"]
[null,null,"     C406.4 Enhanced digital lighting controls"]
[null,null,"C406 Comments:"]

{"sheet":"ENV-SUM","index":2,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":false,"merged":[[34,3,34,6],[7,2,7,4],[57,0,57,1],[59,2,59,3],[34,0,34,1],[35,0,35,1],[50,0,50,1],[35,3,35,6],[37,0,37,1],[39,2,39,6],[40,2,40,3],[43,0,44,1],[41,2,41,3],[36,0,36,3],[36,4,36,6],[2,2,2,4],[19,0,19,1],[26,0,26,1],[12,0,12,1],[13,0,13,1],[4,2,4,4],[5,2,5,4],[6,2,6,4],[8,2,8,4]]}
["Envelope Summary",null,null,null,null,null,"ENV-SUM"]
[{"$f":"ReadMe!A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Aug 2019"}]
["Project Info","Project Title:",{"$f":"IF('PROJ-SUM'!$D$3=\"1 - This title will copy onto other forms\",\"1 - Fill this line out on PROJ-SUM\",'PROJ-SUM'!$D$3)","v":"1 - Fill this line out on PROJ-SUM"},null,null,"Date",{"$f":"TEXT('PROJ-SUM'!$F$3,\"mm/dd/yyyy\")","v":"01/01/2019"}]
[null,null,null,null,null,"For SDCI Use"]
[null,"Company Name:"]
[null,"Company Address:"]
[null,"Applicant Name:"]
[null,"Applicant Phone:"]
[null,"Applicant Email:"]
[]
["Project Description"]
["Envelope Project Scope"]
["Envelope Description"]
["Air Barrier Testing"]
[]
["Compliance Documentation Scope and Method"]
["Scope of This Calculation "]
["Target Insulation Allowance"]
["Envelope Compliance Path"]
["Component Performance Calculation Adjustments"]
["Heating Energy Source"]
["Envelope Summary, pg. 2",null,null,null,null,null,"ENV-SUM"]
[{"$f":"A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,null,{"$f":"G2","v":"Revised Aug 2019"}]
["Project Title:",{"$f":"C3","v":"1 - Fill this line out on PROJ-SUM"},null,null,null,"Date",{"$f":"G3","v":"01/01/2019"}]
[]
["Additions"]
["Alterations - \nFenestration and Skylight"]
[]
[null,null,null,"Total Vertical Fenestration Area\n(rough opening)","NET Exterior Above Grade\nWall Area","Total Skylight Area (rough opening)","NET Exterior Roof Area"]
[null,null,"New"]
[null,null,"Existing"]
[null,null,"Total",{"$f":"IF(OR(ISNUMBER(D31),ISNUMBER(D30)),D30+D31,\"\")","v":""},{"$f":"IF(OR(ISNUMBER(E31),ISNUMBER(E30)),E30+E31,\"\")","v":""},{"$f":"IF(OR(ISNUMBER(F31),ISNUMBER(F30)),F30+F31,\"\")","v":""},{"$f":"IF(OR(ISNUMBER(G31),ISNUMBER(G30)),G30+G31,\"\")","v":""}]
[null,null,null,"Vertical Fenestration-to-Wall Ratio (WWR)",{"$f":"IF(SUM(D30:E31)>0,IF(SUM(E30:E31)>0,(SUM(D30:D31)+IF(AND(SLR=1,SLRtransfer>0),SLRtransfer,0))/SUM(D30:E31),\"Enter wall area\"),\"\")","v":""},"Skylight-to-Roof Ratio (SRR)",{"$f":"IF(SUM(F30:G31)>0,IF(SUM(G30:G31)>0,SUM(F30:F31)/SUM(F30:G31),\"Enter roof area\"),\"\")","v":""}]
["   ",null,"Area"]
["   Vertical Fenestration Area Compliance",null,"Vertical\nFenestration\nArea",{"$f":"IF(AND(ComponentPath<>3,ISNUMBER(E33)),\n     IF(SLRerror,\n             IF(SLRwindow>SLRwall,\"SLR window area must be less than gross SLR wall area\",\"Street level window area exceeds allowance of 75% of qualified gross wall plus transfered glazing area\"),\n             IF(EnvSumExmptSngl>EnvSumNetWall/100,\"DOES NOT COMPLY.  NO MORE THAN 1% OF GROSS WALL MAY BE EXEMPT GLASS\",\n  IF(E33=0,\"NO VERTICAL FENESTRATION PROPOSED. COMPLIES WITH MAXIMUM ALLOWANCE.\",\n   IF(E33<=0.3,\"VERTICAL FENESTRATION AREA COMPLIES WITH MAXIMUM ALLOWANCE\",\n     IF(E33<=0.4,\n        IF(OR(dlz25pct,dlz50pct,hpfwin,hpmwin),\"VERTICAL FENESTRATION AREA COMPLIES WITH MAXIMUM ALLOWED WITH FENESTRATION ALTERNATE\",\n        IF(ComponentPath=1,\"Project exceeds maximum vertical fenestration area allowed for Prescriptive compliance.  May comply prescriptively using a vertical fenestration alternate or via Component Performance with Target Area Adjustment.\",\n        IF(ComponentPath=2,\"Project exceeds maximum target vertical fenestration area. Target area adjustment applied to UA calculation. May comply prescriptively using a vertical fenestration alternate.\",\n         \"\"))),\n      IF(ComponentPath=1,\"Project exceeds maximum vertical fenestration area allowed for Prescriptive compliance.  Comply via Component Performance with Target Area Adjustment.\",\n     IF(ComponentPath=2,\"Project exceeds maximum target vertical fenestration area.  Target area adjustment applied to UA calculation.\",\n     \"\"))))))),\"\")","v":""}]
["   Skylight Area Compliance",null,"Skylight Area",{"$f":"IF(AND(CompliancePath<3,ISNUMBER(G33)),\n     IF(G33>0.05,\n          IF(CompliancePath=1,\n               \"Project exceeds maximum skylight area allowed for Prescriptive compliance.  Comply via Component Performance with Target Area Adjustment.\",\n               IF(CompliancetPath=2,\n                       \"Project exceeds target skylight area.  Target area adjustment applied to UA calculation.\",\n               \"\")),\nIF(G33>0,\"SKYLIGHT AREA COMPLIES WITH MAXIMUM ALLOWANCE\",\"NO SKYLIGHT PROPOSED. COMPILIES WITH MAXIMUM ALLOWANCE.\")),\"\")","v":""}]
["Maximum Prescriptive Vertical Fenestration (%)",null,null,null,{"$f":"IF(OR(CompliancePath<3,CalcType<5),IF(SLR>1,IF(VertFenAlt=1,\"40% per C402.3.1.3\",IF(VertFenAlt=2,\"40% per C402.3.1.1\",\"30% per C402.3.1\")),IF(VertFenAlt=1,\"40% per C402.3.1.3 adjusted for SLR transfer\",IF(VertFenAlt=2,\"40% per C402.3.1.1 adjusted for SLR transfer\",\"30% per C402.3.1 adjusted for SLR transfer\"))),\"\")","v":""}]
["Vertical Fenestration Alternates"]
[]
[null,null,"Daylight Zone Calculations"]
[null,null,{"$f":"IF(dlz50pct,\"Building Conditioned Floor Area\"&CHAR(10)&\"(building < 3 stories)\",IF(dlz25pct,\"Building Net Floor Area\"&CHAR(10)&\"(building ≥ 3 stories)\", \"Daylight Zone Fenestration Alternate Not Selected. No Calculations Required\"))","v":"Daylight Zone Fenestration Alternate Not Selected. No Calculations Required"},null,"Sidelight Daylight Zone Area","Toplight Daylight Zone Area","Percent Daylight Zone Area"]
[null,null,null,null,null,null,{"$f":"IF(C42>0,SUM(E42:F42)/C42,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(hpfwin,heatfuel<>2),\"High performance fenestration option is not available to projects with Electric Resistance or Fossil Fuel Heat\",IF(dlz50pct,IF(AND(C42>0,G42>0),IF(G42>=0.5,\"Qualifies for Daylight Zone Alternate\",\"Does Not Qualify for Daylight Zone Alternate\"),\"\"),IF(dlz25pct,IF(AND(C42>0,G42>0),IF(G42>=0.25,\"Qualifies for Daylight Zone Alternate\",\"Does Not Qualify for Daylight Zone Alternate\"),\"\"),\"\")))","v":""}]
["Street Level Retail",null,null,null,null,null,"n/a"]
[null,null,null,null,null,null,"n/a"]
[null,null,null,null,null,null,{"$f":"IF(SLR=1,MAX(0,SLRwindow-0.75*SLRwall),\"n/a\")","v":"n/a"},{"$f":"IF(SLR=1,IF(OR(SLRwindow>SLRwall,SLRwindow>0.75*SLRwall+SLRtransfer),TRUE,FALSE),FALSE)","v":false}]
["Envelope Summary, pg. 3",null,null,null,null,null,"ENV-SUM"]
[{"$f":"A27","v":"Alterations - \nFenestration and Skylight"},null,null,null,null,null,{"$f":"G27","v":"00:00:00"}]
["Project Title:",{"$f":"C3","v":"1 - Fill this line out on PROJ-SUM"},null,null,null,"Date",{"$f":"G3","v":"01/01/2019"}]
[]
["Spaces in Single Story Building Requiring Skylights"]
[null,null,"Space ","Area (ft2)","DLZ Area (ft2)","SRR or Aperture","Exception"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
["Envelope Exemptions"]
[]
[null,null,null,null,"Wall Insulation \nR-Value","Roof Insulation \nR-Value","Overall Average \nU-Factor"]
[null,null,"Equipment Building Envelope"]
[null,null,null,null,null,"Electronic equipment power (watts/sf)"]
[null,null,null,null,null,"Heating system output capacity (Btu/hr)"]
[null,null,null,null,null,"Cooling capacity (Yes/No)"]
[]
[]
[]
[]
[]
[]
["SLR Adjustment Message"]
[{"$f":"IF(AND(SLR=1,SLRtransfer>0),\"Includes Street Level Retail transfer\",\"\")","v":""}]

{"sheet":"ENV-REQUIREMENTS","index":3,"n_rows":99,"n_cols":6,"rows_kept":99,"cut":false,"hidden":false,"merged":[[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[15,2,15,3],[26,2,26,5],[27,2,27,3],[30,2,30,3],[31,4,31,5],[30,4,30,5],[29,2,29,5],[33,4,33,5],[34,4,34,5],[13,2,13,3],[29,0,29,1],[54,4,54,5],[48,4,48,5],[50,4,50,5],[51,4,51,5],[52,4,52,5],[53,4,53,5],[30,0,30,1],[18,0,18,1],[18,2,18,3],[19,0,19,1],[23,0,23,1],[24,2,24,3],[25,2,25,3],[26,0,26,1],[12,0,12,1],[4,2,4,3],[4,4,4,5],[6,0,6,1],[6,2,6,5],[7,0,7,1],[37,0,37,1],[39,0,39,1],[44,2,44,3],[45,2,45,3],[46,2,46,3],[43,0,43,5],[39,2,39,5],[41,0,41,1],[41,2,41,3],[41,4,41,5],[47,2,47,3],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[14,2,14,3],[57,0,57,1],[62,0,62,1],[98,0,98,5],[40,2,40,3],[40,4,40,5],[42,0,42,1],[42,2,42,3],[42,4,42,5],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[48,2,48,3],[49,0,49,5],[54,2,54,3]]}
["Envelope Requirements Summary, Part 1",null,null,null,null,"ENV-REQ"]
[{"$f":"ReadMe!A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Aug 2019"}]
["Minimum Requirements"]
["for Prescriptive Compliance"]
[null,"Prescriptive Path"," Table C402.1.3 Notes 1,7\nInsulation Minimum R-Value",null,"Table C402.1.4 Notes 1,2\nAssembly Maximum U-factor"]
[null,"Occupancy Group  ","All Other","Group R","All Other","Group R"]
["Opaque Elements"]
["Roofs"]
[null,"Insulation Entirely above Deck","R-38 c.i.","R-38 c.i.","U-0.027","U-0.027"]
[null,"Metal Building (with thermal spacer block) Note 3","R-25 + R-22 Ls","R-25 + R-22 Ls","U-0.027","U-0.027"]
[null,"Attic and Other","R-49","R-49","U-0.021","U-0.021"]
[null,"Joist or single rafter","R-49","R-49","U-0.027","U-0.027"]
["Walls, Above-grade"]
[null,"Mass","Exterior R-16 c.i. Note 6,or\nInterior R-13 + R6 c.i. wood stud, or\nInterior R-13+R-10 c.i. metal stud",null,"U-0.057","U-0.057"]
[null,"Mass transfer deck slab edge","No R-Value for prescriptive compliance",null,"U-0.200","U-0.200"]
[null,"Metal Building","R-19 c.i., or R-13 + R-13 c.i.",null,"U-0.052","U-0.052"]
[null,"Steel Framed","R-13 + R-10c.i.","R-19 + R-8.5 c.i.","U-0.055","U-0.055"]
[null,"Wood Framed and Other","R-13 + R-7.5 c.i.","R-21 w/ int. frame","U-0.051","U-0.054"]
["Below Grade Wall Note 4",null,"Exterior: R-10 c.i.\nInterior: R-19 wood stud, or\nR-13 +R-6 c.i. metal stud",null,"U-0.070","U-0.070"]
["Floors"]
[null,"Mass","R-30 c.i.","R-30 c.i.","U-0.029","U-0.029"]
[null,"Steel Joist","R-38 + R-4 c.i.","R-38 + R-4 c.i.","U-0.029","U-0.029"]
[null,"Wood Joist","R-38","R-38","U-0.025","U-0.025"]
["Slab-On-Grade Floors"]
[null,"Unheated","R-10 for 24 in. (from top of slab)",null,"F-0.54","F-0.54"]
[null,"Heated  Note 5","R-10 perimeter & under entire slab",null,"F-0.55","F-0.55"]
["Opaque Doors"]
[null,"Swinging","No R-Value for prescriptive compliance",null,"U-0.37","U-0.37"]
[null,"Nonswinging (Roll-up or sliding)","R-4.75","R-4.75","U-0.34","U-0.34"]
["Fenestration ",null,"Assembly Maximum U-factor Notes 1,2"]
[null,null,"Table C402.4 - 0-30% of wall area, or\n30%-40% per Section C402.4.1.1 DLZ  or Section C402.4.1.4 DOAS",null,"Section C402.3.1.4 High Performance Fenestration Option - 0-40% of wall area"]
[null,null,"Column A\nElectric Res. And Fossil Fuel","Column B\nOther Heating Fuel Note 8","Other Heating Fuel Only Note 8"]
["Vertical Fenestration"]
[null,"Nonmetal framing ","U-0.26","U-0.30","U-0.28"]
[null,"Metal framing (fixed)","U-0.31","U-0.38","U-0.34"]
[null,"Metal framing (operable)","U-0.38","U-0.40","U-0.36"]
[null,"Entrance doors","U-0.60","U-0.60","U-0.60"]
["Skylights"]
[null,"Skylights","U-0.50","U-0.50","U-0.50"]
["Fenestration",null,"Assembly Maximum SHGC Factor"]
["Vertical Fenestration",null,"PF<0.2: north - SHGC=0.53; \nall other SHGC=0.35\n0.2 ≤ PF < 0.5: north - SHGC-0.58; \nall other - SHGC-0.45\nPF ≥ 0.5: north - SHGC-0.64; \nall other - SHGC-0.60",null,"SHGC-0.35"]
["Skylights",null,"SHGC-0.32",null,"SHGC-0.35"]
["C410.2 Refrigerated Spaces Insulation",null,"Insulation Minimum R-Value ",null,"Assembly Maximum U-factor "]
["Freezers - Walk-in and Warehouse"]
[null,"Roof / Ceiling","R-32",null,"U-0.030"]
[null,"Wall","R-32",null,"U-0.030"]
[null,"Door","R-32",null,"U-0.030"]
[null,"Door - transparent reach-in","triple-pane, heat-reflective treated or gas fill"]
[null,"Floor","R-28",null,"U-0.035"]
["Coolers - Walk-in and Warehouse"]
[null,"Roof / Ceiling","R-25",null,"U-0.039"]
[null,"Wall","R-25",null,"U-0.039"]
[null,"Door","R-25",null,"U-0.039"]
[null,"Door - transparent reach-in","double-pane, heat-reflective treated & gas fill, or comply with freezer door req."]
[null,"Floor","No Requirement"]
["Envelope Requirements Summary, Part 2 ",null,null,null,null,"ENV-REQ"]
[{"$f":"A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"F2","v":"Revised Aug 2019"}]
["Definitions:"]
[]
[]
[]
[]
["Footnote Summary:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," Alternate continuous insulation nominal R-values"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End of Envelope Requirements Summary"]

{"sheet":"ENV-PRESCRIPTIVE","index":4,"n_rows":139,"n_cols":13,"rows_kept":139,"cut":false,"hidden":false,"merged":[[110,3,110,5],[110,6,110,7],[9,3,9,5],[9,6,9,7],[63,3,63,5],[63,6,63,7],[78,3,78,5],[78,6,78,7]]}
["Prescriptive Path, pg. 1",null,null,null,null,null,null,"ENV-PRESCRIPTIVE"]
[{"$f":"'ENV-SUM'!A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised Aug 2019"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Title:"},null,null,{"$f":"IF('PROJ-SUM'!$D$3=\"1 - This title will copy onto other forms\",\"1 - Fill this line out on PROJ-SUM\",'PROJ-SUM'!$D$3)","v":"1 - Fill this line out on PROJ-SUM"},null,null,"Date",{"$f":"TEXT('PROJ-SUM'!$F$3,\"mm/dd/yyyy\")","v":"01/01/2019"}]
["Target Insulation Allowance:",null,null,null,null,null,"For SDCI Use"]
[null,{"$f":"IF(CompliancePath<>2,\"Component Performance Not Selected\",IF(CalcType=1,\"Fully Conditioned Space - Commercial, Group R, Mixed Use\",IF(CalcType=2,\"Semi-heated Space\",IF(CalcType=3,\"Refrigerated Cooler - See note 11 on ENV-UA\",IF(CalcType=4,\"Refrigerated Freezer - See note 12 on ENV-UA\",\"\")))))","v":"Component Performance Not Selected"}]
["Fenestration Area as % gross above-grade wall area",null,null,{"$f":"IF('ENV-SUM'!E33>0,'ENV-SUM'!E33,0)","v":""},"Max. Target:",{"$f":"'Target Area Adjustments'!D17","v":0.3}]
["Skylight Area as % gross roof area",null,null,{"$f":"IF('ENV-SUM'!G33>0,'ENV-SUM'!G33,0)","v":""},"Max. Target:",{"$f":"'Target Area Adjustments'!D73","v":0.05}]
["Vertical Fenestration Alternates:",null,null,null,null,{"$f":"'TA1'!A28","v":"None Selected on ENV-SUM"},"User Note"]
[]
["Building Component ",null,null,"R-Value Method for Prescriptive Compliance",null,null,"U-Factor/F-Factor Method for Prescriptive Compliance"]
[null,null,"Provide plan/detail # of assembly and description","Cavity Ins.\nR-Value","Continuous Ins. (CI)\nR-Value1","% Area of Metal Penetrations \nin CI2","Assembly \nU-Factor","U-Factor Source3                                                       "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
["Prescriptive Path, pg. 2",null,null,null,null,null,null,"ENV-PRESCRIPTIVE"]
[{"$f":"A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,null,null,{"$f":"H2","v":"Revised Aug 2019"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Title:"},null,null,{"$f":"D3","v":"1 - Fill this line out on PROJ-SUM"},null,null,"Date",{"$f":"H3","v":"01/01/2019"}]
["Fenestration Area as % gross above-grade wall area",null,null,{"$f":"D6","v":""},"Max. Target:",{"$f":"F6","v":0.3},"For Building Department Use"]
["Skylight Area as % gross roof area",null,null,{"$f":"D7","v":""},"Max. Target:",{"$f":"F7","v":0.05}]
[]
["Building Component ",null,null,"R-Value Method for \nPrescriptive Compliance",null,null,"U-Factor/F-Factor Method for \nPrescriptive Compliance"]
[null,null,"Provide plan/detail # of assembly and description","Perim. Ins.\nR-Value","Full Slab CI\nR-Value",null,"F-Factor","F-Factor Source10"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"Provide ID from door schedule and description","Ins.\nR-Value",null,null,"Assembly\nU-Factor","U-Factor Source11"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Solar Heat Gain Coefficient (SHGC)",null,null,"U-Factor for Prescriptive Compliance"]
[null,null,"Provide ID from window schedule and description","Projection Factor (PF)\nif applicable12","Orientation (N or SEW)13","Assembly\nSHGC14","Assembly\nU-Factor","U-Factor Source14"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Miscellaneous - Refrigerated Spaces"]
[null,null,"Provide plan/detail # of assembly and description","Ins.\nR-Value",null,null,"Assembly\nU-Factor","U-Factor Source"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Provide ID from window schedule and description","Cooler / Freezer","Double Pane Glass","Triple Pane \nGlass","Inert Gas Filled","Heat Reflective \nTreated Glass"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cooler"]
["Freezer"]
["Yes"]
["No"]
[null,null,"square inches per square foot"]
["≤ 0.04%",null,{"$f":"144*0.04*0.01","v":5.7599999999999998E-2}]
["0.04% - 0.079%",null,{"$f":"144*0.08*0.01","v":0.1152}]
["0.08% - 0.119%",null,{"$f":"144*0.12*0.01","v":0.17280000000000001}]
[]
["N"]
["SEW"]

{"sheet":"ENV-UA","index":5,"n_rows":123,"n_cols":13,"rows_kept":123,"cut":false,"hidden":false,"merged":[[81,2,81,4],[76,2,76,4],[77,2,77,4],[78,2,78,4],[80,2,80,4],[79,2,79,4],[92,2,92,4],[82,2,82,4],[83,2,83,4],[84,2,84,4],[85,2,85,4],[86,2,86,4],[87,2,87,4],[88,2,88,4],[89,2,89,4],[90,2,90,4],[91,2,91,4],[99,2,99,4],[100,2,100,4],[101,2,101,4],[93,2,93,4],[94,2,94,4],[95,2,95,4],[96,2,96,4],[97,2,97,4],[98,2,98,4],[119,10,119,11],[120,10,120,11],[121,10,121,11],[122,10,122,11],[10,9,11,9],[10,10,11,11],[116,10,116,11],[117,10,117,11],[118,10,118,11]]}
["Component Performance Path, pg. 1",null,null,null,null,null,null,null,null,null,null,"ENV-UA"]
[{"$f":"'ENV-SUM'!A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised Aug 2019"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Title:"},null,null,null,null,{"$f":"IF('PROJ-SUM'!$D$3=\"1 - This title will copy onto other forms\",\"1 - Fill this line out on PROJ-SUM\",'PROJ-SUM'!$D$3)","v":"1 - Fill this line out on PROJ-SUM"},null,null,null,"Date",{"$f":"TEXT('PROJ-SUM'!$F$3,\"mm/dd/yyyy\")","v":"01/01/2019"}]
["Target Insulation Allowance:",null,null,null,null,null,null,null,null,"For SDCI Use"]
[null,null,null,{"$f":"IF(CompliancePath<>2,\"Component Performance Not Selected\",IF(CalcType=1,\"Fully Conditioned Space - Commercial, Group R, Mixed Use\",IF(CalcType=2,\"Semi-heated Space\",IF(CalcType=3,\"Refrigerated Cooler - See note 11 on ENV-UA\",IF(CalcType=4,\"Refrigerated Freezer - See note 12 on ENV-UA\",\"\")))))","v":"Component Performance Not Selected"}]
["Calculation Adjustments"]
[null,null,null,{"$f":"IF(ChangeofUseOrConditioning,IF(C406.8_Enhanced_Envelope,\"Proposed UA shall be at least 5% lower than Target UA\",\"Proposed UA is allowed to be 10% higher than Target UA\"),IF(C406.8_Enhanced_Envelope,IF(SecC411_Exception3,\"Proposed UA shall be at least 30% lower than Target UA\",\"Proposed UA shall be at least 15% lower than Target UA\"),IF(SecC411_Exception3,\"Proposed UA shall be at least 15% lower than Target UA\",\"None Applied\")))","v":"None Applied"}]
["Fenestration Area as % gross above-grade wall area",null,null,null,null,null,{"$f":"IF('ENV-SUM'!E33>0,'ENV-SUM'!E33,0)","v":""},"Max. Target:",{"$f":"'Target Area Adjustments'!D17","v":0.3}]
["Skylight Area as % gross roof area",null,null,null,null,null,{"$f":"IF('ENV-SUM'!G33>0,'ENV-SUM'!G33,0)","v":""},"Max. Target:",{"$f":"'Target Area Adjustments'!D73","v":0.05}]
["Vertical Fenestration Alternates:",null,null,null,null,null,null,null,{"$f":"'TA1'!A28","v":"None Selected on ENV-SUM"}]
[null,null,null,null,null,"Vertical Fenestration",null,"Net Wall ",null,"User Note"]
[null,null,null,null,null,"Skylights",null,"Net Roof "]
["Envelope Component ",null,null,null,null,null,null,"Proposed UA",null,"Target UA"]
[null,null,null,"Cavity+CI ","Plan/Detail #","U-factor Source & Table # 2","U-factor","x Area (A)","= UA (U x A)","U-factor","x Area (A) =","UA (U x A)"]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G15=0,H15=0),0,IF(OR(G15=0,H15=0),NA(), H15*G15))","v":0},{"$f":"'TA1'!F131","v":2.7E-2},{"$f":"'Target Area Adjustments'!J90","v":0},{"$f":"IF(TYPE(J15*K15)<>1,0,J15*K15)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Above Deck Insulation",null,{"$f":"'TA1'!F164","v":"U-0.027"}]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G17=0,H17=0),0,IF(OR(G17=0,H17=0),NA(), H17*G17))","v":0},null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F132","v":2.7E-2},{"$f":"'Target Area Adjustments'!J91","v":0},{"$f":"IF(TYPE(J18*K18)<>1,0,J18*K18)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Metal Building",null,{"$f":"'TA1'!F165","v":"U-0.027"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G21=0,H21=0),0,IF(OR(G21=0,H21=0),NA(), H21*G21))","v":0},{"$f":"'TA1'!F134","v":2.7E-2},{"$f":"'Target Area Adjustments'!J92","v":0},{"$f":"IF(TYPE(J21*K21)<>1,0,J21*K21)","v":0}]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G22=0,H22=0),0,IF(OR(G22=0,H22=0),NA(), H22*G22))","v":0},"Joist/single rafter",null,{"$f":"'TA1'!F167","v":"U-0.027"}]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G23=0,H23=0),0,IF(OR(G23=0,H23=0),NA(), H23*G23))","v":0},null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F133","v":2.1000000000000001E-2},{"$f":"'Target Area Adjustments'!J93","v":0},{"$f":"IF(TYPE(J24*K24)<>1,0,J24*K24)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Single raft, attic, other",null,{"$f":"'TA1'!F166","v":"U-0.021"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G27=0,H27=0),0,IF(OR(G27=0,H27=0),NA(), H27*G27))","v":0},{"$f":"'TA1'!F137","v":5.5E-2},{"$f":"'Target Area Adjustments'!J43","v":0},{"$f":"IF(TYPE(J27*K27)<>1,0,J27*K27)","v":0}]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G28=0,H28=0),0,IF(OR(G28=0,H28=0),NA(), H28*G28))","v":0},"Steel/metal frame",null,{"$f":"'TA1'!F170","v":"U-0.055"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F136","v":5.1999999999999998E-2},{"$f":"'Target Area Adjustments'!J44","v":0},{"$f":"IF(TYPE(J30*K30)<>1,0,J30*K30)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Metal Building",null,{"$f":"'TA1'!F169","v":"U-0.052"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F138","v":5.0999999999999997E-2},{"$f":"'Target Area Adjustments'!J45","v":0},{"$f":"IF(TYPE(J33*K33)<>1,0,J33*K33)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Wood Frame, other",null,{"$f":"'TA1'!F171","v":"U-0.051"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G36=0,H36=0),0,IF(OR(G36=0,H36=0),NA(), H36*G36))","v":0},{"$f":"'TA1'!F135","v":5.7000000000000002E-2},{"$f":"'Target Area Adjustments'!J46","v":0},{"$f":"IF(TYPE(J36*K36)<>1,0,J36*K36)","v":0}]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G37=0,H37=0),0,IF(OR(G37=0,H37=0),NA(), H37*G37))","v":0},"Mass Wall",null,{"$f":"'TA1'!F168","v":"U-0.057"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G39=0,H39=0),0,IF(OR(G39=0,H39=0),NA(), H39*G39))","v":0},{"$f":"'TA1'!F139","v":0.2},{"$f":"'Target Area Adjustments'!J47","v":0},{"$f":"IF(TYPE(J39*K39)<>1,0,J39*K39)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Mass Transfer Deck",null,{"$f":"'TA1'!F172","v":"U-0.20"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!G138","v":5.3999999999999999E-2},{"$f":"'Target Area Adjustments'!J48","v":0},{"$f":"IF(TYPE(J42*K42)<>1,0,J42*K42)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Group R Wood/Oth. Wall",null,{"$f":"'TA1'!G171","v":"U-0.054"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F147","v":7.0000000000000007E-2},{"$f":"SUM(H45:H48)","v":0},{"$f":"IF(TYPE(J45*K45)<>1,0,J45*K45)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Assumed to be Mass Wall",null,{"$f":"'TA1'!F180","v":"U-0.07"}]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G47=0,H47=0),0,IF(OR(G47=0,H47=0),NA(), H47*G47))","v":0}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F141","v":2.9000000000000001E-2},{"$f":"SUM(H49:H51)","v":0},{"$f":"IF(TYPE(J49*K49)<>1,0,J49*K49)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Mass Floor",null,{"$f":"'TA1'!F174","v":"U-0.029"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G52=0,H52=0),0,IF(OR(G52=0,H52=0),NA(), H52*G52))","v":0},{"$f":"'TA1'!F143","v":2.9000000000000001E-2},{"$f":"SUM(H52:H54)","v":0},{"$f":"IF(TYPE(J52*K52)<>1,0,J52*K52)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Joist/Framing",null,{"$f":"'TA1'!F172","v":"U-0.20"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F144","v":2.5000000000000001E-2},{"$f":"SUM(H55:H57)","v":0},{"$f":"IF(TYPE(J55*K55)<>1,0,J55*K55)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Joist/Framing",null,{"$f":"'TA1'!F175","v":"U-0.029"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[]
[null,null,null,null,null,null,null,"Area1","UA",null,"Area1","UA"]
[null,null,null,{"$f":"IF(H60<>K60,\"Target Area Adjusted\",\"\")","v":""},null,null,"Page 1 Subtotal ",{"$f":"SUM(H15:H57)","v":0},{"$f":"SUM(I15:I57)","v":0},null,{"$f":"SUM(K15:K57)","v":0},{"$f":"SUM(L15:L57)","v":0}]
[]
["Component Performance Compliance (UA)",null,null,null,null,null,null,null,null,null,null,{"$f":"L114","v":""}]
["Component Performance Path, pg. 2",null,null,null,null,null,null,null,null,null,null,"ENV-UA"]
[{"$f":"A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,null,null,null,null,null,null,{"$f":"L2","v":"Revised Aug 2019"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Title:"},null,null,null,null,{"$f":"F3","v":"1 - Fill this line out on PROJ-SUM"},null,null,null,"Date",{"$f":"K3","v":"01/01/2019"}]
["Fenestration Area as % gross above-grade wall area",null,null,null,null,null,{"$f":"G8","v":""},"Max. Target:",{"$f":"I8","v":0.3},"For Building Department Use"]
["Skylight Area as % gross roof area",null,null,null,null,null,{"$f":"G9","v":""},"Max. Target:",{"$f":"I9","v":0.05}]
[]
["Building Component ",null,null,null,null,null,null,"Proposed UA",null,"Target UA"]
[null,null,null,"Ins. R","Plan/Detail # ","F-factor Source & Table # 8","F-factor","x Perimeter","= FP(F x P)","F-factor","x Perimeter =","FP (F x P)"]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G71=0,H71=0),0,IF(OR(G71=0,H71=0),NA(), H71*G71))","v":0},{"$f":"'TA1'!F145","v":0.54},{"$f":"SUM(H71:H73)","v":0},{"$f":"IF(TYPE(J71*K71)<>1,0,J71*K71)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Slab-On-Grade",null,{"$f":"'TA1'!F178","v":"F-0.54"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F146","v":0.55000000000000004},{"$f":"SUM(H74:H76)","v":0},{"$f":"IF(TYPE(J74*K74)<>1,0,J74*K74)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Heated Slab-On-Grade",null,{"$f":"'TA1'!F179","v":"F-0.55"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"Schedule ID ",null,null,"U-factor Source9,10","U-factor","x Area (A)","= UA (U x A)","U-factor","x Area (A) =","UA (U x A)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(G78=0,H78=0),0,IF(OR(G78=0,H78=0),NA(), H78*G78))","v":0},{"$f":"'TA1'!F129","v":0.37},{"$f":"SUM(H78:H80)","v":0},{"$f":"IF(TYPE(J78*K78)<>1,0,J78*K78)","v":0}]
[null,null,null,null,null,null,null,null,0,"Opaque Swing Doors",null,{"$f":"'TA1'!F162","v":"U-0.37"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(G80=0,H80=0),0,IF(OR(G80=0,H80=0),NA(), H80*G80))","v":0},null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F130","v":0.34},{"$f":"SUM(H81:H83)","v":0},{"$f":"IF(TYPE(J81*K81)<>1,0,J81*K81)","v":0}]
[null,null,null,null,null,null,null,null,0,"Opaque rollup & sliding",null,{"$f":"'TA1'!F163","v":"U-0.34"}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F124","v":"set fuel"},{"$f":"'Target Area Adjustments'!J38","v":0},{"$f":"IF(TYPE(J84*K84)<>1,0,J84*K84)","v":0}]
[null,null,null,null,null,null,null,null,0,"Non-Metal Frame",null,{"$f":"'TA1'!F157","v":"set fuel"}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F125","v":"set fuel"},{"$f":"'Target Area Adjustments'!J39","v":0},{"$f":"IF(TYPE(J87*K87)<>1,0,J87*K87)","v":0}]
[null,null,null,null,null,null,null,null,0,"Metal Frame, Fixed",null,{"$f":"'TA1'!F158","v":"set fuel"}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F126","v":"set fuel"},{"$f":"'Target Area Adjustments'!J40","v":0},{"$f":"IF(TYPE(J91*K91)<>1,0,J91*K91)","v":0}]
[null,null,null,null,null,null,null,null,0,"Metal Frame, Operable",null,{"$f":"'TA1'!F159","v":"set fuel"}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F127","v":"set fuel"},{"$f":"'Target Area Adjustments'!J41","v":0},{"$f":"IF(TYPE(J95*K95)<>1,0,J95*K95)","v":0}]
[null,null,null,null,null,null,null,null,0,"Metal Frame, Entrance Dr.",null,{"$f":"'TA1'!F160","v":"set fuel"}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F128","v":0.45},{"$f":"'Target Area Adjustments'!J88","v":0},{"$f":"IF(TYPE(J99*K99)<>1,0,J99*K99)","v":0}]
[null,null,null,null,null,null,null,null,0,"All types",null,{"$f":"'TA1'!F161","v":"U-0.45"}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[]
["Refrigerated Space Freezer Floors",null,null,null,null,null,null,"Proposed UA",null,"Target UA"]
[null,null,null,"CI ","Plan/Detail #","U-factor Source & Table # 2","U-factor","x Area (A)","= UA (U x A)","U-factor","x Area (A) =","UA (U x A)"]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G106=0,H106=0),0,IF(OR(G106=0,H106=0),NA(),H106*G106))","v":0},{"$f":"IF(CalcType<>4,\"\",'TA1'!F144)","v":""},{"$f":"SUM(H106:H108)","v":0},{"$f":"IF(J106=\"NR\",\"NR\",IF(TYPE(J106*K106)<>1,0,J106*K106))","v":0}]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G107=0,H107=0),0,IF(OR(G107=0,H107=0),NA(),H107*G107))","v":0},"Freezer Floor",null,{"$f":"IF(CalcType<>4,\"\",'TA1'!F177)","v":""}]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G108=0,H108=0),0,IF(OR(G108=0,H108=0),NA(),H108*G108))","v":0},null,null,null,0]
[null,null,null,null,null,null,null,"Area1","UA",null,"Area1","UA"]
[null,null,null,{"$f":"IF(H110<>K110,\"Target Area Adjusted\",\"\")","v":""},null,null,"Page 2 Subtotal ",{"$f":"SUM(H71:H108)","v":0},{"$f":"SUM(I71:I108)","v":0},null,{"$f":"K106+K99+K95+K91+K87+K84+K81+K78+K74+K71","v":0},{"$f":"L106+L99+L95+L91+L87+L84+L81+L78+L74+L71","v":0}]
[null,null,null,null,null,null,"Page 1 Subtotal ",{"$f":"H60","v":0},{"$f":"I60","v":0},null,{"$f":"K60","v":0},{"$f":"L60","v":0}]
[null,null,null,null,null,null," Project Total",{"$f":"H111+H110","v":0},{"$f":"I111+I110","v":0},null,{"$f":"K111+K110","v":0},{"$f":"L111+L110","v":0}]
[]
["Component Performance Compliance (UA)",null,null,null,null,null,null,null,null,null,null,{"$f":" IF(H112>0,IF(CompliancePath<>2,\"Component Performance Not Selected\",IF(CalcType=5,\"Target Insulation Allowance not selected\",\n     IF(OR(L112=0,I112=0),\"\",\n         IF(C406.8_Enhanced_Envelope,\n            IF(SecC411_Exception3,\n               IF(I112<L112*0.7+0.00001,\"UA COMPLIES\",\n               \"UA DOES NOT COMPLY WITH C406.8 AND C411\"),\n               IF(I112<L112*0.85+0.00001,\"UA COMPLIES\",\n                  IF(ChangeofUseOrConditioning,\n                       IF(I112<L112*0.95+0.00001,\"UA COMPLIES\",\n                        \"UA DOES NOT COMPLY WITH C406.8\"),\n                   \"UA DOES NOT COMPLY WITH C406.8\"))),\n         IF(SecC411_Exception3,\n            IF(I112<L112*0.85+0.00001,\"UA COMPLIES\",\n            \"UA DOES NOT COMPLY WITH C411, EXCEPTION 3\"),\n            IF(I112<L112+0.00001,\"UA COMPLIES\",\n              IF(ChangeofUseOrConditioning,\n                    IF(I112>L112*1.10001,\"UA DOES NOT COMPLY\",\n                   \"UA COMPLIES W/ EXISTING SPACE EXEMPTION\"),\n            \"UA DOES NOT COMPLY\")\n)))))),\"\")","v":""}]
[]
["Refrigerated Space Windows In Doors 11, 12"]
[null,null,null,null,"Plan/Detail #","Description","Cooler / Freezer","Double Pane Glass","Triple Pane Glass","Inert Gas Filled","Heat Reflective \nTreated Glass"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"TA1","index":6,"n_rows":183,"n_cols":47,"rows_kept":183,"cut":false,"hidden":true,"merged":[]}
["HARD CODED -- NOT SET on ENV-SUM or ENV-PROJ"]
[{"$f":"IF(OR(CalcType=3,CalcType=4),2,1)","v":1},"Calculation Group: 1=Building, 2=Refrigeration"]
[4,"Climate Zone: 1= Zone 4c/5, 2=Zone 6, 3=Cleared, 4= Seattle "]
[]
["Transfer Variables - DO NOT CHANGE CELL ADDRESS - hard coded in VB "]
[{"$f":"'Target Area Adjustments'!F12","v":0},"Window Area"]
[{"$f":"'Target Area Adjustments'!L12","v":0},"Net AG Wall Area"]
[{"$f":"'Target Area Adjustments'!F69","v":0},"Skylight Area"]
[{"$f":"'Target Area Adjustments'!H69","v":0},"Net Ceiling Area"]
[{"$f":"'Target Area Adjustments'!F13","v":0},"Existing Window Area"]
[{"$f":"'Target Area Adjustments'!L13","v":0},"Existing Net AG Wall Area"]
[{"$f":"'Target Area Adjustments'!F70","v":0},"Existing Skylight Area"]
[{"$f":"'Target Area Adjustments'!H70","v":0},"Existing Net Ceiling Area"]
[]
["Flags from Env-Sum Options"]
[false,"New building ","NOT USED"]
[false,"Addition","NOT USED"]
[false,"Alteration","NOT USED"]
[false,"Window WWR unchanged"]
[false,"Skylight SRR unchanged"]
[]
[4,"Occupancy Group: 2017 LEAVE SET TO ONE, WAS: 1=Non Res, 2= Res, 3=Mixed Use , 4=none specified "]
[3,"Compliance Path: 1= Prescriptive, 2=component performance, 3= not specified",null,null,null,null,null,null,null,null,null,null,"ERROR MESSAGES - NOT USED BUT WOULD BE GOOD WAY TO STRUCTURE ERROR MESSAGES SO NEEC CAN MODIFY AS NEEDED"]
[5,"Calculation Type: 1- normal, 2-semi-heat, 3-refrigerated cooler, 4-refrigerated freezer, 5-clear",null,null,null,null,null,null,null,null,null,null,"page","cell","label","message"]
[3,"Vertical Fenestration Alternates: 1= 50% DLZ, 2= 25% DLZ, 4= high performance window, 3=none, 5=high performance mechanical",null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21","msgpre31noopts","Project exceeds maximum vertical fenestration area for Prescriptive compliance. Comply via 50% DLZ Option (C402.3.1.1) or High Performance Window Option (C402.3.1.3) or Component Performance with Target Area Adjustment. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21","msgpre41opts","Project exceeds maximum vertical fenestration area for Prescriptive compliance. Comply via Component Performance with Target Area Adjustment. "]
["Derived Flags to provide name variables to clarify calculations",null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[{"$f":"IF(VertFenAlt=1,\"  50% Conditioned Floor Area in Daylight Zone\",IF(VertFenAlt=2,\"25% of Net Floor Area in Daylight Zone\",IF(VertFenAlt=4,\"High Performance Vertical Fenestration\",IF(VertFenAlt=5,\"Dedicated Outdoor Air System\",\"None Selected on ENV-SUM\"))))","v":"None Selected on ENV-SUM"},"Vertical Fenestration Alternates text",null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[{"$f":"(VertFenAlt=1)","v":false},">=50% of conditioned floor area in DLZ & building ≤ 2 stories: 1=yes, 2 no ",null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[{"$f":"(VertFenAlt=2)","v":false},">=25% of net floor area in DLZ & building ≥ 3 stories: 1=yes, 2 no ",null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[{"$f":"(VertFenAlt=4)","v":false},"high performance glazing path (2-no, 1- yes) ",null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[{"$f":"(VertFenAlt=5)","v":false},"high performance mechanical path (2-no, 1- yes) ",null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[{"$f":"IF(OR(VertFenAlt=3,AND(VertFenAlt=4,heatfuel<>2)),0.3,0.4)","v":0.3},"Maximum prescriptive / comp WWR NOT USED AFAIK",null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21","msgcomply","COMPLIES"]
[false,"Change of Use / Conditioning"]
[false,"C406.8 Enhanced Envelope",null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21","msgua31noopts","Project exceeds maximum target vertical fenestration area. Target area adjustment applied to UA calculation.  May comply via 50% DLZ Option (C402.3.1.1) or High Performance Window Option (C402.3.1.3)."]
[{"$f":"CalcType=2","v":false},"Semi-ht Calculation"]
[{"$f":"IF(AND(OR(Alteration),WWR_unchanged),TRUE,FALSE)","v":false},"Project is alteration and Window WWR unchanged"]
[{"$f":"IF(AND(OR(Alteration),SRR_unchanged),TRUE,FALSE)","v":false},"Project is alteration and Skylight SRR unchanged"]
[]
[]
["Flags - Seattle Specific"]
[3,"Heating type (1 - Electric, 2 - Other)"]
[2,"Street level retail: 1=yes, 2 - no but paired submitted, 3 - no"]
[false,"C411 OnSite renewable exception 3",null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21","msgua41dlz","Project exceeds maximum target vertical fenestration area. Target area adjustment applied to UA calculation."]
["HEADER Row - NOT USED 2015",null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21","msgua41hpf","Project exceeds maximum target vertical fenestration area. Target area adjustment applied to UA calculation."]
["Occupancy",null,"NOT USED 2015"]
["Climate zone",{"$f":"IF(A22=3,\" \",IF(A3=1,\"Zones 4c/5b\",IF(A3=2,\"Zone 6b\",IF(A3=4,\"Seattle\",\"\"))))","v":"Seattle"},"NOT USED 2015"]
["Header",{"$f":"IF(AND(B46<>\"\",B47<>\"\"),CONCATENATE(B47,\" \",B46),\"\")","v":""},"NOT USED 2015"]
[3,"Prescriptive PF Factor - not used in 2015"]
[3,"North Face Credit Flag - not used in 2015"]
[]
["Form Management - NOT USED 2015"]
[{"$f":"OR(OccGroup=2,OccGroup=3)","v":false},"Group R"]
[{"$f":"OR(OccGroup=1,OccGroup=3)","v":false},"Comm"]
[{"$f":"OR(OccGroup=5)","v":false},"Refrigeration"]
[]
[]
[]
["U-factor, F-factor, Max WWR Look Ups"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FEEDER LOOK UP to set window and skylight values for standard compliance or high performance fenestration compliance"]
[null,null,"This look up was set up to look up percent glass.  With WSEC 2012 it was co-opted to look up glazing based upon selection of the high performance path glazing.  % win could be still be used by assign glazing case differently"]
[]
[]
[null,null,null,null,null,null,null,"Glazing Case (for SEC 2015: 1= HPF Win, 2=base, 3=2018 Electric heat values - in the past this was based by different levels of WWR.)"]
[null,null,null,null,null,null,null,{"$f":"IF(heatfuel=1,3,IF(VertFenAlt=4,1,2))","v":2}]
[]
[]
[null,null,null,null,null,"For each window type value entered for every glazing case"]
[null,null,null,null,null,"BLOCK FOR RAW U-VALUE DATA for Codes that vary values by glazing area.  Referenced by lookup functions in U-value By Jurisdiction Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLOCK FOR RAW SHGC DATA for Codes that vary values by glazing area.  Referenced by lookup functions in U-value By Jurisdiction Table"]
[null,null,null,null,null,null,null,null,"Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg","Freeze","Freeze","Freeze",null,null,null,null,null,null,null,null,null,null,"Nres",null,null,"Res","Refg","Refg","Refg","Freezer","Freezer","Freezer"]
[null,null,null,null,null,null,null,"Glazing Case",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",null,null,null,null,null,"SHGC",null,null,null,null,"Seattle",null,null,"Seattle",1,2,"Seattle",1,2,"Seattle"]
[]
[]
[]
[null,null,null,null,null,"Window","non-metal frame",1,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,null,null,null,null,null,"Window",null,1,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35]
[null,null,null,null,null,"Window","non-metal frame",2,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,null,null,null,null,null,"Window",null,2,0.4,0.4,0.35,0.4,0.4,0.35,0.4,0.4,0.35,0.4,0.4,0.35]
[null,null,null,null,null,"Window","non-metal frame",3,null,null,0.26,null,null,0.26,null,null,0.26,null,null,0.26,null,null,null,null,null,"Window",null,3,null,null,0.35,null,null,0.35,null,null,0.35,null,null,0.35]
[null,null,null,null,null,"Window","Metal Frame, fixed",1,0.34,0.34,0.34,0.34,0.34,0.34,0.34,0.34,0.34,0.34,0.34,0.34,null,null,null,null,null,"Window","0.2<=pf<0.5",1,{"$f":"AC89*AC93/AC90","v":0.41999999999999993},0.41999999999999993,0.35,0.41999999999999993,0.41999999999999993,0.35,0.41999999999999993,0.41999999999999993,0.35,0.41999999999999993,0.41999999999999993,0.35]
[null,null,null,null,null,"Window","Metal Frame, fixed",2,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,null,null,null,null,null,"Window","0.2<=pf<0.5",2,0.48,0.48,0.45,0.48,0.48,0.45,0.48,0.48,0.45,0.48,0.48,0.45]
[null,null,null,null,null,"Window","Metal Frame, fixed",3,null,null,0.31,null,null,0.31,null,null,0.31,null,null,0.31,null,null,null,null,null,"Window","0.2<=pf<0.5",3,null,null,0.45,null,null,0.45,null,null,0.45,null,null,0.45]
[null,null,null,null,null,"Window","Metal Frame, operable",1,0.36,0.36,0.36,0.36,0.36,0.36,0.36,0.36,0.36,0.36,0.36,0.36,null,null,null,null,null,"Window","pf>=0.5",1,{"$f":"AC89*AC96/AC90","v":0.55999999999999994},0.55999999999999994,0.35,0.55999999999999994,0.55999999999999994,0.35,0.55999999999999994,0.55999999999999994,0.35,0.55999999999999994,0.55999999999999994,0.35]
[null,null,null,null,null,"Window","Metal Frame, operable",2,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,null,null,null,null,null,"Window","pf>=0.5",2,0.64,0.64,0.6,0.64,0.64,0.6,0.64,0.64,0.6,0.64,0.64,0.6]
[null,null,null,null,null,"Window","Metal Frame, operable",3,null,null,0.38,null,null,0.38,null,null,0.38,null,null,0.38,null,null,null,null,null,"Window","pf>=0.5",3,null,null,0.6,null,null,0.6,null,null,0.6,null,null,0.6]
[null,null,null,null,null,"Window","metal entrance door",1,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,null,null,null,null,null,"Skylight",null,1,0.35,0.35,0.32,0.35,0.35,0.32,0.35,0.35,0.32,0.35,0.35,0.32]
[null,null,null,null,null,"Window","metal entrance door",2,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,null,null,null,null,null,"Skylight",null,2,0.35,0.35,0.32,0.35,0.35,0.32,0.35,0.35,0.32,0.35,0.35,0.32]
[null,null,null,null,null,"Window","metal entrance door",3,null,null,0.6,null,null,0.6,null,null,0.6,null,null,0.6,null,null,null,null,null,"Skylight",null,3,null,null,0.32,null,null,0.32,null,null,0.32,null,null,0.32]
[]
[null,null,null,null,null,"Skylight","all",1,0.5,0.5,0.45,0.5,0.5,0.45,0.5,0.5,0.45,0.5,0.5,0.45,null,null,null,null,null,"N. Window",null,1,{"$f":"AC$89*AC103/AC$90","v":0.46375},{"$f":"AD89*AD103/AD90","v":0.46375},{"$f":"AE89*AE103/AE90","v":0.53},0.46375,0.46375,0.53,0.46375,0.46375,0.53,0.46375,0.46375,0.53]
[null,null,null,null,null,"Skylight","all",2,0.5,0.5,0.45,0.5,0.5,0.45,0.5,0.5,0.45,0.5,0.5,0.45,null,null,null,null,null,"N. Window",null,2,0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53]
[null,null,null,null,null,"Skylight","all",3,null,null,0.45,null,null,0.45,null,null,0.45,null,null,0.45,null,null,null,null,null,"N. Window",null,3,null,null,0.53,null,null,0.53,null,null,0.53,null,null,0.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window","0.2<=pf<0.5",1,{"$f":"AC$89*AC106/AC$90","v":0.50749999999999995},0.50749999999999995,0.57999999999999996,0.50749999999999995,0.50749999999999995,0.57999999999999996,0.50749999999999995,0.50749999999999995,0.57999999999999996,0.50749999999999995,0.50749999999999995,0.57999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window","0.2<=pf<0.5",2,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window","0.2<=pf<0.5",3,null,null,0.57999999999999996,null,null,0.57999999999999996,null,null,0.57999999999999996,null,null,0.57999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window","pf>=0.5",1,{"$f":"AC$89*AC109/AC$90","v":0.55999999999999994},0.55999999999999994,0.64,0.55999999999999994,0.55999999999999994,0.64,0.55999999999999994,0.55999999999999994,0.64,0.55999999999999994,0.55999999999999994,0.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window","pf>=0.5",2,0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window","pf>=0.5",3,null,null,0.64,null,null,0.64,null,null,0.64,null,null,0.64]
["MAIN LOOKUPS"]
[null,null,null,null,"Selected Group (1=Nres, 2=Res, 3= Mixed, 4=Not specified) ==>",1,"NOT USED 2015"]
[null,null,null,null,"Calculation Type: 1=Building, 2=Refrigeration ==>",{"$f":"CalculationGroup","v":1},null,null,null,"seattle also has swing and non-swing doors",null,null,null,null,null,null,null,null,null,null,null,null,null,"door type u-values","same","diff -swing / non-swing"]
[null,null,null,null,"Selected Zone (1=Zone 4c/5, 2=Zone 6, 3= Seattle) ==>",{"$f":"IF('TA1'!A3<=2,'TA1'!A3,IF('TA1'!A3=3,4,3))","v":3},null,null,null,"and two floor u-values (mass/steel joist vs wood/other)",null,null,null,null,null,null,null,null,null,null,null,null,null,"mtl  bld & steel frame wall u-values","same","diff"]
[null,null,null,null,"Data Entered (0=no, 1=yes) ==>",{"$f":"IF('ENV-UA'!H112=0,0,1)","v":0},null,null,null,"Glass U & SHGC is by 0-30 and >30 to 40%",null,null,null,null,null,null,null,null,null,null,null,null,null,"floor over air u-values","same","state + wd frame"]
[null,null,null,null,"Refrigeration / Occupancy Offset ==>",{"$f":"IF(CalcType=3,6,IF(CalcType=4,9,0))","v":0},{"$f":"IF(CalcType=3,6,IF(CalcType=4,9,3))","v":3}]
[null,null,null,null,"Column # (idxU) ==>",null,"Not used 2015, Now action is in the Target U formulas.  should return blank if nothing entered, warning if something entered but no zone/jurisdiction chosen, or the proper value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not used in current forms"]
[null,null,null,null,null,null,null,"Master Look Up Table of U-Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Master Look Up Table of SHGC-Values"]
[null,null,null,null,null,null,null,"Col Num ==>",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,null,null,null,"Col Num ==>",1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[null,null,null,null,null,null,null,"Group ==>","Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg","Freeze","Freeze","Freeze",null,null,null,null,null,null,null,"Group ==>","Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg","Freezer","Freezer","Freezer"]
[null,"Component","Item Name",null,null,{"$f":"IF(F113=1,\"Comm\",\"Cooler\")","v":"Comm"},{"$f":"IF(F113=1,\"Group R\",\"Freezer\")","v":"Group R"},"Zone ==>",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",null,null,null,null,null,null,null,"Zone ==>",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",null,null,null,null,"SHGC Multipliers"]
[null,null,"Long","Short",null,"Target U","Target U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Target SHGC","Target SHGC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PF","non-North","North"]
[null,"Window","non-metal frame","non-metal frm",1,{"$f":"IF(AND(OR($B124=\"AGWall\",$B124=\"BGWall\"),SemiHt),\"NR\",INDEX(TargetUbyJurisdiction,$E124,IF($F$112=4,13,IF($F$114=4,14,IF(AND(heatfuel=3,B124=\"Window\"),15,$F$116+idxZone)))))","v":"set fuel"},{"$f":"IF(AND(OR($B124=\"AGWall\",$B124=\"BGWall\"),SemiHt),\"NR\",INDEX(TargetUbyJurisdiction,$E124,IF($F$112=4,13,IF($F$114=4,14,IF(AND(heatfuel=3,B124=\"Window\"),15,$G$116+idxZone)))))","v":"set fuel"},null,{"$f":"INDEX(I$89:I$91,$H$79)","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,"set occ.","set zone","set fuel",null,"Window",1,{"$f":"INDEX(TargetSHGCbyJurisdiction,$Z124,IF($F$112=4,13,IF($F$114=4,14,$F$116+(   1-1)*3+idxZone)))","v":0.35},{"$f":"INDEX(TargetSHGCbyJurisdiction,$Z124,IF($F$112=4,13,IF($F$114=4,14,$F$116+(   2-1)*3+idxZone)))","v":0.35},{"$f":"INDEX(AC89:AC91,$H$79)","v":0.4},0.4,0.35,0.4,0.4,0.35,0.4,0.4,0.35,0.4,0.4,0.35,"set occ.","set zone",null,null,0,1,1]
[null,"Window","metal frame, fixed","metal fix",2,"set fuel","set fuel",null,{"$f":"INDEX(I$92:I$94,$H$79)","v":0.38},0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,"set occ.","set zone","set fuel",null,"Window 0.2<=pf<0.5",2,{"$f":"INDEX(TargetSHGCbyJurisdiction,Z125,IF($F$112=4,13,IF($F$114=4,14,$F$116+(   1-1)*3+idxZone)))","v":0.45},0.45,{"$f":"INDEX(AC92:AC94,$H$79)","v":0.48},0.48,0.45,0.48,0.48,0.45,0.48,0.48,0.45,0.48,0.48,0.45,"set occ.","set zone",null,null,0.10000100000000001,0.91,0.95]
[null,"Window","metal frame, operable","metal opp",3,"set fuel","set fuel",null,{"$f":"INDEX(I$95:I$97,$H$79)","v":0.4},0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,"set occ.","set zone","set fuel",null,"Window pf>0.5",3,0.6,0.6,{"$f":"INDEX(AC95:AC97,$H$79)","v":0.64},0.64,0.6,0.64,0.64,0.6,0.64,0.64,0.6,0.64,0.64,0.6,"set occ.","set zone",null,null,0.20000100000000001,0.82,0.91]
[null,"Window","metal entrance door","metal frm door",4,"set fuel","set fuel",null,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,"set occ.","set zone","set fuel",null,"Skylight",4,0.32,0.32,{"$f":"INDEX(AC98:AC100,$H$79)","v":0.35},0.35,0.32,0.35,0.35,0.32,0.35,0.35,0.32,0.35,0.35,0.32,"set occ.","set zone",null,null,0.30000100000000002,0.74,0.87]
[null,"Skylight","All Types","all types",5,0.45,0.45,null,0.5,0.5,0.45,0.5,0.5,0.45,0.5,0.5,0.45,0.5,0.5,0.45,"set occ.","set zone","set fuel",null,"N Window",5,0.53,0.53,{"$f":"INDEX(AC102:AC104,$H$79)","v":0.53},0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53,"set occ.","set zone",null,null,0.400001,0.67,0.84]
[null,"Door","Swinging","swing",6,0.37,0.37,null,0.37,0.37,0.37,0.37,0.37,0.37,0.37,0.37,{"$f":"K129","v":0.37},0.03,0.03,0.03,"set occ.","set zone","set fuel",null,"N Window 0.2<=pf<0.5",6,0.57999999999999996,0.57999999999999996,{"$f":"INDEX(AC105:AC107,$H$79)","v":0.57999999999999996},0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,"set occ.","set zone",null,null,0.50000100000000003,0.61,0.81]
[null,"Door","Roll-up or sliding","roll/slide",7,0.34,0.34,null,0.34,0.34,0.34,0.34,0.34,0.34,0.34,0.34,0.34,0.03,0.03,0.03,"set occ.","set zone","set fuel",null,"N Window pf>0.5",7,0.64,0.64,{"$f":"INDEX(AC108:AC110,$H$79)","v":0.64},0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64,"set occ.","set zone",null,null,0.60000100000000001,0.56000000000000005,0.78]
[null,"Roof",null,"above deck",8,2.7E-2,2.7E-2,null,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.70000099999999998,0.51,0.76]
[null,"Roof",null,"metal bldg",9,2.7E-2,2.7E-2,null,3.1E-2,3.1E-2,2.7E-2,3.1E-2,3.1E-2,2.7E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.80000099999999996,0.47,0.75]
[null,"Roof",null,"attic/other",10,2.1000000000000001E-2,2.1000000000000001E-2,null,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.90000999999999998,0.44,0.73]
[null,"Roof",null,"joist/single",11,2.7E-2,2.7E-2,null,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel",null,"sea has 0.056 for int ins",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"AGWall",null,"mass",12,5.7000000000000002E-2,5.7000000000000002E-2,null,0.104,0.104,5.7000000000000002E-2,7.8E-2,7.8E-2,5.7000000000000002E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel"]
[null,"AGWall",null,"metal bldg",13,5.1999999999999998E-2,5.1999999999999998E-2,null,5.1999999999999998E-2,5.1999999999999998E-2,5.1999999999999998E-2,5.1999999999999998E-2,5.1999999999999998E-2,5.1999999999999998E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel",null,"sea mtl bld and stl are diff"]
[null,"AGWall",null,"steel frame",14,5.5E-2,5.5E-2,null,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel"]
[null,"AGWall",null,"wood frame/other",15,5.0999999999999997E-2,5.3999999999999999E-2,null,5.3999999999999999E-2,5.3999999999999999E-2,5.0999999999999997E-2,5.3999999999999999E-2,5.3999999999999999E-2,5.3999999999999999E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel"]
[null,"AGWall","transfer slab","transfer slab",16,0.2,0.2,null,0.2,0.2,0.2,0.2,0.2,0.2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel",null,"sea has 0.025 wd frm"]
[null,"AGWall","cmu, same as mass but with corefill then okay in z1","CMU w/ Ins. Cores",17,5.7000000000000002E-2,5.7000000000000002E-2,"Not used",0.25,0.25,5.7000000000000002E-2,7.8E-2,7.8E-2,5.7000000000000002E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel"]
[null,"Floor","Mass","mass",18,2.9000000000000001E-2,2.9000000000000001E-2,null,3.1E-2,3.1E-2,2.9000000000000001E-2,3.1E-2,3.1E-2,2.9000000000000001E-2,3.1E-2,3.1E-2,2.9000000000000001E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,"set occ.","set zone","set fuel"]
[null,"Floor","Joist/framing","joist/frame",19,2.9000000000000001E-2,2.9000000000000001E-2,null,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,"set occ.","set zone","set fuel"]
[null,"Floor","Metal joist/framing","Metal joist/framing",20,2.9000000000000001E-2,2.9000000000000001E-2,"seattle only",null,null,2.9000000000000001E-2,null,null,2.9000000000000001E-2,null,null,2.5000000000000001E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,"set occ.","set zone","set fuel"]
[null,"Floor","Wood joist/framing","Wood joist/framing",21,2.5000000000000001E-2,2.5000000000000001E-2,"seattle only",null,null,2.5000000000000001E-2,null,null,2.5000000000000001E-2,null,null,2.9000000000000001E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,"set occ.","set zone","set fuel"]
[null,"Floor",null,"Slab",22,0.54,0.54,"All floors U0.029 - all zones",0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.52,0.54,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,"set occ.","set zone","set fuel"]
[null,"Floor",null,"Heated Slab",23,0.55000000000000004,0.55000000000000004,null,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,"set occ.","set zone","set fuel"]
[null,"BGWall",null,"mass",24,7.0000000000000007E-2,7.0000000000000007E-2,null,0.104,0.104,7.0000000000000007E-2,7.8E-2,7.8E-2,7.0000000000000007E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel"]
[null,"BGWall",null,"metal bldg",25,7.0000000000000007E-2,7.0000000000000007E-2,"Not used",5.1999999999999998E-2,5.1999999999999998E-2,7.0000000000000007E-2,5.1999999999999998E-2,4.3999999999999997E-2,7.0000000000000007E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel"]
[null,"BGWall",null,"steel frame",26,7.0000000000000007E-2,7.0000000000000007E-2,"Not used",5.5E-2,4.9000000000000002E-2,7.0000000000000007E-2,5.5E-2,4.3999999999999997E-2,7.0000000000000007E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel",null,null,null,null,"LABELS"]
[null,"BGWall",null,"wood frame/other",27,7.0000000000000007E-2,7.0000000000000007E-2,"Not used",5.3999999999999999E-2,5.0999999999999997E-2,7.0000000000000007E-2,5.3999999999999999E-2,4.3999999999999997E-2,7.0000000000000007E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone","set fuel",null,null,null,null,null,"Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg","Freezer","Freezer","Freezer"]
[null,"MAXGlass","MAXGlass","MAXGlass",28,0.3,0.3,null,{"$f":"IF(OR(hpfwin,dlz50pct,dlz25pct,hpmwin),0.4,0.3)","v":0.3},0.3,{"$f":"IF(OR(AND(hpfwin,heatfuel=2),dlz50pct,dlz25pct,hpmwin),0.4,0.3)","v":0.3},0.3,0.3,{"$f":"IF(OR(AND(hpfwin,heatfuel=2),dlz50pct,dlz25pct,hpmwin),0.4,0.3)","v":0.3},0.3,0.3,{"$f":"IF(OR(AND(hpfwin,heatfuel=2),dlz50pct,dlz25pct,hpmwin),0.4,0.3)","v":0.3},{"$f":"IF(OR(hpfwin,dlz50pct,dlz25pct,hpmwin),0.4,0.3)","v":0.3},0.3,0.3,0,0,null,null,null,null,{"$f":"F122","v":"Comm"},{"$f":"G122","v":"Group R"},1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle"]
[null,"MAXskylight","MAXskylight","MAXskylight",29,0.05,0.05,null,0.03,0.03,0.05,0.03,0.03,0.05,0.03,0.03,0.05,0.05,0.05,0.05,0,0,null,null,null,null,"SHGC","SHGC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window",1,{"$f":"INDEX( $AC$153:$AQ$159,$Z153,IF($F$112=4,13,IF($F$114=4,14,$F$116+(   1-1)*3+idxZone)))","v":"0.35"},{"$f":"INDEX( $AC$153:$AQ$159,$Z153,IF($F$112=4,13,IF($F$114=4,14,$F$116+(   2-1)*3+idxZone)))","v":"0.35"},{"$f":"TEXT(AC124,\"0.00#\")","v":"0.40"},"0.40","0.35","0.40","0.40","0.35","0.40","0.40","0.35","0.40","0.40","0.35","set occ.","set zone"]
[null,null,null,null,null,null,null,"Group ==>","Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg","Freeze","Freeze","Freeze",null,null,null,null,"Window 0.2<=pf<0.5",2,"0.45","0.45",{"$f":"TEXT(AC125,\"0.00#\")","v":"0.48"},"0.48","0.45","0.48","0.48","0.45","0.48","0.48","0.45","0.48","0.48","0.45","set occ.","set zone"]
[null,"Component","Item Name",null,null,{"$f":"F122","v":"Comm"},{"$f":"G122","v":"Group R"},"Zone ==>",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",null,null,null,null,"Window pf>0.5",3,"0.60","0.60",{"$f":"TEXT(AC126,\"0.00#\")","v":"0.64"},"0.64","0.60","0.64","0.64","0.60","0.64","0.64","0.60","0.64","0.64","0.60","set occ.","set zone"]
[null,null,"Long","Short",null,"Target Label","Target Label","Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight",4,"0.32","0.32",{"$f":"TEXT(AC127,\"0.00#\")","v":"0.35"},"0.35","0.32","0.35","0.35","0.32","0.35","0.35","0.32","0.35","0.35","0.32","set occ.","set zone"]
[null,{"$f":"B124","v":"Window"},"non-metal frame","non-metal frm",1,{"$f":"IF(AND(OR($B157=\"AGWall\",$B157=\"BGWall\"),SemiHt),\"NR\",INDEX(TargetLabelByJurisdiction,$E157,IF($F$112=4,13,IF($F$114=4,14,IF(AND(heatfuel=3,B157=\"Window\"),15,$F$116+idxZone)))))","v":"set fuel"},{"$f":"IF(AND(OR($B157=\"AGWall\",$B157=\"BGWall\"),SemiHt),\"NR\",INDEX(TargetLabelByJurisdiction,$E157,IF($F$112=4,13,IF($F$114=4,14,IF(AND(heatfuel=3,B157=\"Window\"),15,$G$116+idxZone)))))","v":"set fuel"},"nmfrm",{"$f":"CONCATENATE(\"U-\",TEXT(I124,\"0.00#\"))","v":"U-0.30"},"U-0.30","U-0.30","U-0.30","U-0.30","U-0.30","U-0.30","U-0.30","U-0.30",null,null,null,"set occ.","set zone","set fuel",null,"N Window",5,"0.53","0.53",{"$f":"TEXT(AC128,\"0.00#\")","v":"0.53"},"0.53","0.53","0.53","0.53","0.53","0.53","0.53","0.53","0.53","0.53","0.53","set occ.","set zone"]
[null,"Window","metal frame, fixed","metal fix",2,"set fuel","set fuel","mfrm",{"$f":"CONCATENATE(\"U-\",TEXT(I125,\"0.00#\"))","v":"U-0.38"},"U-0.38","U-0.38","U-0.38","U-0.38","U-0.38","U-0.38","U-0.38","U-0.38",null,null,null,"set occ.","set zone","set fuel",null,"N Window 0.2<=pf<0.5",6,"0.58","0.58",{"$f":"TEXT(AC129,\"0.00#\")","v":"0.58"},"0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58","set occ.","set zone"]
[null,"Window","metal frame, operable","metal opp",3,"set fuel","set fuel","med",{"$f":"CONCATENATE(\"U-\",TEXT(I126,\"0.00#\"))","v":"U-0.40"},"U-0.40","U-0.40","U-0.40","U-0.40","U-0.40","U-0.40","U-0.40","U-0.40",null,null,null,"set occ.","set zone","set fuel",null,"N Window pf>0.5",7,"0.64","0.64",{"$f":"TEXT(AC130,\"0.00#\")","v":"0.64"},"0.64","0.64","0.64","0.64","0.64","0.64","0.64","0.64","0.64","0.64","0.64","set occ.","set zone"]
[null,"Window","metal entrance door","metal frm door",4,"set fuel","set fuel","nc",{"$f":"CONCATENATE(\"U-\",TEXT(I127,\"0.00#\"))","v":"U-0.60"},"U-0.60","U-0.60","U-0.60","U-0.60","U-0.60","U-0.60","U-0.60","U-0.60",null,null,null,"set occ.","set zone","set fuel"]
[null,"Skylight","All Types","all types",5,"U-0.45","U-0.45","wc",{"$f":"CONCATENATE(\"U-\",TEXT(I128,\"0.00#\"))","v":"U-0.50"},"U-0.50","U-0.45","U-0.50","U-0.50","U-0.45","U-0.50","U-0.50","U-0.45",null,null,null,"set occ.","set zone","set fuel"]
[null,"Door","Swinging","swing",6,"U-0.37","U-0.37","dr",{"$f":"CONCATENATE(\"U-\",TEXT(I129,\"0.00#\"))","v":"U-0.37"},"U-0.37","U-0.37","U-0.37","U-0.37","U-0.37","U-0.37","U-0.37","U-0.37",null,null,null,"set occ.","set zone","set fuel"]
[null,"Door","Roll-up or sliding","roll/slide",7,"U-0.34","U-0.34",null,{"$f":"CONCATENATE(\"U-\",TEXT(I130,\"0.00#\"))","v":"U-0.34"},"U-0.34","U-0.34","U-0.34","U-0.34","U-0.34",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Roof",0,"above deck",8,"U-0.027","U-0.027",null,"U-0.027","U-0.027","U-0.027","U-0.027","U-0.027","U-0.027",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Roof",0,"metal bldg",9,"U-0.027","U-0.027",null,"U-0.031","U-0.031","U-0.027","U-0.031","U-0.031","U-0.027",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Roof",0,"attic/other",10,"U-0.021","U-0.021",null,"U-0.021","U-0.021","U-0.021","U-0.021","U-0.021","U-0.021",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Roof",0,"joist/single",11,"U-0.027","U-0.027",null,"U-0.027","U-0.027","U-0.027","U-0.027","U-0.027","U-0.027",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"AGWall",0,"mass",12,"U-0.057","U-0.057",null,"U-0.104","U-0.104","U-0.057","U-0.078","U-0.078","U-0.057",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"AGWall",0,"metal bldg",13,"U-0.052","U-0.052",null,"U-0.052","U-0.052","U-0.052","U-0.052","U-0.052","U-0.052",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"AGWall",0,"steel frame",14,"U-0.055","U-0.055",null,"U-0.055","U-0.055","U-0.055","U-0.055","U-0.055","U-0.055",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"AGWall",0,"wood frame/other",15,"U-0.051","U-0.054",null,"U-0.054","U-0.054","U-0.051","U-0.054","U-0.054","U-0.054",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"AGWall","transfer slab","transfer slab",16,"U-0.20","U-0.20",null,"U-0.20","U-0.20","U-0.20","U-0.20","U-0.20","U-0.20",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"AGWall","cmu, same as mass but with corefill then okay in z1","CMU w/ Ins. Cores",17,"U-0.057","U-0.057",null,"U-0.25","U-0.25","U-0.057","U-0.078","U-0.078","U-0.057",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Floor","Mass","mass",18,"U-0.029","U-0.029",null,"U-0.031","U-0.031","U-0.029","U-0.031","U-0.031","U-0.029",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Floor","Joist/framing","joist/frame",19,"U-0.029","U-0.029",null,"U-0.029","U-0.029","U-0.029","U-0.029","U-0.029","U-0.029",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Floor","Metal joist/framing","Metal joist/framing",20,"U-0.029","U-0.029",null,"U-0.00","U-0.00","U-0.029","U-0.00","U-0.00","U-0.029",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Floor","Wood joist/framing","Wood joist/framing",21,"U-0.025","U-0.025",null,"U-0.00","U-0.00","U-0.025","U-0.00","U-0.00","U-0.025",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Floor",0,"Slab",22,"F-0.54","F-0.54",null,{"$f":"CONCATENATE(\"F-\",TEXT(I145,\"0.00#\"))","v":"F-0.54"},"F-0.54","F-0.54","F-0.54","F-0.54","F-0.54",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"Floor",0,"Heated Slab",23,"F-0.55","F-0.55",null,"F-0.55","F-0.55","F-0.55","F-0.55","F-0.55","F-0.55",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"BGWall",0,"mass",24,"U-0.07","U-0.07",null,{"$f":"CONCATENATE(\"U-\",TEXT(I147,\"0.00#\"))","v":"U-0.104"},"U-0.104","U-0.07","U-0.078","U-0.078","U-0.07",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"BGWall",0,"metal bldg",25,"U-0.07","U-0.07",null,"U-0.052","U-0.052","U-0.07","U-0.052","U-0.044","U-0.07",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"BGWall",0,"steel frame",26,"U-0.07","U-0.07",null,"U-0.055","U-0.049","U-0.07","U-0.055","U-0.044","U-0.07",null,null,null,null,null,null,"set occ.","set zone","set fuel"]
[null,"BGWall",0,"wood frame/other",27,"U-0.07","U-0.07",null,"U-0.054","U-0.051","U-0.07","U-0.054","U-0.044","U-0.07",null,null,null,null,null,null,"set occ.","set zone","set fuel"]

{"sheet":"Target Area Adjustments","index":7,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[[74,9,75,9],[66,4,67,5]]}
[null,"Vertical Fenestration Target Area Adjustment Calculations"]
[]
[]
[]
[null,null,"VF = Vertical fenestration (exclude SLG)",null,null,null,"NW = Net above grade wall including opaque doors (excludes fenestration)"]
[null,null,"SG = Exempt Single Glazing",null,null,null,"Gross Exterior Above-Grade Wall Area= VF + NW"]
[null,null,"AG = Above-grade wall (exclude SLW)",null,null,null,"DR = Opaque doors ( NOT USED IN CITY FORM - Include area with net wall)"]
[null,null,"SLW = Street level gross wall below ceiling ",null,null,null,"SLG = Area of window in Street level qualified wall "]
[null,null,null,"  height and 20' per C402.3.1",null,null,"SLT = Window area transferred to Street Level Retail wall from other areas"]
[]
[null,"Proposed Areas",null,null,null,"Vertical Fenestration",null,"Exempt Single Glaze",null,"Street Level \nRetail Transfer",null,"Net Above Grade Wall"]
[null,null,null,"Project Areas ->","VF=",{"$f":"IF(ComponentPath=1,EnvSumTotWin-EnvSumExmptSngl,SUM('ENV-UA'!H84:H98))","v":0},"SG=",{"$f":"EnvSumExmptSngl","v":0},"SLT=",{"$f":"SLRtransfer","v":"n/a"},"NW=",{"$f":"IF(ComponentPath=1,EnvSumNetWall,SUM('ENV-UA'!H27:H44)+SUM('ENV-UA'!H78:H83))","v":0}]
[null,null,null,"Existing Non-project Areas ->","VF=",{"$f":"IF(ComponentPath=1,EnvSumTotWinExisting,'ENV-UA'!G11)","v":0},null,null,null,null,"NW=",{"$f":"IF(ComponentPath=1,EnvSumNetWallExisting,'ENV-UA'!I11)","v":0}]
[]
[null,"Maximum Target Vertical Fenestration Calculation"]
[null,"Gross Exterior AG Wall Area",null,"Max Vert. Fen. %\n(C402.3.1)",null,null,null,"Maximum Target Vert. Fen. Area"]
[null,{"$f":"(SUM(F12:H13,L12:L13))","v":0},"x",{"$f":"'TA1'!F151","v":0.3},"¸",100,"=",{"$f":"B17*D17","v":0}]
[]
[]
[null,"Base Target Vert. Fen. Area",null,"Window area transferred to Street Level Retail (SLT)",null,"Maximum Target Vert. Fen. Area",null,"Gross Exterior AG Wall",null,"Maximum Target Vert. Fen %"]
[null,{"$f":"H17","v":0},"-",{"$f":"IF(SLR=2,0,J12)","v":0},"=",{"$f":"B21-D21","v":0},"¸",{"$f":"TA_GrossWall","v":0},"=",{"$f":"IF(H21=0,\"\",MIN(1,F21/H21))","v":""}]
[]
["Vertical Fenestration Component Performance Target Area Adjustment Calculation"]
[]
[null,"Total Vertical Fenestration",null,null,null,"Delta Vertical Fenestration ",null,"0",null,"Excess Vertical Fenestration"]
[null,{"$f":"SUM(F12:F13)","v":0},"-",{"$f":"F21","v":0},"=",{"$f":"B26-D26","v":0},null,"ô greater","=",{"$f":"MAX(0,H27)","v":0}]
[null,null,null,null,null,null,null,{"$f":"F26","v":0}]
[]
[null,"Project Vertical Fenestration",null,"Excess Vertical Fenestration",null,"Target Vertical Fenestration",null,"Total Vertical Fenestration",null,"Target VF Multiplier"]
[null,{"$f":"F12","v":0},"-",{"$f":"J26","v":0},"=",{"$f":"B30-D30","v":0},"¸",{"$f":"B30","v":0},"=",{"$f":"IF(H30>0,F30/H30,0)","v":0}]
[]
[null,"Net AG Wall Area",null,"Excess Fenestration",null,"Target Net Wall Area",null,"Net Wall",null,"Target Net Wall Mult."]
[null,{"$f":"L12","v":0},"+",{"$f":"D30","v":0},"=",{"$f":"B33+D33","v":0},"¸",{"$f":"B33","v":0},"=",{"$f":"IF(H33>0,F33/H33,0)","v":0}]
[]
[null,"Target Areas - UA"]
[null,null,"Commercial"]
[null,null,null,"Vertical Fenestration",null,"Proposed Area",null,"Target VF Mult.",null,"Target Area"]
[null,null,null,"Non-metal frame",null,{"$f":"SUM('ENV-UA'!H84:H86)","v":0},"x",{"$f":"IF(F38>0,$J$30,0)","v":0},"=",{"$f":"F38*H38","v":0}]
[null,null,null,"Metal frame, fixed",null,{"$f":"SUM('ENV-UA'!H87:H90)","v":0},"x",{"$f":"IF(F39>0,$J$30,0)","v":0},"=",{"$f":"F39*H39","v":0}]
[null,null,null,"Metal frame, operable",null,{"$f":"SUM('ENV-UA'!H91:H94)","v":0},"x",{"$f":"IF(F40>0,$J$30,0)","v":0},"=",{"$f":"F40*H40","v":0}]
[null,null,null,"Metal frame, entrance door",null,{"$f":"SUM('ENV-UA'!H95:H98)","v":0},"x",{"$f":"IF(F41>0,$J$30,0)","v":0},"=",{"$f":"F41*H41","v":0}]
[null,null,null,"Above-grade Wall",null,"Proposed Area",null,"Target Net Wall Mult.",null,"Target Area"]
[null,null,null,"Steel Frame",null,{"$f":"SUM('ENV-UA'!H27:H29)","v":0},"x",{"$f":"IF(F43>0,$J$33,0)","v":0},"=",{"$f":"F43*H43","v":0}]
[null,null,null,"Metal Building",null,{"$f":"SUM('ENV-UA'!H30:H32)","v":0},"x",0,"=",0]
[null,null,null,"Wood / Other frame",null,{"$f":"SUM('ENV-UA'!H33:H35)","v":0},"x",0,"=",0]
[null,null,null,"Mass",null,{"$f":"SUM('ENV-UA'!H36:H38)","v":0},"x",0,"=",0]
[null,null,null,"Mass Transfer Deck",null,{"$f":"SUM('ENV-UA'!H39:H41)","v":0},"x",0,"=",0]
[null,null,null,"Group R Wood / Other frame",null,{"$f":"SUM('ENV-UA'!H42:H44)","v":0},"x",0,"=",0]
[]
[null,null,null,"Sum of Proposed","Sum of Proposed          ",{"$f":"SUM(F38:F49)","v":0},null,"Sum of Target",null,{"$f":"SUM(J38:J49)","v":0}]
[]
[null,"Target Areas - SHGC x A "]
[null,null,null,"Non-North Vertical Fenestration",null,"Proposed Area",null,"Target VF Mult.",null,"Target Area"]
[null,null,null,"PF < 0.2",null,{"$f":"SUMPRODUCT(('ENV-SHGC'!$E$25:$E$34)*('ENV-SHGC'!$C$25:$C$34>=0)*('ENV-SHGC'!$C$25:$C$34<0.2))","v":0},"x",{"$f":"IF(F54>0,$J$30,0)","v":0},"=",{"$f":"F54*H54","v":0}]
[null,null,null,"0.2 ≤ PF < 0.5",null,{"$f":"SUMPRODUCT(('ENV-SHGC'!$E$25:$E$34)*('ENV-SHGC'!$C$25:$C$34>=0.2)*('ENV-SHGC'!$C$25:$C$34<0.5))","v":0},"x",{"$f":"IF(F55>0,$J$30,0)","v":0},"=",{"$f":"F55*H55","v":0}]
[null,null,null,"PF ≥ 0.5",null,{"$f":"SUMPRODUCT(('ENV-SHGC'!$E$25:$E$34)*('ENV-SHGC'!$C$25:$C$34>=0.5)*('ENV-SHGC'!$C$25:$C$34<99))","v":0},"x",{"$f":"IF(F56>0,$J$30,0)","v":0},"=",{"$f":"F56*H56","v":0}]
[null,null,null,"North Vertical Fenestration"]
[null,null,null,"PF < 0.2",null,{"$f":"SUMPRODUCT(('ENV-SHGC'!$E$41:$E$47)*('ENV-SHGC'!$C$41:$C$47>=0)*('ENV-SHGC'!$C$41:$C$47<0.2))","v":0},"x",{"$f":"IF(F58>0,$J$30,0)","v":0},"=",{"$f":"F58*H58","v":0}]
[null,null,null,"0.2 ≤ PF < 0.5",null,{"$f":"SUMPRODUCT(('ENV-SHGC'!$E$41:$E$47)*('ENV-SHGC'!$C$41:$C$47>=0.2)*('ENV-SHGC'!$C$41:$C$47<0.5))","v":0},"x",{"$f":"IF(F59>0,$J$30,0)","v":0},"=",{"$f":"F59*H59","v":0}]
[null,null,null,"PF ≥ 0.5",null,{"$f":"SUMPRODUCT(('ENV-SHGC'!$E$41:$E$47)*('ENV-SHGC'!$C$41:$C$47>=0.5)*('ENV-SHGC'!$C$41:$C$47<99))","v":0},"x",{"$f":"IF(F60>0,$J$30,0)","v":0},"=",{"$f":"F60*H60","v":0}]
[]
[null,"Skylight Target Area Adjustment Calculations "]
[]
[]
[null,null,"SKY= Skylight",null,"NR - Net roof (excludes skylight)",null,null,null,"Gross Exterior Roof Area = SKY + NR"]
[]
[null,null,null,null,"Skylight \n(Horizontal Fenestration)"]
[null,"Proposed Areas",null,null,null,null,null,"Opaque Roof "]
[null,null,null,"Project Areas ->","SKY=",{"$f":"IF(ComponentPath=1,EnvSumTotSky,SUM('ENV-UA'!H99:H102))","v":0},"NR=",{"$f":"IF(ComponentPath=1,EnvSumNetRoof,SUM('ENV-UA'!H15:H26))","v":0}]
[null,null,null,"Existing Non-project Areas ->","SKY=",{"$f":"IF(ComponentPath=1,EnvSumTotSkyExisting,'ENV-UA'!G12)","v":0},"NR=",{"$f":"IF(ComponentPath=1,EnvSumNetRoofExisting,'ENV-UA'!I12)","v":0}]
[]
[null,"Gross Exterior Roof Area",null,"Max Skylight %\n(C402.3.1)",null,null,null,"Maximum Skylight Fenestration Area"]
[null,{"$f":"SUM(F69:H70)","v":0},"x",{"$f":"'TA1'!F152","v":0.05},"¸",100,"=",{"$f":"B73*D73","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Excess Skylight"]
[null,"Total Skylight Area",null,"Maximum Target",null,"Delta Skylight Area",null,"0"]
[null,{"$f":"SUM(F69:F70)","v":0},"-",{"$f":"H73","v":0},"=",{"$f":"B77-D77","v":0},null,"ô greater","=",{"$f":"MAX(0,H78)","v":0}]
[null,null,null,null,null,null,null,{"$f":"F77","v":0}]
[]
[null,"Total Skylight Area",null,"Excess Skylight",null,"Target Skylight Area",null,"Total Skylight Area",null,"Target SKY Multiplier"]
[null,{"$f":"F69","v":0},"-",{"$f":"J77","v":0},"=",{"$f":"B81-D81","v":0},"¸",{"$f":"B81","v":0},"=",{"$f":"IF(H81>0,F81/H81,0)","v":0}]
[]
[null,"Net Roof Area",null,"Excess Skylight",null,"Target Net Roof Area",null,"Net Roof",null,"Target Net Roof Mult."]
[" ",{"$f":"H69","v":0},"+",{"$f":"D81","v":0},"=",{"$f":"B84+D84","v":0},"¸",{"$f":"B84","v":0},"=",{"$f":"IF(H84>0,F84/H84,0)","v":0}]
[]
[null,"Target Areas - UA and SHGC x A"]
[null,null,null,"Skylight",null,"Proposed Area",null,"Target SKY Mult.",null,"Target Area"]
[null,null,null,"All",null,{"$f":"SUM('ENV-UA'!H99:H102)","v":0},"x",{"$f":"IF(F88>0,$J$81,0)","v":0},"=",{"$f":"F88*H88","v":0}]
[null,null,null,"Roof",null,"Proposed Area",null,"Target Net Roof Mult.",null,"Target Area"]
[null,null,null,"Insulation Above Deck",null,{"$f":"SUM('ENV-UA'!H15:H17)","v":0},"x",{"$f":"IF(F90>0,$J$84,0)","v":0},"=",{"$f":"F90*H90","v":0}]
[null,null,null,"Metal Building",null,{"$f":"SUM('ENV-UA'!H18:H20)","v":0},"x",{"$f":"IF(F91>0,$J$84,0)","v":0},null,{"$f":"F91*H91","v":0}]
[null,null,null,"Joist / Single Rafter",null,{"$f":"SUM('ENV-UA'!H21:H23)","v":0},"x",{"$f":"IF(F92>0,$J$84,0)","v":0},"=",{"$f":"F92*H92","v":0}]
[null,null,null,"Attic / All Others",null,{"$f":"SUM('ENV-UA'!H24:H26)","v":0},"x",{"$f":"IF(F93>0,$J$84,0)","v":0},"=",{"$f":"F93*H93","v":0}]
[]
[null,null,null,null,"Sum of Proposed  ",{"$f":"SUM(F87:F93)","v":0},null,null,"Sum of Target  ",{"$f":"SUM(J87:J93)","v":0}]

{"sheet":"ENV-SHGC","index":8,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[22,6,23,6],[38,6,39,6],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3]]}
["SHGC Calculation",null,null,null,null,null,null,null,null,"ENV-SHGC"]
[{"$f":"'ENV-SUM'!A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised Aug 2019"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Title:"},null,{"$f":"IF('PROJ-SUM'!$D$3=\"1 - This title will copy onto other forms\",\"1 - Fill this line out on PROJ-SUM\",'PROJ-SUM'!$D$3)","v":"1 - Fill this line out on PROJ-SUM"},null,null,null,null,"Date",{"$f":"TEXT('PROJ-SUM'!$F$3,\"mm/dd/yyyy\")","v":"01/01/2019"}]
["Target Insulation Allowance:",null,null,null,null,null,null,"For SDCI Use"]
[null,{"$f":"IF(CompliancePath<>2,\"Component Performance Not Selected\",IF(CalcType=1,\"Fully Conditioned Space - Commercial, Group R, Mixed Use\",IF(CalcType=2,\"Semi-heated Space\",IF(CalcType=3,\"Refrigerated Cooler - See note 11 on ENV-UA\",IF(CalcType=4,\"Refrigerated Freezer - See note 12 on ENV-UA\",\"\")))))","v":"Component Performance Not Selected"}]
["Fenestration Area as % gross above-grade wall area",null,null,null,{"$f":"IF('ENV-SUM'!E33>0,'ENV-SUM'!E33,0)","v":""},null,{"$f":"'Target Area Adjustments'!D17","v":0.3}]
["Skylight Area as % gross roof area",null,null,null,{"$f":"IF('ENV-SUM'!G33>0,'ENV-SUM'!G33,0)","v":""},null,{"$f":"'Target Area Adjustments'!D73","v":0.05}]
["Vertical Fenestration Alternates:",null,null,null,null,null,{"$f":"'TA1'!A28","v":"None Selected on ENV-SUM"}]
[]
[null,null,null,null,null,null,null,"User Note"]
[]
["  Skylights",null,null,null,null,"Proposed SHGC",null,"Target SHGC"]
["Sch. ID ","Provide SHGC source and fenestration schedule ID",null,null,"SHGC","x Area (A)","= SHGC x A","SHGC","x Area (A) =","SHGC x A"]
[null,null,null,null,null,null,{"$f":"IF(AND(F14=0,E14=0),0,IF(OR(F14=0,E14=0),NA(),F14*E14))","v":0},{"$f":"'TA1'!AA127","v":0.32},{"$f":"'Target Area Adjustments'!J88","v":0},{"$f":"IF(TYPE(H14*I14)<>1,0,H14*I14)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(F15=0,E15=0),0,IF(OR(F15=0,E15=0),NA(),F15*E15))","v":0},"SHGC",null,{"$f":"'TA1'!AA156","v":"0.32"}]
[null,null,null,null,null,null,{"$f":"IF(AND(F16=0,E16=0),0,IF(OR(F16=0,E16=0),NA(),F16*E16))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(F17=0,E17=0),0,IF(OR(F17=0,E17=0),NA(),F17*E17))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(F18=0,E18=0),0,IF(OR(F18=0,E18=0),NA(),F18*E18))","v":0},null,null,null,null,null,0]
[null,null,null,null,"Skylight Totals",{"$f":"SUM(F13:F18)","v":0},{"$f":"SUM(G13:G18)","v":0},null,{"$f":"SUM(I13:I18)","v":0},{"$f":"SUM(J13:J18)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(F19-'Target Area Adjustments'!F69)>0.1,IF(F19>'Target Area Adjustments'!F69,CONCATENATE(\"More proposed skylight area here than ENV-UA - Remove  \",TEXT(F19-'Target Area Adjustments'!F69,\"0.0\")),CONCATENATE(\"Less proposed skylight area here than ENV-UA - Add  \",TEXT('Target Area Adjustments'!F69-F19,\"0.0\" )) ),\" \")","v":" "}]
[]
[" All Non-North Vertical Fenestration+",null,null,null,"Proposed SHGC",null,"PF Category","Target SHGC ++"]
["Sch. ID ","Provide SHGC source and fenestration schedule ID","PF","SHGC","x Area (A)","= SHGC x A",null,"SHGC","x Area (A) =","SHGC x A"]
[null,null,null,null,null,{"$f":"IF(AND(E25=0,D25=0),0,IF(OR(E25=0,D25=0),NA(),E25*D25))","v":0},"PF < 0.2",{"$f":"'TA1'!AA124","v":0.35},{"$f":"'Target Area Adjustments'!J54","v":0},{"$f":"IF(TYPE(H25*I25)<>1,0,H25*I25)","v":0}]
[null,null,null,null,null,0,"0.2≤PF<0.5",{"$f":"'TA1'!AA125","v":0.45},{"$f":"'Target Area Adjustments'!J55","v":0},{"$f":"IF(TYPE(H26*I26)<>1,0,H26*I26)","v":0}]
[null,null,null,null,null,0,"PF ≥ 0.5",{"$f":"'TA1'!AA126","v":0.6},{"$f":"'Target Area Adjustments'!J56","v":0},{"$f":"IF(TYPE(H27*I27)<>1,0,H27*I27)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,"Non-North Window Totals",{"$f":"SUM(E24:E34)","v":0},{"$f":"SUM(F24:F34)","v":0},null,null,{"$f":"SUM(I24:I34)","v":0},{"$f":"SUM(J24:J34)","v":0}]
[]
[]
[]
["  North Vertical Fenestration+",null,null,null,"Proposed SHGC",null,"PF Category","Target SHGC++"]
["Sch. ID ","Provide SHGC source and fenestration schedule ID","PF","SHGC","x Area (A)","= SHGC x A",null,"SHGC","x Area (A) =","SHGC x A"]
[null,null,null,null,null,{"$f":"IF(AND(E41=0,D41=0),0,IF(OR(E41=0,D41=0),NA(),E41*D41))","v":0},"PF < 0.2",{"$f":"'TA1'!AA128","v":0.53},{"$f":"'Target Area Adjustments'!J58","v":0},{"$f":"IF(TYPE(H41*I41)<>1,0,H41*I41)","v":0}]
[null,null,null,null,null,0,"0.2≤PF<0.5",{"$f":"'TA1'!AA129","v":0.57999999999999996},{"$f":"'Target Area Adjustments'!J59","v":0},{"$f":"IF(TYPE(H42*I42)<>1,0,H42*I42)","v":0}]
[null,null,null,null,null,0,"PF ≥ 0.5",{"$f":"'TA1'!AA130","v":0.64},{"$f":"'Target Area Adjustments'!J60","v":0},{"$f":"IF(TYPE(H43*I43)<>1,0,H43*I43)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"IF(AND(E46=0,D46=0),0,IF(OR(E46=0,D46=0),NA(),E46*D46))","v":0},null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,0,0]
[null,null,null,"North Window Totals",{"$f":"SUM(E40:E47)","v":0},{"$f":"SUM(F40:F47)","v":0},{"$f":"SUM(G40:G47)","v":0},null,{"$f":"SUM(I40:I47)","v":0},{"$f":"SUM(J40:J47)","v":0}]
[null,{"$f":"'ENV-UA'!D110","v":""}]
[null,null,null,null,null,"Area","SHGC x A",null,"Area","SHGC x A"]
[null,null,null,null,"Total (Skylight + Window)",{"$f":"F19+E35+E48","v":0},{"$f":"G19+F35+F48","v":0},null,{"$f":"I19+I35+I48","v":0},{"$f":"J19+J35+J48","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS((E35+E48)-'Target Area Adjustments'!F12)>0.1,IF((E35+E48)>'Target Area Adjustments'!F12,CONCATENATE(\"More proposed vertical fenestration here than ENV-UA - Remove  \",TEXT((E35+E48)-'Target Area Adjustments'!F12,\"0.0\")),CONCATENATE(\"Less proposed vertical fenestration here than ENV-UA: Add  \",TEXT('Target Area Adjustments'!F12-(E35+E48),\"0.0\" )) ),\"\")","v":""}]
["Component Performance Compliance (SHGC)",null,null,null,null,null,null,null,null,{"$f":"IF(CompliancePath<>2,\"Component Performance Compliance Not Selected\",IF(AND(J53=\"\",G51>0,J51>0),IF(G51>J51+0.00001,\"SHGC DOES NOT COMPLY\",\"SHGC COMPLIES\"),\"\"))","v":"Component Performance Compliance Not Selected"}]

{"sheet":"ENV-CHK","index":9,"n_rows":126,"n_cols":6,"rows_kept":126,"cut":false,"hidden":false,"merged":[[12,7,14,7],[20,0,21,0],[20,1,21,1],[20,2,21,2],[16,2,17,2],[16,0,17,0],[16,1,17,1],[12,0,14,0],[12,1,14,1],[12,2,14,2],[93,1,96,1],[84,1,85,1],[29,0,34,0],[29,1,34,1],[29,2,34,2],[70,1,74,1],[70,2,74,2],[40,0,42,0],[40,2,42,2],[51,2,54,2],[61,2,63,2],[55,2,56,2],[51,1,54,1],[51,0,54,0],[70,0,74,0],[43,0,45,0],[86,2,87,2],[86,1,87,1],[82,2,83,2],[80,0,81,0],[119,0,119,5],[104,2,105,2],[93,2,96,2],[89,0,92,0],[89,1,92,1],[89,2,92,2],[104,0,105,0],[104,1,105,1],[84,0,85,0],[82,0,83,0],[86,0,87,0],[93,0,96,0],[80,1,81,1],[80,2,81,2],[84,2,85,2],[82,1,83,1],[78,0,79,0],[3,0,3,5],[78,2,79,2],[22,0,27,0],[46,2,48,2],[46,1,48,1],[22,1,27,1],[22,2,27,2],[40,1,42,1],[78,1,79,1],[55,0,56,0],[61,0,63,0],[46,0,48,0],[61,1,63,1],[55,1,56,1],[43,1,45,1],[43,2,45,2]]}
["Building Permit Plans Checklist, pg. 1",null,null,null,null,"ENV-CHK"]
[{"$f":"ReadMe!A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Aug 2019"}]
["Project Title:",null,{"$f":"IF('PROJ-SUM'!$D$3=\"1 - This title will copy onto other forms\",\"1 - Fill this line out on PROJ-SUM\",'PROJ-SUM'!$D$3)","v":"1 - Fill this line out on PROJ-SUM"},null,"Date",{"$f":"'ENV-SUM'!G3","v":"01/01/2019"}]
["The following information is necessary to check a building permit application for compliance with the building envelope requirements in the Seattle Energy Code, Commercial Provisions."]
["Applicability\n(yes,no,na)","Code Section","Component","Compliance information required in permit documents","Location in Documents","SDCI Notes"]
["SCOPE "]
[null,"C402.1.1","Low energy spaces","Low energy spaces are identified on plans; include project information, and calculations if applicable, that demonstrate spaces are eligible for envelope provisions exemption"]
[null,"C402.1.1.1","Semi-heated spaces","Semi-heated spaces are identified on plans, include calculations that demonstrate spaces are eligible for wall insulation exemption"]
[null,"C402.1.2","Equipment Buildings","Provide building area, average wall and roof U-factor, and installed equipment information that demonstrates equipment building is eligible for envelope provision exemption"]
[null,"C410.2","Walk-in and warehouse cooler and freezer spaces","Cooler and freezer spaces are identified on plans; C410 envelope compliance forms provided (pending)"]
[null,"C101.4.1","Mixed occupancy","Identify boundaries of spaces with different occupancy requirements on plans"]
[null,"C503.2","Change of space conditioning","Identify on plans existing unconditioned spaces changing to semi-heated or conditioned space, and existing semi-heated spaces changing to conditioned space; also identify heated but not cooled space larger than 2000 SF changing to both heated and cooled; provide calculations for existing and final level of space conditioning, and calculations that demonstrate alteration complies with current SEC"]
[null,"C505.1","Change of occupancy","Identify on plans existing F, S and U-occupancy spaces undergoing a change in occupancy; provide calculations that demonstrate alteration complies with the current SEC","."]
[null,null,null,"Identify on plans pre-2002 Group R spaces undergoing a change to a commercial occupancy; provide calculations that demonstrate alteration complies with the current SEC"]
[null,null,null,"Identify on plans non-Group R occupancy spaces undergoing a change to Group R; provide calculations that demonstrate alteration complies with the current SEC"]
["ENVELOPE PROVISIONS"]
[null,"C103.2\nC103.6.3","Compliance documentation","Indicate envelope insulation compliance path and provide applicable forms; ENV-PRESCRIPTIVE or ENV-UA / ENV-SHGC for component performance"]
[null,null,null,"If complying via total building performance, provide a list of all proposed envelope component types, areas and U-values"]
[null,"C303.1.1\nC303.1.2","Insulation identification","Indicate identification mark shall be applied to all insulation materials and insulation installed such that the mark is readily observable during inspection"]
[null,"C303.1.3\nC402.4.3","Fenestration product rating","Fenestration products shall be labeled with rated U-factor, SHGC, VT, and  leakage rating"]
[null,"C303.1.1\nC402.2.1","General insulation installation","Indicate installation methods, thicknesses, densities and clearances to achieve the intended R-value of all insulation materials; "]
[null,null,null,"Where two or more layers of rigid insulation will be used, indicate that edge joints between layers are staggered"]
[null,"C103.2 C402.2.2","Roof assembly insulation","Indicate R-value(s) of cavity/continuous insulation on roof sections;  "]
[null,null,null,"Indicate framing materials on roof sections; "]
[null,null,null,"Indicate method of framing for ceilings below vented attics and vaulted ceilings per A102.2 (std, adv);"]
[null,null,null,"Provide area weighted average U-factor calculation for insulation whose thickness varies by 1 inch or less;"]
[null,null,null,"Indicate effective U-factors of tapered insulation entirely above deck per A102.2.6; include roof configuration and slope, maximum R-value at peak and minimum R-value at low point for all roof surfaces"]
[null,null,null,"Indicate R-values for thermal spacers and each insulation layer, and liner system (LS) method for metal building roofs"]
[null,"C402.2.2","Skylight curb insulation","Indicate curb insulation R-value on roof section if not included in skylight NFRC rating"]
[null,"C103.2\nC402.2.3\nC402.2.4\nC303.2.1","Above/below grade wall insulation","Indicate R-value(s) of cavity/continuous insulation on wall sections;  "]
[null,null,null,"Indicate framing materials on wall sections; "]
[null,null,null,"Indicate method of framing for wood const per A103.2 (std, int, adv);"]
[null,null,null,"Indicate material density category, wall weight and heat capacity for qualifying mass walls; "]
[null,null,null,"For qualifying ASTM C90 masonry walls, indicate loose-fill core insulation material and percentage of cores filled including grouted cores, bond beams, vertical fills, headers and any other grouted cores;"]
[null,null,null,"Indicate method of protection of exposed exterior basement/crawlspace wall insulation"]
["Building Permit Plans Checklist, pg. 2",null,null,null,null,"ENV-CHK"]
[{"$f":"A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "}]
["Project Title:",null,{"$f":"IF('ENV-SUM'!$C$3=\"1 - This address line will copy onto other forms\",\"1 - Fill this line out on ENV-SUM\",'ENV-SUM'!$C$3)","v":"1 - Fill this line out on PROJ-SUM"},null,"Date",{"$f":"F3","v":"01/01/2019"}]
["Applicability (yes,no,na) ","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
[null,"C103.2\nC402.4.4","Opaque doors","Indicate rated U-factor (swinging) or R-value (non-swinging - roll-up/sliding) on wall sections or in door schedules - applies to doors with less than 50% glazed area"]
[null,"C402.2.5","Floor over outdoor or unconditioned space insulation ","Indicate R-value(s) of cavity/continuous insulation on floor sections;"]
[null,null,null,"Indicate framing material on floor sections;"]
[null,null,null,"Indicate material density category and weight of qualifying mass floors"]
[null,"C402.2.6\nC303.2.1","Slab-on-grade floor insulation","Indicate R-value of continuous insulation on wall section or foundation detail;"]
[null,null,null,"Indicate insulation extends down vertically and/or horizontally the required distance from top of slab;"]
[null,null,null,"Indicate method of protection of exposed exterior slab edge insulation"]
[null,"C402.2.6\nC303.2.1","Radiantly heated slab-on-grade floor insulation ","Indicate R-value of continuous insulation on wall section or foundation detail;"]
[null,null,null,"Indicate insulation extends down vertically from top of slab and then horizontally under the entire slab;"]
[null,null,null,"Indicate method of protection of exposed exterior slab edge insulation"]
[null,"C402.2.8","Radiant heating system insulation","Indicate insulation R-value behind radiant panels, U-bend/headers and bottom surface of radiantly heated floors (other than radiantly heated slab-on-grade) "]
[null,"C402.4.1\nC502.2.1\nC503.3.2","Vertical fenestration maximum area","Provide calculation for total vertical fenestration area as a percentage of gross above grade wall area (WWR) for new construction, additions and alterations in ENV-SUM"]
[null,"C402.4.1.1\nC405.2.4.1\nC502.2.1\nC503.3.2","Increased prescriptive maximum vertical fenestration area with daylight zones and controls","Provide calculations showing that the percentage of overall conditioned floor area within daylight zones is equal to or greater than 50% in 1 & 2 story buildings: OR"]
[null,null,null,"Provide calculations showing that the percentage of overall net floor area within daylight zones is equal to or greater than 25% in buildings 3 stories or more; include the gross floor area and list of spaces omitted for the net floor area;"]
[null,null,null,"Note in envelope plans that all lighting fixtures located within daylight zones shall be provided with daylight responsive controls per SEC Section C405.2.4.1; indicate method of control in lighting fixture schedules"]
[null,null,null,"Indicate that the VT of vertical fenestration is at least 1.1 times the rated SHGC"]
[null,"C402.4.1.3\nC502.2.1\nC503.3.2","Increased prescriptive maximum vertical fenestration area with high-performance glazing","Indicate high performance U-factors and SHGC values in fenestration schedules; "]
[null,null,null,"Indicate if an area-weighted U-factor is used for multiple fenestration elements within the same fenestration category per Table C402.3; provide U-factor calculations"]
[null,"C402.4.1.4\nC403.6","Increased prescriptive maximum vertical fenestration area with DOAS mechanical systems","Indicate that for eligibility, all occupied, conditioned spaces will be served by a dedicated outside air system (DOAS) that delivers ventilation air without requiring operation of the heating/cooling system per Section C403.6"]
[null,"C402.1.5","Wall/vertical fenestration target area adjustment","Indicate if component performance with target area adjustment will be used to account for vertical fenestration area in excess of the prescriptive maximum allowed"]
[null,"C402.4.1\nC502.2.2\nC503.3.3","Skylight maximum area","Provide calculation for total skylight area as a percentage of gross roof area (SRR) for new construction, additions and alterations in ENV-SUM"]
[null,"C402.1.5.2","Roof/skylight target area adjustment","Indicate if component performance with target area adjustment will be used to account for skylight area in excess of the prescriptive maximum allowed"]
[null,"C402.4.3\nC303.1.3","U-factors, SHGC and VT for all fenestration assemblies","Indicate U-factors, SHGC and VT values in fenestration schedules;"]
[null,null,null,"Indicate if an area-weighted U-factor is used for multiple fenestration elements within the same fenestration category per Table C402.3; provide U-factor calculations"]
[null,null,null,"Indicate if values are NFRC or default; if default then specify frame type, glazing layers, gap width, low-e coatings, gas-fill"]
[null,"C402.4","HVAC Heating Energy Type","Indicate HVAC Heating Energy Type for each calculation area.  After 1/1/2018 provide description and calculation for any exceptions utilized"]
[null,"C402.4.3","Permanent shading devices","For windows with overhangs or permanent projection shading devices, provide projection factor calculations (Equation C4-6) and associated minimum SHGC for north and non-north orientations"]
["Building Permit Plans Checklist, pg. 3",null,null,null,null,"ENV-CHK"]
[{"$f":"A2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "}]
["Project Title:",null,{"$f":"IF('ENV-SUM'!$C$3=\"1 - This address line will copy onto other forms\",\"1 - Fill this line out on ENV-SUM\",'ENV-SUM'!$C$3)","v":"1 - Fill this line out on PROJ-SUM"},null,"Date",{"$f":"F34","v":"00:00:00"}]
["Applicability (yes,no,na) ","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
[null,"C402.4.2","Spaces in single story buildings requiring skylights","In single story buildings, provide list of enclosed spaces that exceed 2,500 sf; for each space identify the space use, floor area, floor-to-ceiling height, whether skylights are installed or exception taken;"]
[null,null,null,"For each space requiring skylights, provide calculation of percentage of conditioned floor area located within a top daylight zone;"]
[null,null,null,"For each space requiring skylights, calculate the ratio of skylight area to toplight daylight zone area; min 3%, OR;"]
[null,null,null,"Calculate skylight effective aperture (Equation C4-5) within the top daylight zone; min. 1%"]
[null,null,null,"Indicate haze factor of skylight glazing material or diffuser"]
["ADDITIONAL EFFICIENCY PACKAGE OPTION - ENHANCED ENVELOPE PERFORMANCE"]
[null,"C406.8","Enhanced envelope performance","To comply with additional efficiency package option, demonstrate envelope insulation compliance via component performance; provide ENV-UA / ENV-SHGC compliance forms; verify that building total UA is 15% lower than the Code target UA"]
["AIR LEAKAGE"]
[null,"C402.5.1.1","Air barrier construction and sealing","Identify location and provide diagram of continuous air barrier in plans and sections;"]
[null,null,null,"Provide details for all joints, transitions in materials, penetrations in air barrier and note method of sealing (caulked, gasketed, or other approved method)  "]
[null,"C402.5.3","Rooms containing open combustion fuel burning appliances used for space conditioning","Indicate that room(s) containing non-direct vent appliances is isolated from conditioned space by the thermal envelope with a sealed air barrier, including doorway gasketing and sealing around ductwork and piping penetrations;"]
[null,null,null,"Indicate insulation provided in wall, floor and ceiling of the room envelope, and insulation required on combustion air ductwork"]
[null,"C402.5.4","Access openings and doors to shafts, chutes, stairways and doors","Indicate locations of all access openings and doors to shafts, chutes, stairways and elevators;"]
[null,null,null,"Indicate method of gasketing, weatherstripping and sealing of these openings"]
[null,"C402.5.5\nC403.2.4.3","Outdoor air intakes, exhausts and relief openings","Indicate locations of all stairway enclosure, elevator shaft and building pressurization relief openings, outside air intakes and exhaust openings;"]
[null,null,null,"Note in envelope plans that all relief, outside air intake and exhaust openings shall be provided with dampers in accordance with Mechanical Section C403.2.4.3"]
[null,"C402.5.8","Recessed lighting in building envelope ","Indicate method of sealing between light fixture housing and wall or ceiling;"]
[null,null,null,"Note in envelope plans that all recessed lighting fixtures shall be IC rated and have an air leakage rating not greater than 2 cfm per ASTM E283 test; include these requirements in lighting fixture schedules"]
[null,"C402.5.6","Loading dock seals","Indicate weather seal at cargo and loading dock doors"]
[null,"C402.5.7","Vestibules","Indicate locations and dimensions of vestibules and air curtains;"]
[null,null,null,"Indicate exception and criteria utilized for all building entrances and exits that do not have a vestibule or air curtain;"]
[null,null,null,"Indicate required performance for air curtains installed per exception 7;"]
[null,null,null,"For unconditioned vestibules, indicate which envelope assembly (interior or exterior) complies with the requirements for a conditioned space"]
[null,"C103.2\nC402.5.1.2","Building air leakage test","Indicate on plans the location of air barrier boundaries and area calculations on all six sides of the air barrier;"]
[null,null,null,"Indicate air barrier test method in accordance with ASTM E779 or approved equivalent; "]
[null,null,null,"Indicate required maximum leakage rate for compliance."]
[null,null,null,"Include the following requirements in project documents: (1) Submit air barrier test report to jurisdiction once test is completed; (2) If test results exceed 0.30 cfm/ft2 at 0.3 in. wg (1.5 L/s X m2 at 75 Pa), then visually inspect air barrier and seal noted sources of leakage and submit a follow-up report to jurisdiction noting corrective measures taken;  (3) Include air barrier test report in compliance documentation provided to owner."]
["Building Permit Plans Checklist, pg. 4",null,null,null,null,"ENV-CHK"]
[{"$f":"$A$2","v":"2015 Seattle Energy Code Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"F2","v":"Revised Aug 2019"}]
["Project Title:",null,{"$f":"C3","v":"1 - Fill this line out on PROJ-SUM"},null,"Date",{"$f":"F3","v":"01/01/2019"}]
["Applicability (yes,no,na) ","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
["ADDITIONAL EFFICIENCY PACKAGE OPTION - REDUCED AIR INFILTRATION"]
[null,"C406.9","Reduced air infiltration","If option C406.9 is selected, indicate in project documents that the air barrier test results shall not exceed 0.25 cfm/ft2 (1.27 L/s*m2) for Group R buildings, and 0.22 cfm/ft2 (1.11 L/s*m2) for all others, at 0.3 in. wg (75 Pa); indicate air barrier test report shall be submitted to the jurisdiction and building owner once test is completed"]
["ALTERATIONS"]
[null,"C503.1\nC503.3.1","Roof alteration - insulation","For a roof alteration where existing ceiling cavities are exposed, indicate cavities are insulated to full depth at R-3 per inch"]
[null,null,null,"For a roof covering replacement where insulation is installed entirely above the roof deck, indicate insulation complies with requirements for new construction per Tables C402.1.3 or C402.1.4"]
[null,"C503.1","Wall and floor  alteration - insulation","For a wall or floor alteration (floor over outdoor or unconditioned space) where existing envelope cavities are exposed, indicate cavities are insulated to full depth at R-3 per inch"]
[null,"C503.3.2","Addition of vertical fenestration","Where the addition of new vertical fenestration results in total building window-to-wall ratio (WWR) exceeding the maximum allowed per C402.4.1, demonstrate method of compliance (vertical fenestration alternate per C503.3.2, or component performance compliance with target area adjustment for the total building)"]
[null,"C503.3.3","Addition of skylights","Where the addition of new skylights results in total building skylight-to-roof ratio (SRR) exceeding the maximum allowed per C402.4.1, demonstrate component performance compliance with target area adjustment for the total building"]
["PROJECT CLOSE OUT DOCUMENTATION"]
[null,"C103.6.3","Project close out documentation requirements","Indicate in plans that project close out documentation is required including applicable WSEC envelope compliance forms and calculations, and fenestration NFRC rating certificates "]
["If \"no\" is selected for any question, provide explanation:  "]
[]
[]
[]
["r"]
[]
[]
[]
["End of Building Permit Plans Checklist"]
[]
[]
[]
["na"]
["no"]
["yes"]