2010. augusztus 26. 15:31
Our PMO wants to have two views for EV. One is pretty standard. It just shows all the built-in EV fields, (BCWP, BCWS, SV, etc...). Everything represented in dollars. However, they want a second view with those values represented in hours. It's an odd request, and I can't really find any examples of others doing this, so I suspect it's not very common.
Az összes válasz
2010. augusztus 27. 3:16
If you assume the resource standard rate is $1, EV values are same for hours and cost.
BCWP = % complete * (Planned Hours till status date * Rate)
If standard rate for resource is $1, so BCWP as below:
BCWP = % complete * (Planned Hours till status date * 1)
Chak Tukkadi pVector Technologies Consulting: http://www.pvectortech.com Blog: http://www.epmcentral.com
2010. augusztus 27. 7:38Moderátor
2010. augusztus 27. 16:16Thanks Chak, but what if I have different rates for different resources? Do I have access to that data in a custom field?
2010. augusztus 27. 16:25ModerátorYou could do it in Excel....export timephased Baseline Work & Actual Workto Excel into a table. Then calculate Cumulative Work and Cumulative ActualWork within Excel.BCWS => Cumulative Baseline WorkBCWP => % Work Complete X Baseline WorkACWP => Cumulative Actual Work....or something like that.- Andrew Lavinsky