# Electrical Excel Tools

March 22, 2011 43 Comments

**Excel base Programs (Electrical Engineering): Designed by: ***Jignesh.Parmar *

- 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 Electrical Load 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 and Outgoing Feeders.
- Calculate Starting/Full Load/Continuous/Non Continuous Load
- Calculate Size of Cables for Each Outgoing Feeder.

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

Congratulations for the hard word,

Thank you for making this fine work.

Thanks for making this blog, its really helpful.

I get the lots of help from excel tool.

thanx for making these type of blog.

Dear sir,

As above excel tools are very useful to me and i need bus bar temperature rise calculation in 415V level for MCC panels. Kindly do the needful

Reg Karthik

ur blog is awesome man……keep it up….

All file says:

File not found

The file You are looking for… may be deleted by the user or by the Adminstrator !

please upload again

all file says the file not found.Pls help me by providing the correct link to all electrical excel tools.

Raj

I have rechecked all links..All links are workings!!!!!!!!!!!!

File not found

I cannot download all files .

many many thanksss bro….

unfortunately it’s deleted…. :(((

I couldnt download many of the excel. pl help

e anandan

I WANT TO DOWNLOAD CONTINUOUS CURRENT RATING CALCULATION FOR UNDER GROUND EHV CABLES

Thanks a lot for this tools, this is very useful tools for electrical engineers.

dear sir kindly send thiese sheet on my mail id plz abhayzmi1051@gmail.com

Dear Sir,

Please re-upload the file to the new link……thank you very much for your hard work..

thank you very much

it is really helpful..

EXCELLENT AND OUTSTANDING DATA

Please re-upload the file sir, thank you

Sir HATS OFF TO UR HARDWORK LET IT GO ON AND ON ….

AM A Asst Prof. in ENGGG COLLEGE from KARNATAKA , BE in ELectrical and ME in POwer systems

Can you please post these link again please, you did a great job dude

It is good, but should have the user manual with example it is nice for the newest user of this program.

Parmar ji

Nice to see u r aticle, its great and useful to other electrical engineers. i need to share and learn about the following points.

how we can measure 3 phase Morter Winding Resistance by megger and what are the Ohms we can say good resistance. plz guide me in detail or any link

thanks

Jagmohan Singh

hello sir,

the information provided by you is really very much useful for the electrical engineers, no need to depend on others. We are all really indebted to you for your great work. I am unable to download the excel sheet sir its giving an error saying that the file has been deleted by administrator. Could you please help me how can i get them downloaded. waiting for your reponse.

In which Program did you get problem while downloading..

Calculate Home Electrical Load & Electrical Bill. – FILE NOT FOUND.

ITS SHOWING.

“The file You are looking for… may be deleted by the user or by the Administrator ! “.. AND THE OTHER TWO FILES ALSO ARE NOT FOUND.. PLEASE RE UPLOAD SIR.

link is alive

http://www.ziddu.com/download/19969421/HomeElectricalBill22.8.12.xls.html There is no any notification I have faced. Attached screenshot of that.

Regards, Jignesh.Parmar. Technical Blog: http://www.electricalnotes.wordpress.com “Saving One Unit Power is equal to Generating One Unit Power”.

________________________________

Hi Jignesh , its really very good tool and helpfull but i need your help about Earthing mat calculations for Substation,

I have a project of 220/150 kv substation and it exist one power transformer and going to make extention of another transformer 160 MVA, also it exist Earthing mat for the existing Transformer but is needing earthing mat for the new transformer i used your xls tool for making the design of the earth mat , but the specifications of my project is telling that the earthing conductor diameter is 10.5 mm (63mm2) and this size i can not use it with your 3 standard sizes of earthing conductor as you made it (32-36-40 mm)

please tell me what is possible to do for making the earthing mat according to these specifications:

(sooil resistance is 20 Ohm-m and fault current is 8KA)

220/150 kv, 160 MVA primary discharger, secondary discharger and one Power transformer

dimentions of the substation earthing mat what i made is 160 m X 137 m

Sir its a really good one. but all excel tools Not download. tell me how to download it.

in a 3 phase delta to star transformer if single phase has been cutoffed then how the two phases will provide suply???

If you student than Refer B.L.Theraja (Page 919 to 992) for more clarity and

if you are working in filed than your question generate some more questions.

=Suppose If T/C works in only two phase than what will happen

(1) Two phase voltage (p-p) increase with respect to faulty phase or

(2) Two phase voltage (p-p)decrease with faulty phase or

(3) Voltage decrease on all Phase

(4) Voltage increase in all phase..

dear sir i couldnt able to download ur programs plz show me some way to download even free downloads also not working

Dear Jignesh,

Please send a quote of price to ma mail ID for all excel sheets. My mails id is brahmanandam.thadikonda@gmail.com

It is already given in $ and RS..You have to just click on it

How can I still get these excel sheets ? Can you email me details.

I think the admin of this site is truly working hard in favor of his web site, for the reason that here every stuff is quality based information.

All work sheets are useful to contractors. kindly add worksheet for analysis of rates of electrical items which will be useful to cotractors while quoting, for electrical Tenders

Prashant

Hi, i love to check out those files, but couldt find on the links. can you please make sure the links still active?

Thanks

Thushi

Hai sir,

the link for the download is not active… pls guide me to download these Excels sir. I Need those calculations sir…

thanks a lot for sharing these calculation.. its very very useful for my career.

Excel Files are not available Sir …please active downloading……….. thank

Dear Sir how it is posible to get these files ,because all of them appear not to be active

Not available sir…u send again sir ,(WEB OR MAIL)pls

helo sir,

Can you clarify on your excel

Home-Electrical-Bill-22-8-12 eep.xls

No of Unit consumed/ Month seems doubtful

thank you sir,