Task duration as a function of the number of resources

Michael Wilson

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

David Joyeuse

Hi @Michael Wilson

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.

Michael Wilson

Hi @David Joyeuse

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.