-
Notifications
You must be signed in to change notification settings - Fork 0
Zone Export
Etienne edited this page Jun 29, 2026
·
4 revisions
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).
macro vba run [ARES]EditZoneExportOptions
Opens the Zone Export options dialog (configures the variables below).
macro vba run [ARES]ExportLength
Runs the export over the zones on the zone level and produces the Excel summary.
| 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_Group_By |
Style | Grouping key for the rows: Style, Level, or Color. |
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). |