|
Employee Task Scheduling for up to One Year with Excel
-
Version
1.3
Employee Task Scheduling for up to One Year with Excel
Assign 50 daily tasks to 20 employees for one year
with up to three tasks per person per day. You specify
which tasks each employee is qualified to perform and
then specify the number of people (up to 5) you need
assigned to each task each day of the week. You then
proceed to assign people to the daily tasks for up to
one year. The program is best suited for situations
where daily tasks are relatively constant from one
week to the next. The scheduling sheet shows tasks
remaining to be assigned each day and up to 3 extra
(not previously specified as necessary) tasks that
have been assigned.
Statistics are gathered by the program to summarize
the number of times during the year each person has
been assigned to each task. Individual schedules, task
schedules and calendars are produced to show task
assignments.
The spreadsheet comes in several different sizes for
up to 80 employees and for 52, 26 and 13 week
scheduling.
Spreadsheets for other scheduling applications are
available at the website.
|