H
Harley Quinn
We are doing an export of project to excel for a tool we use to determine
resource capacity.
The problem is, when we export, and it's a task that goes over more than one
week, rather than break the task down over the weeks (like you'd see in the
Resource usage view) Excel shoves all the hours into the week the task starts
in.
So, a 30 hour task that's taking place over 2 weeks (15 hrs/wk) shows as
needing 30 hours week 1 and 0 hours week 2 in Excel.
Is there a macro out there (or can you help me create one as I have no
experience doing so) that would export from Project to Excel keeping the
breakdown as it shows in Resource Usage view?
resource capacity.
The problem is, when we export, and it's a task that goes over more than one
week, rather than break the task down over the weeks (like you'd see in the
Resource usage view) Excel shoves all the hours into the week the task starts
in.
So, a 30 hour task that's taking place over 2 weeks (15 hrs/wk) shows as
needing 30 hours week 1 and 0 hours week 2 in Excel.
Is there a macro out there (or can you help me create one as I have no
experience doing so) that would export from Project to Excel keeping the
breakdown as it shows in Resource Usage view?