sales@onepager.com +1.303.779.0344

Creating Primavera Timelines using Excel and OnePager Express

How to create project timelines and reports from Primavera P6 project plans

Do you use Oracle Primavera P6 to build and track project schedules? Do you need create reports on your P6 project plan in a timeline or Gantt chart without redrawing everything by hand in PowerPoint or Visio?

OnePager Express from Chronicle Graphics can import your Primavera P6 project plan and create rich, dynamic timelines and project reports in no time at all. To follow along, you can download a 15-day free trial of OnePager Express to see how it works.

Here's how to get started:

  1. Open your project plan in Primavera P6, as shown below. The default Gantt chart in Primavera P6 is difficult to read, and doesn't do a good job of summarizing your project plan:
    Oracle Primavera P6 project plan, complete with the standard timeline.
  2. Export your Primavera P6 project schedule to Excel. OnePager Express will be able to import your project plan once it is converted to an Excel format.
    Export from Primavera P6 into an Excel format.
  3. Primavera P6 gives you lots of options when you export to Excel. OnePager Express is pretty flexible, and can work with whatever data you decide to export from P6. We recommend exporting "Activity ID," "Activity Name," "Start" and "Finish," but in the example below, you'll see that you can include additional information from your P6 project plan as well:
    Set an export template to pull relevant columns from your Primavera P6 project into your project timeline. In this case, we created a "OnePager Express" template to use with future Primavera P6 exports.
  4. Once you have exported your P6 plan, your Excel spreadsheet will look similar to the one shown below. This spreadsheet has been formatted a little to make it easier to read, but the default Primavera P6 export will work fine, too:
    Excel export from Oracle Primavera P6. Note that we've added a column called "Show It" which allows you to filter your project plan. This allows you to display only a portion of your project plan that is relevant to your audience. You can add this filter in Excel, or in P6 itself, if you want to keep track of the filter in Primavera.
  5. Next, double-click the OnePager Express icon on your desktop. From the Start screen that appears, choose New. Choose your Excel spreadsheet as the source file for your timeline. This will launch the easy import wizard:
    The redesigned OnePager Express import wizard makes it easy to take a Primavera P6 project and build a full-color project timeline. OnePager Express gives you the ability to give your project report a name, and to specify a snapshot or status date. As you update your Primavera P6 plan in future weeks or months, you can update your OnePager Express chart with a new snapshot of your project.
  6. The next page of the wizard will let you choose which columns from Primavera P6 you would like to use in your OnePager Express timeline:
    Map your Primavera P6 columns into OnePager Express to create a data-driven timeline.
  7. Finally, click the Create new project view button, and OnePager Express will create a dynamic project timeline based on the data you exported from Primavera P6:
    Primavera P6 scheduling timelines: This project timeline was created with OnePager Express software based on a project plan from Oracle Primavera P6. Now, you can copy and paste your timeline into PowerPoint, or make edits to the layout of your report. You can also update your timeline to reflect changes that take place in your Primavera P6 project over time.

OnePager Express is the easiest way to summarize or present a Primavera P6 project in a simple timeline view. Because OnePager Express is a data-driven application, there are endless possibilities as to the types of timelines you can create from your Primavera P6 project plan.

Get started today by downloading a free trial or attending one of our demonstration webinars.

15-Day
Free Trial