Indicator Tutorial (Solar Panels) - Revision history

Rudolf@tygron.nl at 11:06, 25 February 2026

2026-02-25T11:06:17Z

← Older revision		Revision as of 11:06, 25 February 2026
Line 31:		Line 31:
	* An example of an Indicator that was build following these steps can be found in the Public [[GeoShare]] named 'Solar panels indicator'.		* An example of an Indicator that was build following these steps can be found in the Public [[GeoShare]] named 'Solar panels indicator'.
	\| external=		\| external=
	* ~~http~~://www.tygron.com/en/2018/08/28/indicators/ How to implement Indicators in the {{software}}		* https://www.tygron.com/en/2018/08/28/indicators/ How to implement Indicators in the {{software}}
	}}		}}

Rudolf@tygron.nl at 11:03, 25 February 2026

2026-02-25T11:03:20Z

← Older revision		Revision as of 11:03, 25 February 2026
Line 12:		Line 12:

	{{Editor steps\|title=create an 'Amount of Houses with Solar Panels' Indicator		{{Editor steps\|title=create an 'Amount of Houses with Solar Panels' Indicator
	\|Download the '~~Dummy~~ Indicator' from ~~the [https://www~~.~~tygron.com/en/2019/05/22/tql-and-indicators/ Video Tutorial page]~~. Use this as a starting point for your own Indicator.		\|Download the 'Indicator Template' from {{wiki download\|indicator_template.xlsx}}. Use this as a starting point for your own Indicator.
	\|Explore the Dummy Indicator. Note that the grey area in the Dummy Indicator is meant for requesting information from the Tygron Platform using queries (TQL). The light blue area is meant for calculations - for instance adding and subtracting data from the Platform. The area on the far right is the html table meant for presenting the results.		\|Explore the Dummy Indicator. Note that the grey area in the Dummy Indicator is meant for requesting information from the Tygron Platform using queries (TQL). The light blue area is meant for calculations - for instance adding and subtracting data from the Platform. The area on the far right is the html table meant for presenting the results.
	\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.		\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.

Hedi@tygron.com at 10:15, 3 February 2023

2023-02-03T10:15:26Z

← Older revision		Revision as of 10:15, 3 February 2023
Line 9:		Line 9:
	You can use this tutorial in several ways:		You can use this tutorial in several ways:
	* To practice building your own Indicator from scratch. Please note that for this, a good level of experience with working with Excel is required.		* To practice building your own Indicator from scratch. Please note that for this, a good level of experience with working with Excel is required.
	* To learn of what elements an Indicator consists, and to be able to adjust excisting Indicators to your own wishes. For this, do not only start with downloading the dummy Indicator (step 1 underneath), but also download the example Indicator in the [~~https://store.tygron.com/ Tygron Index~~] named 'Houses with Solar Panels' straigt away, and compare both for each step.		* To learn of what elements an Indicator consists, and to be able to adjust excisting Indicators to your own wishes. For this, do not only start with downloading the dummy Indicator (step 1 underneath), but also download the example Indicator in the Public [[GeoShare]] named 'Houses with Solar Panels' straigt away, and compare both for each step.

	{{Editor steps\|title=create an 'Amount of Houses with Solar Panels' Indicator		{{Editor steps\|title=create an 'Amount of Houses with Solar Panels' Indicator
Line 29:		Line 29:
	{{article end		{{article end
	\| notes=		\| notes=
	* An example of an Indicator that was build following these steps can be found in the [~~https://store.tygron.com/ Tygron Index~~] named 'Solar panels indicator'.		* An example of an Indicator that was build following these steps can be found in the Public [[GeoShare]] named 'Solar panels indicator'.
	\| external=		\| external=
	* http://www.tygron.com/en/2018/08/28/indicators/ How to implement Indicators in the {{software}}		* http://www.tygron.com/en/2018/08/28/indicators/ How to implement Indicators in the {{software}}
	}}		}}

Rudolf@tygron.nl at 09:47, 30 May 2022

2022-05-30T09:47:33Z

← Older revision		Revision as of 09:47, 30 May 2022
Line 1:		Line 1:
	This tutorial guides you through the steps that are necessary to build your own simple [[Indicator]] using [[Excel]] and [[TQL]].		{{tutorial prerequisites
	In this example, an Indicator is build that calculates the amount of (different kinds of) houses with solar panels that are present in a neighborhood.		\| required-excel=yes
			}}

			==Creating an indicator for solar panels==

			This tutorial guides you through the steps that are necessary to build your own simple [[Indicator]] using [[Excel]] and [[TQL]]. In this example, an Indicator is build that calculates the amount of (different kinds of) houses with solar panels that are present in a neighborhood.

	You can use this tutorial in several ways:		You can use this tutorial in several ways:

Rudolf@tygron.nl at 09:44, 30 May 2022

2022-05-30T09:44:07Z

← Older revision		Revision as of 09:44, 30 May 2022
Line 1:		Line 1:
	This tutorial guides you through the steps that are necessary to build your own simple [[~~Indicator\|~~Indicator]] using [[Excel~~\|excel~~]] and [[~~TQL\|~~TQL]].		This tutorial guides you through the steps that are necessary to build your own simple [[Indicator]] using [[Excel]] and [[TQL]].
	In this example, an Indicator is build that calculates the amount of (different kinds of) houses with solar panels that are present in a ~~neighbourhood~~.		In this example, an Indicator is build that calculates the amount of (different kinds of) houses with solar panels that are present in a neighborhood.


	You can use this tutorial in several ways:		You can use this tutorial in several ways:
	* To ~~practise~~ building your own Indicator from scratch. Please note that for this, a good level of experience with working with Excel is required.		* To practice building your own Indicator from scratch. Please note that for this, a good level of experience with working with Excel is required.
	* To learn of what elements an Indicator consists, and to be able to adjust excisting Indicators to your own wishes. For this, do not only start with downloading the dummy Indicator (step 1 underneath), but also download the example Indicator in the [https://store.tygron.com/ Tygron Index] named 'Houses with Solar Panels' straigt away, and compare both for each step.		* To learn of what elements an Indicator consists, and to be able to adjust excisting Indicators to your own wishes. For this, do not only start with downloading the dummy Indicator (step 1 underneath), but also download the example Indicator in the [https://store.tygron.com/ Tygron Index] named 'Houses with Solar Panels' straigt away, and compare both for each step.

	~~==Steps==~~

	{{Editor steps\|title=create an 'Amount of Houses with Solar Panels' Indicator		{{Editor steps\|title=create an 'Amount of Houses with Solar Panels' Indicator
	\|Download the 'Dummy Indicator' from the [https://www.tygron.com/en/2019/05/22/tql-and-indicators/ Video Tutorial page]. Use this as a starting point for your own Indicator.		\|Download the 'Dummy Indicator' from the [https://www.tygron.com/en/2019/05/22/tql-and-indicators/ Video Tutorial page]. Use this as a starting point for your own Indicator.
	\|Explore the Dummy Indicator. Note that the grey area in the Dummy Indicator is meant for requesting information from the Tygron Platform using queries (TQL). The light blue area is meant for calculations - for instance adding and subtracting data from the Platform. The area on the far right is the html table meant for presenting the results.		\|Explore the Dummy Indicator. Note that the grey area in the Dummy Indicator is meant for requesting information from the Tygron Platform using queries (TQL). The light blue area is meant for calculations - for instance adding and subtracting data from the Platform. The area on the far right is the html table meant for presenting the results.



	~~[[File:Excel_voorbeeld.jpg]]~~



	\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.		\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.
	\|Compose the right [[TQL\|TQL]] queries necessary tot determine the amount of housing functions with solar panels per neighbourhood. Note that you need information about which neighbourhoods are present and how many (differtent kinds of) houses are present in both the Current and the Maquette state.		\|Compose the right [[TQL\|TQL]] queries necessary tot determine the amount of housing functions with solar panels per neighbourhood. Note that you need information about which neighbourhoods are present and how many (differtent kinds of) houses are present in both the Current and the Maquette state.



	~~[[File:TQL.jpg]]~~



	\|Determine and Fill in the required calculations in your Excel Indicator. For instance, the increased amount of buildings with solar panels is obtained by subtracting the amount in the Current state from the amount in the Maquette.		\|Determine and Fill in the required calculations in your Excel Indicator. For instance, the increased amount of buildings with solar panels is obtained by subtracting the amount in the Current state from the amount in the Maquette.
	\|Think of how you want to show the results in the table in the Indicator panel and fill in the [[HTML\|html]] table according to this.		\|Think of how you want to show the results in the table in the Indicator panel and fill in the [[HTML\|html]] table according to this.
Line 34:		Line 17:
	}}		}}

			{{gallery
			\| Excel_voorbeeld.jpg \| Excel example
			\| TQL.jpg \|TQL
			}}

	An example of an Indicator that was build following these steps can be found in the [https://store.tygron.com/ Tygron Index] named 'Solar panels indicator'.		{{article end
			\| notes=
	~~==Also see=~~=		* An example of an Indicator that was build following these steps can be found in the [https://store.tygron.com/ Tygron Index] named 'Solar panels indicator'.
	[http://www.tygron.com/en/2018/08/28/indicators/ ~~Tutorial:~~ How to implement Indicators in the {{software}}]		\| external=
			* http://www.tygron.com/en/2018/08/28/indicators/ How to implement Indicators in the {{software}}
			}}

Bobby@tygron.nl at 09:01, 7 June 2019

2019-06-07T09:01:53Z

← Older revision		Revision as of 09:01, 7 June 2019
Line 12:		Line 12:
	\|Download the 'Dummy Indicator' from the [https://www.tygron.com/en/2019/05/22/tql-and-indicators/ Video Tutorial page]. Use this as a starting point for your own Indicator.		\|Download the 'Dummy Indicator' from the [https://www.tygron.com/en/2019/05/22/tql-and-indicators/ Video Tutorial page]. Use this as a starting point for your own Indicator.
	\|Explore the Dummy Indicator. Note that the grey area in the Dummy Indicator is meant for requesting information from the Tygron Platform using queries (TQL). The light blue area is meant for calculations - for instance adding and subtracting data from the Platform. The area on the far right is the html table meant for presenting the results.		\|Explore the Dummy Indicator. Note that the grey area in the Dummy Indicator is meant for requesting information from the Tygron Platform using queries (TQL). The light blue area is meant for calculations - for instance adding and subtracting data from the Platform. The area on the far right is the html table meant for presenting the results.



	[[File:Excel_voorbeeld.jpg]]		[[File:Excel_voorbeeld.jpg]]



	\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.		\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.
	\|Compose the right [[TQL\|TQL]] queries necessary tot determine the amount of housing functions with solar panels per neighbourhood. Note that you need information about which neighbourhoods are present and how many (differtent kinds of) houses are present in both the Current and the Maquette state.		\|Compose the right [[TQL\|TQL]] queries necessary tot determine the amount of housing functions with solar panels per neighbourhood. Note that you need information about which neighbourhoods are present and how many (differtent kinds of) houses are present in both the Current and the Maquette state.



	[[File:TQL.jpg]]		[[File:TQL.jpg]]

Bobby@tygron.nl at 09:01, 7 June 2019

2019-06-07T09:01:27Z

← Older revision		Revision as of 09:01, 7 June 2019
Line 21:		Line 21:


	[[File:~~tql~~.jpg]]		[[File:TQL.jpg]]

Bobby@tygron.nl at 09:00, 7 June 2019

2019-06-07T09:00:07Z

← Older revision		Revision as of 09:00, 7 June 2019
Line 21:		Line 21:


	[[File:~~TQL~~.jpg]]		[[File:tql.jpg]]

Bobby@tygron.nl at 08:59, 7 June 2019

2019-06-07T08:59:06Z

← Older revision		Revision as of 08:59, 7 June 2019
Line 18:		Line 18:

	\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.		\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.
	\|Compose the right [[TQL\|TQL]] queries necessary tot determine the amount of housing functions with solar panels per neighbourhood. Note that you need information about which neighbourhoods are present and how many (differtent kinds of) houses are present in both the Current and the Maquette state.		\|Compose the right [[TQL\|TQL]] queries necessary tot determine the amount of housing functions with solar panels per neighbourhood. Note that you need information about which neighbourhoods are present and how many (differtent kinds of) houses are present in both the Current and the Maquette state.


			[[File:TQL.jpg]]


	\|Determine and Fill in the required calculations in your Excel Indicator. For instance, the increased amount of buildings with solar panels is obtained by subtracting the amount in the Current state from the amount in the Maquette.		\|Determine and Fill in the required calculations in your Excel Indicator. For instance, the increased amount of buildings with solar panels is obtained by subtracting the amount in the Current state from the amount in the Maquette.
	\|Think of how you want to show the results in the table in the Indicator panel and fill in the [[HTML\|html]] table according to this.		\|Think of how you want to show the results in the table in the Indicator panel and fill in the [[HTML\|html]] table according to this.

Bobby@tygron.nl at 07:57, 7 June 2019

2019-06-07T07:57:15Z

← Older revision		Revision as of 07:57, 7 June 2019
Line 11:		Line 11:
	{{Editor steps\|title=create an 'Amount of Houses with Solar Panels' Indicator		{{Editor steps\|title=create an 'Amount of Houses with Solar Panels' Indicator
	\|Download the 'Dummy Indicator' from the [https://www.tygron.com/en/2019/05/22/tql-and-indicators/ Video Tutorial page]. Use this as a starting point for your own Indicator.		\|Download the 'Dummy Indicator' from the [https://www.tygron.com/en/2019/05/22/tql-and-indicators/ Video Tutorial page]. Use this as a starting point for your own Indicator.
	\|Explore the Dummy Indicator. Note that the grey area in the Dummy Indicator is meant for requesting information from the Tygron Platform using queries (TQL). The light blue area is meant for calculations - for instance adding and subtracting data from the Platform. The area on the far right is the html table meant for presenting the results.		\|Explore the Dummy Indicator. Note that the grey area in the Dummy Indicator is meant for requesting information from the Tygron Platform using queries (TQL). The light blue area is meant for calculations - for instance adding and subtracting data from the Platform. The area on the far right is the html table meant for presenting the results.


			[[File:Excel_voorbeeld.jpg]]


	\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.		\|Check which (housing) [[Functions\|Functions]] with solar panels are present in the {{software}}.
	\|Compose the right [[TQL\|TQL]] queries necessary tot determine the amount of housing functions with solar panels per neighbourhood. Note that you need information about which neighbourhoods are present and how many (differtent kinds of) houses are present in both the Current and the Maquette state.		\|Compose the right [[TQL\|TQL]] queries necessary tot determine the amount of housing functions with solar panels per neighbourhood. Note that you need information about which neighbourhoods are present and how many (differtent kinds of) houses are present in both the Current and the Maquette state.