User guide

© GeoWise Ltd. 2011
Page 99
visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
If you do not know what codes are used to identify features in your map
files you can do the following:
1. Start the InstantAtlas Publisher
2. Publish a report with the desired base geography and contextual
geographies
3. Click the ‘Unpack’ button on the final screen of the Publisher
4. Browse to the output folder for the report you published and open
the file called ‘geographies.csv’ using Excel
5. The codes in your map file will be listed in the first column of
‘geographies.csv’.
6. Copy and paste the codes from ‘geographies.csv’ into your
‘Geographies and Filters’ worksheet
Note that in InstantAtlas version 5 and earlier, feature codes were
automatically given underscore prefixes by the Publisher and Data
Managers if they started with a number. From InstantAtlas version 6 this
rule has been dropped and feature codes will be preserved exactly as they
appear in your digital map files or as entered into the Data Managers.
Make sure that Excel does not automatically remove leading zeros from
your codes – you can avoid this by typing a single quote before the code
(this forces Excel to treat the code as text even if it consists of numbers).
If you wish to include comparison geographies you must enter their codes
below those of the base geography features. The codes must be given the
prefix # (e.g. #TA1 or #00AB) to distinguish them from base geography
features. In the example provided, there are two comparison geographies:
the City of Edinburgh and Scotland.
Please note that the number and order of areas in the Geography and
Filters worksheet must be consistent with the number and order of those in
your iadatasheet(s).
E.4.2. Entering Names (Column B)
Check that cell B2 contains the name of your base geography. You can
type any text here apart from a forward or back slash (/ or \). For example,
if you publish a report for post code sectors, you could enter ‘post code
sectors’ in cell B2. This text is used in the naming of the XML data files
and will not be displayed in the report itself.
From row 3 down, column B should contain names for the geographic
features. These are the feature names that will be displayed in the report.
In the example provided, the names are similar to the codes but include
spaces.
E.4.3. Entering Links (Column C)
For each base geography feature, you can optionally specify a link to any
file. This is the file that will open if the notes icon next to a geographic
feature is clicked in the data table of an InstantAtlas report (Figure 121).
Typically these are used to link to files containing geography-related
metadata.
Figure 121