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

2012 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
2012-01-01 00:00:00 | 2012-01-14 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 | 4 |  | 4 |  |  | 0 |  |  | 0
2012-01-15 00:00:00 | 2012-01-28 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 16 | 4 |  | 8 |  |  | 0 |  |  | 0
2012-01-29 00:00:00 | 2012-02-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 24 | 4 |  | 12 |  |  | 0 |  |  | 0
2012-02-12 00:00:00 | 2012-02-25 00:00:00 |  |  |  |  |  |  |  |  | H |  |  |  |  |  | 8 |  | 32 | 4 |  | 16 |  |  | 0 |  |  | 0
2012-02-26 00:00:00 | 2012-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 40 | 4 |  | 20 |  |  | 0 |  |  | 0
2012-03-11 00:00:00 | 2012-03-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 48 | 4 |  | 24 |  |  | 0 |  |  | 0
2012-03-25 00:00:00 | 2012-04-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 56 | 4 |  | 28 |  |  | 0 |  |  | 0
2012-04-08 00:00:00 | 2012-04-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 64 | 4 |  | 32 |  |  | 0 |  |  | 0
2012-04-22 00:00:00 | 2012-05-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 72 | 4 |  | 36 |  |  | 0 |  |  | 0
2012-05-06 00:00:00 | 2012-05-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 80 | 4 |  | 40 |  |  | 0 |  |  | 0
2012-05-20 00:00:00 | 2012-06-02 00:00:00 |  |  |  |  |  |  |  |  | H |  |  |  |  |  | 8 |  | 88 | 4 |  | 44 |  |  | 0 |  |  | 0
2012-06-03 00:00:00 | 2012-06-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 96 | 4 |  | 48 |  |  | 0 |  |  | 0
2012-06-17 00:00:00 | 2012-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 104 | 4 |  | 52 |  |  | 0 |  |  | 0
2012-07-01 00:00:00 | 2012-07-14 00:00:00 |  |  |  | H |  |  |  |  |  |  |  |  |  |  | 8 |  | 112 | 4 |  | 56 |  |  | 0 |  |  | 0
2012-07-15 00:00:00 | 2012-07-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 120 | 4 |  | 60 |  |  | 0 |  |  | 0
2012-07-29 00:00:00 | 2012-08-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 128 | 4 |  | 64 |  |  | 0 |  |  | 0
2012-08-12 00:00:00 | 2012-08-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 136 | 4 |  | 68 |  |  | 0 |  |  | 0
2012-08-26 00:00:00 | 2012-09-08 00:00:00 |  |  |  |  |  |  |  |  | H |  |  |  |  |  | 8 |  | 144 | 4 |  | 72 |  |  | 0 |  |  | 0
2012-09-09 00:00:00 | 2012-09-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 152 | 4 |  | 76 |  |  | 0 |  |  | 0
2012-09-23 00:00:00 | 2012-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 160 | 4 |  | 80 |  |  | 0 |  |  | 0
2012-10-07 00:00:00 | 2012-10-20 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 168 | 4 |  | 84 |  |  | 0 |  |  | 0
2012-10-21 00:00:00 | 2012-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 176 | 4 |  | 88 |  |  | 0 |  |  | 0
2012-11-04 00:00:00 | 2012-11-17 00:00:00 |  |  |  |  |  |  |  |  | H |  |  |  |  |  | 8 |  | 184 | 4 |  | 92 |  |  | 0 |  |  | 0
2012-11-18 00:00:00 | 2012-12-01 00:00:00 |  |  |  |  | H |  |  |  |  |  |  |  |  |  | 8 |  | 192 | 4 |  | 96 |  |  | 0 |  |  | 0
2012-12-02 00:00:00 | 2012-12-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 200 | 4 |  | 100 |  |  | 0 |  |  | 0
2012-12-16 00:00:00 | 2012-12-29 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