*Pages 1--13 from Microsoft Word - 43112.doc* C. Accessing Auction Announcements You may use your Web browser to view or download announcements, as described in the following sections. 1. Access Procedure 1. Point your Web browser at http:// auctions. fcc. gov Alternatively, you can point your Web browser at http:// auctions2. fcc. gov. 2. On the Auctions Systems page, click the Auctions Archives link 3. On the Auction Data Archives page, click the link for Auction 37. The Index page that appears shows a parent directory that has three subdirectories, or folders. Clicking one of the folder names expands the associated subdirectory to show its contents. 4. Click Announcements. 5. Click the file you want to download. Template File for Importing Bids: The file template. txt is a template that can be modified as desired and used to select a group of bids simultaneously, by importing them in a file. 6. The file will open in your browser and you can save it to a local disk drive, if desired. 2. Naming Conventions For Announcement Files The announcement files will use the naming convention aa_ xxx. nnn, where aa is the auction number, xxx is the round number and nnn is the announcement number. For example, 37_ 002.007 would represent an announcement for Auction 37 that was posted during round two and was the seventh announcement for the auction. D. Tracking the Auction via the FCC Wide Area Network 4 E. Round Results File Formats This section describes the formats for the round results files that will be posted on the FCC Internet site 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 FCC Auction Tracking Tool. The other files are in dbf and txt formats and contain the raw output of the auction data. 1. Auction Tracking Tool File Format There will be a single Auction Tracking Tool .zip 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 FCC Auction Tracking Tool. a. All Bids table Auction ID Number( Long Integer) Round Number( Long Integer) License Name Text( 15) Market Text( 6) Block Text( 2) Submarket Number( Long Integer) Bidder Text( 50) Increments of Bid Number( Long Integer) Gross Bid Amount Currency Net Bid Amount Currency License ID Number( Long Integer) Date Text( 10) Random No Text( 30) b. Bidders table Auction ID Number( Long Integer) Round Number( Long Integer) Bidder Text( 50) FCC Acct Text( 10) Bidding Credit Number( Single) Initial Eligibility Number( Long Integer) Current Eligibility Number( Long Integer) 6 Change in Eligibility Number( Long Integer) Waiver Type Text( 4) New Bids Number( Long Integer) Gross Bids Currency Net Bids Currency Total High Bids Number( Long Integer) Gross High Bids Currency Net High Bids Currency Current Activity Number( Long Integer) Additional Activity Required Number( Long Integer) Unused Elig Number( Long Integer) Waivers Remaining Number( Long Integer) Withdrawals Remaining Number( Long Integer) c. Bidders Raising Own High Bid table Auction ID Number( Long Integer) Round Number( Long Integer) License Name Text( 15) Major Grouping Text( 6) Minor Grouping Text( 6) Block Text( 2) Submarket Number( Long Integer) Bidder Text( 50) Increments of Bid Number( Long Integer) Gross Bid Amount Currency Net Bid Amount Currency Date Text( 10) d. Bidders Who Reduced table Auction ID Number( Long Integer) Round Number( Long Integer) Bidder Who Reduced Text( 50) Reduction Amt Number( Long Integer) Current Eligibility Number( Long Integer) e. Increment Statistics table Auction ID Number( Long Integer) Round Number( Long Integer) 1 Number( Long Integer) 2 Number( Long Integer) 7 3 Number( Long Integer) 4 Number( Long Integer) 5 Number( Long Integer) 6 Number( Long Integer) 7 Number( Long Integer) 8 Number( Long Integer) 9 Number( Long Integer) f. Markets table Auction ID Number( Long Integer) Round Number( Long Integer) License Name Text( 15) Major Grouping Text( 6) Minor Grouping Text( 6) Block Text( 2) Submarket Number( Long Integer) License Size (MHz) Number( Double) Market Name Text( 50) BUs Number( Long Integer) Population Number( Long Integer) Number of Bids Number( Long Integer) High Bidder Text( 50) Round of High Bid Number( Long Integer) Increments of Bid Number( Long Integer) Gross Currency Bidding Credit Number( Single) Net Currency Date Text( 10) Min Acceptable Bid Currency Bid Increment Currency Prev High Bidder Text( 50) Round of Prev High Bid Number( Long Integer) Prev Gross Currency Prev Bidding Credit Number( Single) Prev Net Currency Selected Number( Long Integer) All Selected Number( Long Integer) License ID Number( Long Integer) g. Round Statistics table Auction ID Number( Long Integer) 8 Round Number( Long Integer) Round Date Text( 11) Stage Number( Long Integer) New Bids Number( Long Integer) Total High Bids Number( Long Integer) Pctg of BUs for All Bids Number( Single) Pctg of BUs for High Bids Number( Single) Gross Bids Currency Net Bids Currency Dollar Change in Net Bids Currency Pctg Change in Net Bids Number( Single) Eligible Bidders Number( Long Integer) Bidders At Risk Number( Long Integer) Number Reduced Number( Long Integer) BUs Reduced Number( Double) Eligibility Ratio Number( Single) Pctg of Covered BUs Number( Single) Waivers Number( Long Integer) Withdrawals Number( Long Integer) FCC Held Licenses Number( Long Integer) Pctg of Covered Pops Number( Single) Pctg of the Covered Pops with Bidding Credit Number( Single) h. Waiver Statistics table Auction ID Number( Long Integer) Round Number( Long Integer) Bidder Text( 50) Waiver Type Text( 1) Remaining Waivers Number( Long Integer) i. Withdrawal Statistics table Auction ID Number( Long Integer) Withdrawal Number Number( Long Integer) Bidder Text( 50) License Name Text( 15) Market Text( 6) Block Text( 2) Submarket Number( Long Integer) BUs Number( Long Integer) Population Number( Long Integer) 9 Round Number( Long Integer) Gross Currency Net Currency Date Text( 10) Min Bid Currency New High Bidder Text( 50) New High Bid Round Number( Long Integer) Gross High Bid Currency Net High Bid Currency 2. Round Results File Format 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. a. ALL_ BIDS file service_ code char( 2) market char( 6) freq_ block char( 2) round_ num numeric bid_ amt numeric bidder_ num numeric fcc_ acct char( 10) date char( 10) net_ bid_ amt numeric sort_ col_ 1 numeric sort_ col_ 2 numeric sub_ market numeric random_ num double b. HIGH_ BIDS file service_ code char( 2) market char( 6) freq_ block char( 2) bid_ round numeric bid_ amt numeric bidder_ num numeric fcc_ acct char( 10) 10 date char( 10) net_ bid_ amt numeric min_ accept numeric min_ bid_ incr_ 2 double num_ of_ bids numeric sort_ col_ 1 numeric sort_ col_ 2 numeric sub_ market numeric c. 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_ act numeric d. WITHDRAWALS file service_ code char( 2) market char( 6) freq_ block char( 2) bid_ round numeric bid_ amt numeric bidder_ num numeric fcc_ acct char( 10) date char( 10) net_ bid_ amt numeric sort_ col_ 1 numeric sort_ col_ 2 numeric sub_ market numeric e. BIDDER_ CROSS_ REFERENCE file bidder_ num numeric fcc_ acct char( 10) 11 G. Help For technical assistance with using FCC software, contact the FCC Technical Support Hotline at (202) 414- 1250 (V) or (202) 414- 1255 (TTY). The FCC Technical Support Hotline is generally available Monday through Friday from 8 a. m. to 6 p. m. ET. All calls to the FCC Technical Support Hotline are recorded. 13