2009 Vacation Spreedsheet

  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View 2009 Vacation Spreedsheet as PDF for free.

More details

  • Words: 1,654
  • Pages: 14
Spreadsheet instructions:

Use the sheet that applies to how your employee accures vacation. In the top cell enter any balance that was carried over from Employee Name For Calendar Year Starting: Jan-2007

Hire Date Override Annual Vacation

80

VACATION Jan-1899 Feb-1899 Mar-1899 Apr-1899 May-1899 Jun-1899 Jul-1899 Aug-1899 Sep-1899 Starting Bal. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1 Holiday Sun Sun Sat

SICK Jan-99 Starting Bal. 0.00 1 Holiday

Feb-99 0.00

Mar-99 0.00

Apr-99 0.00 Sun

May-99 0.00

Jun-99 0.00

Jul-99 0.00 Sun

Aug-99 0.00

Sep-99 0.00 Sat

If your employee uses a vacation day you enter -8 in the date that they took for example if they took off January 2nd you would VACATION Jan-1899 Feb-1899 Mar-1899 Apr-1899 May-1899 Jun-1899 Jul-1899 Aug-1899 Sep-1899 Starting Bal. 24.00 22.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1 Holiday Sun Sun Sat 2 -8.00 Sat Sun 3 Sat Sat Sun Holiday 4 Sun Sun Holiday Sat 5 Sat Sun 6 Sat Personal Sun

If you are using the personal day for vacation and you just want to keep track of it but not deduct any hours from the total you c The sick time is used the same way.

You can copy the worksheet tabs attached to this and use the correct one for each employee you have. If you have any quest Annette

e that was carried over from the previous year for both Vacation and for sick time

Oct-1899 Nov-1899 Dec-1899 0.00 0.00 0.00 Sat

Oct-99 0.00

Nov-99 0.00

Dec-99 0.00 Sat

off January 2nd you would put in -8 in the following cell and it will deduct 8 hours from their balance. Oct-1899 Nov-1899 Dec-1899 0.00 0.00 0.00 Sat Sun Sat Sun Sat

y hours from the total you can write in the cell personal

ave. If you have any questions please feel free to ask me.

Name Hire Date Override Annual Vacation

For Calendar Year Starting: Jan-2009

120

VACATION Starting Bal. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.

Jan-2009 0.00 Holiday

SICK Starting Bal. 1 2 3 4 5 6

Feb-2009 6.68 Sun

Mar-2009 13.36 Sun

Jul-2009 40.08

Holiday Sat Sun

Sat Sun Sat Sun

Sat Sun

Sat Sun Sat Sun

Sat Sun

Sat Sun Sat Sun 3.34 Holiday

Sat Sun 3.34

Sat Sun Holiday

Sat Sun Sat Sun

3.34

3.34 Sat Sun

3.34

Sat Sun Sat Sun

Sat Sun

Sat Sun

Sat 3.34 6.68

Sat na na na 3.34 13.36

3.34 20.04

Jan-09 0.00 Holiday

Feb-09 3.34 Sun

Mar-09 6.68 Sun

3.34

Sat Sun

Sat Sun

Sat Sun

Sat Sun

May-2009 Jun-2009 26.72 33.40 Sat Sun

Sat Sun

3.34

Apr-2009 20.04

Sat Sun Holiday

Sat Sun Sat Sun

Sat Sun na 3.34 26.72

Sat Sun 3.34 33.40

na 3.34 40.08

3.34 46.76

Apr-09 10.02

May-09 13.36

Jun-09 16.70

Jul-09 20.04

Sat Sun

Holiday Sat Sun

Sat Sun Sat

7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.

Sat Sun

Sat Sun Sat Sun

Sat Sun

1.67

Sat Sun Sat Sun 1.67 Holiday

Sat Sun 1.67

Sat Sun Holiday

Sat Sun Sat Sun

1.67

1.67 Sat Sun

1.67

Sat Sun Sat Sun

Sat Sun

Sat Sun Sat na na na 1.67 6.68

Sat Sun Holiday

Sat Sun Sat Sun

Sat Sun

1.67 10.02

1.67

Sat Sun

Sat Sun

Sat Sun

Sat 1.67 3.34

Sun

na 1.67 13.36

Sat Sun 1.67 16.70

na 1.67 20.04

1.67 23.38

Aug-2009 46.76 Sat Sun

Sep-2009 53.44

Oct-2009 60.12

Nov-2009 66.80 Sun

Dec-2009 73.48

Sat Sun Sat Sun

Sat Sun

Holiday Sat Sun

Sat Sun Sat Sun Sat Sun

Sat 3.34 Sun

3.34

Sat Sun

3.34

Sat Sun 3.34

3.34

Sat Sun Sat Sun

Sat Sun Sat Sun

Sat Sun Sat Sun Sat Sun

Holiday Holiday Sat Sun

Sat Sun 3.34 53.44 Aug-09 23.38 Sat Sun

na 3.34 60.12

Sat 3.34 66.80

na 3.34 73.48

Sep-09 26.72

Oct-09 30.06

Nov-09 33.40 Sun

Holiday Sat Sun

3.34 80.16 Dec-09 36.74

Sat Sun Sat Sun

Sat Sun

Holiday Sat Sun

Sat Sun Sat Sun Sat Sun

Sat 1.67 Sun

1.67

Sat Sun

1.67

Sat Sun 1.67

1.67

Sat Sun Sat Sun

Sat Sun Sat Sun

Sat Sun Sat Sun Sat Sun

Holiday Holiday Sat Sun

Sat Sun 1.67 26.72

na 1.67 30.06

Sat 1.67 33.40

na 1.67 36.74

Holiday Sat Sun

1.67 40.08

Name Hire Date Override Annual Vacation

For Calendar Year Starting: Jan-2009

120

VACATION Starting Bal. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.

Jan-2009 0.00 Holiday

SICK Starting Bal. 1 2 3 4 5 6

Feb-2009 10.00 Sun

Mar-2009 20.00 Sun

Jul-2009 60.00

Holiday Sat Sun

Sat Sun Sat Sun

Sat Sun

Sat Sun Sat Sun

Sat Sun

Sat Sun Sat Sun 5.00 Holiday

Sat Sun 5.00

Sat Sun Holiday

Sat Sun Sat Sun

5.00

5.00 Sat Sun

5.00

Sat Sun Sat Sun

Sat Sun

Sat Sun

Sat 5.00 10.00

Sat na na na 5.00 20.00

5.00 30.00

Jan-09 0.00 Holiday

Feb-09 3.34 Sun

Mar-09 6.68 Sun

5.00

Sat Sun

Sat Sun

Sat Sun

Sat Sun

May-2009 Jun-2009 40.00 50.00 Sat Sun

Sat Sun

5.00

Apr-2009 30.00

Sat Sun Holiday

Sat Sun Sat Sun

Sat Sun na 5.00 40.00

Sat Sun 5.00 50.00

na 5.00 60.00

5.00 70.00

Apr-09 10.02

May-09 13.36

Jun-09 16.70

Jul-09 20.04

Sat Sun

Holiday Sat Sun

Sat Sun Sat

7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.

Sat Sun

Sat Sun Sat Sun

Sat Sun

1.67

Sat Sun Sat Sun 1.67 Holiday

Sat Sun 1.67

Sat Sun Holiday

Sat Sun Sat Sun

1.67

1.67 Sat Sun

1.67

Sat Sun Sat Sun

Sat Sun

Sat Sun Sat na na na 1.67 6.68

Sat Sun Holiday

Sat Sun Sat Sun

Sat Sun

1.67 10.02

1.67

Sat Sun

Sat Sun

Sat Sun

Sat 1.67 3.34

Sun

na 1.67 13.36

Sat Sun 1.67 16.70

na 1.67 20.04

1.67 23.38

Aug-2009 70.00 Sat Sun

Sep-2009 80.00

Oct-2009 90.00

Nov-2009 100.00 Sun

Dec-2009 110.00

Sat Sun Sat Sun

Sat Sun

Holiday Sat Sun

Sat Sun Sat Sun Sat Sun

Sat 5.00 Sun

5.00

Sat Sun

5.00

Sat Sun 5.00

5.00

Sat Sun Sat Sun

Sat Sun Sat Sun

Sat Sun Sat Sun Sat Sun

Holiday Holiday Sat Sun

Sat Sun 5.00 80.00 Aug-09 23.38 Sat Sun

na 5.00 90.00

Sat 5.00 100.00

na 5.00 110.00

Sep-09 26.72

Oct-09 30.06

Nov-09 33.40 Sun

Holiday Sat Sun

5.00 120.00 Dec-09 36.74

Sat Sun Sat Sun

Sat Sun

Holiday Sat Sun

Sat Sun Sat Sun Sat Sun

Sat 1.67 Sun

1.67

Sat Sun

1.67

Sat Sun 1.67

1.67

Sat Sun Sat Sun

Sat Sun Sat Sun

Sat Sun Sat Sun Sat Sun

Holiday Holiday Sat Sun

Sat Sun 1.67 26.72

na 1.67 30.06

Sat 1.67 33.40

na 1.67 36.74

Holiday Sat Sun

1.67 40.08

Name Hire Date Override Annual Vacation

For Calendar Year Starting: Jan-2009

120

VACATION Starting Bal. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.

Jan-2009 0.00 Holiday

SICK Starting Bal. 1 2 3 4 5 6

Feb-2009 13.34 Sun

Mar-2009 26.68 Sun

Jul-2009 80.04

Holiday Sat Sun

Sat Sun Sat Sun

Sat Sun

Sat Sun Sat Sun

Sat Sun

Sat Sun Sat Sun 6.67 Holiday

Sat Sun 6.67

Sat Sun Holiday

Sat Sun Sat Sun

6.67

6.67 Sat Sun

6.67

Sat Sun Sat Sun

Sat Sun

Sat Sun

Sat 6.67 13.34

Sat na na na 6.67 26.68

6.67 40.02

Jan-09 0.00 Holiday

Feb-09 3.34 Sun

Mar-09 6.68 Sun

6.67

Sat Sun

Sat Sun

Sat Sun

Sat Sun

May-2009 Jun-2009 53.36 66.70 Sat Sun

Sat Sun

6.67

Apr-2009 40.02

Sat Sun Holiday

Sat Sun Sat Sun

Sat Sun na 6.67 53.36

Sat Sun 6.67 66.70

na 6.67 80.04

6.67 93.38

Apr-09 10.02

May-09 13.36

Jun-09 16.70

Jul-09 20.04

Sat Sun

Holiday Sat Sun

Sat Sun Sat

7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.

Sat Sun

Sat Sun Sat Sun

Sat Sun

1.67

Sat Sun Sat Sun 1.67 Holiday

Sat Sun 1.67

Sat Sun Holiday

Sat Sun Sat Sun

1.67

1.67 Sat Sun

1.67

Sat Sun Sat Sun

Sat Sun

Sat Sun Sat na na na 1.67 6.68

Sat Sun Holiday

Sat Sun Sat Sun

Sat Sun

1.67 10.02

1.67

Sat Sun

Sat Sun

Sat Sun

Sat 1.67 3.34

Sun

na 1.67 13.36

Sat Sun 1.67 16.70

na 1.67 20.04

1.67 23.38

Aug-2009 93.38 Sat Sun

Sep-2009 106.72

Oct-2009 120.06

Nov-2009 133.40 Sun

Dec-2009 146.74

Sat Sun Sat Sun

Sat Sun

Holiday Sat Sun

Sat Sun Sat Sun Sat Sun

Sat 6.67 Sun

6.67

Sat Sun

6.67

Sat Sun 6.67

6.67

Sat Sun Sat Sun

Sat Sun Sat Sun

Sat Sun Sat Sun Sat Sun

Holiday Holiday Sat Sun

Sat Sun 6.67 106.72 Aug-09 23.38 Sat Sun

na 6.67 120.06

Sat 6.67 133.40

na 6.67 146.74

Sep-09 26.72

Oct-09 30.06

Nov-09 33.40 Sun

Holiday Sat Sun

6.67 160.08 Dec-09 36.74

Sat Sun Sat Sun

Sat Sun

Holiday Sat Sun

Sat Sun Sat Sun Sat Sun

Sat 1.67 Sun

1.67

Sat Sun

1.67

Sat Sun 1.67

1.67

Sat Sun Sat Sun

Sat Sun Sat Sun

Sat Sun Sat Sun Sat Sun

Holiday Holiday Sat Sun

Sat Sun 1.67 26.72

na 1.67 30.06

Sat 1.67 33.40

na 1.67 36.74

Holiday Sat Sun

1.67 40.08

Related Documents

Spreedsheet
October 2019 0
Vacation
April 2020 18
Vacation
November 2019 27