how do i track staff absences

D

Dg

Hi,

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

Thanks
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top