meric_u2003 Posted May 21, 2014 Posted May 21, 2014 Hi friends, I would like to ask you a question about pipeline profiles. I am having 3kms pipeline with invert levels every 10kms.I made this invert levels in excel and how can I transfer this to AutoCAD? Is there any way If I change in excel it will automatically update in AutoCAD? Please give a reply. Quote
Tiger Posted May 21, 2014 Posted May 21, 2014 Hi Meric, I deleted your duplicate thread, please don't post the same question in multiple sections. I doubt that you can create an active link from AutoCAD to Excel, but you can import the values from Excel, somehow, depending on what you want to do with it. How do you want this to appear in AutoCAD? Are you drawing a profile of your pipe in AutoCAD? So the invert levels should be a distance from a specified line? Or do you want to get the invert levels in as Points, in that case you need X and Y-coordinates as well. Quote
Organic Posted May 21, 2014 Posted May 21, 2014 Invert every 10km? I presume you mean 10m. I've done a few pipelines (30km town water supply, 50km mining water line etc) and the chainage/design levels were generally every 100m or where there were changes in alignment or other crossing/features nearby. Every 10m seems overkill almost. You can link an Excel table to a table in AutoCad and (somewhat) sync the two so that if you change the Excel spreadsheet then the table in AutoCad updates. This will probably be the best you can achieve. A lot of civil engineering software programs have spreadsheet style entry modes for alignments. While I'm not aware of any program that directly accepts an Excel spreadsheet, I imagine you can probably copy the contents of an Excel spreadsheet into these civil spreadsheet style input forms. Quote
meric_u2003 Posted May 21, 2014 Author Posted May 21, 2014 sorry its every 10mts am attaching the drawing pls have a look smple.dwg Quote
Tiger Posted May 21, 2014 Posted May 21, 2014 So you are drawing a profile of the pipes, and you have the invert levels of the pipe in an excel document. you can probably fashion a script of some kind to do this, I think that is your best bet - if you are indeed talking normal AutoCAD? Not AutoCAD Civil or some other vertical application to AutoCAD? Quote
Tiger Posted May 21, 2014 Posted May 21, 2014 I will move your thread over to the Lisp-forum, you'll have a better chance at someone there having a solution for you. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.