Reporting: Excel, PDF

Glen BambrickApplications Engineer, IMGS

What FME can do for reporting..

Spreadsheet operations

Statistics, transpose, pivot

Excel reports

Reporting to PDF

Reporting Formats

Transformers

MapnikRasterizer

PDFPageFormatter

Partners

Avenza – MAPublisher – grids, labelling, symbols, etc – export to Geospatial PDF

Tetrad – Sitewise – demographic data, drivetimeanalysis, etc

Software

Tableau – see and understand data

Adobe Acrobat - georeferencing, measuring

Reporting Demographic data to Excel

AttributeRenaming – to match excel columns

AttributePivoter – to group data by rows and columns

Writer options

Templates and Workbooks

Excel uses named ranges for formulas, bookmarks, validation etc

Feature type - <sheetname>/<namedrange>

Attribute – CUMULATIVE.formula = SUM(C2:N2)

PDF Writing

PDFStyler – basic element, text and line styling

PDFPageFormatter

- more complex page layout

PDF Example – La Rioja

Orthophoto Map:

Incredibly detailed

Use of Inset maps, Annotation and Grids

Easily Updated

Thanks to:

Ana García de Vicuña Ruiz de Argandoña

Gobierno de La Rioja – Spain

RiojaThanks to:

Ana García de Vicuña

Ruiz de Argandoña

Gobierno de La Rioja –

Spain

Thank You!

Questions?

For more information:

gbambrick@imgs.ie

Blog posting on automating Excel tasks