ࡱ> ^] ZO\pLina Johansson Ba==K8X@"1Arial1Arial1Arial1Arial1Arial1Arial1"  Rdg Vesta1" Rdg Vesta1" Rdg Vesta1"  Rdg Vesta1 Arial1$Arial1"  Rdg Vesta1" Rdg Vesta1" Rdg Vesta1"  Rdg Vesta1" Rdg Vesta1Arial1"  Rdg Vesta1"  Rdg Vesta1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) 0.0000 dd/mm/yyyy;@ 0.000 0.0000000 0.000000 0.00000 hh:mm;@% [$-F800]dddd\,\ mmmm\ dd\,\ yyyy[$-809]dd\ mmmm\ yyyy mmm\-yyyy 0.00000000 0.000000000 0.00000000000.0                                                                      ff + ) , *      P  P        ! ` "      #   $ % a> &       x | x   X  |    X 8@ @ x@ @ <@ @  *8@ @ 8@@ 8@ |@ 8 @   8 | x 8   | X | < @ @  @ @  @ @  @ @  "<@ @  <@ @      (@ @  *@ @  *@ @ @ @   @ @  (@ @ "8@ @ "<@ @    x@@  8@ 8 @ x 0 0 x@ @ 0@ @ @@  @  @ x@@ 0@ 0 @ x@ 8@ ||+}A}  yyyy_)ef[$ -}A}  yyyy_)ef[$ -}A}  yyyy_)ef[$ -}A}  yyyy_)ef[$ -}A}  yyyy_)ef[$ -}A}  yyyy_)ef [$ -}A}  yyyy_)L[$ -}A}  yyyy_)L[$ -}A}  yyyy_)L[$ -}A}  yyyy_)L[$ -}A}  yyyy_)L[$ -}A}  yyyy_)L [$ -}A}  yyyy_)23[$ -}A}  yyyy_)23[$ -}A}  yyyy_)23[$ -}A}  yyyy_)23[$ -}A}   yyyy_)23[$ -}A}!  yyyy_)23 [$ -}A}"  yyyy_)[$ -}A}#  yyyy_)[$ -}A}$  yyyy_)[$ -}A}%  yyyy_)[$ -}A}&  yyyy_)[$ -}A}'  yyyy_) [$ -}A}(  yyyy_)[$ -}}) } yyyy_)[$ -##0.  }}*  yyyy_)[$ -???##0.??? ??? ???}-}/  yyyy_)}A}1 a yyyy_)[$ -}A}2  yyyy_)[$ -}A}3  yyyy_)?[$ -}A}4  yyyy_)23[$ -}-}5  yyyy_)}}7 ??v yyyy_)̙[$ -##0.  }A}8 } yyyy_)[$ -}A}9 e yyyy_)[$ -}x}: yyyy_)[$##  }}; ??? yyyy_)[$???## ???  ??? ???}-}=  yyyy_)}U}>  yyyy_)[$## }-}?  yyyy_) 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`s>Leave Calculation,5 H/MondayTuesday WednesdayThursdayFridayto This sheet is used for: Proportion of Leave Year Worked:vYellow boxes require input - other values are calculated automatically - an example has been entered for guidance only Leave Year:Days Worked per Week:DateType Closure DayPublic HolidayDFull year grossed up leave entitlement for this leave year (in days) Day of Weekmvalues in column E should NOT be the same for all days worked - otherwise you are using the wrong spreadsheetEFull year grossed up leave entitlement for this leave year (in hours)Hours to be takenOPublic holidays and closure days (in hours) to be taken from leave entitlement:%* NOT working the same hours each dayBActual grossed up leave entitlement for this leave year (in hours)BAlthough your terms and conditions of service do not specifiy a number of hours per week, in order to calculate your leave entitlement, we use a nominal 35 hour week and we ask you to assign your part time hours to the days you normally work. If you do not have a "normal" work pattern then please contact HR for guidance. (Nominal) Hours Worked per Week:%TOTAL (nominal) hours worked per weekNominal hours per dayAnnual Leave Calculation SheetQWorking pattern (assign your nominal hours appropriately to each day of the week)GLast Date of Employment (if leaving employment during this leave year):W(see below for list of public holidays and closure days to identify which are included))(both pro-rated for days worked per week)0Staff in P&M and A&R roles (grades 6 and above)(i.e. Directed leave)Name:IStart Date of Employment (if starting employment during this leave year):?Actual annual leave entitlement for this leave year (in hours):(i.e. Discretionary leave)Due to work (1 = yes)Proportion of week worked6This must be agreed in advance with your line manager. Closure Day*Tcan either take the Closure Day on this date or take leave on an alternative date. kGrossed Up Leave Entitlement includes annual leave (26), public holiday (8) and closure day (8) entitlement2026/27EPublic Holidays & Closure Days - Leave year 1 Oct 2026 - 30 Sept 2027g* As Greenlands campus remains open on 30-31 March, staff at Greenlands (who usually work on this day) 24 O5b6@9s:<MccB ZO F.  do@_*+%;&F&?'?(?)?M \\uorprint.rdg.ac.uk\FollowMe- ? 4dXXA4?SPLX?MODEL_4PCLXL 4 ++++4 L -e4 4 L -dInTray1InTray2InTray3InTray4InTrayLCTInTrayManuald}HddXXP---_ArialCourier NewTimes New RomanSymbolWingdings ArialCourierTimes New RomanSymbolWingdings#ivK<4 splwow64.exe9a(" @XX333333?333333?&43U} t#B} B} B} B} B} B} . BF;@;A;A;@;@@ @ ;@ ;@;@;@;@;@;@;@@;@;@;@;@;@;@;@;@;@;@ X ], H H HHHHHHHHW H WWWWHWWW uvvvvM w xxxyM B" ^^ B ~ _@ G~ _@EFGF B ~ c@ NH IHH B~ c5@ YYZGYYZD z {{| P@ } ~~~~ d@   ~ d  ~ d@  ~ d@  ~ d  #Q5@ %mNWDD *?5total does not match hours worked per week from aboveB* S' TUVQ333333?  D#NYYaYbN B#e B~ OD@8o,(""$8*, 6:6666K ;@!;@";@$;@&;@';@(;@);@*;@+;@-;@/;@0@1;@2;@3;@4;@5;@6;@7;@8;@9;@:;@;;@<;@=;@>;@?;@ B Qq@& D !J!\ "[+"D $B$f &B$&K@&$$ B$&K@&$ $$B*&Q?(D&D&m 'KKL (B (CCC8(Qe@*"D DD&?@A )J *B*QO@-Z@ *B! +J -H$ -HHH--q@Z@1D(D*?A  -B% /i- /jkk 0l 0m 0n 0n& 0R 1r ~ 1t@ 1s1o?1nDD1 D1D$ B$ED$A&DD1  " "Bo1g@2YD1Z&@ @D1Z&@  D1;@@Bf"B 2r~ 2t@ 2s2o?22x2> nDL LD$ B$ED$A&DL  " "Bo2g3YD2Z&@ @D2Z&@  D2;@@Bf"B 3r~ 3t@ 3s3o?32o3g@4YD3Z&@ @D3Z&@  D3;@@Bf"B 4r ~ 4t @ 4s4o?42o4g5YD4Z&@ @D4Z&@  D4;@@Bf"B 5r ~ 5t@@ 5s5o?52o5g@6YD5Z&@ @D5Z&@  D5;@@Bf"B 6r ~ 6t`@ 6B6o?62o6g@7YD6Z&@ @D6Z&@  D6;@@Bf"B 7r~ 7t@ 7s7o?72o7g8YD7Z&@ @D7Z&@  D7;@@Bf"B 8r~ 8t@ 8D8o?82o8g9YD8Z&@ @D8Z&@  D8;@@Bf"B 9r~ 9t`@ 9s9o?92o9g@:YD9Z&@ @D9Z&@  D9;@@Bf"B :r)~ :t@ :s:o?:2o:g;YD:Z&@ @D:Z&@  D:;@@Bf"B ;r)~ ;t@ ;s;o?;2o;g@<YD;Z&@ @D;Z&@  D;;@@Bf"B <r~ <t@ <s<o?<2o<g@=YD<Z&@ @D<Z&@  D<;@@Bf"B =r~ =t@@ =s=o?=2o=g@>YD=Z&@ @D=Z&@  D=;@@Bf"B >r~ >t@ >s>o?>2o>g@?YD>Z&@ @D>Z&@  D>;@@Bf"B?kkkko?g@YD?Z&@ @D?Z&@  D?;@@Bf"B<g1Z =]F%8@:@A;@B;@C;@D;@E;@ @ppp#@hO@ %1? Ap.Appp` Bp*Bppp` Cp(C````D`````E`-d7 >@`b. Z   7gg@ Oh+'0HPd|  vrs97eagLina JohanssonMicrosoft Excel@BQE@u@]HU ՜.+,0 PXx  University Of Vlog Leave Calculation  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLNOPQRSTVWXYZ[\Root Entry FWorkbookySummaryInformation(MDocumentSummaryInformation8U