P6; Resource Usage Spreadsheet
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Hi Abeer
I have moved this thread to the p6 forum - you will get a better response here.
Best regards
Mike Testro
Dear All,
At P6, Kindly note that if I have a resource code R#1 limit is 42hrs per day this resource was assigned for many activities starting in Mar. and finished in Aug.
And I updated schedule in May 10, 2009
So I need a resource usage spreadsheet showing the following data:
• During May:
1- available units (Resource limit per month) = 42hrs per day X 30d = 1260hrs
2- actual units = 500hrs
3- remaining units = 600
4- Required/downtime units = 1 - (2 + 3) = 1260 - (500 + 600) = -160hrs
• During June:
1- available units (Resource limit per month) = 42hrs per day X 30d = 1260hrs
2- actual units = 0hrs
3- remaining units = 1000hrs
4- Required/downtime units = 1 - (2 + 3) = 1260 - 1000 = 260hrs
• During July:
1- available units (Resource limit per month) = 42hrs per day X 30d = 1260hrs
2- actual units = 0hrs
3- remaining units = 0hrs
4- Required/downtime units = 1 - (2 + 3) = 1260 - 0 = 1260hrs
Regarding that I tried to spreadsheet fields customized options but I think I chose a wrong options so If any one have any idea via resource usage spreadsheet or any other report/way please feed me back with steps.
Regards,
Abeer