Sorting Code libraries

Member for

16 years 5 months

Mike: thanks for teaching me your way of doing things.

I’m glad we both learned something new.



Best Regards.

Carlos A. Matus.

Member for

19 years 10 months

Hi Carlos



Thanks for teaching me something new.



I have never had to use that facility before.



Best regards



Mike Testro.

Member for

16 years 5 months

Thanks for the replies Mike!



I found another way to make it:

tools > options... > view > sort code libraries.



The default is "by name", I choose "By sort order", then fill the sort order field in the library explorer. That gets me to the same sort order as P3’s



I could not get the view the way you suggested, maybe I did not explain clearly what I was trying to do.



Thanks for the help.



Regards.

Member for

19 years 10 months

Hi Carlos



You do not copy paste the code library - you copy paste the task descriptions.



Then add the line numbers from P3 and do a =vlookup on the Powerproject side.



You will find the User Field Manager under the Tools drop down.



Save the file first and make sure that you set the User Level under the Help Drop Down to Advanced.



Best regards



Mike Testro

Member for

16 years 5 months

Thanks Mike.



This may sound stupid but I don’t seem to find how to copy/paste code library definitions from PP. While I investigate it, can you explain me how do I sort the grouping according to a field?



I’m trying to achieve the exact same sort order in PP that I use in Primavera. Why? Because thet will help me learn how to configure the views in any way that is needed. That will also show me the limits and differences between PP and P3.



I think I need to explain it better what i’m trying to achieve. The next image is the contractual view in P3:

http://www.flickr.com/photos/8317996@N03/3962193329/sizes/o/

in P3, Headings are grouped according to the activity code Value, descending.



This is the view I’m getting in Power Project:

http://www.flickr.com/photos/8317996@N03/3962194661/sizes/l/

Member for

19 years 10 months

Hi Carlos



One simple way would be to set up a spreadsheet



Copy and paste the P3 descriptions in column A and a list of numbers representing the line numbers of the P3 programme in Columnn B.



In column C copy paste your PowerProject descriptions and in column D do a =vlookup formula to align the P3 line number to PwerProjct descriptions.



In powerprojec set up a user field column and copy paste the line numbers into it.



Then sort ascending on the user field.



Save the view as P3 Sort.



Best regards



Mike Testro