Hi, I am sharing some useful Excel base Program of Electrical Engineering. Cable Designing Program. Calculate Voltage drop of Cable. Calculate Size of Cable.
Calculate Current Capacity of Cable. Conduit Size Selection Program. Calculate Size of Conduit for LT Cable/CAT-5 Cable/Fiber Optical Cable. Selection of MCCB,ELCB For Main /Branch Circuit.
Calculate Size and Type of Main MCCB/RCCB/ELCB for Continious and Non Continious Load. Calculate Sensitivity of MCCB/RCCB/ELCB. Calculate Size of Cable. Calculate Size and Type of Sub Circuit MCCB/MCB for Continious and Non Continious Load. Calculate Total Load. Calculate Main and Branch Circuit Current. Selection of Fuses.
Also, I explained the fifth method of grounding design calculations: By using Online Earthing Calculators in Articles ' Grounding Design Calculations – Part Seven ' and ' Grounding Design Calculations – Part Eight '. Today, I will explain the Sixth Method of Grounding Design Calculations: Software Programs Method. EARTHWORK CALCULATION SPREADSHEET The spreadsheet “Any Level Method” is used to compute the volume of earthwork. This spreadsheet uses the Any Level Method (Coordinate Method) to compute the end area of the embankment or excavation at a given Station. Earth fill and excavation yardage must be entered and calculated on separate spreadsheets.
Calculate Size of Fuse for Electrical Circuit. Size of Capacitor For Power Factor Improvements. Calculate Size of Capacitor for Power Factor Improvements.
Calculate Annual Saving by selection of Capacitor. Calculate Active and Reactive Power. Short Circuit Current Calculation at Various Point of Electrical Curcuits(Isc). Calculate Short Circuit Current at Substation. Calculate Short Circuit Current at Distribution point. Calculate Short Circuit Current at Transformer.
Calculate Short Circuit Current at Main Panel. Calculate Short Circuit Current at Sub Distribution Board. Circuit Breaker Tripping Settings.
Calculate Tripping Setting of Circuit Breaker. Motor Specifications.
Calculate Various Specification of Motor. Calculate Home Electrical Load & Electrical Bill.
Calculate Electrical Bill of Home. Calculate Size of MCCB/MCB for Domestic Load. Calculate Electrical Load of Home. Calculate Insulation Resistance Value and PI value. Calculate minimum Insulation Resistance Value for Various Electrical Equipments. Calculate IR Value of Electrical Equipments.
Graph of IR Value. Calculate Polarization Index Value with Graph. Calculate Earth Resistivity.
Calculate Electrical Load and Energy Consumption of Panel. Calculate Continuous and non Continuous Electrical Load of Panel. Calculate total Energy Consumption(KWH) in Daily/Monthly of Panel.
Calculate Size of MCB of each branch circuit of Panel. Calculate Voltage / Voltage Difference of Each Phase. Calculate Unbalanced Load in Neutral Wire. Calculate Expected Temperature rise in Each Phase.
Calculate Load in Each Phase. Calculate Starting/Full Load/Continuous/Non Continuous Load. Calculate Size/Type/Tripping setting of Main MCCB.
Calculate Size of Battery Bank and Inverter. Calculate Total Demand Load. Calculate Size of Battery Bank in Amp.Hr.
Select Type of Connection of Batteries in Battery Bank. Select Rating of Each Battery in Battery Bank. Calculate Size of Inverter. Calculate Size/Type/Tripping setting of Main MCCB. Calculate Size of Solar Panel / Battery Bank / Inverter. Calculate Total Demand Load.
Calculate Size of Solar Panel. Select Type of Connection of Solar Panel. Select Rating of Each Solar Panel. Calculate Energy from Solar Panel as per Daily Sun lights. Calculate Size Battery Bank.
Select Type of connection of Batteries in Battery Bank. Calculate size of Inverter Calculate No of Lighting Fittings and Lumen Output. Calculate Total Lumen Output for particular Area. Calculate Total No of Lighting Lamps. Calculate Total No of Lighting Fixtures.
Calculate No of Fittings along with the Length and Width of Room. Calculate Bus Bar Size and Voltage Drop.
Calculate Voltage Drop for Bus Bar. Select Size of Bus Bar for particular Load.
Enter Your Sub Panel Details like Load,Line Length. Design of Earthing Mat for Sub-Station:. Program is design as per ANSI/IEEE 80-1986 Code.
Calculate Step Potential of Switch yard. Calculate Touch Potential of Switch yard. Calculate Total Length of Earthing Mat Conductor. Calculate Size of Earthing Mat Conductor. Calculate Total No of Earthing Rods.
Calculate Touch Voltage and Ground Current. Calculate Resistance of Each Phase. Calculate Resistance of neutral/Ground. Calculate Neutral Current and Load. Calculate Touch Voltage for Metal part to Earth. Calculate Body Resistance and Body Current.
Download Links: link Point to another website Only the registered members can access OR link Point to another website Only the registered members can access See More.
This is a test format for 13.8 kv switchgear 1. GENERAL DATA AND INFORMATION Panel No: Designation No.: A.Q1 Manufacturer: ABB Rated Voltage: 24 KV Type No.: VD4/P 24.25.25 Rated Aux. Voltage: 125 VDC Serial No.: 1VC1AL000 Rated Current: 2300 A 2.
MECHANICAL CHECK AND VISUAL INSPECTION ITEM DESCRIPTION CHECKED 1 Inspect for physical damage / defects. 2 Check nameplate information for correctness 3 Check tightness of all bolt connections (Torque Wrench) 4 Check racking mechanism for alignment and Smoothness of operation 5 Check quality of paint work 6 Check proper operation of all mechanical interlocks 7 Check for correct breaker position indications 8 Check for correct spring status indication 9 Check all wiring correctness as per approved drawings 10 Check that all grounding are securely connected 3.
ELECTRICAL TESTS 3.1 Function Test. ITEM DESCRIPTION CHECKED 1 Local control, alarm and indications 2 Remote control, alarm and indications 3 Check correct operation of all auxiliary “a” and “b” switch contacts. 4 Check breaker operation counter 5 Check trip free and anti-pumping circuit 6 Check electrical operation of breaker racking tracks.
(interlocks and limit switches). 3.2 Insulation Resistance Measurement: TEST VOLTAGE CONDITION DURATION READING (TΩ) 5KV CB CLOSE: R-Y+B+GROUND 1 MIN CB CLOSE: Y-R+B+GROUND 1 MIN CB CLOSE: B-R+Y+GROUND 1 MIN CB OPEN: R1+Y1+B1-R2+Y2+B2+GROUND 1 MIN 3.3 Contact Resistance Test: Current injected 100A CONDITION R-PHASE (µΩ) Y-PHASE (µΩ) Y-PHASE (µΩ) CB CLOSED Test Kit: Megger & CPC 100 3.4 Breaker Timing Set TEST RΦ (in mSec) YΦ (in mSec) BΦ (in mSec) Closing Operation Closing Coil Open Operation Tripping Coil 1 Open Operation Tripping Coil 2 Test Kit: EGIL.