Flat Rating: Building Your First SchemeServe Rating File

From SchemeServe Help
Revision as of 09:51, 4 December 2012 by Nickk (talk | contribs)
Jump to: navigation, search

Introduction

This area of SchemeServe is more complex than most others. In order for you to make the most out of using our Help Guide for developing your own rates, it would be best if you read all the parts of this guide in order. To help you with this they are listed in numerical order in the “See Also” section of each page. You can click on a link to take you to section 1 and then move through logically at your own pace.

There are two types of column in a CSV (Comma Separated Variable) rating file: Condition columns and Action columns.

Conditions: These make up the leftmost columns in the file and they define the specific conditions under which an action is performed. E.g. When to change a rate.

Actions: These are the rightmost columns in the file and they define what should happen when conditions are met. E.g. To increase/decrease a rate based on the conditions being met.

Advanced User Tip: If conditions are left out then the action column will be processed for all states of the case.


Creating a Condition:

  1. Determine the System ID of the Question you need to rate (see Editing Questions/Proposals for details)
  2. Open your CSV file (we've used Excel for the Video Tutorial but the principles are the same in Notepad++ and OpenOffice)
  3. Create the first column in the sheet – this column should be entitled “Answer:MyQuestion” where “MyQuestion” is the SystemId of the question you are conditionally rating
  4. In the rows beneath enter the answers that might be given for the question
  5. In the column next to this enter the corresponding rates and fees for each row

Note: Once you have saved your CSV file you will need to upload the rating file for it to be used in SchemeServe.


Video Tutorial


See Also:

  1. Introduction to Rates in SchemeServe
  2. Uploading SchemeServe Rating Files
  3. Downloading SchemeServe Rating Files
  4. Flat Rating: Building Your First SchemeServe Rating File
  5. Rating Modifiers: What they are and when to use them
  6. Multi-Step Ratings: Using Multiple Sections in Rating Files
  7. Advanced Ratings: Using Formulae
  8. Advanced Ratings: Conditional Statements and Functions
  9. Advanced Ratings: Rounding Values
  10. Master Rating: Using Tables and Row Lookup Loops
  11. Example Ratings for Specific Insurance Types (Life and Public Liability)
  12. Conditions for Rating Files
  13. Actions for Rating Files
  14. Mathematical Helper Functions for Ratings Files
  15. Rating Agents: Tips and Tricks