Spreadsheet: 116574d1311928001-auto-insert-a-row-of-data-based-upon-my-selection-blank-quoting-page
Sheet: Sheet1

 |  | Rod 5/16
 |  | Coup 5/16
 |  | Concrete inspection pit
 |  | 25/3mm 25m tape
 |  | 25/3mm 50m tape
 |  | 14 way dual link bar
 |  | HF fitting2 x 58w
 |  | HF fitting 2 x 70w
 |  | HF fitting 1 x 58w
 |  | HF fitting 1 x 70w
 |  | HF EM 2 x 58w
 |  | HF EM 2 x 70w
 |  | Tube 1 x 58w
 |  | Tube 1 x 70w
 |  | Bulk EM1 x 8w
 |  | Twin spot 2 x 20w
 |  | SON flood 1 x 150w
 |  | SON [NAME] x 250w
 |  | SON [NAME] x 400w
 |  | 28w 2D fitting
 |  | 28w 2D fitting
 |  | 5m [NAME] hinge
 |  | 6m Column mid hinge
 |  | Plug in ceiling rose
 |  | 2 zone fire panel
 |  | Smoke base
 |  | Smoke detector
 |  | Base sounder
 |  | Base sounder + beacon
 |  | Call point (fire alarm
 |  | [NAME] way TP&N DB
 |  | Merlin 6 way TP&N DB
 |  | Merlin 8 way TP&N DB
 |  | Merlin 12 way TP&N DB
 |  | Merlin 16 way TP&N DB
 |  | Merlin 24 way TP&N DB
 |  | Incomer 125A
 |  | Incomer 160A
 |  | Inocmer 250A
 |  | B6A SP MCB
 |  | B10A SP MCB
 |  | B16A SP MCB
 |  | B20A SP MCB
 |  | B25A SP MCB
 |  | B32A SP MCB
 |  | B40A SP MCB
 |  | B45A SP MCB
 |  | B50A SP MCB
 |  | B63A SP MCB
 |  | B6A TP MCB
 |  | B10A TP MCB
 |  | [NAME]
 |  | B20A TP MCB
 |  | B25A TP MCB
 |  | B32A TP MCB
 |  | B40A TP MCB
 |  | B45A TP MCB
 |  | B50A TP MCB
 |  | B63A TP MCB
 |  | C6A SP MCB
 |  | C10A SP MCB
 |  | C16A SP MCB
 |  | C20A SP MCB
 |  | C25A SP MCB
 |  | C32A SP MCB
 |  | C40A SP MCB
 |  | C45A SP MCB
 |  | C50A SP MCB
 |  | C63A SP MCB
 |  | C6A TP MCB
 |  | C10A TP MCB
 |  | C16 A TP MCB
 |  | C20A TP MCB
 |  | C25A TP MCB
 |  | C32A TP MCB
 |  | C40A TP MCB
 |  | C45A TP MCB
 |  | C50A TP MCB
 |  | C63A TP MCB
 |  | C6A RCBO
 |  | [NAME]
 |  | C16 A RCBO
 |  | [NAME]
 |  | C25A RCBO
 |  | C32A RCBO
 |  | C40A RCBO
 |  | [NAME]
 |  | [NAME]
 |  | C63A RCBO
 |  | Isolator 20A
 |  | 3KVA 110v TX
 |  | 110v wall socket
 |  | M8, 25mm
 |  | M8, 35mm
 |  | M10, 50mm
 |  | M10, 70mm
 |  | M12, 95mm
 |  | M12, 120mm
 |  | M14, 150mm
 |  | M16, 185mm
 |  | M16, 240mm
 |  | M16, 300mm
 |  | M16,  400mm
 |  | M16, 500m
 |  | M20, 630mm
 |  | M20, 800mm
 |  | 4xM10 240mm
 |  | 4xM10 300mm
 |  | 4xM10 400mm
 |  | 4xM10 500mm
 |  | 4xM10 630mm
 |  | 4xM10 800mm
 |  | E1W 20SS x 2
 |  | E1W 20S x 2
 |  | E1W 20L x 2
 |  | E1W 25 x 2
 |  | E1W 32 x 2
 |  | E1W 40 x 1
 |  | E1W 50 x 1
 |  | E1W 63 x 1
 |  | E1W 75 x 1
 |  | [NAME]
 |  | Tray HD 225mm
 |  | Tray HD 300mm
 |  | Tray HD 450mm
 |  | Tray HD 600mm
 |  | Tray HD 750mm
 |  | [NAME]
 |  | Tray 150mm flat 90
 |  | Tray 225mm flat 90
 |  | Tray 300mm flat 90
 |  | Tray 450mm flat 90
 |  | Tray 600mm flat 90
 |  | Tray 750[NAME] flat 90
 |  | [NAME] flat 90
 |  | Tray 150mm riser
 |  | Tray 225mm riser
 |  | Tray 300mm riser
 |  | Tray 450mm riser
 |  | Tray 600mm riser
 |  | Tray 750[NAME] riser
 |  | [NAME] riser
 |  | Tray coupler
 |  | 300mm MD ladder
 |  | 450mm MD ladder
 |  | 600mm MD ladder
 |  | 750[NAME] MD ladder
 |  | 900mm MD ladder
 |  | 300mm HD ladder
 |  | 450mm HD ladder
 |  | 600mm HD ladder
 |  | 750mm HD ladder
 |  | 900mm HD ladder
 |  | 300mm Ladder flat 90
 |  | 450mm Ladder flat 90
 |  | 600mm Ladder flat 90
 |  | 750mm Ladder flat 90
 |  | 900mm Ladder flat 90
 |  | Ladder coupler
 |  | [NAME] 2x2 5m
 |  | Galv trunking 3x3 3m
 |  | Galv trunking 4x4 3m
 |  | Galv trunking 6x6 3m
 |  | [NAME] trunking 2x2 bend
 |  | Galv trunking 3x3 bend
 |  | 2x2 galv trunking tee
 |  | 3x3 galv trunking tee
 |  | Lighting hanger
 |  | [NAME]
 |  | [NAME] slotted 41x41
 |  | [NAME] plain 41x41
 |  | 20[NAME] conduit galv
 |  | 25[NAME] conduit galv
 |  | Ceiling rose
 |  | SWA 2pair 0.75mm
 |  | SWA 5pair 0.75mm
 |  | SWA 10pair 0.75mm
 |  | SWA 20pair 0.75mm
 |  | SWA 2pair 1.5mm
 |  | SWA 5pair 1.5mm
 |  | SWA 10pair 1.5mm
 |  | SWA 4c 1.5mm
 |  | SWA 7c 1.5mm
 |  | SWA 12c 1.5mm
 |  | SWA 19c 1.5mm
 |  | SWA 27c 1.5mm
 |  | SWA 37c 1.5mm
 |  | SWA 48c 1.5mm
 |  | SWA 2c 2.5mm
 |  | SWA 3c 2.5mm
 |  | SWA 4c 2.5mm
 |  | SWA 7c 2.5mm
 |  | SWA 12c 2.5mm
 |  | SWA 19c 2.5mm
 |  | SWA 4c 4mm
 |  | SWA 7c 4mm
 |  | SWA 4c 6mm
 |  | SWA 7c 6mm
 |  | SWA 4c 10mm
 |  | SWA 7c 10mm
 |  | SWA 4c 16mm
 |  | SWA 7c 16mm
 |  | SWA 4c 25mm
 |  | SWA 4c 35[NAME]
 |  | SWA 4c 50[NAME]
 |  | SWA 4c 70[NAME]
 |  | SWA 4c 95mm
 |  | SWA 4c 120mm
 |  | SWA 4c 150mm
 |  | SWA 4c 185mm
 |  | SWA 4c 240mm
 |  | SWA 4c 300mm
 |  | AWA 1c 240mm
 |  | AWA 1c 300mm
 |  | AWA 1c 400mm
 |  | AWA 1c 500mm
 |  | AWA 1c 630mm
 |  | AWA 1c 800mm
 |  | G/Ysingles 16mm
 |  | G/Ysingles 25mm
 |  | G/Ysingles 35mm
 |  | G/Ysingles 50mm
 |  | G/Ysingles 70mm
 |  | G/Ysingles 95mm
 |  | G/Ysingles 120mm
 |  | G/Ysingles 150mm
 |  | G/Ysingles 185mm
 |  | G/Ysingles 240mm
 |  | G/Ysingles 300mm
 |  | Profibus 2c violet
 | Containment | Profibus 2c blue
 | Earthing | [NAME] thin
 | Glands | [NAME] thick
 | Lugs | HV Red 3c 120mm
 | Distribution | HV Red 3c 150mm
 | Firealarm | HV Red 3c 185mm
 | Lighting | HV Red 3c 240mm
 | Cable | HV Red 3c 300mm
[NAME] | Group | Description, (Cable type, cores, size) | Price per 1or 1M | QTY | PRICE | % | MATERIALS | LABOUR PRICE | 0.15 | LABOUR TOTAL
Motor 1 |  |  |  |  |  | 15 |  |  |  | 0
Motor 2 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  |  | 15 |  |  |  | 0
 |  |  |  |  | Total |  | 0 |  | Total | 0