Accommodation pivot tables

The Accommodation pivot tables are released at the same time as the Accommodation Survey Hot Off The Press monthly information releases. The Accommodation Survey information is normally updated by the 12th day of the month, except January when it is updated about the 20th.

Latest update for April 2009 month:

Regional Tourism Organisation (RTO) Area by Accommodation Type (Type): April 2009.xls (14.98MB)

Territorial Authority (TA) by Total Accommodation: April 2009.xls (1.17MB) 

Origin of Guests and Employment Information by Regional Tourism Organisation (RTO):April.xls (12.63MB)

Accommodation pivot tables

The Accommodation pivot tables provide more detailed information, breaking the survey variables down by regional tourism organisation areas and territorial authority areas.

These pivot tables are in Excel 97 format. If you do not have access to Excel 97 or higher, you may use the Excel file viewer to view, print and export the contents of the file.

Note: To use the pivot tables, click on the shaded boxes in cell B1 or B2 and select the desired Regional Tourism Organisation (RTO), Territorial Authority (TA) or Accommodation Type (Type). Do not use 'All' in the RTO, TA or Type drop-down menus as 'All' includes every category including 'Total' and is therefore larger than the total.

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 first worksheet will change to display the RTO and Type you select on the second worksheet. When printing the graph, select a cell rather than the graph so the heading will print.
 

Territorial Authority (TA) by Total Accommodation

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

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

Contains domestic and international guest night variables and employment information.
 

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 click the mouse and select 'Hide'.