Spreadsheet: 149044d1333657741-can-the-colour-of-one-cell-be-determined-by-the-information-in-another-lastest-logs1
Sheet: Sheet6

BESTODECK GROUP WARRANTY
PRICE LIST EFFECTIVE FROM 1st DECEMBER 2011 - SURCHARGED 20%
BESTODECK MAIN POLICY - UNDER 5 YEARS/60000 MILES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP INSURANCE EFFECTIVE FROM 1st MARCH 2012
STANDARD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POLICY NUMBER MAKEUP |  |  | Maximum
 |  | CHARGE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Payout
MTHS | GROUP | OUT |  |  |  |  |  |  |  |  |  |  |  | VEHICLE REPLACEMENT -  (VRI) |  |  |  |  | SMCVRI36A
 |  | 2011-12-01 00:00:00 |  |  | POLICY NUMBER MAKEUP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S GUARD
0S | S | 0 |  |  | SMDFA 11 A |  |  |  | OPTIONS |  |  |  |  |  |  |  | NOTE 1 | A | = SELLING PRICE OF VEHICLE |  |  |  |  |  | 55.5
1S | S | 90 |  |  | 11 = PERIOD OF WARRANTY IN MONTHS |  |  |  | 1 - 36 |  |  |  |  |  |  | CHARGE |  | NOTE 1 | A  = £0 - £10000 |  |  | 20000
2S | S | 100 |  |  | A = COMMENCEMENT DATE FOR WARRANTY |  |  |  | D,N,X,Z |  |  |  |  | PERIOD | TYPE | OUT |  |  | B = £10001 - £15000 |  |  | 20000
3S | S | 105 |  | NT 2 | B = TYPE OF COVER |  |  |  | S,P |  |  |  |  |  |  | 2012-03-01 00:00:00 |  |  | C = £15001 - £25000 |  |  | 20000
4S | S | 115 |  | NT 3 | 4 = RECOVERY(INCLUDED) |  |  |  |  |  |  |  |  |  |  |  |  |  | D = £25001 - £50000 |  |  | 20000
5S | S | 120 |  | NT 4 | M=MOT COVER (INCLUDED) |  |  |  |  |  |  |  |  | TO  3 YRS | A | 159
6S | S | 140 |  |  | NOTES
7S | S | 155 |  |  |  |  |  |  |  |  |  |  |  | TO  3 YRS | B | 171
8S | S | 170 |  | NT 2 | S- STANDARD RISK VEHICLES
9S | S | 190 |  |  | P-PRESTIGE/4x4 |  |  |  |  |  |  |  |  | TO  3 YRS | C | 178
10S | S | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALL PRICES EXCLUDE IPT WHICH WILL BE
11S | S | 220 |  | NT 3 | £2 PER MONTH RECOVEY (INCLUDED) |  |  |  |  |  |  |  |  | TO  3 YRS | D | 187 |  | ADDED AT 20.0% OF THE RETAIL PRICE
12S | S | 240
13S | S | 250 |  | NT 4 | £12 FOR COVER FOR NEXT MOT FAILURES (INCLUDED )
14S | S | 265 |  |  | £350 LIMIT NO EXCESS
15S | S | 275 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POLICY NUMBER MAKEUP
16S | S | 285
17S | S | 295 |  |  |  |  |  |  |  |  |  |  |  | PURCHASE PRICE PROTECTION - (PPP) |  |  |  |  | SMCPPP36A
18S | S | 310
19S | S | 325 |  |  |  |  |  |  |  |  |  |  |  |  |  | CHARGE | NOTE 1 | A | = SELLING PRICE OF VEHICLE
20S | S | 335 |  |  |  |  |  |  |  |  |  |  |  | PERIOD | TYPE | OUT
21S | S | 350 |  |  |  | USED CARS |  |  | NEW CARS |  |  |  |  |  |  | 2012-03-01 00:00:00 |  | NOTE 1 | A  = £0 - £10000 |  |  | 5000
22S | S | 365 |  |  |  | KA | CAR |  | KA | NEW CAR |  |  |  |  |  |  |  |  | B = £10001 - £15000 |  |  | 7500
23S | S | 380 |  |  |  | FIESTA | CAR |  | FIESTA | NEW CAR |  |  |  | TO  3 YRS | A | 90 |  |  | C = £15001 - £25000 |  |  | 10000
24S | S | 400 |  |  |  | FOCUS | CAR |  | FOCUS | NEW CAR |  |  |  |  |  |  |  |  | D = £25001 - £50000 |  |  | 20000
25S | S | 410 |  |  |  | C-MAX | CAR |  | C-MAX | NEW CAR |  |  |  | TO  3 YRS | B | 100
26S | S | 420 |  |  |  | [NAME] | CAR |  | [NAME] | NEW CAR |  |  |  |  |  |  |  | ALL PRICES EXCLUDE IPT WHICH WILL BE
27S | S | 430 |  |  |  | G C-MAX | CAR |  | G C-MAX | NEW CAR |  |  |  | TO  3 YRS | C | 110 |  | ADDED AT 20.0% OF THE RETAIL PRICE
28S | S | 440 |  |  |  | S-MAX | CAR |  | S-MAX | NEW CAR
29S | S | 455 |  |  |  | B-MAX | CAR |  | B-MAX | NEW CAR |  |  |  | TO  3 YRS | D | 120
30S | S | 475 |  |  |  | FUSION | CAR |  | FUSION | NEW CAR
31S | S | 490 |  |  |  | MONDEO | CAR |  | MONDEO | NEW CAR
32S | S | 500 |  |  |  | GALAXY | CAR |  | GALAXY | NEW CAR
33S | S | 515
34S | S | 530
35S | S | 540
36S | S | 550
PRESTIGE |  |  |  |  |  | FIESTA VAN | COMMERCIAL |  | FIESTA VAN | COMMERCIAL
 |  |  |  |  |  | CONNECT | COMMERCIAL |  | CONNECT | COMMERCIAL
 |  | CHARGE |  |  |  | TRANSIT | COMMERCIAL |  | TRANSIT | COMMERCIAL
MTHS | GROUP | OUT |  |  |  | MINI BUS | COMMERCIAL |  | MINI BUS | COMMERCIAL
 |  | 2011-12-01 00:00:00 |  |  |  | LUTON | COMMERCIAL |  | LUTON | COMMERCIAL
1P | P | 110 |  |  |  | RANGER | COMMERCIAL |  | RANGER | COMMERCIAL
2P | P | 120
3P | P | 130
4P | P | 140
5P | P | 165
6P | P | 190
7P | P | 205
8P | P | 225
9P | P | 255
10P | P | 275
11P | P | 295
12P | P | 315
13P | P | 335
14P | P | 345
15P | P | 365
16P | P | 385
17P | P | 400
18P | P | 425
19P | P | 450
20P | P | 475
21P | P | 500
22P | P | 520
23P | P | 545
24P | P | 570
25P | P | 580
26P | P | 590
27P | P | 600
28P | P | 610
29P | P | 625
30P | P | 640
31P | P | 650
32P | P | 665
33P | P | 680
34P | P | 690
35P | P | 705
36P | P | 725