assorted work disgruntlement
Mar. 20th, 2024 08:23 pmI have been working on a project to write down the stamps of all our apartment keys, and also request that the Maintenance department make extra copies of anything where we only have a single key in the office. (We can't give out a key if it's the last copy, because then we won't have any spares left.)
This really should have been done several years ago, but when I first started making a key spreadsheet I was told to go do other more immediately important things so I backburnered it and then forgot it existed. Well, now it is apparently top priority, so here we are.
Thus far I have gotten through our largest building and one of the smaller ones. Tomorrow I think I will tackle the second of the large buildings -- that one should be less trouble because we did a big re-numbering project a few years ago, which included making extra copies of anything we were low on. However, I don't think anyone's been tracking that data since the re-numbering, so if any tenants have lost keys and we've changed the locks, the key numbers will have iterated in the interim.
Oh right, explanations. So, our key numbering system works like this:
Each building is assigned a 1- or 2-letter code. Then each apartment is assigned a number. So a key to apartment 201 in Sample Building might have the code SB15. (Sometimes there is a pattern to the numbers, sometimes not. The main point is that they should not match the apartment number so as to confuse anyone who might steal keys or find a lost set.) Then if the tenant of Sample Building apt 201 loses their keys and we change the lock, the key stamp iterates and the new keys will be SB15-A. The next time we change the lock, the key stamp will change to SB15-B, and so on.
The Collegetown office has had spreadsheets and printed records of their key stamps for years, and back around 2019 switched to tracking keys electronically through FileMaker and signing them out on an iPad. The downtown office had none of this, which is why I initially wanted to create a key tracking spreadsheet. I don't think we're going to be ready to track keys via FileMaker any time soon, but at the least we will have SOME kind of tangible inventory.
Ah well, better late than never, I suppose.
...
In other news, my office computer updated and restarted itself over the weekend, which gunked up one of my big floor plan files with a lot of crufty artifacting. I finally got all of that cleared up this afternoon... and then accidentally closed the file and when I reopened it, about 75% of the artifacting had reappeared.
Such are the woes of fucking MS Paint. :(
(The cleanup is going faster the second time through, thankfully.)
This really should have been done several years ago, but when I first started making a key spreadsheet I was told to go do other more immediately important things so I backburnered it and then forgot it existed. Well, now it is apparently top priority, so here we are.
Thus far I have gotten through our largest building and one of the smaller ones. Tomorrow I think I will tackle the second of the large buildings -- that one should be less trouble because we did a big re-numbering project a few years ago, which included making extra copies of anything we were low on. However, I don't think anyone's been tracking that data since the re-numbering, so if any tenants have lost keys and we've changed the locks, the key numbers will have iterated in the interim.
Oh right, explanations. So, our key numbering system works like this:
Each building is assigned a 1- or 2-letter code. Then each apartment is assigned a number. So a key to apartment 201 in Sample Building might have the code SB15. (Sometimes there is a pattern to the numbers, sometimes not. The main point is that they should not match the apartment number so as to confuse anyone who might steal keys or find a lost set.) Then if the tenant of Sample Building apt 201 loses their keys and we change the lock, the key stamp iterates and the new keys will be SB15-A. The next time we change the lock, the key stamp will change to SB15-B, and so on.
The Collegetown office has had spreadsheets and printed records of their key stamps for years, and back around 2019 switched to tracking keys electronically through FileMaker and signing them out on an iPad. The downtown office had none of this, which is why I initially wanted to create a key tracking spreadsheet. I don't think we're going to be ready to track keys via FileMaker any time soon, but at the least we will have SOME kind of tangible inventory.
Ah well, better late than never, I suppose.
...
In other news, my office computer updated and restarted itself over the weekend, which gunked up one of my big floor plan files with a lot of crufty artifacting. I finally got all of that cleared up this afternoon... and then accidentally closed the file and when I reopened it, about 75% of the artifacting had reappeared.
Such are the woes of fucking MS Paint. :(
(The cleanup is going faster the second time through, thankfully.)