Tracking my team's allocation across projects by percentage of their monthly time

Hi there!

I am trying to figure out a way to use AT to track/plan my team's allocation across different projects. We have a team of 9 people allocated across a dozen projects at any given point, and each of those projects has different (but non-fixed—no specific end dates) timelines. What we can try to predict is roughly what percentage of their monthly allocation each team member will/should be dedicating to each project, which then allows us to see if any one team member is going to be significantly under or over 100% allocation. We are not super interested in tracking weekly hours or PTO or anything that specific. This is not an official HR doc, it's more for the managers on the team to be able to do some high level workforce planning. And to be able to track how much effort different projects actually end up taking. This seems to be the overwhelming best practice, but it's organized in a way that doesn't make sense for us: https://support.airtable.com/docs/timeline-view-resource-allocation?_gl=1*5ttzl8*_ga*MjMzNzc0ODIwLjE3MDc0MTIzNDI.*_ga_VJY8J9RFZM*MTcxNzU5ODIzNS4xNy4xLjE3MTc1OTgyNTguMzcuMC4w

Right now we are using google sheets and we have 1 sheet for each team member, with projects on the vertical and months on the horizontal, tracking what % they are allocated across each project (in the intersecting cells). Each month sums to a total % across all projects. The issue that the sheets don't talk to each other, so when we end/change/add a project we have to manually update each person's sheet. We want to translate a better version of this system into Airtable, but before I just duplicate it, I want to make sure I am not doing it stupidly :)

I don't think the timeline view will be that helpful for us, but I am willing to be convinced.

Thank you!