{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions and Help","Input (3 Layer)","Input (4 layer)","Output","CMU Calculations (3 Layer)","CMU Calculations (4 layer)","Hidden Outputs","Inside Finishes","Outside Finishes","Grouting"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions and Help","index":0,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"NCMA R-Value/U-Factor Calculator"]
[]
[null,null,"This spreadsheet provides calculations of R-Value and U-Factor for concrete masonry assemblies."]
[null,null,"Instructions"]
[null,null,"1)","Blue cells are for user input and can be modified as desired."]
[null,null,"2)","Beige cells are important output cells, as calculated by the spreadsheet, and cannot be modified."]
[null,null,"3)","Orange cells are optional input. As noted, they will override certain values previously entered."]
[null,null,"4)","Decide if the unit to be evaluated is 3 layer or 4 layer (see diagrams on each tab). "]
[null,null,null,"Use only the correct input sheet for the unit being evaluated"]
[null,null,"5)","Surface finishes can be chosen from drop-down menus. Assemblies can have no finishes,"]
[null,null,null,"or finishes can be added to the interior, exterior, or both."]
[null,null,"6)","Results with summary of assembly variables will be listed on the 'Output' tab."]
[null,null,"7)","Detailed Instruction can be found by clicking the icon below (will open Help file in Adobe Acrobat)"]
[null,null,"8)","To prevent inadvertent changing of this spreadsheet's functions, many of the cells are lock from editing"]
[null,null,null,"Users may unlock the spreadsheet if they so desire using the password: 'bloxrox'"]
[]
[null,null,null,"DISCLAIMER: NCMA and the companies disseminating this technical information disclaim any and all"]
[null,null,null,"responsibility and liability for the accuracy and application of the information contained in this"]
[null,null,null,"publication."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Version 1.1, Revised March 19, 2019"]

{"sheet":"Input (3 Layer)","index":1,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["NCMA R-Value / U-Factor / Heat Capacity Calculator"]
["User Input Page (3 Layer Unit)",null,null,null,null,null,null,null,null,null,"3 Layer Unit"]
[]
["Please enter inputs below for the wall assembly"]
[]
["Step 2: CMU Description "]
["Description:"]
[" NOTE: Enter description of CMU to be included in calculation output"]
["Step 3: CMU Nominal Dimesions",null,null,null,"Specified"]
["Width (in.)",null,null,null,{"$f":"C13-0.375","v":-0.375}]
["Height (in.)",null,null,null,{"$f":"C14-0.375","v":-0.375}]
["Length (in.)",null,null,null,{"$f":"C15-0.375","v":-0.375}]
[]
["Step 4: Face Shell Thickness"]
["Face 1 Thickness (in.)"]
["Face 2 Thickness (in.)"]
[null,null,null,null,null,null,null,null,"Calculated ",null,"Steps 11 & 12: Surface Finishes"]
["Step 4: Web Information",null,null,null,null,null,null,null,"Web Area"]
["Web 1 Thickness (in.)",null,null,null,"Web 1 Height (in.)",null,null,null,{"$f":"C22*G22","v":0},null,"Inside Surface Finish",null,"None"]
["Web 2 Thickness (in.)",null,null,null,"Web 2 Height (in.)",null,null,null,{"$f":"C23*G23","v":0}]
["Web 3 Thickness (in.)",null,null,null,"Web 3 Height (in.)",null,null,null,{"$f":"C24*G24","v":0},null,"Outside Surface Finish",null,"None"]
["Web 4 Thickness (in.)",null,null,null,"Web 4 Height (in.)",null,null,null,{"$f":"C25*G25","v":0},null,{"$f":"IF(M24=\"Cavity Wall\", \"   - If Cavity Wall, Choose Veneer Type:\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Total",{"$f":"IF(E27=\"\",SUM(I22:I25),E27)","v":0},null,{"$f":"IF(M24=\"Cavity Wall\",\"   - If cavity wall, choose insulation type and thickness:\",\"\")","v":""}]
[" - Option - enter total web area for CMU"]
["NOTE - Entering a total web area above will overide individial web entries."]
[]
["Step 7: Density and Resistivity"]
["CMU Density (lb/ft3)",null,null,null,"Thermal Resistivity",null,null,{"$f":"IF(G32=\"\",1/(0.6*(EXP(0.02*C31))),G32)","v":1.6666666666666667}]
[" - Option - specify concrete thermal resistivity (hr-ft2-°F/Btu-in.)"]
["NOTE - Entering a specific thermal conductivity will override value calcuated based on density"]
[]
["Step 8: Cell Fill"]
["Open Cells Filled with",null,"(input air or insulation)",null,null,"Air"]
[" - if insulation, enter R-value for insulation per inch"]
["NOTE: This will be used for the fill of all cells not grouted."]
[]
["Step 9: Grouting "]
["Choose no grout, fully grouted, or partially grouted",null,null,null,null,"None"]
["- if partial, select grout schedule below"]
[null,null,"Vertical Grout Spacing (inch on center)",null,null,"None",null,{"$f":"IF(F43=\"None\",(1/(F44/8))*100,IF(F44=\"None\",(1/(F43/8))*100,((((F43/8)-1)+(F44/8))/((F43/8)*(F44/8)))*100))","v":{"$error":"#VALUE!"}}]
[null,null,"Horizontal Grout Spacing (inch on center)",null,null,"None"]
[]
["Grouting - percent of wall ungrouted",null,null,null,null,{"$f":"100-F47","v":100},"%"]
[" - percent grouted",null,null,null,null,{"$f":"IF(F41=\"None\",0,IF(F41=\"Fully Grouted\",100,ROUND(H43,1)))","v":0},"%"]
[]
["Step 10: Heat Capacity"]
["If known, enter Heat Capacity",null,null,null,null,null,"Btu/ft2-°F"]
["For more information on heat capacity, see NCMA TEK Note 6-16A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(A68=\"None\",(1/(A69/8))*100,IF(A69=\"None\",(1/(A68/8))*100,((((A68/8)-1)+(A69/8))/((A68/8)*(A69/8)))*100))","v":{"$error":"#DIV/0!"}}]

{"sheet":"Input (4 layer)","index":2,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["NCMA R-Value / U-Factor / Heat Capacity Calculator"]
["User Input Page (4 Layer Unit)",null,null,null,null,null,null,null,null,null,"4 Layer Unit"]
[]
["Please enter inputs below for the wall assembly"]
[]
["Step 2: CMU Description "]
["Description:"]
[" NOTE: Enter description of CMU to be included in calculation output"]
["Step 3: CMU Nominal Dimesions",null,null,null,"Specified"]
["Width (in.)",null,null,null,{"$f":"C13-0.375","v":-0.375}]
["Height (in.)",null,null,null,{"$f":"C14-0.375","v":-0.375}]
["Length (in.)",null,null,null,{"$f":"C15-0.375","v":-0.375}]
[]
["Step 4: Face Shell Thickness"]
["Face 1 Thickness (in.)"]
["Face 2 Thickness (in.)"]
[null,null,null,null,null,null,null,null,"Calculated ",null,"Steps 11 & 12: Surface Finishes"]
["Step 4: Web Information (Layer 2)",null,null,null,null,null,null,null,"Web Area"]
["Web 1 Thickness (in.)",null,null,null,"Web 1 Height (in.)",null,null,null,{"$f":"C22*G22","v":0},null,"Inside Surface Finish",null,"None"]
["Web 2 Thickness (in.)",null,null,null,"Web 2 Height (in.)",null,null,null,{"$f":"C23*G23","v":0}]
["Web 3 Thickness (in.)",null,null,null,"Web 3 Height (in.)",null,null,null,{"$f":"C24*G24","v":0},null,"Outside Surface Finish",null,"None"]
["Web 4 Thickness (in.)",null,null,null,"Web 4 Height (in.)",null,null,null,{"$f":"C25*G25","v":0},null,{"$f":"IF(M24=\"Cavity Wall\", \"   - If Cavity Wall, Choose Veneer Type:\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Total",{"$f":"IF(E27=\"\",SUM(I22:I25),E27)","v":0},null,{"$f":"IF(M24=\"Cavity Wall\",\"   - If cavity wall, choose insulation type and thickness:\",\"\")","v":""}]
[" - Option - enter total web area for Layer 2 Webs"]
["NOTE - Entering a total web area above will overide individial web entries."]
[]
["Step 6: Insulation Insert (Layer 2)"]
["Type (description)"]
["Thickess (in.)"]
["R-value (per inch)"]
[]
[null,null,null,null,null,null,null,null,"Calculated "]
["Step 4: Web Information (Layer 3)",null,null,null,null,null,null,null,"Web Area"]
["Web 1 Thickness (in.)",null,null,null,"Web 1 Height (in.)",null,null,null,{"$f":"C37*G37","v":0}]
["Web 2 Thickness (in.)",null,null,null,"Web 2 Height (in.)",null,null,null,{"$f":"C38*G38","v":0}]
["Web 3 Thickness (in.)",null,null,null,"Web 3 Height (in.)",null,null,null,{"$f":"C39*G39","v":0}]
["Web 4 Thickness (in.)",null,null,null,"Web 4 Height (in.)",null,null,null,{"$f":"C40*G40","v":0}]
[null,null,null,null,null,null,null,"Total",{"$f":"IF(E42=\"\",SUM(I37:I40),E42)","v":0}]
[" - Option - enter total web area for Layer 3 Webs"]
["NOTE - Entering a total web area above will overide individial web entries."]
[]
[]
["Step 7: Density and Resistivity"]
["CMU Density (lb/ft3)",null,null,null,"Thermal Resistivity",null,null,{"$f":"IF(G48=\"\",1/(0.6*(EXP(0.02*C47))),G48)","v":1.6666666666666667}]
[" - Option - specify concrete thermal resistivity (hr-ft2-F/Btu-in.)"]
["NOTE - Entering a specific thermal conductivity will override value calcuated based on density"]
[]
["Step 8: Cell Fill"]
["Open Cells Filled with",null,"(input air or insulation)",null,null,"Air"]
[" - if insulation, enter R-value for insulation per inch",null,null,null,null,0]
["NOTE: This will be used for the fill of all cells not grouted."]
[]
["Step 9: Grouting "]
["Choose no grout, fully grouted, or partially grouted",null,null,null,null,"None"]
["- if partial, select grout schedule below"]
[null,null,"Vertical Grout Spacing (inch on center)",null,null,"None",null,{"$f":"IF(F59=\"None\",(1/(F60/8))*100,IF(F60=\"None\",(1/(F59/8))*100,((((F59/8)-1)+(F60/8))/((F59/8)*(F60/8)))*100))","v":{"$error":"#VALUE!"}}]
[null,null,"Horizontal Grout Spacing (inch on center)",null,null,"None"]
[]
["Grouting - enter percent of wall ungrouted",null,null,null,null,{"$f":"100-F63","v":100},"%"]
[" - fraction grouted",null,null,null,null,{"$f":"IF(F57=\"None\",0,IF(F57=\"Fully Grouted\",100,ROUND(H59,1)))","v":0},"%"]
[]
["Step 10: Heat Capacity"]
["If known, enter Heat Capacity",null,null,null,null,null,"Btu/ft2-°F"]
["For more information on heat capacity, see NCMA TEK Note 6-16A"]

{"sheet":"Output","index":3,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,5],[39,0,39,5]]}
[]
[]
[]
[]
[]
[]
["NCMA R-Value/U-Factor Calculator Output"]
[]
["Assembly Description"]
[{"$f":"'Hidden Outputs'!M4","v":"CMU Description:"},{"$f":"'Hidden Outputs'!N4","v":"No Description Input"}]
[{"$f":"'Hidden Outputs'!M5","v":"CMU Dimensions:"},{"$f":"'Hidden Outputs'!N5","v":"---"},"inch"]
[{"$f":"'Hidden Outputs'!M6","v":"CMU Density:"},{"$f":"'Hidden Outputs'!N6","v":"---"},"lb/ft3"]
[{"$f":"'Hidden Outputs'!M7","v":"Concrete Resistivity:"},{"$f":"'Hidden Outputs'!N7","v":"---"}]
[{"$f":"'Hidden Outputs'!M8","v":""},{"$f":"'Hidden Outputs'!N8","v":""}]
[{"$f":"'Hidden Outputs'!M9","v":"Grouting:"},{"$f":"'Hidden Outputs'!N9","v":"---"},{"$f":"'Hidden Outputs'!O9","v":""}]
[{"$f":"'Hidden Outputs'!M10","v":"Ungrouted Cores:"},{"$f":"'Hidden Outputs'!N10","v":"---"},{"$f":"'Hidden Outputs'!O10","v":""}]
[{"$f":"'Hidden Outputs'!M11","v":"Total Web Area:"},{"$f":"'Hidden Outputs'!N11","v":"---"},"in.2/ft2"]
[]
[{"$f":"'Hidden Outputs'!M13","v":"Surface Finish"}]
[{"$f":"'Hidden Outputs'!M14","v":"   - Exterior:"},{"$f":"'Hidden Outputs'!N14","v":"---"}]
[{"$f":"'Hidden Outputs'!M15","v":"   - Interior:"},{"$f":"'Hidden Outputs'!N15","v":"---"}]
[]
[{"$f":"'Hidden Outputs'!M17","v":"Assembly Details"}]
[{"$f":"'Hidden Outputs'!M18","v":"Inside Air Film:"},{"$f":"'Hidden Outputs'!N18","v":"---"}]
[{"$f":"'Hidden Outputs'!M19","v":"Outside Air Film:"},{"$f":"'Hidden Outputs'!N19","v":"---"}]
[{"$f":"'Hidden Outputs'!M20","v":"R value - CMU:"},{"$f":"'Hidden Outputs'!N20","v":"---"}]
[{"$f":"'Hidden Outputs'!M21","v":"R value - Outside Finish:"},{"$f":"'Hidden Outputs'!N21","v":"---"}]
[{"$f":"'Hidden Outputs'!M22","v":"R-Value - Inside Finish:"},{"$f":"'Hidden Outputs'!N22","v":"---"}]
[]
[{"$f":"'Hidden Outputs'!M24","v":"Assembly R-Value:"},{"$f":"'Hidden Outputs'!N24","v":"---"}]
[{"$f":"'Hidden Outputs'!M25","v":"Assembly U-Factor:"},{"$f":"'Hidden Outputs'!N25","v":"---"}]
[{"$f":"'Hidden Outputs'!M26","v":"Assembly Heat Capacity:"},{"$f":"'Hidden Outputs'!N26","v":"---"}]

{"sheet":"CMU Calculations (3 Layer)","index":4,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Calculations Page for CMU (3 Layer)"]
[null,null,null,null,null,null,null,null,null,null,null,"Thermals",null,null,null,"Output"]
["Nominal Dimensions",null,null,"Specified Dimensions",null,null,"Face Shell 1 Thickness",null,null,{"$f":"'Input (3 Layer)'!C18","v":0},null,"r concrete",{"$f":"'Input (3 Layer)'!H31","v":1.6666666666666667}]
["Width",{"$f":"'Input (3 Layer)'!C13","v":0},"in.","Width",{"$f":"B4-0.375","v":-0.375},null,"Face Shell 2 Thickness",null,null,{"$f":"'Input (3 Layer)'!C19","v":0},null,"r mortar",0.1,null,null,"R CMU ungrouted",null,{"$f":"J12+J20+J28+0.68+0.17","v":{"$error":"#DIV/0!"}},"U ungrout",{"$f":"1/R4","v":{"$error":"#DIV/0!"}}]
["Height",{"$f":"'Input (3 Layer)'!C14","v":0},"in.","Height",{"$f":"B5-0.375","v":-0.375},null,null,null,null,null,null,"r grout",0.1,null,null,"R CMU Grouted",null,{"$f":"J12+J22+J28+0.68+0.17","v":{"$error":"#DIV/0!"}},"U Grout",{"$f":"1/R5","v":{"$error":"#DIV/0!"}}]
["Length",{"$f":"'Input (3 Layer)'!C15","v":0},"in.","Length",{"$f":"B6-0.375","v":-0.375},null,"Total Web Area",null,null,{"$f":"'Input (3 Layer)'!I26","v":0},null,"r air",{"$f":"0.97/G20","v":-2.5866666666666664}]
[null,null,null,null,null,null,null,null,null,null,null,"r insulation",{"$f":"'Input (3 Layer)'!F37","v":0},null,null,"Total CMU R-Value",null,{"$f":"(1/T7)-0.68-0.17","v":{"$error":"#DIV/0!"}},"u tot",{"$f":"(('Input (3 Layer)'!F46/100)*'CMU Calculations (3 Layer)'!T4)+(('Input (3 Layer)'!F47/100)*'CMU Calculations (3 Layer)'!T5)","v":{"$error":"#DIV/0!"}}]
["Plan Area",{"$f":"B6*B5","v":0},"in2",null,null,null,null,null,null,null,null,"r core",{"$f":"IF('Input (3 Layer)'!F36=\"insulation\",'CMU Calculations (3 Layer)'!M7,'CMU Calculations (3 Layer)'!M6)","v":-2.5866666666666664},null,null,"NO films"]
[]
[]
["Layer 1"]
["Area of CMU",null,{"$f":"E6*E5","v":0.140625},null,"Layer Thickness",null,{"$f":"J3","v":0},null,"R Layer 1",{"$f":"(G13*G14)/((G13*C15)+(G14*C14))","v":{"$error":"#DIV/0!"}}]
["Area of Mortar",null,{"$f":"B8-C12","v":-0.140625},null,"r face shell",null,{"$f":"G12*M3","v":0}]
["Percent CMU",null,{"$f":"C12/B8","v":{"$error":"#DIV/0!"}},null,"r mortar",null,{"$f":"G12*M4","v":0}]
["Percent Mortar",null,{"$f":"C13/B8","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Layer 2"]
["Area of CMU",null,{"$f":"J6","v":0},null,"Layer Thickness",null,{"$f":"E4-J3-J4","v":-0.375},null,"R Layer 2 ",{"$f":"(G21*G22)/((G21*C23)+(G22*C22))","v":{"$error":"#DIV/0!"}},"ungrouted"]
["Area of Core",null,{"$f":"B8-C20","v":0},null,"r webs",null,{"$f":"G20*M3","v":-0.625}]
["Percent CMU",null,{"$f":"C20/B8","v":{"$error":"#DIV/0!"}},null,"r core",null,{"$f":"G20*M8","v":0.97},null,"R Layer 2",{"$f":"(G24*G25)/((G24*C23)+(G25*C22))","v":{"$error":"#DIV/0!"}},"grouted"]
["Percent Core",null,{"$f":"C21/B8","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"r webs",null,{"$f":"G20*M3","v":-0.625}]
[null,null,null,null,"r grout",null,{"$f":"G20*M5","v":-3.7500000000000006E-2}]
[]
["Layer 3"]
["Area of CMU",null,{"$f":"E6*E5","v":0.140625},null,"Layer Thickness",null,{"$f":"J4","v":0},null,"R Layer 3",{"$f":"(G29*G30)/((G29*C31)+(G30*C30))","v":{"$error":"#DIV/0!"}}]
["Area of Mortar",null,{"$f":"B8-C28","v":-0.140625},null,"r face shell",null,{"$f":"G28*M3","v":0}]
["Percent CMU",null,{"$f":"C28/B8","v":{"$error":"#DIV/0!"}},null,"r mortar",null,{"$f":"G28*M4","v":0}]
["Percent Mortar",null,{"$f":"C29/B8","v":{"$error":"#DIV/0!"}}]

{"sheet":"CMU Calculations (4 layer)","index":5,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Calculations Page for CMU (3 Layer)"]
[null,null,null,null,null,null,null,null,null,null,null,"Thermals",null,null,null,"Output"]
["Nominal Dimensions",null,null,"Specified Dimensions",null,null,"Face Shell 1 Thickness",null,null,{"$f":"'Input (4 layer)'!C18","v":0},null,"r concrete",{"$f":"'Input (4 layer)'!H47","v":1.6666666666666667}]
["Width",{"$f":"'Input (4 layer)'!C13","v":0},"in.","Width",{"$f":"B4-0.375","v":-0.375},null,"Face Shell 2 Thickness",null,null,{"$f":"'Input (4 layer)'!C19","v":0},null,"r mortar",0.1,null,null,"R CMU ungrouted",null,{"$f":"J12+J20+J27+J34+0.68+0.17","v":{"$error":"#DIV/0!"}},"U ungrout",{"$f":"1/R4","v":{"$error":"#DIV/0!"}}]
["Height",{"$f":"'Input (4 layer)'!C14","v":0},"in.","Height",{"$f":"B5-0.375","v":-0.375},null,null,null,null,null,null,"r grout",0.1,null,null,"R CMU Grouted",null,{"$f":"J12+J20+J29+J34+0.68+0.17","v":{"$error":"#DIV/0!"}},"U Grout",{"$f":"1/R5","v":{"$error":"#DIV/0!"}}]
["Length",{"$f":"'Input (4 layer)'!C15","v":0},"in.","Length",{"$f":"B6-0.375","v":-0.375},null,"Total Web Area Layer 2",null,null,{"$f":"'Input (4 layer)'!I26","v":0},null,"r air",{"$f":"0.97/G27","v":-2.5866666666666664}]
[null,null,null,null,null,null,"Total Web Area Layer 3",null,null,{"$f":"'Input (4 layer)'!I41","v":0},null,"r cell insulation",{"$f":"'Input (4 layer)'!F53","v":0},null,null,"Total CMU R-Value",null,{"$f":"(1/T7)-0.68-0.17","v":{"$error":"#DIV/0!"}},"u tot",{"$f":"(('Input (4 layer)'!F62/100)*T4)+(('Input (4 layer)'!F63/100)*T5)","v":{"$error":"#DIV/0!"}}]
["Plan Area",{"$f":"B6*B5","v":0},"in2",null,null,null,null,null,null,null,null,"r core",{"$f":"IF('Input (4 layer)'!F52=\"insulation\",'CMU Calculations (4 layer)'!M7,'CMU Calculations (4 layer)'!M6)","v":-2.5866666666666664},null,null,"NO films"]
[null,null,null,null,null,null,"Insulation Insert thickness",null,null,{"$f":"'Input (4 layer)'!C32","v":0},null,"r insert",{"$f":"'Input (4 layer)'!C33","v":0}]
[]
["Layer 1"]
["Area of CMU",null,{"$f":"E6*E5","v":0.140625},null,"Layer Thickness",null,{"$f":"J3","v":0},null,"R Layer 1",{"$f":"(G13*G14)/((G13*C15)+(G14*C14))","v":{"$error":"#DIV/0!"}}]
["Area of Mortar",null,{"$f":"B8-C12","v":-0.140625},null,"r face shell",null,{"$f":"G12*M3","v":0}]
["Percent CMU",null,{"$f":"C12/B8","v":{"$error":"#DIV/0!"}},null,"r mortar",null,{"$f":"G12*M4","v":0}]
["Percent Mortar",null,{"$f":"C13/B8","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Layer 2"]
["Area of CMU",null,{"$f":"J6","v":0},null,"Layer Thickness",null,{"$f":"J9","v":0},null,"R Layer 2 ",{"$f":"(G21*G22)/((G21*C23)+(G22*C22))","v":{"$error":"#DIV/0!"}}]
["Area of Insert",null,{"$f":"B8-C20","v":0},null,"r webs",null,{"$f":"G20*M3","v":0}]
["Percent CMU",null,{"$f":"C20/B8","v":{"$error":"#DIV/0!"}},null,"r insert",null,{"$f":"G20*M9","v":0}]
["Percent Insert",null,{"$f":"C21/B8","v":{"$error":"#DIV/0!"}}]
[]
[]
["Layer 2"]
["Area of CMU",null,{"$f":"J7","v":0},null,"Layer Thickness",null,{"$f":"E4-G12-G20-G34","v":-0.375},null,"R Layer 2 ",{"$f":"(G28*G29)/((G28*C30)+(G29*C29))","v":{"$error":"#DIV/0!"}},"ungrouted"]
["Area of core",null,{"$f":"B8-C27","v":0},null,"r webs",null,{"$f":"G27*M3","v":-0.625}]
["Percent CMU",null,{"$f":"C27/B8","v":{"$error":"#DIV/0!"}},null,"r cores",null,{"$f":"G27*M8","v":0.97},null,"R Layer 2",{"$f":"(G31*G32)/((G31*C30)+(G32*C29))","v":{"$error":"#DIV/0!"}},"grouted"]
["Percent Insert",null,{"$f":"C28/B8","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"r webs",null,{"$f":"G27*M3","v":-0.625}]
[null,null,null,null,"r grout",null,{"$f":"G27*M5","v":-3.7500000000000006E-2}]
["Layer 4"]
["Area of CMU",null,{"$f":"E6*E5","v":0.140625},null,"Layer Thickness",null,{"$f":"J4","v":0},null,"R Layer 4",{"$f":"(G35*G36)/((G35*C37)+(G36*C36))","v":{"$error":"#DIV/0!"}}]
["Area of Mortar",null,{"$f":"B8-C34","v":-0.140625},null,"r face shell",null,{"$f":"G34*M3","v":0}]
["Percent CMU",null,{"$f":"C34/B8","v":{"$error":"#DIV/0!"}},null,"r mortar",null,{"$f":"G34*M4","v":0}]
["Percent Mortar",null,{"$f":"C35/B8","v":{"$error":"#DIV/0!"}}]

{"sheet":"Hidden Outputs","index":6,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
["3 Layer Output",null,null,null,null,"4 Layer Output",null,null,null,null,null,null,"Output to display",{"$f":"IF(B4=\"\", IF(G4=\"\",1,4),3)","v":1}]
[]
["CMU Description",{"$f":"IF('Input (3 Layer)'!C10=\"\",\"\",'Input (3 Layer)'!C10)","v":""},null,null,null,"CMU Description",{"$f":"IF('Input (4 layer)'!C10=\"\",\"\",'Input (4 layer)'!C10)","v":""},null,null,null,null,null,"CMU Description:",{"$f":"IF($N$2=1,\"No Description Input\",IF($N$2=4,G4,B4))","v":"No Description Input"}]
["CMU Dimensions",{"$f":"'Input (3 Layer)'!C13&\" x \"&'Input (3 Layer)'!C14&\" x \"&'Input (3 Layer)'!C15","v":" x  x "},"inch",null,null,"CMU Dimensions",{"$f":"'Input (4 layer)'!C13&\" x \"&'Input (4 layer)'!C14&\" x \"&'Input (4 layer)'!C15","v":" x  x "},"inch",null,null,null,null,"CMU Dimensions:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G5,B5))","v":"---"}]
["CMU Density",{"$f":"'Input (3 Layer)'!C31","v":0},"lb/ft2",null,null,"CMU Density",{"$f":"'Input (4 layer)'!C47","v":0},"lb/ft2",null,null,null,null,"CMU Density:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G6,B6))","v":"---"}]
["Concrete Resistivity",{"$f":"'Input (3 Layer)'!H31","v":1.6666666666666667},null,null,null,"Concrete Resistivity",{"$f":"'Input (4 layer)'!H47","v":1.6666666666666667},null,null,null,null,null,"Concrete Resistivity:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G7,B7))","v":"---"}]
[null,null,null,null,null,"Insulation Insert:",{"$f":"'Input (4 layer)'!C32&\" inch thick \"&'Input (4 layer)'!C31","v":" inch thick "},null,null,null,null,null,{"$f":"IF(N2=4,F8,\"\")","v":""},{"$f":"IF($N$2=4,G8,\"\")","v":""}]
["Grouting",{"$f":"IF('Input (3 Layer)'!F47=0,\"Ungrouted\", IF('Input (3 Layer)'!F47=100, \"Solidly Grouted\", \"Partially Grouted\"))","v":"Ungrouted"},{"$f":"IF(B9=\"Partially Grouted\",\"Percent Grouted = \"&'Input (3 Layer)'!F47&\"%\",\"\")","v":""},null,null,"Grouting",{"$f":"IF('Input (4 layer)'!F62=100,\"Ungrouted\", IF('Input (4 layer)'!F62=0, \"Solidly Grouted\", \"Partially Grouted\"))","v":"Ungrouted"},{"$f":"IF(G9=\"Partially Grouted\",\"Percent Grouted = \"&'Input (4 layer)'!F63&\"%\",\"\")","v":""},null,null,null,null,"Grouting:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G9,B9))","v":"---"},{"$f":"IF(N2=4,H9,C9)","v":""}]
["Ungrouted Cores",{"$f":"IF('Input (3 Layer)'!F36=\"Air\", \"Unfilled\", \"Insulated\")","v":"Unfilled"},{"$f":"IF(B10=\"Unfilled\",\"\",\"Insulation R-Value per inch = \"&'Input (3 Layer)'!F37)","v":""},null,null,"Ungrouted Cores",{"$f":"IF('Input (4 layer)'!F52=\"Air\", \"Unfilled\", \"Insulated\")","v":"Unfilled"},{"$f":"IF(G10=\"Unfilled\",\"\",\"Insulation R-Value per inch = \"&'Input (4 layer)'!F53)","v":""},null,null,null,null,"Ungrouted Cores:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G10,B10))","v":"---"},{"$f":"IF(N2=4,H10,C10)","v":""}]
["Total Web Area:",{"$f":"'Input (3 Layer)'!I26","v":0},"in.2",null,null,"Maximum Web Area:",{"$f":"MAX('Input (4 layer)'!I26,'Input (4 layer)'!I41)","v":0},"in.2",null,null,null,null,{"$f":"IF(N2=4,F11,A11)","v":"Total Web Area:"},{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G11,B11))","v":"---"}]
[]
["Surface Finish",null,null,null,null,"Surface Finish",null,null,null,null,null,null,"Surface Finish",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G13,B13))","v":"---"}]
["   - Exterior",{"$f":"'Outside Finishes'!O5","v":"None"},null,null,null,"   - Exterior",{"$f":"'Outside Finishes'!S5","v":"None"},null,null,null,null,null,"   - Exterior:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G14,B14))","v":"---"}]
["   - Interior",{"$f":"'Input (3 Layer)'!M22","v":"None"},null,null,null,"   - Interior",{"$f":"'Input (4 layer)'!M22","v":"None"},null,null,null,null,null,"   - Interior:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G15,B15))","v":"---"}]
[]
["Assembly Details",null,null,null,null,"Assembly Details",null,null,null,null,null,null,"Assembly Details"]
["Inside Air Film",0.68,null,null,null,"Inside Air Film",0.68,null,null,null,null,null,"Inside Air Film:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G18,B18))","v":"---"}]
["Outside Air Film",0.17,null,null,null,"Outside Air Film",0.17,null,null,null,null,null,"Outside Air Film:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G19,B19))","v":"---"}]
["R value - CMU",{"$f":"'CMU Calculations (3 Layer)'!R7","v":{"$error":"#DIV/0!"}},null,null,null,"R value - CMU",{"$f":"'CMU Calculations (4 layer)'!R7","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"R value - CMU:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G20,B20))","v":"---"}]
["R value - Outside Finish",{"$f":"IF(B14=\"None\",\"---\",SUM('Outside Finishes'!O8:O10))","v":"---"},null,null,null,"R value - Outside Finish",{"$f":"IF(G14=\"None\",\"---\",SUM('Outside Finishes'!S8:S10))","v":"---"},null,null,null,null,null,"R value - Outside Finish:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G21,B21))","v":"---"}]
["R-Value - Inside Finish",{"$f":"IF(B15=\"None\",\"---\",VLOOKUP('Input (3 Layer)'!M22,'Inside Finishes'!F4:G39,2,FALSE))","v":"---"},null,null,null,"R-Value - Inside Finish",{"$f":"IF(G15=\"None\", \"---\",VLOOKUP('Input (4 layer)'!M22,'Inside Finishes'!F4:G39,2,FALSE))","v":"---"},null,null,null,null,null,"R-Value - Inside Finish:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G22,B22))","v":"---"}]
[]
["Assembly R-Value",{"$f":"SUM(B18:B22)","v":{"$error":"#DIV/0!"}},null,null,null,"Assembly R-Value",{"$f":"SUM(G18:G22)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Assembly R-Value:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G24,B24))","v":"---"}]
["Assembly U-Factor",{"$f":"1/B24","v":{"$error":"#DIV/0!"}},null,null,null,"Assembly U-Factor",{"$f":"1/G24","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Assembly U-Factor:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G25,B25))","v":"---"}]
["Assembly Heat Capacity",{"$f":"IF('Input (3 Layer)'!F50=\"\",\"---\",'Input (3 Layer)'!F50)","v":"---"},null,null,null,"Assembly Heat Capacity",{"$f":"IF('Input (4 layer)'!F66=\"\",\"---\",'Input (4 layer)'!F66)","v":"---"},null,null,null,null,null,"Assembly Heat Capacity:",{"$f":"IF($N$2=1,\"---\",IF($N$2=4,G26,B26))","v":"---"}]

{"sheet":"Inside Finishes","index":7,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Core fill drop down",null,null,null,"Inside Surface Finishes"]
[]
[1,"Air",null,null,"Assembly ID","Finish","R-value"]
[2,"Insulation",null,null,null,"None",0]
[null,null,null,null,2,"Furring Strips and 1/2 inch Gypsum Wallboard",1.1000000000000001]
[null,null,null,null,3,"1 Inch Spray Polyurethan Foam on CMU, Metal Furring with 1 inch SPF between furring, 1/2 inch Gypsum Wallboard",10.7]
[null,null,null,null,3,"1 Inch Spray Polyurethan Foam on CMU, Metal Furring with 2 inch SPF between furring, 1/2 inch Gypsum Wallboard",11.9]
[null,null,null,null,3,"1 Inch Spray Polyurethan Foam on CMU, Metal Furring with 3 inch SPF between furring, 1/2 inch Gypsum Wallboard",12.5]
[null,null,null,null,3,"1 Inch Spray Polyurethan Foam on CMU, Metal Furring with 3.5 inch SPF between furring, 1/2 inch Gypsum Wallboard",12.7]
[null,null,null,null,4,"3/4 inch Continuous Extruded Polystyrene (XPS) Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",4.8499999999999996]
[null,null,null,null,4,"1 inch Continuous Extruded Polystyrene (XPS) Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",6.1]
[null,null,null,null,4,"1.5 inch Continuous Extruded Polystyrene (XPS) Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",8.6]
[null,null,null,null,4,"2 inch Continuous Extruded Polystyrene (XPS) Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",11.1]
[null,null,null,null,4,"2.5 inch Continuous Extruded Polystyrene (XPS) Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",13.6]
[null,null,null,null,4,"3 inch Continuous Extruded Polystyrene (XPS) Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",16.100000000000001]
[null,null,null,null,4,"3/4 inch Continuous Polyisocyanurate Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",6.3]
[null,null,null,null,4,"1 inch Continuous Polyisocyanurate Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",7.37]
[null,null,null,null,4,"1.5 inch Continuous Polyisocyanurate Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",11.6]
[null,null,null,null,4,"2 inch Continuous Polyisocyanurate Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",15.5]
[null,null,null,null,4,"2.5 inch Continuous Polyisocyanurate Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",18.899999999999999]
[null,null,null,null,4,"3 inch Continuous Polyisocyanurate Insulation, Metal Furring and 1/2 inch Gypsum Wallboard",22.3]
[null,null,null,null,5,"2 inch Continuous Heavy Duty Polyisocyanurate",14.4]
[null,null,null,null,5,"2.5 inch Continuous Heavy Duty Polyisocyanurate",17.8]
[null,null,null,null,5,"3 inch Continuous Heavy Duty Polyisocyanurate",21.2]
[null,null,null,null,5,"3.5 inch Continuous Heavy Duty Polyisocyanurate",24.6]
[null,null,null,null,6,"Metal Furring with R11 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",7.05]
[null,null,null,null,6,"Metal Furring with R13 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",7.65]
[null,null,null,null,6,"Metal Furring with R15 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",8.25]
[null,null,null,null,6,"Metal Furring with R19 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",9.0500000000000007]
[null,null,null,null,6,"Metal Furring with R21 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",9.4499999999999993]
[null,null,null,null,7,"Wood Furring with 3/4 inch Extruded Polystyrene between furring and 1/2 inch Gypsum Wallboard",4.45]
[null,null,null,null,7,"Wood Furring with 3/4 inch Polyisocyanurate between furring and 1/2 inch Gypsum Wallboard",5.65]
[null,null,null,null,7,"Wood Furring with 1.5 inch Extruded Polystyrene between furring and 1/2 inch Gypsum Wallboard",8.0500000000000007]
[null,null,null,null,7,"Wood Furring with 1.5 inch Polyisocyanurate between furring and 1/2 inch Gypsum Wallboard",10.85]
[null,null,null,null,7,"Wood Furring with R11 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",11.05]
[null,null,null,null,7,"Wood Furring with R13 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",12.05]
[null,null,null,null,7,"Wood Furring with R15 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",12.95]
[null,null,null,null,7,"Wood Furring with R19 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",15.85]
[null,null,null,null,7,"Wood Furring with R21 Batt Insulation between strips and 1/2 inch Gypsum Wallboard",17.149999999999999]

{"sheet":"Outside Finishes","index":8,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Outside Finishes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"3 layer",null,null,null,"4 layer"]
["Outside Surface Finishes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Finish Description",null,{"$f":"IF(N8=\"Cavity Wall\", \"Cavity Wall, \"&N9&\" Veneer, \"&N10&\" Insulation\",N8)","v":"None"},null,"Finish Description",null,{"$f":"IF(R8=\"Cavity Wall\", \"Cavity Wall, \"&R9&\" Veneer, \"&R10&\" Insulation\",R8)","v":"None"}]
["Assembly ID",null,"Finish","R-value",null,"Veneer Type","R-value",null,"Cavity wall insulation","R-Value"]
[null,null,"None",0,null,null,0,null,null,0,null,null,"R-value",null,null,null,"R-value"]
[null,null,"Cavity Wall",0.97,null,"None",0,null,"None",0,null,null,"Type",{"$f":"'Input (3 Layer)'!M24","v":"None"},{"$f":"VLOOKUP('Input (3 Layer)'!M24,C7:D16,2,FALSE)","v":0},null,"Type",{"$f":"'Input (4 layer)'!M24","v":"None"},{"$f":"VLOOKUP('Input (4 layer)'!M24,C7:D16,2,FALSE)","v":0}]
[null,null,"EIFS 1 inch polyiso",6.9,null,"4\" Hollow CMU",0.94,null,"XPS 1 inch",5,null,null,"Veneer",{"$f":"IF(N8=\"Cavity Wall\",'Input (3 Layer)'!M25,\"None\")","v":"None"},{"$f":"VLOOKUP(N9,F8:G11,2,FALSE)","v":0},null,"Veneer",{"$f":"IF(R8=\"Cavity Wall\",'Input (4 layer)'!M25,\"None\")","v":"None"},{"$f":"VLOOKUP(R9,F8:G11,2,FALSE)","v":0}]
[null,null,"EIFS 1.5 inch EPS",6.2,null,"4\" Solid CMU",0.41,null,"XPS 1.5 inch",7.5,null,null,"Insulation",{"$f":"IF(N8=\"Cavity Wall\",'Input (3 Layer)'!M26,\"None\")","v":"None"},{"$f":"VLOOKUP(N10,I8:J26,2,FALSE)","v":0},null,"Insulation",{"$f":"IF(R8=\"Cavity Wall\",'Input (4 layer)'!M26,\"None\")","v":"None"},{"$f":"VLOOKUP(R10,I8:J26,2,FALSE)","v":0}]
[null,null,"EIFS 2 inch EPS",8.1999999999999993,null,"Clay Brick",0.44,null,"XPS 2 inch",10]
[null,null,"EIFS 2 inch XPS",5.2,null,null,null,null,"XPS 2.5 inch",12.5]
[null,null,"EIFS 2 inch polyiso",14.6,null,null,null,null,"XPS 3 inch",15]
[null,null,"EIFS 2.5 inch XPS",12.7,null,null,null,null,"XPS 3.5 inch",17.5]
[null,null,"EIFS 3 inch EPS",12.2,null,null,null,null,"SPF 1 inch",6.8]
[null,null,"EIFS 3 inch polyiso",21.4,null,null,null,null,"SPF 1.5 inch",10.1]
[null,null,null,null,null,null,null,null,"SPF 2 inch",13.3]
[null,null,null,null,null,null,null,null,"SPF 2.5 inch",16.149999999999999]
[null,null,null,null,null,null,null,null,"SPF 3 inch",19]
[null,null,null,null,null,null,null,null,"SPF 3.5 inch",22]
[null,null,null,null,null,null,null,null,"Polyiso 1 inch",6.7]
[null,null,null,null,null,null,null,null,"Polyiso 1.5 inch",10.5]
[null,null,null,null,null,null,null,null,"Polyiso 2 inch",14.4]
[null,null,null,null,null,null,null,null,"Polyiso 2.5 inch",17.8]
[null,null,null,null,null,null,null,null,"Polyiso 3 inch",21.2]
[null,null,null,null,null,null,null,null,"Polyiso 3.5 inch",24.6]

{"sheet":"Grouting","index":9,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Grouting"]
[]
["Spacing",null,"None"]
["None",null,16]
["Fully Grouted",null,24]
["Partial Grouted",null,32]
[null,null,40]
[null,null,48]
[null,null,56]
[null,null,64]
[null,null,72]
[null,null,80]
[null,null,88]
[null,null,96]
[null,null,104]
[null,null,112]
[null,null,120]