A while back I created a small SharePoint application to replace our whiteboard based utilisation forecast. Just having to use the whiteboard drove me up the wall and watching someone transpose all the data back to the starting column every 2 months was really productive (not).

The Gantt view is ideal for this although it has a few shortcomings:

• Can't change the bar colours (I would like to show confirmed, tentative and on leave as different colours
• Doesn't support web part connections

The default view for the list filters the list where the consultants name = [Me]. This makes it easy for consultants to keep their forecast up to date as they don't need to see the clutter of all the other forecasts.

For the resource managers, I created this view...

The list of consultants is rendered by a Data View and the hyperlink for the calendar image just appends the value for the column filter to the view url.

As you can see, I'm taking a long break after a very busy year.