leave balances form

Document Sample
leave balances form Powered By Docstoc
					                                                                                   Garee W. Earnest Leave Balances




NAME
VACATION BALANCES 2008-09                                                                For documentation - page down
Beginning Balance (hrs)
                      268.10
Earned per Annum (hrs)
                        176
                               DATE
Month Bal         Use            1    2   3      4    5    6     7    8   9   10    11     12   13   14    15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31
Jul        282.77      0.00
Aug        297.43      0.00
Sep        312.10      0.00
Oct        326.77      0.00
Nov        341.43      0.00
Dec        356.10      0.00
Jan        370.77      0.00
Feb        385.43      0.00
Mar        400.10      0.00
Apr        414.77      0.00
May        429.43      0.00
Jun        444.10      0.00
       Used            0.00
Ending Balance                                Maximum to Carry over 240
                     444.10

SICK LEAVE BALANCE 2008-09
Beginning Balance (hrs)
                     1205.50
Earned per Annum (hrs)
                        120
                               DATE
Month Bal        Use             1    2   3      4    5    6     7    8   9   10    11     12   13   14    15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31
Jul      1215.50      0.00
Aug      1225.50      0.00
Sep      1235.50      0.00
Oct      1245.50      0.00
Nov      1255.50      0.00
Dec      1265.50      0.00
Jan      1275.50      0.00
Feb      1285.50      0.00
Mar      1295.50      0.00
Apr      1305.50      0.00
May      1315.50      0.00
Jun      1325.50      0.00
       Used           0.00
Ending Balance
                   1325.50




                                                                                                Page 1
                                                                             Garee W. Earnest Leave Balances




Documentation:
This a very simple spreadsheet that was developed to track leave balances.
Enter items only in the yellow areas. The gray contain formulas that will be eased if you enter data there.

1. Enter name and beginning employment date.
2. Enter starting vacation leave balance from July 1 of current fiscal year in hours.
3. Enter number of hours vacation earned per year in hours.
4. Enter starting sick leave balance from July 1 of current fiscal year in hours.
5. Enter number of hours sick leave earned per year in hours.
6. Enter number of leave hours taken in the cell that corresponds to the date and month.
7. Spreadsheet automatically calculates number of hours taken each month and gives an end of year.
8. Use a separate spreadsheet for each employee saved with a unique file name.




                                                                                         Page 2

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:6/29/2012
language:
pages:2