Built Up Section Properties Calculator Spreadsheet

Custom Steel Section Information Calculator

The CivilWeb Built Up Section Properties Calculator Spreadsheet is a powerful suite of design spreadsheet designed for the analysis of custom or fabricated steel sections.

In most situations steel sections will be selected from a large range of standard section sizes. These sizes are simple and cheap to specify and are often available off the shelf, reducing ordering time. These standard sections come with all the design property information already calculated and presented in tables for the designer to use. In the vast majority of cases these sections are suitable and sufficient for the purpose.

In some cases however the designer requires a section which will not comply with any standard section. This is common where sections with unusual dimensions or design properties are required. Often this is done by fabricating two or more sections together such as attaching a thick steel plate onto the bottom of an I shaped beam for example.

When this happens it is impossible to determine the design properties from tables of data covering standard shaped steel sections. The design properties which are critical for the design of the section must be determined from first principles. The equations to do this can be time consuming to complete as this involves breaking the section up into many different parts. Each part must be analysed separately and then the combined properties of the whole section must be determined.

CivilWeb Built Up Section Properties Calculator Spreadsheet - Inputs

The CivilWeb Built Up Section Properties Calculator Spreadsheet includes four spreadsheet tools used for the calculation of critical design properties for different types of sections.

Composite Section Properties Spreadsheet

This spreadsheet calculates the section properties from a composite section made up of two or more standard sections including calculate moment of inertia of composite shapes. The spreadsheet allows the designer to input up to 8 different standard sized sections. The designer can then add a further 8 rectangular sections and 8 further circular sections to create any fabricated section created from different sections welded together. This spreadsheet calculates the following design parameters;

• Centroid Location
• Calculate Moment of Inertia of Composite Shape (2^nd Moment of Area) for Y, Z, YZ, U and V axis
• Elastic Section Modulus for Y top and bottom, and Z left and right
• Radius of Gyration for Y, Z, U and V axis
• Tan α angle of U and V axis

Thin Walled Section Properties

This spreadsheet is designed specifically to calculate the design section properties of thin walled section shapes such as sheet piles or Z sections including calculating moment of inertia for complex shapes. The designer can input up to 25 different nodes to describe the shape of the section and then can specify the thickness of each part of the section. This can be all one thickness or have different thicknesses. The spreadsheet then calculates the following section parameters;

• Section Area
• Location of the centroid
• Calculating Moment of Inertia for Complex Shapes (2^nd Moment of Area) for Y, Z, YZ, U and V axis
• Radius of Gyration for the Y, Z, U and V axis
• Elastic Section Modulus for Y top and bottom, Z left and right, U top and bottom and V left and right
• Location of the Shear Centre
• Torsional Constant of Inertia
• Warping Constant

Solid or Voided Section Properties

This spreadsheet includes three separate sheets for the quick and easy identification of the section properties of solid and voided section shapes including moment of inertia calculator of irregular shape sections. The first sheet allows the user to enter any solid section shape with up to 90 different nodes. The second sheet allows the designer to enter a hollow section with up to 60 different external nodes and a single internal void shape with up to 60 nodes. The third sheet allows the designer to enter a shape with up to 30 external nodes, an irregular internal void with up to 30 nodes and up to 20 internal circular voids of any size. This is ideal for the analysis of slabs with bubbles or circular voids for example. These spreadsheets calculate;

• Total Section Area
• Centroid Location
• Moment of Inertia Calculator of Irregular Shape (2^nd Moment of Area) for Y, Z, YZ, U and V axis
• Elastic Section Modulus for Y top and bottom and Z left and right
• Radius of Gyration for Y, Z, YZ, U and V axis
• Tan α angle of U and V axis.

Standard Shape Section Properties

This spreadsheet consists of 29 different sheets for calculation of the section properties of standard shaped sections of any dimensions. For example this can be I sections with asymmetrical flanges or rectangular hollow sections with different thickness flanges and webs. The spreadsheet calculates all the design information required for the following shapes;

1. I Shape (Standard)
2. I Shape (Asymmetrical Flanges)
3. Tee Shape
4. Circular Hollow Sections (CHS)
5. Elliptical Hollow Sections (EHS)
6. Rectangular Hollow Sections (RHS)
7. Square Hollow Sections (SHS)
8. C Shape or Channel Sections with Parallel Flanges
9. C Shape or Channel Sections with Tapered Flanges
10. L Shaped or Angle Sections Either Equal or Unequal
11. Z Shaped Sections
12. Solid Circular Sections
13. Solid Semi-Circular Sections
14. Hollow Semi-Circular Sections
15. Solid Circle Sectors
16. Solid Circle Segments
17. Hollow Circular Sectors
18. Solid Elliptical Sections
19. Solid Semi-Elliptical Sections
20. Solid Quarter Elliptical Sections
21. Solid Octagonal Sections
22. Hollow Octagonal Sections
23. Solid Regular Polygon with Any Number Sides
24. Hollow Regular Polygon with Any Number of Sides
25. Solid Rectangular Sections
26. Inclined Solid Rectangular Sections
27. Solid Diamond Sections
28. Solid Square Sections
29. Inclined Solid Square Sections

CivilWeb Built Up Section Properties Calculator Spreadsheet

The CivilWeb Built Up Section Properties Calculator Spreadsheet is a vital piece of software for any steelwork designers working with non-standard, altered or fabricated steel sections. The spreadsheet calculates all the vital geometrical design parameters required for the design of any non-standard steel sections, saving the designer hours of complex detailed calculations. This spreadsheet provides all the information required for the designer to complete detailed analysis of fabricated or non-standard steelwork sections of any shape or size.

Buy the CivilWeb Built Up Section Properties Calculator Spreadsheet now for only £19.99.