The Valuation Set Output command allows you to review the results of one or more Valuations Sets.

To view output:

1. On the Output menu, select Valuation Set Output. Alternatively, select Valuations Sets in the Shortcuts pane.

2. Select the Valuation Sets you want to view. (To select more than one, hold down the Shift or Ctrl key while clicking.)

3. Select Results to be displayed and specify Formatting options in the Output pane, or load a Saved style from the library. See below for details.

4. Click the View Output button. Upon viewing, you can Print or save to File, among other options. Note: a blank value displayed for a variable indicates that its value has not been calculated during the selected run.

 

The items in the Output pane are as follows:

Saved style is the name of the valuation set output design template that is currently in use. Click the arrow button to manage or select from the library of design templates. Note that the color of the arrow turns to red if output design changes have been made and have not yet been saved. To save changes to an existing style, click the arrow button and Replace; to save a new style, give it a name, click the arrow button and then click “Save as new”. To clear style settings, click the arrow button and then click “Clear settings”. Note that when "Clear settings" is applied to a loaded style, the saved style itself remains intact and can be reloaded. 

Click Variables to select the results to be displayed for each of the Valuation Sets selected. The Variables dialog box includes tabs to organize the variables into logical groups:

• Demographics & Cash Flow – includes demographic variables as well as benefit payments, investment return and other elements of cash flow.

• Funding (modes other than OPEB and German pension) – includes funding liabilities and costs relevant to the particular ProVal mode of operation.

• Funding & GASB 43/45 (OPEB mode) – includes unfunded liability and contribution data, along with GASB 43/45 accounting results.

• Tax / Funding (German pension mode) – includes tax and funding liabilities, premiums and contribution data.

• Pre-PPA / Multiemployer (U.S. qualified mode) – includes current liability variables and funded ratios.

• PPA (U.S. qualified mode) – includes variables related to single-employer liabilities under the Pension Protection Act of 2006, such as legislated liabilities and funded percentages and components of shortfall amortization.

• Accounting – includes accounting liabilities and costs relevant to the particular ProVal mode of operation.

• Trend Sensitivities (OPEB mode) – includes Expense, APBO, and benefit payment variables for +1%/-1% trend sensitivity runs.

Each tab within the Variables dialog box contains the following buttons:

Details – this produces a dialog box that allows you to display actives, inactives and totals separately, display active variables by benefit, or display inactive variables by status code. In OPEB mode, additional detail options are available for both active and inactive variables. The selections made in the Details dialog box are applied (where relevant) to variables on all tabs, not merely the displayed tab.

All and None – these buttons provide a shortcut to select all of the variables, or remove the selection of all variables, on the tab displayed (and only on that tab – these buttons do not affect selections on tabs that are not visible).

Reset – this button provides a shortcut to set the selection of all variables on all tabs to the default setting.

 

Click Layout to specify how the output is to be arranged. The typical arrangement will have Variables in rows and Valuation Sets in columns. However, you can organize the data differently if you wish.

Click Format variables to reorder the listing of the variables selected and to change their labels from those ProVal uses by default. You can also set the numeric format for each variable (e.g., specify the number of decimal digits and indicate whether commas are to be used).

Click Format valuation sets if you wish to rename or reorder the Valuation Sets selected for display. ProVal uses the Valuation Set name as a Default Title, but you can override that default by entering a Custom Title for one or more of the selected valuation sets. By default, the display sequence of the selected valuation sets is determined by the sorting you apply to the valuation sets in the entries pane (e.g., by Name or by date Modified). Clicking Custom order will enable you to renumber the valuation sets to indicate the order in which they are to appear; ProVal will retain the specified order as long as Custom order remains selected, regardless of whether you resort the valuation set listing in the entries pane.

Click Page title to specify a title other than "Valuation Set Output".

Click the View Output button to view the results, after which you can Print or save to File, among other options. Note: a blank value displayed for a variable indicates that its value has not been calculated during the selected run.

 

Under See also, in the bottom right-hand corner of the screen, you can also:

Click Valuation Set Exhibits to open the Valuation Set Exhibits command.

Click U.S. Government Forms Extract to open the U.S. Government Forms Extract command.