{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Unit Configuration","Section Properties Calculator","Calculations","Wall Weight Calculator","STC_OITC Calculator","STC_OITC Lookup Table"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":17,"comments":2,"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","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Unit Configuration","index":1,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[47,0,47,3],[30,5,30,6],[31,5,31,6],[32,5,32,6],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5]]}
[]
[]
[]
[]
[]
[]
["NCMA Section Properties of Concrete Masonry Walls"]
["User Input Page"]
[]
["Step 1: Project/Unit Details"]
["Date"]
["Project Name"]
["Project Number"]
["Unit Description"]
[]
[]
[]
["Step 2a: Select Pre-defined Unit Configuration or;",null,null,null,null,null,null,null,null,null,"Figure 1 - Web Location Example"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 2b: Enter Unit Configuration"]
["Mortar Thickness (in.)",null,null,0.375,null,"Specified Dimensions (in.)"]
["Nominal Unit Width (in.)",null,null,8,null,{"$f":"D31-$D$30","v":7.625}]
["Nominal Unit Height (in.)",null,null,8,null,{"$f":"D32-$D$30","v":7.625}]
["Nominal Unit Length (in.)",null,null,16,null,{"$f":"D33-$D$30","v":15.625}]
[]
["Step 3: Enter Face Shell Details"]
["Are face shells different in thickness?",null,null,"No"]
[{"$f":"IF(D36=\"Yes\", \"First Face shell Thickness (in.)\", \"Face shell thickness (in.)\")","v":"Face shell thickness (in.)"},null,null,1.25]
[{"$f":"IF(D36=\"Yes\",\"Second Faceshell Thickness (in.)\", \"\")","v":""}]
[]
["Step 4: Enter Web Details"]
["Number of Webs",null,null,3]
["Are the webs different in thickness?",null,null,"No"]
[{"$f":"IF(COUNTBLANK(A42),\"\",IF(AND($D$42=\"Yes\",$D$41>=1),\"X1 Thickness (in.)\",\"Minimum Web Thickness (in.)\"))","v":"Minimum Web Thickness (in.)"},null,null,1,null,null,null,null,null,null,"Are all webs full height?",null,null,"Yes"]
[{"$f":"IF(AND(D42=\"Yes\",$D$41>=2),\"X2 Thickness (in.)\",\"\")","v":""},null,null,null,null,{"$f":"IF($D$41>=1,\"Web Location X1 (in.)\",\"\")","v":"Web Location X1 (in.)"},null,null,0,null,{"$f":"IF(AND($N$43=\"No\",$D$41>=1),\"X1 Height (in.)\",\"\")","v":""}]
[{"$f":"IF(AND(D42=\"Yes\",$D$41>=3),\"X3 Thickness (in.)\",\"\")","v":""},null,null,null,null,{"$f":"IF($D$41>=2,\"Web Location X2 (in.)\",\"\")","v":"Web Location X2 (in.)"},null,null,7.3125,null,{"$f":"IF(AND($N$43=\"No\",$D$41>=2),\"X2 Height (in.)\",\"\")","v":""}]
[{"$f":"IF(AND(D42=\"Yes\",$D$41>=4),\"X4 Thickness (in.)\",\"\")","v":""},null,null,null,null,{"$f":"IF($D$41>=3,\"Web Location X3 (in.)\",\"\")","v":"Web Location X3 (in.)"},null,null,14.625,null,{"$f":"IF(AND($N$43=\"No\",$D$41>=3),\"X3 Height (in.)\",\"\")","v":""}]
[{"$f":"IF(AND(D42=\"Yes\",$D$41>=5),\"X5 Thickness (in.)\",\"\")","v":""},null,null,null,null,{"$f":"IF($D$41>=4,\"Web Location X4 (in.)\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND($N$43=\"No\",$D$41>=4),\"X4 Height (in.)\",\"\")","v":""}]
[{"$f":"IF(Calculations!L5>Calculations!B5,\"The sum of web thicknesses is greater than the length of the unit. \nEnter valid web thicknesses.\",\"\")","v":""},null,null,null,{"$f":"IF($D$42=\"No\",$D$43,D47)","v":1},{"$f":"IF($D$41>=5,\"Web Location X5 (in.)\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND($N$43=\"No\",$D$41>=5),\"X5 Height (in.)\",\"\")","v":""}]
["Step 5: Enter Mortar and Block Details"]
["Mortar Bedding"]
["Block Configuration",null,null,"Hollow"]
[]
["Step 6: Unit Normalized Web Area and Volume "]
["Calculated Normalized Web Area (in2/ft2)",null,null,{"$f":"Calculations!E14","v":25.734375}]
["Calculated Unit Volume (ft3/unit)",null,null,{"$f":"Calculations!D123/((12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)))","v":0.24021176938657407}]
["Calculated Equivalent Thickness (in.)",null,null,{"$f":"Calculations!D124/((12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)))*1728/('Wall Weight Calculator'!C9*'Wall Weight Calculator'!C8)","v":3.484}]

{"sheet":"Section Properties Calculator","index":2,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,1,35,9],[8,7,8,8],[7,7,7,8],[6,7,6,8],[6,0,6,1],[11,0,11,2],[9,0,9,1],[10,0,10,1],[9,7,12,10],[11,3,11,4],[14,1,16,1],[14,2,16,2],[14,3,15,5],[14,6,15,9],[12,0,12,1],[5,0,5,2],[7,0,7,1],[8,0,8,1],[12,3,12,4],[7,9,7,10],[8,9,8,10],[5,7,5,10],[6,9,6,10],[0,8,0,10],[0,6,0,7],[1,6,1,7],[2,6,2,7],[3,6,3,7],[1,8,1,10],[2,8,2,10],[3,8,3,10]]}
[null,null,null,null,null,null,"Date:",null,{"$f":"'Unit Configuration'!C11","v":"00:00:00"}]
[null,null,null,null,null,null,"Project Name:",null,{"$f":"'Unit Configuration'!C12","v":0}]
[null,null,null,null,null,null,"Project Number:",null,{"$f":"'Unit Configuration'!C13","v":0}]
[null,null,null,null,null,null,"Unit Description:",null,{"$f":"'Unit Configuration'!C14","v":0}]
[]
["General Unit Info",null,null,"Webs","Location","Height","Thickness","ASTM C90 Web and Face shell Requirements"]
["Specified Unit Width (in.)",null,{"$f":"'Unit Configuration'!F31","v":7.625},{"$f":"IF('Unit Configuration'!F44=\"\",\"\",\"X1 (in.)\")","v":"X1 (in.)"},{"$f":"IF(D7=\"\",\"\",'Unit Configuration'!I44)","v":0},{"$f":"IF(D7=\"\",\"\",Calculations!H3)","v":7.625},{"$f":"IF(D7=\"\",\"\",Calculations!F3)","v":1},"Normalized Web Area?",null,{"$f":"IF(G12>=6.5,\"Complies with ASTM C90\",\"Does not comply\")","v":"Complies with ASTM C90"}]
["Specified Unit Height (in.)",null,{"$f":"'Unit Configuration'!F32","v":7.625},{"$f":"IF('Unit Configuration'!F45=\"\",\"\",\"X2 (in.)\")","v":"X2 (in.)"},{"$f":"IF(D8=\"\",\"\",'Unit Configuration'!I45)","v":7.3125},{"$f":"IF(D8=\"\",\"\",Calculations!H4)","v":7.625},{"$f":"IF(D8=\"\",\"\",Calculations!F4)","v":1},"Faceshell Thicknesses?",null,{"$f":"IF(AND(Calculations!G13,Calculations!G14),\"Complies with ASTM C90\",\"Does not comply\")","v":"Complies with ASTM C90"}]
["Specified Unit Length (in.)",null,{"$f":"'Unit Configuration'!F33","v":15.625},{"$f":"IF('Unit Configuration'!F46=\"\",\"\",\"X3 (in.)\")","v":"X3 (in.)"},{"$f":"IF(D9=\"\",\"\",'Unit Configuration'!I46)","v":14.625},{"$f":"IF(D9=\"\",\"\",Calculations!H5)","v":7.625},{"$f":"IF(D9=\"\",\"\",Calculations!F5)","v":1},"Web Thicknesses?",null,{"$f":"IF(MIN(G7:G11)>=0.75,\"Complies with ASTM C90\",\"Does not comply\")","v":"Complies with ASTM C90"}]
[{"$f":"IF('Unit Configuration'!D36=\"NO\",\"Faceshell thicknesses (in.)\",\"First faceshell thickness (in.)\")","v":"Faceshell thicknesses (in.)"},null,{"$f":"'Unit Configuration'!D37","v":1.25},{"$f":"IF('Unit Configuration'!F47=\"\",\"\",\"X4 (in.)\")","v":""},{"$f":"IF(D10=\"\",\"\",'Unit Configuration'!I47)","v":""},{"$f":"IF(D10=\"\",\"\",Calculations!H6)","v":""},{"$f":"IF(D10=\"\",\"\",Calculations!F6)","v":""},{"$f":"IF(AND('Unit Configuration'!N43=\"Yes\",Calculations!G50=TRUE,'Unit Configuration'!D31>=6),\"\",\"The entered configuration cannot be partially grouted or have a full mortar bed. These values have been eliminated from consideration and will show as blank spaces on the table\")","v":"The entered configuration cannot be partially grouted or have a full mortar bed. These values have been eliminated from consideration and will show as blank spaces on the table"}]
[{"$f":"IF('Unit Configuration'!D36=\"YES\",\"Second faceshell thickness (in.)\",\"\")","v":""},null,{"$f":"IF(COUNTBLANK('Section Properties Calculator'!A11),\"\",'Unit Configuration'!D38)","v":""},{"$f":"IF('Unit Configuration'!F48=\"\",\"\",\"X5 (in.)\")","v":""},{"$f":"IF(D11=\"\",\"\",'Unit Configuration'!I48)","v":""},{"$f":"IF(D11=\"\",\"\",Calculations!H7)","v":""},{"$f":"IF(D11=\"\",\"\",Calculations!F7)","v":""}]
["Mortar Info",null,null,"Normalized Web Area (in2/ft2)",null,null,{"$f":"'Unit Configuration'!D54","v":25.734375}]
["Mortar Thickness (in.)",null,{"$f":"'Unit Configuration'!D30","v":0.375},"Direction of Span",null,null,"Vertical"]
[]
[null,{"$f":"IF(G13=\"Vertical\",\"Grout Spacing (in.)\",\"Bond Beam Spacing (in.)\")","v":"Grout Spacing (in.)"},"Mortar Bedding",{"$f":"IF(G13=\"Vertical\",\"Horizontal Net Cross-Sectional Properties\",\"Vertical Net Cross-Sectional Properties\")","v":"Horizontal Net Cross-Sectional Properties"},null,null,{"$f":"IF(G13=\"Vertical\",\"Horizontal Average Cross-Sectional Properties\",\"Vertical Average Cross-Sectional Properties\")","v":"Horizontal Average Cross-Sectional Properties"}]
[]
[null,null,null,"An (in2/ft)","In (in4/ft)","Sn (in3/ft)","Aavg (in2/ft)","Iavg (in4/ft)","Savg (in3/ft)","ravg (in)"]
[null,{"$f":"IF($G$13=\"Vertical\",Calculations!B20,Calculations!B96)","v":"None"},{"$f":"IF($G$13=\"Vertical\",Calculations!C20,Calculations!C96)","v":"Face shell"},{"$f":"IF($G$13=\"Vertical\",Calculations!D20,Calculations!D96)","v":30},{"$f":"IF($G$13=\"Vertical\",Calculations!E20,Calculations!E96)","v":308.7109375},{"$f":"IF($G$13=\"Vertical\",Calculations!F20,Calculations!F96)","v":80.973360655737707},{"$f":"IF($G$13=\"Vertical\",Calculations!G20,Calculations!G96)","v":41.53125},{"$f":"IF($G$13=\"Vertical\",Calculations!H20,Calculations!H96)","v":333.9505615234375},{"$f":"IF($G$13=\"Vertical\",Calculations!I20,Calculations!I96)","v":87.593589907786878},{"$f":"IF($G$13=\"Vertical\",Calculations!J20,Calculations!J96)","v":2.8356562825665761}]
[null,{"$f":"IF($G$13=\"Vertical\",Calculations!B21,Calculations!B97)","v":"None"},{"$f":"IF($G$13=\"Vertical\",Calculations!C21,Calculations!C97)","v":"Full"},{"$f":"IF($G$13=\"Vertical\",Calculations!D21,Calculations!D97)","v":41.53125},{"$f":"IF($G$13=\"Vertical\",Calculations!E21,Calculations!E97)","v":333.9505615234375},{"$f":"IF($G$13=\"Vertical\",Calculations!F21,Calculations!F97)","v":87.593589907786878},{"$f":"IF($G$13=\"Vertical\",Calculations!G21,Calculations!G97)","v":41.53125},{"$f":"IF($G$13=\"Vertical\",Calculations!H21,Calculations!H97)","v":333.9505615234375},{"$f":"IF($G$13=\"Vertical\",Calculations!I21,Calculations!I97)","v":87.593589907786878},{"$f":"IF($G$13=\"Vertical\",Calculations!J21,Calculations!J97)","v":2.8356562825665761}]
[null,{"$f":"IF($G$13=\"Vertical\",Calculations!B22,Calculations!B98)","v":"None"},{"$f":"IF($G$13=\"Vertical\",Calculations!C22,Calculations!C98)","v":"Full"},{"$f":"IF($G$13=\"Vertical\",Calculations!D22,Calculations!D98)","v":91.5},{"$f":"IF($G$13=\"Vertical\",Calculations!E22,Calculations!E98)","v":443.322265625},{"$f":"IF($G$13=\"Vertical\",Calculations!F22,Calculations!F98)","v":116.28125},{"$f":"IF($G$13=\"Vertical\",Calculations!G22,Calculations!G98)","v":91.5},{"$f":"IF($G$13=\"Vertical\",Calculations!H22,Calculations!H98)","v":443.322265625},{"$f":"IF($G$13=\"Vertical\",Calculations!I22,Calculations!I98)","v":116.28125},{"$f":"IF($G$13=\"Vertical\",Calculations!J22,Calculations!J98)","v":2.2011479012854482}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B23,Calculations!B99),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C23,Calculations!C99),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D23,Calculations!D99),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E23,Calculations!E99),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F23,Calculations!F99),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G23,Calculations!G99),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H23,Calculations!H99),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I23,Calculations!I99),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J23,Calculations!J99),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B24,Calculations!B100),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C24,Calculations!C100),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D24,Calculations!D100),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E24,Calculations!E100),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F24,Calculations!F100),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G24,Calculations!G100),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H24,Calculations!H100),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I24,Calculations!I100),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J24,Calculations!J100),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B25,Calculations!B101),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C25,Calculations!C101),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D25,Calculations!D101),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E25,Calculations!E101),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F25,Calculations!F101),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G25,Calculations!G101),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H25,Calculations!H101),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I25,Calculations!I101),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J25,Calculations!J101),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B26,Calculations!B102),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C26,Calculations!C102),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D26,Calculations!D102),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E26,Calculations!E102),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F26,Calculations!F102),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G26,Calculations!G102),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H26,Calculations!H102),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I26,Calculations!I102),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J26,Calculations!J102),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B27,Calculations!B103),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C27,Calculations!C103),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D27,Calculations!D103),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E27,Calculations!E103),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F27,Calculations!F103),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G27,Calculations!G103),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H27,Calculations!H103),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I27,Calculations!I103),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J27,Calculations!J103),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B28,Calculations!B104),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C28,Calculations!C104),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D28,Calculations!D104),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E28,Calculations!E104),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F28,Calculations!F104),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G28,Calculations!G104),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H28,Calculations!H104),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I28,Calculations!I104),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J28,Calculations!J104),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B29,Calculations!B105),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C29,Calculations!C105),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D29,Calculations!D105),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E29,Calculations!E105),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F29,Calculations!F105),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G29,Calculations!G105),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H29,Calculations!H105),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I29,Calculations!I105),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J29,Calculations!J105),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B30,Calculations!B106),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C30,Calculations!C106),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D30,Calculations!D106),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E30,Calculations!E106),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F30,Calculations!F106),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G30,Calculations!G106),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H30,Calculations!H106),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I30,Calculations!I106),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J30,Calculations!J106),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B31,Calculations!B107),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C31,Calculations!C107),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D31,Calculations!D107),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E31,Calculations!E107),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F31,Calculations!F107),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G31,Calculations!G107),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H31,Calculations!H107),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I31,Calculations!I107),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J31,Calculations!J107),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B32,Calculations!B108),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C32,Calculations!C108),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D32,Calculations!D108),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E32,Calculations!E108),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F32,Calculations!F108),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G32,Calculations!G108),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H32,Calculations!H108),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I32,Calculations!I108),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J32,Calculations!J108),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B33,Calculations!B109),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C33,Calculations!C109),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D33,Calculations!D109),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E33,Calculations!E109),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F33,Calculations!F109),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G33,Calculations!G109),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H33,Calculations!H109),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I33,Calculations!I109),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J33,Calculations!J109),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B34,Calculations!B110),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C34,Calculations!C110),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D34,Calculations!D110),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E34,Calculations!E110),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F34,Calculations!F110),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G34,Calculations!G110),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H34,Calculations!H110),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I34,Calculations!I110),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J34,Calculations!J110),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B35,Calculations!B111),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C35,Calculations!C111),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D35,Calculations!D111),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E35,Calculations!E111),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F35,Calculations!F111),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G35,Calculations!G111),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H35,Calculations!H111),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I35,Calculations!I111),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J35,Calculations!J111),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B36,Calculations!B112),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C36,Calculations!C112),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D36,Calculations!D112),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E36,Calculations!E112),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F36,Calculations!F112),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G36,Calculations!G112),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H36,Calculations!H112),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I36,Calculations!I112),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J36,Calculations!J112),\"\")","v":""}]
[null,{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!B37,Calculations!B113),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!C37,Calculations!C113),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!D37,Calculations!D113),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!E37,Calculations!E113),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!F37,Calculations!F113),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!G37,Calculations!G113),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!H37,Calculations!H113),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!I37,Calculations!I113),\"\")","v":""},{"$f":"IF($H$10=\"\",IF($G$13=\"Vertical\",Calculations!J37,Calculations!J113),\"\")","v":""}]
[null,"**The ability to grout the unit must be conferred with manufacturer and/or contractor."]

{"sheet":"Calculations","index":3,"n_rows":149,"n_cols":15,"rows_kept":149,"cut":false,"hidden":true,"merged":[[16,0,16,9],[38,2,38,9],[48,4,48,6],[93,0,94,0],[93,1,94,1],[93,2,94,2],[93,3,93,5],[93,6,93,9],[92,0,92,9],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,17,5],[17,6,17,9],[1,0,1,11],[9,3,9,8],[10,3,10,4],[10,5,10,6],[10,7,10,8],[141,3,141,5],[119,0,119,11],[114,4,114,5],[120,0,121,0],[120,1,121,1],[120,2,121,2],[120,3,121,3],[120,4,121,4],[120,5,121,5],[120,8,120,14],[120,6,121,6],[120,7,121,7]]}
[]
["Known Information"]
["Unit Width =",{"$f":"'Unit Configuration'!F31","v":7.625},"tfs1 =",{"$f":"'Unit Configuration'!D37","v":1.25},"tweb1 =",{"$f":"'Unit Configuration'!D43","v":1},"hweb1 =",{"$f":"IF(AND('Unit Configuration'!$N$43=\"yes\",'Unit Configuration'!$D$41>=1),'Unit Configuration'!$F$32,'Unit Configuration'!N44)","v":7.625},"Aweb1",{"$f":"F3*H3","v":7.625},"Total Specified Face Shell Area",{"$f":"(D3+D4)*B5","v":39.0625}]
["Unit Height =",{"$f":"'Unit Configuration'!F32","v":7.625},"tfs2 =",{"$f":"IF('Unit Configuration'!D36=\"No\",'Unit Configuration'!D37,'Unit Configuration'!D38)","v":1.25},"tweb2 =",{"$f":"IF(AND($L$8>=2,'Unit Configuration'!$D$42=\"No\"),'Unit Configuration'!$D$43,'Unit Configuration'!$D44)","v":1},"hweb2 =",{"$f":"IF(AND('Unit Configuration'!$N$43=\"yes\",'Unit Configuration'!$D$41>=2),'Unit Configuration'!$F$32,'Unit Configuration'!N45)","v":7.625},"Aweb2",{"$f":"F4*H4","v":7.625},"Total Nominal Face Shell Area",{"$f":"(D3+D4)*B8","v":40}]
["Unit Length =",{"$f":"'Unit Configuration'!F33","v":15.625},"tmj =",{"$f":"'Unit Configuration'!D30","v":0.375},"tweb3 =",{"$f":"IF(AND($L$8>=3,'Unit Configuration'!$D$42=\"No\"),'Unit Configuration'!$D$43,'Unit Configuration'!$D45)","v":1},"hweb3 =",{"$f":"IF(AND('Unit Configuration'!$N$43=\"yes\",'Unit Configuration'!$D$41>=3),'Unit Configuration'!$F$32,'Unit Configuration'!N46)","v":7.625},"Aweb3",{"$f":"F5*H5","v":7.625},"Net Web Thickness",{"$f":"SUM(F3:F7)","v":3}]
["Unit Nominal Width =",{"$f":"'Unit Configuration'!D31","v":8},null,null,"tweb4 =",{"$f":"IF(AND($L$8>=4,'Unit Configuration'!$D$42=\"No\"),'Unit Configuration'!$D$43,'Unit Configuration'!$D46)","v":0},"hweb4 =",{"$f":"IF(AND('Unit Configuration'!$N$43=\"yes\",'Unit Configuration'!$D$41>=4),'Unit Configuration'!$F$32,'Unit Configuration'!N47)","v":0},"Aweb4",{"$f":"F6*H6","v":0},"Cell Width (in block)",{"$f":"B3-SUM(D3:D4)","v":5.125}]
["Unit Nominal Height =",{"$f":"'Unit Configuration'!D32","v":8},null,null,"tweb5 =",{"$f":"IF(AND($L$8>4,'Unit Configuration'!$D$42=\"No\"),'Unit Configuration'!$D$43,'Unit Configuration'!$D47)","v":0},"hweb5 =",{"$f":"IF(AND('Unit Configuration'!$N$43=\"yes\",'Unit Configuration'!$D$41>=5),'Unit Configuration'!$F$32,'Unit Configuration'!N48)","v":0},"Aweb5",{"$f":"F7*H7","v":0},"Total Web area",{"$f":"L6*L5","v":15.375}]
["Unit Nominal Length =",{"$f":"'Unit Configuration'!D33","v":16},null,null,null,null,null,null,null,null,"Number of Webs",{"$f":"'Unit Configuration'!D41","v":3}]
[]
[null,null,null,"Design Checks"]
[null,null,null,"Normalized Web Area Check",null,"Faceshell Check",null,"Normalizations"]
[null,null,null,"Total Web Area (in2)",{"$f":"SUM(J3:J7)","v":22.875},"FS Flag Based on Width of Unit",{"$f":"IF('Unit Configuration'!D31<=4,1,IF(AND('Unit Configuration'!D31>4,'Unit Configuration'!D31<8),2,IF('Unit Configuration'!D31>=8,3,)))","v":3},"Length Normalization",{"$f":"12/(B5+D5)","v":0.75}]
[null,null,null,"Total Web Area/Nominal FS Area ",{"$f":"E12/('Unit Configuration'!D33*'Unit Configuration'!D32)","v":0.1787109375},"FS1",{"$f":"IF(AND($G$12=1,D3>=0.75),TRUE,IF(AND($G$12=2,D3>=1),TRUE,IF(AND($G$12=3,D3>=1.25),TRUE,FALSE)))","v":true},"Height Normalization",{"$f":"12/B7","v":1.5}]
[null,null,null,"Normalized Web Area (in2/ft2)",{"$f":"E13*144","v":25.734375},"FS2",{"$f":"IF(AND($G$12=1,D4>=0.75),TRUE,IF(AND($G$12=2,D4>=1),TRUE,IF(AND($G$12=3,D4>=1.25),TRUE,FALSE)))","v":true}]
[null,null,null,"ASTM C90 Compliant?",{"$f":"IF(E14>=6.5,TRUE,FALSE)","v":true}]
[]
["Concrete Masonry Section Properties for Vertically Grouted Walls "]
["Unit Config","Grout Spacing (in.)","Mortar Bedding","Net Cross-Sectional Properties",null,null,"Average Cross-Sectional Properties"]
[null,null,null,"An (in2/ft)","In (in4/ft)","Sn (in3/ft)","Aavg (in2/ft)","Iavg (in4/ft)","Savg (in3/ft)","ravg (in)"]
["Hollow","None","Face shell",{"$f":"L4*I12","v":30},{"$f":"(((1/12)*(B5+D5)*(B3^3))-((1/12)*(B5+D5)*(L6^3)))*I12","v":308.7109375},{"$f":"(E20/($B$3/2))","v":80.973360655737707},{"$f":"SUM(L4,L7)*I12","v":41.53125},{"$f":"(((1/12)*(B5+D5)*(B3^3))-((1/12)*(B5+D5-L5)*(L6^3)))*I12","v":333.9505615234375},{"$f":"(H20/($B$3/2))","v":87.593589907786878},{"$f":"(H20/G20)^0.5","v":2.8356562825665761}]
["Hollow","None","Full",{"$f":"(L4+L7)*I12","v":41.53125},{"$f":"(((1/12)*(B5+D5)*(B3^3))-((1/12)*(B5+D5-L5)*(L6^3)))*I12","v":333.9505615234375},87.593589907786878,{"$f":"SUM(L4,L7)*I12","v":41.53125},{"$f":"(((1/12)*(B5+D5)*(B3^3))-((1/12)*(B5+D5-L5)*(L6^3)))*I12","v":333.9505615234375},87.593589907786878,{"$f":"(H21/G21)^0.5","v":2.8356562825665761}]
["Solid","None","Full",{"$f":"B8*B3*I12","v":91.5},{"$f":"(1/12)*(B5+D5)*(B3^3)*I12","v":443.322265625},116.28125,{"$f":"D22","v":91.5},{"$f":"E22","v":443.322265625},116.28125,{"$f":"(H22/G22)^0.5","v":2.2011479012854482}]
["Hollow",8,"Full",{"$f":"IF(B8/L8=8,D22,(L4+(L6*B5))*I12)","v":90.05859375},{"$f":"IF(B8/L8=8,E22,((1/12)*B5*L6^3+1/12*(B5+D5)*D3^3+(B5+D5)*D3*(B3/2-D3/2)^2+1/12*(B5+D5)*D4^3+(B5+D5)*D4*(B3/2-D4/2)^2)*I12)","v":440.16731262207037},115.45372134349387,{"$f":"D23","v":90.05859375},{"$f":"E23","v":440.16731262207037},115.45372134349387,{"$f":"(H23/G23)^0.5","v":2.2107840032367898}]
["Hollow",16,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B24,$D$21+$F$47*12/$B24)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B24),$E$21+$G$47*12/$B24)","v":333.9505615234375},87.593589907786878,{"$f":"$G$20+($I$47*12/B24)","v":65.794921875},{"$f":"$H$20+($J$47*(12/B24))","v":387.05893707275391},101.52365562564037,2.4254502001510136]
["Hollow",{"$f":"B24+8","v":24},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B25,$D$21+$F$47*12/$B25)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B25),$E$21+$G$47*12/$B25)","v":333.9505615234375},87.593589907786878,57.70703125,369.35614522298175,96.88030038635587,2.5299287959925829]
["Hollow",32,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B26,$D$21+$F$47*12/$B26)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B26),$E$21+$G$47*12/$B26)","v":333.9505615234375},87.593589907786878,53.6630859375,360.5047492980957,94.558622766713626,2.5918966090308655]
["Hollow",40,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B27,$D$21+$F$47*12/$B27)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B27),$E$21+$G$47*12/$B27)","v":333.9505615234375},87.593589907786878,51.236718750000001,355.19391174316405,93.165616194928276,2.6329469080482069]
["Hollow",48,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B28,$D$21+$F$47*12/$B28)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B28),$E$21+$G$47*12/$B28)","v":333.9505615234375},87.593589907786878,49.619140625,351.65335337320965,92.236945147071381,2.662151471955946]
["Hollow",56,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B29,$D$21+$F$47*12/$B29)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B29),$E$21+$G$47*12/$B29)","v":333.9505615234375},87.593589907786878,48.463727678571431,349.12438310895647,91.573608684316454,2.6839948787426193]
["Hollow",64,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B30,$D$21+$F$47*12/$B30)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B30),$E$21+$G$47*12/$B30)","v":333.9505615234375},87.593589907786878,47.59716796875,347.2276554107666,91.076106337250252,2.7009503286093914]
["Hollow",72,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B31,$D$21+$F$47*12/$B31)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B31),$E$21+$G$47*12/$B31)","v":333.9505615234375},87.593589907786878,46.923177083333336,345.7524227566189,90.689160067309871,2.714494156742369]
["Hollow",80,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B32,$D$21+$F$47*12/$B32)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B32),$E$21+$G$47*12/$B32)","v":333.9505615234375},87.593589907786878,46.383984374999997,344.5722366333008,90.379603051357591,2.7255623104783093]
["Hollow",88,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B33,$D$21+$F$47*12/$B33)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B33),$E$21+$G$47*12/$B33)","v":333.9505615234375},87.593589907786878,45.942826704545453,343.60662980513138,90.126329129214781,2.7347769528581409]
["Hollow",96,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B34,$D$21+$F$47*12/$B34)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B34),$E$21+$G$47*12/$B34)","v":333.9505615234375},87.593589907786878,45.5751953125,342.80195744832355,89.915267527429123,2.7425678289999547]
["Hollow",104,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B35,$D$21+$F$47*12/$B35)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B35),$E$21+$G$47*12/$B35)","v":333.9505615234375},87.593589907786878,45.264122596153847,342.12108083871692,89.736676941302804,2.7492413323206284]
["Hollow",112,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B36,$D$21+$F$47*12/$B36)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B36),$E$21+$G$47*12/$B36)","v":333.9505615234375},87.593589907786878,44.997488839285715,341.53747231619701,89.583599296051673,2.7550218083046865]
["Hollow",120,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$D$20+$F$47*12/$B37,$D$21+$F$47*12/$B37)","v":41.53125},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",$E$20+$G$47*(12/$B37),$E$21+$G$47*12/$B37)","v":333.9505615234375},87.593589907786878,44.766406250000003,341.03167826334635,89.450932003500682,2.760077300402128]
[]
[null,null,"Vertically Grouted Wall - Calculations"]
[null,null,null,"Does the Cell Exist?",{"$f":"IF(AND('Unit Configuration'!D50=\"Faceshell\",D42=TRUE),\"Net Cell Length (Incl. Webs Thicknesses with Mortar)\",\"Net Cell Length\")","v":"Net Cell Length"},"Net Cell Area","Net Cell MOI","Avg Cell Length","Avg Cell Area","Avg Cell MOI"]
[null,null,"Cell 0",{"$f":"IF('Unit Configuration'!I44>0,TRUE,FALSE)","v":false},{"$f":"IF(AND(D41=TRUE,'Unit Configuration'!D50=\"Face shell\"),'Unit Configuration'!I44+Calculations!F3,IF(AND(D41=TRUE,'Unit Configuration'!D50=\"Full\"),'Unit Configuration'!I44,0))","v":0},{"$f":"IF(E41>0,$L$6*E41,0)","v":0},{"$f":"IF(E41>0,1/12*E41*($L$6^3),0)","v":0},{"$f":"IF(D41=TRUE,'Unit Configuration'!I44,0)","v":0},{"$f":"IF(H41>=5,$L$6*H41,0)","v":0},{"$f":"IF(H41>=5,1/12*H41*($L$6^3),0)","v":0}]
[null,null,"Cell 1",{"$f":"IF('Unit Configuration'!I45>0,TRUE,FALSE)","v":true},{"$f":"IF(AND('Unit Configuration'!$D$50=\"Face shell\",D42=TRUE),F4+'Unit Configuration'!I45-'Unit Configuration'!I44,IF(AND('Unit Configuration'!$D$50=\"Full\",D42=TRUE),'Unit Configuration'!I45-'Unit Configuration'!I44-F4,0))","v":0},{"$f":"IF(E42>0,($L$6)*E42,0)","v":0},0,{"$f":"IF(D42=TRUE,'Unit Configuration'!I45-'Unit Configuration'!I44-Calculations!F3,0)","v":6.3125},32.3515625,70.811167399088532]
[null,null,"Cell 2",{"$f":"IF('Unit Configuration'!I46>0,TRUE,FALSE)","v":true},{"$f":"IF(AND('Unit Configuration'!$D$50=\"Face shell\",D43=TRUE),F5+'Unit Configuration'!I46-'Unit Configuration'!I45,IF(AND('Unit Configuration'!$D$50=\"Full\",D43=TRUE),'Unit Configuration'!I46-'Unit Configuration'!I45-F5,0))","v":0},{"$f":"IF(E43>0,($L$6)*E43,0)","v":0},0,{"$f":"IF(D43=TRUE,'Unit Configuration'!I46-'Unit Configuration'!I45-Calculations!F4,0)","v":6.3125},32.3515625,70.811167399088532]
[null,null,"Cell 3",{"$f":"IF('Unit Configuration'!I47>0,TRUE,FALSE)","v":false},{"$f":"IF(AND('Unit Configuration'!$D$50=\"Face shell\",D44=TRUE),F6+'Unit Configuration'!I47-'Unit Configuration'!I46,IF(AND('Unit Configuration'!$D$50=\"Full\",D44=TRUE),'Unit Configuration'!I47-'Unit Configuration'!I46-F6,0))","v":0},{"$f":"IF(E44>0,($L$6)*E44,0)","v":0},0,{"$f":"IF(D44=TRUE,'Unit Configuration'!I47-'Unit Configuration'!I46-Calculations!F5,0)","v":0},0,0]
[null,null,"Cell 4",{"$f":"IF('Unit Configuration'!I48>0,TRUE,FALSE)","v":false},{"$f":"IF(AND('Unit Configuration'!$D$50=\"Face shell\",D45=TRUE),F7+'Unit Configuration'!I48-'Unit Configuration'!I47,IF(AND('Unit Configuration'!$D$50=\"Full\",D45=TRUE),'Unit Configuration'!I48-'Unit Configuration'!I47-F7,0))","v":0},{"$f":"IF(E45>0,($L$6)*E45,0)","v":0},0,{"$f":"IF(D45=TRUE,'Unit Configuration'!I48-'Unit Configuration'!I47-Calculations!F6,0)","v":0},0,0]
[null,null,"Cell 5",{"$f":"IF(MAX('Unit Configuration'!I44:I48)+LOOKUP(5,1/(F3:F7<>0),F3:F7)<B5,TRUE,FALSE)","v":false},{"$f":"IF(AND('Unit Configuration'!$D$50=\"Face shell\",D46=TRUE),F9+'Unit Configuration'!I49-'Unit Configuration'!I48,IF(AND('Unit Configuration'!$D$50=\"Full\",D46=TRUE),'Unit Configuration'!I49-'Unit Configuration'!I48-F9,0))","v":0},{"$f":"IF(E46>0,($L$6)*E46,0)","v":0},0,{"$f":"IF(D46=TRUE,B5-MAX('Unit Configuration'!I44:I48)-LOOKUP(5,1/(F3:F7<>0),F3:F7),0)","v":0},0,0]
[null,null,null,null,"Average Total:",0,0,"Average Total:",{"$f":"AVERAGEIF(I41:I46,\">00\")","v":32.3515625},{"$f":"AVERAGEIF(J41:J46,\">00\")","v":70.811167399088532}]
[]
[null,null,null,null,"Vertically Grouted Wall - Checks"]
[null,null,null,null,"Can the unit potentially be grouted?",null,{"$f":"IF(IFERROR(F47,FALSE),TRUE, FALSE)","v":false}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Concrete Masonry Section Properties for Horizontally Grouted Walls "]
["Unit Config","BB Spacing (in.)","Mortar Bedding","Net Cross-Sectional Properties1",null,null,"Average Cross-Sectional Properties2"]
[null,null,null,"An (in2/ft)","In (in4/ft)","Sn (in3/ft)","Aavg (in2/ft)","Iavg (in4/ft)","Savg (in3/ft)","ravg (in)"]
["Hollow","None","Face shell",{"$f":"(B4+D5)*(D3+D4)*12/(B4+D5)","v":30},{"$f":"(((1/12)*(B4+D5)*(B3^3))-((1/12)*(B4+D5)*(L6^3)))*I13","v":308.7109375},{"$f":"(E96/($B$3/2))","v":80.973360655737707},{"$f":"($D98*($L$5/($B$5+$D$5))+($D96*(($B$5+$D$5-$L$5)/($B$5+$D$5))-((($B$3-(SUM($D$3:$D$4)))*$D5)*$L$8)*($L$5/($B$5+$D$5))))","v":40.4501953125},{"$f":"(E96*((B5+D5-L5)/(D5+B5)))+((E98)*(B4/8*L5)/(B5+D5))","v":330.05417442321777},{"$f":"(H96/($B$3/2))","v":86.571586733958753},{"$f":"(H96/G96)^0.5","v":2.8564873393862182}]
["Hollow","None","Full",{"$f":"(B4+D5)*(D3+D4)*12/(B4+D5)","v":30},{"$f":"(((1/12)*(B4+D5)*(B3^3))-((1/12)*(B4+D5)*(L6^3)))*I13","v":308.7109375},{"$f":"(E97/($B$3/2))","v":80.973360655737707},{"$f":"($D98*($L$5/(D5+$B$5)))+($D97*(($B$5+D5-$L$5)/($B$5+D5)))","v":41.53125},{"$f":"(E97*((B5+D5-L5)/(D5+B5)))+((E98*(L5/(B5+D5))))","v":333.9505615234375},{"$f":"(H97/($B$3/2))","v":87.593589907786878},{"$f":"(H97/G97)^0.5","v":2.8356562825665761}]
["Solid","None","Full",{"$f":"B3*(B4+D5)*12/(D5+B4)","v":91.5},{"$f":"1/12*(B4+D5)*B3^3*I13","v":443.322265625},116.28125,{"$f":"D98","v":91.5},{"$f":"E98","v":443.322265625},116.28125,{"$f":"(H98/G98)^0.5","v":2.2011479012854482}]
["Hollow",8,"Full",{"$f":"B3*(B4+D5)*12/(D5+B4)","v":91.5},{"$f":"E22","v":443.322265625},116.28125,{"$f":"D99","v":91.5},{"$f":"E99","v":443.322265625},{"$f":"F99","v":116.28125},2.2011479012854482]
["Hollow",{"$f":"'Unit Configuration'!D32*2","v":16},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"$D$96+($F$117*(12/B100))","v":60.75},{"$f":"$E$96+($F$118*(12/B100))","v":376.0166015625},98.627305327868854,{"$f":"$G$96+($F$117*12/B100)","v":71.2001953125},{"$f":"$H$96+($F$118*12/B100)","v":397.35983848571777},104.22553140608991,2.3623888965904185]
["Hollow",{"$f":"B100+'Unit Configuration'!$D$32","v":24},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"$D$96+($F$117*(12/B101))","v":50.5},{"$f":"$E$96+($F$118*(12/B101))","v":353.58138020833331},92.742657103825138,60.9501953125,374.92461713155109,98.340883182046184,2.4801870040518774]
["Hollow",{"$f":"B101+'Unit Configuration'!$D$32","v":32},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},45.375,342.36376953125,89.800332991803273,55.8251953125,363.70700645446777,95.398559070024334,2.552470362706484]
["Hollow",{"$f":"B102+'Unit Configuration'!$D$32","v":40},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},42.3,335.63320312500002,88.034938524590174,52.750195312499997,356.9764400482178,93.63316460281122,2.6014036251682304]
["Hollow",{"$f":"B103+'Unit Configuration'!$D$32","v":48},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},40.25,331.14615885416669,86.858008879781423,50.7001953125,352.48939577738446,92.456234958002483,2.6367454906898287]
["Hollow",{"$f":"B104+'Unit Configuration'!$D$32","v":56},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},38.785714285714285,327.94112723214283,86.017344847775163,49.235909598214285,349.28436415536061,91.615570925996224,2.6634747841486659]
["Hollow",{"$f":"B105+'Unit Configuration'!$D$32","v":64},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},37.6875,325.537353515625,85.386846823770497,48.1376953125,346.88059043884277,90.985072901991543,2.6844007594529646]
["Hollow",{"$f":"B106+'Unit Configuration'!$D$32","v":72},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},36.833333333333336,323.66775173611109,84.896459471766846,47.283528645833336,345.01098865932886,90.494685549987892,2.7012297498454783]
["Hollow",{"$f":"B107+'Unit Configuration'!$D$32","v":80},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},36.15,322.17207031250001,84.504149590163934,46.600195312499999,343.51530723571778,90.102375668384994,2.7150584193770908]
["Hollow",{"$f":"B108+'Unit Configuration'!$D$32","v":88},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},35.590909090909093,320.94833096590907,84.183168777943365,46.041104403409093,342.29156788912684,89.781394856164411,2.7266238803896523]
["Hollow",{"$f":"B109+'Unit Configuration'!$D$32","v":96},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},35.125,319.92854817708331,83.915684767759558,45.5751953125,341.27178510030109,89.513910845980618,2.7364399540575781]
["Hollow",{"$f":"B110+'Unit Configuration'!$D$32","v":104},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},34.730769230769234,319.06565504807691,83.689352143757873,45.180964543269234,340.40889197129468,89.287578221978933,2.7448758037044523]
["Hollow",{"$f":"B111+'Unit Configuration'!$D$32","v":112},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},34.392857142857139,318.32603236607144,83.495352751756442,44.843052455357146,339.66926928928922,89.093578829977503,2.7522035129668914]
["Hollow",{"$f":"B112+'Unit Configuration'!$D$32","v":120},{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},34.1,317.68502604166667,83.327219945355196,44.550195312500001,339.02826296488445,88.925446023576242,2.7586280387436828]
[]
[null,null,null,null,"Horizontally Grouted Wall - Calculations"]
[null,null,null,null,"Cell height",{"$f":"B7","v":8}]
[null,null,null,null,"Cell Area",{"$f":"F116*L6","v":41}]
[null,null,null,null,"Net cell MOI",{"$f":"(1/12)*(B4+D5)*(L6^3)","v":89.740885416666657}]
[]
["Wall Weight Calculator - Reference Table"]
["Unit Configuration","Grout Spacing (in.)","Mortar Bedding","Block Vol. \n(ft3/ft2)","Mortar Wt. (lb/ft2)","Grout Wt. \n(lb/ft2)","Grout %","Corrected Grout Wt. \n(lb/ft2)","Weight of Wall (psf) for CMU densities (pcf) of:"]
[null,null,null,null,null,null,null,null,85,95,105,115,125,135,145]
["Hollow","No Grout","Face shell",{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"('Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+('Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))))*(1/1728)*'Wall Weight Calculator'!$E$16*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":1.8024444580078125},0,0,{"$f":"G123*F123","v":0},{"$f":"ROUNDUP(($D123*I$122)+$E123+$H123,0)","v":25},28,31,33,36,39,41]
["Hollow","No Grout","Full",{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"('Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+('Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*(1/1728)*'Wall Weight Calculator'!$E$16*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)))","v":2.2716522216796871},0,0,0,26,28,31,34,37,39,42]
["Solid","No Grout","Full",{"$f":"('Wall Weight Calculator'!$C$7*'Wall Weight Calculator'!$C$8*'Wall Weight Calculator'!$C$9)*(1/1728)*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))","v":0.59143702189127589},{"$f":"('Wall Weight Calculator'!$C$13*(('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$7)+('Wall Weight Calculator'!$C$8)*'Wall Weight Calculator'!$C$7))*(1/1728)*'Wall Weight Calculator'!$E$16*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":5.4974555969238281},0,0,0,56,62,68,74,80,86,92]
["Hollow",8,"Full",{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"('Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B25=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B25,((('Wall Weight Calculator'!$B25/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B25/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":1},{"$f":"G126*F126","v":47.179361979166664},73,76,78,81,84,86,89]
["Hollow",16,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C127=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B127)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B26=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B26,((('Wall Weight Calculator'!$B26/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B26/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":0.5},{"$f":"G127*F127","v":23.589680989583332},49,52,55,57,60,63,66]
["Hollow",24,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C128=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B128)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B27=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B27,((('Wall Weight Calculator'!$B27/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B27/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":0.33333333333333331},15.726453993055554,41,44,47,50,52,55,58]
["Hollow",32,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C129=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B129)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B28=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B28,((('Wall Weight Calculator'!$B28/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B28/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":0.25},11.794840494791666,38,40,43,46,48,51,54]
["Hollow",40,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C130=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B130)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B29=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B29,((('Wall Weight Calculator'!$B29/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B29/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":0.2},9.4358723958333339,35,38,41,43,46,49,51]
["Hollow",48,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C131=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B131)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B30=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B30,((('Wall Weight Calculator'!$B30/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B30/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":0.16666666666666666},7.8632269965277768,34,36,39,42,44,47,50]
["Hollow",56,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C132=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B132)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B31=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B31,((('Wall Weight Calculator'!$B31/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B31/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":0.14285714285714285},6.7399088541666661,32,35,38,41,43,46,49]
["Hollow",64,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C133=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B133)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B32=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B32,((('Wall Weight Calculator'!$B32/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B32/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":0.125},5.897420247395833,{"$f":"ROUNDUP(($D133*I$122)+$E133+$H133,0)","v":32},34,37,40,42,45,48]
["Hollow",72,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C134=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B134)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B33=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B33,((('Wall Weight Calculator'!$B33/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B33/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":0.1111111111111111},5.2421513310185182,31,34,36,39,42,44,47]
["Hollow",80,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C135=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B135)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B34=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B34,((('Wall Weight Calculator'!$B34/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B34/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":0.1},4.717936197916667,30,33,36,39,41,44,47]
["Hollow",88,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C136=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B136)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B35=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B35,((('Wall Weight Calculator'!$B35/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B35/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":9.0909090909090912E-2},4.2890329071969697,30,33,35,38,41,44,46]
["Hollow",96,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C137=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B137)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B36=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B36,((('Wall Weight Calculator'!$B36/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B36/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":8.3333333333333329E-2},3.9316134982638884,30,32,35,38,40,43,46]
["Hollow",104,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C138=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B138)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B37=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B37,((('Wall Weight Calculator'!$B37/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B37/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":7.6923076923076927E-2},3.6291816907051282,29,32,35,37,40,43,46]
["Hollow",112,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C139=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B139)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B38=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B38,((('Wall Weight Calculator'!$B38/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B38/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":7.1428571428571425E-2},3.369954427083333,29,32,35,37,40,43,45]
["Hollow",120,{"$f":"IF('Unit Configuration'!$D$50=\"Face shell\",\"Face shell\",\"Full\")","v":"Full"},{"$f":"((('Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$9*'Wall Weight Calculator'!$C$11)*'Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$7+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$8+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$9+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$10+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*'Wall Weight Calculator'!$F$11))*(1/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))","v":0.27023824055989581},{"$f":"IF($C140=\"Full\",$E$126,'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$C$10*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9)+'Wall Weight Calculator'!$C$11*('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13+'Wall Weight Calculator'!$C$9))*('Wall Weight Calculator'!$E$16/1728)*(12/('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*(12/('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13))+'Wall Weight Calculator'!$C$13*('Wall Weight Calculator'!$G$7*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$8*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$9*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$10*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))+'Wall Weight Calculator'!$G$11*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11)))*'Wall Weight Calculator'!$E$16/1728*144/(('Wall Weight Calculator'!$C$8+'Wall Weight Calculator'!$C$13)*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13))*12/B140)","v":2.2716522216796875},{"$f":"SUM(Calculations!$F$144:$F$149)","v":47.179361979166664},{"$f":"IF('Wall Weight Calculator'!$H$17=\"Partial\",IF('Wall Weight Calculator'!$B39=\"No Grout\",(8/'Wall Weight Calculator'!$H$18),IF('Wall Weight Calculator'!$H$18=\"No Grout\",8/'Wall Weight Calculator'!$B39,((('Wall Weight Calculator'!$B39/8-1)+('Wall Weight Calculator'!$H$18/8))/(('Wall Weight Calculator'!$B39/8)*('Wall Weight Calculator'!$H$18/8))))),IF('Wall Weight Calculator'!$H$17=\"No Grout\",0,1))","v":6.6666666666666666E-2},3.1452907986111107,29,32,34,37,40,42,45]
[]
[null,null,null,"Grout Calculations"]
[null,null,null,null,"Length","Weight of Grout (lb/ft2)"]
[null,null,null,"Cell 0",{"$f":"IF(D41=TRUE,'Unit Configuration'!I44,0)","v":0},{"$f":"IF($D41=FALSE,0,E144*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*('Wall Weight Calculator'!$H$16*144*8)/(1728*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13)*Calculations!$B$126))","v":0}]
[null,null,null,"Cell 1",{"$f":"IF((D42=TRUE),('Unit Configuration'!I45-('Unit Configuration'!I44+F3)),0)","v":6.3125},{"$f":"IF($D42=FALSE,0,E145*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*('Wall Weight Calculator'!$H$16*144*8)/(1728*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13)*Calculations!$B$126))","v":23.589680989583332}]
[null,null,null,"Cell 2",{"$f":"IF(D43=TRUE,'Unit Configuration'!I46-('Unit Configuration'!I45+'Unit Configuration'!I44+F3),0)","v":6.3125},{"$f":"IF($D43=FALSE,0,E146*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*('Wall Weight Calculator'!$H$16*144*8)/(1728*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13)*Calculations!$B$126))","v":23.589680989583332}]
[null,null,null,"Cell 3",{"$f":"IF(D44=TRUE,('Unit Configuration'!I47-('Unit Configuration'!I46+F5+'Unit Configuration'!I45+F4+'Unit Configuration'!I44+F3)),0)","v":0},{"$f":"IF($D44=FALSE,0,E147*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*('Wall Weight Calculator'!$H$16*144*8)/(1728*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13)*Calculations!$B$126))","v":0}]
[null,null,null,"Cell 4",{"$f":"IF(D45=TRUE,('Unit Configuration'!I48-('Unit Configuration'!I47+F6+'Unit Configuration'!I46+F5+'Unit Configuration'!I45+F4+'Unit Configuration'!I44+F3)),0)","v":0},{"$f":"IF($D45=FALSE,0,E148*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*('Wall Weight Calculator'!$H$16*144*8)/(1728*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13)*Calculations!$B$126))","v":0}]
[null,null,null,"Cell 5",{"$f":"IF(D46=TRUE,'Wall Weight Calculator'!C9-(E144+F3+Calculations!E145+F4+Calculations!E146+F5+Calculations!E147+F6+Calculations!E148+F7),0)","v":0},{"$f":"IF($D46=FALSE,0,E149*('Wall Weight Calculator'!$C$7-('Wall Weight Calculator'!$C$10+'Wall Weight Calculator'!$C$11))*('Wall Weight Calculator'!$H$16*144*8)/(1728*('Wall Weight Calculator'!$C$9+'Wall Weight Calculator'!$C$13)*Calculations!$B$126))","v":0}]

{"sheet":"Wall Weight Calculator","index":4,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,8,0,10],[6,8,6,10],[7,8,7,10],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,19,9],[15,2,15,3],[16,5,16,6],[17,5,17,6],[16,2,16,3],[15,5,15,6],[8,8,8,10],[9,7,12,10],[14,2,14,7],[1,8,1,10],[2,8,2,10],[3,8,3,10],[5,0,5,2],[5,7,5,10],[8,0,8,1],[11,0,11,2],[10,0,10,1],[12,0,12,1],[9,0,9,1],[6,0,6,1],[7,0,7,1]]}
[null,null,null,null,null,null,null,"Date",{"$f":"'Section Properties Calculator'!I1","v":"00:00:00"}]
[null,null,null,null,null,null,null,"Project Name:",{"$f":"'Section Properties Calculator'!I2","v":0}]
[null,null,null,null,null,null,null,"Project Number:",{"$f":"'Section Properties Calculator'!I3","v":0}]
[null,null,null,null,null,null,null,"Unit Description:",{"$f":"'Section Properties Calculator'!I4","v":0}]
[]
["General Unit Info",null,null,"Webs","Location","Height","Thickness","ASTM C90 Web and Face shell Requirements"]
["Specified Unit Width (in.)",null,{"$f":"'Unit Configuration'!F31","v":7.625},"X1 (in.)",{"$f":"IF(D7=\"\",\"\",'Unit Configuration'!I44)","v":0},{"$f":"IF(D7=\"\",\"\",Calculations!H3)","v":7.625},{"$f":"IF(D7=\"\",\"\",Calculations!F3)","v":1},"Normalized Web Area?",{"$f":"IF(G12>=6.5,\"Complies with ASTM C90\",\"Does not comply\")","v":"Complies with ASTM C90"}]
["Specified Unit Height (in.)",null,{"$f":"'Unit Configuration'!F32","v":7.625},"X2 (in.)",{"$f":"IF(D8=\"\",\"\",'Unit Configuration'!I45)","v":7.3125},{"$f":"IF(D8=\"\",\"\",Calculations!H4)","v":7.625},{"$f":"IF(D8=\"\",\"\",Calculations!F4)","v":1},"Faceshell Thicknesses?",{"$f":"IF(AND(Calculations!G13,Calculations!G14),\"Complies with ASTM C90\",\"Does not comply\")","v":"Complies with ASTM C90"}]
["Specified Unit Length (in.)",null,{"$f":"'Unit Configuration'!F33","v":15.625},"X3 (in.)",{"$f":"IF(D9=\"\",\"\",'Unit Configuration'!I46)","v":14.625},{"$f":"IF(D9=\"\",\"\",Calculations!H5)","v":7.625},{"$f":"IF(D9=\"\",\"\",Calculations!F5)","v":1},"Web Thicknesses?",{"$f":"'Section Properties Calculator'!J9","v":"Complies with ASTM C90"}]
["First Faceshell Thickness (in.)",null,{"$f":"'Unit Configuration'!D37","v":1.25},"X4 (in.)",{"$f":"IF('Unit Configuration'!$D$41>3,'Unit Configuration'!I47,0)","v":0},{"$f":"IF('Unit Configuration'!$D$41>3,Calculations!H6,0)","v":0},{"$f":"IF('Unit Configuration'!$D$41>3,Calculations!F6,0)","v":0},{"$f":"IF(AND('Unit Configuration'!N43=\"Yes\",Calculations!G50=TRUE),\"\",\"The entered configuration cannot be partially grouted or have a full mortar bed. These values have been eliminated from consideration and will show as blank spaces on the table\")","v":"The entered configuration cannot be partially grouted or have a full mortar bed. These values have been eliminated from consideration and will show as blank spaces on the table"}]
["Second Faceshell Thickness (in.)",null,{"$f":"IF('Unit Configuration'!D36=\"Yes\",'Unit Configuration'!D38,'Unit Configuration'!D37)","v":1.25},"X5 (in.)",{"$f":"IF('Unit Configuration'!$D$41>3,'Unit Configuration'!I48,0)","v":0},{"$f":"IF('Unit Configuration'!$D$41>3,Calculations!H7,0)","v":0},{"$f":"IF('Unit Configuration'!$D$41>3,Calculations!F7,0)","v":0}]
["Mortar Info",null,null,"Normalized Web Area (in2/ft2)",null,null,{"$f":"'Section Properties Calculator'!G12","v":25.734375}]
["Mortar Thickness (in.)",null,{"$f":"'Unit Configuration'!D30","v":0.375},"Block Volume (ft3/ft2)",null,null,{"$f":"'Unit Configuration'!D55","v":0.24021176938657407}]
[]
[null,null,"Wall Assembly Configuration"]
[null,null,"Mortar Density (lb/ft3)",null,125,"Grout Density  (lb/ft3)",null,140]
[null,null,"Mortar Bedding",null,{"$f":"'Unit Configuration'!D50","v":0},"Horizontal Grout Placement",null,"Partial"]
[null,null,null,null,null,"Spacing of Horizontally Grouted Bond Beams (in.)",null,"No Grout"]
[]
["Unit Configuration","Vertical Grout Spacing (in.)","Mortar Bedding","Weight of Wall (psf) for CMU densities (pcf) of:"]
[null,null,null,85,95,105,115,125,135,145]
[{"$f":"Calculations!A123","v":"Hollow"},{"$f":"Calculations!B123","v":"No Grout"},{"$f":"Calculations!C123","v":"Face shell"},{"$f":"Calculations!I123","v":25},{"$f":"Calculations!J123","v":28},{"$f":"Calculations!K123","v":31},{"$f":"Calculations!L123","v":33},{"$f":"Calculations!M123","v":36},{"$f":"Calculations!N123","v":39},{"$f":"Calculations!O123","v":41}]
[{"$f":"Calculations!A124","v":"Hollow"},{"$f":"Calculations!B124","v":"No Grout"},{"$f":"Calculations!C124","v":"Full"},{"$f":"Calculations!I124","v":26},{"$f":"Calculations!J124","v":28},{"$f":"Calculations!K124","v":31},{"$f":"Calculations!L124","v":34},{"$f":"Calculations!M124","v":37},{"$f":"Calculations!N124","v":39},{"$f":"Calculations!O124","v":42}]
[{"$f":"Calculations!A125","v":"Solid"},{"$f":"Calculations!B125","v":"No Grout"},{"$f":"Calculations!C125","v":"Full"},{"$f":"Calculations!I125","v":56},{"$f":"Calculations!J125","v":62},{"$f":"Calculations!K125","v":68},{"$f":"Calculations!L125","v":74},{"$f":"Calculations!M125","v":80},{"$f":"Calculations!N125","v":86},{"$f":"Calculations!O125","v":92}]
[{"$f":"Calculations!A126","v":"Hollow"},{"$f":"Calculations!B126","v":8},{"$f":"Calculations!C126","v":"Full"},{"$f":"Calculations!I126","v":73},{"$f":"Calculations!J126","v":76},{"$f":"Calculations!K126","v":78},{"$f":"Calculations!L126","v":81},{"$f":"Calculations!M126","v":84},{"$f":"Calculations!N126","v":86},{"$f":"Calculations!O126","v":89}]
[{"$f":"Calculations!A127","v":"Hollow"},{"$f":"Calculations!B127","v":16},{"$f":"Calculations!C127","v":"Full"},{"$f":"Calculations!I127","v":49},{"$f":"Calculations!J127","v":52},{"$f":"Calculations!K127","v":55},{"$f":"Calculations!L127","v":57},{"$f":"Calculations!M127","v":60},{"$f":"Calculations!N127","v":63},{"$f":"Calculations!O127","v":66}]
[{"$f":"Calculations!A128","v":"Hollow"},{"$f":"Calculations!B128","v":24},{"$f":"Calculations!C128","v":"Full"},{"$f":"Calculations!I128","v":41},{"$f":"Calculations!J128","v":44},{"$f":"Calculations!K128","v":47},{"$f":"Calculations!L128","v":50},{"$f":"Calculations!M128","v":52},{"$f":"Calculations!N128","v":55},{"$f":"Calculations!O128","v":58}]
[{"$f":"Calculations!A129","v":"Hollow"},{"$f":"Calculations!B129","v":32},{"$f":"Calculations!C129","v":"Full"},{"$f":"Calculations!I129","v":38},{"$f":"Calculations!J129","v":40},{"$f":"Calculations!K129","v":43},{"$f":"Calculations!L129","v":46},{"$f":"Calculations!M129","v":48},{"$f":"Calculations!N129","v":51},{"$f":"Calculations!O129","v":54}]
[{"$f":"Calculations!A130","v":"Hollow"},{"$f":"Calculations!B130","v":40},{"$f":"Calculations!C130","v":"Full"},{"$f":"Calculations!I130","v":35},{"$f":"Calculations!J130","v":38},{"$f":"Calculations!K130","v":41},{"$f":"Calculations!L130","v":43},{"$f":"Calculations!M130","v":46},{"$f":"Calculations!N130","v":49},{"$f":"Calculations!O130","v":51}]
[{"$f":"Calculations!A131","v":"Hollow"},{"$f":"Calculations!B131","v":48},{"$f":"Calculations!C131","v":"Full"},{"$f":"Calculations!I131","v":34},{"$f":"Calculations!J131","v":36},{"$f":"Calculations!K131","v":39},{"$f":"Calculations!L131","v":42},{"$f":"Calculations!M131","v":44},{"$f":"Calculations!N131","v":47},{"$f":"Calculations!O131","v":50}]
[{"$f":"Calculations!A132","v":"Hollow"},{"$f":"Calculations!B132","v":56},{"$f":"Calculations!C132","v":"Full"},{"$f":"Calculations!I132","v":32},{"$f":"Calculations!J132","v":35},{"$f":"Calculations!K132","v":38},{"$f":"Calculations!L132","v":41},{"$f":"Calculations!M132","v":43},{"$f":"Calculations!N132","v":46},{"$f":"Calculations!O132","v":49}]
[{"$f":"Calculations!A133","v":"Hollow"},{"$f":"Calculations!B133","v":64},{"$f":"Calculations!C133","v":"Full"},{"$f":"Calculations!I133","v":32},{"$f":"Calculations!J133","v":34},{"$f":"Calculations!K133","v":37},{"$f":"Calculations!L133","v":40},{"$f":"Calculations!M133","v":42},{"$f":"Calculations!N133","v":45},{"$f":"Calculations!O133","v":48}]
[{"$f":"Calculations!A134","v":"Hollow"},{"$f":"Calculations!B134","v":72},{"$f":"Calculations!C134","v":"Full"},{"$f":"Calculations!I134","v":31},{"$f":"Calculations!J134","v":34},{"$f":"Calculations!K134","v":36},{"$f":"Calculations!L134","v":39},{"$f":"Calculations!M134","v":42},{"$f":"Calculations!N134","v":44},{"$f":"Calculations!O134","v":47}]
[{"$f":"Calculations!A135","v":"Hollow"},{"$f":"Calculations!B135","v":80},{"$f":"Calculations!C135","v":"Full"},{"$f":"Calculations!I135","v":30},{"$f":"Calculations!J135","v":33},{"$f":"Calculations!K135","v":36},{"$f":"Calculations!L135","v":39},{"$f":"Calculations!M135","v":41},{"$f":"Calculations!N135","v":44},{"$f":"Calculations!O135","v":47}]
[{"$f":"Calculations!A136","v":"Hollow"},{"$f":"Calculations!B136","v":88},{"$f":"Calculations!C136","v":"Full"},{"$f":"Calculations!I136","v":30},{"$f":"Calculations!J136","v":33},{"$f":"Calculations!K136","v":35},{"$f":"Calculations!L136","v":38},{"$f":"Calculations!M136","v":41},{"$f":"Calculations!N136","v":44},{"$f":"Calculations!O136","v":46}]
[{"$f":"Calculations!A137","v":"Hollow"},{"$f":"Calculations!B137","v":96},{"$f":"Calculations!C137","v":"Full"},{"$f":"Calculations!I137","v":30},{"$f":"Calculations!J137","v":32},{"$f":"Calculations!K137","v":35},{"$f":"Calculations!L137","v":38},{"$f":"Calculations!M137","v":40},{"$f":"Calculations!N137","v":43},{"$f":"Calculations!O137","v":46}]
[{"$f":"Calculations!A138","v":"Hollow"},{"$f":"Calculations!B138","v":104},{"$f":"Calculations!C138","v":"Full"},{"$f":"Calculations!I138","v":29},{"$f":"Calculations!J138","v":32},{"$f":"Calculations!K138","v":35},{"$f":"Calculations!L138","v":37},{"$f":"Calculations!M138","v":40},{"$f":"Calculations!N138","v":43},{"$f":"Calculations!O138","v":46}]
[{"$f":"Calculations!A139","v":"Hollow"},{"$f":"Calculations!B139","v":112},{"$f":"Calculations!C139","v":"Full"},{"$f":"Calculations!I139","v":29},{"$f":"Calculations!J139","v":32},{"$f":"Calculations!K139","v":35},{"$f":"Calculations!L139","v":37},{"$f":"Calculations!M139","v":40},{"$f":"Calculations!N139","v":43},{"$f":"Calculations!O139","v":45}]
[{"$f":"Calculations!A140","v":"Hollow"},{"$f":"Calculations!B140","v":120},{"$f":"Calculations!C140","v":"Full"},{"$f":"Calculations!I140","v":29},{"$f":"Calculations!J140","v":32},{"$f":"Calculations!K140","v":34},{"$f":"Calculations!L140","v":37},{"$f":"Calculations!M140","v":40},{"$f":"Calculations!N140","v":42},{"$f":"Calculations!O140","v":45}]

{"sheet":"STC_OITC Calculator","index":5,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":true,"merged":[[8,0,8,1],[6,8,6,10],[7,8,7,10],[8,8,8,10],[3,8,3,10],[5,0,5,2],[5,7,5,10],[6,0,6,1],[7,0,7,1],[0,8,0,10],[11,0,11,2],[36,2,36,6],[17,2,17,4],[14,2,14,7],[15,2,15,3],[15,5,15,6],[9,0,9,1],[10,0,10,1],[12,0,12,1],[9,7,12,10],[16,2,16,3],[16,5,16,6],[17,5,17,6],[1,8,1,10],[2,8,2,10]]}
[null,null,null,null,null,null,null,"Date",{"$f":"'Wall Weight Calculator'!I1:K1","v":"00:00:00"}]
[null,null,null,null,null,null,null,"Project Name:",{"$f":"'Wall Weight Calculator'!I2","v":0}]
[null,null,null,null,null,null,null,"Project Number:",{"$f":"'Wall Weight Calculator'!I3","v":0}]
[null,null,null,null,null,null,null,"Unit Description:",{"$f":"'Wall Weight Calculator'!I4","v":0}]
[]
["General Unit Info",null,null,"Webs","Location","Height","Thickness","ASTM C90 Web and Face shell Requirements"]
["Specified Unit Width (in.)",null,{"$f":"'Unit Configuration'!F31","v":7.625},{"$f":"IF('Unit Configuration'!F44=\"\",\"\",\"X1 (in.)\")","v":"X1 (in.)"},{"$f":"IF(D7=\"\",\"\",'Unit Configuration'!I44)","v":0},{"$f":"IF(D7=\"\",\"\",Calculations!H3)","v":7.625},{"$f":"IF(D7=\"\",\"\",Calculations!F3)","v":1},"Normalized Web Area?",{"$f":"IF(G12>=6.5,\"Complies with ASTM C90\",\"Does not comply\")","v":"Complies with ASTM C90"}]
["Specified Unit Height (in.)",null,{"$f":"'Unit Configuration'!F32","v":7.625},{"$f":"IF('Unit Configuration'!F45=\"\",\"\",\"X2 (in.)\")","v":"X2 (in.)"},{"$f":"IF(D8=\"\",\"\",'Unit Configuration'!I45)","v":7.3125},{"$f":"IF(D8=\"\",\"\",Calculations!H4)","v":7.625},{"$f":"IF(D8=\"\",\"\",Calculations!F4)","v":1},"Faceshell Thicknesses?",{"$f":"IF(AND(Calculations!G13,Calculations!G14),\"Complies with ASTM C90\",\"Does not comply\")","v":"Complies with ASTM C90"}]
["Specified Unit Length (in.)",null,{"$f":"'Unit Configuration'!F33","v":15.625},{"$f":"IF('Unit Configuration'!F46=\"\",\"\",\"X3 (in.)\")","v":"X3 (in.)"},{"$f":"IF(D9=\"\",\"\",'Unit Configuration'!I46)","v":14.625},{"$f":"IF(D9=\"\",\"\",Calculations!H5)","v":7.625},{"$f":"IF(D9=\"\",\"\",Calculations!F5)","v":1},"Web Thicknesses?",{"$f":"'Section Properties Calculator'!J9","v":"Complies with ASTM C90"}]
["First Faceshell Thickness (in.)",null,{"$f":"'Unit Configuration'!D37","v":1.25},"X4 (in.)",{"$f":"IF('Unit Configuration'!$D$41>3,'Unit Configuration'!I47,0)","v":0},{"$f":"IF('Unit Configuration'!$D$41>3,Calculations!H6,0)","v":0},{"$f":"IF('Unit Configuration'!$D$41>3,Calculations!F6,0)","v":0},"The following STC/OITC calculations \nwere based off of TMS 302"]
["Second Faceshell Thickness (in.)",null,{"$f":"IF('Unit Configuration'!D36=\"Yes\",'Unit Configuration'!D38,'Unit Configuration'!D37)","v":1.25},"X5 (in.)",{"$f":"IF('Unit Configuration'!$D$41>3,'Unit Configuration'!I48,0)","v":0},{"$f":"IF('Unit Configuration'!$D$41>3,Calculations!H7,0)","v":0},{"$f":"IF('Unit Configuration'!$D$41>3,Calculations!F7,0)","v":0}]
["Mortar Info",null,null,"Normalized Web Area (in2/ft2)",null,null,{"$f":"'Section Properties Calculator'!G12","v":25.734375}]
["Mortar Thickness (in.)",null,{"$f":"'Unit Configuration'!D30","v":0.375},"Block Volume (ft3/ft2)",null,null,{"$f":"'Unit Configuration'!D55","v":0.24021176938657407}]
[]
[null,null,"Wall Assembly Configuration"]
[null,null,"Mortar Density (lb/ft3)",null,{"$f":"'Wall Weight Calculator'!E16","v":125},"Grout Density  (lb/ft3)",null,{"$f":"'Wall Weight Calculator'!H16","v":140}]
[null,null,"Mortar Bedding",null,{"$f":"'Wall Weight Calculator'!E17","v":0},"Grouting Placement",null,{"$f":"'Wall Weight Calculator'!H17","v":"Partial"}]
[null,null,null,null,null,"Horizontal Spacing (in.)",null,{"$f":"'Wall Weight Calculator'!H18","v":"No Grout"}]
[]
[]
[]
["Option 1:  Calculate STC/OITC Ratings Based on Wall Weight"]
["Wall Weight (psf)"]
["Calculated STC (dB)",{"$f":"(20.5)*(B23^0.234)","v":0}]
["Calculated OITC (dB)",{"$f":"(14.7)*(B23^0.29)","v":0}]
[]
["Option 2:  Calculate Required Wall Weight Based on Desired STC/OITC"]
["Desired STC Rating (dB)"]
["Required Wall Weight (psf)",{"$f":"(B28/20.5)^4.274","v":0}]
[]
["Desired OITC Rating (dB)"]
["Required Wall Weight (psf)",{"$f":"(B31/14.7)^3.45","v":0}]
[]
[]
["Option 3: Calculate STC/OITC Ratings with Finishes"]
["Do you wish to adjust the STC or OITC based on finishes?"]
["What type of finish do you wish to add to the CMU wall?"]
["Is sound absorbing material present in the furring space?"]
[{"$f":"IF(C39=\"No\",\"\",\"What is the thickness of the furring space on one side of the wall?\")","v":"What is the thickness of the furring space on one side of the wall?"}]
[{"$f":"IF(OR(C37=\"Clay/CMU Wythe on one side of the wall and Drywall on the other side of the wall\",C37=\"Clay/CMU Veneer Wythe\",C36=\"OITC\"),\"What is the weight (psf) of the veneer material?\",\"\")","v":""}]
[]
[{"$f":"IF(C36=\"STC\",\"Adjusted input wall weight STC based on finishes (dB)\",\"\")","v":""},{"$f":"IF(C37=\"Clay/CMU Veneer Wythe\",'STC_OITC Lookup Table'!B14,INDEX('STC_OITC Lookup Table'!$B$2:'STC_OITC Lookup Table'!$H$14,13,MATCH('STC_OITC Calculator'!$C$37&'STC_OITC Calculator'!$C$38,'STC_OITC Lookup Table'!$B$2:$H$2&'STC_OITC Lookup Table'!$B$3:$H$3,0)))","v":{"$error":"#N/A"}}]
[{"$f":"IF(C36=\"OITC\",\"Adjusted input wall weight OITC based on finishes (dB)\",\"\")","v":""},{"$f":"'STC_OITC Lookup Table'!B22","v":{"$error":"#DIV/0!"}}]

{"sheet":"STC_OITC Lookup Table","index":6,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,0,0,7],[15,0,15,1]]}
["STC Finishes"]
[null,"Clay/CMU Veneer Wythe","Drywall on one side of the wall","Drywall on one side of the wall","Drywall on both sides of the Wall","Drywall on both sides of the Wall","Clay/CMU Wythe on one side of the wall and Drywall on the other side of the wall","Clay/CMU Wythe on one side of the wall and Drywall on the other side of the wall"]
["Furring Material Present?",null,"No","Yes","No","Yes","No","Yes"]
["Block Weight (psf)",{"$f":"'STC_OITC Calculator'!$B$23","v":0},{"$f":"'STC_OITC Calculator'!$B$23","v":0},{"$f":"'STC_OITC Calculator'!$B$23","v":0},{"$f":"'STC_OITC Calculator'!$B$23","v":0},{"$f":"'STC_OITC Calculator'!$B$23","v":0},{"$f":"'STC_OITC Calculator'!$B$23","v":0},{"$f":"'STC_OITC Calculator'!$B$23","v":0}]
["Block STC",null,{"$f":"'STC_OITC Calculator'!$B$24","v":0},{"$f":"'STC_OITC Calculator'!$B$24","v":0},{"$f":"'STC_OITC Calculator'!$B$24","v":0},{"$f":"'STC_OITC Calculator'!$B$24","v":0}]
["Wythe Weight (psf)",{"$f":"'STC_OITC Calculator'!$C$40","v":0},null,null,null,null,{"$f":"'STC_OITC Calculator'!$C$40","v":0},{"$f":"'STC_OITC Calculator'!$C$40","v":0}]
["Thickness of the furring space on one side",null,{"$f":"'STC_OITC Calculator'!$C$39","v":0},{"$f":"'STC_OITC Calculator'!$C$39","v":0},{"$f":"'STC_OITC Calculator'!$C$39","v":0},{"$f":"'STC_OITC Calculator'!$C$39","v":0},{"$f":"'STC_OITC Calculator'!$C$39","v":0},{"$f":"'STC_OITC Calculator'!$C$39","v":0}]
["Eqn 1 of TEK Note 13-1C",{"$f":"ROUNDDOWN(20.5*(B4+B6)^0.234,0)","v":0},null,null,null,null,{"$f":"ROUNDDOWN(20.5*(G4+G6)^0.234,0)","v":0},{"$f":"ROUNDDOWN(20.5*(H4+H6)^0.234,0)","v":0}]
["Eqn 2 of TEK Note 13-1C",{"$f":"19.6*(B4+B6)^0.23","v":0},null,null,null,null,{"$f":"19.6*(G4+G6)^0.23","v":0},{"$f":"19.6*(H4+H6)^0.23","v":0}]
["Eqn 3 of TEK Note 13-1C",null,{"$f":"2.8*C7-1.22","v":-1.22},null,null,null,{"$f":"2.8*G7-1.22","v":-1.22}]
["Eqn 4 of TEK Note 13-1C",null,null,null,{"$f":"3.6*E7-2.78","v":-2.78}]
["Eqn 5 of TEK Note 13-1C",null,null,{"$f":"3*D7+1.87","v":1.87},null,null,null,{"$f":"3*H7+1.87","v":1.87}]
["Eqn 6 of TEK Note 13-1C",null,null,null,null,{"$f":"11.2*F7-7.37","v":-7.37}]
["Total STC",{"$f":"ROUNDDOWN(B8*(B4/SUM(B4,B6))+B9*(B6/SUM(B4,B6)),0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUNDDOWN($C$5+C10,0)","v":-1},{"$f":"ROUNDDOWN($C$5+D12,0)","v":1},{"$f":"ROUNDDOWN($C$5+E11,0)","v":-2},{"$f":"ROUNDDOWN($C$5+F13,0)","v":-7},{"$f":"ROUNDDOWN(G8*(G4/SUM(G4,G6))+G9*(G6/SUM(G4,G6))+G10,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUNDDOWN(H8*(H4/SUM(H4,H6))+H9*(H6/SUM(H4,H6))+H12,0)","v":{"$error":"#DIV/0!"}}]
[]
["OITC Finishes"]
[null,"Clay/CMU Veneer Wythe"]
["Block Weight (psf)",{"$f":"'STC_OITC Calculator'!$B$23","v":0}]
["Wythe Weight (psf)",{"$f":"'STC_OITC Calculator'!$C$40","v":0}]
["Eqn 1 of TEK Note 13-1C",{"$f":"ROUNDDOWN(14.7*(B18+B19)^0.29,0)","v":0}]
["Eqn 2 of TEK Note 13-1C",{"$f":"17.4*(B18+B19)^0.224","v":0}]
["Total STC",{"$f":"ROUNDDOWN(B20*(B18/SUM(B18,B19))+B21*(B19/SUM(B18,B19)),0)","v":{"$error":"#DIV/0!"}}]