Hello,
Goal: To view estimated hours per resource per week.
I am looking for a way to calculate the weekly hours remaining on a project, per person. I am referencing my project plan as the source sheet which has: Resource Name, Estimated Hours, Start Date, Due Date, Week Start, Task Name, etc.
In a summary sheet, I would like to see each team members name, the name of the project, their total hours for the project, and the hours needed for each week.
Ideally, I would like to have information pulling/calculating from multiple project plans into this summary sheet so that we can view each resources weekly capacity.
I have had no luck finding a formula to accurately calculate this so far.
Thank you,