******************************************************** NOTICE ******************************************************** This document was converted from WordPerfect to ASCII Text format. Content from the original version of the document such as headers, footers, footnotes, endnotes, graphics, and page numbers will not show up in this text version. All text attributes such as bold, italic, underlining, etc. from the original document will not show up in this text version. Features of the original document layout such as columns, tables, line and letter spacing, pagination, and margins will not be preserved in the text version. If you need the complete document, download the WordPerfect version or Adobe Acrobat version, if available. ***************************************************************** Attachment F FILE FORMATS This attachment describes the formats for the round results files that will be uploaded to the FCC Internet site and FCC Auction Bulletin Board System (BBS) after each round of the auction. There are three sets of results files. The first set of files is in Microsoft Access 97 mdb format and contains the data tables for the new FCC Auction tracking tool. The other files are in dbf and txt format and contain the raw output of the auction data. The newest round results are uploaded to the Results directory based on type of file format: dbf, mdb, and txt. On wtbwww01.fcc.gov: http://wtbwww01.fcc.gov/LMS/Auction_21/Results/dbf http://wtbwww01.fcc.gov/LMS/Auction_21/Results/mdb/ http://wtbwww01.fcc.gov/LMS/Auction_21/Results/txt/ On www.fcc.gov: http://www.fcc.gov/Auctions/LMS/Results/dbf/ http://www.fcc.gov/Auctions/LMS/Results/mdb/ http://www.fcc.gov/Auctions/LMS/Results/txt/ After every 50 rounds, files will be moved from the Results directory to archive directories. The following listings show an example of the directory structure for an auction in round 102. Note that the results for rounds 101 and 102 would be in the Results directories. On wtbwww01.fcc.gov: Rounds 1-50 http://wtbwww01.fcc.gov/LMS/Auction_21/Results/dbf/D001_050 Rounds 51-100 http://wtbwww01.fcc.gov/LMS/Auction_21/Results/dbf/D051_100 Rounds 101-102 http://wtbwww01.fcc.gov/LMS/Auction_21/Results/dbf/ Rounds 1-50 http://wtbwww01.fcc.gov/LMS/Auction_21/Results/mdb/M001_050 Rounds 51-100 http://wtbwww01.fcc.gov/LMS/Auction_21/Results/mdb/M051_100 Rounds 101-102 http://wtbwww01.fcc.gov/LMS/Auction_21/Results/mdb/ Rounds 1-50 http://wtbwww01.fcc.gov/LMS/Auction_21/Results/txt/T001_050 Rounds 51-100 http://wtbwww01.fcc.gov/LMS/Auction_21/Results/txt/T051_100 Rounds 101-102 http://wtbwww01.fcc.gov/LMS/Auction_21/Results/txt/ On www.fcc.gov: Rounds 1-50 http://www.fcc.gov/Auctions/LMS/Results/dbf/D001_050 Rounds 51-100 http://www.fcc.gov/Auctions/LMS/Results/dbf/D051_100 Rounds 101-102 http://www.fcc.gov/Auctions/LMS/Results/dbf/ Rounds 1-50 http://www.fcc.gov/Auctions/LMS/Results/mdb/M001_050 Rounds 51-100 http://www.fcc.gov/Auctions/LMS/Results/mdb/M051_100 Rounds 101-102 http://www.fcc.gov/Auctions/LMS/Results/mdb/ Rounds 1-50 http://www.fcc.gov/Auctions/LMS/Results/txt/T001_050 Rounds 51-100 http://www.fcc.gov/Auctions/LMS/Results/txt/T051_100 Rounds 101-102 http://www.fcc.gov/Auctions/LMS/Results/txt/ Tracking the FCC Mock Auction Mock Auction round results and announcement files will be posted on the FCC Internet and FCC Auction Bulletin Board System (BBS) in the same location as the auction results. The directory structure for the mock auction will be as follows: On wtbwww01.fcc.gov: http://wtbwww01.fcc.gov/Mock/Results/dbf http://wtbwww01.fcc.gov/Mock/Results/mdb/ http://wtbwww01.fcc.gov/Mock/Results/txt/ On www.fcc.gov: http://www.fcc.gov/Auctions/Mock/Results/dbf/ http://www.fcc.gov/Auctions/Mock/Results/mdb/ http://www.fcc.gov/Auctions/Mock/Results/txt/ Auction Tracking Tool File Format There will be a single Auction tracking Tool file for each round of the auction. The following layout describes the tables and fields within the mdb round file. The mdb files are for use with the new FCC Auction Tracking Tool. All Bids table Auction ID Long Integer Round Long Integer License Name Text(9) Market Text(6) Block Text(2) Bidder Text(50) Increments of Bid Long Integer Gross Bid Amount Currency Net Bid Amount Currency Bidders table Auction ID Long Integer Round Long Integer Bidder Text(50) FCC Acct Text(10) Bidding Credit Single Initial Eligibility Long Integer Current Eligibility Long Integer Change in Eligibility Long Integer Waiver Type Text(1) New Bids Long Integer Gross Bids Currency Net Bids Currency Total High Bids Long Integer Gross High Bids Currency Net High Bids Currency Current Activity Long Integer Required Activity Long Integer Unused Elig from Prev Round Long Integer Waivers Remaining Long Integer Withdrawals Remaining Long Integer Bidders Raising Own High Bid table Auction ID Long Integer Round Long Integer License Name Text(9) Major Grouping Text(6) Minor Grouping Text(6) Block Text(2) Bidder Text(50) Increments of Bid Long Integer Gross Bid Amount Currency Net Bid Amount Currency Bidders Who Reduced table Long Integer Long Integer Round Long Integer Bidder Who Reduced Text(50) Reduction Amt Long Integer Current Eligibility Long Integer Increment Statistics table Auction ID Long Integer Round Long Integer 1 Long Integer 2 Long Integer 3 Long Integer 4 Long Integer 5 Long Integer 6 Long Integer 7 Long Integer 8 Long Integer 9 Long Integer Markets table Auction ID Long Integer Round Long Integer License Name Text(9) Major Grouping Text(6) Minor Grouping Text(6) Block Text(2) License Size Double Market Name Text(50) BUs Long Integer Population Long Integer Number of Bids Long Integer High Bidder Text(50) Round of High Bid Long Integer Increments of Bid Long Integer Gross Currency Bidding Credit Single Net Currency Min Acceptable Bid Currency Bid Increment Currency Prev High Bidder Text(50) Round of Prev High Bid Long Integer Prev Gross Currency Prev Bidding Credit Single Prev Net Currency Selected Long Integer All Selected Long Integer Round Statistics table Auction ID Long Integer Round Long Integer Round Date Date/Time Stage Long Integer New Bids Long Integer Total High Bids Long Integer Pctg of BUs for All Bids Single Pctg of BUs for High Bids Single Gross Bids Currency Net Bids Currency Dollar Change in Net Bids Currency Pctg Change in Net Bids Single Eligible Bidders Long Integer Bidders At Risk Long Integer Number Reduced Long Integer BUs Reduced Long Integer Eligibility Ratio Single Pctg of Covered Bus Single Waivers Long Integer Withdrawals Long Integer FCC Held Licenses Long Integer Pctg of Covered Pops Single Pctg of the Pops with Bidding Credit Single Waiver Statistics table Auction ID Long Integer Round Long Integer Bidder Text(50) Waiver Type Text(1) Remaining Waivers Long Integer Withdrawal Statistics table Auction ID Long Integer Withdrawal Number Long Integer Bidder Text(50) License Name Text(9) Market Text(6) Block Text(2) BUs Long Integer Population Long Integer Round Long Integer Gross Currency Net Currency Min Bid Currency New High Bidder Text(50) New High Bid Round Long Integer Gross High Bid Currency Net High Bid Currency Round Results Files The round results files were used by the previous Excel based tracking tool produced by the FCC and are still being distributed for those bidders who use them for their own tracking purposes. The following layouts are for the dbf files. The txt files will have character field types. ALL_BIDS file market char(6) freq_block char(2) round_num numeric bid_amt numeric bidder_num numeric fcc_acct char(10) date date time char(8) net_bid_amt numeric sort_col_1 numeric sort_col_2 numeric HIGH_BIDS file market char(6) freq_block char(2) bid_round_num numeric bid_amt numeric bidder_num numeric fcc_acct char(10) date date time char(8) net_bid_amt numeric min_accept numeric num_of_bids numeric sort_col_1 numeric sort_col_2 numeric MAXIMUM_ELIGIBILITY file round_num numeric bidder_num numeric fcc_acct char(10) max_elig numeric rmng_waivr numeric waivr_ind char(1) rmng_withdrawals numeric required_act numeric current_activity numeric WITHDRAWALS file market char(6) freq_block char(2) bid_round_num numeric bid_amt numeric bidder_num numeric fcc_acct char(10) date date time char(8) net_bid_amt numeric sort_col_1 numeric sort_col_2 numeric BIDDER_CROSS_REFERENCE file bidder_num numeric fcc_acct char(10) co_name char(50) bidding_credit_pctg numeric