Week Grid

Email:     support@tvmap.com

Phone:   +64 9 304 0762

<< Click to Display Table of Contents >>

Navigation:  TVmap > TVmap in Excel > TVmap Templates >

Week Grid

Email:     support@tvmap.com

Phone:   +64 9 304 0762

 

View quarter hour trends by day in a schedule format; with quarter hours down the side and days of the week across the top.

TVmap.Excel.Week.Grid.Main

 

There are three tabs TARP, Rate and Combination.

 

TARP - gives you the TARP quarter hour trends by day.

Excel.Week.Grid.TARP.Tab

 

Rate - gives you the Cost quarter hour trends by day.

Excel.Week.Grid.Rate.Tab  

 

 

Combination - gives you the Cost, TARP and CPT quarter hour trends by day.

Excel.Week.Grid.Combination.Tab

 

Edit the parameters as required - parameters will differ depending on the tab being used

Start Date

End Date

Demographic

Channel

Viewing Session Type - Overnight or Consolidated

Time From Broadcast - defaults to Any

TV Type - All, SKY or Freeview

 

Excel.Week.Grid.Parameters

 

Results will automatically populate once Channel is set.

Excel.Week.Grid.Results

 

You can change the TARPs colour coding settings as required.

Excel.Week.Grid.Change.TARPs.Colour.Coding

 

Changes will then be reflected in the results.

Excel.Week.Grid.Colour.Coding.Results

 

Change start time by using the drop down.

Excel.Week.Grid.Start.Time

 

Times and results will update to reflect the new start time.

Excel.Week.Grid.Changed.Start.Time.Results

 

 

The Zone Summary section will give you the average for that day and the time range entered under Zone Summary.

Excel.Week.Grid.Zone.Summary.Main

 

 

Change the Zone Summary start and end time using the drop down - note changing the start time on the week grid will not change the Zone Summary section.

Excel.Week.Grid.Zone.Summary.Change.Times

 

 

 


 

* Excel® is a registered trademark of Microsoft Corporation

Have more questions?

E-mail us: support@tvmap.com

or call us: +64 9 304 0762

 

 

©2025 Broadcast M.A.P. Limited.

All Rights Reserved.