Complex Scheduling Help!

Hi Airtable Community,
I’m trying to build a tool that will automate a complex schedule process. I run a music institute each summer, which runs for 5 weeks, with 35 musicians involved, all collaborating with one another. Musicians are assigned to small music groups, and are scheduled weekly for a certain amount of instruction, sometimes with their music groups, sometimes individually for lessons. They remain in the same music group for the entirety of the 5 weeks, but their coaching/instruction time varies week to week, in a pattern determined by our program director on a weekly basis.

We’ve been utilizing macros in Excel to keep music groups together and alert when there are scheduling overlaps and coaching overlaps. But, I’m hoping that perhaps AirTable could help us automate some or more of the process. Can anyone help?
Thanks in advance.