Home Forums Discussion Gantt – sort by path

This topic contains 4 replies, has 2 voices, and was last updated by  Tom Boyle 1 week ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #409450 Reply

    Ben

    I’m looking to sort the Gantt chart for easier viewing.
    I currently export a data dump which I import into Project 2013. While the tasks are linked, they aren’t intuitive to view as the tasks arrive in creation order and not the order of work.
    For instance, deliverable (a pen) has 6 task before it in a network.

    Task Name Successor
    1 Roll refill 5
    2 Fill ink
    3 Attach nib 7
    4 Mill barrel 7
    5 Mill cap 2
    6 Paint parts 1
    7 Assemble pen 2

    My current thought was I’d like to sort them by their network path. If I list the path from Deliverable.nOperations.CurrentOperation and sort path Z to A:
    Task Name Successor Path Sort Order
    6 Paint parts 1 2.5.1.6 1
    1 Roll refill 5 2.5.1 2
    5 Mill cap 2 2.5 3
    3 Attach nib 7 2.7.3 4
    4 Mill barrel 7 2.7.4 5
    7 Assemble pen 2 2.7 6
    2 Fill ink 2 7

    For reference, the data is of about 1500 lines so manually is too slow and isn’t reactive if we change how we manufacture the part.
    Either a way to produce this solution or an alternative solution would be great.

    #409451 Reply
    Larry Christofaro
    Larry Christofaro
    Participant
    • Community Leader
    • Expert
    • Forum Pro

    Ben, my simplest suggestion would be to sort by start date. That will sort tasks by start date within summary task. Another option that might be a bit more work is to create a field called Deliverables, group by Deliverables, and then by Start. Let us know if either of those come close.

    #409539 Reply

    Ben

    Larry, thanks for your response. The start date sort does make it easier, but it leaves a lot of dependencies a fair distance from one-another which leaves them hard to follow. I’ve not a quick way to assign the 50+ deliverables to the 1500 lines (up to 5 levels of WBS for each deliverable) without manually following through the paths. Is there any way to get MSP to find the last item in the chain as a calculation (i.e. not just highlighting the task paths on the Gantt)?

    #409540 Reply
    Larry Christofaro
    Larry Christofaro
    Participant
    • Community Leader
    • Expert
    • Forum Pro

    The only other option I can see is to use the Task Path, which is a visual only option. That can give you immediate response while working on the schedule.

    #409561 Reply

    Tom Boyle

    Ben,
    Larry has given you the best advice for native MS Project functionality. Task Path provides a very welcome graphical addition, but you can’t group or sort based on it.

    Sorting by logical path is a natural output of recursive logic tracing routines. If you are comfortable with vba (macro language), here’s a link to a set of macros on my blog that automatically filter and sort for task path. I grabbed your pen example (with completely imaginary durations) to illustrate the concept. Here it is sorted by ID, sorted by Start, and filtered/sorted by the QTraceP (i.e. quick trace predecessors) macro. PenPaths1

    If you’d rather not mess with vba, I use an add-in called BPC Logic Filter that can generate nearly identical output. PenPaths2

Viewing 5 posts - 1 through 5 (of 5 total)
Reply To: Gantt – sort by path
Your information:




89 − = 80