This information paper advises users of proposed changes to the time series spreadsheets associated with the publication Australian National Accounts: State Accounts (cat. no. 5220.0), resulting from the conversion of the current Lotus 1-2-3 .wks spreadsheets to Excel .xls format.

A concordance between the current time series spreadsheet tables (Lotus 1-2-3 .wks format) and the proposed new tables (in Excel .xls format) is included below.

Also provided under the 'Details' tab are copies of the new tables providing time series up to and including data for 2004–2005. These changes are due to come into effect with the release of the 2005–2006 issue of 5220.0 on the 8th November 2006. From that date, the current Lotus 1-2-3 .wks spreadsheets will be discontinued.

The new product provides a range of benefits for time series clients including:

combining some existing tables thus reducing the number of individual tables that may need to accessed

consistent and complete series metadata is provided for every series displayed

a readily recognised file format (Excel) that will 'auto launch' in most business IT environments

built in features on which clients can base reliable processing systems.

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

For further information or if you have any queries about the change contact Terry Rawnsley on (02) 6252 6711, or email <terry.rawnsley@abs.gov.au>.

New Tables

Current Tables

.xlsTable no.

New Table Name

.wksTable no.

Current Table Name

1

Gross state product, Chain volume measures and current prices

1

Gross state product, Chain volume measures

2

Real gross state income, Chain volume measures

3

Gross state product, Current prices

4

Gross state product per capita, Current prices

2

Expenditure and Income Components of Gross State Product, New South Wales, Chain volume measures and current prices

5

Expenditure components of gross state product, New South Wales – Chain volume measures

6

Expenditure components of gross state product, New South Wales – Current prices

23

Income components of gross state product, Current prices(New South Wales data)

24

Total factor income by industry and principal components, New South Wales – Current prices