|Page tools: Print Page Print All|
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.
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)