Introduction  

The 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.

 
Acknowledgement  

It is 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.

 
   
Disclaimer  

No 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.

 
   
System Requirement  

Microsoft® Windows® 98 / Windows® 2000 / Windows® XP Pentium® II & higher / 64MB RAM / File size 6MB

 
   
Your Usage  

The 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.

 
   
Copyright  

You can 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 act.

 
   
Technical Support  

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.

  
 

References 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

IS 1367 (Part 3) : 2002

  Dimensions of Steel Tubes

Mechanical properties of steel fasteners

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.

Compression Members  

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.).

Tension Members  

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.

Crane Girder  

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  

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  

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 by Saarthi