Bibliography

  • Carlsson, Christer, and Pirkko Walden. “AHP in Political Group Decisions: A Study in the Art of Possibilities,” Interfaces 25, 4 (July 1995): 14–29.

  • Durso, A., and S. Donahue. “An Analytic Approach to Reshaping the United States Army,” Interfaces 25, 1 (January–February 1995): 109–133.

  • Goh, Chon. “AHP for Robot Selection,” Journal of Manufacturing Systems (January 1997): 381–387.

  • Islei, Gerd, Geoff Lockett, Barry Cox, Steve Gisbourne, and Mike Stratford. “Modeling Strategic Decision Making and Performance Measurements at ICI Pharmaceuticals,” Interfaces 21, 6 (November–December 1991): 4–22.

  • Kang, Moonsig and Antonie Stam “PAHAP: A Pairwise Aggregated Hierarchical Analysis of Ration-Scale Preferences,” Decision Sciences 25 (July 1994): 607–624.

  • Koch, Tom, Mary Rowell,. et al. “A Pilot Study on Transplant Eligibility Criteria,” Pediatric Nursing 23, 2 (March 13, 1997): 160–162.

  • Saaty, Thomas. The Analytic Hierarchy Process. New York: McGraw-Hill Book Company, 1980.

  • ——. “How to Make a Decision: The Analytic Hierarchy Process,” Interfaces 24, 6 (November–December 1994): 19–43.

  • Saaty, Thomas, and K. Kearn. Analytical Planning: The Organization of Systems. Oxford, UK: Pergamon Press Ltd., 1985.

Appendix M1.1: Using Excel for the Analytic Hierarchy Process

Excel can be used to perform the calculations in the AHP. Program M1.1A (columns A–I) and Program M1.1B (columns J–P) give the formulas that are used to develop the normalized matrices, the weighted sum vectors, the consistency indices, and the consistency ratios for the example in Section M1.3. The only inputs required in this example are the number of alternatives (cell D1), the upper-right halves of the pairwise comparison matrices, and the table for the random index (cells A26 to B33). When using the MMULT command (cells J27–J29 and four times in column L), highlight the cells and type this function. Then press the Ctrl, Shift, and Enter keys simultaneously to enter the function into all of these cells. Program M1.2 gives the output for this example.

An Excel Spreadsheet with several tables/matrices illustrates the MMULT and LOOKUP functions.

Program M1.1A   Partial Excel Spreadsheet Formulas for AHP

An Excel Spreadsheet with several tables/matrices illustrates the MMULT and LOOKUP functions.

Program M1.1B   Additional Excel Spreadsheet Formulas for AHP

A spreadsheet illustrates the output for AHP.

Program M1.2 Excel Output for AHP

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset