Introduction to Rates in SchemeServe

From SchemeServe Help
Revision as of 23:56, 2 December 2012 by Nickk (talk | contribs) (Created page with "There is a very simple means of entering rates for basic calculation questions in SchemeServe. This section of the SchemeServe help guide, on the ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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:

  1. Open Office – The spreadsheet package offers more reliable results when working with CSV (Comma Separated Variable) files than Excel. It is free to download and use.
  2. GS-Calc – 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)
  3. Notepad++ now that Notepad is no longer standard with Windows this freeware text editor is a great solution for debugging your CSV files.
  4. Textmate – the best text editor for the Apple Mac.


See Also:

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