Engineering with the Spreadsheet: Structural Engineering Templates Using Excel

Please Disable Adblock to Show Download Link
DOWNLOAD eBooks
Author : Craig T. Christy
Genre : Technology & Engineering

Summary : Today, the spreadsheet is an essential tool for engineers. More than 20 years ago, Craig Christy started using a spreadsheet as a way of keeping notes. His practice has evolved into Engineering with the Spreadsheet, a valuable manual for engineers working with Excel. Christy first introduces basic spreadsheet techniques and more advanced applications that may be unfamiliar to even experienced spreadsheet users. He then applies Excel spreadsheets in preparing engineering calculations for an exhaust stack and an elevated storage tank. The book and CD-ROM present more than 50 actual templates in Microsoft Excel that demonstrate the techniques and specific applications for concrete, wind and seismic issues, foundation soil loading, the vortex shedding of tall stacks, and other engineering issues. Beneficial to professional engineers and college students alike, Engineering with the Spreadsheet is a comprehensive manual that structural engineers will use on their next projects.

Please Disable Adblock to Show Download Link
DOWNLOAD eBooks
Author : Dr. Robert Mote
Genre : Science

Summary : About the Book Calculations are the bedrock of the worldwide engineering profession. Unfortunately, engineers often struggle to translate their engineering designs into coherent spreadsheets. Preparing calculations is becoming a considerable issue in engineering project activities worldwide. For most engineers, Microsoft Excel is a style choice. This book introduces Microsoft Excel to the practicing professional engineer and show how Microsoft Excel can become the extended calculator of choice for engineers everywhere. The techniques in this book are invaluable for any engineer looking for a professional and visual layout without having to become an expert in Microsoft Excel. Only ten percent of the power of Microsoft Excel is required to unleash the full potential for effective spreadsheets. This book looks at the psychology of the engineering mind today in the computer age. Over a relatively short period, specifically ten to fifteen years, computers have transformed the engineering profession, the marketplace, the project execution in the drawing office and field, and permitted bad habits to continue unchecked. The book demonstrates the technique through a series of eight modules. Each module takes you through engineering spreadsheet examples using only common commands, based on Microsoft Excel 2003. It is the second in the Mote Method series, which is designed to encourage the engineer to improve his or her PC proficiency in order to pursue engineering excellence. Thus, the limitations of engineering tools commonly used will be surpassed. The commercial and professional benefits of applying these ideas are substantial in saving time, improving productivity, and enhancing Quality Assurance and Quality Control (QA/QC) activities. The benefits of learning and applying the technique are numerous, specifically in positive, time-saving habits. The technique is also future-proof, quality-driven, consistent, effective for repetitive work, efficient for all parties to follow, interesting, and educational.

Please Disable Adblock to Show Download Link
DOWNLOAD eBooks
Author : Robert Sogge
Genre : Technology & Engineering

Summary : 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.

Please Disable Adblock to Show Download Link
DOWNLOAD eBooks
Author : S. R. Davies
Genre : Computers

Summary : Spreadsheets in Structural Design provides a unique and highly practical explanation of the use of spreadsheets to facilitate the design of structures in a range of key materials, such as concrete, steel and brick. Using spreadsheets in this way has important implications in terms of cost and efficiency, and represents a very useful tool hitherto largely neglected by the design community. Each chapter contains spreadsheet layouts to illustrate the method, drawn from different areas of design and using a range of materials and Codes of Practice. Examples used relate to reinforced concrete, reinforced masonry and steel but the approach is easily extended to other materials and other fields of design. Practising structural engineers, civil engineers and architects will find this book an invaluable guide for the solution of routine design problems. It is also useful reading for advanced undergraduate and postgraduate students of structural design, civil engineering and architecture.

Please Disable Adblock to Show Download Link
DOWNLOAD eBooks
Author : David Chadderton
Genre : Architecture

Summary : Building Services Engineering Spreadsheets is a versatile, user friendly tool for design calculations. Spreadsheet application software is readily understandable since each formula is readable in the location where it is used. Each step in the development of these engineering solutions is fully explained. The book provides study material in building services engineering and will be valuable both to the student and to the practising engineer. It deals with spreadsheet use, thermal transmittance, building heat loss and heat gain, combustion analysis, fan selection, air duct design, water pipe sizing, lumen lighting design, electrical cable sizing, at a suitable level for practical design work. Commercially available software, while very powerful and comprehensive, does not allow the user any facility to look into the coded instructions. The user has to rely upon the supplier for explanation, updates and corrections. The advantage that the spreadsheet applications provided with the book have over purchased dedicated software, is that the user can inspect everything that the program undertakes. Parts of the worksheets can be copied to other cells in order to expand the size of each worksheet. Experienced spreadsheet operators can edit the cells to change the way in which data and calculations are used, and with guidance from the explanatory, build their own applications.

Please Disable Adblock to Show Download Link
DOWNLOAD eBooks
Author : John-Michael Wong
Genre :

Summary :

Please Disable Adblock to Show Download Link
DOWNLOAD eBooks
Author :
Genre : Academic libraries

Summary :