User guide

Page 118

visualise | communicate | ENGAGE The InstantAtlas Batch Publisher

g the InstantAtlas Area Profile Template User Guide

F.2.1. The Geography and Filters Worksheet

The ‘Geography and Filters’ worksheet should be edited first. Columns A

and B should contain the code and name of every post code sector in

Edinburgh. Optionally, column C can contain a URL to an external file

containing supporting information for each post code sector. Column D will

be the split column that defines which report each post code sector will be

published in (Figure 146). Columns E onwards should contain any filters

you wish to include in your report.

Figure 146

Cell D1 must contain ‘split’. Cell D2 can be used optionally to supply a

name for your split column although - this is just for your benefit as it is not

used by the software. From row 3 downwards the split column must

contain the name of a part of Edinburgh. Post code sectors with the same

value in column D will be published in the same report. Note that no filter

columns have been included in this example. These could be added in

columns E onwards if required and the entry in row 1 would be ‘filter’ for

any filter columns.

F.2.2. The Datasheets

Enter your data values into one or more datasheets. In this example, there

is just one theme, two indicators and two time periods per indicator

(Figure 147).

Figure 147

F.2.3. The Publisher Worksheet

For the Batch Publisher to work you need a worksheet called ‘Publisher’ in

your Excel workbook. The example workbook IAworkbook_Batch.xls

contains 4 examples of this worksheet depending on what kind of

background mapping you wish to use. The functions behind the cells are

the same in all four ‘Publisher-xxx’ worksheets and you can change one

into another by changing the values in column B. The different Publisher