Excel Template to Calculate Activity Value

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 500x375 Excel Template to Calculate Activity 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 500x151 Excel Template to Calculate Activity Value

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 Excel Template to Calculate Activity Value

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.

Similar Posts:

Please wait...

Leave a Comment