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.

Budgeted resources changes everytime i import data

9 replies [Last post]
Sun, 2005-05-29 11:48
Rolyn Jalea
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 2 Jun 2004
Posts: 34
Groups: None
good day fellow planners!!!
I have a weird problem with regard to my resource loaded programme. Everytime i import a data (i.e. AS, AF & PCT)from our subcontractor, my budgeted resource in some of my activity changes. I don’t know what could be the reason, I’ve been doing this for the past 5 months and its working fine. then last month this problem occur. This programme is cost loaded and every month I have to generate monthly valuation to be submitted to the client. Manually encoding the data that comes from the subcontractor is not possible since i have 7 towers to update & the only way is to do importing datas. I have 25,000 activities as a whole with 7 subprojects. Any help will be gladly appreciated.
THANKS!!!
Top

Replies

Tue, 2005-05-31 05:33
#1
Rolyn Jalea
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 2 Jun 2004
Posts: 34
Groups: None
thanks for the help, I’ll try all of your suggestions...
Top
Tue, 2005-05-31 00:09
#2
Bill Guthrie
User offline. Last seen 7 years 49 weeks ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
have you run PFIX.exe

could be unstable schedule base.
Top
Mon, 2005-05-30 23:44
#3
Jaco Stadler
User offline. Last seen 17 years 27 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Hi Rolyn Transfer Autocost Rule from another Project. (One you are sure that you did not have any problems with)

Also have a look as to earned Value are you using Target Project or Current Project
Top
Mon, 2005-05-30 16:34
#4
Frank Borcherdt
User offline. Last seen 7 years 18 weeks ago. Offline
Joined: 3 May 2001
Posts: 88
Groups: None
Is the freeze the units per timeperiod autocost rule set??
Top
Mon, 2005-05-30 14:11
#5
Jaco Stadler
User offline. Last seen 17 years 27 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
nothing driving
Top
Mon, 2005-05-30 11:09
#6
Rolyn Jalea
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 2 Jun 2004
Posts: 34
Groups: None
Auto-cost rule seems ok... I’ve checked it already.
Top
Mon, 2005-05-30 10:59
#7
Rolyn Jalea
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 2 Jun 2004
Posts: 34
Groups: None
Alex,
the budgeted quantity of some of my activities changes, some have increased and some decreases... there’s no pattern whatsoever. therefore my budgeted cost also changes. This is the first time I’ve encountered such problem like this. and this problem only occurs every time I import data (i.e. AS, AF & PCT).
Top
Sun, 2005-05-29 23:35
#8
Frank Borcherdt
User offline. Last seen 7 years 18 weeks ago. Offline
Joined: 3 May 2001
Posts: 88
Groups: None
Rolyn,

I would check your autocost rules (Tools, Optiosn, Autocost).

You mentioned it is cost loaded and you collect AS, AF and PCT. To have the system estimate the actual you will need to have the option checked to Use updated percentage against budget to estimate actual cost (or quantity) to date.

If these are not set and you are not collecting and inputting/importing the actual cost (or quantity) then as you import the AF the RD becomes 0 and forces the CTC and CAC (and QTC/QAC) to zero and you appear to lose those values from the Project.

HTH
Top
Sun, 2005-05-29 19:30
#9
Alex Wong
User offline. Last seen 11 years 4 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Can you please describe a bit more

is your quantity or $ changed
is increase or decrease
how you update your actuals (Import and Export)

cheers

Alex
Top