I created a new User-Defined Property called As-built elevation. Then created an input fromat called As-Builts, where the elevation gets read into this user defined property instead of the point elevations.
Them I elevate all points to the design surface. This fills in the point elevation column, and I can using another defined format export both elevations to a csv and into a spreadsheet, converting that to any report I want.
I've also created an expression which is the As-built elevation minus Point elevation. Then used that expression in a label, this labels up all my points with the elevation difference and I get a nice conformance check plot.
Pity one can't created "calculated" User Defined properties, i.e. one whose value is calulated from one or more point properties.
Thanks for the tip!!!
If terramodel has it... why doesn't civil 3D? Is somebody slacking off, throwing rubber bands at the wall at autodesk???
I'd like to see a POINTS to SURFACE elevation deviation report choice. Surveying has been in need of this since the beginning of days. Need to hand a CUT/FILL report to contractors for road construction, parking lot paving, etc... Need this feature.
One of the beauties of Civil 3D is that it includes a programmer interface, making it easy to solve small issues like the one presented in this thread. The following code is an example. If it works for you, you are welcome to use it as-is or change it so it does work for you.
;copyright (c)2014 by Timothy Corey ;Delta Engineering Systems, Redding, CA ;Autodesk Authorized Value-Added Reseller ;permission is hereby granted for free use of this program as-is ;or modified to your specifications. ;This program or any portion may not be sold or combined with any ;for-sale software. ;It is the responsibility of the user to debug the software ;to determine its usability and accuracy. ;This program will ask for a reference surface object and a selection set of Civil 3D Points ;a report will then be written, c:\PointDepth.txt, which will list PointNumber, PointElevation, ;SurfaceElevation and DistanceToSurface. Change the file location and name to your specifications. (defun c:go ( / srf vsrf fl pts len ctr p vp pno x y elv srfz depth elvx srfzx output) (setq srf (car (entsel "\nSelect reference surface: ")) vsrf (vlax-ename->vla-object srf) ) (setq fl (open "c:\\PointDepth.txt" "w")) (write-line "PointNumber, PointElevation, SurfaceElevation, DistanceToSurface" fl) (prompt "\nSelect points to report: ") (setq pts (ssget) len (sslength pts) ctr 0) (while (< ctr len) (setq p (ssname pts ctr)) (if (= (cdr (assoc 0 (entget p))) "AECC_COGO_POINT") (progn (setq vp (vlax-ename->vla-object p) pno (itoa (vlax-get-property vp 'Number)) x (vlax-get-property vp 'Easting) y (vlax-get-property vp 'Northing) elv (vlax-get-property vp 'Elevation) ) (setq srfz (vlax-invoke-method vsrf 'FindElevationAtXY x y)) (setq depth (rtos (- srfz elv) 2 2)) (setq elvx (rtos elv 2 2) srfzx (rtos srfz 2 2) ) (setq output (strcat pno "," elvx "," srfzx "," depth)) (write-line output fl) ) ) (setq ctr (1+ ctr)) ) (close fl) (princ) )