Innovating Electrical Engineering Calculations

  Excel_ing CAD - HYPERLINK, HATCH, ENCIRCLE We can add HYPERLINK in AutoCAD drawing in a predefined way using Excel.  HYPERLINK ADDRESS TO AREA OR OBJECT HATCHING UNDER BOUNDARY WITH CONDITIONAL COLORS ENCIRCLE THE TEXT AND MASK Prerequisite to apply our formula in the specified drawing : Get the Coordinates where we want to define the values as text/object. ( Explained in Part-1 ) The area can be defined with 4 coordinates in a CAD file. HYPERLINK ADDRESS TO AREA/OBJECT Hyperlink Formula:  ="(command ""-hyperlink"""&" "&""""&"I"&""""&" "&""""&"A"&""""&" "&""""&[@X]&""""&""""&[@Y]&""""&""""&[@LINK]&""""&""""&...

  Excel_ing CAD - BLOCK We can add blocks in AutoCAD drawing in a predefined way using Excel.  BLOCK WITH DYNAMIC ATTRIBUTES IN THE TABLE BLOCK WITH DYNAMIC VALUE ON EACH ITEM Prerequisite to apply our formula in the specified drawing : Get the Coordinates where we want to define the BLOCK. ( Explained in Part-1 ) Create a user-defined BLOCK and save it for reference

  Excel_ing CAD - TEXT/MTEXT We can add text in AutoCAD drawing in a predefined way using Excel.  NORMAL TEXT IN THE SELECTED LAYER TEXT AS PER CONDITIONAL COLORS TEXT ON SPECIFIED LAYERS TEXT AT A PARTICULAR DISTANCE Prerequisite to apply our formula in the specified drawing : Get the Coordinates where we want to define the values as text/object. ( Explained in Part-1 ) Set the style of text as per requirement. ( COMMAND: "ST" ) NORMAL TEXT IN THE SELECTED LAYER Fx ="-TEXT "&[@[X-COORDINATE]]&","&[@[Y-COORDINATE]]&" "&[@ROTATION]&" "&[@TEXT] RESULT = -TEXT 2717612.8821,-1817752.3676 0 MH-1

Excel_ing CAD - Layer Management Prerequisite to apply our formula in the specified drawing : Autocad drawing Coordinates Simple Excel Formulas Steps to get coordinates of Text/Object in AUTOCAD : Select Text/Object ⇒ Select Similar ⇒ Isolate objects (To get minimum items to be extracted) ⇒ DATAEXTRACTION ⇒ Create a new data extraction ⇒ next ⇒ save (with any name anywhere) ⇒ Select objects in the current drawing ⇒ Enter (After selecting Desired area) ⇒ Next ⇒ Select the objects to extract data from  ⇒ Next ⇒ Select Properties needed  (Must select Geometry also to get coordinates)   ⇒ Next ⇒  Next ⇒ Output data to external files  (.xls type)  ⇒ Specify the path ⇒ Next  ⇒ Finish