Import Excel File Assigns Resource Allocation

[bkoren]

I have all of my Tasks, Priority, Baseline Work, Work, Actual Work, Remaining
Hours, Start Date, Resources and Predecessors in an Excel file. When I open
this file in Project 2007 I see that my resources are allocated various
percentages. I would like to have them all be 100%. My default task type
says Fixed Units. Can someone help explain where this percentage is coming
from?

I appreciate any help.

 

[Rod Gill]

Does Excel also have duration? If Duration does not match work, then units
would not be at 100%.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[bkoren]

That's what's missing! Works now!
Thanks,
Barb

Does Excel also have duration? If Duration does not match work, then units
would not be at 100%.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[bkoren]

I am able to bring in the Durations for each task. And now I see my units at
100%. However, there seems to be a hitch with this. The duration for the
highest level task does not roll up accurately. I am having trouble
understanding where the numbers are coming from that are showing. I have the
same numbers for Work and those roll up nicely.

Any help would be appreciated.

 

[Rod Gill]

Duration for a summary task is not the sum of all durations, but the
duration from start of earliest task to finish of latest task. If all tasks
are finish start then the duration might equal the sum, but otherwise not.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[bkoren]

Thanks Rod. That makes sense. I was expecting it to function like the Work
column.