Solutions for Soil and Structural Systems using Excel and VBA Programs

Solutions for Soil and Structural Systems using Excel and VBA Programs PDF Author: Robert Sogge
Publisher: John Wiley & Sons
ISBN: 1119951550
Category : Technology & Engineering
Languages : en
Pages : 0

Get Book Here

Book Description
A practical guide to analyzing soil and structural systems using Excel spreadsheets and VBA macro programs (in open-source code) that are provided on the accompanying CD. This book gives readers the tools to understand the methods such as finite element analysis used to analyze common problems in structural engineering, foundation engineering and soil-structure interaction. The book has value just based on its instructions in Excel spreadsheets and the Visual Basic for Applications (VBA) macro programming language alone. By providing an expert system and guidance to the reader in its use through examples, the author shows the methods and simple modelling techniques that demystify soil-structure applications by presenting the essentials in a clear and concise way. The book also addresses some of the disappointments in geo-engineering by providing tools to calculate deformations, implement soil-structure interaction procedures, provide simple computer solutions, while incorporating proper soil and rock properties in the analyses. Can be used by students or practicing professional engineers as a hands-on self-study guide as prewritten complete Excel spreadsheets and VBA programs are applied to many different Civil Engineering example problems VBA code techniques and its use and programming are explained but a working knowledge is not required to use the spreadsheet and programs provided Computations are performed using VBA macro programs getting input data from worksheet cells (whereby the spreadsheet functions as a pre-processor) or from input data files Robert L. Sogge has a background which includes training, teaching, research and practical consulting in the area of soil-structure interaction. He achieved his PhD in Civil Engineering at the University of Arizona, USA, and practices in that state and California. He has developed many of these computer programs in the pursuit of his work as a consultant.

Solutions for Soil and Structural Systems using Excel and VBA Programs

Solutions for Soil and Structural Systems using Excel and VBA Programs PDF Author: Robert Sogge
Publisher: John Wiley & Sons
ISBN: 1119951550
Category : Technology & Engineering
Languages : en
Pages : 0

Get Book Here

Book Description
A practical guide to analyzing soil and structural systems using Excel spreadsheets and VBA macro programs (in open-source code) that are provided on the accompanying CD. This book gives readers the tools to understand the methods such as finite element analysis used to analyze common problems in structural engineering, foundation engineering and soil-structure interaction. The book has value just based on its instructions in Excel spreadsheets and the Visual Basic for Applications (VBA) macro programming language alone. By providing an expert system and guidance to the reader in its use through examples, the author shows the methods and simple modelling techniques that demystify soil-structure applications by presenting the essentials in a clear and concise way. The book also addresses some of the disappointments in geo-engineering by providing tools to calculate deformations, implement soil-structure interaction procedures, provide simple computer solutions, while incorporating proper soil and rock properties in the analyses. Can be used by students or practicing professional engineers as a hands-on self-study guide as prewritten complete Excel spreadsheets and VBA programs are applied to many different Civil Engineering example problems VBA code techniques and its use and programming are explained but a working knowledge is not required to use the spreadsheet and programs provided Computations are performed using VBA macro programs getting input data from worksheet cells (whereby the spreadsheet functions as a pre-processor) or from input data files Robert L. Sogge has a background which includes training, teaching, research and practical consulting in the area of soil-structure interaction. He achieved his PhD in Civil Engineering at the University of Arizona, USA, and practices in that state and California. He has developed many of these computer programs in the pursuit of his work as a consultant.

An Introduction to Excel for Civil Engineers

An Introduction to Excel for Civil Engineers PDF Author: Gunthar Pangaribuan
Publisher: Createspace Independent Publishing Platform
ISBN: 9781537137711
Category :
Languages : en
Pages : 386

Get Book Here

Book Description
It's a Excel basics book that every civil engineer should have read by now. It addresses skills that may not be covered in most Excel for civil engineering texts, such as step by step guides to create an application program and how to convert the steps into VBA code, how to perform matrix operations (multiplication and inversion) using Excel-VBA, macro for creating an engineering chart, a brief and simple guide to become an instant Excel-VBA programmer, and more... Also to be presented the depiction in AutoCAD program. Yes! AutoCAD is chosen because one of its advantages that relies on high drawing accuracy. You will learn how to create a simple AutoCAD script file using Excel formulas and Excel-VBA. It is expected that you will be able to create simple Cartesian graph in AutoCAD, even you are an AutoCAD first time user! With the ease of working with Excel, coupled with benefit of the given examples in this book, it is expected to increase the interest of the reader to create new original application programs. Thus, each model or even a specific calculation will be an exciting challenge for a programming job is already enjoyable. Happy Excel programming!

Irrigation and Drainage Engineering

Irrigation and Drainage Engineering PDF Author: Peter Waller
Publisher: Springer
ISBN: 3319056999
Category : Science
Languages : en
Pages : 747

Get Book Here

Book Description
This textbook focuses specifically on the combined topics of irrigation and drainage engineering. It emphasizes both basic concepts and practical applications of the latest technologies available. The design of irrigation, pumping, and drainage systems using Excel and Visual Basic for Applications programs are explained for both graduate and undergraduate students and practicing engineers. The book emphasizes environmental protection, economics, and engineering design processes. It includes detailed chapters on irrigation economics, soils, reference evapotranspiration, crop evapotranspiration, pipe flow, pumps, open-channel flow, groundwater, center pivots, turf and landscape, drip, orchards, wheel lines, hand lines, surfaces, greenhouse hydroponics, soil water movement, drainage systems design, drainage and wetlands contaminant fate and transport. It contains summaries, homework problems, and color photos. The book draws from the fields of fluid mechanics, soil physics, hydrology, soil chemistry, economics, and plant sciences to present a broad interdisciplinary view of the fundamental concepts in irrigation and drainage systems design.

Programming the Finite Element Method

Programming the Finite Element Method PDF Author: I. M. Smith
Publisher: John Wiley & Sons
ISBN: 9780471100980
Category : Civil engineering
Languages : en
Pages : 351

Get Book Here

Book Description


Construction Estimating Using Excel

Construction Estimating Using Excel PDF Author: Steven J. Peterson
Publisher: Prentice Hall
ISBN: 9780131719835
Category : Technology & Engineering
Languages : en
Pages : 0

Get Book Here

Book Description
For courses in Construction Estimating in two year and four year construction management programs. Construction Estimating with Excel introduces readers to the fundamental principles of estimating and includes drawing sets, real-world exercises, and examples that give beginners critical estimating experience. The book moves step-by-step through the estimating process, discussing the art of estimating, the quantity takeoff, how to put costs to the estimate and how to finalize the bid. It is also the first text to demonstrate how Microsoft Excel can be used to improve the estimating process. Because it introduces spreadsheets as a way of increasing estimating productivity and accuracy, the book can help both beginning and experienced estimators improve their skills.

Software Engineering Techniques Applied to Agricultural Systems

Software Engineering Techniques Applied to Agricultural Systems PDF Author: Petraq Papajorgji
Publisher: Springer Science & Business Media
ISBN: 0387281711
Category : Computers
Languages : en
Pages : 249

Get Book Here

Book Description
Software Engineering Techniques Applied to Agricultural Systems presents cutting-edge software engineering techniques for designing and implementing better agricultural software systems based on the object-oriented paradigm and the Unified Modeling Language (UML). The book is divided in two parts: the first part presents concepts of the object-oriented paradigm and the UML notation of these concepts, and the second part provides a number of examples of applications that use the material presented in the first part. The examples presented illustrate the techniques discussed, focusing on how to construct better models using objects and UML diagrams. More advanced concepts such as distributed systems and examples of how to build these systems are presented in the last chapter of the book. The book presents a step-by-step approach for modeling agricultural systems, starting with a conceptual diagram representing elements of the system and their relationships. Furthermore, diagrams such as sequential and collaboration diagrams are used to explain the dynamic and static aspects of the software system.

Engineering with Mathcad

Engineering with Mathcad PDF Author: Brent Maxfield
Publisher: Elsevier
ISBN: 008046694X
Category : Technology & Engineering
Languages : en
Pages : 521

Get Book Here

Book Description
Using the author's considerable experience of applying Mathcad to engineering problems, Engineering with Mathcad identifies the most powerful functions and features of the software and teaches how to apply these to create comprehensive engineering calculations. Many examples from a variety of engineering fields demonstrate the power and utility of Mathcad's tools, while also demonstrating how other software, such as Microsoft Excel spreadsheets, can be incorporated effectively. This simple, step-by-step approach makes this book an ideal Mathcad text for professional engineers as well as engineering and science students.A CD-ROM packaged with the book contains all the examples in the text and an evaluation version of the Mathcad software, enabling the reader to learn by doing and experiment by changing parameters.* Identifies the key Mathcad functions for creating comprehensive engineering calculations* A step-by-step approach enables easy learning for professional engineers and students alike* Includes a CD-ROM containing all the examples in the text and an evaluation version of the Mathcad software

Confronting Climate Uncertainty in Water Resources Planning and Project Design

Confronting Climate Uncertainty in Water Resources Planning and Project Design PDF Author: Patrick A. Ray
Publisher: World Bank Publications
ISBN: 1464804788
Category : Business & Economics
Languages : en
Pages : 149

Get Book Here

Book Description
Confronting Climate Uncertainty in Water Resources Planning and Project Design describes an approach to facing two fundamental and unavoidable issues brought about by climate change uncertainty in water resources planning and project design. The first is a risk assessment problem. The second relates to risk management. This book provides background on the risks relevant in water systems planning, the different approaches to scenario definition in water system planning, and an introduction to the decision-scaling methodology upon which the decision tree is based. The decision tree is described as a scientifically defensible, repeatable, direct and clear method for demonstrating the robustness of a project to climate change. While applicable to all water resources projects, it allocates effort to projects in a way that is consistent with their potential sensitivity to climate risk. The process was designed to be hierarchical, with different stages or phases of analysis triggered based on the findings of the previous phase. An application example is provided followed by a descriptions of some of the tools available for decision making under uncertainty and methods available for climate risk management. The tool was designed for the World Bank but can be applicable in other scenarios where similar challenges arise.

Practical Handbook of Material Flow Analysis

Practical Handbook of Material Flow Analysis PDF Author: Paul H. Brunner
Publisher: CRC Press
ISBN: 0203507207
Category : Technology & Engineering
Languages : en
Pages : 333

Get Book Here

Book Description
The first-ever book on this subject establishes a rigid, transparent and useful methodology for investigating the material metabolism of anthropogenic systems. Using Material Flow Analysis (MFA), the main sources, flows, stocks, and emissions of man-made and natural materials can be determined. By demonstrating the application of MFA, this book reveals how resources can be conserved and the environment protected within complex systems. The fourteen case studies presented exemplify the potential for MFA to contribute to sustainable materials management. Exercises throughout the book deepen comprehension and expertise. The authors have had success in applying MFA to various fields, and now promote the use of MFA so that future engineers and planners have a common method for solving resource-oriented problems.

Advances in Structural Engineering

Advances in Structural Engineering PDF Author: Vasant Matsagar
Publisher: Springer
ISBN: 8132221877
Category : Technology & Engineering
Languages : en
Pages : 1033

Get Book Here

Book Description
The book presents research papers presented by academicians, researchers, and practicing structural engineers from India and abroad in the recently held Structural Engineering Convention (SEC) 2014 at Indian Institute of Technology Delhi during 22 – 24 December 2014. The book is divided into three volumes and encompasses multidisciplinary areas within structural engineering, such as earthquake engineering and structural dynamics, structural mechanics, finite element methods, structural vibration control, advanced cementitious and composite materials, bridge engineering, and soil-structure interaction. Advances in Structural Engineering is a useful reference material for structural engineering fraternity including undergraduate and postgraduate students, academicians, researchers and practicing engineers.