Zone Export

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).