Spreadsheet: 727108d1617720191-multi-tier-dependant-drop-down-school-condition-survey-template
Sheet: Formula sheet

 | Element | Sub element | Construction | Description
 | Roof | Flat | [NAME] | Generally
 |  |  | GRP | Generally
 |  |  | Built up [NAME] | Generally
 |  |  | [NAME] | Generally
 |  |  | Rooflights | Generally
 |  | Pitched | Concrete Tile | Generally
 |  |  | Clay Tile | Generally
 |  |  | Composite | Generally
 |  |  | Slate | Generally
 |  |  | Timber Shingles | Generally
 |  |  | Zinc | Generally
 |  |  | Metal Standing Seam | Generally
 |  | Rainwater Goods | Aluminium | Generally
 |  |  | PVC | Generally
 |  |  | Cast Iron | Generally
 |  |  | Zinc | Generally
 |  | Soffits and [NAME] | Timber | Generally
 |  |  | uPVC | Generally
 |  |  | Fibre Cement | Generally
 |  |  | Aluminium | Generally
 | Walls | External | Brick | Generally
 |  |  | Block | Generally
 |  |  | Render | Generally
 |  |  | Cladding | Timber
 |  |  |  | Fibre Cement
 |  |  |  | uPVC
 |  | Internal | Brick
 |  |  | Block
 |  |  | Plaster
 |  |  | Cladding | Timber
 |  |  |  | Metal
 |  |  |  | uPVC
 | Windows and Doors | Windows | Aluminium | Generally
 |  |  | Timber | Generally
 |  |  | uPVC | Generally
 |  |  | Steel | Generally
 |  |  | Iron | Generally
 |  | Internal Doors | Timber | Generally
 |  |  | Aluminium | Generally
 |  |  | uPVC | Generally
 |  | External Doors | Timber | Generally
 |  |  | Aluminium | Generally
 |  |  | uPVC | Generally
 | Internal Finishes | Ceilings | Suspended | Generally
 |  |  |  | Hygenic
 |  |  | Plaster | Generally
 |  |  | Timber | Generally
 |  |  | uPVC | Generally
 |  |  | Exposed | Generally
 |  | Floors | Timber | Generally
 |  |  | Laminate | Generally
 |  |  | Vinyl | Sheet
 |  |  |  | Tile
 |  |  | Tile | Porcelain/Ceramic
 |  |  |  | Natural Stone
 |  |  | Carpet | Roll
 |  |  |  | Tile
 |  |  | [NAME] | Generally
 |  |  | Unfinished/Screed | Generally
 |  | Decoration | Generally | Generally
 | Toilets | Fittings | Generally | Generally
 |  | Waste plumbing/soil drainage | Generally | Generally
 |  | IPS/Cubicles | Generally | Generally
 |  | Floors | Vinyl | Sheet
 |  |  |  | Tile
 |  |  | [NAME] | Generally
 |  | Ceiling | Suspended | Hygenic
 |  |  |  | Mineral Fibre
 |  |  | Plaster | Generally
 | Accessible Toilet | Fittings | Generally | Generally
 |  | [NAME] | Generally | Generally
 |  | Waste plumbing/soil drainage | Generally | Generally
 |  | IPS/Cubicles | Generally | Generally
 |  | Floors | Vinyl | Sheet
 |  |  |  | Tile
 |  |  | [NAME] | Generally
 |  | Ceiling | Suspended | Hygenic
 |  |  |  | Mineral Fibre
 |  |  | Plaster | Generally
 | Full Production Kitchen | Kitchen fittings | Generally | Generally
 |  | [NAME] | Generally | Generally
 |  | Ceiling finishes | Suspended | Hygenic
 |  |  |  | Mineral Fibre
 |  |  | Plaster | Generally
 |  | Wall Finishes | Plaster | Generally
 |  |  | Tile | Generally
 |  |  | Hygenic Cladding | Generally
 |  | [NAME] | [NAME] | Generally
 |  |  | Vinyl | Sheet
 |  |  |  | Tile
 | Electrical | Mains Supply | Mains Switchgear | Generally
 |  |  | Distribution | Generally
 |  | Power | Controls/Switch gear | Generally
 |  |  | Wiring | Generally
 |  |  | Fittings | Generally
 |  | Lighting | Wiring | Generally
 |  |  | Fittings | Generally
 | FIRE & SECURITY
 |  | [NAME] |  | Generally
 |  | Emergency Lighting |  | Generally
 |  | [NAME] |  | Generally
 | Mechanical Services | Heating | Boiler Plant | Generally
 |  |  | Controls | Generally
 |  |  | Heat Emitters | Radiators
 |  |  | Distribution | Generally
 |  | Hot Water | Calorifier | N/A
 |  |  | Storage tanks and Equipment | N/A
 |  |  | Distribution | Generally
 |  | Cold Water | Distribution | Generally
 |  |  | Storage tanks & Equipment | N/A
 | EXTERNAL AREAS | Surfaces | Playgrounds | Tarmacadam
 |  |  |  | Grass
 |  |  |  | [NAME]
 |  |  | Pedestrian Areas | Tarmacadam
 |  |  |  | Concrete pavers
 |  |  |  | Block Paving
 |  |  | Car parking | Tarmacadam
 |  |  |  | Block Paving
 |  |  |  | [NAME]
 |  | Partitions & Gates | Perimeter Partitions | Timber Picket
 |  |  |  | Post and rail
 |  |  |  | Palisade
 |  |  |  | Weld Mesh
 |  |  |  | Stock Fencing
 |  |  |  | Bow Top
 |  |  |  | Brick
 |  | Partitions & Gates | Site Partitions | Timber Picket
 |  |  |  | Post and rail
 |  |  |  | Palisade
 |  |  |  | Weld Mesh
 |  |  |  | Stock Fencing
 |  |  |  | Bow Top
 |  |  |  | Brick
 |  |  | Gates | Timber Picket
 |  |  |  | Post and rail
 |  |  |  | Palisade
 |  |  |  | Weld Mesh
 |  |  |  | Bow Top
 |  | Drainage | Site | Generally
 |  | Site ancillaries | Timber Framed Canopies | Generally
 |  |  | Steel Framed Canopies | Generally