+ Reply to Thread
Results 1 to 2 of 2

showing the progress of the dependency

  1. #1
    Forum Contributor
    Join Date
    03-16-2010
    Location
    Phnom Penh, Cambodia
    MS-Off Ver
    Excel 2003
    Posts
    214

    showing the progress of the dependency

    Dear All,

    I have list of Tasks with the dependency. Some tasks have only one dependency and some have more. Each dependency has its own tasks to be completed.

    I would like to show the progress of the dependency to the main Tasks. However, I seem cannot figure out how to get this done.

    Example:

    - Task A has 3 links as its dependency (link1, link3, link4). If the 3 links are ready then i would consider links for Task A is "Ready", but actually these links are not yet ready and it shows as "Progress".
    - Task B has only one link as its dependency which is link2. This link2 is also ready so its progress should be "Ready".

    Your advise will be pretty much appreciated.

    Enclosed attachment is the sample worksheet which I am working on.

    Regards,
    sanlen
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: showing the progress of the dependency

    As an option.
    Calculate if each Link in each Tast is Done and then calculate how many links are "done".
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Chart showing progress
    By KClem in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-29-2015, 07:55 AM
  2. [SOLVED] Line Chart Showing What I Think Is Progress
    By HarryGreenwood in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-29-2015, 07:26 AM
  3. Showing progress with arrows
    By bogdn in forum Excel General
    Replies: 2
    Last Post: 05-30-2013, 04:31 AM
  4. Need help showing progress bar
    By dontke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2012, 09:50 AM
  5. VBA: Progress bar not showing
    By kcjones242 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2011, 12:54 PM
  6. [SOLVED] How do I set up a sheet showing tasks, progress, outcome, etc?
    By Donna in forum Excel General
    Replies: 1
    Last Post: 06-26-2006, 12:10 PM
  7. [SOLVED] how to create a msgbox showing progress of macro
    By Macropod in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2005, 10:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1