Australian Bureau of Statistics

Rate the ABS website
ABS Home > Statistics > By Catalogue Number
6364.0 - Information Paper: Job Vacancies, Australia, Changes to Time Series Spreadsheets, May 2005  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 30/06/2005   
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product

INTRODUCTION

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


CHANGE TO MICROSOFT EXCEL FORMAT

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).


CHANGES TO SPREADSHEET CONTENT

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.


CONCORDANCE

NEW AND CURRENT TABLES

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


Bookmark and Share. Opens in a new window

Commonwealth of Australia 2014

Unless otherwise noted, content on this website is licensed under a Creative Commons Attribution 2.5 Australia Licence together with any terms, conditions and exclusions as set out in the website Copyright notice. For permission to do anything beyond the scope of this licence and copyright terms contact us.