While editing an open Table, the Action Bar includes two Action buttons that provide powerful commands for modifying table contents directly: Range Options and Table Options. There is also a third button that provides commands that utilize a separate Table Buffer (refer to Table Buffer Options for more information).
The Range Options button menu offers a variety of commands that operate only on the selected range within the open Table. By clicking on the cell at which the row and column headers intersect, you may easily select the entire table as the range. Many of these commands are also available through the right button action menu.
|
Range Options Command |
Action |
|
Clear Contents |
sets the selected range to zeros |
|
Cut, Copy and Paste |
applies Windows standard cut, copy and paste commands to the selected range using the clipboard |
|
Paste Special |
opens a submenu of six commands that allow you to apply the contents of the clipboard to the selected range of values without just replacing the values; options include adding, subtracting, multiplying or dividing the selected value or range by the clipboard contents and also taking the lower or higher of selected values and clipboard contents |
|
Set Values |
opens a submenu of ten commands that allow you to apply simple algorithms to define the contents of the selected range |
|
Selection Repeats Down |
uses the values in the selected range to fill in subsequent cells by taking repeated copies of the range moving down the table subject to the limit you select from the submenu: a specified row number, a specified attained age, the end of the table, or the last non-zero value in the current table |
|
Selection Repeats Across |
uses the values in the selected range to fill in subsequent cells by taking repeated copies of the range moving across the table to the right subject to the limit you select from the submenu: a specified column number, a specified product age, a specified attained age, the end of the table, or the last non-zero value in the current table |
|
Interpolate |
redefines the values in the selected range by applying an interpolation approach according to options selected in the Interpolation Option window |
|
Inflate/Deflate |
increases values in selected range and optionally to the bottom of the table, by applying specified flat rate of inflation/deflation; submenu choices include both simple and compound application of rate for inflation or deflation. |
|
Extend values for a period of X rows ... |
within the selected range, repeats the values in the first row to rows 2 to X, repeats the values in row X+1 to rows X+2 to 2X, and so on |
|
Normalize rows (Sum = 100%) |
multiplies the values in the selected range by an adjustment factor so that the sum of the values in each row of the table containing values in the selected range is 100 |
|
Transpose |
provided that the selected range is square (equal numbers of rows and columns), the values in the range are transposed (rows become columns and vice-versa) |
|
Switch |
two values or two ranges of values |
| Flip Vertical | flip a range top to bottom |
The Table Options button menu offers a variety of commands that operate on the open Table regardless of any range that may be selected.
|
Table Options Command |
Action |
|
Actuarial calculator |
opens a submenu of four commands that allow you to apply actuarial present value formulas to define the contents of the table; options include assurance single premium factors, annuity factors, net level premium factors and single premium conversion cost factors |
|
Conversion options |
opens a submenu of commands that allow you to apply standard actuarial techniques to define the contents of the selected range by converting the existing table of rates from one form to another |
|
Import from a regular table |
uses the columns of a specified regular table (ten columns only) to define corresponding columns of the current large table (must be independent by age and duration for an accurate translation) |
|
Extract from a large table |
defines the values in the opened regular table (ten columns only) by using the corresponding values of a specified large table by product age and duration |
|
Values vary by age attained |
uses a specified row or column of the current table to define other values in the table according based on attained age; opens a form to specify which values in which rows or columns are used |
|
Produce implied forward rates from a row |
uses the selected row of yield rates in the current Scenario to define yield rates for all future periods according to implied forward yield rate assumption |
|
Produce term rates from duration N rates |
uses values in the Nth row to calculate term insurance premium rates at various durations; opens a form to specify term, expiry age of term, and N |
|
Time series functions |
opens a submenu of eight choices to allow you to calculate values based on selected time series function, using values in each column of current table |
|
Calculate O/S balance on a mortgage given initial balance |
uses the first row of the table as the initial principal balance of a mortgage and calculates the amortization schedule of outstanding balance for subsequent years based on values for term, interest rate and compounding frequency which you enter |
|
Clear all entries beyond attained age X |
sets all values to zero for attained ages greater than selected age which you enter |
|
Age rating |
allows you to adjust a table by applying an age rating of a number of years up or down; opens a form to allow you to specify the rating |