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 8 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 8 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 10 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 10 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

  

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts