User guide

Page 102

visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager

g the InstantAtlas Area Profile Template User Guide

datasheets will affect the number of data files produced when the data is

exported - this will be explained in more detail in section ‘E.7. Exporting

Data Files’.

E.5.1. Entering Indicators

Please refer to the ‘Example 1 iadatasheet’ of the example workbook.

E.5.1.1. Entering Codes (Column A)

The contents of this column must be exactly the same as that of column A

in the ‘Geography and Filters’ worksheet.

E.5.1.2. Entering Names (Column B)

The contents of this column must be exactly the same as that of column B

in the ‘Geography and Filters’ worksheet.

E.5.1.3. Entering Indicator Values (Columns C Onwards)

Columns C onwards hold the data values that will be displayed in your

report. The data you enter must be organised on three levels: by theme,

by indicator and by time period (Figure 127).

Figure 127

Rows 1 and 2

Row 1 contains the theme names, row 2 the indicator names. These

names can be anything you like. Be careful not to include leading or

trailing spaces as these may result in errors in an InstantAtlas report.

You can see that the cells in rows 1 and 2 are merged so that they span

more than one column. This is because the cell containing a theme name

must span all the columns belonging to that theme. Similarly, the cell

containing an indicator name must span all the columns belonging to that

indicator. It is very important that cells containing theme and indicator

names span the correct number of columns or the data files you generate

will be invalid.

There are two time periods with data for Indicator 1: 2004 and 2005. Thus

the cell containing the indicator name must span two columns. There are

two indicators in Theme 1, each with two columns containing data. Thus

the cell containing the theme name must span four columns.