majicleaf Posted June 1, 2010 Share Posted June 1, 2010 hi, i have been designing curves of road manually with autocad a it is a very tedious and repitive task. i need to know how to automate the curve design using vba (i use vb & vba for other applications) i need to: 1. know the radius of a curve of existing polyline 2. know the deflection angle 3. display the curve design data on a table beside the curve 4. repeat for whole length of the road for each curve (1km normally have average of 10 curves) P.S. i know you can do it in civil3d & mxroads but i want to know how to code it myself :-) can anyone please help?? image attached Quote Link to comment Share on other sites More sharing options...
BIGAL Posted June 2, 2010 Share Posted June 2, 2010 Without writing the code you need to find the formula which is contained in your countries road design manual then just write a lisp or vba to do the table. Lots of stuff here about interrorgating polylines getting radius etc. Its not rocket science basic road design of the 1st principles. It would make sense just pick polyline and it just finds every curve and writes a table. Quote Link to comment Share on other sites More sharing options...
majicleaf Posted June 2, 2010 Author Share Posted June 2, 2010 coding the formula to do the table is not an issue. The hard part is how to know the radius and deflection angle of every curves on the existing polyline using vba, then placing the table beside each curve. Quote Link to comment Share on other sites More sharing options...
SEANT Posted June 2, 2010 Share Posted June 2, 2010 A lot of the information needed can be derived from the vertex’s coordinates and Bulge property at each index. See the attached spreadsheet for an example. BulgeLen.zip Quote Link to comment Share on other sites More sharing options...
majicleaf Posted June 2, 2010 Author Share Posted June 2, 2010 when i click on your attachment (bulgelen.zip), i downloaded a "php" file named "attachment" and i can't open it with my browser (iexplorer). when i opened with firefox, a dark grey page with 'home' button and 'site search' button at the top right corner appears. when i click on them, nothing happens. any suggestions?? i downloaded the same link again and opened it in firefox. i took me to the login page of this site. i'm confused????!!!!! Quote Link to comment Share on other sites More sharing options...
SEANT Posted June 2, 2010 Share Posted June 2, 2010 The file is a compressed(.zip) Microsoft Excel 2003 spreadsheet file, (BulgeLen.xls). It may not be useful if you don't have Excel installed. Though, Open Office may have an import filter for Excel files. I'm not sure why clicking on it from a browser would bring you anywhere. Quote Link to comment Share on other sites More sharing options...
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.