Optional Services

Update Multiple

Results Data

Matching information on multiple rows of provisions data may be applied simultaneously to save you time. For example, if you wish to apply the same equipment code to several rows of provisions data, you can do so in one procedure instead of editing one row at a time. You can also update multiple rows to remove values for specific columns.

  1. On the Provisions—Results screen, select the rows of data you wish to update. To select multiple rows in the Results grid, press and hold the Ctrl key on your keyboard while clicking rows (this allows you to select rows that are not in sequence).

  1. Right-click within the rows you have selected, click the Update Multiple and then click Results Data. The Results Data pop-up opens.

  2. Add data on the grid that is to be applied to all of the rows you previously selected. For example, if you wish to apply the same equipment code to all the selected rows, click the right-side of the EQP field to open the Equipment Type lookup and then double-click an equipment code. The added data (such as, the equipment code) will appear in the grid on the Results Data pop-up.

  3. If you need to update multiple rows to remove a data from one or more columns, click the Clear Data link located above the Results Data grid. The Update Multiple Results Data - Clear Data pop-up opens. Select one or more column headers from the provided list and click the Select button.

  4. Click the Apply button button. The Results Data pop-up closes and review your changes.

  5. Click the Save button button. If you are not already active within a batch you will be prompted to create a batch. For more information, see Create a Batch.

Calculate Amounts

Updating fee amounts automatically by using an increase/decrease calculation makes updating multiple rows quick and easy. For example, if you wish to increase the fee amounts of several rows of provisions data by 25 percent, you can do so in one procedure instead of editing one row at a time.

  1. On the Provisions—Results screen, select the rows of data you wish to update. To select multiple rows in the Results grid, press and hold the Ctrl key on your keyboard while clicking rows (this allows you to select rows that are not in sequence).

  2. Right-click within the rows you have selected, click the Update Multiple, and then click Calculate Amounts. The Calculate Amounts pop-up opens.

  3. Select Add or Subtract from the Calculation field and enter an amount in the Amount field. A whole number or a decimal can be entered. Optionally, check the Amount is a Percent check box to indicate a percentage calculation. The calculation entered will be applied to all of the eligible rows you previously selected. For example, if you wish to add 25 percent to all the selected rows, you would select Add from the Calculation field, type 25 in the Amount field, and check the Amount is a Percent check box.

  4. Click the Apply button button. The Calculate Amounts pop-up closes and the new data will be present within the selected rows.

  5. Click the Save button button. If you are not already active within a batch you will be prompted to create a batch. For more information, see Create a Batch.

Calculations cannot be performed for the following:

 

Related Topics

  1. Copy/Paste
  2. Delete a Row
  3. Ignore Changes Made to a Row
  4. Insert a New Row Before or After
  5. Reorder Rows
  6. Restore Incomplete Segments