•Business » Spreadsheets » Schedule Multiple Daily Tasks for Your Employees with Excel
Schedule Multiple Daily Tasks for Your Employees with Excel 7.0
The Multiple Daily Tasks Excel spreadsheet assigns multiple tasks, shifts, or clients to your employees for one week. This series of spreadsheets is popular with home care businesses that send caregivers to several client homes each day. The spreadsheet can handle up to 20 employees and 50 daily tasks. You specify the availability of each employee each day, the name of the tasks, the days that each task needs to be performed, and employee qualifications/preferences. You then assign your employees to daily tasks from drop-down menus of available people. Daily staffing charts show at-a-glance, who is available for an assignment during a specified time-increment. The program interacts with QuickBooks Pro to transfer employee timesheet information for use in client invoices and employee payroll. The spreadsheet produces individual and group schedules and comes in sizes for 20, 40, 60, 80, 120, and 160 employees (and 50, 100, 150, 200, 300, and 400 tasks respectively).