TACCOM_II_SELF_SCORING_WORKSHEET.xlsx

XLSX spreadsheet 103 KB Posted Apr 21, 2017

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

About this file

Written by GovTribe AI · Dec 29, 2023

This document contains a self-scoring worksheet and instructions for vendors bidding on the TACCOM II contract opportunity with the Department of Homeland Security Customs and Border Protection. The self-scoring worksheet includes sections for vendors in Technical Categories 1 and 2 to provide details on up to three past performance projects and answer questions to calculate a score. Technical Category 1 involves equipment such as radios, accessories, and high frequency equipment while Category 2 covers operations and maintenance, radio programming, and site services. Vendors must select a sub-category and complete the worksheet providing project details to validate their self-scoring, which will be compared to agency references. Scoring is calculated based on criteria such as contract value, locations supported, past performance ratings, and number of relevant technical sub-categories delivered. The related federal contract opportunity notice indicates the TacCom II re-compete requirement and directs vendors to the attached special notice and self-scoring instructions when considering submitting an offer.

From the source

TACCOM II SELF SCORING WORKSHEET

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	Mar 15, 2018
WD_No._2015-5637_SCA_WD_for_San_Francisco_Revision_8_011618.pdf	PDF	Mar 15, 2018
CO-COR_Certification_Form_-_Federal.docx	DOCX document	Mar 15, 2018
TACCOM_II_RFP_A0010_Final.docx	DOCX document	Mar 15, 2018
TACCOM_II_TC2_Proposal_Workbook_A0010.Final.xlsx	XLSX spreadsheet	Mar 15, 2018
TACCOM_II_TC1_PROPOSAL_WORKBOOK_A0010.Final.xlsx	XLSX spreadsheet	Mar 15, 2018
INDIVIDUAL_SMALL_BUSINESS_SUBCONTRACTING_PLAN_TEMPLATE.docx	DOCX document	Mar 15, 2018
TACCOM_II_SERVICES_PRICING_TEMPLATE.xlsx	XLSX spreadsheet	Mar 15, 2018
CO-COR_Certification_Form_-_State_or_Local.docx	DOCX document	Feb 28, 2018
TACCOM_II_FBO_COVER_LETTER_A0009.docx	DOCX document	Feb 28, 2018
TACCOM_II_TC2_PROPOSAL_WORKBOOK.xlsx	XLSX spreadsheet	Feb 28, 2018
WD_No._2015-5637_SCA_WD_for_San_Francisco_Revision_8_011618.pdf	PDF	Feb 28, 2018
TACCOM_II_SELF_SCORING_WORKSHEET.xlsx	XLSX spreadsheet	Dec 29, 2017
TACCOM_II_RFP_A0008.docx	DOCX document	Dec 29, 2017
TACCOM_II_SF30_A0006.pdf	PDF	Dec 15, 2017
TACCOM_II_RFP_A0006.docx	DOCX document	Dec 15, 2017
TACCOM_II_SUBCATEGORY_EQUIPMENT_PRICING_TEMPLATE.xlsx	XLSX spreadsheet	Dec 5, 2017
RFP_TACCOM_II_QUESTIONS_ANSWERS_A0005.xlsx	XLSX spreadsheet	Dec 5, 2017
TACCOM_II_SF30_A0004.pdf	PDF	Dec 1, 2017
RFP_TACCOM_II_QUESTIONS_ANSWERS_A0003.xlsx	XLSX spreadsheet	Nov 21, 2017
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx	DOCX document	Nov 21, 2017
TACCOM_II_LABOR_CATEGORIES.xlsx	XLSX spreadsheet	Nov 21, 2017
TACCOM_II_SF30_A0003.pdf	PDF	Nov 21, 2017
TACCOM_II_SELF_SCORING_WORKSHEET.xlsx	XLSX spreadsheet	Nov 21, 2017
TACCOM_II_COVER_LETTER_A0003.docx	DOCX document	Nov 21, 2017
TACCOM_II_RFP_A0003.docx	DOCX document	Nov 21, 2017
TACCOM_II_SF30_A0001.pdf	PDF	Nov 21, 2017
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx	DOCX document	Nov 21, 2017
TACCOM_II_SF30_A0002.pdf	PDF	Nov 21, 2017
TACCOM_II_LCAT_MAP_TEMPLATE.xlsx	XLSX spreadsheet	Nov 21, 2017
TACCOM_II_SUBCATEGORY_EQUIPMENT_PRICING_TEMPLATE.xlsx	XLSX spreadsheet	Nov 21, 2017
TACCOM_II_RFP_A0002.pdf	PDF	Sep 14, 2017
TACCOM_II_LCAT_MAP_TEMPLATE_v2.xlsx	XLSX spreadsheet	Sep 7, 2017
TACCOM_II_RFP_A0001.pdf	PDF	Sep 7, 2017
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx	DOCX document	Sep 6, 2017
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx	DOCX document	Sep 5, 2017
TACCOM_II_RFP.pdf	PDF	Sep 5, 2017
TACCOM_II_LCAT_MAP_TEMPLATE.xlsx	XLSX spreadsheet	Sep 5, 2017
TACCOM_II_LABOR_CATEGORIES.xlsx	XLSX spreadsheet	Sep 5, 2017
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.DOCX	DOCX document	Jul 8, 2017
TACCOM_II_DISCOUNT_AND_SERVICES_PRICING.XLSX	XLSX spreadsheet	Jul 8, 2017
TACCOM_II_LABOR_CATEGORIES.XLSX	XLSX spreadsheet	Jul 8, 2017
SECOND_DRAFT_RFP_TACCOM_II_QUESTIONS_COMMENTS_TEMPLATE_.xlsx	XLSX spreadsheet	Jul 8, 2017
TACCOM_II_Survey.docx	DOCX document	Jun 5, 2017
TACCOM_II_REGISTRATION_LIST_-_FBO_NOTICE.xls	XLS spreadsheet	May 5, 2017
TACCOM_II_PRE-SOLICITATION_CONFERENCE_FBO_NOTICE.docx	DOCX document	Apr 27, 2017
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx	DOCX document	Apr 21, 2017
TACCOM_II_QUESTIONS_COMMENTS_TEMPLATE.xlsx	XLSX spreadsheet	Apr 21, 2017
TACCOM_II_SECTION_B.docx	DOCX document	Apr 21, 2017
TACCOM_II_REQUIREMENTS.xlsx	XLSX spreadsheet	Apr 21, 2017

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

Try for free Login

Text version

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

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

Step 1:

Vendors should select the category they wish to be scored on from the drop down in B2.

Step 2:

Step 2-1: Follow steps 2-1 through step 4 as noted in the Technical Category 1 -Equipment instructions.

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

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 #1			Project #2			Project #3
	Project/Award Title:			Project/Award Title:			Project/Award Title:
	Award ID (Award Number)			Award ID (Award Number)			Award ID (Award Number)
Scoring Criteria	Answer (select from drop-down)	Points	Maximum Points	Answer (select from drop-down)	Points	Maximum Points	Answer (select from drop-down)	Points	Maximum Points
1. All fields of Relevant Experience Form completed and are answered as "Yes"	Yes-Qualified	5.00	5	No-Disqualified	0.00	5	Yes-Qualified	5.00	5
2. Obligated amount	$5M-$10M	3.00	5	$5M-$10M	3.00	5	$500k - $999k	0.00	5
3. Place(s) of Performance (Delivery/Service Locations)	Nationally provided service/delivery	5.00	5	Locally provided service/delivery	1.00	5	Regionally provided service/delivery	3.00	5
4. Past performance (CPARS) rating (average)		5.60	10		3.60	10		3.60	10
Quality of Service	Very Good	4.00		Unsatisfactory	0.00		Unsatisfactory	0.00
Schedule	Marginal	1.00		Marginal	1.00		Marginal	1.00
Cost Control	Marginal	1.00		Very Good	4.00		Satisfactory	3.00
Management	Very Good	4.00		Marginal	1.00		Very Good	4.00
Regulatory	Very Good	4.00		Satisfactory	3.00		Marginal	1.00
5. Relevant technical sub-category areas of delivery		1.00	10		1.00	10		1.00	10
Encryption Key Loaders/and Accessories	Yes	1.00	1	Yes	1.00	1	Yes	1.00	1
Mobile Radios			1			1			1
Portable Radios			1			1			1
UHF-AM			1			1			1
UHF-AM/MAD			1			1			1
VHF-AM			1			1			1
VHF – Digital			1			1			1
Technical Service Manuals			1			1			1
UHF-AM / MAD			1			1			1
VHF-Digital Selective Requirements			1			1			1
Interoperability			1			1			1
6. Number of relevant technical sub-category areas of delivery supported in #5	4+	5.00	5	3	3.00	5	2	1.00	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/IDIQ	2.00	2	Yes-against MA/IDIQ	2.00	2	Yes-against MA/IDIQ	2.00	2
	Sub-Total	26.60	42	Sub-Total	13.60	42	Sub-Total	15.60	42
Section 2: Technical Category Scoring
Scoring Criteria	Answer (select from drop-down)	Points	Maximum 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.)?	3	3	5
	Sub-Total	3	5
Total Scoring for Technical Category		Points	Maximum Points
	Total	58.80	131

TC2- Services

TC2 Level 1 Services
Select Sub-Category:	Radio
Note: Data inputted below must match the Relevant Experience Form and all supporting documentation.
Section 1: Project Specific Scoring
	Project #1			Project #2			Project #3
	Project/Award Title:			Project/Award Title:			Project/Award Title:
	Award ID (Award Number)			Award ID (Award Number)			Award ID (Award Number)
Scoring Criteria	Answer (select from drop-down)	Points	Maximum Points	Answer (select from drop-down)	Points	Maximum Points	Answer (select from drop-down)	Points	Maximum Points
1. All fields of Relevant Experience Form completed and are answered as "Yes"	No-Disqualified	0.00	5	No-Disqualified	0.00	5	Yes-Qualified	5.00	5
2. Obligated amount	>$10M	5.00	5	$5M-$10M	3.00	5	$500k - $999k	0.00	5
3. Place(s) of Performance (Delivery/Service Locations)	Regionally provided service/delivery	3.00	5	Regionally provided service/delivery	3.00	5	Locally provided service/delivery	1.00	5
4. Past performance (CPARS) rating (average)		5.20	10		5.20	10		5.20	10
Quality of Service	Very Good	4.00		Unsatisfactory	0.00		Unsatisfactory	0.00
Schedule	Satisfactory	3.00		Marginal	1.00		Marginal	1.00
Cost Control	Exceptional	5.00		Satisfactory	3.00		Very Good	4.00
Management	Marginal	1.00		Very Good	4.00		Very Good	4.00
Regulatory	Unsatisfactory	0.00		Exceptional	5.00		Very Good	4.00
5. Relevant technical sub-category areas of delivery		1.00	4		1.00	4		1.00	4
Subscriber Programming / Blitz Support	Yes	1.00	1	Yes	1.00	1	Yes	1.00	1
Subscriber Repair			1			1			1
Subscriber Installation			1			1			1
Tactical Communications Fleet / Rapid Deployment Equipment Support			1			1			1
Do Not Complete			0			0			0
Do Not Complete			0			0			0
Do Not Complete			0			0			0
Do Not Complete			0			0			0
Do Not Complete			0			0			0
Do Not Complete			0			0			0
Do Not Complete			0			0			0
6. Number of technical sub-category areas of delivery supported in #5	4+	5.00	5	3	3.00	5	2	1.00	5
7. Is the project a task order issued against a MA/IDIQ in accordance with FAR 16.505 (b)(1) Fair Opportunity?	Yes-against MA/IDIQ	2.00	2	No	0.00	2	Yes-against MA/IDIQ	2.00	2
	Sub-Total	21.20	36	Sub-Total	15.20	36	Sub-Total	15.20	36
Section 2: Technical Category Scoring
Scoring Criteria	Answer (select from drop-down)	Points	Maximum 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.)?	3	3	5
	Sub-Total	3	5
Total Scoring for Technical Category		Points	Maximum Points
	Total	54.60	113

Scoring Methodology

Question	Response	Score
1. All fields of Relevant Experience Form completed and are answered as "Yes"	Yes-Qualified	5
1. All fields of Relevant Experience Form completed and are answered as "Yes"	No-Disqualified	0
2. Obligated amount	$500k - $999k	0
2. Obligated amount	$1M-$4.999M	1
2. Obligated amount	$5M-$10M	3
2. Obligated amount	>$10M	5
3. Place(s) of Performance (Delivery/Service Locations)	Locally provided service/delivery	1
3. Place(s) of Performance (Delivery/Service Locations)	Regionally provided service/delivery	3
3. Place(s) of Performance (Delivery/Service Locations)	Nationally provided service/delivery	5
4. Past performance (CPARS) rating	N/A	ERROR:#N/A
4. Past performance (CPARS) rating	Unsatisfactory	0
4. Past performance (CPARS) rating	Marginal	1
4. Past performance (CPARS) rating	Satisfactory	3
4. Past performance (CPARS) rating	Very Good	4
4. Past performance (CPARS) rating	Exceptional	5
5. Relevant technical sub-category areas of delivery	Yes	1
5. Relevant technical sub-category areas of delivery	No	0
6. Number of technical sub-category areas of delivery	0-1	0
6. Number of technical sub-category areas of delivery	2	1
6. Number of technical sub-category areas of delivery	3	3
6. Number of technical sub-category areas of delivery	4+	5
1. Number of Components within Government Agencies supported (e.g., DHS ICE, DHS CBP, DOJ FBI, etc.)	1	0
1. Number of Components within Government Agencies supported (e.g., DHS ICE, DHS CBP, DOJ FBI, etc.)	2	1
1. Number of Components within Government Agencies supported (e.g., DHS ICE, DHS CBP, DOJ FBI, etc.)	3	3
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/IDIQ	2
7. Is the project a delivery order issued against a MA/IDIQ in accordance with FAR 16.505 (b)(1) Fair Opportunity?	No	0

vlookup

Technical Category

Category Level I

Category Level II

Column1

Column2

Column3

Column4

Column5

Column6

Column7

Column8

Column9

Column10

Equipment

Infrastructure

Communications Infrastructure

Software

Control Stations / Desk Set Control Points

Encryption Key Loaders / and Accessories

Transportable Repeater Non-Commercial Power

Transportable Repeater, Commercial Power

Do Not Complete

Equipment

Radios and accessories

Encryption Key Loaders/and Accessories

Mobile Radios

Portable Radios

UHF-AM

UHF-AM/MAD

VHF-AM

VHF – Digital

Technical Service Manuals

UHF-AM / MAD

VHF-Digital Selective Requirements

Interoperability

Equipment

High Frequency

High Frequency (HF) Radio

HF Radio

Low Band Mobile Radio

Low Band Portable Radio

USCG – specific

Do Not Complete

Equipment

Maritime

Boat Crew Communications System (BCCS)

Do Not Complete

Equipment

Satellite

Military Satellite Communications

Satellite

Do Not Complete

Equipment

Test Equipment

Do Not Complete

Services

O&M Services

O&M Purchasing Support

O&M Repair and Maintenance Services

Preventive Maintenance

Command & Control / Dispatch Center Maintenance

Do Not Complete

Services

Radio

Subscriber Programming / Blitz Support

Subscriber Repair

Subscriber Installation

Tactical Communications Fleet / Rapid Deployment Equipment Support

Do Not Complete

Services

RF Network Management

Spectrum Support

Do Not Complete

Services

Site

Site Surveys

Environmental Analysis

Structural Analysis and Remediation

Site Lease Acquisition

Site Construction and System Implementation

Tower Site / Infrastructure Maintenance Support

Telco Circuit / Pots Lines Support

Tower Lease Support

Tower Operations and Maintenance Support

Do Not Complete

Services

Systems

Interoperable Systems / Interoperability Support

Circuit Acquisition

System Staging

Integration

Re System Design

ROIP System Design

Do Not Complete

Services

Project Management

Project Closeout Activities

Project Management

General Requirements

End User Training

Logistics /Warehouse Support

Command & Control / Dispatch Support

User Requirements Gathering

System Monitoring

Labor and Services

Logistics/ Warehouse/ Transportation Support

Do Not Complete

Equipment

General

Training

Do Not Complete

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

File details come from the government source that posted it. Updated Nov 14, 2017.