Worksheet Function Descriptions

Click function names to display descriptions.

These functions are listed on the primary drop down menu in the Functions section of the buying worksheet. Refer to Worksheet Functions for more information on using functions.

Lookup. Retrieve a code from a list into the selected rows. Select the type of code from the secondary drop down list and click <Apply> to display the Search window. See Looking Up Codes for additional instructions for selecting codes from the Search window.

Refresh Lookups. Refresh the Vendor, Ad Number and Space Code lookup lists with any new codes that have been defined since you opened the Buy Module.

Insert. Add blank rows to the bottom of the worksheet. Key the number of rows to be added in the Functions text box and click <Apply>.

The new rows will contain these default values:

Change. Make mass changes to the value in one column. Only the columns listed on the secondary drop down list may be changed. If you are using Insertions with Revisions, see Changing or Deleting an Insertion.  

Note:  There are differences between the choices to be changed across the three Media (Print, Interactive, Out of Home) Systems.

1. Select the rows to be affected.

2. Select the column to be changed from the secondary drop down list.

3. Key the new value in the Functions text box. Refer to Worksheet Functions and Worksheet Buy Columns for more information.

Comments. Displays the Comment Entry window where you may view or enter comments for the selected buy line(s). Comments may also be entered for a buy line by double clicking in the Comments column for that line. Refer to Entering Insertion Comments.

Copy. Copy selected rows to the bottom of the worksheet. Leaves the selected rows highlighted for further changes. Lead buys and subsequent buys cannot be copied. All information is copied to the new row except these settings: Freeze Buy, Billing Hold, Bill Immediately, and I/O Status.

Create Ad Number. After you type a unique new ad number in an empty field in the ad number column, press <Enter>, highlight this row, then click Create Ad Number. In the function description box, type that description will become the caption. Click <Apply.> The Ad Number is created and may be edited in Ad Number Definition another time.

Delete. Delete the selected rows. Proposed insertions are completely deleted from Print. When an Active insertion is deleted it remains in Print and is included on some reports and inquiries. To display deleted insertions on the worksheet, click the Deleted status check box on the Start Up tab before retrieving the worksheet. If you are using Insertions with Revisions, see Changing or Deleting an Insertion.

If the deleted item has been billed or paid it will still display in Bill/Pay Inquiry and an adjustment will be created that must be cleared in Clear Vendor Invoices. The adjustment amount displays in the Worksheet Buy Totals.

Reload. Reloads the entire worksheet into the browser, losing any changes made since the last time you clicked <Save>. When reloading the worksheet, the following message displays: "Reloading Worksheet Data"

Retrieve Rate. Retrieve contract rates defined in Contract Definition.

Audit Buylines. Checks the selected insertions for errors that would prevent the worksheet from saving.

Export. Exports the Worksheet as you have it displayed, with all your preferences, filters, and column order as you see it on screen.  Exports as a .CSV file, which displays in an Excel worksheet. See also Exporting a Worksheet.

Map Point.  If you have licensed Map Point, this function launches the software when you are working in the Out-of-Home system.

Print Insertion Orders. Print insertion orders for selected insertions. Not available if you are using Insertions with Revisions. See also the explanations for the e-mail and hold outq settings on the Preferences tab.

1. After selecting the function of Print Insertion Orders, select Single or Schedule from the secondary drop down list.

2. Key the Outqueue in the text box and click <Save> to save the worksheet and submit the insertion order print request.