This is a simple excel spreadsheet to track your employee's attendance and plan your employee's vacation.
With one page attendance layout to cover one full year, you can easily track and plan your employee's vacation without switching to other worksheets to find their records. Included in this spreadsheet are custom codes with particular colors to ease you map different type of vacation/holiday.
To get started, you have to fill your company fiscal year start date and select your attendance observation period. You can customize four allocated vacation and holiday codes or leave it as it is. Then you can type your employee's information.
There is a summary vacation worksheet that will help you to calculate your employee's attendance monthly. Download and try the spreadsheet. And there is a commercial version where you can have it fully editable if you want to personalize it to meet your company's needs.
Requirements:
MS Excel 2007
Comments not found