Had a great call this afternoon, someone was trying to take a surface profile and get the station and elevation data from that profile into an excel file. At first I thought, “Easy! Just use the toolbox and create a report!” but, do you think I would be writing this post if it was that easy? Nope, don’t think so.

Apparently, the reporting tools only work on layout profiles and don’t work on surface profiles, even if the update mode for the profile is set to static. You could probably find some way of converting a surface profile to a layout profile. The solution we came up with is a two step process.

1) Create points along the alignment from the profile. We did this using the Points->Create Points – Alignment->Profile Geometry Points command from the Home tab on the ribbon:

Select the alignment and the surface profile.

2) Create a report of the points. This is done through the Toolbox tab of the Toolspace. The report we ran was under the Points->Station Offset to Points.

This report will ask you for the points and the alignment that the station value will be calculated from. The report created will have both the station and elevation in it, simply copy the data out of the report and paste it into Excel, removing the columns you don’t need once in Excel.

Thanks to Bryan and the rest of the people in the Tetra Tech office in Lognmont for always coming up with decent challenges for me!

About these ads