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
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 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 1
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 2
SzeMing CL OD 1 3 0 14 1
Gavin CL OD P P X 1 6 2 18 1
Miranda P P P P P P P OD 1 4 7 19 0
Lenis P P AL X 0 2 2 13 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.