How do I track # of tasks started and completed with export to Xce

[Alfatcop]

Hello,

I need to generate in Xcel 2 graphs:
- number of started tasks (planned vs actual) over time (weekly base)
- number of completed tasks (planned vs actual) over time (weekly base).

Any ideas on how I could do this?

Thanks a lot,

Alfatcop

 

[John]

Hello,

I need to generate in Xcel 2 graphs:
- number of started tasks (planned vs actual) over time (weekly base)
- number of completed tasks (planned vs actual) over time (weekly base).

Any ideas on how I could do this?

Thanks a lot,

Alfatcop

Alfatcop,
There are straightforward but tedious ways to do this and there are less
obvious but more robust ways to do it.

One straightforward way is to successively use the Date Range filter.
Use an export map to export start, actual start, finish and actual
finish to Excel where you can compile it to make the graphs.

If you are using Project 2007, you could probably use the Visual Reports
feature to export timescaled data of work and actual work. Then in the
Excel pivot table parse out the tasks that have work scheduled in the
time period of interest and use that as the basic for your time axis for
the graph.

The less obvious but more robust approach would be to use VBA to export
start, actual start, finish and actual finish data directly to an Excel
graph. A macro will allow you to capture the data in time sequence and
also to set up the Excel graph(s) automatically.

Hope this helps.
John
Project MVP

 

[Alfatcop]

Thank you John.
I'll go the straightforward way.
In fact I am simply exporting the start,finish,actual start and actual
finish in a simple xcel table (no pivot).
Then I count the number of element within a certain range using array formula.
Works great.
I just flag the summary task to avoid counting them in process.

In summary:
- flag summary task
- export flag, start,finish, actual start, actual finish
- sort by flag
- use array formula to count the number of element within each range (weeks)
....done !

Again thanks,

 

[John]

Thank you John.
I'll go the straightforward way.
In fact I am simply exporting the start,finish,actual start and actual
finish in a simple xcel table (no pivot).
Then I count the number of element within a certain range using array formula.
Works great.
I just flag the summary task to avoid counting them in process.

In summary:
- flag summary task
- export flag, start,finish, actual start, actual finish
- sort by flag
- use array formula to count the number of element within each range (weeks)
...done !

Again thanks,

Alfatcop,
You're welcome and thanks for the feedback.
John