Leave Record for small organisations

Dear All,

Please find the attached Leave record file. It will be suitable for small organisations.

Instructions for using this file

AL – Annual Leave (Privileged Leave )
CL – Casual Leave
SL – Sick Leave (Medical Leave)
CO – Compensatory off
WP – Leave With out pay
HD – Half Day

It has assumed that there are 8 Casual Leaves (CL), 7 Sick Leaves (SL) and 12 Annual Leaves (AL) (1 Annual Leave will be added every month) for the leave calendar. Also assumed that Saturdays and Sundays are holidays and compensatory off (CO) will be added if somebody present on Holidays (insert “P” if present on holidays – Compensatory off will automatically added). Half day leaves will be deducted from CL.

You can change all these parameters as per your needs.

Just enter the leaves as CL/SL/AL/CO/WP/HD in the respective date columns.

Also you can find a summary of leaves in the “Master Sheet”


Please let me know your valuble inputs so that i can improve this sheet.

Thanks & Regards

Deepu

Attached Files

leave_record_2007_143.xls (405.5 KB, 5934 views)

Excellent you have done great job.

Regards
Pramita

Thanks Pramita.

Regards

Deepu

Hi Deepu,

Good Work, Keep it up..

Thanks Sumathi,

Please let me know if you have any suggestions to improve this sheet.

Regards

Deepu

Hi Deepu,

Can u give me the leave policy and tell me the formula of leave calculation,how many leaves we have to give and how to calculate earned leave and paid leave.

waiting for your response

Regards
Pramita

Hi Pramita,

You can find the formula by clicking on the respective cells of the Excel sheet.

Please find attached file for the Leave Policy.

Regards

Deepu

Attached Files

leave_policy_203.doc (53.5 KB, 2878 views)

Excellent work........... Keep it up...

Regards,
Monika

A valuable contribution Deepu.

Regards,
~Raghav V

Hi Deepu !

It's nice to know that u r actively participating in the CiteHR !

Thats a very good contribution u have given !

Why don't u join us in the meeting being organised on 1st July07 (Sun) at 11:30 AM at Nirulas CP, New Delhi !

Please check from the latest thread as Ms. Anupama Saini is coordinating for the same.

It's nice to see that both of us from the same Organisation have become the CiteHR member !

Keep it up !

Thanks & Regards,

Pankaj Kumar Sinha
< >
GURGAON.
------------------------------------