Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solver examples
Hi Guys,
I just want to ask our experts in excel on how can build a solver template that goes by specifying certain percetage (mix %) for each model/part and then arriving to a total sales (max out) and minimizing our cost productions. Also, can it be applied in VBA? I really want this template to look like a tool to be use in our department/office. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solver examples
moniong -
I suggest you start by looking at the machine allocation and process selection models available on Solver's web site. Browse to www.solver.com, click the Solutions tab at the top of the web page, and click Production from the drop-down menu. Then download the Production Examples workbook. Or, get it directly from http://www.solver.com/solutions/Prod...20Examples.xls You can control Solver using VBA. For information, browse to www.google.com, and search for "excel solver vba" (without the quotes). There are many resources available. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "moniong" wrote in message ... Hi Guys, I just want to ask our experts in excel on how can build a solver template that goes by specifying certain percetage (mix %) for each model/part and then arriving to a total sales (max out) and minimizing our cost productions. Also, can it be applied in VBA? I really want this template to look like a tool to be use in our department/office. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
STDEV EXAMPLES RELATED TO HR | Excel Discussion (Misc queries) | |||
Need Better Examples for VLOOKUP and the like | Excel Worksheet Functions | |||
Excel VBA examples | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
about examples | New Users to Excel |