{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["portal frame","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":"portal frame","index":0,"n_rows":86,"n_cols":39,"rows_kept":86,"cut":false,"hidden":false,"merged":[[3,22,3,24],[3,25,3,28],[4,22,4,24],[4,25,4,28],[1,4,4,14],[1,15,3,21],[4,18,4,21],[4,15,4,17],[0,1,0,15],[0,16,0,28],[1,22,1,27],[2,22,2,24],[2,25,2,28],[62,2,62,14],[5,2,5,3],[5,22,5,24],[5,25,5,28],[62,15,62,27],[5,4,5,14],[5,18,5,21],[5,15,5,17],[29,2,29,13],[30,2,30,11],[31,2,31,11],[33,2,33,11],[30,12,30,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[9,2,9,27],[36,10,36,11],[37,10,37,11],[38,10,38,11],[40,12,40,13],[32,2,32,11],[32,12,32,13],[33,12,33,13],[39,10,39,11],[40,10,40,11],[47,2,47,8],[41,10,41,11],[52,2,58,27],[46,9,46,13],[47,9,47,13],[41,12,41,13],[42,12,42,13],[48,2,48,8],[31,12,31,13],[12,33,12,38],[35,2,35,13],[48,9,48,13],[36,2,36,9],[37,2,37,9],[38,2,38,9],[39,2,39,9],[40,2,40,9],[41,2,41,9],[42,2,42,11],[43,2,43,11],[43,12,43,13],[45,2,45,13],[39,12,39,13],[46,2,46,8]]}
[null,"Version: 1.0. - FREE LITE VERSION",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,"Span range",15,null,"Eaves height range",6,null,"Rafter load range",8]
[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,4,20,null,{"$f":"IF(M31<AJ2,1,IF(M31>AJ5,\"outside the scope\",IF(ISERROR(MATCH(M31,AJ2:AJ5,0)),1+MATCH(M31,AJ2:AJ5,1),MATCH(M31,AJ2:AJ5,0))))","v":2},8,null,{"$f":"IF(M44<AM2,1,IF(M44>AM6,\"outside the scope\",IF(ISERROR(MATCH(M44,AM2:AM6,0)),1+MATCH(M44,AM2:AM6,1),MATCH(M44,AM2:AM6,0))))","v":4},10]
[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,25,null,null,10,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":"2016-08-07"},null,null,null,null,null,null,30,null,null,12,null,null,14]
[null,null,"Member: ",null,"PORTAL FRAME NO 1",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,null,null,null,null,35,null,null,null,null,null,16]
[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,40]
[]
[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,"Spacing",{"$f":"\"Frames at \"&M33&\"m crs\"","v":"Frames at 7m crs"}]
[null,null,"DIAGRAM:",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,"Span","30m","Rafter",{"$f":"J47&\" Rafter\"","v":"457×191×74 UB Rafter"}]
[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,"Eaves height",{"$f":"M31&\"m\"","v":"8m"},"Stanchion",{"$f":"J48&\" Stanchion\"","v":"610×229×113 UB Stanchion"}]
[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,"Restraints",{"$f":"IF(M34=\"Yes\",\"X\",\"\")","v":"X"},"Hunch",{"$f":"J49&\" Hunch\"","v":"533×210×82 UB Hunch"}]
[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,"SPAN"]
[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,"rafter load","eaves height",15,20,25,30,35,40]
[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,"Rafter",8,6,"254×102×22 UB","356×127×33 UB","406×140×39 UB","406×140×46 UB","406×178×60 UB","457×191×67 UB"]
[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,8,8,"254×102×22 UB","356×127×33 UB","406×140×39 UB","406×178×54 UB","457×191×67 UB","457×191×74 UB"]
[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,8,10,"254×102×22 UB","356×127×33 UB","406×140×39 UB","406×178×54 UB","457×191×67 UB","457×191×74 UB"]
[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,8,12,"outside the scope","356×127×33 UB","406×140×39 UB","406×178×54 UB","457×191×67 UB","457×191×74 UB"]
[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,10,6,"305×102×25 UB","356×127×33 UB","406×140×46 UB","406×178×60 UB","457×191×67 UB","533×210×82 UB"]
[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,10,8,"305×102×25 UB","356×127×33 UB","406×140×46 UB","406×178×60 UB","457×191×74 UB","533×210×82 UB"]
[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,10,10,"305×102×25 UB","406×140×39 UB","406×140×46 UB","406×178×60 UB","457×191×74 UB","533×210×82 UB"]
[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,10,12,"outside the scope","406×140×39 UB","406×140×46 UB","457×191×67 UB","457×191×74 UB","533×210×92 UB"]
[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,12,6,"305×102×28 UB","406×140×39 UB","406×178×54 UB","457×191×67 UB","533×210×82 UB","533×210×92 UB"]
[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,12,8,"305×102×28 UB","406×140×39 UB","406×178×54 UB","457×191×67 UB","533×210×82 UB","533×210×92 UB"]
[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,12,10,"305×102×28 UB","406×140×39 UB","406×178×54 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB"]
[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,12,12,"outside the scope","406×140×39 UB","406×178×54 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB"]
[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,14,6,"356×127×33 UB","406×140×46 UB","406×178×60 UB","457×191×74 UB","533×210×82 UB","610×229×101 UB"]
[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,14,8,"356×127×33 UB","406×140×46 UB","406×178×60 UB","457×191×74 UB","533×210×92 UB","610×229×101 UB"]
[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,14,10,"356×127×33 UB","406×140×46 UB","406×178×60 UB","457×191×74 UB","533×210×92 UB","610×229×101 UB"]
[null,null,"PORTAL FRAME DATA:",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,14,12,"outside the scope","406×140×46 UB","406×178×60 UB","533×210×82 UB","533×210×92 UB","610×229×113 UB"]
[null,null,"Eaves height 'H' [m] =",null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,6,"356×127×33 UB","406×140×46 UB","457×191×67 UB","533×210×82 UB","533×210×92 UB","610×229×113 UB"]
[null,null,"Span of frame 'L' [m] =",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,16,8,"356×127×33 UB","406×140×46 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB","610×229×113 UB"]
[null,null,"Frame spacing 'S' [m] =",null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,10,"356×127×33 UB","406×140×46 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB","610×229×113 UB"]
[null,null,"Restrained stanchions:",null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,12,"outside the scope","406×140×46 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB"]
[]
[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,"Restrained stanchion",8,6,"305×165×40 UB","356×171×51 UB","457×191×67 UB","533×210×82 UB","533×210×92 UB","610×229×113 UB"]
[null,null,"Sheeting and insulation [kN/m2] =",null,null,null,null,null,null,null,1.4,null,0.22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,"305×165×40 UB","356×171×51 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB","610×229×113 UB"]
[null,null,"Purlins [kN/m2] =",null,null,null,null,null,null,null,1.4,null,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,10,"305×165×40 UB","406×178×54 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB"]
[null,null,"Frame self weight [kN/m2] =",null,null,null,null,null,null,null,1.4,null,0.18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,12,"outside the scope","406×178×54 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB"]
[null,null,"Services [kN/m2] =",null,null,null,null,null,null,null,1.4,null,0.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,6,"356×171×45 UB","406×178×60 UB","457×191×74 UB","533×210×92 UB","610×229×113 UB","686×254×125 UB"]
[null,null,"Imposed Load (snow) [kN/m2] =",null,null,null,null,null,null,null,1.6,null,0.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,8,"356×171×45 UB","406×178×60 UB","533×210×82 UB","533×210×92 UB","610×229×113 UB","686×254×125 UB"]
[null,null,"Other [kN/m2] =",null,null,null,null,null,null,null,1.4,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,"356×171×45 UB","406×178×60 UB","533×210×82 UB","610×229×101 UB","610×229×113 UB","686×254×140 UB"]
[null,null,"Total factored unit load [kN/m2] =",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(K37:L42,M37:N42)","v":1.8279999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,12,"outside the scope","406×178×60 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB","686×254×140 UB"]
[null,null,"Total factored load on rafter [kN/m run] =",null,null,null,null,null,null,null,null,null,{"$f":"M33*M43","v":12.795999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,6,"356×141×45 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB","686×254×140 UB"]
[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,12,8,"356×171×45 UB","457×191×67 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB","762×267×147 UB"]
[null,null,"SUGGESTED MEMBER SIZES:",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,12,10,"356×171×51 UB","457×191×67 UB","533×210×92 UB","610×229×113 UB","686×254×125 UB","762×267×147 UB"]
[null,null,"Rafter:",null,null,null,null,null,null,{"$f":"IF(OR(AF3=\"outside the scope\",AI3=\"outside the scope\",AL3=\"outside the scope\"),\"outside the scope\",INDEX(AH15:AM34,AI3+4*(AL3-1),4))","v":"457×191×74 UB"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,12,"outside the scope","457×191×67 UB","533×210×92 UB","610×229×113 UB","686×254×125 UB","762×267×147 UB"]
[null,null,"Stanchion:",null,null,null,null,null,null,{"$f":"IF(OR(AF3=\"outside the scope\",AI3=\"outside the scope\",AL3=\"outside the scope\"),\"outside the scope\",IF(M34=\"Yes\",INDEX(AH36:AM55,AI3+4*(AL3-1),4),INDEX(AH57:AM76,AI3+4*(AL3-1),4)))","v":"610×229×113 UB"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,6,"356×171×51 UB","457×191×74 UB","533×210×92 UB","610×229×113 UB","686×254×140 UB","762×267×147 UB"]
[null,null,"Haunch:",null,null,null,null,null,null,{"$f":"IF(J47=\"outside the scope\",\"outside the scope\",INDEX(AG78:AG86,MATCH(LEFT(J47,7),AF78:AF86,0)))","v":"533×210×82 UB"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,8,"406×178×54 UB","457×191×74 UB","533×210×92 UB","610×229×113 UB","686×254×140 UB","762×267×173 UB"]
[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,14,10,"406×178×54 UB","457×191×74 UB","610×229×101 UB","686×254×125 UB","686×254×140 UB","762×267×173 UB"]
[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,14,12,"outside the scope","457×191×74 UB","610×229×101 UB","686×254×125 UB","762×267×147 UB","762×267×173 UB"]
[null,null,"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,16,6,"406×178×54 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB","762×267×147 UB","762×267×173 UB"]
[null,null,"1) Wind load is based on ground roughness category 2 with a basic wind speed of up to 52m/s. Where dominant openings exist the results should be treated with caution;\n2) Steel grade is S275;\n3) Haunch length is 10% of the span of the frame;\n4) Roof pitch is 6°;\n5) Rafter load is the total factored dead load (including self weight) and factored imposed load;\n6) Given member sizes are suitable for rapid preliminary design or for estimating purposes only;\n7) Results can be used for multiple span frames of equal or unequal spans provided a suitable valley column is used (not covered);\n8) Calculations are based on Appendix A in SCI Publication P252: Design of single-span steel portal frames to BS 5950-1:2000",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,8,"406×178×54 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB","762×267×147 UB","838×292×176 UB"]
[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,10,"406×178×60 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB","762×267×173 UB","838×292×176 UB"]
[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,12,"outside the scope","533×210×82 UB","610×229×101 UB","686×254×125 UB","762×267×173 UB","838×292×194 UB"]
[]
[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,"Unrestrained stanchion",8,6,"356×171×51 UB","457×191×67 UB","533×210×82 UB","533×210×92 UB","610×229×113 UB","686×254×125 UB"]
[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,8,8,"406×178×60 UB","533×210×82 UB","610×229×101 UB","610×229×113 UB","686×254×125 UB","762×267×147 UB"]
[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,8,10,"457×191×67 UB","533×210×92 UB","610×229×113 UB","686×254×125 UB","762×267×147 UB","762×267×173 UB"]
[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,8,12,"outside the scope","610×229×101 UB","686×254×125 UB","762×267×147 UB","762×267×173 UB","838×292×194 UB"]
[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,10,6,"406×178×54 UB","457×191×74 UB","533×210×92 UB","610×229×101 UB","686×254×125 UB","686×254×125 UB"]
[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,10,8,"457×191×67 UB","533×210×92 UB","610×229×113 UB","686×254×125 UB","686×254×140 UB","762×267×173 UB"]
[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 SCI Publication P252",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,"457×191×74 UB","610×229×101 UB","686×254×125 UB","762×267×147 UB","762×267×173 UB","838×292×194 UB"]
[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,10,12,"outside the scope","610×229×113 UB","686×254×140 UB","762×267×173 UB","838×292×194 UB","914×305×224 UB"]
[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,12,6,"406×178×60 UB","533×210×82 UB","610×229×101 UB","610×229×113 UB","686×254×125 UB","762×267×147 UB"]
[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,12,8,"457×191×74 UB","610×229×101 UB","610×229×113 UB","686×254×140 UB","762×267×173 UB","838×292×176 UB"]
[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,12,10,"533×210×82 UB","610×229×113 UB","686×254×140 UB","762×267×173 UB","838×292×194 UB","914×305×224 UB"]
[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,12,12,"outside the scope","686×254×125 UB","762×267×173 UB","836×292×176 UB","914×305×224 UB","914×305×253 UB"]
[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,14,6,"457×191×67 UB","533×210×82 UB","610×229×101 UB","686×254×125 UB","686×254×140 UB","762×267×173 UB"]
[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,14,8,"533×210×82 UB","610×229×101 UB","686×254×125 UB","762×267×147 UB","762×267×173 UB","838×292×176 UB"]
[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,14,10,"533×210×92 UB","686×254×125 UB","762×267×147 UB","762×267×173 UB","838×292×194 UB","914×305×224 UB"]
[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,14,12,"outside the scope","686×254×140 UB","762×267×173 UB","838×292×194 UB","914×305×224 UB","914×305×289 UB"]
[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,6,"457×191×67 UB","533×210×92 UB","610×229×113 UB","686×254×125 UB","762×267×147 UB","762×267×173 UB"]
[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,8,"533×210×82 UB","610×229×113 UB","686×254×140 UB","762×267×173 UB","838×292×176 UB","914×305×201 UB"]
[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,10,"610×229×101 UB","686×254×125 UB","762×267×173 UB","838×292×194 UB","914×305×224 UB","914×305×253 UB"]
[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,12,"outside the scope","686×254×140 UB","838×292×176 UB","914×305×224 UB","914×305×253 UB","914×305×289 UB"]
[]
[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,"Haunch","254×102","305×102×28 UB"]
[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,"305×102","356×127×33 UB"]
[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,"356×127","406×140×39 UB"]
[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,"406×140","457×191×67 UB"]
[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,"406×178","457×191×67 UB"]
[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,"457×191","533×210×82 UB"]
[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,"533×210","610×229×101 UB"]
[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,"610×229","686×254×125 UB"]
[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,"686×254","762×267×147 UB"]

{"sheet":"from author","index":1,"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 Appendix A in SCI Publication P252: Design of single-span steel portal frames to BS 5950-1:2000 - preliminary design.\n\nChangelog:\n07.08.2016 - v.1.0. - official release of the spreadsheet."]