Absence and Vacation Tracker (Excel)
Description:
This template was submitted by Jennifer Muhr. She says, "I'm a new member and wanted to share an excel vacation tracking template which you may find useful if you are an administrator who supports multiple individuals. I created this spreadsheet along with a colleague."
Instructions are outlined in the first tab of the spreadsheet.
Instructions are outlined in the first tab of the spreadsheet.
- Rating:
- Downloads: 2017
Related Downloads
-
- Performance Issue: Record of Conversation (WORD)
- Downloads: 849
-
- Memo: Written Warning of Performance Issue (WORD)
- Downloads: 923
-
- Sample Employee Performance Review (Word)
- Downloads: 1799
12-15-2008
, 11:24 AM
|
|
|
Managing Editor
Join Date: Mar 2008
Posts: 812
|
Absence and Vacation Tracker (Excel)
This template was submitted by Jennifer Muhr. She says, "I'm a new member and wanted to share an excel vacation tracking template which you may find useful if you are an administrator who supports multiple individuals. I created this spreadsheet along with a colleague."
Instructions are outlined in the first tab of the spreadsheet. |
12-15-2008
, 08:54 PM
|
||
|
OA Expert
Join Date: Dec 2008
Posts: 1
|
Re: Absence and Vacation Tracker (Excel)
Quote:
Thanks, T |
|
12-15-2008
, 09:31 PM
|
||
|
OA Spectator
Join Date: Dec 2008
Posts: 1
|
Re: Absence and Vacation Tracker (Excel)
Quote:
|
|
01-01-2009
, 09:00 AM
|
||
|
OA Spectator
Join Date: Dec 2008
Posts: 2
|
Re: Absence and Vacation Tracker (Excel)
Quote:
The Absence and Vacation Tracker which Jennifer Muhr posted is lovely, but I am having great difficulty with one area - that being the formula below. Jennifer gave instructions on how to copy it to the new employee line which I've added, but I cant change the formula name (eg Tibbits, W or the like). It just comes back error in formula. I was wondering if you could give Jen my email address, and perhaps she would lend some assistance to me. I've posted it in "questions"but am still awaiting someone (anyone's) response. I NEED HELP! Urgently. I would appreciate anything you can do. wjtibbits@hotmail.com =SUM(IF('Tibbits, W'!$A$13:$G$24="S",1,IF('Tibbits, W'!$A$13:$G$24="v",1,IF('Tibbits, W'!$A$13:$G$24="p",1,))))+W8 |
|
01-01-2009
, 10:40 AM
|
|
|
OA Expert
Join Date: Dec 2008
Posts: 2
|
Re: Absence and Vacation Tracker (Excel)
Short instruction assuming the name of Abraham Green as a new employee:
1. Insert a new worksheet and name it Green 09 2. Copy (with Ctrl-A, Ctrl-C) the contents of the worksheet Jones 09 into Green 09 3. Write the name of Abraham Green into the cell D3 of Green 09 worksheet 4. In Total worksheet insert a row between rows 6 and 7 5. Copy the contents of B8:T8 into A7:T7 6. Mark A7:T7 and change (with Ctrl-H) Jones into Green within the marked area 7. Make a hyperlink in B7 to the worksheet Green 09 Repeat for all the new employees. This Absence and Vacation Tracker does not provide any automatization of the process. |
01-11-2009
, 12:58 AM
|
|
|
OA Spectator
Join Date: Jan 2009
Posts: 1
|
Re: Absence and Vacation Tracker (Excel)
|
01-13-2009
, 12:24 PM
|
||
|
OA Spectator
Join Date: Jan 2009
Posts: 1
|
Re: Absence and Vacation Tracker (Excel)
Quote:
I can't open this up. What was updated on this one? I was wondering how this could be converted from days to hours. THe employees are awarded based on the avg hrs wked the previous year. So for example, they could be awarded 240 hours (5 wks), 48 hours per week. And it is awarded like 8 hours per day til the 5th day of week and it would be the remainder of week unused, which in this case 16 hours. Can I still use Jennifer's vacation tracker with the right modifications to it? If so, any suggestions on where I should start? Thank you! |
|
| Thread Tools | Search this Thread |
|
|
Similar Discussions |
|||
| Title | Author | Responses | Last Post |
| Template: 2010 Employee Vacation-Absence Tracker (Excel) | OfficeArrow | 0 | 12-14-2009 05:10 PM |
| Template: Vacation Tracker (Excel) | Chrissy Scivicque | 2 | 02-20-2009 12:35 PM |
| Question: Absence and Vacation Tracker (Excel) | J William | 1 | 02-04-2009 03:30 PM |
| Question: Absence and Vacation Tracker | cknightmom | 2 | 01-15-2009 03:37 PM |
| Template: 2009 Employee Vacation-Absence Tracker (Excel) | Chrissy Scivicque | 0 | 01-14-2009 10:46 AM |
All times are GMT -4. The time now is 09:28 PM.
- dodgeje asked "What type of Signature line are other Executive Assistants to CEOs using in electronic correspondence?" in The Water Cooler
- Chrissy Scivicque asked "Are you as productive as you feel you need to be?" in The Water Cooler
- Salwa asked "2010 Objectives - But Resignation on the way.." in The Water Cooler
- lskiles asked "How do I get templates" in The Water Cooler
- rmactier asked "Can't open Daily Planner.ortg." in Macintosh Users
- CZTop54 asked "Free or Inexpensive Icons" in The Water Cooler
- pewy asked "Dishwasher policy?" in The Water Cooler
- crewtondix asked "Admin Bonuses, how to make it so?" in The Water Cooler


















Still not a member? Now is the time to join! 
