Easier still try this, it eliminates the need to export to excel.
For the activity count, select a new column, go to the number of activities and select activity count. Position it where you wish. This will count activities within your WBS and roll up giving a total number of activities for your project.
For the relationships, an easy way is to select your schedule log after a schedule. this will tell you all sorts of information regarding the status of your project. Within this is the total number of activities, as well as the total number of relationships you currently have. Also it gives you useful general information & warnings about your project.
Hope this helps you. It eliminates the need to export anything and is just a few clicks of the mouse away.
Member for
16 years 3 months2 optionsoption #1press F9
2 options
option #1
press F9 and look at the log file
option #2
file
export
excel xls
relationships only
count formula in excel
Member for
13 years 5 months@ Richards Watt,AD-02 report
@ Richards Watt,
AD-02 report does not give you a total count of number of relationships.
Member for
13 years 5 months@ Richards Watt,AD-02 report
@ Richards Watt,
AD-02 report does not give you a total count of number of relationships.
Member for
20 yearsRE: Count of Activities and Relationships in Version 5.0
For the activity count use column "Activity Count" on "Number of Activities"
For the relationships u can use a Global Report called "AD-02 Activity Relationships"
Regards.
Member for
19 years 11 monthsRE: Count of Activities and Relationships in Version 5.0
Easier still try this, it eliminates the need to export to excel.
For the activity count, select a new column, go to the number of activities and select activity count. Position it where you wish. This will count activities within your WBS and roll up giving a total number of activities for your project.
For the relationships, an easy way is to select your schedule log after a schedule. this will tell you all sorts of information regarding the status of your project. Within this is the total number of activities, as well as the total number of relationships you currently have. Also it gives you useful general information & warnings about your project.
Hope this helps you. It eliminates the need to export anything and is just a few clicks of the mouse away.
Regards,
Richard
Member for
20 years 2 monthsRE: Count of Activities and Relationships in Version 5.0
Thanks Mounir. I shall try this. Thanks, Amar
Member for
19 years 7 monthsRE: Count of Activities and Relationships in Version 5.0
Hi Amar,
For the total no. of activities:
U can use a built-in report (eg.SR-18 Schedule Report - Sorted by Activity ID), this report will show u the list of activities in ur schedule.
Export this to excel and count them.
For the total no. of relationships:
U can use a built-in report (eg.SR-06 Schedule Report - Predecessors & Successors), this report will show u a list of relationships in ur schedule.
Export this to excel and count them.
Regards.