{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["timber frame wall","database","from author"],"not_rendered":{"images":1,"macros":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"timber frame wall","index":0,"n_rows":62,"n_cols":46,"rows_kept":62,"merged":[[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],[4,25,4,28],[6,2,6,13],[6,15,6,27],[6,44,6,45],[7,2,7,10],[7,11,7,13],[7,15,7,22],[7,23,7,27],[8,2,8,11],[8,12,8,13],[8,15,8,25],[8,26,8,27],[9,2,9,11],[9,12,9,13],[9,15,9,25],[9,26,9,27],[10,2,10,11],[10,12,10,13],[11,2,11,11],[11,12,11,13],[11,15,11,27],[12,2,12,11],[12,12,12,13],[12,15,12,22],[12,23,12,25],[12,26,12,27],[13,2,13,11],[13,12,13,13],[13,15,13,22],[13,23,13,25],[13,26,13,27],[13,44,13,45],[14,2,14,11],[14,12,14,13],[14,15,14,22],[14,23,14,25],[14,26,14,27],[14,44,18,45],[15,2,15,11],[15,12,15,13],[15,15,15,22],[15,23,15,25],[15,26,15,27],[16,2,16,11],[16,12,16,13],[16,15,16,22],[16,23,16,25],[16,26,16,27],[17,2,17,11],[17,12,17,13],[17,15,17,22],[17,23,17,25],[18,2,18,27],[19,2,19,13],[19,15,19,27],[20,2,20,9],[20,10,20,13],[21,2,21,11],[21,12,21,13],[22,2,22,11],[22,12,22,13],[23,2,23,11],[23,12,23,13],[24,2,24,9],[24,10,24,13],[25,2,25,11],[25,12,25,13],[26,2,26,11],[26,12,26,13],[27,2,27,11],[27,12,27,13],[28,2,28,9],[28,10,28,13],[29,2,29,11],[29,12,29,13],[30,2,30,11],[30,12,30,13],[31,2,31,9],[31,10,31,13],[33,2,33,13],[33,15,33,27],[34,2,34,9],[34,10,34,11],[34,12,34,13],[34,15,34,27],[35,2,35,9],[35,10,35,11],[35,12,35,13],[36,2,36,9],[36,10,36,11],[36,12,36,13],[36,15,36,27],[37,2,37,9],[37,10,37,11],[37,12,37,13],[37,15,37,23],[37,24,37,25],[37,26,37,27],[38,2,38,9],[38,10,38,11],[38,12,38,13],[38,15,38,23],[38,24,38,25],[38,26,38,27],[39,2,39,9],[39,10,39,11],[39,12,39,13],[39,15,39,23],[39,24,39,25],[39,26,39,27],[40,15,40,23],[40,24,40,25],[40,26,40,27],[41,2,41,5],[41,6,41,13],[41,15,41,27],[42,2,42,9],[42,10,42,11],[42,12,42,13],[43,2,43,9],[43,10,43,11],[43,12,43,13],[43,15,43,27],[44,2,44,9],[44,10,44,11],[44,12,44,13],[44,15,44,23],[44,24,44,25],[44,26,44,27],[45,2,45,9],[45,10,45,11],[45,12,45,13],[45,15,45,23],[45,24,45,25],[45,26,45,27],[46,2,46,13],[46,15,46,23],[46,24,46,25],[46,26,46,27],[47,2,47,13],[47,15,47,23],[47,24,47,25],[47,26,47,27],[48,2,48,13],[48,15,48,23],[48,24,48,25],[48,26,48,27],[49,2,49,9],[49,10,49,11],[49,12,49,13],[49,15,49,27],[50,2,50,9],[50,10,50,11],[50,12,50,13],[50,15,50,27],[50,36,50,39],[51,2,51,9],[51,10,51,11],[51,12,51,13],[51,15,51,27],[52,2,52,9],[52,10,52,11],[52,12,52,13],[52,15,52,27],[53,2,53,13],[53,15,53,27],[54,15,54,27],[55,2,55,6],[55,7,55,13],[55,15,55,23],[55,24,55,25],[55,26,55,27],[56,2,56,9],[56,10,56,11],[56,12,56,13],[56,15,56,23],[56,24,56,25],[56,26,56,27],[57,2,57,9],[57,10,57,11],[57,12,57,13],[57,15,57,23],[57,24,57,25],[57,26,57,27],[58,2,58,9],[58,10,58,11],[58,12,58,13],[58,15,58,23],[58,24,58,25],[58,26,58,27],[59,2,59,13],[59,15,59,23],[59,24,59,25],[59,26,59,27],[61,2,61,11],[61,15,61,27]]}
[null,"version: 1.0.",{"$nulls":16},"© 2020 Damian Janicki"]
[{"$nulls":4},"YourSpreadsheets™\nYour Office Address Goes Here\nwww.YourSpreadsheets.co.uk\nTel: 010 1234 567890 (example only)",{"$nulls":10},"TEST PROJECT NAME"]
[{"$nulls":22},"Revision",null,null,"B"]
[{"$nulls":15},"Job No:",{"$nulls":3},22668,null,null,"Page:",null,null,"C/01",{"$nulls":9},{"$f":"COUNTIF(AJ5:AJ7,TRUE)","v":0},null,null,{"$f":"COUNTIF(AM5:AM7,TRUE)","v":0},null,null,{"$f":"COUNTIF(AP5:AP27,TRUE)","v":0}]
[null,null,"Section: ",null,"TIMBER FRAME WALL EXAMPLE",{"$nulls":10},"Prepared By:",{"$nulls":3},"DJ",null,null,"Date:",null,null,{"$f":"TODAY()","v":"2020-03-16"},{"$nulls":9},{"$f":"M11<1","v":false},"ERROR: stud wall must be at least 1m long",null,{"$f":"FALSE","v":false},"NOTE: racking resistance to BS5268-6.1: 1996 is restricted to max 2.7m high wall panels. Racking calculations might be incorrect.",null,{"$f":"AA10<0","v":false},"to perform racking resistance calculations timber frame wall should be in compression"]
[{"$nulls":41},{"$f":"IF(K25<>AI17,IF(AH40=\"N/A\",TRUE,FALSE),FALSE)","v":false},"to perform racking resistance calculations change the secondary sheathing material (current combination not viable)"]
[null,null,"TIMBER FRAME WALL DATA",{"$nulls":12},"LOADING",{"$nulls":25},{"$f":"M16>610","v":false},"to perform racking resistance calculations stud spacing must be 610mm c/c max",null,"SUMMARY:"]
[null,null,"Building type (for racking resistance):",{"$nulls":8},"dwelling",{"$nulls":3},"Load duration:",{"$nulls":7},"Short-term",{"$nulls":6},1,null,"Bending only",{"$f":"AA10=0","v":false},{"$nulls":7},{"$f":"OR(M15<63)","v":false},"to perform racking resistance calculations wall studs must be at least 38x63mm",null,{"$f":"Y41","v":{"v":0.2893297267367512,"d":"0.29"}},"slenderness"]
[null,null,"Timber grade =",{"$nulls":9},"C24",null,null,"Wind load perpendicular to wall 'W' [kN/m2] =",{"$nulls":10},0.25,{"$nulls":3},2,null,"Bending and compression",{"$f":"AA10>0","v":true},{"$nulls":7},false,"to perform racking resistance calculations wall studs must grade C16 or better",null,{"$f":"K53","v":{"v":0.04575723546742629,"d":"0.05"}},"bending"]
[null,null,"Service class =",{"$nulls":9},1,null,null,"Line load on top of wall 'UDL' [kN/m] =",{"$nulls":10},{"v":65,"d":"65.00"},{"$nulls":5},"Bending and tension",{"$f":"AA10<0","v":false},{"$nulls":7},{"$f":"FALSE","v":false},"to perform racking resistance calculations wall must be min 2.4m2",null,{"$f":"K46","v":{"v":0.486316102875372,"d":"0.49"}},"compression"]
[null,null,"Timber frame wall length 'L' [m] =",{"$nulls":9},{"v":6,"d":"6.00"},{"$nulls":19},"Compression only",{"$f":"FALSE","v":false},{"$nulls":5},1,null,{"$f":"AND(X8<>AE28,X8<>AE29)","v":false},"to perform racking resistance calculations select short or very short load duration",null,{"$f":"K59","v":{"v":0.5411513534908661,"d":"0.54"}},"combined"]
[null,null,"Timber frame wall height 'H' [m] =",{"$nulls":9},{"v":2.7,"d":"2.70"},null,null,"SUMMARY OF RESULTS",{"$nulls":14},{"v":0.7,"d":"0.70"},null,"Tension only",{"$f":"FALSE","v":false},null,{"$f":"IF(M15<72,1,0)","v":0},{"$nulls":3},"C24",null,{"$f":"AF46=0","v":false},"to perform racking resistance calculations primary board thickness must be within +/-25% of standard thickness",null,{"$f":"Y49","v":{"v":0.07197288514117317,"d":"0.07"}},"deflection"]
[null,null,"Effective height factor (out of plane of wall) =",{"$nulls":9},0.85,null,null,"Slenderness =",{"$nulls":7},{"$f":"IF(OR(AH8,AH10,AH12),\"N/A\",FIXED(Y39,0)&IF(Y39<=Y40,\" < \",\" > \")&FIXED(Y40,0))","v":"52 < 180"},null,null,{"$f":"IF(OR(AH8,AH10,AH12),\"N/A\",IF(Y39<=Y40,\"OK\",\"NOT OK\"))","v":"OK"},{"$nulls":3},0.85,{"$nulls":8},{"$f":"ABS(AA10*M16/1000)","v":39.65},null,{"$f":"OR(AND(K21=AH22,M22<>AG58),AND(K25=AI23,M26<>AG58))","v":false},"to perform racking resistance calculations plasterboard thicnkess on separating walls must be 30mm"]
[null,null,"Stud breadth 'b' [mm] =",{"$nulls":9},{"v":63,"d":"63.0"},null,null,{"$f":"IF(AF23=AE23,\"Compression\",\"Tension\")&\" parallel to grain =\"","v":"Compression parallel to grain ="},{"$nulls":7},{"$f":"IF(AH8,\"N/A\",FIXED(K44,2)&IF(K44<=K45,\" < \",\" > \")&FIXED(K45,2))","v":"4.28 < 8.80"},null,null,{"$f":"IF(AH8,\"N/A\",IF(K44<=K45,\"OK\",\"NOT OK\"))","v":"OK"},{"$nulls":3},{"v":1,"d":"1.00"},{"$nulls":4},{"$f":"COUNTIF(AP5:AP20,TRUE)","v":0},{"$nulls":3},{"$f":"INDEX(AF27:AF31,MATCH(X8,AE27:AE31,0))","v":"Short"},null,{"$f":"AND(OR(K21=AH22,K25=AI23),M15<72)","v":false},"to perform racking resistance calculations wall studs must be at least 38x72mm for separating walls",null,"WARNING:"]
[null,null,"Stud depth 'h' [mm] =",{"$nulls":9},{"v":147,"d":"147.0"},null,null,"Bending parallel to grain =",{"$nulls":7},{"$f":"IF(OR(AH11,AH12),\"N/A\",FIXED(K51,2)&IF(K51<=K52,\" < \",\" > \")&FIXED(K52,2))","v":"0.61 < 13.39"},null,null,{"$f":"IF(OR(AH11,AH12),\"N/A\",IF(K51<=K52,\"OK\",\"NOT OK\"))","v":"OK"},{"$nulls":3},{"v":1.5,"d":"1.50"},{"$nulls":10},{"$f":"OR(AND(OR(K21=AH21,K21=AH22),M23<>AF48),IF(K25<>AI17,AND(OR(K25=AH21,K25=AH22),M27<>AH48)))","v":false},{"$f":"\"to perform racking resistance calculations specify standard \"&IF($K$32=$AE$19,\"nail\",\"screw\")&\" diameter for plasterboard sheathing.\"","v":"to perform racking resistance calculations specify standard nail diameter for plasterboard sheathing."},null,{"$f":"IF(AP4>0,INDEX(AQ5:AQ27,MATCH(TRUE,AP5:AP27,0)),\"\")","v":""}]
[null,null,"Stud spacing 's' [mm] =",{"$nulls":9},{"v":610,"d":"610.0"},null,null,{"$f":"IF(AF23=AE23,\"Axial compression\",\"Axial tension\")&\" and bending check =\"","v":"Axial compression and bending check ="},{"$nulls":7},{"$f":"IF(OR(AH8,AH11,AH12),\"N/A\",FIXED(K59,2)&IF(K59<=1,\" < \",\" > \")&FIXED(1,2))","v":"0.54 < 1.00"},null,null,{"$f":"IF(OR(AH8,AH11,AH12),\"N/A\",IF(K59<=1,\"OK\",\"NOT OK\"))","v":"OK"},{"$nulls":3},{"v":2,"d":"2.00"},{"$nulls":10},{"$f":"OR(AND(OR(K21=AH21,K21=AH22),M24<>AF49),IF(K25<>AI17,AND(OR(K25=AH21,K25=AH22),M28<>AH49)))","v":false},{"$f":"\"to perform racking resistance calculations specify standard \"&IF($K$32=$AE$19,\"nail\",\"screw\")&\" spacing for plasterboard sheathing.\"","v":"to perform racking resistance calculations specify standard nail spacing for plasterboard sheathing."}]
[null,null,"Thickness of top and bottom rails 'trails' [mm] =",{"$nulls":9},{"v":100,"d":"100.0"},null,null,"Stud deflection =",{"$nulls":7},{"$f":"IF(OR(AH11,AH12),\"N/A\",FIXED(Y48,2)&IF(Y48<=Y47,\" < \",\" > \")&FIXED(Y47,2))","v":"0.50 < 7.00"},null,null,{"$f":"IF(OR(AH11,AH12),\"N/A\",IF(Y48<=Y47,\"OK\",\"NOT OK\"))","v":"OK"},{"$nulls":6},"Bitumen board","None",{"$f":"AI17","v":"None"},{"$f":"AI17","v":"None"},{"$f":"AI17","v":"None"},null,{"$f":"63*M15","v":9261},null,{"$f":"OR(M24>300,M24<50,AND(K25<>AI17,OR(M28>300,M28<50)))","v":false},"to perform racking resistance calculations nails should be spaced at centres not greater than 300mm and not less than 50mm."]
[null,null,"Aggregate opening size 'Ao' [m2] =",{"$nulls":9},{"v":3,"d":"3.00"},null,null,"Total racking resistance =",{"$nulls":7},{"$f":"IF($AJ$14<>0,\"N/A   \",FIXED(AK45,2))&\" kN\"","v":"19.33 kN"},{"$nulls":9},"Medium board","Bitumen board","Bitumen board","Plasterboard","Plasterboard",null,{"$f":"63*M15*M15/6","v":226894.5},null,{"$f":"AND(K25<>AI17,AH46=0)","v":false},"to perform racking resistance calculations secondary board thickness must be within +/-25% of standard thickness."]
[null,null,{"$f":"IF(AJ4>0,INDEX(AK5:AK7,MATCH(TRUE,AJ5:AJ7,0)),IF(AM4>0,INDEX(AN5:AN7,MATCH(TRUE,AM5:AM7,0)),\"\"))","v":""},{"$nulls":27},"Nails",null,null,"OSB","Medium board","Plasterboard","Plasterboard separating",null,null,{"$f":"(M15*63^2)/6","v":97240.5},null,{"$f":"OR(AND(K21=AH17,M24>75),AND(K25=AI18,M28>75))","v":false},"to perform racking resistance calculations nail spacing for bitument board must not be greater than 75mm."]
[null,null,"SHEATHING & CLADDING DATA",{"$nulls":12},"DIAGRAM",{"$nulls":14},"Screws",null,null,"Particleboard","OSB","Plasterboard separating",{"$nulls":3},{"$f":"63*M15*M15*M15/12","v":16676745.75},null,{"$f":"OR(AND(K21<>AH21,K21<>AH22,M24>150),AND(K25<>AI17,K25<>AI22,K25<>AI23,M28>150))","v":false},"to perform racking resistance calculations nail spacing should not be greater than 150mm for perimeter nails."]
[null,null,"Primary board type:",{"$nulls":7},"OSB",{"$nulls":4}," ",{"$nulls":17},"Plasterboard","Particleboard",{"$nulls":4},{"$f":"(M15*63^3)/12","v":3063075.75}]
[null,null,{"$f":"\"Thickness (standard: \"&AF47&\"mm) [mm] =\"","v":"Thickness (standard: 9mm) [mm] ="},{"$nulls":9},{"v":9,"d":"9.0"},{"$nulls":20},"Plasterboard separating","Plasterboard",{"$nulls":4},{"$f":"SQRT(AN20/AN17)","v":42.4352447854375}]
[null,null,{"$f":"IF(AND(OR(K21=AH21,K21=AH22),K32=AE20),\"Screw\",\"Nail\")&\" diameter (standard: \"&AF48&\"mm) [mm] =\"","v":"Nail diameter (standard: 3mm) [mm] ="},{"$nulls":9},{"v":3,"d":"3.00"},{"$nulls":17},"Compression",{"$f":"IF(AA10>=0,AE23,AE24)","v":"Compression"},null,"Plywood","Plasterboard separating",{"$nulls":4},{"$f":"SQRT(AN21/AN17)","v":18.186533479473212},null,{"$f":"AJ47>0.75","v":false},"aggregate opening size is greater than 75% of wall area. Wall modification factor K106 is taken as zero."]
[null,null,{"$f":"IF(AND(OR(K21=AH21,K21=AH22),K32=AE20),\"Screw\",\"Nail\")&\" spacing (standard: \"&AF49&\"mm) [mm] =\"","v":"Nail spacing (standard: 150mm) [mm] ="},{"$nulls":9},{"v":150,"d":"150.0"},{"$nulls":17},"Tension",null,null,"Tempered hardboard","Plywood",{"$nulls":4},7200,null,{"$f":"AND(K29=AJ28,OR(M11<0.6,M30<0.6))","v":false},"masonry cladding cannot be considered becasue wall height is less than 2.4m or wall length is less than 0.6m"]
[null,null,"Secondary board type:",{"$nulls":7},"Plywood",{"$nulls":23},"Tempered hardboard",{"$nulls":4},10800,null,{"$f":"M15<72","v":false},"racking resistance reduced by 15% as wall studs are smaller than 38x72mm (for limitations see Table 2 in the BS)"]
[null,null,{"$f":"IF(K25=AI17,\"Thickness [mm] =\",\"Thickness (standard: \"&AH47&\"mm) [mm] =\")","v":"Thickness (standard: 9.5mm) [mm] ="},{"$nulls":9},9.5,{"$nulls":28},{"$f":"AND(K21=AH22,OR(K25=AI17,K25=AI23))","v":false},"when relaying only on plasterboard at separating walls for racking resistance, additional bracing may be required"]
[null,null,{"$f":"IF(K25=AI17,\"Nail diameter [mm] =\",IF(AND(OR(K25=AI22,K25=AI23),K32=AE20),\"Screw\",\"Nail\")&\" diameter (standard: \"&AH48&\"mm) [mm] =\")","v":"Nail diameter (standard: 3mm) [mm] ="},{"$nulls":9},{"v":3,"d":"3.00"},null,null," ",{"$nulls":14},"Accidental","Accidental",{"$nulls":7},{"$f":"IF(AN14=\"Accidental\",2.25,(IF(AN14=\"Very short\",1.75,(IF(AN14=\"Short\",1.5,(IF(AN14=\"Medium\",1.25,(IF(AN14=\"Long\",1)))))))))","v":{"v":1.5,"d":"1.50"}},null,{"$f":"AND(K29=AJ28,M30>M11)","v":false},"masonry cladding is longer than timber frame wall. Calculations were not interrupted."]
[null,null,{"$f":"IF(K25=AI17,\"Nail spacing [mm] =\",IF(AND(OR(K25=AI22,K25=AI23),K32=AE20),\"Screw\",\"Nail\")&\" spacing (standard: \"&AH49&\"mm) [mm] =\")","v":"Nail spacing (standard: 150mm) [mm] ="},{"$nulls":9},{"v":150,"d":"150.0"},{"$nulls":17},"Very short-term","Very Short",{"$nulls":3},"Consider",3.7,0.4,null,{"$f":"(IF(M15>300,0.81*((M15*M15+92300)/(M15*M15+56800)),IF(M15<72,1.17,(300/M15)^0.11)))","v":{"v":1.081629269962972,"d":"1.08"}}]
[null,null,"Non-loadbearing masonry cladding:",{"$nulls":7},"Consider",{"$nulls":19},"Short-term","Short",{"$nulls":3},"None",4.4,0.5,null,{"$f":"IF(AND(M16<=610,M11>3*M16/1000),1.1,1)","v":{"v":1.1,"d":"1.10"}}]
[null,null,"Masonry cladding length 'Lm' [m] =",{"$nulls":9},{"v":5,"d":"5.0"},{"$nulls":17},"Medium-term","Medium",{"$nulls":7},{"$f":"IF(AN24/AO32<5,1,AQ32)","v":{"v":0.6753915485094649,"d":"0.68"}}]
[null,null,"Wall ties density [ties/m2] =",{"$nulls":9},3.7,{"$nulls":17},"Long-term","Long",{"$nulls":7},{"$f":"ROUNDDOWN(IF(MAX(63,M15)<72,1.17,(300/MAX(63,M15))^0.11),2)","v":1.08},"additional cacls"]
[null,null,"Plasterboard fixings:",{"$nulls":7},"Nails",{"$nulls":4},{"$f":"IF(M18>0,\"Note 1: Additional studs may be required next to openings (NOT CHECKED)\",\"\")","v":"Note 1: Additional studs may be required next to openings (NOT CHECKED)"},{"$nulls":17},"primary diameter",{"$f":"AND(OR(K21=AH21,K21=AH22),M23<>AF48)","v":false},null,{"$f":"M22&\"mm \"&K21","v":"9mm OSB"},null,null,{"$f":"AO32*AN30*AN27*AN29*IF(M10=3,0.6,1)","v":{"v":8.803728834820875,"d":"8.80"}},7.9,{"$f":"AO32*AN27*IF(M10=3,0.6,1)","v":11.850000000000001},{"$f":"(0.5+(1+0.005*Y39)*PI()*PI()*AN24*IF(M10=3,0.8,1)/(2*1.5*Y39*Y39*AP32))-((0.5+(1+0.005*Y39)*PI()*PI()*AN24*IF(M10=3,0.8,1)/(2*1.5*Y39*Y39*AP32))^2-PI()*PI()*AN24*IF(M10=3,0.8,1)/(1.5*Y39*Y39*AP32))^0.5","v":0.6753915485094649}]
[{"$nulls":33},"primary spacing",{"$f":"OR(AND(K21=AH17,M24>75),AND(K21<>AH21,K21<>AH22,M24>150),AND(OR(K21=AH21,K21=AH22,M24<50,M24>300),M24<>AF49))","v":false},null,{"$f":"IF(K25=AI17,\"N/A\",M26&\"mm \"&K25)","v":"9.5mm Plywood"},null,null,{"$f":"AN13*1000/AN17","v":{"v":4.281395097721628,"d":"4.28"}}]
[null,null,"CALCULATIONS: SECTION PROPERTIES",{"$nulls":12},"CALCULATIONS: MODIFICATION FACTORS",{"$nulls":17},"secondary diameter",{"$f":"AND(OR(K25=AI22,K25=AI23),M27<>AH48)","v":false},null,{"$f":"\"63x\"&M15&\" @\"&M16&\" \"&\"C24\"","v":"63x147 @610 C24"},null,null,{"$f":"AN33/AN32","v":{"v":0.486316102875372,"d":"0.49"}}]
[null,null,"Cross sectional area of wall stud 'A' =",{"$nulls":7},{"$f":"AN17/100","v":92.61},null,"cm2",null,null,{"$f":"\"K2=\"&FIXED(1,2)&\"|K3=\"&FIXED(AN27,2)&\"|K7=\"&FIXED(AN28,2)&\"|K8=\"&FIXED(AN29,2)&\"|K12=\"&FIXED(IF(ISERROR(AN30),1,AN30),2)&\"|K14=\"&FIXED(IF(OR(AH10,AH12),AN31,1),2)","v":"K2=1.00|K3=1.50|K7=1.08|K8=1.10|K12=0.68|K14=1.00"},{"$nulls":17},"secondary spacing",{"$f":"OR(AND(K25=AI18,M28>75),AND(K25<>AI17,K25<>AI22,K25<>AI23,M28>150),AND(OR(K25=AI22,K25=AI23,M28<50,M28>300),M28<>AH49))","v":false},null,{"$f":"2.7*1000&\"mm\"","v":"2700mm"},null,null,{"$f":"IF(AN32>AN33,\"Compressive stress: OK\",\"Compressive stress: NOT OK\")","v":"Compressive stress: OK"}]
[null,null,"Section modulus of wall stud 'Zx' =",{"$nulls":7},{"$f":"AN18/1000","v":{"v":226.8945,"d":"226.89"}},null,"cm3",{"$nulls":23},{"$f":"M11*1000&\"mm\"","v":"6000mm"},null,null,{"$f":"(PI()*PI()*7200)/(Y39*Y39)*IF(M10=3,database!E57,1)","v":{"v":26.199989537864493,"d":"26.20"}}]
[null,null,"Second moment of Area of wall stud 'Ix' =",{"$nulls":7},{"$f":"AN20/10000","v":{"v":1667.674575,"d":"1667.67"}},null,"cm4",null,null,"CALCULATIONS: SLENDERNESS",{"$nulls":20},{"$f":"IF(M18>0,\"See Note 1\",\"N/A\")","v":"See Note 1"},null,null,{"$f":"1-(1.5*AN33*AQ32/AN36)","v":{"v":0.8344492813259307,"d":"0.83"}}]
[null,null,"Radius of gyration of wall stud 'rx' =",{"$nulls":7},{"$f":"AN22","v":{"v":42.4352447854375,"d":"42.4"}},null,"mm",null,null,"Effective stud length 'Le' =",{"$nulls":8},{"$f":"IF(OR(AH8,AH10,AH12),\"N/A\",2.7*M13-100/1000)","v":{"v":2.195,"d":"2.20"}},null,"m",{"$nulls":12},{"$f":"K51/(K52*AN37)+AN33/AN32","v":{"v":0.5411513534908661,"d":"0.54"}}]
[null,null,"Minimum elastic modulus 'Emin' =",{"$nulls":7},{"$f":"AN24","v":7200},null,"N/mm2",null,null,"Stud slenderness ratio 'λ' =",{"$nulls":8},{"$f":"IF(OR(AH8,AH10,AH12),\"N/A\",2600*M13/AN22)","v":{"v":52.07935081261522,"d":"52.1"}},{"$nulls":14},{"$f":"4.5*AN27*AN31*AN29*IF(M10=3,database!E57,1)","v":{"v":8.019000000000002,"d":"8.02"}}]
[null,null,"Mean elastic modulus 'Emean' =",{"$nulls":7},{"$f":"AN25","v":10800},null,"N/mm2",null,null,"Permissible slenderness ratio 'λmax' =",{"$nulls":8},180,{"$nulls":6},{"$f":"INDEX($AJ$53:$AJ$60,MATCH($K$21,$AF$53:$AF$60,0))","v":{"v":1.68,"d":"1.680"}},null,{"$f":"IF($K$25=$AI$17,0,INDEX($AK$53:$AN$60,MATCH($K$21,$AF$53:$AF$60,0),INDEX($AE$53:$AE$60,MATCH($K$25,$AF$53:$AF$60,0))))","v":{"v":0.84,"d":"0.840"}},{"$nulls":5},{"$f":"AN13*1000/AN17","v":{"v":4.281395097721628,"d":"4.28"}}]
[{"$nulls":15},"Utilisation factor =",{"$nulls":8},{"$f":"IF(OR(AH8,AH10,AH12),\"N/A\",Y39/Y40)","v":{"v":0.2893297267367512,"d":"0.29"}},{"$nulls":6},{"$f":"AF42*AF43*AF44","v":{"v":0.9999999999999998,"d":"1.000"}},null,{"$f":"AH42*AH43*AH44","v":{"v":0.9999999999999998,"d":"1.000"}},null,{"$f":"AJ42*AJ43*AJ44*AJ45*AJ46","v":{"v":1.1461087752222663,"d":"1.146"}},{"$f":"(AF40*AF41+IF(K25<>AI17,AH40*AH41,0))*AJ41*M11","v":{"v":17.32916468136066,"d":"17.33"}},null,null,{"$f":"AN40/AN39","v":{"v":0.533906359611127,"d":"0.53"}}]
[null,null,"CALCULATIONS:",{"$nulls":3},{"$f":"IF(AF23=AE23,\"COMPRESSION\",\"TENSION\")&\" PARALLEL TO GRAIN\"","v":"COMPRESSION PARALLEL TO GRAIN"},{"$nulls":8},{"$f":"IF(OR(AH8,AH10,AH12),\"Slenderness check not applicable\",IF(Y40>Y39,\"Slenderness: OK\",\"Slenderness: NOT OK\"))","v":"Slenderness: OK"},{"$nulls":15},{"$f":"IF(OR(K21=AH21,K21=AH22),IF($M$23>=2.65,1,$M$23/2.65),MIN(3.75,MAX(2.25,$M$23))/3)","v":{"v":1,"d":"1.000"}},null,{"$f":"IF($K$25=$AI$17,0,IF(OR(K25=AI22,K25=AI23),IF($M$27>=2.65,1,$M$27/2.65),MIN(3.75,MAX(2.25,$M$27))/3))","v":{"v":1,"d":"1.000"}},null,{"$f":"2.4/2.7","v":{"v":0.8888888888888888,"d":"0.889"}},{"$nulls":3},{"$f":"IF(AN39>AN40,\"Tensile stress: OK\",\"Tensile stress: NOT OK\")","v":"Tensile stress: OK"}]
[null,null,{"$f":"IF($AF$23=$AE$23,\"Applied compression per stud 'N' =\",\"Applied tension per stud 'T' =\")","v":"Applied compression per stud 'N' ="},{"$nulls":7},{"$f":"IF(AH8,\"N/A\",AN13)","v":39.65},null,"kN",{"$nulls":18},{"$f":"IF(OR(K25=AI22,K25=AI23),1,IF(AND(M24>AF49,OR(K21=AH21,K21=AH22)),0,1/(0.6*AF45+0.4)))","v":{"v":1,"d":"1.000"}},null,{"$f":"IF(AND(M28>AH49,OR(K25=AH21,K25=AH22)),0,1/(0.6*AH45+0.4))","v":{"v":1,"d":"1.000"}},null,{"$f":"IF(M11>=4.8,1.32,IF(M11<=2.4,M11/2.4,(M11/2.4)^0.4))","v":{"v":1.32,"d":"1.320"}},{"$f":"IF(AND(K29=AJ28,M11>=0.6,M30>=0.6),MIN(25%*AK41,M30*INDEX(AL28:AL29,MATCH(M31,AK28:AK29,0))),0)","v":{"v":2,"d":"2.00"}},null,null,{"$f":"(K51/K52)+(AN40/AN39)","v":{"v":0.5796635950785533,"d":"0.58"}}]
[null,null,{"$f":"IF($AF$23=$AE$23,\"Applied compressive stress per stud =\",\"Applied tensile stress per stud =\")","v":"Applied compressive stress per stud ="},{"$nulls":7},{"$f":"IF(AH8,\"N/A\",IF($AF$23=$AE$23,AN33,AN40))","v":{"v":4.281395097721628,"d":"4.28"}},null,"N/mm2",null,null,"CALCULATIONS: WALL OUT OF PLANE DEFLECTION",{"$nulls":15},{"$f":"IF(AF46=0,0,2.8*AF46-AF46^2-0.8)","v":{"v":0.9999999999999998,"d":"1.000"}},null,{"$f":"IF(OR($K$25=$AI$17,AH46=0),0,2.8*AH46-AH46^2-0.8)","v":{"v":0.9999999999999998,"d":"1.000"}},null,{"$f":"IF(AJ47>0.75,0,(1-1.3*(AJ47))^2)","v":{"v":0.5764746227709191,"d":"0.576"}}]
[null,null,{"$f":"IF($AF$23=$AE$23,\"Permissible compressive stress per stud =\",\"Permissible tensile stress per stud =\")","v":"Permissible compressive stress per stud ="},{"$nulls":7},{"$f":"IF(AH8,\"N/A\",IF($AF$23=$AE$23,AN32,AN39))","v":{"v":8.803728834820875,"d":"8.80"}},null,"N/mm2",null,null,"Allowable deflection multiplier =",{"$nulls":8},0.003,{"$nulls":6},{"$f":"M24/AF49","v":{"v":1,"d":"1.000"}},null,{"$f":"IF($K$25=$AI$17,0,M28/AH49)","v":{"v":1,"d":"1.000"}},null,{"$f":"1+((0.09*AJ48-0.0015*AJ48^2)*(2.4/M11)^0.4)","v":{"v":1.540393048344831,"d":"1.540"}},{"$f":"AK41+AK43","v":{"v":19.32916468136066,"d":"19.33"}}]
[null,null,"Utilisation factor =",{"$nulls":7},{"$f":"IF(AH8,\"N/A\",IF($AF$23=$AE$23,AN34,AN41))","v":{"v":0.486316102875372,"d":"0.49"}},{"$nulls":4},"Maximum allowable deflection 'δlimit' =",{"$nulls":8},{"v":7,"d":"7.0"},null,"mm",{"$nulls":4},{"$f":"IF(OR(M22/AF47>1.25,M22/AF47<0.75),0,M22/AF47)","v":{"v":1,"d":"1.000"}},null,{"$f":"IF($K$25=$AI$17,0,IF(OR(M26/AH47>1.25,M26/AH47<0.75),0,M26/AH47))","v":{"v":1,"d":"1.000"}},null,{"v":1.1,"d":"1.100"}]
[null,null,{"$f":"IF(AH8,\"Compression parallel to grain check not applicable\",IF($AF$23=$AE$23,AN35,AN42))","v":"Compressive stress: OK"},{"$nulls":12},"Allowable deflection 'δallowable' =",{"$nulls":8},{"$f":"IF(OR(AH11,AH12),\"N/A\",MIN(Y46,Y45*2600))","v":{"v":7,"d":"7.0"}},null,"mm",{"$nulls":4},{"$f":"INDEX($AG$53:$AG$60,MATCH($K$21,$AF$53:$AF$60,0))","v":9},null,{"$f":"IF($K$25=$AI$17,0,INDEX($AG$53:$AG$60,MATCH($K$25,$AF$53:$AF$60,0)))","v":9.5},null,{"$f":"M18/(M11*2.7)","v":{"v":0.18518518518518515,"d":"0.185"}}]
[null,null,"NOTE: end bearing on bottom rail not checked",{"$nulls":12},"Actual bending deflection 'δbending' =",{"$nulls":8},{"$f":"IF(OR(AH11,AH12),\"N/A\",5*0.25*M16/1000*2600^4/(384*IF(AN29=1,AN24,AN25)*AN20))","v":{"v":0.5038101959882122,"d":"0.5"}},null,"mm",{"$nulls":4},{"$f":"INDEX($AH$53:$AH$60,MATCH($K$21,$AF$53:$AF$60,0))","v":3},null,{"$f":"IF($K$25=$AI$17,0,INDEX($AH$53:$AH$60,MATCH($K$25,$AF$53:$AF$60,0)))","v":3},null,{"$f":"MIN(10.5,AA10)","v":{"v":10.5,"d":"10.50"}}]
[null,null,"CALCULATIONS: BENDING PARALLEL TO GRAIN",{"$nulls":12},"Utilisation factor =",{"$nulls":8},{"$f":"IF(OR(AH11,AH12),\"N/A\",Y48/Y47)","v":{"v":0.07197288514117317,"d":"0.07"}},{"$nulls":6},{"$f":"INDEX($AI$53:$AI$60,MATCH($K$21,$AF$53:$AF$60,0))","v":150},null,{"$f":"IF($K$25=$AI$17,0,INDEX($AI$53:$AI$60,MATCH($K$25,$AF$53:$AF$60,0)))","v":150}]
[null,null,"Applied bending moment per stud 'M' =",{"$nulls":7},{"$f":"IF(OR(AH11,AH12),\"N/A\",0.25*M16/1000*2.7^2/8)","v":{"v":0.138965625,"d":"0.14"}},null,"kNm",null,null,{"$f":"IF(OR(AH11,AH12),\"Deflection due to wind loading check not applicable\",IF(Y48<=Y47,\"Deflection due to wind loading: OK\",\"Deflection due to wind loading: NOT OK\"))","v":"Deflection due to wind loading: OK"}]
[null,null,"Applied bending stress per stud =",{"$nulls":7},{"$f":"IF(OR(AH11,AH12),\"N/A\",(K50/AN18)*10^6)","v":{"v":0.6124680192776819,"d":"0.61"}},null,"N/mm2",null,null,{"$f":"IF($Y$45>0.003,\"NOTE: racking deflection not checked\",\"\")","v":""}]
[null,null,"Permissible bending stress per stud =",{"$nulls":7},{"$f":"IF(OR(AH11,AH12),\"N/A\",VLOOKUP(\"C24\",database!B5:I24,2,FALSE)*AN27*AN28*AN29*IF(M10=3,database!E57,1))","v":{"v":13.385162215791778,"d":"13.39"}},null,"N/mm2",null,null,"CALCULATIONS: RACKING RESISTANCE"]
[null,null,"Utilisation factor =",{"$nulls":7},{"$f":"IF(OR(AH11,AH12),\"N/A\",K51/K52)","v":{"v":0.04575723546742629,"d":"0.05"}},{"$nulls":4},{"$f":"\"Primary board: Km=\"&FIXED(AF41,2)&\"|K101=\"&FIXED(AF42,2)&\"|K102=\"&FIXED(AF43,2)&\"|K103=\"&FIXED(AF44,2)","v":"Primary board: Km=1.00|K101=1.00|K102=1.00|K103=1.00"},{"$nulls":14},2,"Bitumen board",12.5,3,75,{"$f":"IF($AJ$12=1,0.85,1)*0.9","v":0.9},"N/A",{"$f":"IF($AJ$12=1,0.85,1)*0.45","v":0.45},{"$f":"IF($AJ$12=1,0.85,1)*0.3*IF(AND(K25=AI23,$K$32=$AE$19),1.5,1)","v":0.3},{"$f":"IF($AJ$12=1,0.85,1)*0.2*IF(AND($K$25=$AI$22,$K$32=$AE$19),1.5,1)","v":0.2}]
[null,null,{"$f":"IF(OR(AH11,AH12),\"Bending parallel to grain check not applicable\",IF(K52>K51,\"Bending stress: OK\",\"Bending stress: NOT OK\"))","v":"Bending stress: OK"},{"$nulls":12},{"$f":"IF($K$25=$AI$17,\"No secondary board selected\",\"Secondary board: Km=\"&FIXED(AH41,2)&\"|K101=\"&FIXED(AH42,2)&\"|K102=\"&FIXED(AH43,2)&\"|K103=\"&FIXED(AH44,2))","v":"Secondary board: Km=1.00|K101=1.00|K102=1.00|K103=1.00"},{"$nulls":14},1,"Medium board",9,3,150,{"$f":"IF($AJ$12=1,0.85,1)*1.68","v":1.68},{"$f":"IF($AJ$12=1,0.85,1)*0.84","v":0.84},{"$f":"IF($AJ$12=1,0.85,1)*0.28","v":0.28},{"$f":"IF($AJ$12=1,0.85,1)*0.18*IF(AND(K25=AI23,$K$32=$AE$19),1.5,1)","v":0.18},{"$f":"IF($AJ$12=1,0.85,1)*0.12*IF(AND($K$25=$AI$22,$K$32=$AE$19),1.5,1)","v":0.12}]
[{"$nulls":15},{"$f":"\"Kw=\"&FIXED(AJ41,2)&\"|K104=\"&FIXED(AJ42,2)&\"|K105=\"&FIXED(AJ43,2)&\"|K106=\"&FIXED(AJ44,2)&\"|K107=\"&FIXED(AJ45,2)&\"|K108=\"&FIXED(AJ46,2)","v":"Kw=1.15|K104=0.89|K105=1.32|K106=0.58|K107=1.54|K108=1.10"},{"$nulls":14},1,"OSB",9,3,150,{"$f":"IF($AJ$12=1,0.85,1)*1.68","v":1.68},{"$f":"IF($AJ$12=1,0.85,1)*0.84","v":0.84},{"$f":"IF($AJ$12=1,0.85,1)*0.28","v":0.28},{"$f":"IF($AJ$12=1,0.85,1)*0.18*IF(AND(K25=AI23,$K$32=$AE$19),1.5,1)","v":0.18},{"$f":"IF($AJ$12=1,0.85,1)*0.12*IF(AND($K$25=$AI$22,$K$32=$AE$19),1.5,1)","v":0.12}]
[null,null,"CALCULATIONS:",{"$nulls":4},{"$f":"IF(AF23=AE23,\"AXIAL COMPRESSION\",\"AXIAL TENSION\")&\" AND BENDING\"","v":"AXIAL COMPRESSION AND BENDING"},{"$nulls":7},"Basic racking resistance of Primary board =",{"$nulls":8},{"$f":"IF($AJ$14<>0,\"N/A\",AF40)","v":1.68},null,"kN/m",{"$nulls":3},1,"Particleboard",12,3,150,{"$f":"IF($AJ$12=1,0.85,1)*1.68","v":1.68},{"$f":"IF($AJ$12=1,0.85,1)*0.84","v":0.84},{"$f":"IF($AJ$12=1,0.85,1)*0.28","v":0.28},{"$f":"IF($AJ$12=1,0.85,1)*0.18*IF(AND(K25=AI23,$K$32=$AE$19),1.5,1)","v":0.18},{"$f":"IF($AJ$12=1,0.85,1)*0.12*IF(AND($K$25=$AI$22,$K$32=$AE$19),1.5,1)","v":0.12}]
[null,null,"Euler critical stress per stud 'σe' =",{"$nulls":7},{"$f":"IF(OR(AH8,AH11,AH12),\"N/A\",IF($AF$23=$AE$23,AN36,\"N/A\"))","v":{"v":26.199989537864493,"d":"26.20"}},null,"N/mm2",null,null,"Basic racking resistance of Secondary board =",{"$nulls":8},{"$f":"IF(AND(K25<>AI17,$AJ$14=0),AH40,\"N/A\")","v":0.84},null,"kN/m",{"$nulls":3},4,"Plasterboard",12.5,{"$f":"IF($K$32=$AE$20,3.5,2.65)","v":2.65},{"$f":"IF($K$32=$AE$20,300,150)","v":150},{"$f":"IF($AJ$12=1,0.85,1)*0.4*IF($K$32=$AE$19,1.5,1)","v":0.6000000000000001},"N/A","N/A","N/A",{"$f":"IF($AJ$12=1,0.85,1)*0.2*IF($K$32=$AE$19,1.5,1)","v":0.30000000000000004}]
[null,null,"Euler coefficient 'Keu' =",{"$nulls":7},{"$f":"IF(OR(AH8,AH11,AH12),\"N/A\",IF($AF$23=$AE$23,AN37,\"N/A\"))","v":{"v":0.8344492813259307,"d":"0.83"}},{"$nulls":4},"Racking resistance of wall panel 'Rw' =",{"$nulls":8},{"$f":"IF($AJ$14=0,AK41,\"N/A\")","v":{"v":17.32916468136066,"d":"17.33"}},null,"kN",{"$nulls":3},3,"Plasterboard separating",30,{"$f":"IF($K$32=$AE$20,3.5,2.65)","v":2.65},{"$f":"IF($K$32=$AE$20,300,150)","v":150},{"$f":"IF($AJ$12=1,0.85,1)*0.6*IF($K$32=$AE$19,1.5,1)","v":0.8999999999999999},"N/A","N/A",0,0]
[null,null,"Utilisation factor =",{"$nulls":7},{"$f":"IF(OR(AH8,AH11,AH12),\"N/A\",IF($AF$23=$AE$23,AN38,AN43))","v":{"v":0.5411513534908661,"d":"0.54"}},{"$nulls":4},"Racking resistance of masonry cladding 'Rm' =",{"$nulls":8},{"$f":"IF(AND(K29=AJ28,$AJ$14=0),AK43,\"N/A\")","v":{"v":2,"d":"2.00"}},null,"kN",{"$nulls":3},1,"Plywood",9.5,3,150,{"$f":"IF($AJ$12=1,0.85,1)*1.68","v":1.68},{"$f":"IF($AJ$12=1,0.85,1)*0.84","v":0.84},{"$f":"IF($AJ$12=1,0.85,1)*0.28","v":0.28},{"$f":"IF($AJ$12=1,0.85,1)*0.18*IF(AND(K25=AI23,$K$32=$AE$19),1.5,1)","v":0.18},{"$f":"IF($AJ$12=1,0.85,1)*0.12*IF(AND($K$25=$AI$22,$K$32=$AE$19),1.5,1)","v":0.12}]
[null,null,{"$f":"IF(OR(AH8,AH11,AH12),\"Axial compression and bending check not applicable\",IF(AF23=AE23,IF(K59<=1,\"Axial compression and bending: OK\",\"Axial compression and bending: NOT OK\"),IF(K59<=1,\"Axial tension and bending: OK\",\"Axial tension and bending: NOT OK\")))","v":"Axial compression and bending: OK"},{"$nulls":12},"Total racking resistance 'R' =",{"$nulls":8},{"$f":"IF($AJ$14=0,AK45,\"N/A\")","v":{"v":19.32916468136066,"d":"19.33"}},null,"kN",{"$nulls":3},1,"Tempered hardboard",6,3,150,{"$f":"IF($AJ$12=1,0.85,1)*1.68","v":1.68},{"$f":"IF($AJ$12=1,0.85,1)*0.84","v":0.84},{"$f":"IF($AJ$12=1,0.85,1)*0.28","v":0.28},{"$f":"IF($AJ$12=1,0.85,1)*0.18*IF(AND(K25=AI23,$K$32=$AE$19),1.5,1)","v":0.18},{"$f":"IF($AJ$12=1,0.85,1)*0.12*IF(AND($K$25=$AI$22,$K$32=$AE$19),1.5,1)","v":0.12}]
[]
[null,null,"Spreadsheet provided by: www.YourSpreadsheets.co.uk",{"$nulls":12},"calculations are based on BS 5268-2: 2002 and BS 5268-6.1: 1996"]

{"sheet":"database","index":1,"n_rows":142,"n_cols":12,"rows_kept":142,"hidden":true}
[]
[]
[null,"Strength class","Bending //","Tension //","Compression //","Compression per","Shear //","E","Emin"]
[]
[null,"C14"]
[null,"C16"]
[null,"C18"]
[null,"C22"]
[null,"C24",7.5,4.5,7.9,2.4,0.71,10800,7200]
[null,"C27"]
[null,"C30"]
[null,"C35"]
[null,"C40"]
[null,"D30"]
[null,"D35"]
[null,"D40"]
[null,"D50"]
[null,"D60"]
[null,"D70"]
[null,"TH1 (OAK)"]
[null,"TH2"]
[null,"THA"]
[null,"THB"]
[null,"TH1 (Sweet Chestnut)"]
[null,"none"]
[]
[]
[{"$nulls":3},1,2]
[null,null,2,1.11,1.06]
[null,null,3,1.16,1.08]
[null,null,4,1.19,1.1]
[null,null,5,1.21,1.11]
[null,null,6,1.23,1.12]
[null,null,7,1.24,1.12]
[null,null,8,1.25,1.13]
[null,null,"More than 8",1.25,1.13]
[]
[]
[{"$nulls":3},1,2]
[null,null,2,1.14,1.06]
[null,null,3,1.24,1.08]
[null,null,4,1.24,1.1]
[null,null,5,1.27,1.11]
[null,null,6,1.29,1.12]
[null,null,7,1.3,1.12]
[null,null,8,1.32,1.13]
[{"$nulls":3},1.32,1.13]
{"$rows_empty":8}
[{"$nulls":4},"K2"]
[{"$nulls":3},"Bending Par",0.8]
[{"$nulls":3},"Tension Par",0.8]
[{"$nulls":3},"Com Par",0.6]
[{"$nulls":3},"Com Per",0.6]
[{"$nulls":3},"Sh Par",0.9]
[{"$nulls":3},"M E",0.8]
{"$rows_empty":7}
[{"$nulls":4},"K15","K16","K17","K18","K19","K20"]
[{"$nulls":3},"Strength class","Bending //","Tension //","Compression //","Compression per","Shear //"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"C27",1.1,1.1,1.04,1.49,1.49,1]
[{"$nulls":3},"C30",1.1,1.1,1.04,1.49,1.49,1]
[{"$nulls":3},"C35",1.1,1.1,1.04,1.49,1.49,1]
[{"$nulls":3},"C40",1.1,1.1,1.04,1.49,1.49,1]
[{"$nulls":3},"D50",1.1,1.1,1.04,1.49,1.49,1,null,{"$f":"IF(AND(C3=\"Glulam\",C13=\"Vertical\"),VLOOKUP(C12,database!C28:E35,MATCH(C4+1,database!D28:E28,0),FALSE),1)","v":1}]
[{"$nulls":3},"D60",1.1,1.1,1.04,1.49,1.49,1]
[{"$nulls":3},"D70",1.1,1.1,1.04,1.49,1.49,1]
[]
[]
[{"$nulls":5},4]
[]
[]
[{"$nulls":3},"C16",1.26,1.26,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C18",1.26,1.26,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C22",1.26,1.26,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C24",1.26,1.26,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D30",1.26,1.26,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D35",1.26,1.26,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D40",1.26,1.26,1.04,1.55,2.34,1.07]
[]
[{"$nulls":5},"5,6"]
[{"$nulls":3},"C16",1.34,1.34,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C18",1.34,1.34,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C22",1.34,1.34,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C24",1.34,1.34,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D30",1.34,1.34,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D35",1.34,1.34,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D40",1.34,1.34,1.04,1.55,2.34,1.07]
[]
[{"$nulls":5},"7,8,9"]
[]
[]
[{"$nulls":3},"C16",1.39,1.39,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C18",1.39,1.39,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C22",1.39,1.39,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C24",1.39,1.39,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D30",1.39,1.39,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D35",1.39,1.39,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D40",1.39,1.39,1.04,1.55,2.34,1.07]
[]
[{"$nulls":5},10]
[]
[{"$nulls":3},"C16",1.42,1.42,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C18",1.42,1.42,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C22",1.42,1.42,1.04,1.55,2.34,1.07]
[{"$nulls":3},"C24",1.42,1.42,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D30",1.42,1.42,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D35",1.42,1.42,1.04,1.55,2.34,1.07]
[{"$nulls":3},"D40",1.42,1.42,1.04,1.55,2.34,1.07]
[]
[]
[]
[{"$nulls":3},"Glulam Properties"]
[]
[]
[]
[null,"Strength class","Bending //","Tension //","Compression //","Compression per","Shear //","E mean"]
[null,"Parallam 2.0E PSL",16.8,14.8,15.1,3.6,2.2,12750]
[null,"Timberstrand 1.3E LSL",10.6,8,8.5,3.7,2.8,9000]
[null,"Timberstrand 1.5E LSL",13.1,11.3,11.7,5.3,2.8,10300]
[null,"Kerto S-LVL SC1",19.5,13.5,16.5,3.2,2.2,13500]
[null,"Kerto S-LVL SC2",17.5,12.1,14.8,2.9,2,12850]
[null,"Kerto Q LVL",13.2,8.9,11.1,5.2,2.3,9500]
[null,"Versa Lam LVL SC1",19,15,19.5,4.4,2,14000]
[null,"Versa Lam LVL SC2",17.1,13.5,17.5,4,1.8,13000]

{"sheet":"from author","index":2,"n_rows":41,"n_cols":7,"rows_kept":41,"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",{"$nulls":4},"© 2020 Damian Janicki"]
[]
[null,null,"For latest updates and news visit:",{"$nulls":3},"Contact me at:"]
[null,null,"www.YourSpreadsheets.co.uk",{"$nulls":3},"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"]
{"$rows_empty":20}
[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 wall height\n- Change stud width\n- Change wind load"]
[]
[]
[]
[]
[]
[]
[null,null,"This spreadsheet is based on BS5268-2 (2002) and BS5268-6.1 (1996).\n\nChangelog:\n15.03.2020 - v.1.0. - official release of the spreadsheet."]