PDA

jiguparmar
08-08-2010, 10:16 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 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.

OR

mrtabieh
08-10-2010, 06:23 PM
Thanks alot brother, I appreciate this

AmirElectric
08-13-2010, 10:38 PM
Special Thanks.
These files are very useful.

npsrinivasarao
09-26-2010, 10:52 PM
No Files available, Upload again pls.

sms149
09-28-2010, 12:36 PM
can u pls upload the the files.

jiguparmar
09-28-2010, 08:15 PM

iyan
10-24-2010, 05:12 AM
Thanks a lots bro

allynbert
11-03-2010, 04:10 PM
awesome....thanks for the excel bro..

DM2
11-11-2010, 06:32 AM

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
01-13-2011, 09:54 AM
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
06-29-2011, 02:34 PM
Those files sound like what i was looking for.

I do not seem to see them!

cheers

Manikandan.ic
09-18-2011, 11:38 AM
hi Jiguparmar,

manikandan.ic@gmail.com

Regards

N Manikandan

vampiris
09-18-2011, 01:14 PM

ryankai
09-22-2011, 12:03 PM
็Hi Sir,
ch.pongsathon@gmail.com

Thanks

anihita
09-22-2011, 07:28 PM
the site hosts some free excel programs, but most of them are paid one. This site is not for sharing, infact it is for business in the name of sharing.

smehrabi
11-27-2011, 08:21 AM
Those files sound like what i was looking for.

orlyboy
12-07-2011, 02:12 PM
just click the link and it will be directed to other website and download the excel tools.

sanjeewaro
02-20-2012, 05:21 PM
hi Jiguparmar,

sanjeewaro@yahoo.com

sanjeewa

raj151857
02-21-2012, 08:26 AM
Calculate Touch Voltage and Ground Current is not available

Hisham abu aishah
03-20-2012, 12:19 AM
i hope it will help me

hareshkhatri
12-12-2012, 11:20 AM
Thanks a lot Jig.

modena
12-14-2012, 04:41 AM

Sorry for many asterisk. Please remove asterisk and that is my email.

I just prevent it form autobot to get my email to send spam mail to me.

modena
12-14-2012, 04:42 AM

Sorry for many asterisk. Please remove asterisk and that is my email.

I just prevent it form autobot to get my email to send spam mail to me.

deytonh
12-23-2012, 02:52 AM
Muchas gracias por el aporte lo instalare haber como sale...

deytonh
12-23-2012, 02:53 AM
como bajar el programa, me interesa

deytonh
12-23-2012, 02:54 AM

karammkk
04-09-2013, 01:00 AM
hi Jiguparmar,
karammkk@gmail.com

Regards

04-17-2013, 08:09 AM
Hi all,

can any one send me these files on syedarshad_02@yahoo.com.

chatriyan79
06-04-2013, 02:52 PM

arunsamyal
08-28-2013, 07:43 PM

josefreitas
08-29-2013, 12:53 AM
thanks for this good programms.

migas
11-12-2013, 02:56 PM
tks brother

angki
11-20-2013, 11:13 AM
dear all,

Thank you Jignesh Parmar

ogbuce2006
11-20-2013, 05:38 PM
Thank you for the good work.

Janjua
09-23-2015, 01:50 PM
Special Thanks.
These files are very useful.

fstello59
10-02-2015, 10:20 PM

Maybe directly to fstello59@gmail.com

I will be very grateful. The program seems very useful.

Regards

tbdl
11-02-2016, 12:42 PM
Hello, is it possible to have the link for the program, I couldn't find it in your message. Thanks, regards, Thiery

Mechen
11-02-2016, 03:01 PM
hi Jiguparmar,