Introduction to Rates in SchemeServe
There is a very simple means of entering rates for basic calculation questions in SchemeServe. This section of the SchemeServe help guide, on the other hand, is focused on advanced rating structures using the Conditional Matrix.It is a good idea to familiarise yourself with all sections of this guide (find the other pages in the See Also section at the end of this article) before beginning rating exercises.
Note: ADM Network can develop rating files and schemes on your behalf – this is a chargeable service. If you would like to use this service please contact our support team (http://support.admnetwork.com) and ask about our Managed Schemes Service.
Basic/Concepts and Pre-Requisites for Creating Ratings
You should first examine the conditional rating tool supplied in the Questions Editor. You will need to fully understand Questions, Cases, Answers, Discounts and Loads before you begin creating complex ratings.
Before starting you should know:
- The System IDs of Questions that you intend to modify the rates, cover values or discounts on.
- Questions which you can apply ratings to must be set up as calculation questions.
- In the case of items that are a “Sum Insured” and which are not an “Indemnity Limit” you should have the “This is Coverage” Box ticked for them.
- You should leave the rate blank in the question editor for any conditional rating where you will be using the more complex methodology. This is to prevent confusion and/or any miscalculations of rates.
Tools for Developing Ratings:
- Open Office (Windows, Mac, Linux: http://www.openoffice.org/download) – The spreadsheet package offers more reliable results when working with CSV (Comma Separated Variable) files than Excel. It is free to download and use.
- GS-Calc (Windows: http://citadel5.com/gs-calc.htm)– Most spreadsheet packages cannot handle more than 1 million rows. In many instances this isn't a problem but if you wish to include UK Postcode Lookups in your ratings – there are over 1.7 million rows and GS-Calc offers good value at $19.95 (US Dollars)
- Notepad++ (Windows: http://notepad-plus-plus.org/download) now that Notepad is no longer standard with Windows this freeware text editor is a great solution for debugging your CSV files.
- Textmate (Mac: http://macromates.com/)– the best text editor for the Apple Mac.
- Introduction to Rates in SchemeServe
- Uploading SchemeServe Rating Files
- Downloading SchemeServe Rating Files
- Flat Rating: Building Your First SchemeServe Rating File
- Rating Modifiers: What they are and when to use them
- Multi-Step Ratings: Using Multiple Sections in Rating Files
- Advanced Ratings: Using Formulae
- Advanced Ratings: Conditional Statements and Functions
- Advanced Ratings: Rounding Values
- Master Rating: Using Tables and Row Lookup Loops
- Example Ratings for Specific Insurance Types (Life and Public Liability)
- Conditions for Rating Files
- Actions for Rating Files
- Mathematical Helper Functions for Ratings Files
- Rating Agents: Tips and Tricks