Gantt Chart with Resource Loading

The response to POST 1 of this Gantt Chart mini series was swift and it didn't take long for Vegard to contact me with a query regarding resource loading. Vegard had quickly taken the template and adapted it to include resource hours. The issue existed with getting the total hours for each resource to behave the way he wanted. Naturally, individuals will normally work for a set expected amount of time per day and if tasks are planned which exceed that expectation, it's obvious that they might not get the work done!

In this post, I'll start to explain how to adapt the model from the previous post to include resource loading and associated subtotals per individual resource.