Be careful to for Set Baseline Selected tasks (rather than for the by carefully completing the Entire project) form as shown by the example to the right and for to the database Post Task Task Usage All Tasks Click on the Post Data for the Period ending 04/26/2015 Performance Vs. Baseline Performance group of the And Earned Value SSI Analysis Tools ribbon in Microsoft Project Make sure all the selections on Project Performance are as shown to the right and Earned Value Reporting then Click Post Current Period Data – Make an Earned Value report that shows Cumulative with a (showing and Current Period EV Change Log baseline changes from one period to the next) Click the Earned Value button on Project Performance and Earned Value Reporting Select the options named Get Cumulative & Current and Period EV, Make Pivot Table in Report Make on the form named Change Log Project Earned Value (see the example to the right) Reporting the Excel Icon or activate Excel to see the Earned Value report created by SSI Tools Does your report look like this? Does the sheet named ChangeLog look like this? Importing Actual Values When using or as the you can override Microsoft Task Work Task Cost Earned Value Unit of Measure, Project’s actual values by from an Excel worksheet. You can Importing Cumulative Actual Values import values or you can import values The for each Work Package at the Work Package Parent level. simple format for a worksheet contains imported values is as follows: Work Package or Work Package Parent ID Resource Name Resource Type (Labor, Material, Travel, Other Direct Cost for example) Cumulative Work amount Cumulative Cost amount Below is an example of a worksheet in excel containing Actual values for a project
Be careful to Set Baseline for Selected tasks (rather than for the Entire project) by carefully completing the form as shown by the example to the right Post Task and Task Usage for All Tasks to the database Click Performance Vs. Baseline on the Performance And Earned Value group of the SSI Analysis Tools ribbon in Microsoft Project Make sure all the selections on Project Performance and Earned Value Reporting are as shown to the right – then Click Post Current Period Data Post Data for the Period ending 04/26/2015 Make an Earned Value report that shows Cumulative and Current Period EV with a Change Log (showing baseline changes from one period to the next) Click the Earned Value button on Project Performance and Earned Value Reporting Select the options named Get Cumulative & Current Period EV, Make Pivot Table in Report and Make Change Log on the form named Project Earned Value Reporting (see the example to the right) the Excel Icon or activate Excel to see the Earned Value report created by SSI Tools Does your report look like this? Does the sheet named ChangeLog look like this? Importing Actual Values When using Task Work or Task Cost as the Earned Value Unit of Measure, you can override Microsoft Project’s actual values by Importing Cumulative Actual Values from an Excel worksheet. You can import values for each Work Package or you can import values at the Work Package Parent level. The simple format for a worksheet contains imported values is as follows: Work Package or Work Package Parent ID Resource Name Resource Type (Labor, Material, Travel, Other Direct Cost for example) Cumulative Work amount Cumulative Cost amount Below is an example of a worksheet in excel containing Actual values for a project