{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["9.36-trade-off","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":"9.36-trade-off","index":0,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,11,9,11],[8,12,9,12],[22,0,22,12],[8,0,9,0],[8,1,8,3],[8,4,8,6],[8,9,9,9],[8,10,9,10],[10,0,10,8],[10,9,10,12],[0,0,0,12],[1,0,1,12],[25,0,25,12],[7,0,7,12],[2,0,2,12],[3,8,6,12],[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[24,0,24,12],[8,7,9,7],[8,8,9,8],[21,9,21,10],[21,1,21,6],[23,0,23,12]]}
[]
["9.36: Trade-off Calculator"]
["The Current National Building Code Alberta Edition Article 9.36.2.11\nWorksheet 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,200,200,5.03,8.67,{"$f":"IF(J13=0,0,H13/J13)","v":39.761431411530815},{"$f":"IF(K13=0,0,I13/K13)","v":23.068050749711649}]
[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,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,{"$f":"IF(J21=0,0,H21/J21)","v":0},{"$f":"IF(K21=0,0,I21/K21)","v":0}]
["TOTALS:",null,null,null,null,null,null,{"$f":"SUM(INDIRECT(\"h11:h\"&ROW()-1))","v":200},{"$f":"SUM(INDIRECT(\"i11:i\"&ROW()-1))","v":200},null,null,{"$f":"SUM(INDIRECT(\"L11:L\"&ROW()-1))","v":39.761431411530815},{"$f":"SUM(INDIRECT(\"M11:M\"&ROW()-1))","v":23.068050749711649}]
["Is building envelope compliant with simple trade-off path? (Aip / Rip < total Air / Rir and Aip = Air )"]
[{"$f":"IF(AND(M22<=L22,H22=I22),\"Yes\",\"No\")","v":"Yes"}]
["The areas used in the above calculation shall be clearly indicated on the accompanying drawings."]
["(2025-02)"]

{"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}]