ICFS-Plus: Actuarial Software for the Property and Causality Insurance Industry

ICRFS-Plus™ Training videos for new users


If for any reason you are unable to view the training or demonstration videos, please contact our support staff at support@insureware.com and we will arrange to send you a copy of the videos on CD-Rom. You will be able to run the videos from the CD.


The training videos should be used for hands on training. We suggest you run the videos on a separate computer using a data projector, and train as a group.

The only way you will learn all the new concepts and be able to exploit all the immense benefits is by using the system. Experiential learning is imperative.

It is important that you study the videos in sequential order as set out below.


Table of Contents

1. Introduction to ICRFS-Plus™ 10.2 and modelling modules

    2. Modelling using the Link Ratio Techniques and Extended Link Ratio Family modules

      3. Introduction to the Probabilistic Trend Family modelling framework

        4. Modelling real data (CTP) in the PTF modelling framework

          5. Case Study: CS5

            6. Case Study: ABC

              7. Modelling Wizard

                8. Further PTF Modelling Examples

                  9. Layers and the PALD Module

                    10. Uneven Sampling periods, updating, and various other topics

                      11. Introduction to MPTF

                        12. MPTF Modelling Framework

                          13. Advanced MPTF modelling

                            14. Importing and Reporting

                            14. Importing and Reporting

                            14.1 COM Importing and Schedule P


                            In this video we describe the method of importing data into ICRFS-Plus using COM Scripts. Data stored in triangle format or unit record transaction data format can be imported into an ICRFS-Plus relational database using the exposed ICRFS-Plus COM interface. In principle, any application which is COM enabled can interact with the ICRFS-Plus COM technology.


                            The modelling wizard is run on all incremental triangles in the database (for the sake of the demonstration, only one triangle group is included in the sample database).


                            We demonstrate two examples of importing. The first uses Excel Spreadsheets for the source data and COM Scripts. The COM Scripts consist of two files - one file describes how the spreadsheets are formatted, the other actually imports the data. Once the template is defined, it is trivial to import data or to update data.


                            The second importing demonstration imports data from an Access database in unit record format. Queries into the database are definable using SQL syntax so that any desired combination of triangles can be created.


                            Collapsing from Quarter versus Quarter to Annual versus Quarter is demonstrated.


                            The video illustrating COM and Schedule P is viewable here (15 minutes).


                            14.2 Report Templates


                            This video contains a brief description of report templates.


                            An example of creating a report for the Composite Triangle Group LOB A B C D E F G H I J is conducted.


                            We also demonstrate the use of a report template for another composite triangle group comprising five lines of business.


                            The video demonstrating the use of reports is available here (10 minutes).