Maptype postfix (Excel)

From Tygron Support wiki
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 current state and the maquette state of the project. One such situation is when the Simulation Type of the project is set to timeline.

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.