Spreadsheet: 688003d1595520156-pto-accrual-vacation-sheet-3-
Sheet: Employee

 |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | January |  |  |  |  | February |  |  |  |  | March |  |  |  |  | April |  |  |  |  | May
Employee Name | Co. | Sal. Start | Column2 | Years of Service | Used | Column5 | Accural rate | Vac. Hours | Roll over hours | Accrued | No.PR | Column1 | Hours Taken | Hours Remaining | Column3 | [NAME] | No.PR4 | Hours Taken4 | Hours Remaining6 | Column7 | Will Accrue8 | No.PR9 | Hours Taken10 | Hours Remaining11 | Column4 | [NAME] | No. PR | Hours Taken14 | Hours Remaining15 | Column16 | [NAME] | No. PR18 | Hours Taken19 | Hours Remaining20 | Column21 | Accrued22 | No. PR23 | Hours Taken24 | Hours Remaining25 | Column26 | Accrued27 | No. PR28 | Hours Taken3 | Hours Remaining30 | Column31 | Accrued32 | No. PR33 | Hours Taken2 | Hours Remaining35 | Column36 | Accrued37 | No. PR38 | Hours Taken39 | [NAME] | Column41 | Accrued42 | No. PR43 | Hours Taken44 | Hours Remaining45 | Column46 | Accrued47 | No. PR48 | Hours Taken49 | Hours Remaining50 | Column51 | Accrued52 | No. PR53 | Hours Taken54 | Hours Remaining55
 |  | 2012-09-24 00:00:00 |  |  |  |  | 4.62 |  | 24 |  | 2 |  |  |  |  |  | 2 | 8 |  |  |  | 2 | 4 |  |  |  | 2 | 56 |  |  |  | 3 | 76 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2018-03-05 00:00:00 |  |  |  |  |  |  |  |  | 2
 |  | 2010-06-07 00:00:00 |  |  |  |  | 5.54 |  | 12 |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 | 4 |  |  |  | 2 |  |  |  |  | 3 | 8 |  |  |  | 2 | 4 |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2018-03-07 00:00:00 |  |  |  |  |  |  |  |  | 2
 |  | 2018-03-08 00:00:00 |  |  |  |  |  |  |  |  | 2
 |  | 2018-03-09 00:00:00 |  |  |  |  |  |  |  |  | 2
 |  | 2013-11-04 00:00:00 |  |  |  |  | 4.62 |  | 20 |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 | 24 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2018-07-23 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  | 8 |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 | 8 |  |  |  | 2 | 4 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2007-03-01 00:00:00 |  |  |  |  | 5.54 |  | -28 |  | 2 |  |  |  |  |  | 2 | 4 |  |  |  | 2 |  |  |  |  | 2 | 12 |  |  |  | 3 | 8 |  |  |  | 2 | 4 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2018-06-21 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  | 12 |  |  |  | 2 | 16 |  |  |  | 2 |  |  |  |  | 2 | 8 |  |  |  | 3 |  |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2019-04-22 00:00:00 |  |  |  |  | 3.69
 |  | 2018-09-10 00:00:00 |  |  |  |  | 3.69 |  | -8 |  | 2
 |  | 2012-03-13 00:00:00 |  |  |  |  | 4.62 |  | 24 |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 | 16 |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2018-03-18 00:00:00 |  |  |  |  |  |  |  |  | 2
 |  | 2018-03-19 00:00:00 |  |  |  |  |  |  |  |  | 2
 |  | 2019-03-26 00:00:00 |  |  |  |  | 3.69 |  | 72 |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2012-10-29 00:00:00 |  |  |  |  |  |  |  |  | 2
 |  | 2017-12-17 00:00:00 |  |  |  |  |  |  |  |  | 2
 |  | 2018-04-23 00:00:00 |  |  |  |  | 3.69 |  | 8 |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2017-03-06 00:00:00 |  |  |  |  | 3.69 |  | 24
 |  | 2017-05-18 00:00:00 |  |  |  |  | 3.69 |  | 24 |  | 2 |  | 8 |  |  |  | 2 | 16 |  |  |  | 2 | 12 |  |  |  | 2 |  |  |  |  | 3 | 24 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2019-04-29 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 | 8 |  |  |  | 2 |  |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2019-05-07 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 | 48 |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2017-07-10 00:00:00 |  |  |  |  | 3.69 |  | 24
 |  | 2019-09-02 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  |  |  |  |  | 2 | 40 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 | 4 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2013-07-17 00:00:00 |  |  |  |  | 4.62
 |  | 2019-04-01 00:00:00 |  |  |  |  | 3.69
 |  | 2015-10-19 00:00:00 |  |  |  |  | 3.69 |  | 24 |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2013-01-01 00:00:00 |  |  |  |  | 4.62 |  | 24
 |  | 2019-01-28 00:00:00 |  |  |  |  | 3.69
 |  | 2019-04-01 00:00:00 |  |  |  |  | 3.69
 |  | 2019-02-26 00:00:00 |  |  |  |  | 3.69 |  | 24 |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2015-12-01 00:00:00 |  |  |  |  | 3.69 |  | 20 |  | 2 |  |  |  |  |  | 2 | 4 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 | 28 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2019-09-23 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 | 8 |  |  |  | 2 | 16 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2018-10-10 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  |  |  |  |  | 2 | 16 |  |  |  | 2 | 16 |  |  |  | 2 | 24 |  |  |  | 3 |  |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2010-01-27 00:00:00 |  |  |  |  | 5.54 |  | 24 |  | 2 |  | 12 |  |  |  | 2 |  |  |  |  | 2 | 24 |  |  |  | 2 | 3 |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2020-06-22 00:00:00 |  |  |  |  |  |  | 120 |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2018-10-22 00:00:00 |  |  |  |  | 3.69
 |  | 2016-06-12 00:00:00 |  |  |  |  | 3.69 |  | -16
 |  | 2019-04-22 00:00:00 |  |  |  |  | 3.69
 |  | 2018-08-20 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  | 16 |  |  |  | 2 | 16 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 | 24 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2013-01-25 00:00:00 |  |  |  |  | 4.62 |  | 24
 |  | 2012-02-07 00:00:00 |  |  |  |  | 4.62 |  | 8 |  | 2 |  | 24 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 | 4 |  |  |  | 3 | 12 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2013-02-05 00:00:00 |  |  |  |  | 4.62 |  | 16 |  | 2 |  | 32 |  |  |  | 2 |  |  |  |  | 2 | 48 |  |  |  | 2 | 8 |  |  |  | 3 |  |  |  |  | 2 | 16 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2014-05-26 00:00:00 |  |  |  |  | 4.62 |  | 24
 |  | 2017-06-12 00:00:00 |  |  |  |  | 3.69
 |  | 2011-12-19 00:00:00 |  |  |  |  | 4.62 |  | 24
 |  | 2011-08-15 00:00:00 |  |  |  |  | 4.62 |  | 24 |  | 2 |  |  |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 | 8 |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2003-03-01 00:00:00 |  |  |  |  | 5.54 |  | 24 |  | 2 |  | 4 |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 | 16 |  |  |  | 3 | 20 |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2010-03-01 00:00:00 |  |  |  |  | 5.54 |  | 24
 |  | 2018-04-23 00:00:00 |  |  |  |  | 3.69 |  | 8
 |  | 2009-09-14 00:00:00 |  |  |  |  | 5.54 |  | 24 |  | 2 |  | 12 |  |  |  | 2 | 7 |  |  |  | 2 | 12 |  |  |  | 2 | 10 |  |  |  | 3 | 8 |  |  |  | 2 | 8 |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2013-07-01 00:00:00 |  |  |  |  | 4.62 |  | 24
 |  | 2018-05-07 00:00:00 |  |  |  |  | 3.69
 |  | 2007-07-09 00:00:00 |  |  |  |  | 5.54 |  | 0
 |  | 2019-06-23 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  | 16 |  |  |  | 2 | 8 |  |  |  | 2 | 24 |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2012-10-08 00:00:00 |  |  |  |  | 4.62 |  |  |  | 2 |  |  |  |  |  | 2 | 48 |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2009-07-31 00:00:00 |  |  |  |  | 5.54 |  | 24 |  | 2 |  |  |  |  |  | 2 | 8 |  |  |  | 2 | 4 |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2019-04-15 00:00:00 |  |  |  |  | 3.69
 |  | 2004-07-16 00:00:00 |  |  |  |  | 5.54 |  | 24 |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 | 16 |  |  |  | 2 | 8 |  |  |  | 3 | 24 |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2004-12-06 00:00:00 |  |  |  |  | 5.54 |  | 16 |  | 2 |  | 16 |  |  |  | 2 | 40 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2018-03-05 00:00:00 |  |  |  |  | 3.69 |  |  |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2020-05-26 00:00:00 |  |  |  |  | 1.85
 |  | 2018-08-15 00:00:00 |  |  |  |  | 3.69
 |  | 2018-08-14 00:00:00 |  |  |  |  | 3.69 |  | -4 |  | 2 |  | 12 |  |  |  | 2 |  |  |  |  | 2 | 5 |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 | 8 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | 2
 |  | 2018-08-23 00:00:00 |  |  |  |  | 3.69
Rules
>1 Year | 1.85
1-4 years | 3.69
5-9 years | 4.62
< 10 years | 5.54