If you have not already done so you will have to assign resources (Labour and\or Materials) to each of the tasks on your schedule. In addition you will need to assign rates ($/h or $/Quantity) to each of the resources if you want to create a cost loaded schedule. I would recommend that you level the resources once the resources have been assigned by adjusting task durations and logic so that a manageable work program is produced. At this point the schedule can be baselined. By opening the Task Usage view you will be able to see all of the manhours, materials and costs time phased across the project. I recommend that you copy and paste the values from the Task Usage view in to MS Excel where Histograms and S-Curves can easily be created.
D
Member for
15 years 7 months
Member for15 years7 months
Submitted by Ali Deveboynu on Fri, 2011-11-18 13:59
I guess you have set Units/Time Format in the user settings to "Show as a percentage", as such resources are in percentage format.
Once you have loaded the resources, you can use the Resource Usage spread sheet and Profiles to view the Resource curves and histograms and if required run are report to get the values in excel format. Where u can manually create the curves and histograms.
Member for
16 years 11 monthsMany thanks to all
Many thanks to all
Member for
14 years 7 monthsShahul, If you have not
Shahul,
If you have not already done so you will have to assign resources (Labour and\or Materials) to each of the tasks on your schedule. In addition you will need to assign rates ($/h or $/Quantity) to each of the resources if you want to create a cost loaded schedule. I would recommend that you level the resources once the resources have been assigned by adjusting task durations and logic so that a manageable work program is produced. At this point the schedule can be baselined. By opening the Task Usage view you will be able to see all of the manhours, materials and costs time phased across the project. I recommend that you copy and paste the values from the Task Usage view in to MS Excel where Histograms and S-Curves can easily be created.
D
Member for
15 years 7 monthsmr. shahul you can do it with
mr. shahul
you can do it with visual reports , please refer to
http://office.microsoft.com/en-us/project-help/produce-a-visual-report-of-project-2007-data-in-excel-HA010235237.aspx
address fror details,
best regards
Member for
20 years 1 monthI guess you have set
I guess you have set Units/Time Format in the user settings to "Show as a percentage", as such resources are in percentage format.
Once you have loaded the resources, you can use the Resource Usage spread sheet and Profiles to view the Resource curves and histograms and if required run are report to get the values in excel format. Where u can manually create the curves and histograms.
Regards