Oil Cost of Service Analysis

Driver Description

The Oil Cost of Service Analysis (aka the “Page 700 Driver”) focuses on quickly displaying information from page 700 of the FERC Form 6. All data from the page is visualized in an easy-to-consume format for quick comparison and deep dives into all FERC-regulated midstream oil pipelines. 

• Industry: Oil
• Sub-Industry: Midstream
• Data Timeline: Annual
• Geography: NA

Data Sources

FERC Form 6

• Schedules 
• Annual Cost of Service Based Analysis (page 700)

Usage

The intention of the driver is to have a one-stop place to quickly analyze data from page 700. The driver will be updated as companies file data either as original or resubmissions. 

This driver works best when a single company is selected and all metrics are represented back to the year 2011. To select a company, click on the company filter dropdown at the top-left of the driver. All visualizations are a time-series, you may change the range of data with the year slider at the top of the driver. Charts or KPIs with a icon indicates that a filter is applied to it.

The “Expenses” and “Interstate Metrics” visualizations on the right-side of the driver each have their own drop-down of metrics to select from. Clicking on the dropdown and selecting a metric will filter just that visualization below it to reflect the metric. These dropdowns do not filter the metrics in other visualizations.

Exporting Visuals and Data

There are several ways in which the driver can be exported. A visual export of the driver via PDF or PowerPoint can be generated via the export button () at the top-right corner of the driver. Data can be exported via each card on the driver. To export data, move your cursor over the card/table and another export () button will appear at the top-right of the card/table. The data will export into a csv file in a long-table format. Exports will reflect the filters you select before the export.

An additional feature is the expand details icon on each card. Hovering your cursor over a card/table will show the export icon () and the expand details icon (). The expand details icon will give you a screen as seen below.

Once you click on the expand details icon, a screen will pop-up giving you a few options to interact with that particular card. You can click on the export button at the top-right of the pop-up to export the visualization either in a visual format or the data behind the visualization via CSV or Excel. Clicking the table icon at the top-right of the pop-up will show you the data feeding into the visualization.