Calculation panel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 1: Line 1:
Recalculate indicators is an option in the [[editor#editor menu bar|editor menu bar]] that will allow you to reset how [[indicators]] are calculated. By pressing "recalculate indicators", the current scores for the indicators will serve as the baseline for the indicator scores to be calculated. The current values will score 0% exactly on each indicator.
Recalculate indicators is an option in the [[editor#editor menu bar|editor menu bar]] that will allow you to reset how Excelsheets are calculated.  
There are two options to recalculate indicators.
* Reset to Start Values
* Reset X-queries
Below an explanation of the difference between the two options:


For example: If a project is made with 20 houses, and an indicator with a target for 100 houses, the indicator will start at 20%. Constructing 40 houses will make the total houses 60, raise the indicator to 60%. When the indicators are recalculated when there are 20 houses, the indicator will start at 0%. Constructing 40 houses will make the total houses 60, but will only raise the indicator to 50%. This is because 40 houses only represents 50% or the houses required to get from 20 houses to 100 houses.
Most of the time, in an Excelsheet X-queries are used. If you have for example three areas in your project, an X-query would be as follows: 
SELECT....WHERE_AREA_IS_X.
In the Engine this query is translated to the following three queries:
SELECT....WHERE_AREA_IS_0
SELECT....WHERE_AREA_IS_1
SELECT....WHERE_AREA_IS_2


'''Using this option affects ''all'' indicators.'''
When using Reset to Start Values, for example if you changed an attribute of one o these areas, the three ID-queries are recalculated.
If you choose Reset X-queries, the X-query is again translated to ID-queries. If you for example added a new area, in the Engine the X-query is then translated to:
SELECT....WHERE_AREA_IS_0
SELECT....WHERE_AREA_IS_1
SELECT....WHERE_AREA_IS_2
SELECT....WHERE_AREA_IS_3
 
If you used Reset to Start Values in this case, the fourth area was not taken into account, since the three ID-queries would be recalculated again and the Engine would not check if an area was added or removed.
 
====When to choose which option?====
Choose Reset to X-queries if the amount of areas or neighborhoods is changed (for example by adding of removing an area).
Choose Reset to Start Values if the amount of areas or neighborhoods stays the same (for example if you only changed an attribute of an area or if you did not use X-queries in your Excelsheet.
 
'''Using one of these two option affects ''all'' indicators.'''

Revision as of 13:25, 26 January 2018

Recalculate indicators is an option in the editor menu bar that will allow you to reset how Excelsheets are calculated. There are two options to recalculate indicators.

  • Reset to Start Values
  • Reset X-queries

Below an explanation of the difference between the two options:

Most of the time, in an Excelsheet X-queries are used. If you have for example three areas in your project, an X-query would be as follows: SELECT....WHERE_AREA_IS_X. In the Engine this query is translated to the following three queries: SELECT....WHERE_AREA_IS_0 SELECT....WHERE_AREA_IS_1 SELECT....WHERE_AREA_IS_2

When using Reset to Start Values, for example if you changed an attribute of one o these areas, the three ID-queries are recalculated. If you choose Reset X-queries, the X-query is again translated to ID-queries. If you for example added a new area, in the Engine the X-query is then translated to: SELECT....WHERE_AREA_IS_0 SELECT....WHERE_AREA_IS_1 SELECT....WHERE_AREA_IS_2 SELECT....WHERE_AREA_IS_3

If you used Reset to Start Values in this case, the fourth area was not taken into account, since the three ID-queries would be recalculated again and the Engine would not check if an area was added or removed.

When to choose which option?

Choose Reset to X-queries if the amount of areas or neighborhoods is changed (for example by adding of removing an area). Choose Reset to Start Values if the amount of areas or neighborhoods stays the same (for example if you only changed an attribute of an area or if you did not use X-queries in your Excelsheet.

Using one of these two option affects all indicators.

Retrieved from "https://support.tygron.com/w/index.php?title=Calculation_panel&oldid=13602"