Spreadsheet: 118252d1313571373-excel-2007-if-statement-help-if-value-is-blank-use-another-factory-build-week
Sheet: Sheet2

[NAME] | Production  No | Wolseley Division | Branch Code | Branch | Fleet No | Registration No | Model Description | Gross Weight | W/base | Body Description | [NAME] | [NAME] | Current Status | Hiab Build | Body Build | Dealer Comp | Stock Number | Chassis Number | Signwriting | Fuel Card | Handsfree | Congestion Zone | [NAME] | Actual Delivery Date
780100/33 | 672239 | Build | 1X | Ramsey | 81UD | PJ11VLR | FAR CF75.310 | 26000Kgs | 5.6m | F/M Dropside | 26ft | w/c 8/8/11 | Lancs DAF 1.8.11 | w/c 11/4/11 | w/c 20/6/11 | w/c 04/7/11 | 12613 | E901246
780100/38 | 934146 | [NAME] | 2H | West Horndon |  |  | FA LF55.220 | 18000Kgs | 5.85m | [NAME] |  |  | Factory Build Wk 38 |  |  |  | 13036
780100/38A |  | [NAME] | 2H | West Horndon |  |  | FAX CF85.360 | 32000Kgs |  | [NAME] |  |  |  |  |  |  | 13601
780100/23 | 875615 | [NAME] | 2N | Huddersfield |  |  | FA LF45.180 | 12000Kgs | 4.65m | [NAME] |  | w/c 15/8/11 | Aire 13.4.11 |  | w/c 27/6/11 | w/c 4/7/11 | 12974 | L365647
780100/27 | 883612 | [NAME] | 2N | Huddersfield |  |  | FAR CF75.310 | 26000Kgs | 5.9m | [NAME] |  | w/c 22/8/11 | Aire [NAME] | w/c 27/6/11 | w/c 1/8/11 | w/c 15/8/11 | 13129 | E914102
780100/23 | 875575 | [NAME] | 2P | Derby |  |  | FA LF45.180 | 12000Kgs | 4.65m | [NAME] |  | w/c 15/8/11 | Aire 13.4.11 |  | w/c 27/6/11 | w/c 4/7/11 | 12973 | L365646
780100/38A |  | [NAME] | 2P | Derby |  |  | FAX CF85.360 | 32000Kgs |  | [NAME] |  |  |  |  |  |  | 13602
780100/23 | 875616 | [NAME] | 2R | Tipton |  | PF11HCK | FA LF45.180 | 12000Kgs | 4.65m | [NAME] |  | w/c 22/8/11 | Lancs DAF 1.8.11 |  | w/c 11/7/11 | w/c 18/4/11 | 12975 | L365648
780100/44 | 732475 | Build White | 3NM | Wakefield | 81UG | PJ11VMA | FA LF55.220 | 18000Kgs | 5.85m | F/M Dropside | 20ft | w/c 15/8/11 | Lancs DAF 3.8.11 |  | w/c 20/6/11 | w/c 4/7/11 | 12838 | L365107
 | 732474 | Build | 5J | Bexhill |  |  | FA LF55.220 | 18000Kgs | 5.85m | F/M Dropside | 20ft | w/c 22/8/11 | Hiab 4.8.11 |  | w/c 4/7/11 | w/c 18/7/11 | 12837 | L365106
 | 732472 | Build | 6L | Hastings | 81UE | PJ11VLZ | FA LF55.220 | 18000Kgs | 5.85m | F/M Dropside | 20ft | 17.8.11 | Lancs DAF 5.8.11 | w/c 16/5/11 | w/c 27/6/11 | w/c 11/7/11 | 12835 | L365104
780100/35 | 719493 | Build | 6U | Isle of White | 81SK | PJ11VLH | FA LF55.220 | 18000Kgs | 5.85m | F/M Dropside | 20ft | w/c 8/8/11 | Lancs DAF 22.6.11 | w/c 28/2/11 | w/c 13/6/11 | w/c 27/6/11 | 12792 | L364319
780100/47 | 934147 | Build | 6U | Isle of White |  |  | FAN CF75.310 | 26000Kgs | 5.3m | R/M Dropside | 7m |  | Factory Build Wk 38 |  |  |  | 13616
780100/13 | 732491 | Build | 8Z | Ilfracombe | 81SP | PJ11VLN | FA LF55.220 | 18000Kgs | 5.3m | F/M Dropside | 17ft | 9.8.11 | Lancs DAF 4.7.11 | w/c 4/4/11 | w/c 13/6/11 | w/c 27/6/11 | 12855 | L364753
 | 732530 | Drain | FC | Brimsdown | 81TK | PF11HBN | FA LF45.160 | 7500Kgs | 4.65m | Dropside T/Lift | 22ft | w/c 8/8/11 | Lancs DAF 15.7.11 |  | w/c 27/6/11 | w/c 4/7/11 | 12850 | L365134
 | 732531 | Drain | FC | Brimsdown | 81TL | PF11HBO | FA LF45.160 | 7500Kgs | 4.65m | Dropside T/Lift | 22ft | w/c 8/8/11 | Lancs DAF 14.7.11 |  | w/c 27/6/11 | w/c 4/7/11 | 12851 | [NAME]
780100/53 | 732534 | Drain | FN | Salisbury | 81SJ | PJ11OHY | FA LF45.160 | 7500Kgs | 4.65m | Dropside T/Lift | 22ft | 25.8.11 | Lancs DAF 13.6.11 Waiting Cards |  |  |  | 12854 | L365378
780100/33 | 672241 | Build | N10 | [NAME] | 81TP | PF11HBX | FAR CF75.310 | 26000Kgs | 5.6m | F/M Dropside | 24ft | 30.8.11 | Lancs DAF 19.7.11 | w/c 11/4/11 | w/c 20/6/11 | w/c 04/7/11 | 12615 | E900783
780100/33 | 719490 | Build | N10 | [NAME] | 81SM | PJ11VLL | FA LF55.220 | 18000Kgs | 5.85m | F/M Dropside | 20ft | 30.8.11 | Lancs DAF 22.6.11 | w/c 28/2/11 | w/c 11/4/11 | w/c 20/6/11 | 12789 | L364345
780100/35 | 896916 | Build | N40 | [NAME] |  |  | FA LF55.220 | 15000Kgs | 4.5m | F/M Dropside | 16ft |  | Factory Build Wk 33 2011 |  |  |  | 13408
780100/33 | 896915 | Build | N62 | Leatherhead |  |  | FA LF55.220 | 18000Kgs | 4.75m | R/M Dropside | 18ft | w/c 26/9/11 | Aire 9.8.11 | w/c 8/8/11 | w/c 5/9/11 | w/c 19/9/11 | 13404 | L368290
780100/33 | 896278 | Build | N80 | High Wycombe |  |  | FA LF55.220 | 18000Kgs | 5.3m | F/M Dropside | 18ft | w/c 19/9/11 | Hiab 14.7.11 | w/c 1/8/11 | w/c 29/8/11 | w/c 12/9/11 | 13403 | L367971
780100/21 | 672236 | Plumb | NR | Chester | 81QB | PN11HXD | FA LF45.160 | 7500Kgs | 4.3m | Box T/Lift |  |  | Lancs DAF 4.4.11 Waiting Cards |  | w/c 21/3/11 | w/c 28/3/11 | 12620 | L363358
 | 732498 | Drain | NU | Tyseley | 81TS | PJ11VMD | FA LF45.160 | 7500Kgs | 4.65m | Dropside T/Lift | 22ft | w/c 1/8/11 | Lancs DAF 15.7.11 |  | w/c 27/6/11 | w/c 4/7/11 | 12845 | L365111
 | 732528 | Spare Pipe/Drain | NV | [NAME] | 81SU | PJ11TYV | FA LF45.160 | 7500Kgs | 4.65m | Dropside T/Lift | 22ft | w/c 26/6/11 | Delivered |  |  |  | 12848 | [NAME] |  |  |  |  |  | 1.7.11
780100/30 | 732494 | Drain | NV | [NAME] |  |  | FA LF45.160 | 7500Kgs | 4.65m | Dropside T/Lift | 6.75m |  | Paint |  | w/c 27/6/11 | w/c 4/7/11 | 12841 | L365066
780100/57 | 732532 | Drain | OT | Trafford Park | 81TQ | PJ11TYX | FA LF45.160 | 7500Kgs | 4.65m | Dropside T/Lift | 22ft | w/c 8/8/11 | Lancs DAF 16.6.11 |  |  |  | 12852 | L365323
780100/58 | 950017 | Drain | P17 | Colchester |  |  | FA LF45.180 | 12000Kgs | 5.4m | F/M Dropside | 7m |  | Factory Build Wk 42 |  |  |  | 13720
 | 732529 | Drain | QCJ | Portsmouth | 81TM | PF11HBP | FA LF45.160 | 7500Kgs | 4.65m | Dropside T/Lift | 22ft | w/c 1/8/11 | Lancs DAF 14.7.11 Waiting Cards |  | w/c 27/6/11 | w/c 4/7/11 | 12849 | L365113
780100/35 | 896917 | Build | S71 | Paignton |  |  | FA LF55.220 | 15000Kgs | 4.5m | F/M Dropside | 16ft |  | Factory Build Wk 33 2011 |  |  |  | 13409
780100/33 | 719489 | Build | [NAME] | Wem | 81SQ | PJ11VLO | FA LF55.220 | 18000Kgs | 5.85m | F/M Dropside | 20ft | 10.8.11 | Lancs DAF 6.7.11 | w/c 28/2/11 | w/c 11/4/11 | w/c 27/6/11 | 12788 | L364344
780100/33 | 896279 | Build | Z11 | Crawley |  |  | FA LF55.220 | 18000Kgs | 5.3m | R/M Dropside | 20ft | w/c 19/9/11 | Aire 9.8.11 | w/c 1/8/11 | w/c 29/8/11 | w/c 12/9/11 | 13402 | L367972
780100/35 | 896918 | Build | Z60 | Telford |  |  | FA LF55.220 | 15000Kgs | 4.5m | F/M Dropside | 16ft |  | Factory Build Wk 33 2011 |  |  |  | 13410
 | 672240 | Build | [NAME] | York | 81UF | PJ11VLS | FAR CF75.310 | 26000Kgs | 5.6m | F/M Dropside | 24ft | w/c 29/8/11 | Hiab 4.8.11 | w/c 16/5/11 | w/c 18/7/11 | w/c 1/8/11 | 12614 | E900788
 | 732473 | Pipe | ZD | West Horndon |  |  | FA LF55.220 | 18000Kgs | 5.85m | F/M Dropside | 24ft | w/c 22/8/11 | Hiab 4.8.11 |  | w/c 4/7/11 | w/c 11/7/11 | 12836 | L365105
780100/ |  |  |  |  |  |  | FTG XF105.460 | 44000Kgs | 3.98m | Artic | n/a |  | Paint |  |  |  | 12486 | [NAME]