Excel Scientific and Engineering Cookbook

The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve ...


Author: David M Bourg

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596553173

Category: Computers

Page: 446

View: 762

Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.

Excel for Scientists and Engineers

Ayyub, Bilal M. and Richard H. McCuen, Numerical Methods for Engineers, Prentice-Hall, 1996. Bourg, David M., Excel Scientific and Engineering Cookbook, O'Reilly, 2006. Chapra, Steven C. and Raymond P. Canale, Numerical Methods for ...


Author: E. Joseph Billo

Publisher: John Wiley & Sons

ISBN: 9780470126707

Category: Computers

Page: 480

View: 247

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's® capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices Find roots of equations and solve systems of simultaneous equations Solve ordinary differential equations and partial differential equations Perform linear and non-linear regression Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: All the spreadsheets, charts, and VBA code needed to perform the examples from the text Solutions to most of the end-of-chapter problems An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package

Proceedings of the 1st World Congress on Integrated Computational Materials Engineering ICME

E. J . Billo, Excel for Scientists and Engineers, J. Wiley & Sons, New York, 2007 D. M. Bourg, Excel Scientific and Engineering Cookbook, O'Reilly Media, Sebastopol CA, 2006. S. C. Bloch, Excel for Engineers and Scientists, 2nd Ed., ...


Author: The Minerals, Metals & Materials Society (TMS)

Publisher: John Wiley & Sons

ISBN: 9781118147719

Category: Science

Page: 275

View: 802

In its most advanced form, Integrated Computational Materials Engineering (ICME) holistically integrates manufacturing simulation, advanced materials models and component performance analysis. This volume contains thirty-five papers presented at the 1st World Congress on Integrated Computational Materials Engineering. Modeling processing-microstructure relationships, modeling microstructure-property relationships, and the role of ICME in graduate and undergraduate education are discussed. Ideal as a primary text for engineering students, this book motivates a wider understanding of the advantages and limitations offered by the various computational (and coordinated experimental) tools of this field.

Excel for Engineers and Scientists

Covers new functions and operations in EXCEL 2002 (Microsoft Office XP). Contains more than 80 example workbooks on the included CD. Explore, modify, and edit these workbooks to gain a hands-on learning experience.


Author: S. C. Bloch

Publisher: John Wiley & Sons Incorporated

ISBN: STANFORD:36105132078119

Category: Computers

Page: 308

View: 461

In this basic introduction, the author aims to help engineers and scientists to understand and use Excel in their fields. The book is interactive and designed to be used in conjunction with a computer, to provide a hands-on learning experience.

Head First Excel

Other related books from O'Reilly Head First Data Analysis Analyzing Business Data with Excel Excel Scientific and Engineering Cookbook Access Data Analysis Cookbook Other books in O'Reilly's Head First series Head First JavaTM Head ...


Author: Michael Milton

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449370091

Category: Computers

Page: 448

View: 227

Do you use Excel for simple lists, but get confused and frustrated when it comes to actually doing something useful with all that data? Stop tearing your hair out: Head First Excel helps you painlessly move from spreadsheet dabbler to savvy user. Whether you're completely new to Excel or an experienced user looking to make the program work better for you, this book will help you incorporate Excel into every aspect of your workflow, from a scratch pad for data-based brainstorming to exploratory analysis with PivotTables, optimizing outcomes with Goal Seek, and presenting your conclusions with sophisticated data visualizations. Organize and clearly present information in a spreadsheet Make calculations across a number of worksheets Change your point of view with sorting, zooming, and filtering Manipulate numerical data to extract and use just what you need Leverage Excel as a grid-based layout program Write formulas for optimal functionality Nest formulas for more complex operations Create sophisticated data visualizations with charts and graphs Use Goal Seek to optimize possible outcomes based on different assumptions Create summaries from large data sets for exploratory data analysis with PivotTables We think your time is too valuable to waste struggling with new concepts. Using the latest research in cognitive science and learning theory to craft a multi-sensory learning experience, Head First Excel uses a visually rich format designed for the way your brain works, rather than a text-heavy approach that will put you to sleep.

Excel Hacks

Related titles Hacks Series Home Excel 2007: The Missing Manual Office 2007: The Missing Manual Excel Scientific and Engineering Cookbook WritingExcel Macroswith VBA Windows XP Hacks Access Hacks Word Hacks SQL Hacks  ...


Author: David Hawley

Publisher: "O'Reilly Media, Inc."

ISBN: 0596555288

Category: Computers

Page: 412

View: 286

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks -- clever tools, tips and techniques -- that will leapfrog your work beyond the ordinary. Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to: Reduce workbook and worksheet frustration -- manage how users interact with worksheets, find and highlight information, and deal with debris and corruption. Analyze and manage data -- extend and automate these features, moving beyond the limited tasks they were designed to perform. Hack names -- learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet. Get the most out of PivotTables -- avoid the problems that make them frustrating and learn how to extend them. Create customized charts -- tweak and combine Excel's built-in charting capabilities. Hack formulas and functions -- subjects range from moving formulas around to dealing with datatype issues to improving recalculation time. Make the most of macros -- including ways to manage them and use them to extend other features. Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook. You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.

Vehicle Accident Analysis and Reconstruction Methods

Brach, R.M., Mechanical Impact Dynamics (New York: John Wiley & Sons, 1991); Also Available at Brach Engineering ... Bourg, D.M., Excel Scientific and Engineering Cookbook (Sebastopol, CA: O'Reilly Media, 2006) ...


Author: Matthew Brach

Publisher: SAE International

ISBN: 9781468603453

Category: Technology & Engineering

Page: 596

View: 866

In this third edition of Vehicle Accident Analysis Reconstruction Methods, Raymond M. Brach and R. Matthew Brach have expanded and updated their essential work for professionals in the field of accident reconstruction. Most accidents can be reconstructed effectively using of calculations and investigative and experimental data: the authors present the latest scientific, engineering, and mathematical reconstruction methods, providing a firm scientific foundation for practitioners. Accidents that cannot be reconstructed using the methods in this book are rare.In recent decades, the field of crash reconstruction has been transformed through the use of technology. The advent of event data records (EDRs) on vehicles signaled the era of modern crash reconstruction, which utilizes the same physical evidence that was previously available as well as electronic data that are measured/captured before, during, and after the collision. There is increased demand for more professional and accurate reconstruction as more crash data is available from vehicle sensors. The third edition of this essential work includes a new chapter on the use of EDRs as well as examples using EDR data in accident reconstruction.Early chapters feature foundational material that is necessary for the understanding of vehicle collisions and vehicle motion; later chapters present applications of the methods and include example reconstructions. As a result, Vehicle Accident Analysis Reconstruction Methods remains the definitive resource in accident reconstruction.

Head First Data Analysis

Other related books from O'Reilly Analyzing Business Data with Excel Excel Scientific and Engineering Cookbook Access Data Analysis Cookbook Other books in O'Reilly's Head First series Head First Java Head First Object-Oriented Analysis ...


Author: Michael Milton

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449368333

Category: Computers

Page: 486

View: 916

Today, interpreting data is a critical decision-making factor for businesses and organizations. If your job requires you to manage and analyze all kinds of data, turn to Head First Data Analysis, where you'll quickly learn how to collect and organize data, sort the distractions from the truth, find meaningful patterns, draw conclusions, predict the future, and present your findings to others. Whether you're a product developer researching the market viability of a new product or service, a marketing manager gauging or predicting the effectiveness of a campaign, a salesperson who needs data to support product presentations, or a lone entrepreneur responsible for all of these data-intensive functions and more, the unique approach in Head First Data Analysis is by far the most efficient way to learn what you need to know to convert raw data into a vital business tool. You'll learn how to: Determine which data sources to use for collecting information Assess data quality and distinguish signal from noise Build basic data models to illuminate patterns, and assimilate new information into the models Cope with ambiguous information Design experiments to test hypotheses and draw conclusions Use segmentation to organize your data within discrete market groups Visualize data distributions to reveal new relationships and persuade others Predict the future with sampling and probability models Clean your data to make it useful Communicate the results of your analysis to your audience Using the latest research in cognitive science and learning theory to craft a multi-sensory learning experience, Head First Data Analysis uses a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep.

Smart Grids

... Excel Scientific and Engineering Cookbook, O'Reilly, Sebastopol CA, 2006. W. Hardle, M. Muller, S. Sperlich, and A. Werwatz, Nonparametric and Semi-parametric Models, Springer, Berlin, 2004. W. Li, Architecture design and ...


Author: David Bakken

Publisher: CRC Press

ISBN: 9781351831413

Category: Science

Page: 466

View: 482

The utilization of sensors, communications, and computer technologies to create greater efficiency in the generation, transmission, distribution, and consumption of electricity will enable better management of the electric power system. As the use of smart grid technologies grows, utilities will be able to automate meter reading and billing and consumers will be more aware of their energy usage and the associated costs. The results will require utilities and their suppliers to develop new business models, strategies, and processes. With an emphasis on reducing costs and improving return on investment (ROI) for utilities, Smart Grids: Clouds, Communications, Open Source, and Automation explores the design and implementation of smart grid technologies, considering the benefits to consumers as well as businesses. Focusing on industrial applications, the text: Provides a state-of-the-art account of the smart grid Explains how smart grid technologies are currently being used Includes detailed examples and test cases for real-life implementation Discusses trade-offs associated with the utilization of smart grid technologies Describes smart grid simulation software and offers insight into the future of the smart grid The electric power grid is in the early stages of a sea of change. Nobody knows which business models will survive, but companies heeding the lessons found in Smart Grids: Clouds, Communications, Open Source, and Automation might just increase their chances for success.

Practical Volumetric Analysis

D. M. Bourg, Excel Scientific and Engineering Cookbook, O'Reilly Media Inc., California (USA), 2006. E. Steiner, The Chemistry Maths Book, Oxford University Press, Oxford (UK), 2nd edn, 2008. J. D. Faires and R. L. Burden, ...


Author: Peter McPherson

Publisher: Royal Society of Chemistry

ISBN: 9781849739146

Category: Science

Page: 332

View: 175

Proficiency in volumetric analysis is a key skill for chemists in research and industry. This work seeks to 'modernise' approaches to volumetric analysis, by relating practical work to vocationally-relevant topics, whilst maintaining the rigor required for satisfactory performance in practical examinations. Written by someone who has experienced both teaching and working as a research chemist, this up to date textbook on practical volumetric analysis will provide the theoretical chemistry associated with volumetric analysis supported by a selection of practicals. There will also be suggestions for a number of investigations which could form the basis of project-based learning or coursework, particularly for those pursing vocational science courses. Section 1 will consist of three theory chapters, covering preliminary concepts (fundamentals of chemistry, essential quantitative chemistry and concepts of statistics). Section 2 will be divided into four chapters, based on the four main divisions of volumetric analysis (acid-base titrimetry, redox titrimetry, precipitation titrimetry and complexometric titrimetry). Each chapter in this section will start with a review of essential theory, with worked examples and illustrations where appropriate, and end with a selection of laboratory practicals. Each chapter will also contain a number of open-ended investigations, for use in project-based learning or coursework. Section 3 will address more advanced topics and be divided into four chapters (volumetric analysis in industry, further statistical concepts, mathematics of titrimetry and advanced titrimetry). Practical work and suggestions for further reading will be included where appropriate. Practical Volumetric Analysis is suitable for students taking modules in introductory chemistry and analytical chemistry on undergraduate degree courses as well as providing guidance to non-specialists teaching chemistry.