Home > Business & Finance > Project Management

Do you employ college students or others with limited availability or do you need to assign your people to a different tasks or locations several times each day? If that sounds familiar then try the new Excel spreadsheet where you can specify up to 6 daily time slots each employee is available. Then go on to assign your people to daily shifts, tasks or locations in 30 minute increments from drop-down menus of available people. Once someone is assigned to a 30 minute increment, his or her name is removed from the menu so they will not receive an overlapping assignment. It just couldn?t be any easier than that. Up to 25 different employee categories can be defined and each person can be assigned to up to 10 different categories defining his qualifications for different tasks. Detailed schedules can be created each day for a week while keeping track of the number of hours assigned to each person each day and the weekly payroll budget. Outputs include individual schedules, shift/task/location schedules and charts showing each person?s weekly assignments in a graphical format. Five spreadsheets are available in sizes for 25 employees and 25 shifts up to 300 employees and 100 shifts.