Easy Hour Assignments with Excel 1.66

Easy Hour Assignments with Excel 1.66 offers an effective tool which helps you to save scheduling headaches and time by letting you simply specify your daily staffing needs and then assign them to up to 25 people by inserting a number in the start time column.

You can assign up to 3 groups of hours (shifts) to each person and the program keeps track of your staffing requirements for 3 different groups of employees. Bar graphs keep you informed of your scheduling progress each hour of the week and show the hours each person is scheduled to work. Up to 10 vacation periods for each employee can be entered in the vacation table and you are prevented from assigning hours to employees who are on vacation.
This is a great scheduler for applications where your hourly staffing requirements fluctuate throughout the day and you need to assign shifts in an irregular fashion. It is also great for situations where your staffing requirements are rather constant, but you would like to think in terms of a person?s hours instead of shifts. The multiple daily shifts feature is very handy for businesses where people work a few hours in the morning and then a few more hours later in the day. The flexible scheduling is also great for scheduling people (like students) whose availability can change from day-to-day or change on short notice.

You can assign up to 3 shifts a day to each person by simply placing a number in one of the time columns. The scheduling is flexible enough so you can assign someone to work 6:00 AM to 8:00 AM then 11:00 AM to 2:00 PM and again from 5:00 PM to 7:00 PM for a total of 7 hours.
Outputs include individual and team schedules, an employee hours summary and a file that you can import into your Outlook Calendar, PDA or Smart Phone so your schedules will always be available for easy reference.
The Excel spreadsheets are available in sizes to schedule 25, 50 and 100 employees and can be downloaded from our website and used on a free trial basis for evaluation. Other easy-to-use spreadsheets to schedule your people to daily tasks or daily shifts are also available.
Spreadsheets for other scheduling applications are available at the website.

Major Features:

1. Lets you specify up to 10 vacation periods per person -  Also use this to schedule other absences.
2. Schedules employees in various categories (manager, clerk, technician) - Up to 3 different categories.
3. Lets you specify the number of people needed each hour of the week - For lots of flexibility.
4. Schedules employees to daily hours for four weeks - And up to 3 shifts a day for each person.
5. Tracks hours scheduled for each person - Updates after each assignment for instant feedback.
6. Bar graphs show over/under hours each hour of the day - Shows you where hours are needed.
7. Creates a calendar and group schedules - Keep your people informed.
8. Creates individual schedules for your employees showing daily tasks - Very handy indeed.
9. Can transfer your schedule into your Outlook calendar, PDA or Smart Phone - Just what I need.
10. Automatically e-mail schedules to your employees- WOW, That's Easy.
11. Schedule your employees to multiple daily shifts with Excel

Enhancements: Changed to Annual License

Requirements: Excel 97 or later