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.

Cost Loading

18 replies [Last post]
Tue, 2004-03-30 21:12
Forum Guest
User offline. Last seen 44 weeks 1 day ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Hi ,

There what is the easier way of loading cost in to P3.

Thansk & regards

Kumar
Top

Replies

Fri, 2004-04-16 19:24
#1
MK TSE
User offline. Last seen 4 years 51 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
If use Activity.xls, it is RA solution.
I wonder the business rule in P3 cause the problem. This need time to work out the rule and we self control what data to be input.
Top
Fri, 2004-04-09 19:08
#2
Forum Guest
User offline. Last seen 44 weeks 1 day ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Sorry for cofusion,

Basically the program consists of some completed activities, some in progress and the rest have not started ones.

The problem is how to import cost for all these activities, completed, in progress and not started activities in fast way.

I have tried using RA : in this method i could import resource assignment but not the cost. Cost might have imported but i could not see under budgetted cost

I have also tried with Excel importing and expoting (WK1 files): same problem

I have done using Access (DB1): resources are duplicated, original cost also there with newly assigned cost.


I hope time it is clear.

Thanks & regards

Kumar
Top
Wed, 2004-04-07 23:44
#3
Zq qz
User offline. Last seen 13 years 19 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
So if that the case filter / select only activity you want to update.
Top
Wed, 2004-04-07 21:04
#4
MK TSE
User offline. Last seen 4 years 51 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
To Forum guest(s),
I confused by the posted information in this thread. You have mentioned that resource can be import but not the cost item against it. Then mentioned about the problem is to those activities with progress. The latest is cost imported to 100% PCT activities.
May I ’re-form’ the problem, accurate cost cannot be import to P3 non-completed activity?

(It’s a problem to me that I’m not sure feedback is from same forum guest or not. If more than one forum guest join the discussion, difficult to get a solution. Just like all activities in a programme are marked "Concreting" without Activity Coding Value or WBS assigned)
Top
Wed, 2004-04-07 18:37
#5
Forum Guest
User offline. Last seen 44 weeks 1 day ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
I have done that, when I update in the access and exported back to P3, P3 is showing double entry, one is previously existing resources with previous cost and also the updated cost in access separately.This activity i am talking about is an 100% completed one.

any futher solutions
Top
Tue, 2004-04-06 23:50
#6
Zq qz
User offline. Last seen 13 years 19 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
You can do all this using MS Access.
first link Exported DB to MS access
2nd use query update , etc menu function
last import back to p3

Top
Tue, 2004-04-06 18:40
#7
Forum Guest
User offline. Last seen 44 weeks 1 day ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Not a probelm with access rights my friend.
Top
Sun, 2004-04-04 22:53
#8
MK TSE
User offline. Last seen 4 years 51 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Have you check the access right of the project? As you say, cost can be import. There is something to stop it.
Top
Sun, 2004-04-04 10:38
#9
Forum Guest
User offline. Last seen 44 weeks 1 day ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Most of the items you mentioned are calculated items not an input from the user.The cost is an input from the user which can be imported or exported.I am wondering why it is not happening in my schedule.

Thanks & Regards
Top
Sun, 2004-04-04 10:04
#10
MK TSE
User offline. Last seen 4 years 51 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
btw, onlt the following can be export but NO import: -
- Earned Value Cost (BCWP)
- Earned Value Quantity (BQWP)
- Activity Type
- Free Float
- Total Float
- Calendar ID
- Resource Unit of Measure (RUT)
Top
Sun, 2004-04-04 09:59
#11
MK TSE
User offline. Last seen 4 years 51 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
According to Primavera info, round the data to two decimal places before importing. Hope help.
Top
Sun, 2004-04-04 05:16
#12
Forum Guest
User offline. Last seen 44 weeks 1 day ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Hi,

I heard this problem is due to the some activities with progress.We can not use the techniques like RA , export and import when there are some actual dates,and we have to manually key in one by one if you want to be accurate.

Is this correct or any other ways of doing it faster?

Thanks
Top
Fri, 2004-04-02 21:29
#13
MK TSE
User offline. Last seen 4 years 51 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
May be some data format not accept. To test, input cost to one activity in P3, then use RA to retrieve the information onto Excel. Check the data format.
Top
Thu, 2004-04-01 23:24
#14
Forum Guest
User offline. Last seen 44 weeks 1 day ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
you all saying we can do it with RA.

But I have tried nothing comes up in P3 after i set costs from Excel sheet which is provided by P3 in CD.

1.I have imported activity data into activity infromation sheet.
2.I copy and paste activity ID into cost sheet and entered resources ID and cost.
3. I pressed set resources assignment costs.
4. In P3 resources can be assigned but no cost have been imported.

Please help.

Thanks
Top
Wed, 2004-03-31 09:59
#15
Luca Basile
User offline. Last seen 10 years 16 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
I am agree with RA is the easy way to do it.
You need a little knowledge of Vb and better Vba with excel or access, but after You can do what You want, not just load costs, resources, but standard reports that run automatically.

just a little effort at the beginning to same a lot of time during the project life.

What is not helping in the beginning is that with office xp Vba in access look like not the one for Office 97.
I had also some problem in excel as I prepared some routine in excel XP and in the office with excel 2000 are not able to complete the last step. Mainly is not able to save one sheet in DBIII format.
With the same P3 file in the laptop (XP) all work in the proper way.

Top
Wed, 2004-03-31 09:41
#16
MK TSE
User offline. Last seen 4 years 51 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
How about import/export or by RA? I think much better. If you want more information about RA, have the P3 software CD, one folder is named RA and both sample file and documentation are in this folder.
Top
Wed, 2004-03-31 09:13
#17
Martin Corkill
User offline. Last seen 3 years 19 weeks ago. Offline
Joined: 4 Jul 2003
Posts: 25
Groups: None
Using Global Change ?
Top
Wed, 2004-03-31 05:00
#18
Forum Guest
User offline. Last seen 44 weeks 1 day ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
There isnt one. But if its worth doing, its worth doing well
Top