Spreadsheets are intended to be used by
qualified Civil and Structural Engineers
who are familiar with the usage of
Excel program, the provisions of IS 800
: 2007, and those who will evaluate the
significance and limitations of its
contents and take responsibility for its
use and application.
gratefully acknowledged with thanks
information from various sources,
particularly from codes of the Bureau of
Indian Standards. Special thanks
are to M/S Techno Consultants, Cheshire,
UK, for their permission to use the
details of sectional properties of
Indian steel sections which they have
developed, and incorporated in the spreadsheets.
liability is accepted by the author of
the Spreadsheets for any direct,
indirect, consequential or incidental
loss or damage arising out of the usage
of Spreadsheets or any mistakes and
negligence in developing the
Spreadsheets. The organization or person
using the Spreadsheets bears all risks
and responsibility for the quality and
performance of the Spreadsheets.
Windows® 98 / Windows® 2000 / Windows®
XP Pentium® II & higher / 64MB RAM /
File size 6MB
Spreadsheets are intended to help you
save time and effort in calculations.
Although every effort has been made by
the author to thoroughly test the
functioning of the Spreadsheets, the
user must take full responsibility for
testing and verifying the reliability
of the spreadsheet output.
use the Spreadsheets for your personal
or business design use. Ownership and
copyrights of the Spreadsheets remain
with the author. Trust, fellow
Structural Engineers will not do copying
The author provides technical support by way of answering technical queries by E-mail, and updating the files, if needed as per the current I.S. Codes.
IS 800 : 2007
General Construction in Steel - Code of Practice
IS 808 : 1989
Dimensions for hot-rolled steel beam, column,channel and angle sections
IS 4923 : 1997
Dimensions for Square and Rectangular Hollow Sections
IS 1161 : 1998
Dimensions of Steel Tubes
IS 2062 : 2006
Hot-rolled low, medium and high tensile structural steel
IS 816 : 1969
Code of practice for use of metal arc welding in mild steel
All inputs are in white color cells of 'Main' worksheet. All inputs which are there at present, are only input examples which can be replaced by a new set of inputs. Worksheet tabs are at the bottom of the screen
Steel grades considered are E165, E250, E300, E350, E400 and E450 conforming to IS 2062.
All steel members and connections are designed by Limit-State method as per IS 800 : 2007.
Notes and comments are given to help input preparation. All outputs are shown in colored cells in a tabular form, which are protected and read only. All outputs can be printed on A4 size sheet.
Several structural elements can be designed at one time in most spreadsheets.
Beams & Compound Beams
Calculates safe moment and shear for a selected section and support conditions, checks unstiffened webs for local crushing & buckling, and designs welded web stiffeners if reqd. Sections considered are: I, Channel & RHS (255 nos.) for effect. Beams, and I sections + plates at top and bottom (79 nos.) for Compound Beams.
It checks a selected section for its safety for a given applied loads and effective length. Sections considered are: I, Channel, T, Pipes, SHS, RHS, Single Angle Charts and Double Angle Sections (Total 732 nos.).
It checks a selected section for its safety for a given applied load and type of end connection. Sections considered are: Plates, Rods, Single Angle and Double Angle Sections (Total 400 nos.).
Members subjected to Axial Force & Bending Moment
It checks a selected section for its safety for a given applied factored loads panel (compression/tension), bending moments and effective length of members. Sections considered are: I, Channel, T, Pipes, SHS, RHS (311 nos.), and T and Double Angle Sections for Uniaxial bending (87 nos.).
Purlin and Sheeting Rail, with and without sag rods
It checks a selected section for its safety for a given span, span type and applied loads. Sections considered are: I, Channel, Pipes, SHS, RHS (308 nos.) for case without sag rods, and Channels only (60 nos.) for case with sag rods.
Welded Plate Girder
Calculates safe moment and shear for a selected section and support conditions, checks unstiffened webs for local crushing & buckling, and designs welded bearing and load carrying web stiffeners, if reqd.
Designs a Crane Girder for given crane loads, a selected section for safe moment, shear, deflection, web strength and stiffeners, if reqd. Sections considered for design are: a) I (79 nos.) + Channel Section (60 nos.) b) Welded Plate Girder.
Analysis of Pin-jointed Truss
Calculates member forces, joint displacements and support reactions of a Truss up to 50 nodes/75 members/5 supports, for given Truss Profile, sectional properties and loads.
Analysis of Continuous Beam
Calculates bending moments, shears and support reactions for a continuous beam, up to 9 spans, for given spans, sectional properties and loads up to 10 nos. of 6 different types on each span.
Analysis of Single Beams
Calculates bending moment, support reactions and deflection for Single Span Beams of types: Simply Supported, Fixed, Propped Cantilever and Cantilever, for given spans, loads and sectional properties. 10 nos. beam can be designed at a time for 8 nos. of 3 different types on each span.
Effective Length of Column
Calculates effective length of column for given load on column, properties of columns and beams in a frame for cases of with and without restraint against sway. Column and beam sections can be I, Channel, SHS, RHS and Tube (Total 311 nos.). Charts are given for each case.
Bolted connections are for cases of a) Shear, b)Shear + Moment in plane and c) Shear Moment out-of plane, using hexagonal head bearing type bolts conforming to IS 1367 in standard clearance holes. 10 nos. joint can be designed at a time for each case.
Welded connections are for cases of a) Shear, b)Shear + Moment in plane and c) Shear Moment out-of plane, using fillet welds. 10 nos. joint can be designed at a time for each case.
Sectional Property of any shape
Calculates sectional properties of symmetrical / unsymmetrical section of any shape , about X-X and Y-Y axes for given dimensions to X and Y corordinates for every change of point.
Copyright @ 2007 website. All
Rights reserved. Powered bySaarthi