- Page 154 of 205 - Share to Learn

Elastic Analysis of Reinforced and Prestressed Sections Spreadsheet

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

Download Link

Single span beam analysis spreadsheet

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.

Download Link

Aluminium design capacity spreadsheet

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

Download Link

AIC318-08 RC Beam spreadsheet

Analysis and design of RC beam as per ACI318-08.

Calculation Reference
Reinforced Concrete

Download Link

AASHTO LRFD Concrete Slab and Wall design spreadsheet

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

Download Link

Method of jetgrouting spreadsheet

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

Download Link

Robot Structural Analysis Professional Analysis and Design of 10 story RC Structures (Part 3)

Designing, Analysis & Documenting of 10 story RC Structures using RSA. During this step by step training you will learn:

Designing, Analysis & Documenting of Reinforced Concrete Structures.
Static Analysis of Reinforced Concrete Frames.Assignment of Load Cases & Combinations (Including Characteristic, Frequent & Quasi- permanent combinations).
Analysis of the Structural Model under the Euro code.
Designing of Reinforced Concrete Sections for Beams and Columns.Designing of Reinforced Concrete Slabs.Designing & Calculation of the Reinforcement Steel for Beams and Columns.
Introduction to the Basic Designing of Raft foundation .
Generating the Detail Drawings for the Reinforcement Steel of Beams, Columns & Slabs.
Analysis of the Diagrams of the Axial, Shear Forces & Deformations in the Structure including Compression and Tension forces produced across the Structure.
Analysis of the Maps for the Principal and von Mises Stresses.
Obtaining the Calculation Notes & Documents of the Project. Although this training focuses on the, analyzing our Structural Model under the Eurocode.

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

Download Link

Duration : 67 min

Size: 385 MO

Robot Structural Analysis Professional Analysis and Design of 10 story RC Structures (Part 2)

Designing, Analysis & Documenting of 10.story RC Structures using RSA. During this step by step training you will learn:

Designing, Analysis & Documenting of Reinforced Concrete Structures.
Static Analysis of Reinforced Concrete Frames.Assignment of Load Cases & Combinations (Including Characteristic, Frequent & Quasi- permanent combinations).
Analysis of the Structural Model under the Euro code.
Designing of Reinforced Concrete Sections for Beams and Columns.Designing of Reinforced Concrete Slabs.Designing & Calculation of the Reinforcement Steel for Beams and Columns.
Introduction to the Basic Designing of Raft foundation .
Generating the Detail Drawings for the Reinforcement Steel of Beams, Columns & Slabs.
Analysis of the Diagrams of the Axial, Shear Forces & Deformations in the Structure including Compression and Tension forces produced across the Structure.
Analysis of the Maps for the Principal and von Mises Stresses.
Obtaining the Calculation Notes & Documents of the Project. Although this training focuses on the, analyzing our Structural Model under the Eurocode.

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

Download Link

Duration : 63 min

Size: 338 MO

Robot Structural Analysis Professional Analysis and Design of 10 story RC Structures (Part 1)

Designing, Analysis & Documenting of 10.story RC Structures using RSA. During this step by step training you will learn:

Designing, Analysis & Documenting of Reinforced Concrete Structures.
Static Analysis of Reinforced Concrete Frames.Assignment of Load Cases & Combinations (Including Characteristic, Frequent & Quasi- permanent combinations).
Analysis of the Structural Model under the Euro code.
Designing of Reinforced Concrete Sections for Beams and Columns.Designing of Reinforced Concrete Slabs.Designing & Calculation of the Reinforcement Steel for Beams and Columns.
Introduction to the Basic Designing of Raft foundation .
Generating the Detail Drawings for the Reinforcement Steel of Beams, Columns & Slabs.
Analysis of the Diagrams of the Axial, Shear Forces & Deformations in the Structure including Compression and Tension forces produced across the Structure.
Analysis of the Maps for the Principal and von Mises Stresses.
Obtaining the Calculation Notes & Documents of the Project. Although this training focuses on the, analyzing our Structural Model under the Eurocode.

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

Download Link

Duration : 23 min

Size : 160 MO

INFRAWORKS 2020 new features

In this latest release of InfraWorks, you are now able to make changes to GIS data that was imported from ArcGIS Online and Enterprise. With proper permissions to ArcGIS, those changes made in InfraWorks can be saved back to the ArcGIS Feature Service. For example, you may have brought sanitary sewer manhole and pipe data from ArcGIS into InfraWorks. Within your InfraWorks model, you may wish to change the location of that manhole and pipe location to meet your design requirements. Once you make that change, you simply select the data source from ArcGIS Online and select to ‘save back’ to save those changes back to ArcGIS. Now in ArcGIS Online, we simply refresh the web browser and the new locations of the manhole and pipe are shown.

Enhanced control of design manipulations

Extended Schema Tool

In order to meet BIM requirements, an aggregated model with deep metadata is often required and the schema tool helps simplify the process of managing this data. The new release of InfraWorks allows users to add new properties and information to the elements of their project. Customize data for objects in a model through the extended schema transfer tool. The data can be expanded with multiple fields and each element can be documented as needed. The schema tool can be applied to buildings, parcels, roadways, utilities, and a host of other InfraWorks elements.

Cut and Fill Display

InfraWorks now allows the user to control the cut and fill display on roads. Selecting the material display in the grading option, allows the user to specify the color or material by the impact, cut or fill. Clearly view impacted areas and make design revisions as needed. This feature will greatly help to enhance roadway and concept layouts within InfraWorks.

Spreadsheet-based edits

It is now possible to make adjustments to bridge structures using a convenient spreadsheet technique. The structure parameters are saved to a spreadsheet where multiple edits can be made to multiple areas of the structure at one time. These changes are then saved back into the spreadsheet and the structure model can then be updated. This method of making multiple changes across is particularly efficient for customers working on large bridge projects where changes in many areas of the structure may be required.

Source : www.infrastructure-reimagined.com