Prev: MS Project with small tasks and a full year to complete
Next: External Links - MSP adding them at random and other queries...
From: m3lyssa on 30 May 2010 17:41
Thank you all! It is working. I had changed [ProjectStart] to [Start]
because I kept getting an error but it just occured to me to add a space
[Project Start] and it all fell into place! It looks great! I also added
*-1 to the end of the LF formula to make the number a positive. I was
working on a test project and am now going to apply it to my project and see
how it goes. :)

Thanks again! ~Melissa

"Steve House" wrote:

> You could probably do it with VBA but it would be more trouble than it's
> worth. Task information fields like that don't 'span' across multiple
> tasks, ie, if you had two tasks A and B you could not create a calculated
> field such that the calculation for task B picks up information from a field
> for task A.
>
> I just realized I made an error in the calculation for LS and LF though.
> They actually should be
> =ProjDateDiff([ProjectStart],[LateStart])/[MinutesPerDay] and
> ProjDateDiff([LateFinish],[ProjectStart])/[MinutesPerDay] respectively,
> referencing days from project start rather than days backwards from project
> finish.
>
> The EarlyStart, EarlyFinish, LateStart, And LateFinish fields are calculated
> and maintained as dates by Project and are already built-in. The formlas I
> suggest are to give you days from Day Zero (Start) instead of dates.
>
> The method I gave you does give you cumulative values. Suppose you have
> Start (Milestone, Mon 30 May) -->Task A (5d) --> Task B (3d) -->Task C
> (4d) --> Finish (Milestone)
>
> Start: Day 0
> Task A: ES=0, EF=5, LS=0, LF=5
> Task B: ES=5, EF=8, LS=5, LF=8
> Task C: ES=8, EF=12, LS=8, LF=12
> Finish : Day 12
>
> Now add Task X, duration 5 days, after Task B and running in parallel with
> it, linked A-->X-->C. We have two paths, A->B->C and A->X->C. The critical
> path is now S-A-X-C-F and B has some slack.
>
> Start: Day 0
> Task A: ES=0, EF=5, LS=0, LF=5
> Task B: ES=5, EF=8, LS=7, LF=10 (Slack = LF-EF = 2day)
> Task X: ES=5, EF=10, LS = 5, LF = 10
> Task C: ES=10, EF=14, LS=10, LF=14
> Finish : Day 14
>
> HTH
>
>
> --
> Steve House
> MS Project Trainer & Consultant
>
>
>
> "m3lyssa" <m3lyssa(a)discussions.microsoft.com> wrote in message
> news:F8C6B51D-3385-49FF-880F-B1FAAED042A3(a)microsoft.com...
> > Thank you, Steve! Is there a way to to get each box to take the finish
> > date from box 'A' and add the duration from box 'B' to get the cumulative
> > figures? My boxes are currently configured like this...
> >
> > 0 Duration 10 10 0 Duration 5 5
> > 0 10 0 5
> >
> >
> > I would like them to look like this... Cumulative.
> >
> > 0 Duration 10 10 11 Duration 5 16
> > 0 10 10 16
> >
> > Thanks for your help and time.
> >
> >
> > "Steve House" wrote:
> >
> >> Use the Customize Fields tool to define four custom number fields ES, LS,
> >> EF, and LF.
> >>
> >> ES = ProjectDateDiff([ProjectStart],[EarlyStart])/[MinutesPerDay]
> >> EF = ProjectDateDiff([ProjectStart],[EarlyFinish])/[MinutesPerDay]
> >> LS = ProjectDateDiff([LateStart],[ProjectFinish])/[MinutesPerDay]
> >> LF = ProjectDateDiff([LateFinish],[ProjectFinish])/[MinutesPerDay]
> >>
> >> Then set up your Network Diagram template so each box displays the task
> >> name, duration, and the four above calculated fields.
> >> --
> >> Steve House
> >> MS Project Trainer & Consultant
> >>
> >>
> >> "m3lyssa" <m3lyssa(a)discussions.microsoft.com> wrote in message
> >> news:F1E81769-0904-48CC-81C9-022710FA6F22(a)microsoft.com...
> >> > I'm taking a PM class and our instructor had us manually create a
> >> > network
> >> > diagram so that we could learn how the forward pass and backward pass
> >> > are
> >> > calculated. He also said that the network diagram in project can be
> >> > configured to show the calculations as well. For example... 0 10
> >> > Days
> >> > Duration 10 instead of dates. I have figured out how to reflect this
> >> > in
> >> > diagram box but cannot get it to add the ten days to the duration on
> >> > the
> >> > following box. I created a custom number field with a formula to get
> >> > it
> >> > to
> >> > show what is in the example based on my tasks. Any one know how to get
> >> > the
> >> > print out to show as it would if it were manually calculated? Thanks!
> >>
> >> .
> >>
>
> .
>
From: JulieS on 30 May 2010 18:04
Superb. Thanks for the feedback Melissa.

Remember, this newsgroup is closing on Tuesday June 1. You can
post any new questions to the Project forums.

See:

http://social.technet.microsoft.com/Forums/en-US/category/projectserver2010,projectprofessional2010

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

On 5/30/2010 5:41 PM, m3lyssa wrote:
> Thank you all! It is working. I had changed [ProjectStart] to [Start]
> because I kept getting an error but it just occured to me to add a space
> [Project Start] and it all fell into place! It looks great! I also added
> *-1 to the end of the LF formula to make the number a positive. I was
> working on a test project and am now going to apply it to my project and see
> how it goes. :)
>
> Thanks again! ~Melissa
>
> "Steve House" wrote:
>
>> You could probably do it with VBA but it would be more trouble than it's
>> worth. Task information fields like that don't 'span' across multiple
>> tasks, ie, if you had two tasks A and B you could not create a calculated
>> field such that the calculation for task B picks up information from a field
>> for task A.
>>
>> I just realized I made an error in the calculation for LS and LF though.
>> They actually should be
>> =ProjDateDiff([ProjectStart],[LateStart])/[MinutesPerDay] and
>> ProjDateDiff([LateFinish],[ProjectStart])/[MinutesPerDay] respectively,
>> referencing days from project start rather than days backwards from project
>> finish.
>>
>> The EarlyStart, EarlyFinish, LateStart, And LateFinish fields are calculated
>> and maintained as dates by Project and are already built-in. The formlas I
>> suggest are to give you days from Day Zero (Start) instead of dates.
>>
>> The method I gave you does give you cumulative values. Suppose you have
>> Start (Milestone, Mon 30 May) -->Task A (5d) --> Task B (3d) -->Task C
>> (4d) --> Finish (Milestone)
>>
>> Start: Day 0
>> Task A: ES=0, EF=5, LS=0, LF=5
>> Task B: ES=5, EF=8, LS=5, LF=8
>> Task C: ES=8, EF=12, LS=8, LF=12
>> Finish : Day 12
>>
>> Now add Task X, duration 5 days, after Task B and running in parallel with
>> it, linked A-->X-->C. We have two paths, A->B->C and A->X->C. The critical
>> path is now S-A-X-C-F and B has some slack.
>>
>> Start: Day 0
>> Task A: ES=0, EF=5, LS=0, LF=5
>> Task B: ES=5, EF=8, LS=7, LF=10 (Slack = LF-EF = 2day)
>> Task X: ES=5, EF=10, LS = 5, LF = 10
>> Task C: ES=10, EF=14, LS=10, LF=14
>> Finish : Day 14
>>
>> HTH
>>
>>
>> --
>> Steve House
>> MS Project Trainer& Consultant
>>
>>
>>
>> "m3lyssa"<m3lyssa(a)discussions.microsoft.com> wrote in message
>> news:F8C6B51D-3385-49FF-880F-B1FAAED042A3(a)microsoft.com...
>>> Thank you, Steve! Is there a way to to get each box to take the finish
>>> date from box 'A' and add the duration from box 'B' to get the cumulative
>>> figures? My boxes are currently configured like this...
>>>
>>> 0 Duration 10 10 0 Duration 5 5
>>> 0 10 0 5
>>>
>>>
>>> I would like them to look like this... Cumulative.
>>>
>>> 0 Duration 10 10 11 Duration 5 16
>>> 0 10 10 16
>>>
>>> Thanks for your help and time.
>>>
>>>
>>> "Steve House" wrote:
>>>
>>>> Use the Customize Fields tool to define four custom number fields ES, LS,
>>>> EF, and LF.
>>>>
>>>> ES = ProjectDateDiff([ProjectStart],[EarlyStart])/[MinutesPerDay]
>>>> EF = ProjectDateDiff([ProjectStart],[EarlyFinish])/[MinutesPerDay]
>>>> LS = ProjectDateDiff([LateStart],[ProjectFinish])/[MinutesPerDay]
>>>> LF = ProjectDateDiff([LateFinish],[ProjectFinish])/[MinutesPerDay]
>>>>
>>>> Then set up your Network Diagram template so each box displays the task
>>>> name, duration, and the four above calculated fields.
>>>> --
>>>> Steve House
>>>> MS Project Trainer& Consultant
>>>>
>>>>
>>>> "m3lyssa"<m3lyssa(a)discussions.microsoft.com> wrote in message
>>>> news:F1E81769-0904-48CC-81C9-022710FA6F22(a)microsoft.com...
>>>>> I'm taking a PM class and our instructor had us manually create a
>>>>> network
>>>>> diagram so that we could learn how the forward pass and backward pass
>>>>> are
>>>>> calculated. He also said that the network diagram in project can be
>>>>> configured to show the calculations as well. For example... 0 10
>>>>> Days
>>>>> Duration 10 instead of dates. I have figured out how to reflect this
>>>>> in
>>>>> diagram box but cannot get it to add the ten days to the duration on
>>>>> the
>>>>> following box. I created a custom number field with a formula to get
>>>>> it
>>>>> to
>>>>> show what is in the example based on my tasks. Any one know how to get
>>>>> the
>>>>> print out to show as it would if it were manually calculated? Thanks!
>>>>
>>>> .
>>>>
>>
>> .
>>
First  |  Prev  | 
Pages: 1 2 3
Prev: MS Project with small tasks and a full year to complete
Next: External Links - MSP adding them at random and other queries...