Analyze Timescale in Excel Wizard

[El]

I am trying to use the Analyze Timescale in Excel feature. The challenge I
have is the MS Project Analyze Timescale in Excel wizard spreads the time at
the subtask level and I also need the work hours spread at the summary level.
Is there an easy way to summarize the baseline information over the various
days without doing it manually in Excel. Also how does the wizard determine
how the hours are spread out across the start and finish dates. In some
cases I noticed the hours are spread out evenly. In other cases I noticed
the hours are front load (example 7 hour day and 1 hour in day two for 8 work
hors). Still on some task the hours are back loaded (1 hour in day 1 and 7
hours in day two for 8 work hours).

 

[John]

I am trying to use the Analyze Timescale in Excel feature. The challenge I
have is the MS Project Analyze Timescale in Excel wizard spreads the time at
the subtask level and I also need the work hours spread at the summary level.
Is there an easy way to summarize the baseline information over the various
days without doing it manually in Excel. Also how does the wizard determine
how the hours are spread out across the start and finish dates. In some
cases I noticed the hours are spread out evenly. In other cases I noticed
the hours are front load (example 7 hour day and 1 hour in day two for 8 work
hors). Still on some task the hours are back loaded (1 hour in day 1 and 7
hours in day two for 8 work hours).

El,
Why the re-post? This is essentially a duplicate of your original post.
Let's keep the discussion in one place please.

John
Project MVP

 

[JulieS]

Hi El,

A couple of point of clarification. The Analyze Timescale Wizard does not
spread hours (Work). It merely allows you to export the data from Project
to Excel.

As John said in a reply to your previous post, there are a number of reasons
why work is not spread evenly. You note an example where a task has 7 hours
of work on one day and 1 hour of work on the next. Assuming you have a
resource assigned at 100%, if the task starts one hour into the working day
(9:00 am) then project will assign 7 hours of work for day 1 (9:00 to 5:00
with one hour for lunch) and the remaining 1 hour will be scheduled for 8:00
am to 9:00 am the next day.

For additional information I suggest you take a look at fellow MVP, Mike
Glen's excellent series of articles on MS Project at:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23


You may find it easier to view work per day in comparison to Start and
Finish dates if you show time in the Start and Finish fields. To do so, go
to Tools > Options, View tab. Select a Date Format that shows time as well.

As far as the export of Baseline Work at summary task level, I agree, it is
irritating that the export does not include values from the summary tasks.
The best suggestion I can offer is a very careful cut and paste from the
Task Usage View into the excel spreadsheet created by the export. Or, as
you suggest, simply using Excel to add the values for you.

I imagine there is a more elegant method using VBA, but I'm afraid I'd have
to leave the details on that option up to one of the VBA gurus who frequent
this site as well as the Project Developer newsgroup.

I hope this helps. Let us know how you get along.

Julie