Crane Girder design is an Excel Spreadsheet Template for the design of simply supported crane girders. The procedure is based on the Steelwork Design Guide to BS 5950-1:2000, Volume 2, Worked Examples, SCI Publication P326, The Steel Construction Institute, 2003.
Calculation Reference
BS5950 Crane Design
Beam reaction analysis is a spreadsheet program written in MS-Excel for the purpose of determining the allowable beam end reaction and the allowable end moment for the purpose of end connection design.
This program is a workbook consisting of two (2) worksheets, described as follows:
Program Assumptions and Limitations:
1. This program uses the database of member dimensions and section properties from the “AISC Shapes Database”, Version 3.0 (2001) as well as the AISC 9th Edition (ASD) Manual (1989).
2. The user may select from W, S, M, C, and MC shapes.
3. This program utilizes the procedure which a steel fabricator would typically use to determine end connection design loads when end reaction values are not specified on the design and construction drawings by the engineer. This procedure is based on the AISC 9th Edition (ASD) Manual (1989) Allowable Uniform Load Tables on pages 2-36 to 2-140 and AISC Specification Chapter K, pages 5-80 and 5-81.
4. This program contains “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc. (Note: presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the desired cell to view the contents of that particular “comment box”.)
All the worksheets are independent and self contained, so that you can move them from one workbook to another. All the worksheets are protected, but not with a password.
The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis:
For a cross section with any applied axial load at eccentricity e, measured from the compression face, and depth of the neutral axis X below the compression face:
INA = QNA(X + e)
Where QNA and INA are the first and second moments of area about the neutral axis.
To illustrate this relationship the value of INA has been plotted for a range of neutral axis positions for a typical precast bridge beam, shown below, and compared with the value QNA(X + e) for 5 different values of e.
The intersection of the INA and QNA(X + e) lines gives the depth of the neutral axis for the corresponding value of load eccentricity, e. This is illustrated in the second graph, where the value of (INA – QNA(X + e)) is plotted against the depth of the neutral axis, X, for a load eccentricity of 1 metre above the compression face.
The intersection of this line with the X axis gives the depth of the neutral axis for the specified load eccentricity.
Note: Another calculation file ULS Design Functions.zip contains User Defined Functions (UDF’s) that will find the ultimate bending capacity of any reinforced or prestressed concrete section
Single span beam analysis spreadsheet is a MS-Excel spreadsheet workbook for the analysis of single-span beams (simple, propped, fixed, or cantilever) and continuous beams of up to 5 spans.
The user may apply point, uniform, and varying loads, as well as applied moments. Shear, moment, slope (rotation), and deflection are computed as well as the end reactions. Shear and moment diagrams are also plotted.
There is an addtional worksheet for single-span beams that also performs AISC 9th Edition Code checks for strong-axis bending (only) as well as shear.
All the worksheets are independent and self contained, so that you can move them from one workbook to another. All the worksheets are protected, but not with a password.
Aluminium design capacity spreadsheet will help you design structural and architectural pipe on your building construction whether it is residential, commercial & plant projects. It optimizes the pipe design so that designer can attain the effective, efficient, safe and economical sizes of aluminum pipe.
Calculation Reference
Strength of Aluminium
Analysis and design of RC beam as per ACI318-08.
Calculation Reference
Reinforced Concrete
AASHTO 2004 LRFD SLAB DESIGN: This spreadsheet was created to aid in the rapid design and/or checking of Bridge Decks or Reinforced Concrete Boxes in accordance with AASHTO 2004 LRFD. The 2nd Bar layer is particularly handy for different bar sizes used in the same layer, such as in Bridge Deck Cantilevers.
Calculation Reference
AASHTO LRFD
Drilling is typically performed using rotary drilling techniques and an external water flush with special drill rods and bits. Upon completion of the advancement of the drill rods to the design depth, the jet grouting process commences. The grout is injected through radial nozzles at high pressure and velocity, destroying the soil matrix and forming structural elements.
Many structures and geometries can be achieved by altering the parameters of the jetting procedure. The illustrated procedure details the creation of a jet grout column by continuous rotation of the drill string and controlled pre-set lifting increments.
Calculation Reference
Jet Grouting
Read More : What is Jet Grouting? Common Uses and Advantages
Designing, Analysis & Documenting of 10 story RC Structures using RSA. During this step by step training you will learn:
EN 1990 Eurocode : Basis of Structural Design EN 1991
Eurocode 1: Actions on structures EN 1992
Eurocode 2: Design of concrete structures EN 1993
Eurocode 3: Design of steel structures EN 1997
Eurocode 7: Geotechnical design
Duration : 67 min
Size: 385 MO
Designing, Analysis & Documenting of 10.story RC Structures using RSA. During this step by step training you will learn:
EN 1990 Eurocode : Basis of Structural Design EN 1991
Eurocode 1: Actions on structures EN 1992
Eurocode 2: Design of concrete structures EN 1993
Eurocode 3: Design of steel structures EN 1997
Eurocode 7: Geotechnical design
Duration : 63 min
Size: 338 MO
