User guide

© GeoWise Ltd. 2011
Page 113
visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
set up in the ‘Metadata’ worksheet. The appropriate metadata element is
’column_indicator’ for the indicator column and ‘column_{associateName}’
for associate columns. In the ‘Value’ cells of column D you can define the
aliases of the new data table columns. Examples can be seen in Figure
140.
Figure 140
If your indicator names are not unique, you can address this by adding the
theme name in front of the indicator name in column B. Both must be
separated by a pipe symbol, e.g. ‘Theme 1|Male’.
Please note that it is currently not possible to add columns containing the
confidence limits ‘ul’ and ‘ll’ in this way. Also this functionality is not
supported for the Double Map Template
E.7. Exporting Data Files
To export your data to XML or JSON data files, you must have at least one
active datasheet in your workbook. In other words, you must have at least
one worksheet with a name that starts with ‘iadatasheet’ (this can be typed
with upper or lower case characters).
Click the ‘InstantAtlas’ menu in Excel and then click ‘Export Data File’.
Alternatively click the ‘IA Export’ button in the InstantAtlas toolbar
(Figure 141).
Figure 141
If the Excel Data Manager detects any problems with your workbook it will
inform you at this stage. If your workbook has been correctly formatted, a
dialog box will open in which you are asked to select the file type
(Figure 142). Data files for Flash dynamic reports need to be in XML
format whereas data files for HTML dynamic reports need to be in JSON
format.
In InstantAtlas HTML dynamic reports, adding data table columns for
a theme, indicator or time period overwrites all columns defined in
the config.xml file. This means that you will also need to add the
‘Name’ column which holds the names of the geography features.
The metadata element for this is ‘column_name’. The indicator
column can be defined with either ‘column_indicator’ or
‘column_value’ as the metadata element. For associate columns use
‘column_{associateName}’ e.g. ‘column_count’.