Excel for Scientists and Engineers - Numerical Methods

Excel for Scientists and Engineers - Numerical Methods 

E. Joseph Billo

Preference :

The solutions to mathematical problems in science and engineering can be obtained by using either analytical or numerical methods. Analytical (or direct) methods involve the use of closed-form equations to obtain an exact solution, in a non-repetitive fashion; obtaining the roots of a quadratic equation by application of the quadratic formula is an example of an analytical solution. Numerical (or indirect) methods involve the use of an algorithm to obtain an approximate solution; results of a high level of accuracy can usually be obtained by applying the algorithm in a series of successive approximations. As the complexity of a scientific problem increases, it may no longer be possible to obtain an exact mathematical expression as a solution to the problem. Such problems can usually be solved by numerical methods.

Content :

• Introducing Visual Basic for Applications 
• Fundamentals of Programming with VBA 
• Worksheet Functions for Working with Matrices 
• Number Series 
• Interpolation 
• Differentiation 
• Integration
• Roots of Equations 
• Numerical Integration of Ordinary Differential Equations
• Part I: Initial Conditions 
• Numerical Integration of Ordinary Differential Equations
• Part 11: Boundary Conditions
• Partial Differential Equations 
• Nonlinear Regression Using the Solver
• Random Numbers and the Monte Carlo Method

Download Excel for Scientists and Engineers - Numerical Methods free PDF

LINK

Construction quantity surveying: a practical guide for the contractor's QS

Construction quantity surveying: a practical guide for the contractor's QS 

Donald Towey

Preference :

This book aims to provide readers with a practical guide and insight into quantity surveying from a main contractor’s (the contractor) perspective and allow them to acquire an understanding of the skills and competencies of the contractor’s quantity surveyor. As a result of various procurement pathways open to clients, some contractors are prepared to offer a design and build service and commit to a predetermined budget. As a result, quantity surveying has become a skill in demand by contractors seeking input into contemporary aspects of construction procurement. This includes measurement, estimating, contract administration, and construction planning, as well as commercial, cost, and project management.

Content :

• The Construction Industry and the Quantity Surveyor
• Measurement and Quantities
• Working with the Main Contractor
• Project Commencement
• Supply Chain Procurement 
• Running the Project
• Project Completion

Download Construction quantity surveying: a practical guide for the contractor's QS free PDF

LINK

Timber Construction: Details, Products, Case Studies

Timber Construction: Details, Products, Case Studies 

Johann Weber

Preference :

New materials and stricter energy-efficiency requirements have brought about radical changes in timber construction in recent years. Whether built on-site or pre-fabricated, this publication provides a concise survey of modern timber construction, the materials, and their applications.

Content :

• Introduction
• House A
• House B
• Party wall
• Overview of exemplary constructions
• Exemplary construction
• Index of project

Download Timber Construction: Details, Products, Case Studies free PDF

LINK

Construction Equipment Management for Engineers Estimators and Owners

Construction Equipment Management for Engineers Estimators and Owners 

Douglas Granberg

Preference :

Construction Equipment Management for Engineers, Estimators, and Owners is intended to be a reference book for construction project managers, estimators, construction equipment fleet managers, and professional engineers. The book also contains information relevant to both the public and private sectors. It contains a great deal of ‘‘hands-on, how-to’’ information about equipment management based on the authors’ personal construction experiences throughout the world. It is written as a guide for individuals who need to estimate the cost of equipment on a given project and do not have data at their fingertips because their routine business does not involve a lot of equipment-related construction. The authors also hope that their book will be useful to the public agency equipment manager whose need is to minimize equipment costs rather than to maximize the profit earned by the equipment.

Content :

• Evolution of Heavy Construction Equipment
• Cost of Owning and Operating Construction Equipment
• Equipment Life and Replacement Procedures
• Earthmoving, Excavating, and Lifting Equipment Selection
• Advanced Methods in Estimating and Optimizing Construction Equipment System
• Stochastic Methods for Estimating Productivity
• Scheduling Equipment-Intensive Horizontal Construction Projects
• Scheduling Lifting Equipment for Vertical Construction
• The Buy, Lease, or Rent Decision
• Construction Equipment Maintenance
• Construction Equipment Site Safety
• Construction Equipment Security
• Inventory Procedures and Practices

Download Construction Equipment Management for Engineers Estimators and Owners free PDF

LINK

Earth Reinforcement and Soil Structures

Earth Reinforcement and Soil Structures 

Colin J F P Jones

Preference :

The basic principles involved in earth reinforcement techniques are simple to grasp and have been used by man for centuries. Recently there has been major growth in interest in the subject due in part to the pioneering work of Henri Vidal in the development of 'Reinforced Earth', a term which is now widely used as a general description of this form of construction. The basic attributes of earth reinforcement which are of particular advantage in civil engineering are re- ductions in costs and ease of construction, coupled with a basic simplicity that provides an attraction to engineers. Recognition and interest in the subject have gained impetus because of the technical and commercial success that has been demonstrated by the practitioners. The concept of reinforcing soil has also attracted the attention of the academic world, for although the concept is easily grasped the theoretical aspects involved are numerous. As a result, much research and development work has been undertaken in Universities and laboratories and soil reinforcement is now recognized as a separate subject in its own right in the geotechnical field.

Content :

• 1 Introduction
• 2 History
• 3 Application Areas
• 4 Theory
• 5 Materials
• 6 Design and Analysis
• 7 Construction
• 8 Construction Details
• 9 Costs and Economics
• 10 Durability
• 11 Examples
• 12 Recent Developments

Download Earth Reinforcement and Soil Structures free PDF

LINK

Project Risk Management: A Practical Implementation Approach

Project Risk Management: A Practical Implementation Approach 

Bissonette

Preference :

Growing worldwide competition in virtually every industry has raised the bar for developers and marketers of new products and services. This has led to the goal and pursuit of doing more with less, and thus intentionally taking more risk, which leads to the need for tighter project controls to succeed as a thriving business entity. Further, recognizing that project management competencies, tools, and techniques have evolved over time to enable more reliable and effective project performance raises the need to consider what best practices projects should employ to maximize their probability of success, and gain a distinct competitive advantage in today's marketplace. This book addresses these concerns in a very practical way.

Project Risk Management: A Practical Implementation Approach

Content :

• CHAPTER 1: Practical Application of Project Risk Management
• CHAPTER 2: Risk Management—Integral to Project Management
• CHAPTER 3: Risk Definitions and General Categories
• CHAPTER 4: Classical Project Risk Management Practices
• CHAPTER 5: Determining Individual Project Risks
• CHAPTER 6: Project Risks Influenced by the Project Manager and Project Team
• CHAPTER 7: Project Risks Influenced by Organizational and External Factors
• CHAPTER 8: Individual Project Risk Analysis
• CHAPTER 9: Overall Project Risk Analysis
• CHAPTER 10: Determining and Planning Project Risk Responses
• CHAPTER 16: Example Project Case Studies

Download Project Risk Management: A Practical Implementation Approach free PDF

LINK

Soil Properties and Their Correlations

Soil Properties and Their Correlations 

.Bentley, Stephen P

Preference :

The aims of this book are to provide a summary and discussion of commonly used soil engineering properties and to give correlations of various engineering properties.

The book includes:

• a compendium of published correlations;

• discussions of the reliability, accuracy, and usefulness of the various correlations;

• practical advice on how soil properties are used in the assessment and design of geotechnical problems, including basic concepts, and limitations on their use that need to be considered; and

• descriptions of the measurement of soil properties, and how results are affected by the method of measurement and the expertise of technicians carrying out the testing.

Content :

• Commonly Measured Properties
• Grading and Plasticity 
• Density
• Permeability
• Consolidation and Settlement
• Shear Strength
• California Bearing Ratio
• Shrinkage and Swelling Characteristics
• Frost Susceptibility
• Susceptibility to Combustion
• Soil‐Structure Interfaces
• Appendix A: Soil Classification Systems
• Appendix B: Sampling Methods

Download Soil Properties and Their Correlations free PDF

LINK

Corrosion of Steel in Concrete: Prevention, Diagnosis, Repair, Second Edition

Corrosion of Steel in Concrete: Prevention, Diagnosis, Repair, Second Edition 

Prof. Luca Bertolini

Preference :

The case of reinforced concrete is somewhat different. These structures are not eternal, or nearly eternal, as was generally supposed up until the 1970s. Instead, their service life is limited precisely because of the corrosion of reinforcement. Actually, concrete provides the ideal environment for protecting embedded steel because of its alkalinity. If the design of a structure, choice of materials, composition of the mixture, and placement, compaction, and curing are carried out in compliance with current standards, then concrete is, under most environmental conditions, capable of providing protection beyond the 50 years typical of the required service life of many ordinary structures, at least in temperate regions. In fact, cases of corrosion that have been identified in numerous structures within periods much shorter than those just mentioned can almost always be traced to a failure to comply to current standards or to trivial errors in the manufacturing of the concrete.

Content :

• Cement and Cement Paste
• Transport Processes in Concrete
• Degradation of Concrete
• General Aspects
• Carbonation-Induced Corrosion
• Chloride-Induced Corrosion
• Electrochemical Aspects
• Macrocells
• Stray-Current-Induced Corrosion
• Hydrogen-Induced Stress Corrosion Cracking
• Design for Durability
• Concrete Technology for Corrosion Prevention
• Corrosion Inhibitors
• Surface Protection Systems
• Corrosion-Resistant Reinforcement
• Inspection and Condition Assessment
• Electrochemical Techniques

Download Corrosion of Steel in Concrete: Prevention, Diagnosis, Repair free PDF

LINK

 Steel Staircase Design 

Steel staircase design spreadsheet allows you to design stairs 

Download Steel Staircase Design

LINK

Soil Arching Effect for Braced Excavations Excel Sheet 

This spreadsheet will calculate the horizontal earth pressure exerted on a braced excavation using soil arching theory as proposed 

LINK

Soil Improvement and Ground Modification Methods

Soil improvement and ground modification methods 

Peter G Nicholson

Preference :

With very few exceptions, everything we construct in our built environment lies in or on the ground. As a consequence, the earth materials involved must be evaluated to ensure that engineering properties will adequately provide for acceptable performance of a project. There are many different properties that must be assessed based on the requirements of the project, and these will vary greatly depending on the overall (and underlying) objectives. One must be careful not to overlook other components that may affect lives and property, including natural and man-made hazards. These may involve natural, constructed, and cut slopes, potential flooding and storm surges, earthquakes, and so on. For most structures, including buildings, bridges, roadways, and engineered earth structures, there are some fundamental “rules” pertaining to the ground that must be followed in order to ensure the “success” of the structure.

Content :

• Section I: Introduction to Ground Improvement and Soil Stabilization
• Section II: Soil Densification
• Section III: Hydraulic Modification
• Section IV: Physical and Chemical Modification
• Section V: Modification with Inclusions and Confinement
• Standard Sieve Sizes
• Approximate Conversions to SI Units

Download Soil Improvement and Ground Modification Methods free PDF

LINK