Creating Profiles from Excel Sheet

[Domzinator]

Hi Guys

is there a way of create profiles from Excel? i know you can create them from a file as per attached link:

https://help.autodesk.com/view/CIV3D/2024/ENU/?guid=GUID-58F36650-6B76-4449-BF49-A7899B6F8320

This will not work for my requirements as i have more info i need to use as inputs. Here is a Snip of the data

[ecfernandez]

Hi @Domzinator, thanks for posting your question in the forums.

What I see from your snapshot is that you have the information Civil 3D would show for a layout profile in the panorama window. As you said, you have even more information to create the profile. I agree with that. However, you don't need it.

Unless you have unsymetrical vertical curves or non parabolical curves, you only need station, elevation, and curve length to create your layout profile using the Create Profile from File tool.

The rest of the information you show on that image is obtained from the geometry created after inserting the tangents and curves as disposed by their station, elevation, and length. For instance:

Grade in: tangent grade entering a curve (it can be positive if the following station's elevation is higher than the previous)

Grade out: tangent grade leaving/exiting a curve (it can be negative if the following station's elevation is lower than the previous)

Grade change: Algebraic difference between grade in and grade out values.

K value: this is Curve Length/Grade change.

Curve type: Sag or Crest. The software will know this depending on how the vertical tangents approach the curve.

My advice is to filter out the basic information needed to draw the vertical alignment in Civil 3D from that Excel file you have. Then, create the layout profile and compare the data in the Excel file with that one presented in the panorama window of Civil 3D. Finally, do any required adjustments (if necessary), so your design resembles exactly your raw data.

I hope this helps. Best regards!

[Domzinator]

Thank you for your reply. I will give it a shot than you.

[ecfernandez]

Hi @Domzinator, sure. I'll be attentive to any additional questions. Regards!