The free attendance calendar template is one of my popular excel templates which has been downloaded over 100,000 times since I released it three years ago. Spares For Performance Power Tools. There are many requests came to my email about possibility to do template customization to suit their company needs which I couldn’t fulfilled due to my time limitation. But, I have kept those requests and feedback to create a more general employee attendance calendar template which could meet 90% of those requirement. And here it is, the new employee attendance planner and tracker template which is created with the same style with my previous Gantt Chart and Soccer League templates. If you have downloaded those lite templates, you will be familiar with the worksheets structure:). I have to make a different post for this template because there are many improvement have been made over the old one. I believe this template should help you ease your employee attendance recording job where it will automatically help you calculate it employee by employee where you can further analyze it to evaluate your employee performance.

I made two versions, lite and pro version, where the lite one is free, and you have to purchase a pro one if you want to upgrade it. The lite one only accommodate maximum 25 employees, 12-month period, four absence codes, Saturday/Sunday non working days selection and no layout customization, while the pro one can accommodate until 250 employees, 36-month period, eight absence codes, any non working days selection and layout customization. Other features are as follows: – Custom Month and Week name: If your language is not English, you modify its month and weekname into your own language. To further customize other words and titles, you need the pro one.

– Color marker: You will have options to hide or reveal color marker in attendance worksheets, available color markers are present marker, attendance code, holiday, non working days, and hired/resign markers. You can switch it on/off based on your selection in setup worksheet. – Carry Over period: if your company applied carry over attendance system, you can set the month period of that carry over. – Custom Holiday Dates: You can set your own holiday dates, your country or company official holidays where these holidays will be excluded in working days calculation. @rob: There is no password in allocation cells.

More Employee Absence Template 2010 Calendar images. Making an employee calendar in Excel isn’t hard. It becomes a reusable template to not only disseminate information but also keep track of employee patterns.