Re: How do I transfer the task usage view to excel...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: James Scott (JamesScott_at_discussions.microsoft.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 09:17:11 -0700

Unfortunately the analyze timescaled data function usms the total work per
day, but does not break it down by resource type. There are multiple
resource allocated for each task and I need to see the daily breakdown of
each. Is there some way to goad the analyze timescaled data function to
break down the tasks into its composite resources?

"Jan De Messemaeker" wrote:

> Hi James,
> On the analysis toolbar, click Analyse timescaled data in Excel.
> HTH
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> http://users.online.be/prom-ade/index.htm
> 32-495-300 620
> "James Scott" <JamesScott@discussions.microsoft.com> schreef in bericht
> news:FDC20124-0703-4C44-B6F0-F6E34ED2F8A4@microsoft.com...
> > I am trying to sum up task usage over multiple projects in excel, is there
> a
> > way to export the information in the task usage view for a schedule into
> > excel in the table format that is given within in the task usage view.
> >
> > --
> > James.
>
>
>

Relevant Pages

  • Re: Input the real Work for a specific day
    ... are no custom fields available for timescaled data. ... I noted duration for the period of time the developer took and actual ... add a custom detail to Task Usage View, ...
    (microsoft.public.project)
  • Re: Moving Hours between tasks
    ... Change the bottom view to "Task Usage". ... Task Usage pane and click "Actual; ... and 2 rows for each resource assigned to that task. ... Then in the Task Usage pane at the bottom, ...
    (microsoft.public.project)
  • Re: custom report
    ... "JulieS" wrote: ... into my task usage sheet where I presently input actual hours ... by unchecking "Updating task status updates resource status" ... against the resources in the resource sheet. ...
    (microsoft.public.project)
  • Re: custom report
    ... You may be able to get close to what you want in the Task Usage ... underneath the task name and you can add the Resource Group field. ... against the resources in the resource sheet. ... I then want to get any kind of report or sheet that will ...
    (microsoft.public.project)
  • Re: Resource Usage View
    ... I don't answer newsgroup questions on demand. ... Name the new Group something like "_Group by Resource Assignments" ... On the Group By line, select the Name field and set the Field Type as ... Click View - Task Usage ...
    (microsoft.public.project.pro_and_server)