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 |