6457.0.55.001 - Information Paper: Changes to Time Series Spreadsheets for International Trade Price Indexes, 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 International Trade Price Indexes, Australia (cat. no. 6457.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 20 January 2006.


These changes are due to come into effect with the release of the March quarter 2006 issue of 6457.0 on 21 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 a number of index series that were previously only available as unpublished data on request
  • 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
645701Table 1. Import Price Index: Index numbers and percentage changes645701Tables 1, 3 and 12. Import Price Index by SITC, Index Numbers and Percentage Changes
645703Table 3. Import Price Index , By SITC Section645701Tables 1, 3 and 12. Import Price Index by SITC, Index Numbers and Percentage Changes
645704Table 4. Import Price Index, By BEC End Use Class and Broad Balance of Payments Categories Index Numbers645703Tables 4, 5 and 6. Import Price Index by BEC End Use Class and Broad Balance of Payments Categories, Index Numbers
645707Table 7. Export Price Index : All groups index numbers and percentage changes645704Tables 7 and 9. Export Price Index by SITC, Index Numbers and Percentage Changes
645709Table 9. Export Price Index, By Selected SITC section645704Tables 7 and 9. Export Price Index by SITC, Index Numbers and Percentage Changes
6457010Table 10. Export Price Index, By Balance of Payments Groups Index Numbers645705Tables 10 and 11. Export Price Index by Balance of Payments Groups, Index Numbers
6457012Table 12. Import Price Index, By Selected SITC Division645701Tables 1, 3 and 12. Import Price Index by SITC, Index Numbers and Percentage Changes
6457013Table 13. Import Price Index , By Selected HTISC Section645706Table 13. Import Price Index by Selected HTISC Section, Index Numbers
6457014Table 14. Import Price Index , By Selected ANZSIC Industry of Origin Division645707Tables 14 and 15. Import Price Index by Selected ANZSIC Industry of Origin, Index Numbers
6457015Table 15. Import Price Index, By Selected ANZSIC Industry of Origin Subdivision645707Tables 14 and 15. Import Price Index by Selected ANZSIC Industry of Origin, Index Numbers
6457016Table 16. Import Price Index , By BEC Category645709Table 16. Import Price Index: BEC category, Index Numbers
6457018Table 18. Export Price Index, By Selected AHECC Section6457010Table 18. Export Price Index by Selected AHECC Section, Index Numbers
6457019Table 19. Export Price Index, By Selected ANZSIC Industry of Origin Division and Subdivision6457011Table 19. Export Price Index by Selected ANZSIC Industry of Origin Division & Subdivision, Index Numbers