User guide

© GeoWise Ltd. 2011
Page 106
visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
E.5.2. Entering Associate Values
Please refer to the ‘Example 2 iadatasheet’ of the example workbook.
An associate is a set of values that are so called because they are
associated to indicator values. Associate values are not used in thematic
mapping in InstantAtlas reports but perform other roles. The inclusion of
associate values is optional but the default configuration of some templates
assumes that you will be supplying certain associates. The table below
lists these associates.
Associate
Reason for including in your data file(s)
ll
Lower confidence limits are displayed as error
bars in a report bar chart. You can calculate
these confidence limits in any way you like.
ul
Upper confidence limits are displayed as error
bars in a report bar chart. You can calculate
these confidence limits in any way you like.
highField, lowField,
openField, closeField
These associates need to be provided if you
would like to use the box-and-whisker chart in
your report. This chart can be included in the
Single Map template using the Designer.
Please see an example on how to set up the
data for this chart in the ‘Box and Whisker
iadatasheet'.
diff, number,
significance, national,
regional, baseline, state,
trend, target
These associates perform various roles in the
Area Profile template. For more information
please refer to section ‘I. The InstantAtlas Area
Profile Template’.
xValue, yValue,
sizeValue, FUNNELX
These associates perform various roles in the
Bubble Plot template. For more information
please refer to section ‘J. The InstantAtlas
Bubble Plot Template’.
In addition to those listed in the table above you can supply your own
associates. You will need to configure your dynamic report using the
InstantAtlas Designer to make use of any custom associate(s) you have
supplied. Typically this is done by adding an extra column to the data table
and linking this new column to the custom associate (the column name
must match the associate name). You can also use associates to populate
the Advanced Pie Chart.
The ‘Example 2 iadatasheet’ worksheet demonstrates how to include
associate values in your workbook. Associate values are entered in
columns directly to the right of the indicator values to which they relate.
Note that you do not have to supply the same set of associates for every
date or indicator. You do not have to supply associate value columns for
every indicator/time period combination in your datasheet – you might
decide to enter these for some but not others.
You must merge cells in row 3 to tell InstantAtlas which columns belong to
each time period instance of an indicator. Associates should be named in
row 5 as in the table above (Figure 131). Associate names must be
consistent across dates/indicators. Note that these are not the names
displayed in an InstantAtlas report - the report will display an alias that you
can configure using the InstantAtlas Designer. If you supply your own
custom associates we recommend you keep the associate name simple
(i.e. a single word that does not include any special characters).