Annual Leave Xls Download

-Hello Need help urgently.
i need to submit a report of annual leave with privilege / sick and casual leave calculation on prorata basis. can anyone help with the calculation pls.
i sort of need it urgently. i have created the file with rest of the details like leave taken by each employee but need to know their entitlement and how many leaves are etc when calculated on prorata basis.
would highly appreciate an urgent reply. my mail id
thanks

Hi
I have attached an XL file showing the calculation for leave on prorata basis
If you still have doubt be in touch
Siva