TVmap > TVmap in Excel > TVmap Functions

AverageRate is the average rate or cost for a specific channel over a specific time period, using a specified rate card.

Results can be restricted to specified periods, days of the week and times.

TVmap.Excel.Average.Rate.Main

The AverageRate function requires the following parameters:

DayMask [Optional]

Example

Below is an example of the AverageRate function used to calculate the AverageRate for TVNZ 1*, using the latest ratecard, week commencing 30/06/2019, peak time and including all days of the week.

TVmap.Excel.Average.Rate.Example

* Excel® is a registered trademark of Microsoft Corporation

Have more questions?

E-mail us: support@tvmap.com

or call us: +64 9 304 0762

Average Rate

Average Rate