{"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":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,12],[22,0,22,12],[7,9,8,9],[7,10,8,10],[7,11,8,11],[7,12,8,12],[21,0,21,12],[20,0,20,8],[7,0,8,0],[7,1,7,3],[7,4,7,6],[7,7,8,7],[7,8,8,8],[23,9,23,12],[23,0,23,8],[6,0,6,12],[1,0,1,12],[2,8,5,12],[2,1,2,7],[3,1,3,7],[9,0,9,12],[4,1,4,7],[5,1,5,7]]}
[]
["Statement of Compliance - National Energy Code of Canada for Buildings 2020                                                                                 Worksheet to NECB Part 3 - Simple Trade-Off"]
["Project Name:",null,null,null,null,null,null,null,"Building Permit Number (Completed Internally)"]
["Project Address:"]
["Applicant Name:"]
["Applicant Address:"]
[" Simple Trade-off Calculations for Above-ground Building Envelop Assemblies (1)"]
["Description or Identification of Building Envelope Assembly","Vertical Portions",null,null,"Horizontal Portions",null,null,"Maximum Allowable Thermal Transmittance of Assembly in Reference Building (prescriptive values): Uir  W/(m2•K)","Thermal Tranmittance of Assembly in Proposed Building: Uip  W/(m2•K)","Area of Assembly in Reference Building: \nAir,\n(m²)","Area of Assembly in Proposed Building: \nAip,\n(m²)","Uir x Air\n(W/K)","Uip x Aip\n(W/K)"]
[null,"Wall","Fenestration","Door","Roof","Floor","Skylight"]
[]
[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}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$12*J$12","v":0},{"$f":"I$12*K$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$13*J$13","v":0},{"$f":"I$13*K$13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$14*J$14","v":0},{"$f":"I$14*K$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$15*J$15","v":0},{"$f":"I$15*K$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$16*J$16","v":0},{"$f":"I$16*K$16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$17*J$17","v":0},{"$f":"I$17*K$17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$18*J$18","v":0},{"$f":"I$18*K$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$19*J$19","v":0},{"$f":"I$19*K$19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H$20*J$20","v":0},{"$f":"I$20*K$20","v":0}]
["TOTALS:",null,null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(\"J11:J\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"K11:K\"&ROW()-1))","v":0},{"$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? (Uip x Aip < total Uir x Air and Aip = Air )"]
[{"$f":"IF(AND(M21<=L21,K21=J21),\"Yes\",\"No\")","v":"Yes"}]
["Consultant Information:"]

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