Introduction In my previous tutorial in this series, I described the procedure to export resource assignment data from P6 to Excel. Most of us have worked with Excel charts in our job or during our study in college or university. What we all know is that they are really helpful when you want to demonstrate some [...]

Introduction As you know Primavera P6 has a lack of graphical features so often we schedulers need to export everything to other software packages (mostly Excel) to produce an understandable schedule and graphs. I always had a problem exporting resource related data to Excel with the standard exporting feature on P6 until I found  this way to use the [...]

Tutorial Files Excel Spreadsheet (Excel 2007+): PTuts_Project_Dashboard.xlsm – 1.5Mb One of our previous site manager told us (the project control team), that if we bring to him another report that have more than 1 page, he will just throw it away (sic), actually managers care only about the big picture, and don’t bother reviewing every [...]

Tutorial Files Excel Spreadsheet (Excel 2007+): PlannerTuts_BOQ_Pay_Item.xlsx P6 Schedule and BOQ challenges A contract’s Bill of Quantities is always meant to be more details then the schedule, at least in theory. In many cases,  the planner and the estimator are not working in perfect coordination and you may end with two different level of details [...]

This tutorial will walk you through a process to remove resource costs from XERs exported from Primavera P6.  This comes in very handy if you are sending project schedules to general contractors but want to hide cost information from them (or anyone else for that matter). Tutorial Files Complete this tutorial by downloading the following [...]

  Many P6 users have trouble importing data from Excel.  Many of the problems are focused on importing costs or other numeric data fields that have been manually typed into Excel. Why can’t I import Primavera P6 cost data from Excel? Primavera P6 only imports data that is formatted as “Text” in Excel.  If you [...]

Primavera users are also Excel users.  As many of you know, Microsoft Excel has many useful functions in different areas such as Financial, Date & Time, Math & Trig and so on. One of these areas is Look up & Reference. The functions in this area are dealt with lists, indexes and arrays and help [...]

  Occasionally we revisit some of our reader’s favourite posts from the annals of the PlannerTuts tutorial library, and today we’re revisiting a topic that is always hot – importing updates from excel.  This video tutorial was first published on September 30th, 2011 and was very popular.  Let’s take a look! Often large projects demand [...]

In this tutorial we explain how to import a WBS dictionary in Primavera P6 without the SDK.   NOTE: The steps needed to transform a classical WBS presentation (which is WBS Path and Description) to a format understood by the database (which is parent / child) is covered in Steps 1 to 6 of this [...]

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 [...]