road curve design using vba

[majicleaf]

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

[BIGAL]

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.

[majicleaf]

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.

[SEANT]

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

[majicleaf]

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????!!!!!

[SEANT]

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.