Option Prioritization and Shortlist Tool

Author(s): Robert D'Aurelio, Jamal Shah, Marli Ramsey

This worksheet allows the IT organization to profile the criteria to evaluate each option and generate prioritization and shortlist grids from a fixed list of chosen options. Set the weightings of the criteria in the Data Entry tab and then score options in the Scoring tab. Specific worksheet functionality includes:

  • Variable prioritization factors for both potential cost and potential value factors.
  • Weightings to adjust the contribution of various suitability factors to overall option ranking.
  • A self-sorted ranking list of options (ranking is based on user input).