|
|
Form 175
Filing and Searching Auction Applications |
WTB
Wireless Telecommunications Bureau |
ULS
Universal Licensing System |
CORES
Commission Registration System |
GIS
Geographical Information Systems |
Rural Telecommunications
Telecommunications Service for Rural America |
|
|
|
|
Auction Round Results
Round
Results Files
File
Descriptions for Non-Package Bidding
File
Descriptions for Auction #51 Package Bidding
The bidding results for each round of the FCC Spectrum
Auctions are made available to the public in a database (.dbf), text (.txt)
and, for auctions after Auction No. 20, Microsoft Access (.mdb) file format.
These files can be downloaded by clicking on the "Round Results"
link for the specific auction and selecting the appropriate folder, txt,
dbf or mdb. Once the files have been downloaded they can be imported into
a database applications such as Paradox, Fox Pro, or Microsoft Access,
or into a spreadsheet application such as Microsoft Excel, QuattroPro,
or Lotus 1-2-3. For some auctions, the FCC has provided a tracking tool
for analyzing auction results.
More detail about the files, their types, and their contents is located
below.
Round Results Files, by Auction |
|
|
The following table provides a description of the
above files.
File Descriptions for Non-Package
Bidding |
|
File
Types |
Description |
Round
Results |
These files
consist of "raw" data, in various formats (.dbf, .txt,
and for auctions after Auction No. 20, .mdb) that can be imported
into software such as a spreadsheet or database program, for analyzing
the bids. For specific information, including file description,
refer to attachment "How to Monitor the Auction Online"
that is released as part of the Qualified Bidder Public Notice for
the specific auction of interest. |
Bidder
Cross Reference |
This file
provides each qualified bidder's name, FCC Account Number, Bidder
Number, and bidding credit (if applicable). The file naming convention
is "##_xref.dbf" or "##_xref.txt" where "##"
is replaced by the auction number such as "5_xref.dbf" |
Market
Data |
This file,
if available, provides relevant information about the markets/licenses
being auctioned such as market number, market name, and population.
The file naming convention is "##_market.dbf" where "##"
is replaced by the auction number, such as "5_market.dbf" |
Announcements |
The FCC uses
announcements as a means of informing bidders of auction related
information. This includes stage transitions and round schedules.
For specific information, including file description, refer to the
attachment "How to Monitor the Auction On-line" that is
released as part of the Qualified Bidder Public Notice for the specific
auction of interest. |
Importing
Template |
A template
used to import bids. This can only be used while the auction is
in progress. |
|
Auction #51 File Descriptions (Package Bidding) |
|
|
(See PN DA03-2857 for additional
information)
For each round, ASCII text (.txt) files will be uploaded with the following
naming conventions, where xxx represents the round number:
File Descriptions for Auction #51
Package Bidding |
|
Description
& File Name |
This file contains: |
All
Bids
51_xxxab.txt |
All bids
that are considered in determining the round’s provisionally
winning bids |
Current
Round Bids
51_xxxcb.txt
|
All bids
placed in the current round |
Minimum
Acceptable Bids
51_xxxmb.txt
|
All licenses
applied for and every package that was bid on by each respective
bidder |
Auction
Summary
51_xxxas.txt
|
Information
about the provisionally winning bid for each license and package,
as of that round |
Provisionally
Willing Bids
51_xxxpw.txt
|
A template
used to import bids. This can only be used while the auction
is in progress. |
Current
Price Estimate
51_xxxpr.txt
|
The current
price estimate for each license |
Auction
Parameters
51_xxxap.txt
|
Factors
the FCC used to calculate required bidder activity and minimum
bid amounts in that round and preceding rounds |
Bidder
Summary
51_xxxbs.txt
|
Summary
information for bidders and contains one row per authorized
bidder |
|
FCC Auction Tracking Tool Round
Results Files |
|
|
Microsoft Excel-based Tracking Tool
The FCC Auction Bidding System generates four files
(six files for auctions prior to Auction No. 12) for each round of the
auction. The files are named using the following A_BBBC.dbf, where A is
the auction identification number (e.g. 5 = PCS C-Block), BBB is the round
number, and C designates the content of the file. The following table
lists the possible types of content designated by C. These files were
originally used by a Microsoft Excel based auctions tracking tool, supplied
by the FCC, to assist bidders and the public with analyzing auction results.
|
"C" |
Auctions No. 4 through 12 |
Auctions After No. 12 |
e |
Eligibility
and remaining waivers for every bidder as of the close of bid submission |
Eligibility
and remaining waivers for each bidder |
h |
|
High
bids in a particular round and the minimum bid
increments for the next round |
m |
Minimum
acceptable bids for the next round for all licenses |
|
s |
All
submitted bids during the bid submission period, pre-withdrawal |
All
submitted bids in a particular round |
w |
Withdrawn
high bids during the bid withdrawal period |
All
withdrawn bids in a particular round |
x |
High
bids for every market as of the close of the bid submission period |
|
y |
High
bids for every market as of the close of the round (post withdrawal) |
|
|
For example, the file 14_030e.dbf contains the eligibility and remaining waivers
for each bidder for round 30 of auction No. 14.
The "Bidder Cross Reference" file contains
the bidder's name and the four digit bidder identification number. The
"Market Data" file includes the market name, number and population.
Microsoft Access-based Tracking Tool
Since Auction No. 20, the FCC has supplied a Microsoft Access based auction
tracking tool to assist bidders and the public with analyzing auction results.
The files, one for each round, can be accessed from the above table by clicking
on the appropriate auction "Results" link and selecting the "mdb"
subdirectory.
Visit the Tracking Tool page to download the
auction tracking tool and a readme file for each auction.
Return to Top
Last reviewed/updated on 9/15/2004.
|
|