Worksheet Columns

For information on sorting rows on the worksheet, refer to Worksheet Rows. To hide columns, refer to Preferences Tab.

In the table below, columns are listed in their default order on the worksheet. In the table below, columns are listed in their default order on the worksheet.

To move a column, click the column heading then drag to the desired location. The order of the columns is saved when you save a worksheet as long as you have made at least one change to the worksheet before saving. If you open a worksheet and only rearrange the columns, the column order will not be saved. Once saved, the column order applies to all worksheets until you change it.
To resize a column, move your mouse over one of the sides of the column header to display a two headed arrow, then drag to widen or narrow the column.

* Data in columns marked with an asterisk is retrieved with the avails, if defined, but can be overridden.

Column Name	Summary	Description
* DP	Daypart code	Key the daypart code for the buy. To view a list of valid codes, right click (PC) or CMD-click (MAC) in the column.
* Station	Call letters	Retrieve stations with avails on the Avails tab or key the station for the buy. For a buy to be approved, the station's home market must be the market entered on the Start Up tab. However, on a proposed buy, you may enter stations assigned as spill stations to the market on the Start Up tab.
* BC	Band code	Key the band code for the station.
* Days	Days of the week on which spots are to air	Key the day(s). Refer to Entering Days of the Week.
* Start Time	Beginning time for time period in which spots are to air	Enter as HHMM (no colon) plus A for AM, P for PM, N for noon, or M for midnight. For more information, see Entering Start/End Times.
* End Time	Ending time for time period in which spots are to air	Enter as HHMM (no colon) plus A for AM, P for PM, N for noon, or M for midnight. For more information, see Entering Start/End Times.
* Program Name		Program name from avails, if any, or from share book used for estimated book. Accept display or key a name of up to 20 characters.
Network		For a local cable buy, key the network code for the buy if network is defined as required or optional for the band code in Band Code Definition. Refer to Network Code Settings. Note: Network codes should only be entered on buys for cable networks and must be the Nielsen defined code for the network to retrieve ratings. Local cable ratings are only available from the Nov03 book forward.
* Client Cost	Spot cost to be used in billing the client	Retrieved with avails, if any. Accept display or key an amount. Editing this field will cause CPP/M to be recalculated accordingly. A blank does not represent zero. If the vendor cost and vendor cost qualifier are the same as the client cost and client cost qualifier, changing this field changes the vendor cost to keep it the same.
* Vendor Cost	Spot cost to be used in paying the vendor	This column is only available if your agency is using Dual Costing. Defaults to the amount in the Client Cost column, but may be changed. Accept display or key an amount. The vendor cost/vendor cost qualifier combination is used in affidavit matching and paying. If you do not want the vendor cost to be different from the client cost, use the Preferences tab to hide this column before editing the worksheet. .
Item#	Buy line item number	Active buys only. Number assigned by BROADCAST to each buy line for a station when the buy is approved. This controls the order in which spots are reported on some inquiries and reports, including the Buy Detail Report . To change the order in which spots are reported, use the Buy Sequencer to change this number.
Ref#	Makegood reference number	Item # of the buy line which is being made good. Assigned by BROADCAST and may not be changed. Active buys only.
C	Comment	Indicates if any comments have been entered for this buy line. Click in this cell to view and/or edit comments. Comments may also be entered using the Buy Line Comments function.
RT/IM	Demographic rating/impression	Audience RT/IM figures. One column for each demo. Displays in bold if you key over a retrieved value. Keying a zero in this field will cause audience statistics to be recalculated accordingly. A blank does not represent zero and will not cause other statistics to be recalculated. The Rating Decimal setting on the Preferences tab
Share	Demographic share	Audience share figures. One column for each demo. Keying a zero in this field will cause audience statistics to be recalculated accordingly. A blank does not represent zero and will not cause other statistics to be recalculated.
PVT/HUT	Persons viewing television/Households using television	Audience PVT/HUT figures. One column for each demo. Keying a zero in this field will cause audience statistics to be recalculated accordingly. A blank does not represent zero and will not cause other statistics to be recalculated.
CPP/M	Cost per point/thousand	One column for each demo. If the market is unrated, the column heading remains the same but the value displayed is actually Cost Per Spot. Keying a zero in this field will cause audience statistics to be recalculated accordingly. A blank does not represent zero and will not cause other statistics to be recalculated.
AQH Per	Average Quarter Hour (in thousands)	Audience represented in thousands radio only). Changing AQH Persons will change AQH Rating as well as Turnover (T/O).
Cume	Cume Rating	Number of audience listening to a daypart for at least 5 minutes (radio only). Expressed as a rating. Changing Cume rating will change noting.
Cume Per	Cume Persons	Cume Audience (radio only) represented in thousands. Changing Cume Persons will change Turnover (T/O)/
T/O	Turnover	Station Daypart Turnover (radio only) as defined by dividing Cume Persons by AQH Persons. Changing T/O will only impact Cume Persons.
Est. Book	Estimated book name	Defined on the Start Up tab.
Client Q	Client Cost Qualifier	Defaults to G (Gross). Qualifies the amount in the Client Cost field only. May key over or mass change. Only one Client qualifier may be used per worksheet for a station or a payee rep. If there is a mixture of cost qualifiers for one station, the station is the payee for lines with the most prevalent qualifier and any other line must be assigned a payee rep. If the vendor cost and vendor cost qualifier are the same as the client cost and client cost qualifier, changing this field changes the vendor cost qualifier to keep it the same. N=Net, F=Fixed/free of commission.
Vendor Q	Vendor Cost Qualifier	This column is only available if your agency is using Dual Costing. Defaults to G. Qualifies the amount in the Vendor cost field only. May key over or mass change. Only one vendor qualifier may be used per worksheet for a station or a payee rep. If there is a mixture of vendor cost qualifiers for one station, the station is the payee for lines with the most prevalent qualifier and any other line must be assigned a payee rep.
Len	Spot length	Defaults to 60 for radio and 30 for television media, but you may select a different length from the drop down list.
B	Bonus indicator	Key B to indicate that the spots on this buy line are bonus spots.
* BA	Break average	Key the appropriate code to indicate whether to use break averaging. Refer to Break Average.
* Eff. Start Date	Effective start date	Date after which the avail data from Station Avails Entry is valid. Blank if no effective start date was defined with the avails. To key a different date, key as MM/DD/YY.
* Eff. End Date	Effective end date	Date after which the avail data from Station Avails Entry is no longer valid. Blank if no effective end date was defined with the avails. To key a different date, key as MM/DD/YY.
Payee		If payment is to be made to a special payee for this line only, key the payee. If a special payee was assigned on the estimate, this column is blank and may not be changed. Only one qualifier may be used per worksheet for a station or a payee rep. If there is a mixture of cost qualifiers for one station, the station is the payee for lines with the most prevalent qualifier and any other line must be assigned a payee rep.
S	Select row	Key S to select a row for sorting or filtering.
Filter Code		Informational field only. If using this field, key up to two characters.
PB	Pool buy indicator	Display only. Displays Y if the spots on this row were allocated from a pool buy or if the row is a pool buy row.
Item Type		Key appropriate Item Type (optional) for a buy line as defined in Item Type Defintion.
Spill-in Market		Enter Spill-in Market when estimating a station/time period for a station whose primary market assignment is not equal to the market on the worksheet being purchased. A Spill-In Market must be equal to the market on the worksheet. Once entered, the buy line will turn a shade of orange signifying that line as a Spill Line. Spill-In lines may be approved, must have a Cost of $0.00 and will not impact any billing or paying cycle.
Status	Worksheet status	Display only. Indicates whether this buy line is active (A) or proposed (P).
Total	Total number of spots	Display only. Displays the total number of spots purchased across all weeks for this buy line.
CB	Combo buy indicator	Display only. Displays Y when combo stations are created.
Trade Cost	Miscellaneous cost	You can use this cell on a buy line to factor in any additional costs that don't fall into a specific category. The values in this cell will have no impact on Billing or Paying. Trade Cost may be printed in the Worksheet Schedule Report (located in the Reports Tab) as well as the Buy Detail Report.
Makegood Cost	Miscellaneous cost	You can use this cell on a buy line to factor in any additional costs that don't fall into a specific category. The values in this cell will have no impact on Billing or Paying. Makegood Cost may be printed in the Worksheet Schedule Report (located in the Reports Tab) as well as the Buy Detail Report.
Dial Position	Lists the radio station's dial position.	Only used for Radio buys. The Dial Position cell will be populated using information from Nielsen Audio when you retrieve ratings. Keep in mind that this data is only available for a proposed buy. It is not needed nor is it available for an actual buy.
Format	Lists the radios station's music format.	Only used for Radio buys. The Format cell will be populated using information from Nielsen Audio when you retrieve ratings. Keep in mind that this data is only available for a proposed buy. It is not needed nor is it available for an actual buy.
Week/Day	Scheduled spots	Week/Day columns display based on estimate flight dates for estimate code keyed on Start Up tab. Spots outside the effective start/end date range display in pink. Key the number of spots per week or day, depending on whether this is a weekly or daily worksheet. On a proposed worksheet, you may disallow entry of spots for a buy/week by disabling the cell. See Disabling and Enabling Cells. The Tiered Rates function also disables cells. To move all spots for one week to another week of the estimate, see Move Weekly Spots. To copy spots from one week or set of weeks to another week or set of weeks, see Copying Spots. The column headings for any weeks defined as Hiatus Weeks are highlighted. If you schedule spots in any of these weeks a warning displays when you save the worksheet but you may save anyway.