This excel sheet was developed to aid University of Houston's Student Housing & Residential Life department in visualizing and tracking how many residents will be utilizing each residence hall over the summer months. I wrote a macro that allowed us to display these numbers visually, blue numbers are incoming residents and red numbers are outgoing residents. Organization names and numbers have been changed in order to maintain confidentiality.
EXCEL LINK (macros won't work unless downloaded):
In addition to the residence tracker, I developed an automatic invoicing excel sheet due to the UH Student Housing and Residential Life's lack of financial software. These systems are still used to this day.
EXCEL LINK:
