Accurate GMP

Calculation Date

The Calculation Date to which the calculation is performed.

This defaults to the Current Valuation Date. You can overwrite this if you wish as the calculation can be carried out at dates other than the valuation date provided there is sufficient data.

Dates can be entered in almost any format and they will be automatically converted to DD/MM/YYYY format.

Input Data File

Specify the input data file (or files, if appropriate). It must be located in the Scheme Folder.

Double Clicking will activate the standard Windows Open File Dialog box for selection of a file.

Data Format

The data format of the data file(s).

The data format are saved parameters specifying the column specification of each of the data items contained in the data file. Data format descriptions are prefixed by an indication of the type of format e.g. <Act> for Actives, <Def> for Deferreds, <Pen> for Pensioners.

If you intend to use the GMP Calculators to calculate GMPs after creating your data, ensure that columns are created in your data file for these fields. (In addition, enter dummy data into the data file for the first member that is at least as large as the largest expected GMP for all members. This will ensure that the Format created leaves sufficient space for the GMPs calculated.)

Data>Build

If you have created data using Data>Build then the format name will be the same as the original source (CSV) file or Excel file/tab name.

BasisModule>Migrate

If you have migrated your data files from earlier versions the name will be unchanged.

Output Data File

Specify a name for the data file. The filename specified must not already exist as it will not overwrite an existing file. It will be created in the Scheme Folder.

Double Clicking will activate the standard Windows Open File Dialog box for selection of a file (which can be used as a starting point for the name of the file).

Run

Click the Run button to run the calculations.

Save As

Click the Save As button to save with a new parameter description.

Save

Clicking on the Save button allows you to save the entries.

Quit

Clicking on the Quit button allows you to exit without saving any of your changes.

In some of the screens you will be asked to confirm if you want to exit Ignoring all changes. If you click Yes, the file will be closed without saving any changes. If you click No you will be returned to your original screen.