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:
- Urgency (+)
- Very Urgent (10)
- Urgent (5)
- Normal (2.5)
- Not Urgent (0)
- Business Value (+)
- Very High Value (10)
- High Value (7)
- Normal Value (5)
- Low Value (3)
- Very Low Value (0)
- Potential User Value (+)
- Very High Value (10)
- High Value (7)
- Normal Value (5)
- Low Value (3)
- Very Low Value (0)
- 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
