6-_Location_6_Reference_Only.xlsm

XLSM spreadsheet 148 KB Posted Apr 3, 2019

Attached to: Fire Protection & Safety Surveys Federal contract opportunity
Solicitation number: 47PF0019Q0048
Issued by: General Services Administration Public Buildings Service Region 5

About this file

From the source

Location 6 Reference Attachment

View the file

Other files for this federal contract opportunity

Other files attached to Fire Protection & Safety Surveys, newest first.
File	Type	Posted
1-_Location_1_Reference_Only.xlsx	XLSX spreadsheet	Apr 3, 2019
47PF0019Q0048__SF18.pdf	PDF	Apr 3, 2019
4-_Location_4_Reference_Only.xlsm	XLSM spreadsheet	Apr 3, 2019
5-_Location_5_Reference_Only.xlsm	XLSM spreadsheet	Apr 3, 2019
8-_FLS_Contractor_Quote_Sheet.xlsx	XLSX spreadsheet	Apr 3, 2019
2-_Location_2_Reference_Only.xlsm	XLSM spreadsheet	Apr 3, 2019
7-_Location_7_Reference_Only.xlsm	XLSM spreadsheet	Apr 3, 2019
RFQ_Fire_and_Safety_Surveys.pdf	PDF	Apr 3, 2019
3-_Location_3_Reference_Only.xlsm	XLSM spreadsheet	Apr 3, 2019
Combined_Synopsis-Solicitation.pdf	PDF	Apr 3, 2019

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

RAC Summary

National Consolidated Risk Management Survey

FIRE PROTECTION

RAC Summary

Survey Area	RAC Score
Means of Egress
Fire Detection and Alarm
Fire Suppression
Smoke Control
Other

Fire Protection Survey Overall RAC Score:

Building Information

National Consolidated Risk Management Survey

Building Information

Questions Response Findings/Observations

Building Profile
Region	5
GSA Building Number	IL0206ZZ
GSA Building Name	William L. Beatty FB & USCH
Building Street Address	501 Belle St
Building City	Alton
Building State	Illinois
Date(s) of Onsite Survey	Unknown
Surveyor	Chuck Stormer
Type of Occupancies	Mixed Occupancy
Building Point(s) of Contact for Surveys	Chuck Stormer
Date of Building Construction	1972
Date of Last Major Building Renovation	Unknown
Has any work been done since the last survey (e.g., any tenant fit-outs, changes in occupancy, etc.)? If yes, please describe in the findings section.	N/A
Property Type	CH, FB
What is the tenant breakdown?	Multiple
Primary Tenants	Office of Surface Mining and SSA
Is there a law enforcement tenant in this facility?	Yes
Name of O&M or Facilities Management Services Contractor	CMC & Maintenance, Inc.
Name of Custodial Services Contractor	Challenge Unlimited, Inc.
Identify any Unique Space Type(s). If "other" is chosen, please describe the "other" unique space in the comments section.		Unknown
Building Size (GSF)	31,805
Building Size (RSF)	29,191
Total Number of Floors Above Grade	2
Total Number of Floors Below Grade	0
Is the building a highrise according to Rexus?	No
Is the building a highrise according to FPE?	No
What is the building construction classification (IBC Code)?		Unknown
What is the pitch of roof?	Flat
Are there photovoltaic (PV) cells on the roof?	No
Type of Roof Anchoring System		Unknown
Are there antennas?	No
How many elevators are there?	1
Identify Fuel Fired Equipment	Boilers	There are 4 boilers
What are the fuel types?	Natural gas
How many confined spaces are there?	Unknown
What type of confined spaces are there?		Unknown
How many permit-required confined spaces are there?	Unknown
What is the potable water source?	Municipal
Is there asbestos containing material(s)?	Yes
Is there lead paint or other lead material(s)?	Yes
Is there PCB containing material(s)?	Unknown
What energy sources are used onsite? (select all that apply)	Fossil Fuels, Natural Gas
Above-Ground Storage Tanks (ASTs)
Are there any ASTs?	No
If yes, how many are there?	N/a
What is their total value?	N/a
Tank Size (gallons)	N/a
Type	N/a
Tank Location	N/a
Fuel Type	N/a
Installation Date	N/a
Underground Storage Tanks (USTs)
Are there any USTs?	No
If yes, how many are there?	N/a
What is their total value?	N/a
Tank Size (gallons)	N/a
Type	N/a
Tank Location	N/a
Fuel Type	N/a
Installation Date	N/a
Occupant Emergency Plan (OEP)
Is there an OEP?	Yes
Date of plan	3/2/18
Are persons in plan current?	Yes
Is there OEP training for designated persons?	Yes
Are there procedures for evacuation of disabled persons?	Unknown
Are there procedures for after-hours emergencies?	Unknown
Is there a fire department pre-fire plan?	Yes

Means of Egress

National Consolidated Risk Management Survey

Means of Egress

#	Questions	Response	Findings/Observations	Regulatory Citation	Risk Assessment Code (RAC)				Recommended Corrective Actions
					Probability	Severity	RAC	Is there a recommended corrective action associated with this item?	Location	Recommended Action

Means of Egress Components
1	Are doors in compliance? If no, identify and describe the circumstances in the findings section.
2	Are stairs in compliance? If no, identify and describe the circumstances in the findings section.
3	Are handrail/guards in compliance? If no, identify and describe the circumstances in the findings section.
4	Are ramps in compliance? If no, identify and describe the circumstances in the findings section.
5	Are horizontal exits in compliance? If no, identify and describe the circumstances in the findings section.
6	Are exit passageways in compliance? If no, identify and describe the circumstances in the findings section.
7	Other means of egress elements noted? If no, identify and describe the circumstances in the findings section.
Capacity of Means of Egress
8	Is the means of egress capacity based on occupant load for floor and area adequate?
9	Is egrees capacity adequate at convergence points?
Means of Egress Minimum Width
10	Is the means of egress minimum width maintained (i.e. 44" or 36" where permitted)?
Number of Exits
11	Are the required number of exits provided for floor or area?
12	Are there interlocking or scissor stairs present (if yes, counts as 1 exit)?	-	-	-
Arrangement of Means of Egress
13	Are exits readily accessible? If no, identify and describe the circumstances in the findings section.
14	Are common path of travel and dead end arrangements in compliance? If no, identify and describe the circumstances in the findings section.
15	Are exits arranged to be remote per code? If no, identify and describe the circumstances in the findings section.
16	Are travel distances in compliance? If no, identify and describe the circumstances in the findings section.
Discharge of Means of Egress
17	Is the exit discharge in compliance? If no, identify and describe the circumstances in the findings section.
Illumination of Means of Egress
18	If emergency lighting is provided, is there adequate coverage? If no, identify and describe the circumstances in the findings section.
19	Is there a current emergency lighting testing and maintenance report? If yes, please identify the date and any findings in the findings section.
Marking Means of Egress
20	Are adequate markings of means of egress provided? If no, identify and describe the circumstances in the findings section.
21	Is the illumination of the markings of means of egress in compliance? If no, identify and describe the circumstances in the findings section.
Elevators
22	How many elevators are in the building?	-	-	-
23	What is the installation date(s) of the elevator(s)?	-	-	-
24	Do elevators have firemans recall phase I or II?	-	-	-
25	Are any of the elevators used as a required means of egress?	-	-	-
Other Findings
26

Overall Means of Egress RAC

Once the surveyor has reviewed the Means of Egress findings and Overall RAC provided above, if the RAC does not represent the risk associated with the findings as a whole, please provide an adjusted RAC and explanation below.

User Adjusted Means of Egress RAC

Explanation of User Adjusted RAC

Fire Detection and Alarm

National Consolidated Risk Management Survey

Fire Detection and Alarm

#	Questions	Response	Findings/Observations	Regulatory Citation	Risk Assessment Code (RAC)				Recommended Corrective Actions
					Probability	Severity	RAC	Is there a recommended corrective action associated with this item?	Location	Recommended Action

Fire Detection and Alarm
27	Is there a fire alarm system installed? If no, please explain in the findings section.	-	-	-
28	If there is a fire alarm system installed, is the system operational and functioning correctly?
29	What is the fire alarm system type?	-	-	-
30	Is there a current (NFPA 72) test and maintenance report? If yes, please identify the date and any findings in the findings section.
31	Is there off-site notification? If yes, please describe notification in the findings section.	-	-	-
Fire Alarm Control Panel
32	What is the age of the control panel?	-	-	-
33	Where is the fire alarm control panel located?	-	-	-
34	Identify the fire alarm manufacturer (type/model).	-	-	-
35	Is there a fire command station or emergency control center? If yes, please identify in the findings section.	-	-	-
Initiating Devices
36	Are there manual pull station issues? If yes, please describe in the findings section.
37	Are there smoke detectors issues? If yes, please describe in the findings section.
38	Are there duct detectors issues? If yes, please describe in the findings section.
39	Are there heat detectors issues? If yes, please describe in the findings section.
40	Are there water flow switches issues? If yes, please describe in the findings section.
41	Are there valve supervision issues? If yes, please describe in the findings section.
42	Are there any other initiating devices with issues? If yes, please describe in the findings section.
Notification Devices
43	Are there any visual device problems? If yes, please describe problems and date of test and maintenance report in the findings section.
44	Are there any audibility problems? If yes, please describe in the findings section.
Other Findings
45

Overall Fire Detection and Alarm RAC

Once the surveyor has reviewed the Fire Detection and Alarm findings and Overall RAC provided above, if the RAC does not represent the risk associated with the findings as a whole, please provide an adjusted RAC and explanation below.

User Adjusted Fire Detection and Alarm RAC

Explanation of User Adjusted RAC

Fire Suppression

National Consolidated Risk Management Survey

Fire Suppression

#	Questions	Response	Findings/Observations	Regulatory Citation	Risk Assessment Code (RAC)				Recommended Corrective Actions
					Probability	Severity	RAC	Is there a recommended corrective action associated with this item?	Location	Recommended Action

Automatic Sprinklers
46	Is there a fire sprinkler system installed? If no, please explain in the findings section. If yes, please complete the questions below.
47	What is type of fire sprinkler system?	-	-	-
48	What is the age of the oldest sprinkler?
49	What percentage of the facility has a fire protection system?
50	Is there a current (NFPA 25) maintenance report? If yes, please identify the date and any findings in the findings section.
51	Are there any identified fire sprinkler issues? If yes, please explain in the findings section.
Standpipes
52	What are the types of standpipes?	-	-	-
53	Is there current (NFPA 25) maintenance record? If yes, please identify the date and any findings in the findings section.
54	Are there any standpipe issues? If yes, please explain in the findings section.
Fire Pumps
55	Are there any fire pump(s)? If yes, please complete the questions below.	-	-	-
56	What is the location of the fire pump(s)?	-	-	-
57	What is the size of the fire pump, ___gpm at ___psi?	-	-	-
58	Is there a current (NFPA 25) maintenance record? If yes, please identify the date and any findings in the findings section.
59	Are there any fire pump issues? If yes, please explain in the findings section.
60	What is the power source? If diesel, identify any fuel storage issues in the findings section.
Fire Extinguishers
61	Are there fire extinguishers? If yes, please complete the questions below.	-	-	-
62	Have the fire extinguishers been maintained per NFPA 10? If no, identify issues in the findings section.
63	Are the fire extinguishers properly located and sized in compliance with NFPA 10? If no, please explain in the findings section.
Other Suppression Systems
64	Are there other suppression systems? If yes, please describe location and type in the findings section.
65	Are there current maintenance records? What is the date of the last test?
66	Are there identified issues? If yes, please explain in the findings section.
Other Findings
67

Overall Fire Suppression RAC

Once the surveyor has reviewed the Fire Suppression findings and Overall RAC provided above, if the RAC does not represent the risk associated with the findings as a whole, please provide an adjusted RAC and explanation below.

User Adjusted Fire Suppression RAC

Explanation of User Adjusted RAC

Smoke Control

National Consolidated Risk Management Survey

Smoke Control

#	Questions	Response	Findings/Observations	Regulatory Citation	Risk Assessment Code (RAC)				Recommended Corrective Actions
					Probability	Severity	RAC	Is there a recommended corrective action associated with this item?	Location	Recommended Action

Smoke Control
68	Is there a smoke control system present?
69	What is the application of the smoke control system? Please provide the location in the findings section.
70	Is there a current maintenance record? If yes, please identify the date and any findings in the findings section.
71	Are there any smoke control issues? If yes, please explain in the findings section.
Other Findings
72

Overall Smoke Control RAC

Once the surveyor has reviewed the Smoke Control findings and Overall RAC provided above, if the RAC does not represent the risk associated with the findings as a whole, please provide an adjusted RAC and explanation below.

User Adjusted Smoke Control RAC

Explanation of User Adjusted RAC

Other

National Consolidated Risk Management Survey

Other

#	Questions	Response	Findings/Observations	Regulatory Citation	Risk Assessment Code (RAC)				Recommended Corrective Actions
					Probability	Severity	RAC	Is there a recommended corrective action associated with this item?	Location	Recommended Action

Fire and Smoke Barriers
73	Are vertical applications (i.e. stairwell, HVAC shafts) properly maintained? If no, please describe in the comments section.
74	Are horizontal applications (i.e. floors, corridors, special hazard areas) properly maintained? If no, please describe in the comments section.
75	Are special use areas (i.e. laboratories, firing range) properly maintained? If no, please describe in the comments section.
76	Are penetrations properly maintained? If no, please describe in the comments section.
77	Are opening protective's properly maintained? If no, please describe in the comments section.
78	Are all other fire barriers properly maintained? If no, please describe in the comments section.
79	Are there fire dampers, smoke dampers, or combination dampers? If yes, provide where they are located in the findings section.
80	Is there a current maintenance record (NFPA 80)? If yes, please identify the date and any findings in the findings section.
On-Site Power Generation
81	Is there on-site power generation? If yes, please select the appropriate type from the drop down menu.	-	-	-
82	Identify on-site power generation location.	-	-	-
83	Are firefighter provisions in place?	-	-	-
On-Site Fuel Storage
84	Is there on-site fuel storage? If yes, please select the appropriate type from the drop down menu and provide the location and size in the findings section.
85	What is the intended use of on-site fuel?	-	-	-
86	Are there any maintenance records and associated identified issues or concerns? If yes, please explain in the findings section.
Emergency Power
87	Are there emergency generator(s)?	-	-	-
88	Is there a current maintenance record (NFPA 110)? If yes, please identify the date and any findings in the findings section.
89	Are there any identified issues? If yes, please explain in the findings section.
Kitchen Use
90	Is there commercial cooking equipment present? If yes, identify equipment and related fire protection features (i.e. ventilation hoods) in the findings section.
91	Are there any current (NFPA 96) maintenance records? If yes, please identify the date and any findings in the findings section.
92	Are there any identified kitchen issues? If yes, please explain in the findings section.
Interior Finishes
93	Are interior finishes compliant with the occupancy use? If no, please describe in the findings section.
Fire Planning and Prevention
94	Is the fire rating being maintained? If no, then note areas not maintained in the findings section.
95	Is there a fire command room?	-	-	-
96	Are there any other overall fire prevention issues? If yes, please describe in the findings section.
Other Findings
97

Overall Other RAC

Once the surveyor has reviewed the Other findings and Overall RAC provided above, if the RAC does not represent the risk associated with the findings as a whole, please provide an adjusted RAC and explanation below.

User Adjusted Other RAC

Explanation of User Adjusted RAC

Work Item Summary

National Consolidated Risk Management Survey

Work Item Summary and Tracking Sheet

# Findings/Observations Recommended Action Location Action Taken Completion Date

Means of Egress	Means of Egress
	1
	2
	3
	4
	5
	6
	7
	Capacity of Means of Egress
	8
	9
	Means of Egress Minimum Width
	10
	Number of Exits
	11
	12
	Arrangement of Means of Egress
	13
	14
	15
	16
	Discharge of Means of Egress
	17
	Illumination of Means of Egress
	18
	19
	Marking Means of Egress
	20
	21
	Elevators
	22
	23
	24
	25
	Other Findings - Means of Egress
	26
Fire Detection and Alarm	Fire Detection and Alarm
	27
	28
	29
	30
	31
	Fire Alarm Control Panel
	32
	33
	34
	35
	Initiating Devices
	36
	37
	38
	39
	40
	41
	42
	Notification Devices
	43
	44
	Other Findings - Fire Detection and Alarm
	45
Fire Suppression	Automatic Sprinklers
	46
	47
	48
	49
	50
	51
	Standpipes
	52
	53
	54
	Fire Pumps
	55
	56
	57
	58
	59
	60
	Fire Extinguishers
	61
	62
	63
	Other Suppression Systems
	64
	65
	66
	Other Findings - Fire Suppression
	67
Smoke Control	Smoke Control
	68
	69
	70
	71
	Other Findings - Smoke Control
	72
Other	Fire and Smoke Barriers
	73
	74
	75
	76
	77
	78
	79
	80
	On-Site Power Generation
	81
	82
	83
	On-Site Fuel Storage
	84
	85
	86
	Emergency Power
	87
	88
	89
	Kitchen Use
	90
	91
	92
	Interior Finishes
	93
	Fire Planning and Prevention
	94
	95
	96
	Other Findings - Other
	97

RAC Guidance

National Consolidated Risk Management Survey Severity and Probability Assessment Guidance

SEVERITY ASSESSMENT GUIDANCE
SCOPE and APPLICABILITY
	Environmental Risk	Fire Protection Risk	Safety & Health Risk
	Contamination of air, water soil, and biota or non-compliance with environmental regulations	Effects to occupants or facility as a result of a condition or potential event.	Adverse health effects or injury to facility occupants, contractors or visitors in response to a condition or event

SEVERITY LEVEL DEFINITIONS
CATASTROPHIC	Irreversible long-term impacts.	(1) Death, permanent disability or irreversible health effect to occupants or (2) a loss of an entire facility.	Permanent disability, irreversible health effect or death.

SEVERE Reversible long-term damage (5+ years to remediate). (1) Severe injury, potential long-term health effect or (2) major loss or impact to a facility. Potential long-term health effect or severe injury.

SIGNIFICANT Reversible medium-term damage (1-5 years to remediate). (1) Minor injury or reversible health effect or (2) damage to a portion of a facility requiring an extended period of time to repair. Reversible health effect or minor injury.

MODERATE Reversible short-term impact (<1 year to remediate). (1) First aid, no lost time or (2) damage to a facility requiring a minimal amount of time to repair. First aid or no lost time.

MINOR De minimis regulatory violation. De minimis code violation. De minimis code violation.

NO IMPACT	No risk of impact.	No risk of impact to the occupants or facility.	No risk of impact.
PROBABILITY ASSESSMENT GUIDANCE
PROBABILITY LEVEL DEFINITIONS
Likely	Imminent

	1 in 10
Probable	Probable

	1 in 100
Possible	Possible

	1 in 1000
Remote	Remote

	1 in 10,000
Unlikely	Unlikely

	1 in 100,000
Not Possible	Non-existent

RAC

	Probability							RAC_probability	RAC severity
Severity		Imminent	Probable	Possible	Remote	Unlikely	Not Possible
	Catastrophic	1	1	2	3	3	6	A	I
	Severe	1	2	3	3	4	6	B	II
	SIGNIFICANT	2	3	3	4	4	6	C	III
	MODERATE	3	3	4	4	5	6	D	IV
	MINOR	3	4	4	5	5	6	E	V
	NO IMPACT	6	6	6	6	6	6

Lists

Yes/No

yes/No/NA

NFPA:

Common Terminology

NFPA

FireAlarmSystems

IBC

Standpipe Types

Regions

Oldest Sprinklers

Occupancy Types

Offsite Notification

Sprinkler System

Smoke Control System

Generator Type

On Site Fuel Storage

Building Materials

Risers

YNAction

Probability

Severity

FireProtection

PropertyType

Tenant Breakdown

Unique Spaces

ConfinedSpaces

Potable Water Source

Anchoring System

EnergySources

Yes

Emergency Communication Systems

Yes

Imminent

Catastrophic

0-24%

Multiple

Cafeteria

Manholes

Municipal

Davit

Fossil Fuels

Yes

Type I (443)

Fire Resistive, Non-Combustible

Type I (443)/Fire Resistive, Non-Combustible

Protected Premise Systems

Class I

Standard

Business

Megacenter

Wet

Stair Pressurization

Photovoltaic

LP Containers

Combustible

N/A

Probable

Severe

25-49%

Border Station

Single

CCC

Sewage Ejection Pit

Well-water

Engineered

Natural Gas

N/A

Type I (332)

Fire Resistive, Non-Combustible

Type I (332)/Fire Resistive, Non-Combustible

Class II

Quick Response

Public Assembly

Local Fire Department

Dry

Atrium

Wind Turbines

Diesel

Limited Combustible

Possible

Significant

50-74%

Explosive Storage

Tanks

Tie-back

Wind

Unknown

Type II (222)

Fire Resistive, Non-Combustible

Type II (222)/Fire Resistive, Non-Combustible

IIA

Class III

Storage

UL Central Station

Deluge

Other

Geothermal

Gasoline

Non-Combustible

Remote

Moderate

75-99%

Firing Range

Vaulted

Solar

Type II (111)

Protected Non-combustible

Type II (111)/Protected Non-combustible

IIB

Combination

Light Industrial

Other

Pre-Action

N/A

Microturbines

Other

Unlikely

Minor

100%

Garage

Holding Cells

Other

Geothermal

Type II (000)

Unprotected Non-combustible

Type II (000)/Unprotected Non-combustible

IIIA

Wet

Child Care

Other (Please Identify in Comments)

N/A

Not Possible

No Impact

Warehouse

Laboratory

N/A

Hydropower

Type III (211)

Protected Ordinary

Type III (211)/Protected Ordinary

IIIB

Dry

Mixed Occupancy

None

Wareyard

Sallyport

Other

Type III (200)

Unprotected Ordinary

Type III (200)/Unprotected Ordinary

N/A

Other

Secure Space

Type IV (2HH)

Heavy Timber

Type IV (2HH)/Heavy Timber

Unknown

WWTP

Type V (111)

Protected Combustible

Type V (111)/Protected Combustible

Other

Type V (000)

Unprotected Combustible

Type V (000)/Unprotected Combustible

ESRI_MAPINFO_SHEET

DO NOT EDIT

For Esri use only image1.jpeg

File details come from the government source that posted it.