Go to home page

Event Calendar

Advanced Training Course 1 - June 2019
Hits : 400 2019-06-26

Advanced Training Course 1 (26th June 2019)

Our 1-day Advanced Training Course allows our clients to learn about concepts and functionalities not covered in our Foundation and ALM Course. These modules are advanced and are aimed at Intermediate/Advanced level R³S Modeler users. Clients attending this course could find solutions to meet their more complex modelling needs.

Find the modules covered in Advanced Training Course 2 here.


Advanced Training Course 1

The following advanced modules will be taught in this session:

  • Result Grouping & Calculation Grouping      
  • New Business & Initialisation module                  
  • Projected data layer


Results Grouping & Calculation Grouping

The Grouping components controls the way in which results from calculations are aggregated in subsequent calculations and in output. There are two Grouping components within R³S Modeler, the Results Grouping and the Calculation Grouping. 

Users attending this module will learn how to separate aggregated results at the results stage and how to group records together when they are passed from a child program to a parent program.

This module is ideal for users who want to learn all the methods of grouping calculations and results together in R³S Modeler.

Module overview

  • Set up a grouping to be used as a result grouping
  • Apply a result grouping to a program or layer in a model
  • Understand how to use the Excel add-in to display grouped results
  • Set up a grouping to be used as a calculation grouping, which enables records to be grouped together when they are passed from child programs into a parent program

New Business

Modelling future new business (in other words policies which are not in force at the start of the projection) is an important requirement and a common component to consider when modelling Life insurance products. 

Using the same model to value future new business alongside existing (in force) business avoids the risks inherent in having to maintain separate models and ensures consistency in the valuation of all business. This module outlines how R³S Modeler allows you to model future new business using the same models as for existing business, with maximum ease.

Users attending this module will learn how to include new business policies into an R³S model and the considerations to be made when initializing variables.

Module overview

  • Understand how new business policies can be incorporated into a model
  • To be aware of the usual need for additional IIP variables for new business
  • To be aware of what may and may not be output for new business
  • How to use Initialization modules in conjunction with New Business policies


Projected Data

The projected data layer component allows cashflows that are calculated outside of R³S Modeler to be read into an existing R³S model.

This functionality is advantageous for clients who have calculations that are done outside of R³S Modeler (i.e. Excel or another actuarial modelling tool) but would like to consolidate their cashflows in an R³S model. Projected data layers allow external cashflows to be read via an ODBC connection.

Clients attending this module will learn how to read external aggregate cashflows and how the projected data component works alongside other components in an existing R³S model. 

Module overview

  • Introduction to the Projected Data component
  • Learn how to read in external cashflows via the projected data layer
  • How to use the Data Layer in conjunction with the Projected Data Layer.

For fees and booking information, please contact training@rnaanalytics.com

Find the full 2019 Training Schedule here.


Estimated Resources
In addition to our scheduled courses, an R³S Modeler training course can also be carried out as a ‘private course’ at an RNA Analytics office or provided onsite at your offices.

The teacher led training courses would require 1 or 2 trainers depending on the number of delegates to be taught, as shown in the table below.

Number of delegates

Number of trainers

1 to 6


7 to 14