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.

resouces’ price/unit in P6

8 replies [Last post]
Mon, 2008-09-15 05:35
Mario Sabbioni
User offline. Last seen 16 years 3 weeks ago. Offline
Joined: 15 Sep 2008
Posts: 7
Groups: Civil Engineering
I’ve been struggling for days over this issue.
How can I import from xls to P6 the resources, keeping the price/unit?.
I’ve already created in P6 a resource list with the unit prices but whenever I try to import the assignments P6 doesn’t recognize the status "material" e the resources it imports are new with no price unit.
Making the resource assignment in P6 would be too long.
PLS can anyone help me?
Thanks
Top

Replies

Sun, 2010-03-28 08:43
#1
Abed Prnd
User offline. Last seen 14 years 17 weeks ago. Offline
Joined: 26 Feb 2009
Posts: 37
Groups: Civil Engineering
Thank you Rodel,
Worked like a charm!

Regards,
Abed
Top
Sun, 2010-03-28 04:18
#2
Rodel Marasigan
User offline. Last seen 6 weeks 3 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Abed,
If you don’t want to assigned resources to your activity you can still assigned cost without resources. You can enter the cost under Status Tab (right side of the Status tab change it to Labor cost) Before entering cost you need to set the Default Price/Unit for activities without Resource or Roles Price/Unit (say 1 or 100 or 1000 - It is recommended to use whole figure that easy to divide cost by adjusting the decimal only) under Project Module-> Calculation Tab (Click Project Icon or Select Enterprice-> Project from menu). Highlight the Project that you wanted to set then select Calculation Tab and under Activities enter the Default Price/Unit.
Top
Sun, 2010-03-28 03:57
#3
Abed Prnd
User offline. Last seen 14 years 17 weeks ago. Offline
Joined: 26 Feb 2009
Posts: 37
Groups: Civil Engineering
Dear planners,

maybe it has nothing to do with the subject of this thread (forgive me if so), but I wonder is there a way to assign costs to activities without bothering entering resources. when I tried, got this: "Cannot set cost because there is no price"

consider situations you need to enter JUST cost for activities with lump-sum price, outsourced, with various subcontractors or other similar cases.

Regards,
Abed
Top
Tue, 2008-09-16 05:04
#4
Mario Sabbioni
User offline. Last seen 16 years 3 weeks ago. Offline
Joined: 15 Sep 2008
Posts: 7
Groups: Civil Engineering
Thanks Arnold,
I’ve tried endlessly, and I’m quite positive I have to reassign all the resources in P6.
Bye
Mario
Top
Mon, 2008-09-15 23:23
#5
Arnold Puy
User offline. Last seen 10 years 3 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hello Mario,

I got what you really need. The reason why your Price/unit equal to zero after importing from excel to P6 is because, you did not RUN the "Recalculate Assignment Costs".

Go to Tools --> Recalculate Assignment Costs and see what happen to your price/unit.

Now, for changing of resource type labour to materials. You modify your resource assigment in excel sheet and not in P6. As I mentioned in my post #2 All Column’s title having this kind of symbol (*)the value cannot be changed.

You must first assign all the resources to your activities in P6 prior to exporting to excel just to get rid of resource type alteration.

The best way to change your resource type from labor to material is to re-assign the resources in P6 window by following the steps in post #2. But before doing this make sure to create backup and do not delete the resource assignment you’ve done before. Because, you can use this resource during filtering the activities.

Please let me know if what happen.

HTH.

Arnold




Top
Mon, 2008-09-15 10:42
#6
Arnold Puy
User offline. Last seen 10 years 3 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Mario,

If you already assigned the unit price for each resources in to your schedule then this will give automatically the budgeted cost. you don’t need to import the unit/price from excel to P6.

I don’t know if this is what you need. Can you can please elaborate in detail what do you really want to do or you can send me a screenshot in .pdf at p3-fer@sixco.ae

Thanks.

Arnold
Top
Mon, 2008-09-15 08:30
#7
Mario Sabbioni
User offline. Last seen 16 years 3 weeks ago. Offline
Joined: 15 Sep 2008
Posts: 7
Groups: Civil Engineering
thanks Arnold,
the main problem is that my resource assignment file is 11,000 rows. I have 330 resources and 1,450 activities.

In the first place I simply imported all from xls. into P3 and then into P6. Now there is no correlation between BGT units and BGT costs, though I imported both (since there is no price/unit defined).

Do you think there is no other way than to reassign all the resources?

RGS,
Mario
Top
Mon, 2008-09-15 07:33
#8
Arnold Puy
User offline. Last seen 10 years 3 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Mario,

Resource assignment in P6 is easier than in P3. Since you have already created the list of resources in P6 with unit price you can easily assign the resources to each activities. Try the following steps:

1. Select & Filter all the activities you wanted to assign the Resources.
2. Select the "Assign Resources" icon located at the right corner of your screen.
3. Select the resources to be assigned & tick assign.

After assigning all the required resources you can now export to excel and assign the budgeted units.

For the price/unit, you cannot modify this in excel sheet. All Column’s title having this kind of symbol (*), you cannot change the value.

If you don’t mind, you can forward to me your programme at p3-fer@sixco.ae I can do it for you.

Regards,

Arnold
Top