Welds in shear, bending, torsion and axial loading spreadsheet

Welds in shear, bending, torsion and axial loading spreadsheet

 

WeldCalc is an Excel Template for the design of weld groups having any configuration of multi-linear weld lengths in an x-y plane.  It uses the elastic method to analyse weld groups subjected to simultaneous tension, compression, shear, bending and or torsion in x, y and z directions.   If present, it takes into account the influence of unsymmetrical bending in its analysis.

WeldCalc analyses any configuration of multi-linear weld lengths in an X-Y plane.  The loads can be shear, moment, torsion and axial applied simultaneously.

WeldCalc calculates the induced stress at each node and identifies the node most highly stressed.  It also calculates the magnitude of load resisted by each length of weld in the x, y and z direction.

A weld group can have up to 30 Nodes or 29 weld lengths.  The line of weld lengths can be continuous or discontinuous.  Each continuous series of weld lengths is termed as a Part and it is given a reference number starting from 1 onwards.  A weld group can have up to 15 parts connecting 30 nodes in any pattern.

WeldCalc is supplied as an Excel Template, having .XLT as its filename extension.

You can use WeldCalc by opening its file directly or copying it into the Microsoft Office folder for its Templates.  Consult Microsoft Office documentation for the path to this folder.

Download Link

What is green concrete ? It’s advantages in construction

What is green concrete ? It’s advantages in construction

 

What is green concrete?

Green concrete can be defined as the concrete with material as a partial or complete replacement for cement or fine or coarse aggregates. The substitution material can be of waste or residual product in the manufacturing process. The substituted materials could be a waste material that remain unused, that may be harmful (material that contains radioactive elements).

Green concrete should follow reduce, reuse and recycle technique or any two process in the concrete technology.

Green concrete advantages:

The three major objective behind green concept in concrete :

–  To reduce green house gas emission (carbon dioxide emission from cement industry, as one ton of cement manufacturing process emits one ton of carbon dioxide)

– To reduce the use of natural resources such as limestone, shale, clay, natural river sand, natural rocks that are being consume for the development of human mankind that are not given back to the earth,

– The use of waste materials in concrete that also prevents the large area of land that is used for the storage of waste materials that results in the air, land and water pollution. This objective behind green concrete will result in the sustainable development without destruction natural resources.

Some applications of Green Concrete:

 

Fig: Green concrete dam

Fig: Green Concrete Bridge – Musmeci Bridge

Fig: Green Concrete building

Fig: Green Concrete Road

Fig: Green Concrete Floor

 

AASHTO Steel Tunnel Liner Plate spreadsheet

AASHTO Steel Tunnel Liner Plate spreadsheet

Smooth-back tunnel liner plate in soft ground

 

Purpose:

To design an initial liner for a tunnel using steel liner plate.

Hoop thrust capacity of the liner is checked for a specified overburden pressure, hydrostatic pressure, and live load pressure, which consists of either AASHTO H-20 Truck Loading or Cooper E-80 Train Loading (Per AREMA).

Download Link

Assumptions/Limitations:

  • Surrounding ground consists of granular or cohesive soil (Not rock)
  • Tunnel support is 2-flange or 4-flange, smooth-back liner plate.
  • Liner plate joints (flanges) are non-compact (not slender)

Boring Logs spreadsheet

Boring Logs spreadsheet

 

Boring Logs spreadsheet is a sample spreadsheet for boring log which is very helpful for Geotechnical Engineers. Borehole logs are used to display the results of oil and gas, mining, geotechnical and environmental drilling and sampling. Logs can be used to display soil and rock samples.

Calculation Reference
Geotechnics

 

Download Link

Immediate Pad Footing Settlement spreadsheet

Immediate Pad Footing Settlement spreadsheet

Download Link

Immediate Pad Footing Settlement spreadsheet calculates the immediate settlement of a pad footing given size and soil modulus. Based on equations in “Bowles : Foundation Analysis and Design Fifth addition international,Foundation Settlements pg303 Immediate Settlement Computations”

Calculation Reference
Bowles : Foundation Analysis and Design

 

 

Bridge Design Assessment Spreadsheet

Bridge Design Assessment Spreadsheet

 

Bridge Design Assessment spreadsheet will guide you through to calculate various MEXE Analysis and bridge related calculations.

This spreadsheet has been specially organized in accordance with calculate the capacity of a masonry arch using the modified MEXE process.

INSTRUCTIONS FOR USE:

  • Put data in the yellow cells only. Factors may also be selected from the factor description.
  • Symbols and factors are as described in the DMRB Standard BA16/97 Chapter 3.

Download Link

Roads maintenance, repair and rehabilitation

Roads maintenance, repair and rehabilitation

 

Roads are exposed to tremendous loads that will sooner or later leave their marks on them. A time will come when every road will be in need of a general overhaul. But no two damage patterns are alike.

Which rehabilitation methods offer a cure for distressed roads? What are the differences between them? Which are suitable to be carried out as mobile roadworks?

 

Replacing the pavement is a standard procedure when repairing roads. The challenge is to ensure that only the damaged layers of the road structure are removed – and to avoid disruptions to traffic at the same time. Under these conditions, cold milling is the only viable option for many construction projects

The tools that cold milling machines use for removing road layers were originally developed for the mining industry. So-called point-attack cutting tools, fitted to a rotating milling drum on the underside of the machine, bite into the road at precisely the specified depth.

Fine milling

Fine milling is an alternative to time-consuming and expensive complete rehabilitation. This method is used above all when traffic safety is severely compromized by undulations, ruts or a slippery surface.

Many countries are investing less money in maintaining their road network despite increasing traffic loads. The result is a growing demand for fast and economically efficient solutions that are capable of taking the edge off hazardous stretches of road.

Fine milling is such a method, and is predominantly used where bumps and wheel ruts, or slippery surfaces pose an acute danger to traffic safety.

When cold recycling road pavements, contractors can choose between processing the milled material “in-situ”, meaning on the job site, or “in-plant”, meaning in a cold mixing plant. Their decision is influenced, however, not only by the damage patterns of the road to be repaired. What are the advantages offered by “in-plant” cold recycling? How does it work? What kinds of damage patterns can cold recycling “in-plant” be used for?

One speaks of cold recycling “in-plant” when the reclaimed asphalt material of roads in need of rehabilitation is recycled in a nearby mixing plant, transported back to the job site, and then placed again by road pavers. The method is often used with roads that are exposed to high loads by heavy traffic, and with damages extending all the way into the pavement subgrade, but where site conditions do not allow the operation of an “in-situ” cold recycling train.

 

Source : www.wirtgen-group.com

Analysis for the Assessment of Iconic Steel Structure- Connel Bridge (MIDAS Expert Engineer Webinar)

Analysis for the Assessment of Iconic Steel Structure- Connel Bridge (MIDAS Expert Engineer Webinar)

 

Analysis for the Assessment of Iconic Steel Structure- Connel Bridge, Scotland by Javier Lancho from Jacobs Glasgow Connel Bridge is an iconic riveted steel structure built in 1903 for rail traffic which currently carries the A828 over Loch Etive after a composite steel and concrete deck was installed in two phases, in 1957 and 1967. It comprises a complex geometry, non-standard cross sections and complex connections of the deck to the truss structure. Jacobs UK was commissioned in 2015 to carry out an assessment of the bridge live load capacity. This webinar will present the key Midas Civil features that were used for the project. This webinar will be informative for those engineers who have any interest in the use of day-to-day Midas Civil functionalities in order to address analysis models for bridges.

Details

Title MIDAS Expert Engineer Webinar – Analysis for the Assessment of Iconic Steel Structure- Connel Bridge
Duration 71 Mins
Language English
Format MP4
Size  165 MB

 

Download Link

Beams on Elastic Foundation spreadsheet

Beams on Elastic Foundation spreadsheet

 

Beams on Elastic Foundation is a spreadsheet program written in MS-Excel for the purpose of analysis a finite length beam with free ends supported continuously on an elastic foundation.
This program is ideally suited for analyzing a soil supported beam, a combined footing, or a strip of a slab or a mat.
Specifically, the beam shear, moment, deflection, and soil bearing pressure are calculated for 100 equal beam segments, as well as the maximum values. Plots of both the shear, moment, and soil bearing pressure diagrams are produced, as well as a tabulation of the shear, moment, deflection, and bearing pressure for the beam. This program is a workbook consisting of three (3) worksheets, described as follows:
  1. Doc – documentation sheet
  2. Beam on Elastic Fdn. (English) – Beam on elastic foundation analysis (English units)
  3. Beam on Elastic Fdn. (metric) – Beam on elastic foundation analysis (metric units)

Download Link

Analysis for Flat roof systems in structural steel spreadsheet

Analysis for Flat roof systems in structural steel spreadsheet

 

“PONDING9” is a spreadsheet program written in MS-Excel for the purpose of analysis for ponding for low slope or flat roof systems in structural steel per the AISC 9th Edition (ASD) Code, pages 5-83 to 5-84 and 5-175 to 5-179.

Specifically, simplified checks are performed for the steel members as well as the steel deck. A rigorous analysis, whether actually required or not, is also performed for the steel members.

This program is a workbook consisting of two (2) worksheets, described as follows:

  • Doc – Documentation sheet
  • Ponding – Ponding analysis per AISC 9th Edition (ASD) Manual

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.

Program Assumptions and Limitations:

1.  This program utilizes the equations in AISC Code Sect. K2 to perform a simplified check on the primary and secondary members, as well as the steel roof deck.

2.  This program also performs a rigorous analysis on the primary and secondary members utilizing the equations in AISC Code Commentary Sect. C-K2.

3.  This program contains numerous “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”.)

Calculation Reference
AISC

 

Download Link

error: Content is protected !!
Exit mobile version