![]() 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. 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. For simplification, every step of the tutorial has its own Excel worksheet in the spreadsheet (see WBS-Import-P6-Tutorial.xls in Tutorials Assets). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |