Computing Absolute Values for a Data Column

RockWorks | Datasheet | Columns | Absolute

This RockWorks Datasheet program is used to read a single column of data values and record their absolute values into another column in the main datasheet.

Menu Options

• Data Columns
  • Input Column: Original Value: Click on the down-arrow button to select the name of the column in the current datasheet that contains the numeric values whose absolute values are to be recorded.
  • Output Column: Absolute Value: Select the name of the column into which the absolute values are to be listed. Any existing values in this column will be overwritten!
• Options
  • Decimals: Enter the requested number of decimal places to be represented in the output values.
  • Include disabled rows: Check this if unchecked (disabled) rows in the datasheet are to be included in the processing.
  • 
    

Step-by-Step Summary

1. Access the RockWorks Datasheet program tab.
2. Open the datasheet to be manipulated if necessary.
3. Click on the Columns menu above the datasheet and select Absolute.
4. Establish requested settings, as listed above.
5. Click the Process button at the bottom of the window 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