B08_Attach_1F_2018_AKR_Structural_Fire_Inventory_data_collection_ELECTRONIC.xlsm

XLSM spreadsheet 109 KB Posted

Attached to
KATM 245181 Reinstall Fire Sprinkler Systems in NPS King Salmon FAA Permanent Housing
Solicitation number
140P2018R0044
Issued by

About this file

Attach 1F Structural Fire Inventory data

View the file

Other files

Show all 14

On GovTribe

Work with this file

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

Text version

LOCATION

PARK ALPHA CODE Existing Asset # Action Required

FMSS LOCATION #
LatitudeERROR:#REF!NAD83
LongitudeERROR:#REF!NAD83
BUILDING TYPE

LOCATION DESCRIPTION

QUANTITY (S.F.)

Asset Type / Classification Yes/No Does Asset Already Exist in FMSS?

Vantrease, Scott: Vantrease, Scott:

This is used when an existing asset has undergone modification.Yes/No
ELECTRCL_EMERLGHTNoELECTRCL_EMERLGHTNoNO ACTION REQUIRED

ELECTRCL_GNERATOR No ELECTRCL_GNERATOR No NO ACTION REQUIRED

SAFETY_ALARM_FRALMSIG No SAFETY_ALARM_FRALMSIG No NO ACTION REQUIRED

SAFETY_ALARM_SMKALSYS No SAFETY_ALARM_SMKALSYS No NO ACTION REQUIRED

SAFETY_SMKMNGCT No SAFETY_SMKMNGCT No NO ACTION REQUIRED

SAFETY_SUPPRSSN_FIRESUPP No SAFETY_SUPPRSSN_FIRESUPP No NO ACTION REQUIRED

SAFETY_SUPPRSSN_FIREXTGH No SAFETY_SUPPRSSN_FIREXTGH No NO ACTION REQUIRED

SAFETY_SUPPRSSN_FIRESPRINK No SAFETY_SUPPRSSN_FIRESPRINK No NO ACTION REQUIRED

SAFETY_SUPPRSSN_FRPMPSYS No SAFETY_SUPPRSSN_FRPMPSYS No NO ACTION REQUIRED

SAFETY_SUPPRSSN_HYDRANT No SAFETY_SUPPRSSN_HYDRANT No NO ACTION REQUIRED

SAFETY_SUPPRSSN_STNDPIPE No SAFETY_SUPPRSSN_STNDPIPE No NO ACTION REQUIRED

STRCTURE_DOORNoSTRCTURE_DOORNoNO ACTION REQUIRED
COMMENT
Yes
No

1. Input park alpha using drop down and the FMSS location number provided by the park.

2. Rename the spreadsheet with format: PARK_FMSSloc.Num_Structural Fire Inventory

3. Indicate the asset types using the Yes/No drop down for each asset classification.

4. Asset Types with a Yes: Go to corresponding tab for each with same Asset Type / Classification.

5. Input specification data for each asset classification. If pick list does not describe the asset accurately, add information to comments field. Pick list values are shown in the at the bottom of the page.

6. Enter any additional information that is valuable in the DESCOMT (Description Comments) field.

7. Each picture must be tagged with: PARK alpha_Loc.Num_Classification Asset Type / Classification Legend ELECTRCL_EMERLGHT - Emergency Lighting ELECTRCL_GNERATOR - Generator SAFETY_ALARM_FRALMSIG - Fire Alarm Signaling System SAFETY_ALARM_SMKALSYS - Smoke Alarm System SAFETY_SMKMNGCT - Smoke Management & Control System SAFETY_SUPPRSSN_FIRESUPP - Fixed Fire Suppression System SAFETY_SUPPRSSN_FIREXTGH - Portable Fire Extinguishers SAFETY_SUPPRSSN_FIRESPRINK - Fire Sprinkler System SAFETY_SUPPRSSN_FRPMPSYS - Fire Pump System SAFETY_SUPPRSSN_HYDRANT - Fire Hydrants SAFETY_SUPPRSSN_STNDPIPE - Standpipe System STRCTURE_DOOR - Fire Doors

ELECTRCL-EMERLGHT

Park Information
Park Alpha0
FMSS Location #0
Install DateDate of installation. If unknown, an approximate date is sufficient.
ELECTRCL/EMERLGHTEmergency Lighting
System PresentNo
TYPEType of Emergency Light Power Source
VOLTAGEVoltage of Power Source
Emergency LightEnter count

Exit Signs Enter count

DESCOMTDescription Comment
COMMENTComments
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
ELECTRCL /EMERLGHT
TYPE
Dry Cell Battery
Hard Wired
Other
Wet Cell Battery
VOLTAGE
12
120/208
120/240
24
2400/4160
277/480
36
Other

ELECTRCL-GNERATOR

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
ELECTRCL/GNERATORGenerator
System PresentNo
KWGenerator KW rating (Numeric)
VOLTAGEGenerator Volrage rating (Numeric)
FUELGenerator Fuel Type
DESCOMTDescription Comment
COMMENTComments
KVAGenerator KVA rating (Numeric)
PWRFACTRGenerator Power Factor (Numeric)
PHASEGenerator Phases
SFRELATEIs generator structural fire related?
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
ELECTRCL/GNERATOR
VOLTAGE
12
120/208
120/240
24
2400/4160
277/480
36
Other
FUEL
Biofuel
Coal
Diesel
Electric
Fuel Oil
Gasoline
LPG/Propane
Multi-Fuel
Natural Gas
Oil/Gasoline
Other
Wood
PHASE
1 phase
3 phase
Other
SFRELATE
Yes
No

SAFETY-ALARM-FRALMSIG

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
SAFETY/ALARM/FRALMSIGFire Alarm Signaling System
System PresentNo
TYPEType of FA System
FRALMNETIs the FA panel a part of a network?
RELSSYSIs FA System used to recall elevators, release doors, initiate suppression system activation or initiate HVAC shutdown?
FRALRMMNIs FA System monitored outside of building?
FIREUSEListed for Commercial Use?
CNTPNMANControl Panel Manufacturer
CNTPNMODControl Panel Model
HTDETMANHeat Detector Manufacturer
HTDETMODHeat Detector Model
HTDETTYPHeat Detector Type - Restorable or Nonrestorable?
HEATDETHeat Detector Count (Numeric)
MANPLLSTManual Pull Station Count (Numeric)
NOTFAPPLNotification Appliance Count (Numeric)
REMTANNURemote Annunciator Count (Numeric)
SMKDTMANSmoke Detector Manufactuer
SMKDTMODSmoke Detector Model
SMOKDETSmoke Detector Count (Numeric)
SMOKHDETCombo Smoke/Heat Detector Count (Numeric)
MANABTSYManual Abort Station Count (Numeric)
SIGNTRNSSignal Tramsmission
DESCOMTDescription Comment
COMMENTComment
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION 0

SAFETY/ALARM/FRALMSIG
TYPEFIREUSE
AddressableYes
ConventionalNo
FRALMNETNTDETTYP
YesNonRestorable
NoRestorable
RELSSYSSIGNTRNS
YesCommercial Monitoring Service
NoGovernment Monitoring Service
FRALRMMNNone
YesOther
No

SAFETY-ALARM-SMKALSYS

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
SAFETY/ALARM/SMKALSYSSmoke Alarm System
System PresentNo
TYPEType of Smoke Alarm System
SMKALMCTCount of Smoke Alarms (Numeric)
SMKALMMNSmoke Alarm Manufacturer
SMKALMMDSmoke Alarm Model
DESCOMTDescription Comment
COMMENTComments
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
SAFETY-ALARM-SMKALSYS
TYPE
Battery
Hardwired
Hardwired Interconnected
Other

MASTER ATTRIBUTES LIST

PARK ALPHA CODESAFETY-SUPPRSSN-STNDPIPE
BELATYPE
DENAClass I - Fire Department Use
GLBAClass II - Building Occupant Use
KATMClass III - Combination
KEFJ
KLGO
SITKBuilding TypeDefinition
WEAROffice-PO-Instit.-School-Public BldgsBldg Office*Buildings primarily used for office space or military headquarters.
WRSTBldg Post OfficeBuildings or portions of buildings used as a Post Office.
Bldg SchoolBuildings used primarily for formally organized instruction, such as schools for dependent children of Federal employees, Indian schools, and military training buildings including specialized training facilities.
Bldg School Day CareA building designed and used primarily for daytime care given to preschool and/or adolescent children.
Bldg School Environmental Education CenterA building/educational facility used for structured education to build knowledge, skills and abilities in students and others about wildlife-related environmental topics and programs.
Bldg Training CenterA building used to instruct personnel on programs, techniques, goals, policies, procedures, regulations, standards, and direction relating to individual agency missions.
Comfort Stations/RestroomsMore complex toilet/lavatory building typically with running water and connection to sanitary sewer or septic systems.
Vault Toilets/Pit ToiletsBasic toilet facilities, typically without running water or connection to sanitary sewer/septic systems. May have a lined vault made of concrete or other material in which the waste remains until it is pumped out.
Bldg Museum/RepositoryA building used to store, protect and/or display museum property.
Bldg LibraryA building used for a large systematically arranged collection of books for reading or reference
Bldg Law Enforcement CenterBuilding designed to support local law enforcement operations, and may include short term lockup area.
Bldg CourthouseA building in which court proceedings are held
Bldg ClinicA building where medical personnel administer to outpatient treatment
Bldg Visitor CenterA building designed specifically for the purpose of orienting visitors to resources and programs and providing other services to support visitation. Usually includes exhibits and restrooms; sometimes gift shops.
Bldg Visitor Contact StationA building smaller than 5,000 square feet or which has 50% or less of its square footage devoted to direct service to visitors. This is a place where we distribute information and regulations intended to welcome and orient visitors.
Bldg Entrance StationA small building used primarily for the collection of fees and distribution of limited information and regulations with no additional visitor services. Sometimes referred to as an 'entrance kiosk'. Report all 'kiosks' here at this time.
Bldg RestaurantA building where meals are served to customers that usually contains a food preparation area, a seating area for customers. Primarily for the public.
Bldg GymnasiumA building where the predominant use is for indoor athletic or fitness activities. May contain courts, locker facilities, or specialized sporting or exercise equipment.
Bldg Dining Hall CafeteriaBuilding containing kitchen facilities, food preparation areas, serving areas, and table areas for dining. Primarily for staff and work crews.
Bldg AuditoriumA building used to accommodate listening to or viewing of performances by seated students and/or guests. As opposed to an open air venue which would be categorized as an amphitheater.
Bldg Lodge/Motel/HotelA building for visitor overnight accommodation as opposed to employee, staff, or volunteer housing. This includes sleeping shelters, i.e. along the Appalachian Trail.
Bldg Retail StoreA building used to sell goods to customers.
HousingBldg Housing Mobile Home*A mobile building, fitted with parts for connection to utilities, that can be relocated and used predominantly for housing. This definition does not include trailers that reside on wheels. Includes yurts.
Bldg Housing Single Family*Detached building constructed to house one family.
Bldg Housing Multi- Family Plex*Building consisting of two or more single family housing units such as duplexes, triplexes, townhouses, row houses, etc.
Bldg Housing Apartment*Building consisting of multiple single family housing units with access from a common corridor.
Bldg Housing Cabin*A building with fewer utilities and/or rooms than a typical single-family house.
Bldg Housing Garage*Any building associated with housing designed for the purpose of parking vehicles.
Bldg Housing Support Building*Any building that directly supports employee housing (NPS, concessioner, etc) functions, such as showering, laundry, cooking, and detached carports.
Bldg Dormitories/ Barracks*Buildings primarily used as dwellings for housing individuals (without families/dependents).
WarehouseBldg Warehouse Fire Cache*A building used to store equipment and vehicles used for wildland fire management and suppression.
Bldg Warehouse Equipment Vehicle*A building used to store vehicles or equipment, including heavy equipment. Not associated with housing.
Bldg Warehouse Shed Outbuilding*A small structure, either freestanding or attached to a larger structure, to be used as storage or shelter.
Bldg Warehouse Chemical*A building designed to store materials that may be hazardous if leaked or spilled. Design may incorporate spill containment, explosion proof lights or other electrical fixtures.
Bldg Warehouse Warehouse*Building/structure designed for storage or production purposes, which may include an office area and/or loading dock.
Bldg Warehouse Explosive*A building designed and used to store high explosives such as C4, TNT, Blasting caps, or black or smokeless powder.
Utility-Service-LabBldg Pump House Well HouseA building used to shelter pumps, piping pressure switches, or other related equipment.
Bldg Power GenerationBuilding specifically designed and constructed to house power generation equipment. It does not include the utility system components such as engines, turbines, generators, alternative energy sources, and associated control equipment for the purpose of electrical generation.
Bldg Sewage TreatmentBuilding specifically designed and constructed to house sewage treatment components. It does not include systems used to treat sewage.
Bldg Water TreatmentA building specifically designed and constructed to house water treatment components. It does not include the systems used to treat raw source water to produce potable water.
Bldg Service Shop MaintenanceBuilding used for performing various service activities such as mechanical or preventive maintenance work on various vehicles, welding, sheet metal work, and painting including auto shops, carpenter shops, metal shops etc.
Bldg Communications SystemsBuildings used for telephone and telegraph systems, data transmission, satellite communications and/or associated with radio towers or other communication facilities.
Bldg LighthouseA tower building displaying a light or lights for the guidance of maritime vessels in present time or historically.
Bldg Laboratory*Building used for scientific research and development. Likely to house specialized scientific equipment for conducting scientific experiments or analysis.
Other BuildingsBldg Animal ShelterA building used to provide animals shelter from inclement weather.
Bldg Barn StableA building used to hold or shelter animals or livestock feed. May also contain feeding, exercise or birthing areas.
Bldg Fire StationA building used for fire equipment and staff to ensure readiness. May include communications facilities or living quarters for fire fighters. Associated with structural fire fighting.
Bldg Cultural CenterA building preserved and/or used for training and refinement of the mind pertaining to cultural practices, interest, taste, skills, arts and crafts, or to provide an example of a type of construction, period appearances, or for interpretive uses.
Bldg HoganA typical dwelling of the Navajo Indians, built of earth walls supported by timbers.
Bldg LaundryA building specifically used for laundering clothes, linens, etc. Not associated with housing. See Housing support 35300700.
Bldg GreenhouseA translucent or transparent building used in the conservation or production of plants or plant material.
AmphitheaterA designated area with seating where participants can gather for movies, nature talks, interpretive presentations, etc.
Monument/MemorialA structure erected to commemorate a person or event.

SAFETY-SMKMNGCT

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
SAFETY/SMKMNGCTSmoke Management & Control System
System PresentNo
TYPEType of Smoke Management & Control System
DESCOMTDescription Comment
COMMENTComments
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
SAFETY/SMKMNGCT
TYPE
Dedicated
Nondedicated

SAFETY-SUPPRSSN-FIRESUPP

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
SAFETY/SUPPRSSN/FIRESUPPFixed Fire Suppression System
System PresentNo
TYPEType of Fixed Fire Suppression System
INTRFACESystem interfaced with building FA, HVAC, electrical, gas or other systems?
MANUSystem Manufacturer
MODELSystem Model
INITDEVInitiating Devices - Restorable or Nonrestorable
MANRLSTManual Release Station Count (Numeric)
SMKDTMANUSmoke/Heat Detector Manufacturer
SMKDTMODSmoke/Heat Detector Model
SMOKHDETSmoke/Heat Detector Count (Numeric)
NOTFAPPLNotification Appliance Count (Numeric)
TAMPSWITCTamper Switch Count (Numeric)
WFDETDEVWater Flow Detection Device Count (Numeric)
MANABTSYManual Abort Switch Count (Numeric)
CYLINDERCylinder Count (Numeric)
DESCOMTDescription Comment
COMMENTComments
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
SAFETY-SUPPRSSN-FIRESUPP
TYPE
Carbon Dioxide System
Clean Agent System
Commerical Cooking Protection
Dry Chemical Suppression System
Halon System
Watermist Sprinkler System
Wet Chemical Suppression System
INTRFACE
Yes
No
INITDEV
NonRestorable
Restorable

SAFETY-SUPPRSSN-FIREXTGH

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
SAFETY/SUPPRSSN/FIREXTGHPortable Fire Extinguishers
System PresentNo
TYPEType of Fire Extinguishers
COUNTCount of Fire Extinguishers (Numeric)
FRXAREAFire Extinguisher Coverage Area (Numeric - Sq. Ft.)
DESCOMTDescription Comment
COMMENTComments
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
SAFETY-SUPPRSSN-FIREXTGH
TYPE
CO2
Dry Chemical
Foam
Halon
Inert Agent
Other
Water

SAFETY-SUPPRSSN-FIRESPRINK

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
SAFETY/SUPPRSSN/FIRSPRNKFire Sprinkler System
System PresentNo
TYPEType of Sprinkler System
CNTPMNFRRelease Control Panel Manufacturer
CNTPMODLRelease Control Panel Model
VALVMANUMain Control Valve Manufacturer
VALVMODLMain Control Valve Model
SMKDTMANUSmoke/Heat Detector Manufacturer
SMKDTMODSmoke/Heat Detector Model
SMOKHDETSmoke/Heat Detector Count (Numeric)
MANRLSTManual Release Station Count (Numeric)
NOTFAPPLNotification Appliance Count (Numeric)
TAMPSWITCTamper Switch Count (Numeric)
WFDETDEVWater Flow Detection Device Count (Numeric)
SYSRISRSSystem Riser Count (Numeric)
VLVASMANRiser Valve Assembly Manufacturer
VLVASMDLRiser Valve Assemly Model
VLVACOUNTRiser Valve Assembly Count (Numeric)
DESBASPLDesign Basis Placard Present?
AIRCOMPRAir Compressor Type
BCKFLTYPBackflow Preventer Type
VALSIZEBackflow Preventer Valve Size
FRLOSAMTBackflow Preventer Friction Loss Amount (Numeric)
BCKFLMANBackflow Preventer Manufacturer
ANTFRZSYAntifreeze System Type
DESCOMTDescription Comment
COMMENTComments
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
SAFETY-SUPPRSSN-FIRSPRINK
TYPEAIRCOMPR
DelugeDedicated
Dry PipeRiser
OtherShared
PreactionStand-Alone
ResidentialBCKFLTYP
Wet PipeDouble-check
DESBASPLOther
YesReduced Pressure Zone
NoStandard
ANTFRZSY
Glycerin
Glycol
Other

SAFETY-SUPPRSSN-FRPMPSYS

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
SAFETY/SUPPRSSN/FRPMPSYSFire Pump System
System PresentNo
TYPEFire Pump Type
MANUFire Pump Manufacturer
PUMPSIZEFire Pump Size (Numeric - GPM)
HORSPWERFire Pump Horsepower (Numeric)
FRAMESIZFire Pump Motor Frame Size (Numeric)
MOTRHOUSFire Pump Motor Housing Type
PHASEFire Pump Phase
CNTRMANUFire Pump Controller Manufacturer
CNTRMODLFire Pump Controller Model
DRIVMANUFire Pump Drive Manufacturer
DRIVMODLFire Pump Drive Model
TAMPSWITCTamper Switch Count (Numeric)
JKPMPMANJockey Pump Manufacturer
JKPMPMODJockey Pump Model
DESCOMTDescription Comment
COMMENTComments
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
SAFETY-SUPPRSSN-FRPMPSYS
TYPE
Diesel Engine Drive
Electric Motor Drive
Other
Propoane Motor Drive
MOTRHOUS
Explosion Proof
Other
Standard
Submersible
PHASE
1 Phase
3 Phase
Other

SAFETY-SUPPRSSN-HYDRANT

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
SAFETY/SUPPRSSN/HYDRANTFire Hydrants
System PresentNo
TYPEFire Hydrant Type
SIZEFire Hydrant Size of Base Connection
PSIFire Hydrant Static Pressure (Numeric - PSI)
FLOWRATEFire Hydrant Flow Rate (Numeric - GPM)
DESCOMTDescription Comment
COMMENTComments
MATERIALFire Hydrant Material
NOSSIZEHose Nozzle Size
MOUNTINGFire Hydrant Mounting
HOSNOZZLHose Nozzle Type
PMPNOSSLPumper Nozzle Type
LOCATIONFire Hydrant Locations
HYDBREAKFire Hydrant Breakaway Section

GPS LATITUDE

GPS LONGITUDE
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
SAFETY-SUPPRSSN-HYDRANT
TYPEHOSNOZZL
Dry BarrelNPT
OtherNSHT
Single OutletNSPH
Wet BarrelOther
MATERIALStorz
Cast BronzePMPNOZZL
Cast IronNPT
Ductile IronNSHT
OtherNSPH
PVCOther
Reinforced PlastStorz
Stainless SteelLOCATION
Steel AlloyAt Grade
MOUNTINGFlush
Anti-vibrationOther
Base'Pad MountWall Mount
Close CoupledHYDBREAK
Flange MountedYes
Foot MountedNo
Horizontal Mount
In-line Mount
Other
Roof Mount
Suspended
Vertical Mount
Wall Mount

SAFETY-SUPPRSSN-STNDPIPE

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
SAFETY/SUPPRSSN/STNDPIPEStandpipe System
System PresentNo
TYPEStandpipe System Class
COUNTStandpipe System Count (Numeric)
DESCOMTDescription Comment
COMMENTComments
PARK ALPHA CODE0

LOCATION 0

LOCATION DESCRIPTION0
SAFETY-SUPPRSSN-STNDPIPE
TYPE
Class I - Fire Department Use
Class II - Building Occupant Use
Class III - Combination

STRCTURE-DOOR

Park Information
Park Alpha
FMSS Location #
Install DateDate of installation. If unknown, an approximate date is sufficient.
STRCTURE/DOORFire Doors
System PresentNo
EXT DOOR EGRESS HDWExterior Exit Door with Egress Hardware Count (Numeric)
INT DOOR EGRESS HDWInterior Door with Egress Hardware Count (Numeric)
INT DOOR EGRESS HDW + RATEDInterior Door with Egress Hardware & Fire Rating Count (Numeric)
DESCOMTDescription Comment
COMMENTComments
PARK ALPHA CODE0
LOCATION0
LOCATION DESCRIPTION0

LocationAssetList

Page &P

File details come from the government source that posted it.