Calculation panel

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.