Exporting Resource Spread from MSP 2007 into Excel.

Good Day all

 

I am used to working in Primavera and having the luxury of exporting resource spreads into Excel with ease.

 

How do I do the same using MS Projects 2007.

 

I want to view the following:

 

Column A = Task Name or Resource Name of Phase Title etc

Column B = Total Manhours

Column C through to end = Start Month .......all the Way to Finish Month - How the hours are spread.

 

 

Please can someone assist me here, I want to avoid having to copy and paste the Resource usage screen from MSP into Excel, too many formats and adjustments to be made.

 

Please can someone asnwer as soon as possible, it is quite urgent.

 

 

Regards

 

Julian

J
Julian Coetzee 👤 Member for 15 years 7 months

Hello All...

 

Anyone willing to offer assistance, I want to be able to use this report quite soons.

 

Thank you

 

Regards

 

Julian

J
Julian Coetzee 👤 Member for 15 years 7 months

Hi there Rakesh

 

In 2007, you do not have that function as you did in 2003.  You have to use Visual Reports or Export into Excel and use Pivot tables.

 

How does one get the report exactly in the View or Setup I stipulated?

 

Thanks

 

Kind Regards

 

Julian

R
Rakesh Baurai 👤 Member for 15 years 9 months

Julian you can try it for MSP 2007 i had used it in MSP 2003

It is very simple

go to Tools>>Customize>> toolbars>> and select for "Analysis" toolbar

 

And use "Analyze Timescaled data in Excel"

 

Regards

Rakesh Baurai

[email protected]

[email protected]

+919724348356

  

R
Rakesh Baurai 👤 Member for 15 years 9 months

Julian you can try it for MSP 2007 i had used it in MSP 2003

It is very simple

go to Tools>>Customize>> toolbars>> and select for "Analysis" toolbar

 

And use "Analyze Timescaled data in Excel"

 

Regards

Rakesh Baurai

[email protected]

[email protected]

+919724348356

  

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts