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
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 3
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 3
Miranda P P P P P OD X 1 1 5 11 0
Lenis P P CL 0 2 2 3 1

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.