import pvi spreadsheet into autocad

[jsouth147]

hi,

i have a pvi report from a designer and i want to put into autocad, it is in excel format is this possible if so how do i so it

thanks in advance

James

[sboon · Accepted solution]

This file includes both horizontal alignment and profile data.  You cannot create an alignment from external data, so you'll have to build that using what you have and some drafting.  It appears that your alignment is made up of two lines and one curve.  You should be able to draw the two lines, create an alignment and fit the 35m curve between them.  Once you're satisfied with that you can edit the spreadsheet to remove everything except the VPI's and export it as a text file.  See below for the required format used with the CreateProfileFromFile command.

http://docs.autodesk.com/CIV3D/2014/ENU/filesCUG/GUID-67A2129F-3FD2-47A6-8D2E-139D19C1DD55.htm

Steve
Please use the Accept as Solution or Kudo buttons when appropriate