SectProp28.

xls Ver 01/06/2004 Made by Checked Approved

Engineering Client Name of Client
Excel 2000 Free copy ABC DEF GHI

Date Date Date

Licensed to Company Name Project Name of Project
01.01.02 02.02.02 03.03.02
Street Address Description of the Design Job no. Revision Page no.
Spreadsheets.co.uk Address Descript.
Item
Town, Postcode 111 222 1

INPUT
SECTION PROPERTIES breadth (mm) depth (mm)
Spreadsheet for the derivation of the bt 500.0 tt 50.0
section properties of a plate girder tw 49.5 hw 900.0
symmetrical about the y-y axis. bb 500.0 tb 50.0
N.B. check code limitations, on how B 500.0 H 1000.0
thin all 3 plates can be, in order for them
to act as a section.
Cross Section
bt
tt
Y

ytop
X X
n.a. hw H

ybot,pl
ybot,el
tw tb
ybot

Y
bb

OUTPUT

b d a y ay h bd3/12 ah2 S
X-X (mm) (mm) (mm2) (mm) (mm3) (mm) (mm4) (mm4) (mm4)
top flange 500.0 50.0 25000 975.0 2.44E+07 475.00 5.21E+06 5.64E+09 5.65E+09
web 49.5 900.0 44550 500.0 2.23E+07 0.00 3.01E+09 0.00E+00 3.01E+09
bot flange 500.0 50.0 25000 25.0 6.25E+05 475.00 5.21E+06 5.64E+09 5.65E+09
S 1000.0 94550 4.73E+07 3.02E+09 1.13E+10 1.43E+10

b d a x ax w db3/12 aw2 S
Y-Y (mm) (mm) (mm2) (mm) (mm3) (mm) (mm4) (mm4) (mm4)
top flange 500.0 50.0 25000 250.0 6.25E+06 0.00 5.21E+08 0.00E+00 5.21E+08
web 49.5 900.0 44550 250.0 1.11E+07 0.00 9.10E+06 0.00E+00 9.10E+06
bot flange 500.0 50.0 25000 250.0 6.25E+06 0.00 5.21E+08 0.00E+00 5.21E+08
S 1000.0 94550 2.36E+07 1.05E+09 0.00E+00 1.05E+09

X-X
Elastic Plastic
ytop(mm) 500.0 Ztop(mm3) 2.86E+07 ytop(mm) 500.0 Z (mm3) 3.38E+07
ybot(mm) 500.0 Zbot(mm3) 2.86E+07 ybot(mm) 500.0
S 1000.0 S 1000.0

X-X Y-Y Torsion ( Blodgett, Rzz = S bn(bn.dn3) )

Ixx(mm4) 1.43E+10 Iyy(mm4) 1.05E+09 Rzz(mm4) 7.51E+07
rxx(mm) 388.9 ryy(mm) 105.4
ymax(mm) 500.0 bmax(mm) 250.0
Ze,x(mm3) 2.86E+07 Ze,y(mm3) 4.20E+06
Zp,x(mm3) 3.38E+07 Zp,y(mm3) 6.80E+06
Zp/Ze 1.18 Zp/Ze 1.62

www.EngineeringSpreadsheets.co.uk
 Engineering

Spreadsheets.co.uk

WARNING!

If this sheet remains visible then you have opened the workbook
without enabling macros.

In order to use the workbook properly macros must be enabled.

Please close the workbook and re-open it with macros enable.

EngineeringSpreadsheets.co.uk
 SectProp28.xls Ver 01/06/2004 Made by Checked Approved
Engineering Client Name of Client
Excel 2000 Free copy ABC DEF GHI

Date Date Date

Licensed to Company Name Project Name of Project
01.01.02 02.02.02 03.03.02

Street Address Description of the Design Job no. Revision Page no.
Spreadsheets.co.uk Address Descript.
Item
Town, Postcode 111 222 2

PLATE GIRDER
Assumptions and formulae

Torsion
1) Closed sections :-
a) closed sections use polar moments of inertia :-
J = Ix + Iy
b) torsional stress = t = (Torsion.ymax)/J, where for a pipe, ymax = do/2, which is the distance to the extreme fibre
c) For pipes J = p(do4-di4)/32
Therefore torsion modulus Zt = J/ymax = p(do4-di4)/32 x 2/do = p(do4-di4)/( 16do )

2) Open sections :-
a) open sections use torsional resistance R, this gives much more accurate predictions of torsional rotations,
than polar moment of inertia J, ( see Blodgett, Design Of Welded Structures, 1982, section 2-10, table 1 )
Rzz = S bn(bn.dn3)
b/d 1.00 1.50 1.75 2.00 2.50 3.00 4.00 6.00 8.00 10.00 infinity
b 0.141 0.196 0.214 0.229 0.249 0.263 0.281 0.299 0.307 0.313 0.333
N.B. we have assumed on this spreadsheet, that at b/d = 20, then b = 0.333.
b) torsional stress = t = (Torsion.tmax)/R, where tmax, is the thickness of the thickest plate
c) For an I section the Rzz value will be :- bt.tt3/3 + hw.tw3/3 + bb.tb3/3, if the slenderness of each plate >= 20
Therefore torsion modulus Zt = R/tmax

3) Rotational deflections :-
f ( rads ) = T.L/( Es.J ), where T = Torsion, L = length of shaft, Es = youngs modulus,
J = polar moment of inertia J for closed section, or torsional resistance R for an open section

www.EngineeringSpreadsheets.co.uk
 SectProp28.xls Ver 01/06/2004 Made by Checked Approved
Engineering Client Name of Client
Excel 2000 Free copy ABC DEF GHI

Date Date Date

Licensed to Company Name Project Name of Project
01.01.02 02.02.02 03.03.02

Street Address Description of the Design Job no. Revision Page no.
Spreadsheets.co.uk Address Descript.
Item
Town, Postcode 111 222 3

Terms and Conditions

1 The author is :-
EngineeringSpreadsheets.co.uk

2 Registration :-
The spreadsheets from this website will either be 1) free, or for 2) purchase.
1) A free spreadsheet, will be classified as a free copy, and can be downloaded directly from the website.
2) A purchase spreadsheet, will be available as a :-
2a) partially working free demo copy, classified as a demo copy, and can be downloaded directly
from the website.
and a
2b) fully working purchase copy, classified as a purchase copy, and can be downloaded by following
the instructions on the website.

Only a purchase copy will be registered, and therefore licenced.

3 Licence and Restrictions :-

After purchase you will be deemed to have a non-transferable licence.
You may not :-
a) copy the Software or Documentation except as permitted in this agreement.
b) reverse engineer, decompile or dissassemble the Software.
c) distribute, rent, loan, sell, sublicence or otherwise transfer all or part of the Software or Documentation,
or create derivative works based on the Software or Documentation, for any purpose.
d) utilise any equipment device or software designed to circumvent or remove any form of copy protection
of the Software.

4 Disclaimer :-
The results from this software should be validated by the user. The author will not accept any responsibility for
the integrity of its design function. Although every effort has been made by the author to thoroughly test the
functioning of this software, by following a methodical testing program, the user must take full responsibility
for testing and verifying the reliability of the software output.

5 Limitation of Liability :-
In no event shall the author be liable for any loss or damage of any kind, incidental, consequential, or indirect
damages arising out of the use or inability to use this software or documentation, however caused.
In addition the author shall have no responsibility or liability arising from the loss or theft of the software.

6 Copyright :-
Ownership and copyrights in the Software and Documentation and any copies made by you remain with the
author. Unauthorised copying of the Software or Documentation or failure to comply with any of the terms of
this agreement will result in automatic termination of this agreement. Any use of any copies of the Software
or Documentation after termination of this agreement is unlawful, which may result in a claim for damages,
and being subject to criminal penalties.

www.EngineeringSpreadsheets.co.uk