Why Project doesn't update BCWP

[ma.u]

Hi,
I set physical progress for a task updating
MSP_TASKS.TASK_PHY_PCT_COMP field. Project documentation says that it
should recalculate MSP_TASKS.TASK_BCWP;
but it doesn't work. Why?
(DB is Sql Server 2000, MS Project version is 2003)
I use MSP_BACKUP_TASK on the modified task and set PROJ_EXT_EDITED =
'1'
Thanks.

 

[JackD]

Did you open the project in Project before you try this? The database does
not recalc on it's own. You need to have project open the file and calculate
and then resave.

 

[ma.u]

Did you open the project in Project before you try this? The database does
not recalc on it's own. You need to have project open the file and calculate
and then resave.

Sorry for my bad explain.
My problem is that loading project in MSProject, I expect it
recalculate values of my project so I can see new BCWP but it doesn't
happen.

Other ideas?
Thanks.

 

[Ed Morrison]

Do you have rates associated with the resources? Since BCWP stands for
Budgeted Cost of Work Performed, the result will always be zero if the
resources costs are zero.

BCWP formula is something like
BCWP=(total work) * (% Complete) * (hourly rate)



--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com

 

[ma.u]

Do you have rates associated with the resources? Since BCWP stands for

Budgeted Cost of Work Performed, the result will always be zero if the
resources costs are zero.

BCWP formula is something like
BCWP=(total work) * (% Complete) * (hourly rate)

In Microsoft Project 2003 CD, they say that before modify a MSP_TASKS
record I need to call procedure MSP_BACKUP_TASK that is:

-----------------------------------------
UPDATE MSP_TASKS
SET EXT_EDIT_REF_DATA =
'1,' &
TASK_ACT_WORK & ',' &
TASK_WORK & ',' &
TASK_REM_WORK & ',' &
TASK_DUR & ',' &
TASK_ACT_DUR & ',' &
TASK_REM_DUR & ',' &
TASK_START_DATE & ',' &
TASK_FINISH_DATE & ',' &
TASK_CONSTRAINT_TYPE & ',' &
TASK_CONSTRAINT_DATE & ',' &
TASK_ACT_START & ',' &
TASK_ACT_FINISH & ',' &
TASK_STOP_DATE & ',' &
TASK_RESUME_DATE & ',' &
TASK_PCT_COMP & ',' &
TASK_COST & ',' &
TASK_FIXED_COST & ',' &
TASK_ACT_COST & ',' &
TASK_LEVELING_DELAY & ',' &
TASK_PCT_WORK_COMP & ',' &
TASK_FIXED_COST_ACCRUAL
WHERE PROJ_ID=[PROJ ID]
AND TASK_UID=[TASK UID];
-----------------------------------------

While TASK_PHY_PCT_COMP is not backupped, I think MsProject can't see
if I modified that field.
Was I in wrong?
Or Microsoft forgot it?

Thanks