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.

Total budgeted labor units does not match the same total calculated with excel

3 replies [Last post]
Jean Desjardins
User offline. Last seen 8 years 4 weeks ago. Offline
Joined: 7 Nov 2011
Posts: 23
Groups: None

Hello everybody,

I am experiencing a weird thing with Primavera P6 R8.3.

The total of budgeted labor units indicated at the top row does not match the same total calculated with excel.

I have no filter applied and no grouping, only the list of activities.

Does anyone has an idea of what causes this?

Thanks for help

Jean

Replies

BONG YAGAHON
User offline. Last seen 24 weeks 1 day ago. Offline
Joined: 5 Oct 2009
Posts: 43

Hi Jean,

Which one is the correct total ? Is it the excel calculated total or the P6 calculated total? There are a lot of things that may had happened which ever is the wrong one. Where is the data of excel coming from? I think you will generate more questions than answers if you are not specific with the problem.

Thanks.

BONG YAGAHON
User offline. Last seen 24 weeks 1 day ago. Offline
Joined: 5 Oct 2009
Posts: 43

 .

Zoltan Palffy
User offline. Last seen 3 days 21 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

possibilities 

1. Filter for All activities maybe you have a filter on

2. go to edit users preference and go to the time units tab and make your decimals under the units format and duration format there could be some rounding going on ?

3. how was the excel file created was it created from scratch or it it an export from p6 ? if it is an export from p6 chekc the filter of the export.

4. was the budget labor units imported form excel into p6 " if so maybe some did not make it into p6

solutions

open the excel file and sort on column A (activity id)

open P6 then filter where budget units is not equal to (blank) (only have the activity id and budget labor unit columns showing) sort order by activity id in p6 

go to edit select all then copy the info from p6 straight into excel 

in excel select data then 

select the column from p6 with the budgeted labor units in it then select text to columns

now insert a formula to compare the two columns of the budgeted labor units to see where your differences are