Floating Milestone

[LS123]

I have a programme of around 2000 activities & its got 20-30 odd activities
for painting of walls and I need a "floating" Milestone up in the Milestones
section to show when the painting of walls will start. The project is
currently at Foundation stage Walls will be erected according to a set
sequence. Can this be possible in MSP?

 

[John]

I have a programme of around 2000 activities & its got 20-30 odd activities
for painting of walls and I need a "floating" Milestone up in the Milestones
section to show when the painting of walls will start. The project is
currently at Foundation stage Walls will be erected according to a set
sequence. Can this be possible in MSP?

LS123,
Since we can't "see" your file, what do you mean by, "... up in the
milestones section..."?

What you refer to as "floating milestone" sounds like nothing more than
a milestone that is linked finish-to-start with one or more tasks that
are required before the walls can be painted (i.e. framing, drywall,
taping, sanding). The milestone will "float" as those tasks move due to
acceleration or delays in the schedule.

So yes, it is possible in MSP.

John
Project MVP

 

[Jack Dahlgren]

Certainly. Insert a task in the milestones section, set the duration to 0 and
create a start to start dependency with the first wall painting task. It will
always show when the task starts.

-Jack Dahlgren

 

[LS123]

Thanks for your valuable comments Gents,

I guess, last time I couldn't explain it properly.

Weekly I need to prepare a Milstone chart from the
main programme to show Start & finish of some important event/activities.

My project is at foundation stage, after evey week's progress update I need
to forward the Milestones chart to commecial deptt. to update their schedule
as well.
What happens after every weeks progress input, the first wall which was
supposed to be ready for painting in 4wks from previous status date is now
being delayed by 1 wk & some other foundation is now the first one to be
completed.

There are say 25 wall foundations to be done in next 4-10wks, every week you
have a new foundation that is ahead of schedule. If I give a SS predeccessor
to my milestone from all the walls, the milestone will show the start date of
last wall but I want exactly opposite - Start date of First Wall!!!

Any Help?

 

[John]

Thanks for your valuable comments Gents,

I guess, last time I couldn't explain it properly.

Weekly I need to prepare a Milstone chart from the
main programme to show Start & finish of some important event/activities.

My project is at foundation stage, after evey week's progress update I need
to forward the Milestones chart to commecial deptt. to update their schedule
as well.
What happens after every weeks progress input, the first wall which was
supposed to be ready for painting in 4wks from previous status date is now
being delayed by 1 wk & some other foundation is now the first one to be
completed.

There are say 25 wall foundations to be done in next 4-10wks, every week you
have a new foundation that is ahead of schedule. If I give a SS predeccessor
to my milestone from all the walls, the milestone will show the start date of
last wall but I want exactly opposite - Start date of First Wall!!!

Any Help?

LS123,
OK, I understand better what you mean by "floating" milestone. You
basically want to capture the first completion, whichever one that is by
the status date. In Project there is no way (at least that I can think
of) to set up that type of decision linkage automatically. However,
there are a couple of ways you can get there. First, go ahead and status
the schedule and then manually link the necessary milestones to the
correct task for your milestones chart. A second variation of that would
be to automate the process using VBA but unless you have a little VBA
experience, you're probably better off to do it manually - assuming
there are only a limited number of desired milestones.

John
Project MVP

 

[LS123]

Thanks John,

Even I had a brain storm session for the same but couldn't find a way. I
have got a little exposure to VBA, lets see if I can make the code.

Thanks Again.

 

[John]

Thanks John,

Even I had a brain storm session for the same but couldn't find a way. I
have got a little exposure to VBA, lets see if I can make the code.

Thanks Again.

LS123,
You're welcome and thanks for the feedback. If you have questions with
VBA, post to our sister newsgroup, microsoft.public.project.developer.

John