Why not get the lisp to do all the work if you make a list of all text can sort, then group by dia into sub lists, then get length and add up so output to excel as result required. For me working on smarter excel defuns including write direct to excel say the results in this case.
40dia 1050
30dia 935
25dia 1234
hi again everyone, i tried @Steven Pnew code and yes it worked for me, its indeed very good , it will do my job , thanks very much again @Steven P, i wish nice weekends for all and hope to write you again.
Hi, I have a lisp to create a point to point wall, but I wish I could draw more than one line without the lines breaking or losing my current functions, hope you can help me, I am very new to lisp.
wall point to point.lsp
2D Tree Symbols (Collection 1)
The plan tree symbols in this pack are compatible with AutoCAD Release 14 and higher. All drawings are relatively small (25-30KB) and are suitable for use as blocks within AutoCAD. They are ideally suited for Landscape Architecture planting plans. The trees have been drawn with a radius of 1 drawing unit. To insert a tree at the required size, simply enter the required radius as the insert scale factor. The trees are all drawn on layer 0, this means that they will adopt the characteristics of the current layer when they are inserted. It is advisable therefore, to create a new layer before insertion so that you can easily control object properties. In each case, the insert base point is in the centre of the canopy.
2D Tree Symbols (Collection 2)
The plan tree symbols in this pack are compatible with AutoCAD Release 14 and higher. All drawings are relatively small (25-30KB) and are suitable for use as blocks within AutoCAD. They are ideally suited for Landscape Architecture planting plans. The trees have been drawn with a radius of 1 drawing unit. To insert a tree at the required size, simply enter the required radius as the insert scale factor. The trees are all drawn on layer 0, this means that they will adopt the characteristics of the current layer when they are inserted. It is advisable therefore, to create a new layer before insertion so that you can easily control object properties. In each case, the insert base point is in the centre of the canopy.