I have a VBA script that uses a excel input and generates drawings that look like the attached.
Equipment Layout Template_Output3.dwg (2.1 MB)
These can be very large and are not very useful on their own. What I need is a script that can break this down into human readable sheets with a title block and sub-bom like the following:
I need a sub-bom on each sheet that shows the qtys of each point and each line. All of the points between lines are blocks, and the lines themselves are polylines (some doubled over). To count the lines my plan was to update my VBA script to put a COGO point with a unique category (red/black, or yellow etc) descriptor behind the mid point of each line (if the lines were only one color then I could just count the polyline but since there are color combos I dont think I can do that) I fully acknowledge the mini-map in the lower left may not be possible (but open to ideas). The excel source document has information that breaks the document into “blocks” (green below) and “sub-blocks” (blue below), my thought is these can be used for logic about what to plot (sometimes we like to plot whole blocks other times sub blocks).
Not sure how to best get this information into the dwg though (right now it is in excel and not part of the plotted output).
Ideally I would like this to be fully automated (click a macro run and all the sheets and sub boms plot), my backup plan was to have user selection of windows within ACAD to select what is on a sheet then sheet and sub bom are created for that selection (one at a time). No idea where to even start here (vba? Dynamo? Lisp?) any help is appreciated.