Alignment Station Offset Northing+Easting to Excel® worksheet
Practical situations of highway design
Situation 1:
You have: a topography, a draft Civil 3D alignment with many culverts block,
You want: to list the culverts' Station.
Situation 2:
You have: a draft Civil 3D alignment, a bridge profile with draft span diagram
You want: to convert the abutments/piers Station list to Coordinates (N,E) list.
In both situations, if the alignment is long then to manually measure station, offset/ N,E is really a nightmare.
It is even worse when the design need to update frequently (for example: alignment modified)
Our solution: simple but powerful
Station, Offset ➡ N, E
N, E ➡ Station, Offset
Further improvement
A macro which helps export block information (including insertion coordinates and other attributes) to Excel worksheet. A macro which helps update block information (including insertion coordinates and other attributes) from Excel worksheet. The macro is available
A macro which helps create attribute blocks from information read from Excel worksheet. The macro is available