{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Fire Resistance ","Fire Resistance Rating","Fire Resistance Loop Tables","Fire Resistance Lookup Graph"],"not_rendered":{"charts":2,"images":7,"macros":1,"external_links":0,"defined_names":14,"comments":1,"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":"Fire Resistance ","index":1,"n_rows":129,"n_cols":7,"rows_kept":129,"cut":false,"hidden":false,"merged":[[9,0,9,9],[23,0,23,9],[81,0,81,9],[10,1,11,8],[24,1,25,8],[41,6,43,8],[48,6,50,8],[12,6,15,9],[114,6,116,9],[32,6,32,8],[33,6,33,8],[17,6,19,8],[82,1,83,8],[107,6,108,9],[112,6,113,9],[89,6,90,9],[95,6,96,9],[109,6,111,9]]}
[null,null,null,"Date"]
[null,null,null,"Project Name"]
[null,null,null,"Project Number"]
[null,null,null,"Unit Description"]
[]
[]
[]
[]
[]
["Fire Rating Based on Single Wythe CMU Wall"]
[null,"***This section is meant for producers only! Designers should not use this section of the estimator to create their own mixes. Local producers should be consulted if the mix is needed to be determined. "]
[]
["Step 1: Enter Equivalent Thickness",null,null,null,null,null,{"$f":"CONCATENATE(\"Refer to the SAAP Calculator for an estimated equivalent thickness based on provided dimensions.\",\n\"The subsequent calculations will not account for any tapering of the block.\", \"For more accurate calculations,\nenter the equivalent thickness given from an ASTM C140 Report.\")","v":"Refer to the SAAP Calculator for an estimated equivalent thickness based on provided dimensions.The subsequent calculations will not account for any tapering of the block.For more accurate calculations,\nenter the equivalent thickness given from an ASTM C140 Report."}]
["Enter the Equivalent Thickness",null,null,null,8]
[]
["Step 2: Fill out the aggregate composition of the unit"]
[null,null,null,null,"% Volume Breakdown"]
["Calcareous or Siliceous Gravel",null,null,null,35,null,{"$f":"IF(OR(E22<100%,E22>100%),\"The aggregate compostion must equal 100%\n Adjust accordingly\",\"\")","v":""}]
["Limestone, Cinders or Unexpanded Slag",null,null,null,25]
["Expanded clay, shale, or slate",null,null,null,15]
["Expanded slag or pumice",null,null,null,25]
[null,null,null,null,{"$f":"SUM(E18:E21)/100","v":1}]
[]
["Fire Rating Based on Multi Wythe CMU Wall"]
[null,"***This section is meant for designers if they wish to determine how to effect the fire rating with external components for a CMU wall. "]
[]
["Step 1: Enter Wythe Details"]
["How many total wythes are present including the CMU wall?",null,null,null,2]
["Select the desired layout of the mutli-wythe configuration",null,null,null,"Clay / CMU"]
[]
["Do you wish to enter a fire rating or enter equivalent thickness for clay  (brick, tile, or shale) or CMU wythe(s)?",null,null,null,"Equivalent Thickness"]
[{"$f":"IF($E$31=\"Fire Rating\",\"Step 2a: Enter Fire Rating of Wythe(s) \",\"Step 2a: Enter Equivalent Thickness of Wythe(s) \")","v":"Step 2a: Enter Equivalent Thickness of Wythe(s) "}]
[{"$f":"IF(AND($E$28>1,$E$31=\"Fire Rating\",OR($E$30=\"Clay / CMU / Clay\",$E$29=\"Clay / CMU\",$E$30=\"Clay / CMU / CMU\")),\"Enter the fire rating of clay wythe #1\",IF(AND($E$28>1,$E$31=\"Fire Rating\",OR($E$30=\"CMU / CMU / CMU\",$E$29=\"CMU / CMU\")),\"Enter the fire rating of CMU wythe #1\",IF(AND($E$28>1,$E$31=\"Equivalent Thickness\",OR($E$30=\"Clay / CMU / Clay\",$E$29=\"Clay / CMU\",$E$30=\"Clay / CMU / CMU\")),\"Enter the equivalent thickness of clay wythe #1\",\"Enter the equivalent thickness of CMU wythe #1\")))","v":"Enter the equivalent thickness of clay wythe #1"},null,null,null,3,{"$f":"IF(AND($E$28>1,$E$31=\"Fire Rating\"),\"hours\", IF(AND($E$28>1,$E$31=\"Equivalent Thickness\"), \"in.\",\"\"))","v":"in."},{"$f":"IF($E$31=\"Equivalent Thickness\",\"\",IF(AND($E$31=\"Fire Rating\",1<=$E33,$E33<=4),\"\",\"Enter a fire rating between 1 hr and 4 hrs.\"))","v":""}]
[{"$f":"IF(AND($E$28>2,$E$31=\"Fire Rating\",OR($E$30=\"Clay / CMU / Clay\",$E$29=\"Clay / CMU\")),\"Enter the fire rating of clay wythe #2\",IF(AND($E$28>2,$E$31=\"Fire Rating\",OR($E$30=\"CMU / CMU / CMU\",$E$29=\"CMU / CMU\",E30=\"Clay / CMU / CMU\")),\"Enter the fire rating of CMU wythe #2\",IF(AND($E$28>2,$E$31=\"Equivalent Thickness\",OR($E$30=\"Clay / CMU / Clay\",$E$29=\"Clay / CMU\")),\"Enter the equivalent thickness of clay wythe #2\",IF(AND($E$28>2,$E$31=\"Equivalent Thickness\",OR($E$30=\"CMU / CMU / CMU\",$E$29=\"CMU / CMU\",$E$30=\"Clay / CMU / CMU\")),\"Enter the equivalent thickness of CMU wythe #2\",\"\"))))","v":""},null,null,null,null,{"$f":"IF(AND($E$28>2,$E$31=\"Fire Rating\"),\"hours\", IF(AND($E$28>2,$E$31=\"Equivalent Thickness\"), \"in.\",\"\"))","v":""},{"$f":"IF(OR($E$31=\"Equivalent Thickness\",A34=\"\"),\"\",IF(AND(E28=3,$E$31=\"Fire Rating\",1<=$E34,$E34<=4),\"\",\"Enter a fire rating between 1 hr and 4 hrs.\"))","v":""}]
[]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",OR(E29=\"Clay / CMU\",E30=\"Clay / CMU / Clay\",$E$30=\"Clay / CMU / CMU\")),\"Step 2b: Enter Type of Clay Wythe(s)\",\"\")","v":"Step 2b: Enter Type of Clay Wythe(s)"}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>=2,OR(E29=\"Clay / CMU\",E30=\"Clay / CMU / Clay\",$E$30=\"Clay / CMU / CMU\")),\"What is clay wythe #1 material type?\",\"\")","v":"What is clay wythe #1 material type?"},null,null,null,">=75% Solid"]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>2,OR(E29=\"Clay / CMU\",E30=\"Clay / CMU / Clay\")),\"What is clay wythe #2 material type?\",\"\")","v":""}]
[]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>=2,E30=\"Clay / CMU / CMU\"),\"Step 2c: Enter CMU Wythe Composition\",IF(AND($E$31=\"Equivalent Thickness\",$E$28>=2,A45=\"CMU Wythe #1 Composition\"),\"Step 2b: Enter CMU Wythe Composition\",\"\"))","v":""}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>=2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\")), \"CMU Wythe #1 Composition\",\"\")","v":""}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>=2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\")),\"Calcareous or Siliceous Gravel\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(A41=\"CMU Wythe #1 Composition\",OR(E46<100%,E46>100%)),\"The aggregate compostion must equal 100%\n Adjust accordingly\",\"\")","v":""}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>=2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\")),\"Limestone, Cinders or Unexpanded Slag\",\"\")","v":""}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>=2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\")),\"Expanded clay, shale, or slate\",\"\")","v":""}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>=2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\")),\"Expanded slag or pumice\",\"\")","v":""}]
[null,null,null,null,{"$f":"SUM(E42:E45)/100","v":0}]
[]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\",$E$30=\"Clay / CMU / CMU\")), \"CMU Wythe #2 Composition\",\"\")","v":""}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\",$E$30=\"Clay / CMU / CMU\")), \"Calcareous or Siliceous Gravel\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(A48=\"CMU Wythe #2 Composition\",OR(E53<100%,E53>100%)),\"The aggregate compostion must equal 100%\n Adjust accordingly\",\"\")","v":""}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\",$E$30=\"Clay / CMU / CMU\")), \"Limestone, Cinders or Unexpanded Slag\",\"\")","v":""}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\",$E$30=\"Clay / CMU / CMU\")), \"Expanded clay, shale, or slate\",\"\")","v":""}]
[{"$f":"IF(AND($E$31=\"Equivalent Thickness\",$E$28>2,OR(E29=\"CMU / CMU\",E30=\"CMU / CMU / CMU\",$E$30=\"Clay / CMU / CMU\")), \"Expanded slag or pumice\",\"\")","v":""}]
[null,null,null,null,{"$f":"SUM(E49:E52)/100","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Fire Rating Based on Finish Materials"]
[null,"***This section is meant for designers if they wish to determine how to effect the fire rating with external components for a CMU wall. "]
[]
["Step 1: Enter Assembly Description"]
["**The option of a clay veneer and finish is a not a calculatable option due to multi-wythe walls typically obtaining a fire rating > 4 hrs."]
["What type of assembly is to be analyzed?",null,null,null,"CMU Single Wythe with a finish on both sides"]
["Step 2: Enter Non-Fire Side Finish Detail(s)"]
["Non-Fire-Exposed Side "]
[{"$f":"IF($E$87=\"CMU Single Wythe with a finish on both sides\", \"What type of finish is applied on one side (Finish #1) of the wythe?\",\"What type of finish is being applied?\")","v":"What type of finish is applied on one side (Finish #1) of the wythe?"},null,null,null,"Portland Cement Sand Plaster",{"$f":"IF($E$87=\"CMU Single Wythe with a finish on both sides\",IFERROR('Fire Resistance Rating'!$E$239,2),IFERROR('Fire Resistance Rating'!$E$153,2))","v":1},{"$f":"IF(F90=2,\"This combination of material and thickness is not possible.\nPlease see Tables 4, 5, and 6 of the instruction guide for a list of possible combinations.\",\"\")","v":""}]
["What is the aggregate type in concrete masonry",null,null,null,{"$f":"IF(SUM(E20:E21)>=80,\"80% or more by volume of expanded shale_slate_clay_slag_pumice\",\"Siliceous_Calcareous_Limestone_Cinders_Air Cooled Blast Furnace Slag\")","v":"Siliceous_Calcareous_Limestone_Cinders_Air Cooled Blast Furnace Slag"}]
[null,null,null,{"$f":"IF(AND($E$90=\"Portland Cement Sand Plaster\",$E$91=\"80% or more by volume of expanded shale_slate_clay_slag_pumice\"),\"Is it direct applied?\",\"\")","v":""},"Yes"]
[null,null,null,{"$f":"IF(AND($E$90=\"Portland Cement Sand Plaster\",$E$91=\"80% or more by volume of expanded shale_slate_clay_slag_pumice\"),\"Enter Percent by Volume of Expanded Shale/Slate/Clay/Slag/Pumice\",\"\")","v":""}]
[]
[]
[{"$f":"IF($E$87=\"CMU Single Wythe with a finish on both sides\",\"What type of finish is applied on the other side (Finish #2) of the wythe?\",\"\")","v":"What type of finish is applied on the other side (Finish #2) of the wythe?"},null,null,null,"Gypsum Sand Plaster",{"$f":"IFERROR('Fire Resistance Rating'!$E$223,2)","v":1.25},{"$f":"IF(AND(E87=\"CMU Single Wythe with a finish on both sides\",F96=2),\"This combination of material and thickness is not possible.\nPlease see Tables 4, 5, and 6 of the instruction guide for a list of possible combinations.\",\"\")","v":""}]
[{"$f":"IF($E$87=\"CMU Single Wythe with a finish on both sides\",\"What is the aggregate type in concrete masonry\",\"\")","v":"What is the aggregate type in concrete masonry"},null,null,null,{"$f":"IF(SUM($E$20:$E$21)>=80,\"80% or more by volume of expanded shale_slate_clay_slag_pumice\",\"Siliceous_Calcareous_Limestone_Cinders_Air Cooled Blast Furnace Slag\")","v":"Siliceous_Calcareous_Limestone_Cinders_Air Cooled Blast Furnace Slag"}]
[null,null,null,{"$f":"IF($E$87=\"CMU Single Wythe with a finish on both sides \",IF(AND($E$96=\"Portland Cement Sand Plaster\",$E$97=\"80% or more by volume of expanded shale_slate_clay_slag_pumice\"),\"Is it direct applied?\",\"\"),\"\")","v":""}]
[null,null,null,{"$f":"IF($E$87=\"CMU Single Wythe with a finish on both sides \",IF(AND($E$96=\"Portland Cement Sand Plaster\",$E$97=\"80% or more by volume of expanded shale_slate_clay_slag_pumice\"),\"Enter Percent by Volume of Expanded Shale/Slate/Clay/Slag/Pumice\",\"\"),\"\")","v":""}]
[]
[{"$f":"IF(OR(E92=\"Yes\",$E$90=\"Gypsum Vermiculite or Perlite Plaster\"),\"\",\"What is the finish #1 thickness?\")","v":""},null,null,null,"1/2 in.",{"$f":"IF(E101=\"3/8 in.\",3/8,IF(E101=\"1/2 in.\",1/2,IF(E101=\"5/8 in.\",5/8,IF(E101=\"3/4 in.\",3/4,IF(E101=\"7/8 in.\",7/8,IF(E101=\"1 in.\",1,IF(E101=\"Two Layers of 3/8 in.\",6/8,IF(E101=\"One Layer of 3/8 in. and One layer of 1/2 in.\",3/8+1/2,1))))))))","v":0.5}]
[{"$f":"IF(OR(E92=\"Yes\",$E$90=\"Gypsum Vermiculite or Perlite Plaster\"),\"What is the Finish #1 thickness?\",\"\")","v":"What is the Finish #1 thickness?"},null,null,null,"3/8 in.",{"$f":"IF(OR(E92=\"Yes\",E90=\"Gypsum Vermiculite or Perlite Plaster\"),\"in.\",\"\")","v":"in."}]
[]
[{"$f":"IF(E87=\"CMU Single Wythe with finish on one (1) side\",\"\",IF(OR(E98=\"Yes\",$E$96=\"Gypsum Vermiculite or Perlite Plaster\"),\"\",\"What is the finish #2 thickness?\"))","v":"What is the finish #2 thickness?"},null,null,null,"1/2 in.",{"$f":"IF(E104=\"3/8 in.\",3/8,IF(E104=\"1/2 in.\",1/2,IF(E104=\"5/8 in.\",5/8,IF(E104=\"3/4 in.\",3/4,IF(E104=\"7/8 in.\",7/8,IF(E104=\"1 in.\",1,IF(E104=\"Two Layers of 3/8 in.\",6/8,IF(E104=\"One Layer of 3/8 in. and One layer of 1/2 in.\",3/8+1/2,1))))))))","v":0.5}]
[{"$f":"IF(AND(E87=\"CMU Single Wythe with a finish on both sides\",OR(E98=\"Yes\",$E$96=\"Gypsum Vermiculite or Perlite Plaster\")),\"What is the Finish #2 thickness?\",\"\")","v":""},null,null,null,null,{"$f":"IF(A105=\"What is the finish #2 thickness?\",\"in.\",\"\")","v":""}]
[]
["Step 3: Enter Fire Side Finish Detail(s)"]
["Fire-Exposed Side",null,null,null,null,{"$f":"IFERROR('Fire Resistance Rating'!$E$169,1)","v":""},{"$f":"IF(F108=1,\"This combination is not possible.\nPlease see Tables 4, 5, and 6 of the instruction guide for a list of possible combinations.\",\"\")","v":""}]
[{"$f":"IF($E$87=\"CMU Single Wythe with a finish on both sides\", \"Fire Side - Finish #1\",\"Fire Side Finish\")","v":"Fire Side - Finish #1"},null,null,null,"Portland Cement-Sand Plaster on Metal Lath"]
[null,null,null,null,"3/8 in.",null,{"$f":"IF($E$90=\"Gypsum Vermiculite or Perlite Plaster\",\"Fire Side Finish Calculations cannot be properly performed with \ncurrent finish selection. \nThe calculator will assume no finish is present.\",\"\")","v":""}]
[null,null,null,{"$f":"IF($E$109=\"Direct Applied Portland Cement\",\"Enter Plaster Thickness (in.)\",\"\")","v":""}]
[]
[{"$f":"IF($E$87=\"CMU Single Wythe with a finish on both sides\", \"Fire Side - Finish #2\",\"\")","v":"Fire Side - Finish #2"},null,null,null,"Gypsum-Sand Plaster on 3/8 in. gypsum lath",{"$f":"IFERROR('Fire Resistance Rating'!$E$237,1)","v":0.58333333333333337},{"$f":"IF(F113=1,\"This combination is not possible.\nPlease see Tables 4, 5, and 6 of the instruction guide for a list of possible combinations.\",\"\")","v":""}]
[null,null,null,null,"1/2 in."]
[null,null,null,{"$f":"IF($E$113=\"Direct Applied Portland Cement\",\"Enter Plaster Thickness (in.)\",\"\")","v":""},null,null,{"$f":"IF(AND($E$87=\"CMU Single Wythe with a finish on both sides\",$E$96=\"Gypsum Vermiculite or Perlite Plaster\"),\"Fire Side Finish Calculations cannot be properly performed with \ncurrent finish selection. \nThe calculator will assume no finish is present.\",\"\")","v":""}]
[]
[]
["Step 4: Detail Checks"]
["Does thickness #1 non-fire side and fire side match?",null,null,null,{"$f":"IF(E90=\"Gypsum Vermiculite or Perlite Plaster\",\"N/A\",IF(E102=E110,\"Yes\",IF(AND(E110=\"Direct Applied\",F101=E111),\"Yes\",\"Change thicknesses to match\")))","v":"Yes"}]
[{"$f":"IF(E87=\"CMU Single Wythe with a finish on both sides\",\"Does thickness #2 non-fire side and fire side match?\",\"\")","v":"Does thickness #2 non-fire side and fire side match?"},null,null,null,{"$f":"IF(AND(E87=\"CMU Single Wythe with a finish on both sides\",E96=\"Gypsum Vermiculite or Perlite Plaster\"),\"N/A\",IF(E104=E114,\"Yes\",IF(AND(E114=\"Direct Applied\",F104=E115),\"Yes\",\"Change thicknesses to match\")))","v":"Yes"}]
["Does the non-fire finish and fire side finish for finish #1 match?",null,null,null,{"$f":"IF(AND(E90=\"Portland Cement Sand Plaster\",OR(E109=\"Direct Applied Portland Cement\",E109=\"Portland Cement-Sand Plaster on Metal Lath\")),\"Yes\",IF(AND(E90=\"Gypsum Sand Plaster\",OR(E109=\"Gypsum-Sand Plaster on 3/8 in. gypsum lath\",E109=\"Gypsum-Sand Plaster on Metal Lath\")),\"Yes\",IF(AND(E90=\"Gypsum Wallboard\",OR(E109=\"Gypsum Wallboard\",E109=\"Type 'X' Gypsum Wallboard\")),\"Yes\",IF(E90=\"Gypsum Vermiculite or Perlite Plaster\",\"N/A\",\"Adjust non-fire/fire side finishes to make them matching\"))))","v":"Yes"}]
[{"$f":"IF(E87=\"CMU Single Wythe with a finish on both sides\",\"Does the non-fire finish and fire side finish for finish #2 match?\",\"\")","v":"Does the non-fire finish and fire side finish for finish #2 match?"},null,null,null,{"$f":"IF(AND(E96=\"Portland Cement Sand Plaster\",OR(E113=\"Direct Applied Portland Cement\",E113=\"Portland Cement-Sand Plaster on Metal Lath\")),\"Yes\",IF(AND(E96=\"Gypsum Sand Plaster\",OR(E113=\"Gypsum-Sand Plaster on 3/8 in. gypsum lath\",E113=\"Gypsum-Sand Plaster on Metal Lath\")),\"Yes\",IF(AND(E96=\"Gypsum Wallboard\",OR(E113=\"Gypsum Wallboard\",E113=\"Type 'X' Gypsum Wallboard\")),\"Yes\",IF(E96=\"Gypsum Vermiculite or Perlite Plaster\",\"N/A\",\"Adjust non-fire/fire side finishes to make them matching\"))))","v":"Yes"}]
["Does the CMU contribute equal to or more than half of the total fire rating?",null,null,null,{"$f":"IF(AND(#REF!=\"Yes\",E183>0.5*#REF!),\"Yes\",IF(#REF!=\"No\",OR(E183>0.5*E268,E183>0.5*E233),\"No, the selected CMU does meet IBC codes.\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'Fire Resistance Rating'!$C$16","v":"Max/Min Equivalent Thickness Check"},"Fire Rating"]
[{"$f":"$A$18","v":"Calcareous or Siliceous Gravel"},null,{"$f":"IF('Fire Resistance Rating'!$E$155>'Fire Resistance Lookup Graph'!B3,'Fire Resistance Lookup Graph'!B3,IF('Fire Resistance Rating'!$E$155<'Fire Resistance Lookup Graph'!P3,'Fire Resistance Lookup Graph'!P3,'Fire Resistance Rating'!$E$155))","v":6.2},{"$f":"0.0765*C125^2+0.1955*C125-0.1732","v":3.9795600000000007}]
[{"$f":"$A$19","v":"Limestone, Cinders or Unexpanded Slag"},null,{"$f":"IF('Fire Resistance Rating'!$E$155>'Fire Resistance Lookup Graph'!B4,'Fire Resistance Lookup Graph'!B4,IF('Fire Resistance Rating'!$E$155<'Fire Resistance Lookup Graph'!P4,'Fire Resistance Lookup Graph'!P4,'Fire Resistance Rating'!$E$155))","v":5.9},{"$f":"0.0839*C126^2+0.219*C126-0.2133","v":3.9993590000000006}]
[{"$f":"$A$20","v":"Expanded clay, shale, or slate"},null,{"$f":"IF('Fire Resistance Rating'!$E$155>'Fire Resistance Lookup Graph'!B5,'Fire Resistance Lookup Graph'!B5,IF('Fire Resistance Rating'!$E$155<'Fire Resistance Lookup Graph'!P5,'Fire Resistance Lookup Graph'!P5,'Fire Resistance Rating'!$E$155))","v":5.0999999999999996},{"$f":"0.1668*C127^2-0.0765*C127+0.0839","v":4.0322180000000003}]
[{"$f":"$A$21","v":"Expanded slag or pumice"},null,{"$f":"IF('Fire Resistance Rating'!$E$155>'Fire Resistance Lookup Graph'!B6,'Fire Resistance Lookup Graph'!B6,IF('Fire Resistance Rating'!$E$155<'Fire Resistance Lookup Graph'!P6,'Fire Resistance Lookup Graph'!P6,'Fire Resistance Rating'!$E$155))","v":4.7},{"$f":"0.1389*C128^2+0.2342*C128-0.1647","v":4.0043410000000002}]
[null,null,"Fire Rating of Finish Alone",{"$f":"($E$18*D125+$E$19*D126+E20*D127+$E$21*D128)/100","v":3.9986036999999999}]

{"sheet":"Fire Resistance Rating","index":2,"n_rows":250,"n_cols":10,"rows_kept":250,"cut":false,"hidden":false,"merged":[[0,7,0,10],[1,7,1,10],[2,7,2,10],[3,7,3,10],[136,7,136,10],[66,7,66,10],[67,7,67,10],[68,7,68,10],[69,7,69,10],[78,0,78,10],[89,1,89,3],[12,0,12,10],[24,3,24,6],[6,3,6,5],[97,1,97,3],[72,3,72,5],[143,4,143,7],[144,4,144,7],[152,1,152,2],[154,1,154,2],[156,1,156,2],[143,2,144,3],[145,2,146,3],[201,7,201,10],[202,7,202,10],[203,7,203,10],[200,7,200,10],[148,3,148,6],[149,0,149,10],[158,1,158,2],[170,1,170,2],[172,1,172,2],[168,1,168,2],[247,1,247,2],[217,0,217,10],[213,4,213,7],[214,4,214,7],[211,4,211,7],[212,4,212,7],[231,1,231,2],[233,1,233,2],[223,1,223,2],[222,1,222,2],[225,1,225,2],[216,3,216,6],[249,1,249,2],[240,1,240,2],[241,1,241,2],[14,1,14,3],[21,1,21,3],[82,1,82,3],[80,1,80,3],[238,1,238,2],[239,1,239,2],[220,1,220,2],[165,1,165,2],[142,2,142,7],[211,2,212,3],[213,2,214,3],[236,1,236,2],[224,1,224,2],[99,1,99,3],[146,4,146,7],[145,4,145,7],[8,3,8,4],[7,3,7,4],[9,3,9,4],[10,3,10,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[104,3,104,6],[137,7,137,10],[138,7,138,10],[101,1,101,3],[139,7,139,10],[206,2,206,7],[207,2,208,3],[207,4,207,7],[208,4,208,7],[209,2,210,3],[209,4,209,7],[210,4,210,7]]}
[null,null,null,null,null,null,"Date:",{"$f":"'Fire Resistance '!E1","v":"00:00:00"}]
[null,null,null,null,null,null,"Project Name:",{"$f":"'Fire Resistance '!E2","v":0}]
[null,null,null,null,null,null,"Project Number:",{"$f":"'Fire Resistance '!E3","v":0}]
[null,null,null,null,null,null,"Unit Description:",{"$f":"'Fire Resistance '!E4","v":0}]
[]
[]
[null,null,null,"Unit Composition"]
[null,null,null,"Calcareous or Siliceous Gravel",null,{"$f":"'Fire Resistance '!E18/100","v":0.35}]
[null,null,null,"Limestone, Cinders or Unexpanded Slag","Limestone, Cinders or Unexpanded Slag",{"$f":"'Fire Resistance '!E19/100","v":0.25}]
[null,null,null,"Expanded clay, shale, or slate","Expanded clay, shale, or slate",{"$f":"'Fire Resistance '!E20/100","v":0.15}]
[null,null,null,"Expanded slag or pumice","Expanded slag or pumice",{"$f":"'Fire Resistance '!E21/100","v":0.25}]
[]
["Fire Rating Based on Composition - Single Wythe CMU"]
[]
[null,"Equivalent Thickness of Unit",null,null,{"$f":"'Fire Resistance '!E14","v":8},"in."]
[null,null,"Max/Min Equivalent Thickness Check","Fire Rating"]
[{"$f":"'Fire Resistance '!$A$18","v":"Calcareous or Siliceous Gravel"},null,{"$f":"IF($E$15>'Fire Resistance Lookup Graph'!$B$3,'Fire Resistance Lookup Graph'!$B$3,IF($E$15<'Fire Resistance Lookup Graph'!$P$3,'Fire Resistance Lookup Graph'!$P$3,$E$15))","v":6.2},{"$f":"0.0765*C17^2+0.1955*C17-0.1732","v":3.9795600000000007}]
[{"$f":"'Fire Resistance '!$A$19","v":"Limestone, Cinders or Unexpanded Slag"},null,{"$f":"IF($E$15>'Fire Resistance Lookup Graph'!$B$4,'Fire Resistance Lookup Graph'!$B$4,IF($E$15<'Fire Resistance Lookup Graph'!$P$4,'Fire Resistance Lookup Graph'!$P$4,$E$15))","v":5.9},{"$f":"0.0839*C18^2+0.219*C18-0.2133","v":3.9993590000000006}]
[{"$f":"'Fire Resistance '!$A$20","v":"Expanded clay, shale, or slate"},null,{"$f":"IF($E$15>'Fire Resistance Lookup Graph'!$B$5,'Fire Resistance Lookup Graph'!$B$5,IF($E$15<'Fire Resistance Lookup Graph'!$P$5,'Fire Resistance Lookup Graph'!$P$5,$E$15))","v":5.0999999999999996},{"$f":"0.1668*C19^2-0.0765*C19+0.0839","v":4.0322180000000003}]
[{"$f":"'Fire Resistance '!$A$21","v":"Expanded slag or pumice"},null,{"$f":"IF($E$15>'Fire Resistance Lookup Graph'!$B$6,'Fire Resistance Lookup Graph'!$B$6,IF($E$15<'Fire Resistance Lookup Graph'!$P$6,'Fire Resistance Lookup Graph'!$P$6,$E$15))","v":4.7},{"$f":"0.1389*C20^2+0.2342*C20-0.1647","v":4.0043410000000002}]
[]
[null,"Fire Rating of Unit",null,null,{"$f":"('Fire Resistance '!E18*D17+'Fire Resistance '!E19*D18+'Fire Resistance '!E20*D19+'Fire Resistance '!E21*D20)/100","v":3.9986036999999999},"hours"]
[]
[]
[null,null,null,"The following fire rating calculations were based off of ACI 216/1/TMS 216"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Date:",{"$f":"H1","v":"00:00:00"}]
[null,null,null,null,null,null,"Project Name:",{"$f":"H2","v":0}]
[null,null,null,null,null,null,"Project Number:",{"$f":"H3","v":0}]
[null,null,null,null,null,null,"Unit Description:",{"$f":"H4","v":0}]
[]
[]
[null,null,null,"Unit Wythe Composition"]
[null,null,null,"Calcareous or Siliceous Gravel",null,{"$f":"$F8","v":0.35}]
[null,null,null,"Limestone, Cinders or Unexpanded Slag","Limestone, Cinders or Unexpanded Slag",{"$f":"$F9","v":0.25}]
[null,null,null,"Expanded clay, shale, or slate","Expanded clay, shale, or slate",{"$f":"$F10","v":0.15}]
[null,null,null,"Expanded slag or pumice","Expanded slag or pumice",{"$f":"$F11","v":0.25}]
[]
["Fire Rating Based on Multi-Wythe - Brick and CMU"]
[]
[null,"Fire Rating of Unit",null,null,{"$f":"'Fire Resistance Rating'!$E$22","v":3.9986036999999999},"hours"]
[]
[null,{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>=2,OR('Fire Resistance '!$E$30=\"Clay / CMU / Clay\",'Fire Resistance '!$E$29=\"Clay / CMU\",'Fire Resistance '!$E$30=\"Clay / CMU / CMU\")),\"Equivalent Thickness for Clay Wythe #1\",IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>=2,OR('Fire Resistance '!$E$30=\"CMU / CMU / CMU\",'Fire Resistance '!$E$29=\"CMU / CMU\")),\"Equivalent Thickness for CMU Wythe #1\",IF(AND('Fire Resistance '!$E$31=\"Fire Rating\",'Fire Resistance '!$E$28>=2,OR('Fire Resistance '!$E$30=\"Clay / CMU / Clay\",'Fire Resistance '!$E$29=\"Clay / CMU\",'Fire Resistance '!$E$30=\"Clay / CMU / CMU\")),\"Fire Rating for clay Wythe #1\",\"Fire Rating for CMU Wythe #1\")))","v":"Equivalent Thickness for Clay Wythe #1"},null,null,{"$f":"'Fire Resistance '!$E$33","v":3},{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>=2), \"in.\", \"hours\")","v":"in."}]
[null,null,"Max/Min Equivalent Thickness Check - CMU #1","Fire Rating - CMU #1","Max/Min Equivalent Thickness Check - CMU #2","Fire Rating - CMU #2"]
[{"$f":"'Fire Resistance '!$A$18","v":"Calcareous or Siliceous Gravel"},null,{"$f":"IF($E$83>'Fire Resistance Lookup Graph'!$B$3,'Fire Resistance Lookup Graph'!$B$3,IF($E$83<'Fire Resistance Lookup Graph'!$P$3,'Fire Resistance Lookup Graph'!$P$3,$E$83))","v":3},{"$f":"0.0765*C85^2+0.1955*C85-0.1732","v":1.1017999999999999},{"$f":"IF($E$90>'Fire Resistance Lookup Graph'!$B$3,'Fire Resistance Lookup Graph'!$B$3,IF($E$90<'Fire Resistance Lookup Graph'!$P$3,'Fire Resistance Lookup Graph'!$P$3,$E$90))","v":6.2},{"$f":"0.0765*E85^2+0.1955*E85-0.1732","v":3.9795600000000007}]
[{"$f":"'Fire Resistance '!$A$19","v":"Limestone, Cinders or Unexpanded Slag"},null,{"$f":"IF($E$83>'Fire Resistance Lookup Graph'!$B$4,'Fire Resistance Lookup Graph'!$B$4,IF($E$83<'Fire Resistance Lookup Graph'!$P$4,'Fire Resistance Lookup Graph'!$P$4,$E$83))","v":3},{"$f":"0.0839*C86^2+0.219*C86-0.2133","v":1.1988000000000001},{"$f":"IF($E$90>'Fire Resistance Lookup Graph'!$B$4,'Fire Resistance Lookup Graph'!$B$4,IF($E$90<'Fire Resistance Lookup Graph'!$P$4,'Fire Resistance Lookup Graph'!$P$4,$E$90))","v":5.9},{"$f":"0.0839*E86^2+0.219*E86-0.2133","v":3.9993590000000006}]
[{"$f":"'Fire Resistance '!$A$20","v":"Expanded clay, shale, or slate"},null,{"$f":"IF($E$83>'Fire Resistance Lookup Graph'!$B$5,'Fire Resistance Lookup Graph'!$B$5,IF($E$83<'Fire Resistance Lookup Graph'!$P$5,'Fire Resistance Lookup Graph'!$P$5,$E$83))","v":3},{"$f":"0.1668*C87^2-0.0765*C87+0.0839","v":1.3556000000000001},{"$f":"IF($E$90>'Fire Resistance Lookup Graph'!$B$5,'Fire Resistance Lookup Graph'!$B$5,IF($E$90<'Fire Resistance Lookup Graph'!$P$5,'Fire Resistance Lookup Graph'!$P$5,$E$90))","v":5.0999999999999996},{"$f":"0.1668*E87^2-0.0765*E87+0.0839","v":4.0322180000000003}]
[{"$f":"'Fire Resistance '!$A$21","v":"Expanded slag or pumice"},null,{"$f":"IF($E$83>'Fire Resistance Lookup Graph'!$B$6,'Fire Resistance Lookup Graph'!$B$6,IF($E$83<'Fire Resistance Lookup Graph'!$P$6,'Fire Resistance Lookup Graph'!$P$6,$E$83))","v":3},{"$f":"0.1389*C88^2+0.2342*C88-0.1647","v":1.788},{"$f":"IF($E$90>'Fire Resistance Lookup Graph'!$B$6,'Fire Resistance Lookup Graph'!$B$6,IF($E$90<'Fire Resistance Lookup Graph'!$P$6,'Fire Resistance Lookup Graph'!$P$6,$E$90))","v":4.7},{"$f":"0.1389*E88^2+0.2342*E88-0.1647","v":4.0043410000000002}]
[]
[null,{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>2,OR('Fire Resistance '!$E$30=\"Clay / CMU / Clay\",'Fire Resistance '!$E$29=\"Clay / CMU\")),\"Equivalent Thickness for Clay Wythe #2\",IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>2,OR('Fire Resistance '!$E$30=\"CMU / CMU / CMU\",'Fire Resistance '!$E$29=\"CMU / CMU\",'Fire Resistance '!$E$30=\"Clay / CMU / CMU\")),\"Equivalent Thickness for CMU Wythe #1\",IF(AND('Fire Resistance '!$E$31=\"Fire Rating\",'Fire Resistance '!$E$28>2,OR('Fire Resistance '!$E$30=\"Clay / CMU / Clay\",'Fire Resistance '!$E$29=\"Clay / CMU\")),\"Fire Rating for clay Wythe #2\",IF(AND('Fire Resistance '!$E$31=\"Fire Rating\",'Fire Resistance '!$E$28>2,OR('Fire Resistance '!$E$30=\"CMU / CMU / CMU\",'Fire Resistance '!$E$29=\"CMU / CMU\",'Fire Resistance '!$E$30=\"Clay / CMU / CMU\")),\"Fire Rating for CMU Wythe #2\",\"\"))))","v":""},null,null,{"$f":"IF('Fire Resistance '!$E$28>2,'Fire Resistance '!$E$34,\"\")","v":""},{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>2), \"in.\",IF(AND('Fire Resistance '!$E$31=\"Fire Rating\",'Fire Resistance '!$E$28>2),\"hours\",\"\"))","v":""}]
[]
[null,null,"Wythe #1 - Max/Min Equiv. Thickness Check","Wythe #1 - Fire Rating","Wythe #2 - Max/Min Equiv. Thickness Check","Wythe #2 - Fire Rating"]
[">=75% Solid",null,{"$f":"IF($E$83>'Fire Resistance Lookup Graph'!$B$47,'Fire Resistance Lookup Graph'!$B$47,IF($E$83<'Fire Resistance Lookup Graph'!$E$47,'Fire Resistance Lookup Graph'!$E$47,$E$83))","v":3},{"$f":"-2*10^-15*$C$93+0.9091*$C$93-1.4545","v":1.2727999999999939},{"$f":"IF($E$90>'Fire Resistance Lookup Graph'!$B$47,'Fire Resistance Lookup Graph'!$B$47,IF($E$90<'Fire Resistance Lookup Graph'!$E$47,'Fire Resistance Lookup Graph'!$E$47,$E$90))","v":6},{"$f":"-2*10^-15*$E$93+0.9091*$E$93-1.4545","v":4.0000999999999873}]
["Hollow",null,{"$f":"IF($E$83>'Fire Resistance Lookup Graph'!$B$48,'Fire Resistance Lookup Graph'!$B$48,IF($E$83<'Fire Resistance Lookup Graph'!$E$48,'Fire Resistance Lookup Graph'!$E$48,$E$83))","v":3},{"$f":"0.1367*$C$94^2+0.1072*$C$94+0.0354","v":1.5872999999999999},{"$f":"IF($E$90>'Fire Resistance Lookup Graph'!$B$48,'Fire Resistance Lookup Graph'!$B$48,IF($E$90<'Fire Resistance Lookup Graph'!$E$48,'Fire Resistance Lookup Graph'!$E$48,$E$90))","v":5},{"$f":"0.1367*$E$94^2+0.1072*$E$94+0.0354","v":3.9888999999999997}]
["Grouted",null,{"$f":"IF($E$83>'Fire Resistance Lookup Graph'!$B$49,'Fire Resistance Lookup Graph'!$B$49,IF($E$83<'Fire Resistance Lookup Graph'!$E$49,'Fire Resistance Lookup Graph'!$E$49,$E$83))","v":3},{"$f":"0.0444*$C$95^2+0.4127*$C$95-0.6455","v":0.99219999999999997},{"$f":"IF($E$90>'Fire Resistance Lookup Graph'!$B$49,'Fire Resistance Lookup Graph'!$B$49,IF($E$90<'Fire Resistance Lookup Graph'!$E$49,'Fire Resistance Lookup Graph'!$E$49,$E$90))","v":6.6},{"$f":"0.0444*$E$95^2+0.4127*$E$95-0.6455","v":4.0123839999999991}]
[]
[]
[null,{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>=2,OR('Fire Resistance '!$E$30=\"Clay / CMU / Clay\",'Fire Resistance '!$E$29=\"Clay / CMU\",'Fire Resistance '!$E$30=\"Clay / CMU / CMU\")),\"Fire Rating for Clay Wythe #1\",IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>=2,OR('Fire Resistance '!$E$30=\"CMU / CMU / CMU\",'Fire Resistance '!$E$29=\"CMU / CMU\")),\"Fire Rating for CMU Wythe #1\",\"\"))","v":"Fire Rating for Clay Wythe #1"},null,null,{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>=2, $B$98=\"Fire Rating for Clay Wythe #1\"), INDEX($D$93:$D$95,MATCH('Fire Resistance '!$E$37,$A$93:$A$95,0)),('Fire Resistance '!E42*D85+'Fire Resistance '!E43*D86+'Fire Resistance '!E44*D87+'Fire Resistance '!E45*D88)/100)","v":1.2727999999999939},{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>=2), \"hours\",\"\")","v":"hours"}]
[]
[null,{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>2,OR('Fire Resistance '!$E$30=\"Clay / CMU / Clay\",'Fire Resistance '!$E$29=\"Clay / CMU\")),\"Fire Rating for Clay Wythe #2\",IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>2,OR('Fire Resistance '!$E$30=\"CMU / CMU / CMU\",'Fire Resistance '!$E$29=\"CMU / CMU\",'Fire Resistance '!$E$30=\"Clay / CMU / CMU\")),\"Fire Rating for CMU Wythe #2\",\"\"))","v":""},null,null,{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>2,$B$100=\"Fire Rating for Clay Wythe #2\"),INDEX($F$93:$F$95,MATCH('Fire Resistance '!$E$38,$A$93:$A$95,0)),('Fire Resistance '!E49*F85+'Fire Resistance '!E50*F86+'Fire Resistance '!E51*F87+'Fire Resistance '!E52*F88)/100)","v":0},{"$f":"IF(AND('Fire Resistance '!$E$31=\"Equivalent Thickness\",'Fire Resistance '!$E$28>2), \"hours\",\"\")","v":""}]
[]
[null,"Fire Rating of Assembly ",null,null,{"$f":"IF(AND('Fire Resistance '!E31=\"Equivalent Thickness\",'Fire Resistance '!E28=2),IF(SUM(E81^0.59,E98^0.59,0.3*('Fire Resistance '!E28-1))^1.7>4,4,SUM(E81^0.59,E98^0.59,0.3*('Fire Resistance '!E28-1))^1.7),IF(AND('Fire Resistance '!E31=\"Equivalent Thickness\",'Fire Resistance '!E28=3),IF(SUM(E81^0.59,E98^0.59,E100^0.59,0.3*('Fire Resistance '!E28-1))^1.7>4,4,SUM(E81^0.59,E98^0.59,E100^0.59,0.3*('Fire Resistance '!E28-1))^1.7),IF(AND('Fire Resistance '!E31=\"Fire Rating\",'Fire Resistance '!E28=2),IF(SUM(E81^0.59,E83^0.59,0.3*('Fire Resistance '!E28-1))^1.7>4,4,SUM(E81^0.59,E83^0.59,0.3*('Fire Resistance '!E28-1))^1.7),IF(SUM(E81^0.59,E83^0.59,E90^0.59,0.3*('Fire Resistance '!E28-1))^1.7>4,4,SUM(E81^0.59,E83^0.59,E90^0.59,0.3*('Fire Resistance '!E28-1))^1.7))))","v":4},"hours"]
[]
[]
[null,null,null,"The following fire rating calculations were based off of ACI 216/1/TMS 216"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Date",{"$f":"H1","v":"00:00:00"},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Project Name:",{"$f":"H2","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Project Number:",{"$f":"H3","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Unit Description:",{"$f":"H4","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Finishes"]
[null,null,"Side #1 - Fire Side",null,{"$f":"'Fire Resistance '!E109","v":"Portland Cement-Sand Plaster on Metal Lath"}]
[null,null,null,null,{"$f":"'Fire Resistance '!E110","v":"3/8 in."}]
[null,null,"Side #1 - Non-Fire Side",null,{"$f":"'Fire Resistance '!E90","v":"Portland Cement Sand Plaster"}]
[null,null,null,null,{"$f":"'Fire Resistance '!E91","v":"Siliceous_Calcareous_Limestone_Cinders_Air Cooled Blast Furnace Slag"}]
[]
[null,null,null,"The following fire rating calculations were based off of ACI 216/1/TMS 216"]
["Fire Rating Based on Finishes - Single Wythe CMU with Finish on one side"]
[]
[null,"Non-Fire Side"]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"Non-Fire Side Finish Factor\")","v":""},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",IF('Fire Resistance '!E90=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance Loop Tables'!D20,IF('Fire Resistance '!E92=\"Yes\",'Fire Resistance Loop Tables'!D20,INDEX('Fire Resistance Loop Tables'!$C$5:$D$19,MATCH('Fire Resistance '!$E$90&'Fire Resistance '!$E$101,'Fire Resistance Loop Tables'!$A$5:$A$19&'Fire Resistance Loop Tables'!B5:B19,0),MATCH('Fire Resistance '!$E$91,'Fire Resistance Loop Tables'!$C$4:$D$4,0)))))","v":""}]
[]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"Non-Fire Side Finish #1 Equivalent Thickness\")","v":""},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",IF(OR('Fire Resistance '!E90=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!E92=\"Yes\"),'Fire Resistance '!E102*$E$153,$E$153*'Fire Resistance '!F101))","v":""},{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"in.\")","v":""}]
[]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"Equivalent Thickness of Unit\")","v":""},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",E15)","v":""},{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"in.\")","v":""}]
[]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"Total Equivalent Thickness\")","v":""},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",SUM(E155,E157))","v":""},{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"in.\")","v":""}]
[]
[null,null,{"$f":"$C$16","v":"Max/Min Equivalent Thickness Check"},"Fire Rating"]
[{"$f":"'Fire Resistance '!$A$18","v":"Calcareous or Siliceous Gravel"},null,{"$f":"IF($E$159>'Fire Resistance Lookup Graph'!$B3,'Fire Resistance Lookup Graph'!$B3,IF($E$159<'Fire Resistance Lookup Graph'!$P3,'Fire Resistance Lookup Graph'!$P3,$E$159))","v":6.2},{"$f":"0.0765*C162^2+0.1955*C162-0.1732","v":3.9795600000000007}]
[{"$f":"'Fire Resistance '!$A$19","v":"Limestone, Cinders or Unexpanded Slag"},null,{"$f":"IF($E$159>'Fire Resistance Lookup Graph'!$B4,'Fire Resistance Lookup Graph'!$B4,IF($E$159<'Fire Resistance Lookup Graph'!$P4,'Fire Resistance Lookup Graph'!$P4,$E$159))","v":5.9},{"$f":"0.0839*C163^2+0.219*C163-0.2133","v":3.9993590000000006}]
[{"$f":"'Fire Resistance '!$A$20","v":"Expanded clay, shale, or slate"},null,{"$f":"IF($E$159>'Fire Resistance Lookup Graph'!$B5,'Fire Resistance Lookup Graph'!$B5,IF($E$159<'Fire Resistance Lookup Graph'!$P5,'Fire Resistance Lookup Graph'!$P5,$E$159))","v":5.0999999999999996},{"$f":"0.1668*C164^2-0.0765*C164+0.0839","v":4.0322180000000003}]
[{"$f":"'Fire Resistance '!$A$21","v":"Expanded slag or pumice"},null,{"$f":"IF($E$159>'Fire Resistance Lookup Graph'!$B6,'Fire Resistance Lookup Graph'!$B6,IF($E$159<'Fire Resistance Lookup Graph'!$P6,'Fire Resistance Lookup Graph'!$P6,$E$159))","v":4.7},{"$f":"0.1389*C165^2+0.2342*C165-0.1647","v":4.0043410000000002}]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"Total Non-Fire Side Fire Rating of Unit\")","v":""},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with finish on one (1) side\",IF(('Fire Resistance '!E18*D162+'Fire Resistance '!E19*D163+'Fire Resistance '!E20*D164+'Fire Resistance '!E21*D165)/100>4,4,SUM('Fire Resistance '!E18*D162+'Fire Resistance '!E19*D163+'Fire Resistance '!E20*D164+'Fire Resistance '!E21*D165)/100),\"\")","v":""},{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"hours\")","v":""}]
[]
[null,"Fire Side"]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"Fire Side Finish #1 Fire Rating\")","v":""},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",IF('Fire Resistance '!E90=\"Gypsum Vermiculite or Perlite Plaster\",0,INDEX('Fire Resistance Loop Tables'!C23:C40,MATCH('Fire Resistance '!$E$109&'Fire Resistance '!E110,'Fire Resistance Loop Tables'!A23:A40&'Fire Resistance Loop Tables'!B23:B40,0))))","v":""},{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"hours\")","v":""}]
[]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"Fire Rating of Unit\")","v":""},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",IF('Fire Resistance '!E90=\"Gypsum Vermiculite or Perlite Plaster\",E81,IF('Fire Resistance '!E110=\"Direct Applied\",\"Accounted for in Fire Side Finish #1 Fire Rating\",E81)))","v":""},{"$f":"IF(OR(E171=\"Accounted for in Fire Side Finish #1 Fire Rating\",'Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\"),\"\",\"hours\")","v":""}]
[]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"Total Fire Side Fire Rating of Unit\")","v":""},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with finish on one (1) side\",IF(SUM(E169,E171)>4,4,SUM(E169,E171)),\"\")","v":""},{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"\",\"hours\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Date",{"$f":"H137","v":"00:00:00"},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Project Name:",{"$f":"H138","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Project Number:",{"$f":"H139","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Unit Description:",{"$f":"H140","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Finishes"]
[null,null,"Side #1 - Fire Side",null,{"$f":"E144","v":"Portland Cement-Sand Plaster on Metal Lath"}]
[null,null,null,null,{"$f":"E145","v":"3/8 in."}]
[null,null,"Side #1 - Non-Fire Side",null,"Portland Cement Sand Plaster"]
[null,null,null,null,"Siliceous_Calcareous_Limestone_Cinders_Air Cooled Blast Furnace Slag"]
[null,null,"Side #2 - Fire Side",null,{"$f":"'Fire Resistance '!$E$113","v":"Gypsum-Sand Plaster on 3/8 in. gypsum lath"}]
[null,null,null,null,{"$f":"'Fire Resistance '!$E$114","v":"1/2 in."}]
[null,null,"Side #2 - Non-Fire Side",null,{"$f":"'Fire Resistance '!$E$96","v":"Gypsum Sand Plaster"}]
[null,null,null,null,{"$f":"'Fire Resistance '!$E$97","v":"Siliceous_Calcareous_Limestone_Cinders_Air Cooled Blast Furnace Slag"}]
[]
[null,null,null,"The following fire rating calculations were based off of ACI 216/1/TMS 216"]
[{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Fire Rating Based on Finishes - Both Sides\",\"\")","v":"Fire Rating Based on Finishes - Both Sides"}]
[]
[null,"Fire on Finish #1 Side"]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Fire Side Finish #1 Fire Rating\",\"\")","v":"Fire Side Finish #1 Fire Rating"},null,null,{"$f":"IF(ISNUMBER('Fire Resistance Loop Tables'!C114),'Fire Resistance Loop Tables'!C114,0)","v":0},{"$f":"IF(AND('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",'Fire Resistance '!E92=\"Yes\",'Fire Resistance '!E96=\"Gypsum Vermiculite or Perlite Plaster\"),\"\",\"hours\")","v":"hours"}]
[]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Non-Fire Side Finish #2 Factor\",\"\")","v":"Non-Fire Side Finish #2 Factor"},null,null,{"$f":"IF(AND('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",OR('Fire Resistance '!E96=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!E98=\"Yes\")),'Fire Resistance Loop Tables'!D74,INDEX('Fire Resistance Loop Tables'!$C$59:$D$68,MATCH('Fire Resistance '!$E$96&'Fire Resistance '!$E$104,'Fire Resistance Loop Tables'!$A$59:$A$73&'Fire Resistance Loop Tables'!$B$59:$B$73,0),MATCH('Fire Resistance '!$E$97,'Fire Resistance Loop Tables'!$C$58:$D$58,0)))","v":1.25}]
[null,{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"Non-Fire Side Finish #2 Equivalent Thickness\",\"\")","v":"Non-Fire Side Finish #2 Equivalent Thickness"},null,null,{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",IF(AND('Fire Resistance '!$E$90=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!$E$98=\"Yes\"),'Fire Resistance '!E105*'Fire Resistance Rating'!E223,IF(AND('Fire Resistance '!E96=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!E92=\"Yes\"),'Fire Resistance Loop Tables'!B43+'Fire Resistance '!E105*'Fire Resistance Rating'!E223,IF('Fire Resistance '!$E$90=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!F104*'Fire Resistance Rating'!E223,IF('Fire Resistance '!E96=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!E105*E223,IF(OR('Fire Resistance '!E96=\"Portland Cement Sand Plaster\",'Fire Resistance '!E96=\"Gypsum Sand Plaster\",'Fire Resistance '!E96=\"Gypsum Wallboard\"),E223*'Fire Resistance '!F104,'Fire Resistance Loop Tables'!B98+'Fire Resistance '!E105*'Fire Resistance Rating'!E223))))))","v":0.625},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"in.\",\"\")","v":"in."}]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Equivalent Thickness of Unit\",\"\")","v":"Equivalent Thickness of Unit"},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",E15,\"\")","v":8},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"in.\",\"\")","v":"in."}]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Total Equivalent Thickness\",\"\")","v":"Total Equivalent Thickness"},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",SUM(E224,E225),\"\")","v":8.625},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"in.\",\"\")","v":"in."}]
[null,null,{"$f":"$C$16","v":"Max/Min Equivalent Thickness Check"},"Fire Rating"]
[{"$f":"'Fire Resistance '!$A$18","v":"Calcareous or Siliceous Gravel"},null,{"$f":"IF($E$226>'Fire Resistance Lookup Graph'!$B3,'Fire Resistance Lookup Graph'!$B3,IF($E$226<'Fire Resistance Lookup Graph'!$P3,'Fire Resistance Lookup Graph'!$P3,$E$226))","v":6.2},{"$f":"0.0765*C228^2+0.1955*C228-0.1732","v":3.9795600000000007}]
[{"$f":"'Fire Resistance '!$A$19","v":"Limestone, Cinders or Unexpanded Slag"},null,{"$f":"IF($E$226>'Fire Resistance Lookup Graph'!$B4,'Fire Resistance Lookup Graph'!$B4,IF($E$226<'Fire Resistance Lookup Graph'!$P4,'Fire Resistance Lookup Graph'!$P4,$E$226))","v":5.9},{"$f":"0.0839*C229^2+0.219*C229-0.2133","v":3.9993590000000006}]
[{"$f":"'Fire Resistance '!$A$20","v":"Expanded clay, shale, or slate"},null,{"$f":"IF($E$226>'Fire Resistance Lookup Graph'!$B5,'Fire Resistance Lookup Graph'!$B5,IF($E$226<'Fire Resistance Lookup Graph'!$P5,'Fire Resistance Lookup Graph'!$P5,$E$226))","v":5.0999999999999996},{"$f":"0.1668*C230^2-0.0765*C230+0.0839","v":4.0322180000000003}]
[{"$f":"'Fire Resistance '!$A$21","v":"Expanded slag or pumice"},null,{"$f":"IF($E$226>'Fire Resistance Lookup Graph'!$B6,'Fire Resistance Lookup Graph'!$B6,IF($E$226<'Fire Resistance Lookup Graph'!$P6,'Fire Resistance Lookup Graph'!$P6,$E$226))","v":4.7},{"$f":"0.1389*C231^2+0.2342*C231-0.1647","v":4.0043410000000002}]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Total Non-Fire Side Fire Rating of Unit\",\"\")","v":"Total Non-Fire Side Fire Rating of Unit"},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",('Fire Resistance '!E18*D228+'Fire Resistance '!E19*D229+'Fire Resistance '!E20*D230+'Fire Resistance '!E21*D231)/100,\"\")","v":3.9986036999999999},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"hours\",\"\")","v":"hours"}]
[]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Total Fire Rating of Unit\",\"\")","v":"Total Fire Rating of Unit"},null,null,{"$f":"IF(AND('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",'Fire Resistance '!E96=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!E92=\"Yes\"),E232,IF(E221+E232>4,4,SUM(E221,E232)))","v":3.9986036999999999},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"hours\",\"\")","v":"hours"}]
[]
[null,"Fire on Finish #2 Side"]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Fire Side Finish #2 Fire Rating\",\"\")","v":"Fire Side Finish #2 Fire Rating"},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",IF(AND('Fire Resistance '!E90=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!E98=\"Yes\"),\"Accounted for in thickness below\",IF('Fire Resistance '!E96=\"Gypsum Vermiculite or Perlite Plaster\",0,INDEX('Fire Resistance Loop Tables'!C77:C94,MATCH('Fire Resistance '!$E$113&'Fire Resistance '!E114,'Fire Resistance Loop Tables'!A77:A94&'Fire Resistance Loop Tables'!B77:B94,0)))))","v":0.58333333333333337},{"$f":"IF(AND('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",'Fire Resistance '!E98=\"Yes\",'Fire Resistance '!E90=\"Gypsum Vermiculite or Perlite Plaster\"),\"\",\"hours\")","v":"hours"}]
[]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Non-Fire Side Finish #1 Factor\",\"\")","v":"Non-Fire Side Finish #1 Factor"},null,null,{"$f":"IF(AND('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",'Fire Resistance '!$E$90=\"Gypsum Vermiculite and Perlite Plaster\"),'Fire Resistance Loop Tables'!$D$20,INDEX('Fire Resistance Loop Tables'!$C$5:$D$19,MATCH('Fire Resistance '!$E$90,'Fire Resistance Loop Tables'!$A$5:$A$19,0),MATCH('Fire Resistance '!$E$91,'Fire Resistance Loop Tables'!$C$4:$D$4,0)))","v":1}]
[null,{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"Non-Fire Side Finish #1 Equivalent Thickness\",\"\")","v":"Non-Fire Side Finish #1 Equivalent Thickness"},null,null,{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",IF(AND('Fire Resistance '!$E$90=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!$E$98=\"Yes\"),'Fire Resistance Loop Tables'!B98+'Fire Resistance '!E102*'Fire Resistance Rating'!E239,IF(AND('Fire Resistance '!E96=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!E92=\"Yes\"),'Fire Resistance '!E102*E239,IF('Fire Resistance '!$E$90=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!E102*'Fire Resistance Rating'!E239,'Fire Resistance '!F101*'Fire Resistance Rating'!E239))))","v":0.5},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"in.\",\"\")","v":"in."}]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Equivalent Thickness of Unit\",\"\")","v":"Equivalent Thickness of Unit"},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",E15,\"\")","v":8},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"in.\",\"\")","v":"in."}]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Total Equivalent Thickness\",\"\")","v":"Total Equivalent Thickness"},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",SUM(E240,E241),\"\")","v":8.5},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"in.\",\"\")","v":"in."}]
[null,null,{"$f":"$C$16","v":"Max/Min Equivalent Thickness Check"},"Fire Rating"]
[{"$f":"'Fire Resistance '!$A$18","v":"Calcareous or Siliceous Gravel"},null,{"$f":"IF($E$242>'Fire Resistance Lookup Graph'!$B3,'Fire Resistance Lookup Graph'!$B3,IF($E$242<'Fire Resistance Lookup Graph'!$P3,'Fire Resistance Lookup Graph'!$P3,$E$242))","v":6.2},{"$f":"0.0765*C244^2+0.1955*C244-0.1732","v":3.9795600000000007}]
[{"$f":"'Fire Resistance '!$A$19","v":"Limestone, Cinders or Unexpanded Slag"},null,{"$f":"IF($E$242>'Fire Resistance Lookup Graph'!$B4,'Fire Resistance Lookup Graph'!$B4,IF($E$242<'Fire Resistance Lookup Graph'!$P4,'Fire Resistance Lookup Graph'!$P4,$E$242))","v":5.9},{"$f":"0.0839*C245^2+0.219*C245-0.2133","v":3.9993590000000006}]
[{"$f":"'Fire Resistance '!$A$20","v":"Expanded clay, shale, or slate"},null,{"$f":"IF($E$242>'Fire Resistance Lookup Graph'!$B5,'Fire Resistance Lookup Graph'!$B5,IF($E$242<'Fire Resistance Lookup Graph'!$P5,'Fire Resistance Lookup Graph'!$P5,$E$242))","v":5.0999999999999996},{"$f":"0.1668*C246^2-0.0765*C246+0.0839","v":4.0322180000000003}]
[{"$f":"'Fire Resistance '!$A$21","v":"Expanded slag or pumice"},null,{"$f":"IF($E$242>'Fire Resistance Lookup Graph'!$B6,'Fire Resistance Lookup Graph'!$B6,IF($E$242<'Fire Resistance Lookup Graph'!$P6,'Fire Resistance Lookup Graph'!$P6,$E$242))","v":4.7},{"$f":"0.1389*C247^2+0.2342*C247-0.1647","v":4.0043410000000002}]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Total Non-Fire Side Fire Rating of Unit\",\"\")","v":"Total Non-Fire Side Fire Rating of Unit"},null,null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",('Fire Resistance '!E18*D244+'Fire Resistance '!E19*D245+'Fire Resistance '!E20*D246+'Fire Resistance '!E21*D247)/100,\"\")","v":3.9986036999999999},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"hours\",\"\")","v":"hours"}]
[]
[null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",\"Total Fire Rating of Unit\",\"\")","v":"Total Fire Rating of Unit"},null,null,{"$f":"IF(AND('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",'Fire Resistance '!E90=\"Gypsum Vermiculite or Perlite Plaster\", 'Fire Resistance '!E98=\"Yes\"),E248,IF(E237+E248>4,4,SUM(E237,E248)))","v":4},{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",\"hours\",\"\")","v":"hours"}]

{"sheet":"Fire Resistance Loop Tables","index":3,"n_rows":115,"n_cols":4,"rows_kept":115,"cut":false,"hidden":true,"merged":[[96,0,96,2],[2,2,2,3],[56,2,56,3],[41,0,41,2]]}
["Side 1"]
["Non-Fire Side"]
[null,"Finish","Aggregate Type"]
["Type",null,"Siliceous_Calcareous_Limestone_Cinders_Air Cooled Blast Furnace Slag","80% or more by volume of expanded shale_slate_clay_slag_pumice"]
["Portland Cement Sand Plaster","3/4 in.",1,{"$f":"IF(AND('Fire Resistance '!$E$92=\"Yes\",'Fire Resistance '!$E$102<5/8),1,IF(AND('Fire Resistance '!$E$93=100,'Fire Resistance '!$E$92=\"No\"),0.5,0.75))","v":0.75}]
["Portland Cement Sand Plaster","7/8 in. ",1,{"$f":"IF(AND('Fire Resistance '!$E$92=\"Yes\",'Fire Resistance '!$E$102<5/8),1,IF(AND('Fire Resistance '!$E$93=100,'Fire Resistance '!$E$92=\"No\"),0.5,0.75))","v":0.75}]
["Portland Cement Sand Plaster","1 in.",1,{"$f":"IF(AND('Fire Resistance '!$E$92=\"Yes\",'Fire Resistance '!$E$102<5/8),1,IF(AND('Fire Resistance '!$E$93=100,'Fire Resistance '!$E$92=\"No\"),0.5,0.75))","v":0.75}]
["Gypsum Sand Plaster","1/2 in.",1.25,1]
["Gypsum Sand Plaster","5/8 in.",1.25,1]
["Gypsum Sand Plaster","3/4 in.",1.25,1]
["Gypsum Sand Plaster","7/8 in. ",1.25,1]
["Gypsum Sand Plaster","1 in.",1.25,1]
["Gypsum Vermiculite or Perlite Plaster",null,1.75,1.25]
["Gypsum Wallboard","3/8 in.",3,2.25]
["Gypsum Wallboard","1/2 in.",3,2.25]
["Gypsum Wallboard","5/8 in.",3,2.25]
["Gypsum Wallboard","Two Layers of 3/8 in.",3,2.25]
["Gypsum Wallboard","One Layer of 3/8 in. and One layer of 1/2 in.",3,2.25]
["Gypsum Wallboard","Two layers of 1/2 in.",3,2.25]
[null,null,null,{"$f":"INDEX('Fire Resistance Loop Tables'!$C$5:$D$19,MATCH('Fire Resistance '!$E$90,'Fire Resistance Loop Tables'!$A$5:$A$19,0),MATCH('Fire Resistance '!$E$91,'Fire Resistance Loop Tables'!$C$4:$D$4,0))","v":1}]
["Fire Side"]
[null,"Finish","Time (hr)"]
["Gypsum Wallboard","3/8 in.",{"$f":"10/60","v":0.16666666666666666}]
["Gypsum Wallboard","1/2 in.",{"$f":"15/60","v":0.25}]
["Gypsum Wallboard","5/8 in.",{"$f":"20/60","v":0.33333333333333331}]
["Gypsum Wallboard","Two Layers of 3/8 in.",{"$f":"25/60","v":0.41666666666666669}]
["Gypsum Wallboard","One Layer of 3/8 in. and One layer of 1/2 in.",{"$f":"35/60","v":0.58333333333333337}]
["Gypsum Wallboard","Two layers of 1/2 in.",{"$f":"40/60","v":0.66666666666666663}]
["Type 'X' Gypsum Wallboard","1/2 in.",{"$f":"25/60","v":0.41666666666666669}]
["Type 'X' Gypsum Wallboard","5/8 in.",{"$f":"40/60","v":0.66666666666666663}]
["Direct Applied Portland Cement","Direct Applied",{"$f":"(C44*C49+C45*C50+C46*C51+C47*C52)/100","v":3.9986036999999999}]
["Portland Cement-Sand Plaster on Metal Lath","3/4 in.",{"$f":"20/60","v":0.33333333333333331}]
["Portland Cement-Sand Plaster on Metal Lath","7/8 in.",{"$f":"25/60","v":0.41666666666666669}]
["Portland Cement-Sand Plaster on Metal Lath","1 in.",{"$f":"30/60","v":0.5}]
["Gypsum-Sand Plaster on 3/8 in. gypsum lath","1/2 in.",{"$f":"35/60","v":0.58333333333333337}]
["Gypsum-Sand Plaster on 3/8 in. gypsum lath","5/8 in.",{"$f":"40/60","v":0.66666666666666663}]
["Gypsum-Sand Plaster on 3/8 in. gypsum lath","3/4 in.",{"$f":"50/60","v":0.83333333333333337}]
["Gypsum-Sand Plaster on Metal Lath","3/4 in.",{"$f":"50/60","v":0.83333333333333337}]
["Gypsum-Sand Plaster on Metal Lath","7/8 in.",{"$f":"60/60","v":1}]
["Gypsum-Sand Plaster on Metal Lath","1 in.",{"$f":"80/60","v":1.3333333333333333}]
[]
["DIRECT APPLIED FIRE RATING CALCULATION"]
["Fire Side Thickness",{"$f":"IF('Fire Resistance '!E111>5/8,5/8,'Fire Resistance '!E111)","v":0}]
["Calcareous or Siliceous Gravel",null,{"$f":"'Fire Resistance '!$E$18","v":35}]
["Limestone, Cinders or Unexpanded Slag",null,{"$f":"'Fire Resistance '!$E$19","v":25}]
["Expanded clay, shale, or slate",null,{"$f":"'Fire Resistance '!$E$20","v":15}]
["Expanded slag or pumice",null,{"$f":"'Fire Resistance '!$E$21","v":25}]
[null,"Max/Min Equivalent Thickness Check","Fire Rating"]
["Calcareous or Siliceous Gravel",{"$f":"IF(SUM($B$43+'Fire Resistance Rating'!$E$15)>'Fire Resistance Lookup Graph'!$B3,'Fire Resistance Lookup Graph'!$B3,IF(SUM($B$43+'Fire Resistance Rating'!$E$15)<'Fire Resistance Lookup Graph'!$P3,'Fire Resistance Lookup Graph'!$P3,SUM($B$43+'Fire Resistance Rating'!$E$15)))","v":6.2},{"$f":"0.0765*$B$49^2+0.1955*$B$49-0.1732","v":3.9795600000000007}]
["Limestone, Cinders or Unexpanded Slag",{"$f":"IF(SUM($B$43+'Fire Resistance Rating'!$E$15)>'Fire Resistance Lookup Graph'!$B4,'Fire Resistance Lookup Graph'!$B4,IF(SUM($B$43+'Fire Resistance Rating'!$E$15)<'Fire Resistance Lookup Graph'!$P4,'Fire Resistance Lookup Graph'!$P4,SUM($B$43+'Fire Resistance Rating'!$E$15)))","v":5.9},{"$f":"0.0839*$B$50^2+0.219*$B$50-0.2133","v":3.9993590000000006}]
["Expanded clay, shale, or slate",{"$f":"IF(SUM($B$43+'Fire Resistance Rating'!$E$15)>'Fire Resistance Lookup Graph'!$B5,'Fire Resistance Lookup Graph'!$B5,IF(SUM($B$43+'Fire Resistance Rating'!$E$15)<'Fire Resistance Lookup Graph'!$P5,'Fire Resistance Lookup Graph'!$P5,SUM($B$43+'Fire Resistance Rating'!$E$15)))","v":5.0999999999999996},{"$f":"0.1668*$B$51^2-0.0765*$B$51+0.0839","v":4.0322180000000003}]
["Expanded slag or pumice",{"$f":"IF(SUM($B$43+'Fire Resistance Rating'!$E$15)>'Fire Resistance Lookup Graph'!$B6,'Fire Resistance Lookup Graph'!$B6,IF(SUM($B$43+'Fire Resistance Rating'!$E$15)<'Fire Resistance Lookup Graph'!$P6,'Fire Resistance Lookup Graph'!$P6,SUM($B$43+'Fire Resistance Rating'!$E$15)))","v":4.7},{"$f":"0.1389*$B$52^2+0.2342*$B$52-0.1647","v":4.0043410000000002}]
[]
[]
["Side 2"]
["Non-Fire Side"]
[null,"Finish","Aggregate Type"]
["Type",null,"Siliceous_Calcareous_Limestone_Cinders_Air Cooled Blast Furnace Slag","80% or more by volume of expanded shale_slate_clay_slag_pumice"]
["Portland Cement Sand Plaster","3/4 in.",1,{"$f":"IF(AND('Fire Resistance '!E96=\"Portland Cement Sand Plaster\",'Fire Resistance '!E98=\"Yes\",'Fire Resistance '!$E$105<5/8),1,IF(AND('Fire Resistance '!$E$99=100,'Fire Resistance '!$E$98=\"No\"),0.5,0.75))","v":0.75}]
["Portland Cement Sand Plaster","7/8 in. ",1,{"$f":"IF(AND('Fire Resistance '!E96=\"Portland Cement Sand Plaster\",'Fire Resistance '!E98=\"Yes\",'Fire Resistance '!$E$105<5/8),1,IF(AND('Fire Resistance '!$E$99=100,'Fire Resistance '!$E$98=\"No\"),0.5,0.75))","v":0.75}]
["Portland Cement Sand Plaster","1 in.",1,{"$f":"IF(AND('Fire Resistance '!E96=\"Portland Cement Sand Plaster\",'Fire Resistance '!E98=\"Yes\",'Fire Resistance '!$E$105<5/8),1,IF(AND('Fire Resistance '!$E$99=100,'Fire Resistance '!$E$98=\"No\"),0.5,0.75))","v":0.75}]
["Gypsum Sand Plaster","1/2 in.",1.25,1]
["Gypsum Sand Plaster","5/8 in.",1.25,1]
["Gypsum Sand Plaster","3/4 in.",1.25,1]
["Gypsum Sand Plaster","7/8 in. ",1.25,1]
["Gypsum Sand Plaster","1 in.",1.25,1]
["Gypsum Vermiculite or Perlite Plaster",null,1.75,1.25]
["Gypsum Wallboard","3/8 in.",3,2.25]
["Gypsum Wallboard","1/2 in.",3,2.25]
["Gypsum Wallboard","5/8 in.",3,2.25]
["Gypsum Wallboard","Two Layers of 3/8 in.",3,2.25]
["Gypsum Wallboard","One Layer of 3/8 in. and One layer of 1/2 in.",3,2.25]
["Gypsum Wallboard","Two layers of 1/2 in.",3,2.25]
[null,null,null,{"$f":"INDEX('Fire Resistance Loop Tables'!$C$59:$D$73,MATCH('Fire Resistance '!$E$96,'Fire Resistance Loop Tables'!$A$59:$A$73,0),MATCH('Fire Resistance '!$E$97,'Fire Resistance Loop Tables'!$C$58:$D$58,0))","v":1.25}]
["Fire Side"]
[null,"Finish","Time (hr)"]
["Gypsum Wallboard","3/8 in.",{"$f":"10/60","v":0.16666666666666666}]
["Gypsum Wallboard","1/2 in.",{"$f":"15/60","v":0.25}]
["Gypsum Wallboard","5/8 in.",{"$f":"20/60","v":0.33333333333333331}]
["Gypsum Wallboard","Two Layers of 3/8 in.",{"$f":"25/60","v":0.41666666666666669}]
["Gypsum Wallboard","One Layer of 3/8 in. and One layer of 1/2 in.",{"$f":"35/60","v":0.58333333333333337}]
["Gypsum Wallboard","Two layers of 1/2 in.",{"$f":"40/60","v":0.66666666666666663}]
["Type 'X' Gypsum Wallboard","1/2 in.",{"$f":"25/60","v":0.41666666666666669}]
["Type 'X' Gypsum Wallboard","5/8 in.",{"$f":"40/60","v":0.66666666666666663}]
["Direct Applied Portland Cement","Direct Applied",{"$f":"(C99*C104+C100*C105+C101*C106+C102*C107)/100","v":3.9986036999999999}]
["Portland Cement-Sand Plaster on Metal Lath","3/4 in.",{"$f":"20/60","v":0.33333333333333331}]
["Portland Cement-Sand Plaster on Metal Lath","7/8 in.",{"$f":"25/60","v":0.41666666666666669}]
["Portland Cement-Sand Plaster on Metal Lath","1 in.",{"$f":"30/60","v":0.5}]
["Gypsum-Sand Plaster on 3/8 in. gypsum lath","1/2 in.",{"$f":"35/60","v":0.58333333333333337}]
["Gypsum-Sand Plaster on 3/8 in. gypsum lath","5/8 in.",{"$f":"40/60","v":0.66666666666666663}]
["Gypsum-Sand Plaster on 3/8 in. gypsum lath","3/4 in.",{"$f":"50/60","v":0.83333333333333337}]
["Gypsum-Sand Plaster on Metal Lath","3/4 in.",{"$f":"50/60","v":0.83333333333333337}]
["Gypsum-Sand Plaster on Metal Lath","7/8 in.",{"$f":"60/60","v":1}]
["Gypsum-Sand Plaster on Metal Lath","1 in.",{"$f":"80/60","v":1.3333333333333333}]
[]
[]
["DIRECT APPLIED FIRE RATING CALCULATION"]
["Direct Applied Thickness",{"$f":"IF('Fire Resistance '!E115<5/8,'Fire Resistance '!E115,5/8)","v":0}]
["Calcareous or Siliceous Gravel",null,{"$f":"'Fire Resistance '!$E$18","v":35}]
["Limestone, Cinders or Unexpanded Slag",null,{"$f":"'Fire Resistance '!$E$19","v":25}]
["Expanded clay, shale, or slate",null,{"$f":"'Fire Resistance '!$E$20","v":15}]
["Expanded slag or pumice",null,{"$f":"'Fire Resistance '!$E$21","v":25}]
[null,"Max/Min Equivalent Thickness Check","Fire Rating"]
["Calcareous or Siliceous Gravel",{"$f":"IF(SUM($B$98+'Fire Resistance Rating'!$E$15)>'Fire Resistance Lookup Graph'!$B3,'Fire Resistance Lookup Graph'!$B3,IF(SUM($B$98+'Fire Resistance Rating'!$E$15)<'Fire Resistance Lookup Graph'!$P3,'Fire Resistance Lookup Graph'!$P3,SUM($B$98+'Fire Resistance Rating'!$E$15)))","v":6.2},{"$f":"0.0765*$B104^2+0.1955*$B104-0.1732","v":3.9795600000000007}]
["Limestone, Cinders or Unexpanded Slag",{"$f":"IF(SUM($B$98+'Fire Resistance Rating'!$E$15)>'Fire Resistance Lookup Graph'!$B4,'Fire Resistance Lookup Graph'!$B4,IF(SUM($B$98+'Fire Resistance Rating'!$E$15)<'Fire Resistance Lookup Graph'!$P4,'Fire Resistance Lookup Graph'!$P4,SUM($B$98+'Fire Resistance Rating'!$E$15)))","v":5.9},{"$f":"0.0839*$B$105^2+0.219*$B$105-0.2133","v":3.9993590000000006}]
["Expanded clay, shale, or slate",{"$f":"IF(SUM($B$98+'Fire Resistance Rating'!$E$15)>'Fire Resistance Lookup Graph'!$B5,'Fire Resistance Lookup Graph'!$B5,IF(SUM($B$98+'Fire Resistance Rating'!$E$15)<'Fire Resistance Lookup Graph'!$P5,'Fire Resistance Lookup Graph'!$P5,SUM($B$98+'Fire Resistance Rating'!$E$15)))","v":5.0999999999999996},{"$f":"0.1668*$B$106^2-0.0765*$B$106+0.0839","v":4.0322180000000003}]
["Expanded slag or pumice",{"$f":"IF(SUM($B$98+'Fire Resistance Rating'!$E$15)>'Fire Resistance Lookup Graph'!$B6,'Fire Resistance Lookup Graph'!$B6,IF(SUM($B$98+'Fire Resistance Rating'!$E$15)<'Fire Resistance Lookup Graph'!$P6,'Fire Resistance Lookup Graph'!$P6,SUM($B$98+'Fire Resistance Rating'!$E$15)))","v":4.7},{"$f":"0.1389*$B$107^2+0.2342*$B$107-0.1647","v":4.0043410000000002}]
[]
[]
[]
[]
[]
[]
["Calculation for single wythe with finish on both sides - finish #1 side",null,{"$f":"IF('Fire Resistance '!$E$87=\"CMU Single Wythe with a finish on both sides\",IF(AND('Fire Resistance '!E92=\"Yes\",'Fire Resistance '!E96=\"Gypsum Vermiculite or Perlite Plaster\"),\"Accounted for in thickness\",IF('Fire Resistance '!E90=\"Gypsum Vermiculite or Perlite Plaster\",0,INDEX('Fire Resistance Loop Tables'!$C$77:$C$94,MATCH('Fire Resistance '!$E$109&'Fire Resistance '!$E$110,'Fire Resistance Loop Tables'!$A$77:$A$94&'Fire Resistance Loop Tables'!$B$77:$B$94,0)))))","v":{"$error":"#N/A"}}]
["Calculation for single wythe with finish on both sides - finish #2 side",null,{"$f":"IF('Fire Resistance '!E87=\"CMU Single Wythe with a finish on both sides\",IF(AND('Fire Resistance '!E90=\"Gypsum Vermiculite or Perlite Plaster\",'Fire Resistance '!E98=\"Yes\"),\"Accounted for in thickness below\",IF('Fire Resistance '!E96=\"Gypsum Vermiculite or Perlite Plaster\",0,INDEX('Fire Resistance Loop Tables'!C77:C94,MATCH('Fire Resistance '!$E$113&'Fire Resistance '!E114,'Fire Resistance Loop Tables'!A77:A94&'Fire Resistance Loop Tables'!B77:B94,0)))))","v":0.58333333333333337}]

{"sheet":"Fire Resistance Lookup Graph","index":4,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Reference Table"]
[null,4,3.75,3.5,3.25,3,2.75,2.5,2.25,2,1.75,1.5,1.25,1,0.75,0.5]
[{"$f":"'Fire Resistance '!A18","v":"Calcareous or Siliceous Gravel"},6.2,6,5.8,5.5,5.3,5,4.8,4.5,4.2,3.9,3.6,3.2,2.8,2.4,2]
[{"$f":"'Fire Resistance '!A19","v":"Limestone, Cinders or Unexpanded Slag"},5.9,5.7,5.5,5.2,5,4.8,4.5,4.3,4,3.7,3.4,3.1,2.7,2.2999999999999998,1.9]
[{"$f":"'Fire Resistance '!A20","v":"Expanded clay, shale, or slate"},5.0999999999999996,4.9000000000000004,4.8,4.5999999999999996,4.4000000000000004,4.2,4,3.8,3.6,3.4,3.3,2.9,2.6,2.2000000000000002,1.8]
[{"$f":"'Fire Resistance '!A21","v":"Expanded slag or pumice"},4.7,4.5,4.4000000000000004,4.2,4,3.8,3.6,3.4,3.2,3,2.7,2.5,2.1,1.9,1.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,4,3,2,1]
[">= 75% Solid",6,4.9000000000000004,3.8,2.7]
["Hollow",5,4.3,3.4,2.2999999999999998]
["Grouted",6.6,5.5,4.4000000000000004,3]