5206.0.55.001 - Information Paper: Changes to Spreadsheets for the Quarterly Australian National Accounts, Mar 2006  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 09/06/2006   
   Page tools: Print Print Page Print all pages in this productPrint All

NOTES

This is an updated version of the 11 May 2006 release of this information paper incorporating user comments regarding the proposed changes to the time series spreadsheets associated with the publication Australian National Accounts: National Income, Expenditure and Product (cat. no. 5206.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 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 March quarter 2006, comparable to that released on 7th June 2006.

These changes are due to come into effect with the release of the June quarter 2006 issue of 5206.0 on 6th September 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, the most significant of which is the use of a unique identifier for each series. This allows clients to reliably extract series using the unique identifier rather than column and rows based macros. Other features of the Excel format include:

    • 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

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 or related statistics, 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
1Key National Accounts Aggregates, Australia1Key National Accounts Aggregates: Trend
2Key National Accounts Aggregates: Seasonally adjusted
49Key National Accounts Aggregates: Original
2Expenditure on Gross Domestic Product (GDP), Australia, Chain volume measures4Expenditure on GDP, Chain volume measures: Trend
5Expenditure on GDP, Chain volume measures – Percentage changes: Trend
6Expenditure on GDP, Chain volume measures: Seasonally adjusted
7Expenditure on GDP, Chain volume measures – Percentage changes: Seasonally adjusted
8Expenditure on GDP, Chain volume measures – Contributions to growth: Seasonally adjusted
46Expenditure on GDP, Chain volume measures – Revisions to percentage changes: Seasonally adjusted
50Expenditure on GDP, Chain volume measures: Original
3Expenditure on Gross Domestic Product (GDP), Australia, Current prices9Expenditure on GDP, Current prices: Seasonally adjusted
47Gross domestic product components, Current prices- Revisions: Seasonally adjusted
51Expenditure on GDP, Current prices: Original
108Expenditure on GDP, Current prices: Trend
4Expenditure on Gross Domestic Product (GDP), Australia, Chain price indexes10Expenditure on GDP, Chain price indexes: Original
11Expenditure on GDP, Chain price indexes – Percentage changes: Original
5Expenditure on Gross Domestic Product (GDP), Australia, Implicit price deflators12Expenditure on GDP, Implicit price deflators: Seasonally adjusted
13Expenditure on GDP, Implicit price deflators – Percentage changes: Seasonally adjusted
6Gross Value Added by Industry, Australia, Chain volume measures14Industry gross value added, Chain volume measures: Trend
15Industry gross value added, Chain volume measures – Percentage changes: Trend
16Industry gross value added, Chain volume measures: Seasonally adjusted
17Industry gross value added, Chain volume measures – Percentage changes: Seasonally adjusted
48Industry gross value added, Chain volume measures – Revisions to percentage changes: Seasonally adjusted
54Industry gross value added, Chain volume measures: Original
55Industry gross value added, Chain volume measures—Contributions to growth: Seasonally adjusted
7Income from Gross Domestic Product (GDP), Australia, Current prices18Income from GDP, Current prices: Trend
19Income from GDP, Current prices: Seasonally adjusted
56Income from GDP, Current prices: Original
8Household Final Consumption Expenditure (HFCE), Australia20Household final consumption expenditure, Chain volume measures: Trend
21Household final consumption expenditure, Chain volume measures: Seasonally adjusted
57Household final consumption expenditure, Chain volume measures: Original
58Household final consumption expenditure, Current prices: Trend, seasonally adjusted and original
9Changes in inventories, Australia22Changes in inventories, Chain volume measures: Trend and seasonally adjusted
59Changes in inventories, Chain volume measures: Original
60Changes in inventories, Current prices: Trend, seasonally adjusted and original
10Agricultural Income, Australia, Current prices23Agricultural income, Current prices: Trend and seasonally adjusted
61Agricultural income, Current prices: Original
11National Income Account, Australia, Current prices32National income account, Current prices: Original
62National income account, Current prices: Trend and seasonally adjusted
12National Capital Account, Australia, Current prices33National capital account, Current prices: Trend and seasonally adjusted
64National capital account, Current prices: Original
13External Account, Australia, Current prices34External accounts, Current prices: Trend and seasonally adjusted
66External accounts, Current prices: Original
14Household Income Account, Australia, Current prices35Household income account, Current prices: Trend
36Household income account, Current prices: Seasonally adjusted
68Household income account, Current prices: Original
15General Government Income Account, Australia, Current prices37General government income account, Current prices: Trend
38General government income account, Current prices: Seasonally adjusted
69General government income account, Current prices: Original
16National General Government Income Account, Australia, Current prices70National general government income account, Current prices: Original
17State and Local General Government Income Account, Australia, Current prices71State and local general government income account, Current prices: Original
18Taxes, Australia, Current prices39Taxes, Current prices: Trend and seasonally adjusted
72Taxes, Current prices: Original
19Social Assistance Benefits Payments, Australia, Current prices73Social assistance benefit payments, Current prices: Original
20Selected Analytical Series, Australia40Selected analytical series: Trend
41Selected analytical series: Seasonally adjusted
74Selected analytical series: Original
21State Final Demand, Summary Components by State, Chain volume measures24State final demand, Chain volume measures: Trend and seasonally adjusted - New South Wales
25State final demand, Chain volume measures: Trend and seasonally adjusted - Victoria
26State final demand, Chain volume measures: Trend and seasonally adjusted - Queensland
27State final demand, Chain volume measures: Trend and seasonally adjusted - South Australia
28State final demand, Chain volume measures: Trend and seasonally adjusted - Western Australia
29State final demand, Chain volume measures: Trend and seasonally adjusted - Tasmania
30State final demand, Chain volume measures: Trend and seasonally adjusted - Northern Territory
31State final demand, Chain volume measures: Trend and seasonally adjusted - Australian Capital Territory
22State Final Demand, Detailed Components, New South Wales76Components of state final demand: Trend
84Components of state final demand: Seasonally adjusted
92Components of state final demand – Revisions to percentage changes: Seasonally adjusted
100Components of state final demand: Original
23State Final Demand, Detailed Components, Victoria77Components of state final demand: Trend
85Components of state final demand: Seasonally adjusted
93Components of state final demand – Revisions to percentage changes: Seasonally adjusted
101Components of state final demand: Original
24State Final Demand, Detailed Components, Queensland78Components of state final demand: Trend
86Components of state final demand: Seasonally adjusted
94Components of state final demand – Revisions to percentage changes: Seasonally adjusted
102Components of state final demand: Original
25State Final Demand, Detailed Components, South Australia79Components of state final demand: Trend
87Components of state final demand: Seasonally adjusted
95Components of state final demand – Revisions to percentage changes: Seasonally adjusted
103Components of state final demand: Original
26State Final Demand, Detailed Components, Western Australia80Components of state final demand: Trend
88Components of state final demand: Seasonally adjusted
96Components of state final demand – Revisions to percentage changes: Seasonally adjusted
104Components of state final demand: Original
27State Final Demand, Detailed Components, Tasmania81Components of state final demand: Trend
89Components of state final demand: Seasonally adjusted
97Components of state final demand – Revisions to percentage changes: Seasonally adjusted
105Components of state final demand: Original
28State Final Demand, Detailed Components, Northern Territory82Components of state final demand: Trend
90Components of state final demand: Seasonally adjusted
98Components of state final demand – Revisions to percentage changes: Seasonally adjusted
106Components of state final demand: Original
29State Final Demand, Detailed Components, Australian Capital Territory83Components of state final demand: Trend
91Components of state final demand: Seasonally adjusted
99Components of state final demand – Revisions to percentage changes: Seasonally adjusted
107Components of state final demand: Original
30Key aggregates & analytical series: Annual3Key National Accounts Aggregates: Annual
75Selected analytical series: Annual
31Income from GDP: Annual44Income from GDP, Current prices: Annual
32Expenditure on GDP: Annual42Expenditure on GDP, Chain volume measures: Annual
43Expenditure on GDP, Current prices: Annual
52Expenditure on GDP, Chain price indexes: Annual
53Expenditure on GDP, Implicit price deflators: Annual
33Industry gross value added: Annual45Industry gross value added, Chain volume measures: Annual
34National income account: Annual63National income account, Current prices: Annual
35National capital account: Annual65National capital account, Current prices: Annual
36External account: Annual67External accounts, Current prices: Annual