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

The simple Excel based programs provide an easy-to-use set of tools to help any organization manage projects more efficiently, improve customer deliveries, and minimize work-in-process times.

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.

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.