{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Steel Design Demo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"Steel Design Demo","index":0,"n_rows":134,"n_cols":11,"rows_kept":134,"cut":false,"hidden":false,"merged":[[13,7,13,10]]}
[null,"This spreadsheet demonstrates the functions provided by the Oasys SteelDesign XLA addin for Microsoft Excel"]
[null,"Examples of functions are in Blue"]
[null,"Editable cells are in Green"]
[null,"Notes are in Black"]
[null,"Point your mouse at the red triangles for additional information"]
[null,"In order for this spreadsheet to work correctly, the following requirements need to be met:"]
[null,"1) The SteelDesign Add-In file (SteelDesignClient.xla) must be installed (added-in).  ('File | Options | Add-Ins... | Manage Excel Add-ins | Browse…' for the SteelDesignClient.xla in the GSA program folder)"]
[null,"2) SteelDesign.exe must be present on your system, together with at least one code-checking DLLs (GSA_DES_BS5950_1_2000.dll, GSA_DES_LRFD3.dll and GSA_DES_StressCheck.dll)."]
[null,"3) SteelDesign.exe COM interface must be registered to your computer system (this should be done automatically after installing GSA, if not, ask Oasys for a REG file to this registration)"]
[null,"4) The macro attached to this workbook must be allowed to run ('Enable Macros), so that it can attach the function names to your copy of  the XLA."]
[]
[null,"Demo of utility functions"]
[]
[null,"version",{"$f":"[1]!SteelVersion()","v":"1.8"},null,null,null,null,"Input unit in different standard unit"]
[null,"version date",{"$f":"[1]!SteelVersionDate()","v":"May 2022"},null,null,null,null,null,"SI","European","US"]
[null,"number of grades available",{"$f":"[1]!steelnumgrades()","v":139},null,null,null,null,"Length","m","m","ft"]
[null,"grade no","grade name",null,null,null,null,"Force","N","kN","kip"]
[null,1,{"$f":"[1]!steelgradeName(B18)","v":"User_defined"},null,null,null,null,"Moment","N.m","kN.m","kip.ft"]
[null,2,{"$f":"[1]!steelgradeName(B19)","v":"S235"}]
[null,3,{"$f":"[1]!steelgradeName(B20)","v":"S275"}]
[null,4,{"$f":"[1]!steelgradeName(B21)","v":"S355"}]
[null,5,{"$f":"[1]!steelgradeName(B22)","v":"S450"}]
[null,"number of codes available  ",{"$f":"[1]!SteelNumCodes()","v":23}]
[null,"code no","code name"]
[null,1,{"$f":"[1]!steelcodename(B25)","v":"ANSI/AISC 360-05 (ASD)"}]
[null,2,{"$f":"[1]!steelcodename(B26)","v":"ANSI/AISC 360-05 (LRFD)"}]
[null,3,{"$f":"[1]!steelcodename(B27)","v":"ANSI/AISC 360-10 (LRFD)"}]
[null,4,{"$f":"[1]!steelcodename(B28)","v":"ANSI/AISC 360-10 (ASD)"}]
[null,5,{"$f":"[1]!steelcodename(B29)","v":"AS 4100-1998"}]
[null,6,{"$f":"[1]!steelcodename(B30)","v":"BS 5950-1:2000"}]
[null,7,{"$f":"[1]!steelcodename(B31)","v":"CSA S16-09"}]
[null,8,{"$f":"[1]!steelcodename(B32)","v":"CSA S16-14"}]
[null,9,{"$f":"[1]!steelcodename(B33)","v":"EN 1993-1-1:2005"}]
[null,10,{"$f":"[1]!steelcodename(B34)","v":"BS EN 1993-1-1:2005"}]
[null,11,{"$f":"[1]!steelcodename(B35)","v":"NEN-EN 1993-1-1:2006"}]
[null,12,{"$f":"[1]!steelcodename(B36)","v":"NF EN 1993-1-1:2005"}]
[null,13,{"$f":"[1]!steelcodename(B37)","v":"SS EN 1993-1-1:2010"}]
[null,14,{"$f":"[1]!steelcodename(B38)","v":"BS EN 1993-1-2:2005 (Fire)"}]
[null,15,{"$f":"[1]!steelcodename(B39)","v":"I.S. EN 1993-1-1:2005 "}]
[null,16,{"$f":"[1]!steelcodename(B40)","v":"DIN EN 1993-1-1:2005"}]
[null,17,{"$f":"[1]!steelcodename(B41)","v":"Hong Kong Code of Practice 2005"}]
[null,18,{"$f":"[1]!steelcodename(B42)","v":"Hong Kong Code of Practice 2011"}]
[null,19,{"$f":"[1]!steelcodename(B43)","v":"IS 800 : 1984"}]
[null,20,{"$f":"[1]!steelcodename(B44)","v":"IS 800 : 2007"}]
[null,21,{"$f":"[1]!steelcodename(B45)","v":"AISC LRFD (3rd Ed)"}]
[null,22,{"$f":"[1]!steelcodename(B46)","v":"SANS 10162-1:2011"}]
[null,23,{"$f":"[1]!steelcodename(B47)","v":"<steel generic>"}]
[null,"number of standard unit available  ",{"$f":"[1]!steelnumstdunit()","v":3}]
[null,"standard unit no","standard unit name"]
[null,1,{"$f":"[1]!steelstdunitname(B50)","v":"SI"}]
[null,2,{"$f":"[1]!steelstdunitname(B51)","v":"European"}]
[null,3,{"$f":"[1]!steelstdunitname(B52)","v":"US"}]
[null,"number of utilization ratio types available ",{"$f":"[1]!SteelNumUtilTypes()","v":12}]
[null,"type no","name"]
[null,1,{"$f":"[1]!SteelUtilTypeName(B55)","v":"overall"}]
[null,2,{"$f":"[1]!SteelUtilTypeName(B56)","v":"local combined"}]
[null,3,{"$f":"[1]!SteelUtilTypeName(B57)","v":"local axial"}]
[null,4,{"$f":"[1]!SteelUtilTypeName(B58)","v":"local moment major"}]
[null,5,{"$f":"[1]!SteelUtilTypeName(B59)","v":"local moment minor"}]
[null,6,{"$f":"[1]!SteelUtilTypeName(B60)","v":"local shear major"}]
[null,7,{"$f":"[1]!SteelUtilTypeName(B61)","v":"local shear minor"}]
[null,8,{"$f":"[1]!SteelUtilTypeName(B62)","v":"local torsion"}]
[null,9,{"$f":"[1]!SteelUtilTypeName(B63)","v":"buckling combined"}]
[null,10,{"$f":"[1]!SteelUtilTypeName(B64)","v":"buckling lateral-torsional"}]
[null,11,{"$f":"[1]!SteelUtilTypeName(B65)","v":"buckling axial-major"}]
[null,12,{"$f":"[1]!SteelUtilTypeName(B66)","v":"buckling axial-minor"}]
[null,13,{"$f":"[1]!SteelUtilTypeName(B67)","v":"buckling axial-torsion"}]
[null,14,{"$f":"[1]!SteelUtilTypeName(B68)","v":"buckling axial-flexural torsion"}]
[]
[null,"input data for a local check"]
[null,"Standard unit used","SI"]
[null,"fx",1000]
[null,"fy",2000]
[null,"fz",3000]
[null,"mx",0]
[null,"my",1000]
[null,"mz",1000]
[null,"section","cat ub ub457x191x89"]
[null,"code","BS 5950-1:2000"]
[null,"grade","S355"]
[null,"plastic to elastic moment capacity limit",1.2]
[null,"net to gross area ratio",1]
[null,"shear lag factor",1]
[null,"local check overall utilization",{"$f":"[1]!SteelUtilLocal(C71,C79,$C$78,$C$80,\"ROLLED\",$C$82,$C$81,C$83,1,$C$72,$C$73,$C$74,$C$75,$C$76,$C$77)","v":1.1094494340217972E-2},null,"Options of augument 5 in function SteelUtilLocal on the left are \"Rolled\", Welded\" or Formed\""]
[]
[]
[null,"input data for a simple member check"]
[null,"Standard unit used","SI"]
[null,null,"end 1","end2"]
[null,"fx",3000000,{"$f":"-C90","v":-3000000}]
[null,"fy",2000,-2000]
[null,"fz",3000,-3000]
[null,"mx",0,0]
[null,"my",1000,-1000]
[null,"mz",1000,-1000]
[null,"section","cat ub ub457x191x89"]
[null,"code","BS 5950-1:2000"]
[null,"grade","S355"]
[null,"plastic to elastic moment capacity limit",1.2]
[null,"net to gross area ratio",1]
[null,"shear lag factor",1]
[null,"effective length xx",2]
[null,"effective length yy",3]
[null,"effective length lt",4]
[null,"Equivalent uniform moment factor for LTB",-1,null,null,"Only zero or positive values are used. Overrides alpha_m in AS4100 or mLT in Hong Kong Code of Practice, BS5950, IS800:2007 and all Eurocodes or Cb factor in American codes, this factor is not used by IS800:1984"]
[null,"Moment amplification factor (strong axis)",-1,null,null,"Only zero or positive values are used. Overrides the moment amplification factor (strong axis) in Hong Kong Code of Practice. Invalid for other design codes."]
[null,"Moment amplification factor (weak axis)",-1,null,null,"Only zero or positive values are used. Overrides the moment amplification factor (strong axis) in Hong Kong Code of Practice. Invalid for other design codes."]
[]
[null,"simple member check utilization",{"$f":"[1]!SteelUtilMemberA(C88,C97,C96,C98,\"ROLLED\",C100,C99,C101,1,C102,C103,C104,C90,C91,C92,C93,C94,C95,D90,D91,D92,D93,D94,D95,C105,C106,C107)","v":1.130212867362929},null,null,"Options of augument 5 in function SteelUtilMemberA on the left are \"Rolled\", Welded\" or Formed\""]
[]
[]
[null,"Input data for multi_station member check"]
[null,"Standard unit used","SI"]
[null,"Member points along member (distance from end 1)",1,2,5,7,12]
[null,"fx",1000,500,0,-500,-1000]
[null,"fy",2000,1000,0,-1000,-2000]
[null,"fz",3000,1500,0,-1500,-3000]
[null,"mx",0,0,0,0,0]
[null,"my",1000,500,0,-500,-1000]
[null,"mz",1000,500,0,-500,-1000]
[null,"section","cat ub ub457x191x89"]
[null,"code","BS 5950-1:2000"]
[null,"grade","S355"]
[null,"plastic to elastic moment capacity limit",1.2]
[null,"net to gross area ratio",1]
[null,"shear lag factor",1]
[null,"effective length xx",2]
[null,"effective length yy",3]
[null,"effective length LT",4]
[null,"Lateral torsional buckling factor",-1,null,null,null,null,null,"Only zero or positive values are used. Overrides alpha_m in AS4100 or mLT in Hong Kong Code, BS5950 and all Eurocodes or Cb factor in American codes or CmLT in IS800:2007 or Omega_2 in SANS 10162, this factor is not used by IS800:1984"]
[null,"Moment amplification factor (strong axis)",-1,null,null,null,null,null,"Only zero or positive values are used. Overrides the moment amplification factor (strong axis) in Hong Kong Code of Practice. Invalid for other design codes."]
[null,"Moment amplification factor (weak axis)",-1,null,null,null,null,null,"Only zero or positive values are used. Overrides the moment amplification factor (strong axis) in Hong Kong Code of Practice. Invalid for other design codes."]
[]
[null,"multi-station member check utilization",{"$f":"[1]!SteelUtilMemberB(C113,$C$122,$C$121,$C$123,\"ROLLED\",$C$125,$C$124,C126,1,$C$127,$C$128,$C$129,$C$114:$I$114,$C$115:$I$115,$C$116:$I$116,$C$117:$I$117,$C$118:$I$118,$C$119:$I$119,$C$120:$I$120,C130,C131,C132)","v":1.1094494340217972E-2},null,null,null,null,null,"Options of augument 5 in function SteelUtilMemberB on the left are \"Rolled\", Welded\" or Formed\""]