I need to schedule the resources allocation as part of an integration project where the workload is the same across the defined period (eg: engineer is working 55% of his time between January and April). We only calculate resource allocation on a monthly period and man days per month.
I created a table where I choose the task that gives me the utilisation and I pick the starting month which based on a predefined duration (in month) will give me the end date.
I obviously allocate several tasks for the project.
So I have the following value for now:
- task (manual)
- starting date (manual)
- Duration (predefined - in months - task attribute)
- end date (calculated based on starting date and duration)
- Workload (predefined - pourcentage - task attribute)
What I would like to achieve is to be able to get the utilisation of a resource at any chosen date for all the tasks (additional filters might be added like company, project, etc).
Is it something achievable?
Thank you in advance again for your assistance,