6234.0 - Information Paper: Wage and Salary Earners, Public Sector, Australia, Changes to Time Series Spreadsheets, Mar 2005  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 16/06/2005   
   Page tools: Print Print Page Print all pages in this productPrint All

INTRODUCTION

This information paper provides an outline of changes to the Wage and Salary Earners, Public Sector, Australia (cat. no. 6248.0.55.001) 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 Wage and Salary Earners, Public Sector, Australia of the new spreadsheets in Microsoft Excel format (.xls) is attached to this Information Paper.

For the March 2005 issue of Wage and Salary Earners, Public Sector, Australia (cat. no. 6248.0.55.001) the AusStats Time Series Spreadsheets are provided in the usual Lotus 1-2-3 format (.wks).

From the June 2005 issue of Wage and Salary Earners, Public Sector, Australia (cat. no. 6248.0.55.001), due for release on 15 September 2005, the AusStats Time Series Spreadsheets will only be presented in Microsoft Excel format (.xls).

A concordance between the current AusStats tables (Lotus 1-2-3 .wks format) and the new tables (Microsoft Excel .xls 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:

  • Included in the spreadsheets are data relating to Standard Errors.
  • The presentation of the data has changed. For instance, time periods are represented by rows, and data items by columns.


CONCORDANCE

CURRENT AND NEW TABLES

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

Table No.DescriptionCurrent Lotus 1-2-3 file identifierNew Microsoft Excel file identifier from June 2005

Table 1.Wage and Salary Earners, Public Sector, States and Territories ('000)624801.wks6248055001_1.xls
Table 2.Wage and Salary Earners, Commonwealth Government, States and Territories ('000)624802.wks6248055001_2.xls
Table 3.Wage and Salary Earners, State Government, States and Territories ('000)624803.wks6248055001_3.xls
Table 4.Wage and Salary Earners, Local Government, States and Territories ('000)624804.wks6248055001_4.xls
Table 5.Gross Earnings, Level of Government, States and Territories ($m)624805.wks6248055001_5.xls
Table 6a.Wage and Salary Earners, Level of Government, Industry ('000)624806a.wks6248055001_6a.xls
Table 6b.Gross Earnings, Level of Government, Industry ($m)624806b.wks6248055001_6b.xls
Table 7a.Wage and Salary Earners, States and Territories, Industry ('000)624807a.wks6248055001_7a.xls
Table 7b.Gross Earnings, States and Territories, Industry ($m)624807b.wks6248055001_7b.xls