X Y and Partners Project Steel Beam Design

address Client Made by Date Job No

Description CJB 12-8-00 2001
tel & fax nos Checked Revision Page No
Originated from Steel Beam © 2000-2007 Chris Buczkowski Unregistered Copy for Evaluation - - 02
Design in accordance with BS 5950 : Part 1 : 1990
Analysis Choose steel section: Simply supported beam
● UB
Span (m) 6.000 capacity
UC Design Status ratio
RSJ
Load Factors Vertical shear PASS 0.08
Dead 1.4 E (N/mm²) 205000 PFC Moment PASS 0.27
Imposed 1.6 Ix (cm4) 8249 Buckling FAIL 1.40
Deflection PASS 0.20
Dead Imposed Position Length
LOADING
kN kN m m
UDL 25 10 - - 45
40
Point load - 35
Point load - 30
Point load - 25
20
Point load - 15
Partial UDL 10
5
Partial UDL 0

RESULTS Bending Moment Diagram

Max. deflection (mm)
M max FV max
30
Imposed Total
kNm kN only load 20

40.30 -26.86 -1.66 -6.15 10

Design -10

Design Strength Shear Capacity -20

py N/mm² 275 Area capacity -30
Av Pv
● grade S275
section classification mm² kN Shear Force Diagram
grade S355
Plastic 2094.0 345.51 cl. 4.2.3
0

-1

Position Moment Fv Mcx Unity -2

Moment Capacity Factor
m kNm kN kNm -3

Maximum Moment 3.000 40.30 0.00 149.33 0.27 -4

Critical section 3.000 40.30 0.00 149.33 0.27 -5

* low shear -6

Lateral torsional buckling -7

Equivalent Uniform Moment kNm Zx (cm³) 473

Deflection Diagram
Maximum moment MA 40.30 Sx (cm³) 543
Uniform factor m 1.00
Buckling moment Mbar 40.30 cl. 4.3.7.2

Slenderness Ratio cl. B.2.4 limiting slenderness lLo 34.31

Effective length radius of slenderness cl. 4.3.7.6 correction factor n 1.00
L factor LE gyration buckling parameter u 0.863
m m ry (cm) l torsional index x 42.2
6.000 1.0L+2D 6.698 2.58 259.61 cl. 4.3.7.5 cl. B.2.5 (d) slenderness factor v 0.767
cl. B.2.5 equivalent slenderness lLT 171.80
Deflection cl. B.2.3 Perry coefficient hLT 0.962
Deflection Limits Allowable Plastic moment capacity Mp 149.33
span/deflection ratios mm cl. B.2.2 Elastic critical moment ME 37.22
Imposed Loads 360 16.7 table 5 Buckling index fB 111.19
Total Loads 200 30.0
cl. B.2.1 Buckling capacity Mb 28.70

Section used: UB 356x127x33

X Y and Partners Project Steel Beam Design
address Client Made by Date Job No
Description CJB 12-8-00 2001
tel & fax nos Checked Revision Page No
Originated from Steel Beam © 2000-2007 Chris Buczkowski Unregistered Copy for Evaluation - - 03
Design in accordance with BS 5950 : Part 1 : 1990
Analysis Choose steel section: Simply supported beam with full lateral restraint
UB
Span (m) 6.000 capacity
UC Design Status ratio
RSJ
Load Factors Vertical shear PASS 0.08
Dead 1.4 E (N/mm²) 205000 PFC Moment PASS 0.27
Imposed 1.6 Ix (cm4) 8249 Deflection PASS 0.20

Dead Imposed Position Length

LOADING
kN kN m m
UDL 25 10 - - 45
40
Point load - 35
Point load - 30
Point load - 25
20
Point load - 15
Partial UDL 10
5
Partial UDL 0

RESULTS Bending Moment Diagram

Max. deflection (mm)
M max FV max
30
Imposed Total
kNm kN only load 20

40.30 -26.86 -1.66 -6.15 10

Design -10

Design Strength Shear Capacity -20

py N/mm² 275 Area capacity -30
Av Pv
grade S275
section classification mm² kN Shear Force Diagram
grade S355
Plastic 2094.0 345.51 cl. 4.2.3
0

-1

Position Moment Fv Mcx Unity -2

Moment Capacity Factor
m kNm kN kNm -3

Maximum Moment 3.000 40.30 0.00 149.33 0.27 -4

Critical section 3.000 40.30 0.00 149.33 0.27 -5

* low shear -6

Zx (cm³) 473
-7

Sx (cm³) 543 Deflection Diagram

Deflection
Deflection Limits Allowable
span/deflection ratios mm
Imposed Loads 360 16.7 table 5
Total Loads 200 30.0

Section used: UB 356x127x33

X Y and Partners Project Steel Beam Design
address Client Made by Date Job No
Description CJB 12-8-00 2001
tel & fax nos Checked Revision Page No
Originated from Steel Beam © 2000-2007 Chris Buczkowski Unregistered Copy for Evaluation - - 04
Design in accordance with BS 5950 : Part 1 : 1990
Analysis Choose steel section: Cantilever beam
● UB
Span (m) 2.750 capacity
UC Design Status ratio
RSJ
Load Factors Vertical shear PASS 0.17
Dead 1.4 E (N/mm²) 205000 PFC Moment PASS 0.56
Imposed 1.6 Ix (cm4) 7171 Buckling PASS 0.93
Deflection PASS 0.47
Dead Imposed Position Length
LOADING
kN kN m m
UDL 25 15 - - 0
-10
Point load - -20
Point load - -30
Point load - -40
-50
Point load - -60
Partial UDL -70
-80
Partial UDL
-90

RESULTS Bending Moment Diagram

Max. deflection (mm)
M max FV max
70
Imposed Total
kNm kN only load 60
50
-83.05 60.40 -2.65 -7.25
40

30
Design 20
Design Strength Shear Capacity 10
py N/mm² 275 Area capacity 0
Av Pv
grade S275
section classification mm² kN Shear Force Diagram
grade S355
Plastic 2161.2 356.60 cl. 4.2.3
0
-1

Position Moment Fv Mcx Unity -2

Moment Capacity Factor -3
m kNm kN kNm -4
Critical section 0.000 -83.05 60.40 148.23 0.56 -5
* low shear -6
-7
Lateral torsional buckling -8

Equivalent Uniform Moment kNm Zx (cm³) 471 Deflection Diagram

Maximum moment MA -83.05 Sx (cm³) 539
Uniform factor m 1.00
Buckling moment Mbar -83.05 cl. 4.3.7.2

Slenderness Ratio cl. B.2.4 limiting slenderness lLo 34.31

Effective length radius of slenderness cl. 4.3.7.6 correction factor n 1.00
L factor LE gyration buckling parameter u 0.872
m m ry (cm) l torsional index x 29.7
2.750 1.00 2.750 2.67 103.00 cl. 4.3.7.5 cl. B.2.5 (d) slenderness factor v 0.889
cl. B.2.5 equivalent slenderness lLT 79.84
Deflection cl. B.2.3 Perry coefficient hLT 0.319
Deflection Limits Allowable Plastic moment capacity Mp 148.23
span/deflection ratios mm cl. B.2.2 Elastic critical moment ME 171.08
Imposed Loads 180 15.3 table 5 Buckling index fB 186.92
Total Loads 180 15.3
cl. B.2.1 Buckling capacity Mb 89.04

Section used: UB 305x127x37

X Y and Partners Project Steel Beam Design
address Client Made by Date Job No
Description CJB 12-8-00 2001
tel & fax nos Checked Revision Page No

S
Originated from Steel Beam © 2000-2007 Chris Buczkowski Unregistered Copy for Evaluation - - 05
Design in accordance with BS 5950 : Part 1 : 1990
Web Bearing and Buckling Design

Choose steel section: ● UB capacity

grade
Design Status ratio
● UC
S275
grade Web Buckling PASS 0.41
S355 RSJ
PF Web Bearing PASS 0.46
C

Design Strength of Web E (N/mm²) 205000 Section Dimensions (mm)

pyw N/mm² 275 depth D 311
web thickness t 9
flange thickness T 14
depth between fillets d 265.2
FULL DESIGN LOADING (kN) root radius r 8.9
Concentrated loading or
150
reaction at support *
* factored

Web Buckling
Web Slenderness Ratio Flange Unrestrained Web Compression Strength
Flange Restrained Le factor 0.70 Perry strut formula (N/mm²)
d t (not used) Le 185.64 design strength pyw 275
mm mm ry (mm) 2.60 Robertson constant a 5.5
265.2 9 cl. 4.5.2.1 l 71.45 slenderness l 71.45
limiting slenderness lo 17.15
Tick for flange Perry factor h 0.299
restrained
Euler strength pE 396.29
Web Buckling Resistance, Pw root f 394.82
b1 c n1 t pc Pw compressive strength pc 178.25
mm mm mm mm N/mm² kN ref: Appendix C

75 0 155.50 9 178.25 369.78

cl. 4.5.2.1

✘ Tick for support reaction

NOTES.
b1 = stiff bearing length.
Web Bearing n1 = length obtained by load dispersion at
45 degs though half the section depth.
Local Web Bearing Capacity, Pcrip n2 = length obtained by load dispersion
through the flange and root radius at a
b1 c n2 t pyw Pcrip slope of 1:2.5.
mm mm mm mm N/mm² kN c = overlap distance from end of beam
section to the stiff bearing.
75 0 57.25 9 275 327.32
(If end of beam section on stiff bearing,
cl. 4.5.3
c = 0)

Section used: UB 305x127x48

Factors for Lateral Torsional Buckling
Equivalent Uniform Moment Factor Calculator
Larger end Smaller end
ratio factor ref: Table 18
moment (M) moment (bM)
kNm kNm b m
20 -10 -0.50 0.43

Table 15. Slenderness Correction Factor Calculator

Larger end Smaller end Midspan
M/Mo ratio
moment (M) moment (bM) moment
kNm kNm Mo a b
20 -10 5 4.00 -0.50

Table 15. Slenderness correction factor, n, for members with applied loading substantially concentrated
within the middle fifth of the unrestrained length.
b positive b negative
a=M/Mo
1.0 0.8 0.6 0.4 0.2 0.0 -0.2 -0.4 -0.6 -0.8
> 50.00 1.00 0.96 0.91 0.86 0.82 0.77 0.72 0.68 0.65 0.65
50.00 1.00 0.96 0.92 0.87 0.82 0.77 0.72 0.67 0.66 0.66
10.00 0.99 0.99 0.94 0.90 0.85 0.80 0.75 0.69 0.68 0.68
5.00 0.98 0.98 0.97 0.93 0.89 0.84 0.79 0.73 0.71 0.70
2.00 0.96 0.95 0.95 0.95 0.94 0.94 0.89 0.84 0.79 0.77
1.50 0.95 0.95 0.94 0.94 0.93 0.93 0.92 0.90 0.85 0.80
1.00 0.93 0.92 0.92 0.92 0.92 0.91 0.91 0.91 0.91 0.92
0.50 0.90 0.90 0.90 0.89 0.89 0.89 0.89 0.89 0.88 0.88
0.00 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86
-0.10 0.85 0.85 0.85 0.85 0.85 0.86 0.86 0.86 0.86 0.86
-0.20 0.83 0.83 0.83 0.84 0.84 0.85 0.85 0.85 0.86 0.86
-0.30 0.81 0.82 0.82 0.83 0.83 0.84 0.85 0.85 0.86 0.86
-0.40 0.79 0.80 0.81 0.81 0.82 0.83 0.84 0.85 0.85 0.86
-0.50 0.77 0.78 0.79 0.80 0.82 0.83 0.85 0.86 0.86 0.87
-0.60 0.62 0.66 0.72 0.77 0.80 0.82 0.84 0.85 0.86 0.87
-0.70 0.56 0.56 0.61 0.67 0.73 0.79 0.83 0.85 0.87 0.88
-0.80 0.56 0.53 0.54 0.59 0.65 0.71 0.77 0.83 0.89 0.90
-0.90 0.59 0.57 0.54 0.53 0.57 0.64 0.71 0.77 0.84 0.88
-1.00 0.62 0.58 0.54 0.52 0.54 0.59 0.66 0.72 0.80 0.85
-1.10 0.66 0.62 0.57 0.54 0.54 0.57 0.63 0.68 0.76 0.83
-1.20 0.70 0.66 0.60 0.55 0.54 0.55 0.60 0.65 0.73 0.80
-1.30 0.73 0.69 0.63 0.57 0.55 0.54 0.57 0.61 0.69 0.77
-1.40 0.74 0.70 0.64 0.58 0.56 0.54 0.55 0.60 0.66 0.74
-1.50 0.75 0.70 0.64 0.59 0.56 0.54 0.55 0.59 0.65 0.73
-1.60 0.76 0.72 0.65 0.60 0.57 0.55 0.55 0.58 0.64 0.72
-1.70 0.77 0.74 0.66 0.61 0.58 0.56 0.55 0.58 0.63 0.70
-1.80 0.79 0.77 0.68 0.63 0.59 0.56 0.56 0.57 0.62 0.69
-1.90 0.80 0.79 0.69 0.64 0.60 0.57 0.56 0.57 0.61 0.67
-2.00 0.81 0.81 0.70 0.65 0.61 0.58 0.56 0.56 0.60 0.66
-5.00 0.93 0.89 0.83 0.77 0.72 0.67 0.64 0.61 0.60 0.62
-50.00 0.99 0.95 0.90 0.86 0.79 0.74 0.70 0.67 0.64 0.63
< -50.00 1.00 0.96 0.91 0.86 0.82 0.77 0.72 0.68 0.65 0.65
or Table 16. Slenderness Correction Factor Calculator
Larger end Smaller end Midspan
factor
moment (M) moment (bM) moment
n kNm kNm Mo
0.75 20 -10 5

tially concentrated Table 16. Slenderness correction factor, n, for members with applied loading other than as for
table 15.
tive b positive b negative
a=M/Mo
-1.0 1.0 0.8 0.6 0.4 0.2 0.0 -0.2 -0.4
0.65 > 50.00 1.00 0.96 0.91 0.86 0.82 0.77 0.72 0.68
0.65 50.00 1.00 0.96 0.92 0.87 0.83 0.77 0.72 0.67
0.67 10.00 0.99 0.98 0.95 0.91 0.86 0.81 0.76 0.70
0.70 5.00 0.99 0.98 0.97 0.94 0.90 0.85 0.80 0.75
0.76 2.00 0.98 0.98 0.97 0.96 0.94 0.92 0.90 0.86
0.80 1.50 0.97 0.97 0.97 0.96 0.95 0.93 0.92 0.89
0.92 1.00 0.97 0.97 0.97 0.96 0.96 0.95 0.94 0.93
0.88 0.50 0.96 0.96 0.96 0.96 0.96 0.95 0.94 0.94
0.86 0.00 0.94 0.94 0.94 0.94 0.94 0.94 0.94 0.94
0.86 -0.10 0.93 0.93 0.93 0.93 0.94 0.94 0.94 0.94
0.86 -0.20 0.92 0.92 0.92 0.92 0.93 0.93 0.93 0.93
0.87 -0.30 0.91 0.91 0.92 0.92 0.93 0.93 0.93 0.93
0.87 -0.40 0.90 0.90 0.91 0.91 0.92 0.92 0.92 0.92
0.88 -0.50 0.89 0.90 0.91 0.91 0.92 0.92 0.92 0.92
0.88 -0.60 0.71 0.77 0.84 0.87 0.89 0.91 0.92 0.92
0.89 -0.70 0.57 0.64 0.70 0.77 0.82 0.87 0.89 0.91
0.90 -0.80 0.47 0.52 0.59 0.67 0.73 0.80 0.86 0.90
0.91 -0.90 0.47 0.46 0.50 0.58 0.65 0.73 0.80 0.87
0.92 -1.00 0.50 0.48 0.46 0.51 0.58 0.66 0.73 0.81
0.89 -1.10 0.54 0.51 0.48 0.49 0.54 0.61 0.69 0.77
0.87 -1.20 0.57 0.54 0.50 0.47 0.51 0.56 0.64 0.73
0.83 -1.30 0.61 0.56 0.52 0.47 0.49 0.53 0.61 0.70
0.81 -1.40 0.64 0.59 0.55 0.49 0.48 0.51 0.58 0.67
0.80 -1.50 0.67 0.62 0.57 0.51 0.47 0.49 0.56 0.64
0.80 -1.60 0.69 0.64 0.59 0.52 0.48 0.50 0.55 0.63
0.78 -1.70 0.71 0.66 0.60 0.54 0.50 0.51 0.55 0.61
0.76 -1.80 0.74 0.69 0.62 0.55 0.51 0.51 0.54 0.60
0.75 -1.90 0.76 0.71 0.63 0.57 0.53 0.52 0.54 0.58
0.74 -2.00 0.78 0.73 0.65 0.58 0.54 0.53 0.53 0.57
0.65 -5.00 0.91 0.86 0.80 0.74 0.70 0.65 0.62 0.59
0.65 -50.00 0.99 0.95 0.89 0.84 0.79 0.74 0.70 0.66
0.65 < -50.00 1.00 0.96 0.91 0.86 0.82 0.77 0.72 0.68
n Factor Calculator
M/Mo ratio factor
a b n
4.00 -0.50 0.77

d loading other than as for

b negative
-0.6 -0.8 -1.0
0.65 0.65 0.65
0.66 0.66 0.65
0.68 0.68 0.67
0.71 0.70 0.70
0.82 0.78 0.76
0.86 0.83 0.79
0.93 0.91 0.89
0.94 0.93 0.92
0.94 0.94 0.94
0.94 0.94 0.94
0.94 0.94 0.93
0.94 0.94 0.94
0.93 0.93 0.93
0.92 0.92 0.92
0.92 0.92 0.92
0.92 0.92 0.91
0.92 0.92 0.92
0.90 0.90 0.90
0.87 0.89 0.89
0.83 0.87 0.88
0.80 0.84 0.87
0.77 0.82 0.86
0.74 0.79 0.85
0.71 0.77 0.84
0.69 0.76 0.83
0.68 0.74 0.82
0.66 0.73 0.81
0.65 0.71 0.80
0.63 0.70 0.79
0.58 0.61 0.67
0.63 0.62 0.65
0.65 0.65 0.65
 NOTES
FOREWORD
This spreadsheet performs an analysis and design of simply supported and cantilever, steel beams bending abo
X-X axis and subjected to gravity loads. Beams can be either with full restraint or without full restraint.

Design is in accordance with BS 5950-1:1990. Bending moments, shear forces and deflections are computed a
positions along the span and the maximums of these values are used for the design. The equations for the anal
have been obtained from the Reinforced Concrete Designer's Handbook by Reynolds and Steedman. Self weig
the steel section is automatically included in the calculations. The moment capacity of the section is calculated t
into account the corresponding shear force and a reduction is made as necessary. A check is made to see if a s
bucking calculation is required and a warning is issued. This spreadsheet also contains a calculation sheet for c
local web bearing and buckling.

The spreadsheet uses UK steel section properties which have been directly obtained from the Corus Constructi
Manual, released on CD in February 2000. The values were imported into Microsoft Excel v8.0 from the html tab
contained on the Corus CD. No typing in of values has been carried out and therefore these tables should accu
reflect the tables as published by Corus.

SETUP
This spreadsheet has been formatted using Arial, Arial Black, Symbol and Tahoma truetype fonts. The spreadsh
been optimised for a screen resolution of 1027x768 HiColor (16 bit) using large fonts.

Use the Zoom button on the toolbar to reduce or enlarge the display to suit your computer. Use the Save button
permanently store your new settings. Recommended zoom settings are as follows:
Screen resolution 800x600 with large fonts: 67%
Screen resolution 800x600 with small fonts: 85%
Screen resolution 1024x768 with large fonts: 85%
Screen resolution 1024x768 with small fonts: 105%

Company Details
Enter your company name and other details in the title block on the first sheet only. This is the 'Not Full Restrain
sheet. The details will be automatically copied to the other sheets. Company details cannot be entered in the oth
sheets directly.

KEY INFORMATION
Microsoft Excel
This spreadsheet has been developed for use in Microsoft Excel 97 (v8.0) on the Microsoft Windows 95/98 ope
system.
British Standard Specification (BSI)
This spreadsheet has been developed to comply with BS 5950 : Part 1 : 1990 and amendment no. AMD 6972
published 28 February 1992.
Support
Registered users may obtain support for this spreadsheet from: [email protected]
Additional Information
Refer to the accompanying README.TXT file for additional information.

USING STEEL BEAM FOR MICROSOFT EXCEL

The following colour key is a guide to using the full calculation page spreadsheets.

Input required. 24 Remove value

 Computed output Error/ Alert

Message

Clear cell contents

To clear the contents of a cell, right click your mouse on the cell and then click Clear Contents.

ACCURACY
This spreadsheet calculates exact values of bending moment, shear force and deflections at 1/60th positions al
span of the beam. As the actual maximum moment may not occur at precisely one of these positions, a small er
the value of the moment may occur.
In a simply supported beam, the shear force should be zero at the point of maximum moment. Where the critica
section coincides with the maximum moment, a small value for shear force may be displayed. This occurs becau
the small inaccuracy in determining the exact position of the maximum moment.
The above inaccuracies are no different than that displayed in software produced by the Steel Construction Inst
which employ similar methods of analysis and design.

However, these inaccuracies should be viewed in the correct perspective. The fact that the beam is checked an
designed at 61 positions along its span clearly indicates a more realistic approach to the actual behaviour of the
Consider a beam with a single point load where the maximum moment is at the point of zero shear. According to
code, one would be justified in stating 'low shear'. Yet, just a fraction away from the point of maximum moment,
shear force leaps to its maximum value which could result in 'high shear' and an under designed beam. This
spreadsheet, by virtue of checking at 61 positions along the beam, would not be caught out by such mathematic
anomalies.

MOMENT CAPACITY
Moment capacity is calculated at 1/60th positions along the beam span taking into account the co-existent shea
If the shear force is determined as 'high', then the corresponding moment capacity is reduced in accordance wit
requirements. At each position the 'unity factor' is calculated. This factor is the ratio of the applied moment to the
moment capacity. A unity factor of one represents full utilisation of the beam's capacity. A unity factor exceeding
indicates failure. The largest value of the unity factor determines the position of the critical section along the bea

EFFECTIVE LENGTH
Click on the "factor" cell and choose an effective length factor from the drop-down list.
If circumstances dictate a factor which is not listed, enter the factor directly into the "factor" cell ignoring the drop
list. This procedure can be used when considering a portion of beam between a lateral restraint and an end sup
Calculate the effective length in accordance with clause 4.3.5 and divide it by the length between the restraint a
end support to obtain an effective length factor for entering into the "factor" cell..

LOCAL WEB BUCKLING AND BEARING

Web Slenderness Ratio
The effective length of an unstiffened web with the flange restrained is calculated from 2.5d/t (cl. 4.5.2.1). This is
on an effective length of the web equal to 0.7d where d is the depth between fillets. Clear the flange restrained t
for a flange which is not restrained. This will enable the effective length of the web to be calculated using L E fact
obtained from Table 24 of the code.

Support Reaction Tick Box

Tick this box when considering the reaction at an end support. Clear the box when considering a point load app
the top flange of a beam. A point load applied to the top flange will disperse to either side of the stiff bearing leng
end support reaction will disperse to only one side of the stiff bearing length plus a partial dispersal through any
overlap of the end of the beam past the stiff bearing length. (see the sketch on the Bearing & Buckling sheet)
Note! If a point load is closer to the end of a beam than half the dispersal length (n 1 or n2), calculate as if for a s
reaction.
Tick this box when considering the reaction at an end support. Clear the box when considering a point load app
the top flange of a beam. A point load applied to the top flange will disperse to either side of the stiff bearing leng
end support reaction will disperse to only one side of the stiff bearing length plus a partial dispersal through any
overlap of the end of the beam past the stiff bearing length. (see the sketch on the Bearing & Buckling sheet)
Note! If a point load is closer to the end of a beam than half the dispersal length (n 1 or n2), calculate as if for a s
reaction.

Overlap Dimension 'c'

This is the dimension between the end of a beam and the stiff bearing length when a beam overlaps the stiff bea
length. (see the sketch on the Bearing & Buckling sheet). If the end of the beam does not overlap the stiff bearin
length, then c = 0.

TIPS
#1 When entering loads. the partial UDL cells can be used for point loads by entering zero in the loaded length c
#2 To enter project data into a number of sheets simultaneously, hold down the CTRL key and click on the shee
of the relevant sheets. This will 'group' the sheets and data entered into one sheet will be automatically entered
others. When finished, click on any other sheet tab which has not been selected to release the 'group' selection
feature.

SHORT CUTS
Entering Numerical Data
Expressions may be entered in place of numbers in cells requiring numerical input. e.g. To enter an expression
Click on the relevant cell. Enter the following: =4+8*3 - This expression evaluates to 28. You will see the expr
if you double click on the cell or if you have the formula bar showing (go to View menu and click Formula Bar).
, steel beams bending about their
out full restraint. Not full
restraint

eflections are computed at 1/60th

The equations for the analysis
and Steedman. Self weight of Full
restraint
the section is calculated taking
heck is made to see if a shear
ns a calculation sheet for checking

from the Corus Construction

xcel v8.0 from the html tables
these tables should accurately

etype fonts. The spreadsheet has

puter. Use the Save button to

his is the 'Not Full Restraint'

annot be entered in the other

osoft Windows 95/98 operating

endment no. AMD 6972

eering.fsnet.co.uk
 ions at 1/60th positions along the
these positions, a small error in

moment. Where the critical

splayed. This occurs because of

he Steel Construction Institute

at the beam is checked and

he actual behaviour of the beam.
of zero shear. According to the
oint of maximum moment, the
r designed beam. This
ht out by such mathematical

count the co-existent shear force.

reduced in accordance with code
the applied moment to the
y. A unity factor exceeding one
tical section along the beam.

actor" cell ignoring the drop-down

al restraint and an end support.
th between the restraint and the

m 2.5d/t (cl. 4.5.2.1). This is based

ear the flange restrained tick box
be calculated using L E factors

nsidering a point load applied to

ide of the stiff bearing length. An
rtial dispersal through any
aring & Buckling sheet)
r n2), calculate as if for a support
beam overlaps the stiff bearing
not overlap the stiff bearing

zero in the loaded length cell.

key and click on the sheet tabs
be automatically entered into the
ease the 'group' selection

g. To enter an expression:-
o 28. You will see the expression
u and click Formula Bar).
 STEEL BEAM
FOR MICROSOFT EXCEL
Version
Version 2.03
Please ensure you have the latest version of this software, which may be downloaded
from the internet via this hyperlink : http://www.structural-engineering.org.uk
Click the Connect button to go to the web site.
If you have comments, suggestions, bug reports or
require information, please email: [email protected]

Copyright © 2000-2007 Chris Buczkowski. All rights reserved.

Registration ¤ THIS IS AN UNREGISTERED COPY ¤

Single user licence: £40 VALID FOR 0 COPIES ONLY
Company multiple-user licence: £40 per copy installed

Delivery will be by attachment to an email.

To order a copy, please send a cheque payable to 'C. Buczkowski' to the

following address:
Flat 708, 100 Kingsway, North Finchley, LONDON N12 0EQ

You should include your email or postal address and a contact telephone Tel: 07939-187549
number. Also include the name you require the spreadsheet registered to (30 Tel/fax: 020-8343 9844
characters maximum). email: [email protected]

Licence for Use and Distribution

This spreadsheet is NOT a public domain program. It is copyrighted by the Author*. This software is protected
Kingdom copyright law and also by international treaty provisions. The Author grants you a licence to use this
for evaluation purposes for an indefinite period. You may not use, copy, rent, lease, sell, modify, decompile, u
disassemble, otherwise reverse engineer, or transfer this software except as provided in this agreement. A
unauthorised use shall result in immediate and automatic termination of this licence. All rights not expressly gra
are reserved to the Author. You may copy and distribute the unregistered version of this spreadsheet, co
unaltered, without further permission. The readme.txt file must accompany copies of the spreadsheet.
* The Author is Chris Buczkowski.

Disclaimer
THIS SOFTWARE IS PROVIDED FOR EVALUATION ONLY, ON AN "AS IS" BASIS. THE AUTHOR DISCLAIMS ALL WAR
RELATING TO THIS SOFTWARE, WHETHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO ANY
WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. THE AUTHOR* SHALL NOT B
FOR ANY INDIRECT, CONSEQUENTIAL, OR INCIDENTAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO U
SOFTWARE, EVEN IF THE AUTHOR HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES OR CLAI
PERSON USING THE SOFTWARE BEARS ALL RISK AS TO THE QUALITY AND PERFORMANCE OF THE SO
ALTHOUGH EVERY EFFORT HAS BEEN MADE TO ENSURE THE ACCURACY OF THIS PROGRAM, USERS SHOUL
THE RESULTS FOR THEMSELVES

REVISION HISTORY
Date Version Action
 8/12/2000 1.0 Initial release
11/13/2000 1.1 102x44x7 RSJ width corrected - Dr Shaiq Khan
2/11/2001 1.2 'n' factors calculator added.
Number of loads increased, analysis increased to 60 nodes across span, calculation she
5/16/2001 2.0 rearranged, effective length factor improved. Cantilever beam sheet added. Web bearin
buckling sheet added. Other minor amendments.
8/13/2001 2.01 Amended conditional formatting error in partial UDL's.
5/29/2006 2.02 Administrative revisIon.
3/2/2007 2.03 Administrative revisIon.
L

ngineering.org.uk

UNREGISTERED COPY ¤
OR 0 COPIES ONLY

Tel: 07939-187549
Tel/fax: 020-8343 9844
email: [email protected]

Author*. This software is protected by United

hor grants you a licence to use this software
nt, lease, sell, modify, decompile, unprotect,
t as provided in this agreement. Any such
licence. All rights not expressly granted here
ed version of this spreadsheet, completely
opies of the spreadsheet.

S. THE AUTHOR DISCLAIMS ALL WARRANTIES

LUDING BUT NOT LIMITED TO ANY IMPLIED
POSE. THE AUTHOR* SHALL NOT BE LIABLE
OUT OF THE USE OR INABILITY TO USE SUCH
LITY OF SUCH DAMAGES OR CLAIMS. THE
AND PERFORMANCE OF THE SOFTWARE.
OF THIS PROGRAM, USERS SHOULD VERIFY
 nodes across span, calculation sheet
ver beam sheet added. Web bearing and

s.
Other spreadsheets:
BAR SCHEDULE FOR EXCEL 97
Bar Schedule for Excel 97 is a spreadsheet for the scheduling of steel for the reinforcement of concrete. The spreadsheet has
been developed to comply with BS 4466 : 1989 and Amendment No. 1 published 28 February 1990.

The aim of the spreadsheet is to reduce the time taken to produce a bar schedule, reduce arithmetical errors, reduce
scheduling errors, increase compliance with the BSI specified format for bar scheduling and, eventually, become the basis for
electronic data interchange.

The latest version of Bar Schedule may be downloaded from : http://www.structural-engineering.fsnet.co.uk

Other spreadsheets:
WIND DESIGN WORKBOOK
This spreadsheet implements the full Standard Method of calculating wind loads for buildings in accordance with BS 6399 : Part
2 : 1997. This method is suitable for buildings up to 100m high. The workbook contains spreadsheets which can be printed as
complete calculation pages. It also contains spreadsheets which can be used as design aids, useful for hand calculations or
checking designs. For Engineers new to the code, the spreadsheet can prove an invaluable teaching aid.

The latest version of Wind Design Workbook may be downloaded from :

http://www.structural-engineering.fsnet.co.uk

Other spreadsheets:
REINFORCED CONCRETE WORKBOOK
A spreadsheet which is a powerful aid for the reinforced concrete detailer or designer. It contains many of the everyday
calculations required for detailing and designing reinforced concrete such as lap lengths, minimum spacings, bar bend
dimensions and much more! This spreadsheet could be looked on as an electronic book with an index followed by pages
containing many individual calculators. Each calculator has a specific task to perform. The Reinforced Concrete Workbook also
acts as an aide memoir, reminding the user of the various checks to be made.

The latest version of Reinforced Concrete Workbook may be downloaded from :

http://www.structural-engineering.fsnet.co.uk

FREE SPREADSHEETS !!
REINFORCEMENT AREAS
An interactive sheet for determining areas of reinforcement for concrete.
ISSUE SHEET
A must for every office, a simple but presentable document/drawing issue sheet that can be customised with your company's
name.
STRUCTURAL SECTIONS
British Steel (Corus) steel section tables in Excel format.

The latest versions may be downloaded from :

http://www.structural-engineering.fsnet.co.uk

Other spreadsheets:
BAR SCHEDULE 8666 FOR MICROSOFT EXCEL
Bar Schedule 8666 for Microsoft Excel is a spreadsheet for the scheduling of steel for the reinforcement of concrete. The
spreadsheet has been developed to comply with BS 8666 : 2000.

The aim of the spreadsheet is to reduce the time taken to produce a bar schedule, reduce arithmetical errors, reduce scheduling
errors, increase compliance with the BSI specified format for bar scheduling and, eventually, become the basis for electronic
data interchange.

The latest version of Bar Schedule 8666 may be downloaded from :

http://www.structural-engineering.fsnet.co.uk
Bar Schedule 8666 for Microsoft Excel is a spreadsheet for the scheduling of steel for the reinforcement of concrete. The
spreadsheet has been developed to comply with BS 8666 : 2000.

The aim of the spreadsheet is to reduce the time taken to produce a bar schedule, reduce arithmetical errors, reduce scheduling
errors, increase compliance with the BSI specified format for bar scheduling and, eventually, become the basis for electronic
data interchange.

The latest version of Bar Schedule 8666 may be downloaded from :

http://www.structural-engineering.fsnet.co.uk
readsheet has

duce
e the basis for

h BS 6399 : Part
be printed as
lculations or

eryday
r bend
by pages
Workbook also

our company's

crete. The

educe scheduling
for electronic
crete. The

educe scheduling
for electronic
1 2 3 4 5 6 7 8 9 10 11 12

Universal Beams to BS4 Part1 1993 - Dimensions & Properties

Ratios for Second Moment
Mass Depth Thickness Depth Local Buckling
Width of Root of Area
Per of between
section radius
Designation metre section fillets Axis
Web Flange Flange Web
x-x
h b s t r d b/2t d/s Ix
kg/m mm mm mm mm mm mm cm4
1 1016x305x487 486.6 1036.1 308.5 30 54.1 30 867.9 2.85 28.9 1021400
2 1016x305x437 436.9 1025.9 305.4 26.9 49 30 867.9 3.12 32.3 909900
3 1016x305x393 392.7 1016 303 24.4 43.9 30 868.2 3.45 35.6 807700
4 1016x305x349 349.4 1008.1 302 21.1 40 30 868.1 3.77 41.1 723100
5 1016x305x314 314.3 1000 300 19.1 35.9 30 868.2 4.18 45.5 644200
6 1016x305x272 272.3 990.1 300 16.5 31 30 868.1 4.84 52.6 554000
7 1016x305x249 248.7 980.2 300 16.5 26 30 868.2 5.77 52.6 481300
8 1016x305x222 222 970.3 300 16 21.1 30 868.1 7.11 54.3 408000
9 914x419x388 388 921 420.5 21.4 36.6 24.1 799.6 5.74 37.4 719600
10 914x419x343 343.3 911.8 418.5 19.4 32 24.1 799.6 6.54 41.2 625800
11 914x305x289 289.1 926.6 307.7 19.5 32 19.1 824.4 4.81 42.3 504200
12 914x305x253 253.4 918.4 305.5 17.3 27.9 19.1 824.4 5.47 47.7 436300
13 914x305x224 224.2 910.4 304.1 15.9 23.9 19.1 824.4 6.36 51.8 376400
14 914x305x201 200.9 903 303.3 15.1 20.2 19.1 824.4 7.51 54.6 325300
15 838x292x226 226.5 850.9 293.8 16.1 26.8 17.8 761.7 5.48 47.3 339700
16 838x292x194 193.8 840.7 292.4 14.7 21.7 17.8 761.7 6.74 51.8 279200
17 838x292x176 175.9 834.9 291.7 14 18.8 17.8 761.7 7.76 54.4 246000
18 762x267x197 196.8 769.8 268 15.6 25.4 16.5 686 5.28 44 240000
19 762x267x173 173 762.2 266.7 14.3 21.6 16.5 686 6.17 48 205300
20 762x267x147 146.9 754 265.2 12.8 17.5 16.5 686 7.58 53.6 168500
21 762x267x134 133.9 750 264.4 12 15.5 16.5 686 8.53 57.2 150700
22 686x254x170 170.2 692.9 255.8 14.5 23.7 15.2 615.1 5.4 42.4 170300
23 686x254x152 152.4 687.5 254.5 13.2 21 15.2 615.1 6.06 46.6 150400
24 686x254x140 140.1 683.5 253.7 12.4 19 15.2 615.1 6.68 49.6 136300
25 686x254x125 125.2 677.9 253 11.7 16.2 15.2 615.1 7.81 52.6 118000
26 610x305x238 238.1 635.8 311.4 18.4 31.4 16.5 540 4.96 29.3 209500
27 610x305x179 179 620.2 307.1 14.1 23.6 16.5 540 6.51 38.3 153000
28 610x305x149 149.2 612.4 304.8 11.8 19.7 16.5 540 7.74 45.8 125900
29 610x229x140 139.9 617.2 230.2 13.1 22.1 12.7 547.6 5.21 41.8 111800
30 610x229x125 125.1 612.2 229 11.9 19.6 12.7 547.6 5.84 46 98610
31 610x229x113 113 607.6 228.2 11.1 17.3 12.7 547.6 6.6 49.3 87320
32 610x229x101 101.2 602.6 227.6 10.5 14.8 12.7 547.6 7.69 52.2 75780
33 533x210x122 122 544.5 211.9 12.7 21.3 12.7 476.5 4.97 37.5 76040
34 533x210x109 109 539.5 210.8 11.6 18.8 12.7 476.5 5.61 41.1 66820
35 533x210x101 101 536.7 210 10.8 17.4 12.7 476.5 6.03 44.1 61520
36 533x210x92 92.14 533.1 209.3 10.1 15.6 12.7 476.5 6.71 47.2 55230
37 533x210x82 82.2 528.3 208.8 9.6 13.2 12.7 476.5 7.91 49.6 47540
38 457x191x98 98.3 467.2 192.8 11.4 19.6 10.2 407.6 4.92 35.8 45730
39 457x191x89 89.3 463.4 191.9 10.5 17.7 10.2 407.6 5.42 38.8 41020
40 457x191x82 82 460 191.3 9.9 16 10.2 407.6 5.98 41.2 37050
41 457x191x74 74.3 457 190.4 9 14.5 10.2 407.6 6.57 45.3 33320
42 457x191x67 67.1 453.4 189.9 8.5 12.7 10.2 407.6 7.48 48 29380
43 457x152x82 82.1 465.8 155.3 10.5 18.9 10.2 407.6 4.11 38.8 36590
44 457x152x74 74.2 462 154.4 9.6 17 10.2 407.6 4.54 42.5 32670
45 457x152x67 67.2 458 153.8 9 15 10.2 407.6 5.13 45.3 28930
46 457x152x60 59.8 454.6 152.9 8.1 13.3 10.2 407.6 5.75 50.3 25500
47 457x152x52 52.3 449.8 152.4 7.6 10.9 10.2 407.6 6.99 53.6 21370
48 406x178x74 74.2 412.8 179.5 9.5 16 10.2 360.4 5.61 37.9 27310
49 406x178x67 67.1 409.4 178.8 8.8 14.3 10.2 360.4 6.25 41 24330
50 406x178x60 60.1 406.4 177.9 7.9 12.8 10.2 360.4 6.95 45.6 21600
51 406x178x54 54.1 402.6 177.7 7.7 10.9 10.2 360.4 8.15 46.8 18720
52 406x140x46 46 403.2 142.2 6.8 11.2 10.2 360.4 6.35 53 15690
53 406x140x39 39 398 141.8 6.4 8.6 10.2 360.4 8.24 56.3 12510
54 356x171x67 67.1 363.4 173.2 9.1 15.7 10.2 311.6 5.52 34.2 19460
55 356x171x57 57 358 172.2 8.1 13 10.2 311.6 6.62 38.5 16040
56 356x171x51 51 355 171.5 7.4 11.5 10.2 311.6 7.46 42.1 14140
57 356x171x45 45 351.4 171.1 7 9.7 10.2 311.6 8.82 44.5 12070
58 356x127x39 39.1 353.4 126 6.6 10.7 10.2 311.6 5.89 47.2 10170
59 356x127x33 33.1 349 125.4 6 8.5 10.2 311.6 7.38 51.9 8249
60 305x165x54 54 310.4 166.9 7.9 13.7 8.9 265.2 6.09 33.6 11700
61 305x165x46 46.1 306.6 165.7 6.7 11.8 8.9 265.2 7.02 39.6 9899
62 305x165x40 40.3 303.4 165 6 10.2 8.9 265.2 8.09 44.2 8503
63 305x127x48 48.1 311 125.3 9 14 8.9 265.2 4.47 29.5 9575
64 305x127x42 41.9 307.2 124.3 8 12.1 8.9 265.2 5.14 33.1 8196
65 305x127x37 37 304.4 123.4 7.1 10.7 8.9 265.2 5.77 37.4 7171
66 305x102x33 32.8 312.7 102.4 6.6 10.8 7.6 275.9 4.74 41.8 6501
67 305x102x28 28.2 308.7 101.8 6 8.8 7.6 275.9 5.78 46 5366
68 305x102x25 24.8 305.1 101.6 5.8 7 7.6 275.9 7.26 47.6 4455
69 254x146x43 43 259.6 147.3 7.2 12.7 7.6 219 5.8 30.4 6544
70 254x146x37 37 256 146.4 6.3 10.9 7.6 219 6.72 34.8 5537
71 254x146x31 31.1 251.4 146.1 6 8.6 7.6 219 8.49 36.5 4413
72 254x102x28 28.3 260.4 102.2 6.3 10 7.6 225.2 5.11 35.7 4005
73 254x102x25 25.2 257.2 101.9 6 8.4 7.6 225.2 6.07 37.5 3415
74 254x102x22 22 254 101.6 5.7 6.8 7.6 225.2 7.47 39.5 2841
75 203x133x30 30 206.8 133.9 6.4 9.6 7.6 172.4 6.97 26.9 2896
76 203x133x25 25.1 203.2 133.2 5.7 7.8 7.6 172.4 8.54 30.2 2340
77 203x102x23 23.1 203.2 101.8 5.4 9.3 7.6 169.4 5.47 31.4 2105
78 178x102x19 19 177.8 101.2 4.8 7.9 7.6 146.8 6.41 30.6 1356
79 152x89x16 16 152.4 88.7 4.5 7.7 7.6 121.8 5.76 27.1 834
80 127x76x13 13 127 76 4 7.6 7.6 96.6 5 24.1 473
 13 14 15 16 17 18 19 20 21 22 23 24

rties
Second Moment Radius of Elastic Plastic
of Area Gyration Modulus Modulus Buckling Torsional Warping Torsional Area of
Parameter Index Constant Constant section
Axis Axis Axis Axis Axis Axis Axis
y-y x-x y-y x-x y-y x-x y-y
Iy rx ry Zx Zy Sx Sy u x H J A
cm 4
cm cm cm 3
cm 3
cm 3
cm 3
dm6 cm4 cm2
26720 40.6 6.57 19720 1732 23200 2800 0.867 21.1 64.4 4299 620
23450 40.4 6.49 17740 1535 20760 2469 0.868 23.1 55.9 3185 557
20500 40.2 6.4 15900 1353 18540 2168 0.868 25.5 48.4 2330 500
18460 40.3 6.44 14350 1223 16590 1941 0.872 27.9 43.3 1718 445
16230 40.1 6.37 12880 1082 14850 1713 0.872 30.7 37.7 1264 400
14000 40 6.35 11190 934 12830 1470 0.873 35 32.2 835 347
11750 39 6.09 9821 784 11350 1245 0.861 39.9 26.8 582 317
9546 38 5.81 8409 636 9807 1020 0.85 45.7 21.5 390 283
45440 38.2 9.59 15630 2161 17670 3341 0.885 26.7 88.9 1734 494
39160 37.8 9.46 13730 1871 15480 2890 0.883 30.1 75.8 1193 437
15600 37 6.51 10880 1014 12570 1601 0.867 31.9 31.2 926 368
13300 36.8 6.42 9501 871 10940 1371 0.866 36.2 26.4 626 323
11240 36.3 6.27 8269 739 9535 1163 0.861 41.3 22.1 422 286
9423 35.7 6.07 7204 621 8351 982 0.854 46.8 18.4 291 256
11360 34.3 6.27 7985 773 9155 1212 0.87 35 19.3 514 289
9066 33.6 6.06 6641 620 7640 974 0.862 41.6 15.2 306 247
7799 33.1 5.9 5893 535 6808 842 0.856 46.5 13 221 224
8175 30.9 5.71 6234 610 7167 959 0.869 33.2 11.3 404 251
6850 30.5 5.58 5387 514 6198 807 0.864 38.1 9.39 267 220
5455 30 5.4 4470 411 5156 647 0.858 45.2 7.4 159 187
4788 29.7 5.3 4018 362 4644 570 0.854 49.8 6.46 119 171
6630 28 5.53 4916 518 5631 811 0.872 31.8 7.42 308 217
5784 27.8 5.46 4374 455 5000 710 0.871 35.5 6.42 220 194
5183 27.6 5.39 3987 409 4558 638 0.868 38.7 5.72 169 178
4383 27.2 5.24 3481 346 3994 542 0.862 43.9 4.8 116 159
15840 26.3 7.23 6589 1017 7486 1574 0.886 21.3 14.5 785 303
11410 25.9 7.07 4935 743 5547 1144 0.886 27.7 10.2 340 228
9308 25.7 7 4111 611 4594 937 0.886 32.7 8.17 200 190
4505 25 5.03 3622 391 4142 611 0.875 30.6 3.99 216 178
3932 24.9 4.97 3221 343 3676 535 0.873 34.1 3.45 154 159
3434 24.6 4.88 2874 301 3281 469 0.87 38 2.99 111 144
2915 24.2 4.75 2515 256 2881 400 0.864 43.1 2.52 77 129
3388 22.1 4.67 2793 320 3196 500 0.877 27.6 2.32 178 155
2943 21.9 4.6 2477 279 2828 436 0.875 30.9 1.99 126 139
2692 21.9 4.57 2292 256 2612 399 0.874 33.2 1.81 101 129
2389 21.7 4.51 2072 228 2360 356 0.872 36.5 1.6 75.7 117
2007 21.3 4.38 1800 192 2059 300 0.864 41.6 1.33 51.5 105
2347 19.1 4.33 1957 243 2232 379 0.881 25.7 1.18 121 125
2089 19 4.29 1770 218 2014 338 0.88 28.3 1.04 90.7 114
1871 18.8 4.23 1611 196 1831 304 0.877 30.9 0.922 69.2 104
1671 18.8 4.2 1458 176 1653 272 0.877 33.9 0.818 51.8 94.6
1452 18.5 4.12 1296 153 1471 237 0.872 37.9 0.705 37.1 85.5
1185 18.7 3.37 1571 153 1811 240 0.873 27.4 0.591 89.2 105
1047 18.6 3.33 1414 136 1627 213 0.873 30.1 0.518 65.9 94.5
913 18.4 3.27 1263 119 1453 187 0.869 33.6 0.448 47.7 85.6
795 18.3 3.23 1122 104 1287 163 0.868 37.5 0.387 33.8 76.2
 645 17.9 3.11 950 84.6 1096 133 0.859 43.9 0.311 21.4 66.6
1545 17 4.04 1323 172 1501 267 0.882 27.6 0.608 62.8 94.5
1365 16.9 3.99 1189 153 1346 237 0.88 30.5 0.533 46.1 85.5
1203 16.8 3.97 1063 135 1199 209 0.88 33.8 0.466 33.3 76.5
1021 16.5 3.85 930 115 1055 178 0.871 38.3 0.392 23.1 69
538 16.4 3.03 778 75.7 888 118 0.871 38.9 0.207 19 58.6
410 15.9 2.87 629 57.8 724 90.8 0.858 47.5 0.155 10.7 49.7
1362 15.1 3.99 1071 157 1211 243 0.886 24.4 0.412 55.7 85.5
1108 14.9 3.91 896 129 1010 199 0.882 28.8 0.33 33.4 72.6
968 14.8 3.86 796 113 896 174 0.881 32.1 0.286 23.8 64.9
811 14.5 3.76 687 94.8 775 147 0.874 36.8 0.237 15.8 57.3
358 14.3 2.68 576 56.8 659 89.1 0.871 35.2 0.105 15.1 49.8
280 14 2.58 473 44.7 543 70.3 0.863 42.2 0.081 8.79 42.1
1063 13 3.93 754 127 846 196 0.889 23.6 0.234 34.8 68.8
896 13 3.9 646 108 720 166 0.891 27.1 0.195 22.2 58.7
764 12.9 3.86 560 92.6 623 142 0.889 31 0.164 14.7 51.3
461 12.5 2.74 616 73.6 711 116 0.873 23.3 0.102 31.8 61.2
389 12.4 2.7 534 62.6 614 98.4 0.872 26.5 0.085 21.1 53.4
336 12.3 2.67 471 54.5 539 85.4 0.872 29.7 0.072 14.8 47.2
194 12.5 2.15 416 37.9 481 60 0.866 31.6 0.044 12.2 41.8
155 12.2 2.08 348 30.5 403 48.5 0.859 37.4 0.035 7.4 35.9
123 11.9 1.97 292 24.2 342 38.8 0.846 43.4 0.027 4.77 31.6
677 10.9 3.52 504 92 566 141 0.891 21.2 0.103 23.9 54.8
571 10.8 3.48 433 78 483 119 0.89 24.3 0.086 15.3 47.2
448 10.5 3.36 351 61.3 393 94.1 0.88 29.6 0.066 8.55 39.7
179 10.5 2.22 308 34.9 353 54.8 0.874 27.5 0.028 9.57 36.1
149 10.3 2.15 266 29.2 306 46 0.866 31.5 0.023 6.42 32
119 10.1 2.06 224 23.5 259 37.3 0.856 36.4 0.018 4.15 28
385 8.71 3.17 280 57.5 314 88.2 0.881 21.5 0.037 10.3 38.2
308 8.56 3.1 230 46.2 258 70.9 0.877 25.6 0.029 5.96 32
164 8.46 2.36 207 32.2 234 49.8 0.888 22.5 0.015 7.02 29.4
137 7.48 2.37 153 27 171 41.6 0.888 22.6 0.01 4.41 24.3
89.8 6.41 2.1 109 20.2 123 31.2 0.89 19.6 0.005 3.56 20.3
55.7 5.35 1.84 74.6 14.7 84.2 22.6 0.895 16.3 0.002 2.85 16.5
1 2 3 4 5 6 7 8 9 10 11 12 13

Universal Columns to BS4 Part1 1993 - Dimensions & Properties

Ratios for Second Moment
Mass Depth Thickness Depth Local Buckling
Width of Root of Area
Per of between
Section Radius Axis Axis
Designation metre Section Web Flange fillets Flange Web
x-x y-y
h b s t r d b/2t d/s I x
Iy
kg/m mm mm mm mm mm mm cm4 cm4
1 356x406x634 633.9 474.6 424 47.6 77 15.2 290.2 2.75 6.1 274800 98130
2 356x406x551 551 455.6 418.5 42.1 67.5 15.2 290.2 3.1 6.89 226900 82670
3 356x406x467 467 436.6 412.2 35.8 58 15.2 290.2 3.55 8.11 183000 67830
4 356x406x393 393 419 407 30.6 49.2 15.2 290.2 4.14 9.48 146600 55370
5 356x406x340 339.9 406.4 403 26.6 42.9 15.2 290.2 4.7 10.9 122500 46850
6 356x406x287 287.1 393.6 399 22.6 36.5 15.2 290.2 5.47 12.8 99880 38680
7 356x406x235 235.1 381 394.8 18.4 30.2 15.2 290.2 6.54 15.8 79080 30990
8 356x368x202 201.9 374.6 374.7 16.5 27 15.2 290.2 6.94 17.6 66260 23690
9 356x368x177 177 368.2 372.6 14.4 23.8 15.2 290.2 7.83 20.2 57120 20530
10 356x368x153 152.9 362 370.5 12.3 20.7 15.2 290.2 8.95 23.6 48590 17550
11 356x368x129 129 355.6 368.6 10.4 17.5 15.2 290.2 10.5 27.9 40250 14610
12 305x305x283 282.9 365.3 322.2 26.8 44.1 15.2 246.7 3.65 9.21 78870 24630
13 305x305x240 240 352.5 318.4 23 37.7 15.2 246.7 4.22 10.7 64200 20310
14 305x305x198 198.1 339.9 314.5 19.1 31.4 15.2 246.7 5.01 12.9 50900 16300
15 305x305x158 158.1 327.1 311.2 15.8 25 15.2 246.7 6.22 15.6 38750 12570
16 305x305x137 136.9 320.5 309.2 13.8 21.7 15.2 246.7 7.12 17.9 32810 10700
17 305x305x118 117.9 314.5 307.4 12 18.7 15.2 246.7 8.22 20.6 27670 9059
18 305x305x97 96.9 307.9 305.3 9.9 15.4 15.2 246.7 9.91 24.9 22250 7308
19 254x254x167 167.1 289.1 265.2 19.2 31.7 12.7 200.3 4.18 10.4 30000 9870
20 254x254x132 132 276.3 261.3 15.3 25.3 12.7 200.3 5.16 13.1 22530 7531
21 254x254x107 107.1 266.7 258.8 12.8 20.5 12.7 200.3 6.31 15.6 17510 5928
22 254x254x89 88.9 260.3 256.3 10.3 17.3 12.7 200.3 7.41 19.4 14270 4857
23 254x254x73 73.1 254.1 254.6 8.6 14.2 12.7 200.3 8.96 23.3 11410 3908
24 203x203x86 86.1 222.2 209.1 12.7 20.5 10.2 160.8 5.1 12.7 9449 3127
25 203x203x71 71 215.8 206.4 10 17.3 10.2 160.8 5.97 16.1 7618 2537
26 203x203x60 60 209.6 205.8 9.4 14.2 10.2 160.8 7.25 17.1 6125 2065
27 203x203x52 52 206.2 204.3 7.9 12.5 10.2 160.8 8.17 20.4 5259 1778
28 203x203x46 46.1 203.2 203.6 7.2 11 10.2 160.8 9.25 22.3 4568 1548
29 152x152x37 37 161.8 154.4 8 11.5 7.6 123.6 6.71 15.5 2210 706
30 152x152x30 30 157.6 152.9 6.5 9.4 7.6 123.6 8.13 19 1748 560
31 152x152x23 23 152.4 152.2 5.8 6.8 7.6 123.6 11.2 21.3 1250 400
 14 15 16 17 18 19 20 21 22 23 24

ties
Radius of Elastic Plastic
Gyration Modulus Modulus Buckling Torsional Warping Torsional Area of
Axis Axis Axis Axis Axis Axis Parameter Index Constant Constant Section
x-x y-y x-x y-y x-x y-y
rx ry Zx Zy Sx Sy u x H J A
cm cm cm3 cm3 cm3 cm3 dm6 cm4 cm2
18.4 11 11580 4629 14240 7108 0.843 5.46 38.8 13720 808
18 10.9 9962 3951 12080 6058 0.841 6.05 31.1 9240 702
17.5 10.7 8383 3291 10000 5034 0.839 6.86 24.3 5809 595
17.1 10.5 6998 2721 8222 4154 0.837 7.86 18.9 3545 501
16.8 10.4 6031 2325 6999 3544 0.836 8.85 15.5 2343 433
16.5 10.3 5075 1939 5812 2949 0.835 10.2 12.3 1441 366
16.3 10.2 4151 1570 4687 2383 0.834 12.1 9.54 812 299
16.1 9.6 3538 1264 3972 1920 0.844 13.4 7.16 558 257
15.9 9.54 3103 1102 3455 1671 0.844 15 6.09 381 226
15.8 9.49 2684 948 2965 1435 0.844 17 5.11 251 195
15.6 9.43 2264 793 2479 1199 0.844 19.9 4.18 153 164
14.8 8.27 4318 1529 5105 2342 0.855 7.65 6.35 2034 360
14.5 8.15 3643 1276 4247 1951 0.854 8.74 5.03 1271 306
14.2 8.04 2995 1037 3440 1581 0.854 10.2 3.88 734 252
13.9 7.9 2369 808 2680 1230 0.851 12.5 2.87 378 201
13.7 7.83 2048 692 2297 1053 0.851 14.2 2.39 249 174
13.6 7.77 1760 589 1958 895 0.85 16.2 1.98 161 150
13.4 7.69 1445 479 1592 726 0.85 19.3 1.56 91.2 123
11.9 6.81 2075 744 2424 1137 0.851 8.49 1.63 626 213
11.6 6.69 1631 576 1869 878 0.85 10.3 1.19 319 168
11.3 6.59 1313 458 1484 697 0.848 12.4 0.898 172 136
11.2 6.55 1096 379 1224 575 0.85 14.5 0.717 102 113
11.1 6.48 898 307 992 465 0.849 17.3 0.562 57.6 93.1
9.28 5.34 850 299 977 456 0.85 10.2 0.318 137 110
9.18 5.3 706 246 799 374 0.853 11.9 0.25 80.2 90.4
8.96 5.2 584 201 656 305 0.846 14.1 0.197 47.2 76.4
8.91 5.18 510 174 567 264 0.848 15.8 0.167 31.8 66.3
8.82 5.13 450 152 497 231 0.847 17.7 0.143 22.2 58.7
6.85 3.87 273 91.5 309 140 0.848 13.3 0.04 19.2 47.1
6.76 3.83 222 73.3 248 112 0.849 16 0.031 10.5 38.3
6.54 3.7 164 52.6 182 80.2 0.84 20.7 0.021 4.63 29.2
1 2 3 4 5 6 7 8 9 10 11 12 13 14

Joists to BS4 Part 1 1993 - Dimensions & Properties

Inside Slope = 8o
Mass Depth Depth Ratios for Second Moment
Width of Thickness Radius
Per of between Local Buckling of Area
Designation metre Section Section fillets
Web Flange Root Toe Flange Web Axis Axis
h b s t r1 r2 d b/2t d/s x-x y-y
mm x mm x
mm mm mm mm mm mm cm4 cm4
kg/m
1 254x203x82 82 254 203.2 10.2 19.9 19.6 9.7 166.6 5.11 16.3 12020 2280
2 203x152x52 52.3 203.2 152.4 8.9 16.5 15.5 7.6 133.2 4.62 15 4798 816
3 152x127x37 37.3 152.4 127 10.4 13.2 13.5 6.6 94.3 4.81 9.07 1818 378
4 127x114x29 29.3 127 114.3 10.2 11.5 9.9 4.8 79.5 4.97 7.79 979 242
5 127x114x27 26.9 127 114.3 7.4 11.4 9.9 5 79.5 5.01 10.7 946 236
6 102x102x23 23 101.6 101.6 9.5 10.3 11.1 3.2 55.2 4.93 5.81 486 154
7 102x44x7 7.5 101.6 44.5 4.3 6.1 6.9 3.3 74.6 3.65 17.3 153 7.82
8 89x89x19 19.5 88.9 88.9 9.5 9.9 11.1 3.2 44.2 4.49 4.65 307 101
9 76x76x13 12.8 76.2 76.2 5.1 8.4 9.4 4.6 38.1 4.54 7.47 158 51.8
15 16 17 18 19 20 21 22 23 24 25

Radius of Elastic Plastic

Gyration Modulus Modulus Buckling Torsional Warping Torsional Area of
Parameter Index Constant Constant Section
Axis Axis Axis Axis Axis Axis
x-x y-y x-x y-y x-x y-y u x H J A

cm cm cm3 cm3 cm3 cm3 dm6 cm4 cm2

10.7 4.67 947 224 1077 371 0.89 11 0.312 152 105
8.49 3.5 472 107 541 176 0.891 10.7 0.0711 64.8 66.6
6.19 2.82 239 59.6 279 99.8 0.866 9.33 0.0183 33.9 47.5
5.12 2.54 154 42.3 181 70.8 0.853 8.76 0.00807 20.8 37.4
5.26 2.63 149 41.3 172 68.2 0.868 9.32 0.00788 16.9 34.2
4.07 2.29 95.6 30.3 113 50.6 0.836 7.43 0.00321 14.2 29.3
4.01 0.907 30.1 3.51 35.4 6.03 0.872 14.9 0.000178 1.25 9.5
3.51 2.02 69 22.8 82.7 38 0.83 6.57 0.00158 11.5 24.9
3.12 1.79 41.5 13.6 48.7 22.4 0.852 7.22 0.000595 4.59 16.2
1 2 3 4 5 6 7 8 9 10 11 12 13

Parallel Flange Channels - Dimensions and Properties

Mass Depth Width of Thickness Root Depth Ratios for Local Second Moment
Per of Section Radius between Buckling of Area
metre Section Web Flange Fillets Flange Web Axis Axis
Designation
D B t T r d b/T d/t x-x y-y
Kg/m mm mm mm mm mm mm cm4 cm4
1 430x100x64 64.4 430 100 11 19 15 362 5.26 32.9 21940 722
2 380x100x54 54.0 380 100 9.5 17.5 15 315 5.71 33.2 15030 643
3 300x100x46 45.5 300 100 9 16.5 15 237 6.06 26.3 8229 568
4 300x90x41 41.4 300 90 9 15.5 12 245 5.81 27.2 7218 404
5 260x90x35 34.8 260 90 8 14 12 208 6.43 26 4728 353
6 260x75x28 27.6 260 75 7 12 12 212 6.25 30.3 3619 185
7 230x90x32 32.2 230 90 7.5 14 12 178 6.43 23.7 3518 334
8 230x75x26 25.7 230 75 6.5 12.5 12 181 6 27.8 2748 181
9 200x90x30 29.7 200 90 7 14 12 148 6.43 21.1 2523 314
10 200x75x23 23.4 200 75 6 12.5 12 151 6 25.2 1963 170
11 180x90x26 26.1 180 90 6.5 12.5 12 131 7.2 20.2 1817 277
12 180x75x20 20.3 180 75 6 10.5 12 135 7.14 22.5 1370 146
13 150x90x24 23.9 150 90 6.5 12 12 102 7.5 15.7 1162 253
14 150x75x18 17.9 150 75 5.5 10 12 106 7.5 19.3 861 131
15 125x65x15 14.8 125 65 5.5 9.5 12 82 6.84 14.9 483 80
16 100x50x10 10.2 100 50 5 8.5 9 65 5.88 13 208 32.3
 14 15 16 17 18 19 20 21 22 23 24 25 26

Radius of Elastic Elastic Plastic Plastic Buckling Torsion Warping Torsion Area of
Gyration Modulus NA Modulus NA Parameter Index Constant Constant Section
Axis Axis Axis Axis Axis Axis
x-x y-y x-x y-y cy x-x y-y ceq u x H J A
cm cm cm3 cm3 cm cm3 cm3 cm dm6 cm4 cm2
16.3 2.97 1020 97.9 2.62 1222 176 0.954 0.917 22.5 0.219 63 82.1
14.8 3.06 791 89.2 2.79 933 161 0.904 0.932 21.2 0.15 45.7 68.7
11.9 3.13 549 81.7 3.05 641 148 1.31 0.944 17 0.081 36.8 58
11.7 2.77 481 63.1 2.6 568 114 0.879 0.934 18.4 0.058 28.8 52.7
10.3 2.82 364 56.3 2.74 425 102 1.14 0.942 17.2 0.038 20.6 44.4
10.1 2.3 278 34.4 2.1 328 62 0.676 0.932 20.5 0.02 11.7 35.1
9.27 2.86 306 55 2.92 355 98.9 1.69 0.95 15.1 0.028 19.3 41
9.17 2.35 239 34.8 2.3 278 63.2 1.03 0.947 17.3 0.015 11.8 32.7
8.16 2.88 252 53.4 3.12 291 94.5 2.24 0.954 12.9 0.02 18.3 37.9
8.11 2.39 196 33.8 2.48 227 60.6 1.53 0.956 14.8 0.011 11.1 29.9
7.4 2.89 202 47.4 3.17 232 83.5 2.36 0.949 12.8 0.014 13.3 33.2
7.27 2.38 152 28.8 2.41 176 51.8 1.34 0.946 15.3 0.008 7.34 25.9
6.18 2.89 155 44.4 3.3 179 76.9 2.66 0.936 10.8 0.009 11.8 30.4
6.15 2.4 115 26.6 2.58 132 47.2 1.81 0.946 13.1 0.005 6.1 22.8
5.07 2.06 77.3 18.8 2.25 89.9 33.2 1.55 0.942 11.1 0.002 4.72 18.8
4 1.58 41.5 9.89 1.73 48.9 17.5 1.18 0.942 10 0 2.53 13