Start reading Excel Scientific and Engineering Cookbook (Cookbooks on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here.

Deliver to your Kindle or other device

Enter a promotion code
or gift card
 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Sorry, this item is not available in
Image not available for
Color:
Image not available

To view this video download Flash Player

 

Excel Scientific and Engineering Cookbook (Cookbooks (O'Reilly)) [Kindle Edition]

David M. Bourg
4.1 out of 5 stars  See all reviews (15 customer reviews)

Digital List Price: $39.99 What's this?
Print List Price: $49.99
Kindle Price: $22.99
You Save: $27.00 (54%)

Formats

Amazon Price New from Used from
Kindle Edition $22.99  
Paperback $32.47  
Kindle Delivers
Kindle Delivers
Subscribe to the Kindle Delivers monthly e-mail to find out about each month's Kindle book deals, new releases, editors' picks and more. Learn more (U.S. customers only)

Book Description

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.


Customers Who Bought This Item Also Bought


Editorial Reviews

Book Description

Adding Excel to Your Analysis Arsenal

About the Author

As a naval architect and marine engineer, David M. Bourg performs computer simulations and develops analysis tools that measure such things as hovercraft performance and the effect of waves on the motion of ships and boats. He teaches at the college level in the areas of ship design, construction and analysis. On occasion, David also lectures at high schools on topics such as naval architecture and software development. In addition to David's practical engineering background, he's professionally involved in computer game development and consulting through his company, Crescent Vision Interactive.


Product Details

  • File Size: 10229 KB
  • Print Length: 446 pages
  • Simultaneous Device Usage: Unlimited
  • Publisher: O'Reilly Media; 1 edition (February 9, 2009)
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B0026OR3L2
  • Text-to-Speech: Enabled
  • X-Ray:
  • Lending: Not Enabled
  • Amazon Best Sellers Rank: #649,848 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


Customer Reviews

Most Helpful Customer Reviews
59 of 60 people found the following review helpful
5.0 out of 5 stars Great showcase of Excel's mathematical capabilities February 6, 2006
Format:Paperback
It is often either inconvenient or financially unfeasible to solve every mathematical problem with a standalone procedural language or an expensive application such as Matlab or Mathematica. Since Excel has such advanced computational capabilities built into it and is ubiquitous in offices and homes, it would make sense to mine this application for numerical problem solving techniques. Bourg does a masterful job of presenting the tools available in Excel and showing the reader how to put them to work to solve real world engineering and mathematical problems. First, he spends a couple of chapters briefly going over Excel and its language VBA (Visual Basic for Applications). Next he goes over some intermediate level tasks such as collecting and cleaning up data, charting including 3D charts, and statistical analysis tasks such as correlating data and generating random numbers. Next Bourg moves into purely mathematical tasks such as working with discrete Fourier transforms, manipulating matrices and vectors, as well as working with basic mathematical functions. Once you have learned to use these mathematical tools in Excel, Bourg uses them to show you how to perform curve fitting and regression, solve equations, perform integration and differentiation, and solve both ordinary and partial differential equations. He even spends time on performing multivariable calculus and the finite element method in Excel. Chapter 13, on optimization, was my favorite chapter. Here, Bourg is actually getting into a little algorithm analysis and design via linear programming and genetic algorithms. This chapter showed me some truly innovative uses of Excel. The final chapter deviates from the scientific flavor of the book and concentrates on more traditional financial applications. Read more ›
Comment | 
Was this review helpful to you?
27 of 29 people found the following review helpful
5.0 out of 5 stars A Numbers ExpLOsiOn!!! May 9, 2006
Format:Paperback
Wow what a great Cookbook!!!

No, I mean no sarcasm here at all. With all the books in O'Reilly's "Cookbooks" line, I find that it's really hit or miss. Sometimes the books are good, sometimes great, sometimes it's a big whiff.

Not here folks.

I can say without question that the 'Excel Scientific and Engineering Cookbook' by David Bourg is the BEST line in the Cookbook series I have read thus far. Neatly compact at just over 400 pages and full of actual, useful tips and tricks throughout, this is must read for anyone that uses the mathematical side of Excel and wants to learn how to take their car into the next gear!!

Covering graphs, charts, mathematical calculations, formula creation... you name it, it's here and then some!!

After reading this book you will be amazed at all the things you can do in Excel and I have little doubt that you will learn something new and ENJOY doing it while you take a bite out of this great manual!!

***** HIGHEST POSSIBLE RECOMMENDATION
Comment | 
Was this review helpful to you?
19 of 20 people found the following review helpful
5.0 out of 5 stars An engineer excel book dream March 22, 2006
Format:Paperback
I am very surprised that there are only 2 reviews here. This is a must have book for all engineering students. The book totally leverage all of excel powers commingled with vba. While other vba books talk about loops and looping, this book did that in just one chapter. The other chapters talk about all what engineering students want: solving and writing codes for non-linear equation (a must for solving for z factor in thermo), numerical differentiation, numerical integration, differential equations, partial differential equations, statistical analysis and valuable things about excel. Combined this book with any standard vba text, and you are set. Kudos to David Bourg.
Comment | 
Was this review helpful to you?
7 of 9 people found the following review helpful
Format:Paperback
Bourg's book is an excellent collection of analytical recipes suitable for undergraduates, graduate and postdocs in all scientific disciplines. Engineers will find good treatment of important topics such as optimization and numerical integration. Statistical analysis is also covered, although no theoretical background is provided, and in this format, none should be expected, as the author indicates. An excellent and useful book.
Comment | 
Was this review helpful to you?
8 of 11 people found the following review helpful
5.0 out of 5 stars Good examples, excellent source of ideas March 8, 2006
Format:Paperback
This book is good not just for the examples that are in here, but also for the ideas and techniques it gives you to solve your own unique problems. Each recipe describes the problem, presents a solution in screenshots and code, and then does a good job describing that solution. And through that the book teaches not only a specific solution, but also a generic approach that will help you solve other related problems.

An excellent resource. Highly recommended.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
Format:Paperback
I learned alot from this book. I learned how to use Excel to properly model complex mathametical calculations, and I rounded out some mathematics knowledge (eg PDE implementations, data smoothing via moving average).
there are a few areas that this book doesnt cover, which may be appropriate for scientific computing using Excel: 1) VSTO C# coding against Excel, 2) SQL Server Analysis Services integration with PowerPivot for Excel, 3)Excel Services and UDFs, 4) Solver Foundation, and 5) Windows HPC Excel Services for distrubted workbook processing.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
Format:Paperback
Regarding everyday simple math tools I was considered two things.

1. Sharable and somewhat powerful tool for numerical calculation.
2. Quick and easy way to compare and prove the results of expensive math tools.

I have thought EXCEL might be the best one. That's why I have bought and read this book.

I was delighted that I was right and this book was fun also. I'll point out just one thing how good it is for a mechanical engineer like me: "solver": the optimization tool and more. I have been looking for something like that tool since I started the graduate school.

Well, here maybe I am just telling I am so ignorant about the excel, but anyway I really enjoyed this book and I strongly recommend it.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Very thorough - good resource
There are a ton of valuable methods included in this book and the steps for implementing are very clear. Read more
Published 1 month ago by Mich_blizzard
5.0 out of 5 stars Excel Technical Cookbook
The book amended other books on the subject and should be considered. The cookbook is a good stepping stone for developing tie programs that are required for specific needs.
Published 8 months ago by Glen Beyer
5.0 out of 5 stars One of the best books ever
This book is the perfect companion if you want to use MS Excel for automated test reporting, calculations and all other stuff you usually do with more suitable tools. ;)
Published 10 months ago by Torq
5.0 out of 5 stars Excel Científica e Engenharia Cookbook
The Book Excel Científica e Engenharia Cookbook looks very good, only now should be to Office 2007 or 2010, because that is targeted for 2003. Read more
Published 15 months ago by Victor Brandao
1.0 out of 5 stars Excel is crap and this book should have told us why
Unfortunately, a book titled "Excel Scientific and Engineering Cookbook" should start off on page one with a warning not to rely on Excel statistical functions. Read more
Published 20 months ago by BrusselsSprout
3.0 out of 5 stars PROBLEM SOLUTION DISCUSSION
1.1 This Book

Problem

The entire book is written in this silly format.

Solution

If this sort of thing bothers you, buy something... Read more
Published on May 9, 2007 by C. Bailey
3.0 out of 5 stars Excel Cookbook Half Baked
It appears to be a good book but the writers style lacks substance. I could have written this book! Read more
Published on May 8, 2007 by Hockeyman
1.0 out of 5 stars an alternative point of view
Be wary of using other programmer's work unless it has passed the

sort of critical tests as available on the NIST site. Read more
Published on January 2, 2007 by Student
Search Customer Reviews
Only search this product's reviews

More About the Author

Discover books, learn about writers, read author blogs, and more.

What Other Items Do Customers Buy After Viewing This Item?



Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Look for Similar Items by Category


ARRAY(0xa4c35ef4)