Project to Excel

J

JaneH

I would like to export my remaining cost for each task to Excel. Easy enough
you might think, however I would like the remaining costs to be summarised by
month. I currently do this by using the resource usage view, inserting the
cost field, setting the timescale to months and copying and pasting this
information into Excel. I have tried using Export maps but can't seem to get
the "month" thing. Is there an easier way to do this? I am using Project
2000.
 
J

JulieD

Hi Jane

have you tried "Analyse Timescaled Data in Excel" ... it's on the Analysis
toolbar. It doesn't have "remaining cost" as a field - but has both actual
& baseline cost so, i'm guessing that you could add a formula in excel do
to the calculation.

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resource Budget Cost - Tracking 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Adding Cost Field to Appointment 0
Export task usage view to Excel 1
Resource Usage summary work is 0h 0
Simulate a project performance with earned value analysis 0
timephased remaining value in project 1
Fixed Cost Cash Flow 3

Top