• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11

Car Quotation System-Implementation

Extracts from this document...


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 'Insert', 'Name' and then 'Define'. I called this area 'Groups'. I also highlighted from H1 to I12 and named it 'Costs'. Setting up the Multipliers worksheet The second sheet I set up was the multipliers sheet, which would hold all the factors and their multiplying figure. I entered the separate multipliers onto the sheet, age, sex, area, no-claims bonus and the type of insurance. I entered numbers in column A, which will be needed later to lookup the multipliers. ...read more.


automate the filling of the quotes into the customer: First I recorded a macro like above, this time I called the macro save quote. This macro takes along time to record as it involves copying each of the necessary cells form the quotes sheet, then pasting the cells onto the customer's worksheet. I did this by selecting the first black row on the customer's worksheet, c licking insert, rows. I did this so every time a new quote is saved it will be added in at the top, without replacing old quotes. I then switched back to the Quotes sheet by using the toolbar at the bottom of the screen. I subsequently selected the relevant cell, clicking Edit Copy, then switching to the customers sheet, clicking the relevant cell and finally Edit, paste Special. I used 'paste Special' So only what appears in the cell is copied and not any formulas any formulas that may have been in the cell. Once I copied and pasted all the cells so the headers were all completed, I stopped recording the macro by using the visual basic toolbar and clicking 'stop recording'. This illustration shows the customer worksheet, containing some filled in quotes suing the save quote macro: Setting up macros to get around my system: On the quotes worksheet, I set up macros, that would let the user access the groups worksheet, the multipliers worksheet, view saved quotes and a macro that will let the user print the quote off. ...read more.


This box then appeared, when ever the title cell was actively selected. (Below) Secondly I added a validation rule to the customer's forename and surname. I did this using the same process, which was selecting the relevant cells and clicking Data, then Validation. I chose the text length to be between 1 and 15 so errors such as holding downwards a key by mistake or missing the cells out which would result in an error. I then typed in the error alert that would appear if the user typed in a word over 15 or left the cell blank. I added validation rules also to the Customer's addresses by adding a presence check, so an error message would appear if the cell were left blank. I did this by following the steps I did above for the other validation rules. I added a validation rule also for the customer's postcode; I did this by clicking Data and then Validation. I then set the criteria to text length seven, which would only allow the seven characters needed for a postcode. I then typed in the message and then the error alert. Finally I added a validation rule to the customer's telephone number box, by clicking Data and Validation again. I set the criteria to be 'equal to' 12, which would allow all telephone numbers to be entered, from a mobile phone number to a different regional number from a different part of the UK. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Molecules & Cells section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Molecules & Cells essays

  1. Hang up the phone and drive

    Enforcing laws to prohibit the use of a cell phone while driving can work too. The problem is that our roads are not safe to drive on due to people carelessly using their cell phones while they are driving. They are more concerned about conversations that can wait than they are about driving.

  2. Implementation for Mobile Tariff Selector

    Instead of me writing out the equation again, I dragged it down to the other four tariffs. This means if the number in my peak minutes that the customer uses is bigger than the number of free minutes given by the talk plan, then in the cell it types the

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work