Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Store Period Performance

12 replies [Last post]
Mon, 2005-04-04 14:08
Kashyap Mothali
User offline. Last seen 12 years 24 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 23
Groups: None
I update a cost loaded schedule every month. There are approx. 100-200 activities in this schedule that are being billed out prior to actual progress (due to costs being expended for submittals & fabrication). When I finally run the "Store Period Preformance", P3 tells me that these activities have no Actual Start Date. I then have to insert "bogus Actual Start Dates" for all such activities before I can run the "Store Period Performance" and the schedule calculation.

So far, I have been selecting these 100-200 activities individually, assigning them "bogus start dates" and finally undoing these "bogus start dates" after the schedule calculations. The entire process is painstaking and lenghty. Could anyone please suggest an easier way to do this process?

Thanks,

Kashyap Mothali
Top

Replies

Tue, 2014-10-07 14:19
#1
Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

I would say that you schedule is incomplete. Why don't you have activities for submittals & fabrication this would solve your problem and NOT have bogus start dates. 

every major activity especially that you are billing for should have the following chain of activities

create & submit (whaterver product or component) submittal

review & approve (whatever product or component) submittal

fabricate or procure (whatever product or component) 

deliver (whatever product or component) to site

Install (whatever product or component)

this way if anything in this chain gets delayed you will see where the delay is and the impact of the delay 

Top
Wed, 2014-06-11 20:21
#2
Renee Trent
User offline. Last seen 6 years 12 weeks ago. Offline
Joined: 24 Oct 2011
Posts: 4
Groups: None

Hello Paul,

 I have co-workers that are using "store period performance" and using it to run Earned Value in Primavera.  I have seen that this takes an entire group of administrators to keep the data updated.  ie. they are updating it with weekly financial periods.  Now I have several other groups that are requesting to use this "add-on" in Primavera, which I too believe is more trouble than it is worth.  We have had stored data that was messed up, and when we called the vendor even told us not to use it.  I am looking to get some "pros and cons" for using this part of Primavera. 

Top
Wed, 2005-04-06 16:07
#3
Kashyap Mothali
User offline. Last seen 12 years 24 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 23
Groups: None
Guess what...Eric Chou’s suggestion worked.

It involves a mutli-step process:
1. Export all activities that show up in the initial "Period Performance" log file (P3.OUT)to .xls
2. Assign a new code for these activities
3. Import & Filter these activities in P3
4. Run a Global Change to impose bogus AS Dates against activities assigned to this new code
5. Store Period Performance
6. Run another Global Change to undo previous bogus AS dates.

Once step 6 is done, P3 automatically reverts back to the original ES Dates.

This cut down the time from 2 hrs to 15 min. Thanks again for all your input and feedback!!!

Kashyap
Top
Wed, 2005-04-06 14:16
#4
Philip Jonker
User offline. Last seen 15 years 21 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi Kashyap,

P3 has a history function, where you can store history automatically, alternatively, I suggest you store it manually, in seperate directories for every date you update, the history option being the first option.
I prsonally would stay away from bogus dates. Record history as it is.

Tegards


Philip
Top
Wed, 2005-04-06 00:18
#5
Vladimir Liberzon
User offline. Last seen 17 weeks 1 day ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Paul,
I did not write about P3 in my posting. I am sure that you are right estimating its capabilities. And I did not mean billing and accounting. I don’t recommend to use PM software for this purpose too (and time sheets also). Usually the data entered in PM software are based on current work results and frequently are not supported by corresponding documents used in accounting.

Vladimir
Top
Tue, 2005-04-05 18:21
#6
Paul Harris
User offline. Last seen 1 year 4 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
Vladimir

I agree that Period actuals are necessary for analyzing project performance trends.

But the question I felt was not in relation to project trends, it was for billing, for billing I always recommend a timesheet system, using a scheduling software as a timesheet system is a time consuming exercise.

In relation to project performance trends there are other methods when using P3, other than Period actuals, which off more flexibility. P3 Period Actuals is very inflexible. For example if you wish add a new activity which you are required to assign past period actuals too, I know this should not happen but it does, a new activity will not have the past periods and one has to copy an existing activity with the required number of periods in order to add an activity with past periods.

It is my opinion that P3 period actuals is an inflexible tack on function that is difficult to use and I avoid it.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Book Publishers, Training & Consulting
www.eh.com.au
Top
Tue, 2005-04-05 15:41
#7
Eric Chou
User offline. Last seen 40 weeks 5 days ago. Offline
Joined: 19 Jul 2004
Posts: 29
Groups: None
Kashyap,

I think you have no way around that limitation of the "Store Period Performance". If you just use the period performance data for pay request, it can be done easily by using custom data item. In other words, "Store Period Performance" is only useful when you want to see all the historical period cost/resource data for individual activity or project at one glance such as cost/resource cumulative curve. If you just need the data from previous period such as pay request, I recommend you to use custom data items and global change to copy data over, etc. If necessary, you can use Excel to plot the cost/resource cumulative curve.

Attached is the write-up by me regarding Store Period Performance. Please review for your reference. Go to the http://www.htcprojectcontrols.com/SB003.pdf

Eric Chou, PE
HTC Project Controls, Inc.
www.HTCProjectControls.com
Top
Tue, 2005-04-05 11:15
#8
Kashyap Mothali
User offline. Last seen 12 years 24 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 23
Groups: None
Andrew’s suggestion to itemize procurement and installation is an ideal solution....preferably what should have been done. However, since I inherited this schedule, I’m stuck with what I have.

I experimented with the export/import process,but to no avail. Could you run a set of Global Changes to fix this? Any input would be appreciated. Thanks,

Kashyap
Top
Tue, 2005-04-05 09:30
#9
Vladimir Liberzon
User offline. Last seen 17 weeks 1 day ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Paul, I strongly disagree.
Period actuals are necessary for analyzing project performance trends.
And besides time sheets will not help. Not only time matters, but also cost and material consumption, volumes done, etc.
Vladimir
Top
Tue, 2005-04-05 06:30
#10
Paul Harris
User offline. Last seen 1 year 4 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
This is the usual problem people have when they try using a scheduling package for time sheeting. You will forever have problems.

I suggest you get yourself a time sheet system for this purpose and do not bother with store period actuals, it is more trouble than it is worth.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Book Publishers, Training & Consulting
www.eh.com.au
Top
Tue, 2005-04-05 04:05
#11
Andrew Podolny
User offline. Last seen 41 weeks 3 days ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
Hi, Kashyap
I’d suggest inserting extra activity for each billed activity in your schedule. The point is to retain schedule logic – by this way you can assign real start dates for billing activity and then close it. The cons of this method are some routine work to be done. But in future you’ll be rewarded for this.
Cheers,
Andrew
Top
Tue, 2005-04-05 03:06
#12
Anand Kulkarni
User offline. Last seen 11 years 41 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 41
Groups: None
Hi Kashyap,

If the resources price/Unit & through will be of any help to you?

At least in cash-flow statements it does get reflected.



Top