Lots of SQL. Refactored users table, splitting out ‘organization’ and ‘college’ into a separate table to account for multiple values. With help of Jonathon Trigeux, came up with table to map colleges to organizations. after much fiddling, arrived at this summary table:
https://www.uvm.edu/~waw/php/ctl_events_reports.php
Had to seriously modify calendar coed to account for new table structure.
