|Page tools: Print Page Print All|
SAVE, DOWNLOAD AND PRINT
OPEN A SAVED TABLE
Saved tables can be accessed again from the Saved Tables tab. The Saved Tables tab is available within a dataset and from the TableBuilder home page.
The Saved Tables tab includes options to rename and delete saved tables and create new copies of saved tables.
To rename a saved table:
To delete a saved table:
To create a copy of a saved table:
DOWNLOADING TABLE FORMATS
Tables can be downloaded in the following formats:
Excel 2007 and Excel 2003 have limitations on the size of a table they can display. Excel 2007 allows up to 16,384 columns x 65,000 rows and less than 100,000 cells. Excel 2003 allows up to 255 columns x 65,000 rows. If the table is larger than the Excel 2003 or 2007 limits, these options are greyed out in the download options and can't be selected.
SDMX downloads are not available if the table contains any of the following:
PERCENTAGES IN DOWNLOADED TABLES
When downloading tables containing percentages, the percentage symbol is only displayed in Excel format downloads. Other formats such as CSV include the percentage value but do not show the percent symbol (%) after the value.
RELATIVE STANDARD ERRORS IN DOWNLOADED TABLES
Where relative standard error (RSE) data is available for a table, this data is included in the downloaded table. The RSE data is downloaded even if it is not currently displayed in the table in Table View. Some datasets, including Census TableBuilder datasets, do not have RSEs. RSEs are only applicable for sample data and weighted data. For further information, see the Relative standard error section.
Downloads include RSE data in a separate Excel worksheet (tab).
Downloads include a separate column for RSE data.
RSE data is represented as an attribute value in the SDMX Generic Data observation element. This attribute is only added when the dataset is weighted and has RSE values in the associated data cube. For example:
ANNOTATIONS IN DOWNLOADED TABLES
Annotations provide additional information or notes about features or aspects relating to the dataset. If the table contains annotations they are included in the downloaded table.
SDMX downloaded at the dataset level contains dataset level annotation descriptions and symbols in the <Annotations> ... </Annotations> section of the XML.
Printing is best suited to smaller tables. For larger tables, downloading the table in Excel format and printing the table from within Excel provides more control over the print layout and formatting.
Click the Print Table button to print the current table.
These documents will be presented in a new window.
1406.0.55.005 - TableBuilder, User Guide
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 15/12/2016