Every company seems to have some version of matrix - people and teams are organized in one way (perhaps by discipline, region, etc), while projects are organized a different way (by company goal, mission, theme, metric, etc).
The Solution: Give everyone their own view into the matrix
By modeling people and projects separately, your Coda doc can properly represent the current resource allocations so that you can rebalance with confidence.