Download Electrical Engineering Program (Excel Base)

[jiguparmar]

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]

[mrtabieh]

Thanks alot brother, I appreciate this

[AmirElectric]

Special Thanks.
These files are very useful.

[npsrinivasarao]

No Files available, Upload again pls.

[sms149]

can u pls upload the the files.
link is no longer active

[jiguparmar]

Links are alive. Your net speed may be low so may get some problem from downloading link (from Ziddu.com)

[iyan]

Thanks a lots bro

[allynbert]

awesome....thanks for the excel bro..

[DM2]

The Website is a little Bit Disturbing. Any attempt to download a file causes "Pop-Up's" and advertisements that seem to keep loading. I have my concerns about site installing "Ad Ware"

I finally downloaded all of the files, changed the file names for consistency reasons and removed the passwords to make sure there wasn't anything that snuck into the file. All seems to be good, however it might be best to zip all files and post them to another site that doesn't have all of the "Pop-Up's".

[Kebian]

hi Jiguparmar, i am new, young electrical engineer, i tried downloading your excel software but to no avail. pls help me get it. i need it

regards,
kebian

[mikelata]

Those files sound like what i was looking for.

where are the download links?
I do not seem to see them!

cheers

[Manikandan.ic]

hi Jiguparmar,
i tried downloading your excel software but to not avaiable. Can you send to me

manikandan.ic@gmail.com

Regards

N Manikandan