->
Lynda - Solving Optimization and Scheduling Problems in Excel - 373089
Lynda - Solving Optimization and Scheduling Problems in Excel
Learn how to use Solver, a free Excel add-in, to find optimal solutions to problems with multiple constraints, including linear and nonlinear mixtures, transportation problems, and scheduling conflicts. Along the way, author Curt Frye shows how to organize Excel worksheets for use with Solver, add and swap data, and set each problem's criteria in Solver. In the final chapter, you'll learn how to analyze Solver's results, create scenarios, and change parameters by hand.


Table of Contents

  • Introduction
  • 1. Working with Solver
  • 2. Solving a Linear Mixture Problem
  • 3. Solving a Nonlinear Mixture Problem
  • 4. Solving a Transportation Problem
  • 5. Solving a Resource Scheduling Optimization Problem
  • 6. Solving a Sports Scheduling Problem
  • 7. Analyzing Your Solver Results
  • Conclusion
  • Lynda - Solving Optimization and Scheduling Problems in Excel


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss