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