From Post #2 Step #5 you need to modify the Columns based on your requirements, if you select “Columns” there is an
1. Available Options --> General --> Resource ID Name, anything else you need --> OK.
2. From Filter, you need to filter the resource, only what you required. Where “Resource ID Name” “is under” “Resource Value” then OK --> Next.
3. From Timescale, you can change the “Timescale Start & Finish” “Date Interval” and “Averaging” --> Calculate Average --> OK.
4. From Time Interval Fields --> Available Options --> Time Interval --> Units --> Budgeted Units --> OK --> Next.
From Step #3 above, naturally you need to calculate the average of your Manpower. Unlike in P3x it will give you automatically the average of your required manpower. Just keep on trying.
I followed the procedure U told. I am not getting the results in My format,
I mean if we will follow "Tools>Tabular Reports>Resource>Loading>Resource Loading - Average Monthly Use......in csv format" this then we will get only the resource list.
Whereas this (the above procedure) is giving us the activity list
so if we want the the list of resource and in front of that per month peak or avg ( budgeted Units..? ) to plot the Histogram chart, What is the report format?
Member for
18 years 6 monthsRE: Manpower Histogram
Pradip,
It is working with me. If you dont mind, send me your .xer file to my email p3-fer@sixco.ae and Ill show you how to do it. If you wish.
Thanks.
Arnold
Member for
17 years 3 monthsRE: Manpower Histogram
Yha! I tried wid various way but its showing all the activity list instead the Resource list unlike P3 output.
...?
Member for
18 years 6 monthsRE: Manpower Histogram
Pradip,
One important thing, do not forget to put checked in “Show Time Intervals” from the Date Options of Post #2 Step #7.
Thanks.
Arnold
Member for
18 years 6 monthsRE: Manpower Histogram
Hello Pradip,
From Post #2 Step #5 you need to modify the Columns based on your requirements, if you select “Columns” there is an
1. Available Options --> General --> Resource ID Name, anything else you need --> OK.
2. From Filter, you need to filter the resource, only what you required. Where “Resource ID Name” “is under” “Resource Value” then OK --> Next.
3. From Timescale, you can change the “Timescale Start & Finish” “Date Interval” and “Averaging” --> Calculate Average --> OK.
4. From Time Interval Fields --> Available Options --> Time Interval --> Units --> Budgeted Units --> OK --> Next.
From Step #3 above, naturally you need to calculate the average of your Manpower. Unlike in P3x it will give you automatically the average of your required manpower. Just keep on trying.
Regards,
Arnold
Member for
17 years 3 monthsRE: Manpower Histogram
Thanks Arnold,
I followed the procedure U told. I am not getting the results in My format,
I mean if we will follow "Tools>Tabular Reports>Resource>Loading>Resource Loading - Average Monthly Use......in csv format" this then we will get only the resource list.
Whereas this (the above procedure) is giving us the activity list
so if we want the the list of resource and in front of that per month peak or avg ( budgeted Units..? ) to plot the Histogram chart, What is the report format?
Pls guide me.
Thanks
Member for
18 years 6 monthsRE: Manpower Histogram
Hi Pradip,
Try the following Steps:
1. Go to Reports
2. Create new reports -> Next
3. From Select Subject Area tick Time Distributed Data
4. Select Activity Resource and Role Assignments -> Next
5. From Configure Selected Subject Areas, There is Columns, Group & Sort & Filter
6. After Completing step #5 -> Next
7. From Date Options, Select Timescale -> Calculate Average then OK
8. From Date Options, Select Time Interval Fields -> Available Option -> Budgeted Units then OK -> Next
9. Rename the Report Title -> Next
10. Run Report or select Next
11. Save Report -> Finish
From the right corner select RUN select ASCII then OK, this will open in Excel .csv format.
Regards,
Arnold