{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["masonry bearing","calculationstables","from author"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"masonry bearing","index":0,"n_rows":63,"n_cols":46,"rows_kept":63,"cut":false,"hidden":false,"merged":[[36,15,36,27],[26,2,26,9],[27,2,27,9],[28,2,28,11],[26,10,26,11],[54,2,54,9],[44,2,44,9],[44,10,44,13],[54,10,54,13],[38,15,38,25],[52,2,52,9],[51,2,51,9],[40,12,40,13],[41,12,41,13],[42,12,42,13],[47,12,47,13],[48,12,48,13],[41,15,41,27],[49,2,49,9],[39,10,39,11],[40,10,40,11],[41,10,41,11],[42,10,42,11],[39,12,39,13],[0,1,0,15],[0,16,0,28],[1,4,4,14],[1,15,3,21],[1,22,1,27],[2,22,2,24],[2,25,2,28],[3,22,3,24],[3,25,3,28],[4,15,4,17],[4,18,4,21],[4,22,4,24],[4,25,4,28],[13,12,13,13],[19,2,19,11],[19,12,19,13],[9,2,9,4],[9,5,9,13],[12,12,12,13],[18,12,18,13],[15,12,15,13],[14,2,14,11],[15,2,15,11],[16,2,16,11],[17,12,17,13],[17,2,17,11],[5,25,5,28],[17,15,17,27],[23,10,23,11],[23,12,23,13],[24,10,24,11],[24,12,24,13],[5,15,5,17],[5,18,5,21],[5,22,5,24],[7,15,7,27],[12,15,12,27],[8,15,8,24],[9,15,9,24],[8,25,8,27],[9,25,9,27],[16,12,16,13],[10,15,10,24],[10,25,10,27],[21,2,21,13],[20,12,20,13],[5,2,5,3],[5,4,5,14],[20,2,20,11],[18,2,18,11],[60,15,60,27],[60,2,60,14],[7,2,7,13],[8,2,8,4],[8,5,8,13],[10,2,10,11],[10,12,10,13],[11,2,11,11],[12,2,12,11],[11,12,11,13],[13,2,13,11],[14,12,14,13],[22,2,22,13],[23,2,23,9],[24,2,24,9],[25,2,25,9],[37,26,37,27],[38,26,38,27],[39,15,39,27],[37,15,37,25],[25,10,25,11],[25,12,25,13],[28,12,28,13],[50,2,50,9],[46,2,46,13],[31,2,31,13],[32,2,32,11],[33,2,33,11],[34,2,34,11],[35,2,35,11],[36,2,36,11],[32,12,32,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[39,31,39,34],[39,35,39,37],[45,31,45,34],[45,35,45,37],[39,2,39,9],[40,2,40,9],[41,2,41,9],[42,2,42,9],[38,2,38,13],[47,2,47,9],[26,12,26,13],[27,10,27,11],[27,12,27,13],[29,12,29,13],[42,15,42,23],[43,2,43,9],[53,2,53,9],[53,10,53,11],[43,10,43,11],[43,12,43,13],[53,12,53,13],[49,12,49,13],[50,12,50,13],[51,12,51,13],[52,12,52,13],[47,10,47,11],[48,10,48,11],[49,10,49,11],[50,10,50,11],[51,10,51,11],[52,10,52,11],[48,2,48,9],[29,2,29,11],[51,26,51,27],[52,26,52,27],[47,15,47,23],[48,15,48,23],[49,15,49,23],[50,15,50,23],[51,15,51,23],[42,24,42,25],[43,24,43,25],[43,15,43,23],[45,15,45,23],[46,15,46,23],[44,15,44,27],[42,26,42,27],[43,26,43,27],[45,26,45,27],[46,26,46,27],[47,26,47,27],[48,26,48,27],[49,26,49,27],[50,26,50,27],[56,2,56,13],[57,2,57,13],[58,2,58,13],[53,15,53,23],[13,26,13,27],[14,26,14,27],[15,26,15,27],[15,23,15,25],[14,23,14,25],[13,23,13,25],[13,15,13,22],[14,15,14,22],[15,15,15,22],[53,26,53,27],[45,24,45,25],[46,24,46,25],[47,24,47,25],[48,24,48,25],[49,24,49,25],[50,24,50,25],[51,24,51,25],[52,24,52,25],[53,24,53,25],[52,15,52,23]]}
[null,"Version: 1.0.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2016 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,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:",null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job No:",null,null,22813,null,null,null,"Date:",null,null,{"$f":"TODAY()","v":"2018-06-20"}]
[null,null,"Member: ",null,"BEARING DESIGN EXAMPLE",null,null,null,null,null,null,null,null,null,null,"Prepared By:",null,null,"DJ",null,null,null,"Checked By:",null,null,"DJ"]
[]
[null,null,"MASONRY DATA:",null,null,null,null,null,null,null,null,null,null,null,null,"PARTIAL SAFETY FACTORS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH($F$9,$AF$9:$AK$9,0)","v":3}]
[null,null,"Masonry type:",null,null,"Aggregate concrete blocks (<25% voids)",null,null,null,null,null,null,null,null,null,"Manufacturing control of masonry units:",null,null,null,null,null,null,null,null,null,"Category II",null,null,null,null,null,"Clay or calcium silicate bricks","Autoclaved aerated concrete blocks","Aggregate concrete blocks (<25% voids)","Aggregate concrete blocks (25% to 60% voids)","Solid aggregate concrete blocks collar jointed","Solid aggregate concrete blocks laid flat"]
[null,null,"Lateral supports:",null,null,"Provide enhanced resistance to lateral movement",null,null,null,null,null,null,null,null,null,"Construction control of masonry wall:",null,null,null,null,null,null,null,null,null,"Normal",null,null,null,null,null,"Provide simple resistance to lateral movement","Provide enhanced resistance to lateral movement"]
[null,null,"Wall type:",null,null,null,null,null,null,null,null,null,"Single",null,null,"Partial safety factor for material strength 'γm' :",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Z9,AJ27:AL28,IF(Z10=\"Special\",2,3),FALSE)","v":3.5},null,null,null,null,null,"Single","Cavity"]
[null,null,"Thickness of load bearing leaf 't1' [mm] =",null,null,null,null,null,null,null,null,null,215,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M11=\"Single\",0,M13)","v":0},"mm",null,null,null,"leaf thickness",{"$f":"215","v":215}]
[null,null,"Thickness of second leaf 't2' [mm] =",null,null,null,null,null,null,null,null,null,102.5,null,null,"SUMMARY OF RESULTS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M14*1000","v":2800},"mm",null,null,null,"bearing width",{"$f":"M34","v":215}]
[null,null,"Clear height of masonry wall 'h' [m] =",null,null,null,null,null,null,null,null,null,2.8,null,null,"Bearing stress below supported beam =",null,null,null,null,null,null,null,{"$f":"FIXED(K42,2)&IF(K44<=1,\" < \",\" > \")&FIXED(K43,2)","v":"1.75 > 1.57"},null,null,{"$f":"IF(K44>1,\"N/A\",\"OK\")","v":"N/A"},null,null,null,null,{"$f":"IF($F$10=$AG$10,0.75,1)*AF13","v":2100},"mm",null,null,null,"bearing length",{"$f":"M35","v":150},null,{"$f":"AF9","v":"Clay or calcium silicate bricks"},"Autoclaved aerated concrete blocks","Aggregate concrete blocks (<25% voids)","Aggregate concrete blocks (25% to 60% voids)","Solid aggregate concrete blocks collar jointed","Solid aggregate concrete blocks laid flat"]
[null,null,"Compressive unit strength 'punit' [N/mm2] =",null,null,null,null,null,null,null,null,null,5.2,null,null,"Bearing stress below spreader =",null,null,null,null,null,null,null,{"$f":"IF(AF44=0,\"N/A\",FIXED(CHOOSE($AK$50,AL53,AM58,AN54,AO54),2)&IF(CHOOSE($AK$50,AL55,AM60,AN56,AO56)<=1,\" < \",\" > \")&FIXED(CHOOSE($AK$50,AL54,AM59,AN55,AO55),2))","v":"1.64 < 2.51"},null,null,{"$f":"IF(AF44=0,\"\",IF(CHOOSE($AK$50,AL55,AM60,AN56,AO56)<=1,\"OK\",\"NOT OK\"))","v":"OK"},null,null,null,null,"M2 (iv)","M4 (iii)","M6 (ii)","M12 (i)",null,"edge distance",{"$f":"M36","v":0},null,5,2.9,2.9]
[null,null,"Least horizontal dimension of masonry unit [mm] =",null,null,null,null,null,null,null,null,null,100,null,null,"Bearing stress in wall at 0.4 h below beam =",null,null,null,null,null,null,null,{"$f":"FIXED(K52,2)&IF(K54<=1,\" < \",\" > \")&FIXED(K53,2)","v":"0.32 < 0.96"},null,null,{"$f":"IF(K54<=1,\"OK\",\"NOT OK\")","v":"OK"},null,null,null,null,"Category I","Category II",null,null,null,"spreader length",{"$f":"AA38","v":440},null,10,3.6,3.6]
[null,null,{"$f":"IF($AF$8=6,\"As laid height of flat blocks [mm] =\",\"Height of conventionally laid masonry unit [mm] =\")","v":"Height of conventionally laid masonry unit [mm] ="},null,null,null,null,null,null,null,null,null,215,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal","Special",null,null,null,"spreader height",{"$f":"AA39","v":215},null,15,5.2,5.2]
[null,null,"Mortar strength class/designation =",null,null,null,null,null,null,null,null,null,"M2 (iv)",null,null,"DIAGRAM:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bearing eccentricity",{"$f":"IF(AF34=1,M37,0)","v":0},null,20,7.3,7.3]
[null,null,"Effective thickness of masonry wall 'teff' [mm] =",null,null,null,null,null,null,null,null,null,{"$f":"MAX(215,AF12,2/3*(215+AF12))","v":215},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,">=3",null,null,{"$f":"AA38&\" x \"&AA39&\" x \"&215&\" Spreader\"","v":"440 x 215 x 215 Spreader"},null,null,30,10.4,10.4]
[null,null,"Effective height of masonry wall 'heff' [m] =",null,null,null,null,null,null,null,null,null,{"$f":"AF14/1000","v":2.1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$15","v":5.2},{"$f":"$M$15","v":5.2},5.2,null,null,null,null,null,40,null,17.5]
[null,null,"Characteristic compressive strength 'fk' [N/mm2] =",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AF8=1,AF8=5,AF8=6),calculationstables!I7,calculationstables!I13)","v":4.4000000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AF$8=AF19,\"THIS ONE\",\"\")","v":""},{"$f":"IF($AF$8=AG19,\"THIS ONE\",\"\")","v":""},{"$f":"IF($AF$8>=AH19,\"THIS ONE\",\"\")","v":""},null,null,null,null,null,50,null,22.5]
[null,null,{"$f":"IF(AE29<>\"\",AE29,IF(AF29<>\"\",AF29,\"\"))","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,null,null,null,null,null,null,null,75,null,30]
[null,null,"LOADING:",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,null,100,null,40]
[null,null,null,null,null,null,null,null,null,null,"factor",null,"load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(AF8=1,COUNTIF(AN15:AN25,M15)=0),AND(AF8=2,COUNTIF(AO15:AO19,M15)=0),AND(AF8>=3,COUNTIF(AP15:AP23,M15)=0)),\"ERROR: incorrect compressive strength selected\",1)","v":1},1,null,null,null,null,null,null,null,125]
[null,null,"Beam dead load reaction 'Rdead' [kN] =",null,null,null,null,null,null,null,1.4,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(M33=\"Yes\",M34>215),\"Error: bearing width is greater than wall thickness (t)\",1)","v":1},null,{"$f":"IF(SUM(AE24:AF28)<10,1,0)","v":0},null,null,null,null,null,150]
[null,null,"Beam imposed load reaction 'Rimposed' [kN] =",null,null,null,null,null,null,null,1.6,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF8=1,\"\",IF(calculationstables!F31=0,\"ERROR: \"&VLOOKUP(AF8,calculationstables!B29:G33,6,FALSE),1))","v":1},{"$f":"IF(AND(M33=\"No\",M35>215),\"Error: bearing length is greater than wall thickness (t)\",1)","v":1}]
[null,null,"Wall distributed dead load 'UDLdead' [kN/m] =",null,null,null,null,null,null,null,1.4,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(AF34=1,M37>AG34),\"Error: eccentricity is greater than \"&AG34&\" mm\",1)","v":1},null,null,null,"Category I",2.5,3.1]
[null,null,"Wall distributed imposed load 'UDLimposed' [kN/m] =",null,null,null,null,null,null,null,1.6,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AF44=0,1,IF(AND(M33=\"Yes\",AA38<M35),\"Error: length of spreader is less than length of bearing\",IF(AND(M33=\"No\",AA38<M34),\"Error: length of spreader is less than width of bearing\",1)))","v":1},null,null,null,"Category II",2.8,3.5]
[null,null,"Total factored beam reaction 'Rtotal' [kN] =",null,null,null,null,null,null,null,null,null,{"$f":"K25*20+K26*M26","v":52},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE24<>1,AE24,IF(AE25<>1,AE25,IF(AE26<>1,AE26,IF(AE27<>1,AE27,IF(AE28<>1,AE28,\"\")))))","v":""},{"$f":"IF(AF24<>1,AF24,IF(AF25<>1,AF25,IF(AF26<>1,AF26,IF(AF27<>1,AF27,IF(AF28<>1,AF28,\"\")))))","v":""}]
[null,null,"Total factored distributed load 'UDLtotal' [kN/m] =",null,null,null,null,null,null,null,null,null,{"$f":"K27*10+K28*M28","v":30},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No",null,null,null,"ea",{"$f":"(K48^2/2400-0.015)*215","v":5.3215116279069754}]
[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,null,"ex",{"$f":"K49","v":32.5},null,null,"Parallel",{"$f":"AND(M33=AF30,AF44=0)","v":false}]
[null,null,"SUPPORTED BEAM DETAILS:",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,"et",{"$f":"0.6*AL31+AL30","v":24.821511627906975},null,null,"ParallelSpreader",{"$f":"AND(M33=AF30,AF44=1)","v":false}]
[null,null,"Supported beam spans parallel to wall:",null,null,null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M33=\"No\",M36,0)","v":0},null,null,null,null,"em",{"$f":"MAX(AL31,AL32)","v":32.5},null,null,"Perpendicular",{"$f":"AND(M33=AG30,AF44=0)","v":false}]
[null,null,"Bearing width 'bbearing' [mm] =",null,null,null,null,null,null,null,null,null,215,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M33=\"Yes\",M34<215),1,0)","v":0},{"$f":"215/2-M34/2","v":0},{"$f":"IF(AND(M33=\"Yes\",M34=215),0,IF(M33=\"yes\",M37,215/2-M35/2))","v":32.5},null,null,"beta",{"$f":"MAX(0,IF(K48<=6,1,IF(AL33<=0.05*215,1,1.1*(1-2*AL33/215))))","v":0.76744186046511631},null,null,"PerpendicularSpreader",{"$f":"AND(M33=AG30,AF44=1)","v":true}]
[null,null,"Bearing length 'lbearing' [mm] =",null,null,null,null,null,null,null,null,null,150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[All dimensions are in mm. Not to scale]"]
[null,null,"Edge distance 'cedge' [mm] =",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumed triangular stress distribution"]
[null,null,"Bearing eccentricity 'ex' [mm] =",null,null,null,null,null,null,null,null,null,0,null,null,"SPREADER (PADSTONE) DETAILS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stress distribution similar to semi-infinite beam on elastic foundation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spreader length 'lspreader' [mm] =",null,null,null,null,null,null,null,null,null,null,440,null,null,null,null,{"$f":"MATCH(P40,AF36:AF37,0)","v":1}]
[null,null,"CALCULATIONS: BEARING STRESS BELOW SUPPORTED BEAM",null,null,null,null,null,null,null,null,null,null,null,null,"Spreader height 'hspreader' [mm] =",null,null,null,null,null,null,null,null,null,null,215]
[null,null,"Bearing type:",null,null,null,null,null,null,null,{"$f":"AM40","v":"Type 1"},null,null,null,null,"Assumed triangular stress distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 1",null,null,null,"Type 2",null,null,{"$f":"IF(OR(AJ41=1,AK41=1,AL41=1),AJ40,IF(OR(AF41=1,AG41=1,AH41=1,AI41=1),AF40,\"Not applicable\"))","v":"Type 1"}]
[null,null,"Bearing factor:",null,null,null,null,null,null,null,{"$f":"AM41","v":1.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M33=\"Yes\",M34>=215/2,M35<=3*215),1,0)","v":0},{"$f":"IF(AND(M33=\"NO\",M35>=50,M35<=215/2),1,0)","v":0},{"$f":"IF(AND(M33=\"No\",M35>=215/2,M34<=2*215),1,0)","v":1},{"$f":"IF(AND(M33=\"No\",M35>215/2,M35<=215,M36>=M35,M34<=6*M35),1,0)","v":0},{"$f":"IF(AND(M33=\"Yes\",M34>=215/2,M35<=2*215),1,0)","v":0},{"$f":"IF(AND(M33=\"No\",M35<=215/2,M35>=50,M36>=M35,M34<=8*M35),1,0)","v":0},{"$f":"IF(AND(M33=\"No\",M35>215/2,M35<=215,M36>=M35,M34<=4*215),1,0)","v":0},{"$f":"IF(AM40=\"Type 2\",1.5,IF(AM40=\"Type 1\",1.25,1))","v":1.25}]
[null,null,"Design bearing stress =",null,null,null,null,null,null,null,{"$f":"M29/(M34*M35)*1000+M30/215","v":1.751937984496124},null,"N/mm2",null,null,"CALCULATIONS: SPREADER DESIGN"]
[null,null,"Allowable bearing stress =",null,null,null,null,null,null,null,{"$f":"K41*M21/Z11","v":1.5714285714285714},null,"N/mm2",null,null,"Bearing type:",null,null,null,null,null,null,null,null,{"$f":"IF(AF45=0,\"Type 3\",AM46)","v":"Type 3"}]
[null,null,"Utilisation factor =",null,null,null,null,null,null,null,{"$f":"K42/K43","v":1.1148696264975335},null,null,null,null,"Bearing factor:",null,null,null,null,null,null,null,null,{"$f":"IF(AF45=0,2,AM47)","v":2},null,null,null,null,null,null,{"$f":"IF(K43<K42,1,0)","v":1}]
[null,null,{"$f":"IF(K42>K43,\"Design bearing stress exceeds allowable:\", \"Bearing stress below beam:\")","v":"Design bearing stress exceeds allowable:"},null,null,null,null,null,null,null,{"$f":"IF(K42>K43,\"Use spreader\", \"OK\")","v":"Use spreader"},null,null,null,null,{"$f":"HLOOKUP($AK$50,$AG$52:$AJ$61,$AF53,FALSE)","v":"LOADING ACTS ECCENTRICALLY OUTSIDE MIDDLE THIRD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,AF33-(AA38-M34)/2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($AK$50,$AG$52:$AJ$62,$AF54,FALSE)","v":"Offset distance ="},null,null,null,null,null,null,null,null,{"$f":"IF(ISTEXT(HLOOKUP($AK$50,$AL$52:$AO$61,$AF53,FALSE)),HLOOKUP($AK$50,$AL$52:$AO$61,$AF53,FALSE),ROUND(HLOOKUP($AK$50,$AL$52:$AO$61,$AF53,FALSE),3))","v":107.5},null,{"$f":"HLOOKUP($AK$50,$AQ$52:$AT$61,$AF53,FALSE)","v":"mm"},null,null,null,null,"Type 1",null,null,null,"Type 2",null,null,{"$f":"IF(OR(AJ47=1,AK47=1,AL47=1),AJ46,IF(OR(AF47=1,AG47=1,AH47=1,AI47=1),AF46,\"Not applicable\"))","v":"Type 1"}]
[null,null,"CALCULATIONS: BEARING STRESS IN WALL AT 0.4 h BELOW BEAM",null,null,null,null,null,null,null,null,null,null,null,null,"Design bearing stress =",null,null,null,null,null,null,null,null,1.639,null,"N/mm2",null,null,null,null,{"$f":"IF(AND(M33=\"Yes\",M34>=215/2,M35<=3*215),1,0)","v":0},{"$f":"IF(AND(M33=\"NO\",M35>=50,M35<=215/2),1,0)","v":0},{"$f":"IF(AND(M33=\"No\",M35>=215/2,M34<=2*215),1,0)","v":1},{"$f":"IF(AND(M33=\"No\",M35>215/2,M35<=215,AF45>=M35,M34<=6*M35),1,0)","v":0},{"$f":"IF(AND(M33=\"Yes\",M34>=215/2,M35<=2*215),1,0)","v":0},{"$f":"IF(AND(M33=\"No\",M35<=215/2,M35>=50,AF45>=M35,M34<=8*M35),1,0)","v":0},{"$f":"IF(AND(M33=\"No\",M35>215/2,M35<=215,AF45>=M35,M34<=4*215),1,0)","v":0},{"$f":"IF(AM46=\"Type 2\",1.5,IF(AM46=\"Type 1\",1.25,1))","v":1.25}]
[null,null,"Slenderness ratio =",null,null,null,null,null,null,null,{"$f":"AF14/M19","v":9.7674418604651159},null,null,null,null,"Allowable bearing stress =",null,null,null,null,null,null,null,null,2.5139999999999998,null,{"$f":"HLOOKUP($AK$50,$AQ$52:$AT$61,$AF55,FALSE)","v":"N/mm2"}]
[null,null,"Eccentricity at top of wall =",null,null,null,null,null,null,null,{"$f":"AH34","v":32.5},null,"mm",null,null,"Utilisation factor =",null,null,null,null,null,null,null,null,0.65200000000000002,null,"mm4",null,null,null,null,"valid?",{"$f":"IF(OR(AND(M33=\"No\",M36>(AA38-M34)/2),AND(M33=\"Yes\",AA38=M35)),1,0)","v":0},{"$f":"IF(OR(AND(M33=\"No\",AF38=2,M36<=(AA38-M34)/2),AND(M33=\"Yes\",AF38=2,AA38>M35)),1,0)","v":0},{"$f":"IF(OR(AND(M33=\"No\",AF38=1,M36<=(AA38-M34)/2,(M36+M34/2)>=AA38/3),AND(M33=\"Yes\",AF38=1,M35/2>=AA38/3)),1,0)","v":0},{"$f":"IF(OR(AND(M33=\"No\",AF38=1,M36<(AA38-M34)/2,(M36+M34/2)<AA38/3),AND(M33=\"Yes\",AF38=1,M35/2<AA38/3)),1,0)","v":1}]
[null,null,"Capacity reduction factor 'β' =",null,null,null,null,null,null,null,{"$f":"AL34","v":0.76744186046511631},null,null,null,null,"Bearing stress below spreader:",null,null,null,null,null,null,null,null,"OK",null,"mm-1",null,null,null,null,"case",1,2,3,4,{"$f":"HLOOKUP(1,AG49:AJ50,2,FALSE)","v":4}]
[null,null,"Length of bearing distributed at 0.4 h =",null,null,null,null,null,null,null,{"$f":"IF(M33=\"Yes\",0.4*AF13+M35,IF(M36<0.4*AF13,M36+M34+0.4*AF13,0.8*AF13+M34))","v":1335},null,"mm",null,null," ",null,null,null,null,null,null,null,null," ",null,"N/mm2"]
[null,null,"Design bearing stress at 0.4 h =",null,null,null,null,null,null,null,{"$f":"M29*1000/(K51*215)+M30/215","v":0.32070377144848006},null,"N/mm2",null,null," ",null,null,null,null,null,null,null,null," ",null,"N/mm2",null,null,null,null,1,1,2,3,4,null,1,2,3,4,null,1,2,3,4]
[null,null,"Allowable bearing stress =",null,null,null,null,null,null,null,{"$f":"K50*M21/Z11","v":0.96478405315614624},null,"N/mm2",null,null," ",null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,2,"LOADING ACTS AT MIDPOINT OF SPREADER","LOADING ACTS ECCENTRICALLY","LOADING ACTS ECCENTRICALLY WITHIN MIDDLE THIRD","LOADING ACTS ECCENTRICALLY OUTSIDE MIDDLE THIRD",null,{"$f":"M29*1000/(AA38*215)+M30/215","v":0.68921775898520088},{"$f":"700*M21/1000","v":3.0800000000000005},{"$f":"IF(M33=\"Yes\",(AA38-M35)/2,(AA38-M34)/2-M36)","v":112.5},{"$f":"IF(M33=\"Yes\",M35/2,M36+M34/2)","v":107.5},null,"N/mm2","kN/mm2","mm","mm"]
[null,null,"Utilisation factor =",null,null,null,null,null,null,null,{"$f":"IF(K53=0,\"ERROR\",K52/K53)","v":0.33240990084708161},null,null,null,null," ",null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,3,"Design bearing stress =","Modulus of elasticity of masonry wall =","Eccentricity of load =","Offset distance =",null,{"$f":"Y44*M21/Z11","v":2.5142857142857147},30,{"$f":"M29*1000*(1+(6*AN53/AA38))/(AA38*215)+M30/215","v":1.5324812608110705},{"$f":"2*M29*1000/(3*AO53*215)+M30/215","v":1.639444744907157},null,"N/mm2","kN/mm2","N/mm2","N/mm2"]
[null,null,{"$f":"IF(K52<K53,\"Design bearing stress at 0.4 h below beam:\",\"Design bearing stress at 0.4 h below beam:\")","v":"Design bearing stress at 0.4 h below beam:"},null,null,null,null,null,null,null,{"$f":"IF(K52<K53,\"OK\",\"NOT OK\")","v":"OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Allowable bearing stress =","Modulus of elasticity of spreader =","Design bearing stress =","Design bearing stress =",null,{"$f":"AL53/AL54","v":0.27412069959638669},{"$f":"AM53*1000/AF13","v":1.1000000000000001},{"$f":"Y44*M21/Z11","v":2.5142857142857147},{"$f":"Y44*M21/Z11","v":2.5142857142857147},null," ","N/mm3","N/mm2","N/mm2"]
[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,5,"Utilisation factor =","Modulus of wall =","Allowable bearing stress =","Allowable bearing stress =",null,{"$f":"IF(AL53>AL54,\"NOT OK\", \"OK\")","v":"OK"},{"$f":"215*AA39^3/12","v":178062552.08333334},{"$f":"AN54/AN55","v":0.60950959236803925},{"$f":"AO54/AO55","v":0.65205188717898277},null," ","mm4"," "," "]
[null,null,"DESIGNER'S NOTES",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,6,{"$f":"IF(AL53>AL54,\"Design bearing stress exceeds allowable:\", \"Bearing stress below spreader:\")","v":"Bearing stress below spreader:"},"Moment of inertia of spreader =","Utilisation factor =","Utilisation factor =",null," ",{"$f":"(215*AM55/(4*AM54*1000*AM56))^(1/4)","v":1.8239768685275801E-3},{"$f":"IF(AN54>AN55,\"NOT OK\", \"OK\")","v":"OK"},{"$f":"IF(AO54>AO55,\"NOT OK\", \"OK\")","v":"OK"},null," ","mm-1"," "," "]
[null,null,"note 1",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,7," ","Constant 'γ' =",{"$f":"IF(AN54>AN55,\"Design bearing stress exceeds allowable:\", \"Bearing stress below spreader:\")","v":"Bearing stress below spreader:"},{"$f":"IF(AO54>AO55,\"Design bearing stress exceeds allowable:\", \"Bearing stress below spreader:\")","v":"Bearing stress below spreader:"},null," ",{"$f":"AM55*M29/(2*AM57^3*AM54*AM56)+M30/215","v":1.0218306712877596}," "," ",null," ","N/mm2"," "," "]
[null,null,"note 2",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,8," ","Design bearing stress ="," "," ",null," ",{"$f":"Y44*M21/Z11","v":2.5142857142857147}," "," ",null," ","N/mm2"," "," "]
[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,9," ","Allowable bearing stress ="," "," ",null," ",{"$f":"AM58/AM59","v":0.40640992608035886}," "," ",null," "," "," "," "]
[null,null,"Spreadsheet provided by: www.YourSpreadsheets.co.uk",null,null,null,null,null,null,null,null,null,null,null,null,"calculations are based on BS 5628-1: 2005",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10," ","Utilisation factor ="," "," ",null," ",{"$f":"IF(AM58>AM59,\"NOT OK\", \"OK\")","v":"OK"}," "," ",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,11," ",{"$f":"IF(AM58>AM59,\"Design bearing stress exceeds allowable:\", \"Bearing stress below spreader:\")","v":"Bearing stress below spreader:"}," "," "]
[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," "," "," "," "]

{"sheet":"calculationstables","index":1,"n_rows":84,"n_cols":91,"rows_kept":84,"cut":false,"hidden":true,"merged":[[2,1,3,7]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('masonry bearing'!AF8,$B$22:$F$27,4,TRUE)","v":2.2000000000000002}]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('masonry bearing'!AF8,B22:F27,5,FALSE)","v":4.4000000000000004}]
[null,null,null,null,null,null,null,null,{"$f":"'masonry bearing'!M17","v":215}]
[null,null,null,null,null,null,null,null,{"$f":"IF(B10=\"Thickness of load bearing leaf;\",215,'masonry bearing'!M16)","v":100}]
[null,null,null,null,null,null,null,null,{"$f":"I9/I10","v":2.15}]
[]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('masonry bearing'!AF8,B22:G27,6,FALSE)","v":4.4000000000000004}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Table 2a",null,{"$f":"P30","v":2.2240000000000002},null,null,null,null,null,"CS",5,10,15,20,30,40,50,75,100,125,150,null,"CS",2.9,3.6,5.2,7.3,10.4,null,"CS",2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40,null,"CS",2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40,null,"CS",2.9,3.6,5.2,7.3,10.4,null,"CS",2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40,null,"CS",2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40,null,"CS",2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40]
[null,2,"Table 2b","Table 2e",{"$f":"AB30","v":2.5},{"$f":"BE30","v":4.4000000000000004},{"$f":"IF(I$11<2,E23+(F23-E23)*(I$11-0.6)/(2-0.6),F23)","v":4.4000000000000004},null,"M12 (i)","\"i\"","M12 (i)",2.5,4,5.3,6.4,8.3000000000000007,10,11.6,15.2,18.3,21.2,23.9,null,"M12 (i)",1.4,1.7,2.5,3.4,4.4000000000000004,null,"M12 (i)",1.4,1.7,2.5,3.4,4.4000000000000004,6.3,7.5,9.5,11.2,null,"M12 (i)",2.8,3.5,5,6.8,8.8000000000000007,12.5,15,18.7,22.1,null,"M12 (i)",2.8,3.5,5,6.8,8.8000000000000007,null,"M12 (i)",2.8,3.5,5,6.6,8.1,11.2,13.1,16,19.399999999999999,null,"M12 (i)",2.8,3.4,4.4000000000000004,5.5,7,9.6999999999999993,11.6,14.2,16.5,null,"M12 (i)",2.8,3.5,4.5,5.6,7.2,9.6999999999999993,11.3,13.5,15.4]
[null,3,"Table 2c","Table 2d",{"$f":"AJ30","v":2.2000000000000002},{"$f":"AU30","v":4.4000000000000004},{"$f":"IF(I$11<2,E24+(F24-E24)*(I$11-0.6)/(2-0.6),F24)","v":4.4000000000000004},null,"M6 (ii)","\"ii\"","M6 (ii)",2.5,3.8,4.8,5.6,7.1,8.4,9.5,12,14.2,16.100000000000001,17.899999999999999,null,"M6 (ii)",1.4,1.7,2.5,3.2,4.2,null,"M6 (ii)",1.4,1.7,2.5,3.2,4.2,5.5,6.5,7.9,9.3000000000000007,null,"M6 (ii)",2.8,3.5,5,6.4,8.4,11.1,13,15.9,18.7,null,"M6 (ii)",2.8,3.5,5,6.4,8.4,null,"M6 (ii)",2.8,3.5,5,6.4,7.5,9.9,11.6,14,16.7,null,"M6 (ii)",2.5,2.8,3.5,4.5,5.7,7.9,9.4,11.6,13.5,null,"M6 (ii)",2.5,2.9,3.7,4.5999999999999996,5.9,7.9,9.1,10.8,12.3]
[null,4,"Table 2c","Table 2f",{"$f":"AJ30","v":2.2000000000000002},{"$f":"BM30","v":4.4000000000000004},{"$f":"IF(I$11<2,E25+(F25-E25)*(I$11-0.6)/(2-0.6),F25)","v":4.4000000000000004},null,"M4 (iii)","\"iii\"","M4 (iii)",2.5,3.4,4.3,5,6.3,7.4,8.4,10.5,12.3,14,15.4,null,"M4 (iii)",1.4,1.7,2.5,3.2,4.0999999999999996,null,"M4 (iii)",1.4,1.7,2.5,3.2,4.0999999999999996,5.0999999999999996,6,7.2,8.1999999999999993,null,"M4 (iii)",2.8,3.5,5,6.4,8.1999999999999993,10.1,12,14.5,16.8,null,"M4 (iii)",2.8,3.5,5,6.4,8.1999999999999993,null,"M4 (iii)",2.8,3.5,5,6.1,7.1,9,10.199999999999999,12,14,null,"M4 (iii)",2.2999999999999998,2.4,3.1,4,5.0999999999999996,7,8.3000000000000007,10.3,12,null,"M4 (iii)",2.2999999999999998,2.5,3.2,4.0999999999999996,5.2,7,8.1,9.6,11.1]
[null,5,"Table 2g",null,{"$f":"BX30","v":2.5},null,null,null,"M2 (iv)","\"iv\"","M2 (iv)",2.2000000000000002,2.8,3.6,4.0999999999999996,5.0999999999999996,6.1,7.1,9,10.5,11.6,12.7,null,"M2 (iv)",1.4,1.7,2.5,2.8,3.5,null,"M2 (iv)",1.4,1.7,2.2000000000000002,2.8,3.5,4.5999999999999996,5.3,6.2,7.1,null,"M2 (iv)",2.8,3.5,4.4000000000000004,5.6,7,9.1,10.5,12.5,14.5,null,"M2 (iv)",2.8,3.5,4.4000000000000004,5.6,7,null,"M2 (iv)",2.8,3.5,4.4000000000000004,5.8,6.7,8,8.9,10.199999999999999,11.5,null,"M2 (iv)",2.2000000000000002,2.2999999999999998,2.5,3.2,4.0999999999999996,5.7,6.8,8.1999999999999993,9.5,null,"M2 (iv)",2.2000000000000002,2.1,2.6,3.3,4.3,5.7,6.6,7.8,9]
[null,6,"Table 2h",null,{"$f":"CI30","v":2.6},null,null,null,null,null,null,null,"?",{"$f":"'masonry bearing'!AF20","v":5.2},null,"M2 (iv)",null,null,null,null,null,null,null,null,"?",{"$f":"'masonry bearing'!AG20","v":5.2},null,"M2 (iv)",null,null,null,null,"?",{"$f":"'masonry bearing'!AH20","v":5.2},null,"M2 (iv)",null,null,null,null,null,null,null,"?",{"$f":"'masonry bearing'!AH20","v":5.2},null,"M2 (iv)",null,null,null,null,null,null,"?",{"$f":"'masonry bearing'!AG20","v":5.2},null,"M2 (iv)",null,null,null,null,"?",{"$f":"'masonry bearing'!AH20","v":5.2},null,"M2 (iv)",null,null,null,null,null,null,null,"?",{"$f":"'masonry bearing'!AH20","v":5.2},null,"M2 (iv)",null,null,null,null,null,null,null,"?",{"$f":"'masonry bearing'!AH20","v":5.2},null,"M2 (iv)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"#",{"$f":"MATCH(N27,K22:V22,1)","v":2},{"$f":"N28+1","v":3},null,null,null,null,null,null,null,null,null,"#",{"$f":"MATCH(Z27,X22:AC22,1)","v":4},{"$f":"Z28+1","v":5},null,null,null,null,null,"#",{"$f":"MATCH(AH27,AE22:AN22,1)","v":4},{"$f":"AH28+1","v":5},null,null,null,null,null,null,null,null,"#",{"$f":"MATCH(AS27,AP22:AY22,1)","v":4},{"$f":"AS28+1","v":5},null,null,null,null,null,null,null,"#",{"$f":"MATCH(BC27,BA22:BF22,1)","v":4},{"$f":"BC28+1","v":5},null,null,null,null,null,"#",{"$f":"MATCH(BK27,BH22:BQ22,1)","v":4},{"$f":"BK28+1","v":5},null,null,null,null,null,null,null,null,"#",{"$f":"MATCH(BV27,BS22:CB22,1)","v":4},{"$f":"BV28+1","v":5},null,null,null,null,null,null,null,null,"#",{"$f":"MATCH(CG27,CD22:CM22,1)","v":4},{"$f":"CG28+1","v":5}]
[null,2,0.6,4.5,{"$f":"IF(OR(I$11<C29,I$11>D29),0,1)","v":1},null,"height to least horizontal dimension to be between 0.6 and 4.5",{"$f":"\"\"","v":""},null,null,null,null,null,{"$f":"VLOOKUP(\"CS\",$K$22:$V$26,N28,FALSE)","v":5},{"$f":"VLOOKUP(\"CS\",$K$22:$W$26,O28,FALSE)","v":10},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"CS\",X$22:AC$26,Z28,FALSE)","v":5.2},{"$f":"VLOOKUP(\"CS\",X$22:AD$26,AA28,FALSE)","v":7.3},null,null,null,null,null,null,{"$f":"VLOOKUP(\"CS\",$AE$22:$AN$26,AH28,FALSE)","v":5.2},{"$f":"VLOOKUP(\"CS\",$AE$22:$AO$26,AI28,FALSE)","v":7.3},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"CS\",AP$22:AY$26,AS28,FALSE)","v":5.2},{"$f":"VLOOKUP(\"CS\",AP$22:AZ$26,AT28,FALSE)","v":7.3},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"CS\",BA$22:BF$26,BC28,FALSE)","v":5.2},{"$f":"VLOOKUP(\"CS\",BA$22:BG$26,BD28,FALSE)","v":7.3},null,null,null,null,null,null,{"$f":"VLOOKUP(\"CS\",BH$22:BQ$26,BK28,FALSE)","v":5.2},{"$f":"VLOOKUP(\"CS\",BH$22:BR$26,BL28,FALSE)","v":7.3},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"CS\",BS$22:CB$26,BV28,FALSE)","v":5.2},{"$f":"VLOOKUP(\"CS\",BS$22:CC$26,BW28,FALSE)","v":7.3},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"CS\",CD$22:CM$26,CG28,FALSE)","v":5.2},{"$f":"VLOOKUP(\"CS\",CD$22:CN$26,CH28,FALSE)","v":7.3}]
[null,3,0.6,4.5,{"$f":"IF(OR(I$11<C30,I$11>D30),0,1)","v":1},null,"height to least horizontal dimension to be between 0.6 and 4.5",{"$f":"\"\"","v":""},null,null,null,null,null,{"$f":"VLOOKUP($P27,$K$22:$V$26,N28,FALSE)","v":2.2000000000000002},{"$f":"VLOOKUP($P27,$K$22:$W$26,O28,FALSE)","v":2.8},{"$f":"N30+(O30-N30)*(N27-N29)/(O29-N29)","v":2.2240000000000002},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AB$27,X$22:AC$26,Z28,FALSE)","v":2.5},{"$f":"VLOOKUP(AB27,$X$22:$AD$26,AA28,FALSE)","v":2.8},{"$f":"Z30+(AA30-Z30)*(Z27-Z29)/(AA29-Z29)","v":2.5},null,null,null,null,null,{"$f":"VLOOKUP($AJ27,$AE$22:$AN$26,AH28,FALSE)","v":2.2000000000000002},{"$f":"VLOOKUP($AJ27,$AE$22:$AO$26,AI28,FALSE)","v":2.8},{"$f":"AH30+(AI30-AH30)*(AH27-AH29)/(AI29-AH29)","v":2.2000000000000002},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AU$27,AP$22:AY$26,AS28,FALSE)","v":4.4000000000000004},{"$f":"VLOOKUP(AU27,AP$22:AZ$26,AT28,FALSE)","v":5.6},{"$f":"AS30+(AT30-AS30)*(AS27-AS29)/(AT29-AS29)","v":4.4000000000000004},null,null,null,null,null,null,null,{"$f":"VLOOKUP(BE$27,BA$22:BF$26,BC28,FALSE)","v":4.4000000000000004},{"$f":"VLOOKUP(BE27,$BA$22:$BG$26,BD28,FALSE)","v":5.6},{"$f":"BC30+(BD30-BC30)*(BC27-BC29)/(BD29-BC29)","v":4.4000000000000004},null,null,null,null,null,{"$f":"VLOOKUP(BM$27,BH$22:BQ$26,BK28,FALSE)","v":4.4000000000000004},{"$f":"VLOOKUP(BM27,BH$22:BR$26,BL28,FALSE)","v":5.8},{"$f":"BK30+(BL30-BK30)*(BK27-BK29)/(BL29-BK29)","v":4.4000000000000004},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(BX$27,BS$22:CB$26,BV28,FALSE)","v":2.5},{"$f":"VLOOKUP(BX27,BS$22:CC$26,BW28,FALSE)","v":3.2},{"$f":"BV30+(BW30-BV30)*(BV27-BV29)/(BW29-BV29)","v":2.5},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(CI$27,CD$22:CM$26,CG28,FALSE)","v":2.6},{"$f":"VLOOKUP(CI27,CD$22:CN$26,CH28,FALSE)","v":3.3},{"$f":"CG30+(CH30-CG30)*(CG27-CG29)/(CH29-CG29)","v":2.6}]
[null,4,0.6,4.5,{"$f":"IF(OR(I$11<C31,I$11>D31),0,1)","v":1},{"$f":"IF('masonry bearing'!AF8=5,E32,IF('masonry bearing'!AF8=6,E33,E29))","v":1},"height to least horizontal dimension to be between 0.6 and 4.5",{"$f":"\"\"","v":""}]
[null,5,1,1.2,{"$f":"IF(OR(I$11<C32,I$11>D32),0,1)","v":0},null,"height to wall thickness (t) to be between 1 and 1.2",{"$f":"\"\"","v":""}]
[null,6,0.4,0.6,{"$f":"IF(OR(I$11<C33,I$11>D33),0,1)","v":0},null,"height to wall thickness (t) to be between 0.4 and 0.6",{"$f":"\"\"","v":""}]
[]
[]
[]
[null,"b)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,10,15,20,30,40,50,75,100,125,150]
[null,null,2.9,3.6,5.2,7.3,10.4,null,null,null,null,null,null,null,null,null,"M12","/","(i)",2.5,4,5.3,6.4,8.3000000000000007,10,11.6,15.2,18.3,21.2,23.9]
[null,"M12",1.4,1.7,2.5,3.4,4.4000000000000004,null,null,null,null,null,null,null,null,null,"M6","/","(ii)",2.5,3.8,4.8,5.6,7.1,8.4,9.5,12,14.2,16.100000000000001,17.899999999999999]
[null,"M6",1.4,1.7,2.5,3.2,4.2,null,null,null,null,null,null,null,null,null,"M4","/","(iii)",2.5,3.4,4.3,5,6.3,7.4,8.4,10.5,12.3,14,15.4]
[null,"M4",1.4,1.7,2.5,3.2,4.0999999999999996,null,null,null,null,null,null,null,null,null,"M2","/","(iv)",2.2000000000000002,2.8,3.6,4.0999999999999996,5.0999999999999996,6.1,7.1,9,10.5,11.6,12.7]
[null,"M2",1.4,1.7,2.5,2.8,3.5]
[]
[null,"c)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,0.1,0.2,0.3]
[null,null,2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40,"or","greater",null,null,null,0,1,0.88,0.66,0.44]
[null,"M12",1.4,1.7,2.5,3.4,4.4000000000000004,6.3,7.5,9.5,11.2,null,null,null,null,null,6,1,0.88,0.66,0.44]
[null,"M6",1.4,1.7,2.5,3.2,4.2,5.5,6.5,7.9,9.3000000000000007,null,null,null,null,null,8,1,0.88,0.66,0.44]
[null,"M4",1.4,1.7,2.5,3.2,4.0999999999999996,5.0999999999999996,6,7.2,8.1999999999999993,null,null,null,null,null,10,0.97,0.88,0.66,0.44]
[null,"M2",1.4,1.7,2.2000000000000002,2.8,3.5,4.5999999999999996,5.3,6.2,7.1,null,null,null,null,null,12,0.93,0.87,0.66,0.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0.89,0.83,0.66,0.44]
[null,"d)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0.83,0.77,0.64,0.44]
[null,null,2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40,"or","greater",null,null,null,18,0.77,0.7,0.56999999999999995,0.44]
[null,"M12",2.8,3.5,5,6.8,8.8000000000000007,12.5,15,18.7,22.1,null,null,null,null,null,20,0.7,0.64,0.51,0.37]
[null,"M6",2.8,3.5,5,6.4,8.4,11.1,13,15.9,18.7,null,null,null,null,null,22,0.62,0.56000000000000005,0.43,0.3]
[null,"M4",2.8,3.5,5,6.4,8.1999999999999993,10.1,12,14.5,16.8,null,null,null,null,null,24,0.53,0.47,0.34]
[null,"M2",2.8,3.5,4.4000000000000004,5.6,7,9.1,10.5,12.5,14.5,null,null,null,null,null,26,0.45,0.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0.4,0.33]
[null,"e)"]
[null,null,2.9,3.6,5.2,7.3,10.4]
[null,"M12",2.8,3.5,5,6.8,8.8000000000000007]
[null,"M6",2.8,3.5,5,6.4,8.4]
[null,"M4",2.8,3.5,5,6.4,8.1999999999999993]
[null,"M2",2.8,3.5,4.4000000000000004,5.6,7]
[]
[null,"f)"]
[null,null,2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40,"or","greater"]
[null,"M12",2.8,3.5,5,6.6,8.1,11.2,13.1,16,19.399999999999999]
[null,"M6",2.8,3.5,5,6.4,7.5,9.9,11.6,14,16.7]
[null,"M4",2.8,3.5,5,6.1,7.1,9,10.199999999999999,12,14]
[null,"M2",2.8,3.5,4.4000000000000004,5.8,6.7,8,8.9,10.199999999999999,11.5]
[]
[null,"g)"]
[null,null,2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40,"or","greater"]
[null,"M12",2.8,3.4,4.4000000000000004,5.5,7,9.6999999999999993,11.6,14.2,16.5]
[null,"M6",2.5,2.8,3.5,4.5,5.7,7.9,9.4,11.6,13.5]
[null,"M4",2.2999999999999998,2.4,3.1,4,5.0999999999999996,7,8.3000000000000007,10.3,12]
[null,"M2",2.2000000000000002,2.2999999999999998,2.5,3.2,4.0999999999999996,5.7,6.8,8.1999999999999993,9.5]
[]
[null,"h)"]
[null,null,2.9,3.6,5.2,7.3,10.4,17.5,22.5,30,40,"or","greater"]
[null,"M12",2.8,3.5,4.5,5.6,7.2,9.6999999999999993,11.3,13.5,15.4]
[null,"M6",2.5,2.9,3.7,4.5999999999999996,5.9,7.9,9.1,10.8,12.3]
[null,"M4",2.2999999999999998,2.5,3.2,4.0999999999999996,5.2,7,8.1,9.6,11.1]
[null,"M2",2.2000000000000002,2.1,2.6,3.3,4.3,5.7,6.6,7.8,9]

{"sheet":"from author","index":2,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,6,0,10],[2,2,2,5],[2,6,2,9],[3,2,3,5],[3,6,3,9],[4,12,4,13],[6,2,9,9],[12,2,29,9],[33,2,36,9],[40,2,43,9]]}
[null,"Version: 1.0. - FREE LITE VERSION",null,null,null,null,"© 2016 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 axial load\n- Change column heights in x-axis etc"]
[]
[]
[]
[]
[]
[]
[null,null,"This spreadsheet is based on BS5628-1 (2005).\n\nChangelog:\n24.09.2016 - v.1.0. - official release of the spreadsheet."]