Maptype postfix (Excel)

From Tygron Support wiki
Revision as of 14:04, 4 October 2022 by Frank@tygron.nl (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
The name of this cell is appended with _CURRENT, and the other with _MAQUETTE.

Excel files contain non-query output cells, which use a word or phrase to indicate that the value should be output in some fashion (most notably the EXPLANATION cell, and the SCORE cell for Indicators). By default these values are used for both the current and maquette views in the Tygron Platform. However, sometimes it may be desirable to output different scores for the original (current) state and the planned (maquette) state of the project.

Rather than having only a SCORE output in an Excel for an Indicator, the name simple being:

SCORE

It is possible to instead have 2 cells for the score, expanding the term with a CURRENT or MAQUETTE postfix:

SCORE_CURRENT and SCORE_MAQUETTE.

Both will need to exist to make the Excel file valid.

This functionality does not extend to output cells defined by a query. For input cells defined by a query, a switch between map views is possible via a built-in clause.