Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel for Decision Making
Many years ago I used a software program called Decide Right that allowed a
user to enter outcomes (buy a honda, or buy the chevy, or buy the ford), a set of decision factors (costs the least, gets good gas mileage, easy to maintain), a way to weight the criteria (cost is more important then easy to maintain) and then a way to rate the factors against the outcomes (honda is "great" for gas but chevy is "good" for gas mileages), Are there any add ons or excel products for doing this kind of thing in excel? Thanks in advance bmac |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel for Decision Making
You can try the Solver add-in.
It is included with Excel but you will have to load it from Tools | add-ins The Excel help file has some useful info and there is a Solvsamp.xls workbook in the office/samples folder with multiple examples ready to go. Pack a lunch. -- Jim Cone Portland, Oregon USA "bmac" wrote in message Many years ago I used a software program called Decide Right that allowed a user to enter outcomes (buy a honda, or buy the chevy, or buy the ford), a set of decision factors (costs the least, gets good gas mileage, easy to maintain), a way to weight the criteria (cost is more important then easy to maintain) and then a way to rate the factors against the outcomes (honda is "great" for gas but chevy is "good" for gas mileages), Are there any add ons or excel products for doing this kind of thing in excel? Thanks in advance bmac |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel for Decision Making
Thanks very much,
"Jim Cone" wrote: You can try the Solver add-in. It is included with Excel but you will have to load it from Tools | add-ins The Excel help file has some useful info and there is a Solvsamp.xls workbook in the office/samples folder with multiple examples ready to go. Pack a lunch. -- Jim Cone Portland, Oregon USA "bmac" wrote in message Many years ago I used a software program called Decide Right that allowed a user to enter outcomes (buy a honda, or buy the chevy, or buy the ford), a set of decision factors (costs the least, gets good gas mileage, easy to maintain), a way to weight the criteria (cost is more important then easy to maintain) and then a way to rate the factors against the outcomes (honda is "great" for gas but chevy is "good" for gas mileages), Are there any add ons or excel products for doing this kind of thing in excel? Thanks in advance bmac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Excel contain a decision tree analysis? | Excel Worksheet Functions | |||
decision tree in excel??? | Excel Discussion (Misc queries) | |||
Decision Matrix with multiple criteria and decision | Charts and Charting in Excel | |||
making a decision tree using excel! | Excel Discussion (Misc queries) | |||
How to I make a decision using excel? | Excel Discussion (Misc queries) |