2010 Technician Leave Tracker by wOv4kF

VIEWS: 0 PAGES: 5

									    2008 Leave Tracker                                                                                                                                           For: Tech_LV_Bal_EMP01                                                                                                                           1/12/2012/7:54 AM




                                                                                   2010 LEAVE YEAR RECORD                                                                                                                                                      PRIMARY LEAVE CATEGORIES
               Name:                                                                              SSN:                                                               SCD:                                                                ANNUAL                         SICK                      COMP                        MILITARY

           *** PLEASE READ: To enter leave, enter both the code and # of hours used, i.e. 10 hours annual = LA10 ; 4 hours sick leave = LS04 (or LS4) ; 10 hours comp time earned = CE10 ; etc., in the appropriate pay period cell !!!
                **If leave accrual changes, enter individual amounts in each annual leave"earned" cell instead of using the accrual/pp entry to the right>>>                                                                       **Accrual/PP:     4      <<< Enter your current leave accrual in this cell to the left




                                                                                                                                                                     DAY 11 WED




                                                                                                                                                                                               DAY 13 FRI
                                                                                                                                                                                  DAY 12 THU




                                                                                                                                                                                                            DAY 14 SAT
                                                                                                                                                    DAY 10 TUE
                                             DAY 2 MON




                                                                       DAY 4 WED




                                                                                                                                     DAY 9 MON
                          DAY 1 SUN




                                                                                                                         DAY 8 SUN
                                                                                     DAY 5 THU




                                                                                                             DAY 7 SAT
                                                           DAY 3 TUE




                                                                                                 DAY 6 FRI




                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                             EARNED




                                                                                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                                                                                     EARNED
  PP DAY OF LEAVE




                                                                                                                                                                                                                                  USED




                                                                                                                                                                                                                                                                      USED




                                                                                                                                                                                                                                                                                                   USED




                                                                                                                                                                                                                                                                                                                                 USED
TAKEN (RIGHT) / LEAVE                                                                                                                                                                                                                              USE OR




                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                BAL




                                                                                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                                                                         BAL
  PERIOD (BELOW)                                                                                                                                                                                                                                    LOSE
                                      Enter your leave in the appropriate cell below                                     Enter your beginning leave balances in the cells to the right >>>                                          >>> 0.00                            >>>      0.00               >>>    0.00                   >>>    0.00
03 Jan - 16 Jan                                                                                                                                                                                                           4       0.00    4.00      0.00      4       0.00       4.00   0.00      0.00     0.00      0.00       0.00     0.00
17 Jan - 30 Jan                             LH                                                                                                                                                                            4       0.00    8.00      0.00      4       0.00       8.00   0.00      0.00     0.00      0.00       0.00     0.00
31 Jan - 13 Feb                                                                                                                                                                                                           4       0.00   12.00      0.00      4       0.00      12.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Feb - 27 Feb                             LH                                                                                                                                                                            4       0.00   16.00      0.00      4       0.00      16.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Feb - 13 Mar                                                                                                                                                                                                           4       0.00   20.00      0.00      4       0.00      20.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Mar - 27 Mar                                                                                                                                                                                                           4       0.00   24.00      0.00      4       0.00      24.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Mar - 10 Apr                                                                                                                                                                                                           4       0.00   28.00      0.00      4       0.00      28.00   0.00      0.00     0.00      0.00       0.00     0.00
11 Apr - 24 Apr                                                                                                                                                                                                           4       0.00   32.00      0.00      4       0.00      32.00   0.00      0.00     0.00      0.00       0.00     0.00
25 Apr - 08 May                                                                                                                                                                                                           4       0.00   36.00      0.00      4       0.00      36.00   0.00      0.00     0.00      0.00       0.00     0.00
09 May - 22 May                                                                                                                                                                                                           4       0.00   40.00      0.00      4       0.00      40.00   0.00      0.00     0.00      0.00       0.00     0.00
23 May - 05 Jun                                                                                                                      LH                                                                                   4       0.00   44.00      0.00      4       0.00      44.00   0.00      0.00     0.00      0.00       0.00     0.00
06 Jun - 19 Jun                                                                                                                                                                                                           4       0.00   48.00      0.00      4       0.00      48.00   0.00      0.00     0.00      0.00       0.00     0.00
20 Jun - 03 Jul                                                                                                                                                                                                           4       0.00   52.00      0.00      4       0.00      52.00   0.00      0.00     0.00      0.00       0.00     0.00
04 Jul - 17 Jul                             LH                                                                                                                                                                            4       0.00   56.00      0.00      4       0.00      56.00   0.00      0.00     0.00      0.00       0.00     0.00
18 Jul - 31 Jul                                                                                                                                                                                                           4       0.00   60.00      0.00      4       0.00      60.00   0.00      0.00     0.00      0.00       0.00     0.00
01 Aug - 14 Aug                                                                                                                                                                                                           4       0.00   64.00      0.00      4       0.00      64.00   0.00      0.00     0.00      0.00       0.00     0.00
15 Aug - 28 Aug                                                                                                                                                                                                           4       0.00   68.00      0.00      4       0.00      68.00   0.00      0.00     0.00      0.00       0.00     0.00
29 Aug - 11 Sep                                                                                                                      LH                                                                                   4       0.00   72.00      0.00      4       0.00      72.00   0.00      0.00     0.00      0.00       0.00     0.00
12 Sep - 25 Sep                                                                                                                                                                                                           4       0.00   76.00      0.00      4       0.00      76.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Sep - 09 Oct                                                                                                                                                                                                           4       0.00   80.00      0.00      4       0.00      80.00   0.00      0.00     0.00      0.00       0.00     0.00
10 Oct - 25 Oct                             LH                                                                                                                                                                            4       0.00   84.00      0.00      4       0.00      84.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Oct - 06 Nov                                                                                                                                                                                                           4       0.00   88.00      0.00      4       0.00      88.00   0.00      0.00     0.00      0.00       0.00     0.00
07 Nov - 20 Nov                                                                     LH                                                                                                                                    4       0.00   92.00      0.00      4       0.00      92.00   0.00      0.00     0.00      0.00       0.00     0.00
21 Nov - 04 Dec                                                                     LH                                                                                                                                    4       0.00   96.00      0.00      4       0.00      96.00   0.00      0.00     0.00      0.00       0.00     0.00
05 Dec - 18 Dec                                                                                                                                                                                                           4       0.00  100.00      0.00      4       0.00     100.00   0.00      0.00     0.00      0.00       0.00     0.00
19 Dec - 01 Jan                                                                  LH                                                                                              LH                                       4       0.00  104.00      0.00      4       0.00     104.00   0.00      0.00     0.00      0.00       0.00     0.00
     LEAVE HOURS PAID                                    LEAVE HOURS UNPAID                                                                      FAMILY LEAVE                                                                             Notes:
LA ANNUAL                                                KA     LEAVE WITHOUT PAY (LWOP)                                                         DA        BIRTH/CARE OF NEWBORN
LC COURT                                                 KG     LWOP (MILITARY)                                                                  DB        ADOPTION/FOSTER CARE
LH HOLIDAY                                                                                                                                       DC        CARE OF FAMILY MEMBER
LL LAW ENFORCEMENT                                       COMPENSATORY TIME                                                                       DD        TECHNICIAN HEALTH CONDITION
LM MILITARY                                              CE    COMPENSATORY TIME EARNED                                                          DE        FAMILY CARE/BEREAVEMENT *
LN ADMINISTRATIVE                                        CT    COMPENSATORY TIME TAKEN                                                           *Federal Employee Family Friendly Leave
LV EXCUSED ABSENCE
LS SICK                                                  LEAVE RESTORATION                                                                                        PrintThisSheet
LY TIME OFF AWARD                                        LR     RESTORED LEAVE

Note: Supervisors may rename (or add and rename) the tabs at the bottom of this spreadsheet to track leave for each employee if desired; i.e. EMP01 becomes John Doe, etc.
Note: DO NOT DELETE OR ALTER any filled spreadsheet cells or the hidden spreadsheet columns AE through CZ as they contain the formulas relied on by the leave tracker spreadsheet
    2008 Leave Tracker                                                                                                                                           For: Tech_LV_Bal_EMP02                                                                                                                           1/12/2012/7:54 AM




                                                                                   2010 LEAVE YEAR RECORD                                                                                                                                                      PRIMARY LEAVE CATEGORIES
               Name:                                                                              SSN:                                                               SCD:                                                                ANNUAL                         SICK                      COMP                        MILITARY

           *** PLEASE READ: To enter leave, enter both the code and # of hours used, i.e. 10 hours annual = LA10 ; 4 hours sick leave = LS04 (or LS4) ; 10 hours comp time earned = CE10 ; etc., in the appropriate pay period cell !!!
                **If leave accrual changes, enter individual amounts in each annual leave"earned" cell instead of using the accrual/pp entry to the right>>>                                                                       **Accrual/PP:     4      <<< Enter your current leave accrual in this cell to the left




                                                                                                                                                                     DAY 11 WED




                                                                                                                                                                                               DAY 13 FRI
                                                                                                                                                                                  DAY 12 THU




                                                                                                                                                                                                            DAY 14 SAT
                                                                                                                                                    DAY 10 TUE
                                             DAY 2 MON




                                                                       DAY 4 WED




                                                                                                                                     DAY 9 MON
                          DAY 1 SUN




                                                                                                                         DAY 8 SUN
                                                                                     DAY 5 THU




                                                                                                             DAY 7 SAT
                                                           DAY 3 TUE




                                                                                                 DAY 6 FRI




                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                             EARNED




                                                                                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                                                                                     EARNED
  PP DAY OF LEAVE




                                                                                                                                                                                                                                  USED




                                                                                                                                                                                                                                                                      USED




                                                                                                                                                                                                                                                                                                   USED




                                                                                                                                                                                                                                                                                                                                 USED
TAKEN (RIGHT) / LEAVE                                                                                                                                                                                                                              USE OR




                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                BAL




                                                                                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                                                                         BAL
  PERIOD (BELOW)                                                                                                                                                                                                                                    LOSE
                                      Enter your leave in the appropriate cell below                                     Enter your beginning leave balances in the cells to the right >>>                                          >>> 0.00                            >>>      0.00               >>>    0.00                   >>>    0.00
03 Jan - 16 Jan                                                                                                                                                                                                           4       0.00    4.00      0.00      4       0.00       4.00   0.00      0.00     0.00      0.00       0.00     0.00
17 Jan - 30 Jan                             LH                                                                                                                                                                            4       0.00    8.00      0.00      4       0.00       8.00   0.00      0.00     0.00      0.00       0.00     0.00
31 Jan - 13 Feb                                                                                                                                                                                                           4       0.00   12.00      0.00      4       0.00      12.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Feb - 27 Feb                             LH                                                                                                                                                                            4       0.00   16.00      0.00      4       0.00      16.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Feb - 13 Mar                                                                                                                                                                                                           4       0.00   20.00      0.00      4       0.00      20.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Mar - 27 Mar                                                                                                                                                                                                           4       0.00   24.00      0.00      4       0.00      24.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Mar - 10 Apr                                                                                                                                                                                                           4       0.00   28.00      0.00      4       0.00      28.00   0.00      0.00     0.00      0.00       0.00     0.00
11 Apr - 24 Apr                                                                                                                                                                                                           4       0.00   32.00      0.00      4       0.00      32.00   0.00      0.00     0.00      0.00       0.00     0.00
25 Apr - 08 May                                                                                                                                                                                                           4       0.00   36.00      0.00      4       0.00      36.00   0.00      0.00     0.00      0.00       0.00     0.00
09 May - 22 May                                                                                                                                                                                                           4       0.00   40.00      0.00      4       0.00      40.00   0.00      0.00     0.00      0.00       0.00     0.00
23 May - 05 Jun                                                                                                                      LH                                                                                   4       0.00   44.00      0.00      4       0.00      44.00   0.00      0.00     0.00      0.00       0.00     0.00
06 Jun - 19 Jun                                                                                                                                                                                                           4       0.00   48.00      0.00      4       0.00      48.00   0.00      0.00     0.00      0.00       0.00     0.00
20 Jun - 03 Jul                                                                                                                                                                                                           4       0.00   52.00      0.00      4       0.00      52.00   0.00      0.00     0.00      0.00       0.00     0.00
04 Jul - 17 Jul                             LH                                                                                                                                                                            4       0.00   56.00      0.00      4       0.00      56.00   0.00      0.00     0.00      0.00       0.00     0.00
18 Jul - 31 Jul                                                                                                                                                                                                           4       0.00   60.00      0.00      4       0.00      60.00   0.00      0.00     0.00      0.00       0.00     0.00
01 Aug - 14 Aug                                                                                                                                                                                                           4       0.00   64.00      0.00      4       0.00      64.00   0.00      0.00     0.00      0.00       0.00     0.00
15 Aug - 28 Aug                                                                                                                                                                                                           4       0.00   68.00      0.00      4       0.00      68.00   0.00      0.00     0.00      0.00       0.00     0.00
29 Aug - 11 Sep                                                                                                                      LH                                                                                   4       0.00   72.00      0.00      4       0.00      72.00   0.00      0.00     0.00      0.00       0.00     0.00
12 Sep - 25 Sep                                                                                                                                                                                                           4       0.00   76.00      0.00      4       0.00      76.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Sep - 09 Oct                                                                                                                                                                                                           4       0.00   80.00      0.00      4       0.00      80.00   0.00      0.00     0.00      0.00       0.00     0.00
10 Oct - 25 Oct                             LH                                                                                                                                                                            4       0.00   84.00      0.00      4       0.00      84.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Oct - 06 Nov                                                                                                                                                                                                           4       0.00   88.00      0.00      4       0.00      88.00   0.00      0.00     0.00      0.00       0.00     0.00
07 Nov - 20 Nov                                                                     LH                                                                                                                                    4       0.00   92.00      0.00      4       0.00      92.00   0.00      0.00     0.00      0.00       0.00     0.00
21 Nov - 04 Dec                                                                     LH                                                                                                                                    4       0.00   96.00      0.00      4       0.00      96.00   0.00      0.00     0.00      0.00       0.00     0.00
05 Dec - 18 Dec                                                                                                                                                                                                           4       0.00  100.00      0.00      4       0.00     100.00   0.00      0.00     0.00      0.00       0.00     0.00
19 Dec - 01 Jan                                                                  LH                                                                                              LH                                       4       0.00  104.00      0.00      4       0.00     104.00   0.00      0.00     0.00      0.00       0.00     0.00
     LEAVE HOURS PAID                                    LEAVE HOURS UNPAID                                                                      FAMILY LEAVE                                                                             Notes:
LA ANNUAL                                                KA     LEAVE WITHOUT PAY (LWOP)                                                         DA        BIRTH/CARE OF NEWBORN
LC COURT                                                 KG     LWOP (MILITARY)                                                                  DB        ADOPTION/FOSTER CARE
LH HOLIDAY                                                                                                                                       DC        CARE OF FAMILY MEMBER
LL LAW ENFORCEMENT                                       COMPENSATORY TIME                                                                       DD        TECHNICIAN HEALTH CONDITION
LM MILITARY                                              CE    COMPENSATORY TIME EARNED                                                          DE        FAMILY CARE/BEREAVEMENT *
LN ADMINISTRATIVE                                        CT    COMPENSATORY TIME TAKEN                                                           *Federal Employee Family Friendly Leave
LV EXCUSED ABSENCE
LS SICK                                                  LEAVE RESTORATION                                                                                        PrintThisSheet
LY TIME OFF AWARD                                        LR     RESTORED LEAVE

Note: Supervisors may rename (or add and rename) the tabs at the bottom of this spreadsheet to track leave for each employee if desired; i.e. EMP01 becomes John Doe, etc.
Note: DO NOT DELETE OR ALTER any filled spreadsheet cells or the hidden spreadsheet columns AE through CZ as they contain the formulas relied on by the leave tracker spreadsheet
    2008 Leave Tracker                                                                                                                                           For: Tech_LV_Bal_EMP03                                                                                                                           1/12/2012/7:54 AM




                                                                                   2010 LEAVE YEAR RECORD                                                                                                                                                      PRIMARY LEAVE CATEGORIES
               Name:                                                                              SSN:                                                               SCD:                                                                ANNUAL                         SICK                      COMP                        MILITARY

           *** PLEASE READ: To enter leave, enter both the code and # of hours used, i.e. 10 hours annual = LA10 ; 4 hours sick leave = LS04 (or LS4) ; 10 hours comp time earned = CE10 ; etc., in the appropriate pay period cell !!!
                **If leave accrual changes, enter individual amounts in each annual leave"earned" cell instead of using the accrual/pp entry to the right>>>                                                                       **Accrual/PP:     4      <<< Enter your current leave accrual in this cell to the left




                                                                                                                                                                     DAY 11 WED




                                                                                                                                                                                               DAY 13 FRI
                                                                                                                                                                                  DAY 12 THU




                                                                                                                                                                                                            DAY 14 SAT
                                                                                                                                                    DAY 10 TUE
                                             DAY 2 MON




                                                                       DAY 4 WED




                                                                                                                                     DAY 9 MON
                          DAY 1 SUN




                                                                                                                         DAY 8 SUN
                                                                                     DAY 5 THU




                                                                                                             DAY 7 SAT
                                                           DAY 3 TUE




                                                                                                 DAY 6 FRI




                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                             EARNED




                                                                                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                                                                                     EARNED
  PP DAY OF LEAVE




                                                                                                                                                                                                                                  USED




                                                                                                                                                                                                                                                                      USED




                                                                                                                                                                                                                                                                                                   USED




                                                                                                                                                                                                                                                                                                                                 USED
TAKEN (RIGHT) / LEAVE                                                                                                                                                                                                                              USE OR




                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                BAL




                                                                                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                                                                         BAL
  PERIOD (BELOW)                                                                                                                                                                                                                                    LOSE
                                      Enter your leave in the appropriate cell below                                     Enter your beginning leave balances in the cells to the right >>>                                          >>> 0.00                            >>>      0.00               >>>    0.00                   >>>    0.00
03 Jan - 16 Jan                                                                                                                                                                                                           4       0.00    4.00      0.00      4       0.00       4.00   0.00      0.00     0.00      0.00       0.00     0.00
17 Jan - 30 Jan                             LH                                                                                                                                                                            4       0.00    8.00      0.00      4       0.00       8.00   0.00      0.00     0.00      0.00       0.00     0.00
31 Jan - 13 Feb                                                                                                                                                                                                           4       0.00   12.00      0.00      4       0.00      12.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Feb - 27 Feb                             LH                                                                                                                                                                            4       0.00   16.00      0.00      4       0.00      16.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Feb - 13 Mar                                                                                                                                                                                                           4       0.00   20.00      0.00      4       0.00      20.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Mar - 27 Mar                                                                                                                                                                                                           4       0.00   24.00      0.00      4       0.00      24.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Mar - 10 Apr                                                                                                                                                                                                           4       0.00   28.00      0.00      4       0.00      28.00   0.00      0.00     0.00      0.00       0.00     0.00
11 Apr - 24 Apr                                                                                                                                                                                                           4       0.00   32.00      0.00      4       0.00      32.00   0.00      0.00     0.00      0.00       0.00     0.00
25 Apr - 08 May                                                                                                                                                                                                           4       0.00   36.00      0.00      4       0.00      36.00   0.00      0.00     0.00      0.00       0.00     0.00
09 May - 22 May                                                                                                                                                                                                           4       0.00   40.00      0.00      4       0.00      40.00   0.00      0.00     0.00      0.00       0.00     0.00
23 May - 05 Jun                                                                                                                      LH                                                                                   4       0.00   44.00      0.00      4       0.00      44.00   0.00      0.00     0.00      0.00       0.00     0.00
06 Jun - 19 Jun                                                                                                                                                                                                           4       0.00   48.00      0.00      4       0.00      48.00   0.00      0.00     0.00      0.00       0.00     0.00
20 Jun - 03 Jul                                                                                                                                                                                                           4       0.00   52.00      0.00      4       0.00      52.00   0.00      0.00     0.00      0.00       0.00     0.00
04 Jul - 17 Jul                             LH                                                                                                                                                                            4       0.00   56.00      0.00      4       0.00      56.00   0.00      0.00     0.00      0.00       0.00     0.00
18 Jul - 31 Jul                                                                                                                                                                                                           4       0.00   60.00      0.00      4       0.00      60.00   0.00      0.00     0.00      0.00       0.00     0.00
01 Aug - 14 Aug                                                                                                                                                                                                           4       0.00   64.00      0.00      4       0.00      64.00   0.00      0.00     0.00      0.00       0.00     0.00
15 Aug - 28 Aug                                                                                                                                                                                                           4       0.00   68.00      0.00      4       0.00      68.00   0.00      0.00     0.00      0.00       0.00     0.00
29 Aug - 11 Sep                                                                                                                      LH                                                                                   4       0.00   72.00      0.00      4       0.00      72.00   0.00      0.00     0.00      0.00       0.00     0.00
12 Sep - 25 Sep                                                                                                                                                                                                           4       0.00   76.00      0.00      4       0.00      76.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Sep - 09 Oct                                                                                                                                                                                                           4       0.00   80.00      0.00      4       0.00      80.00   0.00      0.00     0.00      0.00       0.00     0.00
10 Oct - 25 Oct                             LH                                                                                                                                                                            4       0.00   84.00      0.00      4       0.00      84.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Oct - 06 Nov                                                                                                                                                                                                           4       0.00   88.00      0.00      4       0.00      88.00   0.00      0.00     0.00      0.00       0.00     0.00
07 Nov - 20 Nov                                                                     LH                                                                                                                                    4       0.00   92.00      0.00      4       0.00      92.00   0.00      0.00     0.00      0.00       0.00     0.00
21 Nov - 04 Dec                                                                     LH                                                                                                                                    4       0.00   96.00      0.00      4       0.00      96.00   0.00      0.00     0.00      0.00       0.00     0.00
05 Dec - 18 Dec                                                                                                                                                                                                           4       0.00  100.00      0.00      4       0.00     100.00   0.00      0.00     0.00      0.00       0.00     0.00
19 Dec - 01 Jan                                                                  LH                                                                                              LH                                       4       0.00  104.00      0.00      4       0.00     104.00   0.00      0.00     0.00      0.00       0.00     0.00
     LEAVE HOURS PAID                                    LEAVE HOURS UNPAID                                                                      FAMILY LEAVE                                                                             Notes:
LA ANNUAL                                                KA     LEAVE WITHOUT PAY (LWOP)                                                         DA        BIRTH/CARE OF NEWBORN
LC COURT                                                 KG     LWOP (MILITARY)                                                                  DB        ADOPTION/FOSTER CARE
LH HOLIDAY                                                                                                                                       DC        CARE OF FAMILY MEMBER
LL LAW ENFORCEMENT                                       COMPENSATORY TIME                                                                       DD        TECHNICIAN HEALTH CONDITION
LM MILITARY                                              CE    COMPENSATORY TIME EARNED                                                          DE        FAMILY CARE/BEREAVEMENT *
LN ADMINISTRATIVE                                        CT    COMPENSATORY TIME TAKEN                                                           *Federal Employee Family Friendly Leave
LV EXCUSED ABSENCE
LS SICK                                                  LEAVE RESTORATION                                                                                        PrintThisSheet
LY TIME OFF AWARD                                        LR     RESTORED LEAVE

Note: Supervisors may rename (or add and rename) the tabs at the bottom of this spreadsheet to track leave for each employee if desired; i.e. EMP01 becomes John Doe, etc.
Note: DO NOT DELETE OR ALTER any filled spreadsheet cells or the hidden spreadsheet columns AE through CZ as they contain the formulas relied on by the leave tracker spreadsheet
    2008 Leave Tracker                                                                                                                                           For: Tech_LV_Bal_EMP04                                                                                                                           1/12/2012/7:54 AM




                                                                                   2010 LEAVE YEAR RECORD                                                                                                                                                      PRIMARY LEAVE CATEGORIES
               Name:                                                                              SSN:                                                               SCD:                                                                ANNUAL                         SICK                      COMP                        MILITARY

           *** PLEASE READ: To enter leave, enter both the code and # of hours used, i.e. 10 hours annual = LA10 ; 4 hours sick leave = LS04 (or LS4) ; 10 hours comp time earned = CE10 ; etc., in the appropriate pay period cell !!!
                **If leave accrual changes, enter individual amounts in each annual leave"earned" cell instead of using the accrual/pp entry to the right>>>                                                                       **Accrual/PP:     4      <<< Enter your current leave accrual in this cell to the left




                                                                                                                                                                     DAY 11 WED




                                                                                                                                                                                               DAY 13 FRI
                                                                                                                                                                                  DAY 12 THU




                                                                                                                                                                                                            DAY 14 SAT
                                                                                                                                                    DAY 10 TUE
                                             DAY 2 MON




                                                                       DAY 4 WED




                                                                                                                                     DAY 9 MON
                          DAY 1 SUN




                                                                                                                         DAY 8 SUN
                                                                                     DAY 5 THU




                                                                                                             DAY 7 SAT
                                                           DAY 3 TUE




                                                                                                 DAY 6 FRI




                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                             EARNED




                                                                                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                                                                                     EARNED
  PP DAY OF LEAVE




                                                                                                                                                                                                                                  USED




                                                                                                                                                                                                                                                                      USED




                                                                                                                                                                                                                                                                                                   USED




                                                                                                                                                                                                                                                                                                                                 USED
TAKEN (RIGHT) / LEAVE                                                                                                                                                                                                                              USE OR




                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                BAL




                                                                                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                                                                         BAL
  PERIOD (BELOW)                                                                                                                                                                                                                                    LOSE
                                      Enter your leave in the appropriate cell below                                     Enter your beginning leave balances in the cells to the right >>>                                          >>> 0.00                            >>>      0.00               >>>    0.00                   >>>    0.00
03 Jan - 16 Jan                                                                                                                                                                                                           4       0.00    4.00      0.00      4       0.00       4.00   0.00      0.00     0.00      0.00       0.00     0.00
17 Jan - 30 Jan                             LH                                                                                                                                                                            4       0.00    8.00      0.00      4       0.00       8.00   0.00      0.00     0.00      0.00       0.00     0.00
31 Jan - 13 Feb                                                                                                                                                                                                           4       0.00   12.00      0.00      4       0.00      12.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Feb - 27 Feb                             LH                                                                                                                                                                            4       0.00   16.00      0.00      4       0.00      16.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Feb - 13 Mar                                                                                                                                                                                                           4       0.00   20.00      0.00      4       0.00      20.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Mar - 27 Mar                                                                                                                                                                                                           4       0.00   24.00      0.00      4       0.00      24.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Mar - 10 Apr                                                                                                                                                                                                           4       0.00   28.00      0.00      4       0.00      28.00   0.00      0.00     0.00      0.00       0.00     0.00
11 Apr - 24 Apr                                                                                                                                                                                                           4       0.00   32.00      0.00      4       0.00      32.00   0.00      0.00     0.00      0.00       0.00     0.00
25 Apr - 08 May                                                                                                                                                                                                           4       0.00   36.00      0.00      4       0.00      36.00   0.00      0.00     0.00      0.00       0.00     0.00
09 May - 22 May                                                                                                                                                                                                           4       0.00   40.00      0.00      4       0.00      40.00   0.00      0.00     0.00      0.00       0.00     0.00
23 May - 05 Jun                                                                                                                      LH                                                                                   4       0.00   44.00      0.00      4       0.00      44.00   0.00      0.00     0.00      0.00       0.00     0.00
06 Jun - 19 Jun                                                                                                                                                                                                           4       0.00   48.00      0.00      4       0.00      48.00   0.00      0.00     0.00      0.00       0.00     0.00
20 Jun - 03 Jul                                                                                                                                                                                                           4       0.00   52.00      0.00      4       0.00      52.00   0.00      0.00     0.00      0.00       0.00     0.00
04 Jul - 17 Jul                             LH                                                                                                                                                                            4       0.00   56.00      0.00      4       0.00      56.00   0.00      0.00     0.00      0.00       0.00     0.00
18 Jul - 31 Jul                                                                                                                                                                                                           4       0.00   60.00      0.00      4       0.00      60.00   0.00      0.00     0.00      0.00       0.00     0.00
01 Aug - 14 Aug                                                                                                                                                                                                           4       0.00   64.00      0.00      4       0.00      64.00   0.00      0.00     0.00      0.00       0.00     0.00
15 Aug - 28 Aug                                                                                                                                                                                                           4       0.00   68.00      0.00      4       0.00      68.00   0.00      0.00     0.00      0.00       0.00     0.00
29 Aug - 11 Sep                                                                                                                      LH                                                                                   4       0.00   72.00      0.00      4       0.00      72.00   0.00      0.00     0.00      0.00       0.00     0.00
12 Sep - 25 Sep                                                                                                                                                                                                           4       0.00   76.00      0.00      4       0.00      76.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Sep - 09 Oct                                                                                                                                                                                                           4       0.00   80.00      0.00      4       0.00      80.00   0.00      0.00     0.00      0.00       0.00     0.00
10 Oct - 25 Oct                             LH                                                                                                                                                                            4       0.00   84.00      0.00      4       0.00      84.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Oct - 06 Nov                                                                                                                                                                                                           4       0.00   88.00      0.00      4       0.00      88.00   0.00      0.00     0.00      0.00       0.00     0.00
07 Nov - 20 Nov                                                                     LH                                                                                                                                    4       0.00   92.00      0.00      4       0.00      92.00   0.00      0.00     0.00      0.00       0.00     0.00
21 Nov - 04 Dec                                                                     LH                                                                                                                                    4       0.00   96.00      0.00      4       0.00      96.00   0.00      0.00     0.00      0.00       0.00     0.00
05 Dec - 18 Dec                                                                                                                                                                                                           4       0.00  100.00      0.00      4       0.00     100.00   0.00      0.00     0.00      0.00       0.00     0.00
19 Dec - 01 Jan                                                                  LH                                                                                              LH                                       4       0.00  104.00      0.00      4       0.00     104.00   0.00      0.00     0.00      0.00       0.00     0.00
     LEAVE HOURS PAID                                    LEAVE HOURS UNPAID                                                                      FAMILY LEAVE                                                                             Notes:
LA ANNUAL                                                KA     LEAVE WITHOUT PAY (LWOP)                                                         DA        BIRTH/CARE OF NEWBORN
LC COURT                                                 KG     LWOP (MILITARY)                                                                  DB        ADOPTION/FOSTER CARE
LH HOLIDAY                                                                                                                                       DC        CARE OF FAMILY MEMBER
LL LAW ENFORCEMENT                                       COMPENSATORY TIME                                                                       DD        TECHNICIAN HEALTH CONDITION
LM MILITARY                                              CE    COMPENSATORY TIME EARNED                                                          DE        FAMILY CARE/BEREAVEMENT *
LN ADMINISTRATIVE                                        CT    COMPENSATORY TIME TAKEN                                                           *Federal Employee Family Friendly Leave
LV EXCUSED ABSENCE
LS SICK                                                  LEAVE RESTORATION                                                                                        PrintThisSheet
LY TIME OFF AWARD                                        LR     RESTORED LEAVE

Note: Supervisors may rename (or add and rename) the tabs at the bottom of this spreadsheet to track leave for each employee if desired; i.e. EMP01 becomes John Doe, etc.
Note: DO NOT DELETE OR ALTER any filled spreadsheet cells or the hidden spreadsheet columns AE through CZ as they contain the formulas relied on by the leave tracker spreadsheet
    2008 Leave Tracker                                                                                                                                           For: Tech_LV_Bal_EMP05                                                                                                                           1/12/2012/7:54 AM




                                                                                   2010 LEAVE YEAR RECORD                                                                                                                                                      PRIMARY LEAVE CATEGORIES
               Name:                                                                              SSN:                                                               SCD:                                                                ANNUAL                         SICK                      COMP                        MILITARY

           *** PLEASE READ: To enter leave, enter both the code and # of hours used, i.e. 10 hours annual = LA10 ; 4 hours sick leave = LS04 (or LS4) ; 10 hours comp time earned = CE10 ; etc., in the appropriate pay period cell !!!
                **If leave accrual changes, enter individual amounts in each annual leave"earned" cell instead of using the accrual/pp entry to the right>>>                                                                       **Accrual/PP:     4      <<< Enter your current leave accrual in this cell to the left




                                                                                                                                                                     DAY 11 WED




                                                                                                                                                                                               DAY 13 FRI
                                                                                                                                                                                  DAY 12 THU




                                                                                                                                                                                                            DAY 14 SAT
                                                                                                                                                    DAY 10 TUE
                                             DAY 2 MON




                                                                       DAY 4 WED




                                                                                                                                     DAY 9 MON
                          DAY 1 SUN




                                                                                                                         DAY 8 SUN
                                                                                     DAY 5 THU




                                                                                                             DAY 7 SAT
                                                           DAY 3 TUE




                                                                                                 DAY 6 FRI




                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                             EARNED




                                                                                                                                                                                                                                                                                         EARNED




                                                                                                                                                                                                                                                                                                                     EARNED
  PP DAY OF LEAVE




                                                                                                                                                                                                                                  USED




                                                                                                                                                                                                                                                                      USED




                                                                                                                                                                                                                                                                                                   USED




                                                                                                                                                                                                                                                                                                                                 USED
TAKEN (RIGHT) / LEAVE                                                                                                                                                                                                                              USE OR




                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                BAL




                                                                                                                                                                                                                                                                                                            BAL




                                                                                                                                                                                                                                                                                                                                         BAL
  PERIOD (BELOW)                                                                                                                                                                                                                                    LOSE
                                      Enter your leave in the appropriate cell below                                     Enter your beginning leave balances in the cells to the right >>>                                          >>> 0.00                            >>>      0.00               >>>    0.00                   >>>    0.00
03 Jan - 16 Jan                                                                                                                                                                                                           4       0.00    4.00      0.00      4       0.00       4.00   0.00      0.00     0.00      0.00       0.00     0.00
17 Jan - 30 Jan                             LH                                                                                                                                                                            4       0.00    8.00      0.00      4       0.00       8.00   0.00      0.00     0.00      0.00       0.00     0.00
31 Jan - 13 Feb                                                                                                                                                                                                           4       0.00   12.00      0.00      4       0.00      12.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Feb - 27 Feb                             LH                                                                                                                                                                            4       0.00   16.00      0.00      4       0.00      16.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Feb - 13 Mar                                                                                                                                                                                                           4       0.00   20.00      0.00      4       0.00      20.00   0.00      0.00     0.00      0.00       0.00     0.00
14 Mar - 27 Mar                                                                                                                                                                                                           4       0.00   24.00      0.00      4       0.00      24.00   0.00      0.00     0.00      0.00       0.00     0.00
28 Mar - 10 Apr                                                                                                                                                                                                           4       0.00   28.00      0.00      4       0.00      28.00   0.00      0.00     0.00      0.00       0.00     0.00
11 Apr - 24 Apr                                                                                                                                                                                                           4       0.00   32.00      0.00      4       0.00      32.00   0.00      0.00     0.00      0.00       0.00     0.00
25 Apr - 08 May                                                                                                                                                                                                           4       0.00   36.00      0.00      4       0.00      36.00   0.00      0.00     0.00      0.00       0.00     0.00
09 May - 22 May                                                                                                                                                                                                           4       0.00   40.00      0.00      4       0.00      40.00   0.00      0.00     0.00      0.00       0.00     0.00
23 May - 05 Jun                                                                                                                      LH                                                                                   4       0.00   44.00      0.00      4       0.00      44.00   0.00      0.00     0.00      0.00       0.00     0.00
06 Jun - 19 Jun                                                                                                                                                                                                           4       0.00   48.00      0.00      4       0.00      48.00   0.00      0.00     0.00      0.00       0.00     0.00
20 Jun - 03 Jul                                                                                                                                                                                                           4       0.00   52.00      0.00      4       0.00      52.00   0.00      0.00     0.00      0.00       0.00     0.00
04 Jul - 17 Jul                             LH                                                                                                                                                                            4       0.00   56.00      0.00      4       0.00      56.00   0.00      0.00     0.00      0.00       0.00     0.00
18 Jul - 31 Jul                                                                                                                                                                                                           4       0.00   60.00      0.00      4       0.00      60.00   0.00      0.00     0.00      0.00       0.00     0.00
01 Aug - 14 Aug                                                                                                                                                                                                           4       0.00   64.00      0.00      4       0.00      64.00   0.00      0.00     0.00      0.00       0.00     0.00
15 Aug - 28 Aug                                                                                                                                                                                                           4       0.00   68.00      0.00      4       0.00      68.00   0.00      0.00     0.00      0.00       0.00     0.00
29 Aug - 11 Sep                                                                                                                      LH                                                                                   4       0.00   72.00      0.00      4       0.00      72.00   0.00      0.00     0.00      0.00       0.00     0.00
12 Sep - 25 Sep                                                                                                                                                                                                           4       0.00   76.00      0.00      4       0.00      76.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Sep - 09 Oct                                                                                                                                                                                                           4       0.00   80.00      0.00      4       0.00      80.00   0.00      0.00     0.00      0.00       0.00     0.00
10 Oct - 25 Oct                             LH                                                                                                                                                                            4       0.00   84.00      0.00      4       0.00      84.00   0.00      0.00     0.00      0.00       0.00     0.00
26 Oct - 06 Nov                                                                                                                                                                                                           4       0.00   88.00      0.00      4       0.00      88.00   0.00      0.00     0.00      0.00       0.00     0.00
07 Nov - 20 Nov                                                                     LH                                                                                                                                    4       0.00   92.00      0.00      4       0.00      92.00   0.00      0.00     0.00      0.00       0.00     0.00
21 Nov - 04 Dec                                                                     LH                                                                                                                                    4       0.00   96.00      0.00      4       0.00      96.00   0.00      0.00     0.00      0.00       0.00     0.00
05 Dec - 18 Dec                                                                                                                                                                                                           4       0.00  100.00      0.00      4       0.00     100.00   0.00      0.00     0.00      0.00       0.00     0.00
19 Dec - 01 Jan                                                                  LH                                                                                              LH                                       4       0.00  104.00      0.00      4       0.00     104.00   0.00      0.00     0.00      0.00       0.00     0.00
     LEAVE HOURS PAID                                    LEAVE HOURS UNPAID                                                                      FAMILY LEAVE                                                                             Notes:
LA ANNUAL                                                KA     LEAVE WITHOUT PAY (LWOP)                                                         DA        BIRTH/CARE OF NEWBORN
LC COURT                                                 KG     LWOP (MILITARY)                                                                  DB        ADOPTION/FOSTER CARE
LH HOLIDAY                                                                                                                                       DC        CARE OF FAMILY MEMBER
LL LAW ENFORCEMENT                                       COMPENSATORY TIME                                                                       DD        TECHNICIAN HEALTH CONDITION
LM MILITARY                                              CE    COMPENSATORY TIME EARNED                                                          DE        FAMILY CARE/BEREAVEMENT *
LN ADMINISTRATIVE                                        CT    COMPENSATORY TIME TAKEN                                                           *Federal Employee Family Friendly Leave
LV EXCUSED ABSENCE
LS SICK                                                  LEAVE RESTORATION                                                                                        PrintThisSheet
LY TIME OFF AWARD                                        LR     RESTORED LEAVE

Note: Supervisors may rename (or add and rename) the tabs at the bottom of this spreadsheet to track leave for each employee if desired; i.e. EMP01 becomes John Doe, etc.
Note: DO NOT DELETE OR ALTER any filled spreadsheet cells or the hidden spreadsheet columns AE through CZ as they contain the formulas relied on by the leave tracker spreadsheet

								
To top