Active Builders Report - Soft copy This file is a comma-delimited ASCII text file.(Also referred to as a delimited text file, CSV file or comma separated file). If you have Microsoft Office 97 or Excel 97, then the spreadsheet macro XL97ACT.XLS can be run to import and view the data. NOTE! for the macro to work you MUST have all files received from us saved in the same folder - do not try to run the macro by itself (eg from your email) Field Description of Field Length Decimals 1 State Number 1 2 Local Authority Code 8 3 Builder Address 25 4 Builder Suburb 20 5 Builder Postcode 4 6 Builder Name 40 7 Builder Telephone Number 15 8 blank 20 9 blank 25 10 blank 20 11 blank 4 12 blank 15 13 blank 25 14 blank 20 15 blank 4 16 Total Value of jobs 8 0 17 Total Number of jobs 5 0 18 blank 3 0 19 blank 20 20 blank 4 21 blank 8 22 blank 2 23 blank 1 24 Builders sort code 8 25 blank 1 Explanations: The blank fields are necessary so this layout is the same as the Building permit layout. This enables customers who get both types of information to use the same import procedure. state Number - Eg 2=NSW, 3=VIC, 4=QLD etc Local Authority Code - Used internally by Reed Construction Data. A list of these codes and corresponding council names can be downloaded from the Housing section of our website at www.reedconstructiondata.com.au/products/housing.php Builders Sort code - Use this field to sort the data by the "logical" builders name. IE If the Builder name is Peter Jacob then the sort code would be something like JACOBPE ****************** Copyright Notice ******************************* NOTE: All information supplied remains the exclusive property of Reed Construction Data. It is to be used only for the subscriber's business and in no circumstances to be used by other persons, or for any other purpose. Information is not to be reproduced, photocopied recorded, transmitted, or stored in any form of retrieval system without the written permission of Construction Research of Australia. ************************************************************************* Contact information: Phone (toll-free): 1800 80 60 60 Fax: 02 9934 5501 Email: info@rcd.com.au Web Site: www.reedconstructiondata.com.au