Fixed Steel Column Base Design Excel Sheet 

Column base plate connections are the critical interface between the steel and concrete structures or foundations since their behavior greatly influences the performance of steel structures in terms of the distribution of moments, forces, and displacements.

LINK

 Concrete Box Culvert analysis and Design Excel Sheet 

Box culverts are the structures that are used when the path of water in the natural stream crosses roads, railway lines, flyovers, etc. They are normally cheaper than bridges, which make them the natural stream passes through channels.

Concrete Box Culvert analysis and Design Excel Sheet

LINK

Marine Structural Design, Second Edition

Marine Structural Design, Second Edition 

Bai, Yong, Jin

Preference :

This book is devoted to the modern theory for design and analysis of marine structures. The term “marine structures” refers to ships and offshore structures. The objective of this book is to summarize the latest developments of design codes, engineering practices, and research into the form of a book, focusing on applications of finite element analysis and risk/reliability methods.

Calculating wave loads and load combinations is the first step in marine structural design. For structural design and analysis, a structural engineer needs to understand the basic concepts of waves, motions, and design loads. Extreme value analysis for dynamic systems is another area that has had substantial advances from 1995 to 2015. It is an important subject for the determination of the design values for motions and strength analysis of floating structures, risers, mooring systems, and tendons for tension leg platforms.

Content :

• Part 1. Structural Design Principles
• Part 2. Ultimate Strength
• Part 3. Fatigue and Fracture
• Part 4. Structural Reliability
• Part 5. Risk Assessment
• Part 6. Fixed Platforms and FPSO

Download Marine Structural Design, Second Edition free PDF

LINK

 ASCE Beam End Connection Excel Sheet 

"BEAMTAB" is a spreadsheet program written in MS-Excel for the purpose of analysis of steel beam end connections using a beam tab (single plate) field bolted to the beam web and shop welded to either the column flange, column web, or girder web.  The connections may be subjected to end shear reaction and/or axial load. Specifically, all applicable "limit states" for the end connection analysis pertaining to the beam tab (single plate), bolts,  beam web, and either column flange or web, or girder web are checked.

ASCE Beam End Connection Excel Sheet

LINK

Construction Cost Management: Learning from Case Studies

Construction Cost Management: Learning from Case Studies 

Keith Potts,

Preference :

There have been many significant changes in the construction sector within the past decade. Notably, the sector has witnessed the growth of partnering and alliancing which require better management of the supply chain and increasing use of the NEC Contract (NEC3) which requires a team-based proactive approach to project delivery. New financial models have been developed including Private Finance Initiative (PFI), Local Asset Backed Vehicles (LABVs), and variants of these in which private sector consortia design, build, own, and operate public facilities in partnership with the public sector. Great advances have been made on the technical front with the growth of Building Information

Content :

• Introduction
• Management of the Pre-contract Stage
• Key Tools and Techniques
• Procurement Strategies
• Management of the Post-contract Stage
• Contracts and Case Studies

Download Construction Cost Management: Learning from Case Studies free PDF

LINK

Airport Planning & Management, 5th Edition

Airport Planning & Management, 5th Edition 

Alexander T. Wells,

Preference :

It is often said that managing an airport is like being mayor of a city. Similar to a city, an airport is comprised of a huge variety of facilities, systems, users, workers, rules, and regulations. Also, just as cities thrive on trade and commerce with other cities, airports are successful in part by their ability to successfully be the location where passengers and cargo travel to and from other airports. Furthermore, just as cities find their place as part of their county’s, state’s, and country’s economy, airports, too, must operate successfully as part of the nation’s system of airports. In this chapter, the airport system in the United States will be described in a number of ways. First, the national airport system, as a whole, will be described. Next, the various facilities that make up the airport system will be described. Finally, the various rules and regulations that govern the airport system will be described.

Content :

• 1 Airports and airport systems: An introduction
• 2 Airports and airport systems: Organization and administration
• 3 Airports and airport systems: A historical and legislative perspective
• 4 The airfield
• 5 Airspace and air traffic control
• 6 Airport terminals and ground access
• 7 Airport operations management under FAR Part
• 8 Airport security
• 9 Airport financial management
• 10 The economic, political, and social role of airports
• 11 Airport planning
• 12 Airport capacity and delay
• 13 The future of airport management

Download Airport Planning & Management, 5th Edition free PDF

LINK

 Cylindrical Tank with Domed Roof Calculator Excel Sheet 

The formula for the volume of a cylinder is V=Bh or V=πr2h. Cylindrical tanks constructed with domed or coned roofs, which operate at pressures above 15 psia (1 Bar) but are still relatively close to atmospheric pressure, can be built according to API Standard

Cylindrical Tank with Domed Roof Calculator Excel Sheet

LINK

 Continuous Beam Analysis & Design Spreadsheet According to BS Code 

The method of superposition is used to represent a continuous beam by the appropriate single-span beams (each span by two propped cantilevers and one simply supported beam). Simple expressions are presented to determine the equivalent load on each of the substituent beams.

Continuous Beam Analysis & Design Spreadsheet According to BS Code

LINK

Introduction to Software Project Management

Introduction to Software Project Management 

Villafiorita

Preference :

Software development is considered among the most complex activities carried out by man. The steady growth of software systems’ size, the increasing role software is playing in safety-critical applications, and the speed at which technology and software change are some of the causes frequently mentioned to support the above claim. Although techniques and tools to build software have improved considerably in the last 60 years, a proper development process and sound project management are and will remain the top reasons software projects fail or succeed. 

Software project managers share many of the goals of project managers in other domains, namely, ensuring an appropriate quality of the end product, while, at the same time, keeping under control all the other project variables, like time and costs. Different from other domains, however, software has specific characteristics, such as invisibility, complexity, and flexibility (in its application and production means), that call for specific management techniques.

Content :

• Introduction
• The Basics: Software Development Activities and Their Organization
• Making IT Right: Managing Goals, Time, and Costs
• Making IT Better: Managing Changes, Risks, and Quality
• Making IT Perfect: Managing People and Organizing Communication
• Software Project Pricing
• Managing Software Development Projects
• Software Project Pricing
• Managing Software Development Projects
• Development and Management Standards
• Open Source Tools for Managing Projects

Download Introduction to Software Project Management free PDF

LINK

Managing Project Risks

Managing Project Risks 

Edwards,

Preference :

If ‘project’ is part of your daily vocabulary, then this book is aimed at you. It is intended to appeal to practitioners of project management across a wide range of industries and professions; to people working in the private and public sectors, and those in the arts and entertainment; as well as to business organizations, service providers, and manufacturers. Students are very much included in our target readership as they pursue their academic journeys on the way to entering hopefully satisfying and rewarding careers.

Content :

• Introduction 
• An Overview of Risk
• Projects and Project Stakeholders
• Project Risk Management Systems
• Project Risk Contexts and Drivers
• Approach to Project Risk Identification
• Project Risk Identification Tools
• Project Risk Analysis and Evaluation
• Risk Response and Treatment Options
• Risk Monitoring and Control
• Project Risk Knowledge Management
• Cultural Shaping of Risk
• Project Complexity and Risk
• Political Risk
• Opportunity Risk Management
• Strategic Risk Management 
• Communicating Risk 
• Conclusions 

Download Managing Project Risks free PDF

LINK

 Elevated Water Tank Design Excel Sheet 

Elevated water tanks are used to store water for fire protection and potable drinking water within a designated area or community. Elevated tanks allow the natural force of gravity to produce consistent water pressure throughout the system.

Download Elevated Water Tank Design Excel Sheet

LINK

Agile Project Management with Azure DevOps: Concepts, Templates, and Metrics

Agile Project Management with Azure DevOps 

Joachim Rossberg

Preference :

Agile Project Management with Azure DevOps teaches you how to use Azure DevOps to implement many Agile practices such as SAFe, Scrum, and Kanban, and it shows you how they fit into a well-planned Agile implementation. Agile product owners will learn how to work with Azure DevOps to set up a project from scratch, and to continue using Azure DevOps throughout.

Keeping track of progress is important in any project. Author Joachim Rossberg teaches you about the tools in Azure DevOps that can help you track progress and key metrics, including those that are available right out of the box. You will learn how to create and refine the backlog, work with Kanban and Scrum task boards, and get exposed to valuable key concepts along the way. Finally, you will dive into Azure DevOps extensibility to learn about the many ways you can customize reporting to best meet your needs

Content :

• Introduction to Application Life Cycle Management
• An Overview of Azure DevOps
• Introduction to Scrum and Agile Concepts
• Work Items and Process Templates
• Customizing the Process Template in Azure DevOps
• Agile Practices in Azure DevOps and TFS
• Metrics in Agile Projects
• Agile Project Management in Azure DevOps and TFS

Download Agile Project Management with Azure DevOps: Concepts, Templates, and Metrics free PDF

LINK

 Pressure Tank Calculating Excel Sheet 

Pressure tank size formula is given as follows :

size = ((Drawdown volume/cut-out pressure - cut-in pressure)/ cut-out pressure + 1)

The drawdown is based on pump capacity and the number of start/stops per hour and the amount of water that can be taken from the tank before the pump starts.

Download Pressure Tank Calculating Free Excel Sheet

LINK

Principles of Water Quality Control, Fifth Edition

Principles of Water Quality Control, Fifth Edition 

T.H.Y. Tebbutt

Preference :

The importance of safe water supply and effective sanitation was recognized centuries ago by several ancient civilizations. Archaeological excavations in Asia and the Middle East have revealed highly developed communities with piped water supplies, latrines, and sewers. The Minoan civilization in Crete, which flourished 4000 years ago, used fired clay water and wastewater pipes, and the dwellings were provided with flushing toilets. The Romans were expert public health engineers and had highly developed water supply and drainage systems in the main cities. Considerable amounts of water were used in continuously operating fountains which provided the main water supply for most of the population, although wealthy families had their own piped supplies.

Content :

• Characteristics of waters and wastewaters
• Sampling and analysis
• Aquatic microbiology and ecology
• Water quality and health
• Biological oxidation of organic matter
• Water pollution and its control
• Quantities of water and wastewater
• Introduction to treatment processes
• Preliminary treatment processes
• Clarification; Coagulation
• Flow-through porous media
• Aerobic biological oxidation
• Anaerobic biological oxidation
• Disinfection
• Chemical treatment
• Sludge dewatering and disposal
• Tertiary treatment and water reclamation
• Water supply and sanitation in developing countries

Download Principles of Water Quality Control, Fifth Edition free PDF

LINK

Engineering Mechanics, 3rd edition

Engineering Mechanics, 3rd edition 

Kumar

Preference :

Engineering is an activity concerned with the creation of new systems for the benefit of mankind. The process of creativity proceeds by way of research, design, and development; new systems emerge from innovation and systems may be constituted by mechanical, electromechanical, hydraulic. thermal or other elements. The creation of new systems is thus basic to all engineering. The Living Webster Encyclopedic Dictionary aptly defines engineering as the art of excelling a partial application of scientific knowledge.

Forward:

lt is important to understand the difference between engineering and science. Science is concerned with a systematic understanding and gathering of the facts, laws, and principles governing natural phenomena. Engineering, on the other hand, is an art of utilisation of the established facts, laws and principles to create certain desired phenomena. The activities of science and engineering arc thus mutually opposite. Both may proceed through similar ways and means of analysis and synthesis but are oppositely directed. The training of scientists and engineers should be correspondingly designed for their respective objectives.

Download Engineering Mechanics, 3rd edition free PDF

LINK

 Wall Pier Design Spreadsheet 

A pier, in architecture, is an upright support for a structure or superstructure such as an arch or bridge. Sections of structural walls between openings (bays) can function as piers.

Download Wall Pier Design Free Spreadsheet

LINK

Project Management Workbook and PMP/CAPM Exam Study Guide

Project management workbook and PMP/CAPM exam study guide 

Kerzner, Harold

Preference :

Project management has been practiced for hundreds, actually thousands, of years. Long before computers and sophisticated scheduling techniques became available, the ancestors of today’s professional project managers had to determine resource requirements, arrange for material and equipment, and strive to meet a schedule imposed by, in many cases, a powerful leadership entity. They knew that any construction type of undertaking or project endeavor, large or small, required a goal, a set of objectives, a plan, coordination with many functional groups, the management of resources, and the ability to manage change. Additionally, it became very clear that every project requires strong and adaptive leadership.

Content :

• Project Management Overview
• Project Management Growth: Concepts and Definitions
• Organizational Structures
• Organizing and Staffing the Project Office and Team
• Management Functions
• Communications Management
• Conflicts
• Special Topics
• The Variables for Success
• Working with Executives
• Planning
• Network Scheduling Techniques
• Pricing and Estimating
• Cost Control
• Metrics
• Trade-Off Analysis in a Project Environment
• Risk Management
• Learning Curves
• Contract Management
• Quality Management
• Modern Developments in Project Management

Download Modern Construction Handbook, Third Edition free PDF

LINK

Principles of Financial Engineering, Third Edition

Principles of Financial Engineering, Third Edition 

Robert Kosowski

Preference :

This book is an introduction. It deals with a broad array of topics that fit together through a certain logic that we generally call Financial Engineering. The book is intended for beginning graduate students and practitioners in financial markets. The approach uses a combination of simple graphs, elementary mathematics, and real-world examples. The discussion concerning details of instruments, markets, and financial market practices is somewhat limited. The pricing issue is treated in an informal way, using simple examples. In contrast, the engineering dimension of the topics under consideration is emphasized.

Content :

• 1. Introduction
• 2. Institutional Aspects of Derivative Markets
• 3. Cash Flow Engineering, Interest Rate Forwards and Futures
• 4. Introduction to Interest-Rate Swap Engineering
• 5. Repo Market Strategies in Financial Engineering
• 6. Cash Flow Engineering in Foreign Exchange Markets
• 7. Cash Flow Engineering and Alternative Classes (Commodities and Hedge Funds)
• 8. Dynamic Replication Methods and Synthetics Engineering
• 9. Mechanics of Options
• 10. Engineering Convexity Positions
• 11. Options Engineering with Applications
• 12. Pricing Tools in Financial Engineering
• 13. Some Applications of the Fundament
• 14. Fixed Income Engineering
• 15. Tools for Volatility Engineering, Volatility Swaps, and Volatility Trading
• 16. Correlation as an Asset Class and the Smile
• 17. Caps/Floors and Swaptions with an Application to Mortgages
• 18. Credit Markets: CDS Engineering
• 19. Engineering of Equity Instruments and Structural Models of Default
• 20. Essentials of Structured Product Engineering
• 21. Securitization, ABSs, CDOs, and Credit Structured Products

Download Principles of Financial Engineering, Third Edition PDF

LINK

Structure and Architecture, Third Edition

Structure and Architecture, Third Edition 

Angus J Macdonald

Preference :

This book on architectural structures seeks to provide the reader with both the technical background required to appreciate the role of structure in architecture and a discussion of all aspects of this role, including the contribution of structure to architectural form and style and its importance in relation to questions such as environmental sustainability. 

The intention is to give insights into both the methodology of structural engineering in relation to architecture and its historical development. Space does not permit that any of the topics be covered comprehensively. For example, the works of only a small number of the many engineers who have contributed prominently to Modern architecture have been included – chosen for their particular significance. Similarly, the discussion of structural theory covers only a few small aspects of that topic, again selected to allow broad conclusions to be drawn concerning the role of theory in the building process as a whole, and to give insights into its depths.

Content :

• Introduction
• The relationship of structure to building
• Structural requirements
• Structural material
• The relationship between structural form and structural efficiency 
• Complete structural arrangements
• Critical appraisal of structures
• Structure and architecture
• Selected bibliography
• Appendix 1: Simple two-dimensional force systems and static equilibrium
• Appendix 2: Stress and strain
• Appendix 3: The concept of statical determinacy

Download Structure and Architecture, Third Edition free PDF

LINK

Principles of construction safety

Principles of construction safety 

Allan St. John Holt

Preference :

The construction industry has not had a good record on health and safety and faces tough legal and financial penalties for breaches of the law. This book provides a unique resource for all those who construct or procure the construction of projects of all sizes and in all countries and for clients who need to keep abreast of their own and their contractors' responsibilities. It gives practical guidance on best practice, including:* measuring performance and recording information* developing a safety policy and method statements* assessing risk* training and understanding people* the basics of the construction/environment interface book addresses several topics not found in other reference works, discussing techniques of health and safety and basic environmental management as applied to the industry. It uniquely provides 50 quick reference guides setting out solutions to common problems.

Content :

• Introduction 
• Part 1 Construction Safety Management - Fundamentals
• Where are we now?
• Measuring performance & recording information
• Techniques of construction safety management
• The Safety policy
• Assessing the risks
• Control strategies for construction work
• The Health and Safety plan
• Training
• Meetings
• Understanding people
•  Joint consultation; Access to information
• Part 2 Environment, Health and Safety Issues - Construction and the environment
• Construction hazards and solutions
• Quick reference guide
• Part 3 Legal Requirements - Construction Health and safety law

Download Principles of construction safety free PDF

LINK

 Composite Collector Beam Design with Seismic Loads Excel Sheet 

DESIGN CRITERIA

1.  When welded shear connectors are used for the transfer of lateral shear loads to drags/collectors, the allowable shear strength maybe 75% of the available strength for both gravity and lateral design (ACI 318-14 Chapter 17), to consider concrete cracked at lateral loads.

2.  The input STUDS SPACING must be based on actual deck ribs spacing perpendicular to the beam. For the following total [15] studs, if ribs

Download Composite Collector Beam Design with Seismic Loads Excel Sheet

LINK