exporting to excel

[cesarbaq]

Hi, how can I export a report from ms project to excel so that I can modify it there?

thanks,

Cesar Baquerizo

 

[upuki]

Cesar:

just select "Save as" and then look for the Excel option within the "Save as type" ones. You will then be asked to select the data to be exported, and you could select a pre-defined set of data or create one yourself.

By the way, I read your question on productivity. I am very interested in your results. I am living in Argentina, but I work on several countries around. Comparing productivity and cost is something I have to start doing in order to justify the investment in each country. Please let me know of your results, maybe we could exchange data.

Regards,

Idelin

 

[cesarbaq]

Hi, I can email you my paper... I made some comparisons between productivities from USA and Ecuador...what is your email?

I saved as xls and I can export to excel, but what I can't do yet is to export a resource usage report, like the one in ms project(where you have quantity or cost of resource each month)... because what I have found is that I can put the name, code, etc , but I don't know how to make it give me per month...

thanks,

Cesar Baquerizo

http://www.conbaquerizo.com

Guayaquil Ecuador

 

[IRstuff]

You need to go to the Resource Usage Table, which is located either on the View Bar or through the View menu.

The Resource Usage view shows both resources per time period as well as resource allocated per task per period.

TTFN

 

[oijammu]

Try copying the entire BoQ(Description,units & rates) to resource sheet and change type to materials, and go to ghant chart and allocate qty in resource allocation.Even Priliminaries & General can be allocated this way.Woa you will not believe your eyes!

 

[Zhadanov]

Hello,

Our company is making research about this subject.
We are trying to find out the importance of this feature and, possibly, to develop a new software tool (freeware) with such capabilities.
We would greatly appreciate if you give us more information about things you usually do (or would like to) with generated reports.

Sincerely,
Zhadanov Igor.



------------------------

http://www.leadingproject.com

http://www.conceptdraw.com