RockWorks | Datasheet | Columns | Column & Constant
This RockWorks Datasheet 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.
- Data Columns
- Input: 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: Select the name of the column into which the computed values are to be listed. Any existing values in this column will be overwritten.
- Options
- 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
- Multiply: Input x Constant
- Divide: Input / Constant
- Divide: Constant / Input
- Decimals: Enter the requested number of decimal places to be represented in the output values.
- Include disabled rows: Check this option if disabled (unchecked) rows in the datasheet are to be included in the operation.
- Access the RockWorks Datasheet program tab.
- Open the datasheet to be manipulated if necessary.
- Click on the Columns menu above the datasheet and select the 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