Schedule Crew Assignments for Your Employees 3.1

Schedule Crew Assignments for Your Employees permits you to assign 100 employees to 10 daily jobs Schedule Crew Assignments for Your Employees permits you to assign 100 employees to 10 daily jobs.
For example, if your company has several environmental cleanup jobs at different sites for different clients, you can assign employees in various categories such as foreman, crew leader, senior tech, junior tech, etc. with special qualifications or training such as asbestos cleanup, lead cleanup, etc. to each job each day for one week.
Or, you may need to schedule several different building trades such as carpenters, electricians, masons, plumbers, etc to various jobsites on a daily basis. Furthermore, your people have different skill levels such as foreman, senior level, junior level, etc. These can all be scheduled in our Crew Maker Spreadsheets.
Job assignments are made from drop-down menus of qualified employees and once someone is assigned to a job, his or her name is removed from the list to prevent the assignment to multiple daily jobs. The master list of job assignments changes each time you assign someone to a job as does the master list of unassigned people so you can see at a glance who is assigned and who is not assigned to a job each day.
Employee vacations, training sessions, and other absences can be recorded and the program removes their names from the job assignment drop-down menus on the days the person will not be available.
The spreadsheet comes in different sizes for between 50 and 200 employees and 5 and 25 different jobs.
Main features:
- Assigns Employees in Several Labor Categories to Various Jobs Each Day for a Week - Just what I need.
- Each Employee Can be Qualified in Multiple Labor Categories - Easy to keep track of your skill mix.
- Employee Vacations, Training and Other Absences Can be Scheduled - Lets you know who is unavailable.
- Prevents Multiple Daily Employee Job Assignments - And missed assignments too.
- Allows You to Carry Forward a Job from One Week to Another - This useful feature assures job continuity.
- Shows a List of Unassigned Employees for Each Day - Helps you to manage your labor-pool.
- Creates a Weekly Job Schedule Showing Each Persons Daily Assignment - Eliminates job confusion
System requirements:
- Microsoft Excel 97 or higher
Version restrictions:
- Limited schedule output