![primavera p6 tutorial in urdu primavera p6 tutorial in urdu](https://i0.wp.com/109079-310408-raikfcquaxqncofqfm.stackpathdns.com/wp-content/uploads/2011/09/Primavera-P6-Projects-EPS.png)
We’ll then clean things up afterwards.Ĭopy the green-L2 data again and this time paste it to the bottom of the data in the Parent column on Worksheet 4Ĭopy the green-元 data and paste it to the bottom of the Child column on Worksheet 4Ĭopy the green-元 data again and this paste it to the bottom of the Parent columnĬopy the green-L4 data and paste it to the bottom of the Child columnĬopy the green-L4 data again and this paste it to the bottom of the Parent columnĬopy the green-L5 data and paste it to the bottom of the Child columnĮssentially the column data should be combined like this:Īctually that’s the most important step in this tutorial, in order for the SDK (a relational database) to understand the structure of the WBS this one must be presented as Parent and children table.Ĭopy the columns Parent and Child from Worksheet 4, and paste them to Worksheet 5. The next steps might seem unintuitive, but they are important to follow correctly. Copy the green-L2 data and paste it to theChild column on Worksheet 4. Start by copying the data under green-L1 and pasting it to the Parent column on Worksheet 4. We’re going to combine all of the green L-columns now on Worksheet 4. Step 4 – Organize the WBS by Parent & Child The green L-columns contain some text formulas that will recombine part of the WBS Path to build parent and children fields that we’ll need for the import. I have just added it to show that we can determine the level of each WBS by counting how many times the separator (or the delimiter) is repeated. The Level column on Worksheet 3 is not needed for this tutorial. If you have more levels, just adjust the spreadsheet to add them in.
#Primavera p6 tutorial in urdu code
Make sure to format the columns as Text (if your code is 01, Excel will keep it 01 as text, otherwise it will change to 1.Ĭopy the new split columns to “Worksheet 3″ and paste each under the appropriate L1, L2, 元, L4 or L5 heading (use the yellow L columns, not the green ones). When the wizard screen comes up, select Delimited, and click Next. Highlight the WBS Code column, and click on Text to Columns. We will use the Text to Columns function on the Excel Data tab (Excel 2010), it a very easy tool to split one column by delimiters into multiple columns. Step 2 – Split the WBS Path into Distinct LevelsĬopy the column WBS Code from “Worksheet 1″ to “Worksheet 2″ in Excel. I have modified the original WBS to add a root node (SAMPLE – the first entry in the WBS list) as the project name. We’ve already cleaned-up and pasted it for you into the WBS-Import-P6-Tutorial.xls on Worksheet 1. I’ve numbered each worksheet appropriately.įor this tutorial, we’re using a sample WBS from this site.
![primavera p6 tutorial in urdu primavera p6 tutorial in urdu](https://i.ytimg.com/vi/166TDVEw6NA/hqdefault.jpg)
For simplification, every step of the tutorial has its own Excel worksheet in the spreadsheet (see WBS-Import-P6-Tutorial.xls in Tutorials Assets).