A review of simple multiple criteria decision analytic procedures which are implementable on spreadsheet packages

A number of modern multi-criteria decision making aids for the discrete choice problem, are reviewed, with particular emphasis on those which can be implemented on standard commercial spreadsheet packages. Three broad classes of procedures are discussed, namely the analytic hierarchy process, reference point methods, and outranking methods. The broad principles are summarized in a consistent framework, and indications are given as to the practical aspects of implementing these on a spreadsheet. LOTUS spreadsheets implementing these are available from the author.