User guide

© GeoWise Ltd. 2011
Page 104
visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
Row 4
Row 4 is used to specify the type of indicator. This can be ‘numeric’ or
‘categoric’. You only need to specify the indicator type in the first column
for each indicator.
Indicator Type
numeric
categoric
Use when…
...the data values for
your indicator are
numerical.
...the data values for your
indicator are textual rather
than numerical.
Sorting in Data
Table
numerical
alphabetical
Alignment in
Data Table
right aligned
left aligned
Examples
The percentage of
population in the 15-
18 age group or
average household
income
Political affiliation
(Republican, Democrat, etc)
or land classification (Urban,
Rural, etc)
For the InstantAtlas version 6 reports it is possible to specify a precision
value in the metadata for numeric indicators. For ‘categoric’ indicator
types, this precision value is ignored.
Row 5
Row 5 contains the time period names. These names can be anything you
like. Time periods for an indicator should be entered in columns from left
to right in ascending chronological order. If you only have a single time
period for each indicator, you should leave the cells in row 5 blank. You
will then just see two levels (Theme >> Indicator) instead of three (Theme
>> Indicator >> Time Period) in the data explorer of your report.
Data values
Starting in cell C6 you should enter your data values. As indicated above,
you should generally enter numbers for ‘numeric’ type indicators and text
values for ‘categoric’ type indicators. However, it is possible to enter text
values for ‘numeric’ type indicators – this can be useful if, for example, you
need to suppress a value due to a case of small numbers. In the following
image (Figure 130) you can see that <5 has been entered as a data value
for three geographic features. This is a text value and will be treated as
such – these areas will be classified separately by the legend. Other text
values used for ‘numeric’ type indicators might be ‘-’ or ‘N/A’ for example.
Figure 130
You do not have to enter a data value for every geographic feature – if you
leave a cell blank then “No Data” (or some other text you set in the