Alignment, profile view and cross section tables

Civil 3D
1

Hello,

I am searching to create scripts to acheive this.

I would like to have the ability to create 3 Excel tables or table in C3D generated from C3D objects (Alignments, Profile Views and Section Views). But with the style in the end of the post.

I want to have the possibility to adjust the decimals of the datas and it must work for all futur projects and next versions of civil 3D.

For the alignments:

  • Element number

  • Element type

  • Characteristics: - Line: bearing (angle from north) - Arcs: radius, X and Y of the radius center - Clothoids: « A » parameter, X and Y of the radius center

  • Length

  • Station value

  • X

  • Y At the bottom of the table: alignment length

For the profile views:

  • Element number

  • Element type

  • Characteristics: - Line: slope - Parabolas: radius, summit station, Z at summit station - Arcs: radius, summit station, Z at summit station

  • Length (for lines, both the horizontal length and the real length are needed)

  • The station (S)

  • The Z at the station At the bottom of the table: alignment length

For the section view:

  • Section number

  • Station

  • X of station

  • Y of station

  • Bearing at the station (clockwise)

  • Radius at the station of the alignment (infinite if a straight line), hard for me to tell when the station is on a clothoid

  • Z profile view at the station

  • Left slope

  • Left road width

  • Right slope

  • Right road width

I tried to make it by myself with dynamo, I can have the datas but can’t extract it correctly to match the tables below.

I think dynamo is the way to make it to be sure i twill work for next versions of civil 3D.

Launch dynamo player, select alignement, profile line or sections views in C3D, choose decimals (3 décimals by default) and extract excel

To be clear I join 3 manually excels I want to be automated.

projet
projet4962×1612 330 KB

Can someone help me to export datas in the style I want ?

Thank you