% Complete to Date
in [Project]
|
From: Jon S. on 2 May 2008 14:18 I'd like to easily report what percent of work is complete as expected to be by date. Say I have tasks to be finished last week, this week, and next week. Some of my tasks from last week are done, but not all, yet some of my tasks to start next week have begun. Can project easily calculate some % complete to Date? Or atleast, even if it doesn't give me credit for that work I am ahead on, can it tell me if I'm up to date with what I said I would be by now? Jon S.
From: Andrew Lavinsky on 3 May 2008 08:49 If you've got cost associated with your project, you could use Earned Value - this is pretty much what it was designed to do. For expected Expected % Complete, you would most likely be looking at a custom formula like [BCWP] / [Baseline Work]. Then as you adjust the Status Date in Project > Project Information, the Expected % Complete should change. If you're not using cost, I am not sure how you would go about doing this. -A "Jon S." wrote: > I'd like to easily report what percent of work is complete as expected to be > by date. Say I have tasks to be finished last week, this week, and next > week. Some of my tasks from last week are done, but not all, yet some of my > tasks to start next week have begun. Can project easily calculate some % > complete to Date? Or atleast, even if it doesn't give me credit for that > work I am ahead on, can it tell me if I'm up to date with what I said I would > be by now? > > Jon S.
From: Andrew Lavinsky on 3 May 2008 10:00 Coffee wasn't kicking in yet, minor correction on the custom formula: Expected % Complete = [BCWP]/[Baseline Cost] "Andrew Lavinsky" wrote: > If you've got cost associated with your project, you could use Earned Value - > this is pretty much what it was designed to do. > > For expected Expected % Complete, you would most likely be looking at a > custom formula like [BCWP] / [Baseline Work]. Then as you adjust the Status > Date in Project > Project Information, the Expected % Complete should change. > > If you're not using cost, I am not sure how you would go about doing this. > > -A > > "Jon S." wrote: > > > I'd like to easily report what percent of work is complete as expected to be > > by date. Say I have tasks to be finished last week, this week, and next > > week. Some of my tasks from last week are done, but not all, yet some of my > > tasks to start next week have begun. Can project easily calculate some % > > complete to Date? Or atleast, even if it doesn't give me credit for that > > work I am ahead on, can it tell me if I'm up to date with what I said I would > > be by now? > > > > Jon S.
From: Andrew Lavinsky Andrew on 3 May 2008 17:28 3rd Time's a charm. This will definitely do it: Expected % Complete = [BCWS]/[Baseline Cost] > Coffee wasn't kicking in yet, minor correction on the custom formula: > > Expected % Complete = [BCWP]/[Baseline Cost] > > "Andrew Lavinsky" wrote: > >> If you've got cost associated with your project, you could use Earned >> Value - this is pretty much what it was designed to do. >> >> For expected Expected % Complete, you would most likely be looking at >> a custom formula like [BCWP] / [Baseline Work]. Then as you adjust >> the Status Date in Project > Project Information, the Expected % >> Complete should change. >> >> If you're not using cost, I am not sure how you would go about doing >> this. >> >> -A >> >> "Jon S." wrote: >> >>> I'd like to easily report what percent of work is complete as >>> expected to be by date. Say I have tasks to be finished last week, >>> this week, and next week. Some of my tasks from last week are done, >>> but not all, yet some of my tasks to start next week have begun. >>> Can project easily calculate some % complete to Date? Or atleast, >>> even if it doesn't give me credit for that work I am ahead on, can >>> it tell me if I'm up to date with what I said I would be by now? >>> >>> Jon S. >>>
From: Jim Aksel on 4 May 2008 10:22 Pardon the bump in. Using Earned Value techniques, Micrsofto Project automatically calculates Schedule Performance Index [SPI] and Cost Performance Index [CPI]. Insert those columns. SPI=Measure of Work Completed / Measure of Work Scheduled BCWP/BCWS. Above 1 is ahead of schedule, 1.0 is on schedule, less than 1.0 is behind schedule. The value is usually displayed as a percent 100%=1.0 CPI=Measure of Work Completed/Actual Costs BCWP/ACWP. Above 100% is below cost. CPI<100% means costs are exceeding plan... the work may be tougher than you thought. For our purposes BCWP=(%Complete)*(BAC). Now we get crazy -- MS Project can calculate using two methods %COmplete and Physical%Complete. %Complete deals only with duration and nothing else. If you claim 25% Complete you are saying your project is 1/4 of the time it will take to complete the task. Very few projects really work this way. However, when most people say they are 25% complete, they mean they have completed 25% of the work involved or 25% of the value (I have laid 25 of 100 bricks). Both of these measure are independent of duration. For example, work may not produce value or cost in a linear fashion. Planting corn has labor up front, while the corn grows there is less work, and harvesting includes more work. Generally, Physical%Complete is the most correct method to use in most instances. -- If this post was helpful, please consider rating it. Jim Visit http://project.mvps.org/ for FAQs and more information about Microsoft Project "Jon S." wrote: > I'd like to easily report what percent of work is complete as expected to be > by date. Say I have tasks to be finished last week, this week, and next > week. Some of my tasks from last week are done, but not all, yet some of my > tasks to start next week have begun. Can project easily calculate some % > complete to Date? Or atleast, even if it doesn't give me credit for that > work I am ahead on, can it tell me if I'm up to date with what I said I would > be by now? > > Jon S.
|
Next
|
Last
Pages: 1 2 3 4 Prev: BCWP and BCWS Next: Creating makeshift timesheets in Project (need an idea) |