RockWorks | Utilities | Columns | Math | Column & Constant
This RockWorks Utilities program is used to perform arithmetic operations (add, subtract, multiply, or divide) with the values in a single column in the datasheet and a constant. This is also available in the Borehole Manager's Datasheet editor.
Menu Options
- Input Column:
- Original Value: Select the name of the column in the current datasheet that contains the numeric values to which the constant will be added or multiplied, from which the constant will be subtracted, or into which the constant will be divided.
- Output Column:
- New Value: Select the name of the column into which the computed values are to be listed. Any existing values in this column will be overwritten!
- Constant: Click here to type in the real number value to be used as the constant.
- Operation: Click in the radio button for the arithmetic operation to be performed on the values in the input data column.
- Add: Input + Constant
- Subtract: Input - Constant
- Subtract: Constant - Input
- Multiplication: Input x Constant
- Division: Input / Constant
- Division: Constant / Input
- Decimals: Enter the requested number of decimal places to be represented in the output values.
Step-by-Step Summary
- Access the RockWorks Utilities program tab.
- Open the datasheet to be manipulated if necessary.
- Click on the Columns menu above the datasheet, and select the Math | Columns & Constant menu option.
- Enter the requested menu settings, described above.
- Click the Process button to continue.
The program will perform the selected operation on the numeric values read from the selected input data column. The results will be listed in the selected output column.
Back to Editing the Datasheet
RockWare home page