Spreadsheet: 33473d1229900185-how-much-sick-time-used-sickleave-bvj
Sheet: FORMULA TEST

NAME: |  |  |  |  |  |  |  |  |  |  | SSN: |  |  |  |  |  |  |  | DOB: |  |  |  |  |  | DOE: |  |  |  |  | EARNS: | 15.96 | VAC
2009 RECORD OF TIME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200
PAY PERIOD |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | VAC | SICK | HOT
01/03 - 01/16 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 | SE | 15 | SE | 16 | SE | 0 | 128 | 0
 |  |  |  |  |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  |  |  |  |  | 8 |  | 8 |  | 8 |  | 8 |  | 8
01/17 - 01/30 | * | 17 |  | 18 |  | 19 | se | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 15.96 | 114.64 | 0
 |  |  |  |  |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  |  |  |  |  | 8 |  | 8 |  | 8 |  | 8 |  | 8
01/31 - 02/13 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 | HD | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 15.96 | 114.64 | 8
02/14 - 02/27 | * | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 31.92 | 125.28 | 8
02/28 - 03/13 |  | 28 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 | HD | 11 |  | 12 |  | 13 |  | 31.92 | 125.28 | 16
03/14 - 03/27 | * | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 47.88 | 135.92 | 16
03/28 - 04/10 |  | 28 |  | 29 |  | 30 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 47.88 | 135.92 | 16
04/11 - 04/24 | * | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 63.84 | 146.56 | 16
04/25 - 05/08 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 63.84 | 146.56 | 16
05/09 - 05/22 | * | 9 |  | 10 |  | 11 | HD | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 79.80000000000001 | 157.2 | 24
05/23 - 06/05 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 79.80000000000001 | 157.2 | 24
06/06 - 06/19 | * | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 | HD | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 95.76000000000002 | 167.84 | 32
06/20 - 07/03 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3 |  | 95.76000000000002 | 167.84 | 32
* ADD SICK LEAVE AND VACATION EARNED AT THE END OF THIS PAY PERIOD.         HD = HOLIDAY
REMARKS:
NAME: |  |  |  |  |  |  |  |  |  |  | SSN: |  |  |  |  |  |  |  | DOB: |  |  |  |  |  | DOE: |  |  |  |  | EARNS: |  | VAC
2009 RECORD OF TIME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95.76000000000002 | 167.84 | 32
PAY PERIOD |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | VAC | SICK | HOT
07/04 - 07/17 | * | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 95.76000000000002 | 178.48 | 32
07/18 - 07/31 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 95.76000000000002 | 178.48 | 32
08/01 - 08/14 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 | HD | 13 |  | 14 |  | 95.76000000000002 | 178.48 | 40
08/15 - 08/28 | * | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 95.76000000000002 | 189.1199999999999 | 40
08/29 - 09/11 |  | 29 |  | 30 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 | HD | 8 |  | 9 |  | 10 |  | 11 |  | 95.76000000000002 | 189.1199999999999 | 48
09/12 - 09/25 | * | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 95.76000000000002 | 199.7599999999999 | 48
09/26 - 10/09 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 95.76000000000002 | 199.7599999999999 | 48
10/10 - 10/23 | * | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 95.76000000000002 | 210.3999999999999 | 48
10/24 - 11/06 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 95.76000000000002 | 210.3999999999999 | 48
11/07 - 11/20 | * | 7 |  | 8 |  | 9 |  | 10 |  | 11 | HD | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 95.76000000000002 | 221.0399999999999 | 56
11/21 - 12/04 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 | HD | 27 | HD | 28 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3 |  | 4 |  | 95.76000000000002 | 221.0399999999999 | 72
12/05 - 12/18 | * | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 95.76000000000002 | 231.6799999999999 | 72
12/19 - 01/01 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 | HD | 25 | HD | 26 |  | 27 |  | 28 |  | 29 |  | 39 |  | 31 |  | 1 | HD | 95.76000000000002 | 231.6799999999999 | 96
* ADD SICK LEAVE AND VACATION EARNED AT THE END OF THIS PAY PERIOD.         HD = HOLIDAY
REMARKS: