5671.0.55.001 - Information paper: Changes to Time Series Spreadsheets associated with the publication Lending Finance, Australia, Jul 2006  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 11/09/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 "Lending Finance, Australia" (cat. no. 5671.0).


A concordance between the current Time Series Spreadsheets (lotus 1-2-3 .wks format) and the proposed new tables (in Excel .xls format) is included below.


Links to the new tables providing a view of the proposed new format are available from the Details tab of this paper.


These changes are due to come into effect with the August 2006 issue of 5671.0 which will be released on 13 October 2006.


The new product provides a range of benefits for time series clients including:

    • longer time series (we can now provide more than 255 observations in a single series) are presented in columns in accordance with Time Series analysis conventions,
    • 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 and
    • built in features on which clients can base reliable processing systems.

The new format files can be opened, read and manipulated using Excel 2003 (or equivalent).



INQUIRIES


For further information or if you have any queries about the change or related statistics, contact Joellen Hartig on (02) 6252 6623.


CONCORDANCE


CURRENT AND PROPOSED TABLES


Below is a concordance between the current and the proposed Named Time Series.


Current Named Time Series
Proposed New Table
Numbers
Table Nos.Descriptions
TABLE 1.FINANCE COMMITMENTS, Summary: Australia ($000)567101.xls
TABLE 2. HOUSING AND PERSONAL FINANCE COMMITMENTS, By Lender: Australia, Original ($000)567102.xls
TABLE 3.COMMERCIAL AND LEASE FINANCE COMMITMENTS, By Lender: Australia, Original ($'000)567103.xls
TABLE 4. PERSONAL FINANCE COMMITMENTS, By Purpose (Fixed Loans): Australia, Original ($'000)567104.xls
TABLE 5. PERSONAL FINANCE COMMITMENTS, Revolving Credit Stocks and Flows: Australia, Original ($'000)567105.xls
TABLE 6. COMMERCIAL FINANCE COMMITMENTS, By Purpose (Fixed Loans): Australia, Original ($'000)567106.xls
TABLE 7.LEASE AND COMMERCIAL FINANCE COMMITMENTS, Stocks and Flows: Australia, Original ($'000)567107.xls
TABLE 8. Finance Commitments for Housing (Owner Occupation and Commercial): Australia, Original, Seasonally Adjusted and Trend ($'000)567108.xls
TABLE 9. FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($'000)567109.xls
TABLE 10. LEASE FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($'000)567110.xls
TABLE 11. FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($'000)567111.xls
TABLE 12.LEASE FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($'000)567112.xls
TABLE C1a.COMMERCIAL FINANCE COMMITMENTS, Summary: Australia, All Series ($'000)5671C1a.xls
TABLE C1b. COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: Australia, Original ($'000)5671C1b.xls
TABLE C1c.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit by Lender: Australia, Original ($'000)5671C1c.xls
TABLE C1d.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans by Industry: Australia, Original ($'000)5671C1d.xls
TABLE C1e.COMMERCIAL FINANCE COMMITMENTS, Revolving Credit by Industry: Australia, Original ($'000)5671C1e.xls
TABLE C2.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (NSW), Original ($'000)5671C2.xls
TABLE C3.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (VIC), Original ($'000)5671C3.xls
TABLE C4.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (QLD), Original ($'000)5671C4.xls
TABLE C5.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (SA), Original ($'000)5671C5.xls
TABLE C6.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (WA), Original ($'000)5671C6.xls
TABLE C7.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (TAS), Original ($'000)5671C7.xls
TABLE C8.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (NT), Original ($'000)5671C8.xls
TABLE C9.COMMERCIAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (ACT), Original ($'000)5671C9.xls
TABLE L1a.LEASE FINANCE COMMITMENTS, Summary: Australia ($'000)5671L1a.xls
TABLE L1b.LEASE FINANCE COMMITMENTS, By Purpose: Australia, Original (Number: $'000)5671L1b.xls
TABLE L1c.LEASE FINANCE COMMITMENTS, Purpose by Lender: Australia, Original (Number: $'000)5671L1c.xls
TABLE L1d.LEASE FINANCE COMMITMENTS, By Industry: Australia, Original ($'000)5671L1d.xls
TABLE L2.LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), Original (Number: $'000)5671L2.xls
TABLE L3.LEASE FINANCE COMMITMENTS, By Purpose: State (VIC), Original (Number: $'000)5671L3.xls
TABLE L4.LEASE FINANCE COMMITMENTS, By Purpose: State (QLD), Original (Number: $'000)5671L4.xls
TABLE L5.LEASE FINANCE COMMITMENTS, By Purpose: State (SA), Original (Number: $'000)5671L5.xls
TABLE L6.LEASE FINANCE COMMITMENTS, By Purpose: State (WA), Original (Number: $'000)5671L6.xls
TABLE L7.LEASE FINANCE COMMITMENTS, By Purpose: State (TAS), Original (Number: $'000)5671L7.xls
TABLE L8.LEASE FINANCE COMMITMENTS, By Purpose: State (NT), Original (Number: $'000)5671L8.xls
TABLE L9.LEASE FINANCE COMMITMENTS, By Purpose: State (ACT), Original (Number: $'000)5671L9.xls
TABLE OL1b.OPERATING LEASE FINANCE COMMITMENTS, By Purpose: Australia, Original (Number: $'000)5671OL1b.xls
TABLE OL1c.OPERATING LEASE FINANCE COMMITMENTS, By Lender: Australia, Original ($'000)5671OL1c.xls
TABLE OL1d.OPERATING LEASE FINANCE COMMITMENTS, By Industry: Australia, Original ($'000)5671OL1d.xls
TABLE OL2.OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), Original (Number: $'000)5671OL2.xls
TABLE OL3.OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (VIC), Original (Number: $'000)5671OL3.xls
TABLE OL4.OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (QLD), Original (Number: $'000)5671OL4.xls
TABLE OL5.OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (SA), Original (Number: $'000)5671OL5.xls
TABLE OL6.OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (WA), Original (Number: $'000)5671OL6.xls
TABLE OL7.OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (TAS), Original (Number: $'000)5671OL7.xls
TABLE OL8.OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (NT), Original (Number: $'000)5671OL8.xls
TABLE OL9.OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (ACT), Original (Number: $'000)5671OL9.xls
TABLE P1a.PERSONAL FINANCE COMMITMENTS, Summary: Australia ($'000)5671P1a.xls
TABLE P1b.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: Australia, Original (Number: $'000)5671P1b.xls
TABLE P1c.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit by Lender: Australia, Original (Number: $'000)5671P1c.xls
TABLE P2.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (NSW), Original (Number: $'000)5671P2.xls
TABLE P3.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (VIC), Original (Number: $'000)5671P3.xls
TABLE P4.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (QLD), Original (Number: $'000)5671P4.xls
TABLE P5.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (SA), Original (Number: $'000)5671P5.xls
TABLE P6.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (WA), Original (Number: $'000)5671P6.xls
TABLE P7.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (TAS), Original (Number: $'000)5671P7.xls
TABLE P8.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (NT), Original (Number: $'000)5671P8.xls
TABLE P9.PERSONAL FINANCE COMMITMENTS, Fixed Loans & Revolving Credit: State (ACT), Original (Number: $'000)5671P9.xls

Table 13. Lending Finance Seasonal Factors, By Purpose and Lender: Australia, January 1985 onwards will be available as an Excel spreadsheet under the heading of Data Cubes. The format will be similar to the current format.