Beyond 20/20

Adjusting Cell Values

After you have created a table, you can apply various computations to the data to adjust the cell values. You can round off or scale data values, and you can replace data that is within a specific range with zeros or missing values.

To round off data values:

Note: If the table you want to modify is open, you must close it before you can proceed.

1. From the File menu, point at Utilities and then click Adjust Cell Values. The Open dialog box appears.
2. In File name, type or select the name of the table that you want to modify. (If you do not see the table you want to modify, select a different location to search for the file.)
3. Click Open. The Adjust Cell Values dialog box appears.
4. In Operations, select Round Off.
5. In Rounding Factor, enter a factor to round the data to. Data will be rounded to the nearest multiple of the rounding factor. For example, rounding 47 by a factor of 5 converts it to the nearest multiple of 5, or 45. Similarly, rounding 48 by a factor of 5 converts it to 50.
6. Click OK. A message warns that the table's data will be permanently modified.
7. Click OK. All data values are rounded to the factor you selected.

To exclude data values:

Note: If the table you want to modify is open, you must close it before you can proceed.

1. In the File menu, point at Utilities and then click Adjust Cell Values. An Open dialog box appears.
2. In File name, type or select the name of the table you want to modify. If you do not see the table you want to modify, search for the file in a different location.
3. Click Open. The Adjust Cell Values dialog box appears.
4. In Operations, select Low Bound (Missing) or Low Bound (Zero) to set the excluded data to missing values or zeros, respectively.
5. In Minimum and Maximum, enter the minimum and maximum values of the data that you want to exclude from the table.
6. Click OK. A message warns that the table data will be permanently modified.
7. Click OK.

   Data values that lie within the range you selected are set to zero or to missing values, as the case may be.

To scale data values:

Note: If the table you want to modify is open, you must close it before you can proceed.

1. In the File menu, point at Utilities and then select Adjust Cell Values. The Open dialog box appears.
2. In File name, type or select the name of the table you want to modify. (If you do not see the table you want to modify, search for it in a different location.)
3. Click Open. The Adjust Cell Values dialog box appears.
4. In Operations, select Scale or Integer Scaling.
   • Scale scales your data to a given factor (i.e., divides it by the scaling factor).
   • Integer Scaling scales your data to a given factor and then rounds off the result.
5. In Scaling Factor, enter a factor to scale the data to and then click OK. A message warns you that the table data will be permanently modified.
6. Click OK.

   The data is scaled to the factor you entered.

Note: This has to be done individually for each IVT file. There is no setting to preserve you cell adjustments across many IVT files although there is an unsupported tool that will allow you to adjust cell values from the command line.

ADJUSTCELL

usage: b2020tools ADJUSTCELL -f FILENAME -t TYPE [-b MIN,MAX][-m MISSING] [-v VALUE] [-s]
where:
-f FILENAME is the file that will be updated using the specified method.
-t TYPE is one of scale, scalei, round, bound, boundv.
-b MIN,MAX is the minimum and maximum values. Required for bound and boundv:
Values entered as "min,max" do not include the end-points. To specify
     inclusion, use the band convention as follows:
        [min,max] includes values >= min and <= max.
        (min,max] includes values > min and <= max.
        [min,max) includes values >= min and < max.
        (min,max) includes values > min and < max.
-m MISSING is the indicator of the missing value to be set.
-v VALUE is a numeric value required to specify the factor for round, scale, and scalei.
-s Execute silently without any console output. The default is to display output.

Email support@beyond2020.com to request a copy of the unsupported