Plug Cell Setup Command - Rounding Dialog

Rounding relations may have multiple plug cells that allow the difference to be plugged into different cells depending upon the plug's value.

When values are present in cells 1 and 2 and the rounding relation is enabled, the relation searches for the first plug cell whose condition is not true based on the value of the difference. If all of the plug cells' conditions are met, then the difference is not inserted anywhere.

Plug Cells

The table displays existing plug cells for the difference cells chosen in the Rounding dialog.

Add

Click to add a new plug cell and condition for the difference cells. A new line is added to the table and the Plug Cell properties fields are readied to fill in.

Remove

To remove an existing plug cell, select it in the list and then click Remove.

Plug Cell Properties

Cell

Type or select a cell to use as the plug cell.

Click the Pick Cell button to launch the Cell Picker dialog.

Click the Go to Cell button to highlight the cell name.

Plug Condition

Enter a plug condition for the cell chosen. Click the $images\calctool_shg.gif$ button to access the Calculation Editor.

The Plug Condition is the condition that makes this cell get skipped as the plug cell. That is, if the condition is evaluated to be true, the difference is not plugged here and another plug cell is searched for. If the condition is evaluated to be false, the value of the difference between cells 1 and 2 goes in this cell.

Notes

Be careful with the order in which you add the plug cells. If two or more plug cells are evaluated to be 0 or false, the plug value goes in the first cell the relation finds and then stops looking. This may not be the correct cell to use for the plug.
Use the up $images\plugcellup_shg.gif$ and down $images\plugcelldown_shg.gif$ arrows to change the order of the plug cells: click a plug cell and then click an arrow to move the plug cell up or down.