Is it possible to represent BCWS in hours?
-
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
Hi Kevin,
If you assume the resource standard rate is $1, EV values are same for hours and cost.
Example:
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)
Thanks
Chak
Chak Tukkadi pVector Technologies Consulting: http://www.pvectortech.com Blog: http://www.epmcentral.com -
2010. augusztus 27. 7:38ModerátorYou can use rate B for teh $1 rate and swap as required
The one and only Project VBA Book Rod Gill Project Management -
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átor You 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
- Válasznak javasolta: Marc Soester [MVP]MVP, Moderator 2010. augusztus 28. 1:37
- Megjelölte válaszként: Christophe FiessingerMicrosoft Employee, Owner 2010. augusztus 28. 4:55
