6364.0 - Information Paper: Job Vacancies, Australia, Changes to Time Series Spreadsheets, May 2005  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 30/06/2005   
   Page tools: Print Print Page Print all pages in this productPrint All


This information paper provides an outline of changes to the Job Vacancies, Australia (cat. no. 6354.0) AusStats Time Series Spreadsheets.


The Australian Bureau of Statistics (ABS) has introduced a new method of presenting time series data to the AusStats service. The Lotus 1-2-3 time series spreadsheets are being replaced with Microsoft Excel spreadsheets. A sample of the layout for Job Vacancies, Australia of the new spreadsheets in Microsoft Excel format (.xls) is attached to this Information Paper.

For the May 2005 issue of Job Vacancies, Australia (cat. no. 6354.0), the AusStats Time Series Spreadsheets are provided in the usual Lotus 1-2-3 format (.wks).

From the August 2005 issue of Job Vacancies, Australia (cat. no. 6354.0), due for release on 29 September 2005, the AusStats Time Series Spreadsheets will only be presented in Microsoft Excel format (.xls).

A concordance between the new tables (Microsoft Excel .xls format) and the current AusStats tables (Lotus 1-2-3 .wks format) is included below.

The Microsoft 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, some of the content of the spreadsheets has changed. These changes apply to the data provided in Microsoft Excel format only:

  • Table numbering has been changed to agree with the table numbering in the Job Vacancies, Australia publication (cat. no. 6354.0).
  • Consistent with the other spreadsheets, data relating to Standard Errors has been included in the 'Job Vacancies, Industry, Australia', (Table 4) spreadsheet.
  • The presentation of the data has changed. For instance, time periods are represented by rows and data items by columns.



Below is a concordance between the new tables in Microsoft Excel format and the current AusStats tables in Lotus 1-2-3 format.

New Table No.Current Table No.DescriptionNew Excel file identifier from August 2005Interim Excel file identifier for sample spreadsheetsCurrent Lotus 1-2-3 file identifier

TABLE 1.TABLE 1C.Job Vacancies, States and Territories ('000)63540_1.xls63640_1.xls635401c.wks
TABLE 2.TABLE 1A.Job Vacancies, Private Sector, States and Territories ('000)63540_2.xls63640_2.xls635401a.wks
TABLE 3.TABLE 1B.Job Vacancies, Public Sector, States and Territories ('000)63540_3.xls63640_3.xls635401b.wks
TABLE 4.TABLE 2.Job Vacancies, Industry, Australia ('000) - Original63540_4.xls63640_4.xls635402.wks