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

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