Low cost and easy-to-use spreadsheet templates for Project Management, Scheduling Customer Jobs and Employees, Generating Calendars and Gantt Charts. The Excel Scheduler is a sub-set of the Spreadsheet Scheduler, containing all models except job/workcenter models.

Scheduling problems tend to be specific to the operating procedures of a particular business. Therefore, this collection can be used as a set of building blocks to develop custom applications. The spreadsheet environment is particularly suited for this since you can link, customize, expand, and consolidate the data however you wish.

The scheduling techniques include:

• job and task sequencing
• development of calendars
• Gantt charts
• due-date assignment
• computation of lateness and other performance measures
• scheduling of work according to precedence relationships

                                                                

How it Works

The Excel Scheduler includes CPM (Critical Path Management) models for hourly, daily, or weekly time units.

By determining early and late starting points for each task, as well as task duration and precedence relationships, the template generates a Gantt Chart showing which tasks are critical; that is, must be done on time, otherwise the entire schedule will slip.

Functionality also includes ability to do "what-if" analysis to accommodate changes without missing deadlines.

Features

The scheduling techniques include:

• job and task sequencing,
• development of calendars,
• construction of several different types of Gantt charts,
• processing idle periods,
• due-date assignment,
• computation of lateness and other performance measures, and scheduling of work according to precedence relationships.

These techniques can be extracted and assembled in many different ways.