Indicators Tutorial - Revision history

Frank@tygron.nl at 14:49, 6 March 2026

2026-03-06T14:49:47Z

← Older revision		Revision as of 14:49, 6 March 2026
Line 346:		Line 346:
	For small and specifically applicable [[Excel]]s and [[Indicator]]s, it is possible to use multiples of this query to obtain data for all desired [[Neighborhood]]s. However, in cases where there are a large number, or an indeterminate number of [[Neighborhood]]s which you intent to consult, it's not feasible to manually create all individual queries.		For small and specifically applicable [[Excel]]s and [[Indicator]]s, it is possible to use multiples of this query to obtain data for all desired [[Neighborhood]]s. However, in cases where there are a large number, or an indeterminate number of [[Neighborhood]]s which you intent to consult, it's not feasible to manually create all individual queries.

	Instead, a syntax is available which allows for automatically obtaining the data for all relevant [[Neighborhood]]s. This syntax is known as an [[X-~~query~~]]:		Instead, a syntax is available which allows for automatically obtaining the data for all relevant [[Neighborhood]]s. This syntax is known as an [[X-Query]]:

	{{code\|1=SELECT_LANDSIZE_WHERE_NEIGHBORHOOD_IS_X}}		{{code\|1=SELECT_LANDSIZE_WHERE_NEIGHBORHOOD_IS_X}}

Frank@tygron.nl at 14:49, 6 March 2026

2026-03-06T14:49:04Z

← Older revision		Revision as of 14:49, 6 March 2026
Line 302:		Line 302:
	# Change the Excel to use a combination of a LOTSIZE query and a FLOORSIZE query to compute the average amount of floors of [[Buildings]].		# Change the Excel to use a combination of a LOTSIZE query and a FLOORSIZE query to compute the average amount of floors of [[Buildings]].
	#* Change the text of the output accordingly.		#* Change the text of the output accordingly.
	#* Where ~~neccesary~~, check whether your formula is going to divide by 0, and change your output accordingly.		#* Where necessary, check whether your formula is going to divide by 0, and change your output accordingly.
	# Upload the Excel again and inspect the results.		# Upload the Excel again and inspect the results.

Line 334:		Line 334:
	===Creating a simple calculation for multiple Items===		===Creating a simple calculation for multiple Items===

	In the first example [[Excel]] file, a simple calculation was made based on 2 inputs: the (total) lotsize and the (total) landsize in the (entire) Project. However, generally results are more ~~managable~~ when they apply to specific subdivisions of a [[Project]], so that some more overview can be established over the state of more specific location. Generally, the [[Neighborhood]]s which are included by default in every [[Project]] are used as a sensible subdivision.		In the first example [[Excel]] file, a simple calculation was made based on 2 inputs: the (total) lotsize and the (total) landsize in the (entire) Project. However, generally results are more manageable when they apply to specific subdivisions of a [[Project]], so that some more overview can be established over the state of more specific location. Generally, the [[Neighborhood]]s which are included by default in every [[Project]] are used as a sensible subdivision.

	This means that conceptually, a query such as the following:		This means that conceptually, a query such as the following:

Frank@tygron.nl at 14:37, 6 March 2026

2026-03-06T14:37:42Z

← Older revision		Revision as of 14:37, 6 March 2026
Line 227:		Line 227:
	Use the file save screen to save the file to a location on your computer. Remember the location where you save the file.		Use the file save screen to save the file to a location on your computer. Remember the location where you save the file.

	When the download has completed, open the [[Excel]] file in [[Microsoft Excel]]. You will see that this file contains actual values from the [[Project]].		When the download has completed, open the [[Excel]] file in Microsoft Excel. You will see that this file contains actual values from the [[Project]].

	Note that as a matter of good practice, the debug file should ''not'' be reuploaded to a [[Project]]. This has to do with the undue presence of data in [[Indicator]]s. This will be further clarified later on.		Note that as a matter of good practice, the debug file should ''not'' be reuploaded to a [[Project]]. This has to do with the undue presence of data in [[Indicator]]s. This will be further clarified later on.

Frank@tygron.nl at 14:36, 6 March 2026

2026-03-06T14:36:59Z

Frank@tygron.nl at 14:35, 6 March 2026

2026-03-06T14:35:52Z

← Older revision		Revision as of 14:35, 6 March 2026
Line 35:		Line 35:
	Create a new [[Excel]] file, and save it locally to your computer. Ensure it is located in a place where you are able to find it later.		Create a new [[Excel]] file, and save it locally to your computer. Ensure it is located in a place where you are able to find it later.

	Open the [[Excel]] file in [[~~Microsoft~~ Excel]].		Open the [[Excel]] file in [[Excel]].

	Select cell '''B1'''. Notice at the top of the screen, to the left of the formula bar, the coordinate of the cell is listed.		Select cell '''B1'''. Notice at the top of the screen, to the left of the formula bar, the coordinate of the cell is listed.

Rudolf@tygron.nl at 11:38, 26 November 2025

2025-11-26T11:38:08Z

@@ Line 457: / Line 457: @@
 ===Creating overviews of grid results===
-With a simple example [[Indicator]] now in place, more complex calculations can be created and included in the [[Excel]], to provide more insight into how the various [[Neighborhood]]s are doing.
+With a simple example [[Indicator]] now in place, more complex calculations can be created and included in the [[Excel]], to provide more insight into how the various [[Neighborhood]]s are doing. One especially useful function is the ability to aggregate spatially calculated results, as from [[Grid Overlay]]s, per subdivision in the [[Project]]. A concrete example is the calculation of traffic noise. The result is a detailed grid with exact calculated values for every location in the [[Project]]. To help interpret a near-analog spatial result, aggregating the results (like by averaging them) per [[Neighborhood]] creates a simpler overview of the results and allows for easier comparisons between different locations.
 * Save-as indicator to "traffic noise disturbance"
 * Add GRIDAVG query to indicator

Rudolf@tygron.nl at 10:32, 26 November 2025

2025-11-26T10:32:17Z

← Older revision		Revision as of 10:32, 26 November 2025
Line 449:		Line 449:

	Recalculate the [[Project]] if necessary.		Recalculate the [[Project]] if necessary.

			Click on the new "Built" [[Indicator]] in the [[top bar]], to open the [[indicator panel]].

			The contents of the [[Indicator]] will be a list of all [[Neighborhood]]s in the [[Project]], as well as how much of the [[Neighborhood]] is built in. (Landsize, divided by lotsize)

	<!--		<!--

Rudolf@tygron.nl: /* Creating a simple calculation for multiple Items */

2025-11-26T09:59:54Z

Creating a simple calculation for multiple Items

Rudolf@tygron.nl at 12:53, 2 May 2025

2025-05-02T12:53:02Z

← Older revision		Revision as of 12:53, 2 May 2025
Line 9:		Line 9:

	{{tutorial prerequisites		{{tutorial prerequisites
	\|tutorial=This tutorial is a continuation of the [[TQL tutorial]]~~. If you have not already done so, please complete that tutorial first~~.		\|tutorial=This tutorial is a continuation of the [[TQL tutorial]].
	\|project=This tutorial can be followed with any project of any arbitrary location. There must be WRITE access to the Project. Recommended is to create or load a project in the editor with 3 or more neighborhoods at least partially within the project area.		\|project=This tutorial can be followed with any project of any arbitrary location. There must be WRITE access to the Project. Recommended is to create or load a project in the editor with 3 or more neighborhoods at least partially within the project area.
	\|required-excel=true		\|required-excel=true
Line 449:		Line 449:

	Recalculate the [[Project]] if necessary.		Recalculate the [[Project]] if necessary.

			<!--
			===Creating overviews of grid results===

			With a simple example [[Indicator]] now in place, more complex calculations can be created and included in the [[Excel]], to provide more insight into how the various [[Neighborhood]]s are doing.

			* Add traffic noise overlay
			* Add Attribute to the overlay, clarify its tidier
			* Save-as indicator to "traffic noise disturbance"
			* Add GRIDAVG query to indicator
			* Add UNITS WHERE GRIDMINVALUE query to indicator
			* Add UNITS to indicator
			* Add formula to calculate percentage
			* Add display of neighborhood size, average noise, units affected / units total, and percentage
			* Add score
			* Clean up vestigial query/queries
			* Save
			* Upload

	<!--		<!--
	{{Tutorial completed		{{Tutorial completed
	\| learned=how to create and manage excels for indicators in your project		\| learned=how to create and manage excels for indicators in your project
	}}-->		}}-->

Rudolf@tygron.nl: /* Creating a simple calculation for multiple Items */

2025-05-02T12:15:10Z

Creating a simple calculation for multiple Items

← Older revision		Revision as of 12:15, 2 May 2025
Line 388:		Line 388:
	Hit enter on the keyboard to confirm the value of the cell.		Hit enter on the keyboard to confirm the value of the cell.

	This formula will see if there is a landsize defined. If there is (or ~~mroe~~ specifically, if the landsize is not zero), then the lotsize is divided by the landsize. This is the same calculation which happened in the earlier example. However, if the landsize is 0, then the result in this cell will be 0 as well.		This formula will see if there is a landsize defined. If there is (or more specifically, if the landsize is not zero), then the lotsize is divided by the landsize. This is the same calculation which happened in the earlier example. However, if the landsize is 0, then the result in this cell will be 0 as well.

	Select cell '''K10''' again.		Select cell '''K10''' again.

← Older revision		Revision as of 14:36, 6 March 2026
Line 63:		Line 63:
	{{code\|1=0,8}}		{{code\|1=0,8}}

	Ensure it is entered such that it is interpreted by [[Microsoft Excel]] as a number.		Ensure it is entered such that it is interpreted by [[Excel\|Microsoft Excel]] as a number.

	''Note that depending on your application's localization, the decimal seperator may either be a comma (" , ") or a point (" . ").''		''Note that depending on your application's localization, the decimal seperator may either be a comma (" , ") or a point (" . ").''

	Save the [[Excel]] file, and close [[Microsoft Excel]].		Save the [[Excel]] file, and close [[Excel\|Microsoft Excel]].

	In the editor, go to:		In the editor, go to:
Line 134:		Line 134:
	Use the file save screen to save the file to a location on your computer. Remember the location where you save the file.		Use the file save screen to save the file to a location on your computer. Remember the location where you save the file.

	When the download has completed, open the file in [[Microsoft Excel]]. You will see that it is the same file previously created.		When the download has completed, open the file in [[Excel\|Microsoft Excel]]. You will see that it is the same file previously created.

	This allows you to obtain [[Excel]] files from a [[Project]] for editing and updating. Any [[Excel]] file can be downloaded, modified, and then uploaded again as an update of the pre-existing [[Asset]], or as a new file separate from the original.		This allows you to obtain [[Excel]] files from a [[Project]] for editing and updating. Any [[Excel]] file can be downloaded, modified, and then uploaded again as an update of the pre-existing [[Asset]], or as a new file separate from the original.
Line 140:		Line 140:
	==Adding data to Indicators==		==Adding data to Indicators==

	Reopen [[Microsoft Excel]], and reopen the local [[Excel]] file.		Reopen [[Excel\|Microsoft Excel]], and reopen the local [[Excel]] file.

	The most important property of indicators is the ability to obtain data from a [[Session]] and use it in calculations and finally the output. To obtain data from a [[Session]], [[TQL]] queries are used.		The most important property of indicators is the ability to obtain data from a [[Session]] and use it in calculations and finally the output. To obtain data from a [[Session]], [[TQL]] queries are used.
Line 240:		Line 240:
	* Names can refer to multiple cells		* Names can refer to multiple cells

	For [[Microsoft Excel]], this functionality is fitting. However, for compatibility with the {{software}}, the following are prerequisites:		For Microsoft Excel, this functionality is fitting. However, for compatibility with the {{software}}, the following are prerequisites:
	* A single cell may have only one name. Otherwise, the {{software}} will be unsure what value to place in such a cell or read from such a cell.		* A single cell may have only one name. Otherwise, the {{software}} will be unsure what value to place in such a cell or read from such a cell.
	* A name may only refer to a single cell. Otherwise, the {{software}} will be unsure what value to obtain from a cell, or in which cell to place a specific (part of) a value.		* A name may only refer to a single cell. Otherwise, the {{software}} will be unsure what value to obtain from a cell, or in which cell to place a specific (part of) a value.
	* A name may not refer to a non-existent cell. Otherwise, there is no value for the {{software}} to read or manipulate.		* A name may not refer to a non-existent cell. Otherwise, there is no value for the {{software}} to read or manipulate.

	In [[Microsoft Excel]], with the [[Excel]] file open, in the ribbon's header click on "Formulas", and then find the "Defined Names" section.		In Microsoft Excel, with the [[Excel]] file open, in the ribbon's header click on "Formulas", and then find the "Defined Names" section.

	Click on "Name Manager". This will open the Name Manager.		Click on "Name Manager". This will open the Name Manager.
Line 352:		Line 352:
	This effectively means "for every [[Neighborhood]]".		This effectively means "for every [[Neighborhood]]".

	In the Indicator template [[Excel]] file, opened in [[Microsoft Excel]], select cell '''D9'''. This is one of the orange cells just above the dark-grey cells.		In the Indicator template [[Excel]] file, opened in Microsoft Excel, select cell '''D9'''. This is one of the orange cells just above the dark-grey cells.

	Click in the address field, and enter the following text:		Click in the address field, and enter the following text:
Line 416:		Line 416:
	This formula will again check whether there is a name for a [[Neighborhood]] present. If there isn't, the cell is kept empty. But if there is, then the result of the calculation performed is shown here, formatted as a rounded percentage with a percentage sign behind it.		This formula will again check whether there is a name for a [[Neighborhood]] present. If there isn't, the cell is kept empty. But if there is, then the result of the calculation performed is shown here, formatted as a rounded percentage with a percentage sign behind it.

	Note that to format the data, the output of the formula in the cell itself is defined. Formatting of text or numbers in the [[Excel]] file as done as a visualization option in [[Microsoft Excel]] is ''not'' carried over to the {{software}}.		Note that to format the data, the output of the formula in the cell itself is defined. Formatting of text or numbers in the [[Excel]] file as done as a visualization option in Microsoft Excel is ''not'' carried over to the {{software}}.

	In cell '''V7''', change the text to "Neighborhood".		In cell '''V7''', change the text to "Neighborhood".

← Older revision		Revision as of 09:59, 26 November 2025
Line 352:		Line 352:
	This effectively means "for every [[Neighborhood]]".		This effectively means "for every [[Neighborhood]]".

	In the Indicator template [[Excel]] file, opened in [[Microsoft Excel]], select cell '''C9'''. This is one of the orange cells just above the dark-grey cells.		In the Indicator template [[Excel]] file, opened in [[Microsoft Excel]], select cell '''D9'''. This is one of the orange cells just above the dark-grey cells.

	Click in the address field, and enter the following text:		Click in the address field, and enter the following text:
Line 362:		Line 362:
	This query will obtain the name of the [[Neighborhood]], for every [[Neighborhood]]. Phrased differently: starting in the next row, a query will be executed for every [[Neighborhood]] on each row.		This query will obtain the name of the [[Neighborhood]], for every [[Neighborhood]]. Phrased differently: starting in the next row, a query will be executed for every [[Neighborhood]] on each row.

	Select cell '''D9'''. Click in the address field, and enter the following text:		Select cell '''E9'''. Click in the address field, and enter the following text:

	{{code\|1=SELECT_LOTSIZE_WHERE_NEIGHBORHOOD_IS_X}}		{{code\|1=SELECT_LOTSIZE_WHERE_NEIGHBORHOOD_IS_X}}
Line 368:		Line 368:
	Ensure the letters match exactly. Hit enter on the keyboard to confirm the name of the cell.		Ensure the letters match exactly. Hit enter on the keyboard to confirm the name of the cell.

	Select cell '''E9'''. Click in the address field, and enter the following text:		Select cell '''F9'''. Click in the address field, and enter the following text:

	{{code\|1=SELECT_LANDSIZE_WHERE_NEIGHBORHOOD_IS_X}}		{{code\|1=SELECT_LANDSIZE_WHERE_NEIGHBORHOOD_IS_X}}
Line 376:		Line 376:
	These queries will obtain the same data obtained in the previous, simpler example. However, now the results will be per [[Neighborhood]], and the name of the [[Neighborhood]] will be included as well.		These queries will obtain the same data obtained in the previous, simpler example. However, now the results will be per [[Neighborhood]], and the name of the [[Neighborhood]] will be included as well.

	For legibility, enter the texts "Name", "Lotsize", and "Landsize" as values in cells C7, D7, and E7 respectively.		For legibility, enter the texts "Name", "Lotsize", and "Landsize" as values in cells D7, E7, and F7 respectively.

	Next, the desired calculations can be defined.		Next, the desired calculations can be defined.

	Select cell '''~~K10~~'''. This is the first cell in the rows and columns of light-blue cells.		Select cell '''L10'''. This is the first cell in the rows and columns of light-blue cells.

	Enter the following formula:		Enter the following formula:

	{{code\|1==IF(~~E10~~=0;0;~~D10~~/~~E10~~)}}		{{code\|1==IF(F10=0;0;E10/F10)}}

	Hit enter on the keyboard to confirm the value of the cell.		Hit enter on the keyboard to confirm the value of the cell.
Line 390:		Line 390:
	This formula will see if there is a landsize defined. If there is (or more specifically, if the landsize is not zero), then the lotsize is divided by the landsize. This is the same calculation which happened in the earlier example. However, if the landsize is 0, then the result in this cell will be 0 as well.		This formula will see if there is a landsize defined. If there is (or more specifically, if the landsize is not zero), then the lotsize is divided by the landsize. This is the same calculation which happened in the earlier example. However, if the landsize is 0, then the result in this cell will be 0 as well.

	Select cell '''~~K10~~''' again.		Select cell '''L10''' again.

	The selection ~~boundáry~~ around the cell has a small square in the lower right corner that can be used to drag and expand the formula to other cells as well.		The selection boundary around the cell has a small square in the lower right corner that can be used to drag and expand the formula to other cells as well.

	Click-and-hold the square, and drag it downwards for a large number of rows (up to row 50 should be sufficient).		Click-and-hold the square, and drag it downwards for a large number of rows (up to row 50 should be sufficient).
Line 400:		Line 400:
	Finally, it is possible to configure the output for the [[Indicator]].		Finally, it is possible to configure the output for the [[Indicator]].

	Select cell '''~~U10~~'''. This is the first cell in the first green column, and is surrounded by pre-defined HTML for a table display. The value entered or calculated in this cell is shown in this place in the table which will appear in the [[indicator panel]].		Select cell '''V10'''. This is the first cell in the first green column, and is surrounded by pre-defined HTML for a table display. The value entered or calculated in this cell is shown in this place in the table which will appear in the [[indicator panel]].

	Enter the following formula:		Enter the following formula:

	{{code\|1==IF(~~C10~~="";"";~~C10~~)}}		{{code\|1==IF(D10="";"";D10)}}

	This formula means that if ~~C10~~ is empty, then leave this cell empty as well. This will only happen if, on this row, there is no information about a [[Neighborhood]]. However, if there is something in ~~C10~~, (which should be the name of the [[Neighborhood]], then that value is placed verbatim in this cell for output.		This formula means that if D10 is empty, then leave this cell empty as well. This will only happen if, on this row, there is no information about a [[Neighborhood]]. However, if there is something in D10, (which should be the name of the [[Neighborhood]], then that value is placed verbatim in this cell for output.

	Next, select cell '''~~W10~~'''. This is the first cell in the second green column. Whatever is entered here will also be shown in the table in the [[indicator panel]], but in the next column.		Next, select cell '''X10'''. This is the first cell in the second green column. Whatever is entered here will also be shown in the table in the [[indicator panel]], but in the next column.

	Enter the following formula:		Enter the following formula:

	{{code\|1==IF(~~C10~~="";""; ROUND(~~K10~~*100;0) & " %" )}}		{{code\|1==IF(D10="";""; ROUND(L10*100;0) & " %" )}}

	This formula will again check whether there is a name for a [[Neighborhood]] present. If there isn't, the cell is kept empty. But if there is, then the result of the calculation performed is shown here, formatted as a rounded percentage with a percentage sign behind it.		This formula will again check whether there is a name for a [[Neighborhood]] present. If there isn't, the cell is kept empty. But if there is, then the result of the calculation performed is shown here, formatted as a rounded percentage with a percentage sign behind it.
Line 418:		Line 418:
	Note that to format the data, the output of the formula in the cell itself is defined. Formatting of text or numbers in the [[Excel]] file as done as a visualization option in [[Microsoft Excel]] is ''not'' carried over to the {{software}}.		Note that to format the data, the output of the formula in the cell itself is defined. Formatting of text or numbers in the [[Excel]] file as done as a visualization option in [[Microsoft Excel]] is ''not'' carried over to the {{software}}.

	In cell '''U7''', change the text to "Neighborhood".		In cell '''V7''', change the text to "Neighborhood".

	In cell '''W7''', change the text to "Percentage built".		In cell '''X7''', change the text to "Percentage built".

	In cell '''Y7''', change the text to " " (a single space).		In cell '''Z7''', change the text to " " (a single space).

	In cell '''~~AA7~~''', change the text to " " (a single space).		In cell '''AB7''', change the text to " " (a single space).

	Select the range of cells '''~~T10~~ through ~~AB10~~'''.		Select the range of cells '''S10 through AC10'''.

	Use the square at the bottom-right of the selection boundary, and drag the selection downwards for a large number of rows (again up to row 50 should be sufficient).		Use the square at the bottom-right of the selection boundary, and drag the selection downwards for a large number of rows (again up to row 50 should be sufficient).