{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["holding down bolt design","from author"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"holding down bolt design","index":0,"n_rows":110,"n_cols":44,"rows_kept":110,"cut":false,"hidden":false,"merged":[[39,33,39,40],[21,15,21,22],[22,15,22,22],[25,15,25,27],[21,26,21,27],[22,26,22,27],[23,15,23,22],[23,26,23,27],[24,15,24,22],[24,26,24,27],[21,23,21,24],[22,23,22,24],[23,23,23,24],[24,23,24,24],[27,15,27,27],[28,15,28,27],[29,15,29,27],[30,15,30,27],[0,1,0,16],[0,18,0,28],[1,4,3,14],[1,15,2,21],[2,22,2,24],[2,25,2,28],[3,15,3,18],[3,19,3,21],[3,22,3,24],[3,25,3,28],[4,2,4,3],[4,4,4,14],[4,15,4,18],[4,19,4,21],[4,22,4,24],[6,15,6,27],[20,15,20,27],[14,2,14,11],[14,12,14,13],[15,2,15,11],[15,12,15,13],[16,2,16,11],[16,12,16,13],[8,2,8,5],[8,6,8,13],[9,2,9,5],[9,6,9,13],[10,2,10,11],[10,12,10,13],[6,2,6,13],[4,25,4,28],[11,2,11,11],[11,12,11,13],[12,12,12,13],[7,6,7,13],[62,2,62,13],[64,2,64,11],[64,12,64,13],[13,2,13,11],[13,12,13,13],[7,2,7,5],[27,12,27,13],[28,12,28,13],[29,12,29,13],[12,10,12,11],[12,2,12,9],[19,2,19,13],[17,2,17,11],[17,12,17,13],[18,2,18,11],[18,12,18,13],[63,2,63,5],[63,6,63,13],[59,2,59,11],[23,2,23,11],[34,2,34,11],[20,2,20,13],[24,2,24,11],[108,12,108,13],[109,12,109,13],[26,2,26,13],[27,2,27,11],[28,2,28,11],[29,2,29,11],[106,2,106,11],[107,2,107,11],[108,2,108,11],[106,12,106,13],[109,2,109,11],[76,12,76,13],[72,2,72,13],[74,2,74,11],[36,2,36,13],[92,2,92,11],[91,12,91,13],[92,12,92,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[32,2,32,11],[107,12,107,13],[33,2,33,11],[24,12,24,13],[21,9,21,13],[21,2,21,8],[22,2,22,11],[22,12,22,13],[23,12,23,13],[31,2,31,13],[37,2,37,11],[38,2,38,11],[37,12,37,13],[38,12,38,13],[40,2,40,13],[41,2,41,11],[42,2,42,11],[105,2,105,13],[44,12,44,13],[45,12,45,13],[41,12,41,13],[42,12,42,13],[43,12,43,13],[73,2,73,5],[73,6,73,13],[77,2,77,11],[77,12,77,13],[90,2,90,11],[91,2,91,11],[75,2,75,11],[75,12,75,13],[76,2,76,11],[90,12,90,13],[74,12,74,13],[89,2,89,13],[45,2,45,11],[44,2,44,11],[43,2,43,11]]}
[null,"version: 1.0. - FREE LITE VERSION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2015 Damian Janicki"]
[null,null,null,null,"  YourSpreadsheets™\n   2nd Floor, 52 Marcus Hill, London\n   www.YourSpreadsheets.co.uk\n   Tel: 020 7542 8734",null,null,null,null,null,null,null,null,null,null,"TEST PROJECT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision",null,null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job No:",null,null,null,22668,null,null,"Page:",null,null,"C/01"]
[null,null,"Section: ",null,"TEST MEMBER",null,null,null,null,null,null,null,null,null,null,"Prepared By:",null,null,null,"DJ",null,null,"Date:",null,null,{"$f":"TODAY()","v":"2015-02-23"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Holding down bolts - simplified check",null,null,null,{"$f":"M13","v":550},{"$f":"M23","v":46},"Picture1A",{"$f":"OR(AND(G8=AJ6,G9=AG8),AND(G8=AJ7,G9=AG8))","v":false}]
[null,null,"BOLT AND CONCRETE DATA",null,null,null,null,null,null,null,null,null,null,null,null,"DIAGRAM: SECTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cast-in holding down bolts",null,null,null,{"$f":"M14","v":50},{"$f":"\"M\"&30","v":"M30"},"Picture1B",{"$f":"OR(AND(G8=AJ6,G9=AG9),AND(G8=AJ7,G9=AG9))","v":false}]
[null,null,"Structure type:",null,null,null,"Post-grouted holding down bolts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"Based on overall length of bolt",null,null,"Post-grouted holding down bolts",null,null,null,{"$f":"M15","v":3},{"$f":"M77","v":300},"Picture3A",{"$f":"AND(G8=AJ8,G9=AG8)","v":true}]
[null,null,"Calculation type:",null,null,null,"Based on overall length of bolt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Based on bolt embedment depth",null,null,"Holding down bolts with anchor plates",null,null,null,{"$f":"M16","v":25},{"$f":"M75&\"x\"&M76","v":"50x50"},"Picture3B",{"$f":"AND(G8=AJ8,G9=AG9)","v":false}]
[null,null,"Bolt type:",null,null,null,"Grade 8.8 black bolts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH($G$8,$AJ$6:$AJ$9,0)","v":3},null,null,null,null,null,null,null,null,{"$f":"M17","v":50},null,"Picture4",{"$f":"G8=AJ9","v":false}]
[null,null,"Applied factored tension force per bolt 'Ft' [kN] =",null,null,null,null,null,null,null,null,null,100]
[null,null,"Bolt diameter 'dbolt' [mm] =",null,null,null,null,null,null,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade 4.6 black bolts",240,null,"Bolts are adequate.",null,null,"Bolt with limited length of thread"]
[null,null,{"$f":"IF(G9=AG8,\"Bolt overall length\",\"Bolt embedment depth\")","v":"Bolt overall length"},null,null,null,null,null,null,null,"Lbolt' [mm] =",null,550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade 8.8 black bolts",560,null,"Bolts are NOT adequate.",null,null,"Bolt threaded full length"]
[null,null,"Clear projection of bolt above nut 'Lprojection' [mm] =",null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade 10.9 black bolts",700]
[null,null,"Washer thickness 'twasher' [mm] =",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Untorqued general grade HSFG bolts",515,null,"Relatively smooth"]
[null,null,"Baseplate thickness 'tbaseplate' [mm] =",null,null,null,null,null,null,null,null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Untorqued higher grade HSFG bolts",700,null,"Relatively rough"]
[null,null,"Grout thickness 'tgrout' [mm] =",null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,"Bolt centre to centre spacing 'X' [mm] =",null,null,null,null,null,null,null,null,null,300]
[null,null,"Concrete shear strength 'vc' [N/mm2] =",null,null,null,null,null,null,null,null,null,0.34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,10,10,10,11,{"$f":"AK17","v":"N/A"}]
[null,null,{"$f":"IF(AND($G$8=$AJ$9,$M$109>1000),\"Shear stress at critical perimeter is greater than allowable\",IF(M28=AK17,\"Incorrect bolt diameter for this bolt type\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,13,13,13,15,15]
[null,null,"ADDITIONAL DATA FOR POST-GROUTED BOLTS",null,null,null,null,null,null,null,null,null,null,null,null,"SUMMARY OF RESULTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,16,16,16,18,18]
[null,null,"Inside surface of drill hole:",null,null,null,null,null,null,"Relatively rough",null,null,null,null,null,"Tension capacity of bolt:",null,null,null,null,null,null,null,{"$f":"$M$30","v":251.328},null,{"$f":"IF(X22>=AA22,\">\",\"<\")","v":">"},{"$f":"100","v":100},null,null,null,null,null,22,18,18,18,19,19,null,null,null,null,null,{"$f":"IF(X22<AA22,\"NOT OK\",\".\")","v":"."}]
[null,null,"Average hole diameter 'dhole' [mm] =",null,null,null,null,null,null,null,null,null,46,null,null,{"$f":"IF($G$8=$AJ$9,\"Concrete shear strength:\",\"Concrete pull-out resistance per bolt:\")","v":"Concrete pull-out resistance per bolt:"},null,null,null,null,null,null,null,{"$f":"IF($G$8=$AJ$9,FIXED($M$19,2),$M$35)","v":179.41664},null,{"$f":"IF(X23>=AA23,\">\",\"<\")","v":">"},{"$f":"IF($G$8=$AJ$9,FIXED($M$109,2)&\" MPa\",100)","v":100},null,null,null,null,null,24,19,19,19,22,22,null,null,null,null,null,{"$f":"IF(X23<AA23,\"NOT OK\",\".\")","v":"."}]
[null,null,"Grout design anchorage bond stress 'fbu' [N/mm2] =",null,null,null,null,null,null,null,null,null,3,null,null,"Bolt anchorage bond strength:",null,null,null,null,null,null,null,{"$f":"IF($G$8=$AJ$7,$M$93,IF($G$8=$AJ$8,$M$39,\"N/A\"))","v":3},null,{"$f":"IF(OR($G$8=$AJ$7,$G$8=$AJ$8),IF(X24>=AA24,\">\",\"<\"),\"\")","v":">"},{"$f":"IF(OR($G$8=$AJ$7,$G$8=$AJ$8),$M$91,\"\")","v":2.6659119445878621},null,null,null,null,null,27,22,22,22,24,24,null,null,null,null,null,"."]
[null,null,"Concrete characteristic strength 'fcu' [N/mm2] =",null,null,null,null,null,null,null,null,null,35,null,null,"Hole anchorage bond strength:",null,null,null,null,null,null,null,{"$f":"IF($G$8=$AJ$8,$M$46,\"N/A\")","v":2.9580398915498081},null,{"$f":"IF($G$8=$AJ$8,IF(X25>=AA25,\">\",\"<\"),\"\")","v":">"},{"$f":"IF($G$8=$AJ$8,$M$42,\"\")","v":1.7386382247312142},null,null,null,null,null,30,24,24,24,26,26,null,null,null,null,null,"."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(X22>=AA22,X23>=AA23,OR(X24>=AA24,X24=AK17),OR(X25>=AA25,X25=AK17)),$AJ$12,$AJ$13)","v":"Bolts are adequate."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,26,26,26,{"$f":"AK17","v":"N/A"},29]
[null,null,"CALCULATIONS: BOLT TENSION CAPACITY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,29,29,29,31,{"$f":"AK17","v":"N/A"}]
[null,null,"Bolt nut thickness 'tnut' [mm] =",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(AG19:AL27,MATCH(30,AG19:AG27,0),1+MATCH(G10,AG12:AG16,0))","v":24},null,null,"DESIGNER'S NOTES"]
[null,null,"Bolt tensile strength 'pt' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(AG12:AH16,MATCH(G10,AG12:AG16,0),2)","v":560},null,null,"Additional user notes about the design"]
[null,null,"Nominal tension capacity of bolt 'Pnom' [kN] =",null,null,null,null,null,null,null,null,null,{"$f":"0.8*M29*INDEX(AG30:AH38,MATCH(30,AG30:AG38,0),2)/1000","v":251.328},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,84.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,157]
[null,null,"CALCULATIONS: CONCRETE PULL-OUT RESISTANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,245]
[null,null,"Bolt embedment depth 'D' [mm] =",null,null,null,null,null,null,null,null,null,{"$f":"IF($G$9=$AG$9,$M$13,$M$13-$M$14-$M$28-$M$15-$M$16-$M$17)","v":398},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,303]
[null,null,"Eff. conical surface area of two bolts 'AD' [cm2] =",null,null,null,null,null,null,null,null,null,{"$f":"IF(M18>=2*M33,8.886*M33^2/100,AI55*10)","v":10553.92},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,353]
[null,null,"Concrete pull-out resistance per bolt 'Ptc' [kN] =",null,null,null,null,null,null,null,null,null,{"$f":"M34*M19/2/10","v":179.41664},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,459]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,561]
[null,null,"BOND STRESS CHECK: BOLT/GROUT INTERFACE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,694]
[null,null,"Bolt anchorage bond stress 'fb' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"$M$91","v":2.6659119445878621},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,817]
[null,null,"Grout design anchorage bond stress 'fbu1' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"$M$24","v":3}]
[]
[null,null,"BOND STRESS CHECK: GROUT/CONCRETE INTERFACE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,150,200,300,450,600,750,1000]
[null,null,"Hole anchorage bond stress 'fb' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"100*1000/(PI()*$M$23*$M$33)","v":1.7386382247312142},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,71.5,82.5,88.9,88.9,88.9,88.9,88.9,88.9,null,{"$f":"AG49","v":1000}]
[null,null,"Coefficient dependent on surface inside hole 'β' =",null,null,null,null,null,null,null,null,null,{"$f":"IF(J22=AJ15,0.28,0.5)","v":0.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,141.6,160.80000000000001,178,199.9,199.9,199.9,199.9,199.9,null,{"$f":"AG48","v":750}]
[null,null,"Grout design anchorage bond stress 'fbu1' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"$M$24","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,233.7,260.5,285.89999999999998,329.8,355.4,355.4,355.4,355.4,null,{"$f":"AG47","v":600}]
[null,null,"Conc. design anchorage bond stress 'fbu2' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"M43*(M25)^0.5","v":2.9580398915498081},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,484.3,525.79999999999995,566.4,643.4,742,799.7,799.7,799.7,null,{"$f":"AG46","v":450}]
[null,null,"Allowable anchorage bond stress 'fbu' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"MIN($M$24,$M$45)","v":2.9580398915498081},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,450,1027,1090,1152,1274,1448,1602,1728,1799,null,{"$f":"AG45","v":300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,1769,1853,1937,2103,2345,2574,2784,3072,null,{"$f":"AG44","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750,2711,2817,2922,3131,3439,3737,4021,4451,null,{"$f":"AG43","v":150}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,4726,4867,5008,5288,5705,6114,6513,7149,null,{"$f":"AG42","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$33","v":398},{"$f":"IF($AG$52=$AG$53,INDEX(AH42:AH49,$AG$52),($AG$51-INDEX($AG$42:$AG$49,$AG$52))*(INDEX(AH42:AH49,$AG$53)-INDEX(AH42:AH49,$AG$52))/(INDEX($AG$42:$AG$49,$AG$53)-INDEX($AG$42:$AG$49,$AG$52))+INDEX(AH42:AH49,$AG$52))","v":838.86400000000003},{"$f":"IF($AG$52=$AG$53,INDEX(AI42:AI49,$AG$52),($AG$51-INDEX($AG$42:$AG$49,$AG$52))*(INDEX(AI42:AI49,$AG$53)-INDEX(AI42:AI49,$AG$52))/(INDEX($AG$42:$AG$49,$AG$53)-INDEX($AG$42:$AG$49,$AG$52))+INDEX(AI42:AI49,$AG$52))","v":894.41066666666666},948.99199999999996,1055.3920000000001,1203.2533333333333,1323.8693333333333,1406.1893333333333,1452.576]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH($AG$51,AG42:AG49,1)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"9-MATCH($AG$51,AQ42:AQ49,-1)","v":5}]
[null,null,"NOTES:"]
[null,null,"- these calculations assume there is no shear load applied to the holding down bolts;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$18","v":300},{"$f":"IF($AH$56=$AH$57,INDEX($AH$51:$AO$51,1,$AH$56),($AH$55-INDEX($AH$41:$AO$41,1,$AH$56))*(INDEX($AH$51:$AO$51,1,$AH$57)-INDEX($AH$51:$AO$51,1,$AH$56))/(INDEX($AH$41:$AO$41,1,$AH$57)-INDEX($AH$41:$AO$41,1,$AH$56))+INDEX($AH$51:$AO$51,1,$AH$56))","v":1055.3920000000001}]
[null,null,"- bolts cannot be closer to the edge distance of a foundation than 1.5 x bolt embedment depth;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH($AH$55,AH41:AO41,1)","v":4}]
[null,null,"- (for anchor plate design only) anchor plate cannot be closer to the edge distance of a foundation than 2.0 x Dplate ;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"9-MATCH($AH$55,AQ42:AQ49,-1)","v":4}]
[null,null,{"$f":"IF($G$8=$AJ$6,\"- bolts require adequate anchorage by suitable sized washer or similar below bolt head.\",\"\")","v":""}]
[]
[null,null,"Spreadsheet provided by: www.YourSpreadsheets.co.uk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"calculations are based on BS5950 (2000), BS8110 (1997) and Concrete Society Advice No. 05"]
[]
[]
[null,null,"ADDITIONAL DATA FOR CAST-IN BOLTS",null,null,null,null,null,null,null,null,null,null,null,"case 2"]
[null,null,"Bolt surface type:",null,null,null,"Bolt threaded full length"]
[null,null,"Concrete characteristic strength 'fcu' [N/mm2] =",null,null,null,null,null,null,null,null,null,35,null,null,null,"  <- do not delete, used to fill in grey areas in main sheet"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"case 3"]
[]
[]
[]
[]
[]
[null,null,"ADDITIONAL DATA FOR ANCHOR PLATES",null,null,null,null,null,null,null,null,null,null,null,"case 4"]
[null,null,"Bolt surface type:",null,null,null,"Bolt threaded full length"]
[null,null,"Anchor plate length 'lplate' [mm] =",null,null,null,null,null,null,null,null,null,50]
[null,null,"Anchor plate width 'wplate' [mm] =",null,null,null,null,null,null,null,null,null,50]
[null,null,"Anchor plate depth from CL of top rebar 'Dplate' [mm] =",null,null,null,null,null,null,null,null,null,300]
[null,null,"Concrete characteristic strength 'fcu' [N/mm2] =",null,null,null,null,null,null,null,null,null,35]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"always"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"case 1, 2, 3"]
[]
[]
[]
[]
[null,null,"CALCULATIONS: BOND STRESS CHECK",null,null,null,null,null,null,null,null,null,null,null,"case 2"]
[null,null,"Bolt anchorage bond stress 'fb' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"100*1000/(PI()*30*$M$33)","v":2.6659119445878621}]
[null,null,"Coefficient dependent on bolt surface type 'β' =",null,null,null,null,null,null,null,null,null,{"$f":"IF(G64=AM12,0.28,0.5)","v":0.5}]
[null,null,"Allowable anchorage bond stress 'fbu' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"M92*(M65)^0.5","v":2.9580398915498081}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"case 3"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"case 3"]
[]
[]
[]
[]
[]
[]
[null,null,"CALCULATIONS: CONCRETE PULL-OUT RESISTANCE",null,null,null,null,null,null,null,null,null,null,null,"case 4"]
[null,null,"Anchor plate perimeter length 'u0' [mm] =",null,null,null,null,null,null,null,null,null,{"$f":"2*$M$75+2*$M$76","v":200}]
[null,null,"Effective punching shear perimeter 'u' [mm] =",null,null,null,null,null,null,null,null,null,{"$f":"12*$M$77+2*$M$75+2*$M$76","v":3800}]
[null,null,"Shear stress at critical perimeter 'v' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"100*1000/$M$108/$M$77","v":8.771929824561403E-2}]
[null,null,"Conc. max. allowable shear stress 'vmax' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"MIN(5,0.8*M78^0.5)","v":4.7328638264796927}]

{"sheet":"from author","index":1,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,2,2,5],[2,6,2,9],[3,2,3,5],[3,6,3,9],[0,6,0,10],[0,1,0,5],[4,12,4,13],[6,2,9,9],[40,2,43,9],[12,2,29,9],[33,2,36,9]]}
[null,"Version: 1.0. - FREE LITE VERSION",null,null,null,null,"© 2015 Damian Janicki"]
[]
[null,null,"For latest updates and news visit:",null,null,null,"Contact me at:"]
[null,null,"www.YourSpreadsheets.co.uk",null,null,null,"info@yourspreadsheets.co.uk"]
[]
[]
[null,null,"General information:\nNote: This spreadsheet contains macros."]
[]
[]
[]
[]
[]
[null,null,"The Author takes no liability for use of this spreadsheet and gives no guarantee that it is error free. \n\nIn no event shall the Author be responsible for any special, incidental or consequential damages whatsoever arising from the use of this spreadsheet, even if the Author has been advised of the possibility of such damage.\n\nThis spreadsheet is a freeware and can be distributed freely but only in its original form.\n\nReverse-engineering, decompiling or disassembling of this spreadsheet is not allowable.\n\nBy using this spreadsheet you understand and agree with the above terms and conditions. You also acknowledge that you do not become the owner of this spreadsheet.\n\nDamian Janicki"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This is a Free Lite Version. The full version of the spreadsheet allows to:\n- Input your company information, change logo and change header information\n- Change applied load\n- Change bolt diameter"]
[]
[]
[]
[]
[]
[]
[null,null,"This spreadsheet is based on BS5950, BS8110 and Concrete Society Advice No. 05.\n\nChangelog:\n22.02.2015 - v.1.0. - official release of the spreadsheet."]