I do like the idea of using excel for their inputs and then once I input it into microsoft project, I could export the sub-projects to excel weekly and have them provide updates from that file each week. Just the overall PM has Microsoft project right now, but I could get it for the sub-project managers, but they don't know how to use it. They'd just be able to have better control of their sub-projects in the interim. It would save the manual input time by the overall PM, but everyone would still need to wait for updates to get the full picture. If things are more complex, and you don't have Project Server, then you'd do essentially the same thing but use a master project and sub-projects in MS Project. If it was consistently done, this could work. The overall PM would manually input all of this into MS Project and then regenerate the new sheets for the sub-PMs. These could be sent out to the PMs each Monday, and then they complete filling in updated actuals, ETCs, and any other changes and send back on Friday. ![]() What is the complexity of the work we are talking about, and how many tasks are the sub-project managers managing? If each of the sub-projects can be separated in the WBS, you could have the overall PM expert each subproject into separate Excel sheets for each of the sub-PMs. That said, a master project and sub-projects can be complex. Does everyone have Microsoft Project, or just the overall PM? If they all have it, then would seem its best long term to get the training needed to allow them to all use it.
0 Comments
Leave a Reply. |