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 - 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

  Breaker Size : Example: Design Current for the R-TPN Load of Max 10 KW value is 20.89 A We need to select the Next Higher size of Breaker available in the Market for Calculated Design Current (=20.89 A) Here In our Case 30/32 A breaker can be selected. It can be MCCB or MCB or RCBO depending upon requirements. Ib = 21 A In = 30 A Iz = 52.48 (From Cable Data) Note: The operating characteristics of a device protecting a conductor against overload shall satisfy the following two conditions: Ib <= In <= Iz I2 <= 1.45 Iz Ib = the current for which the circuit is designed, e.g. maximum demand In = the nominal current of the protective device Iz = the continuous current-carrying capacity of the conductor (see the AS/NZS 3008.1) I2 = the current ensuring the effective operation of the protective device and may be taken as equal to either— (a) the operating current in conventional time for circuit breakers (1.45 In); or (b) the fusing current in conventional time for fuses (1...