Adding Products to List in Report Parameters

<< Click to Display Table of Contents >>

Navigation:  Running Reports > Report Tables >

Adding Products to List in Report Parameters

Navigation: Running Reports > Report Tables >

hm_btn_navigate_prevhm_btn_navigate_tophm_btn_navigate_next

Show/Hide Hidden Text

Certain reports in PHDwin allow users to specify which products to display on the report. For example, after running a Detailed Report, go to the Parameters Pane, on the Detailed Type, instead of Standard, select the "3 Volume Report" and select three products to display their volumes and revenue. The drop-down menus contain a set of default products, but can be customized to include any products.

Report - Add products

html toggle_plus1 To Add a Custom Product that Will Show Up in the User-defined Report Parameters

1.Go to the Reports Ribbon and click on Report Tables.

2.Find the table named UserDefinedCaseEco.

3.Use the Plus button button to the right of the report table name to add 3 new columns.  The name of the columns are very important. They should be called GrossProdname, NetProdname, and CoNetRevProdname; where Prodname is replaced with the exact name of the product selected under the Product column. For example, to add a new product named "Methane" it would look like the image below:

 

Report - Custom product on report table

 

4.In the Product column, choose the name of the product that has been added.

5.In the Stream and Ownership column, set them up as in the image above.

For GrossProdname, the stream should be Base Value, the ownership should be Gross

NetProdname the stream should Shrunk Volume, the ownership should be Net

CoNetRevProdname the stream should be set to Revenue, the ownership should be Net

6.Once the product has been added, Save the report table and run the report as normal to see the custom products just added.

html toggle_plus1 Report Parameter Definitions

FieldName

Technical Name

Definition

Unit

Product

Stream

Ownership

Notes

GrossGas

Gross Gas

Gross Gas is the total production volume of Gas prior to Shrinkage

MMcf

Gas

Base Value

Gross

Changes Based on Convention

GrossOil

Gross Oil

Gross Oil is the total production volume of Oil prior to Shrinkage

Mbbl

Oil

Base Value

Gross

Changes Based on Convention

NetGas

Net Gas

Net Gas is the Shrunk volume * RI (revenue interest shrunk volume)

MMcf

Gas

Shrunk Volume

Net

Changes Based on Convention

NetOil

Net Oil

Net Oil is the Shrunk volume * RI (revenue interest shrunk volume)

Mbbl

Oil

Shrunk Volume

Net

Changes Based on Convention

CoNetRevGas

Company Net Revenue Gas

NetGas*price; in USA this is the same as GrossRevGas

M$

Gas

Revenue

Net

Changes Based on Currency

CoNetRevOil

Company Net Revenue Oil

NetOil*price; in USA this is the same as GrossRevOil

M$

Oil

Revenue

Net

Changes Based on Currency

NetProdTax

Net Production Tax

Net Severance Tax for all products

M$

All

Production Tax

Net

Changes Based on Currency

NetLocalTax

Net Local Tax

Net Local Tax, also known as Ad Valorem Tax

M$

All

Local Tax

Net

Changes Based on Currency

NetInv

Net Investment

Net Investment is the total investment costs, including capital and abandonment, among other one-time expenses

M$

NetInv

Base Value

Gross

Changes Based on Currency

NDCash

Non-Discounted Cash Flow

Non-discounted cashflow (net income). Revenue minus expenses before discounting

M$

NDCash

Base Value

Gross

Changes Based on Currency

Dcash

Discounted Cash Flow

Estimates the value of an investment based on its expected future cash flows

M$

Dcash

Base Value

Gross

Changes Based on Currency

DryGas

Dry Gas

Shrunk Gas Volume

MMcf

Gas

Shrunk Volume

Gross

Changes Based on Convention

CoWIGas

Company Working Interest Gas

Working Interest volume for Gas

MMcf

Gas

Shrunk Volume

CoWI

Changes Based on Convention

GrossRevGas

Gross Revenue Gas

Company revenue before all burdens; in USA, NetGas*price

M$

Gas

Revenue

Gross

Changes Based on Currency

CoWIRevGas

Company Working Interest Revenue Gas

CoWIGas*price; in USA, this is NOT the same as GrossRevGas

M$

Gas

Revenue

CoWI

Changes Based on Currency

CoWIOil

Company Working Interest Oil

Working Interest volume for Oil

Mbbl

Oil

Shrunk Volume

CoWI

Changes Based on Convention

GrossRevOil

Gross Revenue Oil

Company revenue before all burdens; in USA, NetOil*price

M$

Oil

Revenue

Gross

Changes Based on Currency

CoWIRevOil

Company Working Interest Revenue Oil

CoWIOil*price; in USA, this is NOT the same as GrossRevOil

M$

Oil

Revenue

CoWI

Changes Based on Currency

GrossNGL

Gross NGL

Gross NGL is the total production volume of NGL prior to Shrinkage

Mgal

NGL

Base Value

Gross

Changes Based on Convention

CoWINGL

Company Working Interest NGL

Working Interest volume for NGL

Mgal

NGL

Shrunk Volume

CoWI

Changes Based on Convention

NetNGL

Net NGL

NGL Shrunk volume * RI (revenue interest shrunk volume)

Mgal

NGL

Shrunk Volume

Net

Changes Based on Convention

GrossRevNGL

Gross Revenue NGL

Company revenue before all burdens; in USA, NetNGL*price

M$

NGL

Revenue

Gross

Changes Based on Currency

CoWIRevNGL

Company Working Interest Revenue NGL

CoWINGL*price; in USA, this is NOT the same as GrossRevGas

M$

NGL

Revenue

CoWI

Changes Based on Currency

CoNetRevNGL

Company Net Revenue NGL

NetNGL*price; in USA this is the same as GrossRevNGL

M$

NGL

Revenue

Net

Changes Based on Currency

GrossCond

Gas Condensate

Gross Condensate is the total production volume of Condensate prior to Shrinkage

Mbbl

Condensate

Base Value

Gross

Changes Based on Convention

CoWICond

Company Working Interest Condensate

Working Interest volume for Condensate

Mbbl

Condensate

Shrunk Volume

CoWi

Changes Based on Convention

NetCond

Net Condensate

Condensate Shrunk volume * RI (revenue interest shrunk volume)

Mbbl

Condensate

Shrunk Volume

Net

Changes Based on Convention

GrossRevCond

Gross Revenue Condensate

Company revenue before all burdens; in USA, NetCond*price

Mbbl

Condensate

Revenue

Gross

Changes Based on Currency

CoWIRevCond

Company Working Interest Revenue Condensate

CoWICond*price; in USA, this is NOT the same as GrossRevGas

M$

Condensate

Revenue

CoWi

Changes Based on Currency

TotalWells

Total Wells

Number of total well count

#

Total Wells

Base Value

Gross

 

WellCost

Well Cost

$/well expense

M$

Total Wells

Well Cost

Gross

Changes Based on Currency

NetOpCost

Net Operational Cost

$/unit based costs applied to the Shrunk Volumes and adjusted by the Working Interest

M$

All

Op Cost

Net

Changes Based on Currency

NetFixedCost

Net Fixed Cost

$/case based costs applied to the Shrunk Volumes and adjusted by the Working Interest

M$

All

Fixed Cost

Net

Changes Based on Currency

NetTransCost

Net Transportation Cost

$/unit based costs applied to the Shrunk Volumes and adjusted by the Revenue Interest

M$

All

Trans Cost

Net

Changes Based on Currency

NetOtherCost

Net Other Cost

$/unit based costs applied to the Shrunk Volumes and adjusted by the Working Interest

M$

All

Other Cost

Net

Changes Based on Currency

ProdTaxGas

Gas Production Tax

Net Severance Tax for Gas

M$

Gas

Production Tax

Net

Changes Based on Currency

ProdTaxOil

Oil Production Tax

Net Severance Tax for Oil

M$

Oil

Production Tax

Net

Changes Based on Currency

NetProfit

Net Profit

NetProfitRevenue - NetProfitExpense. Negative values are net profits expenses. Positive values are net profits revenue.  Note: All net profits values are dependent on the interest entered.

M$

All

Base Value

Net

Changes Based on Currency

ProdTaxCond

Condensate Production Tax

Net Severance Tax for Condensate

M$

Condensate

Production Tax

Net

Changes Based on Currency

Expensed

Expensed

Summary of all after-tax treatment of expenses pertaining to Depreciation and Depletion

M$

Expensed

Base Value

Gross

Changes Based on Currency

IncomeTax

Income Tax

Taxes levied on business profits, Taxable Income * Revenue Interest

M$

IncomeTax

Base Value

Gross

Changes Based on Currency

TaxableIncome

Taxable Income

Income less deductions

M$

TaxableIncome

Base Value

Gross

Changes Based on Currency

Depreciation

Depreciation

Depreciation based on gross volume

M$

Depreciation

Base Value

Gross

Changes Based on Currency

NetOperatingLoss

Net Operating Loss

Identifies when a there is a negative tax due to deductions being higher than taxable income or if the tax rolls forward to future years

M$

NetOperatingLoss

Base Value

Gross

Changes Based on Currency

CumDepr

Cumulative Depreciation

The total amount of a company's cost that has been allocated to depreciation expense since the asset was put into use.

M$

CumDepr

Base Value

Gross

Changes Based on Currency

AllNetRoyalty

All Net Royalty

Total royalty of all streams

M$

All

Revenue

ORRI

Changes Based on Currency

RoyRevCond

Royalty Revenue Condensate

Royalty Revenue Interest of shrunk production for Condensate

M$

Condensate

Revenue

ORRI

Changes Based on Currency

RoyRevNGL

Royalty Revenue NGL

Royalty Revenue Interest of shrunk production for NGL

M$

NGL

Revenue

ORRI

Changes Based on Currency

RoyRevOil

Royalty Revenue Oil

Royalty Revenue Interest of shrunk production for Oil

M$

Oil

Revenue

ORRI

Changes Based on Currency

RoyRevGas

Royalty Revenue Gas

Royalty Revenue Interest of shrunk production for Gas

M$

Gas

Revenue

ORRI

Changes Based on Currency

CoNetRevSulfur

Company Net Revenue Sulfur

Working Interest Net Revenue of shrunk production for Sulfur

M$

Sulfur

Revenue

Net

Changes Based on Currency

CoNetRevPentanePlus

Company Net Revenue Pentane Plus

Working Interest Net Revenue of shrunk production for Pentane

M$

Pentane

Revenue

Net

Changes Based on Currency

CoNetRevButane

Company Net Revenue Butane

Working Interest Net Revenue of shrunk production for Butane

M$

Butane

Revenue

Net

Changes Based on Currency

CoNetRevPropane

Company Net Revenue Propane

Working Interest Net Revenue of shrunk production for Propane

M$

Propane

Revenue

Net

Changes Based on Currency

CoNetRevEthane

Company Net Revenue Ethane

Working Interest Net Revenue of shrunk production for Ethane

M$

Ethane

Revenue

Net

Changes Based on Currency

RoyaltyGas

Royalty Gas

Royalty net volume of Gas

MMcf

Gas

Shrunk Volume

ORRI

Changes Based on Convention

RoyaltyOil

Royalty Oil

Royalty net volume of Oil

Mbbl

Oil

Shrunk Volume

ORRI

Changes Based on Convention

RoyaltyNGL

Royalty NGL

Royalty net volume of NGL

Mgal

NGL

Shrunk Volume

ORRI

Changes Based on Convention

RoyaltyCond

Royalty Condensate

Royalty net volume of Condensate

Mbbl

Condensate

Shrunk Volume

ORRI

Changes Based on Convention

GrossWater

Gross Water

Gross Water is the total production volume of Water prior to Shrinkage

Mbbl

Water

Base Value

Gross

Changes Based on Convention

NetWater

Net Water

Net Production Volume of Water

Mbbl

Water

Shrunk Volume

Net

Changes Based on Convention

CoNetRevWater

Company Net Revenue Water

Working Interest Net Revenue of shrunk production for Water

M$

Water

Revenue

Net

Changes Based on Currency

RoyRevWater

Royalty Revenue Water

Royalty Revenue Interest of shrunk production for Water

M$

Water

Revenue

ORRI

Changes Based on Currency

RoyaltyWater

Royalty Water

Royalty net volume of Oil

Mbbl

Water

Shrunk Volume

ORRI

Changes Based on Convention

SDCash

Summary Discounted Cash flow

Summary discounted cashflow. This field is required since each case can have a different discount rate.The Primary discount rate is use on all cases to calculate the Sdcash value. If this field is used in reports then all discounted values in summaries or roll ups will reflect the same discount rate.

M$

SDCash

Base Value

Gross

Changes Based on Currency

NetAbandonment

Net Abandonment

Net Abandonment is the amount of capital spent on executing a well abandonment

M$

NetAban

Base Value

Gross

Changes Based on Currency

AllNetRevenue

All Net Revenue

Total Revenue of all streams

M$

All

Base Value

Net

Changes Based on Currency

AllNetExpense

All Net Expenses

Total Expenses of all streams

M$

AllNetExpense

Base Value

Gross

Changes Based on Currency

AllNetTax

All Net Taxes

Total Taxes of all streams

M$

All

Base Value

Gross

Changes Based on Currency

GrossWellCost

Gross Well Costs

$/well based costs applied to the Gross Volumes and adjusted by the Working Interest

M$

Total Wells

Well Cost

Gross

Changes Based on Currency

GrossOpCost

Gross Operating Costs

$/unit based costs applied to the Gross Volumes and adjusted by the Working Interest

M$

All

Op Cost

Gross

Changes Based on Currency

GrossOtherCost

Gross Other Costs

$/unit based costs applied to the Gross Volumes and adjusted by the Working Interest

M$

All

Other Cost

Gross

Changes Based on Currency

GrossTransCost

Gross Transportation Costs

$/unit based costs applied to the Gross Volumes and adjusted by the Revenue Interest

M$

All

Trans Cost

Gross

Changes Based on Currency

GrossFixedCost

Gross Fixed Costs

$/case based costs applied to the Gross Volumes and adjusted by the Working Interest

M$

All

Fixed Cost

Gross

Changes Based on Currency

NetPentanePlus

Net Pentane Plus

Net PentanePlus is the Shrunk volume * RI (revenue interest shrunk volume)

Mbbl

PentanePlus

Shrunk Volume

Net

Changes Based on Convention

GrossPentanePlus

Gross Pentane Plus

Gross Pentane is the total production volume of Pentane prior to Shrinkage

Mbbl

PentanePlus

Base Value

Gross

Changes Based on Convention

NetPropane

Net Propane

Net Propane is the Shrunk volume * RI (revenue interest shrunk volume)

Mbbl

Propane

Shrunk Volume

Net

Changes Based on Convention

GrossPropane

Gross Propane

Gross Propane is the total production volume of Propane prior to Shrinkage

Mbbl

Propane

Base Value

Gross

Changes Based on Convention

NetButane

Net Butane

Net Butane is the Shrunk volume * RI (revenue interest shrunk volume)

Mbbl

Butane

Shrunk Volume

Net

Changes Based on Convention

GrossButane

Gross Butane

Gross Butane is the total production volume of Butane prior to Shrinkage

Mbbl

Butane

Base Value

Gross

Changes Based on Convention