+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Forum Newbie
    Discipline
    Construction
    Using
    AutoCAD 2016
    Join Date
    Dec 2017
    Posts
    4

    Default I'm trying to display as-built elevation vs design elevation, cut fill values +/-

    Registered forum members do not see this ad.

    I've managed to export the points from 2 x dwg's to a spreadsheet and do the cut-fill calculations, but I can't find how to import the resulting cut/fill, it doesn't have a tool/facility to import CSV. Is there any other way I can display the cut/fill values in standard autocad 2016? I have deposited both design level and as-built dwg's and spreadsheet in google drive, here's the link
    *
    https://drive.google.com/open?id=1hG...x_Kav-ARk5Ti9B
    *
    Now if anyone could please guide me through the procedure to*import them back in to display the cut-fill required at each point (to get the diff-Z shown) as displayed in col ‘L’ on the spreadsheet. Thanks,

    Bruceybee

  2. #2
    Luminous Being
    Using
    Civil 3D 2016
    Join Date
    Dec 2005
    Location
    GEELONG AUSTRALIA
    Posts
    9,890

    Default

    Had a quick look at data you can import points directly from a excel file as Point x,y,z on each line or directly as text note text has two versions depending on text style this example is for pre set height.

    Text x,y 90 pointheight1
    Text x,y 90 pointheight2
    Text x,y 90 pointheight3

    Look at this also http://www.cadtutor.net/forum/showth...-Easting-value shows the excel formula. Using Concatenate is very usefull in these situations and is so simple then just copy and paste a column directly to the command line.
    A man who never made mistakes never made anything

  3. #3
    Forum Newbie
    Discipline
    Construction
    Using
    AutoCAD 2016
    Join Date
    Dec 2017
    Posts
    4

    Default I'm trying to display as-built elevation vs design elevation, cut fill values +/-

    Hi BIGAL,
    Thanks for your response, I don’t quite understand the first part,
    Text x,y 90 pointheight1
    Text x,y 90 pointheight2
    Text x,y 90 pointheight3
    So I tried the =Concatenate method, when I use the =Concatenate (with a C in the last cell of row G) method with a selection of my points and ‘LINE’ command in G1, it draws the lines, but when I change the command to ‘POINT’, it just places the first point in the list, and then asks for the centre of the circle (xls and dwg screenshots attached) which I imagine it’s taking the ‘C’ in G14 as ‘circle’ command. I also want it to display the cut/fill values next to each point on the dwg.
    Bruceybee

  4. #4
    Forum Newbie
    Discipline
    Construction
    Using
    AutoCAD 2016
    Join Date
    Dec 2017
    Posts
    4

    Default

    Registered forum members do not see this ad.

    Hi BIGAL,
    Thanks for getting me this far with the =Concatenate method. It will come in very useful for other things, hopefully, as with the polyline in the example, but unfortunately not for the POINTS or TEXT. Now I have posted a query on how to import the cut/fill values as text into AutoCAD, Thanks again,
    Bruceybee

Similar Threads

  1. Surface elevation not matching contour elevation
    By JordanK in forum Civil 3D & LDD
    Replies: 6
    Last Post: 20th Sep 2014, 12:42 am
  2. Replies: 5
    Last Post: 14th Mar 2012, 08:26 am
  3. Changes the z elevation to 0
    By antistar in forum AutoLISP, Visual LISP & DCL
    Replies: 5
    Last Post: 2nd Aug 2010, 09:17 pm
  4. elevation values
    By michaeloureiro in forum AutoCAD General
    Replies: 9
    Last Post: 3rd Sep 2009, 12:36 pm
  5. Display elevation(Z coordinate) for Topo map
    By JaJunky in forum AutoCAD General
    Replies: 6
    Last Post: 11th Feb 2009, 05:21 am

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts