Calculation panel: Difference between revisions

From Tygron Preview Support Wiki
Jump to navigation Jump to search
No edit summary
 
(73 intermediate revisions by 7 users not shown)
Line 1: Line 1:
==Calculation Panel==
 
The Calculation Panel can be found by hovering with your mouse over the arrow icon button. The Calculation Panel helps you to manage the calculation time of your project. For more guidelines on calculation time see [[Troubleshooting_calculation_performance|Troubleshooting calculation performance]]. <br>
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_panel.JPG|750px]]  
[[File:Recalculate panel.JPG||thumb|none|700px]]
<br>
 
<br>
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 reset how [[Indicator|indicators]], [[Panel|panels]] and [[Overlays|overlays]] are being calculated and provides an overview of the calculation time of some of the components in your project.  
 
<br>
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===
 
This option is by default turned on and ensures that whenever you make a change in the Editor, the [[Indicator|indicators]], [[Panel|panels]] and [[Overlays|overlays]] will be recalculated immediately. When the auto-update is not checked, you have to manually refresh the project, after making an adjustment, by choosing one of the following two Reset options (see below) or by clicking on the arrow icon.
==Auto-update indicators==
The arrow icon will indicate this by lighting up and the text: ''Manual Update Required'' will be visible in the Calculation panel. If no update is required, the text: ''Indicators up to date'' will be visible. Compare the three different states below.
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.
<br clear=all>
 
Compare the three different Project Update states below.
<gallery>
File:Auto_update_on2.jpg|150px|Auto update on
File:Auto_update_off2.jpg|150px|Auto update off but the project is up to date
File:Manual_update2.jpg|150px|Auto update is off and manual recalculation is required
</gallery>
 
==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 {{software}} 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 {{software}} 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 {{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.


<gallery>
<gallery>
File:Auto_update_on.JPG|150px|Auto update on
File:Scheduled_update_option1.jpg|200px|Scheduled Update (long running) option.
File:Auto_update_off.JPG|150px|Auto update off but the project is up to date
File:ScheduledUpdateNotification1.jpg|200px|Options to be notified (or not).
File:Manual_update.JPG|150px|Auto update off and manual recalculation is required
</gallery>
</gallery>


===Reset to Start Values and Reset X Queries===
==Reset Excel X-Queries==
Below an explanation of the difference between the two options:
{{main|X query (Excel)#Resetting X queries}}


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: 
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.
<br>SELECT....WHERE_AREA_IS_X<br>
In the {{software}} this query is translated to the following three queries:<br>
SELECT....WHERE_AREA_IS_0<br>
SELECT....WHERE_AREA_IS_1<br>
SELECT....WHERE_AREA_IS_2<br>


When using Reset to Start Values, for example if you changed an attribute of one of these areas, the three queries are recalculated.
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.
If you choose Reset 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 Reset to Start Values 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.
{{gallery
|Update_Indicators_option1.jpg|Update Indicators option
|ResetExcelXQueries1.jpg|Reset Excel X-Queries option
}}


====When to choose which option?====
===When to choose which option?===
Choose Reset to 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 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.  
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 one of these two 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==
[[File:Performance_overview.JPG|thumb|right|300px|Performance overview panel]]
{{main|Performance Overview}}
[[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.
<br clear=all>


===GPU overview===
{{clear}}
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).


<gallery widths=300px>
==GPU overview==
File:Busy.JPG|400px|One of the clusters is busy with another job
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. 
File:Cancel.JPG|600px|The calculation time of one of the components in your project is visible and the option to cancel it
 
<gallery>
File:Busy.JPG|200px|One of the clusters is busy with another job
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
Also take note of the Peak hours (from 9.00h till 17.00h), the maximum calculation time will then be one hour.
|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.