Excel Sheet to Design all Types of Footings

Excel Sheet to Design all Types of Footings


Reinforced concrete foundations, or footings, transmit loads from a structure to the supporting soil.
Footings are designed based on the nature of the loading, the properties of the footing and the
properties of the soil.
Design of a footing typically consists of the following steps:
1. Determine the requirements for the footing, including the loading and the nature of the supported
structure.
2. Select options for the footing and determine the necessary soils parameters. This step is often
completed by consulting with a Geotechnical Engineer.
3. The geometry of the foundation is selected so that any minimum requirements based on soils
parameters are met.
 
  




Download Excel Sheet to Design all Types of Footings Free  

Link

Introduction to Tunnel Construction

Introduction to Tunnel Construction

Chapman, David N.

Preference :

Computers have a prominent, often controlling role throughout the life cycle of engineering products and manufacturing processes. Their role is vital as global competitive pressures call for improvements in product performance and quality coupled with significant reductions in product design, development, and manufacturing timetables. Design engineers vastly improve their work productivity using computers. For example, performance of a product or process can be evaluated prior to fabricating a prototype using appropriate simulation software. Computer-aided design (CAD) uses the mathematical and graphic processing power of the computer to assist the engineer in the creation, modification, analysis, and display of designs.

Download Introduction to Tunnel Construction free PDF


Content :
  • Introduction. 
  • Site Investigation. 
  • Preliminary Analysis. 
  • Ground Improvement Techniques and Lining Systems. 
  • Tunnel Construction
  • Techniques. 
  • Health and Safety and Risk Management in Tunneling. 
  • Ground Movements and Monitoring. 
  • Case Studies.


Download Introduction to Tunnel Construction free PDF

LINK

Design of Rectangular Tank Excel Sheet

Design of Rectangular Water Tank Excel Sheet


Storage tanks are built for storing water, liquid petroleum, petroleum products and
similar liquids. Analysis and design of such tanks are independent of chemical nature
of product. They are designed as crack free structures to eliminate any leakage.
Adequate cover to reinforcement is necessary to prevent corrosion. In order to avoid
leakage and to provide higher strength concrete of grade M20 and above is
recommended for liquid retaining structures.
 
  




Download Design of Rectangular Water Tank Excel Sheet Free  

Link

Mechanical Engineers' Handbook: Design, Instrumentation, and Controls

Mechanical Engineers' Handbook: Design, Instrumentation, and Controls

Myer Kutz

Preference :

Computers have a prominent, often controlling role throughout the life cycle of engineering products and manufacturing processes. Their role is vital as global competitive pressures call for improvements in product performance and quality coupled with significant reductions in product design, development, and manufacturing timetables. Design engineers vastly improve their work productivity using computers. For example, performance of a product or process can be evaluated prior to fabricating a prototype using appropriate simulation software. Computer-aided design (CAD) uses the mathematical and graphic processing power of the computer to assist the engineer in the creation, modification, analysis, and display of designs.

Download Mechanical Engineers' Handbook: Design, Instrumentation, and Controls free PDF








Content :
  • 1. Computer-Aided Design 
  • 2. Product Design for Manufacturing and Assembly
  • 3. Design-for-Environment Processes and Tools
  • 4. Design Optimization: An Overview
  • 5. Total Quality Management in Mechanical System Design
  • 6. Reliability in the Mechanical Design Process
  • 7. Product Design and Manufacturing Processes for Sustainability
  • 8. Life-Cycle Design
  • 9. Design for Maintainability
  • 10. Design for Remanufacturing Processes
  • 11. Design for Manufacture and Assembly with Plastics
  • 12. Design for Six Sigma: A Mandate for Competitiveness 
  • 13. Engineering Applications of Virtual Reality
  • 14. Physical Ergonomics
  • 15. Electric Circuits
  • 16. Measurements
  • 17. Signal Processing
  • 18. Data Acquisition and Display Systems
  • 19. Systems Engineering: Analysis, Design, and Information Processing for Analysis and Design
  • 20. Mathematical Models of Dynamic Physical Systems.


Download Mechanical Engineers' Handbook: Design, Instrumentation, and Controls free PDF

LINK

Design Of Spread Footing Excel Sheet

Design Of Spread Footing Excel Sheet


Spread footings are usually designed to use 3 ksi < f'c < 4 ksi, whereas modern structural
members frequently use concrete between the range of 4 ksi < f'c < 8 ksi. A higher concrete
strength helps reduction the member’s size. However, the footing’s design is govern by the
bearing capacity and settlement. That means that the strength of the soil might be limiting
factor, and a higher concrete strength would not be relevant.
 
  








Download Design Of Spread Footing Excel Sheet Free  

Link

Site Planning and Design, First Edition

Site Planning and Design, First Edition

Thomas Russ

Preference :

The character of site design is such that the profession requires a combination of applying one’s experience while always learning new methods and materials, and then educating peers, clients, and the public. Site design professionals more so than most other professionals are always faced with having their work reviewed and often modified by nonprofessionals. I recently sat in a meeting with representatives of a state department of education, all former teachers and not a planner or site professional among them. They were discussing the need to review plans prepared by professionals to be sure the plans were correct! Their primary concern was the environmental impact of school construction and seeing that the plan addressed this concern

Download Site Planning and Design, First Edition free PDF






Content :
  • 1 Sustainability and Site Design
  • 2 Site Analysis
  • 3 Site Grading
  • 4 Designing for People
  • 5 Street and Parking Lot Design
  • 6 Infrastructure
  • 7 Landscape Restoration
  • 8 Site Layout
  • 9 Vegetation in the Site Plan
  • 10 Project Management Issues
  • 11 Historic Landscapes and Preserving Land
  • 12 Landscape and Culture


Download Site Planning and Design, First Edition free PDF

LINK

Bolts Connection Design Spreadsheet

Bolts Connection Design Spreadsheet


A bolt is a metal pin with a head formed at one end and shank threaded at the other in order to
receive a nut. On the basis of load transfer in the connection bolts are classified as:
 (a) Bearing Type
 (b) Friction Grip Type
 There are two types of bearing type bolts, namely,
 (i) Unfinished or Black Bolts.
 (ii) Finished or Turned Bolts.
 The shanks of black bolts are unfinished, i.e., rough as obtained at the time of rolling, while
turned bolts are obtained by turning hexagonal shank to circular shape. The bolt hole diameter is
only 1.5 mm larger than that of the shank in case of turned bolt. These bolts are used in special jobs
like connecting machine parts subject to dynamic loadings. For black bolts, diameter of bolt hole is
larger and are used in most of the work
 
  






Download Bolts Connection Design Spreadsheet Free  

Link

Traffic Engineering, 4th Edition

Traffic Engineering, 4th Edition

Roger Roess,

Preference :

The transportation system is often referred to as the nation' s "lifeblood circulation system." Our complex system of roads and highways, railroads, airports and airlines, waterways, and urban transit systems provides for the movement of people and goods within and between our densest urban cities and the most remote outposts of the nation. Without the ability to travel and to transport goods, society must be stmctured around small self-sufficient communities, each of which produces food and material for all of its needs locally and disposes of its wastes in a similar manner. The benefits of economic specialization and mass production are possible only where transportation exists to move needed materials of production to centralized locations, and finished products to widely dispersed consumers.

Download Traffic Engineering, 4th Edition free PDF




Content :
  • 1 Introduction to Traffic Engineering
  • 2 Road User and Vehicle Characteristics
  • 3 Roadways and Their Geometric Characteristics
  • 4 Introduction to Traffic Control Devices


Download Traffic Engineering, 4th Edition free PDF

LINK

Engineering Graphics with AutoCAD 2020

Engineering Graphics with AutoCAD 2020

James D. Bethune

Preference :

In Engineering Graphics with AutoCAD 2020, award-winning CAD instructor and author James Bethune teaches technical drawing using AutoCAD 2020 as its drawing instrument.
Taking a step-by-step approach, this textbook encourages students to work at their own pace and uses sample problems and illustrations to guide them through the powerful features of this drawing program. More than 680 exercise problems provide instructors with a variety of assignment material and students with an opportunity to develop their creativity and problem-solving capabilities.

Download Engineering Graphics with AutoCAD 2020 free PDF


Content :
  • Chapter 1  Getting Started
  • Chapter 2  Fundamentals of 2D Construction 
  • Chapter 3  Advanced Commands
  • Chapter 4  Sketching
  • Chapter 5  Orthographic Views 
  • Chapter 6  Sectional Views
  • Chapter 7  Auxiliary Views
  • Chapter 8  Dimensioning
  • Chapter 9  Tolerancing
  • Chapter 10  Geometric Tolerances 
  • Chapter 11  Threads and Fasteners
  • Chapter 12  Working Drawings
  • Chapter 13  Gears, Bearings, and Cams
  • Chapter 14  Fundamentals of 3D Drawing
  • Chapter 15  Modeling


Download Engineering Graphics with AutoCAD 2020 free PDF

LINK

Commercial Drafting and Detailing

Commercial Drafting and Detailing

Alan Jefferis

Preference :

Commercial drafting and detailing is a practical, comprehensive textbook intended to introduce students to the development of architectural and structural drawings required to develop a commercial structure. Students are expected to have previously completed either a basic drawing class or a class dealing with residential drafting as well as have a working knowledge of AutoCAD. Students will build on their knowledge gained through residential drafting and design as common materials and construction methods for commercial structures are explored. Throughout the text, students will be exposed to the work that the engineer or architect will do to develop the project. This book is in no way an attempt to transform CAD technicians into junior engineers. The work of the engineer and the architect is presented to help develop an understanding of the technician’s role in the overall process of developing a set of plans.

Download Commercial Drafting and Detailing free PDF








Content :
  • Drafting and Design Considerations of Structures
  • Building Methods and Materials of Commercial Construction
  • Preparing Architectural and Civil Drawings
  • Preparing Structural Drawings


Download Commercial Drafting and Detailing free PDF

LINK

Design of Retaining Wall Under Earth Pressure & Other Loads

Design of Retaining Wall Under Earth Pressure & Other Loads


Retaining Wall is an Excel spreadsheet for the analysis of Retaining Walls subjected to lateral and vertical loads.  Using its analysis results, the wall stem and its base can be sized to have adequate stability and strength for resisting applied loads. Retaining Wall helps save design time by avoiding cumbersome hand calculations. It does not aim to predict the real behaviour which may differ from that generally assumed in routine calculations.  Retaining Wall is therefore a tool to complement the design steps for sizing and detailing such structures.
 
  




Download Design of Retaining Wall Under Earth Pressure & Other Loads Free  

Link

Flat Slab Analysis & Design Spreadsheet

Flat Slab Analysis & Design Spreadsheet


Reinforced  concrete  slabs  are  the  most  important structural component in the construction industry and the most common practice  to design any reinforced concrete slab is to start with the selection of slab type (one  way  slabs,    two  way  slabs,  waffle  slabs,  flat slabs or pre-cast or pre-stressed slabs). The most common  type  of  slabs  used  in  the  construction industry is the flat slab due to the dominancy of slab–column  connection in  the  general  behaviour of  flat slab.  Flat slab  is  also an  ease  for the  contractor  to construct  in shorter  duration.  The flat  slab sections with  regular  column  layout  are  the  most  common type of RC structures in the construction industry and it’s also  the choice for the  contractor  to  construct the building  with  regular  column  layouts.
 
  














Download Flat Slab Analysis & Design Spreadsheet Free  

Link

Understanding Construction Drawings

Understanding Construction Drawings

Mark W. Huth

Preference :

Understanding Construction Drawings is intended for students in construction programs in two-year and four-year colleges and technical institutes, as well as apprentice training. Designed for a course in print reading focused on both residential and commercial construction, the book helps you learn to read the drawings that are used to communicate information about buildings. It includes drawings for buildings that were designed for construction in several parts of North America. The diversity of building classifications and geographic locations ensures that you are ready to work on construction jobs anywhere in the industry. Everyone who works in building construction should be able to read and understand the drawings of the major trades.

Download Understanding Construction Drawings free PDF






Content :
  • PART I Drawings—The Language of Construction
  • PART II Reading Drawings for Trade Information
  • PART III Multifamily Construction
  • PART IV Heavy Commercial Construction
  • Part IV Test


Download Understanding Construction Drawings free PDF

LINK

Solar Energy: Renewable Energy and the Environment

Solar Energy: Renewable Energy and the Environment

Robert Foster,

Preference :

The twenty-first century is rapidly becoming the “perfect energy storm”; modern society is faced with volatile energy prices and growing environmental concerns, as well as energy supply and security issues. Today’s society was founded on hydrocarbon fuel—a finite resource that already is one of the main catalysts for international conflicts, which is likely to intensify in the future. The global energy appetite is enormous, representing over $6 trillion per year, or about 13% of global gross domestic product (GDP). Unfortunately, the vast majority of this energy is not efficiently utilized for buildings, vehicles, or industry. This is especially true in the United States, which has about double the per-capita and GDP energy usage rates as compared to the European Union and Japan. The inefficient use of energy strongly exacerbates the global energy crisis. It is time to shed the outdated “burn, baby, burn” hydrocarbon energy thinking with a new energy vision; the time for clean energy solutions is here. Only through energy efficiency and renewable energy technologies can modern civilization extricate itself from the gathering perfect energy storm.

Download Solar Energy: Renewable Energy and the Environment free PDF




Content :
  • Introduction to Solar Energy
  • Solar Resource
  • Fundamentals of Engineering: Thermodynamics and Heat Transfer
  • Solar Thermal Systems and Applications
  • Photovoltaic Cells
  • Photovoltaic Conversion Systems
  • Photovoltaic System Sizing and Design
  • Photovoltaic (PV) Applications
  • Economics
  • Institutional Issues
  • Energy Storage
  • Solar Energy Glossary


Download Solar Energy: Renewable Energy and the Environment free PDF

LINK

Design of Combined Foundation With Piles

Design of Combined Foundation With Piles


The first problem facing the designer of a foundation is to determine whether or not the site conditions are such that piles must be used. Piles are used where upper soil strata are compressible or weak; where footings cannot transmit inclined, horizontal, or uplift forces; where scour is likely to occur; where future excavation may be adjacent to the structure; and where expansive or collapsible soils extend for a considerable depth.
 
  












Download Design of Combined Foundation With Piles Free  

Link

Amazing Excel Sheet to Design all Structural Element

Amazing Excel Sheet to Design all Structural Element


Structural design is a key element of all degree and
diploma courses in civil and structural engineering.
It involves the study of principles and procedures
contained in the latest codes of practice for structural design for a range of materials, including concrete, steel, masonry and timber.
 
  










Download Amazing Excel Sheet to Design all Structural Element Free  

Link

Design of Structural Elements to Eurocodes

Design of Structural Elements to Eurocodes

W.M.C. McKenzie

Preference :

The development of new building materials/structural systems and improved understanding of their behaviour increased at a faster rate during the latter half of the twentieth century than at any other time in history. The most commonly used materials are reinforced concrete, structural steelwork, timber and masonry. In all developed countries of the world structural design codes/codes of practice have been formulated or adopted to enable engineers to design structures using these materials which should be safe and suitable for the purposes for which they are intended. Despite this, the fact remains that structural failures do, and always will, occur. In order to minimise the occurrence of failure it is necessary to incorporate education, training, experience and quality control in all aspects of a design project. To provide merely familiarity with design codes as part of an educational programme is clearly inadequate; understanding and competence will only develop with further training and experience.

Download Design of Structural Elements to Eurocodes free PDF






Content :
  • Chapter 1 - Structural Analysis Techniques
  • Chapter 2 - Overall Structural Stability and Robustness
  • Chapter 3 - Design Philosophies and the Eurocode Program 
  • Chapter 4 - EN 1990 - Basis of Structural Design (Eurocode)
  • Chapter 5 - EN 1991 - Actions on Structures (Eurocode 1) 
  • Chapter 6 - EN 1992 - Design of Reinforced Concrete Elements (Eurocode 2) 
  • Chapter 7 - EN 1993 - Design of Structural Steelwork Elements (Eurocode 3) 
  • Chapter 8 - EN 1995 - Design of Timber Elements (Eurocode 5) 
  • Chapter 9 - EN 1996 - Design of Masonry Elements (Eurocode 6)


Download Design of Structural Elements to Eurocodes free PDF

LINK

Tube / Pipe Column Design Spreadsheet

Tube / Pipe Column Design Spreadsheet


Further innovations in the flat tube /pipe column method are now being utilized. On-site precast slabs, apartment size or slightly smaller, are being lifted to form the apartment floors. The slabs for another three - s tory, twelve - unit building are supported on bearing walls. The change from the bearing wall to the pipe column type of s u p p o rt will be made on two projects now in the design stage 
  








Download Tube / Pipe Column Design Spreadsheet Free  

Link

Cantilever Retaining Wall Analysis and Design

Cantilever Retaining Wall Analysis and Design


Purpose of calculation: The details of a cantilever retaining wall are shown below, is the design of the wall satisfactory? Calculation Reference: Craig Soil Mechanics. R.F. Craig Calculation Validation: Check against a worked example in the reference above. 
  






Download Cantilever Retaining Wall Analysis and Design Excel Sheet Free  

Link

Surveying for Engineers

Surveying for Engineers

J. Uren, W.F. Price

Preference :

It is now more than 30 years since the publication of the first edition of Surveying for Engineers, and in that time the equipment and techniques used in engineering surveying have undergone incredible changes. Electronic theodolites and total stations, digital levels, laser scanners, and machine control systems, to name just a few, were all unheard of when the first edition was published in 1978, which by pure coincidence was the same year that the first GPS satellite was launched. Since then the discipline into which engineering surveying falls has developed almost beyond recognition, having even been given a new identity with the name of Geomatics. There can be few disciplines that have changed so quickly and dramatically. Subsequent editions of Surveying for Engineers have always tried to reflect this evolution and this new fifth edition is no exception.

Download Surveying for Engineers free PDF




Content :
  • Introduction
  • Levelling
  • Angle measurement
  • Distance measurement: taping
  • Total stations
  • Traversing and coordinate calculations
  • Global Navigation Satellite Systems
  • National coordinates and transformations
  • Measurements, errors and specifications
  • Detail surveying and mapping
  • Setting out
  • Circular curves
  • Transition curves
  • Vertical curves
  • Earthwork quantities


Download Surveying for Engineers free PDF

LINK

Shear Wall Design Based on ACI

Shear Wall Design Based on ACI


shear  wall  is  a structural  system  composed  of  braced  panels  (also known  as  shear  panels)  to  counter  the  effects  of lateral  load  acting  on  a  structure.  Wind  and seismic loads are the most common loads that shear walls  are  designed  to  carry.  Vibrations,  which  are caused  under  the  earth’s  surface,  generate  waves, which  disturb  the  earth’s  surface,  termed  as earthquakes. 
  








Download Shear Wall Design Based on ACI Excel Sheet Free  

Link

Australian Guidebook for Structural Engineers

Australian Guidebook for Structural Engineers

Lonnie Pack

Preference :

This text aims to bridge the gap between Australian Standards, textbooks and industry knowledge. After years of work in the industry, many engineers will have created a library of calculations, specifications and standards that can be used to help complete projects. It is hoped that this compendium of resources helps to create a useful set of references that can aid engineers in the expedient delivery of design projects. Many examples and information in this document are drawn from the mining and oil and gas industries. A multidiscipline engineering project requires close and coordinated work between engineers and designers of the same and other disciplines. A clear scope and list of deliverables is imperative, along with a structured formwork of how to achieve the desired outcome.


Download Australian Guidebook for Structural Engineers free PDF




Content :

  • 1 Setting up the project
  • 2 Design
  • 3 Steel design
  • 4 Concrete design
  • 5 Geotechnical
  • 6 Design items
  • 7 Design aids
  • 8 Vendor catalogues
  • 9 Notations and abbreviations

  • Download Australian Guidebook for Structural Engineers free PDF

    LINK