Spreadsheet: 688092d1595567660-pto-accrual-accrual-rate-bvj-
Sheet: Employee

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