8752.0 - Building Activity, Australia, Sep 2013 Quality Declaration
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 16/01/2014
Page tools: Print Page Print All | ||||||||||||||||||||||||||||
File contents
Validation Table The validation table is an Excel spreadsheet containing data for checking purposes. It is important to check totals from tables created against the validation table to ensure you have extracted correct data. This is due to overcounting that will occur in the table if you make no selection for some classifications. For example, for Type of Building, you must select the categories you require, and include the classification in the table. If you do not do this, records will be counted more than once because sub-totals and totals are included in this classification. Even if you do not require Type of Building in your table, overcounting will occur unless you select the total category and drag this into the table. Note also that Reference Quarter must be brought into the table or the table will show the total for all quarters. Best practice is to make sure all fields are selected and put into the table. Formula Type of Work Total = New + Total alterations/additions (incl. refurb and conversion) Type of Building Total residential building = Total houses + Total other residential building Non-house building = Total other residential building + Total non-residential building Total building = Total residential building + Total non-residential building Total building = Total houses + Non-house building Definition of Conversions etc. Conversions etc. = Total building - New houses - New other residential buildings (This is how to calculate Conversions etc., but it is the equivalent of new non-residential buildings + alterations and additions for total building) |