External results calculation

Calculation methods

Method Description
Last Entry The last number specified
Sum The sum of specified numbers
Highest The highest number specified
Lowest The lowest number specified
Average (sum of specified numbers)/(count of non-zero entries)
Annualized (Average) x (Entry Results Frequency)

Result calculation example

Assume this goal:

  • Goal = Achieve a 0% variance of actual versus budgeted expenses for the department.
  • Goal weight = 10%.
  • Results measured against a five-point rating scale.
  • Lower results are better.
  • Result ranges (rating criteria):
    Rating Level Result Range From Result Range Thru
    1 4.50 999,999.00
    2 2.50 4.99
    3 0.00 2.49
    4 -2.50 -0.01
    5 -999,999.00 -2.51
  • The results in this table are specified:
    Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Entry permitted Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
    Value 3 5 -2 0 0 -1 0 3 1.5

Last Entry calculation method result

This method uses the number from the last month that contains a number value.

  • Results
    Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Entry permitted Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
    Value 3 5 -2 0 0 -1 0 3 1.5
  • Result ranges
    Rating Level Result Range From Result Range Thru
    1 4.50 999,999.00
    2 2.50 4.99
    3 0.00 2.49
    4 -2.50 -0.01
    5 -999,999.00 -2.51
  • Calculation

    In this case, the last number specified is the value for September = 1.5

    1.5 falls at level 3 (between 0.00 and 2.49)

    Final score = 3 x 10 % (rating x goal weight)

    Final score = .3

Sum calculation method result

This method adds the number entries

  • Results
    Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Entry permitted Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
    Value 3 5 -2 0 0 -1 0 3 1.5
  • Result ranges
    Rating Level Result Range From Result Range Thru
    1 4.50 999,999.00
    2 2.50 4.99
    3 0.00 2.49
    4 -2.50 -0.01
    5 -999,999.00 -2.51
  • Calculation

    Sum of number entries = 9.5 (3 + 5 + -2 + 0 + 0 + -1 + 3 +1.5)

    9.5 falls at level 1(between 4.50 and 999,999.00)

    Final score = 1 x 10 % (rating x goal weight)

    Final score = .1

Highest calculation method result

This method takes the highest value of all the number entries.

  • Results
    Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Entry permitted Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
    Value 3 5 -2 0 0 -1 0 3 1.5
  • Result ranges
    Rating Level Result Range From Result Range Thru
    1 4.50 999,999.00
    2 2.50 4.99
    3 0.00 2.49
    4 -2.50 -0.01
    5 -999,999.00 -2.51
  • Calculation

    In this example, 5 is the highest number value (specified in February)

    5 falls at level 1(between 4.50 and 999,999.00)

    Final score = 1 x 10 % (rating x goal weight)

    Final score = .1

Lowest calculation method result

This method takes the lowest value of all the number entries.

  • Results
    Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Entry permitted Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
    Value 3 5 -2 0 0 -1 0 3 1.5
  • Result ranges
    Rating Level Result Range From Result Range Thru
    1 4.50 999,999.00
    2 2.50 4.99
    3 0.00 2.49
    4 -2.50 -0.01
    5 -999,999.00 -2.51
  • Calculation

    In this example, -2 is the lowest number value (specified in March)

    -2 falls at level 4 (between -2.50 and -0.01)

    Final score = 4 x 10 % (rating x goal weight)

    Final score = .4

Average calculation method result

This method calculates the average of all specified numbers.

  • Results
    Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Entry permitted Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
    Value 3 5 -2 0 0 -1 0 3 1.5
  • Result ranges
    Rating Level Result Range From Result Range Thru
    1 4.50 999,999.00
    2 2.50 4.99
    3 0.00 2.49
    4 -2.50 -0.01
    5 -999,999.00 -2.51
  • Calculation

    The formula is (sum of number entries) / (count of number entries)

    Note: 

    Zero entries are not included in the count for the denominator of the average calculation.

    Sum of number entries = 9.5 (3 + 5 + -2 + 0+ 0 + -1 +0 + 3 + 1.5)

    Count of number entries = 6

    Score = 1.58 (9.5/7)

    1.57 falls at level 3 (within 0.00 and 2.49)

    Final score = 3 x 10% (rating x goal weight)

    Final score = .3

Annualized calculation method result

This method calculated the average of all specified numbers then multiplies them by a number determined by the Result Entry Frequency. This gives an estimate of an annual result. If the Result Entry Frequency is Monthly, then the average is multiplied by 12. If it is Quarterly, then the average is multiplied by 4. If it is Semi-Annually, then the average is multiplied by 2.

  • Results
    Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Entry permitted Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
    Value 3 5 -2 0 0 -1 0 3 1.5
  • Result ranges
    Rating Level Result Range From Result Range Thru
    1 4.50 999,999.00
    2 2.50 4.99
    3 0.00 2.49
    4 -2.50 -0.01
    5 -999,999.00 -2.51
  • Calculation

    The formula is (Average) x (Result Entry Frequency)

    Sum of number entries = 9.5 (3 + 5 + -2 + 0 + 0 + -1 + 0 + 3 + 1.5)

    Count of number entries for average = 6

    Average = 1.58 (9.5 / 6)

    Result Entry Frequency = 12 (Monhtly)

    Score = 18.96 (1.58 x 12)

    10.88 falls at level 1 (within 4.50 and 999,999.00)

    Final score = 1x 10% (rating x goal weight)

    Final score = .1