Calculation panel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
 
(22 intermediate revisions by 6 users not shown)
Line 1: Line 1:


The Calculation Panel helps you to manage the calculation time of your project. The Calculation Panel can be found by hovering with your mouse over the Refresh button, under the File menu tab in the top left corner.
The Calculation Panel helps you to manage the calculation time of your project. The Calculation Panel can be found by hovering with your mouse over the Refresh button, under the File menu tab in the top left corner.
[[File:Recalculate_panel2.jpg||thumb|none|700px]]
[[File:Recalculate panel.JPG||thumb|none|700px]]


The options in this panel will allow you to set up how [[Indicator|indicators]], [[Panel|panels]] and [[Overlay]]s are being (re)calculated and provide an overview of the calculation time of some of the components in your project. For more guidelines on calculation performance see [[Troubleshooting_calculation_performance|Troubleshooting calculation performance]].
The options in this panel will allow you to set up how [[Indicator|indicators]], [[Panel|panels]] and [[Overlay]]s are being (re)calculated and provide an overview of the calculation time of some of the components in your project. For more guidelines on calculation performance see [[Troubleshooting_calculation_performance|Troubleshooting calculation performance]].
In the top of the panel, you can find information on the total amount of grid cells in your project. This amount of grid cells relates to the [[Grid_Overlay#Grid_size|Grid size]] and influences the performance.


==Auto-update indicators==
==Auto-update indicators==
The Auto-update option is by default enabled and ensures that whenever you make a change in the Editor, the indicators, panels and overlays will be recalculated immediately. When Auto-update is disabled, you will have to manually refresh the project after making any adjustment. You can refresh the project manually by choosing one of the available options; [[#Scheduled Update (long running)|Scheduled Update (long running)]], [[#Update Indicators and Reset Excell X-Queries|Update Indicators]]. Clicking on the Refresh button itself triggers the Update Indicators option.
The Auto-update option is by default enabled and ensures that whenever you make a change in the Editor, the indicators, panels and overlays will be recalculated immediately. When Auto-update is disabled, you will have to manually refresh the project after making any adjustment. You can refresh the project manually by choosing one of the available options; [[#Scheduled Update (long running)|Scheduled Update (long running)]], [[#Update Indicators and Reset Excel X-Queries|Update Indicators or Reset Excel X-Queries]]. Clicking on the Auto-update button itself triggers the Update Indicators option.


Compare the three different Project Update states below.
Compare the three different Project Update states below.
Line 22: Line 24:
When scheduling a long running calculation, the user will be prompted whether and how to be alerted when the calculation completes. It's possible to be alerted via email, in which case an email is sent to the email address of the user, or via SMS, in which case an SMS text message will be sent to the user's registered phone number (or one entered at the time of scheduling). It is also possible to forgo an alert. In addition, opting to schedule a long running calculations will automatically put the session in [[Keep Alive]] mode. This means the {{software}} can be closed on the user's computer, and the [[Session]] will remain active, allowing a user to reconnect to the [[Session]] within a week.
When scheduling a long running calculation, the user will be prompted whether and how to be alerted when the calculation completes. It's possible to be alerted via email, in which case an email is sent to the email address of the user, or via SMS, in which case an SMS text message will be sent to the user's registered phone number (or one entered at the time of scheduling). It is also possible to forgo an alert. In addition, opting to schedule a long running calculations will automatically put the session in [[Keep Alive]] mode. This means the {{software}} can be closed on the user's computer, and the [[Session]] will remain active, allowing a user to reconnect to the [[Session]] within a week.


Like with shorter calculations, if all calculation resources which allow long running calculations are already in use, the calculation remains queued until resources free up. If calculation resources are free when the calculation is scheduled, the calculation will still be queued, but then start calculating immediately.
Like with shorter calculations, if all calculation resources which allow long running calculations are already in use, the calculation remains queued until resources free up.  


<gallery>
<gallery>
Line 29: Line 31:
</gallery>
</gallery>


==Update Indicators and Reset Excell X-Queries==
==Reset Excel X-Queries==
<gallery>
{{main|X query (Excel)#Resetting X queries}}
File:Update_Indicators_option1.jpg|Update Indicators option
File:ResetExcelXQueries1.jpg|Reset Excell X-Queries option
</gallery>


Below an explanation of the difference between the two options:
Often, [[Excel]]s for [[Indicator]]s or [[Panel]]s use [[X-Queries]]. These queries are interpreted by the {{software}} as "for every" of a certain [[Item]]. For example, {code|1=WHERE_AREA_IS_X}} will resolve to multiple queries, one for every Area. These individual queries are then reused whenever a calculation is performed.


Most of the time, in an Indicator Excelsheet [[Excel#X_Queries|X-Queries]] are used. If you have for example three areas in your project, an X-Query would be as follows:<br>
When new [[Item]]s matching the [[X-Query]] are added, or such [[Item]]s are removed, it is necessary to use the "Reset X-Queries" option, to force the {{software}} to re-evaluate for which [[Item]]s individual queries should be generated. If queries are not reset before performing a new calculation, added [[Item]]s will not be included in the calculation, and removed [[Item]]s will mean queries exist referencing a non-existent [[Item]], which will result in an error.


* SELECT....WHERE_AREA_IS_X<br>
{{gallery
 
|Update_Indicators_option1.jpg|Update Indicators option
In the {{software}} this query is translated to the following three queries:<br>
|ResetExcelXQueries1.jpg|Reset Excel X-Queries option
 
}}
* SELECT....WHERE_AREA_IS_0<br>
* SELECT....WHERE_AREA_IS_1<br>
* SELECT....WHERE_AREA_IS_2<br>
 
When using Update Indicators, for example if you changed an attribute of one of these areas, the three queries are recalculated.  
If you choose Reset Excell X-Queries, the X-Query is again translated to queries. If you for example added a new area, in the {{software}} the X-Query is then translated to:<br>
 
* SELECT....WHERE_AREA_IS_0<br>
* SELECT....WHERE_AREA_IS_1<br>
* SELECT....WHERE_AREA_IS_2<br>
* SELECT....WHERE_AREA_IS_3<br>
 
If you used Update Indicators in this case, the fourth area was not taken into account, since the three queries would be recalculated again and the {{software}} would not translate the X-Query to other queries.


===When to choose which option?===
===When to choose which option?===
Choose Reset Excell X-Queries if the amount of areas or neighborhoods is changed (for example by adding or removing an area/neighborhood).  
Choose Reset Excel X-Queries if the amount of [[area]]s or [[neighborhood]]s is changed (for example by adding or removing an area/neighborhood).  
Choose Update Indicators 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.  
Choose Update Indicators 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 any one of these option affects ''all'' indicators, panels and grid overlays.''
''Using any one of these option affects ''all'' [[indicator]]s, [[panel]]s and [[grid Overlay]]s.''


===Performance overview===
==Performance overview==
{{main|Performance Overview}}
[[File:Performance_overview.JPG|thumb|right|200px|Performance overview panel]]
[[File:Performance_overview.JPG|thumb|right|200px|Performance overview panel]]
The performance overview shows an overview of the components in a project and their calculation time. If your project performance is slow, check the overview to see which component(s) could cause this.
The performance overview shows an overview of the components in a project and their calculation time. If your project performance is slow, check the overview to see which component(s) could cause this.


See also:
{{clear}}
[[File:YoutubeLogo1.jpg|thumb|200px|left|link=https://youtu.be/jZIArca3l8A|Uitleg Performance Overview Paneel (Dutch only)]]
 
<br clear=all>


==GPU overview==
==GPU overview==
The GPU cluster overview shows the different GPU clusters that are available for calculation and their status. If they are busy with calculating components of another project, it will be visible here. Also your own calculation jobs will be visible in the panel and the possibility to cancel your own calculation(s), by clicking on the cancel icon (see image).  
The GPU cluster overview shows the different GPU clusters that are available for calculation and their status. If they are busy with calculating components of other projects of other users, it will be visible here. Also your own calculation jobs will be visible in the panel and the possibility to cancel your own calculation(s), by clicking on the cancel icon (see image). The GPU clusters where short is stated are used for short calculations (max 30 minutes). The other GPU clusters are available for [[Calculation_panel#Scheduled Update (long running)|Long running scheduled]] calculations. 


<gallery>
<gallery>
Line 79: Line 63:
File:Cancel.JPG|200px|The calculation time of one of the components in your project is visible and the option to cancel it
File:Cancel.JPG|200px|The calculation time of one of the components in your project is visible and the option to cancel it
</gallery>
</gallery>
{{article end
|seealso=
*[[Ribbon]]
*[[Grid Overlay]]s
*[[Indicator]]s
|howtos=
*[[How to delay Grid Overlay calculations]]
}}
{{editor ui nav}}

Latest revision as of 10:58, 1 February 2024

The Calculation Panel helps you to manage the calculation time of your project. The Calculation Panel can be found by hovering with your mouse over the Refresh button, under the File menu tab in the top left corner.

Recalculate panel.JPG

The options in this panel will allow you to set up how indicators, panels and Overlays are being (re)calculated and provide an overview of the calculation time of some of the components in your project. For more guidelines on calculation performance see Troubleshooting calculation performance.

In the top of the panel, you can find information on the total amount of grid cells in your project. This amount of grid cells relates to the Grid size and influences the performance.

Auto-update indicators

The Auto-update option is by default enabled and ensures that whenever you make a change in the Editor, the indicators, panels and overlays will be recalculated immediately. When Auto-update is disabled, you will have to manually refresh the project after making any adjustment. You can refresh the project manually by choosing one of the available options; Scheduled Update (long running), Update Indicators or Reset Excel X-Queries. Clicking on the Auto-update button itself triggers the Update Indicators option.

Compare the three different Project Update states below.

Scheduled Update (long running)

Calculations are capped at a maximum calculation time of 30 minutes. This means that if a calculation takes longer than 30 minutes it reaches a "timeout" and calculates no further. This is to ensure fair use of the calculation capacity of the Tygron Platform between all customers.

When a calculation is expected to take longer than 30 minutes, it is possible to schedule a long running calculation. This means the Tygron Platform allocates specific calculation resources without a time limit, which should not hinder other calculations taking shorter amounts of time.

When scheduling a long running calculation, the user will be prompted whether and how to be alerted when the calculation completes. It's possible to be alerted via email, in which case an email is sent to the email address of the user, or via SMS, in which case an SMS text message will be sent to the user's registered phone number (or one entered at the time of scheduling). It is also possible to forgo an alert. In addition, opting to schedule a long running calculations will automatically put the session in Keep Alive mode. This means the Tygron Platform can be closed on the user's computer, and the Session will remain active, allowing a user to reconnect to the Session within a week.

Like with shorter calculations, if all calculation resources which allow long running calculations are already in use, the calculation remains queued until resources free up.

Reset Excel X-Queries

Main article: X query (Excel)#Resetting X queries

Often, Excels for Indicators or Panels use X-Queries. These queries are interpreted by the Tygron Platform as "for every" of a certain Item. For example, {code|1=WHERE_AREA_IS_X}} will resolve to multiple queries, one for every Area. These individual queries are then reused whenever a calculation is performed.

When new Items matching the X-Query are added, or such Items are removed, it is necessary to use the "Reset X-Queries" option, to force the Tygron Platform to re-evaluate for which Items individual queries should be generated. If queries are not reset before performing a new calculation, added Items will not be included in the calculation, and removed Items will mean queries exist referencing a non-existent Item, which will result in an error.



When to choose which option?

Choose Reset Excel X-Queries if the amount of areas or neighborhoods is changed (for example by adding or removing an area/neighborhood). Choose Update Indicators 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 any one of these option affects all indicators, panels and grid Overlays.

Performance overview

Main article: Performance Overview
Performance overview panel

The performance overview shows an overview of the components in a project and their calculation time. If your project performance is slow, check the overview to see which component(s) could cause this.

GPU overview

The GPU cluster overview shows the different GPU clusters that are available for calculation and their status. If they are busy with calculating components of other projects of other users, it will be visible here. Also your own calculation jobs will be visible in the panel and the possibility to cancel your own calculation(s), by clicking on the cancel icon (see image). The GPU clusters where short is stated are used for short calculations (max 30 minutes). The other GPU clusters are available for Long running scheduled calculations.