Schedule Your Work Crews to Various Daily Jobs with Excel by Chapman Software

Description

The crew maker spreadsheet allows you to assign employees to daily jobs or crews or tasks one week at a time and is ideal for businesses that need to create job-specific work crews that may vary in composition from day-to-day.

Up to 6 different employee categories and 8 different specialties can be assigned to daily jobs or crews. You can have categories such as foreman, crew leader, senior tech, etc. with specialties like carpenters, plumbers, laborers, etc. and schedule them to work crews that can change from day-to-day.

Individual 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 program maintains a master list of unassigned people so you can see at a glance who is not assigned to a job each day.

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 daily job assignments can be printed and distributed or they can be published to your website if you prefer to communicate with your people via the internet.

The CD includes 12 different spreadsheets that can schedule between 50 and 200 people to between 5 and 25 daily jobs.

Platforms

Windows

Product Features

• Twelve Excel spreadsheets of various sizes to schedule people to daily jobs or work crews.
• Your employees can be placed into up to 6 different categories and assigned up to 8 specialties.
• Daily crew assignments are made from drop-down menus of available people. Your employees are prevented from being assigned to more than one crew or job per day.
• Vacations, training and other employee absences can be scheduled. A master list alerts you to people without daily job assignments.
• Daily job assignments can be printed and distributed or published to your website.