MAIN FEATURES
This information paper summaries format changes to be made to the Population by Age and Sex, Australian States and Territories (cat. no. 3201.0) Time Series Spreadsheets from the June 2005 issue onwards, released 15 December 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. With the next issue of Population by Age and Sex, Australian States and Territories (cat. no. 3201.0) on 15 December 2005, the AusStats Time Series Spreadsheets will be presented in Excel format (.xls). This will replace AusStats Time Series Spreadsheets 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 are presented rows and data items columns.
For 'mock-ups' of the new format Population by Age and Sex, Australian States and Territories (cat. no. 3201.0) AusStats Time Series Spreadsheets, please refer to this information paper's associated Time Series Spreadsheets.
For further information contact Rachael Hill (02) 6252 6296 or rachael.hill@abs.gov.au