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 |
645701 | Table 1. Import Price Index: Index numbers and percentage changes | 645701 | Tables 1, 3 and 12. Import Price Index by SITC, Index Numbers and Percentage Changes |
645703 | Table 3. Import Price Index , By SITC Section | 645701 | Tables 1, 3 and 12. Import Price Index by SITC, Index Numbers and Percentage Changes |
645704 | Table 4. Import Price Index, By BEC End Use Class and Broad Balance of Payments Categories Index Numbers | 645703 | Tables 4, 5 and 6. Import Price Index by BEC End Use Class and Broad Balance of Payments Categories, Index Numbers |
645707 | Table 7. Export Price Index : All groups index numbers and percentage changes | 645704 | Tables 7 and 9. Export Price Index by SITC, Index Numbers and Percentage Changes |
645709 | Table 9. Export Price Index, By Selected SITC section | 645704 | Tables 7 and 9. Export Price Index by SITC, Index Numbers and Percentage Changes |
6457010 | Table 10. Export Price Index, By Balance of Payments Groups Index Numbers | 645705 | Tables 10 and 11. Export Price Index by Balance of Payments Groups, Index Numbers |
6457012 | Table 12. Import Price Index, By Selected SITC Division | 645701 | Tables 1, 3 and 12. Import Price Index by SITC, Index Numbers and Percentage Changes |
6457013 | Table 13. Import Price Index , By Selected HTISC Section | 645706 | Table 13. Import Price Index by Selected HTISC Section, Index Numbers |
6457014 | Table 14. Import Price Index , By Selected ANZSIC Industry of Origin Division | 645707 | Tables 14 and 15. Import Price Index by Selected ANZSIC Industry of Origin, Index Numbers |
6457015 | Table 15. Import Price Index, By Selected ANZSIC Industry of Origin Subdivision | 645707 | Tables 14 and 15. Import Price Index by Selected ANZSIC Industry of Origin, Index Numbers |
6457016 | Table 16. Import Price Index , By BEC Category | 645709 | Table 16. Import Price Index: BEC category, Index Numbers |
6457018 | Table 18. Export Price Index, By Selected AHECC Section | 6457010 | Table 18. Export Price Index by Selected AHECC Section, Index Numbers |
6457019 | Table 19. Export Price Index, By Selected ANZSIC Industry of Origin Division and Subdivision | 6457011 | Table 19. Export Price Index by Selected ANZSIC Industry of Origin Division & Subdivision, Index Numbers |