Thanks Zoltan, especially for the 5th option. It was something I did not consider as I could not do a proper conversion from primavera to MS project without data inconsistencies previously. Now that I have figured a way to convert the file format, I could try and use the method to do so. (p6 and MS project aren't the only software whereby the files convert with data losses and inconsistencies. I also do BIM, and face problems with Revit and AECOsim.)
By the way, I can't agree more with you, p6 it is a database, not a spreadsheet. However, why is it that microsoft project has the function to allow users to hide rows but primavera does not?
In fact, there are times when I wonder why I bother trying (or wasting so much time) to satisfy the client's request so that they can present the data in a coherent and less confusing manner. Should I present the case as a professional on behalf of primavera's lack of functionality or should I take the stance that the customer is always right and try to find means to meet the requests?
Sometimes, owners and clients or rather the world only have one thing in mind, the end objective: the end which justifies the means. I am simply trying my best to find a solution, it is not that I want to use p6 as a spreadsheet or otherwise. Otherwise what sort of professional denies their client's requests without even giving a shot at the possible solutions?
Member for
16 years 3 months
Member for16 years3 months
Submitted by Zoltan Palffy on Tue, 2014-12-02 14:27
I'm afraid your approach by Excel is the only to fulfil your requirements. In the headlines for groups P6 only summarizes those activities which are currently displayed.
Thanks Raymund, show summaries is a useful function. However, I intend to present the program with specific layouts (such as critical paths, look ahead, etc.). And the show summaries only would roll up all those activities that I wish to show.
Well, I feel a strong feeling that it's going to be far less time consuming and painful doing it via copying the program to excel and hiding it using the excel filter. Then probably use conditional cell formatting to make a gantt chart with excel cells. Simply have to consider an alternative when some function isn't available.
Member for
15 years 11 months
Member for15 years11 months
Submitted by Raymund de Laza on Wed, 2014-10-15 10:02
Member for
12 years 1 monthThanks Zoltan, especially for
Thanks Zoltan, especially for the 5th option. It was something I did not consider as I could not do a proper conversion from primavera to MS project without data inconsistencies previously. Now that I have figured a way to convert the file format, I could try and use the method to do so. (p6 and MS project aren't the only software whereby the files convert with data losses and inconsistencies. I also do BIM, and face problems with Revit and AECOsim.)
By the way, I can't agree more with you, p6 it is a database, not a spreadsheet. However, why is it that microsoft project has the function to allow users to hide rows but primavera does not?
In fact, there are times when I wonder why I bother trying (or wasting so much time) to satisfy the client's request so that they can present the data in a coherent and less confusing manner. Should I present the case as a professional on behalf of primavera's lack of functionality or should I take the stance that the customer is always right and try to find means to meet the requests?
Sometimes, owners and clients or rather the world only have one thing in mind, the end objective: the end which justifies the means. I am simply trying my best to find a solution, it is not that I want to use p6 as a spreadsheet or otherwise. Otherwise what sort of professional denies their client's requests without even giving a shot at the possible solutions?
Member for
16 years 3 monthsthis is not a spreasheet its
this is not a spreasheet its a database so why are you tring to use like a spreadsheet
option 1 use filters
option 2 manually make them small
option 3 expand everything and manually collapse
option 4 take everything to excel
option 5 export it to microsoft project and hide the rows there
Member for
16 years 11 monthsExcell it, then create a
Excell it, then create a macro to hide rows
Member for
18 years 9 monthsHi Yong Shen Lim I'm afraid
Hi Yong Shen Lim
I'm afraid your approach by Excel is the only to fulfil your requirements. In the headlines for groups P6 only summarizes those activities which are currently displayed.
Regards
Dieter
Member for
12 years 1 month---
---
Member for
12 years 1 monthThanks Raymund, show
Thanks Raymund, show summaries is a useful function. However, I intend to present the program with specific layouts (such as critical paths, look ahead, etc.). And the show summaries only would roll up all those activities that I wish to show.
Well, I feel a strong feeling that it's going to be far less time consuming and painful doing it via copying the program to excel and hiding it using the excel filter. Then probably use conditional cell formatting to make a gantt chart with excel cells. Simply have to consider an alternative when some function isn't available.
Member for
15 years 11 monthsYong Shen Lim,In the Group &
Yong Shen Lim,
In the Group & Sort.. Click the "Show Summaries Only"
Hope that will help....