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

XLSX spreadsheet 488 KB Posted

Attached to
Amendment 0003 for 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 an asset data template and details regarding a federal contract opportunity for the global sustainment of Anti-Terrorism Force Protection systems and assets worldwide. The asset data template provides fields to track hardware and software assets, including action taken, asset information, location data, and software details.

The federal contract opportunity is a pre-solicitation for amendment 0003 related to the global sustainment of 955 ATFP systems and over 81,000 assets. The planned acquisition strategy is a single-award IDIQ contract with a base ordering period of five years, an optional three-year ordering period, and a potential six-month extension. The maximum contract value is $600 million over eight years. The bulk of work will be through a large task order with base and option years for sustainment of existing systems and assets. Separate task orders may be issued for technology refreshment, system upgrades, repairs from damage or natural disasters, and engineering changes. Interested parties are advised the acquisition strategy requires approval and the RFP is still in development. Feedback is requested by March 31, 2020 to improve the draft RFP. An industry day may be held or written responses provided depending on the COVID-19 situation.

View the file

Other files

File Type Posted
N3943020R22450003.pdf PDF
N3943020R22450002.pdf PDF
Attachment 2 Pricing Schedule 20200921.xlsx XLSX spreadsheet
Attachment 2 Pricing Schedule 20200916.xlsx XLSX spreadsheet
Attachment 6 - Safety Factor 20200909.doc DOC document
Attachment 2 - Pricing 20200909.xlsx XLSX spreadsheet
Remedy Incident Guide.pdf PDF
Attachment 9 - Sustainment Task Order PWS 20200909.docx DOCX document
AIM User Guide.pdf PDF
Remedy CDRL Submission Guide.pdf PDF
LENEL Dongles list June 2020.xlsx XLSX spreadsheet
Attachment 5 - Subcontracting Plan Template 20200910.doc DOC document
N3943020R22450001.pdf PDF
N3943020R2245.pdf PDF
Appendix A - Acronym List.pdf PDF
Attachment 9 Sustainment Task Order PWS 20200730.docx DOCX document
Draft RFP RFIs 20200820.pdf PDF
Attachment 7 - Wage Determinations 20200819.pdf PDF
Appendix B Contractor User Guide for Remedy AIM 20200709 Final.docx DOCX document
Attachment 4 - SB Participation and Commitment Strategy 20200812.docx DOCX document
Attachment 2 - ELIN Price Schedule 20200812.xlsx XLSX spreadsheet
PreProposal Conference Materials.pdf PDF
PreProposal Conf Invitiations.pdf PDF
Pre-Proposal Conference RFIs.pdf PDF
N3943020R2245 Draft 7 Aug 2020.pdf PDF
Attachment 2 20200612.xlsx XLSX spreadsheet
APP-M Subcomponent Detail for Systems to be Sustained - 20200713 Final.xlsx XLSX spreadsheet
Appendix B Contractor User Guide for Remedy AIM 20200709 Final.pdf PDF
N3943020R2245 Draft 17Jul2020.pdf PDF
Appendix D3 Tech Refresh 20200714 Final.pdf PDF
APP-C List of Systems to be Sustained - 20200709 Final.xlsx XLSX spreadsheet
Appendix D1 Sustainment 20200714.pdf PDF
Attachment 9 Sustainment Task Order PWS 20200715 Final.docx DOCX document
Appendix D2 New Install 20200714 Final.pdf PDF
20200429 RFP Questions.pdf PDF
N3943020R2245 Draft Rev2.pdf PDF
N3943020R2245 Draft Rev1.pdf PDF
Appendix K - GSC DD254 Draft 20191206.pdf PDF
Appendix G CDRL Review Process BMT Approved 12Jan16.pdf PDF
Attachment 4 - SB Participation and Commitment Strategy.docx DOCX document
Attachment 5 - Subcontracting Plan Template.doc DOC document
Appendix N - Historical 3-yr Asset Failure Data - 20191204.xlsx XLSX spreadsheet
Appendix Q - Historical FRU Costs.xlsx XLSX spreadsheet
Attachment 2 - ELIN Price Schedule - 20200306.xlsx XLSX spreadsheet
Attachment 9 - Sustainment Task Order PWS.docx DOCX document
Attachment 6 - Safety Factor.doc DOC document
Appendix M - Subcomponent Detail for Systems to be Sustained - 20191203.xlsx XLSX spreadsheet
Attachment 1 - PPQ.docx DOCX document
Attachment 8 - RFI Form.doc DOC document
Appendix D3 Tech Refresh and Upgrade 20200224.pdf PDF
Show 40 more

Latest 50 of 65 listed here. See the rest on GovTribe.

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 .