Exporting MS Project Values into Excel

[Paul Peterson - Velox Consulting, LLC]

I am exporting the "Actual Work" values from MS Project into an excel
worksheet. Unfortunately, 40 hours is stored as "40h" in excel which makes
it impossible to use for calculations. I would like some automatic way of
making sure this value is always 40 (rather than 40h) - I don't want to
manually manipulate my excel file. Any ideas?

Thanks.

Paul C. Peterson.

 

[Darrell]

Paul,

I use a macro in excel that changes all of the exported hours into numbers
based on the "find/replace" function, i.e. Replace "0h" with "0". "1h" with
"1", etc.

Darrell

 

[Jim Aksel]

I also use Darrel's method. In Project2007 you can use the Visual Reports,
select a new template and specify the Number field from the Field Picker.
Select an appropriate interval for export (Days, Weeks, Month, etc).
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Paul Peterson - Velox Consulting, LLC]

Thanks Jim.

I also use Darrel's method. In Project2007 you can use the Visual Reports,
select a new template and specify the Number field from the Field Picker.
Select an appropriate interval for export (Days, Weeks, Month, etc).
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Paul Peterson - Velox Consulting, LLC]

Thanks Darrell

Paul,

I use a macro in excel that changes all of the exported hours into numbers
based on the "find/replace" function, i.e. Replace "0h" with "0". "1h" with
"1", etc.

Darrell

 

[Mert Muftugil]

Hey Jim:

I was reviewing the thread here and your explanation below reminded me of
something I was struggling with in MS Project. Perhaps you have an idea why
I cannot get it to work.

I have MS Project 2007, MS Excel 2003, and MS Visio 2007 installed. When I
generate a "Task Usage" cube with a custom field added (number1 for example),
I can never display it as a field in the pivot table that is generated in MS
Excel. I have fields such as cost, fixed cost etc. but never any of the
custom fields.

Is there a way to include the custom fields in the pivot table generated
from this "OLAP cube" that is supposed to include any of the custom fields I
add prior to execution?

Mert

 

[Mert Muftugil]

Actually, never mind. I basically found out in other posts that the custom
fields are not timescaled/time-tracked. Good luck all...