Posts

Showing posts with the label Construction

Update AUTOCAD Drawing Using EXCEL formulas - Part 2

Image
  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

Earthing Sizing calculation

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