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
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
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.