{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Master","Instructions","Base Building U-Value","New Sheet 1"],"not_rendered":{"charts":1,"images":16,"macros":1,"external_links":1,"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":"Master","index":0,"n_rows":26,"n_cols":22,"rows_kept":26,"cut":false,"hidden":true,"merged":[[10,21,10,22],[11,21,11,22],[12,21,12,22],[10,23,10,24],[11,23,11,24],[12,23,12,24],[10,29,10,30],[11,29,11,30],[12,29,12,30],[10,25,10,26],[11,25,11,26],[12,25,12,26],[10,27,10,28],[11,27,11,28],[12,27,12,28],[11,5,11,6],[5,0,5,3],[17,0,19,0],[11,8,11,9],[12,8,12,9],[17,2,19,2],[17,1,19,1],[17,6,19,6],[17,7,19,7],[17,8,19,8],[17,9,19,9],[17,4,19,4],[17,5,19,5],[10,8,10,10],[6,0,6,3],[2,7,2,10],[21,0,21,10],[25,0,25,10],[25,21,25,30],[12,5,12,6],[24,21,24,30],[17,3,19,3],[17,21,19,30],[20,21,20,30],[22,21,22,30],[17,10,19,10],[17,14,19,14],[17,15,19,15],[21,21,21,30],[23,21,23,30],[10,5,10,7]]}
[]
[null,null,null,null,null,null,null,"Scenario Description"]
[null,null,null,null,null,null,null,"Enter Scenario Name",null,null,null,null,null,null,null,null,null,null,"Max U-Value Coefficients"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m","b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.005124432086739,4.6584087593014717E-2]
[]
["Enhanced Thermal Performance Spread Sheet",null,null,null,{"$f":"IF(N13=TRUE, \"IP Units\", \"SI Units\")","v":"SI Units"}]
[]
[]
["Clear Field Area Method",null,null,null,null,"Overall Opaque Wall Thermal Performance Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Workspace"]
["Select Area Calculation (Choose One)","Area","Units",null,null,"Base Building ",null,null,"Proposed Building",null,null,"Sum Option On or Off","Percent Difference","If values are number or not","% Below Baseline",null,"Base Building Clear Field U-Value",{"$f":"SUM(R21:R22)/B12","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"SUM(N21:N22)","v":0},"m2",null,null,"Opaque USI-Value\n(W/m2K)",null,"Enter Base Building       U-Value","Opaque USI-Value\n(W/m2K)",null,{"$f":"IF(ISERROR(J17/(IF(L12=TRUE,B12,B13))),\"-\",J17/(IF(L12=TRUE,B12,B13)))","v":"-"},true,{"$f":"-(1-K12/H12)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(M12), TRUE, FALSE)","v":false},{"$f":"IF(N12=TRUE,IF(M12>=10,\"> +1000%\",M12),\"-\")","v":"-"},null,"Max Overall U-Value",{"$f":"S5*R11+T5","v":{"$error":"#DIV/0!"}},null,"Used U-Value"]
[null,"Enter User Defined Opaque Area","m2",null,null,"Effective RSI-Value\n(m2K/W)",null,{"$f":"IF(ISERROR(1/H12),\"-\",1/H12)","v":"-"},"Effective RSI-Value\n(m2K/W)",null,{"$f":"IF(ISERROR(1/K12),\"-\",1/K12)","v":"-"},false,null,false,null,null,"Base Building Overall U-Value",{"$f":"IF(ISERROR(R17/(IF(L12=TRUE,B12,B13))),\"-\",R17/(IF(L12=TRUE,B12,B13)))","v":"-"},null,{"$f":"IF(R13>=R12, R12, R13)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Proposed Building Entries",null,null,null,null,null,null,null,"Totals ",{"$f":"SUM(J21:J26)","v":0},{"$f":"SUM(K21:K26)","v":0},null,null,null,null,null,null,{"$f":"SUM(R21:R26)","v":0}]
["Add/Remove Detail","Transmittance Type","Include","Transmittance Description","Area, Length or Amount Takeoff","Units","Transmittance Value","Units","Source Reference","Heat Flow\n(W/K)","%Total Heat Flow",null,null,null,null,null,null,null,null,null,null,"Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Include On or Off","Conditional Formatting On or Off","Area On or Off"]
[1,"Clear Field",null,"Enter Description Here","Enter Area Here","m2","Enter Clear Field U-Value Here","W/m2K","Enter Source Here",{"$f":"IF(ISERROR(G21*E21),\"-\",IF(L21=TRUE,G21*E21,))","v":"-"},{"$f":"IF(ISERROR(J21/$J$17),\"-\",J21/$J$17)","v":"-"},true,{"$f":"IF(L21=FALSE,TRUE,FALSE)","v":false},{"$f":"IF(L21=TRUE,E21,0)","v":"Enter Area Here"},null,null,null,{"$f":"IF(ISERROR(O21*E21),\"-\",IF(L21=TRUE,O21*E21,))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Linear Interface Detail",null,"Enter Description Here","Enter Length Here","m","Enter Psi-Value Here","W/mK","Enter Source Here",{"$f":"IF(ISERROR(G23*E23),\"-\",IF(L23=TRUE,G23*E23,))","v":"-"},{"$f":"IF(ISERROR(J23/$J$17),\"-\",J23/$J$17)","v":"-"},true,false,null,null,null,null,{"$f":"IF(ISERROR(O23*E23),\"-\",IF(L23=TRUE,O23*E23,))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Point Interface Detail",null,"Enter Description Here","Enter Amount Here","#","Enter Chi-Value Here","W/K","Enter Source Here",{"$f":"IF(ISERROR(G25*E25),\"-\",IF(L25=TRUE,G25*E25,))","v":"-"},{"$f":"IF(ISERROR(J25/$J$17),\"-\",J25/$J$17)","v":"-"},true,{"$f":"IF(L25=FALSE,TRUE,FALSE)","v":false},null,null,null,null,{"$f":"IF(ISERROR(O25*E25),\"-\",IF(L25=TRUE,O25*E25,))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]

{"sheet":"Instructions","index":1,"n_rows":106,"n_cols":1,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Enhanced Thermal Performance Spread Sheet"]
[]
["Introduction"]
[]
["This enchanced spreadsheet is intended to be a helpful tool in combining thermal performance values for building assemblies into an overall R- and U-Value. The methodology for calculations in this spreadsheet follows the approach given in the Building Envelope Thermal Bridging Guide. This methodology allows for the calculation of R- and U- values that include the heat flow effects from clear field transmittances, linear transmittances and point transmittances. For more information on the methodology, the guide can be found free for download at the BC Hydro New Construction website:"]
["Building Envelope Thermal Bridging Guide"]
[]
["Disclaimer"]
["Pleae note that this is only a tool to assist in calculations. As with all calculations, proper judgement is needed in determining appropriate values to use with this spreadsheet. It is not intended to be used without an understanding of the calculation methodology behind this spreadsheet, as detailed in the Building Envelope Thermal Bridging Guide. It is soley upto the users of this spreadsheet to determine whether the values found using this spreadsheet are appropriate for their intended use. "]
[]
["Spreadsheet Entries"]
[]
["This spread sheet has many sections where Users may input data. Here we will go over each input."]
[]
["Scenario Name"]
["Enter a name for the scenario. This is for organization for the users who may have multiple cases that they would like to compare"]
[]
["Create New WorkSheet"]
["This will create a new blank worksheet"]
[]
["Copy to New WorkSheet"]
["This will copy the current scenario and all its entries into a new tab"]
[]
["Reset Current WorkSheet"]
["This will reset all the information in the worksheet back to its default entries. Note, all user inputted information will be erased from the selected worksheet"]
[]
["Change Units"]
["Clicking this button will change all the units in the spreadsheet from Imperial (IP) to the Internation System of Units (SI). This will convert all users entries as well"]
[]
["Clear Field Area Method"]
["Two options are available for the Total Area to be used in calculations. The default is to use a sum of the active clear field areas which is automatically calculated from the user entered areas in clear field section. Clear fields that are not active will not be included in this sum. In some cases, the Total Area for calculations may not match the total clear field area (such as with floor to ceiling glazing situations) and the second option is for the User to manually input the area to be used. See the Building Envelope Thermal Bridiging Guide, 1-11 for more information"]
[]
["Base Building U-value"]
["See Base Building U-Value Tab"]
[]
["Workspace"]
["This is a blank work area that can be used for quick calculations"]
[]
["Add Clear Field"]
["Clicking this button will add another blank Clear Field line"]
[]
["Add Linear Interface Detail"]
["Clicking this button will add another blank Linear Interface Detail line"]
[]
["Add Point Interface Detail"]
["Clicking this button will add another blank Point Interface Detail line"]
[]
["Include"]
["Clicking the checkmark on will include this clear field/interface detail in calculations. Unclicking this checkmark will exclude this entry from calculations"]
[]
["Enter Description"]
["User can input a description of the clear field or interface detail. Ie \"Exterior insulated steel stud wall\""]
[]
["Area, Length or Amount Takeoff"]
["Enter the area of the clear field assembly, length of the interface detail or number of a particular point interface detail"]
[]
["Transmittance Value"]
["Enter the appropriate transmittance value. Enter the U-value for the clear field, a Psi-Value for the Linear detail and the Chi-Value for the point detail"]
[]
["Source Reference"]
["Optionally the User can put the reference from which the transmittance was found. Ie \"Detail 5.2.1 from the Building Envelope Thermal Bridging Guide\" or \"Hand Calculations\""]
[]
["Notes"]
["User can enter any other notes for a particular clear field assembly or detail as they wish"]
[]
["Spreadsheet Values"]
[]
["Base Building U- and R-Value"]
["This is the base building U- and R-Values as determined by the User. See Base Building U-Value tab"]
[]
["Proposed Building U- and R-Value"]
["This is the proposed building U- and R-Values as determined by the spreadsheet calculator. This includes all active clear field assemblies and linear and point details along with all active takeoff values. This will not return a value if there is an error with any of the values. This is calculated using the follow equation. For more information on the calculation, see the Building Envelope Thermal Bridging Guide"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["% Below Baseline"]
["This value shows the difference between the base building and proposed building U-values in percentage. Red indicates that the proposed is worse than the base. Green indicates the proposed is better than the base. "]
[]
["Heat Flow"]
["Shows the actual total amount of heat flow from the clear field assembly or detail (not averaged per area)"]
[]
["% Total Heat Flow"]
["Shows the percentage of total heat flow from that particular clear field assembly or detail compared to the other active assemblies or details. This can be useful in determining the biggest contributor to heat flow."]

{"sheet":"Base Building U-Value","index":2,"n_rows":80,"n_cols":21,"rows_kept":80,"cut":false,"hidden":false,"merged":[[11,0,11,7],[50,0,50,7],[69,0,69,7],[26,17,26,20],[31,17,31,20],[39,17,39,20],[44,17,44,20],[76,0,76,2],[71,0,71,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Enhanced Thermal Performance Spread Sheet"]
[]
["Base Building U-value"]
["In typical energy models using ASHRAE 90.1-2010, the base building uses building envelope values based on the prescriptive tables 5.5-1 to 5.5-8, depending on the climate zone. For the BC Hydro New Construction Program, these values are derated for the base building to include a default amount of thermal bridging in the base building. The ASHRAE 90.1-2010 values are derated according to the graph in Figure 1. The amount of derating depends on the construction type and building type. An allowance has been made for High-Rise Multi-Unit Residential Buildings. For a given construction type, and User must determine what their ASHARE 90.1-2010 prescriptive U-value (or USI-Value) is. Then using Figure 1, the User will find where their ASHRAE 90.1-2010 value is on the horizontal axis and where it intercepts either the High-Rise MURB or All Other curve. This intercept will line up with the Base Building U-Value (or USI value) on the vertical axis. This value is input into the Base Building U-Value entry"]
[]
[]
[null,null,null,"Base Building - All Other",null,null,null,"Base Building - High-Rise MURB"]
["R","90.1-2010 U-Value","USI","%Increase",null,"Maximum Allowable U-value","USI","%Increase",null,"Maximum Allowable U-value","USI"]
[8,{"$f":"1/A17","v":0.125},{"$f":"B17*5.678","v":0.70974999999999999},38,{"$f":"1+D17/100","v":1.38},{"$f":"B17*E17","v":0.17249999999999999},{"$f":"F17*5.678","v":0.97945499999999996},65,{"$f":"1+H17/100","v":1.65},{"$f":"B17*I17","v":0.20624999999999999},{"$f":"J17*5.678","v":1.1710874999999998}]
[12.5,{"$f":"1/A18","v":0.08},{"$f":"B18*5.678","v":0.45423999999999998},57,{"$f":"1+D18/100","v":1.5699999999999998},{"$f":"B18*E18","v":0.12559999999999999},{"$f":"F18*5.678","v":0.71315679999999992},98,{"$f":"1+H18/100","v":1.98},{"$f":"B18*I18","v":0.15840000000000001},{"$f":"J18*5.678","v":0.89939520000000006}]
[15.6,{"$f":"1/A19","v":6.4102564102564111E-2},{"$f":"B19*5.678","v":0.36397435897435904},75,{"$f":"1+D19/100","v":1.75},{"$f":"B19*E19","v":0.1121794871794872},{"$f":"F19*5.678","v":0.63695512820512834},127,{"$f":"1+H19/100","v":2.27},{"$f":"B19*I19","v":0.14551282051282052},{"$f":"J19*5.678","v":0.82622179487179492}]
[23.8,{"$f":"1/A20","v":4.2016806722689072E-2},{"$f":"B20*5.678","v":0.23857142857142855},113,{"$f":"1+D20/100","v":2.13},{"$f":"B20*E20","v":8.9495798319327718E-2},{"$f":"F20*5.678","v":0.50815714285714275},195,{"$f":"1+H20/100","v":2.95},{"$f":"B20*I20","v":0.12394957983193278},{"$f":"J20*5.678","v":0.70378571428571435}]
[27.8,{"$f":"1/A21","v":3.5971223021582732E-2},{"$f":"B21*5.678","v":0.20424460431654676},128,{"$f":"1+D21/100","v":2.2800000000000002},{"$f":"B21*E21","v":8.2014388489208639E-2},{"$f":"F21*5.678","v":0.46567769784172663},221,{"$f":"1+H21/100","v":3.21},{"$f":"B21*I21","v":0.11546762589928057},{"$f":"J21*5.678","v":0.65562517985611513}]
[null,null,null,null,"Slope",{"$f":"SLOPE(F17:F21,B17:B21)","v":1.005124432086739},{"$f":"SLOPE(G17:G21,C17:C21)","v":1.0051244320867392},null,null,{"$f":"SLOPE(J17:J21,B17:B21)","v":1.0017519330085047},{"$f":"SLOPE(K17:K21,C17:C21)","v":1.0017519330085045}]
[null,null,null,null,"Intercept",{"$f":"INTERCEPT(F17:F21,B17:B21)","v":4.6584087593014717E-2},{"$f":"INTERCEPT(G17:G21,C17:C21)","v":0.26450444935313755},null,null,{"$f":"INTERCEPT(J17:J21,C17:C21)","v":8.0376270585779272E-2},{"$f":"INTERCEPT(K17:K21,C17:C21)","v":0.45637646438605467}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 1: Typical Base Building Values (IP)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wall Type","ASHRAE 90.1 Zone 5 \nU-Value","Base Building \nU-value: High Rise MURB","Base Building \nU-Value: All Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non Residential"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mass",0.09,"-",0.13700000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Building",0.113,"-",0.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steel-Framed",6.4000000000000001E-2,"-",0.1109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood-Framed and Other",6.4000000000000001E-2,"-",0.1109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mass",0.08,0.1605,0.12698999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Building",5.7000000000000002E-2,"-",0.103876]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steel-Framed",6.4000000000000001E-2,0.1444,0.1109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood-Framed and Other",5.0999999999999997E-2,"-",9.7845000000000001E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 2: Typical Base Building Values (SI)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wall Type","ASHRAE 90.1 Zone 5 \nU-Value","Base Building \nU-value: High Rise MURB","Base Building \nU-Value: All Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non Residential"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mass",{"$f":"S28*5.678","v":0.51102000000000003},"-",0.77800000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Building",{"$f":"S29*5.678","v":0.64161400000000002},"-",0.90900000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steel-Framed",0.36339199999999999,"-",0.62975000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood-Framed and Other",0.36339199999999999,"-",0.62975000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mass",{"$f":"S33*5.678","v":0.45423999999999998},0.91100000000000003,0.72106999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Building",{"$f":"S34*5.678","v":0.32364599999999999},"-",0.58979999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steel-Framed",0.36339199999999999,0.82,0.62975000000000003]
["Figure 1: BC Hydro New Construction Base Building Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood-Framed and Other",0.289578,"-",0.55549999999999999]
[]
["Tables 1 and 2 show common entries for ASHRAE 90.1-2010 Zone 5 and the resulting Base Building U-values. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["If doing an multiple construction area weighted building U- or R-Value, the same would have to be done for the ASHRAE 90.1-2010 value. For example if an office building in Zone 5 had 50% steel stud and 50% mass wall, the ASHRAE 90.1-2010 value would be U-0.077 (USI-0.437). From Figure 1, the Base Building U-Value would be U-0.124 (USI-0.704). Below is a quick calculator using the values in Figure 1 to assist in calculting the base building U-value"]
[]
["High Rise MURB Base Building Calculator"]
["Unit Type","ASHRAE 90.1-2010 Value","Base Building Value"]
["IP","Enter IP \nU-Value",{"$f":"IF(ISERROR(INT(B74))=FALSE,IF(B74=0,\"-\",B74*J22+J23),\"-\")","v":"-"}]
["SI","Enter SI \nUSI-Value",{"$f":"IF(ISERROR(INT(B75))=FALSE,IF(B75=0,\"-\",B75*K22+K23),\"-\")","v":"-"}]
[]
["All Other Base Building Calculator"]
["Unit Type","ASHRAE 90.1-2010 U-Value","Base Building U-Value"]
["IP","Enter IP \nU-Value",{"$f":"IF(ISERROR(INT(B79))=FALSE,IF(B79=0,\"-\",B79*F22+F23),\"-\")","v":"-"}]
["SI","Enter SI \nUSI-Value",{"$f":"IF(ISERROR(INT(B80))=FALSE,IF(B80=0,\"-\",B80*G22+G23),\"-\")","v":"-"}]

{"sheet":"New Sheet 1","index":3,"n_rows":26,"n_cols":22,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,21,23,30],[24,21,24,30],[25,0,25,10],[25,21,25,30],[17,15,19,15],[17,21,19,30],[20,21,20,30],[21,0,21,10],[21,21,21,30],[22,21,22,30],[17,6,19,6],[17,7,19,7],[17,8,19,8],[17,9,19,9],[17,10,19,10],[17,14,19,14],[17,0,19,0],[17,1,19,1],[17,2,19,2],[17,3,19,3],[17,4,19,4],[17,5,19,5],[11,29,11,30],[12,5,12,6],[12,8,12,9],[12,21,12,22],[12,23,12,24],[12,25,12,26],[12,27,12,28],[12,29,12,30],[10,23,10,24],[10,25,10,26],[10,27,10,28],[10,29,10,30],[11,5,11,6],[11,8,11,9],[11,21,11,22],[11,23,11,24],[11,25,11,26],[11,27,11,28],[10,21,10,22],[2,7,2,10],[5,0,5,3],[6,0,6,3],[10,5,10,7],[10,8,10,10]]}
[]
[null,null,null,null,null,null,null,"Scenario Description"]
[null,null,null,null,null,null,null,"Enter Scenario Name",null,null,null,null,null,null,null,null,null,null,"Max U-Value Coefficients"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m","b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.005124432086739,4.6584087593014717E-2]
[]
["Enhanced Thermal Performance Spread Sheet",null,null,null,{"$f":"IF(N13=TRUE, \"IP Units\", \"SI Units\")","v":"SI Units"}]
[]
[]
["Clear Field Area Method",null,null,null,null,"Overall Opaque Wall Thermal Performance Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Workspace"]
["Select Area Calculation (Choose One)","Area","Units",null,null,"Base Building ",null,null,"Proposed Building",null,null,"Sum Option On or Off","Percent Difference","If values are number or not","% Below Baseline",null,"Base Building Clear Field U-Value",{"$f":"SUM(R21:R22)/B12","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"SUM(N21:N22)","v":0},"m2",null,null,"Opaque USI-Value\n(W/m2K)",null,"Enter Base Building       U-Value","Opaque USI-Value\n(W/m2K)",null,{"$f":"IF(ISERROR(J17/(IF(L12=TRUE,B12,B13))),\"-\",J17/(IF(L12=TRUE,B12,B13)))","v":"-"},true,{"$f":"-(1-K12/H12)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(M12), TRUE, FALSE)","v":false},{"$f":"IF(N12=TRUE,IF(M12>=10,\"> +1000%\",M12),\"-\")","v":"-"},null,"Max Overall U-Value",{"$f":"S5*R11+T5","v":{"$error":"#DIV/0!"}},null,"Used U-Value"]
[null,"Enter User Defined Opaque Area","m2",null,null,"Effective RSI-Value\n(m2K/W)",null,{"$f":"IF(ISERROR(1/H12),\"-\",1/H12)","v":"-"},"Effective RSI-Value\n(m2K/W)",null,{"$f":"IF(ISERROR(1/K12),\"-\",1/K12)","v":"-"},false,null,false,null,null,"Base Building Overall U-Value",{"$f":"IF(ISERROR(R17/(IF(L12=TRUE,B12,B13))),\"-\",R17/(IF(L12=TRUE,B12,B13)))","v":"-"},null,{"$f":"IF(R13>=R12, R12, R13)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Proposed Building Entries",null,null,null,null,null,null,null,"Totals ",{"$f":"SUM(J21:J26)","v":0},{"$f":"SUM(K21:K26)","v":0},null,null,null,null,null,null,{"$f":"SUM(R21:R26)","v":0}]
["Add/Remove Detail","Transmittance Type","Include","Transmittance Description","Area, Length or Amount Takeoff","Units","Transmittance Value","Units","Source Reference","Heat Flow\n(W/K)","%Total Heat Flow",null,null,null,null,null,null,null,null,null,null,"Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Include On or Off","Conditional Formatting On or Off","Area On or Off"]
[1,"Clear Field",null,"Enter Description Here","Enter Area Here","m2","Enter Clear Field U-Value Here","W/m2K","Enter Source Here",{"$f":"IF(ISERROR(G21*E21),\"-\",IF(L21=TRUE,G21*E21,))","v":"-"},{"$f":"IF(ISERROR(J21/$J$17),\"-\",J21/$J$17)","v":"-"},true,{"$f":"IF(L21=FALSE,TRUE,FALSE)","v":false},{"$f":"IF(L21=TRUE,E21,0)","v":"Enter Area Here"},null,null,null,{"$f":"IF(ISERROR(O21*E21),\"-\",IF(L21=TRUE,O21*E21,))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Linear Interface Detail",null,"Enter Description Here","Enter Length Here","m","Enter Psi-Value Here","W/mK","Enter Source Here",{"$f":"IF(ISERROR(G23*E23),\"-\",IF(L23=TRUE,G23*E23,))","v":"-"},{"$f":"IF(ISERROR(J23/$J$17),\"-\",J23/$J$17)","v":"-"},true,false,null,null,null,null,{"$f":"IF(ISERROR(O23*E23),\"-\",IF(L23=TRUE,O23*E23,))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Point Interface Detail",null,"Enter Description Here","Enter Amount Here","#","Enter Chi-Value Here","W/K","Enter Source Here",{"$f":"IF(ISERROR(G25*E25),\"-\",IF(L25=TRUE,G25*E25,))","v":"-"},{"$f":"IF(ISERROR(J25/$J$17),\"-\",J25/$J$17)","v":"-"},true,{"$f":"IF(L25=FALSE,TRUE,FALSE)","v":false},null,null,null,null,{"$f":"IF(ISERROR(O25*E25),\"-\",IF(L25=TRUE,O25*E25,))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]