Go to...
Style Markers Units Target Format Borders Plot Heat Map

Styles are currently implemented for the following types:

• Title
• Unmitigated
• Mitigated
• Source
• Reference
• Silencer
• User Input
• Comment
• Subtotal
• Total
• Normal

Styles can be selected through the Trace Ribbon (applies to whole row) or through the regular Excel interface (applies to selected cells). The function Clear applies the Trace Normal style.

[Back to top]

TBC

[Back to top]

Formatting to cells is applied through the NumberFormat attribute in VBA. Formatting of units can be applied with this button for the following unit types:

• metres (m)
• metres squared (m²)
• metres squared per second (m²/s)
• metres cubed per second (m²/s)
• decibels (dB)
• A-weighted decibels (dBA)
• kilowatts (kW)
• Pascals (Pa)
• Directivity (Q)

[Back to top]

Applies colouring to the cells using a 'traffic light' system. Conditional formatting will be applied to the correct columns to indicate when the target it met, marginal or exceeds in a 'traffic light' format.

Formatting may be applied to whole numbers or to the maximum allowable level, accounting for rounding of values up to 0.4dB above the target.

[Back to top]

Makes borders of cells look consistent. The default format looks like this:

[Back to top]

Generates a plot of the rows selected and applies formatting based on the user input form.

Formatting is applied to all series in the chart for consistency. Edits to an individual series can still be made the regular way through Excel's interface. The plot tool can also be applied to existing chart objects, by having the chart selected first, then clicking the Plot button in the Trace Ribbon.

[Back to top]

Uses conditional formatting to generate a heat map of values.

• Green = Less
• Red = More

[Back to top]