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.
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.||Description||Current Lotus 1-2-3 file identifier||New Microsoft Excel file identifier from June 2005|
|Table 1.||Wage and Salary Earners, Public Sector, States and Territories ('000)||624801.wks||6248055001_1.xls|
|Table 2.||Wage and Salary Earners, Commonwealth Government, States and Territories ('000)||624802.wks||6248055001_2.xls|
|Table 3.||Wage and Salary Earners, State Government, States and Territories ('000)||624803.wks||6248055001_3.xls|
|Table 4.||Wage and Salary Earners, Local Government, States and Territories ('000)||624804.wks||6248055001_4.xls|
|Table 5.||Gross Earnings, Level of Government, States and Territories ($m)||624805.wks||6248055001_5.xls|
|Table 6a.||Wage and Salary Earners, Level of Government, Industry ('000)||624806a.wks||6248055001_6a.xls|
|Table 6b.||Gross Earnings, Level of Government, Industry ($m)||624806b.wks||6248055001_6b.xls|
|Table 7a.||Wage and Salary Earners, States and Territories, Industry ('000)||624807a.wks||6248055001_7a.xls|
|Table 7b.||Gross Earnings, States and Territories, Industry ($m)||624807b.wks||6248055001_7b.xls|