Spreadsheet: 131273d1322840181-sumif-looking-for-a-text-reference-not-working-junctions-rev-a
Sheet: Data

 | cover slab depths |  |  | Cover openings |  | Ring depths |  |  | pipe sizes | lengths | Pipe thickness |  |  | Gully Pots |  | Iron work
 |  |  |  |  |  |  |  |  |  |  | Gross | Nett |  |  |  |  | Depth
 | 900 | 0.15 |  | 600 x 600 opening |  | 500mm | 0.5 |  | 0.15 |  |  |  |  | 300 x 450 |  | A15 450 x 450 x 44mm | 0.044
 | 1050 | 0.15 |  | 675 x 675 opening |  | 750mm | 0.75 |  | 0.225 | 1.25 | 0.305 |  |  | 300 x 600 |  | A15 600 CIRCULAR x 44[NAME] | 0.044
 | 1200 | 0.15 |  | 750 x 750 opening |  | 1000mm | 1 |  | 0.3 | 1.25 | 0.41 |  |  | 375 x 750 |  | A15 600 x 450 x 44mm | 0.044
 | 1350 | 0.15 |  | 750 x 600 opening |  |  |  |  | 0.375 | 2.5 | 0.49 |  |  | 375 x 900 |  | A15 600 x 600 x 44mm | 0.044
 | 1500 | 0.17 |  | 1220 x 675 opening |  |  |  |  | 0.45 | 2.5 | 0.575 |  |  | 450 x 750 |  | A15 675 x 675 x 44mm | 0.044
 | 1800 | 0.175 |  |  |  |  |  |  | 0.525 | 2.5 | 0.67 |  |  | 450 x 900 |  | A15 750 x 600 x 44mm | 0.044
 | 2100 | 0.18 |  | Pipe Type |  |  |  |  | 0.6 | 2.5 | 0.77 |  |  | 450 x 1050 |  | A15 750 x 750 x 44mm | 0.044
 | 2400 | 0.18 |  |  |  |  |  |  | 0.675 | 2.5 | 0.82 |  |  |  |  | A15 900 x 600 x 44mm | 0.044
 | 2700 | 0.205 |  | Plastic |  |  |  |  | 0.75 | 2.5 | 0.91 |  |  | Gully Grating |  | A15 Recessed Double seal 600 x 450 x 65mm | 0.065
 | 3000 | 0.205 |  | Clay |  |  |  |  | 0.825 | 2.5 | 0.985 |  |  |  |  | A15 Recessed Double seal 600 x 600 x 65mm | 0.065
 |  |  |  | Concrete |  |  |  |  | 0.9 | 2.5 | 1.08 |  |  | Double Tri D400 600 x 600 x 100mm |  | A15 Recessed Single seal 600 x 450 x 65mm | 0.065
 |  |  |  |  |  |  |  |  | 1.05 | 2.5 | 1.26 |  |  | Double Tri D400 440 x 400 x 100mm |  | A15 Recessed Single seal 600 x 600 x 65mm | 0.065
 |  |  |  |  |  |  |  |  | 1.2 | 2.5 | 1.44 |  |  | Double Tri D400 600 x 600 x 150mm |  | B125 450 x 450 x 40mm | 0.04
 |  |  |  |  |  |  |  |  | 1.5 | 2.5 | 1.81 |  |  | Double Tri D400 440 x 400 x 150mm |  | B125 450 x 450 x 75mm | 0.075
 |  |  |  |  |  |  |  |  | 1.6 | 2.5 | 1.92 |  |  | Hinged D400 440 x 400 x 100mm |  | B125 600 x 450 x 40mm | 0.04
 |  |  |  |  |  |  |  |  | 1.8 | 2.5 | 2.16 |  |  | Hinged D400 380 x 310 x 150mm |  | B125 600 x 450 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hinged D400 440 x 400 x 150mm |  | B125 600 x 600 x 40mm | 0.04
 |  | Tumbling Bay Assemblies For Concrete Back Drops |  |  |  |  |  |  |  |  |  |  |  | Class A D400 Gully grating |  | B125 600 x 600 x 75mm | 0.075
 |  |  | A | B | C | IL - IL |  |  |  |  |  |  |  | Double Tri C250 445 x 445 x 75mm |  | B125 675 x 675 x 40mm | 0.04
 |  | 225 | 0.825 | 0.25 | 0.71 |  |  |  |  |  |  |  |  | Hinged C250 320 x 300 x 75mm |  | B125 675 x 675 x 75mm | 0.075
 |  | 300 | 0.86 | 0.355 | 0.71 |  |  |  |  |  |  |  |  | Hinged C250 380 x 310 x 75mm |  | B125 750 x 600 x 40mm | 0.04
 |  | 375 | 0.9 | 0.355 | 0.71 |  |  |  |  |  |  |  |  | Hinged C250 420 x 420 x 75mm |  | B125 750 x 600 x 75mm | 0.075
 |  | 450 | 0.94 | 0.365 | 0.71 |  |  |  |  |  |  |  |  | Hinged C250 500 x 350 x 75mm |  | B125 750 x 750 x 40mm | 0.04
 |  | 525 | 0.975 | 0.375 | 0.71 |  |  |  |  |  |  |  |  | Hinged & Dished C250 300 x 300 x 70mm |  | B125 750 x 750 x 75mm | 0.075
 |  | 600 | 1.015 | 0.385 | 0.71 |  |  |  |  |  |  |  |  | Hinged & Dished C250 375 x 375 x 80mm |  | B125 900 x 600 x 40mm | 0.04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B125 900 x 600 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C250 450 x 450 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C250 600 x 450 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C250 600 x 600 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C250 675 x 675 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C250 750 x 600 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C250 750 x 750 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C250 900 x 600 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C250 900 x 900 x 75mm | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 1220 x 675 x 100mm | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 1220 x 675 x 150mm | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 1800 x 675 x 100mm | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 1800 x 675 x 150mm | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 450 x 450 x 100mm | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 600 x 450 x 100mm | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 600 x 600 x 100mm | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 600 x 600 x 150mm | 0.15
 |  | Rocker - Spigot - Socket Effective length |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 675 x 675 x 100mm | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 675 x 675 x 150mm | 0.15
 |  | 225 - 600 |  | 0.6 |  |  |  |  |  |  |  |  |  |  |  | D400 750 x 600 x 100mm | 0.1
 |  | 675 - 825 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | D400 750 x 600 x 150mm | 0.15
 |  | 900 + |  | 1.25 |  |  |  |  |  |  |  |  |  |  |  | D400 750 x 750 x 100mm | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 750 x 750 x 150mm | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 900 x 600 x 100mm | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 900 x 600 x 150mm | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 900 x 900 x 100mm | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 900 x 900 x 150mm | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 Circular 110mm | 0.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D400 Circular 150mm | 0.15