Who is this article for?

Noise analysts and report authors who need to build an Excel export template.

Access to the ANOMS Noise Analyst Workbench and Microsoft Excel are required.

Excel export templates use the same browser fields as Word templates, but because Excel has no native mergefield concept, the fields are written as text placeholders in double braces.

Understanding field placeholders

Simulate a mergefield in Excel by typing a text value into a cell, consisting of the field name enclosed in double curly braces. Two forms are accepted:

• A table field name of the form tbl_browser_field in double curly braces — for example, the placeholder for tbl_operations_opnum
• A plain field name of the form browser_field in double curly braces — for example, the placeholder for operations_opnum

Both forms are treated as a table column — a double-braced operations_opnum behaves exactly the same as a double-braced tbl_operations_opnum, with one row filled in per exported record.

Use the sample field documents to find the correct field names for each browser — see the article Downloading the stock ANOMS export templates.

Adding image placeholders

Excel templates also support image tags.

To insert an image placeholder:

1. Insert an image into the Excel template.
2. Name it with one of the valid image tag names (PcaGraph, NoiseTofGraph, PenetrationGraph, NoiseSampleGraph, NoiseEventGraph, TrackProfileGraph or Map — see the article Creating or modifying a Word export template for what each contains).

Note: Image names in Excel templates are NOT enclosed in double curly braces — only field placeholders are.

As with Word templates, the image must be open in ANOMS at the time of export, and the template only appears in a browser's Excel export drop-down if it uses that browser's fields.