Digital List Price: $39.99
Kindle Price: $22.99

Save $27.00 (54%)

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Deliver to your Kindle or other device

Deliver to your Kindle or other device

Flip to back Flip to front
Audible Narration Playing... Paused   You are listening to a sample of the Audible narration for this Kindle book.
Learn more

Get the Free Kindle App

Enter email or phone number to get a link

Processing your request...

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

16 customer reviews

Amazon Price New from Used from
Kindle
"Please retry"
$22.99

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

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 (January 17, 2006)
  • Publication Date: February 9, 2009
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B0026OR3L2
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Lending: Not Enabled
  • Enhanced Typesetting: Not Enabled
  • Amazon Best Sellers Rank: #720,823 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

60 of 61 people found the following review helpful By calvinnme HALL OF FAMETOP 1000 REVIEWERVINE VOICE on 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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
28 of 30 people found the following review helpful By Dan McKinnon VINE VOICE on 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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
19 of 20 people found the following review helpful By A. Adebamiro on 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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 9 people found the following review helpful By Yannick Pouliot on July 29, 2006
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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 11 people found the following review helpful By Jack D. Herrington on 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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
Recognizing the limitations of Excel...this is very useful if your unable to gain access to better tools (matlab/octave, python, ANSI C, fortran, etc.) for engineering computing due to policy, budget or other constraints. You will, generally speaking get Excel, and this book is an excellent eye-opener to so of the things you can get done in it. It's not a comprehensive power users manual nor a complete how-to-code textbook in Visual Basic for Applications (VBA). Rather it is a good book to flip through for great non-trivial and representative examples to showcase what you CAN do should you be shackled to Excel only. The author treats some of the examples in multiple approaches and gives many avenues to working some of the problems; some by conventional spreadsheet work, some by using the solver and other add-in tools, and some by writing some VBA code. Some example "recipes" covered are: equation solving (linear and non-), numerical integration, ODE's, PDE's and optimization. There is also useful coverage of advanced graphing and plotting in excel, data importation, basic statistics overview, basic VBA essentials, and so forth. Again the book does not give a comprehensive overview but showcases what Excel can do with a selection of intelligently chose case studies.

Some particularly useful techniques are automating goal-seek and/or solver with VBA codes, solving systems of linear equations, numerical integration using Euler and 4th order runga kutta both with and without VBA codes, and use of linear programming and genetic algorithms within Excel to optimize.

Note: the website also has the example spreadsheets (with attendant VBA codes; "http://shop.oreilly.com/product/9780596008796.do" on righthand margin under the link "Download Example Code" ) for download as a companion to the book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


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