Nisus Writer Pro - Manual (Page 432)

412 The Nisus Writer Pro Macro Language Macros, the Deeper Workings
▸ Average Rows and Columns
Place the insertion point in the first cell, that is the first row and the
first column cell.
Each row and each column of the table will be averaged, with the
rows being averaged first. Each average will be placed in the last cell
of each row and column respectively. That means that the last cell,
the bottom right corner cell, will contain the average of all row
averages.
Those who need the order of averaging reversed can change the
order of averaging in this macro and then the last cell will contain
the average of all column averages.
It is, however, important to note that this macro uses two other
macros: the average row and the average column macros. If you
change either of these, you may stop the functioning of this one.
▸ Evaluate Selection Evaluates the selected text based on the operator(s) (+, -, *, /, etc.)
in the selection and places the result to the right of and equal sign
following the last item in the selection.
▸ Mortgage Calculator Calculates the monthly payment on the specified principal for the
given interest rate.
▸ StdDev Column This macro evaluates the standard deviation of the column of
numbers, starting at the current cell and placing the results in the
last cell of the column. Note: empty cells are not counted so they do
not affect the standard deviation, but cells with a zero in them are
counted and they do affect the standard deviation.
Be sure to have an empty cell in the column otherwise the last cell
will be overwritten with the result. Its contents will not be summed.
Place the insertion point in the first cell of the column to be
evaluated.
▸ StdDev Row This macro evaluates the standard deviation of the row of numbers,
starting at the current cell and placing the results in the last cell of
the row. Note: empty cells are not counted so they do not affect the
standard deviation, but cells with a zero in them are counted and
they do affect the standard deviation.
Be sure to have an empty cell in the row otherwise the last cell will
be overwritten with the result and its contents will not be summed.
Place the insertion point in the first cell of the row to be evaluated.
▸ StdDev Rows and Columns
Place the insertion point in the first cell, that is the first row and the
first column cell.
Each row and each column of the table will be evaluated, with the
rows being evaluated first. Each standard deviation will be placed in
the last cell of each row and column respectively. That means that
the last cell, the bottom right corner cell, will contain the standard
deviation of all row standard deviations.
Those who need the order of averaging reversed can change the
order of evaluation blocks in this macro and then the last cell will
contain the standard deviation of all column standard deviations.
It is important to note that this macro uses two other macros: the
StdDev Row and the StdDev Column macros. If you change either of
those, you may stop the functioning of this one.
▸
Sum Clipboard Sums the numbers copied to the Clipboard by interpreting any
white space, including new lines, between numbers as a plus sign.
The result is placed at the insertion point.
▸ Sum Column Sums the column of numbers starting at the current cell and places
the result in the last cell of the column.
Be sure to have an empty cell at the bottom of the column otherwise
the last cell will be overwritten with the result and its contents will
not be summed.
Place the insertion point in the first cell of the column to be added.