Excel Indicator: Difference between revisions
| Line 10: | Line 10: | ||
First create a new blank Excel, or use an existing one. In the image below you can see a created Excel with [[List_of_actions#Construction_Options|Function Categories]]. As an example, we are interested in calculating the percentage per construction type that are within a safe zone. In the Tygron Engine, a [[Terrain]] with the type SafeZone has already been created. | First create a new blank Excel, or use an existing one. In the image below you can see a created Excel with [[List_of_actions#Construction_Options|Function Categories]]. As an example, we are interested in calculating the percentage per construction type that are within a safe zone. In the Tygron Engine, a [[Terrain]] with the type SafeZone has already been created. | ||
[[File:Excel_quick_start_1.jpg|thumb|left|600px]] | [[File:Excel_quick_start_1.jpg|thumb|left|600px]] | ||
In order to get the amount of Floor Space of constructions within the SafeZone, a Cell can be given a particular Name: | |||
[[File:Excel_quick_start_1.jpg|thumb|left|600px]] | |||
The Name is shown in the upper left text field in the Excel. This Name is actually a query command that can be interpreted by the Tygron Engine, also known as [[TQL]]. In this case it says: | |||
<code>SELECT_FLOORSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_MAP_IS_MAQUETTE_AND_TERRAINTYPE_IS_SAFE_ZONE</code> | |||
This query is not hard to read or understand. To retrieve the total amount of Affordable (Social) Housing, the query is as followed: | |||
<code>SELECT_FLOORSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_MAP_IS_MAQUETTE</code> | |||
Revision as of 08:10, 1 July 2015
|
Please note: This page is currently being updated! |
Excel Indicator
The Excel Indicator is an indicator that uses an Excel to do the calculations. Spatial information can be send to the Excel and score and explanation information is retrieved from the Excel to show in the Indicator Panel.
Quick Start
First create a new blank Excel, or use an existing one. In the image below you can see a created Excel with Function Categories. As an example, we are interested in calculating the percentage per construction type that are within a safe zone. In the Tygron Engine, a Terrain with the type SafeZone has already been created.
In order to get the amount of Floor Space of constructions within the SafeZone, a Cell can be given a particular Name:
The Name is shown in the upper left text field in the Excel. This Name is actually a query command that can be interpreted by the Tygron Engine, also known as TQL. In this case it says:
SELECT_FLOORSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_MAP_IS_MAQUETTE_AND_TERRAINTYPE_IS_SAFE_ZONE
This query is not hard to read or understand. To retrieve the total amount of Affordable (Social) Housing, the query is as followed:
SELECT_FLOORSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_MAP_IS_MAQUETTE