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 — am or pm, counts 0.5
Days Saturday Sunday Working holiday Everyone off — department closed Important — please do not move
Nobody is on duty on Sat 4 Apr. Every Saturday and working holiday needs one senior marked OD.
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 3
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 3
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

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.