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

 |  |  |  |  |  |  |  |  |  |  | Suspension |  |  |  | Tyres
Body | Chassis Available | Free Space LHS ([NAME]) | Wheelbase ([NAME]) | Standard Fuel Tank RHS | [NAME] | GVW | Engine | Gearbox | [NAME] | Seating | [NAME] | Axle 2 | Axle 3 | Axle 4 | [NAME] | Axle 2 | Axle 3 | Axle 4
OL10N | 4x2_N | 700 | 3250 | 150 RHS | 150 RHS | 18,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | - | - | 315/80R | 11R | - | -
OL14N | 4x2_N | 1500 | 4050 | 280 RHS | 280 RHS | 18,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | - | - | 315/80R | 11R | - | -
OL14N | 6x2ML_N | 0 | 4050 | Special Application | Special Application | 22,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 11R | 11R | 11R | -
OL16N | 6x2ML_N | 935 | 4800 (3482+1318) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL16N | 6x2MS_N | 850 | 4800 (3400+1400) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL16N | 6x2RS_N | 900 | 4800 (3450+1350) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 315/80 | -
OL19N | 6x2ML_N | 1335 | 5200 (3882+1318) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL19N | 6x2MS_N | 1250 | 5200 (3800+1400) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL19N | 6x2RS_N | 1350 | 5250 (3900+1350) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 315/80 | -
OL11N_2.0mPod | 6x2ML_N |  | 4950 (3632+1318) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL11N_2.0mPod | 6x2MS_N |  | 4950 (3550+1400) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL11N_2.0mPod | 6x2RS_N |  | 4950 (3600+1350) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 315/80 | -
OL11N_3.5mPod | 6x2ML_N |  | 5350 (4032+1318) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL11N_3.5mPod | 6x2MS_N |  | 5350 (3950+1400) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL11N_3.5mPod | 6x2RS_N |  | 5350 (4000+1350) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 315/80 | -
OL14N_2.0mPod | 6x2ML_N |  | 5450 (4132+1318) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL14N_2.0mPod | 6x2MS_N |  | 5450 (4050+1400) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL14N_2.0mPod | 6x2RS_N |  | 5450 (4100+1350) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 315/80 | -
OL14N_3.5mPod | 6x2ML_N |  | 5900 (4582+1318) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL14N_3.5mPod | 6x2MS_N |  | 5900 (4500+1400) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 295/80 | -
OL14N_3.5mPod | 6x2RS_N |  | 5900 (4550+1350) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 | Air Assist | Full Air | Full Air | - | 315/80R | 295/80 | 315/80 | -
OL13W | 4x2_W | 950 | 3500 | 150 RHS | 150 RHS | 18,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | - | -
OL13W | Mercedes |  |  |  |  | 18,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 315/80R | - | -
OL16W | 4x2_W | 1450 | 4050 | 280 RHS | 280 RHS | 18,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | - | -
OL16W | 6x2ML_W (22t) | 0 | 4050 (2732+1318) | Special Application | Special Application | 22,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 11R | 11R | 11R | -
OL16W | Mercedes |  |  |  |  |  | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 315/80R | - | -
OL20W | 6x2ML_W | 935 | 4800 (3482+1318) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL20W | 6x2MS_W | 850 | 4800 (3400+1400) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL20W | 6x2RS_W | 900 | 4800 (3450+1350) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 315/80 | -
OL20W | 6x4_W | 850 | 4800 (3415+1385) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | 11R | -
OL20W | Mercedes |  |  |  |  | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 315/80R | 315/80R | -
OL21W | 6x2ML_W | 1335 | 5200 (3882+1318) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL21W | 6x2MS_W | 1250 | 5200 (3800+1400) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL21W | 6x2RS_W | 1350 | 5250 (3900+1350) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 315/80 | -
OL21W | 6x4_W | 1400 | 5300 (3915+1385) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | 11R | -
OL21W | Mercedes |  | 5250 (3900+1350) |  |  | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 315/80R | 315/80R | -
OL23W | 6x2ML_W | 1735 | 5600 (4282+1318) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL23W | 6x2MS_W | 1550 | 5500 (4100+1400) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL23W | 6x2RS_W | 1750 | 5650 (4300+1350) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 315/80 | -
OL23W | 6x4_W | 1700 | 5600 (4215+1385) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | 11R | -
OL23W | Mercedes |  | 5550 (4200+1350) |  |  | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 315/80R | 315/80R | -
OL27W | 8x4_W | 1150 | 6400 (5050+1350) | 280 RHS | 280 RHS | 32,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | 295/80
OL27W | Mercedes |  | 6450 (5100+1350) |  |  | 32,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 315/80R | 315/80R | 315/80R
OL13W_2.5mPod | 6x2ML_W |  | 4950 (3632+1318) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL13W_2.5mPod | 6x2MS_W |  | 4950 (3550+1400) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL13W_2.5mPod | 6x2RS_W |  | 4950 (3600+1350) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 315/80 | -
OL13W_2.5mPod | 6x4_W |  | 4950 (3565+1385) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | 11R | -
OL13W_4.0mPod | 6x2ML_W |  | 5350 (4032+1318) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL13W_4.0mPod | 6x2MS_W |  | 5350 (3950+1400) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL13W_4.0mPod | 6x2RS_W |  | 5350 (4000+1350) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 315/80 | -
OL13W_4.0mPod | 6x4_W |  | 5400 (4015+1385) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | 11R | -
OL16W_2.5mPod | 6x2ML_W |  | 5450 (4132+1318) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL16W_2.5mPod | 6x2MS_W |  | 5450 (4050+1400) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL16W_2.5mPod | 6x2RS_W |  | 5450 (4100+1350) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 315/80 | -
OL16W_2.5mPod | 6x4_W |  | 5600 (4215+1385) | 280 RHS | 280 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | 11R | -
OL16W_4.0mPod | 6x2ML_W |  | 5900 (4582+1318) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL16W_4.0mPod | 6x2MS_W |  | 5900 (4500+1400) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OL16W_4.0mPod | 6x2RS_W |  | 5900 (4550+1350) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 315/80 | -
OL16W_4.0mPod | 6x4_W |  | 6000 (4615+1385) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | 11R | -
OLTP16 | 6x2ML_W (23.5t) | 450 | 4300 (2982+1318) | Special Application | Special Application | 23,500kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 11R | 11R | 11R | -
OLTP19 | 6x2ML_W | 935 | 4800 (3482+1318) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OLTP19 | 6x2MS_W | 850 | 4800 (3400+1400) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OLTP19 | 6x4_W | 850 | 4800 (3415+1385) | 150 RHS | 280 LHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | 11R | -
OLTP19 | Mercedes |  | 4800 (3450+1350) |  |  | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 315/80R | 315/80R | -
OLTP22 | 6x2ML_W | 1335 | 5200 (3882+1318) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OLTP22 | 6x2MS_W | 1250 | 5200 (3800+1400) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | -
OLTP22 | 6x2RS_W | 1335 | 5250 (3900+1350) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 315/80 | -
OLTP22 | 6x4_W | 1400 | 5300 (3915+1385) | 280 RHS | 315 RHS | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 11R | 11R | -
OLTP22 | Mercedes |  | 5250 (3900+1350) |  |  | 26,000kg | Volvo 280 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 315/80R | 315/80R | -
OLTP27 | 8x4_W | 1150 | 6400 (5050+1350) | 280 RHS | 280 RHS | 32,000kg | Volvo 320 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 295/80 | 295/80 | 295/80
OLTP27 | Mercedes |  | 6450 (5100+1350) |  |  | 32,000kg | Volvo 320 HP Euro 6 | [NAME] 3000P | Right Hand Steer, Hinged Door | Driver+3 |  |  |  |  | 315/80R | 315/80R | 315/80R | 315/80R
One Pass
None | > Narrow <
 | 4x2_N
 | 6x2ML_N (22t)
 | 6x2ML_N
 | 6x2MS_N
 | 6x2RS_N
 | > Wide <
 | 4x2_W
 | 6x2ML_W (23.5t)
 | 6x2ML_W
 | 6x2MS_W
 | 6x2RS_W
 | 6x4_W
 | 8x4_W
Please Select… | Price | Chassis | Price | [NAME] | Price
> Narrow < |  | > Narrow <
OL10N | 42000 | 4x2_N | 70795 | BetaLip
OL14N | 42500 | 6x2ML_N (22t) | 79095 | BetaPal
OL16N | 43000 | 6x2ML_N | 81695 | Terberg
OL19N | 44000 | 6x2MS_N | 84380 | Zoeller
 |  | 6x2RS_N | 85115 | Otto
OL11N_2.0mPod | 42000 |  |  | Openback
OL11N_3.5mPod | 42000 | > Wide < |  | Pipe Up & Frame Only
OL11N_4.2mPod | 42000 | 4x2_W | 70250
OL14N_2.0mPod | 42500 | 6x2ML_W (23.5t) | 79060
 |  | 6x2ML_W | 80660
> Wide < |  | 6x2MS_W | 84295
OL13W | 41000 | 6x2RS_W | 84295
OL16W | 41000 | 6x4_W | 84025
OL20W | 42250 | 8x4_W | 90000
OL21W | 42500
OL23W | 43000 | >Non-Dennis<
OL27W | 45000 | Mercedes
 |  | Volvo
OL13W+2.5m Pod | 41000 | DAF
OL13W+4.0m Pod | 41000 | Scania
OL13W+5.0m Pod | 41000
OL16W+2.5m Pod | 41000
OL16W+4.0m Pod | 41000
OLTP16 | 65500
OLTP19 | 67500
OLTP22 | 67500
OLTP27 | 70500
One Pass | 67500
None | 0