Download The Primaver P6 Users Guide to Excel PDF

TitleThe Primaver P6 Users Guide to Excel
TagsDatabases Spreadsheet Microsoft Excel Information Technology Management Array Data Structure
File Size1.7 MB
Total Pages44
Document Text Contents
Page 2

https://www.facebook.com/PlannerTuts
https://twitter.com/plannertuts
https://www.linkedin.com/company/planner-tutorials-hub

Page 22

22






CHAPTER FOUR

HOW TO IMPORT WBS FROM

EXCEL TO PRIMAVERA P6

USING THE SDK

https://www.facebook.com/PlannerTuts
https://twitter.com/plannertuts
https://www.linkedin.com/company/planner-tutorials-hub

Page 23

23





In this tutorial we explain how to use the

Oracle Primavera P6 SDK to import a WBS

from Excel to Primavera P6. We are using

the WBS.xls P6 SDK spreadsheet made

available by Oracle Support. The SDK is a

very handy tool, but the data must exactly

respect the required format, we used

a sample WBS and a step-by-step guide to

prepare the data to be imported. We

assume you already have the Primavera

SDK installed.



Tutorial Assets

The following assets were used during the

production of this tutorial.

 WBS-Import-P6-Tutorial.xls

 WBS.xls

Step 1 – Copy the WBS from to Excel

For simplification, every step of the

tutorial has its own Excel

worksheet in the spreadsheet (see

WBS-Import-P6-Tutorial.xls in

Tutorials Assets). I’ve numbered each

worksheet appropriately.



For this tutorial, we’re using a sample

WBS from this site. We’ve already

cleaned-up and pasted it for you into

the WBS-Import-P6-Tutorial.xls on

Worksheet 1.

I have modified the original WBS to

add a root node (SAMPLE – the first

entry in the WBS list) as the project

name.





http://www.plannertuts.com/wp-content/uploads/2012/01/WBS-Import-P6-Tutorial.xls
http://www.plannertuts.com/wp-content/uploads/2012/01/WBS.xls
http://www.toolboxforplanning.com/2010/11/sample-wbs-for-oilgas-and-petrochemical.html

Similer Documents