Assign your employees to daily shifts and tasks with Excel

Creating Award-Winning Scheduling Spreadsheets
Since 1998

Assign your employees to daily shifts and tasks with Excel
Schedue and Monitor Batch Processes with Excel
Schedue and Monitor Batch Processes with Excel
S1 Simple Scheduler
S2 10 Shift Automatic
S3 Template Scheduler
S4 Complex Shifts
S5 Random Shifts
S6 Multiple Daily Tasks
S7 Split Shifts
S8 Daily Shifts & Tasks
S9  Auto Doctors Calls
S9 Manual Doctors Calls
S10 Crew Maker
S11 Floor Schedules
S12 Class Scheduler
S13 Nurse Dispatcher
S14 Task Scheduler
S15 Easy Shifts
S15 Easy Tasks
S15 Easy Hours
S15 Easy Hours & Tasks
S16 Shift Calendar
S16 Task Calendar
S16 Shift & Task Calendar
S17 Limited Availability
S18 Process Scheduler
S19-Bus Scheduling
S20-Training Tracker

S18 Process Scheduler

 

The Batch Process Schedulers can be used to schedule equipment to consecutive batches (or jobs) or to schedule people to consecutive tasks.

The batch schedulers are available to track job progress in either hours or in days. The hours tracker shows jobs scheduled by hours for 31 days and the days tracker shows jobs scheduled each day for up to 6 months.

Each scheduler can track as many as 20 jobs for each of 10 people or processes. As the jobs are completed, they are removed from the list, making room for additional jobs.

The order in which the jobs are to be performed can be easily changed to reflect new priorities.

Both the hours tracker and the days tracker spreadsheets allow you to specify up to 20 holidays and to specify which days of the week you work. The hours tracker also allows you to specify the hours that you work each day.

You simply list your jobs and their duration and specify the start time for the first job. The scheduled start and stop times for all future jobs are automatically calculated and updated each day.

Jobs assigned to each person or process are charted to give you a graphical representation of the progress of each job.

This type of scheduler is often used in businesses that operate numerous batch processes (such as heat-treating ovens) with jobs for numerous customers scheduled for each process. With our scheduler you can easily find any of the hundreds of jobs and to easily reschedule any of them in response to new priorities.

The scheduler can also be used to assign, reassign, and track tasks to your employees.
 

Schedue and Monitor Batch Processes with Excel
 

The S18-Process Schedulers Have The Following Features:

Schedules people to up to 20 consecutive tasks - Enough for any business.
Schedules batch processes to up to 20 consecutive jobs - That's a lot of jobs!
Calculates the start and stop time for each job - That's really handy.
Lets you change the order in which the jobs are to be performed -
Oh so flexible.
Allows you to change the scheduled job duration at any time -
Giving you complete control.
Allows you to specify up to 20 holidays and weekly work days and hours -
That's more than enough.
Provides a table of all scheduled jobs with start and stop times -
For those who like tabulated schedules.
Provides a chart of all scheduled jobs with start and stop times -
For those who like charted schedules.

Schedue and Monitor Batch Processes with Excel

 

Click Here to See Some of the Hourly Batch Process Scheduler Sheets

This link will open a small Excel spreadsheet with sheets from the scheduling spreadsheet for your review. You can select a full spreadsheet to download and try by clicking on the link in the table below.
 

Click Here to See Some of the Daily Batch Process Scheduler Sheets

This link will open a small Excel spreadsheet with sheets from the scheduling spreadsheet for your review. You can select a full spreadsheet to download and try by clicking on the link in the table below.
.

Schedue and Monitor Batch Processes with Excel


You can download any of the spreadsheets and use it freely for as long as you like with minor restrictions as described on the Welcome sheet. Once you register (purchase) the spreadsheet, a password will be provided to remove these restrictions.


Click on the Spreadsheet Name to Download it and on the Price to Purchase it

   Name

Time Unit Employees or Processes Jobs per Process or Tasks per Person Price
  S18-D-5-20 Days 5 20 $99
  S18-D-10-20 Days 10 20 $149
  S18-H-5-20 Hours 5 20 $99
  S18-H-10-20 Hours 10 20 $149

Click Here for information about the download process
 

Click Here for information about the purchase process

You can have a backup CD with your spreadsheet mailed to you. Since most customers order one, it is automatically put in your shopping cart. Simply remove it if you do not need a backup CD.
 

Schedue and Monitor Batch Processes with Excel

"This is a great way to track my people as they move from one project to another and it lets me see the affect one project's schedule has on the next one my people are assigned to do." - Taylor in Berkeley


It is very easy to see how schedule changes can ripple through all of the other tasks assigned to an individual.
 

 
Nelson in Pennsylvania told us that he is using this spreadsheet to schedule heat treating batch jobs in his foundry and that it helps him to juggle jobs as priorities change.

Yes, you can change the order jobs are arranged in the queue and see the effect on the timetable for all of the jobs.
 
 
You will need a file compression utility such as WinZip to unzip the download. M.Dev Software has an excellent free file compression utility that you can download by clicking on this link

 

Schedule your employees to shifts and tasks with Excel
Clicky Web Analytics