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.

Activity status in Spider

3 replies [Last post]
Evgeny Z.
User offline. Last seen 51 weeks 1 day ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None

Dear all,

I just noticed, that there is no such activity field as activity status in Spider. Such field is normally available in other tools.

E.g: In MS Project:

·         Complete

·         Future Task

·         On schedule

·         Late

 In Primavera

·         Not Started

·         In Progress

·         Complete

I am sure, there is a reason for it, but just wondering how Spider deals with the absence of activity status.

E.g, how would I filter activities, which are “in progress ” ?


Evgeny Z.
User offline. Last seen 51 weeks 1 day ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None

Vladimir, Rafael,

OK, thanks. Understatood. One needs to look at the presence of Actual Start and Actual finish.

Activity in progress has Actual Start, Actual Duration, Actual Volume. It does not have Actual Finish and its Remaining Duration and Remaining Volume are positive.

You may select which combination of conditions to use for filtering Activity Gantt Chart or Activity Table to get all in progress activities.

Not started activity does not have Actual Start.

Complete Activities have Actual Finish.

On schedule and Late activities can be determined and filtered after comparison of the curent version with the baseline or any other project version. Spider Project shows the difference of any data. And looking at the differences you will not only see if an activity is on schedule or late but also if activity duration was larger or smaller than expected, if activity cost was larger or smaller, etc. The data deviations between any two versions will be calculated and shown.

Rafael showed what to do if you need such fields.

Rafael Davila
User offline. Last seen 1 week 4 days ago. Offline
Joined: 1 Mar 2004
Posts: 5230

Just use a user defined field and a simple formula.  

If you want to get the statistics just export Activity Table from Activity Gantt to Excel and use COUNTIF formula.  You can add these statistics to the Statistics Report Document with simple copy-paste.

 photo Status04_zpsrkjvvc5d.jpg

 photo Status01_zpshbxyvspy.png


Status02 photo Status02_zpszz8ueo1v.png

 photo Status3_zpsxrd3wx8h.png