Report
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Dear Moutaz,
You can also easily do 2 and 3 in MSP.
Ref. 2) Introduce e.g. a "Number 1"-column with a customized field containing an iff-equation asking where Total Slack equals zero (critical task). If so, it should be "1" otherwise "0". For the summaries you will then just put it to roll up with a sum function. In total 2-3 min. work. You will now get a count of all you critical task within each summary and also a total for the overall project assuming you have an overall summary bar for the project.
Ref. 3) Similar introduce a "Number 2" column again with a iif-equation asking where "Constraint Type" differs from zero, where zero represents "As Soon As Possible". If differs then "1" otherwise "0". Again do a roll up with a sum function. Same result as above.
The different constraints types in MSP is represented by a number, e.g. ASAP equals "0" whereas SNET is represented by the value "4" and FNET equals "6".
The above takes in total 5 min, so no need to import to Excel or use Primavera in this case, unless I have misunderstood your question.
Regards,
Bo
Dear Alexandre,
thanks for your reply, for all the three requirements, I export it to excel and used count formula but I did not use the filter for no.1, I used excel and used count blank.
so, Primavera is more powerful in this case.
Regards,
Moutaz
yâ sahbi moutaz,
I am afraid you will not be able to obtain all these informations in one report only.
1. Open end activities : create a filter that says
Summary = No AND Successor = (keep the lats column empty)
2. Nbr of critical tasks : I would export critical tasks to Excel and then count them
3. Nbr of constraints : same as 2.
3la kheir,
Alexandre