Hi,
Thanks for appreciation from all of u. Please chk this out.
Here is more towards attendance tracking. It's the next big thing. Yearly attendance tracking and see how good an agent is in his attendance by calc through simple formulas( at the end columns).
Once you have updated the monthly attendances, you can collate the data in this file and then have attendance performances defined for each employee at end of appraisal period.
Just a brief of the file
New things in this file:-
Date of joining of each employee
Non working days in initial month- employee might not join on the very first day of the month. we need to calc no. of working days already skipped for the month and update the non working days here manually.
e.g.
I join an organisation on 15th of September. To keep my attendance data at par with every one, you will note down my non wrking days which is 10 (we have to exclude weekends or scheduled roster offs). and enter this figure in this column. This will accurately bring me two formulas at the end.
Working days per month- days excluding any holidays or schedules offs/weekends
In the file there are 4 eg.
1) person joined on 9th jan - 5 non working day
2) person joined on 7th jan - 0 non working day
3) person joined on 9th july - 129(jan-jun) + 5(july) = 134 non working day
4) person joined on 1st jan - 129(jan-jun) non working day
-----
You need to update here the no. of planned/unplanned/camebut left/uninformed leave for each employee from their monthly data.
Absolute attendance: - Total no. of leaves (any type) divided by total workable days for each agent
Planned attendance: - Tracks unplanned leaves of agents keeping out the already planned leaves out of workable days.
Benefits:
A) Tracks individual attendance.
B) Gives idea about how healthy the attendance data we have.
C) Tracks two type of attendance:
1. Absolute attendance: - Total no. of leaves (any type) divided by total workable days for each agent.
2. Planned attendance: - Tracks unplanned leaves of agents keeping out the already planned leaves out of workable days.
D) Data for performance review.
E) Highlighting the grey areas and giving opportunities to focus on people with unhealthy attendance.
Thanks
Gurpreet Singh Mann