User guide

© GeoWise Ltd. 2011
Page 166
visualise | communicate | ENGAGE The InstantAtlas Election Template
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
K.3. Data Preparation
The required data structure is represented in Figure 197 below, and an
example workbook containing fictitious election results has been included
in the ‘iadatasheet’ worksheet of the workbook named
IAworkbookElectionResults.xls. This file is found in the ‘workbooks’
subfolder of your installation folder of InstantAtlas.
Figure 197
The data in the iadatasheet of the example workbook provided is divided
into two themes containing a number of indicators and associates. These
are discussed below in detail, in reference to the example workbook, to
help you create your own election results workbook.
K.3.1. Theme 1
This theme (row 1, merged across Column C to K) contains a number of
indicators that contain all data except for the breakdown of election results.
It is named ‘Electoral Area Details’ in the example workbook, as shown in
Figure 198 below.
Figure 198
K.3.1.1. Theme 1, Indicator 1
This indicator (row 2, merged across Column C to F) contains data
populating three areas of the report: the ‘Winning Party’ shown in the first
theme of the Spine Chart; the winning parties shown in the Table below the
Map; and all of the Comparison Table at the top-right of the report. This
indicator is named ‘Winning Party’ in the example workbook.
The indicator type is designated ‘categoric’ in cell C4, and associates are
assigned in cell D5 as ‘seats’, in cell E5 as ‘voteCount’, and in cell F5 as
‘votePercent’.