Time Management Tool for resource planning

Hia,

I think I know what you are trying to do, but I cant think of a really clean way to do it. I think most of the time you are going to run into problems of circular references..

I have attached something close (I think). It's obviously not the complete thing, but it's maybe a nudge in a direction that gets you what you need. It does rely on a second set 'override' cells where you can put your manual adjustments in.