We see that javascript is disabled or not supported by your browser - javascript is needed for important actions on the site. Read more

What's New - Home - Login

Member $avings: $81,595,742.75 | Books Available: 790,292 | Members Online: 88

Swap Used Books - Buy New Books at Great Prices!

How To Swap Books Sign Up Search submenu

PBS Market (New Books)

Gift Buying Guide

Book Browser Advanced Search Books Posted Today Member Book Reviews Award Winning Books NYT Best Sellers Amazon Best Sellers Most Traveled Copies Club Wish List

Discussion Forums Book Lists

Club Lists My Book Lists My Watched Lists Create a List

Blog Donations

School Donation Program In Memory of... Military Donation Program Friends of PBS

Box-O-Books Maps The Eclectic Pen Fun Stuff

20 Questions Sudoku Bookmark Creator

Top 100

Requests Posts Swappers Referrers Reviewers

Pulse of PBS Spread The Word

Invite Friends Bookmarks Facebook Page Facebook App More Ways...

Photo Gallery Recipes Club Tag Cloud Member Testimonials

Help Center submenu

How To Swap Books Browse Help Docs Ask the Librarian PBS Member Icons Live Help

Kiosk

PBS Market (New Books) Go Shopping Buy Credits Buy PBS Money Upgrade Membership Gift Certificates Transfer Credits

Need Help?

Search - Step-By-Step Optimization With Excel Solver - the Excel Statistical Master

StepByStep Optimization With Excel Solver the Excel Statistical Master
Author: Mark Harmon

For anyone who wants to be operating at a high level with the Excel Solver quickly, this is the book for you. Step-By-Step Optimization With Excel Solver is more than 200+ pages of simple yet thorough explanations on how to use the Excel Solver to solve today's most widely known optimization problems. Loaded with screen shots that are coupled wi... more »th easy-to-follow instructions, this book will simplify many difficult optimization problems and make you a master of the Excel Solver almost immediately. Here are just some of the Solver optimization problems that are solved completely with simple-to-understand instructions and screen shots in this book: ? The famous "Traveling Salesman" problem using Solver's Alldifferent constraint and the Solver's Evolutionary method to find the shortest path to reach all customers. This also provides an advanced use of the Excel INDEX function. ? The well-known "Knapsack Problem" which shows how optimize the use of limited space while satisfying numerous other criteria. ? How to perform nonlinear regression and curve-fitting on the Solver using the Solver's GRG Nonlinear solving method. ? How to solve the "Cutting Stock Problem" faced by many manufacturing companies who are trying to determine the optimal way to cut sheets of material to minimize waste while satisfying customer orders. ? Portfolio optimization to maximize return or minimize risk. ? Venture capital investment selection using the Solver's Binary constraint to maximize Net Present Value of selected cash flows at year 0. Clever use of the If-Then-Else statements makes this a simple problem. ? How use Solver to minimize the total cost of purchasing and shipping goods from multiple suppliers to multiple locations. ? How to optimize the selection of different production machine to minimize cost while fulfilling an order. ? How to optimally allocate a marketing budget to generate the greatest reach and frequency or number of inbound leads at the lowest cost. Step-By-Step Optimization With Excel Solver has complete instructions and numerous tips on every aspect of operating the Excel Solver. You'll fully understand the reports and know exactly how to tweek all of the Solver's settings for total custom use. The book also provides lots of inside advice and guidance on setting up the model in Excel so that it will be as simple and intuitive as possible to work with. All of the optimization problems in this book are solved step-by-step using a 6-step process that works every time. In addition to detailed screen shots and easy-to-follow explanations on how to solve every optimization problem in the book, a link is provided to download an Excel workbook that has all problems completed exactly as they are in this book. Step-By-Step Optimization With Excel Solver is exactly the book you need if you want to be optimizing at an advanced level with the Excel Solver quickly.

ISBN-13: 9781937159122
ISBN-10: 1937159124
Publication Date: 9/30/2011
Pages: 238
Rating:

0 stars, based on 0 rating

Publisher: Excel Master Series
Book Type: Paperback
Members Wishing: 0
Reviews: Amazon | Write a Review

Genres:

Back to the Top ↑

Search - Step-By-Step Optimization With Excel Solver - the Excel Statistical Master

Loading...