{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["ReadMe","ENV-SUM","ENV-REQUIREMENTS","ENV-PRESCRIPTIVE","ENV-UA","Target Area Adjustments","TA1","ENV-SHGC","ENV-CHK","temp"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":87,"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":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,1,1],[5,0,6,0],[9,0,10,0],[13,0,19,0],[40,0,40,1],[27,0,27,1],[29,0,30,0],[31,0,32,0],[34,0,37,0],[38,0,39,0]]}
["Instructions for Electronic Forms, pg 1"]
["2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "]
[null,"Revised Oct 2013"]
[null,"     Commercial Provision Chapters 1 - 5 of the 2012 Washington State Energy Code apply to all commercial occupancies, R-2 and R-3 occupancies greater than 3 stories above grade, and R-1 occupancy (all building heights)."]
["Intro","     This file, ENV12-v3.XLSM, has electronic compliance forms for envelope provisions as defined in Sections C101, C303, C402 and Appendix A for Climate Zones 4c and 5b. There are two companion files: LTG12-v3.XLSM (Section C405 lighting, motor, and transformer requirements), and MECH12-v3.XLSM (Section C403 mechanical systems requirements). "]
["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 2012 WSEC code text is available for download from the NEEC website:"]
[null,"http:/www.neec.net/energy-codes"]
["Training ","Refer to the NEEC website for instruction on how to complete all of the 2012 WSEC Compliance Forms."]
["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.  "]
[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 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 ENV-SUM. This information is automatically replicated on all other ENV forms. The ENV-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/2013 or 12/21/2014."]
[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."]
["Compliance Path","    You must select a Compliance Path on ENV-SUM (line 12) to activate the correct input method for Window-to-Wall and Skylight-to-Roof ratios."]
["Occupancy Group","    You must select an Occupancy Group on ENV-SUM (line 14) for this workbook to display the correct code requirements and automatically calculate component performance target UA values."]
["Instructions for Electronic Forms, pg 2"]
[{"$f":"A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "}]
[null,{"$f":"B3","v":"Revised Oct 2013"}]
["Fenestration Area ","     For projects complying via the Prescriptive Path, enter the vertical fenestration area, gross wall area (includes vertical fenestration, doors, etc), skylight area and gross roof area (includes skylights, mechanical equipment curbs, etc) 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 either C402.3.1.1 50% floor area within the daylight zone, or C402.3.1.3 high performance vertical fenestration. "]
[null,"     If the project is eligible for one of these alternates, select the corresponding button on Line 24 of the ENV-SUM form. This will re-calculate the prescriptive target area in the ENV-SUM and ENV-UA forms based on 40%. "]
["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 ","    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":"ENV-SUM","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[27,0,28,1],[27,2,28,6],[20,3,20,6],[21,3,21,6],[20,0,21,1],[23,0,23,1],[25,0,25,1]]}
["Envelope Summary",null,null,null,{"$f":"'TA1'!$C$101","v":" "},null,"ENV-SUM"]
[{"$f":"ReadMe!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Oct 2013"}]
["Project Info","Project Address","1 - This address line will copy onto other forms",null,null,"Date","2013-05-21"]
[null,null,null,null,null,"For Building Department Use"]
[]
[null,"Applicant Name:"]
[null,"Applicant Address:"]
[null,"Applicant Phone:"]
[]
["Project Description"]
[]
["Compliance Path"]
[]
["Occupancy Group"]
[]
[null,null,"Total Vertical Fenestration\n(rough opening)","divided by","Gross Exterior Above Grade\nWall Area","\ntimes 100 equals","\n% Vertical Fenestration"]
[null,null,null,"¸",null,"X 100 =",{"$f":"IF(C17=\"Path?\",\"Path?\",IF(E17>0,C17/E17,\"\"))","v":""}]
[null,null,"Total Skylight","divided by","Gross Exterior Roof Area","\ntimes 100 equals","\n% Skylight"]
[null,null,null,"¸",null,"X 100 =",{"$f":"IF(C19=\"Path?\",\"Path?\",IF(E19>0,C19/E19,\"\"))","v":""}]
[]
["Fenestration Area Compliance",null,"Vertical Fenestration Area",{"$f":"IF(AND(ComponentPath<>4,OccGroup<>3,ISNUMBER(G17)),IF(OR(G17<=0.3,AND(G17<=0.4,OR(dlz50pct=1,hpfwin=1))),\"VERTICAL FENESTRATION AREA COMPLIES\",IF(OR(dlz50pct=1,hpfwin=1),IF(ComponentPath=1,\"Project exceeds maximum vertical fenestration area for Prescriptive compliance.  Comply via Component Performance with Target Area Adjustment.\",IF(ComponentPath=2,\"Project exceeds maximum target vertical fenestration area.  Target area adjustment applied to UA calculation.\",\"\")),IF(ComponentPath=1,\"Project exceeds maximum vertical fenestration area for Prescriptive compliance.  Comply via 50% DLZ Option (C402.3.1.1), High Performance Window Option (C402.3.1.3), or Component Performance with Target Area Adjustment.\",IF(ComponentPath=2,\"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).\",\"\")) )),\"\")","v":""}]
[null,null,"Skylight Area",{"$f":"IF(ISNUMBER(G19),IF(G19>0.05,IF(ComponentPath=1,\"Project exceeds maximum skylight area for Prescriptive compliance.  Comply via Component Performance with Target Area Adjustment.\",IF(ComponentPath=2,\"Project exceeds target skylight area.  Target area adjustment applied to UA calculation.\",\"\")),IF(G19>=0,\"SKYLIGHT AREA COMPLIES\",\"\")),\"\")","v":""}]
[]
["Vertical Fenestration Alternates"]
[]
["Single Story Spaces Requiring Skylights"]
[]
["Semi-Heated Spaces"]
[]
[]
["Refrigerated Spaces"]
[]
["Mixed Occupancy and/or "]
["Space Conditioning"]

{"sheet":"ENV-REQUIREMENTS","index":2,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[[11,0,11,1],[4,2,4,3],[4,4,4,5],[6,0,6,1],[6,2,6,5],[7,0,7,1],[27,0,27,1],[16,0,16,1],[16,2,16,3],[16,4,16,5],[17,0,17,1],[21,0,21,1],[22,2,22,3],[23,2,23,3],[24,0,24,1],[24,2,24,5],[25,2,25,3],[26,4,26,5],[27,2,27,3],[27,4,27,5],[28,0,28,1],[28,2,28,5],[29,2,29,5],[34,0,34,1],[36,0,36,1],[40,0,40,5],[36,2,36,5],[38,0,38,1],[38,2,38,3],[38,4,38,5],[51,2,51,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[54,0,54,1],[59,0,59,1],[71,0,71,5],[37,2,37,3],[37,4,37,5],[39,0,39,1],[39,2,39,3],[39,4,39,5],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[41,4,45,5],[45,2,45,3],[46,0,46,5],[47,4,51,5]]}
["Envelope Requirements Summary, pg 1",null,null,null,{"$f":"'TA1'!$C$101","v":" "},"ENV-REQ"]
[{"$f":"ReadMe!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Oct 2013"}]
["Minimum Requirements"]
["for Prescriptive Compliance"]
[null,"Prescriptive Path"," Table C402.2 Notes 1,7\nInsulation Minimum R-Value",null,"Table C402.1.2 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-30 c.i.","R-38 c.i.","U-0.034","U-0.031"]
[null,"Metal Building (with R-3.5 thermal blocks) 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"]
["Walls, Above-grade"]
[null,"Mass","R-9.5 c.i.","R-13.3 c.i.","U-0.104 Note 6","U-0.078"]
[null,"Metal Building","R-13 + R-13 c.i.","R-13 + R-13 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 int","R-21 int","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,"Roll-up or sliding","R-4.75","R-4.75","No U-Value for prescriptive compliance."]
[null,null,"Table C402.3 - 0-30% of wall area, or\n30%-40% per Section C402.3.1.1 DLZ",null,"Section C402.3.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: all orientations - SHGC-0.40\n0.2 ≤ PF < 0.5: north - SHGC-0.44; \nall other - SHGC-0.48\nPF ≥ 0.5: north - SHGC-0.48; \nall other - SHGC-0.64",null,"PF < 0.2: all orientations - SHGC-0.35\n0.2 ≤ PF < 0.5: north - SHGC-0.385; \nall other - SHGC-0.42\nPF ≥ 0.5: north - SHGC-0.42; \nall other - SHGC-0.56"]
["Skylights",null,"SHGC-0.35",null,"SHGC-0.35"]
["Refrigerated Spaces Insulation",null,"Insulation Minimum R-Value \nTable C402.5 and C402.6",null,"Assembly Maximum U-factor "]
["Freezers - Walk-in and Warehouse"]
[null,"Roof / Ceiling","R-32",null,"No U-Value for prescriptive compliance"]
[null,"Wall","R-32"]
[null,"Door","R-32"]
[null,"Door - transparent reach-in","triple-pane, heat-reflective treated or gas fill"]
[null,"Floor","R-28"]
["Coolers - Walk-in and Warehouse"]
[null,"Roof / Ceiling","R-25",null,"No U-Value for prescriptive compliance"]
[null,"Wall","R-25"]
[null,"Door","R-25"]
[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":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,{"$f":"F2","v":"Revised Oct 2013"}]
["Definitions:"]
[]
[]
[]
[]
["Footnote Summary:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End of Envelope Requirements Summary"]

{"sheet":"ENV-PRESCRIPTIVE","index":3,"n_rows":101,"n_cols":13,"rows_kept":101,"cut":false,"hidden":false,"merged":[[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[8,5,8,7],[8,8,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[40,3,40,4],[41,3,41,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[44,9,44,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[60,3,60,4],[38,9,38,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[46,3,46,4],[47,3,47,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[58,5,58,7],[58,8,58,10],[59,9,59,10],[60,9,60,10],[79,9,79,10],[80,9,80,10],[81,9,81,10],[70,9,70,10],[71,9,71,10],[72,9,72,10],[73,9,73,10],[74,9,74,10],[75,9,75,10],[61,9,61,10],[99,8,99,10],[100,8,100,10],[101,8,101,10],[92,0,92,2],[93,0,93,2],[94,0,94,2],[95,0,95,2],[96,0,96,2],[92,8,92,10],[93,8,93,10],[94,8,94,10],[95,8,95,10],[96,8,96,10],[96,5,96,7],[97,5,97,7],[98,5,98,7],[99,5,99,7],[100,5,100,7],[101,5,101,7],[97,0,97,2],[98,0,98,2],[97,8,97,10],[98,8,98,10],[88,9,88,10],[85,9,85,10],[86,9,86,10],[87,9,87,10],[88,3,88,4],[62,9,62,10],[63,9,63,10],[64,9,64,10],[65,9,65,10],[69,9,69,10],[82,3,82,4],[83,3,83,4],[84,3,84,4],[85,3,85,4],[66,9,66,10],[68,9,68,10],[67,8,67,10],[82,9,82,10],[83,9,83,10],[84,9,84,10],[76,9,76,10],[77,9,77,10],[79,3,79,4],[78,9,78,10],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[91,0,91,5],[65,3,65,4],[69,3,69,4],[81,3,81,4],[70,3,70,4],[71,3,71,4],[67,5,67,7],[80,3,80,4],[86,3,86,4],[100,0,100,2],[92,5,92,7],[93,5,93,7],[94,5,94,7],[95,5,95,7],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[98,3,98,4],[99,3,99,4],[100,3,100,4],[92,3,92,4],[93,3,93,4],[94,3,94,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[87,3,87,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[99,0,99,2]]}
["Prescriptive Path, pg. 1",null,null,null,null,null,{"$f":"'TA1'!$C$101","v":" "},null,null,null,"ENV-PRESCRIPTIVE"]
[{"$f":"'ENV-SUM'!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised Oct 2013"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,null,null,{"$f":"IF('ENV-SUM'!$C$3=\"1 - This address line will copy onto other forms\",\"1 - Fill this line out on ENV-SUM\",'ENV-SUM'!$C$3)","v":"1 - Fill this line out on ENV-SUM"},null,null,null,"Date",{"$f":"TEXT('ENV-SUM'!$G$3,\"mm/dd/yyyy\")","v":"05/21/2013"}]
["Occupancy Group",null,null,null,null,null,null,null,"For Building Department Use"]
["Fenestration Area as % gross above-grade wall area",null,null,null,null,{"$f":"IF('ENV-SUM'!G17>0,'ENV-SUM'!G17,0)","v":""},"Max. Target:",{"$f":"'TA1'!D15","v":0}]
["Skylight Area as % gross roof area",null,null,null,null,{"$f":"IF('ENV-SUM'!G19>0,'ENV-SUM'!G19,0)","v":""},"Max. Target:",{"$f":"'TA1'!D64","v":0}]
["Vertical Fenestration Alternates:",null,null,null,null,{"$f":"'TA1'!B95","v":"None Selected on ENV-SUM"}]
[]
["Building Component ",null,null,null,null,"R-Value for Prescriptive Compliance",null,null,"U-Factor/F-Factor for Alternative Prescriptive Compliance"]
[null,null,null,"Provide page/plan # of assembly detail and ID.",null,"Cavity Ins.\nR-Value","Continuous Ins. (CI)\nR-Value","Alternate CI \nR-Value                               (Table C402.2 Footnote F)1","Assembly \nU-Factor","U-Factor Source                                                        (Appendix A, Chapter 3 table, or approved calculation method) "]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:",null,null,null,null,null,null,null,null,null,0]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,null,null,null,"Perim. Ins.\nR-Value","Full Slab CI\nR-Value",null,"F-Factor","F-Factor Source"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[]
[]
[]
[]
["Prescriptive Path, pg. 2",null,null,null,null,null,{"$f":"'TA1'!$C$101","v":" "},null,null,null,"ENV-PRESCRIPTIVE"]
[{"$f":"A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!E67","v":0},null,{"$f":"K2","v":"Revised Oct 2013"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,null,null,{"$f":"E3","v":"1 - Fill this line out on ENV-SUM"},null,null,null,"Date",{"$f":"J3","v":"05/21/2013"}]
["Fenestration Area as % gross above-grade wall area",null,null,null,null,{"$f":"F5","v":""},"Max. Target:",{"$f":"H5","v":0},"For Building Department Use"]
["Skylight Area as % gross roof area",null,null,null,null,{"$f":"F6","v":""},"Max. Target:",{"$f":"H6","v":0}]
[]
["Building Component ",null,null,null,null,"R-Value for Prescriptive Compliance",null,null,"U-Factor/F-Factor for Alternative Prescriptive Compliance"]
[null,null,null,"Provide page/plan # of assembly detail and ID.",null,"Cavity Ins.\nR-Value","Continuous Ins. (CI)\nR-Value","Alternate CI \nR-Value                               (Table C402.2 Footnote F)","Assembly\nU-Factor","U-Factor Source                                                        (Appendix A, Chapter 3 table, or approved calculation method) "]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[]
[null,null,null,null,null,"Solar Heat Gain Coefficient (SHGC)",null,null,"U-Factor for Prescriptive Compliance"]
[null,null,null,null,null,"Projection factor (PF)\n (if applicable)","SHGC Adjustment Multiplier (if applicable)","Assembly\nSHGC","Assembly\nU-Factor","U-Factor Source                                                        (NFRC, Appendix A, or Chapter 3 table) "]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[null,null,"ID:"]
[]
[]
["Refrigerated Spaces, Walk-in & Warehouse"]
["Coolers",null,null,"Notes",null," R-Values for Prescriptive Compliance",null,null,"Prescriptive U-Factor not allowed."]
["Walls"]
["Ceiling"]
["Doors"]
["Freezers"]
["Walls"]
["Ceiling"]
["Doors"]
["Floor"]

{"sheet":"ENV-UA","index":4,"n_rows":95,"n_cols":13,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Component Performance Path, pg. 1",null,null,null,null,null,null,null,null,{"$f":"'TA1'!$C$101","v":" "},null,"ENV-UA"]
[{"$f":"'ENV-SUM'!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised Oct 2013"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,null,null,null,{"$f":"IF('ENV-SUM'!$C$3=\"1 - This address line will copy onto other forms\",\"1 - Fill this line out on ENV-SUM\",'ENV-SUM'!$C$3)","v":"1 - Fill this line out on ENV-SUM"},null,null,null,"Date",{"$f":"TEXT('ENV-SUM'!$G$3,\"mm/dd/yyyy\")","v":"05/21/2013"}]
["Occupancy Group",null,null,null,null,null,null,null,null,"For Building Department Use"]
["Change in occupancy or space conditioning"]
["Fenestration Area as % gross above-grade wall area",null,null,null,null,null,{"$f":"IF('ENV-SUM'!G17>0,'ENV-SUM'!G17,0)","v":""},"Max. Target:",{"$f":"'TA1'!D15","v":0}]
["Skylight Area as % gross roof area",null,null,null,null,null,{"$f":"IF('ENV-SUM'!G19>0,'ENV-SUM'!G19,0)","v":""},"Max. Target:",{"$f":"'TA1'!D64","v":0}]
["Vertical  Fenestration Alternates:",null,null,null,null,null,{"$f":"'TA1'!B95","v":"None Selected on ENV-SUM"}]
[]
["Building Component ",null,null,null,null,null,null,"Proposed UA",null,"Target UA"]
[null,"Provide source of U-factor, page/plan # of assembly detail & ID",null,null,null,null,"U-factor","x Area (A)","= UA (U x A)","U-factor","x Area (A) =","UA (U x A)"]
[null,null,"R=",null,"ID:",null,null,null,{"$f":"IF(AND(G12=0,H12=0),0,IF(OR(G12=0,H12=0),NA(), H12*G12))","v":0},{"$f":"'TA1'!U92","v":"set occ."},{"$f":"'TA1'!J81","v":0},{"$f":"IF(TYPE(J12*K12)<>1,0,J12*K12)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Above Deck Insulation",null,{"$f":"'TA1'!U122","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0,null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U93","v":"set occ."},{"$f":"'TA1'!J82","v":0},{"$f":"IF(TYPE(J15*K15)<>1,0,J15*K15)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Metal Building",null,{"$f":"'TA1'!U123","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U94","v":"set occ."},{"$f":"'TA1'!J83","v":0},{"$f":"IF(TYPE(J18*K18)<>1,0,J18*K18)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Single raft, attic, other",null,{"$f":"'TA1'!U124","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,{"$f":"IF(AND(G21=0,H21=0),0,IF(OR(G21=0,H21=0),NA(), H21*G21))","v":0},{"$f":"'TA1'!U98","v":"set occ."},{"$f":"'TA1'!J35","v":0},{"$f":"IF(TYPE(J21*K21)<>1,0,J21*K21)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,{"$f":"IF(AND(G22=0,H22=0),0,IF(OR(G22=0,H22=0),NA(), H22*G22))","v":0},"Steel/metal frame",null,{"$f":"'TA1'!U128","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U97","v":"set occ."},{"$f":"'TA1'!J36","v":0},{"$f":"IF(TYPE(J24*K24)<>1,0,J24*K24)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Metal Building",null,{"$f":"'TA1'!U127","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U99","v":"set occ."},{"$f":"'TA1'!J37","v":0},{"$f":"IF(TYPE(J27*K27)<>1,0,J27*K27)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Wood Frame, other",null,{"$f":"'TA1'!U129","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U96","v":"set occ."},{"$f":"'TA1'!J38","v":0},{"$f":"IF(TYPE(J30*K30)<>1,0,J30*K30)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Mass Wall",null,{"$f":"'TA1'!U126","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U105","v":"set occ."},{"$f":"SUM(H33:H36)","v":0},{"$f":"IF(TYPE(J33*K33)<>1,0,J33*K33)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Assumed to be Mass Wall",null,{"$f":"'TA1'!U135","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U101","v":"set occ."},{"$f":"SUM(H37:H39)","v":0},{"$f":"IF(TYPE(J37*K37)<>1,0,J37*K37)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Mass Floor",null,{"$f":"'TA1'!U131","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U102","v":"set occ."},{"$f":"SUM(H40:H42)","v":0},{"$f":"IF(TYPE(J40*K40)<>1,0,J40*K40)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Joist/Framing",null,{"$f":"'TA1'!U132","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,null,null,null,null,"F-factor","x Perimeter","= UA(U x A)","F-factor","x Perimeter =","UA (U x A)"]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U103","v":"set occ."},{"$f":"SUM(H44:H46)","v":0},{"$f":"IF(TYPE(J44*K44)<>1,0,J44*K44)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Slab-On-Grade",null,{"$f":"'TA1'!U133","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U104","v":"set occ."},{"$f":"SUM(H47:H49)","v":0},{"$f":"IF(TYPE(J47*K47)<>1,0,J47*K47)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Heated Slab-On-Grade",null,{"$f":"'TA1'!U134","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[]
[null,null,null,null,null,null,null,"Area","UA",null,"Area","UA"]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H49)","v":0},{"$f":"SUM(I12:I49)","v":0},null,{"$f":"K47+K44+K40+K37+K33+K30+K27+K24+K21+K18+K15+K12","v":0},{"$f":"L47+L44+L40+L37+L33+L30+L27+L24+L21+L18+L15+L12","v":0}]
[]
["Component Performance Compliance (UA)",null,null,null,null,null,null,null,null,null,null,{"$f":"L95","v":"Occupancy Group not selected"}]
["Component Performance Path, pg. 2",null,null,null,null,null,null,null,null,{"$f":"'TA1'!$C$101","v":" "},null,"ENV-UA"]
[{"$f":"A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!E67","v":0},null,{"$f":"L2","v":"Revised Oct 2013"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,null,null,null,{"$f":"F3","v":"1 - Fill this line out on ENV-SUM"},null,null,null,"Date",{"$f":"K3","v":"05/21/2013"}]
["Fenestration Area as % gross above-grade wall area",null,null,null,null,null,{"$f":"G6","v":""},"Max. Target:",{"$f":"I6","v":0},"For Building Department Use"]
["Skylight Area as % gross roof area",null,null,null,null,null,{"$f":"G7","v":""},"Max. Target:",{"$f":"I7","v":0}]
[]
["Building Component ",null,null,null,null,null,null,"Proposed UA",null,"Target UA"]
[null,"Provide source of U-factor, page/plan # of assembly detail & ID",null,null,null,null,"U-factor","x Area (A)","= UA (U x A)","U-factor","x Area (A) =","UA (U x A)"]
[null,null,"U=",null,"ID:",null,null,null,{"$f":"IF(AND(G63=0,H63=0),0,IF(OR(G63=0,H63=0),NA(), H63*G63))","v":0},{"$f":"'TA1'!U90","v":"set occ."},{"$f":"SUM(H63:H65)","v":0},{"$f":"IF(TYPE(J63*K63)<>1,0,J63*K63)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Opaque Swing Doors",null,{"$f":"'TA1'!U120","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U91","v":"set occ."},{"$f":"SUM(H66:H68)","v":0},{"$f":"IF(TYPE(J66*K66)<>1,0,J66*K66)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Opaque rollup & sliding",null,{"$f":"'TA1'!U121","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U85","v":"set occ."},{"$f":"'TA1'!J30","v":0},{"$f":"IF(TYPE(J69*K69)<>1,0,J69*K69)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Non-Metal Frame",null,{"$f":"'TA1'!U115","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U86","v":"set occ."},{"$f":"'TA1'!J31","v":0},{"$f":"IF(TYPE(J73*K73)<>1,0,J73*K73)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Metal Frame, Fixed",null,{"$f":"'TA1'!U116","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U87","v":"set occ."},{"$f":"'TA1'!J32","v":0},{"$f":"IF(TYPE(J77*K77)<>1,0,J77*K77)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Metal Frame, Operable",null,{"$f":"'TA1'!U117","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U88","v":"set occ."},{"$f":"'TA1'!J33","v":0},{"$f":"IF(TYPE(J81*K81)<>1,0,J81*K81)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Metal Entrance Door",null,{"$f":"'TA1'!U118","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"'TA1'!U89","v":"set occ."},{"$f":"'TA1'!J79","v":0},{"$f":"IF(TYPE(J85*K85)<>1,0,J85*K85)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"All types",null,{"$f":"'TA1'!U119","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0]
[]
[null,null,null,null,null,null,null,"Area","UA",null,"Area","UA"]
[null,null,null,null,null,null,"Page 2 Subtotal ",{"$f":"SUM(H63:H88)","v":0},{"$f":"SUM(I63:I88)","v":0},null,{"$f":"K85+K81+K77+K73+K69+K66+K63","v":0},{"$f":"L85+L81+L77+L73+L69+L66+L63","v":0}]
[null,null,null,null,null,null,"Page 1 Subtotal ",{"$f":"H52","v":0},{"$f":"I52","v":0},null,{"$f":"K52","v":0},{"$f":"L52","v":0}]
[null,null,null,null,null,null,"Total ",{"$f":"H92+H91","v":0},{"$f":"I92+I91","v":0},null,{"$f":"K92+K91","v":0},{"$f":"L92+L91","v":0}]
[]
["Component Performance Compliance (UA)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OccGroup=3,\"Occupancy Group not selected\",IF(OR(L93=0,I93=0),\"\",IF(I93<L93+0.00001,\"UA COMPLIES\",IF(Alteration110=2,\"UA DOES NOT COMPLY\",IF(I93>L93*1.10001,\"UA DOES NOT COMPLY\",\"UA COMPLIES W/ EXISTING SPACE EXEMPTION\")))))","v":"Occupancy Group not selected"}]

{"sheet":"Target Area Adjustments","index":5,"n_rows":46,"n_cols":1,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Vertical Fenestration Target Area Adjustment Calculations  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Skylight Target Area Adjustment Calculations "]

{"sheet":"TA1","index":6,"n_rows":138,"n_cols":55,"rows_kept":138,"cut":false,"hidden":true,"merged":[[65,9,66,9]]}
[]
[]
[null,"Vertical Fenestration Target Area Adjustment Calculations"]
[]
[]
[]
[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 ->","VF=",{"$f":"SUM('ENV-UA'!H69:H84)","v":0}]
[null,null,null,"Opaque ->","NW=",{"$f":"SUM('ENV-UA'!H21:H32)","v":0},"DR=",{"$f":"SUM('ENV-UA'!H63:H68)","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(F12:H13))","v":0},"x",{"$f":"U109","v":0},"¸",100,"=",{"$f":"B15*D15","v":0}]
[]
[]
[null,"Total Vertical Fenestration",null,null,null,"Delta Vertical Fenestration ",null,"0",null,"Excess Vertical Fenestration"]
[null,{"$f":"F12","v":0},"-",{"$f":"H15","v":0},"=",{"$f":"B19-D19","v":0},null,"ô greater","=",{"$f":"MAX(0,H20)","v":0}]
[null,null,null,null,null,null,null,{"$f":"F19","v":0}]
[]
[null,"Total Vertical Fenestration",null,"Excess Vertical Fenestration",null,"Target Vertical Fenestration",null,"Total Vertical Fenestration",null,"Target VF Multiplier",null,null,null,null,null,null,null,"This whole look up is current only used by seattle but the functionality is preserved incase some future code varies the u-value by glass area."]
[null,{"$f":"B19","v":0},"-",{"$f":"J19","v":0},"=",{"$f":"B23-D23","v":0},"¸",{"$f":"B23","v":0},"=",{"$f":"IF(H23>0,F23/H23,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":"F13","v":0},"+",{"$f":"D23","v":0},"=",{"$f":"B26+D26","v":0},"¸",{"$f":"B26","v":0},"=",{"$f":"IF(H26>0,F26/H26,0)","v":0}]
[]
[null,"UA Adjustments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR MESSAGES"]
[null,null,null,"Vertical Fenestration",null,"Proposed Area",null,"Target VF Mult.",null,"Target Area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"page","cell","label","message"]
[null,null,null,"Non-metal frame",null,{"$f":"SUM('ENV-UA'!H69:H72)","v":0},"x",{"$f":"IF(F30>0,$J$23,0)","v":0},"=",{"$f":"F30*H30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Metal frame, fixed",null,{"$f":"SUM('ENV-UA'!H73:H76)","v":0},"x",{"$f":"IF(F31>0,$J$23,0)","v":0},"=",{"$f":"F31*H31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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. "]
[null,null,null,"Metal frame, operable",null,{"$f":"SUM('ENV-UA'!H77:H80)","v":0},"x",{"$f":"IF(F32>0,$J$23,0)","v":0},"=",{"$f":"F32*H32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[null,null,null,"Metal frame, entrance door",null,{"$f":"SUM('ENV-UA'!H81:H84)","v":0},"x",{"$f":"IF(F33>0,$J$23,0)","v":0},"=",{"$f":"F33*H33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[null,null,null,"Above-grade Wall",null,"Proposed Area",null,"Target Net Wall Mult.",null,"Target Area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[null,null,null,"Steel Frame",null,{"$f":"SUM('ENV-UA'!H21:H23)","v":0},"x",{"$f":"IF(F35>0,$J$26,0)","v":0},"=",{"$f":"F35*H35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[null,null,null,"Metal Building",null,{"$f":"SUM('ENV-UA'!H24:H26)","v":0},null,{"$f":"IF(F36>0,$J$26,0)","v":0},"=",{"$f":"F36*H36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[null,null,null,"Wood / Other frame",null,{"$f":"SUM('ENV-UA'!H27:H29)","v":0},"x",{"$f":"IF(F37>0,$J$26,0)","v":0},"=",{"$f":"F37*H37","v":0},null,null,null,null,null,null,null,"This whole 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21"]
[null,null,null,"Mass",null,{"$f":"SUM('ENV-UA'!H30:H32)","v":0},"x",{"$f":"IF(F38>0,$J$26,0)","v":0},"=",{"$f":"F38*H38","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV-SUM","D21","msgcomply","COMPLIES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glazing Case (WSEC 2012 1= HPF Win, 2=base)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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)."]
[null,null,null,"Sum of Proposed","Sum of Proposed          ",{"$f":"SUM(F30:F38)","v":0},null,"Sum of Target",null,{"$f":"SUM(J30:J38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VertFenAlt=2,1,2)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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."]
[null,"SHGC x A Adjustments"]
[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":"SUMIFS('ENV-SHGC'!$E$22:$E$31,'ENV-SHGC'!$C$22:$C$31,\">=0\",'ENV-SHGC'!$C$22:$C$31,\"<0.2\")+ SUMIFS('ENV-SHGC'!$E$22:$E$31,'ENV-SHGC'!$C$22:$C$31,\"\",'ENV-SHGC'!$C$22:$C$31,\"\")","v":0},"x",{"$f":"IF(F44>0,$J$23,0)","v":0},"=",{"$f":"F44*H44","v":0},null,null,null,null,null,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,"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,"0.2 ≤ PF < 0.5",null,{"$f":"SUMIFS('ENV-SHGC'!$E$22:$E$31,'ENV-SHGC'!$C$22:$C$31,\">=0.2\",'ENV-SHGC'!$C$22:$C$31,\"<0.5\")","v":0},"x",{"$f":"IF(F45>0,$J$23,0)","v":0},"=",{"$f":"F45*H45","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg",null,null,null,null,null,null,null,null,null,"Nres",null,null,"Res",null,null,"Refg"]
[null,null,null,"PF ≥ 0.5",null,{"$f":"SUMIFS('ENV-SHGC'!$E$22:$E$31,'ENV-SHGC'!$C$22:$C$31,\">=0.5\",'ENV-SHGC'!$C$22:$C$31,\"<99\")","v":0},"x",{"$f":"IF(F46>0,$J$23,0)","v":0},"=",{"$f":"F46*H46","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Glazing Case",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",null,null,null,null,"SHGC",null,null,null,null,"Seattle",null,null,"Seattle",null,null,"Seattle"]
[null,null,null,"North Vertical Fenestration"]
[null,null,null,"PF < 0.2",null,{"$f":"SUMIFS('ENV-SHGC'!$E$38:$E$44,'ENV-SHGC'!$C$38:$C$44,\">=0\",'ENV-SHGC'!$C$38:$C$44,\"<0.2\")+ SUMIFS('ENV-SHGC'!$E$38:$E$44,'ENV-SHGC'!$C$38:$C$44,\"\",'ENV-SHGC'!$C$38:$C$44,\"\")","v":0},"x",{"$f":"IF(F48>0,$J$23,0)","v":0},"=",{"$f":"F48*H48","v":0}]
[null,null,null,"0.2 ≤ PF < 0.5",null,{"$f":"SUMIFS('ENV-SHGC'!$E$38:$E$44,'ENV-SHGC'!$C$38:$C$44,\">=0.2\",'ENV-SHGC'!$C$38:$C$44,\"<0.5\")","v":0},"x",{"$f":"IF(F49>0,$J$23,0)","v":0},"=",{"$f":"F49*H49","v":0}]
[null,null,null,"PF ≥ 0.5",null,{"$f":"SUMIFS('ENV-SHGC'!$E$38:$E$44,'ENV-SHGC'!$C$38:$C$44,\">=0.5\",'ENV-SHGC'!$C$38:$C$44,\"<99\")","v":0},"x",{"$f":"IF(F50>0,$J$23,0)","v":0},"=",{"$f":"F50*H50","v":0},null,null,null,null,null,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,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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]
[null,"Skylight Target Area Adjustment Calculations ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","non-metal frame",3,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window",null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,"Window","0.2<=pf<0.5",1,{"$f":"AN50*1.2","v":0.42},{"$f":"AO50*1.2","v":0.42},{"$f":"AP50*1.2","v":0.42},{"$f":"AQ50*1.2","v":0.42},0.42,0.42,0.42,0.42,0.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,"Window","0.2<=pf<0.5",2,{"$f":"AN51*1.2","v":0.48},{"$f":"AO51*1.2","v":0.48},{"$f":"AP51*1.2","v":0.42},0.48,0.48,0.42,0.48,0.48,0.42]
[null,null,"SKY= Skylight",null,"NR - Net roof (excludes skylight)",null,null,null,"Gross Exterior Roof Area = SKY + NR",null,null,null,null,null,null,null,null,null,null,null,"Window","Metal Frame, fixed",3,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","0.2<=pf<0.5",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,"Window","pf>=0.5",1,{"$f":"AN50*1.6","v":0.55999999999999994},{"$f":"AO50*1.6","v":0.55999999999999994},{"$f":"AP50*1.6","v":0.55999999999999994},{"$f":"AQ50*1.6","v":0.55999999999999994},0.55999999999999994,0.55999999999999994,0.55999999999999994,0.55999999999999994,0.55999999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,"Window","pf>=0.5",2,{"$f":"AN51*1.6","v":0.64000000000000012},{"$f":"AO51*1.6","v":0.64000000000000012},{"$f":"AP51*1.6","v":0.55999999999999994},0.64000000000000012,0.64000000000000012,0.55999999999999994,0.64000000000000012,0.64000000000000012,0.55999999999999994]
[null,"Proposed Areas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","Metal Frame, operable",3,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","pf>=0.5",3]
[null,null,null,"Skylight (Horizontal Fenestration) ->","SKY=",{"$f":"SUM('ENV-UA'!H85:H88)","v":0},null,null,null,null,null,null,null,null,null,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,null,null,null,null,"Skylight",null,1,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35]
[null,null,null,"Opaque Roof  ->","NR=",{"$f":"SUM('ENV-UA'!H12:H20)","v":0},null,null,null,null,null,null,null,null,null,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,null,null,null,null,"Skylight",null,2,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal entrance door",3,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight",null,3]
[]
[null,"Gross Exterior Roof Area",null,"Max Skylight %\n(C402.3.1)",null,null,null,"Maximum Skylight Fenestration Area",null,null,null,null,null,null,null,null,null,null,null,null,"Skylight","all",1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,null,null,null,null,"N. Window",null,1,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35]
[null,{"$f":"SUM(F59:F60)","v":0},"x",{"$f":"U110","v":0},"¸",100,"=",{"$f":"B64*D64","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Skylight","all",2,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,null,null,null,null,"N. Window",null,2,0.4,0.4,0.35,0.4,0.4,0.35,0.4,0.4,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight","all",3,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window",null,3]
[null,null,null,null,null,null,null,null,null,"Excess Skylight",null,null,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":"AN63*1.1","v":0.38500000000000001},{"$f":"AO63*1.1","v":0.38500000000000001},0.38500000000000001,0.38500000000000001,0.38500000000000001,0.38500000000000001,0.38500000000000001,0.38500000000000001,0.38500000000000001]
[null,"Total Skylight Area",null,"Maximum Target",null,"Delta Skylight Area",null,"0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window","0.2<=pf<0.5",2,{"$f":"AN64*1.1","v":0.44000000000000006},0.44000000000000006,0.38500000000000001,0.44000000000000006,0.44000000000000006,0.38500000000000001,0.44000000000000006,0.44000000000000006,0.38500000000000001]
[null,{"$f":"F59","v":0},"-",{"$f":"H64","v":0},"=",{"$f":"B68-D68","v":0},null,"ô greater","=",{"$f":"MAX(0,H69)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window","0.2<=pf<0.5",3]
[null,null,null,null,null,null,null,{"$f":"F68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. Window","pf>=0.5",1,{"$f":"AN63*1.2","v":0.42},{"$f":"AO63*1.2","v":0.42},0.42,0.42,0.42,0.42,0.42,0.42,0.42]
[null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"AN64*1.2","v":0.48},0.48,0.42,0.48,0.48,0.42,0.48,0.48,0.42]
[null,"Total Skylight Area",null,"Excess Skylight",null,"Target Skylight Area",null,"Total Skylight Area",null,"Target SL Multiplier",null,null,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,{"$f":"B68","v":0},"-",{"$f":"J68","v":0},"=",{"$f":"B72-D72","v":0},"¸",{"$f":"B72","v":0},"=",{"$f":"IF(H72>0,F72/H72,0)","v":0}]
[]
[null,"Net Roof Area",null,"Excess Skylight",null,"Target Net Roof Area",null,"Net Roof",null,"Target Net Roof Mult.",null,null,null,null,null,null,null,null,null,"Selected Group (1=Nres, 2=Res, 3= Refg WA) ==>",{"$f":"IF(B91<=2,B91,IF(B91=3,4,3))","v":4},null,null,null,"seattle also has swing and non-swing doors",null,null,null,null,null,null,null,null,null,"door type u-values","same","diff -swing / non-swing"]
[null,{"$f":"F60","v":0},"+",{"$f":"D72","v":0},"=",{"$f":"B75+D75","v":0},"¸",{"$f":"B75","v":0},"=",{"$f":"IF(H75>0,F75/H75,0)","v":0},null,null,null,null,null,null,null,null,null,"Selected Zone (1=Zone 4c/5, 2=Zone 6, 3= Seattle) ==>",{"$f":"IF(B93<=2,B93,IF(B93=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,"mtl  bld & steel frame wall u-values","same","diff"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Entered (0=no, 1=yes) ==>",{"$f":"IF('ENV-UA'!H93=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,"floor over air u-values","same","state + wd frame"]
[null,"UA and SHGC x A Adjustments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Offset ==>",0]
[null,null,null,"Skylight",null,"Proposed Area",null,"Target SL Mult.",null,"Target Area",null,null,null,null,null,null,null,null,null,"Column # (idxU) ==>",{"$f":"IF(U74=4,10,IF(U75=4,11,U77+(idxGroup-1)*3+idxZone))","v":10},"should return blank if nothing entered, warning if something entered but no zone/jurisdiction chosen, or the proper value"]
[null,null,null,"All",null,{"$f":"SUM('ENV-UA'!H85:H88)","v":0},"x",{"$f":"IF(F79>0,$J$72,0)","v":0},"=",{"$f":"F79*H79","v":0}]
[null,null,null,"Roof",null,"Proposed Area",null,"Target Net Wall Mult.",null,"Target Area",null,null,null,null,null,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,"Master Look Up Table of U-Values"]
[null,null,null,"Insulation Above Deck",null,{"$f":"SUM('ENV-UA'!H12:H14)","v":0},"x",{"$f":"IF(F81>0,$J$75,0)","v":0},"=",{"$f":"F81*H81","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Col Num ==>",1,2,3,4,5,6,7,8,9,10,11,null,null,null,null,"Col Num ==>",1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,"Metal Building",null,{"$f":"SUM('ENV-UA'!H15:H17)","v":0},"x",{"$f":"IF(F82>0,$J$75,0)","v":0},null,{"$f":"F82*H82","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Group ==>","Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg",null,null,null,null,null,null,"Group ==>","Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg"]
[null,null,null,"Attic / All Others",null,{"$f":"SUM('ENV-UA'!H18:H20)","v":0},"x",{"$f":"IF(F83>0,$J$75,0)","v":0},"=",{"$f":"F83*H83","v":0},null,null,null,null,null,null,"Component","Item Name",null,null,null,null,"Zone ==>",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",null,null,null,null,"SHGC Multipliers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long","Short",null,"Target U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Target U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PF","non-North","North"]
[null,null,null,null,"Sum of Proposed  ",{"$f":"SUM(F78:F83)","v":0},null,null,"Sum of Target  ",{"$f":"SUM(J78:J83)","v":0},null,null,null,null,null,null,"Window","non-metal frame","non-metal frm",1,{"$f":"INDEX(TargetUbyJurisdiction,T85,$U$78)","v":"set occ."},null,null,{"$f":"INDEX(X$50:X$52,$W$40)","v":0.3},{"$f":"VLOOKUP($W$40,$W$50:$AF$52,3,FALSE)","v":0.3},{"$f":"VLOOKUP($W$40,$W$50:$AF$52,4,FALSE)","v":0.3},{"$f":"VLOOKUP($W$40,$W$50:$AF$52,5,FALSE)","v":0.3},{"$f":"VLOOKUP($W$40,$W$50:$AF$52,6,FALSE)","v":0.3},{"$f":"VLOOKUP($W$40,$W$50:$AF$52,7,FALSE)","v":0.3},{"$f":"VLOOKUP($W$40,$W$50:$AF$52,8,FALSE)","v":0.3},{"$f":"VLOOKUP($W$40,$W$50:$AF$52,9,FALSE)","v":0.3},{"$f":"VLOOKUP($W$40,$W$50:$AF$52,10,FALSE)","v":0.3},"set occ.","set zone",null,"Window",1,{"$f":"INDEX(TargetSHGCbyJurisdiction,AK85,$U$78)","v":"set occ."},null,{"$f":"INDEX(AN50:AN52,$W$40)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal frame, fixed","metal fix",2,"set occ.",null,null,{"$f":"INDEX(X$53:X$55,$W$40)","v":0.38},{"$f":"INDEX(Y$53:Y$55,$W$40)","v":0.38},0.38,0.38,0.38,0.38,0.38,0.38,0.38,"set occ.","set zone",null,"Window 0.2<=pf<0.5",2,"set occ.",null,{"$f":"AN85*1.2","v":0.48},{"$f":"AO85*1.2","v":0.48},{"$f":"AP85*1.2","v":0.42},0.48,0.48,0.42,0.48,0.48,0.42,"set occ.","set zone",null,null,0.10000100000000001,0.91,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal frame, operable","metal opp",3,"set occ.",null,null,{"$f":"INDEX(X$56:X$58,$W$40)","v":0.4},{"$f":"INDEX(Y$56:Y$58,$W$40)","v":0.4},0.4,0.4,0.4,0.4,0.4,0.4,0.4,"set occ.","set zone",null,"Window pf>0.5",3,"set occ.",null,{"$f":"AN85*1.6","v":0.64000000000000012},{"$f":"AO85*1.6","v":0.64000000000000012},{"$f":"AP85*1.6","v":0.55999999999999994},0.64000000000000012,0.64000000000000012,0.55999999999999994,0.64000000000000012,0.64000000000000012,0.55999999999999994,"set occ.","set zone",null,null,0.20000100000000001,0.82,0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal entrance door","metal frm door",4,"set occ.",null,null,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,"set occ.",null,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,"set occ.","set zone",null,null,0.30000100000000002,0.74,0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight","All Types","all types",5,"set occ.",null,null,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,"set occ.","set zone",null,"N Window",5,"set occ.",null,{"$f":"INDEX(AN63:AN65,$W$40)","v":0.4},{"$f":"INDEX(AO63:AO65,$W$40)","v":0.4},0.35,0.4,0.4,0.35,0.4,0.4,0.35,"set occ.","set zone",null,null,0.400001,0.67,0.84]
[null,"Flags for U-Value Group from building flags on Env-Sum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door","Swinging","swing",6,{"$f":"INDEX(TargetUbyJurisdiction,T90,$U$78)","v":"set occ."},null,null,0.37,0.37,0.37,0.37,0.37,0.37,0.37,0.37,{"$f":"Z90","v":0.37},"set occ.","set zone",null,"N Window 0.2<=pf<0.5",6,"set occ.",null,{"$f":"AN89*1.1","v":0.44000000000000006},{"$f":"AO89*1.1","v":0.44000000000000006},{"$f":"AP89*1.1","v":0.38500000000000001},0.44000000000000006,0.44000000000000006,0.38500000000000001,0.44000000000000006,0.44000000000000006,0.38500000000000001,"set occ.","set zone",null,null,0.50000100000000003,0.61,0.81]
[null,3,"Occupancy Group: 1=Non Res, 2= Res, 3=none selected ,   4=Refg Warehouse,",null,null,null,null,null,null,null,null,null,null,null,null,null,"Door","Roll-up or sliding","roll/slide",7,"set occ.",null,null,0.37,0.37,0.37,0.37,0.37,0.37,0.37,0.37,{"$f":"Z91","v":0.37},"set occ.","set zone",null,"N Window pf>0.5",7,"set occ.",null,{"$f":"AN89*1.2","v":0.48},{"$f":"AO89*1.2","v":0.48},{"$f":"AP89*1.2","v":0.42},0.48,0.48,0.42,0.48,0.48,0.42,"set occ.","set zone",null,null,0.60000100000000001,0.56000000000000005,0.78]
[null,4,"Compliance Path",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof","above deck U0.034 - all zones","above deck",8,"set occ.",null,null,3.4000000000000002E-2,3.2000000000000001E-2,2.5999999999999999E-2,3.1E-2,3.1E-2,3.1E-2,null,null,null,"set occ.","set zone",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,1,"Climate Zone: 1= Zone 4c/5, 2=Zone 6, 3=Cleared, 4= Seattle ",null,null,null,null,null,"for seattle need to set this to 4",null,null,null,null,null,null,null,"Roof","metal building U0.031 - all zones","metal bldg",9,"set occ.",null,null,3.1E-2,2.9000000000000001E-2,2.7E-2,3.1E-2,3.1E-2,3.1E-2,null,null,null,"set occ.","set zone",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,3,"Vertical Fenestration Alternates: 1= 50% DLZ, 2= high performance window, 3=none",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof","attic/Other U0.027 - all zones","attic/other",10,"set occ.",null,null,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,null,null,null,"set occ.","set zone",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,{"$f":"IF(VertFenAlt=1,\"50% Floor Area in DLZ\",IF(VertFenAlt=2,\"High Performance Vertical Fenestration\",\"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,null,null,null,"Roof","dummy","dummy",11,"set occ.",null,null,0.999,0.999,0.999,0.999,0.999,0.999,null,null,null,"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,1]
[null,{"$f":"IF(VertFenAlt=1,1,2)","v":2},">=50% of floor area in DLZ: 1=yes, 2 no : not used ",null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","mass U0.15 z1, U0.123 z2","mass",12,"set occ.",null,null,0.104,7.8E-2,5.7000000000000002E-2,7.8E-2,7.0999999999999994E-2,0.09,null,null,null,"set occ.","set zone"]
[null,{"$f":"IF(VertFenAlt=2,1,2)","v":2},"high performance glazing path (2-no, 1- yes) : not used",null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","metal building U0.064 - all zones","metal bldg",13,"set occ.",null,null,5.1999999999999998E-2,5.1999999999999998E-2,5.1999999999999998E-2,5.1999999999999998E-2,4.3999999999999997E-2,5.1999999999999998E-2,null,null,null,"set occ.","set zone",null,"sea mtl bld and stl are diff"]
[null,{"$f":"IF(B96=1,0.4,0.3)","v":0.3},"Maximum prescriptive / comp WWR",null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","steel frame U0.064 - all zones","steel frame",14,"set occ.",null,null,5.5E-2,4.9000000000000002E-2,5.5E-2,5.5E-2,4.3999999999999997E-2,5.5E-2,null,null,null,"set occ.","set zone"]
[null,"HEADER Row",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","wood frame/other U0.057 zi, U 0.051z2","wood frame/other",15,"set occ.",null,null,5.3999999999999999E-2,5.0999999999999997E-2,5.0999999999999997E-2,5.3999999999999999E-2,4.3999999999999997E-2,5.7000000000000002E-2,null,null,null,"set occ.","set zone"]
[null,"Occupancy",{"$f":"IF(B91=1,\"Commercial\",IF(B91=2,\"Residential\",IF(B91=4,\"Refrigerated Warehouse\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","cmu, same as mass but with corefill then okay in z1","CMU w/ Ins. Cores",16,"set occ.",null,null,0.25,0.123,5.7000000000000002E-2,0.09,0.08,0.09,null,null,null,"set occ.","set zone",null,"sea has 0.025 wd frm"]
[null,"Climate zone",{"$f":"IF(B91=3,\" \",IF(B93=1,\"Zones 4c/5b\",IF(B93=2,\"Zone 6b\",IF(B93=4,\"Seattle\",\"\"))))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor","Mass","mass",17,"set occ.",null,null,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,null,null,null,"set occ.","set zone"]
[null,"Header",{"$f":"IF(AND(C100<>\"\",C101<>\"\"),CONCATENATE(C101,\" \",C100),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor","Joist/framing","joist/frame",18,"set occ.",null,null,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,null,null,null,"set occ.","set zone"]
[null,"Prescriptive PF Factor - not used in 2012",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor",null,"Slab",19,"set occ.",null,"All floors U0.029 - all zones",0.54,0.54,0.52,0.54,0.52,0.52,null,null,null,"set occ.","set zone"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor",null,"Heated Slab",20,"set occ.",null,null,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,null,null,null,"set occ.","set zone"]
[null,"North Face Credit Flag - not used in 2012",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","mass U0.15 z1, U0.123 z2","mass",21,"set occ.",null,null,0.104,7.8E-2,5.7000000000000002E-2,7.8E-2,7.0999999999999994E-2,0.09,null,null,null,"set occ.","set zone"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","metal building U0.064 - all zones","metal bldg",22,"set occ.",null,null,5.1999999999999998E-2,5.1999999999999998E-2,5.1999999999999998E-2,5.1999999999999998E-2,4.3999999999999997E-2,5.1999999999999998E-2,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","steel frame U0.064 - all zones","steel frame",23,"set occ.",null,null,5.5E-2,4.9000000000000002E-2,5.5E-2,5.5E-2,4.3999999999999997E-2,5.5E-2,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","wood frame/other U0.057 zi, U 0.051z2","wood frame/other",24,"set occ.",null,null,5.3999999999999999E-2,5.0999999999999997E-2,5.0999999999999997E-2,5.3999999999999999E-2,4.3999999999999997E-2,5.7000000000000002E-2,null,null,null,"set occ.","set zone"]
[null,"Alteration / Change of Use",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAXGlass","MAXGlass","MAXGlass",25,0,null,null,{"$f":"IF(OR(hpfwin=1,dlz50pct=1),0.4,0.3)","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0,0]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAXskylight","MAXskylight","MAXskylight",26,{"$f":"INDEX(TargetUbyJurisdiction,T110,$U$78)","v":0},null,null,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0,0,null,null,null,null,"LABELS"]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Group ==>","Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg",null,null,null,null,null,null,null,1,2,"Seattle",1,2,"Seattle",1,2,"Seattle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Component","Item Name",null,"Column # (idxU) ==>",{"$f":"IF(U74=4,10,IF(U75=4,11,U77+(idxGroup-1)*3+idxZone))","v":10},null,"Zone ==>",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",null,null,null,null,null,"Target Label"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long","Short",null,"Target Label",null,"Code",null,null,null,null,null,null,null,null,null,null,null,null,"Window",1,{"$f":"INDEX( $AN$114:$AY$120,AK114,$U$113)","v":"set occ."},null,{"$f":"TEXT(AN85,\"0.00#\")","v":"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,null,null,null,null,null,null,null,null,null,{"$f":"Q85","v":"Window"},"non-metal frame","non-metal frm",1,{"$f":"INDEX(TargetLabelByJurisdiction,T115,$U$113)","v":"set occ."},null,"nmfrm",{"$f":"CONCATENATE(\"U-\",TEXT(X85,\"0.00#\"))","v":"U-0.30"},"U-0.30","U-0.30","U-0.30","U-0.30","U-0.30","U-0.30","U-0.30","U-0.30","set occ.","set zone",null,"Window 0.2<=pf<0.5",2,{"$f":"INDEX( $AN$114:$AY$120,AK115,$U$113)","v":"set occ."},null,{"$f":"TEXT(AN86,\"0.00#\")","v":"0.48"},"0.48","0.42","0.48","0.48","0.42","0.48","0.48","0.42","set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal frame, fixed","metal fix",2,"set occ.",null,"mfrm",{"$f":"CONCATENATE(\"U-\",TEXT(X86,\"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","set occ.","set zone",null,"Window pf>0.5",3,"set occ.",null,{"$f":"TEXT(AN87,\"0.00#\")","v":"0.64"},"0.64","0.56","0.64","0.64","0.56","0.64","0.64","0.56","set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal frame, operable","metal opp",3,"set occ.",null,"med",{"$f":"CONCATENATE(\"U-\",TEXT(X87,\"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","set occ.","set zone",null,"Skylight",4,"set occ.",null,{"$f":"TEXT(AN88,\"0.00#\")","v":"0.35"},"0.35","0.35","0.35","0.35","0.35","0.35","0.35","0.35","set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal entrance door","metal frm door",4,"set occ.",null,"nc",{"$f":"CONCATENATE(\"U-\",TEXT(X88,\"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","set occ.","set zone",null,"N Window",5,"set occ.",null,{"$f":"TEXT(AN89,\"0.00#\")","v":"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,null,null,null,null,null,null,null,null,null,"Skylight","All Types","all types",5,"set occ.",null,"wc",{"$f":"CONCATENATE(\"U-\",TEXT(X89,\"0.00#\"))","v":"U-0.50"},"U-0.50","U-0.50","U-0.50","U-0.50","U-0.50","U-0.50","U-0.50","U-0.50","set occ.","set zone",null,"N Window 0.2<=pf<0.5",6,"set occ.",null,{"$f":"TEXT(AN90,\"0.00#\")","v":"0.44"},"0.44","0.385","0.44","0.44","0.385","0.44","0.44","0.385","set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door","Swinging","swing",6,"set occ.",null,"dr",{"$f":"CONCATENATE(\"U-\",TEXT(X90,\"0.00#\"))","v":"U-0.37"},"U-0.37","U-0.37","U-0.37","U-0.37","U-0.37","U-0.37","U-0.37","U-0.37","set occ.","set zone",null,"N Window pf>0.5",7,"set occ.",null,{"$f":"TEXT(AN91,\"0.00#\")","v":"0.48"},"0.48","0.42","0.48","0.48","0.42","0.48","0.48","0.42","set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door","Roll-up or sliding","roll/slide",7,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X91,\"0.00#\"))","v":"U-0.37"},"U-0.37","U-0.37","U-0.37","U-0.37","U-0.37",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof","above deck U0.034 - all zones","above deck",8,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X92,\"0.00#\"))","v":"U-0.034"},"U-0.032","U-0.026","U-0.031","U-0.031","U-0.031",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof","metal building U0.031 - all zones","metal bldg",9,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X93,\"0.00#\"))","v":"U-0.031"},"U-0.029","U-0.027","U-0.031","U-0.031","U-0.031",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof","attic/Other U0.027 - all zones","attic/other",10,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X94,\"0.00#\"))","v":"U-0.021"},"U-0.021","U-0.021","U-0.021","U-0.021","U-0.021",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof","dummy","dummy",11,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X95,\"0.00#\"))","v":"U-0.999"},"U-0.999","U-0.999","U-0.999","U-0.999","U-0.999",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","mass U0.15 z1, U0.123 z2","mass",12,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X96,\"0.00#\"))","v":"U-0.104"},"U-0.078","U-0.057","U-0.078","U-0.071","U-0.09",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","metal building U0.064 - all zones","metal bldg",13,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X97,\"0.00#\"))","v":"U-0.052"},"U-0.052","U-0.052","U-0.052","U-0.044","U-0.052",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","steel frame U0.064 - all zones","steel frame",14,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X98,\"0.00#\"))","v":"U-0.055"},"U-0.049","U-0.055","U-0.055","U-0.044","U-0.055",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","wood frame/other U0.057 zi, U 0.051z2","wood frame/other",15,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X99,\"0.00#\"))","v":"U-0.054"},"U-0.051","U-0.051","U-0.054","U-0.044","U-0.057",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","cmu, same as mass but with corefill then okay in z1","CMU w/ Ins. Cores",16,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X100,\"0.00#\"))","v":"U-0.25"},"U-0.123","U-0.057","U-0.09","U-0.08","U-0.09",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor","Mass","mass",17,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X101,\"0.00#\"))","v":"U-0.031"},"U-0.031","U-0.031","U-0.031","U-0.031","U-0.031",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor","Joist/framing","joist/frame",18,"set occ.",null,"All floors U0.029 - all zones",{"$f":"CONCATENATE(\"U-\",TEXT(X102,\"0.00#\"))","v":"U-0.029"},"U-0.029","U-0.029","U-0.029","U-0.029","U-0.029",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor",0,"Slab",19,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X103,\"0.00#\"))","v":"U-0.54"},"U-0.54","U-0.52","U-0.54","U-0.52","U-0.52",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor",0,"Heated Slab",20,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X104,\"0.00#\"))","v":"U-0.55"},"U-0.55","U-0.55","U-0.55","U-0.55","U-0.55",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","mass U0.15 z1, U0.123 z2","mass",21,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X105,\"0.00#\"))","v":"U-0.104"},"U-0.078","U-0.057","U-0.078","U-0.071","U-0.09",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","metal building U0.064 - all zones","metal bldg",22,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X106,\"0.00#\"))","v":"U-0.052"},"U-0.052","U-0.052","U-0.052","U-0.044","U-0.052",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","steel frame U0.064 - all zones","steel frame",23,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X107,\"0.00#\"))","v":"U-0.055"},"U-0.049","U-0.055","U-0.055","U-0.044","U-0.055",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","wood frame/other U0.057 zi, U 0.051z2","wood frame/other",24,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(X108,\"0.00#\"))","v":"U-0.054"},"U-0.051","U-0.051","U-0.054","U-0.044","U-0.057",null,null,null,"set occ.","set zone"]

{"sheet":"ENV-SHGC","index":7,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[19,6,20,6],[35,6,36,6],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
["SHGC Calculation",null,null,null,null,null,{"$f":"'TA1'!$C$101","v":" "},null,null,"ENV-SHGC"]
[{"$f":"'ENV-SUM'!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised Oct 2013"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,{"$f":"IF('ENV-SUM'!$C$3=\"1 - This address line will copy onto other forms\",\"1 - Fill this line out on ENV-SUM\",'ENV-SUM'!$C$3)","v":"1 - Fill this line out on ENV-SUM"},null,null,null,null,"Date",{"$f":"TEXT('ENV-SUM'!$G$3,\"mm/dd/yyyy\")","v":"05/21/2013"}]
["Fenestration Area as % gross above-grade wall area",null,null,null,{"$f":"IF('ENV-SUM'!G17>0,'ENV-SUM'!G17,0)","v":""},null,{"$f":"'TA1'!D15","v":0},"For Building Department Use"]
["Skylight Area as % gross roof area",null,null,null,{"$f":"IF('ENV-SUM'!G19>0,'ENV-SUM'!G19,0)","v":""},null,{"$f":"'TA1'!D64","v":0}]
["Vertical  Fenestration Alternates:",null,{"$f":"'TA1'!B95","v":"None Selected on ENV-SUM"}]
[]
[]
["  Skylights",null,null,null,null,"Proposed SHGC",null,"Target SHGC"]
["Provide source of SHGC, page/plan # of assembly detail & ID",null,null,null,"SHGC","x Area (A)","= SHGC x A","SHGC","x Area (A) =","SHGC x A"]
["  ID:",null,null,null,null,null,{"$f":"IF(AND(F11=0,E11=0),0,IF(OR(F11=0,E11=0),NA(),F11*E11))","v":0},{"$f":"'TA1'!AL88","v":"set occ."},{"$f":"'TA1'!J79","v":0},{"$f":"IF(TYPE(H11*I11)<>1,0,H11*I11)","v":0}]
["  ID:",null,null,null,null,null,{"$f":"IF(AND(F12=0,E12=0),0,IF(OR(F12=0,E12=0),NA(),F12*E12))","v":0},"SHGC",null,{"$f":"'TA1'!AL117","v":"set occ."}]
["  ID:",null,null,null,null,null,0]
["  ID:",null,null,null,null,null,{"$f":"IF(AND(F14=0,E14=0),0,IF(OR(F14=0,E14=0),NA(),F14*E14))","v":0}]
["  ID:",null,null,null,null,null,0]
[null,null,null,null,"Totals",{"$f":"SUM(F10:F15)","v":0},{"$f":"SUM(G10:G15)","v":0},"Totals",{"$f":"SUM(I10:I15)","v":0},{"$f":"SUM(J10:J15)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(F16-'TA1'!F59)>0.1,IF(F16>'TA1'!F59,CONCATENATE(\"More proposed skylight area here than ENV-UA - Remove  \",TEXT('TA1'!F59-F16,\"0.0\")),CONCATENATE(\"Less proposed skylight area here than ENV-UA - Add  \",TEXT('TA1'!F59-F16,\"0.0\" )) ),\" \")","v":" "}]
[]
[" All Non-North Vertical Fenestration+",null,null,null,"Proposed SHGC",null,"PF Category","Target SHGC ++"]
[null,null,"PF","SHGC*","x Area (A)","= SHGC x A",null,"SHGC","x Area (A) =","SHGC x A"]
["  ID:",null,0,null,null,{"$f":"IF(AND(E22=0,D22=0),0,IF(OR(E22=0,D22=0),NA(),E22*D22))","v":0},"PF < 0.2",{"$f":"'TA1'!AL85","v":"set occ."},{"$f":"'TA1'!J44","v":0},{"$f":"IF(TYPE(H22*I22)<>1,0,H22*I22)","v":0}]
["  ID:",null,0,null,null,0,"0.2≤PF<0.5",{"$f":"'TA1'!AL86","v":"set occ."},{"$f":"'TA1'!J45","v":0},{"$f":"IF(TYPE(H23*I23)<>1,0,H23*I23)","v":0}]
["  ID:",null,0,null,null,0,"PF ≥ 0.5",{"$f":"'TA1'!AL87","v":"set occ."},{"$f":"'TA1'!J46","v":0},{"$f":"IF(TYPE(H24*I24)<>1,0,H24*I24)","v":0}]
["  ID:",null,0,null,null,0]
["  ID:",null,0,null,null,0]
["  ID:",null,0,null,null,0]
["  ID:",null,0,null,null,0]
["  ID:",null,0,null,null,0]
["  ID:",null,0,null,null,0]
["  ID:",null,0,null,null,0,null,null,null,null,null,null,0]
[null,null,null,"Totals",{"$f":"SUM(E21:E31)","v":0},{"$f":"SUM(F21:F31)","v":0},null,"Totals",{"$f":"SUM(I21:I31)","v":0},{"$f":"SUM(J21:J31)","v":0}]
[]
[]
[]
["  North Vertical Fenestration+",null,null,null,"Proposed SHGC",null,"PF Category","Target SHGC++"]
[null,null,"PF","SHGC*","x Area (A)","= SHGC x A",null,"SHGC","x Area (A) =","SHGC x A"]
["  ID:",null,0,null,null,{"$f":"IF(AND(E38=0,D38=0),0,IF(OR(E38=0,D38=0),NA(),E38*D38))","v":0},"PF < 0.2",{"$f":"'TA1'!AL89","v":"set occ."},{"$f":"'TA1'!J48","v":0},{"$f":"IF(TYPE(H38*I38)<>1,0,H38*I38)","v":0}]
["  ID:",null,0,null,null,0,"0.2≤PF<0.5",{"$f":"'TA1'!AL90","v":"set occ."},{"$f":"'TA1'!J49","v":0},{"$f":"IF(TYPE(H39*I39)<>1,0,H39*I39)","v":0}]
["  ID:",null,0,null,null,0,"PF ≥ 0.5",{"$f":"'TA1'!AL91","v":"set occ."},{"$f":"'TA1'!J50","v":0},{"$f":"IF(TYPE(H40*I40)<>1,0,H40*I40)","v":0}]
["  ID:",null,0,null,null,0]
["  ID:",null,0,null,null,0]
["  ID:",null,0,null,null,{"$f":"IF(AND(E43=0,D43=0),0,IF(OR(E43=0,D43=0),NA(),E43*D43))","v":0}]
["  ID:",null,0,null,null,0]
[null,null,null,"North Total",{"$f":"SUM(E37:E44)","v":0},{"$f":"SUM(F37:F44)","v":0},{"$f":"SUM(G37:G44)","v":0},null,{"$f":"SUM(I37:I44)","v":0},{"$f":"SUM(J37:J44)","v":0}]
[]
[null,null,null,null,null,"Area","SHGC x A",null,"Area","SHGC x A"]
[null,null,null,null,"Grand\nTotal",{"$f":"F16+E32+E45","v":0},{"$f":"G16+F32+F45","v":0},"Grand\nTotal",{"$f":"I16+I32+I45","v":0},{"$f":"J16+J32+J45","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS((E32+E45)-'TA1'!F12)>0.1,IF((E32+E45)>'TA1'!F12,CONCATENATE(\"More proposed vertical fenestration here than ENV-UA - Remove  \",TEXT('TA1'!F12-(E32+E45),\"0.0\")),CONCATENATE(\"Less proposed vertical fenestration here than ENV-UA: Add  \",TEXT('TA1'!F12-(E32+E45),\"0.0\" )) ),\"\")","v":""}]
["Component Performance Compliance (SHGC)",null,null,null,null,null,null,null,null,{"$f":"IF(OccGroup=3,\"Occupancy Group not selected\",IF(AND(J50=\"\",G48>0,J48>0),IF(G48>J48+0.00001,\"SHGC DOES NOT COMPLY\",\"SHGC COMPLIES\"),\"\"))","v":"Occupancy Group not selected"}]

{"sheet":"ENV-CHK","index":8,"n_rows":127,"n_cols":6,"rows_kept":127,"cut":false,"hidden":false,"merged":[[14,5,15,5],[75,5,76,5],[75,4,76,4],[75,0,76,0],[75,1,76,1],[75,2,76,2],[73,0,74,0],[73,1,74,1],[73,2,74,2],[73,4,74,4],[73,5,74,5],[70,5,71,5],[70,4,71,4],[70,2,71,2],[70,1,71,1],[70,0,71,0],[68,0,69,0],[68,1,69,1],[68,2,69,2],[68,4,69,4],[68,5,69,5],[65,5,67,5],[65,4,67,4],[65,2,67,2],[65,1,67,1],[65,0,67,0],[63,0,64,0],[63,1,64,1],[63,2,64,2],[63,4,64,4],[63,5,64,5],[55,0,56,0],[55,1,56,1],[55,2,56,2],[55,4,56,4],[55,5,56,5],[52,5,54,5],[52,4,54,4],[52,2,54,2],[52,1,54,1],[52,0,54,0],[49,0,51,0],[49,1,51,1],[49,2,51,2],[49,4,51,4],[49,5,51,5],[58,0,61,0],[58,1,61,1],[58,2,61,2],[58,4,61,4],[58,5,61,5],[38,5,40,5],[38,4,40,4],[38,2,40,2],[38,1,40,1],[38,0,40,0],[35,0,37,0],[35,1,37,1],[35,2,37,2],[35,4,37,4],[35,5,37,5],[32,0,34,0],[32,1,34,1],[32,2,34,2],[32,4,34,4],[32,5,34,5],[28,0,30,0],[28,1,30,1],[28,2,30,2],[28,4,30,4],[28,5,30,5],[3,0,3,5],[86,0,86,5],[14,0,15,0],[14,1,15,1],[14,2,15,2],[14,4,15,4],[16,0,20,0],[16,1,20,1],[16,2,20,2],[16,4,20,4],[16,5,20,5],[22,0,27,0],[22,1,27,1],[22,2,27,2],[22,4,27,4],[22,5,27,5]]}
["Building Permit Plans Checklist, pg. 1",null,null,null,null,"ENV-CHK"]
[{"$f":"ReadMe!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "}]
["Project Address",null,{"$f":"IF('ENV-SUM'!$C$3=\"1 - This address line will copy onto other forms\",\"1 - Fill this line out on ENV-SUM\",'ENV-SUM'!$C$3)","v":"1 - Fill this line out on ENV-SUM"},null,"Date",{"$f":"'ENV-SUM'!G3","v":"2013-05-21"}]
["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 (yes,no,na) ","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
["SCOPE "]
[null,"C101.5.2","Low energy spaces","Low energy spaces identified on plans"]
[null,"C101.5.2.1\nC402.1.4","Semi-heated spaces","Semi-heated spaces identified on plans"]
[null,"C402.5 C402.6","Cooler and freezer spaces","Walk-in and refrigerated warehouse cooler and freezer spaces identified on plans"]
[null,"C101.4.6","Mixed occupancy","Spaces with different occupancy requirements identified on plans"]
[null,"C101.4.4 C101.4.5","Change of occupancy/space conditioning","Existing F, S and U-occupancy building spaces undergoing a change of occupancy or space conditioning that require compliance are identified on plans"]
["ENVELOPE PROVISIONS"]
[null,"C303.1","Insulation identification","Indicate identification mark shall be applied to all insulation materials"]
[null,"C303.1.3 C402.4.3","Fenestration product rating","Fenestration products shall be labeled with rated U-factor, SHGC, VT, and  leakage rating"]
[null,"C303.1.1 C402.2 ","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,"C402.2.1","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 calculations for sloped insulation installed entirely above deck;"]
[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.1","Skylight curb insulation","Indicate curb insulation R-value on roof section if not included in skylight NFRC rating"]
[null,"C402.2.3 C402.2.4 C303.2.1","Above/below grade wall insulation","Indicate R-value(s) of cavity/continuous insulation on wall sections;  "]
[null,null,null,"Indicate framing materials on wall sections; "]
[null,null,null,"Indicate method of framing for wood const per A103.2 (std, int, adv);"]
[null,null,null,"Indicate mass of masonry walls;"]
[null,null,null,"Indicate loose-fill core insulation material, percentage of cores filled, and frequency of grouted cores and bond beams for masonry walls;"]
[null,null,null,"Indicate method of protection of exposed exterior basement/crawlspace wall insulation"]
[null,"C402.5 C402.6","Walk-in/refrigerated warehouse cooler and freezer insulation","Indicate insulation R-values of ceilings, walls, doors, floors on sections;"]
[null,null,null,"Indicate method of minimizing door infiltration;"]
[null,null,null,"Indicate type(s) of transparent doors and windows"]
[null,"C402.2.7","Opaque doors","Indicate rated U-factor (swinging) or R-value (roll-up/sliding) on wall sections - 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 mass of masonry floors"]
[null,"C402.2.6 C303.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 C303.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) "]
[]
["Building Permit Plans Checklist, pg. 2",null,null,null,null,"ENV-CHK"]
["2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1"]
["Project Address",null,{"$f":"IF('ENV-SUM'!$C$3=\"1 - This address line will copy onto other forms\",\"1 - Fill this line out on ENV-SUM\",'ENV-SUM'!$C$3)","v":"1 - Fill this line out on ENV-SUM"},null,"Date",{"$f":"F3","v":"2013-05-21"}]
["Applicability (yes,no,na) ","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
[null,"C402.3.1","Vertical fenestration maximum area","Provide calculation for total vertical fenestration area as percentage of gross above grade wall area"]
[null,"C402.3.1.2","Skylight maximum area","Provide calculation for total skylight area as percentage of gross roof area"]
[null,"C402.3.3 C402.3.1.3 C303.1.3","U-factors, SHGC and VT for all fenestration assemblies","Indicate U-factors, SHGC and VT values in fenestration schedules;"]
[null,null,null,"An area-weighted U-value may be used for all fenestration elements that qualify within the same fenestration category per Table C402.3;"]
[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.3.1.1 Chap. 2 Definition","Increased max. vertical fenestration area with daylighting controls","Provide calculations showing that percentage of overall conditioned floor area in the daylight zone is equal to or greater than 50%; "]
[null,null,null,"Indicate method of daylighting control in lighting equipment schedules;"]
[null,null,null,"Indicate VT of vertical fenestration is at least 1.1 times the rated SHGC"]
[null,"C402.3.1.2","Increased max. vertical fenestration area with high-performance glazing","Indicate high performance U-factors and SHGC values in fenestration schedules; "]
[null,null,null,"An area-weighted U-value may be used for all fenestration elements that qualify within the same fenestration category per this section"]
[null,"C402.3.3 C402.3.3.1","Permanent shading devices","Provide projection factor calculations (Equation C4-2) and associated SHGC multipliers for north and non-north orientations"]
[null,"C402.3.2","Single story spaces requiring skylights","Provide calculations for percentage of conditioned floor area located within a skylight daylight zone;"]
[null,null,null,"Provide calculations for percentage of skylight area to daylight zone under skylights, OR;"]
[null,null,null,"Provide calculations for percentage of overall skylight effective aperture (Equation C4-1);"]
[null,null,null,"Indicate haze factor of skylight glazing material or diffuser"]
["AIR LEAKAGE"]
[null,"C402.4.1.1 C402.4.2","Air barrier construction and sealing","Indicate location of continuous air barrier on 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.4.5.1","Stairway and shaft vents","Indicate locations of all stairway and shaft vents;  "]
[null,null,null,"Provide leakage rating of motorized dampers in mechanical equipment schedules;"]
[null,null,null,"Indicate method of emergency operation - activation of fire alarm or interruption of power"]
[null,"C402.4.5.2","Outdoor air intakes, exhausts and relief openings","Indicate locations of all outside air intakes, exhausts and relief outlets, including those integral to mechanical equipment;"]
[null,null,null,"Provide in mechanical equipment schedules leakage rating of dampers, identify whether motorized or gravity, and note any exceptions taken "]
[null,"C402.4.8","Recessed lighting in building envelope ","Indicate IC rating of fixtures in lighting equipment schedules;"]
[null,null,null,"Indicate method of sealing between light fixture housing and wall or ceiling"]
[null,"C402.4.6","Loading dock seals","Indicate weather seal at cargo and loading dock doors"]
[null,"C402.4.7","Vestibules","Indicate locations and dimensions of vestibules;"]
[null,null,null,"For unconditioned vestibules, indicate which envelope assembly (interior or exterior) complies with the requirements for a conditioned space"]
[null,"C402.4 - .1.2.3","Air barrier building  test","Indicate air barrier test method in accordance with ASTM E779 or approved equivalent; "]
[null,null,null,"Include the following requirements in project documents: (1) air barrier test report shall be submitted to jurisdiction once test is completed; (2) if test results exceed 0.4 cfm/ft2 at 0.3 in. wg then visually inspect air barrier and seal noted sources of leakage; (3) submit a follow-up report to jurisdiction noting corrective measures taken"]
["If \"no\" is selected for any question, provide explanation:  "]
[]
[]
[]
[]
[]
[]
[]
[]
["End of Building Permit Plans Checklist"]
[]
[]
["  Yes"]
["  No"]
["  N.A."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["na"]
["no"]
["yes"]

{"sheet":"temp","index":9,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]