ipt type="text/javascript"> (fun

1. Junior Member

Join Date
Aug 2010
Posts
11

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 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 Size/Type/Tripping setting of Main MCCB.

Calculate Size of Battery Bank and Inverter.
* 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 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.

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.

[link Point to another website Only the registered members can access] OR

[link Point to another website Only the registered members can access]

2. Spons Circuit
Join Date
Always
Posts
Many

3. Active Member

Join Date
May 2009
Location
India
Posts
183
good work. thanks

4. -

5. Very Active Member

Join Date
Nov 2009
Location
All over EGPET
Posts
693
Blog Entries
1
Files not available, Kindly share again. Thanks in advance.

6. Member

Join Date
May 2010
Location
India/Africa
Posts
55
Thanks very useful information for technical professional

7. Junior Member

Join Date
Nov 2010
Posts
16
Thanks for the useful EXcel format.

8. Junior Member

Join Date
Sep 2010
Location
I'm from Brazil, I live at Campinas city in the Sao Paulo state
Posts
13
thanks a lot. very usefull

9. Junior Member

Join Date
Apr 2011
Posts
1
hey dude am unable to download the file pls. could you guide me r else send it to tulajappa@gmail.com. thank you for knowing new things from you.

10. cag
Junior Member

Join Date
Jul 2011
Posts
5

## down link is not working

11. Junior Member

Join Date
Aug 2011
Posts
1
Hi
thansks

12. Junior Member

Join Date
Oct 2011
Posts
1

## thank you very very thanks

13. Junior Member

Join Date
Oct 2011
Location
Philippines
Posts
1

## please send me the file

sir, please send me the file, here is my email add, nyah1829@yahoo.com. thank you very much.

14. Junior Member

Join Date
Dec 2011
Posts
1
i couldnt find anything
can u send it to me (( Mohd.bastaki@hotmail.com ))