Spreadsheet Problem Solving and Programming for Engineers and Scientists

Spreadsheet Problem Solving and Programming for Engineers and Scientists

Author: David E. Clough

Publisher: CRC Press

Published: 2023-10-19

Total Pages: 452

ISBN-13: 1000966275

DOWNLOAD EBOOK

1) Provides a unique contribution to a gap in the market, presenting a comprehensive guide to spreadsheet use for modern engineers 2) Builds on decades of teaching experience from two experts in the field 3) Introduces Visual Basic for Applications and macros 4) Includes topics such as Numerical applications and applied statistics.


An Introduction to Excel for Civil Engineers

An Introduction to Excel for Civil Engineers

Author: Gunthar Pangaribuan

Publisher: Createspace Independent Publishing Platform

Published: 2016-08-16

Total Pages: 386

ISBN-13: 9781537137711

DOWNLOAD EBOOK

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!


Building Services Engineering Spreadsheets

Building Services Engineering Spreadsheets

Author: David Chadderton

Publisher: Routledge

Published: 2002-09-11

Total Pages: 334

ISBN-13: 1135811873

DOWNLOAD EBOOK

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.


Engineering with Excel

Engineering with Excel

Author: Ronald W. Larsen

Publisher: Prentice Hall

Published: 2009

Total Pages: 697

ISBN-13: 0136017754

DOWNLOAD EBOOK

For introductory courses in Engineering and Computing Based on Excel 2007, Engineering with Excel, 3e takes a comprehensive look at using Excel in engineering. This book focuses on applications and is intended to serve as both a textbook and a reference for students.


Liengme's Guide to Excel 2016 for Scientists and Engineers

Liengme's Guide to Excel 2016 for Scientists and Engineers

Author: Bernard Liengme

Publisher: Academic Press

Published: 2019-08-14

Total Pages: 416

ISBN-13: 0128182504

DOWNLOAD EBOOK

Liengme's Guide to Excel 2016 for Scientists and Engineers is a completely updated guide for students, scientists, and engineers who want to use Microsoft Excel 2016 to its full potential, whether you're using a PC or a Mac. Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis, and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data. - Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with Microsoft Office release of Excel 2016. - Features of Excel 2016 are illustrated through a wide variety of examples based on technical contexts, demonstrating the use of the program for analysis and presentation of experimental results. - Where appropriate, demonstrates the differences between the PC and Mac versions of Excel. - Includes many new end-of-chapter problems at varying levels of difficulty.


Modelling Physics with Microsoft Excel

Modelling Physics with Microsoft Excel

Author: Bernard V Liengme

Publisher: Morgan & Claypool Publishers

Published: 2014-10-01

Total Pages: 95

ISBN-13: 1627054197

DOWNLOAD EBOOK

This book demonstrates some of the ways in which Microsoft Excel® may be used to solve numerical problems in the field of physics. But why use Excel in the first place? Certainly, Excel is never going to out-perform the wonderful symbolic algebra tools tha


Integrated Natural Resources Research

Integrated Natural Resources Research

Author: Lawrence K. Wang

Publisher: Springer Nature

Published: 2021-07-21

Total Pages: 651

ISBN-13: 3030610020

DOWNLOAD EBOOK

This book is a sister volume to Volume 20 of the Handbook of Environmental Engineering Series, "Integrated Natural Resources Management", and expands on the themes of that volume by addressing the conservation and protection of natural resources in an environmental engineering context through state-of-the-art research methodologies and technologies. With a focus on water and wastewater treatment, the book takes a multidisciplinary approach to provide readers with an understanding of developments in natural resources technology over the last few decades, and how technology and industry methods will progress to ensure cleaner and sustainable methods of natural resources management. The key topics covered include biological activated carbon treatment for recycling biotreated wastewater, composting for food processing wastes, treatment of wastewater from chemical industries, agricultural waste as a low-cost adsorbent, and the invention, design and construction of potable water dissolved air flotation and filtration plants. The book will be useful to environmental resources engineers, researchers, water treatment plant managers, chemical engineers, industrial plant managers, and environmental conservation agencies.


Spreadsheets in Science and Engineering

Spreadsheets in Science and Engineering

Author: Gordon Filby

Publisher: Springer Science & Business Media

Published: 2013-12-18

Total Pages: 306

ISBN-13: 3642802494

DOWNLOAD EBOOK

"Spreadsheets in Science and Engineering" shows scientists and engineers at all levels how to analyze, validate and calculate data and how the analytical and graphic capabilities of spreadsheet programs (ExcelR) can solve these tasks in their daily work. The examples on the CD-ROM accompanying the book include material of undergraduate to current research level in disciplines ranging from chemistry and chemical engineering to molecular biology and geology.


Introduction to Infrastructure

Introduction to Infrastructure

Author: Michael R. Penn

Publisher: John Wiley & Sons

Published: 2011-12-13

Total Pages: 473

ISBN-13: 0470411910

DOWNLOAD EBOOK

Introduction to Infrastructure: An Introduction to Civil and Environmental Engineering breaks new ground in preparing civil and environmental engineers to meet the challenges of the 21st century. The authors use the infrastructure that is all around us to introduce students to civil and environmental engineering, demonstrating how all the parts of civil and environmental engineering are interrelated to help students see the "big picture" in the first or second year of the curriculum. Students learn not only the what of the infrastructure, but also the how and the why of the infrastructure. Readers learn the infrastructure is a system of interrelated physical components, and how those components affect, and are affected by, society, politics, economics, and the environment. Studying infrastructure allows educators and students to develop a valuable link between fundamental knowledge and the ability to apply that knowledge, so students may translate their knowledge to new contexts. The authors' implementation of modern learning pedagogy (learning objectives, concrete examples and cases, and hundreds of photos and illustrations), and chapters that map well to the ABET accreditation requirements AND the ASCE Civil Engineering Body of Knowledge 2nd edition (with recommendations for using this text in a 1, 2, or 3 hour course) make this text a key part of any civil and/or environmental engineering curriculum.