×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

exporting to excel

exporting to excel

exporting to excel

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

thanks,

Cesar Baquerizo

RE: exporting to excel

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

RE: exporting to excel

(OP)
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
www.conbaquerizo.com
Guayaquil Ecuador

RE: exporting to excel

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

RE: exporting to excel

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!

RE: exporting to excel

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.



------------------------
www.leadingproject.com
www.conceptdraw.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close