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

 Brief Calculation for earthing : Protective Conductor Sizes. Regulation 543.1.1: This can be achieved by either calculation (543.1.3) or selected (543.1.4) from Table 54.7. The formula used in 543.1.4 for calculating the size of a protective conductor is covered in great detail in a session inside our 17th edition BS7671. Selecting from Table 54.7 The protective conductor size is relative to the size of the line conductor which is represented by the letter 'S. Also, the far right column can usually be ignored as this is only used when the protective conductor and line conductor are of different materials.

  VBA ADDIN FOR ELECTRICAL CALCULATIONS Functions accessible in Excel : fx = CableTraySize( ) fx = CONTAINMENT( ) fx = EARTHING( ) fx = FAULTCURRENT( ) fx = kVA( ) fx = LLMF( ) fx = LMF( ) fx = LSF( ) fx = RSMF( ) fx = say( ) fx = TRCURRENT( ) fx = Z_CABLE( ) fx = Z_Transformer( ) fx = CABLE( ) fx = CURRENT( ) fx = MCCB( ) fx = SHORTCIR( ) fx = VDrop( )