{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Guidance Notes","Annual Leave Calculation","Bank Holiday Calculation","Calculations-do not use"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guidance Notes","index":0,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[12,0,12,13],[19,0,19,13],[7,0,7,13],[5,0,5,13],[4,0,4,13],[8,0,8,13],[6,0,6,13],[13,0,13,9],[10,0,10,13],[11,0,11,13],[15,0,15,13],[16,0,16,13],[18,0,18,13],[17,0,17,13],[0,0,0,13],[1,0,1,13],[3,0,3,13],[2,0,2,14],[9,0,9,13],[32,0,32,13],[20,0,20,13],[29,4,29,13],[26,0,26,13],[28,1,28,13],[27,0,27,13],[24,0,24,13],[21,1,21,2],[23,0,23,13],[25,4,25,13],[21,4,21,13],[22,1,22,13]]}
["Guidelines for Annual Leave Calculation"]
[]
["This annual leave calculator only applies to the whole leave year 2021/2022"]
[]
["To find out your annual leave entitlement for the year, click onto the worksheet tab marked 'Annual Leave Calculation' at the bottom left hand corner and follow the instructions."]
[]
["Employees who complete 5 years LG Service in the leave year 21/22 are entitled to a proportion of the 5 days.  Please indicate what month you will complete 5 years on the 'annual leave calculation' worksheet. "]
[]
["If you make a mistake press the clear button at the top of the 'Annual Leave Calculation' worksheet."]
[]
["PART TIME EMPLOYEES"]
["After you have found out what your annual leave entitlement is, you need to enter your hours of work at the bottom of the 'Annual Leave Calculation' worksheet (please scroll down the page).  This will work out your annual leave in hours."]
["To calculate your entitlement to Bank Holidays (part time employees only), click onto the worksheet tab marked 'Bank Holiday Calculation'"]
["EMPLOYEES WORKING COMPRESSED HOURS (employees working full time over four days or less)"]
[]
["You need to use the calculator as if you are part-time.  It will work out your bank holiday entitlement, as you may be entitled to add some to your basic annual leave."]
[]
["IMPORTANT"]
[]
["When entering your hours of work, parts of an hour must be expressed in decimals"]
[]
["For Example:","7 hours 12 mins",null," = 7.2 hrs"," "]
[]
["Formula for converting minutes into decimals:-"]
[]
[null,"minutes ","÷","60  =","decimal (e.g. 30 mins divided by 60 = 0.5)"]
[]
["Formula for converting decimals into minutes:-"]
[]
[null,"decimal","x","60 =","minutes (e.g. 0.5 times 60 = 30 mins)"]
[]
[]
["IMPORTANT"]
[]
["Every member of staff must take a minimum of 28 days (pro-rata) leave (including bank holidays) in the year as this is the statutory leave entitlement.  You can only "]
["carry over leave once you have taken this minimum amount of time off, up to the maximum of 10 days (pro-rata)."]
[]
["This calculator does NOT work out your annual leave if you start part way through the year, or if you change your hours "]
["part way through the year."]

{"sheet":"Annual Leave Calculation","index":1,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,1,1,8],[2,1,2,8],[12,1,12,8],[38,9,38,13],[27,12,27,16],[3,1,3,8],[4,1,4,8],[5,1,5,8],[6,1,6,8],[16,1,16,8],[11,1,11,8],[14,12,14,16],[23,12,23,16],[13,1,13,8],[14,1,14,8],[31,1,31,9],[17,1,17,8],[18,1,18,8],[19,1,19,8],[21,1,21,8],[24,1,24,9],[27,1,27,9],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[15,1,15,8]]}
[null,"LEAVE CALCULATOR",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Follow this instruction",null,null,null,null,null,null,null,"Select which button applies to you","Annual Leave Days"]
[null,"Standard Leave (Employees with less than 5 years Local Govt Service):",null,null,null,null,null,null,null,"25 days",23]
[1,"Continuous Service (5 years or more in local govt.) as at 1 April 2023 of Leave Year?",null,null,null,null,null,null,null," ",{"$f":"IF(J4,5,0)","v":{"$error":"#VALUE!"}}]
[null,"5 Years continuous service in April 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J5,4,0)","v":0}]
[null,"5 Years continuous service in May 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J6,4,0)","v":0}]
[null,"5 Years continuous service in June 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J7,3,0)","v":0}]
[null,"5 Years continuous service in July 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J8,3,0)","v":0}]
[null,"5 Years continuous service in August 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J9,2,0)","v":0}]
[null,"5 Years continuous service in September 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J10,2,0)","v":0}]
[null,"5 Years continuous service in October 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J11,2,0)","v":0}]
[null,"5 Years continuous service in November 2023?",null,null,null,null,null,null,null,null,{"$f":"IF(J12,1,0)","v":0}]
[null,"5 Years continuous service in December 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J13,1,0)","v":0}]
[null,"5 Years continuous service between Jan '24 and Mar '24 - No additional days in this leave year",null,null,null,null,null,null,null,null,0]
[2,"10 to 14 years at Harrow Council as at 1 April 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J15,1,0)","v":0},null," "]
[null,"15 to 19 years at Harrow Council as at 1 April 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J16,2,0)","v":0}]
[null,"20 to 24 years at Harrow Council as at 1 April 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J17,3,0)","v":0}]
[null,"25 to 29 years at Harrow Council as at 1 April 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J18,4,0)","v":0}]
[null,"30 to 34 years at Harrow Council as at 1 April 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J19,5,0)","v":0}]
[null,"35 + years at Harrow Council as at 1 April 2023 ?",null,null,null,null,null,null,null,null,{"$f":"IF(J20,6,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total annual leave days",null,null,null,null,null,null,null,{"$f":"25+K22+L22","v":25},{"$f":"IF(L21=1,\"5\",IF(L21=2,\"4\",IF(L21=3,\"2\",IF(L21=4,\"6\",IF(L21=5,\"7\",IF(L21=6,\"8\",IF(L21=7,\"9\",IF(L21=8,\"10\"))))))))","v":false},{"$f":"IF(L21=9,\"11\",IF(L21=10,\"3\",IF(L21=11,\"1\")))","v":false}," "]
[]
[null," ",null,null,null,null,null,null,null,null,null,null," "]
[null,"If you currently have a leased car or an interest free car loan, please deduct one days leave from your 'Total annual leave days'"]
[]
[]
[null,"PART TIME EMPLOYEES - ENSURE THAT YOU HAVE ENTERED YOUR SERVICE IN THE ABOVE TABLE",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"If you work the same number of hours Monday to Friday your annual leave entitlement can remain in days."]
[]
[null,"Otherwise, please follow the instructions below to convert your annual leave days into hours :-"]
[]
[]
[null,{"$f":"J22","v":25},"x",7.2," =",{"$f":"B35*D35","v":180}]
[]
[]
[null,"Type in your hours of work per week and press enter",null,null,null," "]
[null,21,"¸",36,"x",{"$f":"F35","v":180}," =",{"$f":"B39/D39*F39","v":105},null,"Total Annual Leave Entitlement in Hours        (now go to bank holiday calculation worksheet)"]
[null,null,null,null,null,null,null," "]

{"sheet":"Bank Holiday Calculation","index":2,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[39,2,39,7],[38,1,39,1],[34,0,34,1],[34,2,34,3],[28,0,28,1],[33,2,33,3],[29,0,29,1],[31,2,31,3],[32,2,32,3],[34,5,34,10],[28,2,28,3],[22,2,22,3],[30,0,30,1],[16,2,16,3],[17,2,17,3],[19,2,19,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[21,2,21,3],[18,2,18,3],[20,2,20,3],[24,2,24,3],[0,0,0,7],[11,0,11,6],[15,0,15,1],[13,2,13,3],[15,2,15,3],[13,0,13,1],[14,2,14,3]]}
["BANK HOLIDAY CALCULATOR (FOR PART TIME EMPLOYEES ONLY WHO WORK DIFFERENT HOURS EACH DAY OR WORK LESS THAN 5 DAYS A WEEK)"]
[]
["Hours of work per week"]
[0," "," "," "," "," "]
[]
[]
[]
[]
["You are entitled to",{"$f":" A4/36*72","v":0},"  hours bank holidays"]
[]
[]
["You need to plot your bank holiday pattern to find out if you have any hours to add to your annual leave"]
[]
[" ",null,"Type in below what hours you normally work on each date indicated, then press enter (please use decimals e.g. 7hrs 12 mins = 7.2 (see note on Guidance Notes)"]
["Friday 7 April",null,0]
["Monday 10 April",null,7]
["Monday 1 May",null,7]
["Monday 8 May",null,7]
["Monday 29 May",null,7]
["Monday 28 August",null,7]
["Monday 25 December",null,7]
["Tuesday 26 December",null,7]
["Monday 1 January",null,7]
["Friday 29 March 2024",null,0]
[]
[]
[]
[]
[]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL",null,{"$f":"SUM(C15:D33)","v":56},null,null,"Total hours calculated based on when bank holidays fall during 22/23"]
[]
[]
[{"$f":" B9-C35","v":-56},null,"Positive figures are automatically added to your leave total  below"]
[null,null,"Negative minus figures have no effect on your annual leave entitlement"]
[null,null," "]
[]
[{"$f":"'Annual Leave Calculation'!H39+A44","v":105}," ","Your total Annual Leave Entitlement"]
[]
[{"$f":"IF(A38>0,+A38,0)","v":0}]

{"sheet":"Calculations-do not use","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Part Time Leave"]
[]
["Bank Holiday Entitlement",{"$f":" 'Bank Holiday Calculation'!A4","v":0}]