Car Quotation System-Implementation
Member rating: No Rating | Words: 1804 | Submitted: Mon Jun 18 2007
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Implementation: Setting up the Insurance Groups worksheet: I started off by setting up a sheet that would contain all the information on the cars and their insurance groups. First of all I entered the number per car in column A; this is so later, the cars can be looked up easily. I entered the makes of the cars in column B, the model of the car in column C, the IG of the cars in column D. The Insurance Groups number from 1 to group 20; this range will easily include the Vauxhall cars Insurance Groups. I entered the basic premiums in column I. I also added a column in E that would produce a unique name for a car by combining the make and model. I did this by typing in a formula that combined the contents of column B and C. I then highlighted the area A1 to E10 and went to...

