ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linear Programming (https://www.excelbanter.com/excel-discussion-misc-queries/4465-linear-programming.html)

Franklin

Linear Programming
 
In Excel how do you set up a 3 variable linear programming
problem on a spreadsheet with a a number of constaints
using Solver?

Michael R Middleton

Franklin -

See the tutorials and examples at www.solver.com.

Or, search your drive for the file solvsamp.xls, which is installed when
Solver is installed and which has a 3-variable nonlinear example that is
easily converted to linear.

- Mike

www.mikemiddleton.com

+++++++++++++++++++

"Franklin" wrote in message
...
In Excel how do you set up a 3 variable linear programming
problem on a spreadsheet with a a number of constaints
using Solver?





All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com