Decision making tool for Excel

[bmac]

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

 

[Gary''s Student]

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

trade study template excel

 

[Mike Middleton]

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