Translating an Excel list into a P6 schedule is notoriously tedious. Here is how to bypass the structural headaches and save hours of manual entry.
The Traditional Struggle
Often, we receive data from the project team in an Excel file that must be captured as a WBS and/or Activity into the schedule. Traditional methods, manual entry, using P6 export/import functions, modifying XER files in Notepad, or clunky Excel macros, require immense effort. The Planner must carefully ensure IDs are not duplicated, verify the WBS structure is correct, and perform tedious formatting checks just to get the data loaded.
The SAT Advantage
The Scheduling Assistance Tool (SAT) makes this process incredibly easy, requiring the planner to simply copy and paste the data from another Excel file. SAT automatically creates the IDs and exports them to P6 with the exact same structure in which the data was pasted.
Need to add a new WBS or Activity? Simply insert rows, add the name, and export to P6.
How to develop a large Schedule?
Watch the video below to see how SAT makes the development of large schedules significantly faster and much less tedious.
Discussion
No comments yet. Be the first to share an insight.
Leave a Comment