Spreadsheet: 154390d1336411186-excel-2007-vacation-accruals-help-please-vacation-accrual
Sheet: Sheet1

 | Vacation Accrual Tracking: HOURLY
*only enter in yellow columns |  |  |  |  |  |  |  |  |  |  | 2008-01-04 00:00:00 | 2008-01-11 00:00:00 | 2008-01-18 00:00:00 | 2008-01-25 00:00:00 | 2008-02-01 00:00:00 | 2008-02-08 00:00:00 | 2008-02-15 00:00:00 | 2008-02-22 00:00:00 | 2008-02-29 00:00:00 | 2008-03-07 00:00:00 | 2008-03-14 00:00:00 | 2008-03-21 00:00:00 | 2008-03-28 00:00:00 | 2008-04-04 00:00:00 | 2008-04-11 00:00:00 | 2008-04-18 00:00:00 | 2008-04-25 00:00:00 | 2008-05-02 00:00:00 | 2008-05-09 00:00:00 | 2008-05-16 00:00:00 | 2008-05-23 00:00:00 | 2008-05-30 00:00:00 | 2008-06-06 00:00:00 | 2008-06-13 00:00:00 | 2008-06-20 00:00:00 | 2008-06-27 00:00:00
 |  |  |  | Years of Employment | Earned Vacation Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining Vacation Hours | Remaining Vacation Dollars
First | Last | Hire Date | Todays Date |  |  | [NAME] | Dollars Accrued | Hours Accrued | Taken in 2006 | Taken in 2007
[NAME] | Gardner | 2011-05-07 00:00:00 | 2012-05-07 00:00:00 | 1.002739726027397 | 10.6516301369863 | 0 | 0 | 24 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | [NAME] | 2011-05-07 00:00:00 | 2012-05-07 00:00:00 | 1.002739726027397 | 10.6516301369863 | 0 | 0 | 24 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | [NAME] | 2005-11-14 00:00:00 | 2012-05-07 00:00:00 | 6.482191780821918 | 19 | 0 | 0 | 180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Tiffany | Leonard | 2006-05-01 00:00:00 | 2012-05-07 00:00:00 | 6.021917808219178 | 19 | 0 | 0 | 177.12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Crouse | 2006-05-22 00:00:00 | 2012-05-07 00:00:00 | 5.964383561643835 | 18 | 0 | 0 | 174.66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Pepin | 2006-07-31 00:00:00 | 2012-05-07 00:00:00 | 5.772602739726027 | 18 | 0 | 0 | 169.74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Aldridge | 2006-10-10 00:00:00 | 2012-05-07 00:00:00 | 5.578082191780822 | 18 | 0 | 0 | 162.36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Stacy | [NAME] | 2006-10-30 00:00:00 | 2012-05-07 00:00:00 | 5.523287671232877 | 18 | 0 | 0 | 162.36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Handley | 2006-10-30 00:00:00 | 2012-05-07 00:00:00 | 5.523287671232877 | 18 | 0 | 0 | 162.36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Gross | 2007-02-12 00:00:00 | 2012-05-07 00:00:00 | 5.235616438356164 | 18 | 0 | 0 | 152.52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Dustin | [NAME] | 2007-03-30 00:00:00 | 2012-05-07 00:00:00 | 5.109589041095891 | 18 | 0 | 0 | 150.06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | [NAME] | 2007-06-11 00:00:00 | 2012-05-07 00:00:00 | 4.909589041095891 | 17 | 0 | 0 | 142.68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Harrell | 2007-06-14 00:00:00 | 2012-05-07 00:00:00 | 4.901369863013699 | 17 | 0 | 0 | 142.68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Crandall | 2007-06-25 00:00:00 | 2012-05-07 00:00:00 | 4.871232876712329 | 17 | 0 | 0 | 142.68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Mark | Ervin | 2007-07-23 00:00:00 | 2012-05-07 00:00:00 | 4.794520547945205 | 17 | 0 | 0 | 140.22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | [NAME] | 2007-08-06 00:00:00 | 2012-05-07 00:00:00 | 4.756164383561644 | 17 | 0 | 0 | 140.22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Clarke | 2007-10-01 00:00:00 | 2012-05-07 00:00:00 | 4.602739726027397 | 17 | 0 | 0 | 135.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Weaver | 2007-10-01 00:00:00 | 2012-05-07 00:00:00 | 4.602739726027397 | 17 | 0 | 0 | 135.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Todd | [NAME] | 2007-10-01 00:00:00 | 2012-05-07 00:00:00 | 4.602739726027397 | 17 | 0 | 0 | 135.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Tolly | 2007-10-03 00:00:00 | 2012-05-07 00:00:00 | 4.597260273972603 | 17 | 0 | 0 | 135.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Ferguson | 2007-10-08 00:00:00 | 2012-05-07 00:00:00 | 4.583561643835616 | 17 | 0 | 0 | 132.84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Lori | Lockard | 2007-10-15 00:00:00 | 2012-05-07 00:00:00 | 4.564383561643836 | 17 | 0 | 0 | 132.84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Berry | 2007-11-19 00:00:00 | 2012-05-07 00:00:00 | 4.468493150684932 | 17 | 0 | 0 | 130.38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | [NAME] | 2007-12-10 00:00:00 | 2012-05-07 00:00:00 | 4.410958904109589 | 17 | 0 | 0 | 127.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Theresa | [NAME] | 2007-12-18 00:00:00 | 2012-05-07 00:00:00 | 4.389041095890411 | 17 | 0 | 0 | 127.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Kelly | Rhinehart | 2007-12-28 00:00:00 | 2012-05-07 00:00:00 | 4.361643835616438 | 17 | 0 | 0 | 127.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Kathy | Helton | 2008-02-05 00:00:00 | 2012-05-07 00:00:00 | 4.254794520547946 | 17 | 0 | 0 | 125.46 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  |  |  | 0
[NAME] | [NAME] | 2008-02-25 00:00:00 | 2012-05-07 00:00:00 | 4.2 | 17 | 0 | 0 | 123 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Brittany | [NAME] | 2008-03-04 00:00:00 | 2012-05-07 00:00:00 | 4.178082191780822 | 17 | 0 | 0 | 123 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Tanya | Wolcott | 2008-03-05 00:00:00 | 2012-05-07 00:00:00 | 4.175342465753425 | 17 | 0 | 0 | 123 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Wheatly | 2008-05-01 00:00:00 | 2012-05-07 00:00:00 | 4.019178082191781 | 17 | 0 | 0 | 118.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Crystal | Ward | 2008-05-01 00:00:00 | 2012-05-07 00:00:00 | 4.019178082191781 | 17 | 0 | 0 | 118.08 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Helen | [NAME] | 2008-05-01 00:00:00 | 2012-05-07 00:00:00 | 4.019178082191781 | 17 | 0 | 0 | 118.08 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | Berry | 2007-11-19 00:00:00 | 2012-05-07 00:00:00 | 4.468493150684932 | 120