Hello:
I'll try to explain this the best way I can.
I've been asked to do a resource matrix based on complexity of work and duration of a project.
Complexity would be values of 0-5. Duration would be based on a start date and an end date. I think the WEEKNUM function may work out here [e.g. week 9 (start) week 45 (end); the difference would be 36 (weeks)].
I would need to take the start week and populate the count from week 9 all the way through to week 45..run a loop through the data and continue to populate each cell for each week that there is activity (or duration/difference between the two dates).
So if there is a project that starts week 1 and ends week 5 and another project that starts week 2 and ends week 4...the table should look like this...
For complexity 0 and PM Joe; week1=1, week2=2 week3=2, week4=2, week5=1.
Any help would be greatly appreciated, I'm going bald
I'll try to explain this the best way I can.
I've been asked to do a resource matrix based on complexity of work and duration of a project.
Complexity would be values of 0-5. Duration would be based on a start date and an end date. I think the WEEKNUM function may work out here [e.g. week 9 (start) week 45 (end); the difference would be 36 (weeks)].
I would need to take the start week and populate the count from week 9 all the way through to week 45..run a loop through the data and continue to populate each cell for each week that there is activity (or duration/difference between the two dates).
So if there is a project that starts week 1 and ends week 5 and another project that starts week 2 and ends week 4...the table should look like this...
For complexity 0 and PM Joe; week1=1, week2=2 week3=2, week4=2, week5=1.
Any help would be greatly appreciated, I'm going bald