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.

Updating via Importing Data from Another Project

1 reply [Last post]
Sun, 2009-03-08 12:48
R Jones
User offline. Last seen 12 years 47 weeks ago. Offline
Joined: 15 Sep 2005
Posts: 3
Groups: None
Hello

I have a baseline project which has subsequently had the resources (quantities) updated by a standalone user (i.e. working from a copy of the baseline). Unfortunately the standalone user has also added some new activities and progress.

My problem is I want to update the resource quantities in my baseline but don’t want any of the other updated information.

Is this possible as I have experimented with the Import wizard and also tried via excel but have been unable to import just “Budgeted Labour Units” and “Budget Nonlabour Units”

Apart from having to manually input the data to 8000+ activities does anyone have any suggestions?

Cheers
RB

Top

Replies

Mon, 2009-03-09 08:27
#1
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi R Jones,

First of all, welcome to Planning Planet.

Well, it is not very clear for me however, let me answer your question. But first make a backup to your project.

In order to update your Baseline Resource Quantities, go to Project --> Maintain Baselines and select the Baseline you wanted to update.

Select the "Update" button remove all the checks except for "Update exisitng activities already in the baseline" & "Ignore Last Update Date". In Specify the activities to include: select the "All activities" or filter the folowing activities you want to change.

Then select the "Update Options" radio button, under the "When updating resource assignment data, include:
Mark the checkbox next to "Update existing resource and role assignments" & "Budgeted units and cost" & unselect the rest of the checkbox then ok.

Then select "Update".

You can easily perform this exercise in excel sheet.

HTH.

Regards,

Arnold




Top