Scheduling in Excel - Project Management, Job Scheduling, Gantt Charts

Software : Schedulers : Spreadsheet Scheduler

$129.00

Functions

Project Management
Basic Job Scheduling
Gantt Charts

Low cost and easy-to-use spreadsheet templates for Project Management, Scheduling Customer Jobs and Employees, Generating Calendars and Gantt Charts. The Spreadsheet Scheduler is a toolkit containing 14 ready-to-use, practical models for a variety of common scheduling problems. The models are spreadsheet templates that work with all popular spreadsheets.

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 14 spreadsheet-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.

Gant Chart in days ( Gantt Chart for hours and weeks is also available)

Project Management : Critical Path Management in Days ( CPM for hours and weeks is also available)

Job Scheduling for Single Workcenter (also available job scheduling for 2, 3 and more workcenters in series and two workcenters in parallel)

Job Scheduling for Single Workcenter Chart

How does it Work

The Spreadsheet Scheduler includes Gantt Charting and 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.

Work flow and work-in-process models provide techniques for scheduling customer jobs through single workstations, workstations in series, or workstations in parallel. These models enable more efficient planning and accurate customer deliveries through minimizing average flow time, number of days late for jobs, and number of late jobs.

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.

FAQ

What is the difference between Spreadsheet Scheduler, Resource Manager for Excel, and Noah 2000?

Spreadsheet Scheduler includes a simple approach to Project Management and a quick method to generate Gantt Charts. It can be thought of as a ‘lower end Microsoft Project".

Resource Manager for Excel is User Solutions’ most popular package, offering a general purpose, flexible and adaptable approach to manage materials, workcenters, and labor for most manufacturers. It includes BOMs, MRP, Finite Capacity planning and scheduling, inventory, purchasing and receiving, costing, really just about everything for manufacturing management EXCEPT accounting,

Noah 2000 is a customized version of Resource Manager for Excel and focuses on forward scheduling, finite capacity, for jobs configured to run with a estimated number of hours per step. Noah 2000 allows the user to define independent workcenter calaendars, manages queue time, and is geared toward generating a realistic completion date and managing Jobs to meet the completion date.