Tuesday, October 18, 2011

Another promise fulfilled…

A HUGE thank you to all who attended my presentation of the Versatile Company’s “Tips and Tricks” webinar on October 13th. There were many comments and during the webinar I made a promise which I am fulfilling here - creating a custom field with a graphical indicator. The directions below apply whether using Project 2007 or 2010.

In this post we will create the baseline checker that was shown in the webinar. The field we’ll customize is “Text1”, and we will assign graphical indicators to show the results of the check for each task. (Click on any image in this posting to examine the detail being shown.)

1 custom_fields

Step 1: Insert the field to be customized. In the Gantt Chart view click on the column heading where you wish to insert the new field, then press the Insert (Ins) key on your keyboard. The “Column Definition” dialog box will appear. In this dialog box find the “Text1” field in the “Field Name:” drop down list and select it. Click on the “OK” button. Your “Text1” field should now be visible.

A field name should reflect its purpose. In this example, the field name “Text1” becomes “Baseline?” indicating whether each task is baselined or not.

Step 2: Rename the field and create the formula. Click on the “Tools” menu and choose “Customize”, then “Fields…”

The “Custom Fields” dialog box will be offered.

2 Custom_field_and_formula

Ensure that the “Text1” field is selected and then click on the “Rename…” button and rename the field to “Baselined?”. Click on the “OK” button.  Next click on the “Formula…” button and enter the formula exactly as seen in the image above. This is the formula that returns the state of each task’s baseline. Each non-summary task should now have either “Baseline!” or “No Baseline!” in the new “Baselined?” field, depending on its state..

Step 3: Create graphical indicators.

Click on the “Graphical Indicators…” button to match indicators to the results of the formula. Enter the data needed exactly as seen in the image below.

3 Indicators

Click on the “OK” button. Do the same for the “Custom Fields” dialog box. You’re done! Now the baseline state is visible and easy to evaluate.

Once you get the hang of custom fields and graphical indicators, you can dramatically reduce the time needed in your projects for analysis.

If you really liked this information on customizing Microsoft MS Project, join me on future webinars! Like my Project Server webinars, the Microsoft Project webinars fill very quickly. Why not sign up now?

Sign up for free webinars HERE.

If you’d like more information on these webinars or our training, please call Jon Wagner at (206) 417-2295.

Monday, October 3, 2011

Realistic Project Modeling: the Mid-Point Schedule Technique

The subject of mid-point scheduling has risen continually over my career. I created an article to explain the technique several years ago and popular demand has convinced me its time to examine it again…

Not every project schedule has a clear beginning with an obvious first task or milestone start date. The following training event project model is driven by a task within its project task list. What precedes the training event may be logistical tasks that have a date related dependency with the start of the event, such as material shipping, travel arrangements and travel. What follows the training event will certainly have a date related dependency with the finish of the event, such as travel home and invoicing. The start and finish dates of the project and all tasks are therefore determined by the training event’s start date and duration. Adjustments to the training event start date will change the dates of every other task in the project, but keep the project task sequence and any imposed lead times intact in the schedule. Thus the project as a unit can be moved in the timeline.

There are seven tasks in the model. Along with the sequencing and lead times, the start date and duration of task number 5, “Train Participants”, drives all task dates. It is the mid-point driver and is the key to understanding the model. It is also the only task constrained to a specific date.

The start date of task 5 determines the finish date of task 4. The relationship between the two tasks is start-to-finish.

The finish date for task 3 depends on the start date of task 5 and needs 7 days of time for the material to actually be shipped and received. This relationship is also start-to-finish.

In this model tasks 2 and 3 may occur concurrently and so a start-to-start relationship is utilized.

The start of task 2 drives the completion date of task 1 due to the time required to communicate/negotiate the logistical needs of the training event.

Tasks 6 and 7 are the follow-up events from the training and are sequenced with the default finish-to-start dependency type.

Here’s how to create the model if you want to try it out:

Step 1: Create the Task List


Step 2: Sequence the tasks in the Task List


Step 3: Constrain the mid-point-driver


Step 4: Analyze the Gantt Chart for Accuracy


Here is how to adjust it to your dates:

If the start date for the event needs to be modified, it should be re-constrained to the new date as described above. The Gantt Chart below shows the new date for the training event as January 10.


The remaining tasks in the project are then driven to new dates by the same sequences and lead times resulting in the project moving as a unit to the new location in the timeline.

An error message may warn you that a task in the sequence is occurring before the project start date. This message is driven by the start date found in Project Information. Adjust the date manually to embrace the new project start date and the message will no longer appear.


Give it a try! Mid-Point Scheduling has served me well for many years in consulting, in training and for life in general.

If you really liked this information on Microsoft Project’s scheduling features, join me on October 13, 2011 in a free webinar entitled Tips and Tricks. This is the first of a two part presentation that I know you’ll love. Like my Project Server webinars, my Microsoft Project webinars fill very quickly. Why not sign up now?

Sign up for one or both HERE.

If you’d like more information on these webinars or our training, please call Jon Wagner at (206) 417-2295.