Gambrill Gardens: Room Keys and Ukuleles

This week has been incredibly busy, but I love it!  I have been working all week on my spreadsheet.  First, I enter the residents last name, first name, and room number.  Then I enter the floor number, their main phone number, and their secondary phone number.

After I have all of that information set up, I can go through the key check-out cards.  The cards provide Gambrill with a record of which (and how many) apartment keys, outside keys, and mailbox keys each resident owns… the only problem was the number of cards that began to take up space.

There were over 400 cards when I started, and now I am down to a little over 300.  There were old cards from residents who died or who no longer live here, so I threw all of those away.

Then, with the current cards, I can enter the date the keys were attained by the resident and each key’s number.  This is the longest part of the process.  I am going through all of them alphabetically by the last name, and I am currently on “M” now.

I’m hoping I can show off the spreadsheet somehow either on here or during my presentation!  I would just have to cover or change the resident’s names.