5220.0.55.001 - Information Paper: Changes to spreadsheets for the Annual State Accounts, 2004-2005  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 30/08/2006  First Issue
   Page tools: Print Print Page Print all pages in this productPrint All

NOTES

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
.xls
Table no.
New Table Name
.wks
Table 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
44
Expenditure components of gross state product, New South Wales – Chain volume measures: Revisions to percentage changes
52
Total factor income by industry, New South Wales – Current prices: Revisions
3
Expenditure and Income Components of Gross State Product, Victoria, Chain volume measures and current prices
7
Expenditure components of gross state product, Victoria –
Chain volume measures
8
Expenditure components of gross state product, Victoria –
Current prices
23
Income components of gross state product, Current prices
(Victoria data)
25
Total factor income by industry and principal components, Victoria –
Current prices
45
Expenditure components of gross state product, Victoria – Chain volume measures: Revisions to percentage changes
53
Total factor income by industry, Victoria – Current prices: Revisions
4
Expenditure and Income Components of Gross State Product, Queensland, Chain volume measures and current prices
9
Expenditure components of gross state product, Queensland –
Chain volume measures
10
Expenditure components of gross state product, Queensland –
Current prices
23
Income components of gross state product, Current prices
(Queensland data)
26
Total factor income by industry and principal components, Queensland –
Current prices
46
Expenditure components of gross state product, Queensland – Chain volume measures: Revisions to percentage changes
54
Total factor income by industry, Queensland – Current prices: Revisions
5
Expenditure and Income Components of Gross State Product, South Australia, Chain volume measures and current prices
11
Expenditure components of gross state product, South Australia –
Chain volume measures
12
Expenditure components of gross state product, South Australia –
Current prices
23
Income components of gross state product, Current prices
(South Australia data)
27
Total factor income by industry and principal components, South Australia –
Current prices
47
Expenditure components of gross state product, South Australia – Chain volume measures: Revisions to percentage changes
55
Total factor income by industry, South Australia – Current prices: Revisions
6
Expenditure and Income Components of Gross State Product, Western Australia, Chain volume measures and current prices
13
Expenditure components of gross state product, Western Australia –
Chain volume measures
14
Expenditure components of gross state product, Western Australia –
Current prices
23
Income components of gross state product, Current prices
(Western Australia data)
28
Total factor income by industry and principal components, Western Australia – Current prices
48
Expenditure components of gross state product, Western Australia – Chain volume measures: Revisions to percentage changes
56
Total factor income by industry, Western Australia – Current prices: Revisions
7
Expenditure and Income Components of Gross State Product, Tasmania, Chain volume measures and current prices
15
Expenditure components of gross state product, Tasmania –
Chain volume measures
16
Expenditure components of gross state product, Tasmania –
Current prices
23
Income components of gross state product, Current prices
(Tasmania data)
29
Total factor income by industry and principal components, Tasmania – Current prices
49
Expenditure components of gross state product, Tasmania – Chain volume measures: Revisions to percentage changes
57
Total factor income by industry, Tasmania – Current prices: Revisions
8
Expenditure and Income Components of Gross State Product, Northern Territory, Chain volume measures and current prices
17
Expenditure components of gross state product, Northern Territory –
Chain volume measures
18
Expenditure components of gross state product, Northern Territory –
Current prices
23
Income components of gross state product, Current prices
(Northern Territory data)
30
Total factor income by industry and principal components, Northern Territory – Current prices
50
Expenditure components of gross state product, Northern Territory – Chain volume measures: Revisions to percentage changes
58
Total factor income by industry, Northern Territory – Current prices: Revisions
9
Expenditure and Income Components of Gross State Product, Australian Capital Territory, Chain volume measures and current prices
19
Expenditure components of gross state product, Australian Capital Territory – Chain volume measures
20
Expenditure components of gross state product, Australian Capital Territory – Current prices
23
Income components of gross state product, Current prices
(Australian Capital Territory data)
31
Total factor income by industry and principal components, Australian Capital Territory – Current prices
51
Expenditure components of gross state product, Australian Capital Territory – Chain volume measures: Revisions to percentage changes
59
Total factor income by industry, Australian Capital Territory – Current prices: Revisions
10
Expenditure and Income Components of Gross State Product, Australia, Chain volume measures and current prices
21
Expenditure components of gross state product, Australia – Chain volume measures
22
Expenditure components of gross state product, Australia – Current prices
23
Income components of gross state product, Current prices
(Australia data)
32
Total factor income by industry and principal components, Australia – Current prices
11
Household Income Account and Per Capita, New South Wales: Current prices
33
Gross household income and gross household disposable income, Current prices (New South Wales data)
34
Household income account, New South Wales – Current prices
12
Household Income Account and Per Capita, Victoria: Current prices
33
Gross household income and gross household disposable income, Current prices (Victoria data)
35
Household income account, Victoria – Current prices
13
Household Income Account and Per Capita, Queensland: Current prices
33
Gross household income and gross household disposable income, Current prices (Queensland data)
36
Household income account, Queensland – Current prices
14
Household Income Account and Per Capita, South Australia: Current prices
33
Gross household income and gross household disposable income, Current prices (South Australia data)
37
Household income account, South Australia– Current prices
15
Household Income Account and Per Capita, Western Australia: Current prices
33
Gross household income and gross household disposable income, Current prices (Western Australia data)
38
Household income account, Western Australia– Current prices
16
Household Income Account and Per Capita, Tasmania: Current prices
33
Gross household income and gross household disposable income, Current prices (Tasmania data)
39
Household income account, Tasmania – Current prices
17
Household Income Account and Per Capita, Northern Territory: Current prices
33
Gross household income and gross household disposable income, Current prices (Northern Territory data)
40
Household income account, Northern Territory – Current prices
18
Household Income Account and Per Capita, Australian Capital Territory: Current prices
33
Gross household income and gross household disposable income, Current prices (Australian Capital Territory data)
41
Household income account, Australian Capital Territory – Current prices
19
Household Income Account and Per Capita, Australia: Current prices
33
Gross household income and gross household disposable income, Current prices (Australia data)
42
Household income account, Australia – Current prices
20
Agricultural Income, All States: Current prices
43
Agricultural income, Current prices