[email protected] +1.303.779.0344

Midstream Project Portfolio

This Midstream Project Portfolio, summarized in OnePager Pro for Microsoft Project, shows multiple timelines--each representing parallel phases for several midstream energy projects.

Each midstream project timeline shows acquisition, closing, design, regulatory review, construction, go-live preparation, and launch of the pipeline or transportation system.


Download Midstream Project Portfolio as PDF      Download Midstream Project Portfolio as Image

OnePager Midstream Project Portfolio Features

This Midstream Project Portfolio includes:

  • Import of multiple project plans into a single set of timelines.
  • Alignment of standard midstream project phases into a single row to show the progression of activities at each site
  • Grouping of sites into overall projects.
  • Assignment of distinct colors to each standard phase of the project (acquisition, closing, design, regulatory review, construction, go-live preparation, and launch).
  • Inclusion of a legend to help people quickly identify parallel activities.

This Midstream Project Portfolio was created using OnePager, project management software which can import multiple project plans from Microsoft Project, Project Server/Online, Primavera P6, or Smartsheet into a single report.

To learn more about OnePager, and see how it can help you with your management of midstream projects, get started today by downloading a free trial.

15-Day
Free Trial

Sample Files

This midstream project portfolio was built using the following files, which you can download if you'd like to create something similar:

Excel Samples

Midstream Project Portfolio.xlsx (Excel Plan)

Midstream Project Portfolio (Excel).tat (OnePager Template for Excel)


Excel Instructions

To build a Midstream Project Portfolio like the example above, follow these instructions:

  1. Download the set of sample files from above. The Excel file contains the actual project schedule, and the matching OnePager template file has all of the settings that will format the chart like the example above. Save both the project plan and the template file to your desktop.

  2. Open the Excel file.

  3. Once the Excel file is open, go to Add-Ins and click the OnePager button.

  4. When the start screen appears click NEW to build a new chart.

  5. With the Excel file ready for import, we need to change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains all of the data-driven formatting (colors, layout, etc.) that give this project portfolio its specific look.

  6. With the template loaded, click on Create New Chart to build your chart. It should closely match the example at the top of this article.
15-Day
Free Trial

Microsoft Project Samples

Midstream Project Portfolio.mpp (Microsoft Project Plan)

Midstream Project Portfolio (Project).tat (OnePager Template for Microsoft Project)


Microsoft Project Instructions

To build a Midstream Project Portfolio like the example above, follow these instructions:

  1. Download the sample files listed above. The Microsoft Project file contains the project schedule, and the matching OnePager template file has most of the settings that drive the look and feel of the Gantt chart based on the data from Microsoft Project. Save both files to your desktop.

  2. Open the Microsoft Project plan.

  3. Once the project plan is open, go to Add-Ins and click the OnePager button.

  4. When the start screen appears, click NEW to build a new chart.

  5. Change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains most of the data-driven formatting (colors, layout, etc.) that give this project portfolio its specific look.

  6. With the template loaded, click on Create New Chart to build your chart. It should closely resemble the example at the top of this article.

15-Day
Free Trial

Primavera P6 Samples

Midstream Project Portfolio.xml (Primavera P6 Plan)

Midstream Project Portfolio (Primavera).tat (OnePager Template for Primavera P6)


Primavera P6 Instructions

To build a midstream project portfolio like the example above, follow these instructions:

  1. Download the set of sample files from above. The XML file contains the actual project schedule from Primavera P6, and the matching OnePager template file has all of the settings that will format the chart like the example above. Save both the project plan and the template file to your desktop.

  2. Click the OnePager icon on your desktop.

  3. When the start screen appears, click NEW to build a new chart.

  4. Go to Select > BROWSE Primavera P6 Files, and then point OnePager to the Primavera P6 XML file that you downloaded from above.

  5. With the Primavera P6 file ready for import, we need to change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains all of the data-driven formatting (colors, layout, etc.) that give this project portfolio its specific look.

  6. With the template loaded, click on Create New Chart to build your chart. It should closely match the example at the top of this article.

  7. If you'd like to modify our example Primavera P6 project, you can import the XML file into your own Primavera P6 environment by going to File > Import and choosing the Primavera P6 - (XML) option.

15-Day
Free Trial

Smartsheet Samples

Midstream Project Portfolio (Smartsheet).xlsx (Excel for import into Smartsheet)

Midstream Project Portfolio (Smartsheet).tat (OnePager Template for Smartsheet)


Smartsheet Instructions

To build a midstream project portfolio like the example above, follow these instructions:

  1. Download the sample files above. The Excel file contains all of the key milestones, and will be imported into your Smartsheet account, while the OnePager template will help define the layout of the timeline itself. Save both files to your desktop.

  2. To import the Excel file into Smartsheet, first log into your Smartsheet account.

  3. In Smartsheet, click on + Solution Center, and then on the Import screen, choose Microsoft Excel:

    Import from Excel into Smartsheet

  4. Point Smartsheet to the Excel file that you downloaded above and press Continue. On the Import Settings, review the name of your sheet, and then click Import::

    Finish importing from Excel into Smartsheet

  5. Now that the sample project has been imported into your Smartsheet account, go to your desktop, and click the OnePager button.

  6. On the OnePager start screen, click NEW to build a new timeline.

  7. Go to Select > BROWSE Smartsheet, log into your Smartsheet account, and then point OnePager to the example project.

  8. We need to change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains all of the data-driven formatting (styles, layout, etc.) that make the timeline look the way that it does.

  9. Once the custom OnePager template is selected, click on Create New Chart to build your timeline. It should look similar to the example at the top of this article.

15-Day
Free Trial