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 weigh the criteria (cost is more important than 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 mileage, etc.),

Are there any add ons or excel products for doing this kind of thing in excel?

Thanks in advance

bmac

You want to perform a system engineering task called a Trade Study. Google:

trade study template excel
--
Gary''s Student - gsnu200859


"bmac" wrote:

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 weigh the criteria (cost is more important than 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 mileage, etc.),

Are there any add ons or excel products for doing this kind of thing in excel?

Thanks in advance

bmac

bmac -

I have a rough draft of a chapter for a forthcoming book that describes how
to do multiattribute utility using Excel features, along with sensitivity
analysis. I'll send a PDF file if you provide an email address.

- Mike

http://www.MikeMiddleton.com


"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 weigh the criteria (cost is more important than 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 mileage, etc.),

Are there any add ons or excel products for doing this kind of thing in
excel?

Thanks in advance

bmac