Spreadsheet: 542871d1508150683-getting-data-from-one-sheet-to-another-depending-on-two-text-values-incident-summary-dummy
Sheet: Driver

Drivers - Damage Costs and Traffic Offences  - Dummy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GJ62 UUR | Tipper
Date | Driver | Incident Type | Off the Highway Disclaimer Signed? | Vehicle Registration | Vehicle Type | Cost £ | Traffic Offence Code | Traffic Offences | Fines | Points | Paid? |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Tipper
2010-01-01 00:00:00 | [NAME] | Windscreen |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Tipper
2010-01-02 00:00:00 | [NAME] | RTA |  |  |  | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EY15 BTF | Tipper
2010-01-03 00:00:00 | [NAME] | Property Damage |  |  |  | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EY15 BTO | Tipper
2010-01-04 00:00:00 | [NAME] | Windscreen |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EY15 BTU | Tipper
2010-01-05 00:00:00 | [NAME] | RTA |  |  |  | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LX14 BHE | RORO
2010-01-06 00:00:00 | [NAME] | Property Damage |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 8WG
2010-01-07 00:00:00 | [NAME] | Windscreen |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LX14 BGO | 8WG
2010-01-08 00:00:00 | [NAME] | RTA |  |  |  | 3000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LX64 EAA | 4WG
2010-01-09 00:00:00 | [NAME] | Property Damage |  |  |  | 400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LX64 EAO | 6WG
2010-01-10 00:00:00 | [NAME] | Windscreen |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EU66 WYB | 8WG
2010-01-11 00:00:00 | [NAME] | RTA |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EU66 WYC | 8WG
2010-01-12 00:00:00 | [NAME] | Property Damage |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 8WG
2010-01-13 00:00:00 | [NAME] | Windscreen |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EU67 WWN | Tipper
2010-01-14 00:00:00 | [NAME] | RTA |  |  |  | 250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EU67 WWL | Tipper
2010-01-15 00:00:00 | [NAME] | Property Damage |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EU67 WWM | Tipper
2010-01-16 00:00:00 | [NAME] | [NAME] |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KX63 NJV | Volumetric Mixer
2010-01-17 00:00:00 | [NAME] | [NAME] |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KX63 NFR | Volumetric Mixer
2010-01-18 00:00:00 | [NAME] | Windscreen |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KN63 WNY | Volumetric Mixer
2010-01-19 00:00:00 | [NAME] | Windscreen |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PO64 DHY | Volumetric Mixer
2010-01-20 00:00:00 | [NAME] | Windscreen |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PO15 AOE | Volumetric Mixer
2010-01-21 00:00:00 | [NAME] | Property Damage |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PO15 AYT | Volumetric Mixer
2010-01-22 00:00:00 | [NAME] | Property Damage |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KX65 CKP | Volumetric Mixer
2010-01-23 00:00:00 | [NAME] | Property Damage |  |  |  | 400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KX65 CKO | Volumetric Mixer
2010-01-24 00:00:00 | [NAME] | Windscreen |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KX65 ELH | Volumetric Mixer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KX66 CKO | Screed Mixer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LJ67 HBN | Volumetric Mixer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LJ67 HCL | Screed Mixer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Volumetric Mixer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LJ17 TJY | Volumetric Mixer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LJ17 TYS | Volumetric Mixer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LJ17 TFK | Volumetric Mixer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LK64 LVD | 24m [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GD65 NBN | 36m [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Line Pump
AC10 | Failing to stop after an accident | 5 to 10 |  |  | AC10 | 5 to 10
AC20 | Failing to give particulars or report an accident within 24 hours | 5 to 10 |  |  | AC20 | 5 to 10
AC30 | Undefined accident offences | 4 to 9 |  |  | AC30 | 4 to 9
BA10 | Driving while disqualified by order of court | 6 |  |  | BA10 | 6
BA30 | Attempting to drive while disqualified by order of court | 6 |  |  | BA30 | 6
BA40 | Causing death by driving while disqualified | 3 to 11 |  |  | BA40 | 3 to 11
BA60 | Causing serious injury by driving while disqualified | 3 to 11 |  |  | BA60 | 3 to 11
CD10 | Driving without due care and attention | 3 to 9 |  |  | CD10 | 3 to 9
CD20 | Driving without reasonable consideration for other road users | 3 to 9 |  |  | CD20 | 3 to 9
CD30 | Driving without due care and attention or without reasonable consideration for other road users | 3 to 9 |  |  | CD30 | 3 to 9
CD40 | Causing death through careless driving when unfit through drink | 3 to 11 |  |  | CD40 | 3 to 11
CD50 | Causing death by careless driving when unfit through drugs | 3 to 11 |  |  | CD50 | 3 to 11
CD60 | Causing death by careless driving with alcohol level above the limit | 3 to 11 |  |  | CD60 | 3 to 11
CD70 | Causing death by careless driving then failing to supply a specimen for alcohol analysis | 3 to 11 |  |  | CD70 | 3 to 11
CD80 | Causing death by careless, or inconsiderate, driving | 3 to 11 |  |  | CD80 | 3 to 11
CD90 | Causing death by driving: unlicensed, disqualified or uninsured drivers | 3 to 11 |  |  | CD90 | 3 to 11
CU10 | Using a vehicle with defective brakes | 3 |  |  | CU10 | 3
CU20 | Causing or likely to cause danger by reason of use of unsuitable vehicle or using a vehicle with parts or accessories (excluding brakes, steering or tyres) in a dangerous condition | 3 |  |  | CU20 | 3
CU30 | Using a vehicle with defective tyre(s) | 3 |  |  | CU30 | 3
CU40 | Using a vehicle with defective steering | 3 |  |  | CU40 | 3
CU50 | Causing or likely to cause danger by reason of load or passengers | 3 |  |  | CU50 | 3
CU80 | Breach of requirements as to control of the vehicle, such as using a mobile phone | 3 to 6 |  |  | CU80 | 3 to 6
DD10 | Causing serious injury by dangerous driving | 3 to 11 |  |  | DD10 | 3 to 11
DD40 | Dangerous driving | 3 to 11 |  |  | DD40 | 3 to 11
DD60 | Manslaughter or culpable homicide while driving a vehicle | 3 to 11 |  |  | DD60 | 3 to 11
DD80 | Causing death by dangerous driving | 3 to 11 |  |  | DD80 | 3 to 11
DD90 | Furious driving | 3 to 9 |  |  | DD90 | 3 to 9
DR10 | Driving or attempting to drive with alcohol level above limit | 3 to 11 |  |  | DR10 | 3 to 11
DR20 | Driving or attempting to drive while unfit through drink | 3 to 11 |  |  | DR20 | 3 to 11
DR30 | Driving or attempting to drive then failing to supply a specimen for analysis | 3 to 11 |  |  | DR30 | 3 to 11
DR31 | Driving or attempting to drive then refusing to give permission for analysis of a blood sample that was taken without consent due to incapacity | 3 to 11 |  |  | DR31 | 3 to 11
[NAME] | Refusing to give permission for analysis of a blood sample that was taken without consent due to incapacity in circumstances other than driving or attempting to drive | 10 |  |  | [NAME] | 10
DR40 | In charge of a vehicle while alcohol level above limit | 10 |  |  | DR40 | 10
DR50 | In charge of a vehicle while unfit through drink | 10 |  |  | DR50 | 10
DR60 | Failure to provide a specimen for analysis in circumstances other than driving or attempting to drive | 10 |  |  | DR60 | 10
DR70 | Failing to provide specimen for breath test | 4 |  |  | DR70 | 4
DG10 | Driving or attempting to drive with drug level above the specified limit | 3 to 11 |  |  | DG10 | 3 to 11
DG60 | Causing death by careless driving with drug level above the limit | 3 to 11 |  |  | DG60 | 3 to 11
DR80 | Driving or attempting to drive when unfit through drugs | 3 to 11 |  |  | DR80 | 3 to 11
DG40 | In charge of a vehicle while drug level above specified limit | 10 |  |  | DG40 | 10
DR90 | In charge of a vehicle when unfit through drugs | 10 |  |  | DR90 | 10
IN10 | Using a vehicle uninsured against third party risks | 6 to 8 |  |  | IN10 | 6 to 8
LC20 | Driving otherwise than in accordance with a licence | 3 to 6 |  |  | LC20 | 3 to 6
LC30 | Driving after making a false declaration about fitness when applying for a licence | 3 to 6 |  |  | LC30 | 3 to 6
LC40 | Driving a vehicle having failed to notify a disability | 3 to 6 |  |  | LC40 | 3 to 6
LC50 | Driving after a licence has been cancelled (revoked) or refused on medical grounds | 3 to 6 |  |  | LC50 | 3 to 6
MS10 | Leaving a vehicle in a dangerous position | 3 |  |  | MS10 | 3
MS20 | Unlawful pillion riding | 3 |  |  | MS20 | 3
MS30 | Play street offences | 2 |  |  | MS30 | 2
MS50 | Motor racing on the highway | 3 to 11 |  |  | MS50 | 3 to 11
MS60 | Offences not covered by other codes (including offences relating to breach of requirements as to control of vehicle) | 3 |  |  | MS60 | 3
MS70 | Driving with uncorrected defective eyesight | 3 |  |  | MS70 | 3
MS80 | Refusing to submit to an eyesight test | 3 |  |  | MS80 | 3
MS90 | Failure to give information as to identity of driver etc | 6 |  |  | MS90 | 6
MW10 | Contravention of special roads regulations (excluding speed limits) | 3 |  |  | MW10 | 3
PC10 | Undefined contravention of pedestrian crossing regulations | 3 |  |  | PC10 | 3
PC20 | Contravention of pedestrian crossing regulations with moving vehicle | 3 |  |  | PC20 | 3
PC30 | Contravention of pedestrian crossing regulations with stationary vehicle | 3 |  |  | PC30 | 3
SP10 | Exceeding goods vehicle speed limits | 3 to 6 |  |  | SP10 | 3 to 6
SP20 | Exceeding speed limit for type of vehicle (excluding goods or passenger vehicles) | 3 to 6 |  |  | SP20 | 3 to 6
SP30 | Exceeding statutory speed limit on a public road | 3 to 6 |  |  | SP30 | 3 to 6
SP40 | Exceeding passenger vehicle speed limit | 3 to 6 |  |  | SP40 | 3 to 6
SP50 | Exceeding speed limit on a motorway | 3 to 6 |  |  | SP50 | 3 to 6
TS10 | Failing to comply with traffic light signals | 3 |  |  | TS10 | 3
TS20 | Failing to comply with double white lines | 3 |  |  | TS20 | 3
TS30 | Failing to comply with ‘stop’ sign | 3 |  |  | TS30 | 3
TS40 | Failing to comply with direction of a constable/warden | 3 |  |  | TS40 | 3
TS50 | Failing to comply with traffic sign (excluding ‘stop’ signs, traffic lights or double white lines) | 3 |  |  | TS50 | 3
TS60 | Failing to comply with a school crossing patrol sign | 3 |  |  | TS60 | 3
TS70 | Undefined failure to comply with a traffic direction sign | 3 |  |  | TS70 | 3
[NAME] | Aggravated taking of a vehicle | 3 to 11 |  |  | [NAME] | 3 to 11