PreviousNext
TRAC v8 Reference > Setting Up Your Optional Data > Override Files > Formatting rules
Formatting rules

In a spreadsheet, a header row is required. The Row and Comment fields must be present and labeled accordingly.

In a spreadsheet, the dates in the header row need to be either in an Excel format, or in a Year-Period format, e.g. 2019-July, or 2019-52.

Overrides can be assigned at any level.

The override row can be specified by either the row number or the row name.

Overrides can be entered as values or formulas.

If an item has no overrides, it does not need to be included in the spreadsheet, table or query.

PreviousNext