(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.
Sometimes it is useful to copy and paste schedule information from Primavera P6 to excel in wbs format.
Howerver, whenever you paste information from P6 into excel the color fomatting and the ability to group by wbs doe snot carry over.
There is an excel wbs add in utility that can color your wbs and add the ability to exapnd and or collapse the wbs and inforamtion.
This is a handy utility so that other people who do not have Primavera P6 or who do not know how to use P6 can use excel to view schedule information in a wbs format coloring and grouping similiar to P6.
Here is a link to the excel add-in uility.
https://planlamamuhendisi.com/wbs-organizer.html
Printer-friendly version
Send to friend
Hello Zoltan,
I'm using this formula to count the number of spaces at the beginning of each lines.
Then I use conditionnal formatting to color the lines based on the number of spaces.
The formula is unfortunately in french, hope this helps though.
=TROUVE(GAUCHE(SUPPRESPACE(D10),1),D10)-1
The English version should be:
=find(left(trim(D10),1),D10)-1
Regards, Jean
Thank you Zoltan.
I usually have a spreadsheet ready with a formula (that trims and detects the WBS level/activity) and conditionnal formatting that colors the WBS rows using P6 default color pallette. But a plugin would help to automate things better.
Email: PPadmin@planningplanet.com
Hello Zoltan,
I'm using this formula to count the number of spaces at the beginning of each lines.
Then I use conditionnal formatting to color the lines based on the number of spaces.
The formula is unfortunately in french, hope this helps though.
=TROUVE(GAUCHE(SUPPRESPACE(D10),1),D10)-1
The English version should be:
=find(left(trim(D10),1),D10)-1
Regards, Jean