Indicators Tutorial - Revision history

Rudolf@tygron.nl: /* Placeholder data */

2026-07-30T09:45:12Z

Placeholder data

← Older revision		Revision as of 09:45, 30 July 2026
Line 880:		Line 880:
	These values are again temporary stand-ins for what kind of data might be injected by the {{software}} upon (re)calculation.		These values are again temporary stand-ins for what kind of data might be injected by the {{software}} upon (re)calculation.

	See the results of the fomulas in cells '''N10''', '''~~O10~~''', ~~and~~ '''~~P10~~''', ~~and~~ '''~~V10~~''' and '''~~X10~~'''. Notice how now that there is data to calculate, intermediate and final results are calculated and displayed.		See the results of the fomulas in cells '''N10''', and '''Y10''', '''AA10''', '''AC10''' and '''AE10'''. Notice how now that there is data to calculate, intermediate and final results are calculated and displayed.

	[[File:Indicator tutorial 05 26 placeholder results.jpg\|frame\|center\|TODO]]		[[File:Indicator tutorial 05 26 placeholder results.jpg\|frame\|center\|TODO]]

Rudolf@tygron.nl: /* Outputs */

2026-07-30T09:40:28Z

Outputs

← Older revision		Revision as of 09:40, 30 July 2026
Line 861:		Line 861:
	[[File:Indicator tutorial 05 23 titles.jpg\|frame\|center\|TODO]]		[[File:Indicator tutorial 05 23 titles.jpg\|frame\|center\|TODO]]

	Select the range of cells '''~~T10~~ through AF10'''.		Select the range of cells '''N10 through AF10'''. (This covers both the newly created calculation as well as the newly created outputs.)

	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).

Rudolf@tygron.nl: /* Outputs */

2026-07-30T09:34:37Z

Outputs

← Older revision		Revision as of 09:34, 30 July 2026
Line 851:		Line 851:
	[[File:Indicator tutorial 05 22 AE10 formula.jpg\|frame\|center\|TODO]]		[[File:Indicator tutorial 05 22 AE10 formula.jpg\|frame\|center\|TODO]]

	In cell '''W7''', change the text to "Size".		In cell '''Y7''', change the text to "Size".

	In cell '''AA7''', change the text to "Average traffic noise".		In cell '''AA7''', change the text to "Average traffic noise".

Rudolf@tygron.nl: /* Outputs */

2026-07-30T09:30:57Z

Outputs

← Older revision		Revision as of 09:30, 30 July 2026
Line 833:		Line 833:

	Right-click on column '''AD''', and click on "Insert copied cells".		Right-click on column '''AD''', and click on "Insert copied cells".
			[[File:Indicator tutorial 05 19 insert.jpg\|frame\|center\|TODO]]

			2 new columns are now added to the output.

	[[File:Indicator tutorial 05 20 added.jpg\|frame\|center\|TODO]]		[[File:Indicator tutorial 05 20 added.jpg\|frame\|center\|TODO]]

	~~2 new columns are now added to the output.~~ Note that in this operation, a column was copied from ''inside'' the table, and inserted ''into'' the table. This is important because the first and last columns of the table html have slightly different syntax to properly create the rows desired.		Note that in this operation, a column was copied from ''inside'' the table, and inserted ''into'' the table. This is important because the first and last columns of the table html have slightly different syntax to properly create the rows desired.

	Select cell '''AE10'''.		Select cell '''AE10'''.

Rudolf@tygron.nl: /* Outputs */

2026-07-30T09:26:26Z

Outputs

← Older revision		Revision as of 09:26, 30 July 2026
Line 828:		Line 828:
	Now, one more column should be added to the output of the [[Excel]], so that the amount of significantly affected housing units can be displayed as well.		Now, one more column should be added to the output of the [[Excel]], so that the amount of significantly affected housing units can be displayed as well.

	Select ~~column~~ '''AB''' and '''AC'''and right-click on them, and click on "copy"		Select columns '''AB''' and '''AC''' and right-click on them, and click on "copy"

	[[File:Indicator tutorial 05 19 selected.jpg\|frame\|center\|TODO]]		[[File:Indicator tutorial 05 19 selected.jpg\|frame\|center\|TODO]]

Rudolf@tygron.nl: /* Deploy the new Indicator */

2026-07-30T08:14:43Z

Deploy the new Indicator

← Older revision		Revision as of 08:14, 30 July 2026
Line 689:		Line 689:

	[[File:Indicator tutorial 04 26 indicator panel.jpg\|frame\|center\|TODO]]		[[File:Indicator tutorial 04 26 indicator panel.jpg\|frame\|center\|TODO]]

			Note that, for now, the "score" in the Excel template has not been configured. There is a "SCORE" cell, otherwise using the Excel for an [[Indicator]] would result in an error. However, the cell is left with the default of 1, meaning the [[Indicator]] will always display 100%.

	===Creating overviews of grid results===		===Creating overviews of grid results===

Rudolf@tygron.nl: /* Placeholder data */

2026-07-30T07:29:25Z

Placeholder data

← Older revision		Revision as of 07:29, 30 July 2026
Line 636:		Line 636:
	Select cell '''F10''', and enter as content "2000".		Select cell '''F10''', and enter as content "2000".

	[[File:Indicator tutorial 04 18 placeholders.jpg\|frame\|center\|TODO]		[[File:Indicator tutorial 04 18 placeholders.jpg\|frame\|center\|TODO]]

	These values are temporary stand-ins for what kind of data might be injected by the {{software}} upon (re)calculation.		These values are temporary stand-ins for what kind of data might be injected by the {{software}} upon (re)calculation.

Rudolf@tygron.nl: /* Outputs */

2026-07-30T07:23:39Z

Outputs

← Older revision		Revision as of 07:23, 30 July 2026
Line 620:		Line 620:
	[[File:Indicator tutorial 04 16 titles.jpg\|frame\|center\|TODO]]		[[File:Indicator tutorial 04 16 titles.jpg\|frame\|center\|TODO]]

	Select the range of cells '''S10 through ~~AC10~~'''.		Select the range of cells '''S10 through AF10'''.

	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).

Rudolf@tygron.nl: /* Outputs */

2026-07-30T07:17:38Z

Outputs

← Older revision		Revision as of 07:17, 30 July 2026
Line 594:		Line 594:
	[[File:Indicator tutorial 04 13 V10 filled.jpg\|frame\|center\|TODO]]		[[File:Indicator tutorial 04 13 V10 filled.jpg\|frame\|center\|TODO]]

	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.		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 '''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.		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.

Rudolf@tygron.nl: /* Calculations */

2026-07-30T06:44:15Z

Calculations

← Older revision		Revision as of 06:44, 30 July 2026
Line 560:		Line 560:
	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 prevents errors caused by dividing by 0.		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 prevents errors caused by dividing by 0.

	For legibility, enter the text "Built fraction" in cell '''V7'''.		For legibility, enter the text "Built fraction" in cell '''L7'''.

	[[File:Indicator tutorial 04 08 calculation title.jpg\|frame\|center\|TODO]]		[[File:Indicator tutorial 04 08 calculation title.jpg\|frame\|center\|TODO]]