Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Planned % Complete S Curves at EST & LST

5 replies [Last post]
Thu, 2004-08-19 08:56
Mike Swan
User offline. Last seen 16 years 13 hours ago. Offline
Joined: 26 May 2004
Posts: 3
Groups: None
I’m interested in producing planned % complete S curves at EST and LST. Then track actual % complete as the contract progresses.

Does anyone know how to calculate these planned percentages from the target programme?
My solution so far is to take a copy of my target programme and update progress using the auto functionality for each projected update date. This gives me EST.
Then take another copy and use global change to move all the EST to LST and repeat the process. A time consuming exercise.
Top

Replies

Sat, 2004-08-21 23:08
#1
Forum Guest
User offline. Last seen 18 weeks 3 days ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Let me understand the question by clarifying the ff. points:

1) What do EST and LST means? Early Scheduled Target and Late Scheduled Target?

2) Why do you need to update the target programme to get the EST?

3) Why do you have to move all the EST to LST by global change?

4) Are you producing the s-curves inside P3 or outside the system using other graphical software?

Top
Sat, 2004-08-21 09:34
#2
Zq qz
User offline. Last seen 12 years 46 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Steps: Go to the ff p3 menu
1- Tools
2- Tabular reports
3- Resource
4- Tabular >> timescale menu >> then select menu for Schedule 1 and schedule 2 , type filename and path

thats it,

MMD
Top
Fri, 2004-08-20 11:32
#3
B Cass
User offline. Last seen 20 years 11 weeks ago. Offline
Joined: 17 Aug 2004
Posts: 7
Groups: None
"I’m interested in producing planned % complete S curves at EST and LST. Then track actual % complete as the contract progresses."

If you’re looking for activity % and not cost % you can create a new resource called DUR and copy all your original durations to the BQ column for DUR using Import/Export. Once you’ve done this, go to your grahpic reports and run a resource curve using DUR as your selection and show early/late dates. I run my Baseline schedule as Target 2, previous month’s update as Target 1. I mostly run histograms and compare the difference between the early and late dates for each month. It’s not precise but it’s a good reference tool.
Top
Fri, 2004-08-20 09:55
#4
Forum Guest
User offline. Last seen 18 weeks 3 days ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
1- Cost load the Job with a resource named PA for Payment Application
2- Assign same resource "PA" several times for a single activity using a unique cost account per Payment Breakdown Item for easy cross referencing. In this way an activity sucks as Lighting Fixtures Building A might be cost loaded for Fixture Type A and C while Lighting Fixtures Building B might be cost loaded for Fixture Types A an G. As you can see a Payment Breakdown Item can span several Activities, while a single Activity can span several Payment Breakdown Items.
3- After distributing all your Payment Breakdown Amounts you can create a Table Layout for easy data entry to update Payment Applications directly from the table.
4- From P3 Graphic Reports as well as Tabular reports you can get the Early and Late Progress Payment Curves Reports.
5- P3 allows you to present a Resource/Cost Graphic Reports with 2 Baselines and the current job in the same Graph, with the option to use Early Dates, Late Dates or Both.
6- Use Period posting so P3 shows true spread.
7- Time consuming and error prone. I still prefer to use a summary spreadsheet based on my P3 Schedule to develop and track my S Curves and not to complicate things trying to match my schedule to the Payment Applications.

If you are using Suretrack you must create a resource per Payment Breakdown Item as Cost Accounts are not available, this is also an option under P3 to be considered if want to model unit prices instead of just % complete.

You won’t get the curves for early dates and late dates in the same Suretrak run.

Good Luck

Top
Thu, 2004-08-19 10:37
#5
Brennan Westworth
User offline. Last seen 7 years 30 weeks ago. Offline
Joined: 23 Feb 2003
Posts: 150
Groups: None
In the past I have done this by exporting the Early/Late and then EV data to excel using suretrak’s pivot table wizard.
Top