Very simple project. We need someone to build formulas for our Software Development Board table - specifically to create a formula that sums up the different ‘variables’ (1) for each task, and outputs a ‘score’ (2) to help prioritize each task.

Here’s an example of the structure we look to create:

The current input variables are:

1. Urgency (+)
   
   
   
   
   
   • Very Urgent (10)
   
   
   
   • Urgent (5)
   
   
   
   • Normal (2.5)
   
   
   
   • Not Urgent (0)
   
   
   
   
   
   



2. Business Value (+)
   
   
   
   
   
   • Very High Value (10)
   
   
   
   • High Value (7)
   
   
   
   • Normal Value (5)
   
   
   
   • Low Value (3)
   
   
   
   • Very Low Value (0)
   
   
   
   
   
   



3. Potential User Value (+)
   
   
   
   
   
   • Very High Value (10)
   
   
   
   • High Value (7)
   
   
   
   • Normal Value (5)
   
   
   
   • Low Value (3)
   
   
   
   • Very Low Value (0)
   
   
   
   
   
   



4. Effort Required (-)
   
   
   
   
   
   • <1 hour (0)
   
   
   
   • 1-3 hours (-1)
   
   
   
   • 3-5 hours (-2)
   
   
   
   • 5-10 hours (-3)
   
   
   
   • 10-20 hours (-5)
   
   
   
   • 20+ hours (-7)
   
   
   
   
   
   

So, for each of our dev tasks, we would attribute one option per variable. For example:

Task A (inputs):

• Urgency (Very Urgent, +10)



• Business Value (Very High Value, +10)



• User Value (High Value, +7)



• Effort Required (1-3 hours, -1)

Task A (output):

• Priority Score = 26 (10+10+7-1)

Anyone who can build this for us, please leave your email/contact info below and I will reach out to you ASAP.

Thanks,


kjr