This information paper provides an outline of the format changes to be made to the Short-term Visitor Arrival Estimates, Australia (cat. no. 3401.0.55.001) AusStats Time Series Spreadsheets from June 2005, to be released on 14 July 2005. This paper also provides 'mock-ups' of the new file format.
PRESENTING TIME SERIES IN EXCEL FORMAT
The Australian Bureau of Statistics (ABS) has introduced a new method of presenting time series data to the AusStats service. From the June 2005 issue of Short-term Visitor Arrival Estimates, Australia (cat. no. 3401.0.55.001), released 14 July 2005, the AusStats Time Series Spreadsheets will be presented in Excel format (.xls). This will replace the AusStats Time Series Spreadsheets that are currently provided in Lotus 1-2-3 (.WKS).
The Excel spreadsheets offer clearer presentation, simpler data navigation and retrieval, and enhanced metadata content over the Lotus 1-2-3 spreadsheets. The new format files can be opened, read and manipulated using Excel 5.0/95 (or equivalent), however, some features will not be available unless you have Excel 97 (or a later version).
In addition to the file format change, the presentation of the data will also change. For instance, time periods will be presented in the rows and data items in the columns.
For 'mock-ups' of the new format Short-term Visitor Arrival Estimates, Australia (cat. no. 3401.0.55.001) AusStats Time Series Spreadsheets, please refer to this information paper's associated Time Series Spreadsheets.
For further information contact Anne Ward on (02) 6252 6871 or by email email@example.com.
This page last updated 2 June 2011