{"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":127,"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":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,0,1,1],[5,0,6,0],[8,0,9,0],[12,0,18,0],[42,0,42,1],[26,0,26,1],[28,0,29,0],[30,0,31,0],[35,0,38,0],[39,0,41,0],[32,0,33,0]]}
["Instructions for Electronic Forms, pg 1"]
["2015 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "]
[null,"Revised Oct 2017"]
[null,"     Commercial Provision Chapters 1 - 5 of the 2015 Washington State 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, ENV15-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 and 5b. There are two companion files: LTG15-v4.XLSM (Section C405 lighting and electrical systems), and MECH15-v4.XLSM (Section C403 and C404 mechanical and service water systems). "]
["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 local jurisdiction for complete information. The full 2015 WSEC code text is available for download from the NEEC website:"]
[null,"http:/www.neec.net/energy-codes"]
["Start-up","Select this file from the NEEC website to download to your computer.  When opening the file be sure to Enable Macros. "]
["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 17) to enable the forms."]
["Compliance Path","    You must select a Compliance Path on ENV-SUM (line 18) 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 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "}]
[null,{"$f":"B3","v":"Revised Oct 2017"}]
["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 34-39 of the ENV-SUM form. This will re-calculate the prescriptive target area in the ENV-SUM and ENV-UA forms based on 40%. "]
["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 19 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 19 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 ","     NEEC does not recommend completing these compliance forms by hand. Most worksheets run various calculations and compliance checks. For this reason, many jurisdictions do not accept these forms if not completed electronically. Verify with your jurisdiction prior to submitting forms completed by hand."]
[null,"    To print blank forms to fill out by hand, delete all of the heading information at the beginning of ENV-SUM and select the desired Occupancy Group."]
[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":[[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[42,0,42,1],[17,4,17,5],[16,4,16,5],[19,0,19,1],[13,0,14,1],[16,0,17,1],[31,0,40,1],[29,1,29,2]]}
["Project Summary, pg 1",null,null,null,null,"PROJ-SUM"]
[{"$f":"ReadMe!A2","v":"2015 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Oct 2017"}]
["General Info","Project Title:",null,"1 - This title will copy onto other forms","Date","2017-01-01"]
[null,"Project Street Address:",null,null,"For Building Department 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]
[]
["Space Conditioning Categories"]
[]
[]
["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 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"F2","v":"Revised Oct 2017"}]
["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":"2017-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":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[46,0,46,1],[48,2,48,3],[2,2,2,4],[39,0,39,1],[3,2,3,4],[4,2,4,4],[5,2,5,4],[7,2,7,4],[33,0,33,1],[6,2,6,4],[35,2,35,6],[20,0,20,1],[31,0,31,1],[36,2,36,3],[37,2,37,3],[11,0,11,1],[12,0,12,1],[18,0,18,1],[32,0,32,1],[31,2,31,6],[32,2,32,6]]}
["Envelope Summary",null,null,null,null,null,"ENV-SUM"]
[{"$f":"ReadMe!A2","v":"2015 WSEC 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 Oct 2017"}]
["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/2017"}]
[null,"Company Name:",null,null,null,"For Building Department Use"]
[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"]
["Additions"]
["Alterations - \nFenestration and Skylight"]
[]
["Envelope Summary, pg. 2",null,null,null,null,null,"ENV-SUM"]
[{"$f":"A2","v":"2015 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,null,{"$f":"G2","v":"Revised Oct 2017"}]
["Project Title:",{"$f":"C3","v":"1 - Fill this line out on PROJ-SUM"},null,null,null,"Date",{"$f":"G3","v":"01/01/2017"}]
[]
[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(D29),ISNUMBER(D28)),D28+D29,\"\")","v":""},{"$f":"IF(OR(ISNUMBER(E29),ISNUMBER(E28)),E28+E29,\"\")","v":""},{"$f":"IF(OR(ISNUMBER(F29),ISNUMBER(F28)),F28+F29,\"\")","v":""},{"$f":"IF(OR(ISNUMBER(G29),ISNUMBER(G28)),G28+G29,\"\")","v":""}]
[null,null,null,"Vertical Fenestration-to-Wall Ratio (WWR)",{"$f":"IF(SUM(D28:E29)>0,IF(SUM(E28:E29)>0,SUM(D28:D29)/SUM(D28:E29),\"Enter wall area\"),\"\")","v":""},"Skylight-to-Roof Ratio (SRR)",{"$f":"IF(SUM(F28:G29)>0,IF(SUM(G28:G29)>0,SUM(F28:F29)/SUM(F28:G29),\"Enter roof area\"),\"\")","v":""}]
["   Vertical Fenestration Area Compliance",null,{"$f":"IF(AND(CompliancePath<>3,ISNUMBER(E31)),\n  IF(E31=0,\"NO VERTICAL FENESTRATION PROPOSED. COMPLIES WITH MAXIMUM ALLOWANCE.\",\n   IF(AND(OR(Addition,Alteration), hpmwin ),\"\",IF(E31<=0.3,\"VERTICAL FENESTRATION AREA COMPLIES WITH MAXIMUM ALLOWANCE\",\n     IF(E31<=0.4,\n        IF(OR(dlz25pct,dlz50pct,hpfwin,hpmwin),\"VERTICAL FENESTRATION AREA COMPLIES WITH MAXIMUM ALLOWED WITH FENESTRATION ALTERNATE\",\n        IF(CompliancePath=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(CompliancePath=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(CompliancePath=1,\"Project exceeds maximum vertical fenestration area allowed for Prescriptive compliance.  Comply via Component Performance with Target Area Adjustment.\",\n     IF(CompliancePath=2,\"Project exceeds maximum target vertical fenestration area.  Target area adjustment applied to UA calculation.\",\n     \"\")))))),\"\")","v":""}]
["   Skylight Area Compliance",null,{"$f":"IF(AND(CompliancePath<>3,ISNUMBER(G31)),\n     IF(G31>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(CompliancePath=2,\n                       \"Project exceeds target skylight area.  Target area adjustment applied to UA calculation.\",\n               \"\")),\nIF(G31>0,\"SKYLIGHT AREA COMPLIES WITH MAXIMUM ALLOWANCE\",\"NO SKYLIGHT PROPOSED. COMPILIES WITH MAXIMUM ALLOWANCE.\")),\"\")","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(C38>0,SUM(E38:F38)/C38,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(dlz50pct,IF(AND(C38>0,G38>0),IF(G38>=0.5,\"Qualifies for Daylight Zone Alternate\",\"Does Not Qualify for Daylight Zone Alternate\"),\"\"),IF(dlz25pct,IF(AND(C38>0,G38>0),IF(G38>=0.25,\"Qualifies for Daylight Zone Alternate\",\"Does Not Qualify for Daylight Zone Alternate\"),\"\"),\"\"))","v":""}]
["Spaces in Single Story Building Requiring Skylights"]
[null,null,"Space ","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)"]

{"sheet":"ENV-REQUIREMENTS","index":3,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[[14,2,14,3],[56,0,56,1],[61,0,61,1],[97,0,97,5],[39,2,39,3],[39,4,39,5],[41,0,41,1],[41,2,41,3],[41,4,41,5],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[47,2,47,3],[48,0,48,5],[53,2,53,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[30,0,30,1],[30,2,30,5],[31,2,31,5],[36,0,36,1],[38,0,38,1],[42,0,42,5],[38,2,38,5],[40,0,40,1],[40,2,40,3],[40,4,40,5],[29,0,29,1],[18,0,18,1],[18,2,18,3],[18,4,18,5],[19,0,19,1],[23,0,23,1],[24,2,24,3],[25,2,25,3],[26,0,26,1],[26,2,26,5],[27,2,27,3],[29,2,29,3],[29,4,29,5],[12,0,12,1],[4,2,4,3],[4,4,4,5],[6,0,6,1],[6,2,6,5],[7,0,7,1],[53,4,53,5],[47,4,47,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,4,52,5]]}
["Envelope Requirements Summary, pg 1",null,null,null,null,"ENV-REQ"]
[{"$f":"ReadMe!A2","v":"2015 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Oct 2017"}]
["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-11 Ls","R-25 + R-11 Ls","U-0.031","U-0.031"]
[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","R-9.5 c.i. Note 6","R-13.3 c.i.","U-0.104 Note 6","U-0.078"]
[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.","R-19 c.i.","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-21 w/ int. frame","R-21 w/ int. frame","U-0.054","U-0.054"]
["Below Grade Wall Note 4",null,"Same as above grade",null,"Same as above grade"]
["Floors"]
[null,"Mass","R-30 c.i.","R-30 c.i.","U-0.031","U-0.031"]
[null,"Steel Joist","R-38 + R-10 c.i.","R-38 + R-10 c.i.","U-0.029","U-0.029"]
[null,"Wood Framed and Other","R-30","R-30","U-0.029","U-0.029"]
["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"]
[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.4.1.3 High Performance Fenestration Option - 0-40% of wall area"]
["Fenestration ",null,"Assembly Maximum U-factor Notes 1,2"]
["Vertical Fenestration"]
[null,"Nonmetal framing ","U-0.30","U-0.30","U-0.28","U-0.28"]
[null,"Metal framing (fixed)","U-0.38","U-0.38","U-0.34","U-0.34"]
[null,"Metal framing (operable)","U-0.40","U-0.40","U-0.36","U-0.36"]
[null,"Entrance doors","U-0.60","U-0.60","U-0.60","U-0.60"]
["Skylights"]
[null,"Skylights","U-0.50","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.4\n0.2 ≤ PF < 0.5: north - SHGC-0.58; \nall other - SHGC-0.48\nPF ≥ 0.5: all orientations - SHGC-0.64",null,"PF<0.2: north - SHGC=0.46; \nall other SHGC=0.35\n0.2 ≤ PF < 0.5: north - SHGC-0.51; \nall other - SHGC-0.42\nPF ≥ 0.5: all orientations - SHGC-0.56"]
["Skylights",null,"SHGC-0.35",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, pg 2 ",null,null,null,null,"ENV-REQ"]
[{"$f":"A2","v":"2015 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"F2","v":"Revised Oct 2017"}]
["Definitions:"]
[]
[]
[]
[]
["Footnote Summary:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," Alternate continuous insulation nominal R-values"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End of Envelope Requirements Summary"]

{"sheet":"ENV-PRESCRIPTIVE","index":4,"n_rows":156,"n_cols":13,"rows_kept":156,"cut":false,"hidden":false,"merged":[[111,3,111,5],[111,6,111,7],[9,3,9,5],[9,6,9,7],[64,3,64,5],[64,6,64,7],[79,3,79,5],[79,6,79,7]]}
["Prescriptive Path, pg. 1",null,null,null,null,null,null,"ENV-PRESCRIPTIVE"]
[{"$f":"'ENV-SUM'!A2","v":"2015 WSEC 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 Oct 2017"}]
[{"$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/2017"}]
["Target Insulation Allowance",null,null,null,null,null,"For Building Department Use"]
[null,null,{"$f":"IF(CompliancePath<>1,\"    Prescriptive Compliance 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 16 for instructions\",IF(CalcType=4,\"    Refrigerated Freezer - See note 17 for instructions\",\"\")))))","v":"    Prescriptive Compliance Not Selected"}]
["Fenestration Area as % gross above-grade wall area",null,null,{"$f":"IF('ENV-SUM'!E31>0,'ENV-SUM'!E31,0)","v":""},"Max. Target:",{"$f":"'Target Area Adjustments'!D14","v":0.3}]
["Skylight Area as % gross roof area",null,null,{"$f":"IF('ENV-SUM'!G31>0,'ENV-SUM'!G31,0)","v":""},"Max. Target:",{"$f":"'Target Area Adjustments'!D66","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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Prescriptive Path, pg. 2",null,null,null,null,null,null,"ENV-PRESCRIPTIVE"]
[{"$f":"A2","v":"2015 WSEC 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 Oct 2017"}]
[{"$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/2017"}]
["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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Insulation is required under the entire freezer floor. If the freezer floor assembly rests on top of a standard floor, the vertical edge of the freezer floor shall be entered as and comply with the requirements for a freezer wall. If freezer floor insulation is installed as integral to or applied underneath a slab-on-grade or exposed floor, this floor shall be thermally broken from the surrounding floor area with the same amount of insulation as required for a freezer floor. Enter proposed thermal break information in the Freezer Floor section and note it as In-Floor Thermal Break. "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["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,"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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cooler"]
[null,"Freezer"]
[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":147,"n_cols":15,"rows_kept":147,"cut":false,"hidden":false,"merged":[[10,9,11,9],[10,10,11,11],[122,10,122,11],[123,10,123,11],[117,10,117,11],[118,10,118,11],[119,10,119,11],[120,10,120,11],[121,10,121,11],[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],[92,2,92,4],[81,2,81,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],[80,2,80,4],[75,2,75,4],[76,2,76,4],[77,2,77,4],[79,2,79,4],[78,2,78,4]]}
["Component Performance Path, pg. 1",null,null,null,null,null,null,null,null,null,null,"ENV-UA"]
[{"$f":"'ENV-SUM'!A2","v":"2015 WSEC 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 Oct 2017"}]
[{"$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/2017"}]
["Target Insulation Allowance",null,null,null,null,null,null,null,null,"For Building Department 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 for instructions\",IF(CalcType=4,\"Refrigerated Freezer - See note 12 for instructions\",\"\")))))","v":"Component Performance Not Selected"}]
["Calculation Adjustments"]
[null,null,null,{"$f":" IF(SemiHt,IF(ChangeofUseOrConditioning,IF(C406.8_Enhanced_Envelope,\"Proposed UA shall be at least 5% lower than Target UA excluding walls\",\"Proposed UA is allowed to be 10% higher than Target UA excluding walls\"),IF(C406.8_Enhanced_Envelope,\"Proposed UA shall be at least 15% lower than Target UA excluding walls\",\"Semi-heated space - walls excluded from proposed and target total UA\")),\nIF(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,\"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'!E31>0,'ENV-SUM'!E31,0)","v":""},"Max. Target:",{"$f":"'Target Area Adjustments'!D14","v":0.3}]
["Skylight Area as % gross roof area",null,null,null,null,null,{"$f":"IF('ENV-SUM'!G31>0,'ENV-SUM'!G31,0)","v":""},"Max. Target:",{"$f":"'Target Area Adjustments'!D66","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 "]
["Building 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'!F132","v":2.7E-2},{"$f":"'Target Area Adjustments'!J83","v":0},{"$f":"IF(J15=\"NR\",\"NR\",IF(TYPE(J15*K15)<>1,0,J15*K15))","v":0}]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G16=0,H16=0),0,IF(OR(G16=0,H16=0),NA(), H16*G16))","v":0},"Above Deck Insulation",null,{"$f":"'TA1'!F165","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,{"$f":"IF(AND(G18=0,H18=0),0,IF(OR(G18=0,H18=0),NA(), H18*G18))","v":0},{"$f":"'TA1'!F133","v":3.1E-2},{"$f":"'Target Area Adjustments'!J84","v":0},{"$f":"IF(J18=\"NR\",\"NR\",IF(TYPE(J18*K18)<>1,0,J18*K18))","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Metal Building",null,{"$f":"'TA1'!F166","v":"U-0.031"}]
[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'!F135","v":2.7E-2},{"$f":"'Target Area Adjustments'!J85","v":0},{"$f":"IF(J21=\"NR\",\"NR\",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'!F168","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'!F134","v":2.1000000000000001E-2},{"$f":"'Target Area Adjustments'!J86","v":0},{"$f":"IF(J24=\"NR\",\"NR\",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'!F167","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(), IF(SemiHt,\"NR\",H27*G27)))","v":0},{"$f":"'TA1'!F138","v":5.5E-2},{"$f":"'Target Area Adjustments'!J35","v":0},{"$f":"IF(J27=\"NR\",\"NR\",IF(TYPE(J27*K27)<>1,0,J27*K27))","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Steel/metal frame",null,{"$f":"'TA1'!F171","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'!F137","v":5.1999999999999998E-2},{"$f":"'Target Area Adjustments'!J36","v":0},{"$f":"IF(J30=\"NR\",\"NR\",IF(TYPE(J30*K30)<>1,0,J30*K30))","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Metal Building",null,{"$f":"'TA1'!F170","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'!F139","v":5.3999999999999999E-2},{"$f":"'Target Area Adjustments'!J37","v":0},{"$f":"IF(J33=\"NR\",\"NR\",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'!F172","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'!F136","v":0.104},{"$f":"'Target Area Adjustments'!J38","v":0},{"$f":"IF(J36=\"NR\",\"NR\",IF(TYPE(J36*K36)<>1,0,J36*K36))","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Mass Wall",null,{"$f":"'TA1'!F169","v":"U-0.104"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F140","v":0.2},{"$f":"'Target Area Adjustments'!J39","v":0},{"$f":"IF(J39=\"NR\",\"NR\",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'!F173","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'!G136","v":0.104},{"$f":"'Target Area Adjustments'!J40","v":0},{"$f":"IF(J42=\"NR\",\"NR\",IF(TYPE(J42*K42)<>1,0,J42*K42))","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Group R Mass Wall",null,{"$f":"'TA1'!G169","v":"U-0.078"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F148","v":0.104},{"$f":"SUM(H45:H47)","v":0},{"$f":"IF(J45=\"NR\",\"NR\",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'!F181","v":"U-0.104"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!G148","v":0.104},{"$f":"SUM(H48:H50)","v":0},{"$f":"IF(J48=\"NR\",\"NR\",IF(TYPE(J48*K48)<>1,0,J48*K48))","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Assumed to be Mass Wall",null,{"$f":"'TA1'!G181","v":"U-0.078"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G51=0,H51=0),0,IF(OR(G51=0,H51=0),NA(),H51*G51))","v":0},{"$f":"'TA1'!F142","v":3.1E-2},{"$f":"SUM(H51:H53)","v":0},{"$f":"IF(J51=\"NR\",\"NR\",IF(TYPE(J51*K51)<>1,0,J51*K51))","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Mass Floor",null,{"$f":"'TA1'!F175","v":"U-0.031"}]
[null,null,"R=",null,null,null,null,null,0,null,null,null,0]
[null,null,"R=",null,null,null,null,null,0,{"$f":"'TA1'!F143","v":2.9000000000000001E-2},{"$f":"SUM(H54:H56)","v":0},{"$f":"IF(J54=\"NR\",\"NR\",IF(TYPE(J54*K54)<>1,0,J54*K54))","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Joist/Framing",null,{"$f":"'TA1'!F176","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(H59<>K59,\"Target Area Adjusted\",\"\")","v":""},null,null,"Page 1 Subtotal ",{"$f":"SUM(H15:H56)","v":0},{"$f":"SUM(I15:I56)","v":0},null,{"$f":"SUM(K15:K56)","v":0},{"$f":"SUMIF(L15:L56,\"<>\"\"NR\",L15:L56)","v":0}]
[]
["Component Performance Compliance (UA)",null,null,null,null,null,null,null,null,null,null,{"$f":"L115","v":"Component Performance Not Selected"}]
["Component Performance Path, pg. 2",null,null,null,null,null,null,null,null,null,null,"ENV-UA"]
[{"$f":"A2","v":"2015 WSEC 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 Oct 2017"}]
[{"$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/2017"}]
["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 =","UA (U x A)"]
[null,null,"R=",null,null,null,null,null,{"$f":"IF(AND(G70=0,H70=0),0,IF(OR(G70=0,H70=0),NA(), H70*G70))","v":0},{"$f":"'TA1'!F146","v":0.54},{"$f":"SUM(H70:H72)","v":0},{"$f":"IF(TYPE(J70*K70)<>1,0,J70*K70)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Slab-On-Grade",null,{"$f":"'TA1'!F179","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'!F147","v":0.55000000000000004},{"$f":"SUM(H73:H75)","v":0},{"$f":"IF(TYPE(J73*K73)<>1,0,J73*K73)","v":0}]
[null,null,"R=",null,null,null,null,null,0,"Heated Slab-On-Grade",null,{"$f":"'TA1'!F180","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(G77=0,H77=0),0,IF(OR(G77=0,H77=0),NA(), H77*G77))","v":0},{"$f":"'TA1'!F130","v":0.37},{"$f":"SUM(H77:H79)","v":0},{"$f":"IF(TYPE(J77*K77)<>1,0,J77*K77)","v":0}]
[null,null,null,null,null,null,null,null,0,"Opaque Swing Doors",null,{"$f":"'TA1'!F163","v":"U-0.37"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(G79=0,H79=0),0,IF(OR(G79=0,H79=0),NA(), H79*G79))","v":0},null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F131","v":0.34},{"$f":"SUM(H80:H82)","v":0},{"$f":"IF(TYPE(J80*K80)<>1,0,J80*K80)","v":0}]
[null,null,null,null,null,null,null,null,0,"Opaque rollup & sliding",null,{"$f":"'TA1'!F164","v":"U-0.34"}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F125","v":0.3},{"$f":"'Target Area Adjustments'!J30","v":0},{"$f":"IF(TYPE(J83*K83)<>1,0,J83*K83)","v":0}]
[null,null,null,null,null,null,null,null,null,"Non-Metal Frame",null,{"$f":"'TA1'!F158","v":"U-0.30"}]
[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":0.38},{"$f":"'Target Area Adjustments'!J31","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'!F159","v":"U-0.38"}]
[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":0.4},{"$f":"'Target Area Adjustments'!J32","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'!F160","v":"U-0.40"}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F128","v":0.6},{"$f":"'Target Area Adjustments'!J33","v":0},{"$f":"IF(TYPE(J95*K95)<>1,0,J95*K95)","v":0}]
[null,null,null,null,null,null,null,null,0,"Metal Entrance Door",null,{"$f":"'TA1'!F161","v":"U-0.60"}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,{"$f":"'TA1'!F129","v":0.5},{"$f":"'Target Area Adjustments'!J81","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'!F162","v":"U-0.50"}]
[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'!F142)","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'!F175)","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(H111<>K111,\"Target Area Adjusted\",\"\")","v":""},null,null,"Page 2 Subtotal ",{"$f":"SUM(H70:H108)","v":0},{"$f":"SUM(I70:I108)","v":0},null,{"$f":"K99+K95+K91+K87+K83+K80+K77+K73+K70+K106","v":0},{"$f":"L99+L95+L91+L87+L83+L80+L77+L73+L70+L106","v":0}]
[null,null,null,null,null,null,"Page 1 Subtotal ",{"$f":"H59","v":0},{"$f":"I59","v":0},null,{"$f":"K59","v":0},{"$f":"L59","v":0}]
[null,null,null,null,null,null," Project Total",{"$f":"H112+H111","v":0},{"$f":"I112+I111","v":0},null,{"$f":"K112+K111","v":0},{"$f":"L112+L111","v":0}]
[]
["Component Performance Compliance (UA)",null,null,null,null,null,null,null,null,null,null,{"$f":" IF(CompliancePath<>2,\"Component Performance Not Selected\",IF(CalcType=5,\"Target Insulation Allowance not selected\",\n          IF(OR(L113=0,I113=0),\"\",\n         IF(C406.8_Enhanced_Envelope,\n               IF(I113<L113*0.85+0.00001,\"UA COMPLIES\",\n                  IF(ChangeofUseOrConditioning,\n                       IF(I113<L113*0.95+0.00001,\"UA COMPLIES\",\n                        \"UA DOES NOT COMPLY WITH C406.8\"),\n                   \"UA DOES NOT COMPLY WITH C406.8\")),\n           IF(I113<L113+0.00001,\"UA COMPLIES\",\n           IF(ChangeofUseOrConditioning,\n                  IF(I113>L113*1.10001,\"UA DOES NOT COMPLY\",\n                   \"UA COMPLIES W/ EXISTING SPACE EXEMPTION\"),\n           \"UA DOES NOT COMPLY\")\n)))))","v":"Component Performance Not Selected"}]
[]
["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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cooler"]
["Freezer"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Refrigerated Freezers - Target U-factors for freezer roof, wall and door assemblies are per C410. Enter proposed information under the most similar assembly type. Target U-factor for insulated freezer floors is per C410. Insulation is required under the entire freezer floor. Enter proposed UA information under Freezer Floor if it is an insulated freezer floor assembly that rests on top of a standard floor. The vertical edge of an insulated freezer floor shall be documented as a section of freezer wall. If freezer floor insulation is installed as integral to or applied underneath a slab-on-grade or exposed floor, then enter proposed UA floor information under Floors (slab-on-grade entered as a mass floor). This floor area shall be thermally broken from the surrounding floor. Enter proposed FP information as In-Floor Thermal Break. Enter only the opaque portion of freezer doors. Windows within doors and reach-in display case doors shall comply with C410 prescriptive requirements."]

{"sheet":"TA1","index":6,"n_rows":184,"n_cols":46,"rows_kept":184,"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"]
[1,"Climate Zone: 1= Zone 4c/5, 2=Zone 6, 3=Cleared, 4= Seattle "]
[null,null,null,null,null,null,null,null,"Addition button"]
["Transfer Variables - DO NOT CHANGE CELL ADDRESS - hard coded in VB ",null,null,null,null,null,null,null,1]
[{"$f":"'Target Area Adjustments'!F11","v":0},"Window Area",null,null,null,null,null,null,"Alteration Button"]
[{"$f":"SUM('Target Area Adjustments'!H11:J11)","v":0},"Net AG Wall Area",null,null,null,null,null,null,1]
[{"$f":"'Target Area Adjustments'!F62","v":0},"Skylight Area"]
[{"$f":"'Target Area Adjustments'!H62","v":0},"Net Ceiling Area"]
[{"$f":"'Target Area Adjustments'!F12","v":0},"Existing Window Area"]
[{"$f":"'Target Area Adjustments'!H12","v":0},"Existing Net AG Wall Area"]
[{"$f":"'Target Area Adjustments'!F63","v":0},"Existing Skylight Area"]
[{"$f":"'Target Area Adjustments'!H63","v":0},"Existing Net Ceiling Area"]
[]
["Flags from Env-Sum Options"]
[false,"New building "]
[false,"Addition"]
[false,"Alteration"]
[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 & builidng ≥ 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(VertFenAlt=3,0.3,0.4)","v":0.3},"Maximum prescriptive / comp WWR",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"]
[]
[]
[null,null,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."]
["Flags - Seattle Specific",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."]
[2,"Heating type (1 - Electric, 2 - Other)"]
[2,"Street level retail: 1=yes, 2 - no but paired submitted, 3 - no"]
[]
["HEADER Row - NOT USED 2015"]
["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":"Zones 4c/5b"},"NOT USED 2015"]
["Header",{"$f":"IF(AND(B47<>\"\",B48<>\"\"),CONCATENATE(B48,\" \",B47),\"\")","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 WSEC 2015: 1= HPF Win, 2=base, 3=SEC 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,"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,"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,"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,"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,"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,"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,"Window","0.2<=pf<0.5",1,{"$f":"AB90*AB94/AB91","v":0.41999999999999993},{"$f":"AC90*AC94/AC91","v":0.41999999999999993},0.45,{"$f":"AE90*AE94/AE91","v":0.41999999999999993},{"$f":"AF90*AF94/AF91","v":0.41999999999999993},0.45,{"$f":"AH90*AH94/AH91","v":0.41999999999999993},{"$f":"AI90*AI94/AI91","v":0.41999999999999993},0.45,{"$f":"AK90*AK94/AK91","v":0.41999999999999993},{"$f":"AL90*AL94/AL91","v":0.41999999999999993},0.45]
[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,"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,"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,"Window","pf>=0.5",1,{"$f":"AB90*AB97/AB91","v":0.55999999999999994},{"$f":"AC90*AC97/AC91","v":0.55999999999999994},0.6,{"$f":"AE90*AE97/AE91","v":0.55999999999999994},{"$f":"AF90*AF97/AF91","v":0.55999999999999994},0.6,{"$f":"AH90*AH97/AH91","v":0.55999999999999994},{"$f":"AI90*AI97/AI91","v":0.55999999999999994},0.6,{"$f":"AK90*AK97/AK91","v":0.55999999999999994},{"$f":"AL90*AL97/AL91","v":0.55999999999999994},0.6]
[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,"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,"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,"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,"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,"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,"N. Window",null,1,{"$f":"AB$90*AB104/AB$91","v":0.46375},{"$f":"AC90*AC104/AC91","v":0.46375},0.53,{"$f":"AE90*AE104/AE91","v":0.46375},{"$f":"AF90*AF104/AF91","v":0.46375},0.53,{"$f":"AH$90*AH104/AH$91","v":0.46375},{"$f":"AI90*AI104/AI91","v":0.46375},0.53,{"$f":"AK90*AK104/AK91","v":0.46375},{"$f":"AL90*AL104/AL91","v":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,"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,"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,"N. Window","0.2<=pf<0.5",1,{"$f":"AB$90*AB107/AB$91","v":0.50749999999999995},{"$f":"AC$90*AC107/AC$91","v":0.50749999999999995},0.57999999999999996,{"$f":"AE$90*AE107/AE$91","v":0.50749999999999995},{"$f":"AF$90*AF107/AF$91","v":0.50749999999999995},0.57999999999999996,{"$f":"AH$90*AH107/AH$91","v":0.50749999999999995},{"$f":"AI$90*AI107/AI$91","v":0.50749999999999995},0.57999999999999996,{"$f":"AK$90*AK107/AK$91","v":0.50749999999999995},{"$f":"AL$90*AL107/AL$91","v":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,"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,"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,"N. Window","pf>=0.5",1,{"$f":"AB$90*AB110/AB$91","v":0.55999999999999994},{"$f":"AC$90*AC110/AC$91","v":0.55999999999999994},0.64,{"$f":"AE$90*AE110/AE$91","v":0.55999999999999994},{"$f":"AF$90*AF110/AF$91","v":0.55999999999999994},0.64,{"$f":"AH$90*AH110/AH$91","v":0.55999999999999994},{"$f":"AI$90*AI110/AI$91","v":0.55999999999999994},0.64,{"$f":"AK$90*AK110/AK$91","v":0.55999999999999994},{"$f":"AL$90*AL110/AL$91","v":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,"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,"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]
[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,"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":1},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,"mtl  bld & steel frame wall u-values","same","diff"]
[null,null,null,null,"Data Entered (0=no, 1=yes) ==>",{"$f":"IF('ENV-UA'!H113=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,"floor over air u-values","same","state + wd frame"]
[null,null,null,null,"Refrigeration Offset ==>",{"$f":"IF(CalcType=3,6,IF(CalcType=4,9,0))","v":0}]
[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,"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,"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,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,"Group ==>","Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg","Freezer","Freezer","Freezer"]
[null,"Component","Item Name",null,null,{"$f":"\"Comm\"","v":"Comm"},{"$f":"\"Group R\"","v":"Group R"},"Zone ==>",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",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,"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($B125=\"AGWall\",$B125=\"BGWall\"),SemiHt),\"NR\",INDEX(TargetUbyJurisdiction,$E125,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   1-1)*3+idxZone))))","v":0.3},{"$f":"IF(AND(OR($B125=\"AGWall\",$B125=\"BGWall\"),SemiHt),\"NR\",IF(AND(OR(CalcType=3,CalcType=4),B125<>\"Floor\"),F125,INDEX(TargetUbyJurisdiction,$E125,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   IF(CalcType<=2,2,1)-1)*3+idxZone)))))","v":0.3},null,{"$f":"VLOOKUP($H$80,$H$90:$Q$92,3,FALSE)","v":0.3},{"$f":"VLOOKUP($H$80,$H$90:$Q$92,3,FALSE)","v":0.3},0.3,{"$f":"VLOOKUP($H$80,$H$90:$Q$92,5,FALSE)","v":0.3},{"$f":"VLOOKUP($H$80,$H$90:$Q$92,6,FALSE)","v":0.3},0.3,{"$f":"VLOOKUP($H$80,$H$90:$Q$92,5,FALSE)","v":0.3},{"$f":"VLOOKUP($H$80,$H$90:$Q$92,6,FALSE)","v":0.3},0.3,{"$f":"VLOOKUP($H$80,$H$90:$Q$92,8,FALSE)","v":0.3},{"$f":"VLOOKUP($H$80,$H$90:$Q$92,9,FALSE)","v":0.3},{"$f":"VLOOKUP($H$80,$H$90:$Q$92,10,FALSE)","v":0.3},"set occ.","set zone",null,"Window",1,{"$f":"INDEX(TargetSHGCbyJurisdiction,$Y125,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   1-1)*3+idxZone)))","v":0.4},{"$f":"INDEX(TargetSHGCbyJurisdiction,$Y125,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   IF(CalcType<=2,2,1)-1)*3+idxZone)))","v":0.4},{"$f":"INDEX(AB90:AB92,$H$80)","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,0.38,{"$f":"IF(AND(OR($B126=\"AGWall\",$B126=\"BGWall\"),SemiHt),\"NR\",IF(AND(OR(CalcType=3,CalcType=4),B126<>\"Floor\"),F126,INDEX(TargetUbyJurisdiction,$E126,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   IF(CalcType<=2,2,1)-1)*3+idxZone)))))","v":0.38},null,{"$f":"INDEX(I$93:I$95,$H$80)","v":0.38},{"$f":"INDEX(J$93:J$95,$H$80)","v":0.38},0.38,{"$f":"INDEX(L$93:L$95,$H$80)","v":0.38},{"$f":"INDEX(M$93:M$95,$H$80)","v":0.38},0.38,{"$f":"INDEX(O$93:O$95,$H$80)","v":0.38},{"$f":"INDEX(P$93:P$95,$H$80)","v":0.38},0.38,{"$f":"INDEX(R$93:R$95,$H$80)","v":0.38},{"$f":"INDEX(S$93:S$95,$H$80)","v":0.38},{"$f":"INDEX(T$93:T$95,$H$80)","v":0.38},"set occ.","set zone",null,"Window 0.2<=pf<0.5",2,{"$f":"INDEX(TargetSHGCbyJurisdiction,Y126,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   1-1)*3+idxZone)))","v":0.48},0.48,{"$f":"INDEX(AB93:AB95,$H$80)","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,0.4,0.4,null,{"$f":"INDEX(I$96:I$98,$H$80)","v":0.4},{"$f":"INDEX(J$96:J$98,$H$80)","v":0.4},0.4,{"$f":"INDEX(L$96:L$98,$H$80)","v":0.4},{"$f":"INDEX(M$96:M$98,$H$80)","v":0.4},0.4,{"$f":"INDEX(O$96:O$98,$H$80)","v":0.4},{"$f":"INDEX(P$96:P$98,$H$80)","v":0.4},0.4,{"$f":"INDEX(R$96:R$98,$H$80)","v":0.4},{"$f":"INDEX(S$96:S$98,$H$80)","v":0.4},{"$f":"INDEX(T$96:T$98,$H$80)","v":0.4},"set occ.","set zone",null,"Window pf>0.5",3,0.64,0.64,{"$f":"INDEX(AB96:AB98,$H$80)","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,0.6,0.6,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",null,"Skylight",4,0.35,0.35,{"$f":"INDEX(AB99:AB101,$H$80)","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.5,0.5,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",null,"N Window",5,0.53,0.53,{"$f":"INDEX(AB103:AB105,$H$80)","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,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone",null,"N Window 0.2<=pf<0.5",6,0.57999999999999996,0.57999999999999996,{"$f":"INDEX(AB106:AB108,$H$80)","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,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone",null,"N Window pf>0.5",7,0.64,0.64,{"$f":"INDEX(AB109:AB111,$H$80)","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.5999999999999999E-2,2.7E-2,2.7E-2,2.5999999999999999E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone",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,3.1E-2,3.1E-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",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",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",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,0.104,0.104,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"]
[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",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"]
[null,"AGWall",null,"wood frame/other",15,5.3999999999999999E-2,5.3999999999999999E-2,null,5.3999999999999999E-2,5.3999999999999999E-2,5.0999999999999997E-2,5.3999999999999999E-2,5.3999999999999999E-2,5.0999999999999997E-2,3.9E-2,3.9E-2,3.9E-2,0.03,0.03,0.03,"set occ.","set zone"]
[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",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,0.25,0.25,"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"]
[null,"Floor","Mass","mass",18,3.1E-2,3.1E-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"]
[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"]
[null,"Floor","Wood joist/framing","Wood joist/framing",20,0,0,"seattle only",null,null,2.5000000000000001E-2,null,null,2.5000000000000001E-2,null,null,2.5000000000000001E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,"set occ.","set zone"]
[null,"Floor","Metal joist/framing","Metal joist/framing",21,0,0,"seattle only",null,null,2.9000000000000001E-2,null,null,2.9000000000000001E-2,null,null,2.9000000000000001E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,"set occ.","set zone"]
[null,"Floor",null,"Slab",22,0.54,0.54,"All floors U0.029 - all zones",0.54,0.54,0.54,0.54,0.52,0.54,0.54,0.52,0.54,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,"set occ.","set zone"]
[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"]
[null,"BGWall",null,"mass",24,0.104,0.104,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"]
[null,"BGWall",null,"metal bldg",25,5.1999999999999998E-2,5.1999999999999998E-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"]
[null,"BGWall",null,"steel frame",26,5.5E-2,5.5E-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",null,null,null,null,"LABELS"]
[null,"BGWall",null,"wood frame/other",27,5.3999999999999999E-2,5.3999999999999999E-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",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,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0,0,null,null,null,{"$f":"F123","v":"Comm"},{"$f":"G123","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.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0,0,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,"Window",1,{"$f":"INDEX( $AB$154:$AP$160,$Y154,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   1-1)*3+idxZone)))","v":"0.40"},{"$f":"INDEX( $AB$154:$AP$160,$Y154,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   2-1)*3+idxZone)))","v":"0.40"},{"$f":"TEXT(AB125,\"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,"Window 0.2<=pf<0.5",2,"0.48","0.48",{"$f":"TEXT(AB126,\"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":"F123","v":"Comm"},{"$f":"G123","v":"Group R"},"Zone ==>",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",null,null,null,"Window pf>0.5",3,"0.64","0.64",{"$f":"TEXT(AB127,\"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,"Skylight",4,"0.35","0.35",{"$f":"TEXT(AB128,\"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":"B125","v":"Window"},"non-metal frame","non-metal frm",1,{"$f":"IF(AND(OR($B158=\"AGWall\",$B158=\"BGWall\"),SemiHt),\"NR\",INDEX(TargetLabelByJurisdiction,$E158,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   1-1)*3+idxZone))))","v":"U-0.30"},{"$f":"IF(AND(OR($B158=\"AGWall\",$B158=\"BGWall\"),SemiHt),\"NR\",INDEX(TargetLabelByJurisdiction,$E158,IF($F$113=4,13,IF($F$115=4,14,$F$117+(   2-1)*3+idxZone))))","v":"U-0.30"},"nmfrm",{"$f":"IF(I125<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I125,\"0.00#\")))","v":"U-0.30"},{"$f":"IF(J125<=0,\"NR\",CONCATENATE(\"U-\",TEXT(J125,\"0.00#\")))","v":"U-0.30"},"U-0.30","U-0.30","U-0.30","U-0.30",{"$f":"IF(O125<=0,\"NR\",CONCATENATE(\"U-\",TEXT(O125,\"0.00#\")))","v":"U-0.30"},"U-0.30","U-0.30","U-0.30","U-0.30","U-0.30","set occ.","set zone",null,"N Window",5,"0.53","0.53",{"$f":"TEXT(AB129,\"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,"U-0.38","U-0.38","mfrm",{"$f":"IF(I126<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I126,\"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","U-0.38","U-0.38","U-0.38","set occ.","set zone",null,"N Window 0.2<=pf<0.5",6,"0.58","0.58",{"$f":"TEXT(AB130,\"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,"U-0.40","U-0.40","med",{"$f":"IF(I127<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I127,\"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","U-0.40","U-0.40","U-0.40","set occ.","set zone",null,"N Window pf>0.5",7,"0.64","0.64",{"$f":"TEXT(AB131,\"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,"U-0.60","U-0.60","nc",{"$f":"IF(I128<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I128,\"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","U-0.60","U-0.60","U-0.60","set occ.","set zone"]
[null,"Skylight","All Types","all types",5,"U-0.50","U-0.50","wc",{"$f":"IF(I129<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I129,\"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","U-0.50","U-0.50","U-0.45","set occ.","set zone"]
[null,"Door","Swinging","swing",6,"U-0.37","U-0.37","dr",{"$f":"IF(I130<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I130,\"0.00#\")))","v":"U-0.37"},"U-0.37","U-0.37","U-0.37","U-0.37","U-0.37",{"$f":"IF(O130<=0,\"NR\",CONCATENATE(\"U-\",TEXT(O130,\"0.000#\")))","v":"U-0.039"},"U-0.039","U-0.039","U-0.030","U-0.030","U-0.030","set occ.","set zone"]
[null,"Door","Roll-up or sliding","roll/slide",7,"U-0.34","U-0.34",null,{"$f":"IF(I131<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I131,\"0.00#\")))","v":"U-0.34"},"U-0.34","U-0.34","U-0.34","U-0.34","U-0.34","U-0.039","U-0.039","U-0.039","U-0.030","U-0.030","U-0.030","set occ.","set zone"]
[null,"Roof",0,"above deck",8,"U-0.027","U-0.027",null,{"$f":"IF(I132<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I132,\"0.00#\")))","v":"U-0.027"},"U-0.027","U-0.026","U-0.027","U-0.027","U-0.026","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"Roof",0,"metal bldg",9,"U-0.031","U-0.031",null,{"$f":"IF(I133<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I133,\"0.00#\")))","v":"U-0.031"},"U-0.031","U-0.027","U-0.031","U-0.031","U-0.027","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"Roof",0,"attic/other",10,"U-0.021","U-0.021",null,{"$f":"IF(I134<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I134,\"0.00#\")))","v":"U-0.021"},"U-0.021","U-0.021","U-0.021","U-0.021","U-0.021","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"Roof",0,"joist/single",11,"U-0.027","U-0.027",null,{"$f":"IF(I135<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I135,\"0.00#\")))","v":"U-0.027"},"U-0.027","U-0.027","U-0.027","U-0.027","U-0.027","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"AGWall",0,"mass",12,"U-0.104","U-0.078",null,{"$f":"IF(I136<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I136,\"0.00#\")))","v":"U-0.104"},"U-0.104","U-0.057","U-0.078","U-0.078","U-0.057","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"AGWall",0,"metal bldg",13,"U-0.052","U-0.052",null,{"$f":"IF(I137<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I137,\"0.00#\")))","v":"U-0.052"},"U-0.052","U-0.052","U-0.052","U-0.052","U-0.052","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"AGWall",0,"steel frame",14,"U-0.055","U-0.055",null,{"$f":"IF(I138<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I138,\"0.00#\")))","v":"U-0.055"},"U-0.055","U-0.055","U-0.055","U-0.055","U-0.055","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"AGWall",0,"wood frame/other",15,"U-0.054","U-0.054",null,{"$f":"IF(I139<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I139,\"0.00#\")))","v":"U-0.054"},"U-0.054","U-0.051","U-0.054","U-0.054","U-0.051","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"AGWall","transfer slab","transfer slab",16,"U-0.20","U-0.20",null,{"$f":"IF(I140<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I140,\"0.00#\")))","v":"U-0.20"},"U-0.20","U-0.20","U-0.20","U-0.20","U-0.20","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"AGWall","cmu, same as mass but with corefill then okay in z1","CMU w/ Ins. Cores",17,"U-0.25","U-0.078",null,{"$f":"IF(I141<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I141,\"0.00#\")))","v":"U-0.25"},"U-0.25","U-0.057","U-0.078","U-0.078","U-0.057","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"Floor","Mass","mass",18,"U-0.031","U-0.031",null,{"$f":"IF(I142<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I142,\"0.00#\")))","v":"U-0.031"},"U-0.031","U-0.029","U-0.031","U-0.031","U-0.029","U-0.031","U-0.031","U-0.029","U-0.035","U-0.035","U-0.035","set occ.","set zone"]
[null,"Floor","Joist/framing","joist/frame",19,"U-0.029","U-0.029",null,{"$f":"IF(I143<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I143,\"0.00#\")))","v":"U-0.029"},"U-0.029","U-0.029","U-0.029","U-0.029","U-0.029","U-0.029","U-0.029","U-0.029","U-0.035","U-0.035","U-0.035","set occ.","set zone"]
[null,"Floor","Wood joist/framing","Wood joist/framing",20,"NR","NR",null,{"$f":"IF(I144<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I144,\"0.00#\")))","v":"NR"},"NR","U-0.025","NR","NR","U-0.025","NR","NR","U-0.025","U-0.035","U-0.035","U-0.035","set occ.","set zone"]
[null,"Floor","Metal joist/framing","Metal joist/framing",21,"NR","NR",null,{"$f":"IF(I145<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I145,\"0.00#\")))","v":"NR"},"NR","U-0.029","NR","NR","U-0.029","NR","NR","U-0.029","U-0.035","U-0.035","U-0.035","set occ.","set zone"]
[null,"Floor",0,"Slab",22,"F-0.54","F-0.54",null,{"$f":"IF(I146<=0,\"NR\",CONCATENATE(\"F-\",TEXT(I146,\"0.00#\")))","v":"F-0.54"},{"$f":"IF(J146<=0,\"NR\",CONCATENATE(\"F-\",TEXT(J146,\"0.00#\")))","v":"F-0.54"},"F-0.54","F-0.54","F-0.52","F-0.54","F-0.54","F-0.52","F-0.54",{"$f":"IF(R146<=0,\"NR\",CONCATENATE(\"U-\",TEXT(R146,\"0.00#\")))","v":"U-0.035"},"U-0.035","U-0.035","set occ.","set zone"]
[null,"Floor",0,"Heated Slab",23,"F-0.55","F-0.55",null,{"$f":"IF(I147<=0,\"NR\",CONCATENATE(\"F-\",TEXT(I147,\"0.00#\")))","v":"F-0.55"},{"$f":"IF(J147<=0,\"NR\",CONCATENATE(\"F-\",TEXT(J147,\"0.00#\")))","v":"F-0.55"},"F-0.55","F-0.55","F-0.55","F-0.55","F-0.55","F-0.55","F-0.55","U-0.035","U-0.035","U-0.035","set occ.","set zone"]
[null,"BGWall",0,"mass",24,"U-0.104","U-0.078",null,{"$f":"IF(I148<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I148,\"0.00#\")))","v":"U-0.104"},"U-0.104","U-0.07","U-0.078","U-0.078","U-0.07","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"BGWall",0,"metal bldg",25,"U-0.052","U-0.052",null,{"$f":"IF(I149<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I149,\"0.00#\")))","v":"U-0.052"},"U-0.052","U-0.07","U-0.052","U-0.044","U-0.07","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"BGWall",0,"steel frame",26,"U-0.055","U-0.055",null,{"$f":"IF(I150<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I150,\"0.00#\")))","v":"U-0.055"},"U-0.049","U-0.07","U-0.055","U-0.044","U-0.07","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]
[null,"BGWall",0,"wood frame/other",27,"U-0.054","U-0.054",null,{"$f":"IF(I151<=0,\"NR\",CONCATENATE(\"U-\",TEXT(I151,\"0.00#\")))","v":"U-0.054"},"U-0.051","U-0.07","U-0.054","U-0.044","U-0.07","U-0.039","U-0.039","U-0.039","U-0.03","U-0.03","U-0.03","set occ.","set zone"]

{"sheet":"Target Area Adjustments","index":7,"n_rows":88,"n_cols":12,"rows_kept":88,"cut":false,"hidden":false,"merged":[[67,9,68,9],[16,1,16,2]]}
[null,"Vertical Fenestration Target Area Adjustment Calculations"]
[]
[null,{"$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,null,null,null,"Date",{"$f":"TEXT('PROJ-SUM'!$F$3,\"mm/dd/yyyy\")","v":"01/01/2017"}]
[]
[]
[null,null,"VF = Vertical fenestration",null,null,null,"NW = Net above grade wall (excludes fenestration and doors.)"]
[null,null,"DR = Opaque doors",null,null,null,"Gross Exterior Above-Grade Wall Area= VF + NW + DR"]
[null,null,"AG = Above-grade"]
[]
[null,"Proposed Areas",null,null,null,"Vertical Fenestration",null,"Net Above Grade Wall",null,"Opaque Door"]
[null,null,null,"Project Areas ->","VF=",{"$f":"SUM('ENV-UA'!H83:H98)","v":0},"NW=",{"$f":"SUM('ENV-UA'!H27:H44)","v":0},"DR=",{"$f":"SUM('ENV-UA'!H77:H82)","v":0}]
[null,null,null,"Existing Non-project Areas ->","VF=",{"$f":"'ENV-UA'!G11","v":0},"NW=",{"$f":"'ENV-UA'!I11","v":0}]
[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(F11:J12))","v":0},"x",{"$f":"'TA1'!F152","v":0.3},"¸",100,"=",{"$f":"IF(altWWRunchanged,B18,B14*D14)","v":0}]
[]
[]
[null,"Total Vertical Fenestration",null,null,null,"Delta Vertical Fenestration ",null,"0",null,"Excess Vertical Fenestration"]
[null,{"$f":"SUM(F11:F12)","v":0},"-",{"$f":"H14","v":0},"=",{"$f":"B18-D18","v":0},null,"ô greater","=",{"$f":"MAX(0,H19)","v":0}]
[null,null,null,null,null,null,null,{"$f":"F18","v":0}]
[]
[null,"Project Vertical Fenestration",null,"Excess Vertical Fenestration",null,"Target Vertical Fenestration",null,"Total Vertical Fenestration",null,"Target VF Multiplier"]
[null,{"$f":"F11","v":0},"-",{"$f":"J18","v":0},"=",{"$f":"B22-D22","v":0},"¸",{"$f":"B22","v":0},"=",{"$f":"IF(H22>0,F22/H22,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":"H11","v":0},"+",{"$f":"D22","v":0},"=",{"$f":"B25+D25","v":0},"¸",{"$f":"B25","v":0},"=",{"$f":"IF(H25>0,F25/H25,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'!H83:H86)","v":0},"x",{"$f":"IF(F30>0,$J$22,0)","v":0},"=",{"$f":"F30*H30","v":0}]
[null,null,null,"Metal frame, fixed",null,{"$f":"SUM('ENV-UA'!H87:H90)","v":0},"x",{"$f":"IF(F31>0,$J$22,0)","v":0},"=",{"$f":"F31*H31","v":0}]
[null,null,null,"Metal frame, operable",null,{"$f":"SUM('ENV-UA'!H91:H94)","v":0},"x",{"$f":"IF(F32>0,$J$22,0)","v":0},"=",{"$f":"F32*H32","v":0}]
[null,null,null,"Metal frame, entrance door",null,{"$f":"SUM('ENV-UA'!H95:H98)","v":0},"x",{"$f":"IF(F33>0,$J$22,0)","v":0},"=",{"$f":"F33*H33","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(F35>0,$J$25,0)","v":0},"=",{"$f":"F35*H35","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 Mass",null,{"$f":"SUM('ENV-UA'!H42:H44)","v":0},"x",0,"=",0]
[]
[null,null,null,"Sum of Proposed","Sum of Proposed          ",{"$f":"SUM(F30:F41)","v":0},null,"Sum of Target",null,{"$f":"SUM(J30:J41)","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(F46>0,$J$22,0)","v":0},"=",{"$f":"F46*H46","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(F47>0,$J$22,0)","v":0},"=",{"$f":"F47*H47","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(F48>0,$J$22,0)","v":0},"=",{"$f":"F48*H48","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(F50>0,$J$22,0)","v":0},"=",{"$f":"F50*H50","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(F51>0,$J$22,0)","v":0},"=",{"$f":"F51*H51","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(F52>0,$J$22,0)","v":0},"=",{"$f":"F52*H52","v":0}]
[]
[null,"Skylight Target Area Adjustment Calculations "]
[]
[null,{"$f":"B3","v":"Project Title:"},null,null,{"$f":"E3","v":"1 - Fill this line out on PROJ-SUM"},null,null,null,null,null,"Date",{"$f":"L3","v":"01/01/2017"}]
[]
[null,null,"SKY= Skylight",null,"NR - Net roof (excludes skylight)",null,null,null,"Gross Exterior Roof Area = SKY + NR"]
[]
[]
[null,"Proposed Areas",null,null,null,"Skylight",null,"Net Opaque Roof "]
[null,null,null,"Project Areas ->","SKY=",{"$f":"SUM('ENV-UA'!H99:H102)","v":0},"NR=",{"$f":"SUM('ENV-UA'!H15:H26)","v":0}]
[null,null,null,"Existing Non-project Areas ->","SKY=",{"$f":"'ENV-UA'!G12","v":0},"NR=",{"$f":"'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(F62:H63)","v":0},"x",{"$f":"'TA1'!F153","v":0.05},"¸",100,"=",{"$f":"IF(altSRRunchanged,B70,B66*D66)","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(F62:F63)","v":0},"-",{"$f":"H66","v":0},"=",{"$f":"B70-D70","v":0},null,"ô greater","=",{"$f":"MAX(0,H71)","v":0}]
[null,null,null,null,null,null,null,{"$f":"F70","v":0}]
[]
[null,"Project\n Skylight Area",null,"Excess Skylight",null,"Target Skylight Area",null,"Total Skylight Area",null,"Target SKY Multiplier"]
[null,{"$f":"F62","v":0},"-",{"$f":"J70","v":0},"=",{"$f":"B74-D74","v":0},"¸",{"$f":"B74","v":0},"=",{"$f":"IF(H74>0,F74/H74,0)","v":0}]
[]
[null,"Net Project\nRoof Area",null,"Excess Skylight",null,"Target Net Roof Area",null,"Net Roof",null,"Target Net Roof Mult."]
[" ",{"$f":"H62","v":0},"+",{"$f":"D74","v":0},"=",{"$f":"B77+D77","v":0},"¸",{"$f":"B77","v":0},"=",{"$f":"IF(H77>0,F77/H77,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(F81>0,$J$74,0)","v":0},"=",{"$f":"IF(AND(F81=0,J70>0),-J70,F81*H81)","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(F83>0,$J$77,0)","v":0},"=",{"$f":"IF(SUM(F83:F86)=0,-J81,F83*H83)","v":0}]
[null,null,null,"Metal Building",null,{"$f":"SUM('ENV-UA'!H18:H20)","v":0},"x",{"$f":"IF(F84>0,$J$77,0)","v":0},null,{"$f":"F84*H84","v":0}]
[null,null,null,"Joist / Single Rafter",null,{"$f":"SUM('ENV-UA'!H21:H23)","v":0},"x",{"$f":"IF(F85>0,$J$77,0)","v":0},"=",{"$f":"F85*H85","v":0}]
[null,null,null,"Attic / All Others",null,{"$f":"SUM('ENV-UA'!H24:H26)","v":0},"x",{"$f":"IF(F86>0,$J$77,0)","v":0},"=",{"$f":"F86*H86","v":0}]
[]
[null,null,null,null,"Sum of Proposed  ",{"$f":"SUM(F80:F86)","v":0},null,null,"Sum of Target  ",{"$f":"SUM(J80:J86)","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 WSEC 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 Oct 2017"}]
[{"$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/2017"}]
["Target Insulation Allowance:",null,null,null,null,null,null,"For Building Department 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'!E31>0,'ENV-SUM'!E31,0)","v":""},null,{"$f":"'Target Area Adjustments'!D14","v":0.3}]
["Skylight Area as % gross roof area",null,null,null,{"$f":"IF('ENV-SUM'!G31>0,'ENV-SUM'!G31,0)","v":""},null,{"$f":"'Target Area Adjustments'!D66","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'!Z128","v":0.35},{"$f":"'Target Area Adjustments'!J81","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'!Z157","v":"0.35"}]
[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'!F62)>0.1,IF(F19>'Target Area Adjustments'!F62,CONCATENATE(\"More proposed skylight area here than ENV-UA - Remove  \",TEXT(F19-'Target Area Adjustments'!F62,\"0.0\")),CONCATENATE(\"Less proposed skylight area here than ENV-UA - Add  \",TEXT('Target Area Adjustments'!F62-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'!Z125","v":0.4},{"$f":"'Target Area Adjustments'!J46","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'!Z126","v":0.48},{"$f":"'Target Area Adjustments'!J47","v":0},{"$f":"IF(TYPE(H26*I26)<>1,0,H26*I26)","v":0}]
[null,null,null,null,null,0,"PF ≥ 0.5",{"$f":"'TA1'!Z127","v":0.64},{"$f":"'Target Area Adjustments'!J48","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'!Z129","v":0.53},{"$f":"'Target Area Adjustments'!J50","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'!Z130","v":0.57999999999999996},{"$f":"'Target Area Adjustments'!J51","v":0},{"$f":"IF(TYPE(H42*I42)<>1,0,H42*I42)","v":0}]
[null,null,null,null,null,0,"PF ≥ 0.5",{"$f":"'TA1'!Z131","v":0.64},{"$f":"'Target Area Adjustments'!J52","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'!D111","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'!F11)>0.1,IF((E35+E48)>'Target Area Adjustments'!F11,CONCATENATE(\"More proposed vertical fenestration here than ENV-UA - Remove  \",TEXT((E35+E48)-'Target Area Adjustments'!F11,\"0.0\")),CONCATENATE(\"Less proposed vertical fenestration here than ENV-UA: Add  \",TEXT('Target Area Adjustments'!F11-(E35+E48),\"0.0\" )) ),\"\")","v":""}]
["Component Performance Compliance (SHGC)",null,null,null,null,null,null,null,null,{"$f":"IF(CompliancePath<>2,\"Compliance Performance Not Selected\",IF(AND(J53=\"\",G51>0,J51>0),IF(G51>J51+0.00001,\"SHGC DOES NOT COMPLY\",\"SHGC COMPLIES\"),\"\"))","v":"Compliance Performance Not Selected"}]

{"sheet":"ENV-CHK","index":9,"n_rows":127,"n_cols":6,"rows_kept":127,"cut":false,"hidden":false,"merged":[[103,1,104,1],[103,2,104,2],[103,4,104,4],[103,5,104,5],[55,1,56,1],[77,4,78,4],[77,5,78,5],[85,5,86,5],[85,4,86,4],[85,2,86,2],[85,1,86,1],[83,5,84,5],[81,5,82,5],[81,4,82,4],[83,4,84,4],[92,5,95,5],[3,0,3,5],[118,0,118,5],[29,0,34,0],[29,1,34,1],[29,2,34,2],[29,4,34,4],[29,5,34,5],[46,0,48,0],[79,1,80,1],[79,2,80,2],[43,0,45,0],[43,1,45,1],[43,2,45,2],[43,4,45,4],[43,5,45,5],[40,0,42,0],[12,7,14,7],[20,5,21,5],[20,0,21,0],[20,1,21,1],[20,2,21,2],[16,2,17,2],[16,4,17,4],[16,5,17,5],[16,0,17,0],[16,1,17,1],[20,4,21,4],[12,0,14,0],[12,1,14,1],[12,2,14,2],[22,0,27,0],[46,5,48,5],[46,4,48,4],[46,2,48,2],[46,1,48,1],[22,1,27,1],[22,2,27,2],[22,4,27,4],[40,1,42,1],[40,2,42,2],[40,4,42,4],[40,5,42,5],[22,5,27,5],[88,2,91,2],[88,4,91,4],[88,5,91,5],[81,0,82,0],[81,2,82,2],[85,0,86,0],[83,2,84,2],[81,1,82,1],[83,0,84,0],[83,1,84,1],[92,4,95,4],[92,0,95,0],[92,1,95,1],[92,2,95,2],[51,0,54,0],[69,0,73,0],[69,1,73,1],[69,2,73,2],[77,1,78,1],[55,0,56,0],[61,0,63,0],[61,1,63,1],[77,2,78,2],[79,4,80,4],[88,0,91,0],[88,1,91,1],[79,5,80,5],[79,0,80,0],[51,2,54,2],[69,4,73,4],[69,5,73,5],[55,4,56,4],[55,5,56,5],[61,4,63,4],[61,5,63,5],[61,2,63,2],[55,2,56,2],[51,1,54,1],[77,0,78,0],[51,5,54,5],[51,4,54,4]]}
["Building Permit Plans Checklist, pg. 1",null,null,null,null,"ENV-CHK"]
[{"$f":"ReadMe!A2","v":"2015 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Oct 2017"}]
["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/2017"}]
["The following information is necessary to check a building permit application for compliance with the building envelope requirements in the Washington State Energy Code, Commercial Provisions."]
["Applicability\n(yes,no,na)","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
["SCOPE "]
[null,"C402.1.1","Low energy spaces","Identify low energy spaces 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","Identify semi-heated spaces 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","Identify walk-in and warehouse cooler and freezer spaces on plans"]
[null,"C101.4.1","Mixed occupancy","Identify 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; provide calculations for existing and final level of space conditioning, and calculations that demonstrate alteration complies with current WSEC"]
[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 WSEC","."]
[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 WSEC"]
[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 WSEC"]
["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 construction 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":"$A$2","v":"2015 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"F2","v":"Revised Oct 2017"}]
["Project Title:",null,{"$f":"C3","v":"1 - Fill this line out on PROJ-SUM"},null,"Date",{"$f":"F3","v":"01/01/2017"}]
["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 and 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 WSEC 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.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":"$A$2","v":"2015 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"F2","v":"Revised Oct 2017"}]
["Project Title:",null,{"$f":"C3","v":"1 - Fill this line out on PROJ-SUM"},null,"Date",{"$f":"F3","v":"01/01/2017"}]
["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 areas that exceed 2,500 sf; for each space identify the space use, floor area, floor to ceiling height, whether skylights are installed, and any exception taken;"]
[null,null,null,"Provide calculations for percentage of conditioned floor area located within a daylight zone including skylight and eligible sidelight daylight zones;"]
[null,null,null,"Provide calculations for percentage of skylight area in each space over 2,500 sf, OR;"]
[null,null,null,"Provide calculations for skylight effective aperture (Equation C4-5) for each space over 2,500 sf;"]
[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.40 cfm/ft2 (1.5 L/s*m2) at 0.3 in. wg (75 Pa), then visually inspect air barrier and seal noted sources of leakage; (3) Submit a follow-up report to jurisdiction noting corrective measures taken;  (4) Include air barrier test report in compliance documentation provided to building owner."]
["Building Permit Plans Checklist, pg. 4",null,null,null,null,"ENV-CHK"]
[{"$f":"$A$2","v":"2015 WSEC Compliance Forms for Commercial Buildings including R2, R3, & R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"F2","v":"Revised Oct 2017"}]
["Project Title:",null,{"$f":"C3","v":"1 - Fill this line out on PROJ-SUM"},null,"Date",{"$f":"F3","v":"01/01/2017"}]
["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","To comply with additional efficiency package option, indicate in project documents that the air barrier test results shall not exceed 0.25 cfm/ft2 (0.94 L/s*m2) 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"]