Visual Earned Value Over Time Report
in [Project]
|
From: Anna on 8 May 2008 12:33 I'm working in MS Project 2007 and the service pack is installed. When I try to generate an earned value over time report by going to reports/visual reports/excel/earned value over time report/view, then clicking on Assignment Usage with EV tab, I am receiving 0 values. If I double click the Q2 it will drop down the weeks. If I double click the items listed under type in the Pivot table field list, the only value showing is under costs. How do you get the values to read under the planned, earned and actuals columns?
From: Jack Dahlgren on 8 May 2008 14:05 First, you need to assign resources to tasks within your project with costs associated with them. Second you need to set a baseline. Have you done that? Third, you need to set the status date. Have you done that? Finally you need to update the tasks with actual work done. Then the reports would be valid. -Jack Dahlgren "Anna" <Anna(a)discussions.microsoft.com> wrote in message news:101DC4CE-4A43-446D-BC19-F41C17C6C83A(a)microsoft.com... > I'm working in MS Project 2007 and the service pack is installed. > > When I try to generate an earned value over time report by going to > reports/visual reports/excel/earned value over time report/view, then > clicking on Assignment Usage with EV tab, I am receiving 0 values. > > If I double click the Q2 it will drop down the weeks. If I double click > the > items listed under type in the Pivot table field list, the > only value showing is under costs. > > How do you get the values to read under the planned, earned and actuals > columns? > > > >
From: Anna on 8 May 2008 14:27 Hi Jack! Resource have been assigned to the tasks. Cost have been entered in the task sheet under Fixed Cost because The costs are lump sum and not hourly. Should I enter the cost in the Resource sheet under fixed cost next to the resource it's assigned to? The baseline and staus dates have been assigned as well. What do you mean by actual work done? % Complet? Physical % Complete? or 5 Work Complete? or actual against remaining duration? "Jack Dahlgren" wrote: > First, you need to assign resources to tasks within your project with costs > associated with them. > Second you need to set a baseline. Have you done that? > Third, you need to set the status date. Have you done that? > Finally you need to update the tasks with actual work done. > > Then the reports would be valid. > > -Jack Dahlgren > > "Anna" <Anna(a)discussions.microsoft.com> wrote in message > news:101DC4CE-4A43-446D-BC19-F41C17C6C83A(a)microsoft.com... > > I'm working in MS Project 2007 and the service pack is installed. > > > > When I try to generate an earned value over time report by going to > > reports/visual reports/excel/earned value over time report/view, then > > clicking on Assignment Usage with EV tab, I am receiving 0 values. > > > > If I double click the Q2 it will drop down the weeks. If I double click > > the > > items listed under type in the Pivot table field list, the > > only value showing is under costs. > > > > How do you get the values to read under the planned, earned and actuals > > columns? > > > > > > > > > > >
From: Jack Dahlgren on 8 May 2008 16:24 Anna, There are a number of ways to enter progress so that % complete is updated. You get to choose how you want to do that. The earned value calculation method can be configured to use either % Complete or Physical % Complete and also which baseline to compare against. You can set that by going to tools menu/options/calculation tab and click the "Earned Value" button. Have you updated your fixed costs with the actual costs to date? Planned cost should come from the baseline Actual cost should come from the actual cost Earned value is based on % complete (either regular or physical) x planned cost. -Jack Dahlgren "Anna" <Anna(a)discussions.microsoft.com> wrote in message news:B98670AD-1156-433A-B419-1AA8090382AE(a)microsoft.com... > Hi Jack! > > Resource have been assigned to the tasks. Cost have been entered in the > task > sheet under Fixed Cost because The costs are lump sum and not hourly. > > Should I enter the cost in the Resource sheet under fixed cost next to the > resource it's assigned to? > > The baseline and staus dates have been assigned as well. > > What do you mean by actual work done? % Complet? Physical % Complete? or 5 > Work Complete? or actual against remaining duration? > > "Jack Dahlgren" wrote: > >> First, you need to assign resources to tasks within your project with >> costs >> associated with them. >> Second you need to set a baseline. Have you done that? >> Third, you need to set the status date. Have you done that? >> Finally you need to update the tasks with actual work done. >> >> Then the reports would be valid. >> >> -Jack Dahlgren >> >> "Anna" <Anna(a)discussions.microsoft.com> wrote in message >> news:101DC4CE-4A43-446D-BC19-F41C17C6C83A(a)microsoft.com... >> > I'm working in MS Project 2007 and the service pack is installed. >> > >> > When I try to generate an earned value over time report by going to >> > reports/visual reports/excel/earned value over time report/view, then >> > clicking on Assignment Usage with EV tab, I am receiving 0 values. >> > >> > If I double click the Q2 it will drop down the weeks. If I double click >> > the >> > items listed under type in the Pivot table field list, the >> > only value showing is under costs. >> > >> > How do you get the values to read under the planned, earned and actuals >> > columns? >> > >> > >> > >> > >> >> >>
From: Anna on 8 May 2008 16:45
I have the Earned Value Method set at % Complete. I only have one baseline. and that was the one I chose by going to tools menu/options/calculation tab and click the "Earned Value" button. As far as fixed cost with actual, no I have not updated. I thought that was calculated automatically through Project. When I go to view/tables/ more tables/ earned value, the information is already calculated with the exception of the CV (Cost Varience) field. When I go to the visual earned value over time report the planned, earned, and actual fields are 0 values. Is there a table like the task or resource sheet or a view Task/resource) that I should be in before clicking on reports to get those values to show the correct values on the visual report? "Jack Dahlgren" wrote: > Anna, > > There are a number of ways to enter progress so that % complete is updated. > You get to choose how you want to do that. The earned value calculation > method can be configured to use either % Complete or Physical % Complete and > also which baseline to compare against. You can set that by going to tools > menu/options/calculation tab and click the "Earned Value" button. > > Have you updated your fixed costs with the actual costs to date? > > Planned cost should come from the baseline > Actual cost should come from the actual cost > Earned value is based on % complete (either regular or physical) x planned > cost. > > -Jack Dahlgren > > > "Anna" <Anna(a)discussions.microsoft.com> wrote in message > news:B98670AD-1156-433A-B419-1AA8090382AE(a)microsoft.com... > > Hi Jack! > > > > Resource have been assigned to the tasks. Cost have been entered in the > > task > > sheet under Fixed Cost because The costs are lump sum and not hourly. > > > > Should I enter the cost in the Resource sheet under fixed cost next to the > > resource it's assigned to? > > > > The baseline and staus dates have been assigned as well. > > > > What do you mean by actual work done? % Complet? Physical % Complete? or 5 > > Work Complete? or actual against remaining duration? > > > > "Jack Dahlgren" wrote: > > > >> First, you need to assign resources to tasks within your project with > >> costs > >> associated with them. > >> Second you need to set a baseline. Have you done that? > >> Third, you need to set the status date. Have you done that? > >> Finally you need to update the tasks with actual work done. > >> > >> Then the reports would be valid. > >> > >> -Jack Dahlgren > >> > >> "Anna" <Anna(a)discussions.microsoft.com> wrote in message > >> news:101DC4CE-4A43-446D-BC19-F41C17C6C83A(a)microsoft.com... > >> > I'm working in MS Project 2007 and the service pack is installed. > >> > > >> > When I try to generate an earned value over time report by going to > >> > reports/visual reports/excel/earned value over time report/view, then > >> > clicking on Assignment Usage with EV tab, I am receiving 0 values. > >> > > >> > If I double click the Q2 it will drop down the weeks. If I double click > >> > the > >> > items listed under type in the Pivot table field list, the > >> > only value showing is under costs. > >> > > >> > How do you get the values to read under the planned, earned and actuals > >> > columns? > >> > > >> > > >> > > >> > > >> > >> > >> > > > |