how do i track staff absences
 

Hi,

I am looking for a 2009 staff calendar which tracks absences and annual
leave entitlements.

Thanks

how do i track staff absences
 

If you create the calendar/workbook we will help you with the formatting
or automation, what you have to remember is we dont know your business,
your numbers of staff, their working pattern, their annual leave
entitlement......etc, this is why you need to build a structure first
and get us to help with that.

Dg;333438 Wrote:
Hi,

I am looking for a 2009 staff calendar which tracks absences and
annual
leave entitlements.

Thanks


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93180

how do i track staff absences
 

I agree with the Code Cage team's comments. But I might also offer some
suggestions based on one that I helped flesh out (from the client's initial
design concepts)

One sheet was much like a table of contents sheet, with links to each of the
other sheets in the workbook, which were themselves detailed annual records
of each employee's attendance.

The individual employee sheets have basic information, including hire date
(so that leave accrual can be determined accurately based on tenure).

Down the left side, column A, is a list of months for the year, and a row
above them has days of the month. He used several codes to indicate the
reason for an absence in each of the daily cells for each month. You could
do that or just enter hours of absence, OR two rows per month, one for reason
for absence, second one to record amount of time absent.

He had one workbook for each division of the company, and the supervisor for
that division was responsible for maintaining it. There is also another
workbook that accesses all of the division workbooks and pulls in a summary
of information for all employees so that upper management can get an overall
view without having to open multiple books and try to figure out what's going
on within the company with regards to absences.

There's a lot of VBA code behind the scenes in all of these to keep them
coordinated, but if you have just a single workbook with all employees in it,
you can probably keep up with all of it with nothing but worksheet functions.



"Dg" wrote:

Hi,

I am looking for a 2009 staff calendar which tracks absences and annual
leave entitlements.

Thanks

how do i track staff absences
 

Excel templates Employee Absence Tracker

"Dg" wrote:

Hi,

I am looking for a 2009 staff calendar which tracks absences and annual
leave entitlements.

Thanks