Grid Editing Ownership
The Grid Editor could be used to modify the ownership on cases.
To Open the Ownership Table in Grid Editor
- Open Forms List – Go to Forms and double-click on Grid Editor if it is not already open.
- Select Cases – Drag cases from the Case List into the right section of the Grid Editor window.
- Multi-Select Cases – Use Shift, Ctrl, or mouse drag to select multiple cases.
- Remove Cases – Click ❌ next to a case or press Delete after selecting cases.
- Go to Edit Tables – Under Available Edit Tables, select Ownership.
- Open Table – Click Edit to open the Grid Editor table.
- Make Changes – Update the required fields in the table.
- Save Data – Click Save to apply changes and exit the Grid Editor.
Columns in the Ownership Table
These are the standard columns in the ownership table. Click on the icon on the top left 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 – Displays the case title so users can easily recognize it. While the system uses Case ID internally for linking, the case name helps identify and manage records. If a new ownership entry is created, filling this field is optional.
• Sequence – Determines the order of ownership records. Starts from 1 for the initial entry and increases with each revision.
• Reversion Type – Used to define the initial setup or any changes over time. Available types include Payout, Cumulative, or Date-based.
• Product – Relevant only for cumulative reversions. Select the product that will influence ownership changes based on production volume.
• Reversion Date – Mandatory for date-based reversions. Each entry should follow predefined or linked dates. Initial ownership is always aligned with the case start date.
• Interest Type – Required for payout or cumulative reversions. Specifies whether values are calculated as gross or net. Not applicable for date-based types.
• Initial Balance – Represents the starting financial position of the case (revenue minus costs). Usually zero for new wells.
• WI (Working Interest) – Shows the operational stake held by a person or company. Value must be between 0.0 and 1.0.
• RI (Revenue Interest) – Indicates the share of revenue earned. Must fall within 0.0 to 1.0.
• Royalty – Reflects the royalty share assigned. Range allowed is from -1.0 to 1.0. Useful for handling royalties, overrides, or burdens.
• NRI (Net Revenue Interest) – Total net revenue share across the case. Used to determine overall economic limits. Range: 0.0 to 1.0.
• NPI (Net Profit Interest) – Represents profit-based interest. Positive values indicate profit share, negative values represent expense share.
• Interest Rate – Applies only to payout reversions. Defines the yearly rate applied to payout balances.
• Reversion Value – Required for payout or cumulative reversions. For cumulative, values are in production units; for payout, values are in currency.
• Discount Rate – Used only for payout reversions. Helps calculate present value by discounting 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 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).