Dependency Chain View or Report Available AnyWhere?

[Michael Balda]

Does anyone know where to find/get a Dependency Chain View or Report? I
would like to follow the links associated with a certain task to see how it
flows through the project and I can not find a view or report that will show
me the successor and predecessor chain of a task through the entire project.
I have 13000 tasks and trying to follow the successor/predecessor is very
hard to do and hoping someone can help me, Thanks in advance for your help

 

[JackD]

Go to my website and check out the Trace macro

http://masamiki.com/project/macros.htm

 

[Michael Balda]

Thanks, I will. Have a nice day.

Go to my website and check out the Trace macro

http://masamiki.com/project/macros.htm

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

 

[Michael Balda]

That was useful, thanks...

Maybe you can help me on this question. Deliverables were to be milestones,
and you could run a milestone report to give to management to show them what
the deliverables for a month will be.

Since I Have 13000 tasks, I do not want to create a bazillion milestones for
each deliverable, is there a way to mark a task as a deliverable item and
then run a report to show how many of something will be created each month?

I tried searching for deliverables and only found stuff telling me what a
deliverable is, nothing told me how to mark something as a deliverable.

 

[JackD]

Insert one of the number fields. Put a number in the field for each line
item you want to count.
Go to the project menu, select group by.
group the tasks by finish date and set the interval to be month.
The month summary line should have the sum of the items in that month.

 

[Michael Balda]

JackD, I hope you kept the notify me of replies checked for this thread...

I followed the sort directions, very helpful as I did not know how/what that
featured did till I just used it.

It sorted great by months and should be able to show me delivereables for
each month as I wanted, but I need more help with it. But it however it is
not sorted to show me exactly what I need, yet, maybe you can help me
further? Sorting only tis way gives me to much information yet or is not
really complete.

A deliverable as defined by me is when all tasks for something is complete.
The parent name of a task is called "Create Art Model 01", it has a create
concept for art task, then a create 2D art task, and then a create 3D art
task - after all three of those tasks are complete I then have a deliverable
item. When I sort it will give me a sort just fine, but it is really not a
deliverable till all 3 items are complete. Using the sort you told me to try,
it can give me a sort for Sept when tasks 1 is complete but the deliverable
is not meet till all 3 tasks are done. Can you tell me how to sort, add
whatever columns I need so it will only give it to me when all three tasks
are complete - thus I can show for each month how many of what management can
expect to receive?

Thanks in advance of your response. If my reasoning/description is not
clear, let me know and I will try again.

 

[JackD]

Sorry,

You can't do what you want with grouping.
You could structure your file like this however

Deliverable Summary Task
First Task
Second Task
Third Task

The tasks are indented which makes the first task a summary task.
Then filter to show only summary tasks.
I'm not really sure how you would go about generating a report, but I'd use
a bit of VBA code to do it.
The code would not be too complicated. This would be most of the code.

something like this
dim t as task
dim ts as tasks
dim reportperiod as date
dim reportstart as date
dim reportend as date
dim reportstep as integer
dim deliverablecount as integer
set ts = activeproject.tasks
for reportperiod = reportstart to reportend step reportstep
deliverablecount = 0
for each t in ts
if t.summary then
if t.finish > reportperiod and t.finish < reportperiod + reportstep
then
deliverablecount = deliverablecount +1
end if
end if
next t
'write value of deliverablecount and the reportperiod out to a text file or
excel
'see my website for details on writing out to a file
next reportperiod

Of course you need to set the start and finish but that is pretty simple.
This would give you the plan.

 

[Michael Balda]

Hey Jack... Been away from work for a couple days, sorry for not replying
earlier.

All my tasks do have a summary task and are set up ;ike 1st, 2nd, 3rd task
then a summary task above them. Most of my summary tasks are what I would
define as being a deliverable - for the exceptions of that rule I created a
milestone for them. I have zero knowledge on what VBA is, I can do a search
for it to learn about it. So me finishing the information you provided is
greek to me. It sounds like from what you wrote, it is possible to generate
a report to give to management showing them what the monthly deliverables
would be.

Can you provide me more info on how to finish your code or where to gain
knowledge on how to achieve what I need? Thanks again for your assistance.

 

[JackD]

Take a look at the VBA examples at either of my websites.
You might want to read these:
http://zo-d.com/blog/archives/programming.html
http://masamiki.com/project/macros
and also some of the reference material that you can find links to there.