Hello all,



I am currently doing this task manually in a big spreadsheet, so I'm trying to figure out step by step how to automate the task. Step one requires me to understand how to automatically do the calculation of figuring out how many hours the person worked on a project divided by the # of hours that they could have worked. So for example if

so Joe Smith spent 40/40 hours so his utiliation is 1 = 100%
John Doe on his stream Construction is 26/40 - 65%
Jill is 15% on Construction utilization and 10% on Financial

So basically, on one tab, I enter the hours that someone has worked in the week (their weekly time sheet report) - then on another tab (which is too large and I haven't included yet) we try to do forecast and figure out how much they actually billed. So the tab "Utilization Calculation" I'm hoping there is an easy way to make it automated so I don't have to manually calculate each person every single week.

Appreciate the help in advance.

Attached Files

resource_utilization.xlsx (491.5 KB, 12 views)