Skip to content

Zone Export

Asketyll edited this page Jul 3, 2026 · 4 revisions

Zone Export

Computes how much of each element's length lies inside the zone polygons (full or partial), aggregates by a chosen key, and writes a per-group summary to a new Excel workbook (.xlsx).

Commands

EditZoneExportOptions

macro vba run [ARES]EditZoneExportOptions

Opens the Zone Export options dialog (configures the variables below).

ExportLength

macro vba run [ARES]ExportLength

Runs the export over the zones on the zone level and produces the Excel summary.

Configuration variables

Variable Default Purpose
ARES_Zoning_Output_Level ARES_Zoning The zone level whose polygons are used as export regions (shared with Zoning output).
ARES_Zone_Export_Level (empty) Restrict the measured elements to these level(s), pipe-separated (|). Empty = all levels. Non-existent names are ignored (reported on the status bar).
ARES_Zone_Export_Group_By Style Grouping key for the rows: Style, Level, or Color.
ARES_Zone_Export_Per_Zone False When True, break each group down per zone: long format Zone | group | length, one row per (zone × group), zones never merged. False (default) = classic single global grouping.
ARES_Zone_Export_Zone_Property (empty) Custom property (a member of ARES_Custom_Property_List) carried by the zone element, whose value labels each zone in the Zone column. Empty, or absent on a given zone → that zone is numbered Zone 1, Zone 2, … Used only when ARES_Zone_Export_Per_Zone is True.
ARES_Zone_Export_Round 2 Decimal places for exported lengths.
ARES_Zone_Export_Use_Dialog True True = prompt with a Save dialog; False = auto timestamped path next to the design file.
ARES_Zone_Export_Sheet_Name Export Worksheet tab name in the output workbook.
ARES_Zone_Export_Excel_Visible False True = leave the workbook open and visible in Excel after export; False = silent (workbook closed, Excel quit if ARES started it).

Clone this wiki locally