Appendix F - CDRL A033 Asset Data Template v2.2.xlsx

XLSX spreadsheet 488 KB Posted

Attached to
Solicitation Posting of the Global Sustainment of Anti-Terrorism Force Protection (AT/FP) Systems and Assets, Worldwide.
Solicitation number
N3943020R2245
Issued by

About this file

This document contains a federal contract solicitation and an asset data template. The solicitation seeks proposals for the global sustainment of Anti-Terrorism Force Protection systems and assets worldwide. The Naval Facilities Engineering Command intends to award a single IDIQ contract with a ceiling of $600 million over a base period of 5 years and an optional 3 year extension. The minimum guarantee is $50,000. Proposals are due by 11 September 2020 in response to Performance Work Statement requirements for sustainment of existing AT/FP systems and assets. Separate task orders will be awarded for modernization and upgrades. The asset data template provides a standardized format for capturing information on hardware, software, and location details of AT/FP assets to support the contract requirements.

View the file

Other files

File Type Posted
Remedy Incident Guide.pdf PDF
N3943020R22450001.pdf PDF
Remedy CDRL Submission Guide.pdf PDF
AIM User Guide.pdf PDF
N3943020R22450002.pdf PDF
N3943020R22450003.pdf PDF
Attachment 6 - Safety Factor 20200909.doc DOC document
Attachment 5 - Subcontracting Plan Template 20200910.doc DOC document
LENEL Dongles list June 2020.xlsx XLSX spreadsheet
Attachment 2 Pricing Schedule 20200921.xlsx XLSX spreadsheet
Remedy Incident Categorization Information.pptx PPTX presentation
Attachment 9 - Sustainment Task Order PWS 20200909.docx DOCX document
Appendix J - Historical 3-yrs Record of Gap Service Calls - 20191204.xlsx XLSX spreadsheet
Appendix A - Acronym List.pdf PDF
Appendix D2 New Install 20200714 Final.pdf PDF
Appendix E CNIC Move Add Change Policy.pdf PDF
APP-C List of Systems to be Sustained - 20200709 Final.xlsx XLSX spreadsheet
Attachment 2 - ELIN Price Schedule 20200812.xlsx XLSX spreadsheet
Appendix D3 Tech Refresh 20200714 Final.pdf PDF
Appendix D1 Sustainment 20200714.pdf PDF
Attachment 9 Sustainment Task Order PWS 20200730.docx DOCX document
Appendix B Contractor User Guide for Remedy AIM 20200709 Final.docx DOCX document
Appendix N - Historical 3-yr Asset Failure Data - 20191204.xlsx XLSX spreadsheet
Appendix H ATFP Ashore GSC QASP 20200306.pdf PDF
Attachment 5 - Subcontracting Plan Template.doc DOC document
Appendix O - Historical 3-yr Record of Non-Gap Service Calls with tix count- 20191204.xlsx XLSX spreadsheet
Attachment 6 - Safety Factor.doc DOC document
Appendix L - DD Form 1423s for CDRL A002-A043.pdf PDF
Appendix P - Historical HAZMAT Costs.xlsx XLSX spreadsheet
Appendix R - Preventive Maintenance Checklist Samples.pdf PDF
Attachment 8 - RFI Form.doc DOC document
Appendix K - GSC DD254 Draft 20191206.pdf PDF
Attachment 3 - SB Subcontracting Record.docx DOCX document
Attachment 1 - PPQ.docx DOCX document
Appendix Q - Historical FRU Costs.xlsx XLSX spreadsheet
Attachment 4 - SB Participation and Commitment Strategy 20200812.docx DOCX document
APP-M Subcomponent Detail for Systems to be Sustained - 20200713 Final.xlsx XLSX spreadsheet
Appendix G CDRL Review Process BMT Approved 12Jan16.pdf PDF
Attachment 7 - Wage Determinations 20200819.pdf PDF
N3943020R2245.pdf PDF
Show all 40

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

Asset Data Template

Yes
No
Hardware
Software
Action Column Legend:
NCNo Change (Used during SPOT CHECKS to indicate an Asset has been checked)
NFNot Found (Used during SPOT CHECKS to indicate this Asset could not be located (Add "Unable to Locate Asset" to col "Description/Addtl Info"))
AAdd (Used to add a new Asset)
RRemoved (The asset has been removed or replaced). Indicate the "Asset Status" for this record as "Disposed" and include the Asset Tag ID of the asset replacing it in the "Description/Addtl Info" cell of this record.
MModified (used to show changes and add information that may have been missing) - Highlight the modified data in YELLOW
NSNot Sustained (Used to indicate this Asset is Not Sustained by ATFP/ASHORE)
NAVFAC AT/FP Asset Data Template - 10 Jan 2018 - v2.2
1580606060141430503060255254254253302532536025330255255255253255
ActionIncident NumberUnique Remedy IDPrincipal CategoryFamily Of Systems-SystemProject RegionBase SiteUnique IdentifierProject NameAsset SystemNumber Of UnitsUnit CostAsset NameCategoryTypeItemVerified ByDate Asset VerifiedAsset IDPrevious Asset IDSerial NumberPart NumberModel NumberFrequencySecurity KeyPLC Logic Version NumberManufacturer NameDescription/Addtl InfoAsset StatusBuildingFloorRoomRackAsset LocationLatitudeLongitudeSoftware VersionLast Date AllowedLast Software Change DateDADMSIDServer Machine NameOperating SystemLicense CodeLicense Expiration DateType of LicenseCertificate Expiration DateSoftware AssuranceSoftware OwnershipHardware Firmware VersionMission Critical

Example Sheet

Not required but please fill out if you have the information
Required Fields, if info is applicable
SPAWAR will fill out info
Software Data, only applicable to Software Items
ActionIncident NumberUnique Remedy IDPrincipal CategoryFamily Of Systems-SystemProject RegionBase SiteUnique IdentifierProject NameAsset SystemNumber Of UnitsUnit CostAsset NameCategoryTypeItemVerified ByDate Asset VerifiedAsset IDPrevious Asset IDSerial NumberPart NumberModel NumberFrequencySecurity KeyPLC Logic Version NumberManufacturer NameDescription/Addtl InfoAsset StatusBuildingFloorRoomRackAsset LocationLatitudeLongitudeSoftware VersionLast Date AllowedLast Software Change DateDADMSIDServer Machine NameOperating SystemLicense CodeLicense Expiration DateType of LicenseCertificate Expiration DateSoftware AssuranceSoftware OwnershipHardware Firmware VersionMission Critical
NO CHANGE EXAMPLE (SPOT CHECK)
NC1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City1450Camera, Mini DomeHardwareAV EquipmentCameraTim SmithMM/DD/YYYYATFP0000033377WV-CW504SD5RX/TX: 123.4567 MHz12345PANASONICDeployed1Gate 2 Burns City12.345467123.45678
NC1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City1255.25Traffic LightHardwareAV EquipmentLightTim SmithMM/DD/YYYYATFP000003340582B7-48BE-D0F44555 9-24VDCSIGNAL TECHDeployed1Gate 2 Burns City
MISSING ASSET EXAMPLE (SPOT CHECK)
NF1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City1332Assembly, Instrument RackHardwareAccessoriesMounting BracketTim SmithMM/DD/YYYYATFP0000034473SPTIDFAC-001SPTIDFAC-001SPT/ALUTIIQUnable to locate AssetDisposed1Gate 2 Burns City
NF1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City1125Receiver, WirelessHardwareAV EquipmentReceiverTim SmithMM/DD/YYYYATFP0000034485WWR-42RX/TX: 123.4567 MHz12345FARPOINTE DATAUnable to locate AssetDisposed1Gate 2 Burns City12.345467123.45678
NF1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City145Card Reader, RFIDHardwareBiometrics & Access ControlCard ReaderTim SmithMM/DD/YYYYATFP00000344991142A1304971050977-101MC2 250CODEBENCHUnable to locate AssetDisposed1Gate 2 Burns City
HARDWARE ASSOCIATED TO SOFTWARE EXAMPLE
NC1960C4IRDCCNREURAFSWANSA BahrainLDC UpgradeC4I.RDC.CNREURAFSWA.NSA Bahrain.LDC Upgrade1623.74HP DL360e Proliant ServerTim SmithMM/DD/YYYYATFP0000084074MXQ40306B8686210-S01Hewlett PackardCAD Domain ServerDeployed2662nd2277BAHRAIN-DCMicrosoft Server 2008R210/31/19F.4112
A1960C4IRDCCNREURAFSWANSA BahrainLDC UpgradeC4I.RDC.CNREURAFSWA.NSA Bahrain.LDC Upgrade11228.25WINDOWS 2008 SERVERTim SmithMM/DD/YYYYNTRMicrosoftDeployed2662nd227720088/26/14ATFP0000084074Microsoft Server 2008R3W6735-RZR80-BFG5H-65TY7-2SX79ServerNoCNIC N6
A1960C4IRDCCNREURAFSWANSA BahrainLDC UpgradeC4I.RDC.CNREURAFSWA.NSA Bahrain.LDC Upgrade149.99Symantec pcAnywhereTim SmithMM/DD/YYYYNTRNortonDeployed2662nd227712.1.08/26/14ATFP0000084074Microsoft Server 2008R4XFT8-KLUN-8H7T-MV34-2E65-VZ92FixedNoAT/FP Ashore
A1960C4IRDCCNREURAFSWANSA BahrainLDC UpgradeC4I.RDC.CNREURAFSWA.NSA Bahrain.LDC Upgrade1155.23MiY Security ManagerTim SmithMM/DD/YYYYNTRRX/TX: 123.4567 MHz12345CogentDeployed2662nd22771.7.13986.08/26/14ATFP0000084074Microsoft Server 2008R5FloatingNoMotorola
A1960C4IRDCCNREURAFSWANSA BahrainLDC UpgradeC4I.RDC.CNREURAFSWA.NSA Bahrain.LDC Upgrade159.63Paragon Drive BackupTim SmithMM/DD/YYYYNTRParagon SoftwareDeployed2662nd22778.51 Server Edition8/26/14ATFP0000084074Microsoft Server 2008R6FloatingNoCNIC N6
A1960C4IRDCCNREURAFSWANSA BahrainLDC UpgradeC4I.RDC.CNREURAFSWA.NSA Bahrain.LDC Upgrade11002.44AutoCAD LT 2004Tim SmithMM/DD/YYYYNTRAutodeskDeployed2662nd227716.0.0.0868/26/14ATFP0000084074Microsoft Server 2008R7Single UserNoCNIC N6
A1960C4IRDCCNREURAFSWANSA BahrainLDC UpgradeC4I.RDC.CNREURAFSWA.NSA Bahrain.LDC Upgrade13586.71Miscorsoft SQL ServerTim SmithMM/DD/YYYYNTRMicrosoftDeployed2662nd22772008 R28/26/14ATFP0000084074Microsoft Server 2008R8Server9/30/15NoCNIC N6
HARDWARE ASSOCIATED TO SMALLER HARDWARE i.e., CIRCUIT CARDS/HARD DRIVES
NC1783PSACACP-AVGCNRSWNAVBASE CoronadoSSTC Post 13PSAC.ACP-AVG.CNRSW.NAVBASE Coronado.SSTC Post 1311258.45Assembly, Gate ControlHardwareBiometrics & Access ControlModuleTim SmithMM/DD/YYYYATFP0000147671147671AQ-GCA-001RX/TX: 123.4567 MHz123451.2.4Alutiiq LLCPrimary AssemblyDeployedAccess control island mounted in drop arm operator
A2076PSACACP-AVGCNRSWNAVBASE CoronadoSSTC Post 13 Tech RefreshPSAC.ACP-AVG.CNRSW.NAVBASE Coronado.SSTC Post 13 Tech Refresh1166.47I/O Module, 16 Channel, Din MountHardwareBiometrics & Access ControlRelayTim SmithMM/DD/YYYYNTRIAA7418787ADAM-6052-BEAdvantechIntegrated Electronic DeviceDeployedVer. 1.00ATFP0000147671GreenHills RTOS
A2076PSACACP-AVGCNRSWNAVBASE CoronadoSSTC Post 13 Tech RefreshPSAC.ACP-AVG.CNRSW.NAVBASE Coronado.SSTC Post 13 Tech Refresh6124Relay, 24VDC, Din MountHardwareBiometrics & Access ControlCard ReaderTim SmithMM/DD/YYYYNTR857-724WagoIntegrated Electronic DeviceDeployedATFP0000147671GreenHills RTOS
A2076PSACACP-AVGCNRSWNAVBASE CoronadoSSTC Post 13 Tech RefreshPSAC.ACP-AVG.CNRSW.NAVBASE Coronado.SSTC Post 13 Tech Refresh12385Detector, Loop, Dual ChannelHardwareBiometrics & Access ControlDetectorTim SmithMM/DD/YYYYNTRVEK M2H2.6.4.02FEIGIntegrated Electronic DeviceDeployedATFP0000147671GreenHills RTOS
A2076PSACACP-AVGCNRSWNAVBASE CoronadoSSTC Post 13 Tech RefreshPSAC.ACP-AVG.CNRSW.NAVBASE Coronado.SSTC Post 13 Tech Refresh1158.76Power Supply, 24VDC, Panel MountHardwarePower DistributionPower SupplyTim SmithMM/DD/YYYYNTRHB28309018LVP-60-24MeanwellIntegrated Electronic DeviceDeployedATFP0000147671GreenHills RTOS
ADD ASSET EXAMPLE
A1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City1855.34Network SwitchHardwareAV EquipmentSwitchTim SmithMM/DD/YYYYATFP0000166660CT0213029220EX2200-48P-4GEX2200-48P-4GRX/TX: 123.4567 MHz12345JUNIPERDeployed1Gate 2 Burns City12.345467123.45678
A1004PSACECPCNRMWNSA CraneGate 3 BedfordPSAC.ECP.CNRMW.NSA Crane.Gate 3 Bedford1236LPR Camera EncoderHardwareAV EquipmentEncoderTim SmithMM/DD/YYYYATFP00001666832122150079Raven-M-720MHZRaven-M-720MHZVigilant SolutionsDeployed1Gate 3 Burns City
DISPOSE ASSET EXAMPLE
R1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City1154.78Monitor, GateHardwareMonitorLCDTim SmithMM/DD/YYYYATFP0000033367JLU00006VZ19RTVWV-LC1900PANASONICDisposed1Gate 2 Burns City
R1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City14254.69Network SwitchHardwarePeripheralSwitchTim SmithMM/DD/YYYYDNI15390368SF300-24PRX/TX: 123.4567 MHz12345CiscoDisposed1Gate 2 Burns City
ADD/DISPOSE EXAMPLE See Description/Addtl Info Col (T)
A1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City1578.37LPR CameraHardwareAV EquipmentCameraTim SmithMM/DD/YYYYATFP0000166679BS13080002F.01U.808.125REG-XBOSCHReplaced ATFP0000034478Deployed1Gate 2 Burns City12.345467123.45678
R1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City1699.99Camera, License PlateHardwareAV EquipmentCameraTim SmithMM/DD/YYYYATFP00000344784528HY-ALPRHY-LPR-190-850-5/50-WCRX/TX: 123.4567 MHz12345INEX ZAMIRReplaced with ATFP0000166679Disposed1Gate 2 Burns City
REPAIR/REPLACE EXAMPLE See Description/Addtl Info Col (T)
ANFAC000000240601169C4IMNSCNRSWNAVBASE CoronadoGVC4I.MNS.CNRSW.NAVBASE Coronado.GV112687.34Cooper Integrated Base StationHardwareAV EquipmentBase StationTim SmithMM/DD/YYYYATFP0000102480537IBS 30004-DRRX/TX: 123.4567 MHz12345Cooper NotificationReplaced ATFP0000011410Deployed678EOC
RNFAC000000240601169C4IMNSCNRSWNAVBASE CoronadoGVC4I.MNS.CNRSW.NAVBASE Coronado.GV15689.84Cooper Base StationHardwareAV EquipmentBase StationTim SmithMM/DD/YYYYATFP0000011410412IBS 30004-DRMadahComReplaced with ATFP0000102480Disposed678 SFTC
EDIT EXAMPLE
M1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City1755.24Sign, Digital DisplayHardwareAV EquipmentSignTim SmithMM/DD/YYYYATFP0000033451AF-6300-32x144-8-R-SFRX/TX: 123.4567 MHz12345DAKTRONICSDeployed1Gate 2 Burns City
M1003PSACECPCNRMWNSA CraneGate 2 Burns CityPSAC.ECP.CNRMW.NSA Crane.Gate 2 Burns City11350.81Gate ArmHardwareBiometrics & Access ControlGate ArmTim SmithMM/DD/YYYYATFP00000344474311N3740MATDCBBMAT-DC-BB33.06.121LIFT MASTERDeployed36511178Gate 2 Burns City12.345467123.45678
NOT SUSTAINED BY ATFP/ASHORE
NS2256PSACEnclaveCNRHJB Pearl Harbor - HickamGeneralPSAC.Enclave.CNRH.JB Pearl Harbor - Hickam.General11256.98DictaphoneHardwareTape LibraryTape DriveTim SmithMM/DD/YYYYATFP0000088172DictaphoneNot SustainedWest Lock Security Bldg12.345467123.45678

Asset Data Field Sheet ATFP Tag Number Short Description Location Information (Bldg, Room, Gate 1, etc) Serial Number Part Number SoftwareVersion ServerMachineName Operating System LicenseExpirationDate Type of License Software Assurance

&12SITE: &12BLDG: &12ROOM:

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .