That quickie sheet was done in LibreOffice. I would at least add some conditional formatting e.g. RED overdue and yellow - within 10 days.
https://wiki.documentfoundation.org...ice_Calc._Conditional_formatting_guide_EN.pdf
Knowing how many locations would help. You could add some sort of proximity field, maybe. You can sort by bldg, room, floor etc. Maybe even the time of day
I think there is a "note" type of function, where when you hover over a cell, you get specific information.
You can get fancy and add a button macro to do the sort or just manually do it.
This can be an exercise as well. I might try a picaxe and an I2C LED or LCD display.
Here
https://ww1.microchip.com/downloads/en/DeviceDoc/DS-22238b.pdf is an I2C clock calendar. That project might be able to run off a USB wall wart and a backup battery.
The trick would be a device similar to a watch.
I think this method is very do-able with minimal skills.