Spreadsheet: 91039d1290711975-excel-2008-resolved-configuring-nested-if-logic-vacation-and-family-care-v2
Sheet: Leave

Name | Status | Date Hired | Years Employed | Vacation Leave | Used Vacation Leave | Remaining Vacation Leave | Family Leave | Used Family Leave | Remaining Family Leave
Abba | FT | 2007-08-23 00:00:00 |  |  | 5 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00
Abbot | FT | 2010-05-07 00:00:00 |  |  | 0 |  |  | 0
Adtkins | FT | 2008-10-06 00:00:00 |  |  | 4 |  |  | 1
[NAME] | FT | 2008-05-15 00:00:00 |  |  | 3 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 days for full time working 4 or more years
[NAME] | PT | 2009-03-19 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 days for full time between 2 and 4 years
[NAME] | FT | 2006-12-28 00:00:00 |  |  | 4 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 days for full time between 1-2 years
Bergeman | FT | 2009-10-01 00:00:00 |  |  | 0 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 for none.
Blake | CN | 2007-08-17 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2008-03-20 00:00:00 |  |  | 6 |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 days 1 or more years
Borchardt | CN | 2007-07-06 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 days less than 1 year full time or part time for more than 1.5 years
Captian | FT | 2009-01-08 00:00:00 |  |  | 3 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 for none
[NAME] | PT | 2006-05-04 00:00:00 |  |  | 0 |  |  | 0
Chi | FT | 2008-09-12 00:00:00 |  |  | 3 |  |  | 2
[NAME] | FT | 2009-06-25 00:00:00 |  |  | 3 |  |  | 0
Christain | FT | 2010-01-21 00:00:00 |  |  | 0 |  |  | 2
Clarke | FT | 2010-02-18 00:00:00 |  |  | 0 |  |  | 0
Crawford | PT | 2009-08-20 00:00:00 |  |  | 0 |  |  | 0
Czeller | FT | 2006-06-29 00:00:00 |  |  | 0 |  |  | 0
[NAME] | PT | 2008-09-12 00:00:00 |  |  | 0 |  |  | 1
[NAME] | FT | 2010-03-04 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2008-09-26 00:00:00 |  |  | 3 |  |  | 2
Dawes | FT | 2010-01-07 00:00:00 |  |  | 0 |  |  | 1
Doering | FT | 2007-12-27 00:00:00 |  |  | 2 |  |  | 0
Dolan | FT | 2006-05-04 00:00:00 |  |  | 0 |  |  | 3
[NAME] | CN | 2006-06-01 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2008-07-24 00:00:00 |  |  | 1 |  |  | 0
[NAME] | FT | 2009-12-04 00:00:00 |  |  | 0 |  |  | 1
[NAME] | PT | 2008-08-21 00:00:00 |  |  | 0 |  |  | 0
Frase | FT | 2006-04-06 00:00:00 |  |  | 0 |  |  | 3
Fuller | PT | 2007-12-27 00:00:00 |  |  | 0 |  |  | 3
Gere | FT | 2009-05-14 00:00:00 |  |  | 1 |  |  | 4
[NAME] | FT | 2008-11-13 00:00:00 |  |  | 2 |  |  | 0
Green | FT | 2009-07-23 00:00:00 |  |  | 0 |  |  | 2
[NAME] | FT | 2009-09-05 00:00:00 |  |  | 0 |  |  | 3
Hayden | FT | 2007-08-17 00:00:00 |  |  | 7 |  |  | 2
Hennings | FT | 2006-08-12 00:00:00 |  |  | 2 |  |  | 4
Hensel | PT | 2006-08-07 00:00:00 |  |  | 0 |  |  | 1
Hildeberg | FT | 2007-09-14 00:00:00 |  |  | 4 |  |  | 0
Hogan | FT | 2006-04-06 00:00:00 |  |  | 6 |  |  | 3
[NAME] | FT | 2009-07-31 00:00:00 |  |  | 0 |  |  | 2
Isaacs | FT | 2006-08-18 00:00:00 |  |  | 5 |  |  | 3
Jessup | FT | 2009-08-16 00:00:00 |  |  | 0 |  |  | 1
[NAME] | FT | 2010-05-21 00:00:00 |  |  | 0 |  |  | 2
Kaufmann | FT | 2007-07-26 00:00:00 |  |  | 1 |  |  | 1
Knuteson | PT | 2006-04-06 00:00:00 |  |  | 0 |  |  | 1
[NAME] | PT | 2008-04-03 00:00:00 |  |  | 0 |  |  | 2
Lasek | PT | 2010-04-15 00:00:00 |  |  | 0 |  |  | 0
Laszewski | PT | 2007-09-20 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2008-12-11 00:00:00 |  |  | 4 |  |  | 1
[NAME] | FT | 2009-01-08 00:00:00 |  |  | 2 |  |  | 1
Lei | FT | 2007-11-29 00:00:00 |  |  | 0 |  |  | 0
Mahanez | FT | 2007-05-03 00:00:00 |  |  | 4 |  |  | 2
Menendez | PT | 2009-08-20 00:00:00 |  |  | 0 |  |  | 0
Meyer | PT | 2006-07-13 00:00:00 |  |  | 0 |  |  | 3
[NAME] | FT | 2008-09-12 00:00:00 |  |  | 3 |  |  | 3
[NAME] | FT | 2008-09-12 00:00:00 |  |  | 4 |  |  | 3
Nevers | FT | 2007-11-29 00:00:00 |  |  | 3 |  |  | 2
Nieland | FT | 2009-12-04 00:00:00 |  |  | 0 |  |  | 3
Okanawa | FT | 2006-09-07 00:00:00 |  |  | 7 |  |  | 3
Palmer | FT | 2009-12-26 00:00:00 |  |  | 0 |  |  | 3
[NAME] | PT | 2008-06-26 00:00:00 |  |  | 0 |  |  | 0
Paulson | PT | 2009-07-09 00:00:00 |  |  | 0 |  |  | 0
[NAME] | PT | 2008-12-11 00:00:00 |  |  | 0 |  |  | 0
Phman | FT | 2009-11-12 00:00:00 |  |  | 0 |  |  | 0
Pia | PT | 2009-08-08 00:00:00 |  |  | 0 |  |  | 0
Quinonese | FT | 2010-01-21 00:00:00 |  |  | 0 |  |  | 2
Raab | FT | 2006-05-04 00:00:00 |  |  | 4 |  |  | 2
[NAME] | FT | 2010-05-07 00:00:00 |  |  | 0 |  |  | 1
Ratcliffe | FT | 2006-06-23 00:00:00 |  |  | 1 |  |  | 2
Raulings | PT | 2008-09-04 00:00:00 |  |  | 0 |  |  | 0
Ricard | PT | 2008-03-06 00:00:00 |  |  | 0 |  |  | 0
Roche | FT | 2008-08-21 00:00:00 |  |  | 1 |  |  | 2
Rodriguez | FT | 2009-04-16 00:00:00 |  |  | 2 |  |  | 1
Rosenblum | FT | 2007-10-14 00:00:00 |  |  | 7 |  |  | 1
[NAME] | PT | 2008-08-21 00:00:00 |  |  | 0 |  |  | 0
[NAME] | PT | 2010-03-04 00:00:00 |  |  | 0 |  |  | 0
Sanchez | FT | 2009-04-30 00:00:00 |  |  | 0 |  |  | 2
Santoirre | FT | 2008-08-29 00:00:00 |  |  | 2 |  |  | 2
Schorr | CN | 2006-04-06 00:00:00 |  |  | 0 |  |  | 0
Shapiro | CN | 2008-04-03 00:00:00 |  |  | 0 |  |  | 0
Sidney | CN | 2009-01-17 00:00:00 |  |  | 0 |  |  | 0
Takayma | FT | 2009-04-16 00:00:00 |  |  | 5 |  |  | 2
Tallard | FT | 2008-04-03 00:00:00 |  |  | 4 |  |  | 0
[NAME] | PT | 2006-08-24 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2010-01-07 00:00:00 |  |  | 0 |  |  | 0
Unlaughten | PT | 2006-07-13 00:00:00 |  |  | 0 |  |  | 0
Vaughn | FT | 2008-04-06 00:00:00 |  |  | 1 |  |  | 3
Veronese | FT | 2009-05-14 00:00:00 |  |  | 5 |  |  | 1
Vos | PT | 2006-07-13 00:00:00 |  |  | 0 |  |  | 1
Walters | FT | 2007-05-31 00:00:00 |  |  | 5 |  |  | 3
Weigstein | FT | 2009-10-29 00:00:00 |  |  | 0 |  |  | 0
Whitman | FT | 2007-08-11 00:00:00 |  |  | 5 |  |  | 0
Whorle | FT | 2010-05-07 00:00:00 |  |  | 0 |  |  | 1
Whyte | FT | 2006-04-13 00:00:00 |  |  | 4 |  |  | 2
[NAME] | PT | 2008-04-17 00:00:00 |  |  | 0 |  |  | 0
Woods | FT | 2010-05-29 00:00:00 |  |  | 0 |  |  | 3
[NAME] | FT | 2007-08-11 00:00:00 |  |  | 6 |  |  | 2
[NAME] | FT | 2008-05-15 00:00:00 |  |  | 7 |  |  | 1
Young | FT | 2008-06-30 00:00:00 |  |  | 5 |  |  | 0
Zellner | FT | 2007-11-04 00:00:00 |  |  | 0 |  |  | 2
Ziegler | FT | 2007-11-29 00:00:00 |  |  | 7 |  |  | 3
[NAME] | FT | 2007-06-28 00:00:00 |  |  | 0 |  |  | 0