Ned,
I'm proud of you actually. You were able to sift through our suggestions
and philosophies and come up with an approach, that as you understand
it, will meet your needs. I may not agree with your chosen approach but
then, I'm not the one in your situation. My comments are shown below.
With regard to MY specific problem(s); the conclusion I've come to is
[simply] this:
1) Each of the project managers creates their own "sub-project",
completely free of constraints. They spell out their portion of the
project as they see it. This is NOTHING more than a list of tasks in
outline organization, with NO dependancies. They do, however, assign
resources, and fill in durations/est. durations.
We actually had a similar, I guess I'll call it fear, with the CAMs at
our company. I always told the cost account managers (CAMs) to work on
their "live file", (the actual project file that was used to create and
track the plan), but I found some of them were just uncomfortable or
scared and wanted to work on their plan off on their local hard drive
(our "live files" were on a shared server). I tried to tell them that
there was nothing they could do that couldn't be fixed and sure enough
we did have some "incidents". Well, that's more of a story than a
constructive comment so here's my take on what your are doing. Although
it would probably be (or have been?) easier for your CAMs to develop the
task list in Excel, it certainly can be done in Project. Many people do
a plan in Excel and then transfer it to Project. Excel is just a lot
easier to work with for most people.
2) Each sub-project is then consolidated into the "master" project by
COPYING the tasks - no linking, no copy/link, just a raw consolidation
of the tasks. During this process the "master project manager" (which
in our case is more than 1 person), will organize a "full project"
outline, and place & consolidate tasks appropriately.
You do NOT have to use copy/paste to create a master from the separate
files. As a matter of fact that is a very inefficient method. Rather, if
you do NOT want the original individual files to remain active after
they are initially uploaded to the master (i.e. statically consolidated
master), then go to Insert/Project and in the Insert window that appears
uncheck the "Link to project" option at the bottom of the window. Then
select all the subprojects and "Insert". Basically, it will create a
single file of all the subprojects at that point in time. That master
can then be manipulated (e.g. eliminate duplicate tasks, link dependent
tasks, etc.).
If you really want to use static master, (I still think a dynamic master
is a better approach), then the Program Manager needs to designate ONE
person to be the "curator" of the master file. Otherwise the "too many
cooks" rule will apply. Now, there's nothing wrong with a big "come to
grips" meeting to get everybody's input when the master is built and
tweaked to be the working file, but in the end, only one person can be
the user of the master file.
3) Dependancies are now linked, and if one manager wants to "keep
tabs" on a task or group of tasks that they have little or nothing to
do with - they assign themselves as a "1%" resource. This allows
managers to filter the [full] project and see ONLY the things that they
own, or have interest in.
This is an unnecessary complication and does not reflect what you
intend. Do NOT keep tabs on unrelated tasks by artificially assigning a
resource. Bad idea. A much better and simpler approach is to assign each
CAM a spare flag field, (or a coded spare number field could also be
used), and then set the flag for all those tasks that are of interest to
the CAM. A simple filter can be used to show just those tasks.
4) This unfortunately means that only 1 manager can be editting the
project at a time, and it also means the project file can ONLY be
worked on IN THE OFFICE. (Many of our people spend time working from
home; so they wanted to take their "sub-project" home to work on).
That's right, by using a static master, you have now limited yourselves
to effectively having one person responsible. The exact opposite of what
I was suggesting originally. In this regard a dynamic master works much
better because CAMs can indeed work on their own file and do it remotely
(i.e. home, remote server, etc.), but those files are still subject to
review.
Interested in hearing both of your opinions.... although I'm assuming
Steve in particular will take issue with #1. You strike me as more a
"lay out the structure first, and fill it in with the actions to fit
that structure" type of guy. I'm more a let the actions dictate the
structure type of guy. Both approaches have merit, but I think mine is
more common, and works better in small companies. I think the
structure-first approach is far better suited to large companies, where
way too many cooks get involved (and would make my approach a
nightmare).
I'm VERY interested in both of your comments re: #'s 3 & 4. Curious if
you have a better idea.
While I now believe this to be the best solution for our problem - I
must point out, it's the best solution AVAILABLE TODAY. I still believe
that project isn't the right tool in our situation, and I'm sure many
others (short of any significant upgrades). (I'm really complaining
about #'s 3 & 4 here - so maybe 1 of you will tell me I'm full of it -
which would make me very happy!)
Wrong. Project is designed for creating, tracking and managing schedule
plans - big or small. No upgrades are needed for what you need, its
already there and has been since Project was first introduced years ago.
What did you have for breakfast? That's the only thing you are full of

Just because you are having a difficult time getting your arms
around Project and the best way to use it in you situation, doesn't mean
you are off base. Far from it. Rather, you are just another user who is
struggling to learn a not-so-user-friendly tool. In my opinion learning
to use Project effectively is a long term (i.e. years) proposition. Oh
sure, you can take a crash course or be taught by "experts" but
comprehension and effectiveness takes hands on experience and a lot of
it. Most of the MVPs have been using Project for years and at least for
this MVP, I'm still learning.
The only other thing I would like to add to the ongoing discussion, is
that you can't always run changes thru "management" for approval. Many
times, the changes are simply a matter of fact, and it's their NET
EFFECT on the project as a whole that the management needs to address.
So I would argue that the managers will and should make whatever
changes they see fit (without approval - but within the scope of their
power), and their effect on the whole project (as evidenced by the "new
timeline") would be addressed in group meetings.
Many changes to the project plan (e.g. format, views, even some
structural changes) do not need review and approval from the Program
Manager. However, any changes that materially affect the plan cost or
timeline need some type of formal review for a check and balance
approach. I already talked about my belief in regular communication
amongst CAMs and with Program Management in periodic formal reviews. If
appropriate, the customer should be involved in major decisions also
(boy can that be a scary thought sometimes).
John