Excel Indicator - Revision history

Maxim@tygron.com: /* Example Setup */

2026-03-06T14:21:52Z

Example Setup

← Older revision		Revision as of 14:21, 6 March 2026
Line 42:		Line 42:

	===Example Setup===		===Example Setup===
	First create a new blank Excel workbook/ spreadsheet. In the image below you can see a spreadsheet with [[Function\|Function Categories]]. For the Lower Manhattan use case we are interested in calculating the amount of housing units per building type that are protected within a safe zone. In the {{software}}, a project, situated around Lower Manhattan, containing a Safe Zone [[Areas#Safe zone\|Areas]], has already been created. This project is conveniently named "Lower Manhattan". The Safe Zone terrain of this project has been imported from [[ArcGIS ~~online~~]], based on the National Flood Hazard Layer (NFHL) from the Federal Emergency Agency (FEMA).		First create a new blank Excel workbook/ spreadsheet. In the image below you can see a spreadsheet with [[Function\|Function Categories]]. For the Lower Manhattan use case we are interested in calculating the amount of housing units per building type that are protected within a safe zone. In the {{software}}, a project, situated around Lower Manhattan, containing a Safe Zone [[Areas#Safe zone\|Areas]], has already been created. This project is conveniently named "Lower Manhattan". The Safe Zone terrain of this project has been imported from [[ArcGIS Online]], based on the National Flood Hazard Layer (NFHL) from the Federal Emergency Agency (FEMA).
	<gallery>		<gallery>
	File:excel-func-cat-Q3-2015.jpg\|Spreadsheet with function categories		File:excel-func-cat-Q3-2015.jpg\|Spreadsheet with function categories

Maxim@tygron.com: /* Example Setup */

2026-03-06T14:21:06Z

Example Setup

← Older revision		Revision as of 14:21, 6 March 2026
Line 42:		Line 42:

	===Example Setup===		===Example Setup===
	First create a new blank Excel workbook/ spreadsheet. In the image below you can see a spreadsheet with [[Function\|Function Categories]]. For the Lower Manhattan use case we are interested in calculating the amount of housing units per building type that are protected within a safe zone. In the {{software}}, a project, situated around Lower Manhattan, containing a Safe Zone [[Areas#Safe zone\|Areas]], has already been created. This project is conveniently named "Lower Manhattan". The Safe Zone terrain of this project has been imported from [[ArcGIS]], based on the National Flood Hazard Layer (NFHL) from the Federal Emergency Agency (FEMA).		First create a new blank Excel workbook/ spreadsheet. In the image below you can see a spreadsheet with [[Function\|Function Categories]]. For the Lower Manhattan use case we are interested in calculating the amount of housing units per building type that are protected within a safe zone. In the {{software}}, a project, situated around Lower Manhattan, containing a Safe Zone [[Areas#Safe zone\|Areas]], has already been created. This project is conveniently named "Lower Manhattan". The Safe Zone terrain of this project has been imported from [[ArcGIS online]], based on the National Flood Hazard Layer (NFHL) from the Federal Emergency Agency (FEMA).
	<gallery>		<gallery>
	File:excel-func-cat-Q3-2015.jpg\|Spreadsheet with function categories		File:excel-func-cat-Q3-2015.jpg\|Spreadsheet with function categories

Maxim@tygron.com at 15:47, 4 March 2026

2026-03-04T15:47:41Z

← Older revision		Revision as of 15:47, 4 March 2026
Line 1:		Line 1:
	The Excel Indicator is an [[Indicators\|indicator]] that uses a Microsoft Excel File to perform calculations. Spatial information can be send to an uploaded Excel spreadsheet and score and explanation information is retrieved from the file to be displayed in the project main view.		The Excel Indicator is an [[Indicators\|indicator]] that uses a Microsoft [[Excel]] File to perform calculations. Spatial information can be send to an uploaded Excel spreadsheet and score and explanation information is retrieved from the file to be displayed in the project main view.

	Please note that the full offline version of Microsoft Excel is required and the file format used is the xlsx-format. Also, we can not guarantee that other (open source and online MS Office) packages offer the same functionality as the full offline version of Microsoft Excel, such as the naming of cells and expandable entry fields for longer cell names.		Please note that the full offline version of Microsoft Excel is required and the file format used is the xlsx-format. Also, we can not guarantee that other (open source and online MS Office) packages offer the same functionality as the full offline version of Microsoft Excel, such as the naming of cells and expandable entry fields for longer cell names.

Rudolf@tygron.nl at 10:30, 25 February 2026

2026-02-25T10:30:51Z

← Older revision		Revision as of 10:30, 25 February 2026
Line 42:		Line 42:

	===Example Setup===		===Example Setup===
	First create a new blank Excel workbook/ spreadsheet. In the image below you can see a spreadsheet with [[Function\|Function Categories]]. For the Lower Manhattan use case we are interested in calculating the amount of housing units per building type that are protected within a safe zone. In the {{software}}, a project, situated around Lower Manhattan, containing a Safe Zone [[Areas#Safe zone\|Areas]], has already been created. This project is conveniently named "Lower Manhattan". The Safe Zone terrain of this project has been imported from [~~https://www.arcgis.com/features~~ ArcGIS], based on the National Flood Hazard Layer (NFHL) from the Federal Emergency Agency (FEMA).		First create a new blank Excel workbook/ spreadsheet. In the image below you can see a spreadsheet with [[Function\|Function Categories]]. For the Lower Manhattan use case we are interested in calculating the amount of housing units per building type that are protected within a safe zone. In the {{software}}, a project, situated around Lower Manhattan, containing a Safe Zone [[Areas#Safe zone\|Areas]], has already been created. This project is conveniently named "Lower Manhattan". The Safe Zone terrain of this project has been imported from [[ArcGIS]], based on the National Flood Hazard Layer (NFHL) from the Federal Emergency Agency (FEMA).
	<gallery>		<gallery>
	File:excel-func-cat-Q3-2015.jpg\|Spreadsheet with function categories		File:excel-func-cat-Q3-2015.jpg\|Spreadsheet with function categories

Rudolf@tygron.nl: /* Extras */

2025-11-19T11:03:24Z

Extras

← Older revision		Revision as of 11:03, 19 November 2025
Line 468:		Line 468:
	* [[TQL]]		* [[TQL]]
	\|howtos=		\|howtos=
	*[[How to configure a Query for an Excel Indicator]]		* [[How to configure a Query for an Excel Indicator]]
	*[[How to create an Excel background calculation model]]		* [[How to create an Excel background calculation model]]
	*[[How to implement an Excel Indicator]]		* [[How to implement an Excel Indicator]]
	*[[How to manually adjust Indicators in Excel]]		* [[How to manually adjust Indicators in Excel]]
	*[[How to use the Query Tool to test queries from an Excel Indicator spreadsheet]]		* [[How to use the Query Tool to test queries from an Excel Indicator spreadsheet]]
			* [[How to refer to a Grid by Attribute when using TQL]]
	}}{{Indicator nav}}		}}{{Indicator nav}}
	[[Category:TQL]][[Category:How-to's]][[Category:Indicator]]		[[Category:TQL]][[Category:How-to's]][[Category:Indicator]]

Rudolf@tygron.nl at 05:42, 8 September 2025

2025-09-08T05:42:50Z

← Older revision		Revision as of 05:42, 8 September 2025
Line 287:		Line 287:

	===Indicator Scores===		===Indicator Scores===
	To be able to generate scores from the Excel indicator, there needs to be ~~either one~~ cell named <code>SCORE</code>.		To be able to generate scores from the Excel indicator, there needs to be a cell named <code>SCORE</code>.
	~~<br />~~
	[[File:ExcelScorePlanned-Q3-2015.jpg\|thumb\|left\|<code>SCORE</code> output]]		[[File:ExcelScorePlanned-Q3-2015.jpg\|thumb\|left\|<code>SCORE</code> output]]
	~~<br~~ clear~~=all>~~		{{clear}}

	===Explanation===		===Explanation===
Line 296:		Line 295:

	[[File:ExcelIndicatorPanelExplanation2-Q3-2015.jpg\|thumb\|left\|Explanation field on Indicator Panel]]		[[File:ExcelIndicatorPanelExplanation2-Q3-2015.jpg\|thumb\|left\|Explanation field on Indicator Panel]]
	~~<br~~ clear~~=all>~~		{{clear}}
	====Simple text string as EXPLANATION output====		====Simple text string as EXPLANATION output====
	A simple HTML text string as <code>EXPLANATION</code> output can be written as follows:		A simple HTML text string as <code>EXPLANATION</code> output can be written as follows:

Maxim@tygron.com: /* Prerequisites */

2025-09-06T09:59:03Z

Prerequisites

← Older revision		Revision as of 09:59, 6 September 2025
Line 29:		Line 29:
	<gallery>		<gallery>
	File:ExcelExplanation-Q3-2015.jpg\|<code>EXPLANATION</code>		File:ExcelExplanation-Q3-2015.jpg\|<code>EXPLANATION</code>
	~~File:ExcelScoreMaquette-Q3-2015.jpg\|<code>SCORE_MAQUETTE</code>~~
	~~File:ExcelScoreCurrent-Q3-2015.jpg\|<code>SCORE_CURRENT</code>~~
	File:ExcelVar_0-Q3-2015.jpg\|<code>VAR_0</code>		File:ExcelVar_0-Q3-2015.jpg\|<code>VAR_0</code>
	File:Excel_s_Variable-Q3-2015.jpg\|<code>%s</code> variable		File:Excel_s_Variable-Q3-2015.jpg\|<code>%s</code> variable

Maxim@tygron.com: /* Exact */

2025-09-06T09:58:27Z

Exact

← Older revision		Revision as of 09:58, 6 September 2025
Line 424:		Line 424:

	: <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_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_NUMBER_VALUE_CURRENT</code>: A numerical value for the current situation that is formatted using the unit system selected for your project. Replaces the indicator's progress bar.~~
	~~: <code>EXACT_NUMBER_VALUE_MAQUETTE</code>: A numerical value for the maquette situation 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.		: <code>EXACT_TEXT_VALUE</code>: A text value that will be used instead of the progress bar.
	~~: <code>EXACT_TEXT_VALUE_CURRENT</code>: A text value for the current situation that will be used instead of the progress bar.~~
	~~: <code>EXACT_TEXT_VALUE_MAQUETTE</code>: A text value for the maquette situation that will be used instead of the progress bar.~~

	==Upload an Excel file==		==Upload an Excel file==

Maxim@tygron.com: /* Indicator Scores */

2025-09-06T09:56:57Z

Indicator Scores

← Older revision		Revision as of 09:56, 6 September 2025
Line 289:		Line 289:

	===Indicator Scores===		===Indicator Scores===
	To be able to generate scores from the Excel indicator, there needs to be either one cell named <code>SCORE</code>, or two cells named <code>SCORE_CURRENT</code> and <code>SCORE_MAQUETTE</code>. The <code>SCORE_MAQUETTE</code> and <code>SCORE_CURRENT</code> queries can be used to indicate the difference between the planned outcome and the original (current) situation.		To be able to generate scores from the Excel indicator, there needs to be either one cell named <code>SCORE</code>.
	<br />		<br />
	[[File:ExcelScorePlanned-Q3-2015.jpg\|thumb\|left\|<code>SCORE</code> output]]		[[File:ExcelScorePlanned-Q3-2015.jpg\|thumb\|left\|<code>SCORE</code> output]]

Maxim@tygron.com: /* SCORE */

2025-09-06T09:56:30Z

SCORE

← Older revision		Revision as of 09:56, 6 September 2025
Line 259:		Line 259:
	: These cells can contain different formulas. In general the score is a percentage of the scoring value on as a fraction of the total value.		: These cells can contain different formulas. In general the score is a percentage of the scoring value on as a fraction of the total value.

	: <code>~~SCORE_CURRENT</code>: <code>=E7/IF(D7;D7;1)</code> = In safe zone current (SZC)/ Total Current (if Total Current > 0, with one decimal significance)~~		: <code>SCORE</code>: <code>=G7/IF(I7;I7;1)</code> = In safe zone planned (SZP)/ Total Plannend (if Total Planned > 0, with one decimal significance)
	~~: <code>SCORE_MAQUETTE~~</code>: <code>=G7/IF(I7;I7;1)</code> = In safe zone planned (SZP)/ Total Plannend (if Total Planned > 0, with one decimal significance)

	===Editing Named Cells===		===Editing Named Cells===

← Older revision		Revision as of 09:59, 6 September 2025
Line 29:		Line 29:
	<gallery>		<gallery>
	File:ExcelExplanation-Q3-2015.jpg\|<code>EXPLANATION</code>		File:ExcelExplanation-Q3-2015.jpg\|<code>EXPLANATION</code>
	~~File:ExcelScoreMaquette-Q3-2015.jpg\|<code>SCORE_MAQUETTE</code>~~
	~~File:ExcelScoreCurrent-Q3-2015.jpg\|<code>SCORE_CURRENT</code>~~
	File:ExcelVar_0-Q3-2015.jpg\|<code>VAR_0</code>		File:ExcelVar_0-Q3-2015.jpg\|<code>VAR_0</code>
	File:Excel_s_Variable-Q3-2015.jpg\|<code>%s</code> variable		File:Excel_s_Variable-Q3-2015.jpg\|<code>%s</code> variable