Leave Calculatorv 2.xls
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 Leave Calculatorv 2.xls as PDF for free.
More details
- Words: 496
- Pages: 2
PEOPLE AND ORGANISATIONAL DEVELOPMENT Annual leave calculator - to calculate leave to 31 December 2010 Enter the information in the white fields below to obtain future dated annual leave entitlement and leave planning requirements. NB. This calculator assumes a maximum of 10 days being worked per fortnight
1 Hours worked per fortnight
75
2 Annual leave provision in days (20 or 25 days)
20
3 The last accrued to date, as recorded in YourSelf (absence history screen) 4 Available balance as shown in YourSelf (in hours)
2/7/2010 0
NB For managers and leave managers, the available balance is not displayed and the second worksheet labelled "For Managers" should be used, which calculates this balance
5 Your target balance in days, (max to be half year's balance as at 31/12/2010)
75 hours
A default target balance of a half year entitlement will appear, this can be overridden and reduced as required
The following fields will automatically generate the amount of further leave that you need to plan for, in order to achieve your target amount entered in 5 Annual accrual
150
Annual hours worked
1950
Fortnightly accrual
5.769
No of pay periods between current accrual and 31/12/2010 Total accrual to end of year Plus current accrual Total of current and accrual to year end Amount of further leave to be planned and taken (not including current leave already entered) to reach your target amount
23 133 0 133 57.69 hours
PEOPLE AND ORGANISATIONAL DEVELOPMENT Annual leave calculator - to calculate leave to 31 December 2010 Enter the information in the white fields below to obtain a staff member's future dated annual leave entitlement and leave planning requirements, using the absence history screen. NB. This calculator assumes a maximum of 10 days being worked per fortnight
Staff Name ………………………………………………………………. If the staff name is completed, the information on this form becomes confidential 1 Hours worked per fortnight
75
2 Annual leave provision in days (20 or 25 days)
20
3 The last "accrued to date", as recorded in YourSelf
2/7/2010
4 Balance in hours as shown in YourSelf (top right of screen)
0
5 Total of annual leave with status of "booked" or "authorised"
0
6 Target year end balance in hours, (max to be half year's balance as at 31/12/2010)
75 hours
A default target balance of a half year entitlement will appear, this can be overridden and reduced as required
The following fields will automatically generate the amount of further leave that plans are needed for, in order to achieve the target amount entered in 6 Available balance (leave balance with booked and authorised leave removed) Annual accrual
0 150
Annual hours worked
1950
Fortnightly accrual
5.769
No of pay periods between current accrual and 31/12/2010
23
Total accrual to end of year
133
Total of current and accrual to year end
133
Amount of further leave to be planned and taken (not including current leave already entered) to reach target year end amount
57.69 hours
1 Hours worked per fortnight
75
2 Annual leave provision in days (20 or 25 days)
20
3 The last accrued to date, as recorded in YourSelf (absence history screen) 4 Available balance as shown in YourSelf (in hours)
2/7/2010 0
NB For managers and leave managers, the available balance is not displayed and the second worksheet labelled "For Managers" should be used, which calculates this balance
5 Your target balance in days, (max to be half year's balance as at 31/12/2010)
75 hours
A default target balance of a half year entitlement will appear, this can be overridden and reduced as required
The following fields will automatically generate the amount of further leave that you need to plan for, in order to achieve your target amount entered in 5 Annual accrual
150
Annual hours worked
1950
Fortnightly accrual
5.769
No of pay periods between current accrual and 31/12/2010 Total accrual to end of year Plus current accrual Total of current and accrual to year end Amount of further leave to be planned and taken (not including current leave already entered) to reach your target amount
23 133 0 133 57.69 hours
PEOPLE AND ORGANISATIONAL DEVELOPMENT Annual leave calculator - to calculate leave to 31 December 2010 Enter the information in the white fields below to obtain a staff member's future dated annual leave entitlement and leave planning requirements, using the absence history screen. NB. This calculator assumes a maximum of 10 days being worked per fortnight
Staff Name ………………………………………………………………. If the staff name is completed, the information on this form becomes confidential 1 Hours worked per fortnight
75
2 Annual leave provision in days (20 or 25 days)
20
3 The last "accrued to date", as recorded in YourSelf
2/7/2010
4 Balance in hours as shown in YourSelf (top right of screen)
0
5 Total of annual leave with status of "booked" or "authorised"
0
6 Target year end balance in hours, (max to be half year's balance as at 31/12/2010)
75 hours
A default target balance of a half year entitlement will appear, this can be overridden and reduced as required
The following fields will automatically generate the amount of further leave that plans are needed for, in order to achieve the target amount entered in 6 Available balance (leave balance with booked and authorised leave removed) Annual accrual
0 150
Annual hours worked
1950
Fortnightly accrual
5.769
No of pay periods between current accrual and 31/12/2010
23
Total accrual to end of year
133
Total of current and accrual to year end
133
Amount of further leave to be planned and taken (not including current leave already entered) to reach target year end amount
57.69 hours
Related Documents
Leave Calculatorv 2.xls
December 2019 31
Leave
May 2020 38
Leave Forms
August 2019 90
Annual Leave
November 2019 21
Leave Record
November 2019 23
Leave Form
October 2019 26More Documents from "Nitin Malviya"
Leave Calculatorv 2.xls
December 2019 31
2018 Wage Survey Final Report(e).pdf
December 2019 16
Permutations.docx
December 2019 15
