jiguparmar

08-08-2010, 10:19 AM

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:

OR

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:

OR