score calc

Excel Template to Calculate Activity Value

Reading Time: 1 minutes (ish)

A while back I wrote an article about how you have to balance the reward value of activities against the value to the client, user and effort.

effort vs system value

The basic idea was that if a user has to work hard to get a reward, it had better be worth something. At the same time, if the value of the activity is high to the client, the reward should also be worth having.

At the time I wrote that, I developed a simple spreadsheet to help me calculate reward values for activities for a client I was working with. I thought I would share that with you to help you with your projects as well.

How to Use It

  • Open the spreadsheet and start by entering the activities in the first column.
  • Next, estimate the activity’s value to the client 1 to 5, 5 being the highest.
  • Do the same for the value to the user and the user effort.
  • The sheet will give you overall value of the activity and an idea of how to score it.

score calc

You will notice there is a weighted value. If you go to the settings tab, you can adjust the weighting of each of the value types (value to client, value to user, user effort).

score calc settings

The weighting is on a scale of 1 to 10 to give you a bit more control. The more important the value type, the higher you should set the weighting.

Min Points sets the smallest number of points that can be assigned to an activity and will change the values in the Points column of the first sheet.

So, if you are interested, you can download the spreadsheet from here.

Let me know how you get on with it in the comments section.


Spread the love!

Leave a Reply


Play the Game


Subscribe to our newsletter


Andrzej Marczewski
About Andrzej Marczewski twitter facebook    
Gamification Consultant. I love to write about it, talk about it and bore people to death with it! If you really want to get to know me, check out the About page.

Trackback URL for this post: https://www.gamified.uk/2016/03/21/excel-template-calculate-activity-value/trackback/