Innovating Electrical Engineering Calculations

411.5 TT system In this system, all exposed-conductive-parts and extraneous-conductive-parts of the installation must be connected to a common earth electrode. The neutral point of the supply system is normally earthed at a point outside the influence area of the installation earth electrode but need not be so. The impedance of the earth fault loop therefore consists mainly in the two earth electrodes (i.e., the source and installation electrodes) in series, so that the magnitude of the earth fault current is generally too small to operate overcurrent relays or fuses, and the use of a residual current operated device is essential. "BS 7671, 411.5.l Every exposed-conductive-part which is to be protected by a single protective device shall be connected, via the main earthing terminal, to a common earth electrode. However, if two or more protective devices are in series, the exposed-conductive-parts may be connected to separate earth electrodes corresponding to each protective d...

  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

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