Schedule Management Tools (T1)

Tool Name Description File to download
MS-Project Gantt to Spreadsheet This tool creates a simple MS-Excel spreadsheet representation of a Gantt chart created in MS-Project.

This package contains the following files:

  1. Sample MS-Project
  2. Sample Excel spreadsheet
  3. User notes
  4. A .bas file containg the macro for this tool
Download Package while having a coffee... pack
Operational Schedule Generator

This tool creates a MS-Project schedule for each team using the following definitions::

  1. List of Teams
  2. List of Releases or Subprojects
  3. List of Phases
  4. List of Worproducts required for each Release and Phase
Download User Notes Document

This package contains the following files:

  1. Template Schedule in MS-Project format
  2. SEP Matrix (Teams, Phases, Releases, Workproducts, Activities) in excel format
  3. User notes in ppt format
  4. Database in SQLite format
  5. Schedule Generator Engine (Python Application)
Download Package
Schedule Metrics Generator

This tool creates extracts key metrics from a collection of schedules in a program. These metrics include:

  1. Number of late start/finish tasks
  2. Number of tasks without or with multiple resources
  3. List of Phases
  4. List of Worproducts required for each Release and Phase

This package is planned to be released mid May 2020

Integrated Schedule Generator This tool generates an Integrated Schedule for a program consisting of multiple Sub-projects, Phases and Teams.

This package is planned to be released late May 2020

Operational Schedule Rollup Engine

This tool extract data from a all Operational Schedules in a program and inserts critical data in the Program Integrated Schedule. This data includes:

  1. Planned/actual start/finish data
  2. % complete
  3. Resources
  4. Schedule Performance Index (SPI)

This package is planned to be released late May 2020