Auto vs Manual Scheduling in Project

One small but important feature in MS Project is the Auto versus Manual Scheduling popup, in the Status Bar at bottom.

Here’s how it works:

Manual Scheduling allows the user to control start date, finish date, and therefore, duration. And the program will not change the dates of a manually scheduled task. Period. It might let you know if there are potential conflicts or problems with other tasks, but that’s up to you, as far as the program’s concerned. (If you can look at the project plan, especially in Gantt Chart view, most of those kinds of problems are fairly easy to spot, especially on adjacent or nearly adjacent tasks.)

Some people wonder, if this can become an issue so easily, why one might want to use it. The answer is, most project managers will start building the structure of a plan in Manual mode because it’s simpler, initially, not to have to worry about scheduling when the first goal is to get things written down and the basic sequence arranged. From what my students have told me, it’s often quite helpful to simply write the whole kit and caboodle down immediately, THEN worry about organizing and sequencing. (As one of my favorite literary characters said, “If you don’t write it down, it never happened.”)

Once that’s done, though, and the high-level tasks (or phases/stages) are in, switching to Auto mode is usually better. Because once you start linking tasks, and the plan starts really taking shape, you may still have some adjusting to do on dates and durations, but if the program can handle the basics, you the project manager can focus on the real trouble spots. “Which is, of course, the entire point.” (As Agent Smith said in THE MATRIX.) Auto mode, as you may gather, will allow more flex to a task and be more aware of adjustments that need making based on what’s going on around it—calendar specifics, constraints, and so on.

And since any task can be switched from Auto to Manual or vice versa at any time, you can fiddle with them whenever. You may not need to, but the program will not lock you in on this.

Using Effort Driven in Project

Even though Microsoft Project is fairly easy to use at the basic level–entering tasks and resources, assigning the one to the other, and fine-tuning a schedule–there are a few parts of the program that seem quirky, and can take a little practice to use comfortably.

One of these is the checkmark in the Task Information dialog box called “Effort driven”. The name is fairly self-explanatory, in that a task’s duration (the thing we normally concern ourselves with) can be affected by how much effort we want to put into the task, in the form of resources. Specifically, how *many* resources.

Effort driven checkbox

There is the quirk, though. This is how it works:

When the project manager first creates the task, it defaults to Fixed Units of work (stuffing envelopes for a wedding, or laying bricks for a wall would be good examples), and (if one chooses in the Program Options) Effort driven being on. The first time resources are assigned to the task, whether it’s one person, three, seven, or more, the duration won’t change. The program is assuming you know it takes, say, four days for six people to build a garden wall, and simply goes with the original duration. BUT…if, from then on, you change the number of resources (people, in this case), the program recalculates the number of days/weeks/etc. involved, as it assumes more people can do the task in less time, and vice versa. Not totally illogical.

Add resources and change duration

Nevertheless, there are some kinds of tasks for which the relationship doesn’t apply. If someone wants to interview a subject matter expert for three days prior to writing a manual, having one or two more people involved in the interview might help develop information, but probably won’t take substantially more time, or less.

So the trick, when one wants to add or remove resources without affecting duration in Project, is to open the Task Information box, go to the Advanced tab at top, and uncheck Effort driven FIRST. Then, go to the Resources tab, add or remove people or other resources, and OK out of the box. After which, if necessary, one can repeat the process and turn it on again.

On a more general level, depending on the task, the resources, and so on, one can remind oneself that it’s a good idea to go into the Task Information box->Advanced tab, and note the state of the checkbox before making changes.

Is there a suggested default? Hard to say. It depends on the nature of the projects and the tasks a project manager is involved in. A couple of guidelines might be:

  1. If the project will likely involve fairly frequent changes to resource assignment, leaving Effort driven off would probably cause fewer upsets to the schedule, though the manager would need to manually adjust it when needed.
  2. If the project resources are assigned and pretty much left in place, having Effort driven checked by default (again, this is an item in the Program Options which can be changed) would likely work in favor of the manager.

Program Options Effort Driven

Keeping the checkbox state in mind, then, can help avoid trouble when shifting resource assignments around.

Microsoft Project: Formatting a Gantt Chart for Summary Task

Recently a student posed a question during a Microsoft Project class. How does one format the bars of a Gantt chart to look the same for each unique summary task? Something that may look like this.


It begins with creating a custom flag field for each summary task. In Microsoft Project a flag field is a basic Boolean value. A simple yes/no field to identify further action. They are created using the Custom Fields button on the Format tab within the Gantt Chart Tools of the ribbon.


The Custom Fields button opens a separate dialog box with many options. Our first choice will be to select flag from the drop down list of data fields in the upper right-hand corner. We are presented with twenty (20) flag fields. Our example uses five (5) and each one needs a unique name.


That can be accomplished by selecting a flag, clicking rename, and supplying the new value.


Once our five (5) flags have been named we can click OK to close the Custom Fields window.


Next we need to mark our tasks as active (yes) or inactive (no) using the flags we just created. Insert a new column in the sheet view of the Gantt chart using one of our flag fields.


The entire column defaults to no but we will select the first task of our named summary and change its value to yes.


Once selected we can use the auto-fill handle (just like in Excel) to copy our yes across the remaining subtasks.


We will insert a column for each of our summary tasks and repeat the process described above.


The great thing is, once the tasks have been flagged we can hide the additional columns we just inserted.


At this point we are in the home stretch. There is only one more step necessary to finish. We need some custom bar styles to match our flagged tasks and that is done by choosing the Format tab within the Gantt Chart Tools of the ribbon and selecting Bar Styles from the Format button in the Bar Styles group. You can also double-click a blank area within the chart side of the Gantt Chart View.


In the Bar Styles dialog box we will scroll to the bottom of the list and add a new entry for each of our summary tasks using the name we gave to each flag. Shape, pattern, and color can be applied to each group and of course the flag number will be selected in the Show For … Tasks column.


Once complete, clicking OK will supply our newly flagged and formatted Gantt bars with the shape, pattern, and color we just set up.


Changing Microsoft Projects Default Task Duration

In a recent Microsoft Project class a question arose concerning the default task duration, which is set in days. This student had recently been working on a deployment project and the default duration was too broad. It needed to focus on a smaller time-frame and it made perfect sense to set the task duration to hours.

An excellent question and the answer couldn’t be easier.


To change the default duration for the tasks in a project we need to use the backstage options Microsoft Project makes available. By choosing the File tab and selection Options we are taken to the Project Options dialog box.


Once there we are presented with eleven options along the left side of the dialog box. Scheduling is the third option on the left and the one we are looking for.


In the Schedule section we will find Scheduling options for this project, and Duration is entered in will reveal the five choices we have:  minutes, hours, days, weeks, and months.


Also notice that the Scheduling options for this project can be set for only this project or for All New Projects.

Once the duration has been changed simply click the OK button in the lower right corner and you will be returned to you open project. Any value entered in the duration column will now default to hours unless you specify otherwise.



Understanding Task Dependency Types in Microsoft Project

Dependency Types in Microsoft Project

When creating schedules in Microsoft Project the first thing that a Project Manager would typically do is to input the tasks involved in a project. These tasks then need to be linked to show the relationship between them. These links create task dependencies.

There are 4 different types of task dependency:

  • Finish-to-Start (FS): The finish date of one task drives the start date of another.
  • Start-to-Start (SS): The start date of one task drives the start date of another.
  • Finish-to-Finish (FF): The finish date of one task drives the finish date of another.
  • Start-to-Finish (SF): The start date of one task drives the finish date of another.


Missing Resources when Using Microsoft Project Resource Pools

If you work with Microsoft Project and have ever leveraged the power of Resource Pools across multiple projects, you may have encountered a strange behavior when assigning those resources.


When you share resources between a Resource Pool file (a dummy project file that typically has no tasks but is merely a container for holding resources) and another project file, sometimes the resources don’t show up when it comes time to make the resource assignments. (more…)