{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Single","Twin","Triple"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Single","index":0,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[20,0,20,1],[39,0,39,4],[45,0,45,1]]}
["Worksheet for Reinforcing Percent Effective at Critical Locations in a Single Cell RCB Culvert"]
[]
["General Input"]
[]
["Maintenance Number:","0191.0S092"]
["Design Number:","Adair 1065"]
["Date:","2015-07-30"]
["By:","JSI"]
["Concrete Strength:",3.5]
["Reinforcement Strength:",40]
["Rating Code:","LFR"]
[]
[]
["Location: Slab - Top - Corner"]
[]
["Bar Size:",6,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B16)*$B$10/SQRT($B$9),0.4*BARDIA(B16)*$B$10),MAX(0.04*BARAREA(B16)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B16)*$B$10))","v":12.000000000000002}]
["Horiz. Leg Length:",20,null,"Top Bar Factor =",{"$f":"IF(B20-B25-BARDIA(B16)>12,1.4,1)","v":1}]
["Center-to-Center Spacing:",12,null,"Epoxy Coated Factor =",{"$f":"IF(B19=\"Yes\",IF(OR(B18-BARDIA(B16)<6*BARDIA(B16),B25<3*BARDIA(B16)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1)","v":1}]
["Epoxy Coated?","No",null,"Spacing Factor =",{"$f":"IF(B18>=6,0.8,1)","v":0.8}]
["Slab Thickness:",12,null,"Development Length =",{"$f":"MAX(E16*MIN(E17*E18,1.7)*E19,12)","v":12}]
["Critical Section Location From Outside Face of Wall -",null,null,"Available Length (Flexure) =",{"$f":"B17+B24-B22","v":9.5}]
["Flexure:",12,null,"Available Length (Shear) =",{"$f":"B17+B24-B23","v":-6.1999999999999993}]
["Shear:",27.7]
["Side Clear Cover:",1.5,null,"Percent Effective (Flexure) =",{"$f":"MIN(1,E21/E20)","v":0.79166666666666663}]
["Top Clear Cover:",1.5,null,"Percent Effective (Shear) =",{"$f":"MIN(1,E22/E20)","v":-0.51666666666666661}]
[]
[]
["Location: Slab - Bottom - Midspan - Exterior Cell"]
[]
["Bar 1 (Full Width) Size:",8,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",IF(B31=\"None\",\"NA\",MAX(1.25*BARAREA(B31)*$B$10/SQRT($B$9),0.4*BARDIA(B31)*$B$10)),IF(B31=\"None\",\"NA\",MAX(0.04*BARAREA(B31)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B31)*$B$10)))","v":10}]
["Bar 2 (Partial Width) Size:",5,null,"Top Bar Factor =",{"$f":"IF(B31=\"None\",\"NA\",1)","v":1}]
["Bar 2 Length from 0.4 Pt. to End:",null,null,"Epoxy Coated Factor =",{"$f":"IF(B31=\"None\",\"NA\",IF(B34=\"Yes\",IF(OR(B33/2-BARDIA(B31)<6*BARDIA(B31),B35<3*BARDIA(B31)),1.5,IF(B14=\"LRFR\",1.2,1.15)),1))","v":1}]
["Bar 1 Center-to-Center Spacing:",12,null,"Spacing Factor =",{"$f":"IF(B31=\"None\",\"NA\",IF(B33/2>=6,0.8,1))","v":0.8}]
["Epoxy Coated?","No",null,"Development Length =",{"$f":"IF(B31=\"None\",\"NA\",MAX(E30*MIN(E31*E32,1.7)*E33,12))","v":12}]
["Bottom Clear Cover:",2,null,"Available Length (Flexure) =",{"$f":"IF(B31=\"None\",\"NA\",B32)","v":0}]
[]
[null,null,null,"Percent Effective (Flexure) =",{"$f":"IF(B31=\"None\",1,MIN(1,(BARAREA(B30)+BARAREA(B31)*E35/E34)/(BARAREA(B30)+BARAREA(B31))))","v":0.71818181818181814}]
[]
[]
["Location: Floor - Bottom - Corner"]
[]
["Bar Size:",5,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B42)*$B$10/SQRT($B$9),0.4*BARDIA(B42)*$B$10),MAX(0.04*BARAREA(B42)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B42)*$B$10))","v":10}]
["Horiz. Leg Length:",10,null,"Top Bar Factor =",{"$f":"IF(B50>12,1.4,1)","v":1}]
["Center-to-Center Spacing:",12,null,"Epoxy Coated Factor =",{"$f":"IF(B45=\"Yes\",IF(OR(B44-BARDIA(B42)<6*BARDIA(B42),B50<3*BARDIA(B42)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1)","v":1}]
["Epoxy Coated?","No",null,"Spacing Factor =",{"$f":"IF(B44>=6,0.8,1)","v":0.8}]
["Critical Section Location From Outside Face of Wall -",null,null,"Development Length =",{"$f":"MAX(E42*MIN(E43*E44,1.7)*E45,12)","v":12}]
["Flexure:",12,null,"Available Length (Flexure) =",{"$f":"B43+B49-B47","v":-0.5}]
["Shear:",25.6,null,"Available Length (Shear) =",{"$f":"B43+B49-B48","v":-14.100000000000001}]
["Side Clear Cover:",1.5]
["Bottom Clear Cover:",3.5,null,"Percent Effective (Flexure) =",{"$f":"MIN(1,E47/E46)","v":-4.1666666666666664E-2}]
[null,null,null,"Percent Effective (Shear) =",{"$f":"MIN(1,E48/E46)","v":-1.175}]
[]
[]
["Location: Floor - Top - Midspan - Exterior Cell"]
[]
["Bar 1 (Full Width) Size:",8,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",IF(B57=\"None\",\"NA\",MAX(1.25*BARAREA(B57)*$B$10/SQRT($B$9),0.4*BARDIA(B57)*$B$10)),IF(B57=\"None\",\"NA\",MAX(0.04*BARAREA(B57)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B57)*$B$10)))","v":10}]
["Bar 2 (Partial Width) Size:",5,null,"Top Bar Factor =",{"$f":"IF(B57=\"None\",\"NA\",IF(B60-B62-BARDIA(B56)>12,1.4,1))","v":1}]
["Bar 2 Length from 0.4 Pt. to End:",null,null,"Epoxy Coated Factor =",{"$f":"IF(B57=\"None\",\"NA\",IF(B61=\"Yes\",IF(OR(B59/2-BARDIA(B57)<6*BARDIA(B57),B62<3*BARDIA(B57)),1.5,IF(B1=\"LRFR\",1.2,1.15)),1))","v":1}]
["Bar 1 Center-to-Center Spacing:",12,null,"Spacing Factor =",{"$f":"IF(B57=\"None\",\"NA\",IF(B59/2>=6,0.8,1))","v":0.8}]
["Floor Thickness:",14,null,"Development Length =",{"$f":"IF(B57=\"None\",\"NA\",MAX(E56*MIN(E57*E58,1.7)*E59,12))","v":12}]
["Epoxy Coated?","No",null,"Available Length (Flexure) =",{"$f":"IF(B57=\"None\",\"NA\",B58)","v":0}]
["Top Clear Cover:",1.5]
[null,null,null,"Percent Effective (Flexure) =",{"$f":"IF(B57=\"None\",1,MIN(1,(BARAREA(B56)+BARAREA(B57)*E61/E60)/(BARAREA(B56)+BARAREA(B57))))","v":0.71818181818181814}]

{"sheet":"Twin","index":1,"n_rows":92,"n_cols":5,"rows_kept":92,"cut":false,"hidden":false,"merged":[[54,0,54,4],[76,0,76,1],[20,0,20,1],[60,0,60,1],[36,0,36,1]]}
["Worksheet for Reinforcing Percent Effective at Critical Locations in a Twin Cell RCB Culvert"]
[]
["General Input"]
[]
["Maintenance Number:","0191.0S092"]
["Design Number:","Adair 1065"]
["Date:","2015-07-30"]
["By:","JSI"]
["Concrete Strength:",3.5]
["Reinforcement Strength:",40]
["Rating Code:","LFR"]
[]
[]
["Location: Slab - Top - Corner"]
[]
["Bar Size:",6,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B16)*$B$10/SQRT($B$9),0.4*BARDIA(B16)*$B$10),MAX(0.04*BARAREA(B16)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B16)*$B$10))","v":12.000000000000002}]
["Horiz. Leg Length:",20,null,"Top Bar Factor =",{"$f":"IF(B20-B25-BARDIA(B16)>12,1.4,1)","v":1}]
["Center-to-Center Spacing:",12,null,"Epoxy Coated Factor =",{"$f":"IF(B19=\"Yes\",IF(OR(B18-BARDIA(B16)<6*BARDIA(B16),B25<3*BARDIA(B16)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1)","v":1}]
["Epoxy Coated?","No",null,"Spacing Factor =",{"$f":"IF(B18>=6,0.8,1)","v":0.8}]
["Slab Thickness:",12,null,"Development Length =",{"$f":"MAX(E16*MIN(E17*E18,1.7)*E19,12)","v":12}]
["Critical Section Location From Outside Face of Wall -",null,null,"Available Length (Flexure) =",{"$f":"B17+B24-B22","v":9.5}]
["Flexure:",12,null,"Available Length (Shear) =",{"$f":"B17+B24-B23","v":-6.1999999999999993}]
["Shear:",27.7]
["Side Clear Cover:",1.5,null,"Percent Effective (Flexure) =",{"$f":"MIN(1,E21/E20)","v":0.79166666666666663}]
["Top Clear Cover:",1.5,null,"Percent Effective (Shear) =",{"$f":"MIN(1,E22/E20)","v":-0.51666666666666661}]
[]
[]
[]
["Location: Slab - Top - Interior Wall - Exterior Cell"]
[]
["Bar 1 (Full Width) Size:",10,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B32)*$B$10/SQRT($B$9),0.4*BARDIA(B32)*$B$10),MAX(0.04*BARAREA(B32)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B32)*$B$10))","v":10}]
["Bar 2 (Partial Width) Size:",5,null,"Top Bar Factor =",{"$f":"IF(B36-B40-BARDIA(B32)>12,1.4,1)","v":1}]
["Bar 2 Length from CL Wall to End:",20,null,"Epoxy Coated Factor =",{"$f":"IF(B35=\"Yes\",IF(OR(IF(OR(B31=\"None\",B32=\"None\"),B34,B34/2)-BARDIA(B32)<6*BARDIA(B32),B40<3*BARDIA(B32)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1)","v":1}]
["Bar 1 or 2 Center-to-Center Spacing:",24,null,"Spacing Factor =",{"$f":"IF(IF(OR(B31=\"None\",B32=\"None\"),B34,B34/2)>=6,0.8,1)","v":0.8}]
["Epoxy Coated?","No",null,"Development Length =",{"$f":"MAX(E31*MIN(E32*E33,1.7)*E34,12)","v":12}]
["Slab Thickness:",12,null,"Available Length (Flexure) =",{"$f":"B33-B38","v":14}]
["Critical Section Location From Centerline of Wall -",null,null,"Available Length (Shear) =",{"$f":"B33-B39","v":-1.1999999999999993}]
["Flexure:",6]
["Shear:",21.2,null,"Percent Effective (Flexure) =",{"$f":"IF(B32=\"None\",1,MIN(1,(IF(B31=\"None\",0,BARAREA(B31))+BARAREA(B32)*E36/E35)/(IF(B31=\"None\",0,BARAREA(B31))+BARAREA(B32))))","v":1}]
["Top Clear Cover:",1.5,null,"Percent Effective (Shear) =",{"$f":"IF(B32=\"None\",1,MIN(1,(IF(B31=\"None\",0,BARAREA(B31))+BARAREA(B32)*E37/E35)/(IF(B31=\"None\",0,BARAREA(B31))+BARAREA(B32))))","v":0.78417721518987349}]
[]
[]
["Location: Slab - Bottom - Midspan - Exterior Cell"]
[]
["Bar 1 (Full Width) Size:",8,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",IF(B46=\"None\",\"NA\",MAX(1.25*BARAREA(B46)*$B$10/SQRT($B$9),0.4*BARDIA(B46)*$B$10)),IF(B46=\"None\",\"NA\",MAX(0.04*BARAREA(B46)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B46)*$B$10)))","v":10}]
["Bar 2 (Partial Width) Size:",5,null,"Top Bar Factor =",{"$f":"IF(B46=\"None\",\"NA\",1)","v":1}]
["Bar 2 Length from 0.4 Pt. to End:",null,null,"Epoxy Coated Factor =",{"$f":"IF(B46=\"None\",\"NA\",IF(B49=\"Yes\",IF(OR(B48/2-BARDIA(B46)<6*BARDIA(B46),B50<3*BARDIA(B46)),1.5,IF(B14=\"LRFR\",1.2,1.15)),1))","v":1}]
["Bar 1 Center-to-Center Spacing:",12,null,"Spacing Factor =",{"$f":"IF(B46=\"None\",\"NA\",IF(B48/2>=6,0.8,1))","v":0.8}]
["Epoxy Coated?","No",null,"Development Length =",{"$f":"IF(B46=\"None\",\"NA\",MAX(E45*MIN(E46*E47,1.7)*E48,12))","v":12}]
["Bottom Clear Cover:",2,null,"Available Length (Flexure) =",{"$f":"IF(B46=\"None\",\"NA\",B47)","v":0}]
[]
[null,null,null,"Percent Effective (Flexure) =",{"$f":"IF(B46=\"None\",1,MIN(1,(BARAREA(B45)+BARAREA(B46)*E50/E49)/(BARAREA(B45)+BARAREA(B46))))","v":0.71818181818181814}]
[]
[]
["Location: Floor - Bottom - Corner"]
[]
["Bar Size:",5,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B57)*$B$10/SQRT($B$9),0.4*BARDIA(B57)*$B$10),MAX(0.04*BARAREA(B57)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B57)*$B$10))","v":10}]
["Horiz. Leg Length:",10,null,"Top Bar Factor =",{"$f":"IF(B65>12,1.4,1)","v":1}]
["Center-to-Center Spacing:",12,null,"Epoxy Coated Factor =",{"$f":"IF(B60=\"Yes\",IF(OR(B59-BARDIA(B57)<6*BARDIA(B57),B65<3*BARDIA(B57)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1)","v":1}]
["Epoxy Coated?","No",null,"Spacing Factor =",{"$f":"IF(B59>=6,0.8,1)","v":0.8}]
["Critical Section Location From Outside Face of Wall -",null,null,"Development Length =",{"$f":"MAX(E57*MIN(E58*E59,1.7)*E60,12)","v":12}]
["Flexure:",12,null,"Available Length (Flexure) =",{"$f":"B58+B64-B62","v":-0.5}]
["Shear:",25.6,null,"Available Length (Shear) =",{"$f":"B58+B64-B63","v":-14.100000000000001}]
["Side Clear Cover:",1.5]
["Bottom Clear Cover:",3.5,null,"Percent Effective (Flexure) =",{"$f":"MIN(1,E62/E61)","v":-4.1666666666666664E-2}]
[null,null,null,"Percent Effective (Shear) =",{"$f":"MIN(1,E63/E61)","v":-1.175}]
[]
[]
["Location: Floor - Bottom - Interior Wall - Exterior Cell"]
[]
["Bar 1 (Full Width) Size:",10,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B72)*$B$10/SQRT($B$9),0.4*BARDIA(B72)*$B$10),MAX(0.04*BARAREA(B72)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B72)*$B$10))","v":27.04493615131253}]
["Bar 2 (Partial Width) Size:",9,null,"Top Bar Factor =",{"$f":"IF(B80>12,1.4,1)","v":1}]
["Bar 2 Length from CL Wall to End:",37,null,"Epoxy Coated Factor =",{"$f":"IF(B75=\"Yes\",IF(OR(IF(OR(B71=\"None\",B72=\"None\"),B74,B74/2)-BARDIA(B72)<6*BARDIA(B72),B80<3*BARDIA(B72)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1)","v":1.1499999999999999}]
["Bar 1 or 2 Center-to-Center Spacing:",24,null,"Spacing Factor =",{"$f":"IF(IF(OR(B71=\"None\",B72=\"None\"),B74,B74/2)>=6,0.8,1)","v":0.8}]
["Epoxy Coated?","Yes",null,"Development Length =",{"$f":"MAX(E71*MIN(E72*E73,1.7)*E74,12)","v":24.881341259207527}]
["Floor Thickness:",8,null,"Available Length (Flexure) =",{"$f":"B73-B78","v":35}]
["Critical Section Location From Centerline of Wall -",null,null,"Available Length (Shear) =",{"$f":"B73-B79","v":35}]
["Flexure:",2]
["Shear:",2,null,"Percent Effective (Flexure) =",{"$f":"IF(B72=\"None\",1,MIN(1,(IF(B71=\"None\",0,BARAREA(B71))+BARAREA(B72)*E76/E75)/(IF(B71=\"None\",0,BARAREA(B71))+BARAREA(B72))))","v":1}]
["Bottom Clear Cover:",3.5,null,"Percent Effective (Shear) =",{"$f":"IF(B72=\"None\",1,MIN(1,(IF(B71=\"None\",0,BARAREA(B71))+BARAREA(B72)*E77/E75)/(IF(B71=\"None\",0,BARAREA(B71))+BARAREA(B72))))","v":1}]
[]
[]
["Location: Floor - Top - Midspan - Exterior Cell"]
[]
["Bar 1 (Full Width) Size:",8,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",IF(B86=\"None\",\"NA\",MAX(1.25*BARAREA(B86)*$B$10/SQRT($B$9),0.4*BARDIA(B86)*$B$10)),IF(B86=\"None\",\"NA\",MAX(0.04*BARAREA(B86)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B86)*$B$10)))","v":10}]
["Bar 2 (Partial Width) Size:",5,null,"Top Bar Factor =",{"$f":"IF(B86=\"None\",\"NA\",IF(B89-B91-BARDIA(B85)>12,1.4,1))","v":1}]
["Bar 2 Length from 0.4 Pt. to End:",null,null,"Epoxy Coated Factor =",{"$f":"IF(B86=\"None\",\"NA\",IF(B90=\"Yes\",IF(OR(B88/2-BARDIA(B86)<6*BARDIA(B86),B91<3*BARDIA(B86)),1.5,IF(B1=\"LRFR\",1.2,1.15)),1))","v":1}]
["Bar 1 Center-to-Center Spacing:",12,null,"Spacing Factor =",{"$f":"IF(B86=\"None\",\"NA\",IF(B88/2>=6,0.8,1))","v":0.8}]
["Floor Thickness:",14,null,"Development Length =",{"$f":"IF(B86=\"None\",\"NA\",MAX(E85*MIN(E86*E87,1.7)*E88,12))","v":12}]
["Epoxy Coated?","No",null,"Available Length (Flexure) =",{"$f":"IF(B86=\"None\",\"NA\",B87)","v":0}]
["Top Clear Cover:",1.5]
[null,null,null,"Percent Effective (Flexure) =",{"$f":"IF(B86=\"None\",1,MIN(1,(BARAREA(B85)+BARAREA(B86)*E90/E89)/(BARAREA(B85)+BARAREA(B86))))","v":0.71818181818181814}]

{"sheet":"Triple","index":2,"n_rows":143,"n_cols":5,"rows_kept":143,"cut":false,"hidden":false,"merged":[[35,0,35,1],[49,0,49,1],[101,0,101,1],[115,0,115,1],[20,0,20,1],[85,0,85,1],[55,0,55,4],[67,0,67,4]]}
["Worksheet for Reinforcing Percent Effective at Critical Locations in a Triple Cell RCB Culvert"]
["*CALCULATIONS FOR ORIGINAL PORTION OF CULVERT*"]
["General Input"]
[]
["Maintenance Number:","3155.9S052"]
["Design Number:","Dubuque 164"]
["Date:","2015-08-21"]
["By:","TJC"]
["Concrete Strength:",3.5]
["Reinforcement Strength:",40]
["Rating Code:","LFR"]
[]
[]
["Location: Slab - Top - Corner"]
[]
["Bar Size:",8,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B16)*$B$10/SQRT($B$9),0.4*BARDIA(B16)*$B$10),MAX(0.04*BARAREA(B16)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B16)*$B$10))","v":21.365499559536904}]
["Horiz. Leg Length:",37.5,null,"Top Bar Factor =",{"$f":"IF(B20-B25-BARDIA(B16)>12,1.4,1)","v":1.4}]
["Center-to-Center Spacing:",10,null,"Epoxy Coated Factor =",{"$f":"IF(B19=\"Yes\",IF(OR(B18-BARDIA(B16)<6*BARDIA(B16),B25<3*BARDIA(B16)),1.5,1.2),1)","v":1}]
["Epoxy Coated?","No",null,"Spacing Factor =",{"$f":"IF(B18>=6,0.8,1)","v":0.8}]
["Slab Thickness:",18,null,"Development Length =",{"$f":"MAX(E16*MIN(E17*E18,1.7)*E19,12)","v":23.929359506681333}]
["Critical Section Location From Outside Face of Wall -",null,null,"Available Length (Flexure) =",{"$f":"B17+B24-B22","v":27}]
["Flexure:",12,null,"Available Length (Shear) =",{"$f":"B17+B24-B23","v":2.5}]
["Shear:",36.5]
["Side Clear Cover:",1.5,null,"Percent Effective (Flexure) =",{"$f":"MIN(1,E21/E20)","v":1}]
["Top Clear Cover:",1.5,null,"Percent Effective (Shear) =",{"$f":"MIN(1,E22/E20)","v":0.10447417112447048}]
[]
[]
["Location: Slab - Top - Interior Wall - Exterior Cell"]
[]
["Bar 1 (Full Width) Size:","None",null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B31)*$B$10/SQRT($B$9),0.4*BARDIA(B31)*$B$10),MAX(0.04*BARAREA(B31)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B31)*$B$10))","v":27.04493615131253}]
["Bar 2 (Partial Width) Size:",9,null,"Top Bar Factor =",{"$f":"IF(B35-B39-BARDIA(B31)>12,1.4,1)","v":1.4}]
["Bar 2 Length from CL Wall to End:",48,null,"Epoxy Coated Factor =",{"$f":"IF(B34=\"Yes\",IF(OR(IF(OR(B30=\"None\",B31=\"None\"),B33,B33/2)-BARDIA(B31)<6*BARDIA(B31),B39<3*BARDIA(B31)),1.5,IF(#REF!=\"LRFR\",1.2,1.15)),1)","v":1}]
["Bar 1 or 2 Center-to-Center Spacing:",10,null,"Spacing Factor =",{"$f":"IF(IF(OR(B30=\"None\",B31=\"None\"),B33,B33/2)>=6,0.8,1)","v":0.8}]
["Epoxy Coated?","No",null,"Development Length =",{"$f":"MAX(E30*MIN(E31*E32,1.7)*E33,12)","v":30.290328489470035}]
["Slab Thickness:",18,null,"Available Length (Flexure) =",{"$f":"B32-B37","v":42}]
["Critical Section Location From Centerline of Wall -",null,null,"Available Length (Shear) =",{"$f":"B32-B38","v":17.7}]
["Flexure:",6]
["Shear:",30.3,null,"Percent Effective (Flexure) =",{"$f":"IF(B31=\"None\",1,MIN(1,(IF(B30=\"None\",0,BARAREA(B30))+BARAREA(B31)*E35/E34)/(IF(B30=\"None\",0,BARAREA(B30))+BARAREA(B31))))","v":1}]
["Top Clear Cover:",1.5,null,"Percent Effective (Shear) =",{"$f":"IF(B31=\"None\",1,MIN(1,(IF(B30=\"None\",0,BARAREA(B30))+BARAREA(B31)*E36/E34)/(IF(B30=\"None\",0,BARAREA(B30))+BARAREA(B31))))","v":0.58434493393338838}]
[]
[]
["Location: Slab - Top - Interior Wall - Interior Cell"]
[]
["Bar 1 (Full Width) Size:","None",null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B45)*$B$10/SQRT($B$9),0.4*BARDIA(B45)*$B$10),MAX(0.04*BARAREA(B45)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B45)*$B$10))","v":27.04493615131253}]
["Bar 2 (Partial Width) Size:",9,null,"Top Bar Factor =",{"$f":"IF(B49-B53-BARDIA(B45)>12,1.4,1)","v":1.4}]
["Bar 2 Length from CL Wall to End:",48,null,"Epoxy Coated Factor =",{"$f":"IF(B48=\"Yes\",IF(OR(IF(OR(B44=\"None\",B45=\"None\"),B47,B47/2)-BARDIA(B45)<6*BARDIA(B45),B53<3*BARDIA(B45)),1.5,IF(#REF!=\"LRFR\",1.2,1.15)),1)","v":1}]
["Bar 1 or 2 Center-to-Center Spacing:",10,null,"Spacing Factor =",{"$f":"IF(IF(OR(B44=\"None\",B45=\"None\"),B47,B47/2)>=6,0.8,1)","v":0.8}]
["Epoxy Coated?","No",null,"Development Length =",{"$f":"MAX(E44*MIN(E45*E46,1.7)*E47,12)","v":30.290328489470035}]
["Slab Thickness:",18,null,"Available Length (Flexure) =",{"$f":"B46-B51","v":42}]
["Critical Section Location From Centerline of Wall -",null,null,"Available Length (Shear) =",{"$f":"B46-B52","v":17.7}]
["Flexure:",6]
["Shear:",30.3,null,"Percent Effective (Flexure) =",{"$f":"IF(B45=\"None\",1,MIN(1,(IF(B44=\"None\",0,BARAREA(B44))+BARAREA(B45)*E49/E48)/(IF(B44=\"None\",0,BARAREA(B44))+BARAREA(B45))))","v":1}]
["Top Clear Cover:",1.5,null,"Percent Effective (Shear) =",{"$f":"IF(B45=\"None\",1,MIN(1,(IF(B44=\"None\",0,BARAREA(B44))+BARAREA(B45)*E50/E48)/(IF(B44=\"None\",0,BARAREA(B44))+BARAREA(B45))))","v":0.58434493393338838}]
[]
[]
["Location: Slab - Bottom - Midspan - Exterior Cell "]
[]
["Bar 1 (Full Width) Size:",6,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",IF(B59=\"None\",\"NA\",MAX(1.25*BARAREA(B59)*$B$10/SQRT($B$9),0.4*BARDIA(B59)*$B$10)),IF(B59=\"None\",\"NA\",MAX(0.04*BARAREA(B59)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B59)*$B$10)))","v":12.000000000000002}]
["Bar 2 (Partial Width) Size:",6,null,"Top Bar Factor =",{"$f":"IF(B59=\"None\",\"NA\",1)","v":1}]
["Bar 2 Length from 0.4 Pt. to End:",39,null,"Epoxy Coated Factor =",{"$f":"IF(B59=\"None\",\"NA\",IF(B62=\"Yes\",IF(OR(B61/2-BARDIA(B59)<6*BARDIA(B59),B63<3*BARDIA(B59)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1))","v":1}]
["Bar 1 Center-to-Center Spacing:",10,null,"Spacing Factor =",{"$f":"IF(B59=\"None\",\"NA\",IF(B61/2>=6,0.8,1))","v":1}]
["Epoxy Coated?","No",null,"Development Length =",{"$f":"IF(B59=\"None\",\"NA\",MAX(E58*MIN(E59*E60,1.7)*E61,12))","v":12.000000000000002}]
["Bottom Clear Cover:",1.5,null,"Available Length (Flexure) =",{"$f":"IF(B59=\"None\",\"NA\",B60)","v":39}]
[]
[null,null,null,"Percent Effective (Flexure) =",{"$f":"IF(B59=\"None\",1,MIN(1,(BARAREA(B58)+BARAREA(B59)*E63/E62)/(BARAREA(B58)+BARAREA(B59))))","v":1}]
[]
[]
["Location: Slab - Bottom - Midspan - Interior Cell "]
[]
["Bar 1 (Full Width) Size:",6,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",IF(B71=\"None\",\"NA\",MAX(1.25*BARAREA(B71)*$B$10/SQRT($B$9),0.4*BARDIA(B71)*$B$10)),IF(B71=\"None\",\"NA\",MAX(0.04*BARAREA(B71)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B71)*$B$10)))","v":"NA"}]
["Bar 2 (Partial Width) Size:","None",null,"Top Bar Factor =",{"$f":"IF(B71=\"None\",\"NA\",1)","v":"NA"}]
["Bar 2 Length from 0.5 Pt. to End:",null,null,"Epoxy Coated Factor =",{"$f":"IF(B71=\"None\",\"NA\",IF(B74=\"Yes\",IF(OR(B73/2-BARDIA(B71)<6*BARDIA(B71),B75<3*BARDIA(B71)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1))","v":"NA"}]
["Bar 1 Center-to-Center Spacing:",null,null,"Spacing Factor =",{"$f":"IF(B71=\"None\",\"NA\",IF(B73/2>=6,0.8,1))","v":"NA"}]
["Epoxy Coated?","No",null,"Development Length =",{"$f":"IF(B71=\"None\",\"NA\",MAX(E70*MIN(E71*E72,1.7)*E73,12))","v":"NA"}]
["Bottom Clear Cover:",null,null,"Available Length (Flexure) =",{"$f":"IF(B71=\"None\",\"NA\",B72)","v":"NA"}]
[]
[null,null,null,"Percent Effective (Flexure) =",{"$f":"IF(B71=\"None\",1,MIN(1,(BARAREA(B70)+BARAREA(B71)*E75/E74)/(BARAREA(B70)+BARAREA(B71))))","v":1}]
[]
[]
["Location: Floor - Bottom - Corner "]
[]
["Bar Size:",8,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B82)*$B$10/SQRT($B$9),0.4*BARDIA(B82)*$B$10),MAX(0.04*BARAREA(B82)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B82)*$B$10))","v":21.365499559536904}]
["Horiz. Leg Length:",37.5,null,"Top Bar Factor =",{"$f":"IF(B90>12,1.4,1)","v":1}]
["Center-to-Center Spacing:",10,null,"Epoxy Coated Factor =",{"$f":"IF(B85=\"Yes\",IF(OR(B84-BARDIA(B82)<6*BARDIA(B82),B90<3*BARDIA(B82)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1)","v":1}]
["Epoxy Coated?","No",null,"Spacing Factor =",{"$f":"IF(B84>=6,0.8,1)","v":0.8}]
["Critical Section Location From Outside Face of Wall -",null,null,"Development Length =",{"$f":"MAX(E82*MIN(E83*E84,1.7)*E85,12)","v":17.092399647629524}]
["Flexure:",12,null,"Available Length (Flexure) =",{"$f":"B83+B89-B87","v":27}]
["Shear:",31.5,null,"Available Length (Shear) =",{"$f":"B83+B89-B88","v":7.5}]
["Side Clear Cover:",1.5]
["Bottom Clear Cover:",3.5,null,"Percent Effective (Flexure) =",{"$f":"MIN(1,E87/E86)","v":1}]
[null,null,null,"Percent Effective (Shear) =",{"$f":"MIN(1,E88/E86)","v":0.438791518722776}]
[]
[]
["Location: Floor - Bottom - Interior Wall - Exterior Cell "]
[]
["Bar 1 (Full Width) Size:","None",null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B97)*$B$10/SQRT($B$9),0.4*BARDIA(B97)*$B$10),MAX(0.04*BARAREA(B97)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B97)*$B$10))","v":21.365499559536904}]
["Bar 2 (Partial Width) Size:",8,null,"Top Bar Factor =",{"$f":"IF(B105>12,1.4,1)","v":1}]
["Bar 2 Length from CL Wall to End:",48,null,"Epoxy Coated Factor =",{"$f":"IF(B100=\"Yes\",IF(OR(IF(OR(B96=\"None\",B97=\"None\"),B99,B99/2)-BARDIA(B97)<6*BARDIA(B97),B105<3*BARDIA(B97)),1.5,IF(#REF!=\"LRFR\",1.2,1.15)),1)","v":1}]
["Bar 1 or 2 Center-to-Center Spacing:",10,null,"Spacing Factor =",{"$f":"IF(IF(OR(B96=\"None\",B97=\"None\"),B99,B99/2)>=6,0.8,1)","v":0.8}]
["Epoxy Coated?","No",null,"Development Length =",{"$f":"MAX(E96*MIN(E97*E98,1.7)*E99,12)","v":17.092399647629524}]
["Floor Thickness:",20,null,"Available Length (Flexure) =",{"$f":"B98-B103","v":42}]
["Critical Section Location From Centerline of Wall -",null,null,"Available Length (Shear) =",{"$f":"B98-B104","v":22.5}]
["Flexure:",6]
["Shear:",25.5,null,"Percent Effective (Flexure) =",{"$f":"IF(B97=\"None\",1,MIN(1,(IF(B96=\"None\",0,BARAREA(B96))+BARAREA(B97)*E101/E100)/(IF(B96=\"None\",0,BARAREA(B96))+BARAREA(B97))))","v":1}]
["Bottom Clear Cover:",3.5,null,"Percent Effective (Shear) =",{"$f":"IF(B97=\"None\",1,MIN(1,(IF(B96=\"None\",0,BARAREA(B96))+BARAREA(B97)*E102/E100)/(IF(B96=\"None\",0,BARAREA(B96))+BARAREA(B97))))","v":1}]
[]
[]
["Location: Floor - Bottom - Interior Wall - Interior Cell "]
[]
["Bar 1 (Full Width) Size:","None",null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",MAX(1.25*BARAREA(B111)*$B$10/SQRT($B$9),0.4*BARDIA(B111)*$B$10),MAX(0.04*BARAREA(B111)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B111)*$B$10))","v":21.365499559536904}]
["Bar 2 (Partial Width) Size:",8,null,"Top Bar Factor =",{"$f":"IF(B119>12,1.4,1)","v":1}]
["Bar 2 Length from CL Wall to End:",48,null,"Epoxy Coated Factor =",{"$f":"IF(B114=\"Yes\",IF(OR(IF(OR(B110=\"None\",B111=\"None\"),B113,B113/2)-BARDIA(B111)<6*BARDIA(B111),B119<3*BARDIA(B111)),1.5,IF(#REF!=\"LRFR\",1.2,1.15)),1)","v":1}]
["Bar 1 or 2 Center-to-Center Spacing:",10,null,"Spacing Factor =",{"$f":"IF(IF(OR(B110=\"None\",B111=\"None\"),B113,B113/2)>=6,0.8,1)","v":0.8}]
["Epoxy Coated?","No",null,"Development Length =",{"$f":"MAX(E110*MIN(E111*E112,1.7)*E113,12)","v":17.092399647629524}]
["Floor Thickness:",20,null,"Available Length (Flexure) =",{"$f":"B112-B117","v":42}]
["Critical Section Location From Centerline of Wall -",null,null,"Available Length (Shear) =",{"$f":"B112-B118","v":22.5}]
["Flexure:",6]
["Shear:",25.5,null,"Percent Effective (Flexure) =",{"$f":"IF(B111=\"None\",1,MIN(1,(IF(B110=\"None\",0,BARAREA(B110))+BARAREA(B111)*E115/E114)/(IF(B110=\"None\",0,BARAREA(B110))+BARAREA(B111))))","v":1}]
["Bottom Clear Cover:",3.5,null,"Percent Effective (Shear) =",{"$f":"IF(B111=\"None\",1,MIN(1,(IF(B110=\"None\",0,BARAREA(B110))+BARAREA(B111)*E116/E114)/(IF(B110=\"None\",0,BARAREA(B110))+BARAREA(B111))))","v":1}]
[]
[]
["Location: Floor - Top - Midspan - Exterior Cell "]
[]
["Bar 1 (Full Width) Size:",6,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",IF(B125=\"None\",\"NA\",MAX(1.25*BARAREA(B125)*$B$10/SQRT($B$9),0.4*BARDIA(B125)*$B$10)),IF(B125=\"None\",\"NA\",MAX(0.04*BARAREA(B125)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B125)*$B$10)))","v":12.000000000000002}]
["Bar 2 (Partial Width) Size:",6,null,"Top Bar Factor =",{"$f":"IF(B125=\"None\",\"NA\",IF(B128-B130-BARDIA(B124)>12,1.4,1))","v":1.4}]
["Bar 2 Length from 0.4 Pt. to End:",44,null,"Epoxy Coated Factor =",{"$f":"IF(B125=\"None\",\"NA\",IF(B129=\"Yes\",IF(OR(B127/2-BARDIA(B125)<6*BARDIA(B125),B130<3*BARDIA(B125)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1))","v":1}]
["Bar 1 Center-to-Center Spacing:",10,null,"Spacing Factor =",{"$f":"IF(B125=\"None\",\"NA\",IF(B127/2>=6,0.8,1))","v":1}]
["Floor Thickness:",20,null,"Development Length =",{"$f":"IF(B125=\"None\",\"NA\",MAX(E124*MIN(E125*E126,1.7)*E127,12))","v":16.8}]
["Epoxy Coated?","No",null,"Available Length (Flexure) =",{"$f":"IF(B125=\"None\",\"NA\",B126)","v":44}]
["Top Clear Cover:",1.5]
[null,null,null,"Percent Effective (Flexure) =",{"$f":"IF(B125=\"None\",1,MIN(1,(BARAREA(B124)+BARAREA(B125)*E129/E128)/(BARAREA(B124)+BARAREA(B125))))","v":1}]
[]
[]
["Location: Floor - Top - Midspan - Interior Cell "]
[]
["Bar 1 (Full Width) Size:",6,null,"Basic Development Length =",{"$f":"IF(B11=\"LRFR\",IF(B137=\"None\",\"NA\",MAX(1.25*BARAREA(B137)*$B$10/SQRT($B$9),0.4*BARDIA(B137)*$B$10)),IF(B137=\"None\",\"NA\",MAX(0.04*BARAREA(B137)*$B$10*1000/SQRT($B$9*1000),0.4*BARDIA(B137)*$B$10)))","v":"NA"}]
["Bar 2 (Partial Width) Size:","None",null,"Top Bar Factor =",{"$f":"IF(B137=\"None\",\"NA\",IF(B140-B142-BARDIA(B136)>12,1.4,1))","v":"NA"}]
["Bar 2 Length from 0.5 Pt. to End:",null,null,"Epoxy Coated Factor =",{"$f":"IF(B137=\"None\",\"NA\",IF(B141=\"Yes\",IF(OR(B139/2-BARDIA(B137)<6*BARDIA(B137),B142<3*BARDIA(B137)),1.5,IF(B11=\"LRFR\",1.2,1.15)),1))","v":"NA"}]
["Bar 1 Center-to-Center Spacing:",null,null,"Spacing Factor =",{"$f":"IF(B137=\"None\",\"NA\",IF(B139/2>=6,0.8,1))","v":"NA"}]
["Floor Thickness:",null,null,"Development Length =",{"$f":"IF(B137=\"None\",\"NA\",MAX(E136*MIN(E137*E138,1.7)*E139,12))","v":"NA"}]
["Epoxy Coated?",null,null,"Available Length (Flexure) =",{"$f":"IF(B137=\"None\",\"NA\",B138)","v":"NA"}]
["Top Clear Cover:"]
[null,null,null,"Percent Effective (Flexure) =",{"$f":"IF(B137=\"None\",1,MIN(1,(BARAREA(B136)+BARAREA(B137)*E141/E140)/(BARAREA(B136)+BARAREA(B137))))","v":1}]