{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["ReadMe","ENV-SUM","ENV-UA","TargetArea1","ENV-SHGC","ENV-VT","ENV-CHK","Sheet1","temp"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":57,"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":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Instructions for Electronic Forms"]
["2009 Seattle Energy Code Compliance Forms for Nonresidential and Multifamily Residential"]
[null,"Revised September 2011"]
[null,"     Chapters 11-16 of the 2009 Seattle Energy Code apply to all nonresidential occupancies and to all multifamily residential occupancies except those within the scope of the IRC (single family residential, duplexes, attached townhouses)."]
["Intro","     This file, 2009sec-ENV.XLS, has electronic compliance forms for Chapter 13 envelop provisions for Climate Zones 1 and 2.  There are two companion files: 2009sec-MECH.XLS (Chapter 14 mechanical systems requirements); and 2009sec-LTG.XLS (Chapter 15 lighting, motor, and transformer requirements)."]
[null,"     This form is a compliance aid and is not a substitute for the full energy code text or specific jusidiction compliance requirements.  In particular, this form is not to be used for cold storage areas.  Users should refer to the code text and contact the local jurisdiction for complete information.  The 2009 Seattle Energy code text is available for download at:"]
[null,"www.seattle.gov/dpd/energy"]
[null,"The 2009 Washington State Energy code text is available for download at:"]
[null,"www.ga.wa.gov/sbcc"]
["Start-up","     Open a working copy of this file and be sure to use Save As to save it to a new file name.  Alternatively, you can save the file as a template in the XLSTART subdirectory in the EXCEL directory, and open new copies with the \"File New\" menu command. Look for \"2009sec-ENV\"."]
["Overview","      This workbook file contains multiple worksheets.  Each worksheet is indicated by a tab at the bottom of the screen.  (If you don't see the tabs, visit menu option \"Tools-Options-View-Sheet Tabs\".)  You may visit each form by clicking on its tab.  "]
[null,"      Most calculations are automated.  The spaces which display the results of calculations are not editable.  Some adjustments to formatting have been made to facilitate electronic filling and calculation of the forms. "]
["Save Files","      Each time you open this file and start filling forms, you must save it under a new filename of your choosing using File Save As.  The original template file cannot be altered.  You may also save your own versions of the forms this way."]
["Getting Around","Each form has two pages (front and back).  Both pages are available on screen when you click the tab for a form.  Use the scroll bars to find the second page.  It is either to the right, below, or sometimes to the right and below the first page."]
["Filling Fields","      All project info and the date for all forms is entered once on \"ENV-SUM\" and automatically reproduced on the other forms. Always fill in the heading of ENV-SUM, even if you will not be using that form.  The other forms have a reminder to do this."]
[null,"      Only fillable fields are accessible.  If you try to edit any other field, you'll get an error message.  You may use the TAB key to move to the next fillable field.  If the TAB doesn't take you where you want to go, use the mouse.     "]
[null,"      Avoid excessively long text strings when entering information.  In some cases, text that extends beyond the available space will simply not be seen.  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 6/8/2006 or 12/21/2012."]
[null,"     Check boxes can be either blank, or checked-off with an \"x\" shown in the box.  To toggle between cases, click the box with your mouse.  Radio buttons  (circles) are either filled or unfilled.  Only one in a set may be filled."]
[null,"     Drop-down lists have an arrow at the right side of the space.  Click the arrow with your mouse and select the appropriate option.  One of the options is a blank."]
[null,"      When a form has a space for notes or explanation, click anywhere in the space to edit.  Your cursor will become a text editing insertion bar and you can edit as with a word processor."]
["Personal-\nizing","     You can personalize the forms with your company name, address, phone, or any other information.  This is done by editing the footer using File Page Setup Header/Footer.  You can then save the file under a new template name and re-use it again."]
["Adding Lines and","      Many tables, such as for listing equipment types, have a certain number of lines for entering data.  There may not always be enough lines for all the entries you need to make.  With this electronic version, you can add additional lines to the table."]
["Removing","     To add additional lines where this feature is available, click on the \"+\" button with your mouse.  This button is located to the right of the sheet.  If you can't see it, scroll right (or change the View Zoom setting to 83%). "]
[null,"     To remove lines that you have added, click on the \"-\" button with your mouse.  You cannot remove lines that were not added; an error appears if you try."]
[null,"      If you add additional lines with this method, the pagination will usually be affected.  The forms will be forced to carry additional lines over to other pages.  Be sure to submit all pages to the plans examiner."]
["Occupancy Group","     You must select a value for Occupancy Group on ENV-SUM (line 14) for this workbook to display the correct code requirements and automatically calculate component preformance target UA."]
["Fenestration vs Glazing","     The 2009 SEC uses the terms \"fenestration\" and \"glazing\" and the terms \"overhead glazing\" and \"skylight\" somewhat interchangably.  These forms use fenestration and skylight exclusively.  In general, \"vertical fenestration\" is equivalent to \"vertical glazing\" and \"skylight\" is equivalent to \"overhead glazing\".  "]
["Fenestration Area","     The Fenstration % shown on the ENV-SUM form is automatically calculated in the electronic version from the Proposed areas on the corresponding ENV-UA form.  These calculations follow those in equations 13-1 and 13-2."]
[null,"     If you use the Envelope Prescriptive Option, you still must enter the actual areas.  As a shortcut in this case, you can enter the vertical fenestration, the skylight and the opaque wall areas (including doors) as single numbers and leave the rest of the ENV-UA form blank."]
["Fenestration Adjustments","Under the Envelope Component Performance option, the Target Area Adjustment Calculations are fully automatic, using information you enter for on your project type and your Proposed Areas on the ENV-UA form.  Target areas are calculated automatically."]
["Printing","      The forms should print on any printer supported by Windows.  You will need to have the following TrueType fonts installed under Windows:  Arial, Times New Roman, Courrier New and Wingdings.  These are all standard Windows fonts."]
[null,"      If you are losing form or flowchart details when printing, you may have a shortage of printer memory.  Try printing problem pages individually."]
[null,"      By default, only selected forms are printed.  To select one or more forms, hold down the Ctrl key and click the tabs of the worksheets you need. Issue the File Print Selected Sheets command. To print the entire set, use File Print Entire Workbook."]
["Clean Forms","     It is possible to print clean, blank versions of these forms for hand filling.  To do so, delete all of the heading information at the beginning of ENV-SUM, select the desired Climate Zone and Occupancy Group, and make sure that all fillable cells in the forms are empty. Then print the clean forms.  "]
[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."]
["Partial Form Sets","     Forms in a set may not be deleted, because the file is locked, but you need not print all the forms, as explained in \"Printing\" above."," "]
["Re-Calcu\nlation","      As this is a large file, it may respond slowly to changes if it is set to automatically re-calculate after every action.  To set calculation to manual, visit the \"Tools-Options-Calculation\" menu item.  Then manually recalculate using the F9 key."]

{"sheet":"ENV-SUM","index":1,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,0,17,1],[16,2,17,6]]}
["Envelope Summary",null,null,null,{"$f":"TargetArea1!$B$71","v":""},null,"ENV-SUM",null,"Envelope Summary (back)",null,null,{"$f":"TargetArea1!$B$71","v":""},"ENV-SUM"]
[{"$f":"ReadMe!A2","v":"2009 Seattle Energy Code Compliance Forms for Nonresidential and Multifamily Residential"},null,null,null,null,null,{"$f":"ReadMe!B3","v":"Revised September 2011"},null,{"$f":"A2","v":"2009 Seattle Energy Code Compliance Forms for Nonresidential and Multifamily Residential"},null,null,null,{"$f":"G2","v":"Revised September 2011"}]
["Project Info","Project Address","1 - Always fill out this line on ENV-SUM1",null,null,"Date",{"$f":"TODAY()","v":"2013-11-15"},null,"Minimum Requirements"]
[null,null,"2 - Fill out this line on ENV-SUM1",null,null,"For Building Department Use",null,null,"for Prescriptive Option"]
[null,null,"3 - Fill out this line on ENV-SUM1"]
[null,"Applicant Name:","4 - Fill out this line on ENV-SUM1"]
[null,"Applicant Address:","5 - Fill out this line on ENV-SUM1"]
[null,"Applicant Phone:","6 - Fill out this line on ENV-SUM1"]
[]
["Project Description"]
[]
["Compliance Option"]
[]
["Occupancy Group"]
["r",null,"Total Fenestration\n(rough opening)\n(vertical & overhd)","divided by","Gross Exterior\nWall Area","\ntimes 100 equals","\n% Fenestration"]
[null,null,{"$f":"TargetArea1!A21","v":0},"¸",{"$f":"TargetArea1!A13","v":0},"X 100 =",{"$f":"IF(E16>0,C16/E16,0)","v":0}]
["Semi-Heated Path"]
[]
[]
["Envelope Requirements (enter values as applicable)",null,null,null,"Envelope Requirements ( continued )"]
[]
[null,null,"Minimum Insulation R-values"," ",null,null,"Maximum U-factors"]
["Roofs - Insulation Above Deck",null,null,null,"Vertical Fenestration"]
["Roofs - Metal Building",null,null,null,"   Non-Metal Frame"]
["Roofs - Single Rafter",null,null,null,"   Metal Frame"]
["Roofs - Attic and All Others",null,null,null,"   Entrance Door"]
["Walls - Mass w/ Ext./Integral Insulation",null,null,null,"Skylights - Without Curb"]
["Walls - Mass w/ Interior Insulation",null,null,null,"Skylights - With Curb"]
["Walls - Metal Building",null,null,null,"Opaque Doors - Swinging"]
["Walls - Steel Framed",null,null,null,"Opaque Doors - Non-Swinging"]
["Walls - Wood Framed and Other",null,null,null,null,null,"Maximum SHGC (or SC)"]
["Below Grade Walls",null,null,null,"Vertical Fenestration"]
["Floors - Mass",null,null,null,"   Non-North"]
["Floors - Steel Joist",null,null,null,"   North"]
["Floors - Wood Framed and Other",null,null,null,"Skylights"]
[null,null,"Maximum F-factors",null,null,null,"Minimum Visible Transmittance (VT)"]
["Slabs-on-Grade - Unheated",null,null,null,"Vertical Fenstration"]
["Slabs-on-Grade - Heated"]
["Notes:"]

{"sheet":"ENV-UA","index":2,"n_rows":112,"n_cols":12,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
["Envelope UA Calculations",null,null,null,null,null,null,null,null,{"$f":"TargetArea1!$B$71","v":""},null,"ENV-UA"]
[{"$f":"'ENV-SUM'!A2","v":"2009 Seattle Energy Code Compliance Forms for Nonresidential and Multifamily Residential"},null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!E2","v":0},null,{"$f":"'ENV-SUM'!G2","v":"Revised September 2011"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,null,null,null,{"$f":"'ENV-SUM'!$C$3","v":"1 - Always fill out this line on ENV-SUM1"},null,null,null,"Date",{"$f":"TEXT('ENV-SUM'!$G$3,\"mm/dd/yyyy\")","v":"11/15/2013"}]
["Occupancy Group",null,null,null,null,null,null,null,null,"For Building Department Use"]
["Fenestration Area as % gross exterior wall area",null,null,null,null,null,{"$f":"IF('ENV-SUM'!G16>0,'ENV-SUM'!G16,0)","v":0},"Max. Target:",{"$f":"TargetArea1!C13","v":0}]
[]
["Building Component ",null,null,null,null,null,null,"Proposed UA",null,"Target UA"]
[null,null,"Provide assembly ID & page/plan # for each bldg. element",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":"H9*G9","v":0},{"$f":"TargetArea1!T79","v":0},{"$f":"SUM(H9:H11)","v":0},{"$f":"IF(TYPE(J9*K9)<>1,0,J9*K9)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Above Deck Insulation",null,{"$f":"TargetArea1!T111","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T80","v":0},{"$f":"SUM(H12:H14)","v":0},{"$f":"IF(TYPE(J12*K12)<>1,0,J12*K12)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Metal Building",null,{"$f":"TargetArea1!T112","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T81","v":0},{"$f":"SUM(H15:H17)","v":0},{"$f":"IF(TYPE(J15*K15)<>1,0,J15*K15)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Single rafter",null,{"$f":"TargetArea1!T113","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T82","v":0},{"$f":"SUM(H18:H20)","v":0},{"$f":"IF(TYPE(J18*K18)<>1,0,J18*K18)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Attic, other",null,{"$f":"TargetArea1!T114","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T85","v":0},{"$f":"TargetArea1!I36","v":0},{"$f":"IF(TYPE(J21*K21)<>1,0,J21*K21)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Metal bldg",null,{"$f":"TargetArea1!T117","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T86","v":0},{"$f":"TargetArea1!I37","v":0},{"$f":"IF(TYPE(J24*K24)<>1,0,J24*K24)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Steel frame",null,{"$f":"TargetArea1!T118","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T87","v":0},{"$f":"TargetArea1!I38","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":"TargetArea1!T119","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T83","v":0},{"$f":"TargetArea1!I39","v":0},{"$f":"IF(TYPE(J30*K30)<>1,0,J30*K30)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Mass w/ ext. ins",null,{"$f":"TargetArea1!T115","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T84","v":0},{"$f":"TargetArea1!I40","v":0},{"$f":"IF(TYPE(J33*K33)<>1,0,J33*K33)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Mass w/ int. ins",null,{"$f":"TargetArea1!T116","v":"set occ."}]
[null,null," Proposed assembly U-factor from Tables 10-5 thru 10-5B",null,null,null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T94","v":0},{"$f":"SUM(H36:H38)","v":0},{"$f":"IF(TYPE(J36*K36)<>1,0,J36*K36)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Assumed to be Mass Wall",null,{"$f":"TargetArea1!T126","v":"set occ."}]
[null,null," Proposed assembly U-factor from Tables 10-5 thru 10-5B.  Do  NOT use Table 10-1."]
[null,null,"R=",null,"ID:",null,null,null,{"$f":"H39*G39","v":0},{"$f":"TargetArea1!T94","v":0},{"$f":"SUM(H39:H41)","v":0},{"$f":"IF(TYPE(J39*K39)<>1,0,J39*K39)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,{"$f":"H40*G40","v":0},"Assumed to be Mass Wall",null,{"$f":"TargetArea1!T126","v":"set occ."}]
[null,null," Proposed assembly U-factor from Tables 10-5 thru 10-5B.  Do  NOT use Table 10-1."]
[null,null,"R=",null,"ID:",null,null,null,{"$f":"H42*G42","v":0},{"$f":"TargetArea1!T89","v":0},{"$f":"SUM(H42:H44)","v":0},{"$f":"IF(TYPE(J42*K42)<>1,0,J42*K42)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Mass",null,{"$f":"TargetArea1!T121","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T90","v":0},{"$f":"SUM(H45:H47)","v":0},{"$f":"IF(TYPE(J45*K45)<>1,0,J45*K45)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Steel Joist",null,{"$f":"TargetArea1!T122","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T91","v":0},{"$f":"SUM(H48:H50)","v":0},{"$f":"IF(TYPE(J48*K48)<>1,0,J48*K48)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Wood Frame / other",null,{"$f":"TargetArea1!T123","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,{"$f":"H52*G52","v":0},{"$f":"TargetArea1!T92","v":0},{"$f":"SUM(H52:H54)","v":0},{"$f":"IF(TYPE(J52*K52)<>1,0,J52*K52)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Slab-On-Grade",null,{"$f":"TargetArea1!T124","v":"set occ."}]
[null,null,"R=",null,"ID:",null,null,null,0]
[null,null,"R=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T93","v":0},{"$f":"SUM(H55:H57)","v":0},{"$f":"IF(TYPE(J55*K55)<>1,0,J55*K55)","v":0}]
[null,null,"R=",null,"ID:",null,null,null,0,"Heated Slab-On-Grade",null,{"$f":"TargetArea1!T125","v":"set occ."}]
[null,null," Proposed assembly F-factors can use the unheated values in Table 10-2 ",null,null,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(H9:H57)","v":0},{"$f":"SUM(I9:I57)","v":0},null,{"$f":"K55+K52+K48+K45+K42+K39+K36+K33+K30+K27+K24+K21+K18+K15+K12+K9","v":0},{"$f":"L55+L52+L48+L45+L42+L39+L36+L33+L30+L27+L24+L21+L18+L15+L12+L9","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L101","v":""}]
["Envelope UA, continued.",null,null,null,null,null,null,null,null,{"$f":"TargetArea1!$B$71","v":""},null,"ENV-UA"]
[{"$f":"'ENV-SUM'!A59","v":0},null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!E59","v":0},null,{"$f":"'ENV-SUM'!G59","v":0}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,null,null,null,{"$f":"'ENV-SUM'!$C$3","v":"1 - Always fill out this line on ENV-SUM1"},null,null,null,"Date",{"$f":"TEXT('ENV-SUM'!$G$3,\"mm/dd/yyyy\")","v":"11/15/2013"}]
["Fenestration Area as % gross exterior wall area",null,null,null,null,null,{"$f":"IF('ENV-SUM'!G16>0,'ENV-SUM'!G16,0)","v":0},"Max. Target:",{"$f":"TargetArea1!C13","v":0},"For Building Department Use"]
[]
["Building Component ",null,null,null,null,null,null,"Proposed UA",null,"Target UA"]
[null,null,"Provide assembly ID & page/plan # for each bldg. element",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":"H70*G70","v":0},{"$f":"TargetArea1!T77","v":0},{"$f":"SUM(H70:H72)","v":0},{"$f":"IF(TYPE(J70*K70)<>1,0,J70*K70)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Non-swing Doors",null,{"$f":"TargetArea1!T109","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T78","v":0},{"$f":"SUM(H73:H75)","v":0},{"$f":"IF(TYPE(J73*K73)<>1,0,J73*K73)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Swing Doors",null,{"$f":"TargetArea1!T110","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T72","v":0},{"$f":"TargetArea1!I28","v":0},{"$f":"IF(TYPE(J76*K76)<>1,0,J76*K76)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Metal Frame",null,{"$f":"TargetArea1!T104","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":"TargetArea1!T73","v":0},{"$f":"TargetArea1!I29","v":0},{"$f":"IF(TYPE(J80*K80)<>1,0,J80*K80)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Non-Metal Frame"]
[null,null,"U=",null,"ID:",null,null,null,0,"0%-30%",null,{"$f":"TargetArea1!T132","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0,"30%-40%",null,{"$f":"TargetArea1!T133","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T74","v":0},{"$f":"TargetArea1!I30","v":0},{"$f":"IF(TYPE(J84*K84)<>1,0,J84*K84)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Metal Entance Door",null,{"$f":"TargetArea1!T106","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":"TargetArea1!T75","v":0},{"$f":"TargetArea1!I33","v":0},{"$f":"IF(TYPE(J88*K88)<>1,0,J88*K88)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Without Curb"]
[null,null,"U=",null,"ID:",null,null,null,0,"0%-30%",null,{"$f":"TargetArea1!T134","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0,"30%-40%",null,{"$f":"TargetArea1!T135","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0,{"$f":"TargetArea1!T76","v":0},{"$f":"TargetArea1!I34","v":0},{"$f":"IF(TYPE(J92*K92)<>1,0,J92*K92)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,0,"Including Curb"]
[null,null,"U=",null,"ID:",null,null,null,0,"0%-30%",null,{"$f":"TargetArea1!T136","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,0,"30%-40%",null,{"$f":"TargetArea1!T137","v":"set occ."}]
[]
[null,null,null,null,null,null,null,"Area","UA",null,"Area","UA"]
[null,null,null,null,null,null,"Page 2 Subtotal ",{"$f":"SUM(H70:H95)","v":0},{"$f":"SUM(I70:I95)","v":0},null,{"$f":"K92+K88+K84+K80+K76+K73+K70","v":0},{"$f":"L92+L88+L84+L80+L76+L73+L70","v":0}]
[null,null,null,null,null,null,"Page 1 Subtotal ",{"$f":"H60","v":0},{"$f":"I60","v":0},null,{"$f":"K60","v":0},{"$f":"L60","v":0}]
["To comply:",null,null,null,null,null,"Total ",{"$f":"H99+H98","v":0},{"$f":"I99+I98","v":0},null,{"$f":"K99+K98","v":0},{"$f":"L99+L98","v":0}]
[null,null,"1) Proposed Total UA shall not exceed Target Total UA.",null,null,null,null,null,null,null,null,{"$f":"IF(I100>L100+0.00001,\"UA DOES NOT COMPLY\",\"\")","v":""}]
[null,null,"2) Proposed Total Area shall equal Target Total Area."]
[]
[{"$f":"IF(Occupancy=2,\"Table 13-1 Footnote 2 not allowed in residential occupancies\",\"Table 13-1 Footnote 2 Operable Vertical  Fenestration\")","v":"Table 13-1 Footnote 2 Operable Vertical  Fenestration"},null,null,null,null,null,null,"Proposed UA",null,"Target UA"]
[null,null,"Provide assembly ID & page/plan # for each bldg. element",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":"H106*G106","v":0},{"$f":"IF(I111>0,0.45,\"\")","v":""},{"$f":"H111*TargetArea1!$I$21","v":0},{"$f":"IF(TYPE(J106*K106)<>1,0,J106*K106)","v":0}]
[null,null,"U=",null,"ID:",null,null,null,{"$f":"H107*G107","v":0},"Operable Metal Frame",null,{"$f":"IF(Occupancy=1,\"U-0.45\",IF(Occupancy=3,\"set occ.\",\"Not Allowed\"))","v":"set occ."}]
[null,null,"U=",null,"ID:",null,null,null,{"$f":"H108*G108","v":0}]
[null,null,"U=",null,"ID:",null,null,null,{"$f":"H109*G109","v":0}]
[null,null,null,null,null,null,null,"Area","UA",null,"Area","UA"]
[null,null,null,null,null,null,"Operable Fenestration Total",{"$f":"SUM(H106:H109)","v":0},{"$f":"SUM(I106:I109)","v":0},null,{"$f":"K106","v":0},{"$f":"L106","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I111>0,IF(Occupancy=2,\"Footnote 2 not allowed for residential projects\",IF(G5>0.4,\"Footnote 2 requires total fenestration to be <= 40%\",IF(H111/TargetArea1!E9>0.1,\"Footnote 2 area must be <= 10% of total vertical fenestration\",IF(I111>L111+0.00001,\"Operable Vertical Fenestration UA DOES NOT COMPLY\",\"\")))),\"\")","v":""}]

{"sheet":"TargetArea1","index":3,"n_rows":138,"n_cols":54,"rows_kept":138,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Target Area Adjustment Calculations    All Climates"]
[]
[]
[]
[null,null,null,"Proposed Areas"]
[null,null,null,"Above Grade Walls",null,null,"Doors & BG Walls"]
["Fenestration ->","SKY=",{"$f":"SUM('ENV-UA'!H88:H95)","v":0},"VF=",{"$f":"SUM('ENV-UA'!H76:H87,'ENV-UA'!H111)","v":0},null,"0"]
["Opaque ->",null,null,"NW=",{"$f":"SUM('ENV-UA'!H21:H35)","v":0},"DBG=",{"$f":"SUM('ENV-UA'!H36:H38)+SUM('ENV-UA'!H70:H75)","v":0}]
[]
["Gross Exterior Wall Area",null,"Max Fenestration %\n(Table 13-1)",null,null,null,"Maximum Target Fenestration Area"]
[{"$f":"(SUM(E9:G10))","v":0},"x",{"$f":"T99","v":0},"¸",100,"=",{"$f":"A13*C13","v":0}]
[]
[]
["Total Fenestration",null,null,null,"Excess Fenestration",null,"0",null,"Excess Fenestration"]
[{"$f":"C9+E9","v":0},"-",{"$f":"G13","v":0},"=",{"$f":"A17-C17","v":0},"-","ô lesser","=",{"$f":"MAX(0,G18)","v":0}]
[null,null,null,null,null,null,{"$f":"E17","v":0}]
[]
["Total Fenestration",null,"Excess Fenestration",null,"Target Fenestration",null,"Total Fenestration",null,"Target Fen. 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."]
[{"$f":"A17","v":0},"-",{"$f":"I17","v":0},"=",{"$f":"A21-C21","v":0},"¸",{"$f":"A21","v":0},"=",{"$f":"IF(G21>0,E21/G21,0)","v":0}]
[]
["Net AG  Wall Area",null,"Excess Fenestration",null,"Target Net Wall Area",null,"Net Wall",null,"Target Net Wall Mult."]
[{"$f":"E10","v":0},"+",{"$f":"C21","v":0},"=",{"$f":"A24+C24","v":0},"¸",{"$f":"A24","v":0},"=",{"$f":"IF(G24>0,E24/G24,0)","v":0}]
[]
[]
[null,null,"Vertical Fenestration",null,"Proposed Area",null,"Target Fen. Mult.",null,"Target Area",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,"metal frame",null,{"$f":"SUM('ENV-UA'!H76:H79)","v":0},"x",{"$f":"IF(E28>0,$I$21,0)","v":0},"=",{"$f":"E28*G28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nres",null,null,"Res",null,null,"Refg",null,null,null,null,null,null,null,null,null,"Nres",null,null,"Res",null,null,"Refg"]
[null,null,"non-metal frame",null,{"$f":"SUM('ENV-UA'!H80:H83)","v":0},"x",{"$f":"IF(E29>0,$I$21,0)","v":0},"=",{"$f":"E29*G29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"pct glass",null,null,"Seattle",null,null,"Seattle",null,null,"Seattle",null,null,null,null,"SHGC",null,null,null,null,"Seattle",null,null,"Seattle",null,null,"Seattle"]
[null,null,"metal entrance",null,{"$f":"SUM('ENV-UA'!H84:H87)","v":0},"x",{"$f":"IF(E30>0,$I$21,0)","v":0},"=",{"$f":"E30*G30","v":0},null,null,null,null,null,null,null,null,null,null,"Window","Metal Frame",0,null,null,0.38,null,null,0.4,null,null,0.38,null,null,null,null,"Window",null,0,null,null,0.35,null,null,"No Req.",null,null,0.35]
[null,null,"operable-footnote 2",null,{"$f":"'ENV-UA'!H111","v":0},"x",{"$f":"IF(E31>0,$I$21,0)","v":0},"=",{"$f":"E31*G31","v":0},null,null,null,null,null,null,null,null,null,null,"Window","Metal Frame",0.3,null,null,0.38,null,null,0.4,null,null,0.38,null,null,null,null,"Window",null,0.3,null,null,0.35,null,null,"No Req.",null,null,0.35]
[null,null,"Skylight",null,"Proposed Area",null,"Target Fen. Mult.",null,"Target Area",null,null,null,null,null,null,null,null,null,null,"Window","Metal Frame",0.4,null,null,0.38,null,null,0.4,null,null,0.38,null,null,null,null,"Window",null,0.4,null,null,0.33,null,null,"No Req.",null,null,0.33]
[null,null,"without curb",null,{"$f":"SUM('ENV-UA'!H88:H91)","v":0},"x",{"$f":"IF(E33>0,$I$21,0)","v":0},"=",{"$f":"E33*G33","v":0},null,null,null,null,null,null,null,null,null,null,"Window","non-metal frame",0,null,null,0.3,null,null,0.32,null,null,0.3,null,null,null,null,"Window","pf>0.5",0,null,null,0.45,null,null,"No Req.",null,null,0.35]
[null,null,"with curb",null,{"$f":"SUM('ENV-UA'!H92:H95)","v":0},"x",{"$f":"IF(E34>0,$I$21,0)","v":0},"=",{"$f":"E34*G34","v":0},null,null,null,null,null,null,null,null,null,null,"Window","non-metal frame",0.3,null,null,0.3,null,null,0.32,null,null,0.3,null,null,null,null,"Window","pf>0.5",0.3,null,null,0.45,null,null,"No Req.",null,null,0.35]
[null,null,"AG Wall",null,"Proposed Area",null,"Target Net Wall Mult.",null,"Target Area",null,null,null,null,null,null,null,null,null,null,"Window","non-metal frame",0.4,null,null,0.28000000000000003,null,null,0.32,null,null,0.28000000000000003,null,null,null,null,"Window","pf>0.5",0.4,null,null,0.45,null,null,"No Req.",null,null,0.33]
[null,null,"Metal Building",null,{"$f":"SUM('ENV-UA'!H21:H23)","v":0},"x",{"$f":"IF(E36>0,$I$24,0)","v":0},"=",{"$f":"E36*G36","v":0},null,null,null,null,null,null,null,null,null,null,"Window","metal entrance door",0,null,null,0.6,null,null,0.6,null,null,0.6,null,null,null,null,"Skylight",null,0,null,null,0.32,null,null,0.35,null,null,0.32]
[null,null,"Steel Frame",null,{"$f":"SUM('ENV-UA'!H24:H26)","v":0},"x",{"$f":"IF(E37>0,$I$24,0)","v":0},"=",{"$f":"E37*G37","v":0},null,null,null,null,null,null,null,null,null,null,"Window","metal entrance door",0.3,null,null,0.6,null,null,0.6,null,null,0.6,null,null,null,null,"Skylight",null,0.3,null,null,0.32,null,null,0.35,null,null,0.32]
[null,null,"Wood/Other frame",null,{"$f":"SUM('ENV-UA'!H27:H29)","v":0},"x",{"$f":"IF(E38>0,$I$24,0)","v":0},"=",{"$f":"E38*G38","v":0},null,null,null,null,null,null,null,null,null,null,"Window","metal entrance door",0.4,null,null,0.6,null,null,0.6,null,null,0.6,null,null,null,null,"Skylight",null,0.4,null,null,0.3,null,null,0.35,null,null,0.3]
[null,null,"Mass w/  Exterior Ins.",null,{"$f":"SUM('ENV-UA'!H30:H32)","v":0},"x",{"$f":"IF(E39>0,$I$24,0)","v":0},"=",{"$f":"E39*G39","v":0}]
[null,null,"Mass w/  Interior Ins.",null,{"$f":"SUM('ENV-UA'!H33:H35)","v":0},"x",{"$f":"IF(E40>0,$I$24,0)","v":0},"=",{"$f":"E40*G40","v":0},null,null,null,null,null,null,null,null,null,null,"Skylight","Without Curb",0,null,null,0.45,null,null,0.5,null,null,0.45,null,null,null,null,"N. Window",null,0,null,null,0.45,null,null,"No Req.",null,null,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight","Without Curb",0.3,null,null,0.45,null,null,0.5,null,null,0.45,null,null,null,null,"N. Window",null,0.3,null,null,0.45,null,null,"No Req.",null,null,0.45]
[null,null,null,"Sum of Proposed  ",{"$f":"SUM(E28:E40)","v":0},null,null,"Sum of Target  ",{"$f":"SUM(I28:I40)","v":0},null,null,null,null,null,null,null,null,null,null,"Skylight","Without Curb",0.4,null,null,0.4,null,null,0.5,null,null,0.4,null,null,null,null,"N. Window",null,0.4,null,null,0.43,null,null,"No Req.",null,null,0.43]
["SHGC Target Area Calculation"]
[null,null,"Total Fenestration",null,"Footnote 1 Skylight",null,"Total SHGC Fen."]
[null,null,{"$f":"A17","v":0},"-",{"$f":"'ENV-SHGC'!G53","v":0},"=",{"$f":"C45-E45","v":0}]
[]
["Target Fenestration",null,"Footnote 1 Skylight",null,"Target SHGC Fen.",null,"Total SHGC Fen.",null,"Target SHGC Multiplier"]
[{"$f":"E21","v":0},"-",{"$f":"E45","v":0},"=",{"$f":"A48-C48","v":0},"¸",{"$f":"G45","v":0},"=",{"$f":"IF(G48>0,E48/G48,0)","v":0}]
[]
[null,null,"SHGC Calculation",null,"Proposed Area",null,"Target SHGC Mult.",null,"Target Area"]
[null,null,"Skylights (all)",null,{"$f":"'ENV-SHGC'!G16","v":0},"x",{"$f":"IF(E51>0,$I$48,0)","v":0},"=",{"$f":"E51*G51","v":0}]
[null,null,"Non-North Vertical Fenestration",null,{"$f":"'ENV-SHGC'!G27","v":0},"x",{"$f":"IF(E52>0,$I$48,0)","v":0},"=",{"$f":"E52*G52","v":0}]
[null,null,"North Vertical Fenestration",null,{"$f":"'ENV-SHGC'!G39","v":0},"x",{"$f":"IF(E53>0,$I$48,0)","v":0},"=",{"$f":"E53*G53","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,"variations","state","seattle"]
["VLT Target Area is same as Target Fenestration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight","With Curb",0,null,null,0.55000000000000004,null,null,0.6,null,null,0.55000000000000004,null,null,null,null,"N. Window","pf>0.5",0,null,null,0.55000000000000004,null,null,"No Req.",null,null,0.55000000000000004]
[null,null,"VLT Calculation",null,"Proposed Area",null,"Target Fen. Mult.",null,"Target Area",null,null,null,null,null,null,null,null,null,null,"Skylight","With Curb",0.3,null,null,0.55000000000000004,null,null,0.6,null,null,0.55000000000000004,null,null,null,null,"N. Window","pf>0.5",0.3,null,null,0.55000000000000004,null,null,"No Req.",null,null,0.55000000000000004]
[null,null,"All Vertical Fenestration",null,{"$f":"'ENV-VT'!D20","v":0},"x",{"$f":"IF(E56>0,$I$21,0)","v":0},"=",{"$f":"E56*G56","v":0},null,null,null,null,null,null,null,null,null,null,"Skylight","With Curb",0.4,null,null,0.5,null,null,0.6,null,null,0.5,null,null,null,null,"N. Window","pf>0.5",0.4,null,null,0.55000000000000004,null,null,"No Req.",null,null,0.55000000000000004]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Selected Group (1=Nres, 2=Res, 3= Refg WA) ==>",{"$f":"IF(A66<=2,A66,IF(A66=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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Selected Zone (1=Zone 1, 2=Zone 2, 3= Seattle) ==>",{"$f":"IF(A67<=2,A67,IF(A67=3,4,3))","v":3},null,null,null,"and two floor u-values (mass/steel joist vs wood/other)",null,null,null,null,null,null,null,null,null,"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,"Data Entered (0=no, 1=yes) ==>",{"$f":"IF('ENV-UA'!H100=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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Offset ==>",0]
["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,null,null,null,"Column # (idxU) ==>",{"$f":"IF(T63=0,12,IF(T61=4,10,IF(T62=4,11,T64+(idxGroup-1)*3+idxZone)))","v":12},"should return blank if nothing entered, warning in something entered but no zone/jurisdiction chosen, or the proper value"]
[3,"Occupancy Group: 1=Non Res, 2= Res, 3=none selected ,   4=Refg Warehouse,"]
[4,"Climate Zone: 1= Zone One, 2=Zone Two, 3=Cleared, 4= Seattle ",null,null,null,null,null,"for seattle need to set this to 4",null,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"]
["HEADER Row",null,null,null,null,null,null,null,null,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]
["Occupancy",{"$f":"IF(A66=1,\"Nonresidential\",IF(A66=2,\"Multifamily Res\",IF(A66=4,\"Refrigerated Warehouse\",\"\")))","v":""},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,"Group ==>","Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg"]
["Climate zone",{"$f":"IF(A66=3,\" \",IF(A67=1,\"Zone 1\",IF(A67=2,\"Zone 2\",IF(A67=4,\"Seattle\",\"\"))))","v":" "},null,null,null,null,null,null,null,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"]
["Header",{"$f":"IF(AND(B69<>\"\",B70<>\"\"),CONCATENATE(B70,\" \",B69),\"\")","v":""},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"]
["Prescriptive PF Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","Metal Frame","metal frm",1,{"$f":"INDEX(TargetUbyJurisdiction,S72,$T$65)","v":0},null,null,0.4,0.4,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$30:$AE32,4,TRUE)","v":0.38},0.4,0.4,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$30:$AE32,7,TRUE)","v":0.4},0.4,0.4,{"$f":"Y72","v":0.38},"set occ.","set zone",null,"Window",1,{"$f":"INDEX(TargetSHGCbyJurisdiction,AJ72,$T$65)","v":0},null,0.4,0.4,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$30:$AU32,4,TRUE)","v":0.35},"No Req.","No Req.",{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$30:$AU32,7,TRUE)","v":"No Req."},0.4,0.4,{"$f":"AO72","v":0.35},"set occ.","set zone",null,null,0,1,1]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","non-metal frame","non-metal frm",2,0,null,null,0.32,0.32,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$33:$AE35,4,TRUE)","v":0.3},0.32,0.32,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$33:$AE35,7,TRUE)","v":0.32},0.32,0.32,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$33:$AE35,10,TRUE)","v":0.3},"set occ.","set zone",null,"Window pf>0.5",2,{"$f":"INDEX(TargetSHGCbyJurisdiction,AJ73,$T$65)","v":0},null,0.45,0.45,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$33:$AU35,4,TRUE)","v":0.45},"No Req.","No Req.",{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$33:$AU35,7,TRUE)","v":"No Req."},0.45,0.45,{"$f":"AO73","v":0.45},"set occ.","set zone",null,null,0.10000100000000001,0.91,0.95]
["North Face Credit Flag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal entrance door","metal frm door",3,0,null,null,0.6,0.6,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$36:$AE38,4,TRUE)","v":0.6},0.6,0.6,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$36:$AE38,7,TRUE)","v":0.6},0.6,0.6,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$36:$AE38,10,TRUE)","v":0.6},"set occ.","set zone",null,"Skylight",3,{"$f":"INDEX(TargetSHGCbyJurisdiction,AJ74,$T$65)","v":0},null,0.35,0.35,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$36:$AU38,4,TRUE)","v":0.32},0.35,0.35,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$36:$AU38,7,TRUE)","v":0.35},0.35,0.35,{"$f":"AO74","v":0.32},"set occ.","set zone",null,null,0.20000100000000001,0.82,0.91]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight","Without Curb","no curb",4,0,null,null,0.5,0.5,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$40:$AE42,4,TRUE)","v":0.45},0.5,0.5,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$40:$AE42,7,TRUE)","v":0.5},0.5,0.5,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$40:$AE42,10,TRUE)","v":0.45},"set occ.","set zone",null,"N Window",4,{"$f":"INDEX(TargetSHGCbyJurisdiction,AJ75,$T$65)","v":0},null,0.45,0.45,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$40:$AU41,4,TRUE)","v":0.45},"No Req.","No Req.",{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$40:$AU41,7,TRUE)","v":"No Req."},0.45,0.45,{"$f":"AO75","v":0.45},"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,"Skylight","With Curb","with curb",5,0,null,null,0.6,0.6,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$54:$AE56,4,TRUE)","v":0.55000000000000004},0.6,0.6,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$54:$AE56,7,TRUE)","v":0.6},0.6,0.6,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$V$54:$AE56,10,TRUE)","v":0.55000000000000004},"set occ.","set zone",null,"N Window pf>0.5",5,{"$f":"INDEX(TargetSHGCbyJurisdiction,AJ76,$T$65)","v":0},null,0.5,0.5,{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$54:$AU57,4,TRUE)","v":0.55000000000000004},"No Req.","No Req.",{"$f":"VLOOKUP('ENV-SUM'!$G$16,TargetArea1!$AL$54:$AU57,7,TRUE)","v":"No Req."},0.5,0.5,{"$f":"AO76","v":0.55000000000000004},"set occ.","set zone",null,null,0.400001,0.67,0.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door","Opaque Non-swinging Doors","Non-swing",6,0,null,null,0.6,0.6,0.39,0.4,0.4,0.4,0.6,0.6,0.39,"set occ.","set zone",null,"sea has swing /non-swing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.50000100000000003,0.61,0.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door","Opaque Swinging Doors","Swing",7,0,null,null,0.6,0.6,0.47,0.4,0.4,0.4,0.6,0.6,0.47,"set occ.","set zone"]
[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,0,null,null,3.4000000000000002E-2,3.4000000000000002E-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.60000100000000001,0.56000000000000005,0.78]
[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,0,null,null,3.1E-2,3.1E-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.70000099999999998,0.51,0.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof","single rafter U0.027 - all zones","single rafter",10,0,null,null,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof","attic/Other U0.027 - all zones","attic/other",11,0,null,null,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","mass","mass",12,0,null,null,0.15,0.123,5.7000000000000002E-2,0.09,0.08,0.09,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","mass w/ int ins.","mass w/ int ins.",13,0,null,null,null,null,5.6000000000000001E-2,null,null,0.09,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","metal building U0.064 - all zones","metal bldg",14,0,null,null,6.4000000000000001E-2,6.4000000000000001E-2,5.1999999999999998E-2,5.7000000000000002E-2,4.3999999999999997E-2,5.7000000000000002E-2,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","steel frame U0.064 - all zones","steel frame",15,0,null,null,6.4000000000000001E-2,6.4000000000000001E-2,5.5E-2,5.7000000000000002E-2,4.3999999999999997E-2,5.7000000000000002E-2,null,null,null,"set occ.","set zone",null,"sea mtl bld and stl are diff"]
[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",16,0,null,null,5.7000000000000002E-2,5.0999999999999997E-2,5.0999999999999997E-2,5.7000000000000002E-2,4.3999999999999997E-2,5.7000000000000002E-2,null,null,null,"set occ.","set zone"]
[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",17,0,null,null,0.25,0.123,5.7000000000000002E-2,0.09,0.08,0.09,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor","Mass","Mass",18,0,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,"sea has 0.025 wd frm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor","Steel joist","steel joist",19,0,null,null,null,null,2.9000000000000001E-2,null,null,2.9000000000000001E-2,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor","wood frame/other","wood frame",20,0,null,null,null,null,2.5000000000000001E-2,null,null,2.9000000000000001E-2,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor",null,"Slab",21,0,null,null,0.54,0.54,0.52,0.54,0.54,0.54,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor",null,"Heated Slab",22,0,null,"All floors U0.029 - all zones",0.36,0.36,0.36,0.36,0.36,0.36,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","below grade","all BG",23,0,null,null,0.15,0.123,7.0000000000000007E-2,0.09,0.08,0.09,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","metal building U0.064 - all zones","metal bldg",24,0,null,null,6.4000000000000001E-2,6.4000000000000001E-2,7.0000000000000007E-2,5.7000000000000002E-2,4.3999999999999997E-2,5.7000000000000002E-2,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","steel frame U0.064 - all zones","steel frame",25,0,null,null,6.4000000000000001E-2,6.4000000000000001E-2,7.0000000000000007E-2,5.7000000000000002E-2,4.3999999999999997E-2,5.7000000000000002E-2,null,null,null,"set occ.","set zone"]
[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",26,0,null,null,5.7000000000000002E-2,5.0999999999999997E-2,7.0000000000000007E-2,5.7000000000000002E-2,4.3999999999999997E-2,5.7000000000000002E-2,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","cmu, same as mass but with corefill then okay in z1","CMU w/ Ins. Cores",27,0,null,null,0.25,0.123,7.0000000000000007E-2,0.09,0.08,0.09,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAXGlass","MAXGlass","MAXGlass",28,0,null,null,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0,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,"LABELS"]
[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,"Nres","Nres","Nres","Res","Res","Res","Refg","Refg","Refg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Component","Item Name",null,"Column # (idxU) ==>",{"$f":"IF(T61=4,10,IF(T62=4,11,T64+(idxGroup-1)*3+idxZone))","v":10},null,"Zone ==>",1,2,"Seattle",1,2,"Seattle",1,2,"Seattle",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,"Long","Short",null,"Target Label",null,"Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Target Label"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","Metal Frame","metal frm",1,{"$f":"INDEX(TargetLabelByJurisdiction,S104,$T$102)","v":"set occ."},null,"nmfrm",{"$f":"CONCATENATE(\"U-\",TEXT(W72,\"0.00#\"))","v":"U-0.40"},"U-0.40","U-0.38","U-0.40","U-0.40","U-0.40","U-0.40","U-0.40","U-0.38","set occ.","set zone",null,"Window",1,{"$f":"INDEX( $AM$104:$AX$108,AJ104,$T$102)","v":"set occ."},null,{"$f":"TEXT(AM72,\"0.00#\")","v":"0.40"},"0.40","0.35",{"$f":"CONCATENATE(\"\",AP72)","v":"No Req."},"No Req.","No Req.",{"$f":"TEXT(AS72,\"0.00#\")","v":"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,"Window","non-metal frame","non-metal frm",2,"set occ.",null,"mfrm",{"$f":"CONCATENATE(\"U-\",TEXT(W73,\"0.00#\"))","v":"U-0.32"},"U-0.32","U-0.30","U-0.32","U-0.32","U-0.32","U-0.32","U-0.32","U-0.30","set occ.","set zone",null,"Window pf>0.5",2,{"$f":"INDEX( $AM$104:$AX$108,AJ105,$T$102)","v":"set occ."},null,"0.45","0.45","0.45","No Req.","No Req.","No Req.","0.45","0.45","0.45","set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal entrance door","metal frm door",3,"set occ.",null,"med",{"$f":"CONCATENATE(\"U-\",TEXT(W74,\"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,"Skylight",3,{"$f":"INDEX( $AM$104:$AX$108,AJ106,$T$102)","v":"set occ."},null,"0.35","0.35","0.32",{"$f":"TEXT(AP74,\"0.00#\")","v":"0.35"},{"$f":"TEXT(AQ74,\"0.00#\")","v":"0.35"},{"$f":"TEXT(AR74,\"0.00#\")","v":"0.35"},"0.35","0.35","0.32","set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight","Without Curb","no curb",4,"set occ.",null,"nc",{"$f":"CONCATENATE(\"U-\",TEXT(W75,\"0.00#\"))","v":"U-0.50"},"U-0.50","U-0.45","U-0.50","U-0.50","U-0.50","U-0.50","U-0.50","U-0.45","set occ.","set zone",null,"N Window",4,{"$f":"INDEX( $AM$104:$AX$108,AJ107,$T$102)","v":"set occ."},null,"0.45","0.45","0.45",{"$f":"CONCATENATE(\"\",AP75)","v":"No Req."},"No Req.","No Req.","0.45","0.45","0.45","set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skylight","With Curb","with curb",5,"set occ.",null,"wc",{"$f":"CONCATENATE(\"U-\",TEXT(W76,\"0.00#\"))","v":"U-0.60"},"U-0.60","U-0.55","U-0.60","U-0.60","U-0.60","U-0.60","U-0.60","U-0.55","set occ.","set zone",null,"N Window pf>0.5",5,{"$f":"INDEX( $AM$104:$AX$108,AJ108,$T$102)","v":"set occ."},null,"0.50","0.50","0.55","No Req.","No Req.","No Req.","0.50","0.50","0.55","set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door","Opaque Non-swinging Doors","Non-swing",6,"set occ.",null,"dr",{"$f":"CONCATENATE(\"U-\",TEXT(W77,\"0.00#\"))","v":"U-0.60"},"U-0.60","U-0.39","U-0.40","U-0.40","U-0.40","U-0.60","U-0.60","U-0.39","set occ.","set zone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door","Opaque Swinging Doors","Swing",7,"set occ.",null,"dr",{"$f":"CONCATENATE(\"U-\",TEXT(W78,\"0.00#\"))","v":"U-0.60"},"U-0.60","U-0.47","U-0.40","U-0.40","U-0.40","U-0.60","U-0.60","U-0.47","set occ.","set zone"]
[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(W79,\"0.000#\"))","v":"U-0.034"},"U-0.034","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,"Roof","metal building U0.031 - all zones","metal bldg",9,"set occ.",null,null,"U-0.031","U-0.031","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,"Roof","single rafter U0.027 - all zones","single rafter",10,"set occ.",null,null,"U-0.027","U-0.027","U-0.027","U-0.027","U-0.027","U-0.027",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof","attic/Other U0.027 - all zones","attic/other",11,"set occ.",null,null,"U-0.027","U-0.027","U-0.027","U-0.027","U-0.027","U-0.027",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","mass","mass",12,"set occ.",null,null,"U-0.150","U-0.123","U-0.057","U-0.090","U-0.080","U-0.090",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","mass w/ int ins.","mass w/ int ins.",13,"set occ.",null,null,"U-0.000","U-0.000","U-0.056","U-0.000","U-0.000","U-0.090",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGWall","metal building U0.064 - all zones","metal bldg",14,"set occ.",null,null,"U-0.064","U-0.064","U-0.052","U-0.057","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,"AGWall","steel frame U0.064 - all zones","steel frame",15,"set occ.",null,null,"U-0.064","U-0.064","U-0.055","U-0.057","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,"AGWall","wood frame/other U0.057 zi, U 0.051z2","wood frame/other",16,"set occ.",null,null,"U-0.057","U-0.051","U-0.051","U-0.057","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,"AGWall","cmu, same as mass but with corefill then okay in z1","CMU w/ Ins. Cores",17,"set occ.",null,null,"U-0.250","U-0.123","U-0.057","U-0.090","U-0.080","U-0.090",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor","Mass","Mass",18,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(W89,\"0.000#\"))","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,"Floor","Steel joist","steel joist",19,"set occ.",null,null,"U-0.000","U-0.000","U-0.029","U-0.000","U-0.000","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,"Floor","wood frame/other","wood frame",20,"set occ.",null,null,"U-0.000","U-0.000","U-0.025","U-0.000","U-0.000","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,"Floor",null,"Slab",21,"set occ.",null,null,"U-0.540","U-0.540","U-0.520","U-0.540","U-0.540","U-0.540",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor",null,"Heated Slab",22,"set occ.",null,"All floors U0.029 - all zones","U-0.360","U-0.360","U-0.360","U-0.360","U-0.360","U-0.360",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","below grade","all BG",23,"set occ.",null,null,"U-0.150","U-0.123","U-0.070","U-0.090","U-0.080","U-0.090",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGWall","metal building U0.064 - all zones","metal bldg",24,"set occ.",null,null,"U-0.064","U-0.064","U-0.070","U-0.057","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,"BGWall","steel frame U0.064 - all zones","steel frame",25,"set occ.",null,null,"U-0.064","U-0.064","U-0.070","U-0.057","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,"BGWall","wood frame/other U0.057 zi, U 0.051z2","wood frame/other",26,"set occ.",null,null,"U-0.057","U-0.051","U-0.070","U-0.057","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,"BGWall","cmu, same as mass but with corefill then okay in z1","CMU w/ Ins. Cores",27,"set occ.",null,null,"U-0.250","U-0.123","U-0.070","U-0.090","U-0.080","U-0.090",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAXGlass","MAXGlass","MAXGlass",28,"set occ.",null,null,{"$f":"CONCATENATE(\"U-\",TEXT(W99,\"0.00#\"))","v":"U-0.40"},"U-0.40","U-0.40","U-0.40","U-0.40","U-0.40",null,null,null,"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<30%","Window","non-metal frame","non-metal frm",29,"set occ.",null,null,null,null,{"$f":"CONCATENATE(\"U-\",TEXT(Y34,\"0.00#\"))","v":"U-0.30"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AB34,\"0.00#\"))","v":"U-0.32"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AE34,\"0.00#\"))","v":"U-0.30"},"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30%-40%","Window","non-metal frame","non-metal frm",30,"set occ.",null,null,null,null,{"$f":"CONCATENATE(\"U-\",TEXT(Y35,\"0.00#\"))","v":"U-0.28"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AB35,\"0.00#\"))","v":"U-0.32"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AE35,\"0.00#\"))","v":"U-0.28"},"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<30%","Skylight","Without Curb","no curb",31,"set occ.",null,null,null,null,{"$f":"CONCATENATE(\"U-\",TEXT(Y41,\"0.00#\"))","v":"U-0.45"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AB41,\"0.00#\"))","v":"U-0.50"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AE41,\"0.00#\"))","v":"U-0.45"},"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30%-40%","Skylight","Without Curb","no curb",32,"set occ.",null,null,null,null,{"$f":"CONCATENATE(\"U-\",TEXT(Y42,\"0.00#\"))","v":"U-0.40"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AB42,\"0.00#\"))","v":"U-0.50"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AE42,\"0.00#\"))","v":"U-0.40"},"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<30%","Skylight","With Curb","with curb",33,"set occ.",null,null,null,null,{"$f":"CONCATENATE(\"U-\",TEXT(Y55,\"0.00#\"))","v":"U-0.55"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AB55,\"0.00#\"))","v":"U-0.60"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AE55,\"0.00#\"))","v":"U-0.55"},"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30%-40%","Skylight","With Curb","with curb",34,"set occ.",null,null,null,null,{"$f":"CONCATENATE(\"U-\",TEXT(Y56,\"0.00#\"))","v":"U-0.50"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AB56,\"0.00#\"))","v":"U-0.60"},null,null,{"$f":"CONCATENATE(\"U-\",TEXT(AE56,\"0.00#\"))","v":"U-0.50"},"set occ.","set zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window","metal frame",null,35,"set occ.",null,null,null,null,"U-0.45",null,null,null,null,null,null,"set occ.","set zone"]

{"sheet":"ENV-SHGC","index":4,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[[46,3,46,4],[45,2,45,3]]}
["SHGC Calculation",null,null,null,null,null,null,{"$f":"TargetArea1!$B$71","v":""},null,null,"ENV-SHGC"]
[{"$f":"'ENV-SUM'!A2","v":"2009 Seattle Energy Code Compliance Forms for Nonresidential and Multifamily Residential"},null,null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised September 2011"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,null,{"$f":"'ENV-SUM'!$C$3","v":"1 - Always fill out this line on ENV-SUM1"},null,null,null,null,"Date",{"$f":"TEXT('ENV-SUM'!$G$3,\"mm/dd/yyyy\")","v":"11/15/2013"}]
["Fenestration Area as % gross exterior wall area",null,null,null,null,{"$f":"IF('ENV-SUM'!G16>0,'ENV-SUM'!G16,0)","v":0},{"$f":"TargetArea1!C13","v":0},null,"For Building Department Use"]
["Prescriptive PF Credit"]
["Vertical North Facing Credit (1323.3 Exp. 2 )"]
[]
[]
["  Skylights",null,null,null,null,null,"Proposed SHGC",null,"Target SHGC",null,null,null,null,"\n"]
["  List ID & page #, NFRC or glass only",null,null,null,null,"SHGC*","x Area (A)","= SHGC x A","SHGC","x Area (A) =","SHGC x A"]
["  ID:",null,null,null,null,null,null,{"$f":"IF(G11=\"\",0,G11*F11)","v":0},{"$f":"TargetArea1!AK74","v":0},{"$f":"TargetArea1!I51","v":0},{"$f":"IF(TYPE(I11*J11)<>1,0,I11*J11)","v":0}]
["  ID:",null,null,null,null,null,null,{"$f":"IF(G12=\"\",0,G12*F12)","v":0},"Criteria",null,"SHGC"]
["  ID:",null,null,null,null,null,null,{"$f":"IF(G13=\"\",0,G13*F13)","v":0},"All",null,{"$f":"TargetArea1!AK106","v":"set occ."}]
["  ID:",null,null,null,null,null,null,{"$f":"IF(G14=\"\",0,G14*F14)","v":0}]
["  ID:",null,null,null,null,null,null,{"$f":"IF(G15=\"\",0,G15*F15)","v":0}]
[null,null,null,null,null,"Totals",{"$f":"SUM(G10:G15)","v":0},{"$f":"SUM(H10:H15)","v":0},"Totals",{"$f":"J11","v":0},{"$f":"K11","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Occupancy=2,IF(H16>K16+0.00001,\"AVERAGE SKYLIGHT SHGC DOES NOT COMPLY\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(G16+G53-TargetArea1!C9)>0.1,IF((G16+G53)>TargetArea1!C9,CONCATENATE(\"MORE PROPOSED SKYLIGHT IN G16 & G53 THAN ENV-UA - Remove  \",TEXT(TargetArea1!C9-(G16+G53),\"0.0\")),CONCATENATE(\"LESS PROPOSED SKYLIGHT IN G16 & G53 THAN ENV-UA - ADD  \",TEXT(TargetArea1!C9-(G16+G53),\"0.0\" )) ),\" \")","v":" "}]
[{"$f":"IF(TargetArea1!A66=2,\" Vertical Fenestration - No Residential SHGC Requirement\",\" All Non-North Vertical Fenestration++\")","v":" All Non-North Vertical Fenestration++"},null,null,null,null,null,"Proposed SHGC",null,"Target SHGC"]
["  List ID & page #, NFRC or glass only",null,"SHGC+","PF","PF \nMult*","Adjusted SHGC","x Area (A)","= SHGC x A","SHGC","x Area (A) =","SHGC x A"]
["  ID:",null,null,null,{"$f":"IF(AND(D21>0,PrescriptivePF<>1),VLOOKUP(D21,SHGC_Multipliers,2,TRUE),IF(C21=\"\",\"\",1))","v":""},{"$f":"IF(E21=\"\",\"\",C21*E21)","v":""},null,{"$f":"IF(E21=\"\",0,G21*F21)","v":0},{"$f":"IF(J21=0,0,IF(AND(SUMPRODUCT($D$21:$D$26,$G$21:$G$26)/$G$27>0.5,PrescriptivePF=1),TargetArea1!$AK$73,TargetArea1!$AK$72))","v":0},{"$f":"TargetArea1!$I$52","v":0},{"$f":"IF(TYPE(I21*J21)<>1,0,I21*J21)","v":0}]
["  ID:",null,null,null,"","",null,0,"Criteria",null,"SHGC"]
["  ID:",null,null,null,"","",null,0,"All",null,{"$f":"TargetArea1!AK104","v":"set occ."}]
["  ID:",null,null,null,"","",null,0,"  Prescriptive PF ",null,{"$f":"TargetArea1!AK105","v":"set occ."}]
["  ID:",null,null,null,"","",null,0]
["  ID:",null,null,null,"","",null,0]
[null,null,null,null,null,"Totals",{"$f":"SUM(G20:G26)","v":0},{"$f":"SUM(H20:H26)","v":0},"Totals",{"$f":"J21","v":0},{"$f":"K21","v":0}]
[null,null,null,null,null,null,"Non-North Total   ",{"$f":"H16+H27","v":0},null,null,{"$f":"K16+K27","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Occupancy=2,IF(G27>0,\"NO RESIDENTIAL VERTICAL FENESTRATION REQUIREMENT\",\"\"),IF(NorthCredit=1,IF(H28>K28+0.00001,\"AVERAGE NON-NORTH SHGC DOES NOT COMPLY\",\"\"),\"\"))","v":""}]
[]
[{"$f":"IF(TargetArea1!A66=2,\"Vertical Fenestration -  No Residential SHGC Requirement\",\"  North Vertical Fenestration++\")","v":"  North Vertical Fenestration++"},null,null,null,null,null,"Proposed SHGC",null,"Target SHGC"]
["  List ID & page #, NFRC or glass only",null,"SHGC+","PF","PF \nMult*","Adjusted SHGC","x Area (A)","= SHGC x A","SHGC","x Area (A) =","SHGC x A"]
["  ID:",null,null,null,{"$f":"IF(AND(D33>0,PrescriptivePF<>1),VLOOKUP(D33,SHGC_Multipliers,3,TRUE),IF(C33=\"\",\"\",1))","v":""},{"$f":"IF(E33=\"\",\"\",C33*E33)","v":""},null,{"$f":"IF(E33=\"\",0,G33*F33)","v":0},{"$f":"IF(J33=0,0,IF(AND(IF(G27=0,TRUE,(SUMPRODUCT($D$21:$D$26,$G$21:$G$26)/$G$27>0.5)),PrescriptivePF=1),IF(NorthCredit=1,TargetArea1!$AK$76,TargetArea1!$AK$73),IF(NorthCredit=1,TargetArea1!$AK$75,TargetArea1!$AK$72)))","v":0},{"$f":"TargetArea1!$I$53","v":0},{"$f":"IF(TYPE(I33*J33)<>1,0,I33*J33)","v":0}]
["  ID:",null,null,null,"","",null,0,"Criteria","Mixed ","North"]
["  ID:",null,null,null,"","",null,0,null,"Orientation","Separate"]
["  ID:",null,null,null,"","",null,0,"All",{"$f":"TargetArea1!AK104","v":"set occ."},{"$f":"TargetArea1!AK107","v":"set occ."}]
["  ID:",null,null,0,"","",null,0,"Prescrpt PF",{"$f":"TargetArea1!AK105","v":"set occ."},{"$f":"TargetArea1!AK108","v":"set occ."}]
["  ID:",null,null,0,"","",null,0]
[null,null,null,null,null,"North Total",{"$f":"SUM(G32:G38)","v":0},{"$f":"SUM(H32:H38)","v":0},null,{"$f":"J33","v":0},{"$f":"K33","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Occupancy=2,G39>0),\"NO RESIDENTIAL VERTICAL GLASS REQUIREMENT\", IF(NorthCredit=1,IF(H39>K39+0.00001,\"AVERAGE NORTH SHGC DOES NOT COMPLY\",\"\"),\"\"))","v":""}]
[null,null,null,null,null,null,"Area","SHGC x A",null,"Area","SHGC x A"]
[null,null,null,null,null,"Grand\nTotal",{"$f":"G16+G27+G39","v":0},{"$f":"H28+H39","v":0},"Grand\nTotal",{"$f":"J16+J27+J39","v":0},{"$f":"K28+K39","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Occupancy=2,\"\",IF(ABS((G27+G39)-TargetArea1!E9)>0.1,IF((G27+G39)>TargetArea1!E9,CONCATENATE(\"MORE PROPOSED VERTICAL GLASS HERE THAN ENV-UA - Remove  \",TEXT(TargetArea1!E9-(G27+G39),\"0.0\")),CONCATENATE(\"LESS PROPOSED VERTICAL GLASS HERE THAN ENV-UA: ADD  \",TEXT(TargetArea1!E9-(G27+G39),\"0.0\" )) ),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Occupancy=2,G42>0),\"NO RESIDENTIAL VERTICAL GLASS REQUIREMENT\", IF(NorthCredit=1,\"\",IF(H42>K42+0.00001,\"AVERAGE NORTH + NON-NORTH SHGC DOES NOT COMPLY\",\"\")))","v":""}]
[]
[null,"Total Overhead Daylight Zone Area (ODA):",null,null,null,null,null,"Footnote 1 Skylight Area % of ODA:",{"$f":"IF(C46>0,G53/C46,IF(G53>0,\"ERROR\",\"\"))","v":""}," Must be <=6.00%"]
[]
[{"$f":"IF(TargetArea1!A66=2,\" Footnote 1 Skylights - No Residential Allowance\",\"  Footnote 1 Skylights - SEPARATE COMPLIANCE\")","v":"  Footnote 1 Skylights - SEPARATE COMPLIANCE"},null,null,null,null,null,"Proposed SHGC",null,"Target SHGC"]
["  List ID & page #, NFRC or glass only",null,null,null,null,"SHGC*","x Area (A)","= SHGC x A","SHGC","x Area (A) =","SHGC x A"]
["  ID:",null,null,null,null,null,null,{"$f":"IF(G50=\"\",0,G50*F50)","v":0},{"$f":"IF(TargetArea1!A66=1,IF(G53>0,0.65,\"\"),\"\")","v":""},{"$f":"G53","v":0},{"$f":"IF(TYPE(I50*J50)<>1,0,I50*J50)","v":0}]
["  ID:",null,null,null,null,null,null,{"$f":"IF(G51=\"\",0,G51*F51)","v":0},"All",null,{"$f":"IF(TargetArea1!A66=1,\"SHGC-0.65\",\"N/A\")","v":"N/A"}]
["  ID:",null,null,null,null,null,null,{"$f":"IF(G52=\"\",0,G52*F52)","v":0}]
[null,null,null,null,null,"Totals",{"$f":"SUM(G49:G52)","v":0},{"$f":"SUM(H49:H52)","v":0},"Totals",{"$f":"J50","v":0},{"$f":"K50","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Occupancy=2,IF(G53>0,\"FOOTNOTE 1 NOT ALLOWED IN RESIDENTIAL\",\"\"),IF(C46<=0,IF(G53>0,\"MUST ENTER OVERHEAD DAYLIGHT ZONE AREA IN CELL D46\",\"\"),IF(G53<=0,\"\",IF(G53/C46>0.06,\"MORE THAN 6% SKYLIGHT.  DOES NOT COMPLY\",IF(H53>K53+0.00001,\"AVERAGE SKYLIGHT SHGC DOES NOT COMPLY\",\"\")))))","v":""},null,null,null,{"$f":"Occupancy","v":3}]
[]
[]
["Target Area Adjustment Calculations"]
[{"$f":"'ENV-SUM'!A2","v":"2009 Seattle Energy Code Compliance Forms for Nonresidential and Multifamily Residential"},null,null,null,null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised September 2011"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,null,{"$f":"'ENV-SUM'!$C$3","v":"1 - Always fill out this line on ENV-SUM1"},null,null,null,null,"Date",{"$f":"TEXT('ENV-SUM'!$G$3,\"mm/dd/yyyy\")","v":"11/15/2013"}]

{"sheet":"ENV-VT","index":5,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,0,20,7]]}
["VT Calculation",null,null,null,{"$f":"TargetArea1!$B$71","v":""},null,null,"ENV-VT"]
[{"$f":"'ENV-SUM'!A2","v":"2009 Seattle Energy Code Compliance Forms for Nonresidential and Multifamily Residential"},null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised September 2011"}]
[{"$f":"'ENV-SUM'!B3","v":"Project Address"},null,{"$f":"'ENV-SUM'!$C$3","v":"1 - Always fill out this line on ENV-SUM1"},null,null,"Date",{"$f":"TEXT('ENV-SUM'!$G$3,\"mm/dd/yyyy\")","v":"11/15/2013"}]
["Fenestration Area as % gross exterior wall area",null,{"$f":"IF('ENV-SUM'!G16>0,'ENV-SUM'!G16,0)","v":0},{"$f":"TargetArea1!C13","v":0},null,"For Building Department Use"]
[]
[]
[{"$f":"IF(Occupancy=2,\"NO MULTIFAMILY RESIDENTIAL REQUIREMENTS\",\"All Vertical Fenestration\")","v":"All Vertical Fenestration"},null,null,"Proposed VT",null,"Target VT"]
["  List ID & page #, NFRC or glass only",null,"VT","x Area (A)","= VT x A","VT","x Area (A) =","VT x A"]
["  ID:",null,null,null,{"$f":"IF(C9=\"\",0,D9*C9)","v":0},{"$f":"IF(G9=0,0,0.51)","v":0},{"$f":"TargetArea1!$I$56","v":0},{"$f":"IF(TYPE(F9*G9)<>1,0,F9*G9)","v":0}]
["  ID:",null,null,null,{"$f":"IF(C10=\"\",0,D10*C10)","v":0},"Criteria",null,"VT"]
["  ID:",null,null,null,0,"All",null,{"$f":"IF(OR(Occupancy<>1,C4<=0.3),\"No Requirements\",0.51)","v":"No Requirements"}]
["  ID:",null,null,null,0]
["  ID:",null,null,null,0]
["  ID:",null,null,null,0]
["  ID:",null,null,null,0]
["  ID:",null,null,null,0]
["  ID:",null,null,null,0]
["  ID:",null,null,null,0]
[]
[null,null,"Totals",{"$f":"SUM(D8:D18)","v":0},{"$f":"SUM(E8:E18)","v":0},"Totals",{"$f":"G9","v":0},{"$f":"H9","v":0}]
[{"$f":"IF(AND(Occupancy<>3,C4>0),IF(Occupancy=2,IF(D20>0,\"NO RESIDENTIAL VERTICAL FENESTRATION VT REQUIREMENT\",\"\"),IF(C4<=0.3,\"NO VT REQUIREMENT FOR GLAZING FRACTIONS <= 30%\",IF(D20<>TargetArea1!E9,\"VERTICAL FENESTRATION AREA MUST EQUAL SUM OF ENV-UA VERTICAL FENSTRATION\",IF(E20>H20-0.00001,\"\",\"AVERAGE VT DOES NOT COMPLY\")))),\"\")","v":""}]

{"sheet":"ENV-CHK","index":6,"n_rows":83,"n_cols":17,"rows_kept":83,"cut":false,"hidden":false,"merged":[[18,14,18,15]]}
["Building Permit Plans Checklist",null,null,null,null,null,null,"ENV-CHK",null,"ENV-UA INSTRUCTIONS & EXAMPLES",null,null,null,null,null,null,"ENV-CHK"]
[{"$f":"'ENV-SUM'!A2","v":"2009 Seattle Energy Code Compliance Forms for Nonresidential and Multifamily Residential"},null,null,null,null,null,null,{"$f":"'ENV-SUM'!G2","v":"Revised September 2011"},null,{"$f":"A2","v":"2009 Seattle Energy Code Compliance Forms for Nonresidential and Multifamily Residential"},null,null,null,null,null,null,{"$f":"H2","v":"Revised September 2011"}]
["Project Address",null,null,null,{"$f":"'ENV-SUM'!C3","v":"1 - Always fill out this line on ENV-SUM1"},null,"Date",{"$f":"'ENV-SUM'!G3","v":"2013-11-15"}]
[]
["Applicability",null,null,"Code",null,null,"Location","Building Department"]
["(yes,no,na)",null,null,"Section","Component","Information Required","on Plans","Notes"]
["GENERAL REQUIREMENTS (Sections 1301-1314)"]
[null,null,null,1301,"Scope","Unconditioned spaces identified on plans if allowed"]
[{"$f":"IF(C9=1,\"  Yes\",IF(C9=2,\"  No\",IF(C9=3,\"  N.A.\",\"\")))","v":""},null,4,1310.2,"Semi-heated spaces","Semi-heated spaces identified on plans if allowed"]
[{"$f":"IF(C10=1,\"  Yes\",IF(C10=2,\"  No\",IF(C10=3,\"  N.A.\",\"\")))","v":""},null,4,1310.3,"Cold Storage / refrigerated ","All refrigerated spaces identified on plans.  ENV-RFG  completed."]
[null,null,null,1311,"Insulation"]
[{"$f":"IF(C12=1,\"  Yes\",IF(C12=2,\"  No\",IF(C12=3,\"  N.A.\",\"\")))","v":""},null,4,1311.1,"General installation","Indicate installation nethod, densities and clearances to achieve "]
[null,null,null,null,null,"     intended R-value of all insulation materials"]
[{"$f":"IF(C14=1,\"  Yes\",IF(C14=2,\"  No\",IF(C14=3,\"  N.A.\",\"\")))","v":""},null,4,1311.2,"Roof /ceiling insul.","Indicate R-value on roof sections for attics and other roofs;  "]
[null,null,null,null,null,"Indicate clearances for attic insulation;"]
[null,null,null,null,null,"Indicate baffles if eave vents installed;"]
[null,null,null,null,null,"Indicate face stapling of faced batts"]
[{"$f":"IF(C18=1,\"  Yes\",IF(C18=2,\"  No\",IF(C18=3,\"  N.A.\",\"\")))","v":""},null,4,1311.3,"Wall insulation","Indicate R-value and framing material on wall sections;  "]
[null,null,null,null,null,"Indicate face stapling of faced batts;",null,null,null,null,"Building Component ",null,null,null,"Proposed UA",null,"Typical Example"]
[null,null,null,null,null,"Indicate above grade exterior insulation is protected;",null,null,null,null,"List ID & page #, code table # or calculation page #",null,null,null,"U-factor","x Area (A)"]
[null,null,null,null,null,"Indicate mass of masonry walls if mass wall claimed",null,null,null,"Roofs"]
[null,null,null,null,null,"Indicate loose-fill core insulation for masonry walls as necessary",null,null,null,null,"R=","38  ","ID:","R1/A1.5, T.10-7 default",3.1E-2,532,"R-38 blown-in attic insulation per default"]
[null,null,null,null,null,"Indicate frequency of grouted cores and bond beams  as necessary",null,null,null,null,"R=","40  ","ID:","R2/A1.5, T.10-7G default",2.5000000000000001E-2,9885,"R-40 uniform thickness rigid insulation per default"]
[{"$f":"IF(C24=1,\"  Yes\",IF(C24=2,\"  No\",IF(C24=3,\"  N.A.\",\"\")))","v":""},null,4,1311.4,"Floor insulation","Indicate R-value on floor sections;  ",null,null,null,"Walls"]
[null,null,null,null,null,"Indicate substantial contact with surface;",null,null,null,null,"R=13+7.5",null,"ID:","W1/A1.6, T.10-5A(1) default",6.4000000000000001E-2,7587,"R-13 cavity + R-7.5 rigid ins. over metal studs per default"]
[null,null,null,null,null,"Indicate supports not more than 24\" o.c.;",null,null,null,null,"R=","5  ","ID:","W2/A1.6, T.10-5B(2) default",0.157,923,"R-5 rigid ins. at edge of intermediate concrete floors per def"]
[null,null,null,null,null,"Indicate that insulation does not block airflow through foundation vents.",null,null,null,null,"R=",null,"ID:"]
[{"$f":"IF(C28=1,\"  Yes\",IF(C28=2,\"  No\",IF(C28=3,\"  N.A.\",\"\")))","v":""},null,4,1311.5,"Slab-on-grade floor","Indicate R-value on wall section or foundation detail;",null,null,null,null,"R=",null,"ID:"]
[null,null,null,null,null,"Indicate slab insulation extends down vertically 24\" from top;",null,null,null,null,"R=","11","ID:","W4/A1.6, T.10-5(1) default",9.4E-2,512,"R-11 cavity ins. between wood studs on conc. wall per def."]
[null,null,null,null,null,"Indicate above grade exterior insulation is protected",null,null,null,null,"R=",null,"ID:"]
[{"$f":"IF(C31=1,\"  Yes\",IF(C31=2,\"  No\",IF(C31=3,\"  N.A.\",\"\")))","v":""},null,4,1311.6,"Radiant floor","Indicate R-value on wall section or foundation detail;",null,null,null,"Doors"]
[null,null,null,null,null,"Indicate slab insulation extends down vertically 36\" from the top;",null,null,null,null,"U=","0.6","ID:","D1/A1.3, T.10-6 default","0.60",120,"Non-NFRC fire-rated exit door per default"]
[null,null,null,null,null,"Indicate above grade exterior insulation is protected;",null,null,null,null,"U=","1.2","ID:","D2/A1.3, T.10-6 default","1.20",40,"Non-NFRC warehouse door per default"]
[null,null,null,null,null,"Indicate insulation also under entire slab where req'd. by Official",null,null,null,"Floors and Slabs"]
[{"$f":"IF(C35=1,\"  Yes\",IF(C35=2,\"  No\",IF(C35=3,\"  N.A.\",\"\")))","v":""},null,4,1312,"Glazing and doors","Provide calculation of vertical and overhead glazing area as percent of gross wall area",null,null,null,"Floor","R=","30","ID:","F1/A1.7, T.10-4A default",3.1E-2,10417,"R-30 continuous ins.  under concrete floor slab per default"]
[{"$f":"IF(C36=1,\"  Yes\",IF(C36=2,\"  No\",IF(C36=3,\"  N.A.\",\"\")))","v":""},null,4,1312.1,"U-factors","Indicate glazing and door U-factors on glazing and door ",null,null,null,null,"R=",null,"ID:"]
[null,null,null,null,null,"      schedule (provide area-weighted calculations as necessary);",null,null,null,null,"R=","10","ID:","F2/A1.7, T.10-2 default",0.7,612,"R-10 slab edge ins. for 2 feet without thermal break per def."]
[null,null,null,null,null,"Indicate if values are NFRC or default, if default then specify",null,null,null,"Fenestration and Skylights"]
[null,null,null,null,null,"     frame type, glazing layers, gapwidth, low-e coatings, gas filling",null,null,null,null,"ID:","W1/A1.3, NFRC certified",null,null,"0.36",12307,"Curtainwall rated, certified, and labeled per NFRC"]
[{"$f":"IF(C40=1,\"  Yes\",IF(C40=2,\"  No\",IF(C40=3,\"  N.A.\",\"\")))","v":""},null,4,1312.2,"SHGC, SC, & VT","Indicate glazing solar heat gain coefficient or shading coefficient on glazing ",null,null,null,null,"ID:","W2/A1.3, T.10-6 default",null,null,"0.50",5240,"Non-NFRC curtainwall, 2 layer, 0.05emis, argon, TB, fixed"]
[null,null,null,null,null,"      schedule (provide area-weighted calculations by orientation as necessary);",null,null,null,null,"ID:","W3/A1.3, T.10-6 default",null,null,"0.65",282,"Non-NFRC curtainwall, 2 layer, 0.05emis fixed"]
[null,null,null,null,null,"Indicate visible transmittance (VT) on fenestration schedule",null,null,null,null,"ID:","W3/A1.3, T.10-6 default",null,null,"0.78",282,"Non-NFRC curtainwall, 2 layer, 0.05emis operable"]
[null,null,null,1313,"Moisture control",null,null,null,null,null,"ID:","S1/A1.3, NFRC certified",null,null,"0.50",453,"Sloped glazing rated, certified, and labeled per NFRC"]
[{"$f":"IF(C44=1,\"  Yes\",IF(C44=2,\"  No\",IF(C44=3,\"  N.A.\",\"\")))","v":""},null,4,1313.1,"Vapor retarders","Indicate vapor retarders applied to warm side of insulation",null,null,null,null,"ID:","S2/A1.3, T.10-6 default",null,null,"0.78",118,"Non-NFRC atrium sloped glazing, 2 layer, 0.05 emis., fixed"]
[{"$f":"IF(C45=1,\"  Yes\",IF(C45=2,\"  No\",IF(C45=3,\"  N.A.\",\"\")))","v":""},null,4,1313.2,"Roof/ceiling vap.ret.","Indicate vapor retarder on roof section; or list exception"]
[null,null,null,null,null,"Indicate vap. retard. with sealed seams for non-wood structure"]
[{"$f":"IF(C47=1,\"  Yes\",IF(C47=2,\"  No\",IF(C47=3,\"  N.A.\",\"\")))","v":""},null,4,1313.3,"Wall vapor retarder","Indicate vapor retarder on wall section"]
[{"$f":"IF(C48=1,\"  Yes\",IF(C48=2,\"  No\",IF(C48=3,\"  N.A.\",\"\")))","v":""},null,4,1313.4,"Floor vapor retarder","Indicate vapor retarder on floor section"]
[{"$f":"IF(C49=1,\"  Yes\",IF(C49=2,\"  No\",IF(C49=3,\"  N.A.\",\"\")))","v":""},null,4,1313.5,"Crawl space vap. ret.","Indicate required grade ground cover with required overlapping."]
[null,null,null,1314,"Air leakage"]
[{"$f":"IF(C51=1,\"  Yes\",IF(C51=2,\"  No\",IF(C51=3,\"  N.A.\",\"\")))","v":""},null,4,1314.1,"Bldg. envel. sealing","Indicate sealing, caulking, gasketing, and weatherstripping"]
["",null,4,1314.2,"Glazing/door sealing","Specify maximum air leakage rates for fenestration and door products"]
["",null,4,1314.3,"Assemb. as ducts","Indicate sealing, caulking and gasketing"]
["",null,4,1314.4,"Recessed Lighting Fixtures","Indicate IC rating, ASTM E283 cert., and gasketing or caulking to ceiling"]
["",null,4,1314.5,"Loading Dock Seal","Indicate weatherseal at cargo and loading dock doors"]
["",null,4,1314.6,"Continuous Air Barrier","Indicate air barrier sealing on all roof, wall  & floor details"]
[null,null,null,null,null,"Indicate leakage testing method."]
[null,null,null,null,null,"Provide testing results to building official.  Max. leakage of  0.40 cfm/ft2 at 0.3 inch w.g. "]
[{"$f":"IF(C59=1,\"  Yes\",IF(C59=2,\"  No\",IF(C59=3,\"  N.A.\",\"\")))","v":""},null,4,1314.7,"Vestibules","Indicate Vestibules on drawings."]
["PRESCRIPTIVE PERFORMANCE (Sections 1320-1323)"]
[{"$f":"IF(C61=1,\"  Yes\",IF(C61=2,\"  No\",IF(C61=3,\"  N.A.\",\"\")))","v":""},null,4,null,"ENV-SUM Form","Completed and attached."]
[{"$f":"IF(C62=1,\"  Yes\",IF(C62=2,\"  No\",IF(C62=3,\"  N.A.\",\"\")))","v":""},null,4,1323,"Glazing","Indicate number of glazing panes and location of emissivity coating or exception taken"]
["COMPONENT PERFORMANCE (Sections 1330-1338)"]
[{"$f":"IF(C64=1,\"  Yes\",IF(C64=2,\"  No\",IF(C64=3,\"  N.A.\",\"\")))","v":""},null,4,null,"ENV-SUM, ENV-UA,","Completed and attached."]
[null,null,null,null,"ENV-SHGC & ENV-VT Forms"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  Yes","yes","Electric resistance"]
["  No","no","Other"]
["  N.A."]
[null,null,"Provided"]
[null,null,"n.a."]

{"sheet":"Sheet1","index":7,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":true,"merged":[[41,1,41,5],[42,2,42,5],[53,1,53,5],[0,2,0,3],[0,4,0,5]]}
[null,null,"Nonresidential",null,"Residential, Other than Single-Family"]
[null,"Opaque Elements","Assembly","Insulation","Assembly","Insulation"]
[null,null,"Max. U-factor","Min. R-Value","Max. U-factor","Min. R-Value"]
[null,"Roofs"]
[null,"Insulation entirely above deck","U-0.026","R-38 c.i.","U-0.031","R-38 c.i."]
[null,"Metal building","U-0.027","R-25 + R-11 + R-11 Ls","U-0.031","R-25 + R-11 Ls"]
[null,"Single-rafter","U-0.027","R-38","U-0.027","R-38"]
[null,"Attic and other","U-0.027","R-38 adv or R-49","U-0.027","R-38 adv or R-49"]
[null,"Walls, Above Grade"]
[null,"Mass w/ exterior & integral insulation (includes peripheral edges of intermediate floor slabs and columns)","U-0.057","a. R-16 c.i.","U-0.090","R-11.4 c.i."]
[null,null,null,"b. R-20 insulation with < 0.04% Mp"]
[null,null,null,"c. R-24 insulation with > 0.04% and < 0.08% Mp"]
[null,"Mass w/ interior insulation","U-0.056 ","d. R-13 cavity insulation + R-6 c.i. wood studs; or ","U-0.090","R-11.4 c.i."]
[null,"(includes peripheral edges of intermediate floor slabs and columns)",null,"e. R-13 cavity insulation + R-10 c.i. metal studs; or "]
[null,null,null,"f. R-22.4 insulation held solely by 1-in metal clips."]
[null,"Metal building","U-0.052","R-13 + R-13 c.i","U-0.057","R-19 + R-8.5 c.i."]
[null,"Steel framed","U-0.055","a. R-13 cavity + R-10 c.i.","U-0.057","R-19 + R-8.5 c.i."]
[null,null,null,"b. R-13 cavity + R-12.5 insulation with < 0.04% Mp."]
[null,null,null,"c. R-13 cavity + R-15 insulation with"]
[null,null,null,"> 0.04% and < 0.08% Mp."]
[null,"Wood framed and other","U-0.051","a. R-13 cavity + R-7.5 c.i.","U-0.057","R-13 + R-6 c.i."]
[null,null,null,"b. R-13 cavity + R-9.4 insulation with < 0.04% Mp."]
[null,null,null,"c. R-13 cavity + R-11.3 insulation with"]
[null,null,null,"> 0.04% and < 0.08% Mp."]
[null,"Walls, Below Grade"]
[null,"Below grade wall","U-0.070","a. Exterior R-10 c.i",null,"Same as above grade"]
[null,null,null,"b. R-19 cavity insulation wood studs; or "]
[null,null,null,"c. R-13 cavity insulation + R-6 c.i. metal studs; or "]
[null,null,null,"d. R-16.8 insulation held solely by 1-in metal clips."]
[null,"Floors"]
[null,"Mass","U-0.029","R-30 c.i.","U-0.029","R-30 c.i."]
[null,"Steel joist","U-0.029","R-38 cavity + R-4 c.i.","U-0.029","R-38 + R-4 c.i."]
[null,"Wood framed and other","U-0.025","R-38 cavity","U-0.029","R-30"]
[null,"Slab-on-Grade Floors"]
[null,"Unheated","F-0.520","R-15 for 24 in.","F-0.540","R-10 for 24 in."]
[null,null,null,"(with thermal break)",null,"(with thermal break)"]
[null,"Heated","F-0.360","R-10 c.i.","F-0.360","R-10 c.i."]
[null,null,null,"(with thermal break)",null,"(with thermal break)"]
[null,"Opaque Doors"]
[null,"Swinging","U-0.470",null,"U-0.400"]
[null,"Nonswinging","U-0.390",null,"U-0.400"]
[null,"Fenestration  0-30.0% of wall – (Total fenestration area, vertical and overhead, relative to the gross exterior wall area)"]
[null,null,"Assembly Maximum - NFRC-certified or U-Factor per 1006 & SHGC per 1312.1"]
[null,null,"U-Factor","SHGC","U-Factor","SHGC"]
[null,"Vertical Fenestration"]
[null,"Nonmetal framing:  All","U-0.30","For all frame types:","U-0.32"]
[null,"Metal framing:  ",null,"SHGC-0.35 all","U-0.40"]
[null,"   Fixed/operable","U-0.38 2","OR"]
[null,"Entrance doors","U-0.60","SHGC-0.45 all PLUS permanent PF>0.50 on west, south and east","U-0.60"]
[null,"  (revolving doors & vestibules)","(U-0.65)"]
[null,"Skylights"]
[null,"Without curb (i.e., sloped glazing)","U-0.45","SHGC-0.32 all1 ","U-0.50","SHGC-0.35 all"]
[null,"With curb (i.e.,individual unit skylights)","U-0.55",null,"U-0.60"]
[null,"Fenestration  30.0%-40.0% of wall – (Total fenestration area, vertical and overhead, relative to the gross exterior wall area)"]
[null,"Vertical Fenestration"]
[null,"Nonmetal framing:  All","U-0.28","For all frame types:","U-0.32"]
[null,null,null,"SHGC-0.33 all AND minimum VT-0.51 all"]
[null,"Metal framing:  ","U-0.38 2","OR","U-0.40"]
[null,"   Fixed/operable",null,"SHGC-0.45 all PLUS permanent PF>0.50 on west, south and east AND minimum VT-0.51 all"]
[null,"Entrance doors","U-0.60",null,"U-0.60"]
[null,"  (revolving doors & vestibules)","(U-0.65)"]
[null,"Skylights"]
[null,"Without curb (i.e., sloped glazing)","U-0.40","SHGC-0.30 all1","U-0.50","SHGC-0.35 all"]
[null,"With curb (i.e.,individual unit skylights)","U-0.50 ",null,"U-0.60"]
[null,"The following defintions apply: c.i.=continuous insulation, Ls=linear system (see definitions, Mp= cross-sectional area of  metal penetrations per Section 1322."]

{"sheet":"temp","index":8,"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]