I've had to change the stationing of an alignment (station equation was not an option). Before doing so, I copied all of my alignment properties' superelevation tab table data to a spreadsheet. I can manipulate the key stations in excel. The spreadheet is loaded with all the inside/outside lane and shoulder slope data as well. Is there any way I can paste/import this data back into the alignment properties???? Thanks.
Solved! Go to Solution.
Solved by SethHall. Go to Solution.
Hi Bubba1925-
This was actually functionality added with the Subscription Advantage Pack for Civil 3D 2010. From the Subscription Advantage Pack HELP file:
"The Subscription Advantage Pack for AutoCAD Civil 3D enables you to import superelevation data from either a CSV or XML file."
I have also attached a screen shot of the Superelevation Tab in Alignment Properties. The Subscription Advanatge Pack is available on the Subscription Center for download.
Hope this helps!
Thats great Seth! I'm going to see if we can get that, it will save a lot of time. Thanks!
Hi c3dlearner-
I took a look at the example files that ship with Civil 3D, but it doesn't look like I have any to post. Maybe someone else has an example file they wouldn't mind sharing, or possibly do what Bubba1925 did and create your own from an alignment you have already designed.
Thanks!
Attached is my successful .csv. It took me several hours to get one right; copying it out of another alignment and pasting results in extran, hidden, and out of order columns in excel (???). You gotta arrange to match what you see in the alignment properties, super tab, then you gotta remove special symbols like "+", ', and %. you need a column at the end (curve smoothing or something like that, I don't have it in front of me) - mine is all zeros.
I tried exporting the old align w/ supers to xml, then import xml - nothing happened so I'm not sure how that works.
after looking at my sections and seeing something wrong with the shoulders, i realized the following whacky situation occurs upon input:
the column of data for right outside shoulder gets inserted into the column of data in the alignment properties superelevation tab for right inside shoulder AND, the data for right inside shoulder gets inserted into the column of data in the alignment properties superelevation tab for right outside shoulder
I fixed this by swapping the data to the "wrong" columuns in Excel, then they go into the "right" columns in the spreadsheet! The wires got crossed somehow.