Exporting Resource Spread from MSP 2007 into Excel.
- Created
- 5
- 5
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
5 replies
Oldest first- 0Rakesh Baurai ·
Julian you can try it for MSP
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
+919724348356
- 0Rakesh Baurai ·
Julian you can try it for MSP
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
+919724348356
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?