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