Schedule Percent Complete - Graph

K
Ken S 👤 Member for 21 years
E
Ernesto Puyana 👤 Member for 25 years 5 months

I use an indirect method, with suretrak. Once my schedule is ready, I run the spotlight and click on progress update. That gives me the precent complete I should get if everything was done according to schedule. I repeat this week after week and create a spreadsheet graph with these data, which is actually my baseline.

Later while the project is going on, I record actual percent complete data from weekly updates, and graph them as a second series in the speadsheet.

The only drawback is that when many activities tend to slip unfinished, the actual percent complete can diminish, which makes no sense.

R
Ravi Potwar 👤 Member for 21 years 3 months

Ken,

You have to give the weightage to each activity (On the Basis of Qty or manhrs,or Cost ) as total 100 % completion & Make Resources as % & load to each activity total 100%.

You can Monitoring this as S curve

All the best

A
Anand Kulkarni 👤 Member for 21 years 2 months

Hi Philip,



Great! it does make lot of sense.



I think this contribution will be very very helpful for all who’s plans are without resources to plot that mystic curve.





cheers!!!

P
Philip Jonker 👤 Member for 21 years 7 months

Hi Ken,



At least it will give you a picture, and some idea of the spread of the work, even though you do not have specific quantities.



Regards



Philip

K
Ken S 👤 Member for 21 years

Philip - I ended up going with that method - apparantly there was no estimate for this project.

J
Jaco Stadler 👤 Member for 21 years 9 months

Another option is to an estimate yourself. or ask for your estimating/cost department.



Personnel with exceptional technical, commercial, financial, estimating, planning, scheduling, cost control, and contract administration expertise who effectively staff the project team;

P
Philip Jonker 👤 Member for 21 years 7 months

Hi Ken,



One way, which might not be the most scientific, but does give reasonable answers, is to create a dummy resources, and use your durations as budget values. It will give you some idea of where you are going. This is a five minute job, but if you want to increase the values on activities that are more resources intensive, apply some factors to these activities. the easiest way to do this is to export/import via dbf files, and work on them in excel.



Regards



Philip

A
Anand Kulkarni 👤 Member for 21 years 2 months

Ken,



If the schedule is not resoruce loaded than, then you it will be very difficult to trace the histroy unless Milestone based weighing was done or back-up of each reporting period is taken.



Because if resources are not loaded than % complete is calculated on activity durations with respect to project durations.



Check the summary bar of the project & interaction with site team and try to come to some logical conclusion.


J
Jaco Stadler 👤 Member for 21 years 9 months

It is actualy very easy Transfer your resources into the Target schedule and them you use your target schedule as your Planned Value

F
Frank Borcherdt 👤 Member for 25 years 1 month

Ken,



It is possible. Under Tools/Graphical Reports/Resource and Costs RC-05 in your APEX sample project is a cumulative curve based on %...check out the options in the Content Tab when modifying.



You will need to ensure that the resource/cost data is loaded onto all activities (even those that were complete at time of initial loading).



HTH

Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts