Status dates in master schedules

[MikeF]

When you create a master schedule from subprojects that include different
status dates, is there any way to contol this in the master schedule? It
appears the master schedule only has the ability to set a single progress
date. I have 50 projects that I need to rollup and yet all will have progress
as of dates that are different. Help!

 

[Jim Aksel]

This needs to be accomplished with a VBA routine which recursively calls all
the projects. I have two macros that may help you.

1. Sets status date to the status date of the MasterProject file for all
inserted files, including files inserted into the inserted files (to any
depth).

2. A macro that sets a flag=True as a red dot next to every task that
requires a status update compared to the status date. Items Flagged:
Actual Finish>Status Date
Actual Start>Status Date
Incomplete work to the left of the status date
Tasks needing an update to Earned Value (such as %Complete)

In work: Tasks with a %Complete when predecessors are not complete

These are not freeware.
More info at jeaksel (at) yahoo (dot) com
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project