System and method for computerized insurance rating
First Claim
Patent Images
1. A computerized system for rating possible insurance risk, comprising:
- an insurance computer system for receiving and storing risk information;
a web service in electronic communication with said insurance computer system for receiving said risk information from the insurance computer system, wherein said web service also being provided for transmitting risk rating information to said insurance computer system; and
a calculation engine in electronic communication with said web service and configured to;
load, from a data repository for storing rating spreadsheets for calculation of risk rating data, instances of selected ones of workbooks of the stored spreadsheets;
populate cells of said workbooks with data based on said received risk information;
perform calculations employing formulas included in said workbooks to determine risk rating information and premium data; and
furnish results of the calculations from the cells of the workbooks to the web service;
said insurance computer system configured to receive said risk rating information and premium data from said web service and parse said risk rating information and premium data for display on a user interface;
wherein the workbooks are loaded responsive to identifying a cell name in a workbook corresponding to a field name in a document generated by the insurance computer system for furnishing the risk information to the web service, andwherein the document is in XML format, and the data from one or more fields in the XML format document is mapped to one or more cells in the workbook having the corresponding name.
0 Assignments
0 Petitions
Accused Products
Abstract
The invention relates generally to a computer system and method for integrating insurance policy underwriting. In one aspect, it integrates an older legacy insurance policy generating system to on-line rating systems where users access the system through browsers. The computer system to perform the process of dynamically rating includes generating an input XML file of risk information that is sent to a web service and calculated in a calculation engine. The processed data is retrieved by the web service and transmitted as an XML file to a user interface that parses the rating information and displays the data.
345 Citations
19 Claims
-
1. A computerized system for rating possible insurance risk, comprising:
-
an insurance computer system for receiving and storing risk information; a web service in electronic communication with said insurance computer system for receiving said risk information from the insurance computer system, wherein said web service also being provided for transmitting risk rating information to said insurance computer system; and a calculation engine in electronic communication with said web service and configured to; load, from a data repository for storing rating spreadsheets for calculation of risk rating data, instances of selected ones of workbooks of the stored spreadsheets; populate cells of said workbooks with data based on said received risk information; perform calculations employing formulas included in said workbooks to determine risk rating information and premium data; and furnish results of the calculations from the cells of the workbooks to the web service; said insurance computer system configured to receive said risk rating information and premium data from said web service and parse said risk rating information and premium data for display on a user interface; wherein the workbooks are loaded responsive to identifying a cell name in a workbook corresponding to a field name in a document generated by the insurance computer system for furnishing the risk information to the web service, and wherein the document is in XML format, and the data from one or more fields in the XML format document is mapped to one or more cells in the workbook having the corresponding name. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer implemented method for providing real time insurance risk rating information, comprising the steps of:
-
receiving at a front-end computer system, via a user interface in electronic communication with a user computer, insurance risk information; loading, from a data repository for storing rating spreadsheets for calculation of risk rating data, by a processor of a calculation engine, the calculation engine being in electronic communication with a web service, instances of selected ones of workbooks of the rating spreadsheets; populating by the processor of the calculation engine, cells of said workbooks with data based on said received insurance risk information; calculating, by the processor of the calculation engine employing formulas included in said workbooks, risk rating information and premium data and populating cells of said workbooks with the calculated risk rating information and premium data; furnishing by the processor of the calculation engine the risk rating information and the premium data from the cells of the workbooks to the web service; transmitting, via the web service, the furnished risk rating information and premium data to the front-end computer system; and parsing by the front-end computer system, the transmitted risk rating information and premium data for display on the user interface, wherein the workbooks are loaded responsive to identifying a cell name in a workbook corresponding to a field name in a document generated by the front-end computer system for furnishing the risk information to the web service, and wherein the document is in XML format, and the data from one or more fields in the XML format document is mapped to one or more cells in the workbook having the corresponding name. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A computerized system for rating possible insurance risk comprising:
-
an insurance computer system for receiving risk information via a user interface; a web service in electronic communication with said insurance computer system for receiving said risk information from the insurance computer system and for transmitting risk rating information to said insurance computer system; a calculation engine in electronic communication with said web service for calculating said risk rating information; a data repository in communication with said calculation engine for storing calculations for rating spreadsheets, wherein instances of selected ones of workbooks of the rating spreadsheets are loaded from the data repository by the calculation engine, cells of the workbooks are populated with data based on said received risk information, calculations in accordance with formulas included in said workbooks are performed to determine risk rating information, and wherein said calculation engine transmits said risk rating information to said web service, and said insurance computer system receives said risk rating information and displays said risk rating information on said user interface, wherein the workbooks are loaded responsive to identifying a cell name in a workbook corresponding to a field name in a document generated by the insurance computer system for furnishing the risk information to the web service, and wherein the document is in XML format, and the data from one or more fields in the XML format document is mapped to one or more cells in the workbook having the corresponding name. - View Dependent Claims (18, 19)
-
Specification