Ideas for plotting script

[jacksoncarl5]

I have a VBA script that uses a excel input and generates drawings that look like the attached. 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.

Equipment Layout Template_Output3.dwg

[BIGAL]

I think it can be done I selected the top green "shape" re interpreting your "BLOCK" Word, and got this. Dont worry for now how I got it.

 

So next step would be to get all line work and do the same but using say color & layer to get lengths.

 

Ok you have a block for me would be make a table much easier to deal with, you can have block symbols and a Line within a block cell.

 

One issue is that the torque tubes are twice as two different thickness so really only need 1. Needs to be fixed 1st. Can divide by 2 but dangerous as may have only 1. May be another way to get only 1 "delete duplicates".

 

Also need to look at color look up table RGB:142,88,40 =" Brown". That is a task you can do, need just text 142,88,40,Brown. Can then be inserted into code. Include colors not shown.

 

Another question, avoiding multi please add this, can you post a true finished dwg what would be the end result in the layouts ?

 

This is bordering on a pay for answer.

 

 

 

 

 

Edited June 4, 2024 by BIGAL

[jacksoncarl5]

@BIGAL would not be opposed to paying for a solution here (or maybe even just the start of one). I did some updates to my script today which I think will eliminate the complexity of the line works. Now I have a cogo point associated with each line (tube) the raw description of these cogo point contains a unique identifier that can be summed and tabulate for the bom. I have also tacked on some additonal info in the raw description in this format (unique identifier, block, sub-block, row name). See attached.

Equipment Layout Template_Output3.dwg

[BIGAL]

I am running Bricscad, so a Cogo point is a CIV3D point, is that what your using ? I can not find any using. Trying to avoid testing with CIV3D.

(setq ss (ssget (list (cons 0 "Aecc_Cogo_point"))))

I can remove the duplicate plines, I have a remove duplicates lisp. So long as start and end points are the same.

Edited June 5, 2024 by BIGAL