I'm not sure I understand your problem? -All the fields you require should be available to you in the activity usage spreadsheet
-Earned Value (cost), Earned Value (labour), Planned Value (cost), Planned Value (labour), Actual cost, Actual Labour, Remaining cost & Remaining labour
If you apply the correct filter, you should only get the results for the relevant phase
Member for
21 years 7 months
Member for21 years8 months
Submitted by Rafael Davila on Sun, 2013-07-14 14:03
1) Create a zero-cost labour resource called "Procurement Weighting"
2) Add this resource to all Procurement tasks, Budget units = original duration
3) Repeat for Engineering
4) Set up a filter for engineering, procurement & construction phases
5) Filter the project before reporting. Use "Earned Value Labour units" to track progress for engineering & procurement phases & "Earned Value cost" for construction phase. % complete = EV/BAC
NB: If you have any summary tasks or long-duration activities with little work actually being done in the engineering or procurement phases, they will skew your progress figures. Consider ommitting them from the reports by not loading them with resource
Member for
16 years 7 monthsIrfan, I'm not sure I
Irfan,
I'm not sure I understand your problem? -All the fields you require should be available to you in the activity usage spreadsheet
-Earned Value (cost), Earned Value (labour), Planned Value (cost), Planned Value (labour), Actual cost, Actual Labour, Remaining cost & Remaining labour
If you apply the correct filter, you should only get the results for the relevant phase
Member for
21 years 7 monthshttp://www.planning-engineer.
http://www.planning-engineer.com/resources/P6P-Progress-2.pdf
Member for
21 years 7 monthshttp://www.plannertuts.com/ta
http://www.plannertuts.com/tag/percent-complete/
Member for
16 years 3 monthsthanx Gary, after following
thanx Gary,
after following your procedures i got result. But here i want these value separately in Activity Spreadsheet as well.
Coz i want to show it by curves i mean Planned, Actual & Forcast by exporting it to Excel for each disciplines.
any clue....?
Member for
16 years 7 months1) Create a zero-cost labour
1) Create a zero-cost labour resource called "Procurement Weighting"
2) Add this resource to all Procurement tasks, Budget units = original duration
3) Repeat for Engineering
4) Set up a filter for engineering, procurement & construction phases
5) Filter the project before reporting. Use "Earned Value Labour units" to track progress for engineering & procurement phases & "Earned Value cost" for construction phase. % complete = EV/BAC
NB: If you have any summary tasks or long-duration activities with little work actually being done in the engineering or procurement phases, they will skew your progress figures. Consider ommitting them from the reports by not loading them with resource
Cheers,
G