Mathematical Helper Functions for Ratings Files

From SchemeServe Help
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.

Mathematical Functions for Ratings

Here is a list of quick mathematical functions which can be used in your rating files. They can be used anywhere: within data cells, column headers and even right within other functions like IF.

Function Description
cos()Takes a single parameter of a radius angle and returns the "cos" of it.
sin() Takes a single parameter of a radius angle and returns the "sin" of it.
tan()Takes a single parameter of a radius angle and returns the "tan" of it.
cosh() Takes a single parameter of a radius angle and returns the "cosh" of it.
sinh()Takes a single parameter of a radius angle and returns the "sinh" of it.
tanh() Takes a single parameter of a radius angle and returns the "tanh" of it.
ln()Takes a single parameter of a number and returns the "ln" of it, which is the logarithm of base "e".
log() Takes a single parameter of a number and returns the "log" of it, which is the logarithm of base "10".
logn()Takes two parameters; the first is a number that we want to compute the logarithm of; the second parameter is the base of the logarithm.
sqrt() Takes a single parameter number and returns its square root.
abs()Takes a single parameter number and returns its absolute value.
acos() Takes a single parameter number and returns its "arc cos".
asin()Takes a single parameter number and returns its "arc sin".
atan() Takes a single parameter number and returns its "arc tan".
exp()Takes a single parameter number and returns its exponent.


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. Conditions for Rating Files
  6. Actions for Rating Files
  7. Rating Modifiers: What they are and when to use them
  8. Multi-Step Ratings: Using Multiple Sections in Rating Files
  9. Advanced Ratings: Using Formulae
  10. Advanced Ratings: Conditional Statements and Functions
  11. Advanced Ratings: Rounding Values
  12. Master Rating: Using Tables and Row Lookup Loops
  13. Example Ratings for Specific Insurance Types (Life and Public Liability)
  14. Mathematical Helper Functions for Ratings Files
  15. Rating Agents: Tips and Tricks