TacCom_II_Scoring_Spreadsheet_v6.xlsx

XLSX spreadsheet 114 KB Posted

Attached to
TACCOM II Federal contract opportunity
Solicitation number
2017036109
Issued by
Department of Homeland Security Customs and Border Protection

About this file

This document contains a self-scoring spreadsheet and instructions for the Tactical Communications II (TacCom II) federal contract opportunity. The spreadsheet provides a framework for vendors to self-score their proposals according to relevant experience on past projects. It includes sections for vendors to provide details on three past performance projects for technical categories including equipment, operations and maintenance services, or general services. Vendors select sub-categories and answer questions to calculate scores in areas such as contract value, place of performance, past performance ratings, and technical scope. Additional points are awarded based on the number of federal agencies and components supported. The instructions provide detailed steps for vendors to complete the scoring under each technical category. The related federal contract opportunity notice indicates the re-compete requirement is for the Tactical Communications II indefinite-delivery/indefinite-quantity contract issued by the Department of Homeland Security Customs and Border Protection.

Scoring Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to TACCOM II, newest first.
File Type Posted
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx DOCX document
WD_No._2015-5637_SCA_WD_for_San_Francisco_Revision_8_011618.pdf PDF
CO-COR_Certification_Form_-_Federal.docx DOCX document
TACCOM_II_RFP_A0010_Final.docx DOCX document
TACCOM_II_TC2_Proposal_Workbook_A0010.Final.xlsx XLSX spreadsheet
TACCOM_II_TC1_PROPOSAL_WORKBOOK_A0010.Final.xlsx XLSX spreadsheet
INDIVIDUAL_SMALL_BUSINESS_SUBCONTRACTING_PLAN_TEMPLATE.docx DOCX document
TACCOM_II_SERVICES_PRICING_TEMPLATE.xlsx XLSX spreadsheet
CO-COR_Certification_Form_-_State_or_Local.docx DOCX document
TACCOM_II_FBO_COVER_LETTER_A0009.docx DOCX document
TACCOM_II_TC2_PROPOSAL_WORKBOOK.xlsx XLSX spreadsheet
WD_No._2015-5637_SCA_WD_for_San_Francisco_Revision_8_011618.pdf PDF
TACCOM_II_SELF_SCORING_WORKSHEET.xlsx XLSX spreadsheet
TACCOM_II_RFP_A0008.docx DOCX document
TACCOM_II_RFP_A0007.docx DOCX document
TACCOM_II_SF30_A0006.pdf PDF
TACCOM_II_RFP_A0006.docx DOCX document
TACCOM_II_SUBCATEGORY_EQUIPMENT_PRICING_TEMPLATE.xlsx XLSX spreadsheet
RFP_TACCOM_II_QUESTIONS_ANSWERS_A0005.xlsx XLSX spreadsheet
TACCOM_II_SF30_A0004.pdf PDF
RFP_TACCOM_II_QUESTIONS_ANSWERS_A0003.xlsx XLSX spreadsheet
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx DOCX document
TACCOM_II_LABOR_CATEGORIES.xlsx XLSX spreadsheet
TACCOM_II_SF30_A0003.pdf PDF
TACCOM_II_SELF_SCORING_WORKSHEET.xlsx XLSX spreadsheet
TACCOM_II_COVER_LETTER_A0003.docx DOCX document
TACCOM_II_RFP_A0003.docx DOCX document
TACCOM_II_SF30_A0001.pdf PDF
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx DOCX document
TACCOM_II_SF30_A0002.pdf PDF
TACCOM_II_RFP_A0002.pdf PDF
TACCOM_II_LCAT_MAP_TEMPLATE_v2.xlsx XLSX spreadsheet
TACCOM_II_RFP_A0001.pdf PDF
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx DOCX document
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx DOCX document
TACCOM_II_RFP.pdf PDF
TACCOM_II_LCAT_MAP_TEMPLATE.xlsx XLSX spreadsheet
TACCOM_II_LABOR_CATEGORIES.xlsx XLSX spreadsheet
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.DOCX DOCX document
TACCOM_II_DISCOUNT_AND_SERVICES_PRICING.XLSX XLSX spreadsheet
TACCOM_II_LABOR_CATEGORIES.XLSX XLSX spreadsheet
SECOND_DRAFT_RFP_TACCOM_II_QUESTIONS_COMMENTS_TEMPLATE_.xlsx XLSX spreadsheet
TACCOM_II_Survey.docx DOCX document
TACCOM_II_REGISTRATION_LIST_-_FBO_NOTICE.xls XLS spreadsheet
TACCOM_II_PRE-SOLICITATION_CONFERENCE_FBO_NOTICE.docx DOCX document
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx DOCX document
TACCOM_II_QUESTIONS_COMMENTS_TEMPLATE.xlsx XLSX spreadsheet
TACCOM_II_SECTION_B.docx DOCX document
TACCOM_II_SELF_SCORING_WORKSHEET.xlsx XLSX spreadsheet
TACCOM_II_REQUIREMENTS.xlsx XLSX spreadsheet
Show all 50

TACCOM II has more files on GovTribe.

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

Text version

Instructions

Please reference the RFP and self scoring instructions below for completing the self scoring process. Self scoring will be compared to the references provided for validity.
Procedures
Technical Category 1 Equipment
For vendors wishing to bid on Technical Category 1 - Equipment, please complete the following steps
Step 1:
Vendors should select the category they wish to be scored on from the drop down in B2.
Step 2:
Complete Section 1: Project Specific Scoring. For this section, vendors will need to answer questions based on their three approved projects used for past performance. Please note that for any projects referenced, information will be required to validate the self scoring completed by the vendors.
Step 2-1: For Project #1, provide the Project/Award Title and Award ID (Award Number).
Step 2-2: For Project #1, review and answer the questions #1-7 as they pertain the project. In the Answer section, you should select the appropriate response from the drop down. The Points column will auto calculate based on the response. The Maximum Points column indicates the maximum points available for that question.
Please note the following details:
For question, 3. Place(s) of Performance (Delivery/Service Locations). Select the answer of "Locally provided service/delivery" if the service or delivery area in the project is confined to no more than two states. The D.C. metro area (Virginia, Washington D.C., and Maryland) will be considered local. Select the answer of "Regionally provided service/delivery" if the support extends to three or more states. Select the answer of "Nationally provided service/delivery" if the support is throughout the contiguous United States.
For question, 4. Past performance (CPARS) rating (average). Select a response of N/A if the category was not scored on your past performance review or survey
For question, 5. Relevant technical sub-category areas of delivery. The sub-categories will populate based on the category selected from the drop-down in B2. If a row indicates "Do Not Complete", then vendors are not to select yes or no and to leave the drop down blank.
For question, 6. Number of technical sub-category areas of delivery supported in #5. Depending on the number of "yes" selections in question 5, select the appropriate answer.
Step 2-3: For Project #2, provide the Project/Award Title and Award Number.
Step 2-4: For Project #2, review and answer the questions #1-7 as they pertain the project. In the Answer section, you should select the appropriate response from the drop down. The Points column will auto calculate based on the response. The Maximum Points column indicates the maximum points available for that question. Refer to Step 2-2 for additional details on how to answer the questions.
Step 2-5: For Project #3, provide the Project/Award Title and Award Number.
Step 2-6: For Project #3, review and answer the questions #1-7 as they pertain the project. In the Answer section, you should select the appropriate response from the drop down. The Points column will auto calculate based on the response. The Maximum Points column indicates the maximum points available for that question. Refer to Step 2-2 for additional details on how to answer the questions.
Step 3:
Complete Section 2: Technical Category Scoring. For this section, vendors will answer the question based on all projects listed above.
Step 3-1: Across all three projects listed in Section 1, indicate the number of unique Agencies/Components within Government Departments that have been supported. For example, if Project #1 supported DHS, Customs and Border Protection, Project #2 supported DHS, Immigration and Customs Service, and Project #3 supported DOJ Marshalls, then the vendor should select 3 from the dropdown.
Step 4:
Verify responses and total score.
Procedures
Technical Category 2 Services
For vendors wishing to bid on Technical Category 2 - Services please complete the following steps. Note that vendors wishing to bid as a generalist under TC-2 should proceed to the next set of steps.
Step 1:
Vendors should select the category they wish to be scored on from the drop down in B2.
Step 2:
Complete Section 1: Project Specific Scoring. For this section, vendors will need to answer questions based on their three approved projects used for past performance. Please note that for any projects referenced, information will be required to validate the self scoring completed by the vendors.
Step 2-1: Follow steps 2-1 through step 4 as noted in the Technical Category 1 -Equipment instructions.
Procedures
Technical Category 2 - General
For vendors wishing only to bid as a TC2 generalist please complete the following steps. Filling out this tab will negate any responses on the TC2- Services tab.
Step 1: Follow steps 2-1 through step 4 as noted in the Technical Category 1 -Equipment instructions.
Note, question 6 (6. Number of technical sub-category areas of delivery supported in #5) in TC-1 Equipment and TC-2 Services was removed from TC-2 Generalist questions.

&"-,Bold"&20&K000000Self Scoring Instructions

&P of &N

TC1-Equipment

TC1 Level 1 Equipment
Select Sub-Category:Radios and Accessories
Note: Data inputted below must match the Relevant Experience Form and all supporting documentation.
Section 1: Project Specific Scoring
Project #1Project #2Project #3
Project/Award Title:Project/Award Title:Project/Award Title:
Award ID (Award Number)Award ID (Award Number)Award ID (Award Number)
Scoring CriteriaAnswer (select from drop-down)PointsMaximum PointsAnswer (select from drop-down)PointsMaximum PointsAnswer (select from drop-down)PointsMaximum Points
1. All fields of Relevant Experience Form completed and are answered as "Yes"555
2. Obligated amount555
3. Place(s) of Performance (Delivery/Service Locations)555
4. Past performance (CPARS) rating (average)0.00100.00100.0010
Quality of Service
Schedule
Cost Control
Management
Regulatory
5. Relevant technical sub-category areas of delivery012012012
Encryption Key Loaders / and Accessories111
Mobile Radios111
Portable Radios111
UHF-AM111
UHF-AM/MAD111
VHF-AM111
VHF – Digital111
Technical Service Manuals111
VHF-Digital Selective Requirements111
Interoperability111
General LMR111
General VHF/UHF111
6. Number of relevant technical sub-category areas of delivery supported in #5555
7. Is the project a delivery order issued against a MA/IDIQ in accordance with FAR 16.505 (b)(1) Fair Opportunity?222
Sub-Total044Sub-Total044Sub-Total044
Section 2: Technical Category Scoring
Scoring CriteriaAnswer (select from drop-down)PointsMaximum Points
1. Indicate the number of unique Agencies/Components within Government Departments that the projects above supported (e.g., DHS ICE, DHS CBP, DOJ FBI, DOJ Marshalls, etc.)?05
Sub-Total05
Total Scoring for Technical CategoryPointsMaximum Points
Total0137

TC2- Services

TC2 Level 1 Services
Select Sub-Category:O&M Services
Note: Data inputted below must match the Relevant Experience Form and all supporting documentation.
Section 1: Project Specific Scoring
Project #1Project #2Project #3
Project/Award Title:Project/Award Title:Project/Award Title:
Award ID (Award Number)Award ID (Award Number)Award ID (Award Number)
Scoring CriteriaAnswer (select from drop-down)PointsMaximum PointsAnswer (select from drop-down)PointsMaximum PointsAnswer (select from drop-down)PointsMaximum Points
1. All fields of Relevant Experience Form completed and are answered as "Yes"555
2. Obligated amount555
3. Place(s) of Performance (Delivery/Service Locations)555
4. Past performance (CPARS) rating (average)0.00100.00100.0010
Quality of Service
Schedule
Cost Control
Management
Regulatory
5. Relevant technical sub-category areas of delivery060606
O&M Purchasing Support111
O&M Repair and Maintenance Services111
Preventive Maintenance111
Command & Control / Dispatch Center Maintenance111
Tower Site / Infrastructure Maintenance Support111
Tower Operations and Maintenance Support111
Do Not Complete000
Do Not Complete000
Do Not Complete000
Do Not Complete000
Do Not Complete000
Do Not Complete000
Do Not Complete000
Do Not Complete000
Do Not Complete000
6. Number of technical sub-category areas of delivery supported in #5555
7. Is the project a task order issued against a MA/IDIQ in accordance with FAR 16.505 (b)(1) Fair Opportunity?222
Sub-Total038Sub-Total038Sub-Total038
Section 2: Technical Category Scoring
Scoring CriteriaAnswer (select from drop-down)PointsMaximum Points
1. Indicate the number of unique Agencies/Components within Government Departments that the projects above supported (e.g., DHS ICE, DHS CBP, DOJ FBI, DOJ Marshalls, etc.)?05
Sub-Total05
Total Scoring for Technical CategoryPointsMaximum Points
Total0119

TC2- General

TC2 Level 1 Services - General
If offeror is using this tab “TC2- General” to submit scoring as a Generalist, DO NOT submit scoring under Tab “TC2 – Services"
Note: Data inputted below must match the Relevant Experience Form and all supporting documentation.
Section 1: Project Specific Scoring
Project #1Project #2Project #3
Project/Award Title:Project/Award Title:Project/Award Title:
Award ID (Award Number)Award ID (Award Number)Award ID (Award Number)
Scoring CriteriaAnswer (select from drop-down)PointsMaximum PointsAnswer (select from drop-down)PointsMaximum PointsAnswer (select from drop-down)PointsMaximum Points
1. All fields of Relevant Experience Form completed and are answered as "Yes"555
2. Obligated amount555
3. Place(s) of Performance (Delivery/Service Locations)555
4. Past performance (CPARS) rating (average)5.60100.00100.0010
Quality of ServiceUnsatisfactory0
ScheduleMarginal1
Cost ControlVery Good4
ManagementVery Good4
RegulatoryExceptional5
5. Relevant technical sub-category areas of delivery035035035
Subscriber Programming / Blitz Support111
Subscriber Repair111
Subscriber Installation111
Tactical Communications Fleet / Rapid Deployment Equipment Support111
O&M Purchasing Support111
O&M Repair and Maintenance Services111
Preventive Maintenance111
Command & Control / Dispatch Center Maintenance111
Tower Site / Infrastructure Maintenance Support111
Tower Operations and Maintenance Support111
RF Network Management111
Spectrum Support111
Site Surveys111
Interoperable Systems / Interoperability Support111
Environmental Analysis111
Structural Analysis and Remediation111
Site Lease Acquisition111
Site Construction and System Implementation111
Telco Circuit / Pots Lines Support111
Tower Lease Support111
Circuit Acquisition111
System Staging111
Integration111
Re System Design111
ROIP System Design111
Project Closeout Activities111
Project Management111
General Requirements111
End User Training111
Logistics /Warehouse Support111
Command & Control / Dispatch Support111
User Requirements Gathering111
System Monitoring111
Labor and Services111
Logistics/ Warehouse/ Transportation Support111
6. Is the project a task order issued against a MA/IDIQ in accordance with FAR 16.505 (b)(1) Fair Opportunity?222
Sub-Total662Sub-Total062Sub-Total062
Section 2: Technical Category Scoring
Scoring CriteriaAnswer (select from drop-down)PointsMaximum Points
1. Indicate the number of unique Agencies/Components within Government Departments that the projects above supported (e.g., DHS ICE, DHS CBP, DOJ FBI, DOJ Marshalls, etc.)?05
Sub-Total05
Total Scoring for Technical CategoryPointsMaximum Points
Total6191

Scoring Methodology

QuestionResponseScore
1. All fields of Relevant Experience Form completed and are answered as "Yes"Yes-Qualified5
1. All fields of Relevant Experience Form completed and are answered as "Yes"No-Disqualified0
2. Obligated amount$150k - $499k1
2. Obligated amount$500k - $999k2
2. Obligated amount$1M-$4.999M3
2. Obligated amount$5M-$10M4
2. Obligated amount>$10M5
3. Place(s) of Performance (Delivery/Service Locations)Locally provided service/delivery1
3. Place(s) of Performance (Delivery/Service Locations)Regionally provided service/delivery3
3. Place(s) of Performance (Delivery/Service Locations)Nationally provided service/delivery5
4. Past performance (CPARS) ratingN/AERROR:#N/A
4. Past performance (CPARS) ratingUnsatisfactory0
4. Past performance (CPARS) ratingMarginal1
4. Past performance (CPARS) ratingSatisfactory3
4. Past performance (CPARS) ratingVery Good4
4. Past performance (CPARS) ratingExceptional5
5. Relevant technical sub-category areas of deliveryYes1
5. Relevant technical sub-category areas of deliveryNo0
6. Number of technical sub-category areas of delivery0-10
6. Number of technical sub-category areas of delivery21
6. Number of technical sub-category areas of delivery33
6. Number of technical sub-category areas of delivery4+5
1. Number of Components within Government Agencies supported (e.g., DHS ICE, DHS CBP, DOJ FBI, etc.)10
1. Number of Components within Government Agencies supported (e.g., DHS ICE, DHS CBP, DOJ FBI, etc.)21
1. Number of Components within Government Agencies supported (e.g., DHS ICE, DHS CBP, DOJ FBI, etc.)33
1. Number of Components within Government Agencies supported (e.g., DHS ICE, DHS CBP, DOJ FBI, etc.)4+5
7. Is the project a delivery order issued against a MA/IDIQ in accordance with FAR 16.505 (b)(1) Fair Opportunity?Yes-against MA/IDIQ2
7. Is the project a delivery order issued against a MA/IDIQ in accordance with FAR 16.505 (b)(1) Fair Opportunity?No0

vlookup

Technical CategoryCategory Level ICategory Level IIColumn1Column2Column3Column4Column5Column6Column7Column8Column9Column10Column11Column12Column13Column14
EquipmentInfrastructureCommunications InfrastructureSoftwareControl Stations / Desk Set Control PointsTransportable Repeater Non-Commercial PowerTransportable Repeater, Commercial PowerCivil InfrastructureTone/Digital/IP Remote Control ConsolesAdditional: Microwave WaveDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not Complete
EquipmentRadios and accessoriesEncryption Key Loaders / and AccessoriesMobile RadiosPortable RadiosUHF-AMUHF-AM/MADVHF-AMVHF – DigitalTechnical Service ManualsVHF-Digital Selective RequirementsInteroperabilityGeneral LMRGeneral VHF/UHFDo Not CompleteDo Not CompleteDo Not Complete
EquipmentHigh FrequencyHigh Frequency (HF) RadioGeneral HFDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not Complete
EquipmentMaritimeBoat Crew Communications System (BCCS)Do Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not Complete
EquipmentSatelliteMilitary Satellite CommunicationsSatelliteGeneral UHF MILSATCOMDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not Complete
EquipmentTest EquipmentTest EquipmentDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not Complete
ServicesO&M ServicesO&M Purchasing SupportO&M Repair and Maintenance ServicesPreventive MaintenanceCommand & Control / Dispatch Center MaintenanceTower Site / Infrastructure Maintenance SupportTower Operations and Maintenance SupportDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not Complete
ServicesRadioSubscriber Programming / Blitz SupportSubscriber RepairSubscriber InstallationTactical Communications Fleet / Rapid Deployment Equipment SupportDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not Complete
ServicesEngineeringRF Network ManagementSpectrum SupportSite SurveysInteroperable Systems / Interoperability SupportEnvironmental AnalysisStructural Analysis and RemediationSite Lease AcquisitionSite Construction and System ImplementationTelco Circuit / Pots Lines SupportTower Lease SupportCircuit AcquisitionSystem StagingIntegrationRe System DesignROIP System Design
ServicesProject ManagementProject Closeout ActivitiesProject ManagementGeneral RequirementsEnd User TrainingLogistics /Warehouse SupportCommand & Control / Dispatch SupportUser Requirements GatheringSystem MonitoringLabor and ServicesLogistics/ Warehouse/ Transportation SupportDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not Complete
EquipmentGeneralGeneralTrainingDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not CompleteDo Not Complete

image1.png image2.png image3.png image4.png image5.png image6.png image7.png image8.png

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