Spreadsheet: 69326d1269872965-keeping-a-running-balance-my-leave
Sheet: 2009

2009 LEAVE RECORD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNUAL LEAVE |  |  | SICK LEAVE |  |  | COMP EARNED |  |  | OVERTIME
Pay Period |  | DAILY RECORD OF LEAVE USED DURING EACH PAY PERIOD |  |  |  |  |  |  |  |  |  |  |  |  |  | Carried Over |  | 0 | Carried Over |  | 0 | Carried Over |  | 0 | Carried Over |  | 0
Beginning | Ending | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | Earned | Used | Balance | Earned | Used | Balance | Earned | Used | Balance | Earned | Used | Balance
2009-01-04 00:00:00 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 | 4 |  | 4 |  |  | 0 |  |  | 0
2009-01-18 00:00:00 | 2009-01-31 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 16 | 4 |  | 8 |  |  | 0 |  |  | 0
2009-02-01 00:00:00 | 2009-02-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 24 | 4 |  | 12 |  |  | 0 |  |  | 0
2009-02-15 00:00:00 | 2009-02-28 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 32 | 4 |  | 16 |  |  | 0 |  |  | 0
2009-03-01 00:00:00 | 2009-03-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 40 | 4 |  | 20 |  |  | 0 |  |  | 0
2009-03-15 00:00:00 | 2009-03-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 48 | 4 |  | 24 |  |  | 0 |  |  | 0
2009-03-29 00:00:00 | 2009-04-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 56 | 4 |  | 28 |  |  | 0 |  |  | 0
2009-04-12 00:00:00 | 2009-04-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 64 | 4 |  | 32 |  |  | 0 |  |  | 0
2009-04-26 00:00:00 | 2009-05-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 72 | 4 |  | 36 |  |  | 0 |  |  | 0
2009-05-10 00:00:00 | 2009-05-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 80 | 4 |  | 40 |  |  | 0 |  |  | 0
2009-05-24 00:00:00 | 2009-06-06 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 88 | 4 |  | 44 |  |  | 0 |  |  | 0
2009-06-07 00:00:00 | 2009-06-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 96 | 4 |  | 48 |  |  | 0 |  |  | 0
2009-06-21 00:00:00 | 2009-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | H |  | 8 |  | 104 | 4 |  | 52 |  |  | 0 |  |  | 0
2009-07-05 00:00:00 | 2009-07-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 112 | 4 |  | 56 |  |  | 0 |  |  | 0
2009-07-19 00:00:00 | 2009-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 120 | 4 |  | 60 |  |  | 0 |  |  | 0
2009-08-02 00:00:00 | 2009-08-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 128 | 4 |  | 64 |  |  | 0 |  |  | 0
2009-08-16 00:00:00 | 2009-08-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 136 | 4 |  | 68 |  |  | 0 |  |  | 0
2009-08-30 00:00:00 | 2009-09-12 00:00:00 |  |  |  |  |  |  |  |  | H |  |  |  |  |  | 8 |  | 144 | 4 |  | 72 |  |  | 0 |  |  | 0
2009-09-13 00:00:00 | 2009-09-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 152 | 4 |  | 76 |  |  | 0 |  |  | 0
2009-09-27 00:00:00 | 2009-10-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 160 | 4 |  | 80 |  |  | 0 |  |  | 0
2009-10-11 00:00:00 | 2009-10-24 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 168 | 4 |  | 84 |  |  | 0 |  |  | 0
2009-10-25 00:00:00 | 2009-11-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 176 | 4 |  | 88 |  |  | 0 |  |  | 0
2009-11-08 00:00:00 | 2009-11-21 00:00:00 |  |  |  | H |  |  |  |  |  |  |  |  |  |  | 8 |  | 184 | 4 |  | 92 |  |  | 0 |  |  | 0
2009-11-22 00:00:00 | 2009-12-05 00:00:00 |  |  |  |  | H |  |  |  |  |  |  |  |  |  | 8 |  | 192 | 4 |  | 96 |  |  | 0 |  |  | 0
2009-12-06 00:00:00 | 2009-12-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 200 | 4 |  | 100 |  |  | 0 |  |  | 0
2009-12-20 00:00:00 | 2010-01-02 00:00:00 |  |  |  |  |  | H |  |  |  |  |  |  | H |  | 8 |  | 208 | 4 |  | 104 |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | 208 | 0 |  | 104 | 0 |  | 0 | 0 |  | 0 | 0
Projected leave |  |  | Annual leave |  |  |  |  | Sick leave |  |  |  | Holiday |  |  |  | Use or lose