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.

P6 Report Loading Error

4 replies [Last post]
Mon, 2009-03-30 23:01
Izam Zakaria
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 28 May 2006
Posts: 221
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Guys,

I’ve a problem currently which BQ was uploaded for quite example 10 000 mhrs. But the report just shown 1 000 mhrs (period totals)column only.Another 9 000 mhrs was allocated on (post) column.What the heck is this? I did on others project which used the same report group resource and the result is perfect. Guys pls help me
Top

Replies

Wed, 2009-04-01 01:12
#1
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 Izam,

Okey. You mean Export P6 to Excel sheet. You can even do this in P6 itself using global.

So, what exactly you need to export and modify it in Excel? The Units/Time, Budgeted Units or Duration?

I think the reason why the UPT remain to 1 it is because, the duration type is "Fixed Units/Time". Try to change it to "Fixed Duration & Units".

Now if you are trying to update your schedule, the UPT will change depending on the "Remaining Duration & Units".

Hope this helps.

Regards,

Arnold
Top
Wed, 2009-04-01 00:40
#2
Izam Zakaria
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 28 May 2006
Posts: 221
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Hi Arnold,

Sorry for not making it clear since I’m too rushing yesterday

As we know Budgeted Quantity = Original duration*units per day right? but the problem is all my UPT (units per day) remain to 1. Is not suppose to be, becuase it would calculate automatically once we drop BQ and OD status.

What I did yesterday, I convert it to P3 version then export it to excel direct do correction.

Done perfectly, but I didn’t find it at P6 software. Could u tell how to do this at p6 via excel spreadsheet?
Top
Tue, 2009-03-31 01:07
#3
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 Izam,

Can you cite an example, a little bit clearer.

Regards,

Arnold
Top
Mon, 2009-03-30 23:19
#4
Izam Zakaria
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 28 May 2006
Posts: 221
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
To make it clear, it’s loading 5 mhrs only per week....
Top