Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

tracker

VIEWS: 55 PAGES: 2

									                                                     Vacation Tracker Deluxe
                                                       (for Administrative Staff)

Today's Date:                  5/18/2011                               Important: For the purposes of this tool, "days" are equivalent to
Employee's Name:                                                       standard full work days . An employee at 50% effort working five half
                                                                       days each week should record a day of vacation as ".5" in the Days Used
Leave Accrual Rate Date:
                                                                       column. An employee at 80% effort working 4 full days each week
Enter month and year to                                                should record a day of vacation as "1" in the Days Used column.
begin tracking (if different   Month       Year
from start date):                                                      Be sure to enter the correct % effort for each month!

                                                                               th
                                  REGULAR VACATION ACCRUAL       5 WEEK CREDIT
                               Beginning Days    Days  Ending Days    Days         Monthly %
                                                                           Balance                                             Notes
    Month Ending                Balance Accrued Used Balance Credited Used          Effort
 Enter Eligibility Date!
                                  0.00      1.6667              1.67   #VALUE!                #VALUE!         100%
                                  1.67      1.6667              3.33   #VALUE!                #VALUE!         100%
                                  3.33      1.6667              5.00   #VALUE!                #VALUE!         100%
                                  5.00      1.6667              6.67   #VALUE!                #VALUE!         100%
                                  6.67      1.6667              8.33   #VALUE!                #VALUE!         100%
                                  8.33      1.6667             10.00   #VALUE!                #VALUE!         100%
                                  10.00     1.6667             11.67   #VALUE!                #VALUE!         100%
                                  11.67     1.6667             13.33   #VALUE!                #VALUE!         100%
                                  13.33     1.6667             15.00   #VALUE!                #VALUE!         100%
                                  15.00     1.6667             16.67   #VALUE!                #VALUE!         100%
                                  16.67     1.6667             18.33   #VALUE!                #VALUE!         100%
                                  18.33     1.6667             20.00   #VALUE!                #VALUE!         100%
                                  20.00     1.6667             21.67   #VALUE!                #VALUE!         100%
                                  21.67     1.6667             23.33   #VALUE!                #VALUE!         100%
                                  23.33     1.6667             25.00   #VALUE!                #VALUE!         100%
                                  25.00     1.6667             26.67   #VALUE!                #VALUE!         100%
                                  26.67     1.6667             28.33   #VALUE!                #VALUE!         100%
                                  28.33     1.6667             30.00   #VALUE!                #VALUE!         100%
                                  30.00     1.6667             31.67   #VALUE!                #VALUE!         100%
                                  31.67     1.6667             33.33   #VALUE!                #VALUE!         100%
                                  33.33     1.6667             35.00   #VALUE!                #VALUE!         100%
                                  35.00     1.6667             36.67   #VALUE!                #VALUE!         100%
                                  36.67     1.6667             38.33   #VALUE!                #VALUE!         100%
                                  38.33     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
                                  40.00     1.6667             40.00   #VALUE!                #VALUE!         100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%
40.00   1.6667   40.00   #VALUE!   #VALUE!   100%

								
To top