OK, so I found some VBA that does exactly what I want. Check out this blogpost by Stefan Waldherr.

I was indeed afraid it was going to be VBA. However, part of my question still stands:

How do I create custom columns showing the weekly availability of people?