Spreadsheet: 118988d1314123325-excel-2007-excel-problem-vacation-time
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Years 1 and 2 - 5 Vacation Days  5 Sick/Personal days |  |  |  | AYS        5 sick/personal days |  |  |  | 3.33 | 3.33
PERSONAL/SICK/VACATION SCHEDULE |  |  |  |  |  |  |  |  | Years 3-9           10 VACATION DAYS |  |  |  | DAYS     8 sick/personal days |  |  |  | 6.66 | 5.33
2011 |  |  |  |  |  |  |  |  | YEARS 10-14     15 VACATION DAYS |  |  |  | DAYS     8 sick/personal days |  |  |  | 10 | 5.33
EMPLOYEE |  | BALANCE | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | [NAME] |  | JULY |  | AUG |  | SEPT |  | OCT |  | NOV |  | DEC |  |  | Balance
 |  | 2011-12-10 00:00:00 | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used
[NAME] | VAC | -1.94
2009-05-26 00:00:00 | S/P
BAINES | VAC | 117.28 | 10 |  | 10 | -8 | 10 |  | 10 |  | 10 | -40.15 | 10 | -8 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  |  | 122.13
1998-04-09 00:00:00 | S/P | 50.57 | 5.33 |  | 5.33 | -10.15 | 5.33 | -19.3 | 5.33 | -0.45 | 5.33 |  | 5.33 | -5.75 | 5.33 | -1 | 5.33 | -2.15 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 49.08
BENTON | VAC | 3.33 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 33.31
2010-12-01 00:00:00 | S/P | 3.33 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 | -4 | 3.33 | -8 | 3.33 | -3.33 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 9.98
BOWMAN | VAC | 4.3 | 3.33 |  | 3.33 |  | 3.33 |  |  | -6.15
2009-04-19 00:00:00 | S/P | -7.33 | 3.33 |  | 3.33 |  | 3.33 | -8
CASS | VAC | 26.64 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 | -40 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 16.61
2010-05-24 00:00:00 | S/P | 18.64 | 3.33 |  | 3.33 | -2.3 | 3.33 |  | 3.33 |  | 3.33 | -4.9 | 3.33 | -3.45 | 3.33 |  | 3.33 | -16 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 21.66
[NAME] | VAC | 36.63 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 | -46 |  |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 3.95
2010-01-22 00:00:00 | S/P | 9.03 | 3.33 | -0.15 | 3.33 |  | 3.33 | -8 | 3.33 | -4.3 | 3.33 | -6 |  |  | 3.33 |  | 3.33 | -1.45 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 2.45
COX | VAC | 100.31 | 10 |  | 10 |  | 10 |  | 10 | -32 | 10 | -16.45 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  |  | 130.86
1997-09-08 00:00:00 | S/P | 16.66 | 5.33 | -1.5 | 5.33 | -12.45 | 5.33 | -13 | 5.33 | -3 | 5.33 | -1.15 | 5.33 | -1 | 5.33 | -1.15 | 5.33 | -16.9 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 6.85
GARRISON | VAC | 25.18 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.333 |  | 3.33 |  | 3.33 |  |  | 55.15
2010-02-01 00:00:00 | S/P | 29.4 | 3.33 |  | 3.33 | -8.3 | 3.33 |  | 3.33 |  | 3.33 | -8 | 3.33 | -1 | 3.33 | -8 | 3.33 |  |  |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 34.07
GRIFFITHS | VAC | 22.98 | 3.33 | -7.75 | 3.33 | -10 | 3.33 | -8.3 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66
2008-06-09 00:00:00 | S/P | 0.83 | 3.33 |  | 3.33 | -3.15 | 3.33 | -7.3 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33
IRVING | VAC | 1 | 10 |  | 10 | -7.3 | 10 |  | 10 | -23 | 10 | -16 | 10 |  | 10 | -13.15 | 10 | -16 | 10 |  | 10 |  | 10 |  | 10 |  |  | 15.55
2000-01-10 00:00:00 | S/P | 2.38 | 5.33 |  | 5.33 | -9.3 | 5.33 | -4 | 5.33 | -4.3 | 5.33 | -8 | 5.33 | -6.45 | 5.33 | -5.15 | 5.33 | -6.45 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 6.7
MABE | VAC | -0.5 | 3.33 | -2.85 | 3.33 | -3 | 3.33 |  | 3.33 |  | 3.33 | -3 | 3.33 | -8 | 6.66 |  | 6.66 | -8 | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  |  | 8.29
2008-11-03 00:00:00 | S/P | 0.52 | 3.33 |  | 3.33 | -4.15 | 3.33 | -10 | 3.33 |  | 3.33 | -5.15 | 3.33 | -12.45 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 1.41
POKORA | VAC | 26.33 | 10 |  | 10 |  | 10 |  | 10 | -56 | 10 |  | 10 | -32 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  |  | 28.33
1998-01-03 00:00:00 | S/P | 9.35 | 5.33 |  | 5.33 | -8.15 | 5.33 |  | 5.33 |  | 5.33 | 0.45 | 5.33 | -2 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 52.06
PRATER E | VAC | -0.31 | 6.66 |  | 6.66 | -4 | 6.66 | -8 | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  |  | 47.63
2007-01-16 00:00:00 | S/P | -0.29 | 5.33 |  | 5.33 | -4 | 5.33 | -6 | 5.33 |  | 5.33 |  | 5.33 | -4 | 5.33 |  | 5.33 | -8 | 5.33 |  | 5.33 |  |  |  | 5.33 |  |  | 17.68
PRATER S | VAC | 79.366 | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 | -20 | 6.66 |  | 6.66 | -8 | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  |  | 95.27
2001-10-29 00:00:00 | S/P | 35.25 | 5.33 | -0.5 | 5.33 | -9.3 | 5.33 |  | 5.33 | -19.45 | 5.33 | -2 | 5.33 | -6 | 5.33 | -6 | 5.33 | -2 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 27.31
SARATAVICH | VAC | 113.69 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 | -90 | 10 |  | 10 |  | 10 |  | 10 |  |  | 103.69
1998-08-03 00:00:00 | S/P | 41.12 | 5.33 |  | 5.33 | -8 | 5.33 | -11 | 5.33 | -8.15 | 5.33 |  | 5.33 | -1.15 | 5.33 |  | 5.33 | -2 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 48.81
SHANNER | VAC | 93.1 | 6.66 |  | 6.66 | -19.45 | 6.66 |  | 6.66 |  | 10 |  | 10 | -48 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  |  | 115.66
2000-05-01 00:00:00 | S/P | 22.26 | 5.33 |  | 5.33 | -8 | 5.33 |  | 5.33 | -1.3 | 5.33 |  | 5.33 | -8 | 5.33 | -0.45 | 5.33 | -4 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 39.85
EMPLOYEE |  | BALANCE | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | [NAME] |  | JULY |  | AUG |  | SEPT |  | OCT |  | NOV |  | DEC |  |  | Balance
 |  |  | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used | Earned | Used
SMITH | VAC | 13.31 | 3.33 | -0.45 | 3.33 | -7.15 | 3.33 | -16 | 3.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.3
2009-08-03 00:00:00 | S/P | 0.86 | 3.33 |  | 3.33 | -0.3 | 3.33 | -5.45 | 3.33 | -3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.1
SQUIRES | VAC | 9.99 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 39.97
2010-09-07 00:00:00 | S/P | 9.99 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 | -8 | 3.33 |  | 3.33 | -8 | 3.33 | -8 | 3.33 | -10 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 5.96
SUMMERS | VAC | 72.91 | 6.66 | -4 | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 | -40 | 6.66 | -8 | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  |  | 80.85
2006-09-25 00:00:00 | S/P | 39.1 | 5.33 | -0.25 | 5.33 | -16 | 5.33 | -9.15 | 5.33 |  | 5.33 | -4.15 | 5.33 | -16 | 5.33 | -1 | 5.33 | -8.15 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 24.22
WATT | VAC | 73.75 | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  |  | 147.01
2006-11-08 00:00:00 | S/P | 91.27 | 5.33 |  | 5.33 | -8.3 | 5.33 | -16 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 109.61
WISE | VAC | 40.26 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 6.66 | -48 | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  | 6.66 |  |  | 52.2
2008-05-19 00:00:00 | S/P | 10.8 | 3.33 |  | 3.33 | -8 | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 5.33 | -24 | 5.33 |  | 5.33 |  | 5.33 |  | 5.33 |  |  | 24.77
MORGAN | VAC |  |  |  |  |  |  |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 16.65
2011-03-07 00:00:00 | S/P |  |  |  |  |  |  |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 16.65
MONTY | VAC |  |  |  |  |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 19.98
2011-02-14 00:00:00 | S/P |  |  |  |  |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  | 3.33 |  |  | 19.98