" Steel HSS Section Properties
Select Section - ' #post 'Section type - ' #show 'HSS254X254X12.7 'HSS254X254X9.5 'HSS254X254X7.9 'HSS254X254X6.4 'HSS203.2X203.2X6.4 'HSS152.4X152.4X6.4 ' ''id = ? {5}' #hide #read HSS from Section_data.xlsm@HSS!B2 S = HSS 'we are reading sheet HSS and data starts from B2 ' Now we have to get the section properties A = S.(id; 2)*mm^2 h = S.(id; 3)*mm b = S.(id; 5)*mm t_f = S.(id; 8)*mm t_w = S.(id; 8)*mm I_x = S.(id; 11)*1000000*mm^4 I_y = S.(id; 15)*1000000*mm^4 S_x = S.(id; 13)*1000*mm^3 S_y = S.(id; 17)*1000*mm^3 r_x = S.(id; 14)*mm r_y = S.(id; 18)*mm J = S.(id; 19)*1000*mm^4 C = S.(id; 20)*1000000*mm^6 #post 'Section properties (from Excel) ' ''h''b''t_f''t_w''A' ''I_x''I_y''S_x''S_y' ''r_x''r_y''J''C' ' 'Moment capacity calculation φ = 0.9 F_y = 350MPa M_r = φ*F_y*S_x
Section type - ' #show 'HSS254X254X12.7 'HSS254X254X9.5 'HSS254X254X7.9 'HSS254X254X6.4 'HSS203.2X203.2X6.4 'HSS152.4X152.4X6.4 '
'id = ? {5}'