Seniors’ Leave Sheet

Annual leave, compensation leave, trips, late shifts and Saturday/PH duty for the department’s seniors · this sheet only — it changes nothing on any other page
Imported from Duty Roster_Seniors.xlsx on 7 Sep 2026 · last edited here 18 Sep 2026, 13:57 by Gavin · the sheet runs from January 2026
Sign in
Month Year
← →
Marks AL Annual Leave CL Compensation Leave Trip Business Trip P Late Shift OD Sat/PH On Duty X Not in Office ALam Half day — yellow, am or pm, counts 0.5
Days Saturday Sunday Working holiday Everyone off — department closed
Nobody is on duty on Sat 4 Apr. Every Saturday and working holiday needs one senior marked OD.

Year to date · 2026

Every mark on the sheet for 2026, counted per senior. The Sat OD, Late and CL columns of the grids below build up to these. Leave is in days, so a half-day morning or afternoon counts 0.5.
Senior Sat OD Late AL CL TripX On sheet
Gavin 12 43 26.5 11 0 1 12
Ting 12 1 23 11 0 5 12
Franky 10 29 21 7 0 0 12
Pauline 9 0 17 9 0 5 12
Chloe 9 0 20.5 9 0 3 12
Winky 8 27 22 8 0 8 12
Lenis 8 27 17 4.5 0 1 12
SzeMing 7 33 24 4 0 0 12
Bruce 7 0 13 12.5 0 0 12
Taki 6 1 23 5.5 0 1 12
Miranda 5 41 16 5 0 5 12
Stephanie 3 0 16 2 0 1 6

January 2026

open month →
Senior T F S S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T F S Remark for wk 5 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline CL OD AL AL AL AL 1 1 0 0 1
Chloe CL OD 1 1 0 0 1
Ting OD CL 1 1 0 0 1
Taki OD CL 1 1 0 0 1
Bruce CL CL CL OD 1 1 0 0 2.5
Franky P P AL 0 0 2 2 0
Winky P P P P 0 0 4 4 0
SzeMing AL CL CL OD AL P P P P AL 1 1 4 4 1
Gavin P P P P OD AL OD 2 2 4 4 0
Miranda P P X AL AL AL AL P P P X P 0 0 6 6 0
Lenis OD AL AL AL AL P CL OD 2 2 1 1 1

February 2026

open month →
Senior S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T F S Remark for wk 5 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline CL OD 1 2 0 0 1
Chloe CL OD OD CL AL AL 2 3 0 0 2
Ting P AL X AL AL OD 1 2 1 1 0
Taki CL OD OD CL 2 3 0 0 2
Bruce CL CL AL AL CL 0 1 0 0 2.5
Franky P CL OD P AL 1 1 2 4 1
Winky P P OD 1 1 2 6 0
SzeMing P AL AL 0 1 1 5 0
Gavin CL OD CL CL P P P P 1 3 4 8 2.5
Miranda P P P P P OD X 1 1 5 11 0
Lenis P P CL 0 2 2 3 0.5

March 2026

open month →
Senior S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T F S S Remark for wk 5 M T Remark for wk 6 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline OD CL 1 3 0 0 1
Chloe X X X OD CL AL 1 4 0 0 1
Ting CL CL AL AL OD CL AL AL AL 1 3 0 1 2.5
Taki AL 0 3 0 0 0
Bruce CL CL OD 1 2 0 0 1.5
Franky P P P P P CL OD P P 1 2 7 11 1
Winky X X X 0 1 0 6 0
SzeMing AL P P P P P AL AL 0 1 5 10 0
Gavin OD P P P P P CL AL AL 1 4 5 13 1
Miranda OD X OD P 2 3 1 12 0
Lenis AL AL AL AL AL AL P P P P 0 2 4 7 0

April 2026

open month →
Senior W T F S S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T Remark for wk 5 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline OD 1 4 0 0 0
Chloe AL AL OD CL OD 2 6 0 0 1
Ting CL CL AL AL AL CL OD X X 1 4 0 1 2.5
Taki AL AL AL 0 3 0 0 0
Bruce OD CL CL AL 1 3 0 0 2
Franky P P AL AL AL P P CL 0 2 4 15 1
Winky CL CL CL AL P P P OD 1 2 3 9 2.5
SzeMing AL OD CL P P P P 1 2 4 14 1
Gavin AL AL AL AL AL CL P P P OD 1 5 3 16 1
Miranda X 0 3 0 12 0
Lenis P P P AL P AL 0 2 4 11 0

May 2026

open month →
Senior F S S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T F S S Remark for wk 5 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline OD 1 5 0 0 0
Chloe CL 0 6 0 0 1
Ting OD OD 2 6 0 1 0
Taki CL 0 3 0 0 0.5
Bruce OD CL OD 2 5 0 0 1
Franky OD P P 1 3 2 17 0
Winky P CL P OD CL P P 1 3 4 13 1.5
SzeMing CL OD 1 3 0 14 1
Gavin CL OD P P X 1 6 2 18 0.5
Miranda P P P P P P P OD 1 4 7 19 0
Lenis P P AL X 0 2 2 13 0

June 2026

open month →
Senior M T W T F S S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T Remark for wk 5 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline OD 1 6 0 0 0
Chloe CL OD 1 7 0 0 1
Ting CL OD AL CL CL CL 1 7 0 1 3
Taki AL AL AL AL AL AL AL CL AL AL OD CL 1 4 0 0 1
Bruce CL 0 5 0 0 1
Franky AL AL AL AL AL P CL P P OD 1 4 3 20 1
Winky X X X X X AL AL AL AL AL AL AL AL AL P 0 3 1 14 0
SzeMing OD P P P P P 1 4 5 19 0
Gavin OD P P P CL 1 7 3 21 0.5
Miranda P CL CL 0 4 1 20 2
Lenis P P P P OD P AL AL 1 3 5 18 0

July 2026

open month →
Senior W T F S S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T F Remark for wk 5 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline X CL CL AL AL AL X CL CL OD 1 7 0 0 4
Chloe 0 7 0 0 0
Ting OD OD AL 2 9 0 1 0
Taki CL P AL 0 4 1 1 0.5
Bruce CL 0 5 0 0 1
Stephanie CL OD 1 1 0 0 1
Franky P CL OD CL AL AL AL AL AL AL AL AL 1 5 1 21 1.5
Winky P P P OD P P P P 1 4 7 21 0
SzeMing AL AL AL AL AL AL AL AL AL AL 0 4 0 19 0
Gavin P OD P CL P P 1 8 4 25 1
Miranda CL CL AL AL AL AL AL P P P P P P P OD 1 5 7 27 2
Lenis P 0 3 1 19 0

August 2026

open month →
Senior S S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T F S S Remark for wk 5 M Remark for wk 6 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline OD CL X AL 1 8 0 0 1
Chloe AL AL AL AL AL CL OD 1 8 0 0 1
Ting X CL AL AL AL AL 0 9 0 1 1
Taki CL OD AL X AL 1 5 0 1 0.5
Bruce OD AL AL AL AL AL AL AL AL AL 1 6 0 0 0
Stephanie AL CL OD 1 2 0 0 1
Franky AL AL AL P P CL P OD OD P CL 2 7 4 25 1.5
Winky OD P CL CL CL AL AL AL AL AL AL AL AL AL AL CL 1 5 1 22 4
SzeMing AL AL AL P AL AL 0 4 1 20 0
Gavin AL AL AL AL AL AL AL AL CL P P P P P OD 1 9 5 30 1
Miranda P 0 5 1 28 0
Lenis P P P CL OD AL P CL OD 2 5 4 23 2

September 2026

open month →
Senior T W T F S S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W Remark for wk 5 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline AL AL AL AL X AL AL AL AL AL X CL OD 1 9 0 0 1
Chloe AL AL AL AL AL AL CL 0 8 0 0 1
Ting OD 1 10 0 1 0
Taki AL AL AL AL AL 0 5 0 1 0
Bruce AL OD CL 1 7 0 0 1
Stephanie AL AL AL AL AL 0 2 0 0 0
Franky P P P 0 7 3 28 0
Winky OD P P P P P AL 1 6 5 27 0
SzeMing P CL OD P P P 1 5 4 24 1
Gavin AL AL AL CL CL OD 1 10 0 30 1
Miranda P P P P P P 0 5 6 34 0
Lenis AL P P 0 5 2 25 0

October 2026

open month →
Senior T F S S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T F S Remark for wk 5 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline 0 9 0 0 0
Chloe OD 1 9 0 0 0
Ting CL 16/10 CL for 24/10 OD 1 11 0 1 1
Taki OD AL AL 1 6 0 1 0
Bruce 0 7 0 0 0
Stephanie OD 1 3 0 0 0
Franky P OD 1 8 1 29 0
Winky AL OD 1 7 0 27 0
SzeMing P P P P OD 1 6 4 28 0
Gavin P P P P OD CL CL AL AL AL AL AL AL AL AL AL 1 11 4 34 1.5
Miranda P CL AL 15/10 15/10 = CL for 25/7 P P P P P 0 5 6 40 1
Lenis OD 1 6 0 25 0

November 2026

open month →
Senior S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T F S S Remark for wk 5 M Remark for wk 6 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline 0 9 0 0 0
Chloe 0 9 0 0 0
Ting AL AL AL X AL 0 11 0 1 0
Taki AL AL 0 6 0 1 0
Bruce 0 7 0 0 0
Stephanie AL AL AL AL AL X 0 3 0 0 0
Franky OD 1 9 0 29 0
Winky 0 7 0 27 0
SzeMing OD 1 7 0 28 0
Gavin CL P P P P OD 1 12 4 38 1
Miranda P 0 5 1 41 0
Lenis P CL OD 1 7 1 26 1

December 2026

open month →
Senior T W T F S S Remark for wk 1 M T W T F S S Remark for wk 2 M T W T F S S Remark for wk 3 M T W T F S S Remark for wk 4 M T W T Remark for wk 5 Sat OD Late CL
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 Mth Yr Mth Yr Mth
Pauline 0 9 0 0 0
Chloe AL AL AL AL AL 0 9 0 0 0
Ting AL AL OD 1 12 0 1 0
Taki 0 6 0 1 0
Bruce 0 7 0 0 0
Stephanie AL AL AL AL AL 0 3 0 0 0
Franky OD 1 10 0 29 0
Winky OD 1 8 0 27 0
SzeMing P P P P P 0 7 5 33 0
Gavin P P P P P 0 12 5 43 0
Miranda AL AL AL AL AL AL 0 5 0 41 0
Lenis P OD 1 8 1 27 0

Remarks — how to read and write them

1 To read the remarks

  1. Tick Remarks at the top right of the month bar.
  2. A Remark for wk N column opens after every Sunday. Each note is stamped with its day — 16/9 covering for Bruce — and the whole week's notes read in one line.
  3. A day that carries a note also wears a small blue corner at its bottom left, whether the column is open or not. Hover the cell and the note is in its tooltip.

2 To add or change a remark (seniors, admin and dev)

  1. Press Lock to edit beside Save. Nobody else can edit the sheet while you hold it.
  2. Click the cell of the day — or drag across several days for one note on all of them. A palette appears beside it.
  3. Press the pen on the palette (or key R). Type the note and press Set remark; Clear takes one off. A note can stand on a day with no mark at all.
  4. Press Save, then Unlock when you have finished.