Re: Export Wizard - Duration and Work

From: Gérard Ducouret (gerard.ducouret_at_NOSPAM.wanadoo.fr)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 18:24:55 +0200

Hello Geoff,
If the "d" or "w" of the Duration and Work fields disturb your data export,
you can use a formula in a Number(x) field which will display the duarations
and the work load in minute. Then you export these Number(x) fields with you
map.

Hope this helps,

Gérard Ducouret

"geoff.pratt@hp.com" <anonymous@discussions.microsoft.com> a écrit dans le
message de news:196201c49a07$0ff9bc50$a501280a@phx.gbl...
> Dear All,
> I am using the export map wizard to create csv delimited
> files to load project data to a repository. The resultant
> duration and work fields can be in a differing format of
> days or weeks, and difficult to identify and manipulate.
> Project does store durations in minutes, but that doesn't
> seem to be available after the export.
> Should I be addressing this problem using a VBA approach?
> I know that I can run the Duration Macro against the
> projects (and change to minutes), or change the format
> using Tools Options, but as there are multi-projects
> involved, and I am ecouraging team-leaders to load the
> files themselves (by a File load option) I don't
> necessarily get to see the file before it is in the
> repository.
> Also, using the Wizard takes 2 runs - one for tasks and
> assignments, and the 2nd for resources.
> Is there a better way to load the data?
> Using 2002 Std.
> Kind Regards........Geoff
>

Relevant Pages

  • Re: wrestling with Percent
    ... Also, if I want to change Ben and Jennifer's load to 75%, I would expect the ... type), Fixed Duration, and Fixed Work. ... If you are using default settings for Duration and work, ... Also, keep in mind that when you make changes to resource assignments, ...
    (microsoft.public.project)
  • Export Wizard - Duration and Work
    ... files to load project data to a repository. ... I know that I can run the Duration Macro against the ...
    (microsoft.public.project)
  • Re: MS Proct 2003: Format Work field to round up to whole numbers
    ... In Microsoft Project, the software stores all Work and Duration data in minutes, but converts it to hours in Work fields and to days in Duration fields. ...
    (microsoft.public.project)
  • Re: Generating a load duration curve
    ... I wish to generate a Load ... Is there any quick easy method in Matlab that will allow me to ... have will not give me the load duration curve directly. ... using a Matlab command rather than having to generate my own M-file ...
    (comp.soft-sys.matlab)
  • Re: fx duration
    ... First paragraph of HELP for DURATION: ... install and load the Analysis ToolPak add-in. ... Kind regards, ...
    (microsoft.public.excel.worksheet.functions)