Spreadsheet: 271028d1381787725-percentage-formulas-vacation_accrual_sample
Sheet: 1.0 Day

 | Employee |  |  |  |  |  |  |  |  |  |  |  |  |  | USC Hire Date: |  |  |  | 2000-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted Hire Date:
 | Department |  |  | XXXXXXXX / XX-XXXX-XXXX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0-4 Years: 1.0 Days Per Month ([NAME]: 24 days)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5-9 Years: 1.5 Days Per Month ([NAME]: 36 days)
 | Employee Signature: ________________________________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: ______________________ |  |  |  |  |  |  |  | 10+ Years: 2.0 Days Per Month ([NAME]: 48 days)
 | Supervisor Signature: ________________________________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: ______________________
 |  | Earns |  | 1.7 |  |  | Vacation Days/month until |  |  |  |  |  | 2003-06-06 00:00:00
 | Vacation Days Carried forward |  |  |  |  |  |  | 0 |  | 35 | Days Maximum |  |  |  |  |  | 2013-10-11 00:00:00 |  |  |  | Vacation |  |  |  | Sick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To-date Totals |  |  |  |  | 20 |  |  |  | 3
 | Sick Days Carried forward |  |  |  |  |  |  | 0 |  | 12 | Days Maximum
 | Percentage of time Worked |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VACATION
 |  | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) | Time Out | Code (S/V) |  |  |  | BAL FWD | EARN | USE | LOST VACATION | BAL
 |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  | 1 |  | 2012-07-31 00:00:00 | 0 | 1.7 | 0 | 0 | 1.7
 | 2 |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 2012-08-31 00:00:00 | 1.7 | 1.7 | 0 | 0 | 3.4
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2012-09-30 00:00:00 | 3.4 | 1.7 | 0 | 0 | 5.1
 | 4 |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 2012-10-31 00:00:00 | 5.1 | 1.7 | 0 | 0 | 6.8
 | 5 |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 2012-11-30 00:00:00 | 6.8 | 1.7 | 0 | 0 | 8.5
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 2012-12-31 00:00:00 | 8.5 | 1.7 | 0 | 0 | 10.2
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 2013-01-31 00:00:00 | 10.2 | 1.7 | 0 | 0 | 11.9
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 2013-02-28 00:00:00 | 11.9 | 1.7 | 0 | 0 | 13.6
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 2013-03-31 00:00:00 | 13.6 | 1.7 | 0 | 0 | 15.3
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 2013-04-30 00:00:00 | 15.3 | 1.7 | 0 | 0 | 17
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 2013-05-31 00:00:00 | 17 | 1.7 | 0 | 0 | 18.7
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 2013-06-30 00:00:00 | 18.7 | 1.300000000000004 | 0 | 1.7 | 20
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  | Vacation
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  | TOTALS | 20 | 0 | 1.7 | 20
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  | 17 |  |  | SICK
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  | BAL FWD | EARN | USE |  | BAL
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  | 20 |  | 2013-07-31 00:00:00 | 0 | 1 | 0 |  | 1
 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 2013-08-31 00:00:00 | 1 | 1 | 0 |  | 2
 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 2013-09-30 00:00:00 | 2 | 1 | 0 |  | 3
 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 2013-10-31 00:00:00 | 3 | 0 | 0 |  | 3
 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 2013-11-30 00:00:00 | 3 | 0 | 0 |  | 3
 | 25 |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 2013-12-31 00:00:00 | 3 | 0 | 0 |  | 3
 | 26 |  |  |  |  |  |  |  |  |  |  |  | WR |  |  |  |  |  |  |  |  |  | H |  |  | 26 |  | 2014-01-31 00:00:00 | 3 | 0 | 0 |  | 3
 | 27 |  |  |  |  |  |  |  |  |  |  |  | WR |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  | 2014-02-28 00:00:00 | 3 | 0 | 0 |  | 3
 | 28 |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  | 2014-03-31 00:00:00 | 3 | 0 | 0 |  | 3
 | 29 |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 2014-04-30 00:00:00 | 3 | 0 | 0 |  | 3
 | 30 |  |  |  |  |  |  |  |  |  |  |  | WR |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 2014-05-31 00:00:00 | 3 | 0 | 0 |  | 3
 | 31 |  |  |  |  |  |  |  |  |  |  |  | WR |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  | 2014-06-30 00:00:00 | 3 | 0 | 0 |  | 3
 |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | 30 |  |  | Sick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  |  | TOTALS | 3 | 0 |  | 3
 |  | Key: |  | H= | University Holiday |  |  |  |  | B= | Bereavement |  |  |  |  | M= | Maternity Leave
 |  |  |  | S= | Sick |  |  |  |  | D= | Disability |  |  |  |  | L= | [NAME]
 |  |  |  | V= | Vacation |  |  |  |  | [NAME] | Jury Duty |  |  |  |  | LV= | Lost Vacation