{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Part 3 Trade-off Worksheet","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Part 3 Trade-off Worksheet","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[27,0,27,12],[6,0,6,12],[1,0,1,12],[2,8,5,12],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,5,7],[26,0,26,12],[7,7,8,7],[7,8,8,8],[23,9,23,10],[23,1,23,6],[0,0,0,12],[25,0,25,12],[7,11,8,11],[7,12,8,12],[24,0,24,12],[7,0,8,0],[7,1,7,3],[7,4,7,6],[7,9,8,9],[7,10,8,10],[9,0,9,8],[9,9,9,12]]}
[]
["National Building Code 2019 Alberta Edition Article 9.36.2.11                                                                                              Worksheet for Building Envelope Trade-Off"]
["Project Name:",null,null,null,null,null,null,null,"Building Permit Number (Completed Internally)"]
["Project Address:"]
["Applicant Name:"]
["Applicant Address:"]
["Trade-off Calculations for Above-ground Building Envelope Assemblies"]
["Description or Identification of Building Envelope Assembly","Opaque Portions",null,null,"Fenestration Portions",null,null,"Area of Assembly in Reference Building: \nAir,\n(m²)","Area of Assembly in Proposed Building: \nAip,\n(m²)","Minimum Allowable Thermal Resistance of Assembly in Reference Building (prescriptive values): Rir  (m2•K)/W","Thermal Resistance of Assembly in Proposed Building: Rip  (m2•K)/W","Air / Rir\n(W/K)","Aip / Rip\n(W/K)"]
[null,"Wall","Roof","Floor","Fenestration","Door","Skylight"]
["Fenestration Trade offs are limited to fenestration on the same elevation. Please indicate which elevation contains the fenestration being calculated",null,null,null,null,null,null,null,null,"North            South            East            West   "]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J12=0,0,H12/J12)","v":0},{"$f":"IF(K12=0,0,I12/K12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J13=0,0,H13/J13)","v":0},{"$f":"IF(K13=0,0,I13/K13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J14=0,0,H14/J14)","v":0},{"$f":"IF(K14=0,0,I14/K14)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J15=0,0,H15/J15)","v":0},{"$f":"IF(K15=0,0,I15/K15)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["TOTALS:",null,null,null,null,null,null,{"$f":"SUM(INDIRECT(\"h11:h\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"i11:i\"&ROW()-1))","v":0},null,null,{"$f":"SUM(INDIRECT(\"L11:L\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"M11:M\"&ROW()-1))","v":0}]
["Is building envelope compliant with simple trade-off path? (Aip / Rip < total Air / Rir and Aip = Air )"]
[{"$f":"IF(AND(M24<=L24,H24=I24),\"Yes\",\"No\")","v":"Yes"}]
["The areas used in the above calculation shall be clearly indicated on the accompanying drawings."]

{"sheet":"Sheet3","index":1,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$11*J$11","v":0},{"$f":"I$11*K$11","v":0}]