Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Count of Activities and Relationships in Version 5.0

7 replies [Last post]
Mon, 2006-10-30 01:15
Amar Aghana
User offline. Last seen 16 years 37 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 103
Groups: Petro-Chem / Oil & Gas
Freiends, How to get the Count of Total Activities and Total Relationships in Version 5.0? Thanks, Amar
Top

Replies

Tue, 2018-02-13 14:45
#1
Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

2 options

option #1

press F9 and look at the log file 

option #2

file

export 

excel xls

relationships only 

count formula in excel

Top
Mon, 2018-02-12 21:32
#2
Sayed Elyas Kawish
User offline. Last seen 6 years 10 weeks ago. Offline
Joined: 14 May 2012
Posts: 7
Groups: None

@ Richards Watt,

AD-02 report does not give you a total count of number of relationships.

Top
Mon, 2018-02-12 21:32
#3
Sayed Elyas Kawish
User offline. Last seen 6 years 10 weeks ago. Offline
Joined: 14 May 2012
Posts: 7
Groups: None

@ Richards Watt,

AD-02 report does not give you a total count of number of relationships.

Top
Sat, 2006-11-04 17:50
#4
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
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.
Top
Mon, 2006-10-30 21:57
#5
Richard Watts
User offline. Last seen 17 years 13 weeks ago. Offline
Joined: 2 Dec 2005
Posts: 3
Groups: None
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
Top
Mon, 2006-10-30 05:36
#6
Amar Aghana
User offline. Last seen 16 years 37 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 103
Groups: Petro-Chem / Oil & Gas
Thanks Mounir. I shall try this. Thanks, Amar
Top
Mon, 2006-10-30 03:07
#7
Karim Mounir
User offline. Last seen 9 years 37 weeks ago. Offline
Joined: 5 Apr 2006
Posts: 314
Groups: None
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.
Top