Task duration as a function of the number of resources
Hello!
Can task duration be calculated as a function of the number of resources?
If one person takes three weeks then allocating three people should complete the task in one week, etc.
This should be easy but I can't find this capability.
I'd appreciate suggestions on how to do this.
Thank you,
Michael
Answers
-
Sounds doable, but would require a small database with duration of every and one task for 1 person.
Then your task duration column would have a formula like this one:
=IFERROR((INDEX({Task Duration Sheet - Duration Range}, MATCH([Task Name Column]@row, {Task Duration Sheet - Task Name Range},0)) / COUNTM([Affected to]@row),"")
The IFERROR being here to prevent divide by zero errors when the [Affected to] is blank.
-
Thank you for your suggestion.
I was hoping for a simpler "Resource multiplier" column. Then you could charge the resourcing for 0 to 100 % for one person AND also add multiple resources.
