Grid Editing Ownership

<< Click to Display Table of Contents >>

Navigation:  Multi-case Editing > Grid Editor >

Grid Editing Ownership

Navigation: Multi-case Editing > Grid Editor >

hm_btn_navigate_prevhm_btn_navigate_tophm_btn_navigate_next

Show/Hide Hidden Text

The Grid Editor could be used to modify the ownership on cases.

html toggle_plus1 To Open the Ownership Table in Grid Editor

1.Go to the list of Forms and double-click on Grid Editor if it is not already open.

2.Select the cases to edit by dragging and dropping them from the Case List into the right section of the Grid Editor window. Select multiple cases by using Click+Shift, Click+CTRL, or by dragging over a grouping of cases set up in the sort order. The number of cases selected is shown with a case count on the top right. To remove one or more cases, hover over the case and click the x-delete button on the line next to the appropriate case or highlight the cases and hit Delete on the keyboard.

3.Under Available Edit Tables,select Ownership.

4.Click Edit to open the Grid Editor table

5.Make the appropriate changes and click Save to save the data and exit the Grid Editor.

html toggle_plus1 Columns in the Ownership Table

These are the standard columns in the ownership table. Click on the icon on the top left Grid editor show hide to show or hide specific columns on the grid.

Case ID - The ID Code ties each record to a case in PHDwin. New rows should be populated with the proper Case ID. This is a required field when adding new ownership records and tells the program which case the ownership or ownership adjustment will be applied to when the Grid Editor is closed.

Case Name - The Case Name is presented so that users are able to easily identify the case, even though the Case ID is the actual field used by the Grid Editor to link the new ownership data to a case. The case name is used for reference and is displayed so users can identify the case being edited. If a new ownership record is added, there is no need to populate the Case Name as this new information is not saved in this table.

Sequence – The order in which reversions occur. This is 1 for the initial ownership and increment for each reversion.

Reversion Type – Adjust to model the “Initial” interest on the case or set up to model a reversion. The reversion types are Payout, Cum, or Date.

Product  –  Applicable to Cum reversions. Select the product for which produced volume will trigger the change in ownership.

Rev. Date – Required for Date reversions only – All reversions should be set to the proper hard-coded or linked date. The “Initial” ownership is always be tied to the Case Start Date. Not applicable to Cum or Payout reversions.

Interest Type – Required for Cum or Payout reversions - Specifies if the reversion value is gross or net. Used to allow flexibility to enter payout or cum reversion balances as gross or net. Not applicable to date reversions.

Initial Balance - The Initial balance of [revenue - costs] for the case. This value will be zero if it is a newly drilled well.

WI – The working interest that the person/company has in the case. Accepted range is between 0.0 and 1.0.

RI – The revenue interest the person/company has in the case. Accepted range is between 0.0 and 1.0.

Royalty – The royalty interest the person/company has in the case. Accepted range between -1.0 and 1.0. This is a great tool to model pure royalty, overrides, and burdens on the case.

NRI – The net revenue interest for the entire lease (also called the Lease NRI). It is used to calculate the economic limit of the case. Accepted range between 0.0 and 1.0.

NPI – The net profits interest. Accepted range between -1.0 and 1.0. Enter a positive value to model a net profits revenue. Enter a negative value to model a net profits expense.

Interest rate – Only applicable to Payout reversions. The interest charged on the payout balance each year.  

Reversion Value – Required for Cum or Payout reversions - The value of the reversion. Cum reversions are entered in thousands of base volume units. Payout reversions are entered in thousands of currency units.

Discount Rate – Only applicable to Payout reversions. The discount rate used to discount cash flow used to calculate the payout date.

NPI Adj. Net Volume  – The net profits interest adjusted net volume. This field is either True or False. If set to True, the net profits expense will be reported as a reduction in volumes instead of as an expense.

Include Investments – Required for Payout reversions. The field will be either True or False. If set to True, investments will be deducted from the cash flow to determine the payout date. If set to False, investments will not be deducted from cash flow.

Adjusted Ownership - If there are adjusted ownership for a specific product(s) in the case, users need to provide the WI, RI, NRI, and Royalty values for the specified product(s).