Excel array or routine for symbols ?

[rlshound]

Hello,

 

 

I've completed filling out the styles for 324 field codes in C3D 2014. I appreciated your help along the way. Another question if I may...I'd like to create a D size drawing showing a legend of all the symbols,points, and line codes. Does anyone have a routine or can you suggest a good spacing of coordinates in an excel file?

 

 

Thanks Again, rlshound

[BIGAL]

Sneaky suspision Lee-mac has something, you can create a block list and insert as an array pretty easy only problem is some blocks overlap. Its not hard to code I am looking, sure I did something once asks spacing how many rows/columns. Our other civil software its an option built in just do this. Its a bit of a let down in CIV3d that something as simple as a report of survey codes can not be done as a button press, it available in some other add on software for CIV3d its name I forget at moment.

[caddcop]

I use a TDS RAW file that consists of all SP codes that plots a column of matching points a fixed distance apart. And if the style is one defined as linear, it draws a figure between the points.

I also used a tool in Civil 3D that can plot a grid or array of points. By exporting them to a PNEZD file and opening that in Excel, I was able to paste in a list of our available codes and then write back out the PNEZD file. When re-imported, the result was a grid showing every point style with its assigned label style according to our description keys.

[rlshound]

BIGAL, Lee-mac was helpful....created a manual point and then used arrayclassic command....fiddled and calced it in to the correct spacing, rows and columns, it worked, looks great, Thanks for your help!

[rlshound]

caddcop, Your method worked great....Had a text file with all the codes and descriptions....created an array of cogo points without descriptions, exported them to csv, copied in the codes from the txt file, backed out of the c3d to remove points to prevent duplicates, reimported....it populated the drawing...awesome....great tool...Thanks for your help!