Home > Project Planning and Management User Guide > Creating the Gantt Schedule Help Topic Share

Creating the Gantt Schedule

Help for creating the gantt schedule in the project planning and management template for Excel

User Guide Navigation:
Business Spreadsheets User Guides: Project Planning and Management Multiple Regression Analysis and Forecasting Investment and Business Valuation Real Options Valuation Portfolio Optimization Portfolio Performance Tracking Customer Invoicing
Project Planning and Management Help Topics: Defining the Project Resources Defining and Entering Project Tasks Creating the Gantt Schedule Running and Analyzing the Project Status Report Participant Emailing and Workbook Generation

When the Auto-Timing process has been run, the Project Gantt Schedule can be recreated to capture the changes made in the project task timing. The Gantt Schedule schedules each task by phase according to the dates along the top row for which the frequency is specified in the 'Resources' sheet.


Each task's timeline is color coded according to the Phase colors specified in the 'Pre-Defined' sheet. Tasks that have been completed are colored in dark grey. Each colored cell in the task timeline is commented with the task details and participant's productivity schedule for the cells time period.


Underneath the Task timelines are totals of Full-time man hours (scheduled and completed), and Costs (operating, capital and total) for the time period relating to each column. If the selected scheduling frequency specified in the 'Resources' sheet is Days, then columns for weekends and public holidays are blocked out of the scheduling.


If the project deadline (also specified in the 'Resources' sheet) occurs before the expected end date of the final task, then the project deadline is marked and labeled on the schedule in red.

Screenshot: Creating the Gantt Schedule