Spreadsheet: 274761d1383214913-copy-row-from-one-worksheet-to-another-based-on-cell-value-test-data
Sheet: Options Pricing

Chassis Options |  | Cost
Option Number | Description | 2012-13 | 2013-14 | Dimension (mm)
6001502 | [NAME] | 780 | 780
6001602 | [NAME] | 210 | 230
6004203 | Auto Lubrication - Chassis & Bin Lift | 1895 | 1895
6004202 | Auto Lubrication - Chassis Only | 1045 | 1150
6004402 | Battery Isolation Switch | 360 | 395
6004403 | Battery Power Guard | 350
6001803 | Bus/Folding Passenger Door | 1650
6004003 | [NAME] for Header Lockers | 100
6001902 | Central Locking | 0
6001302 | [NAME] | 735 | 750
6004702 | Disc Lock Wheel Nuts | 230 | 250
6002604 | Driver +4 | 500 | 1650
6004802 | Engine Hour [NAME] | 130 | 140
6000402 | Exhaust Brake | 780 | 450
6002502 | Eye Wash | 60 | 50
6002202 | Fan | 135 | 150
6002302 | [NAME] | 60 | 75
6004902 | Fire Supression Kit | 1650
6002402 | First Aid Kit | 55 | 60
6005002 | FMS Gateway | 500 | 500
6003402 | [NAME] | 0
6005202 | Fuel Saver Pack | 5100 | 5100
6000000001 | Fuel Tank - 280 litre LHS | 0 | 200 | 1000
6000802 | Fuel Tank - 280 litre RHS | 0 | 0
6000000002 | Fuel Tank - 315 litre LHS | 0 | 200 | 12000
6000803 | Fuel Tank - 315 litre RHS | 0 | 200
6000710 | Gearbox Integral Retarder | 3150 | 2900
6005302 | Ground Plate for 2-way Radio | 50
6005402 | Handbrake Warning System | 365 | 400
6000902 | Heated Fuel Filter | 260 | 285
6002702 | Heated Seat | 0
6003002 | Heated Windscreen | 320 | 350
6003902 | Hi-Viz Entry Kit | 0
6005502 | Lashing Points | 320 | 350
6003102 | Locker [NAME] | 260 | 285
6005702 | Offroad kit | 250
6003603 | Radio | 0 | 250
 | Rear Air Suspension | 2500
6004704 | [NAME] | 100
6002902 | [NAME] | 0
6006202 | Spare wheel/[NAME] | 410 | 450
6005602 | Spray Supression Mudflaps - Front | 0
6005603 | Spray Supression Mudflaps - Front & Rear | 470 | 515
6003202 | Tachograph | 670 | 670
6000302 | Volvo 320 HP Euro 6 | 1000 | 1000
6006302 | Wheel Chocks | 0
6004703 | Wheel Nut Indicators | 210 | 230
Warranty & Training
 | [NAME] 2nd Year | 1100 | 1200
 | [NAME] Year | 2500 | 2500
 | Driveline - 3rd Year | 850 | 900
 | Factory Training Course | 500
[NAME]
6002001 | Right Hand Steer, Hinged Door
6002002 | Left Hand Steer, Hinged Door
6002003 | Dual Control
6002004 | Right Hand Steer, Bus Door on Left
6002005 | Left Hand Steer, Bus Door on Right
Engine
6003001 | Volvo 280 HP Euro 6
6003002 | Volvo 320 HP Euro 6
Seating
6026001 | Driver+3
6026002 | Driver+1
6026003 | Driver+2
6026004 | Driver+4
6026005 | Driver+5
Suspension
6010001 | Air Assist
6010002 | Full Air
Body Options
Option Number | Description | Cost
Lighting
1 | LED Body Beacons | 350 | 400
2 | Additional Work Light | 105 | 110
4 | Barrier Inspection Light | 105 | 110
3 | [NAME] | 105 | 110
5 | Work Station Lights | 190 | 210
Body Options
6 | Handwash Unit - Hot & Cold | 370 | 405 | 300
7 | Handwash Unit - Hot Only | 310 | 340 | 300
8 | Plastic Storage Box - 1000 |  | 350 | 1000
9 | Plastic [NAME] | 0 | 350 | 440
10 | Plastic Storage Box - 750 |  | 350 | 750
11 | Wire Mesh Storage Container - 1200 |  | 350 | 1200
12 | Wire Mesh Storage Container - 670 | 0 | 350 | 600
13 | Triangular Storage Box | 0 | 200
14 | Storage Tray | 0 | 250 | 500
15 | Battery Recycling Storage Box | 0 | 350 | 440
16 | 4 Load Cell System c/w PCO | 4200 | 4000
17 | 6 Load Cell System c/w PCO | 4800 | 4500
18 | 8 Load Cell System c/w PCO | 5950 | 5950
19 | PCO & Intelligent Barrier for non DE Chassis | 0
20 | Access Door c/w Grab Handles | 300
21 | Bi-Line Safety System c/w Anti Slip Paint | 950 | 1050
22 | Body Roof Rails c/w Anti Slip Paint | 320 | 350
23 | Brush & Shovel c/w Brackets | 100
24 | Bypass Filtration System | 630 | 700
25 | Crew Intercom - Dual Speaker | 260 | 285
26 | Crew Intercom - Single Speaker | 210 | 230
27 | Cycle Guards | 580 | 640
28 | External [NAME] | 160 | 175 | 250
29 | Fire Hydrant Point | 370 | 400
30 | Front of Body Netting | 110 | 120
31 | High Front of Body Dam | 0 | 200
32 | Hydraulic Oil Hand Pump | 310 | 350
33 | Lashing Points | 350
34 | Remote Service Tool | 0 | 250
35 | [NAME] | 0 | 160
36 | [NAME] Noise | 0 | 160
37 | Soft Pack/Green Waste Switch | 370 | 350
Tailgate
38 | Additional Hopper Prop | 90 | 100
39 | Control Station Overide Switch | 200
40 | External Controls | 470 | 515
41 | High Capacity Tailgate | 2000 | 3000
42 | [NAME] Valve | 60 | 65
43 | [NAME] | 1850 | 1950
44 | Multi Cycle Switch | 0 | 220
45 | Sacrificial Tailgate Floor | 0
46 | Steel Hopper Canopy | 370 | 400
Paint/Signwriting
47 | Two Colour Paint | 380 | 800
48 | Fit Free Issue Decals | 150 | 150
49 | Supply & Fit Decals | 500
Warranty & Training
50 | Full Warranty - 2nd Year | 600 | 600
51 | Full Warranty - 3rd Year | 1550 | 1550
52 | Hydraulics & Structure - 3rd Year | 1000 | 1000
53 | Structure Only - 3rd Year | 500 | 500
54 | Structure Only - 5th Year | 1550 | 1550
55 | Factory Training Course | 500