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 |
||
| (One intermediate revision by one other user not shown) | |||
| 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 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: | |||
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]]. | |||
Latest revision as of 14:04, 4 October 2022
_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.