Home > Business & Finance

Schedule Multiple Daily Tasks for Your Employees With Excel The Multiple Daily Tasks Excel spreadsheet assigns multiple tasks, shifts, or clients to your employees or multiple employees to your tasks, shifts, clients, or vehicles for one week. This series of spreadsheets is very 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). Microsoft Excel or compatible spreadsheet program is required. During the free trial period restrictions apply with respect to the number of schedules displayed. Spreadsheets for other scheduling applications are available at the website.