Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i track staff absences
Hi,
I am looking for a 2009 staff calendar which tracks absences and annual leave entitlements. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting consecutive absences | Excel Worksheet Functions | |||
Count consecutive absences with a limit | Excel Worksheet Functions | |||
Adding absences in rolling twelvemonths in a calendar | Excel Discussion (Misc queries) | |||
Recording Absences | Excel Worksheet Functions | |||
how many staff have 1 skill, how many staff have 2 skills, etc. | Excel Discussion (Misc queries) |