3107.0.55.004 - Information Paper: Population Projections, Australia, New Format Time Series Spreadsheets, 2004 to 2101  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 24/11/2005   
   Page tools: Print Print Page Print all pages in this productPrint All

This information paper provides an outline of the format changes to be made to the Population Projections, Australia (cat. no. 3222.0) AusStats Time Series Spreadsheets from the June 2004 to June 2101 issue onwards, released 29 November 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 2004 to June 2101 issue of Population Projections, Australia (cat. no. 3222.0), released 29 November 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 Population Projections, Australia (cat. no. 3222.0) AusStats Time Series Spreadsheets, please refer to this information paper's associated Time Series Spreadsheets.

For further information contact Matthew Montgomery on (02) 6252 6487 or by email matthew.montgomery@abs.gov.au.