Hi All,
Just wondering if anybody has a solution to my problem. I am working on drawings where we create dtm's from surfaces, use the dtm for layout, shoot the asbuilt of the final surface, and then compare hundreds of shots to the surface to develop an as-build report.
I want to be able to select a mass of points, compare the perpindicular difference in elevation to the surface, and have an excel spread sheet generated from the results.
My coworkers are able to do this in Terramodel but I am on a mission to eliminate Terramodel from my day to day work.
Just hoping somebody may have come across this before and can shed some light as to what commands or add-ons are availbable. I've never worked with a LISP but i am certainly open to suggestions at this point.
Solved! Go to Solution.
Solved by tcorey. Go to Solution.
@Anonymous wrote:
I would much rather see a solution that is specifically designed to produce these results without creating extra points or surfaces.
This is what the SincpacC3D Display Points does.....select points in drawing, or by Point Group, choose the surface, Print to File.....fast, simple.
and the results in Excel:
Agreed. Reporting would be better
Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Oh, and the reason we don't round off values in the report to Excel is because you can do that easily in Excel, via cell formatting... When I wrote that routine, I knew people might want to export that data to Excel, then use it for further calculations (such as slopes, etc...) so I wrote it so that it does NOT honor the format settings in your drawing, and dumps the data out in full-precision. That lets you take this data and further-manipulate it in Excel, should you choose.
This seems to work better for those "****" types (mainly people in Government reviewing agencies, who don't seem to understand "rounding error"....).
LOL - I'm glad about that.....unnaturally precise work otherwise......!!!!!
neilyj (No connection with Autodesk other than using the products in the real world)
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
I suppose I should also point out that the screen shot that Jeff posted has the Northing and Easting rounded because he didn't stretch the columns in Excel prior to creating the screen shot... The actual output has the full Northing and Easting, and is not rounded.... The rounding is an artifact of Excel.
hai friends
I created a urface and alignment. now i wand to create interpolated points and abels perpenticular to the aligenment.
(The attached image had shown what I need exactly. It is just I created manually as a ref sketch .if there is any way to make it automatically )
any budy can help me please
Hello Dilsmails,
You have changed the subject of this thread. You will likely find a response if you make yours a new thread. Not as many readers read the last post in a thread as read the first!
Best regards,
Tim
how to make a new thread. can ypo p;ease tell me
Hi Andrew,
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.
Easy peasy.
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) )
Best regards,
Tim
Hi Tim,
I came accross this thread and would like to know how to use this code. Do I need to program this in using VB.net?
Thanks,
John
Welcome to the forums @Anonymous. That's a LISP program. Copy the code and paste in to notepad. Save with a .lsp extension in a folder in your support path. Then use Appload to load the file.
Allen Jessup
CAD Manager - Designer
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
I didn't read the entire thread so please excuse me if this has already been covered.
If you're looking to have your points tell you the elevation differences between existing and proposed, then create a surface from the points, save a snapshot of the surface, create a VOLUME SURFACE that compares this new surface to the EG surface. Now tell your points to take their elevations from the new surface. The "Elevation" will actually be the DIFFERENCE between EG & FG. Export your points to Excel and done.
Don Ireland
Engineering Design Technician
If I remember correctly, the OP was asking for a report. That's what the lisp routine does.
Can't find what you're looking for? Ask the community or share your knowledge.