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