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

Year to date · 2027

Every mark on the sheet for 2027, 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 1 4 0 1 0 0 1
Miranda 1 3 7 0 0 0 1
Franky 1 0 0 0 0 0 1
Winky 1 0 0 0 0 0 1
SzeMing 1 0 0 0 0 0 1
Pauline 0 0 0 0 0 0 1
Chloe 0 0 0 0 0 0 1
Ting 0 0 0 0 0 0 1
Taki 0 0 0 0 0 0 1
Bruce 0 0 0 0 0 0 1
Stephanie 0 0 0 0 0 0 1
Lenis 0 0 0 0 0 0 1

January 2027

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 0 0 0 0 0
Chloe 0 0 0 0 0
Ting 0 0 0 0 0
Taki 0 0 0 0 0
Bruce 0 0 0 0 0
Stephanie 0 0 0 0 0
Franky OD 1 1 0 0 0
Winky OD 1 1 0 0 0
SzeMing OD 1 1 0 0 0
Gavin CL P P P P OD 1 1 4 4 1
Miranda AL AL AL AL AL AL AL P P P OD 1 1 3 3 0
Lenis 0 0 0 0 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.