• Share this page to Facebook
  • Share this page to Twitter
  • Share this page to Google+
Archived Accommodation Survey pivot tables

Archived pivot tables – July 1996 to August 2009

The following tables contain data up to August 2009, before the survey change in September 2009. The tables contain data based on 1996 regional tourism organisation (RTO) boundaries and still include the 'hosted' accommodation type.

excel icon. Regional Tourism Organisation (RTO) Area by Accommodation Type (Type): August 2009 (Excel, 25.1MB)

excel icon. Origin of Guests and Employment Information by Regional Tourism Organisation (RTO): August 2009 (Excel, 20.1MB)

excel icon. Territorial Authority (TA) by Total Accommodation: August 2009 (Excel, 1.2MB)

Latest pivot tables

See Accommodation Survey information releases to view the latest pivot tables, which have data from the early 2000s.

From the page, select the latest month, then go to the 'Downloads' box on the page.

We usually publish information releases and pivot tables by the 12th of the month, except January when we publish by about the 20th.

Types of pivot tables

RTO and accommodation type

Previously called Regional Tourism Organisation (RTO) Area by Accommodation Type (Type).

Contains the number of establishments, capacity, occupancy rates, guest nights, guest arrivals, length of stay, and some ratios of these variables.

The graph on the 'Guest nights graph' worksheet changes according to the RTO and accommodation type selected on the worksheet to its right.

RTO and origin

Previously called Origin of Guests and Employment Information by Regional Tourism Organisation (RTO).

Contains domestic and international guest night variables.

Territorial authority area

Previously called Territorial Authority (TA) by Total Accommodation.

Contains the number of establishments, capacity, guest nights, guest arrivals, length of stay, occupancy rates, and some ratios of these variables.

Other information

Infoshare

Most of the statistics in the pivot tables are also available from Infoshare.

Problems opening files

If you problems viewing the pivot tables or files, see opening files and PDFs.

Using the pivot tables

Click on the shaded boxes in cell B1, B2, or B3 and select the desired region, territorial authority, or accommodation type. Do not use 'All' in any drop-down menu as 'All' includes every category including 'Total' and is therefore larger than the total.

Printing a selection of data in a spreadsheet

If you only want to print out some of the information in a spreadsheet, either select the pages you want in the print box, or hide the data you don't want to print by highlighting the columns or rows of data you don't want; then right-mouse-click and select 'Hide'.

  • Share this page to Facebook
  • Share this page to Twitter
  • Share this page to Google+
Top
  • Share this page to Facebook
  • Share this page to Twitter
  • Share this page to Google+