Spreadsheet: 697407d1601341556-calculating-pto-by-hire-date-and-jan-1-reset-pto-edit
Sheet: MASTER

MASTER
SEN | FIRST | SLI Sen. [NAME] | DATE OF HIRE | DAT DAYS | BLOCK WEEK | DAT HOURS | FTO | FHL | YEARS
1 | Darrell | 1978-06-18 00:00:00 | 1980-12-18 00:00:00
2 | [NAME] | 1987-03-05 00:00:00 | 1989-09-05 00:00:00
3 | [NAME] | 1987-03-05 00:00:00 | 1989-09-05 00:00:00
4 | [NAME] | 1987-06-13 00:00:00 | 1989-12-13 00:00:00
5 | [NAME] | 1988-11-16 00:00:00 | 1991-05-16 00:00:00 |  | 1
6 | [NAME] | 1988-12-18 00:00:00 | 1991-06-18 00:00:00 |  | 1
7 | Lindsey | 1995-08-15 00:00:00 | 1998-02-15 00:00:00 |  | 1 |  |  | x
8 | [NAME] | 1998-03-19 00:00:00 | 2000-09-19 00:00:00 |  |  |  |  | x
9 | George | 1998-03-19 00:00:00 | 2000-09-19 00:00:00
10 | [NAME] | 1998-09-14 00:00:00 | 2001-03-14 00:00:00 |  | 4
11 | [NAME] | 1999-11-27 00:00:00 | 2002-05-27 00:00:00
12 | [NAME] | 1999-12-11 00:00:00 | 2002-06-11 00:00:00
13 | [NAME] | 2000-01-17 00:00:00 | 2002-07-17 00:00:00 |  | 1
14 | Mark | 2002-03-20 00:00:00 | 2004-09-20 00:00:00 |  |  |  |  | x
15 | [NAME] | 2003-10-02 00:00:00 | 2006-01-30 00:00:00
16 | [NAME] | 2003-12-09 00:00:00 | 2006-03-16 00:00:00 |  |  |  |  |  |  |  |  | DAT/FTO CALCULATION
17 | [NAME] | 2004-04-08 00:00:00 | 2006-06-05 00:00:00 |  |  |  |  |  |  |  |  | TOTAL DATS & FTO |  |  |  |  | ROUND UP
18 | Isaias | 2004-10-14 00:00:00 | 2004-10-14 00:00:00 |  | 1 |  |  |  |  |  |  |  |  | /363 | =
19 | [NAME] | 2005-05-23 00:00:00 | 2007-03-05 00:00:00
20 | [NAME] | 2006-01-29 00:00:00 | 2005-12-14 00:00:00
21 | Scott | 2007-01-11 00:00:00 | 2008-04-07 00:00:00 |  |  |  |  |  |  |  |  | F. Day at a Time (DAT) Vacation/Flexible Time Off (FTO) Days. The following guidelines shall control DAT vacations/FTO Days: 1. DATs/FTOs will be set aside during the vacation declaration round. 2. If less than five (5) days of vacation are accrued, DATs may be taken. 3. Each bid of work schedules provided in Article Six, Section 1, Paragraph D, shall include an appropriate number of days available for DAT vacations/FTO Days. The appropriate number of DAT/FTO days shall be calculated by dividing the total number of DAT/FTO days after the completion of the vacation declaration by 45 three hundred sixty-three (363). The resulting number (rounded up to the nearest whole number) will be the DAT/FTO days available per day.
22 | [NAME] | 2007-04-28 00:00:00 | 2007-04-28 00:00:00
23 | [NAME] | 2008-12-20 00:00:00 | 2008-12-20 00:00:00
24 | [NAME] | 2010-03-11 00:00:00 | 2010-03-11 00:00:00
25 | Travis | 2010-10-07 00:00:00 | 2010-09-20 00:00:00 |  | 1
26 | [NAME] | 2011-04-11 00:00:00 | 2011-03-12 00:00:00
27 | Kelly | 2011-09-09 00:00:00 | 2011-09-09 00:00:00
28 | Timothy | 2011-11-16 00:00:00 | 2011-11-16 00:00:00
29 | [NAME] | 2013-09-19 00:00:00 | 2013-09-19 00:00:00 |  | 1
30 | [NAME] | 2013-09-19 00:00:00 | 2013-09-09 00:00:00 |  |  |  |  |  |  |  |  | B. Accrual. All Employees shall receive two (2) weeks vacation beginning in the year following their first anniversary with the Company. All Employees shall receive three (3) weeks vacation beginning in the year following their fifth anniversary with the Company. All Employees shall receive four (4) weeks vacation beginning in the year following their tenth anniversary with the Company. All Employees shall receive five (5) weeks vacation beginning in the year following their eighteenth anniversary with the Company.
31 | [NAME] | 2013-12-20 00:00:00 | 2013-12-20 00:00:00
32 | Tyrone | 2013-12-20 00:00:00 | 2013-12-20 00:00:00
33 | [NAME] | 2014-02-18 00:00:00 | 2014-02-18 00:00:00
34 | [NAME] | 2014-02-18 00:00:00 | 2014-02-18 00:00:00
35 | [NAME] | 2014-04-17 00:00:00 | 2014-04-17 00:00:00 |  |  |  |  | x
36 | [NAME] | 2014-05-12 00:00:00 | 2014-05-12 00:00:00
37 | [NAME] | 2014-05-12 00:00:00 | 2014-05-12 00:00:00 |  | 1
38 | [NAME] | 2014-06-23 00:00:00 | 2014-06-23 00:00:00
39 | Lavell | 2014-06-23 00:00:00 | 2014-06-23 00:00:00
40 | [NAME] | 2014-10-27 00:00:00 | 2014-10-27 00:00:00
41 | [NAME] | 2014-12-15 00:00:00 | 2014-12-15 00:00:00 |  | 1
42 | [NAME] | 2015-04-12 00:00:00 | 2015-03-10 00:00:00
43 | Dustin | 2015-04-12 00:00:00 | 2015-03-10 00:00:00 |  | 1
44 | Titus | 2015-06-05 00:00:00 | 2015-05-19 00:00:00
45 | DeTarance | 2015-06-16 00:00:00 | 2015-04-14 00:00:00
46 | Doug | 2015-08-07 00:00:00 | 2015-06-30 00:00:00
47 | Sherilyn | 2015-08-31 00:00:00 | 2015-05-19 00:00:00
48 | Javier | 2015-09-29 00:00:00 | 2015-09-08 00:00:00
49 | Jon | 2015-12-18 00:00:00 | 2015-11-10 00:00:00
50 | Dantre | 2015-12-18 00:00:00 | 2015-11-10 00:00:00
51 | [NAME] | 2015-12-19 00:00:00 | 2015-11-10 00:00:00
52 | [NAME] | 2016-01-09 00:00:00 | 2016-01-09 00:00:00
53 | [NAME] | 2016-03-23 00:00:00 | 2016-03-15 00:00:00
54 | [NAME] | 2016-03-23 00:00:00 | 2016-03-15 00:00:00 |  |  |  |  | x
55 | [NAME] | 2016-04-16 00:00:00 | 2016-03-29 00:00:00
56 | [NAME] | 2016-06-06 00:00:00 | 2016-03-29 00:00:00 |  |  |  |  | x
57 | [NAME] | 2016-06-23 00:00:00 | 2016-06-13 00:00:00 |  | 1
58 | [NAME] | 2016-06-25 00:00:00 | 2016-06-13 00:00:00
59 | [NAME] | 2016-08-06 00:00:00 | 2016-08-02 00:00:00
60 | Malick | 2016-09-15 00:00:00 | 2016-08-22 00:00:00 |  | 1 |  |  | x
61 | Jeanette | 2016-09-28 00:00:00 | 2016-08-02 00:00:00
62 | [NAME] | 2016-10-02 00:00:00 | 2016-08-22 00:00:00
63 | [NAME] | 2016-10-06 00:00:00 | 2016-08-22 00:00:00
64 | Greg | 2016-10-06 00:00:00 | 2016-08-22 00:00:00
65 | [NAME] | 2017-03-30 00:00:00 | 2017-03-30 00:00:00 |  | 1
66 | [NAME] | 2017-04-17 00:00:00 | 2017-01-23 00:00:00 |  |  |  |  | x
67 | [NAME] | 2017-04-20 00:00:00 | 2017-02-13 00:00:00
68 | Mitch | 2017-06-14 00:00:00 | 2017-04-10 00:00:00 |  |  |  |  | x
69 | [NAME] | 2017-07-08 00:00:00 | 2017-04-10 00:00:00
70 | [NAME] | 2017-11-25 00:00:00 | 2017-05-15 00:00:00
71 | Kody | 2017-12-10 00:00:00 | 2017-10-09 00:00:00
72 | [NAME] | 2018-02-06 00:00:00 | 2017-10-09 00:00:00 |  | 1
73 | Olivia | 2018-03-02 00:00:00 | 2017-12-11 00:00:00 |  |  |  |  | x
74 | [NAME] | 2018-03-09 00:00:00 | 2017-12-11 00:00:00 |  |  |  |  | x
75 | [NAME] | 2019-01-08 00:00:00 | 2018-11-12 00:00:00 |  | 1 |  |  | x
76 | Troy | 2019-01-08 00:00:00 | 2018-11-12 00:00:00 |  |  |  |  | x
77 | [NAME] | 2019-08-19 00:00:00 | 2019-08-19 00:00:00
78 | [NAME] | 2019-09-09 00:00:00 | 2019-09-09 00:00:00
PART TIME
1 | Alexa | 2015-12-01 00:00:00 | 2015-12-01 00:00:00
2 | [NAME] | 2016-06-06 00:00:00 | 2016-06-06 00:00:00
3 | [NAME] | 2016-10-31 00:00:00 | 2016-10-20 00:00:00 |  |  |  |  | x
4 | [NAME] | 2017-03-30 00:00:00 | 2017-02-13 00:00:00 |  | 1
5 | Blake | 2017-04-10 00:00:00 | 2017-04-10 00:00:00
6 | Cooper | 2018-01-15 00:00:00 | 2018-01-15 00:00:00 |  |  |  |  | x
7 | Cornell | 2018-07-09 00:00:00 | 2018-07-09 00:00:00 |  |  |  |  | x
8 | Caryn | 2018-11-12 00:00:00 | 2018-11-12 00:00:00 |  |  |  |  | x
9 | [NAME] | 2018-11-12 00:00:00 | 2018-11-12 00:00:00 |  |  |  |  | x
10 | [NAME] | 2019-09-23 00:00:00 | 2019-09-29 00:00:00