You can also save upto ten baseline positions if you cant save copies of your schedule for some reason e.g. if you have live links to other projects. As an added bonus your gantt chart will have lots of coloured lines for each of the baseline positions which will baffle with science anyone who does not know much about schedules e.g. the management team. It does come in handy for getting snapshots and identifying trends against your original baseline over time, and you would be able to show in a report just the columns from previous months where you have baselined if you wanted.
Project, Project Information, set the Status Date.
After you set the Status Date to, say, some date a month ago, select all Tasks and hit the "Update As Scheduled" button on the Tracking Toolbar.
See the Tracking Table for % Complete for every Task.
Job done.
However,if you are going to look for the planned % Complete (as well as the planned everything else) for a month ago, you must use the plan that was the current plan on that date. You cant use this weeks plan for the status of a month ago.
Thats one (more) reason why you should save a copy of the plan every day, rather than just overwriting it every day.
Member for
18 years 2 months
Member for18 years2 months
Submitted by ronaldo celestino on Tue, 2009-01-20 07:13
However I am looking for a summary report page telling me % complete as of last month etc.
Oddly enough I think I have found the answer, by going back in time! Yes by altering the time clock on the PC back a month, then printing out a summary report!
Member for
16 years 9 monthsRE: MS Reporting
Hi Andrew,
You can also save upto ten baseline positions if you cant save copies of your schedule for some reason e.g. if you have live links to other projects. As an added bonus your gantt chart will have lots of coloured lines for each of the baseline positions which will baffle with science anyone who does not know much about schedules e.g. the management team. It does come in handy for getting snapshots and identifying trends against your original baseline over time, and you would be able to show in a report just the columns from previous months where you have baselined if you wanted.
Regards,
Will.
Member for
17 years 9 monthsRE: MS Reporting
Hi Andrew,
Do you archive your project files??
If I want to run a report retrospectively, I’ll just use a file from that reporting period.
Regards,
Darren
Member for
19 years 11 monthsRE: MS Reporting
Andrew,
You dont need to re-set the computer.
Project, Project Information, set the Status Date.
After you set the Status Date to, say, some date a month ago, select all Tasks and hit the "Update As Scheduled" button on the Tracking Toolbar.
See the Tracking Table for % Complete for every Task.
Job done.
However,if you are going to look for the planned % Complete (as well as the planned everything else) for a month ago, you must use the plan that was the current plan on that date. You cant use this weeks plan for the status of a month ago.
Thats one (more) reason why you should save a copy of the plan every day, rather than just overwriting it every day.
Member for
18 years 2 monthsRE: MS Reporting
Hi Andrew,
You cab also take the advantage of using formula on fields.
Regards,
Ronald
Member for
21 years 6 monthsRE: MS Reporting
well done dr. who
Member for
17 years 2 monthsRE: MS Reporting
Thanks Colin
However I am looking for a summary report page telling me % complete as of last month etc.
Oddly enough I think I have found the answer, by going back in time! Yes by altering the time clock on the PC back a month, then printing out a summary report!
Needs must
Thanks
Andrew
Member for
21 years 6 monthsRE: MS Reporting
Andrew
I would filter the tasks that are in that time frame.
Project/filtered for /date range
Select dates
Then, under the print options - select the date range you require.
File / print (timescale)
select dates
Hope this helps
Colin