Earthwork Calculation Excel Sheet

Earthwork Calculation Excel Sheet

Earthworks can be described as “the disturbance of land surfaces by blading, contouring, ripping, moving, removing, placing or replacing soil or earth, or by the excavation, or by cutting or filling operations”. Soil Disturbance – The disturbance of land surfaces by any means including blading, blasting, contouring, cutting of batters, excavation, ripping, root raking, excludes normal maintenance of legally established structures, roads, tracks, and railway lines. The definition also excludes those activities that are identified as vegetation clearance activities.

LINK

Design of Welded Steel Structures, Seventh Edition

STEEL DESIGNERS’ MANUAL, SEVENTH EDITION

Buick Davison

Preference :

For more than twenty years, the design of steel-framed buildings in the UK, including those where composite (steel and concrete) construction is used, has generally been in accordance with the British Standard BS 5950. This first appeared in 1985 to replace BS 449 and introduced designers to the concept of limit state design. However, BS 5950 was withdrawn in March 2010 and replaced by the various parts of the Structural Eurocodes. Bridge design in the UK has generally been in accordance with BS 5400, which was also introduced in the early 1980s and was also replaced in 2010. The Structural Eurocodes are a set of structural design standards, developed by the European Committee for Standardisation (CEN) over the last 30 years, to cover the design of all types of structures in steel, concrete, timber, masonry and aluminium. In the UK, they are published by BSI under the designations BS EN 1990 to BS EN 1999.

 Each of the ten Eurocodes is published in several parts, and each part is accompanied by a National Annex that adds certain UK-specific provisions to go alongside the CEN document when it is implemented in the UK. In England, implementation of these Standards for building design is achieved through Approved Document A to the Building Regulations. In Scotland and Northern Ireland, corresponding changes will be made to their regulations. It is expected that adoption of the Eurocodes by building designers will increase steadily from 2010 onwards. As a public body, the Highways Agency is committed to specifying the Eurocodes for the design of all highway bridges as soon as it is practicable to do so. British Standard information reflected in the numerous BDs and BAS will be effectively replaced, and a comprehensive range of complementary guidance documents will be produced.

Content :

• 1 Introduction – designing to the Eurocodes 
• 2 Integrated design for successful steel construction 
• 3 Loading to the Eurocodes 
• 4 Single-story buildings 
• 5 Multi-story buildings 
• 6 Industrial steelwork 
• 7 Special steel structures 
• 8 Light steel structures and modular construction 
• 9 Secondary steelwork 
• 10 Applied metallurgy of steel 
• 11 Foundations and holding-down systems 
• 12 Design for movement in structures 

Download Design of Welded Steel Structures, Seventh Edition free PDF

LINK

Bridge Engineering. Classifications, Design Loading, and Analysis Methods

Bridge Engineering. Classifications, Design Loading, and Analysis Methods

WEIWEI LIN, TERUHIKO YODA

Preference :

A bridge is a construction made for carrying the road traffic or other moving loads in order to pass through an obstacle or other constructions. The required passage may be for pedestrians, a road, a railway, a canal, a pipeline, etc. Obstacle can be rivers, valleys, sea channels, and other constructions, such as bridges themselves, buildings, railways, or roads. The covered bridge at Cambridge in Fig. 1.1 and a flyover bridge at Osaka in Fig. 1.2 are also typical bridges according to above definition. Bridges are important structures in modern highway and railway transportation systems, and generally serving as “lifelines” in the social infrastructure systems. Bridge engineering is a field of engineering (particularly a significant branch of structural engineering) dealing with the surveying, plan, design, analysis, construction, management, and maintenance of bridges that support or resist loads. This variety of disciplines requires knowledge of the science and engineering of natural and man-made materials, composites, metallurgy, structural mechanics, statics, dynamics, statistics, probability theory, hydraulics, and soil science, among other topics.

The bridge structures are important components in highway, railway, and urban roads and play important roles in the economy, politics, culture, as well as national defense. Especially for medium span and larger span bridges, they are generally served as “lifeline” engineering due to their vital functions in the transportation network. Therefore, the bridge structures should be carefully planned and designed before the construction. The bridge design process, bridge design philosophy will be discussed in this chapter. A brief diagram showing the bridge planning and design process is shown in Fig. 2.1. In bridge design survey, planning, and design, the structural safety, serviceability, economic efficiency constructability, feasibility in structural maintenance, environmental impact, etc., should be considered to propose an appropriate bridge location and suitable structural type.

Content :

• 1: Introduction of Bridge Engineering.
• 2: Bridge Planning and Design.
• 3: Materials for Bridge Constructions.
• 4: Loads and Load Distribution.
• 5: Bridge Deck Systems.
• 6: Reinforced and Prestressed Concrete Bridges.
• 7: Steel Bridges.
• 8: Truss Bridges.
• 9: Arch Bridges.
• 10: Cable-Stayed Bridges.
• 11: Suspension Bridges.
• 12: Bridge Bearings and Substructures.
• 13: Inspection, Monitoring, and Assessment.
• 14: Repair, Strengthening, and Replacement.

Download Bridge Engineering. Classifications, Design Loading, and Analysis Methods free PDF

LINK

RCC Stair Design Spreadsheet

RCC Stair Design Spreadsheet

In construction, the most important and appropriate part is reinforced concrete in comparison with all other components that exist in this sector. In this section, we are going to provide a newly designed excel sheet that is very much required to perform a design of the reinforced concrete staircase. This spreadsheet provides RCC Stair Design
with very simple steps

LINK

Fundamentals of Structural Analysis, Fifth Edition

Fundamentals of Structural Analysis, Fifth Edition 

Kenneth M. Leet, Chia-Ming

Preference :

This text introduces engineering and architectural students to the basic techniques required for analyzing the majority of structures and the elements of which most structures are composed, including beams, frames, trusses, arches, and cables. Although the authors assume that readers have completed basic courses in statics and strength of materials, we briefly review the basic techniques from these courses the first time we mention them. To clarify the discussion, we use many carefully chosen examples to illustrate the various analytic techniques introduced, and whenever possible, we select examples confronting engineers in real-life professional practice.

As an engineer or architect involved with the design of buildings, bridges, and other structures, you will be required to make many technical decisions about structural systems. These decisions include (1) selecting an efficient, economical, and attractive structural form; (2) evaluating its safety, that is, its strength and stiffness; and (3) planning its erection under temporary construction loads. To design a structure, you will learn to carry out a structural analysis that establishes the internal forces and deflections at all points produced by the design loads. Designers determine the internal forces in key members in order to size both members and the connections between members. And designers evaluate deflections to ensure a serviceable structure—one that does not deflect or vibrate excessively under load so that its function is impaired.

Content :

• Introduction
• Design Loads and Structural Framing
• Statics of Structures Reactions
• Trusses
• Beams and Frames
• Cables and Arches
• Deflections of Beams and Frames
• Work-Energy Methods for Computing Deflections
• Analysis of Indeterminate Structures by the Flexibility Method
• Analysis of Indeterminate Beams and Frames by the Slope-Deflection Method
• Analysis of Indeterminate Beams and Frames by the Moment Distribution
• Influence Lines for Moving Loads
• Approximate Analysis of Indeterminate Structures
• Introduction to the General Stiffness Method
• Matrix Analysis of Trusses by the Direct Stiffness Method

Download Fundamentals of Structural Analysis, Fifth Edition free PDF

LINK

Design of Simply Supported Beam with Torsional Loading

Design of Simply Supported Beam with Torsional Loading

This spreadsheet performs a design analysis on a simply supported beam with torsional loading for a W10X54 steel beam (as defined by the AISC Steel Shapes Database). The application follows the design code and equations in AISC

LINK

Steel Beam Design Excel Sheet with Gravity Loading

Steel Beam Design Excel Sheet with Gravity Loading

The Steel Beam module does not permit biaxial loading at the present time, so there are two potential approaches to this loading scheme:
One option is to do two separate Steel Beam runs.  One run would apply the gravity loads to the beam with the beam oriented “web vertical”.  The other run would apply the wind loads to the beam with the beam oriented “web horizontal”.  This would require that the user manually combine the results of the two runs using engineering judgment to come up with a final result.

LINK