You can choose one of three formulas available to calculate the Total Score and determine your Top Priorities:

  • Score Sum
  • Average Score Sum
  • RICE Scoring

The setting is separate for each board. The default is Score Sum.

To change the formula:

  1. Choose the board which you want to set up.
  2. Click the Criteria menu.
  3. Find the Board Formula field.
  4. Set the one you want to use on this board.
Note! To set the board formula, you must be Admin in Ducalis.

Score Sum

With this formula, the Total Score depends on the number of people who have evaluated the issue. The more scores an issue has, the higher the total score is. This is because we calculate each criterion as a sum of all scores it has. We multiply the sum by the criterion weight and get the Score Sum. Then, we add up Score Sums of all criteria and receive the Total Score.

We can express the formula this way:

Criterion Score (Cx) is the Sum of Scores (∑Sn) multiplied by the Criterion Weight (Wx).

Criterion Score (Cx) is the Sum of Scores (∑Sn) multiplied by the Criterion Weight (Wx)

So we calculate:

  1. Criterion X Score = (Score 1 + Score 2 + Score 3 + Score n) * Weight X
  2. Total Score = Criterion A Score + Criterion B Score + Criterion X Score

For example:

3 users evaluated 2 criteria—Sales and Effort.

The criterion Sales has weight +3 and scores: 2; 3; 2.

The criterion Effort has weight -2 and scores: 0; 2; 1.

Sales Score Sum = (2 + 3 + 2) * 3 = 21

Effort Score Sum = (0 + 2 + 1) * -2 = -6

Total Score = Sales 21 + Effort -6 = 15

Average Score Sum

With this formula, the Total Score doesn't depend on the number of people who have evaluated the issue. It appears as if one person evaluated all criteria because we calculate the average rating. We add up all the scores and divide the sum by their number. Then we multiply the resulting figure by the criterion weight. Thus we get the Average Score. Finally, we sum up Average Scores of all criteria and receive the Total Score.

We can express the formula this way:

Average Criterion Score (ACx) is the Sum of Scores (∑Sn) divided by the Number of Scores (NS) and multiplied by the Criterion Weight (Wx).

Average Criterion Score (ACx) is the Sum of Scores (∑Sn) divided by the Number of Scores (NS) and multiplied by the Criterion Weight (Wx)

So we calculate:

  1. Criterion X Average Score = ((Score 1 + Score 2 + Score 3 + Score n) / N Scores ) * Weight X
  2. Total Score = Criterion A Average Score + Criterion B Average Score + Criterion X Average Score

For example:

3 users evaluated 2 criteria—Sales and Effort.

The criterion Sales has weight +3 and scores: 2; 3; 2.

The criterion Effort has weight -2 and scores: 0; 2; 1.

Sales Score Sum = ((2 + 3 + 2) / 3) * 3 = 7

Effort Score Sum = ((0 + 2 + 1) / 3) * -2 = -2

Total Score = Sales 7 + Effort -2 = 5

RICE Scoring

With this evaluation formula, criteria don't have weights. They fall into Value or Effort metrics—Values are multiplied, Efforts are divided.

First, we calculate each criterion average score—add up all scores assigned to the criterion and divide the sum by the number of the scores.

To calculate the total score, we multiply average scores of all Values and divide the resulting amount by the average score of the Effort. Thus the formula allows you to set up the original RICE scoring in Ducalis.

We can express the formula this way:

  • The Total Score (TS) is the multiplied Average Value Criteria (ACval) divided by the Average Effort Criterion (ACeff);
    where
  • Average Criterion Score (ACn) is the Sum of Scores (∑Sn) divided by the Number of Scores (NS).

So we calculate:

  1. Criterion X Average Score = (Score 1 + Score 2 + Score 3 + Score n) / N Scores.
  2. Total Score = (Criterion A Average Score (val) * Criterion B Average Score (val) * Criterion C Average Score (val)) / Criterion D Average Score (eff).

For example:

3 users evaluated 4 criteria—Reach, Impact, Confidence, and Effort.

The criterion Reach is Value and has scores: 500; 700; 300.

The criterion Impact is Value and has scores: 3; 1; 5.

The criterion Confidence is Value and has scores: 80%; 95%; 65%.

The criterion Effort is Effort and has scores: 5; 2; 8.

Reach (val) Score = (500 + 700 + 300) / 3 = 500

Impact (val) Score = (3 + 1 + 5) / 3 = 3

Confidence (val) Score = ((80 + 95 + 65) / 3) / 100 = 0.8
Note! When you use percents as scores, the average score is divided by 100.

Effort (eff) Score = (5 + 2 + 8) / 3 = 5

Total Score = (Reach (val) 500 * Impact (val) 3 * Confidence (val) 0.8) / Effort (eff) 5 = 1200 / 5 = 240

Contact us in the chat bottom right if you need another formula.

Did this answer your question?