6308.0 - Information Paper: Average Weekly Earnings, Australia, Changes to Time Series Spreadsheets, Feb 2005  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 19/05/2005   
   Page tools: Print Print Page Print all pages in this productPrint All

INTRODUCTION

This information paper provides an outline of changes to the Average Weekly Earnings, Australia (cat. no. 6302.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.

For the February 2005 issue of Average Weekly Earnings, Australia (cat. no. 6302.0) the AusStats Time Series Spreadsheets are provided in the usual Lotus 1-2-3 format (.wks). A sample of the layout of the new Microsoft Excel format spreadsheets (.xls) is attached to this Information Paper.

From the May 2005 issue of Average Weekly Earnings, Australia (cat. no. 6302.0), due for release on 18 August 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 'original series' spreadsheets are data relating to Standard Errors.
  • New series showing states and territories by sector are presented (table numbers 14A to 14H, see concordance below).
  • The presentation of the data has also 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
identifier
Interim
Microsoft Excel file identifier February 2005
New
Microsoft Excel file identifier from May 2005
TABLE 1.Average Weekly Earnings, Australia (Dollars) - Trend630201.wks63080_1.xls63020_1.xls
TABLE 2.Average Weekly Earnings, Australia (Dollars) - Seasonally Adjusted630202.wks63080_2.xls63020_2.xls
TABLE 3.Average Weekly Earnings, Australia (Dollars) - Original630203.wks63080_3.xls63020_3.xls
TABLE 4.Average Weekly Earnings, Private Sector - Australia (Dollars) - Trend630204.wks63080_4.xls63020_4.xls
TABLE 5.Average Weekly Earnings, Private Sector - Australia (Dollars) - Seasonally Adjusted630205.wks63080_5.xls63020_5.xls
TABLE 6.Average Weekly Earnings, Private Sector - Australia (Dollars) - Original630206.wks63080_6.xls63020_6.xls
TABLE 7.Average Weekly Earnings, Public Sector - Australia (Dollars) - Trend630207.wks63080_7.xls63020_7.xls
TABLE 8.Average Weekly Earnings, Public Sector - Australia (Dollars) - Seasonally Adjusted630208.wks63080_8.xls63020_8.xls
TABLE 9.Average Weekly Earnings, Public Sector - Australia (Dollars) - Original630209.wks63080_9.xls63020_9.xls
TABLE 10A.Average Weekly Earnings, Industry, Australia (Dollars) - Original - Males,
Full Time Adult Ordinary Time Earnings
630210a.wks63080_10A.xls63020_10A.xls
TABLE 10B.Average Weekly Earnings, Industry, Australia (Dollars) - Original - Males,
Full Time Adult Total Earnings
630210b.wks63080_10B.xls63020_10B.xls
TABLE 10C.Average Weekly Earnings, Industry, Australia (Dollars) - Original - Males,
Total Earnings
630210c.wks63080_10C.xls63020_10C.xls
TABLE 10D.Average Weekly Earnings, Industry, Australia (Dollars) - Original - Females,
Full Time Adult Ordinary Time Earnings
630210d.wks63080_10D.xls63020_10D.xls
TABLE 10E.Average Weekly Earnings, Industry, Australia (Dollars) - Original - Females,
Full Time Adult Total Earnings
630210e.wks63080_10E.xls63020_10E.xls
TABLE 10F.Average Weekly Earnings, Industry, Australia (Dollars) - Original - Females,
Total Earnings
630210f.wks63080_10F.xls63020_10F.xls
TABLE 10G.Average Weekly Earnings, Industry, Australia (Dollars) - Original - Persons,
Full Time Adult Ordinary Time Earnings
630210g.wks63080_10G.xls63020_10G.xls
TABLE 10H.Average Weekly Earnings, Industry, Australia (Dollars) - Original - Persons,
Full Time Adult Total Earnings
630210h.wks63080_10H.xls63020_10H.xls
TABLE 10I.Average Weekly Earnings, Industry, Australia (Dollars) - Original - Persons,
Total Earnings
630210i.wks63080_10I.xls63020_10I.xls
TABLE 11A.Average Weekly Earnings, New South Wales (Dollars) - Trend630211a.wks63080_11A.xls63020_11A.xls
TABLE 11B.Average Weekly Earnings, Victoria (Dollars) - Trend630211b.wks63080_11B.xls63020_11B.xls
TABLE 11C.Average Weekly Earnings, Queensland (Dollars) - Trend630211c.wks63080_11C.xls63020_11C.xls
TABLE 11D.Average Weekly Earnings, South Australia (Dollars) - Trend630211d.wks63080_11D.xls63020_11D.xls
TABLE 11E.Average Weekly Earnings, Western Australia (Dollars) - Trend630211e.wks63080_11E.xls63020_11E.xls
TABLE 11F.Average Weekly Earnings, Tasmania (Dollars) - Trend630211f.wks63080_11F.xls63020_11F.xls
TABLE 11G.Average Weekly Earnings, Northern Territory (Dollars) - Trend630211g.wks63080_11G.xls63020_11G.xls
TABLE 11H.Average Weekly Earnings, Australian Capital Territory (Dollars) - Trend630211h.wks63080_11H.xls63020_11H.xls
TABLE 12A.Average Weekly Earnings, New South Wales (Dollars) - Seasonally Adjusted630212a.wks63080_12A.xls63020_12A.xls
TABLE 12B.Average Weekly Earnings, Victoria (Dollars) - Seasonally Adjusted630212b.wks63080_12B.xls63020_12B.xls
TABLE 12C.Average Weekly Earnings, Queensland (Dollars) - Seasonally Adjusted630212c.wks63080_12C.xls63020_12C.xls
TABLE 12D.Average Weekly Earnings, South Australia (Dollars) - Seasonally Adjusted630212d.wks63080_12D.xls63020_12D.xls
TABLE 12E.Average Weekly Earnings, Western Australia (Dollars) - Seasonally Adjusted630212e.wks63080_12E.xls63020_12E.xls
TABLE 12F.Average Weekly Earnings, Tasmania (Dollars) - Seasonally Adjusted630212f.wks63080_12F.xls63020_12F.xls
TABLE 12G.Average Weekly Earnings, Northern Territory (Dollars) - Seasonally Adjusted630212g.wks63080_12G.xls63020_12G.xls
TABLE 12H.Average Weekly Earnings, Australian Capital Territory (Dollars) - Seasonally Adjusted630212h.wks63080_12H.xls63020_12H.xls
TABLE 13A.Average Weekly Earnings, New South Wales (Dollars) - Original630213a.wks63080_13A.xls63020_13A.xls
TABLE 13B.Average Weekly Earnings, Victoria (Dollars) - Original630213b.wks63080_13B.xls63020_13B.xls
TABLE 13C.Average Weekly Earnings, Queensland (Dollars) - Original630213c.wks63080_13C.xls63020_13C.xls
TABLE 13D.Average Weekly Earnings, South Australia (Dollars) - Original630213d.wks63080_13D.xls63020_13D.xls
TABLE 13E.Average Weekly Earnings, Western Australia (Dollars) - Original630213e.wks63080_13E.xls63020_13E.xls
TABLE 13F.Average Weekly Earnings, Tasmania (Dollars) - Original630213f.wks63080_13F.xls63020_13F.xls
TABLE 13G.Average Weekly Earnings, Northern Territory (Dollars) - Original630213g.wks63080_13G.xls63020_13G.xls
TABLE 13H.Average Weekly Earnings, Australian Capital Territory (Dollars) - Original630213h.wks63080_13H.xls63020_13H.xls
TABLE 14A.Average Weekly Earnings, Private and Public Sectors, New South Wales (Dollars) - Original - Personsnot available63080_14A.xls63020_14A.xls
TABLE 14B.Average Weekly Earnings, Private and Public Sectors, Victoria (Dollars) -
Original - Persons
not available63080_14B.xls63020_14B.xls
TABLE 14C.Average Weekly Earnings, Private and Public Sectors, Queensland (Dollars) - Original - Personsnot available63080_14C.xls63020_14C.xls
TABLE 14D.Average Weekly Earnings, Private and Public Sectors, South Australia
(Dollars) - Original - Persons
not available63080_14D.xls63020_14D.xls
TABLE 14E.Average Weekly Earnings, Private and Public Sectors, Western Australia (Dollars) - Original - Personsnot available63080_14E.xls63020_14E.xls
TABLE 14F.Average Weekly Earnings, Private and Public Sectors, Tasmania (Dollars) - Original - Personsnot available63080_14F.xls63020_14F.xls
TABLE 14G.Average Weekly Earnings, Private and Public Sectors, Northern Territory
(Dollars) - Original - Persons
not available63080_14G.xls63020_14G.xls
TABLE 14H.Average Weekly Earnings, Private and Public Sectors, Australian Capital
Territory (Dollars) - Original - Persons
not available63080_14H.xls63020_14H.xls


INQUIRIES

For further information contact Manpreet Singh on (08) 9360 5304 or by email manpreet.singh@abs.gov.au.