Attendance tracking format

its really helpful for me.Thanks to all

Nancy S

Hi Rahul,

0 stands for a person being present and no leave.

Suppose a person has taken leave on 5th of the month, then you will select the drop down menu on 5th infornt of his name and select the type of leave.
This will add up to his monthly total and daily total of the team

Thanks

Gurpreet Singh

U are smart singh

Lockwood

thank for sharing.Really helpful

Regards,
Sashi

Thanks for the compliment.

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

Attached Files

attendance_tracker_167.xls (33.5 KB, 444 views)

Its unbelieve, Grupreet, you are a GURU. this master piece, i like the way you share your knowledge. You will gain more and more.

Stephen Lockwood

Very Well Done!! Now I am gonna be coming at yer place tomorrow evening..explain me all

Good Posting !

Also in my Co for associates who fall in shift basis have fixed working time i.e every associate has to work for 9.00hrs a day . Hence we follow the same format with 2 additional rows i.e Intime and Out time.At the month end, the concerned authority also calculates if the associate has to be paid any OT or how many hrs they have taken off on any particular day etc...

Regards,
vandana.