Grid Overlay Area Measurement (Panel): Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| Line 3: | Line 3: | ||
[[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.]] | [[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 | {{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]]. | | Add a new [[Template Panel|Template Excel Panel]] by hovering over [[Panel]]s in [[Current Situation]] in the [[Editor]]. | ||
| Line 17: | Line 16: | ||
| Hover over the Calculation Cloud option in the Ribbon bar and select Reset Excel X-Queries to calculate the Templated Excel Panels. | | Hover over the Calculation Cloud option in the Ribbon bar and select Reset Excel X-Queries to calculate the Templated Excel Panels. | ||
}} | }} | ||
{{article end | {{article end | ||
Revision as of 06:19, 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
- Only applicable on Areas
- Currently up to 365 Overlay timeframes are supported.
- Uses the Plotly library to generate the Line Chart.