Hi,
I have been asked on a high level to show my resource utilization for my department. The tool has to be used by others than myself.
We do not want to register hours etc., but just track allocation on a quarterly basis by inputting the percentage each resource is allocated to what activities.
The data input table is as below. So as illustrated an employee can be allocated more than 100%.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Activity type[/TD]
[TD]Task[/TD]
[TD]Quarter[/TD]
[TD]Allocation[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]Project[/TD]
[TD]Win10 project[/TD]
[TD]Q1[/TD]
[TD]0.5 [/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]Operations[/TD]
[TD]Desktop[/TD]
[TD]Q1[/TD]
[TD]0.7[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]Project[/TD]
[TD]Sharepoint Upgrade[/TD]
[TD]Q1[/TD]
[TD]0.5[/TD]
[/TR]
[TR]
[TD]Allan[/TD]
[TD]Operations[/TD]
[TD]Desktop[/TD]
[TD]Q1[/TD]
[TD]0.7[/TD]
[/TR]
</tbody>[/TABLE]
My plan was to show it in a bar chart (Using Pivot table-chart), that could then illustrate the utlilization of employees. However, if he/she is not (like Allan) 100% allocated we need to be able to see his Free time. Of course the easy way would be to add another row for each employee and manage it manually, but I was hoping Pivot could somehow help me with it. Any ideas/suggestions?
Thanks
Best,
Peter
I have been asked on a high level to show my resource utilization for my department. The tool has to be used by others than myself.
We do not want to register hours etc., but just track allocation on a quarterly basis by inputting the percentage each resource is allocated to what activities.
The data input table is as below. So as illustrated an employee can be allocated more than 100%.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Activity type[/TD]
[TD]Task[/TD]
[TD]Quarter[/TD]
[TD]Allocation[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]Project[/TD]
[TD]Win10 project[/TD]
[TD]Q1[/TD]
[TD]0.5 [/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]Operations[/TD]
[TD]Desktop[/TD]
[TD]Q1[/TD]
[TD]0.7[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]Project[/TD]
[TD]Sharepoint Upgrade[/TD]
[TD]Q1[/TD]
[TD]0.5[/TD]
[/TR]
[TR]
[TD]Allan[/TD]
[TD]Operations[/TD]
[TD]Desktop[/TD]
[TD]Q1[/TD]
[TD]0.7[/TD]
[/TR]
</tbody>[/TABLE]
My plan was to show it in a bar chart (Using Pivot table-chart), that could then illustrate the utlilization of employees. However, if he/she is not (like Allan) 100% allocated we need to be able to see his Free time. Of course the easy way would be to add another row for each employee and manage it manually, but I was hoping Pivot could somehow help me with it. Any ideas/suggestions?
Thanks
Best,
Peter