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.

EV against Cost Account

5 replies [Last post]
Thu, 2007-11-22 06:00
Neil Wigmore
User offline. Last seen 10 years 29 weeks ago. Offline
Joined: 11 Jan 2005
Posts: 10
Groups: None
Does anyone know of a way to report Earned Value against Cost Accounts?

Currently we have multiple expenses against activities with mulitiple cost accounts. It appears that P5 will only allow EV to be calculated at activity level. Our cost system collects actual costs against cost accounts and we need to be able to compare one with the other.

Any suggestions?
Top

Replies

Thu, 2007-11-22 13:36
#1
Neil Wigmore
User offline. Last seen 10 years 29 weeks ago. Offline
Joined: 11 Jan 2005
Posts: 10
Groups: None
Hi Steve!

Tried the UDF route as well, but that doesn’t have the desired effect either, due to not being able to set resource fields equal to the value in an activity field. Going to try excel next, but really wanted to avoid doing that as it adds another few steps to the process where errors can appear.

Primavera have suggested using the SDK, but I think that is one for when we have a bit more time.

thanks for the input though
Top
Thu, 2007-11-22 09:38
#2
Steven Oliver
User offline. Last seen 11 years 43 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
Neil,

Earned Value in P3e is computed at activity level from the Performance Percent Complete and the activity budget.

The best workaround would be to create a User Defined Fields to calculate a Resource Percent Complete and Earned Value from the Resource Budget (or do it in Excel)
Top
Thu, 2007-11-22 09:16
#3
Mark Chapman
User offline. Last seen 8 years 31 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
I would have thought an activity could only have 1 CA. If you are going to use P5 then you will have to break your activities down per CA.

CA is available against resources.
Top
Thu, 2007-11-22 06:56
#4
Neil Wigmore
User offline. Last seen 10 years 29 weeks ago. Offline
Joined: 11 Jan 2005
Posts: 10
Groups: None
Thanks Mark,

but unfortunately that doesn’t work properly with multiple Cost Accounts. Where an activity has multiple accounts, the summary bands contain multiple accounts as well.

Using the expense or resource views doesn’t work either as EV is not an available field at that level, only at activity level.

Any other thoughts?
Top
Thu, 2007-11-22 06:39
#5
Mark Chapman
User offline. Last seen 8 years 31 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
Hi Neil,

Resources and Activities are the bottom level and this is where all the calculations start. WBS, OBS and CA are used for reporting levels. So its just the case of chnaging the reports from WBS to CA. If you go to Group you can select CA there.

I hope this helps and puts you back on track.

Mark
Top