Add a new Lookup key value to an existing lookup

Example 1

1. VehicleAge lookup is configured with:

   1. Lookup Type = LowerBoundRange

   2. Type Of The Identity Key In Lookup = int

   3. Type Of The Value in Lookup = decimal
      
      

      Open

      

2. You want to add the new rate = 1.07 if VehicleAge > 7

Steps to do

1. Clone the active version to a new product version. Product Details

2. Go to Lookup tab. Lookup tab

3. Download the Lookup file of the product version.

   Open

   

4. Find the Lookup name “VehicleAge” in Motor_Lookup_v10.xlsx sheet

5. What you can interpret from the above lookup table (minimum VehicleAge = 0, no maximum):

   1. If VehicleAge <= -1 (i.e. <0), no lookup key → no rate for cover “ThirdPartyBodilyInjury10011”

   2. If VehicleAge > -1 and <= 1 (i.e. 0, 1), lookup key “-1” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   3. If VehicleAge > 1 and <= 2 (i.e. 2), lookup key “1” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   4. If VehicleAge > 2 and <= 3 (i.e. 3), lookup key “2” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   5. If VehicleAge > 3 and <= 5 (i.e. 4, 5), lookup key “3” → rate for cover “ThirdPartyBodilyInjury10011” = 0.96

   6. If VehicleAge > 5 (i.e. 6, 7, 8…), lookup key “5” → rate for cover “ThirdPartyBodilyInjury10011” = 1.05

6. Now you want to add the rate = 1.07 if VehicleAge > 7, then you need to add a new row to the lookup sheet as below:

7. What you can interpret from the above lookup table:

   1. If VehicleAge <= -1 (i.e. <0), no lookup key → no rate for cover “ThirdPartyBodilyInjury10011”

   2. If VehicleAge > -1 and <= 1 (i.e. 0, 1), lookup key “-1” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   3. If VehicleAge > 1 and <= 2 (i.e. 2), lookup key “1” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   4. If VehicleAge > 2 and <= 3 (i.e. 3), lookup key “2” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   5. If VehicleAge > 3 and <= 5 (i.e. 4, 5), lookup key “3” → rate for cover “ThirdPartyBodilyInjury10011” = 0.96

   6. If VehicleAge > 5 and <= 7 (i.e. 6, 7), lookup key “5” → rate for cover “ThirdPartyBodilyInjury10011” = 1.05

   7. If VehicleAge > 7 (i.e. 8, 9, 10…), lookup key “7” → rate for cover “ThirdPartyBodilyInjury10011” = 1.07

8. Save the lookup file and upload it again to the new product version.

9. Save the product version.

10. Publish the product version.

11. To verify the change, create a new quote to see the change.

Change the Lookup Type from LowerBoundRange to HigherBoundRange

Example 2

1. VehicleAge lookup is configured with:

   1. Lookup Type = LowerBoundRange

   2. Type Of The Identity Key In Lookup = int

   3. Type Of The Value in Lookup = decimal

2. You want to change Lookup Type to HigherBoundRange (no minimum, maximum VehicleAge is 7):

   1. If VehicleAge < 2 (i.e. … -1, 0, 1), lookup key “2” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   2. If VehicleAge < 3 (i.e. 2), lookup key “3” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   3. If VehicleAge < 4 (i.e. 3), lookup key “4” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   4. If VehicleAge < 6 (i.e. 4, 5), lookup key “6” → rate for cover “ThirdPartyBodilyInjury10011” = 0.96

   5. If VehicleAge < 8 (i.e. 6, 7), lookup key “8” → rate for cover “ThirdPartyBodilyInjury10011” = 1.05

   6. If VehicleAge >=8 (i.e. 8, 9, 10…), no lookup key → no rate for cover “ThirdPartyBodilyInjury10011”

Steps to do

1. Clone the active version to a new product version. Product Details

2. Go to Lookup tab. Lookup tab

3. Download the Lookup file of the product version.

4. Find the Lookup name “VehicleAge” in Motor_Lookup_v10.xlsx sheet

5. What you can interpret from the above lookup table:

   1. If VehicleAge <= -1 (i.e. <0), no lookup key → no rate for cover “ThirdPartyBodilyInjury10011”

   2. If VehicleAge > -1 and <= 1 (i.e. 0, 1), lookup key “-1” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   3. If VehicleAge > 1 and <= 2 (i.e. 2), lookup key “1” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   4. If VehicleAge > 2 and <= 3 (i.e. 3), lookup key “2” → rate for cover “ThirdPartyBodilyInjury10011” = 0.9

   5. If VehicleAge > 3 and <= 5 (i.e. 4, 5), lookup key “3” → rate for cover “ThirdPartyBodilyInjury10011” = 0.96

   6. If VehicleAge > 5 and <= 7 (i.e. 6, 7), lookup key “5” → rate for cover “ThirdPartyBodilyInjury10011” = 1.05

   7. If VehicleAge > 7 (i.e. 8, 9, 10…), lookup key “7” → rate for cover “ThirdPartyBodilyInjury10011” = 1.07

6. Now you want to change Lookup Type to HigherBoundRange