6401.0.55.001 - Information Paper: Changes to Time Series Spreadsheets for Consumer Price Index, Australia, Feb 2006  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 03/03/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 Consumer Price Index, Australia (cat. no. 6401.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 December quarter 2005, comparable to that released on 25 January 2006.


These changes are due to come into effect with the release of the March quarter 2006 issue of 6401.0 on 26 April 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
  • providing access to time series for CPI expenditure class index numbers by capital city that were previously only available as single quarter data cubes
  • 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 or related statistics, contact Steve Whennan on (02) 6252 6251, or email <steve.whennan@abs.gov.au>.


CONCORDANCE BETWEEN CURRENT AND PROPOSED TABLES

Below is a concordance between the current Lotus 1-2-3 .wks time series spreadsheet tables and the proposed new Excel .xls time series spreadsheet tables.

Current Tables
New Tables
.wks Table no.Current Table Name.xls Table no.New Table Name
640101TABLE 1. CPI: All Groups, Index Numbers (Quarterly)640101TABLES 1 and 2. CPI: All Groups, Index Numbers and Percentage Changes
640102TABLE 2. CPI: All Groups, Percentage Changes (Quarter)640101TABLES 1 and 2. CPI: All Groups, Index Numbers and Percentage Changes
640103TABLE 3. CPI: Groups, Weighted Average of Eight Capital Cities, Index Numbers (Quarterly)640102TABLES 3 and 4. CPI: Groups, Weighted Average of Eight Capital Cities, Index Numbers and Percentage Changes
640104TABLE 4. CPI: Groups, Weighted Average of Eight Capital Cities, Percentage Changes (Quarter)640102TABLES 3 and 4. CPI: Groups, Weighted Average of Eight Capital Cities, Index Numbers and Percentage Changes
640105TABLE 5. CPI: Groups, Index Numbers (Quarterly)640103TABLE 5. CPI: Groups, Sub-groups and Expenditure Class, Index Numbers by Capital City
640106ATABLE 6A. CPI: Food, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106BTABLE 6B. CPI: Alcohol and tobacco, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106CTABLE 6C. CPI: Clothing and footwear, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106DTABLE 6D. CPI: Housing, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106ETABLE 6E. CPI: Household contents and services, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106FTABLE 6F. CPI: Health, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106GTABLE 6G. CPI: Transportation, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106HTABLE 6H. CPI: Communication, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106ITABLE 6I. CPI: Recreation, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106JTABLE 6J. CPI: Education, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106KTABLE 6K. CPI: Financial and insurance services, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640106LTABLE 6L. CPI: All groups, Contribution to Change in All Groups Indexes (Quarterly)640104TABLES 6A to 6L. CPI: Group, Sub-group and Expenditure Class Contribution to Change in All Groups Indexes, by Capital City
640107ATABLE 7A. CPI: Food, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107BTABLE 7B. CPI: Alcohol and tobacco, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107CTABLE 7C. CPI: Clothing and footwear, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107DTABLE 7D. CPI: Housing, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107ETABLE 7E. CPI: Household contents and services, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107FTABLE 7F. CPI: Health, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107GTABLE 7G. CPI: Transportation, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107HTABLE 7H. CPI: Communication, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107ITABLE 7I. CPI: Recreation, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107JTABLE 7J. CPI: Education, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107KTABLE 7K. CPI: Financial and insurance services, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640107LTABLE 7L. CPI: All groups, Weighted Average of Eight Capital Cities640105TABLES 7A to 7L. CPI: Groups, Sub-groups and Expenditure Class, Weighted Average of Eight Capital Cities
640108TABLE 8. CPI: Special Series, Weighted Average of Eight Capital Cities (Quarter)640106TABLE 8. CPI: Special Series, Weighted Average of Eight Capital Cities
640109TABLE 9. CPI: Analytical Series, Index Numbers (Quarter)640107TABLES 9 and 10. CPI: Analytical Series, Index Numbers and Percentage Changes
640110TABLE 10. CPI: Analytical Series, Percentage Changes640107TABLES 9 and 10. CPI: Analytical Series, Index Numbers and Percentage Changes
640111TABLE 11. CPI: International Comparisons, All Groups Excluding Housing and Financial and insurance services, Index Numbers (Quarterly)640108TABLES 11 and 12. CPI: International Comparisons, All Groups Excluding Housing and Financial and insurance services, Index Numbers and Percentage Changes
640112TABLE 12. CPI: International Comparisons, All Groups Excluding Housing and Financial and insurance services, Percentage Changes (Quarter)640108TABLES 11 and 12. CPI: International Comparisons, All Groups Excluding Housing and Financial and insurance services, Index Numbers and Percentage Changes
640109TABLE 13. CPI: Groups, Sub-groups and Expenditure Class, Index Numbers by Capital City