Spreadsheet: 719240d1613573066-i-want-the-data-from-a-row-in-one-sheet-to-populate-a-form-on-the-adjacent-sheet-ssri-excel
Sheet: Sheet2

Column1 | Column2 | Column3 | Column4 | Column5
SITE SPECIFIC RISK INFORMATION
[NAME]:
 | 0
UPRN:
 | 0
Name of Occupier/Premises:
 | 0
Address of Premises:
 | 0
Station Ground:
Geo Code:
 | 0
Trade, Business or Use of Premises:
 | 0
Organisation representative responsible during Risk Visit, Contact Details
Name & Tel No:
Number of Buildings covered by this SSRI:
 | 0
LIFE RISK – INFORMATION CONCERNING THE OCCUPANTS OF THE BUILDING
Building maybe occupied when firefighting commences | 2
Evacuation:
* Total | 0
* Progressive | 2
* Unknown | 2
* Stay put | 2
What type of TOTAL evacuation:
* Horizontal | 0
* Zoned | 0
Occupants mobility:
* Special assistance required | 4
* Semi – ambulant | 4
* Non-ambulant | 4
* Bedridden / Stay put | 6
* Other
[NAME]:
Very Large capacity premises, over 500 persons | 2
Potential for Overcrowding | 2
Occupancy Impairment:
* Visually impaired | 2
* Hearing impaired | 2
* Non-English speaking | 2
* None | 0
Large Sleeping Risks | 2
Large numbers of persons that may be unfamiliar with the premises | 2
Large numbers of persons who may not respond to the actuation of a fire alarm | 2
Awareness of poor premises management Inc. fire safety, maintenance, housekeeping etc | 2
Potential risk to firefighter safety from physical attack by occupants | 2
Additional Info Life Risk:
HAZARDS/RISK – PRESENCE OF HAZARDOUS MATERIALS AND PROCESSES ON THE PREMISES
HAZARDOUS MATERIALS
Explosive | 6
[NAME]:
Flammable Gases | 6
[NAME]:
Flammable Liquids | 6
[NAME] Liquids:
Flammable Solids | 6
[NAME]:
Oxidising Substances | 6
[NAME]:
Toxic & Infectious Substances | 6
[NAME]:
Radioactive Material | 6
[NAME]:
Corrosives | 6
[NAME]:
Miscellaneous Dangerous Goods | 6
[NAME]:
SPECIFIC HAZARDS
LPG Cylinders | 6
[NAME]:
LPG Bulk Storage | 6
[NAME]:
[NAME] | 6
[NAME]:
Other Cylinders | 6
[NAME]:
Cryogenic Substances | 6
[NAME]:
Pipelines (Above or below Ground) | 6
[NAME]:
Liquefied Natural Gas | 6
[NAME]:
HAZARDOUS PROCESSES PRESENT
* Oxygen enrichment/deficiency | 4
* Gas fumes/vapours | 4
* Excessive heat	(Industrial Ovens) | 4
* Excessive cold	(Refrigerated Compartments) | 4
* Process baths | 4
* Naked flames	(Processing, Using or Creating) | 6
* Stored energy system: Hydraulic (Hydraulic rams, High pressure water systems, Pressure vessels | 6
* Stored energy system: Pneumatic (Airlines or pressurised gas lines, Pressure vessels) | 0
* Magnetic fields present | 0
* Plant/Machinery left running | 0
* Dust which may cause an explosive risk | 6
* Industrial Lasers Present | 0
* Elevated Pressure (Atmosphere maintained higher than 1 bar) | 2
[NAME] Present:
ELECTRICAL INSTALLATIONS
* Electrical supplies over 230v   (415v) | 0
* Electricity in excess of 11Kv | 4
* Uninterruptible power supplies (UPS) | 0
* Sub-station on site | 4
* Transformer on site | 4
* Overhead power supplies/Cables | 4
* Luminous discharge tubes | 4
* Entanglement risk from surface mounted cables in fire | 10
* Standby Generators | 0
* Photovoltaic Panels | 4
* Wind driven Electric Power Generation Equipment | 0
* Bio Mass Digester Power Generation Equipment | 0
* Other Electrical Installation not listed | 0
[NAME]:
INTERNAL LAYOUT
* Complex or unusual | 4
* Potential for disorientation | 4
* Complex basements | 4
* Building built within a building | 4
* Atrium present | 0
* Other | 0
[NAME] Layout:
CONFINED SPACES
* Service Shafts / Ducts | 10
* Wells | 10
* Sewers / Underground Structures | 10
* Tanks | 10
* Trenches | 10
* Silos / Grain Driers | 10
* Other | 10
[NAME]:
ADDITIONAL HAZARDS
* Ponds / Lakes / Canals / Rivers | 2
* Railway Lines | 4
* Slurry Lagoons / Storage Systems | 2
* Guard Dogs | 2
* Multi-Lane Carriageway | 4
* Other | 2
[NAME]:
CONTROL MEASURES
RADIO COMMUNICATION
* Repeater system | 0
* Sensitive equipment that may be affected | 0
* Areas where intrinsically safe equipment is required | 2
* Consider the use of Service Radio Repeaters (Analogue channels only) | 0
[NAME]:
OPERATIONAL CONSIDERATIONS
Fire-fighting Shaft | -2
* Staircase
* Lift
Fire-fighting Lift to Lift Safety Specifications | -2
[NAME]:
SECURITY MEASURES
* Access code | 0
* Access fob | 0
* Access key | 0
* Smoke Security Systems | 2
* Gerda Doors | 0
* 24hr security on site | -2
* Daytime Security on Site | -2
* Night time Security on Site | -2
* Guard Dogs | 0
[NAME]:
BUILDING UTILITIES
* Electrical intakes/Isolation Location | 0
* Gas intakes/ Isolation Location | 0
* Fuel oil intakes/ Isolation Location | 0
[NAME]:
KEY HOLDER CONTACT DETAILS
Name, Position & Out of Hours Contact Number: | 0
COMMAND AND CONTROL INFORMATION
On Site Location of Plans ([NAME],Salvage plans):
[NAME]
PIB Box contains
* Plans
* Keys
* Empty
* Other
[NAME] information:
Appliance Rendezvous Point
[NAME]:
Onsite area available for Control Point Area:
[NAME] area available for control points:
EXCEPTIONAL VALUE OR SOCIAL RISK
* Heritage Risk
* Community Risk
* Exceptional Value
[NAME]:
ENVIRONMENTAL CONSIDERATION – ENVIRONMENTAL EFFECTS OF AN INCIDENT AT THE PREMISES
Regulated site
* BASIS – Biological & Systematic Information | 20
* COMAH - Control of Major Accident Hazards | 50
* NAMOS – The dangerous Substances (Notification and Marking of Sites) Regulation 1990 | 20
[NAME]:
In the event of a fire or spillage, likelihood of
* Requirement for [NAME] being invoked (weather forecasting) | 0
* EA becoming involved | 4
* Potential for widespread on or off site environmental pollution from toxic smoke | 10
* Potential for environmental pollution from contaminated water run off but it can be contained on site | 6
* Potential for environmental pollution from contaminated water run off which will spread off-site | 10
[NAME]:
6 CONSTRUCTION DESCRIPTION – INFORMATION ON THE PREMISES CONSTRUCTION
Number of floors (including [NAME]):
* 1 - 4 floors (Low Rise) | 0
* 5 - 7 floors (Medium Rise) | 20
* 8 floors and above (High Rise) | 20
No of Basements :
Ground floor area (m2):
BUILDING CONSTRUCTION
Building Construction:
* Traditional brick and timber | 0
* Timber framed | 2
* Concrete framed | 2
* Protected steel frame | 0
* Portal frame | 4
* Air supported | 6
* Temporary structure | 2
* LISP (large insulated sandwich panels with polystyrene/polyurethane core) | 20
* LISP (large insulated sandwich panels with mineral fibre core) | 10
* LISP (unknown) | 20
* CLASP  (Consortium of Local Authority Special Programme -Quick and cheap method of construction, poor fire performance including lack of compartmentation leading to rapid, sometimes hidden, spread of fire and early collapse) | 2
* SCOLA (Second Consortium of Local Authorities- 2000 built. All schools. 1961-1990. Steel frame construction similar to CLASP. Contains asbestos, quantities, locations and type under current FOI request) | 4
* Single large compartment | 6
* Modular/prefabricated building | 2
* Other | 2
[NAME]:
ASBESTOS
* Cement sheet | 2
* White | 6
* Blue | 6
* Brown | 6
* Unknown | 6
* Asbestos Log present
[NAME] score of 6
[NAME]:
ROOF FEATURES
* Undivided roof space | 6
* Roof space common to more than one premises | 6
* Mansard roof | 6
* Fragile roof | 6
* Unguarded roof area | 4
* Composite roof panels | 6
[NAME] features:
WALL FEATURES
* Flammable wall panelling | 2
* Large areas of internal glazing | 2
* Large areas of external glazing | 2
* Composite wall panels | 6
[NAME] features:
POSSIBLE STRUCTURAL COLLAPSE DUE TO
* Curtain walling (non-load bearing unsupported external skin on a building outer covering of a building in which the outer walls are non-structural merely keeping out the weather) | 6
* Unprotected steelwork | 6
* Unprotected cast iron columns and beams | 6
* Poor construction | 6
* The ceilings are likely to collapse and cause injury | 2
[NAME] collapse:
RISK OF HIDDEN FIRE SPREAD DUE TO
* Voids | 4
* Mezzanine floors | 4
* False ceilings | 4
[NAME] | 4
* Service tunnels | 4
* Unprotected lift shafts | 4
* Ducting | 4
* Air conditioning  / Air Handling Plant | 4
[NAME] fire spread:
BUILDING CONTENTS SIGNIFICANTLY INCREASE FIRE LOAD DUE TO
* Amount of stock | 4
* Type of stock | 4
* High bay storage/racking | 6
* Stock stored to height over 5m | 6
[NAME]:
RISK OF EXTERNAL FIRE SPREAD TO
* One side
* Two sides
* Three sides
* All sides
[NAME]:
FIXED INSTALLATIONS
FIRE ALARM SYSTEM
* Mains | 0
* Battery | 0
* None | 0
AUTOMATIC FIRE DETECTION
* AFD | -1
* Linked to an External Monitoring Station | -1
FIRE SPRINKLER/WATER MIST SYSTEM
* Complete Coverage | -4
* Partial Coverage | -2
* Installed for life safety | -2
* Installed for property protection | -2
* Tank Water Supply | 0
* Mains Water Supply | 0
[NAME] score of -2
[NAME]:
SMOKE CONTROL SYSTEM
* Natural system | -2
* Mechanical system | -2
* Pressurised system | -2
[NAME] score of -2
[NAME]:
FIXED INSTALLATION
* Ventilation system | 0
* Total flood system | -2
* Engineered solution | -2
* Regularly maintained and tested | 0
[NAME]:
8 FIRE FIGHTING WATER
HYDRANTS AS SHOWN ON MDT’S
* Private hydrants available
* Geocode -
* Wash-outs available
* Washouts required to be adopted due to no other hydrants available
* Meter by-pass valves fitted
* Other
OPEN WATER SUPPLIES
* Under 20,000
* 20,000 - 50,000
* 50,000 - 100,000
* 100,001 and over
* Access provisions to the Open Water Supply suitable for pumping appliances
* Access to the Open Water Supply using LPP
* Water supplies prone to seasonal availability
* Other
Available Water Supplies are sufficient to deal with potential risk
RISING MAIN INLET
* Wet
* Dry
* Foam
* Falling Main
[NAME]:
Inspecting Officer:
Station:
Watch:
Date Inspection completed:
Total Score:
???
Risk levels:
SPECIAL
VERY HIGH = 120+
HIGH = 80 - 119
MEDIUM/LOW = 79<