GENERATION OF INSTRUMENT LOOP DIAGRAM USING EXCEL MACRO'S

GENERATION OF INSTRUMENT LOOP DIAGRAM USING EXCEL MACRO'S

sarsivi30993
Advocate Advocate
5,653 Views
4 Replies
Message 1 of 5

GENERATION OF INSTRUMENT LOOP DIAGRAM USING EXCEL MACRO'S

sarsivi30993
Advocate
Advocate

Dear all,

 

I am working on a project where I need to generate loop diagram for instruments.  But in my case the number of instruments is more than 1000.  The advantage here is, the template for typical type of instruments are the same and its about matter of few data's to be changed (Eg. Tag number, cable number, Junction box number).  I am core engineer and into coding. 

With few data's on each template to be change, is there a way I can do that using MACRO's excel or LISP ?

 

I believe this is possible but someone help me in macro's coding.  I am looking to use AutoCAD to the fullest.

 

Anticipating your response. 

 

Thanks in advance.

 

Cheers

0 Likes
5,654 Views
4 Replies
Replies (4)
Message 2 of 5

TheCADnoob
Mentor
Mentor

Id say dont reinvent the wheel. 

https://www.cadlinecommunity.co.uk/hc/en-us/articles/207793889-AutoCAD-Electrical-2017-Automatic-Loo...

 

If you have a new subscription to the Only One AutoCAD you may already have access to this tool set.

 

If you are stuck on creating it, the way you tackle the problem should be based on your coding strengths. I've developed a lot of stuff for file handling in excel so for me i would start there (mostly cause i would be cutting and pasting my own code sets) and dynamically create a script (.scr) that i would call with coreconsole with each step through an excel file. 

CADnoob

EESignature

0 Likes
Message 3 of 5

Yamishon_Noah
Enthusiast
Enthusiast

Have you found any?

 

I am also looking for the same.

 

see attached found one but I need for open & closed loop also... Pls let me know

 

Yamishon

0 Likes
Message 4 of 5

sarsivi30993
Advocate
Advocate

Hai,

 

I am used this one & many items added in my knowledge but pdf converting not correct also control valve loops not yet.

 

please share any control valve loops.

0 Likes
Message 5 of 5

Anonymous
Not applicable

 

Hi,

Am too looking for solution, pl share if you can.

0 Likes