App Store Wiki

User Tools

Site Tools

Trace: • ui • how_to_run_app_store_connect_under_a_service_account • releasenotes • modify_data_storage_location • set_up_a_mode • asp-net-core-app
excel:ui

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
excel:ui [2022/08/17 15:23] – suexcel:ui [2022/08/17 15:40] (current) – [Advanced] su
Line 6: Line 6:
 {{:excel:ip_query_-_current_value_icon.png?400|}} {{:excel:ip_query_-_current_value_icon.png?400|}}
  
-Clicking "Get Current Value" allows you to configure a request to get the current value for some tags. +Clicking "Current Value" allows you to configure a request to get the current value for some tags. 
   * Select the relevant data source    * Select the relevant data source 
   * Enter a filter to search for tags available from that data source and click "Search"   * Enter a filter to search for tags available from that data source and click "Search"
Line 20: Line 20:
 {{:excel:ip_query_-_historical_values_icon.png?400|}} {{:excel:ip_query_-_historical_values_icon.png?400|}}
  
-Clicking "Get Historical Values" allows you to configure a request to get the historical values for some tags. +Clicking "Historical Values" allows you to configure a request to get the historical values for some tags. 
   * Select the relevant data source    * Select the relevant data source 
   * Enter a query to search for tags available from that data source   * Enter a query to search for tags available from that data source
   * Select the tag(s) you would like to query   * Select the tag(s) you would like to query
-  * Enter the start, end times, interval and data funciton for the query+  * Enter the start time, end time, interval and data function for the query
   * Enter the number of points (e.g. a 10 day query with interval 1h is 240 points)   * Enter the number of points (e.g. a 10 day query with interval 1h is 240 points)
   * Select whether you would like a header row and time stamps   * Select whether you would like a header row and time stamps
Line 82: Line 82:
   * **Tags** - The range of cells that contains the tag names you want to update   * **Tags** - The range of cells that contains the tag names you want to update
   * **Values** - The range of cells that contains the new values of the tags   * **Values** - The range of cells that contains the new values of the tags
-  * **CurrentValues** - [Optional] The range of cells that contains queries to the effected tags (so that they can be reloaded autmatically)+  * **CurrentValues** - [Optional] The range of cells that contains queries to the effected tags (so that they can be reloaded automatically)
  
 Each value in the Values range will be written to the corresponding tag in the Tags range. Tags whose corresponding Values  cell is empty will be ignored. Each value in the Values range will be written to the corresponding tag in the Tags range. Tags whose corresponding Values  cell is empty will be ignored.
Line 95: Line 95:
 ===== Advanced ===== ===== Advanced =====
  
-All text boxes can will be evaluated as a formula if they begin with "="+All text boxes can be evaluated as a formula if they begin with "="
  
 You can use the "Custom Tag" box to add tags that aren't listed, this is primarily useful if you want to query Alarm Analysis Meta tags. You can use the "Custom Tag" box to add tags that aren't listed, this is primarily useful if you want to query Alarm Analysis Meta tags.
excel/ui.1660749816.txt.gz · Last modified: 2022/08/17 15:23 by su