G
Guest
Guest
Com'on Al, we need your erudite input here even if we can't understand it!
A quote engine is pretty simple database application. At its basic level all you need is a table that looks like:
Carrier_Name
Product_Name
Product_State
Age_Band_Start
Age_Band_End
Type (S=Single, F=Family, etc.)
Rate
The front-end screen accepts the search Input (In_) parms and turns them in to an SQL query such as:
select * from Master_Table where In_Age between Abe_Band_Start and Age_Band_End and In-Type = Type and In_State = Product_State
The output would be a list of carriers, products, and rates.
Anyone with some proficiency in Access could put up a bare-bones system in a day or two, perhaps less.
The hard part is populating the master table and keeping it updated. Add to that the data for every state and you are looking at a lot of work... but once you have it input, since rates don't change more than once or twice a year, if you had the time or the staff, it would not be a huge task.
I'm not sure this answers your question. There are several quote engines on the market now. What is the purpose of creating another one? I don't see a quote engine as a big money-maker... and I guess no one else does either... or there would be a ton of them out there?
Al
