2015 IHO Space Utilization Analysis via calendar records
This repository contains the scripts for parsing room booking info from Oakland Impact Hub's events calendar and determining how close we are to optimal space utilization.
Workflow
- Parse the text from IHO Google Calendars into a CSV file with gcal2excel
- Determine hours booked and count of number of rentals over the year 2015 for each rentable space in categories:
conf_rooms = ['UPTOWN', 'DOWNTOWN', 'EAST_OAK', 'WEST_OAK', 'MERIDIAN']floor_space = ['BROADWAY', 'GALLERY', 'ATRIUM', 'JINGLETOWN', 'ENTIRE']
- Classify each space usage event as
-
DAY: Events beginning 8:00 - 17:30 -
EVENING: " " 17:30 - 24:00
-
- Determine rental capacity of IHO:
- 9.5 day hours and 6.5 evening hours comprises one rental day
- 251 work days and 105 weekend days in 2015, according to http://www.workingdays.us/workingdays_holidays_2015.htm
- Compute percentage of capacity for each room
- Present the findings in an Excel doc
Data
The original data is in two Google calendars used by IHO. We grabbed those fields and put them in a CSV file. Time information is already standardized but event description and location are human written into a general "Description" text field. IHO_cal.py parses the text from that CSV and catgorizes calendar entries. The relevant data are contained in IHO_space_util_2015.csv. Note that if multiple rooms are specified in a calendar entry, each room has a separate row in IHO_space_util_2015.csv.
Questions
Aside from percentage capacity we might want to know:
- How do results compare with 2014?
- What is the minimum space utilization that sustains IHO financially?