I am working on a file with multiple alignments, with the primary one being for the highway, but there are roughly 20 additional alignments representing ramps, and arterial roads that run along or across the highway. I have roughly 600 points that are spread out along the highway and arterial roads, and I want to report their station offsets from the NEAREST alignment, so one point may lie 1 meter to the right of an arterial alignment, but may be 50 meters to the left of the main highway alignment. I have used CALCOFF to calculate and report the offsets with respect to one alignment, aka I would select all 600 points and their calculated offsets would be with respect to the main highway alignment, but I want it to be calculated from the nearest alignment so I don't have to individually select the points (per alignment) I wanted their offsets to be calculated from.Is there another way I could be doing this more efficiently? My end goal is to have a list (table) of point # and station and offsets exported to Excel (I don't need them labeled). Thanks
With many points and many alignments, my suggestion would be to run the?ÿCALCOFF routine to calculate and report the offsets of all points with respect to each alignment and include the alignment name in the resulting report.
Assemble the entire list into a spreadsheet and then sort the whole collection by point number then by offset.
It's been a while for me, but I think you'd be able to use an HLOOKUP function to return the unique Point Numbers and the MIN (minimum) of the Offset field. For me, I'd dump this into Microsoft Access and have it knocked out in a query.
I hope this fuels the imagination.
