#1
|
|||
|
|||
Earned Value isn't recalculated by MS Project
Dear experts,
I can't solve such problem. I want to import from Excel such data: "physical % complete" and "actual work" to update Earned value (BCWP) and ACWP. I import only 3 fields: Task ID (task ID is used as a merge key to merge the data from Excel to Project), "physical % complete" and "actual work". Problem occurs when data is imported. "Physical % complete" and "actual work" fields are filled with excel data, ACWP field is recalculated according to new "actual work" data from Excel, but BCWP turns to 0. When write the same "Physical % complete" in the corresponding cells manually, the BCWP is recalculated as it should be. What is the problem with importing "Physical % complete" and recalculating BCWP, how to solve it??? Bellow is attached 3 screenshots: 1. Initial data in project 2. Excel data was imported ("Physical % complete", "actual work" and ACWP have been updated, BCWP turned to 0) 3. I just manually entered the same imported data over imported cells and BCWP recalculated) Updated "Physical % complete", "actual work" data is highlighted in yellow. Initial project data.jpg Excel data is imported.jpg Data is written manualy.jpg |
#2
|
||||
|
||||
Ilya,
I also encountered the same problem when I replicated the physical % import either through Excel or XML. Unfortunately, I don't know what is causing it but a workaround is to add a new Cost custom field, say Cost1 & rename it Calculated BCWP and enter the following formula. [Baseline Cost]*[Physical % Complete]/100 and for "calculation for task and group summary rows", select Rollup: Sum. Hide the default BCWP and display the Calculated BCWP field and it will work with both Excel import and manual update. =jerome |
#3
|
|||
|
|||
The problem is that ACWP isnt calculated by Project- it is the actual cost. You would need to add the "actual cost" column to the programme and fill it on. BCWP is based on the %age complete to findo ut what it should cost, whereas actual cost can be any number.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Earned Value Calculations - BCWP In Microsoft Project | Lenin | Project | 0 | 03-25-2016 09:20 AM |
Microsoft Project Managing Planned / Earned Value & Actual Costs | shane_dav71 | Project | 1 | 10-06-2014 06:07 PM |
MS Project not calculating earned value correctly | mtbtomo | Project | 1 | 10-23-2013 06:49 AM |
Finding Earned Values for Different Baselines in a single project | pratik6312 | Project | 1 | 08-22-2013 11:18 AM |
earned value not calculating | ketanco | Project | 3 | 08-16-2012 02:13 PM |