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

2010 LEAVE RECORD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNUAL LEAVE |  |  | SICK LEAVE |  |  | COMP EARNED |  |  | OVERTIME
Pay Period |  | DAILY RECORD OF LEAVE USED DURING EACH PAY PERIOD |  |  |  |  |  |  |  |  |  |  |  |  |  | Carried Over |  | 12 | Carried Over |  | -18.5 | 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
2010-01-03 00:00:00 | 2010-01-16 00:00:00 |  |  |  |  |  | 2AL |  |  |  |  |  |  |  |  | 6 | 2 | 16 | 4 |  | -14.5 |  |  | 0 |  |  | 0
2010-01-17 00:00:00 | 2010-01-30 00:00:00 |  | H | 8AL |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 22 | 4 |  | -10.5 |  |  | 0 |  |  | 0
2010-01-31 00:00:00 | 2010-02-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 28 | 4 |  | -6.5 |  |  | 0 |  |  | 0
2010-02-14 00:00:00 | 2010-02-27 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 34 | 4 |  | -2.5 |  |  | 0 |  |  | 0
2010-02-28 00:00:00 | 2010-03-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 40 | 4 |  | 1.5 |  |  | 0 |  |  | 0
2010-03-14 00:00:00 | 2010-03-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 6 |  | 46 | 4 |  | 5.5 |  |  | 0 |  |  | 0
2010-03-28 00:00:00 | 2010-04-10 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 52 | 4 |  | 9.5 |  |  | 0 |  |  | 0
2010-04-11 00:00:00 | 2010-04-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 58 | 4 |  | 13.5 |  |  | 0 |  |  | 0
2010-04-25 00:00:00 | 2010-05-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 64 | 4 |  | 17.5 |  |  | 0 |  |  | 0
2010-05-09 00:00:00 | 2010-05-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 70 | 4 |  | 21.5 |  |  | 0 |  |  | 0
2010-05-23 00:00:00 | 2010-06-05 00:00:00 |  |  |  |  |  |  |  |  | H |  |  |  |  |  | 6 |  | 76 | 4 |  | 25.5 |  |  | 0 |  |  | 0
2010-06-06 00:00:00 | 2010-06-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 82 | 4 |  | 29.5 |  |  | 0 |  |  | 0
2010-06-20 00:00:00 | 2010-07-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 88 | 4 |  | 33.5 |  |  | 0 |  |  | 0
2010-07-04 00:00:00 | 2010-07-17 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 94 | 4 |  | 37.5 |  |  | 0 |  |  | 0
2010-07-18 00:00:00 | 2010-07-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 100 | 4 |  | 41.5 |  |  | 0 |  |  | 0
2010-08-01 00:00:00 | 2010-08-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 106 | 4 |  | 45.5 |  |  | 0 |  |  | 0
2010-08-15 00:00:00 | 2010-08-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 112 | 4 |  | 49.5 |  |  | 0 |  |  | 0
2010-08-29 00:00:00 | 2010-09-11 00:00:00 |  |  |  |  |  |  |  |  | H |  |  |  |  |  | 6 |  | 118 | 4 |  | 53.5 |  |  | 0 |  |  | 0
2010-09-12 00:00:00 | 2010-09-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 124 | 4 |  | 57.5 |  |  | 0 |  |  | 0
2010-09-26 00:00:00 | 2010-10-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 130 | 4 |  | 61.5 |  |  | 0 |  |  | 0
2010-10-10 00:00:00 | 2010-10-23 00:00:00 |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 136 | 4 |  | 65.5 |  |  | 0 |  |  | 0
2010-10-24 00:00:00 | 2010-11-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 142 | 4 |  | 69.5 |  |  | 0 |  |  | 0
2010-11-07 00:00:00 | 2010-11-20 00:00:00 |  |  |  |  | H |  |  |  |  |  |  |  |  |  | 6 |  | 148 | 4 |  | 73.5 |  |  | 0 |  |  | 0
2010-11-21 00:00:00 | 2010-12-04 00:00:00 |  |  |  |  | H |  |  |  |  |  |  |  |  |  | 6 |  | 154 | 4 |  | 77.5 |  |  | 0 |  |  | 0
2010-12-05 00:00:00 | 2010-12-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 160 | 4 |  | 81.5 |  |  | 0 |  |  | 0
2010-12-19 00:00:00 | 2011-01-01 00:00:00 |  |  |  |  |  | H |  |  |  |  |  |  | H |  | 6 |  | 166 | 4 |  | 85.5 |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | 156 | 2 |  | 104 | 0 |  | 0 | 0 |  | 0 | 0
Projected leave |  |  | Annual leave |  |  |  |  | Sick leave |  |  |  | Holiday |  |  |  | Use or lose