annual vacation planner

**iamreese** · 11-08-2011, 11:27 PM

im currently doing a vacation planner for 2012 for 20 staffs. I need the following result:
12 months in one sheet
auto color for specific leaves
generates a report for specific employee

Are these things possible in excel?

**6StringJazzer** · 11-09-2011, 12:47 AM

It's all possible. You need to provide much more detail. For starters:

What are the types of leaves?

Why do you want a calendar with 12 months on one sheet? How will you use that?

What exactly is it that you want to be auto colored?

How do you want to enter the data for each employee's leave? I would suggest having one line for each instance of leave with the employee name, leave type, begin date, and end date.

What information do you want in the report for an employee?

Do you need anything else that you didn't happen to mention, like comparing amount of leave planned to the maximum allowed?

I suggest you lay out an Excel file that illustrates how you want it all to look. You don't have to put in formulas, just how you would want the results to look. Be sure you distinguish between what you want to happen automatically vs. where the user would enter data.

**iamreese** · 11-09-2011, 03:14 AM

Hi I have replied to some of your queries.

Originally Posted by 6StringJazzer

It's all possible. You need to provide much more detail. For starters:

What are the types of leaves?
Annual leave (days)
Sick leave (days)
Emergency leave (days)
Excuse (in hours)

Why do you want a calendar with 12 months on one sheet? How will you use that?
each month compose of the days, then the staffs will fill the days on the assigned codes (auto color).

What exactly is it that you want to be auto colored?
Auto color for each leave types, eg If annual leave has a code of A, once the staff enters A in specifc day, it will automatically make the cell red.

How do you want to enter the data for each employee's leave? I would suggest having one line for each instance of leave with the employee name, leave type, begin date, and end date.
I am not sure if this is possible that a field of FROM and TO (for dates) is available and it will automatically reflect in the calendar (with codes and color)

What information do you want in the report for an employee?
It is basically a summary of leaves taken with option of range of period, type of leaves taken. The report can be individually or as a group.

Do you need anything else that you didn't happen to mention, like comparing amount of leave planned to the maximum allowed? Yes, this can be included in the report.

I suggest you lay out an Excel file that illustrates how you want it all to look. You don't have to put in formulas, just how you would want the results to look. Be sure you distinguish between what you want to happen automatically vs. where the user would enter data.