Setting up Scoring and Ranking Criteria

This article explains how to define scoring and ranking criteria in the Administration Center. This criteria is used when ranking projects against others in the portfolio.



Projects can be ranked and scored based on a predefined set of criteria, such as Strategic Fit, Hard ROI, Soft ROI, Risk, and more. To set up this criteria, along with the defined choices and calculations, click on Administration->Ranking:


The main Ranking page will display, where you can choose to work with Fields, Formulas or Lists:



Ranking Fields

To add a scoring element field for ranking, click the clipboard_e6f5122d4e298f13ad53186580cd716f8.png icon on the upper left.  To delete a field, click the clipboard_ef64925a949815ab81263dd28eca252bb.png icon.

You can type into the columns to name the field, give it a description, and identify which “List” to use for the field (see “Ranking Lists” below), or choose to set up that field without a predefined list.

Lists can be used for multiple ranking criteria fields, and determine what choices the user has when scoring that particular element.  You can also specify the order in which the field should appear (when users are scoring projects in the Ranking tab for their project). When setting up a ranking field, you can assign a min/max value, as well as thresholds for various colors. If you add a new ranking field, be sure to adjust the formulas on the Formulas tab to accommodate the new field. Also, make sure the sequence number of the new fields match up to the numbers in the formula (see Ranking Formulas below).

Note: The KPI scoring fields are system defaults. You can revise the color settings, but the fields themselves are used for the automatic project KPI scoring.


The 7 ranking fields below are set up as system defaults and are defined in Admin–>Column Headings in the Project table (screenshot below).  Note that the internal field names are RANKVALUE1, RANKVALUE2, etc. These do not change. However, you can change the visible name (ECV, NPV, etc.) to be some other ranking value if you prefer.



Ranking Formulas

Formulas come preset with ResourceFirst, but you can revise and add formulas as well. As an example, RC[1] refers to the first Ranking Column (Field). The “1” refers to the order in which the field is listed. However, if you add a new ranking field in position 8, you would not necessarily add RC[8] to the list.

Adding new ranking fields: The number for any new fields needs to match the Sequence number of the new fields in the Fields tab.  For instance, if you added a new ranking field on the Fields tab at Sequence 18, then the formula would add the new ranking field as RC[18] to the list.



Ranking Lists

Lists are the choices users will have when assigning a score to a certain scoring element. The list includes the list items, value for that item when used in a formula and color that should be assigned if that value is chosen.

Once a list is defined, it can be used when defining any of the ranking fields on the Fields tab.


Play Video
Play Video