Indicator - Revision history

Maxim@tygron.com at 11:42, 13 July 2026

2026-07-13T11:42:39Z

← Older revision		Revision as of 11:42, 13 July 2026
Line 113:		Line 113:

	The available default indicators are listed below.		The available default indicators are listed below.
	Some of these indicators already perform specific calculations and can be directly used in the project. They can also be [[~~Excel indicator~~\|modified and extended with adjusted calculation]]s.		Some of these indicators already perform specific calculations and can be directly used in the project. They can also be [[Indicators Tutorial\|modified and extended with adjusted calculation]]s.

	It is also possible to implement your own indicator, using an [[Excel\|Excel file]]. This Excel file should be imported into your project and assigned to an indicator. Each added indicator is initially empty, and will require some work to set up, but it is highly customizable.		It is also possible to implement your own indicator, using an [[Excel\|Excel file]]. This Excel file should be imported into your project and assigned to an indicator. Each added indicator is initially empty, and will require some work to set up, but it is highly customizable.

Maxim@tygron.com at 11:26, 13 July 2026

2026-07-13T11:26:53Z

← Older revision		Revision as of 11:26, 13 July 2026
Line 151:		Line 151:
	{{article end		{{article end
	\|seealso=		\|seealso=
	* [[Excel Indicator]]
	* [[Indicators Tutorial]]		* [[Indicators Tutorial]]
	* [[TQL]]		* [[TQL]]

Maxim@tygron.com: /* Excel Summary */

2026-07-13T11:24:32Z

Excel Summary

← Older revision		Revision as of 11:24, 13 July 2026
Line 157:		Line 157:
	\|howtos=		\|howtos=
	* [[How to upload an Indicator Excel]]		* [[How to upload an Indicator Excel]]
			* [[How to edit Excel named Cells]]
	* [[How to add or remove or duplicate an Indicator]]		* [[How to add or remove or duplicate an Indicator]]
	* [[How to edit Indicator properties]]		* [[How to edit Indicator properties]]

Maxim@tygron.com: /* Relation to stakeholders */

2026-07-13T11:21:08Z

Relation to stakeholders

← Older revision		Revision as of 11:21, 13 July 2026
Line 131:		Line 131:

	[[File:Personal_heat_indicator.png\|thumb\|right\| A personal heat indicator for the municipality. It is only visible in the top bar for this specific stakeholder.]]		[[File:Personal_heat_indicator.png\|thumb\|right\| A personal heat indicator for the municipality. It is only visible in the top bar for this specific stakeholder.]]

			<br clear=all>

	==Excel Summary==		==Excel Summary==

Maxim@tygron.com: /* Summary (how to...) */

2026-07-13T11:20:38Z

Summary (how to...)

← Older revision		Revision as of 11:20, 13 July 2026
Line 132:		Line 132:
	[[File:Personal_heat_indicator.png\|thumb\|right\| A personal heat indicator for the municipality. It is only visible in the top bar for this specific stakeholder.]]		[[File:Personal_heat_indicator.png\|thumb\|right\| A personal heat indicator for the municipality. It is only visible in the top bar for this specific stakeholder.]]

	==Summary ~~(how to...)~~==		==Excel Summary==
	: Below is a small summary describing a suggested workflow from a bird's eye perspective, without going deeper into details:		: Below is a small summary describing a suggested workflow from a bird's eye perspective, without going deeper into details:
	<br>		<br>

Maxim@tygron.com: /* Relation to stakeholders */

2026-07-13T11:08:05Z

Relation to stakeholders

← Older revision		Revision as of 11:08, 13 July 2026
Line 131:		Line 131:

	[[File:Personal_heat_indicator.png\|thumb\|right\| A personal heat indicator for the municipality. It is only visible in the top bar for this specific stakeholder.]]		[[File:Personal_heat_indicator.png\|thumb\|right\| A personal heat indicator for the municipality. It is only visible in the top bar for this specific stakeholder.]]

			==Summary (how to...)==
			: Below is a small summary describing a suggested workflow from a bird's eye perspective, without going deeper into details:
			<br>
			{{Editor steps\|title=create an Excel Indicator\|Load a sample project in the editor.\|Create an empty xlsx workbook.\|Name one cell <code>EXPLANATION</code>.\|Create the <code>EXPLANATION</code> output format (HTML text string, HTML table) with <code>%s</code> variables.\|Decide, based on the <code>EXPLANATION</code>, which function categories are needed, and place them in one column.\|Add consecutive columns that match the <code>EXPLANATION</code>.\|Create the <code>VAR</code> columns with <code>ROUND(UP)</code> formulas and <code>VAR_n</code> name labels.\|Create the <code>SCORE</code> field(s) as required by the type of project (Timeline/ Planning).\|Optionally, test the spreadsheet by entering round values in query fields.\|Create a new Excel Indicator in the project and upload the Excel file to the project.\|Recalculate the indicators and verify if no errors are present.}}

			===Tips===
			*Divisions by zero can be solved as follows: <code>=C2/IF(D2,D2,1)</code>. In this example cells C2 and D2 contain number values.
			*Instead of using the VAR_# method for the explanation text, you can also use the concatenate function of excel:
			<code>
			CONCATENATE(<nowiki>"<p>",A2, ": ", E2, " m2 and in Safe Zone: ", F2, " m2</p>"</nowiki>)
			</code>
			*Starting with creating a table aids in setting up the Excel spreadsheet, by already thinking in advance about the lay out and formatting of the <code>EXPLANATION</code>.
			*To quickly test the spreadsheet, without uploading it to the project, it is possible to enter some values in all the cells that contain queries as name. Other cells with formulas will change their content accordingly. By entering round values, for example 100, 1000, etc, calculations can easily be verified. Don't forget to save first and to revert back to the last saved version when done verifying!
			*To display an actual percentage sign in the explanation, you need to place two percentage signs. I.e. : "50% of houses" should be written as "50%% of houses".

	{{article end		{{article end

Maxim@tygron.com at 11:05, 13 July 2026

2026-07-13T11:05:47Z

← Older revision		Revision as of 11:05, 13 July 2026
Line 1:		Line 1:
	[[File:Api_current_situation_calculation.png\|thumb\|right\|400px\|[[Overlay]] in comparison to [[Measurement]]s, [[Indicator]]s and [[Global]]s]]		[[File:Api_current_situation_calculation.png\|thumb\|right\|400px\|[[Overlay]] in comparison to [[Measurement]]s, [[Indicator]]s and [[Global]]s]]
	Indicators are named after Key Performance Indicators, which serve as a means to identify potential improvements and as a metric for the degree to which those improvements have been successful.		Indicators are named after Key Performance Indicators (KPI), which serve as a means to identify potential improvements and as a metric for the degree to which those improvements have been successful.

	Indicators are visible at the top of the [[interface]]. Each indicator has a short name and, except for the budget, a progress bar showing current performance. Indicators can also be inspected by clicking on its element in the top bar, which opens the [[indicator panel]].		Indicators are visible at the top of the [[interface]]. Each indicator has a short name and, except for the budget, a progress bar showing current performance. Indicators can also be inspected by clicking on its element in the top bar, which opens the [[indicator panel]].

Maxim@tygron.com: /* Score */

2026-07-13T11:04:34Z

Score

@@ Line 9: / Line 9: @@
 * When not selected, the progress is relative to the calculate score in the current situation. Such an indicator will measure the relative improvements.
-In the indicator panel, the indicator's full name is shown in the title, along with a description and indicator progress on the left. On the right part of this panel a calculated score and an <code>EXPLANATION</code> are shown. The score and <code>EXPLANATION</code> are produced by the indicator's [[Excel Sheet]]. This Excel sheet calculates a score and explanation, placing them in designated cells. The excel sheet is also able to obtain information from a project using [[TQL|Tygron Query Language (TQL)]] statements. A change in the project state provides input to the indicator, the indicator spreadsheet performs calculations based on this input and displays the result as output in the indicator and progress panel on the top bar.<br/>
+In the indicator panel, the indicator's full name is shown in the title, along with a description and indicator progress on the left. On the right part of this panel a calculated <code>SCORE</code> and an <code>EXPLANATION</code> are shown. The <code>SCORE</code> and <code>EXPLANATION</code> are produced by the indicator's [[Excel Sheet]]. This Excel sheet calculates a score and explanation, placing them in designated cells. The excel sheet is also able to obtain information from a project using [[TQL|Tygron Query Language (TQL)]] statements. A change in the project state provides input to the indicator, the indicator spreadsheet performs calculations based on this input and displays the result as output in the indicator and progress panel on the top bar.<br/>
 To better understand the implementation of the Excel Indicator, please follow the [[Indicators Tutorial]].
@@ Line 22: / Line 22: @@
 : <code>EXACT_NUMBER_VALUE</code>: A numerical value that is formatted using the unit system selected for your project. Replaces the indicator's progress bar.
 : <code>EXACT_TEXT_VALUE</code>: A text value that will be used instead of the progress bar.

Maxim@tygron.com: /* Relation to stakeholders */

2026-07-13T10:59:21Z

Relation to stakeholders

← Older revision		Revision as of 10:59, 13 July 2026
Line 70:		Line 70:
	* [[Plotly]]		* [[Plotly]]
	\|howtos=		\|howtos=
	* [[How upload an Indicator Excel]]		* [[How to upload an Indicator Excel]]
	* [[How to add or remove or duplicate an Indicator]]		* [[How to add or remove or duplicate an Indicator]]
	* [[How to edit Indicator properties]]		* [[How to edit Indicator properties]]

Maxim@tygron.com: /* Upload an Excel file */

2026-07-13T10:58:59Z

Upload an Excel file

@@ Line 62: / Line 62: @@
 [[File:Personal_heat_indicator.png|thumb|right| A personal heat indicator for the municipality. It is only visible in the top bar for this specific stakeholder.]]
 {{article end
@@ Line 88: / Line 70: @@
 * [[Plotly]]
 |howtos=
 * [[How to add or remove or duplicate an Indicator]]
 * [[How to edit Indicator properties]]