Reset
Undo
Snapshot
Toggle
Precedent
Single
Impact
Interactive Impact
Multiple Impact - Equal
Multiple Impact - Percent
Multiple Impact - Weighted
Multiple Impact - Total
Multiple Impact - User Defined
Multiple Impact - Version
Aware™ Technology
Permutation Control Toolbar
The toolbar shown to the left contains speedbuttons that are used to control the permutation process. Users click on these speedbuttons to set values in cell's permutation control which are then utilized to control the permutation process when a model permutation is triggered. Here is a brief description of each speedbutton and the its corresponding permutation behavior.
Reset (Dynamic)
The reset speedbutton is a dynamic controls which triggers an immediate
permutation process to reset the current model to its original form. The original state
control is maintained automatically as the user defines the initial model. Subsequently,
after one or more model permutations, the model can be reset to it's original state. The
term model in this instance refers to resetting all cells to their original state as
either input cells or formula cells, but without resetting the actual data values stored
in each cell.
Undo (Dynamic)
The undo speedbutton is a dynamic control that causes the model to be reset immediately to
the state it was in when the last snapshot of the model was taken. The term model in this
instance refers to resetting all cells to their original state as either input cells or
formula cells, but without resetting the actual data values stored in each cell.
Snapshot (Dynamic)
The snapshot speedbutton is a dynamic control that immediately creates a copy of
the current model (formulas and data) in computer memory. This copy of the model can be
used to reset the model formulas, data or both in response to a menu command by the user.
Toggle Precedent
(Dynamic - Applies to Single Impact Only)
The toggle precedent speedbutton is a dynamic control that immediately changes
the permutation controls current contents to the next contents in sequence. This is a
targeting mechanism. It changes the target cell from a current to a next cell in the
permutation control contents list. For example, if the current contents pointed to cell B1
and the next contents pointed to cell B2, then the toggle precedent speedbutton would
change the current contents to cell B2 and move cell B1 to the bottom of the permutation
control's content list. This control is only enabled for single impact cells. It is
disabled for multiple impact cells.
Single Impact (Static)
The single impact speedbutton sets a static control value in the cell's
permutation control that instructs the permutation process to use only the current
permutation control contents to permute just a single precedent cell during model
permutations which utilize this cell's permutation control.
Interactive Impact (Dynamic)
The interactive impact speedbutton sets a dynamic control value in the
cell's permutation control that instructs the permutation process to display the cell's
permutation control contents in a selection dialog. This dialog gives the user the
opportunity to view and change the permutation pathway through the model when it
encounters the cell containing this control value during the model permutation process.
Multiple Impact - Equal (Static)
The multiple impact - equal speedbutton sets a static control value in the
cell's permutation control that instructs the permutation process to use the entire
contents of the permutation control for the current cell and to permute every precedent
cell listed with a new equation. This speedbutton causes the equations stored for
each precedent cell to contain a proportionate calculation that will result in all cells
calculating an equal portion of the cell's final value. Keep in mind that the operation
triggered here creates alternate equations for each precedent cell. It does not actually
calculate any values. Thus, it is a permutation type which specifies a specific behavior
and sets specific contents in the permutation control to achieve this behavior.
Multiple Impact - Percent (Static)
The multiple impact - percent speedbutton sets a static control value in the
cell's permutation control which instructs the permutation process to use the entire
contents of the permutation control thus affecting multiple cells during the permutation
process. It also automatically generates a set of equations for the precedent cells that
contain a percent value which represents the percent the current precedent cell's value is
of the current parent cell's value. This action is performed for each precedent cell
separately and is stored in the permutation control for use during the permutation
process.
Multiple Impact - Weighted (Static)
The multiple impact - weighted percent speedbutton sets a static control value in
the cell's permutation control which instructs the permutation process to use the
entire contents of the permutation control thus affecting multiple cells during the
permutation process. It also asks the user for a row or column offset to use in creating a
set of equations which contain weighting percentages based upon the row or column offset.
These percentages are stored in each precedent cell's equation which will be used during
model permutations.
Multiple Impact - Total (Static)
The multiple impact - total speedbutton sets a static control value in the cell's
permutation control which instructs the permutation process to use the entire
contents of the permutation control thus affecting multiple cells during the permutation
process. It also asks the user for a row or column offset to use in creating a set of
equations which contain weighting percentages based upon the row or column offset and the
total of that column or row. These percentages are stored in each precedent cell's
equation which will be used during model permutations.
Multiple Impact - User Defined
(Static)
The multiple impact - user defined speedbutton sets a static control value in the
cell's permutation control which instructs the permutation process to use the entire
contents of the permutation control thus affecting multiple cells during the permutation
process. It also asks the user to enter the contents of the permutation control in a line
by line dialog display. For example, the user could throw a value to another cell to
trigger a subsidiary model permutation and also throw several equations to other cells.
These permutation control contents are stored in the permutation control for use during
the permutation process. They are "user defined" because the user edits them
directly into the permutation control.
Multiple Impact - Version
(Static)
The multiple impact - version speedbutton is an alternate use of the user defined
speedbutton above. It sets a static value in the cell's permutation control that specifies
the name of a saved model version to load when the permutation process encounters the
current cell during a permutation of the model.