TheSwamp

Code Red => AutoLISP (Vanilla / Visual) => Topic started by: jtm2020hyo on May 09, 2020, 02:22:13 AM

Title: Create Electric Single Line Diagram importing Excel file
Post by: jtm2020hyo on May 09, 2020, 02:22:13 AM
Is there a way to create a single line Electrical Diagram from an imported Excel file with LISP or similar?
Title: Re: Create Electric Single Line Diagram importing Excel file
Post by: DEVITG on May 09, 2020, 09:03:23 AM
yes it is.

give us both xls, dwg , and what do you want to do
Title: Re: Create Electric Single Line Diagram importing Excel file
Post by: jtm2020hyo on May 09, 2020, 11:06:33 AM
no problems, wait for me some hours.
Title: Re: Create Electric Single Line Diagram importing Excel file
Post by: jtm2020hyo on May 09, 2020, 11:07:30 PM
This took me the entire day, but finally, I did. In theory, should be possible to draw any Single line diagram. if anyone helps me with the lisp I might create a SLD template for everyone. if possible explain a bit of your lisp.

PD: attached files

(https://i.imgur.com/MQqQElK.png)

(https://i.imgur.com/yi2frY1.png)

(https://i.imgur.com/K8vZSIb.png)

(https://i.imgur.com/jF5D05D.png)

(https://i.imgur.com/Uf8W2Dl.png)


related links:

https://forums.autodesk.com/t5/visual-lisp-autolisp-and-general/create-electric-single-line-diagram-importing-excel-file/m-p/9503679#M399622

https://forums.autodesk.com/t5/revit-architecture-forum/create-electric-single-line-diagram-importing-excel-file/td-p/9503318

https://www.theswamp.org/index.php?topic=56014.0

https://forums.autodesk.com/t5/revit-mep-forum/create-electric-single-line-diagram-importing-excel-file/td-p/9504525

Title: Re: Create Electric Single Line Diagram importing Excel file
Post by: jtoverka on May 11, 2020, 01:53:13 PM
Below is a link to an AutoCAD Electrical Automation technique

https://www.autodesk.com/autodesk-university/class/I-Feel-Need-Need-Speed-AutoCAD-Electrical-Automation-2016 (https://www.autodesk.com/autodesk-university/class/I-Feel-Need-Need-Speed-AutoCAD-Electrical-Automation-2016)

If you are starting out in LISP and automation and programming is not your main strength, then that is where you should start. It's a hack of the PLCIO utility. It can be used for everything else, including one lines.
Title: Re: Create Electric Single Line Diagram importing Excel file
Post by: jtm2020hyo on May 11, 2020, 06:14:05 PM
I am very grateful. thanks for your help.