Prev: Repetitive Assignment Update email Notification to all resources i
Next: formulas in standard columns
From: Dave Eade on 10 Mar 2010 08:51
Guys,

I have a number of MSPs for different projects [ and before you say it I
know they should use server but they don't].

Anyway, I want to extract from each plan a report or data dump of the number
of Milestones per calendar month based firstly on Baseline Finish Date and
the by Actual Finish Date.

Is there any easy way of doing this for each plan?

Thanks in anticipation.

Dave
From: G�rard Ducouret on 10 Mar 2010 09:38
Hello Dave,

In a Gantt view, you could create a filter : Project / Filtered for... /
More filters:
Field Name : Milestone
Test : equals
Value(s) : Yes
And : grey row (nothing here)
Field Name : Baseline finish
Test : is within
Values : "first day of the month:"?;"Last day of the month"?
Or : Actual finish ... is within ... "first day of the month:"?;"Last day of
the month"?

G�rard Ducouret

"Dave Eade" <DaveEade(a)discussions.microsoft.com> a �crit dans le message de
news: EB5EDAF2-398F-435C-8EE7-92CA7CA96053(a)microsoft.com...
> Guys,
>
> I have a number of MSPs for different projects [ and before you say it I
> know they should use server but they don't].
>
> Anyway, I want to extract from each plan a report or data dump of the
> number
> of Milestones per calendar month based firstly on Baseline Finish Date and
> the by Actual Finish Date.
>
> Is there any easy way of doing this for each plan?
>
> Thanks in anticipation.
>
> Dave



From: Rob Schneider on 10 Mar 2010 09:38
Why in earth *must* they use server?

First thing that comes to mind is to create a filter which shows all
tasks that are Milestones. Have to work through the full details of that
filter (I don't quite understand your spec). Once you have the filter,
you can save that filter into the shared global.mpt so that all files
opened with that global.mpt will have that filter available.

Take a look at how to create filters and I think you'll get the gist of it.

--rms

www.rmschneider.com




On 10/03/10 13:51, Dave Eade wrote:
> Guys,
>
> I have a number of MSPs for different projects [ and before you say it I
> know they should use server but they don't].
>
> Anyway, I want to extract from each plan a report or data dump of the number
> of Milestones per calendar month based firstly on Baseline Finish Date and
> the by Actual Finish Date.
>
> Is there any easy way of doing this for each plan?
>
> Thanks in anticipation.
>
> Dave
From: Dave Eade on 10 Mar 2010 10:29
Sorry Gerard, I think my question must have confused.

The result I'm looking for is a report which says:

January 2009 = 5
February 2009 = 6
March 2009 = 12
etc etc

The figures 5,6 & 12 reprsent the numbers of milestones with a baseline
finish in that calendar month, I then want to run a similar report but the
results are based on the "actual" finish date.

Thanks

"Gérard Ducouret" wrote:

> Hello Dave,
>
> In a Gantt view, you could create a filter : Project / Filtered for... /
> More filters:
> Field Name : Milestone
> Test : equals
> Value(s) : Yes
> And : grey row (nothing here)
> Field Name : Baseline finish
> Test : is within
> Values : "first day of the month:"?;"Last day of the month"?
> Or : Actual finish ... is within ... "first day of the month:"?;"Last day of
> the month"?
>
> Gérard Ducouret
>
> "Dave Eade" <DaveEade(a)discussions.microsoft.com> a écrit dans le message de
> news: EB5EDAF2-398F-435C-8EE7-92CA7CA96053(a)microsoft.com...
> > Guys,
> >
> > I have a number of MSPs for different projects [ and before you say it I
> > know they should use server but they don't].
> >
> > Anyway, I want to extract from each plan a report or data dump of the
> > number
> > of Milestones per calendar month based firstly on Baseline Finish Date and
> > the by Actual Finish Date.
> >
> > Is there any easy way of doing this for each plan?
> >
> > Thanks in anticipation.
> >
> > Dave
>
>
>
> .
>
From: Rob Schneider on 10 Mar 2010 10:33
You have to (can't think of another way) build filter like Gérard
suggests. Save it in to a macro. Write the macro so that it displays
the results to itself and then you loop down the set and count how many
there are. In the macro print the results to a file or screen. you
could do the macro so that it does both dates in two passes of your
little program.


--rms

www.rmschneider.com




On 10/03/10 15:29, Dave Eade wrote:
> Sorry Gerard, I think my question must have confused.
>
> The result I'm looking for is a report which says:
>
> January 2009 = 5
> February 2009 = 6
> March 2009 = 12
> etc etc
>
> The figures 5,6& 12 reprsent the numbers of milestones with a baseline
> finish in that calendar month, I then want to run a similar report but the
> results are based on the "actual" finish date.
>
> Thanks
>
> "Gérard Ducouret" wrote:
>
>> Hello Dave,
>>
>> In a Gantt view, you could create a filter : Project / Filtered for... /
>> More filters:
>> Field Name : Milestone
>> Test : equals
>> Value(s) : Yes
>> And : grey row (nothing here)
>> Field Name : Baseline finish
>> Test : is within
>> Values : "first day of the month:"?;"Last day of the month"?
>> Or : Actual finish ... is within ... "first day of the month:"?;"Last day of
>> the month"?
>>
>> Gérard Ducouret
>>
>> "Dave Eade"<DaveEade(a)discussions.microsoft.com> a écrit dans le message de
>> news: EB5EDAF2-398F-435C-8EE7-92CA7CA96053(a)microsoft.com...
>>> Guys,
>>>
>>> I have a number of MSPs for different projects [ and before you say it I
>>> know they should use server but they don't].
>>>
>>> Anyway, I want to extract from each plan a report or data dump of the
>>> number
>>> of Milestones per calendar month based firstly on Baseline Finish Date and
>>> the by Actual Finish Date.
>>>
>>> Is there any easy way of doing this for each plan?
>>>
>>> Thanks in anticipation.
>>>
>>> Dave
>>
>>
>>
>> .
>>
 |  Next  |  Last
Pages: 1 2
Prev: Repetitive Assignment Update email Notification to all resources i
Next: formulas in standard columns