Attachment A
Format of Data
All data should be submitted in a .CSV (comma-delimited) format. The sheets in the workbook provide a template for how the tables should be designed.
The required format for the entries in each column/field is indicated in the instructions for each sheet.
All entries in Text fields must be in quotation marks (e.g. "National Aeronautical and Space Administration").
Column entries in bold red indicate that the party should enter only one of the possible entries listed for that column. No other entries should be entered.
Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables.
Attachment
A
Format
of
Data
All
data
should
be
submitted
in
a
.CSV
(comma-delimited)
format.
The
sheets
in
the
workbook
provide
a
template
for
how
the
tables
should
be
designed.
The
required
format
for
the
entries
in
each
column/field
is
indicated
in
the
instructions
for
each
sheet.
All
entries
in
Text
fields
must
be
in
quotation
marks
(e.g.
"National
Aeronautical
and
Space
Administration").
Column
entries
in
bold
red
indicate
that
the
party
should
enter
only
one
of
the
possible
entries
listed
for
that
column.
No
other
entries
should
be
entered.
Data
for
all
of
the
tables
should
be
submitted
on
a
periodic
basis
as
specified
in
the
instructions
in
individual
tables.
"RFP Data" Instructions
Submit all responses to Requests for Proposal (RFPs) made by the United States Government, including by any agency or other entity representing the United States or any of its
States made between 01/2018 and 09/2022. Data should be submitted whether or not the United States Government accepted the Company's bid or submission, or a competing offer.
All data must conform to award specific identifiers available on USASpending.gov, including the "award_id_piid," "awarding_sub_agency_code," "parent_award_id_pild,"
and "parent_award_agency_id' as described below, including for RFPs that the Company responded to, but where the United States Government accepted a competing offer.
The required format for the entries in each column/field is indicated in the instructions for each sheet. Column entries in bold red indicate that the Company should enter only one
of the possible entries listed for that column. Variables "A" through "H", "J", "M" and "N" should conform with the corresponding variables in USASpending.gov.
Column "A" identifies a unique customer observation. Column "K" indicates the date that designates whether data must be submitted (i.e., submit if "response_date is 01/2018 or later).
Column
Variable Name
Format
Possible Entries/Example Entries
Description
"MFTEW226N0010", "3024",
A
award_id_piid
Text
"Y37MKOE39027507430598"
The "Procurement Instrument Identifier" (PIID) - The unique identifier of the specific award being reported.
The "Agency Identifier" - The agency code identifies the department or agency that is responsible for the
B
awarding_sub_agency_code
Text
"2315", "7022"
account. Please see https://files.usaspending.gov/reference_data/agency_codes.csm ("SUBTIER CODE"
column).
The "Referenced PIID" - If this award is derived from another award, such as Blank Purchase Agreement
C
parent_award_id_pild
Text
"RM12L2315K", "NR342N38752E", "N/A"
(BPA) call or a Delivery Order, the PIID of the original award. Otherwise this field should be "N/A".
The "Referenced Indefinite Delivery Vehicle Agency Identifier" - If this award is derived from another
D
parent_award_agency_id
Text
"2315", "7022", "NA"
award, such as Blank Purchase Agreement (BPA) call or a Delivery Order, the department or agency
identifier of original award. Otherwise this field should be "N/A". Please see
https://files.usaspending.gov/reference_data/agency_codes.csv ("SUBTIER CODE" column).
E
award_sub_agency_name
Text
"U.S. Coast Guard", "Kennedy Space Center"
The name of the department or agency that issued the RFP.
If this award is derived from another award, such as Blank Purchase Agreement (BPA) call or a Delivery
F
parent_award_agency_name
Text
"U.S. Coast Guard", "Kennedy Space Center", "N/A"
Order, the department or agency name of the original award. Otherwise this field should be "N/A".
G
action_date
Text YYYY_MM
"2018_01"
The date the RFP contract was officially issued/signed by the government. Use "0000_00" if RFP remains
open.
The date that the parties agree will be the starting date for the contract's requirements. This is the period of
performance start date for the entire contract period; this date does not reflect period of performance per
H
period_of_performance_start_date
Text YYYY_MM
"2022_09"
modification, but rather the start of the entire contract period of performance. Use "0000_00" if not
applicable.
I
The date that the parties agree will be the ending date for the contract's requirements, if applicable. Use
period_of_performance_end_date
Text YYYY_MM
"2022_09"
"0000_00" if not applicable.
J
solicitation_date
Text YYYY_MM
"2018_01"
The date on which the solicitation was issued.
K
response_date
Text YYYY_MM
"2022_09"
The date the Company responded to the RFP.
Number 0 decimal
The total dollar ($) amount included in the bid amount for the base offered service, without any options
L
bid_base_value
100340
points
exercised.
Number 0 decimal
The total dollar ($) amount included in the bid amount for the base offered service plus all options
M
potential_total_value_of_award
100340
points
exercised.
"Cost No Fee", "Cost Plus Award Fee", "Cost Plus Fixed
Fee", "Cost Plus Incentive", "Cost Sharing", "Firm Fixed
N
type_of_contract_pricing
Text
Price", "Fixed Price", "Fixed Price Award Fee", "Fixed
The type of contract pricing for the bid as identified in Federal Acquisition Regulation part 16.
Price Level of Effort", "Fixed Price With Economic Price
Adjustment", "Labor Hours", "Time and Materials"
o
won
Text
"0", "1", or "999"
Whether the Company won the RFP ("1") or did not win the RFP ("0"). Use "999" if RFP remains open.
Number 2 decimal
P
capacity
2.8
The total MHz of capacity included in the bid (if relevant) across all bands.
points
"HTS", "Lower Throughput Services", "Equipment",
Q
product_type
Text
"Other"
The type of the main product or service being rendered pursuant to the service contract.
"Aviation", "Ground", "Managed Wi-Fi", "Maritime",
R
product_category
Text
"Other"
The functional purpose of the main product or service being rendered pursuant to the service contract.
"Department of Defense requested 2.8 MHz of dedicated
S
description
Text
A brief description of the RFP.
IFC capacity for 3 years"
"RFP
Data"
Instructions
Submit
all
responses
to
Requests
for
Proposal
(RFPs)
made
by
the
United
States
Government,
including
by
any
agency
or
other
entity
representing
the
United
States
or
any
of
its
States
made
between
01/2018
and
09/2022.
Data
should
be
submitted
whether
or
not
the
United
States
Government
accepted
the
Company's
bid
or
submission,
or
a
competing
offer.
All
data
must
conform
to
award
specific
identifiers
available
on
USASpending.gov,
including
the
"award_id_piid,"
"awarding_sub_agency_code,"
"parent_award_id_pild,"
and
"parent_award_agency_id'
as
described
below,
including
for
RFPs
that
the
Company
responded
to,
but
where
the
United
States
Government
accepted
a
competing
offer.
The
required
format
for
the
entries
in
each
column/field
is
indicated
in
the
instructions
for
each
sheet.
Column
entries
in
bold
red
indicate
that
the
Company
should
enter
only
one
of
the
possible
entries
listed
for
that
column.
Variables
"A"
through
"H",
"J",
"M"
and
"N"
should
conform
with
the
corresponding
variables
in
USASpending.gov.
Column
"A"
identifies
a
unique
customer
observation.
Column
"K"
indicates
the
date
that
designates
whether
data
must
be
submitted
(i.e.,
submit
if
"response_date
is
01/2018
or
later).
Column
Variable
Name
Format
Possible
Entries/Example
Entries
Description
"MFTEW226N0010",
"3024",
A
award_id_piid
Text
"Y37MKOE39027507430598"
The
"Procurement
Instrument
Identifier"
(PIID)
-
The
unique
identifier
of
the
specific
award
being
reported.
The
"Agency
Identifier"
-
The
agency
code
identifies
the
department
or
agency
that
is
responsible
for
the
B
awarding_sub_agency_code
Text
"2315",
"7022"
account.
Please
see
https://files.usaspending.gov/reference_data/agency_codes.csm
("SUBTIER
CODE"
column).
The
"Referenced
PIID"
-
If
this
award
is
derived
from
another
award,
such
as
Blank
Purchase
Agreement
C
parent_award_id_pild
Text
"RM12L2315K",
"NR342N38752E",
"N/A"
(BPA)
call
or
a
Delivery
Order,
the
PIID
of
the
original
award.
Otherwise
this
field
should
be
"N/A".
The
"Referenced
Indefinite
Delivery
Vehicle
Agency
Identifier"
-
If
this
award
is
derived
from
another
D
parent_award_agency_id
Text
"2315",
"7022",
"NA"
award,
such
as
Blank
Purchase
Agreement
(BPA)
call
or
a
Delivery
Order,
the
department
or
agency
identifier
of
original
award.
Otherwise
this
field
should
be
"N/A".
Please
see
https://files.usaspending.gov/reference_data/agency_codes.csv
("SUBTIER
CODE"
column).
E
award_sub_agency_name
Text
"U.S.
Coast
Guard",
"Kennedy
Space
Center"
The
name
of
the
department
or
agency
that
issued
the
RFP.
If
this
award
is
derived
from
another
award,
such
as
Blank
Purchase
Agreement
(BPA)
call
or
a
Delivery
F
parent_award_agency_name
Text
"U.S.
Coast
Guard",
"Kennedy
Space
Center",
"N/A"
Order,
the
department
or
agency
name
of
the
original
award.
Otherwise
this
field
should
be
"N/A".
G
action_date
Text
YYYY_MM
"2018_01"
The
date
the
RFP
contract
was
officially
issued/signed
by
the
government.
Use
"0000_00"
if
RFP
remains
open.
The
date
that
the
parties
agree
will
be
the
starting
date
for
the
contract's
requirements.
This
is
the
period
of
performance
start
date
for
the
entire
contract
period;
this
date
does
not
reflect
period
of
performance
per
H
period_of_performance_start_date
Text
YYYY_MM
"2022_09"
modification,
but
rather
the
start
of
the
entire
contract
period
of
performance.
Use
"0000_00"
if
not
applicable.
I
The
date
that
the
parties
agree
will
be
the
ending
date
for
the
contract's
requirements,
if
applicable.
Use
period_of_performance_end_date
Text
YYYY_MM
"2022_09"
"0000_00"
if
not
applicable.
J
solicitation_date
Text
YYYY_MM
"2018_01"
The
date
on
which
the
solicitation
was
issued.
K
response_date
Text
YYYY_MM
"2022_09"
The
date
the
Company
responded
to
the
RFP.
Number
0
decimal
The
total
dollar
($)
amount
included
in
the
bid
amount
for
the
base
offered
service,
without
any
options
L
bid_base_value
100340
points
exercised.
Number
0
decimal
The
total
dollar
($)
amount
included
in
the
bid
amount
for
the
base
offered
service
plus
all
options
M
potential_total_value_of_award
100340
points
exercised.
"Cost
No
Fee",
"Cost
Plus
Award
Fee",
"Cost
Plus
Fixed
Fee",
"Cost
Plus
Incentive",
"Cost
Sharing",
"Firm
Fixed
N
type_of_contract_pricing
Text
Price",
"Fixed
Price",
"Fixed
Price
Award
Fee",
"Fixed
The
type
of
contract
pricing
for
the
bid
as
identified
in
Federal
Acquisition
Regulation
part
16.
Price
Level
of
Effort",
"Fixed
Price
With
Economic
Price
Adjustment",
"Labor
Hours",
"Time
and
Materials"
o
won
Text
"0",
"1",
or
"999"
Whether
the
Company
won
the
RFP
("1")
or
did
not
win
the
RFP
("0").
Use
"999"
if
RFP
remains
open.
Number
2
decimal
P
capacity
2.8
The
total
MHz
of
capacity
included
in
the
bid
(if
relevant)
across
all
bands.
points
"HTS",
"Lower
Throughput
Services",
"Equipment",
Q
product_type
Text
"Other"
The
type
of
the
main
product
or
service
being
rendered
pursuant
to
the
service
contract.
"Aviation",
"Ground",
"Managed
Wi-Fi",
"Maritime",
R
product_category
Text
"Other"
The
functional
purpose
of
the
main
product
or
service
being
rendered
pursuant
to
the
service
contract.
"Department
of
Defense
requested
2.8
MHz
of
dedicated
S