Maptype postfix (Excel): Difference between revisions
(Created page with "framed|right|The name of this cell is appended with <code>_CURRENT</code>, and the other with <code>_MAQUETTE</code>. Non-query output cells use a word...") |
No edit summary |
||
| Line 1: | Line 1: | ||
[[File:postfixes.jpg|framed|right|The name of this cell is appended with <code>_CURRENT</code>, and the other with <code>_MAQUETTE</code>.]] | [[File:postfixes.jpg|framed|right|The name of this cell is appended with <code>_CURRENT</code>, and the other with <code>_MAQUETTE</code>.]] | ||
[[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 [[Indicator]]s). By default these values are used for both the [[Map Type|current and maquette views]] in the {{software}}. 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: | |||
This functionality does not extend to | <code>SCORE</code> | ||
It is possible to instead have 2 cells for the score, expanding the term with a CURRENT or MAQUETTE postfix: | |||
<code>SCORE_CURRENT</code> and <code>SCORE_MAQUETTE</code>. | |||
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 [[Tygron Query Language#Map types|a built-in clause]]. | |||
Revision as of 15:44, 3 March 2021
_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.