{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Allowable Stress Design (null)","Instructions","Allowable Stress Design","Strength Design","Figure 6","Figure 7","Figure X","Data"],"not_rendered":{"charts":7,"images":34,"macros":1,"external_links":0,"defined_names":3,"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":"Allowable Stress Design (null)","index":0,"n_rows":109,"n_cols":20,"rows_kept":109,"cut":false,"hidden":true,"merged":[[15,1,15,6],[12,3,12,4]]}
["2008 MSJC Anchor Bolt Design Values"]
["Allowable Stress Design"]
[]
["Anchor Type =","Bent-Bar",null,"Choose \"Headed\" or \"Bent-Bar\""]
["Anchor Yield Strength, fy  =",{"$f":"IF(B4=\"Headed\",60000,36000)","v":36000},"psi"]
["Anchor Diameter, db =",0.5,"in","Choose 1/2, 5/8, 3/4, or 7/8 in."]
["Anchor Hook Length, eb =",{"$f":"IF(B4=\"Bent-Bar\",2*B6,0)","v":1},"in","Taken equal to 2db for bent anchors"]
["f'm =",2000,"psi"]
["Wall thickness, t =",7.625,"in"]
["Edge Distance, lbe =",4,"in"]
["Net Anchor Area, Ab =",{"$f":"IF(B6=0.5,0.142,IF(B6=0.625,0.226,IF(B6=0.75,0.334,IF(B6=0.875,0.462,\"NA\"))))","v":0.14199999999999999},"in2"]
["Min. Embed Length, lbmin =",{"$f":"IF(4*B6<2,2,4*B6)","v":2},"in"]
["Actual Embedment Length, lb",5,"in",{"$f":"IF(B13>=B12,\"Embed. OK\", \"Revise Embedment Length\")","v":"Embed. OK"}]
[]
["Axial Tensile Strength",null,null,null,null,null,null,null,null,null,null,null,null,"Shear Strength"]
[null,"Projected Breakout Area Outside Masonry, Aout (in.2)"]
["Anchor Embedment, lb (in.)","Segment Height, h1 (in.)","Segment Height, h2 (in.)","Segment Length, s1 (in.)","Segment Length, s2 (in.)","Segment Area, A1 (in.)","Segment Area, A2 (in.)","Net Projected Tension Breakout Area, Apt (in.2)","Breakout Strength, Bab (lb)","Yield Strength, Bas (lb)","Pullout Strength, Bap (lb)","Allowable Axial Load, Ba (lb)","Governing Failure Mode","Net Projected Shear Breakout Area, Apv (in.2)","Breakout Strength, Bvb (lb)","Crushing Strength, Bvc (lb)*","Pryout Strength, Bvpry (lb)","Yield Strength, Bvs (lb)","Allowable Shear Load, Bv (lb)","Governing Failure Mode"]
[{"$f":"B12","v":2},{"$f":"IF(A18-$B$10<0,0,A18-$B$10)","v":0},{"$f":"IF(A18+$B$10-$B$9<0,0,A18+$B$10-$B$9)","v":0},{"$f":"(8*B18*(A18-(B18/2)))^0.5","v":0},{"$f":"(8*C18*(A18-(C18/2)))^0.5","v":0},{"$f":"IF(B18=0,0,((B18/(6*D18))*((3*B18*B18)+(4*D18*D18))))","v":0},{"$f":"IF(C18=0,0,((C18/(6*E18))*((3*C18*C18)+(4*E18*E18))))","v":0},{"$f":"(PI()*(A18^2))-F18-G18","v":12.566370614359172},{"$f":"1.25*H18*SQRT($B$8)","v":702.48147310407262},{"$f":"0.6*$B$11*$B$5","v":3067.1999999999994},{"$f":"IF(B4=\"bent-bar\",(0.6*$B$8*$B$7*$B$6)+((120*3.141592)*(A18+$B$7+$B$6)*$B$6),\"N/A\")","v":1259.73432},{"$f":"IF($B$4=\"headed\",MIN(I18:J18),MIN(I18:K18))","v":702.48147310407262},{"$f":"IF(L18=I18,\"Breakout\",IF(L18=J18,\"Yield\",\"Pullout\"))","v":"Breakout"},{"$f":"(0.5)*PI()*($B$10^2)","v":25.132741228718345},{"$f":"1.25*N18*($B$8^0.5)","v":1404.9629462081452},{"$f":"350*($B$8*$B$11)^0.25","v":1436.8043340790032},{"$f":"2*I18","v":1404.9629462081452},{"$f":"J18*0.6","v":1840.3199999999995},{"$f":"MIN(O18:R18)","v":1404.9629462081452},{"$f":"IF(S18=O18,\"Breakout\",IF(S18=P18,\"Crushing\",IF(S18=Q18,\"Pryout\",\"Yield\")))","v":"Breakout"}]
[4,0,0.375,0,3.3819373146171707,{"$f":"IF(B19=0,0,((B19/(6*D19))*((3*B19*B19)+(4*D19*D19))))","v":0},{"$f":"IF(C19=0,0,((C19/(6*E19))*((3*C19*C19)+(4*E19*E19))))","v":0.85328080299639175},{"$f":"(PI()*(A19^2))-F19-G19","v":49.412201654440295},{"$f":"1.25*H19*SQRT($B$8)","v":2762.2260454314023},{"$f":"0.6*$B$11*$B$5","v":3067.1999999999994},"N/A",{"$f":"IF($B$4=\"Headed\",MIN(I19:J19),MIN(I19:K19))","v":2762.2260454314023},{"$f":"IF(L19=I19,\"Breakout\",IF(L19=J19,\"Yield\",\"Pullout\"))","v":"Breakout"},{"$f":"(0.5)*PI()*($B$10^2)","v":25.132741228718345},{"$f":"1.25*N19*($B$8^0.5)","v":1404.9629462081452},{"$f":"350*($B$8*$B$11)^0.25","v":1436.8043340790032},{"$f":"2*I19","v":5524.4520908628047},{"$f":"J19*0.6","v":1840.3199999999995},{"$f":"MIN(O19:R19)","v":1404.9629462081452},{"$f":"IF(S19=O19,\"Breakout\",IF(S19=P19,\"Crushing\",IF(S19=Q19,\"Pryout\",\"Yield\")))","v":"Breakout"}]
[{"$f":"A19+1","v":5},1,1.375,6,6.887488656977955,4.083333333333333,6.502250953564559,67.954232052846947,3798.7570557240215,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,7597.514111448043,1840.3199999999995,1404.9629462081452,"Breakout"]
[6,2,2.375,8.9442719099991592,9.5622957494526393,12.372909475498838,15.840786336569572,84.883639717164129,4745.1397146295003,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,9490.2794292590006,1840.3199999999995,1404.9629462081452,"Breakout"]
[7,3,3.375,11.489125293076057,11.976539567003485,24.153274763853076,28.552158390527243,101.23260687151955,5659.0747626057519,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,11318.149525211504,1840.3199999999995,1404.9629462081452,"Breakout"]
[8,4,4.375,13.856406460551018,14.263151825595912,39.259818304894551,44.536404011878361,117.26570751297383,6555.3523357154327,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,13110.704671430865,1840.3199999999995,1404.9629462081452,"Breakout"]
[9,5,5.375,16.124515496597098,16.475360390595405,57.624470444569752,63.749415579018475,133.095118917185,7440.2433343060975,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,14880.486668612195,1840.3199999999995,1404.9629462081452,"Breakout"]
[10,6,6.375,18.330302779823359,18.639675426358689,79.213094155665232,86.168419269587361,148.77775193372673,8316.9291715853433,3067.1999999999994,"N/A",{"$f":"IF($B$4=\"Headed\",MIN(I25:J25),MIN(I25:K25))","v":3067.1999999999994},"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,16633.858343170687,1840.3199999999995,1404.9629462081452,"Breakout"]
[11,7,7.375,20.493901531919196,20.771073636189342,104.00655027448991,111.78044261719042,164.34571819268461,9187.204942246668,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,18374.409884493336,1840.3199999999995,1404.9629462081452,"Breakout"]
[12.5,8.5,8.875,23.685438564654021,23.925666134927152,147.18167411104136,156.16887383055831,187.52330418180549,10482.871387897192,3067.1999999999994,{"$f":"IF(B14=\"bent-bar\",(0.6*$B$8*$B$7*$B$6)+((120*3.141592)*(A27+$B$7+$B$6)*$B$6),\"N/A\")","v":"N/A"},3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,20965.742775794384,1840.3199999999995,1404.9629462081452,"Breakout"]
[{"$f":"A27+0.5","v":13},9,9.375,24.738633753705962,24.968730444297723,163.16584174319297,172.55469553404762,195.20862117943446,10912.493668780517,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,21824.987337561033,1840.3199999999995,1404.9629462081452,"Breakout"]
[{"$f":"A28+0.5","v":13.5},9.5,9.875,25.787593916455254,26.008412100703111,179.94521635869341,189.73464896654579,202.87539579150055,11341.079398799249,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,22682.158797598498,1840.3199999999995,1404.9629462081452,"Breakout"]
[14,10,10.375,26.832815729997478,27.045101219999157,197.51933801248146,207.70841534264642,210.52440674847153,11768.672110309946,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,23537.344220619892,1840.3199999999995,1404.9629462081452,"Breakout"]
[14.5,10.5,10.875,27.874719729532707,28.079129260003771,215.88782087822204,226.47572693771789,218.15630760131407,12195.30833792231,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,24390.61667584462,1840.3199999999995,1404.9629462081452,"Breakout"]
[15,11,11.375,28.913664589601922,29.110779790311355,235.05033910889108,246.03635742309885,225.77165052571351,12621.018949195539,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,25242.037898391078,1840.3199999999995,1404.9629462081452,"Breakout"]
[15.5,11.5,11.875,29.949958263743873,30.140296946115178,255.00661579370382,266.39011429754265,233.37090493370135,13045.830185059931,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,26091.660370119862,1840.3199999999995,1404.9629462081452,"Breakout"]
[16,12,12.375,30.983866769659336,31.167892132770223,275.75641424996803,287.53683290519518,240.95447216382388,13469.764481022277,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,26939.528962044555,1840.3199999999995,1404.9629462081452,"Breakout"]
[16.5,12.5,12.875,32.015621187164243,32.193749393321681,297.29953109523711,309.47637166707119,248.52269717751295,13892.841121012852,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,27785.682242025705,1840.3199999999995,1404.9629462081452,"Breakout"]
[17,13,13.375,33.045423283716609,33.218029742897151,319.6357906907113,332.20860824977512,256.07587794696383,14315.07676218376,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,28630.153524367521,1840.3199999999995,1404.9629462081452,"Breakout"]
[17.5,13.5,13.875,34.073450074801642,34.240874696771399,342.76504065072987,355.73343646463621,263.61427304650812,14736.485859279568,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,29472.971718559136,1840.3199999999995,1404.9629462081452,"Breakout"]
[18,14,14.375,35.09985754956849,35.262409163300227,366.68714818829511,380.05076374083768,271.13810783396008,15157.081010185075,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,30314.16202037015,1840.3199999999995,1404.9629462081452,"Breakout"]
[18.5,14.5,14.875,36.124783736376884,36.282743832295814,{"$f":"IF(B39=0,0,((B39/(6*D39))*((3*B39*B39)+(4*D39*D39))))","v":391.40199712149456},{"$f":"IF(C39=0,0,((C39/(6*E39))*((3*C39*C39)+(4*E39*E39))))","v":405.16050905313585},278.64757951647636,15576.873239115477,3067.1999999999994,"N/A",{"$f":"IF($B$4=\"Headed\",MIN(I39:J39),MIN(I39:K39))","v":3067.1999999999994},"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,31153.746478230954,1840.3199999999995,1404.9629462081452,"Breakout"]
[19,15,15.375,37.148351242013419,37.301977159394646,416.90948540629188,431.06260121222073,286.14286132740261,15995.8722301092,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,31991.7444602184,1840.3199999999995,1404.9629462081452,"Breakout"]
[19.5,15.5,15.875,38.17066936798463,38.320197024545685,443.20952309147043,457.75697744633749,293.62410598971087,16414.086520639918,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,32828.173041279835,1840.3199999999995,1404.9629462081452,"Breakout"]
[20,16,16.375,39.191835884530846,39.337482125830064,470.30203061437015,485.24358221833489,301.09144860321231,16831.523663016673,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,33663.047326033346,1840.3199999999995,1404.9629462081452,"Breakout"]
[20.5,16.5,16.875,40.2119385257662,40.353903156943815,498.18693737342744,513.52236623414944,308.5450090635336,17248.190359608747,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,34496.380719217494,1840.3199999999995,1404.9629462081452,"Breakout"]
[21,17,17.375,41.231056256176608,41.369523806783178,526.86418052684348,542.59328560783831,315.98489409841693,17664.092576678311,3067.1999999999994,"N/A",3067.1999999999994,"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,35328.185153356622,1840.3199999999995,1404.9629462081452,"Breakout"]
[21.5,17.5,17.875,42.249260348555218,42.384401611913788,{"$f":"IF(B45=0,0,((B45/(6*D45))*((3*B45*B45)+(4*D45*D45))))","v":556.33370397699241},{"$f":"IF(C45=0,0,((C45/(6*E45))*((3*C45*C45)+(4*E45*E45))))","v":572.45630115531412},323.41119898957527,18079.235640635041,3067.1999999999994,"N/A",{"$f":"IF($B$4=\"Headed\",MIN(I45:J45),MIN(I45:K45))","v":3067.1999999999994},"Yield",25.132741228718345,1404.9629462081452,1436.8043340790032,36158.471281270082,1840.3199999999995,1404.9629462081452,"Breakout"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Values assume threads cross shear plane."]
[]
["Unity Interaction"]
["Wall thickness, t =",{"$f":"B9","v":7.625}]
["Anchor Type =",{"$f":"B4","v":"Bent-Bar"}]
["Anchor Diameter, db =",{"$f":"B6","v":0.5}]
["Edge Distance, lbe =",{"$f":"B10","v":4}]
["Anchor Embedment, lb (in.)","Allowable Axial Load, Ba (lb)","Allowable Shear Load, Bv (lb)"]
[{"$f":"$A18","v":2},{"$f":"L18","v":702.48147310407262},0]
[null,0,{"$f":"S18","v":1404.9629462081452}]
[{"$f":"$A19","v":4},{"$f":"L19","v":2762.2260454314023},0]
[null,0,{"$f":"S19","v":1404.9629462081452}]
[{"$f":"$A20","v":5},{"$f":"L20","v":3067.1999999999994},0]
[null,0,{"$f":"S20","v":1404.9629462081452}]
[{"$f":"$A21","v":6},{"$f":"L21","v":3067.1999999999994},0]
[null,0,{"$f":"S21","v":1404.9629462081452}]
[{"$f":"$A22","v":7},{"$f":"L22","v":3067.1999999999994},0]
[null,0,{"$f":"S22","v":1404.9629462081452}]
[{"$f":"$A23","v":8},{"$f":"L23","v":3067.1999999999994},0]
[null,0,{"$f":"S23","v":1404.9629462081452}]
[{"$f":"$A24","v":9},{"$f":"L24","v":3067.1999999999994},0]
[null,0,{"$f":"S24","v":1404.9629462081452}]
[{"$f":"$A25","v":10},{"$f":"L25","v":3067.1999999999994},0]
[null,0,{"$f":"S25","v":1404.9629462081452}]
[{"$f":"$A26","v":11},{"$f":"L26","v":3067.1999999999994},0]
[null,0,{"$f":"S26","v":1404.9629462081452}]
[{"$f":"$A27","v":12.5},{"$f":"L27","v":3067.1999999999994},0]
[null,0,{"$f":"S27","v":1404.9629462081452}]
[{"$f":"$A28","v":13},{"$f":"L28","v":3067.1999999999994},0]
[null,0,{"$f":"S28","v":1404.9629462081452}]
[{"$f":"$A29","v":13.5},{"$f":"L29","v":3067.1999999999994},0]
[null,0,{"$f":"S29","v":1404.9629462081452}]
[{"$f":"$A30","v":14},{"$f":"L30","v":3067.1999999999994},0]
[null,0,{"$f":"S30","v":1404.9629462081452}]
[{"$f":"$A31","v":14.5},{"$f":"L31","v":3067.1999999999994},0]
[null,0,{"$f":"S31","v":1404.9629462081452}]
[{"$f":"$A32","v":15},{"$f":"L32","v":3067.1999999999994},0]
[null,0,{"$f":"S32","v":1404.9629462081452}]
[{"$f":"$A33","v":15.5},{"$f":"L33","v":3067.1999999999994},0]
[null,0,{"$f":"S33","v":1404.9629462081452}]
[{"$f":"$A34","v":16},{"$f":"L34","v":3067.1999999999994},0]
[null,0,{"$f":"S34","v":1404.9629462081452}]
[{"$f":"$A35","v":16.5},{"$f":"L35","v":3067.1999999999994},0]
[null,0,{"$f":"S35","v":1404.9629462081452}]
[{"$f":"$A36","v":17},{"$f":"L36","v":3067.1999999999994},0]
[null,0,{"$f":"S36","v":1404.9629462081452}]
[{"$f":"$A37","v":17.5},{"$f":"L37","v":3067.1999999999994},0]
[null,0,{"$f":"S37","v":1404.9629462081452}]
[{"$f":"$A38","v":18},{"$f":"L38","v":3067.1999999999994},0]
[null,0,{"$f":"S38","v":1404.9629462081452}]
[{"$f":"$A39","v":18.5},{"$f":"L39","v":3067.1999999999994},0]
[null,0,{"$f":"S39","v":1404.9629462081452}]
[{"$f":"$A40","v":19},{"$f":"L40","v":3067.1999999999994},0]
[null,0,{"$f":"S40","v":1404.9629462081452}]
[{"$f":"$A41","v":19.5},{"$f":"L41","v":3067.1999999999994},0]
[null,0,{"$f":"S41","v":1404.9629462081452}]
[{"$f":"$A42","v":20},{"$f":"L42","v":3067.1999999999994},0]
[null,0,{"$f":"S42","v":1404.9629462081452}]
[{"$f":"$A43","v":20.5},{"$f":"L43","v":3067.1999999999994},0]
[null,0,{"$f":"S43","v":1404.9629462081452}]
[{"$f":"$A44","v":21},{"$f":"L44","v":3067.1999999999994},0]
[null,0,{"$f":"S44","v":1404.9629462081452}]
[{"$f":"$A45","v":21.5},{"$f":"L45","v":3067.1999999999994},0]
[null,0,{"$f":"S45","v":1404.9629462081452}]

{"sheet":"Instructions","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2013 MSJC Anchor Bolt Design "]
[]
[null,null,"Instructions"]
[null,null,"1)","Blue cells are for user input and can be modified as desired."]
[null,null,"2)","Beige cells are important output cells, as calculated by the spreadsheet, and cannot be modified."]
[null,null,"3)","A simple design summary box, located after user input, summarizes the adequacy of the design."]
[null,null,"4)","All calculations are conducted in US [in-lb] units."]
[null,null,"5)","Invalid user input will be prompted with an error message requiring the user to correct their input. "]
[null,null,"Design Notes"]
[null,null,"1)","Analysis and subsequent calculations are for a single anchor."]
[null,null,"2)","Wall thickness is the actual dimension, not a nominal measurement."]
[null,null,"3)","Tension force is indicated as a positive value.  "]
[null,null,"4)","It is the duty of the designer/user to verify the validity of calculations presented in the spreadsheets."]
[null,null,"Disclaimer"]
[null,null,"NCMA and the companies disseminating this technical information disclaim any and all responsibility and"]
[null,null,"liability for the accuracy and the application of the information contained in this publication.   "]
[null,null,"Worksheet Protection"]
[null,null,"To prevent the inadvertant changing of the spreadsheet's functions, many of the cells are locked from editing."]
[null,null,"Users may unlock the spreadsheet if they so desire using the password: 'bloxrox'"]
[]
[null,null,null,null,null,null,null,null,null,null,"Ver. 1.2: Rev. March 19, 2019"]

{"sheet":"Allowable Stress Design","index":2,"n_rows":73,"n_cols":15,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,14,72,15],[29,1,29,2],[30,1,30,2],[40,6,40,7],[28,1,28,2],[40,10,40,14],[43,6,44,6],[43,7,44,7],[43,2,44,2],[56,2,56,3],[56,4,56,6],[34,2,35,11],[44,3,44,4],[43,3,43,4],[69,7,70,8],[65,2,65,3],[69,1,70,1],[69,4,70,4],[69,5,70,5],[69,6,70,6],[65,4,65,6],[1,12,1,13],[12,1,13,5],[18,1,18,5],[24,1,24,2],[27,1,27,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,"2013 MSJC Anchor Bolt Design ",null,null,null,null,null,null,null,null,null,null,null,null,"(MM/DD/YYYY)"]
[null,"Allowable Stress Design"]
[]
[null,"***user input indicated by blue cells"]
[]
[null,"DATA INPUT AND SUMMARY OF DESIGN"]
[]
[null,"Propeties and Geometry"]
[null,"Weather or Soil Exposure",null,"YES"]
[null,"Top or Face Mount",null,"Top"]
[null,{"$f":"IF(D12=\"Face\", \"**Assumed adequate distance from top/bottom of wall and spacing from adjacent anchors to develop breakout cone\", \"**Assumed adequate spacing from adjacent anchors to allow no overlap of breakout cones\")","v":"**Assumed adequate spacing from adjacent anchors to allow no overlap of breakout cones"}]
[]
[null,"Anchor Type =",null,"bent-bar"]
[null,"Anchor Yield Strength =",null,{"$f":"IF(D15=\"Headed\",60000,36000)","v":36000},"psi"]
[null,"Anchor Diameter, db =",null,0.875,"in"]
[null,"Anchor Hook Length, eb =",null,0,"in"]
[null,{"$f":"IF(D15=\"headed\",\"**For headed anchor set hook length equal to 0\",\"\")","v":""}]
[null,"f'm =",null,2000,"psi"]
[null,"Wall thickness, t =",null,7.625,"in"]
[null,"Edge Distance, lbe =",null,3.25,"in"]
[null,"Net Anchor Area, Ab =",null,{"$f":"IF(D17=0.5,0.142,IF(D17=0.625,0.226,IF(D17=0.75,0.334,IF(D17=0.875,0.462,\"NA\"))))","v":0.46200000000000002},"in2"]
[]
[null,"Effective Embed. Length, lb =",null,8,"in"]
[]
[null,"Loading"]
[null,"Shear Force, Vtotal =",null,500,"lbs"]
[null,"Offset distance, e =",null,2,"in"]
[null,"Dist. From C.L. of Bolt To Edge of Ledger, x =",null,4,"in"]
[null,"Direct Tension Force, Ptotal =",null,1000,"lbs"]
[]
[]
[]
[null,null,{"$f":"IF(AND(G44>D43, E70<=1),\"<<Anchor design is satisfactory. See detailed analysis>>\", \"<<Anchor is inadequate, revise design.  See detailed analysis>>\")","v":"<<Anchor design is satisfactory. See detailed analysis>>"}]
[]
[]
[]
[null,"Detailed Analysis"]
[null,"Check minimum embed. "]
[null,"[TMS 402-13 §1.17.6]","lb=",{"$f":"D25","v":8},"in",{"$f":"IF(D41>=I41,\">\",\"<\")","v":">"},"lb_min = min(4db,2 in) =",null,{"$f":"IF(4*D17<2,2,4*D17)","v":3.5},"in",{"$f":"IF(D25>=I41,\"<Satisfactory>\", \"<Fail, revise embed>\")","v":"<Satisfactory>"}]
[null,"Check minimum cover"]
[null,"[TMS 402-13 §1.16.4.1]","covermin=",{"$f":"IF(D11=\"YES\",IF(D17>(5/8),2,1.5),1.5)","v":2},"in"]
[null,null,"coveractual=","(for top mounted)",null,"t - leb =",{"$f":"IF(D12=\"Top\",MIN(D21-D22,D22),D21-D25)","v":3.25},"in",{"$f":"IF(D12=\"Top\",IF(G44>D43, \"<Satisfactory>\", \"<Fail, revise edge distance.>\"),\"\")","v":"<Satisfactory>"}]
[null,null,null,"(for face mounted)",null,"t - lb =",null,null,{"$f":"IF(D12=\"Face\",IF(G44>D43, \"<Satisfactory>\", \"<Fail, revise embed.>\"),\"\")","v":""}]
[null,"Total Tension Force Considering Ecc., baf"]
[null,null,null,null,{"$f":"IF(D30>0,D31+D28*D29/((5/6)*D30), D31)","v":1300},"lbs",null,"***assuming that moment arm is (5/6) of 'd'"]
[]
[null,"Determine Tensile Capacity"]
[null,null,"h1=",{"$f":"IF(D12=\"Face\",0,IF(D25-$D$22<0,0,D25-$D$22))","v":4.75},"in","s1=",{"$f":"(8*D50*(D25-(D50/2)))^0.5","v":14.620191517213446},"in","A1=",{"$f":"IF(D50=0,0,((D50/(6*G50))*((3*D50*D50)+(4*G50*G50))))","v":49.962473927921785},"in2"]
[null,null,"h2=",{"$f":"IF(D12=\"Face\",0,IF(D25+$D$22-D21<0,0,D25+$D$22-D21))","v":3.625},"in","s2=",{"$f":"(8*D51*(D25-(D51/2)))^0.5","v":13.395428324618814},"in","A2=",{"$f":"IF(D51=0,0,((D51/(6*G51))*((3*D51*D51)+(4*G51*G51))))","v":34.150308353467125},"in2"]
[null,null,null,null,{"$f":"(PI()*(D25^2))-J50-J51","v":116.94914754835784},"in2"]
[null,"[TMS 402-13 Eqn. 8-1]","Masonry Tensile Breakout ",null,null,null,null,null,null,null,{"$f":"1.25*E52*($D$20^0.5)","v":6537.6560957195252},"lbs"]
[null,"[TMS 402-13 Eqn. 8-2]","Steel Tensile Yield ",null,null,null,null,null,null,null,{"$f":"0.6*$D$23*$D$16","v":9979.2000000000007},"lbs"]
[null,"[TMS 402-13 Eqn. 8-4]","Anchor Pullout  ",null,null,null,null,null,null,null,{"$f":"IF(D15=\"bent-bar\",((0.6*$D$20*$D$18*$D$17)+((120*3.141592)*(D25+$D$18+$D$17)*$D$17)),\"N/A\")","v":2927.5710449999997},"lbs"]
[null,null,"Design Axial Strength",null,null,null,null,null,null,null,{"$f":"IF(MIN(K53:K55)=K53,K53,IF(MIN(K53:K55)=K54,K54,K55))","v":2927.5710449999997},"lbs",{"$f":"IF(K56>$E$47,\">\", \"<\")","v":">"},"baf",{"$f":"IF(K56>$E$47, \"<Satisfactory>\",  \"<Fail, revise anchor>\")","v":"<Satisfactory>"}]
[null,null,"Governing Failure Mode:",null,{"$f":"IF(MIN(K53:K55)=K53,\"Breakout\",IF(MIN(K53:K55)=K54,\"Anchor Yielding\",\"Pullout\"))","v":"Pullout"}]
[]
[null,"Determine Shear Capacity"]
[null,null,null,null,{"$f":"(0.5)*(3.141592)*($D$22^2)","v":16.591532750000002},"in2"]
[null,"[TMS 402-13 Eqn. 8-6]","Masonry Shear Breakout ",null,null,null,null,null,null,null,{"$f":"1.25*E60*($D$20^0.5)","v":927.49487699785072},"lbs"]
[null,"[TMS 402-13 Eqn. 8-7]","Masonry Crushing ",null,null,null,null,null,null,null,{"$f":"(350*($D$20*$D$23)^0.25)","v":1929.6832946431423},"lbs"]
[null,"[TMS 402-13 Eqn. 8-8]","Anchor Shear Pryout",null,null,null,null,null,null,null,{"$f":"2*K53","v":13075.31219143905},"lbs"]
[null,"[TMS 402-13 Eqn. 8-9]","Steel Shear Yielding",null,null,null,null,null,null,null,{"$f":"0.36*$D$23*$D$16","v":5987.5199999999995},"lbs"]
[null,null,"Design Shear Strength",null,null,null,null,null,null,null,{"$f":"IF(MIN(K61:K64)=K61,K61,IF(MIN(K61:K64)=K62,K62,IF(MIN(K61:K64)=K63,K63,K64)))","v":927.49487699785072},"lbs",{"$f":"IF(K65>$D$28,\">\", \"<\")","v":">"},"bvf",{"$f":"IF(K65>$D$28, \"<Satisfactory>\",  \"<Fail, revise anchor>\")","v":"<Satisfactory>"}]
[null,null,"Governing Failure Mode:",null,{"$f":"IF(MIN(K61:K64)=K61,\"Breakout\",IF(MIN(K61:K64)=K62,\"Crushing\",IF(MIN(K61:K64)=K63,\"Pryout\",\"Yielding\")))","v":"Breakout"}]
[]
[null,"Check Combined Tension and Shear Interaction"]
[]
[null,"[TMS 402-13 Eqn. 8-10]",null,null,{"$f":"ROUND((E47/K56)+(D28/K65),3)","v":0.98299999999999998},{"$f":"IF(E70>=G70,\">\",\"<\")","v":"<"},1,{"$f":"IF(E70<=G70, \"<Satisfactory>\", \"<Fail, revise anchor>\")","v":"<Satisfactory>"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision Date: 03/19/2019"]

{"sheet":"Strength Design","index":3,"n_rows":73,"n_cols":15,"rows_kept":73,"cut":false,"hidden":false,"merged":[[56,4,56,6],[65,4,65,6],[43,2,44,2],[44,3,44,4],[27,1,27,2],[30,1,30,2],[14,1,14,2],[16,1,16,2],[72,14,72,15],[69,1,70,1],[69,4,70,4],[43,8,44,10],[15,1,15,2],[40,10,40,14],[69,6,70,6],[69,5,70,5],[69,7,70,8],[65,2,65,3],[40,6,40,7],[56,2,56,3],[43,6,44,6],[43,7,44,7],[29,1,29,2],[43,3,43,4],[1,12,1,13],[12,1,13,4],[18,1,18,4],[17,1,17,2],[34,2,35,11],[23,1,23,2],[22,1,22,2],[21,1,21,2],[20,1,20,2],[19,1,19,2],[24,1,24,2],[28,1,28,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,"2013 MSJC Anchor Bolt Design ",null,null,null,null,null,null,null,null,null,null,null,null,"(MM/DD/YYYY)"]
[null,"Strength Design"]
[]
[null,"***user input indicated by blue cells"]
[]
[null,"DATA INPUT AND SUMMARY OF DESIGN"]
[]
[null,"Propeties and Geometry"]
[null,"Weather or Soil Exposure",null,"YES"]
[null,"Top or Face Mounted",null,"Top"]
[null,{"$f":"IF(D12=\"Face\", \"**Assumed adequate distance from top/bottom of wall and spacing from adjacent anchors to develop breakout cone\", \"**Assumed adequate spacing from adjacent anchors to allow no overlap of breakout cones\")","v":"**Assumed adequate spacing from adjacent anchors to allow no overlap of breakout cones"}]
[]
[null,"Anchor Type =",null,"headed"]
[null,"Anchor Yield Strength, fy =",null,{"$f":"IF(D15=\"Headed\",60000,36000)","v":60000},"psi"]
[null,"Anchor Diameter, db =",null,0.5,"in"]
[null,"Anchor Hook Length, eb =",null,0,"in"]
[null,{"$f":"IF(D15=\"headed\",\"**For headed anchor set hook length equal to 0\",\"\")","v":"**For headed anchor set hook length equal to 0"}]
[null,"f'm =",null,2000,"psi"]
[null,"Wall thickness, t =",null,7.625,"in"]
[null,"Edge Distance, lbe =",null,3.25,"in"]
[null,"Net Anchor Area, Ab =",null,{"$f":"IF(D17=0.5,0.142,IF(D17=0.625,0.226,IF(D17=0.75,0.334,IF(D17=0.875,0.462,\"NA\"))))","v":0.14199999999999999},"in2"]
[]
[null,"Effective Embed. Length, lb =",null,8,"in"]
[]
[null,"Loading (factored)"]
[null,"Shear Force, Vu =",null,500,"lbs"]
[null,"Offset distance, e =",null,2,"in"]
[null,"Dist. From C.L. of Bolt To Edge of Ledger, x =",null,4,"in"]
[null,"Direct Tension Force, Pu =",null,1000,"lbs"]
[]
[]
[]
[null,null,{"$f":"IF(AND(G44>D43, E70<=1),\"<<Anchor design is satisfactory. See detailed analysis>>\", \"<<Anchor is inadequate, revise design.  See detailed analysis>>\")","v":"<<Anchor design is satisfactory. See detailed analysis>>"}]
[]
[]
[]
[null,"Detailed Analysis"]
[null,"Check minimum embed. "]
[null,"[TMS 402-13 §1.17.6]","lb=",{"$f":"D25","v":8},"in",{"$f":"IF(D41>=I41,\">\",\"<\")","v":">"},"lb_min = min(4db,2 in) =",null,{"$f":"IF(4*D17<2,2,4*D17)","v":2},"in",{"$f":"IF(D25>=I41,\"<Satisfactory>\", \"<Fail, revise embed>\")","v":"<Satisfactory>"}]
[null,"Check minimum cover"]
[null,"[TMS 402-13 §1.16.4.1]","covermin=",{"$f":"IF(D11=\"YES\",IF(D17>(5/8),2,1.5),1.5)","v":1.5},"in"]
[null,null,"coveractual=","(for top mounted)",null,"t - leb =",{"$f":"IF(D12=\"Top\",MIN(D21-D22,D22),D21-D25)","v":3.25},"in",{"$f":"IF(G44>D43, \"<Satisfactory>\",\"<Fail, revise embed.>\")","v":"<Satisfactory>"}]
[null,null,null,"(for face mounted)",null,"t - lb ="]
[null,"Total Tension Force Considering Ecc., baf"]
[null,null,null,null,{"$f":"D31+D28*D29/((5/6)*D30)","v":1300},"lbs",null,"***assuming that moment arm is (5/6) of 'd'"]
[]
[null,"Determine Tensile Capacity"]
[null,null,"h1=",{"$f":"IF(D12=\"Face\",0,IF(D25-$D$22<0,0,D25-$D$22))","v":4.75},"in","s1=",{"$f":"(8*D50*(D25-(D50/2)))^0.5","v":14.620191517213446},"in","A1=",{"$f":"IF(D50=0,0,((D50/(6*G50))*((3*D50*D50)+(4*G50*G50))))","v":49.962473927921785},"in2"]
[null,null,"h2=",{"$f":"IF(D12=\"Face\",0,IF(D25+$D$22-D21<0,0,D25+$D$22-D21))","v":3.625},"in","s2=",{"$f":"(8*D51*(D25-(D51/2)))^0.5","v":13.395428324618814},"in","A2=",{"$f":"IF(D51=0,0,((D51/(6*G51))*((3*D51*D51)+(4*G51*G51))))","v":34.150308353467125},"in2"]
[null,null,null,null,{"$f":"(PI()*(D25^2))-J50-J51","v":116.94914754835784},"in2"]
[null,"[TMS 402-13 Eqn. 9-1]","Masonry Tensile Breakout ( f = 0.5)",null,null,null,null,null,null,null,{"$f":"4*E52*($D$20^0.5)","v":20920.499506302483},"lbs"]
[null,"[TMS 402-13 Eqn. 9-2]","Steel Tensile Yield  ( f = 0.9)",null,null,null,null,null,null,null,{"$f":"$D$23*$D$16","v":8520},"lbs"]
[null,"[TMS 402-13 Eqn. 9-4]","Anchor Pullout  ( f = 0.65)",null,null,null,null,null,null,null,{"$f":"IF(D15=\"bent-bar\",((1.5*$D$20*$D$18*$D$17)+((300*3.141592)*(D25+$D$18+$D$17)*$D$17)),\"N/A\")","v":"N/A"},"lbs"]
[null,null,"Design Axial Strength",null,null,null,null,null,null,null,{"$f":"IF(MIN(K53:K55)=K53,0.5*K53,IF(MIN(K53:K55)=K54,0.9*K54,0.65*K55))","v":7668},"lbs",{"$f":"IF(K56>$E$47,\">\", \"<\")","v":">"},"baf",{"$f":"IF(K56>$E$47, \"<Satisfactory>\",  \"<Fail, revise anchor>\")","v":"<Satisfactory>"}]
[null,null,"Governing Failure Mode:",null,{"$f":"IF(MIN(K53:K55)=K53,\"Breakout\",IF(MIN(K53:K55)=K54,\"Anchor Yielding\",\"Pullout\"))","v":"Anchor Yielding"}]
[]
[null,"Determine Shear Capacity"]
[null,null,null,null,{"$f":"(0.5)*(3.141592)*($D$22^2)","v":16.591532750000002},"in2"]
[null,"[TMS 402-13 Eqn. 9-6]","Masonry Shear Breakout ( f = 0.5)",null,null,null,null,null,null,null,{"$f":"4*E60*($D$20^0.5)","v":2967.9836063931225},"lbs"]
[null,"[TMS 402-13Eqn. 9-7]","Masonry Crushing ( f = 0.5)",null,null,null,null,null,null,null,{"$f":"(1050*($D$20*$D$23)^0.25)","v":4310.41300223701},"lbs"]
[null,"[TMS 402-13 Eqn. 9-8]","Anchor Shear Pryout ( f = 0.5)",null,null,null,null,null,null,null,{"$f":"2*K53","v":41840.999012604967},"lbs"]
[null,"[TMS 402-13 Eqn. 9-9]","Steel Shear Yielding ( f = 0.9)",null,null,null,null,null,null,null,{"$f":"K54*0.6","v":5112},"lbs"]
[null,null,"Design Shear Strength",null,null,null,null,null,null,null,{"$f":"IF(MIN(K61:K64)=K61,0.5*K61,IF(MIN(K61:K64)=K62,0.5*K62,IF(MIN(K61:K64)=K63,0.5*K63,0.9*K64)))","v":1483.9918031965612},"lbs",{"$f":"IF(K65>$D$28,\">\", \"<\")","v":">"},"bvf",{"$f":"IF(K65>$D$28, \"<Satisfactory>\",  \"<Fail, revise anchor>\")","v":"<Satisfactory>"}]
[null,null,"Governing Failure Mode:",null,{"$f":"IF(MIN(K61:K64)=K61,\"Breakout\",IF(MIN(K61:K64)=K62,\"Crushing\",IF(MIN(K61:K64)=K63,\"Pryout\",\"Yielding\")))","v":"Breakout"}]
[]
[null,"Check Combined Tension and Shear Interaction"]
[]
[null,"[TMS 402-13 Eqn. 9-10]",null,null,{"$f":"ROUND((E47/K56)+(D28/K65),3)","v":0.50600000000000001},{"$f":"IF(E70>=G70,\">\",\"<\")","v":"<"},1,{"$f":"IF(E70<=G70, \"<Satisfactory>\", \"<Fail, revise anchor>\")","v":"<Satisfactory>"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision Date: 03/19/2019"]

{"sheet":"Figure 6","index":4,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[[4,1,4,2],[4,3,4,4],[4,5,4,6]]}
["Unity Interaction - Allowable Stress Design"]
["Wall thickness, t =",7.625]
["Anchor Type =","Headed"]
["Anchor Diameter, db =",0.5]
["Edge Distance, lbe =","2.0 in.",null,"3.8125 in.",null,"5.625 in."]
["Anchor Embedment, lb (in.)","Allowable Axial Load, Ba (lb)","Allowable Shear Load, Bv (lb)","Allowable Axial Load, Ba (lb)","Allowable Shear Load, Bv (lb)","Allowable Axial Load, Ba (lb)","Allowable Shear Load, Bv (lb)",null,"Ledger Connection",null,"Allowable Axial Load, Ba (lb)","Allowable Shear Load, Bv (lb)"]
[2,608.36667482892256,0,608.36667482892256,0,608.36667482892256,0,null,"Anchor Embedment, lb (in.) =",5.5,4600.8,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1216.7333496578451,null,"Anchor Diameter, db =",0.5,0,1337]
[3,1219.0747922940166,0,1368.8250183650759,0,1219.0747922940166,0,null,"*Anchor shear strength controlled by masonry crushing; requires at least 4.2 in. of edge distance."]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[3.5,1570.7940950486536,0,1863.1229416635751,0,1570.7940950486536,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766,null,"Legend Information"]
[4,1958.3022540969851,0,2404.0379883781902,0,1958.3022540969851,0,null,"Top of Wall, lbe = 2.0 in."]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766,null,"Top of Wall, lbe = 3.81 in."]
[4.5,2382.4231214281704,0,2864.3884796173438,0,2382.4231214281704,0,null,"Top of Wall, lbe = 5.625 in."]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766,null,"Side of Wall, lbe > 5.5 in.; lb = 5.5 in."]
[5,2843.5698599731049,0,3293.8269039233928,0,2843.5698599731049,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[5.5,3341.9741124262773,0,3707.8091595330247,0,3341.9741124262773,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[6,3826.9299664255673,0,4112.2230733091201,0,3826.9299664255673,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[7,4684.5516209822845,0,4903.1492064665599,0,4684.5516209822845,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[8,5112,0,5112,0,5112,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]

{"sheet":"Figure 7","index":5,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[[4,1,4,2],[4,3,4,4],[4,5,4,6]]}
["Unity Interaction - Strength Design"]
["Wall thickness, t =",7.625]
["Anchor Type =","Headed"]
["Anchor Diameter, db =",0.5]
["Edge Distance, lbe =","2.0 in.",null,"3.8125 in.",null,"5.625 in."]
["Anchor Embedment, lb (in.)","Design Axial Load, FBan (lb)","Design Shear Load, FBvn (lb)","Design Axial Load, FBan (lb)","Design Shear Load, FBvn (lb)","Design Axial Load, FBan (lb)","Design Shear Load, FBvn (lb)",null,"Ledger Connection",null,"Design Axial Load, FBan (lb)","Design Shear Load, FBvn (lb)"]
[2,973.38667972627616,0,973.38667972627616,0,973.38667972627616,0,null,"Anchor Embedment, lb (in.) =",5.5,7361.2,0]
[null,0,486.69333986313808,0,1768.5409351862663,0,1946.7733594525523,null,"Anchor Diameter, db =",0.5,0,2005.6]
[3,1950.5196676704263,0,2190.1200293841212,0,1950.5196676704263,0,null,"*Anchor shear strength controlled by masonry crushing; requires at least 4.2 in. of edge distance."]
[null,0,486.69333986313808,0,1768.5409351862663,0,2005.645642309315]
[3.5,2513.2705520778459,0,2980.9967066617205,0,2513.2705520778459,0]
[null,0,486.69333986313808,0,1768.5409351862663,0,2005.645642309315,null,"Legend Information"]
[4,3133.283606555176,0,3846.4607814051042,0,3133.283606555176,0,null,"Top of Wall, lbe = 2.0 in."]
[null,0,486.69333986313808,0,1768.5409351862663,0,2005.645642309315,null,"Top of Wall, lbe = 3.81 in."]
[4.5,3811.8769942850722,0,4583.0215673877501,0,3811.8769942850722,0,null,"Top of Wall, lbe = 5.625 in."]
[null,0,486.69333986313808,0,1768.5409351862663,0,2005.645642309315,null,"Side of Wall, lbe > 5.5 in.; lb = 5.5 in."]
[5,4549.7117759569683,0,5270.1230462774283,0,4549.7117759569683,0]
[null,0,486.69333986313808,0,1768.5409351862663,0,2005.645642309315]
[5.5,5347.1585798820433,0,5932.494655252839,0,5347.1585798820433,0]
[null,0,486.69333986313808,0,1768.5409351862663,0,2005.645642309315]
[6,6123.087946280908,0,6579.5569172945916,0,6123.087946280908,0]
[null,0,486.69333986313808,0,1768.5409351862663,0,2005.645642309315]
[7,7495.2825935716555,0,7668,0,7495.2825935716555,0]
[null,0,486.69333986313808,0,1768.5409351862663,0,2005.645642309315]
[8,7668,0,7668,0,7668,0]
[null,0,486.69333986313808,0,1768.5409351862663,0,2005.645642309315]

{"sheet":"Figure X","index":6,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[[4,1,4,2],[4,3,4,4],[4,5,4,6]]}
["Unity Interaction"]
["Wall thickness, t =",7.625]
["Anchor Type =","Headed"]
["Anchor Diameter, db =",0.5]
["Edge Distance, lbe =","2.0 in.",null,"3.8125 in.",null,"5.625 in."]
["Anchor Embedment, lb (in.)","Allowable Axial Load, Ba (lb)","Allowable Shear Load, Bv (lb)","Allowable Axial Load, Ba (lb)","Allowable Shear Load, Bv (lb)","Allowable Axial Load, Ba (lb)","Allowable Shear Load, Bv (lb)",null,"Ledger Connection",null,"Allowable Axial Load, Ba (lb)","Allowable Shear Load, Bv (lb)"]
[2,608.36667482892256,0,608.36667482892256,0,608.36667482892256,0,null,"Anchor Embedment, lb (in.) =",5.5,4600.8,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1216.7333496578451,null,"Anchor Diameter, db =",0.5,0,1337]
[3,1219.0747922940166,0,1368.8250183650759,0,1219.0747922940166,0,null,"*Anchor shear strength controlled by masonry crushing; requires at least 4.2 in. of edge distance."]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[3.5,1570.7940950486536,0,1863.1229416635751,0,1570.7940950486536,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766,null,"Legend Information"]
[4,1958.3022540969851,0,2404.0379883781902,0,1958.3022540969851,0,null,"Top of Wall, lbe = 2.0 in."]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766,null,"Top of Wall, lbe = 3.81 in."]
[4.5,2382.4231214281704,0,2864.3884796173438,0,2382.4231214281704,0,null,"Top of Wall, lbe = 5.625 in."]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766,null,"Side of Wall, lbe > 5.5 in.; lb = 5.5 in."]
[5,2843.5698599731049,0,3293.8269039233928,0,2843.5698599731049,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[5.5,3341.9741124262773,0,3707.8091595330247,0,3341.9741124262773,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[6,3826.9299664255673,0,4112.2230733091201,0,3826.9299664255673,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[7,4684.5516209822845,0,4903.1492064665599,0,4684.5516209822845,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]
[8,5112,0,5112,0,5112,0]
[null,0,304.18333741446128,0,1105.3380844914166,0,1337.0970948728766]

{"sheet":"Data","index":7,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Anchor Types",null,"Anchor Bolt Diameters",null,null,"Prism Strengths",null,null,"Weather/Soil",null,"Mounting"]
["headed",null,null,null,null,1900,null,null,"YES",null,"Top"]
["bent-bar",null,0.5,null,null,1500,null,null,"NO",null,"Face"]
[null,null,0.625,null,null,2000]
[null,null,0.75,null,null,2500]
[null,null,0.875,null,null,3000]
[null,null,null,null,null,3500]
[null,null,null,null,null,4000]