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.

Problems in cost loading in Excel sheet

2 replies [Last post]
Thu, 2010-04-01 10:02
Haresh Jayanth
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 24 Aug 2006
Posts: 219
Groups: Building Information Modelling, GPC Qatar
1) I want to export P6 files into excel and then cost load in excel sheet. Since WBS headings are not exported in Excel i am finding it difficult to export.....Any solution to export primavera files along with WBS and again to import back..

2) When i export my primavera program i got 5 sheets i.e. RSRC , TASKRSRC,PROJCOST,TASK & USERDATA. But when i tried to load cost under particular resources in Budget column and then import back , my cost are not reflected in P6. it shows "Zero value" . So what is the solution to import cost in Budgeted cost column under particular resource in excel and then import in P6.

Kindly guide on above two issues......
Top

Replies

Thu, 2010-04-01 23:09
#1
Ferdinand U.
User offline. Last seen 7 years 4 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
uncheck cost linked or use global change first
Top
Thu, 2010-04-01 21:42
#2
Rodel Marasigan
User offline. Last seen 17 weeks 2 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Haresh,
You can include WBS name when you export data into excel. When you run the export-> spreadsheet-(xls) and reached select template, click modify and select WBS name under general. There is a forum that I explain how to import cost into Primavera using export/import spreadsheet-(xls). I believed either Option 2 or 3 is appropriate for you to use. Instead duration use your estimated cost.

Duration Percent Complete Post #3
Top