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_29Sep.xlsx (2027 only) on 29 Sep 2026 · last edited here 5 Nov 2026, 15:06 by Taki · the sheet runs from January 2026
← →
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 / special Saturday Sunday Working public holiday Everyone off — department closed
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 PH OD Late
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
Pauline AL 1 1 0 0
Chloe OD 2 1 0 0
Ting CL 16/10 PM CL for 24/10 OD OD CL 27/10 PM CL for 24/10 OD 2 0 0 1
Taki X OD CL CL CL AL AL 2 1 0 2
Bruce CL OD 2 1 0 0
Stephanie OD CL 1 0 0 0
Franky P OD CL 13/10 CL for 3Oct AL 8 0 1 28
Winky P OD 7 0 1 28
SzeMing P P 20/10 Pre-dept meeting 0930, no late shift OD 6 0 2 26
Gavin AL OD CL CL 13/10 CL PM for 19/9 AL AL AL AL AL AL AL AL AL 11 0 0 30
Miranda P CL AL 15/10 15/10 = CL for 25/7 P P P P P 5 0 6 40
Lenis P P CL OD P 6 0 3 28

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.