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 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 General Info.

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.

These are the standard columns in the General Info table. Click on the icon on the top left to show or hide specific columns on the grid. Some of the fields require specific formatting or values to be input and those are noted below.

•Case ID - Record Index - The unique identifier for each case in the database. Case ID cannot be edited for existing cases and will be populated automatically when adding new cases.

•*Case Name- The name of the case that is displayed on the Case List. This is the only table where Case Name can be modified.  It should be populated when adding new cases with Grid Editor.

•*Classification - The classification entered here must be one of the available categories set up in the Database settings - Classifications & Categories. Users have to choose one of the predefined classifications in the Database settings using the menu provided.

•*Category - The category selected here must be one of the available categories that you've set up in the Database settings - Classifications & Categories, and is nested underneath the chosen classification. The available menu helps users make the appropriate selection.

•*Sub-category - The sub-category is selected using the provided drop-down menu based on the list of the available categories set up in the Database settings - Classifications & Categories and is nested underneath the chosen classification and category.

•*Convention - The unit convention used for the case. Changing the convention will only change the unit labels and will not recalculate any affected items. The convention entered here must be one of the available conventions set up in the Database settings - Conventions and available using the drop-down menu.

•*Phase Configuration – The available products and their definitions for the case. Changing the Phase Configuration may cause projections or product volumes to be lost if their definitions are different or if the product does not exist in the new convention.

•*Well Type - The well type must be Flow, INJ (Injector), Pump, Source, SWD (Salt Water Disposal) or Unknown.

•*Currency - The currency used for the case. Changing the currency will only change the label and will not recalculate any affected items. The currency selected must be one of the available currencies set up in the Database settings - Currencies.

•*Field - The field name entered must be one of the available fields as set up in the Database settings - Fields, Reservoirs & Zones.

•*Reservoir - The reservoir name entered must be one of the available reservoirs as set up in the Database settings - Fields, Reservoirs & Zones, and is nested underneath the Field selected.

•County - The county in which the case is located.

•Country - The country in which operations are taking place for that particular case/well.

•State - The state (if United States) in which the case/well is being operated.

•Operator - The Oil and Gas operator that has the majority working interest in the case.

•Well - The well number associated with the case.

•API Code - The API number of the case (from the ID Codes form)

•Latitude - The locational latitude coordinate of the case.

•Longitude - The locational longitude coordinate of the case.

•Location - The block and section that the case is located. There is a specific location format that is the default when cases are imported from DrillingInfo, but users may change it here to be specific.

•Gradient - The pressure gradient for the well.

•Tubing Inner Diameter - The inner diameter of the tubing of the well in the case.

•Total Depth - The total depth of the well. The units for depth will correspond with the units set for the Convention that is applied to this case.

•Azimuth - The angle measurement from the vertical that the well is in. The azimuth is measured in degrees.

•Gas Gatherer - The energy company that will be receiving the gas that comes out of the well. It is usually a midstream or natural gas company.

•Oil Gatherer - The energy company that will be receiving the oil that comes out of the well. This is sometimes the same as the operator.

•Area - The total area that the reservoir covers. The units will correspond with whatever convention is applied to this case.

•Spud Date - The date drilling of the well started.

•Lateral Length - The length of the horizontal section of the well in the case of horizontal wells. The units for lateral length should correspond to the units set for the Convention that is applied to this case.

•True Vertical Depth - This is the depth of the vertical section of the well as measured perpendicularly downward from a horizontal plane. The units for true vertical depth should correspond to the units set for the Convention that is applied to this case.

•On Shore - True or False. Should be set to TRUE for onshore cases, and FALSE to offshore cases.

•Deep Water - True or False. Should be set to TRUE for Deep Water cases or FALSE if not deep water or for onshore wells.

*Required fields

The General Info table of the Grid Editor can be used to add new cases. In order to use Grid Editor, at least one case must be existing in the database already.

To add new cases:

1.Open the Grid Editor and select General Info as the table to edit. Select at least one case to edit, or others to copy information from.

2.Add the new case by right-clicking and selecting Insert New Case (or using their shortcuts Alt+B)

3.Once the new rows/cases are added, fill out the information for each case - the required fields will be filled out by default.

Note: There is no need to populate the Case ID. This will be generated by the application.