RockWorks | Datasheet | Columns | Column & Column
This RockWorks Datasheet program is used to add, subtract, multiply, or divide the values in one column in the datasheet to, from, by, or into the values in the corresponding row in another column.
- Data Columns
- Input:
- Column A: Select the name of the column in the current datasheet that contains the numeric values to which another column of values will be added or multiplied, from which another column will be subtracted, or into which another column will be divided.
- Column B: Here, select the name of the datasheet column containing numeric values to be added or multiplied to, subtracted from, or divided into Column A values.
- Output:
- Column C: 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
- Operation: Click in the radio button for the arithmetic operation to be performed on the values in the input data columns.
- 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 Column & Column menu item.
- Establish the 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 data columns. The results will be listed in the selected output column.
Back to Editing the Datasheet
RockWare home page