Grid Overlay Area Measurement (Panel): Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (21 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
Template panel that can be applied on Areas. This excel calculates and creates a line chart of [[Select gridavg (TQL)|Grid Averages]] within a specific [[Area]] per timeframe for a [[Grid Overlay]]. The Grid Overlay is identified by specifying the [[Attribute]] '''AREA_MEASUREMENT''' with a value 1. | |||
[[File:Grid_overlay_area_measurement_line_chart.png|thumb|right|A Panel instance of this Template Excel showing the calculated average values within an area of a Surface Value result of a Water Overlay simulation.]] | |||
{{editor steps|title=import and configure the Grid Overlay Area Measurement panel | |||
| Add a new [[Template Panel|Template Excel Panel]] by hovering over [[Panel]]s in [[Current Situation]] in the [[Editor]]. | |||
| Click on the Select Excelsheet button for this Panel. | |||
| Click on the 'Add Geoshare File' link | |||
| Select Public share and browse to the Panels folder and select this file. | |||
| Select the imported [[Excel Sheet]] for this Panel. | |||
| Set the Update timing to ''AFTER'' | |||
| Select the Template tab in the details of this Panel and specify on what Areas it should be applied. Optionally with specific Attribute. | |||
| Click on the Apply Template button to create the Panel instances. | |||
| Select Overlays in the ribbon bar and select the Grid Overlay that should be measured. | |||
| Select the Attributes tab of this overlay and add a new Attribute named '''AREA_MEASUREMENT''' with a value 1. | |||
| Hover over the Calculation Cloud option in the Ribbon bar and select Reset Excel X-Queries to calculate the Templated Excel Panels. | |||
}} | |||
{{article end | |||
|notes= | |||
* Panel should be templated on [[Area]]s, since the used [[TQL]] statements contain explicit [[Area (TQL Param)|Area clause]]s. These can be adjusted to other types such as [[Terrain]]s or [[Building]]s by manually editing the queries in the Excel. | |||
* Currently up to 365 Overlay [[timeframe]]s are supported. More timeframes can be easily supported by editing the Excel. | |||
* Uses the [[Plotly]] library to generate the [https://plotly.com/javascript/line-charts/ Line Chart]. | |||
}} | |||
{{Panel nav}} | {{Panel nav}} | ||
Latest revision as of 12:52, 20 May 2025
Template panel that can be applied on Areas. This excel calculates and creates a line chart of Grid Averages within a specific Area per timeframe for a Grid Overlay. The Grid Overlay is identified by specifying the Attribute AREA_MEASUREMENT with a value 1.
How to import and configure the Grid Overlay Area Measurement panel:
- Add a new Template Excel Panel by hovering over Panels in Current Situation in the Editor.
- Click on the Select Excelsheet button for this Panel.
- Click on the 'Add Geoshare File' link
- Select Public share and browse to the Panels folder and select this file.
- Select the imported Excel Sheet for this Panel.
- Set the Update timing to AFTER
- Select the Template tab in the details of this Panel and specify on what Areas it should be applied. Optionally with specific Attribute.
- Click on the Apply Template button to create the Panel instances.
- Select Overlays in the ribbon bar and select the Grid Overlay that should be measured.
- Select the Attributes tab of this overlay and add a new Attribute named AREA_MEASUREMENT with a value 1.
- Hover over the Calculation Cloud option in the Ribbon bar and select Reset Excel X-Queries to calculate the Templated Excel Panels.
Notes
- Panel should be templated on Areas, since the used TQL statements contain explicit Area clauses. These can be adjusted to other types such as Terrains or Buildings by manually editing the queries in the Excel.
- Currently up to 365 Overlay timeframes are supported. More timeframes can be easily supported by editing the Excel.
- Uses the Plotly library to generate the Line Chart.