Electrical Excel Tools
March 22, 2011 50 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.
About Jignesh.Parmar (B.E,Mtech,MIE,FIE,CEng)
Jignesh.Parmar (B.E,Mtech,MIE,FIE,CEng)
AI WORKSHOP
Congratulations for the hard word,
Thank you for making this fine work.
Dear Sir, thank you for your hard work. I m a best followers of your.
The download files are not opening or download. Please help.
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
The file You are looking for… may be deleted by the user or by the Adminstrator !. i got the same problem. please recheck …..
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..
sir the free files are not downloaded and by clicking it goes to vedios.
plz gave me the correct sites
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,
Good Day Jignesh
I would like to know if you may have excel sheet that can do calculation for encapsulated busbar for Resin and Metal Enclosed Busbar ,
Regards
couldnt download many of the excel..
Dear Sir many many thanks for your hard working. I m a big fan of yiu. I always follow your all doc. Sir the calculation excells are not downloadibg. Please help us to download. Ifpossible kindly check once in your end.
i need this excel sheets i will pa for it << download link is broken nabill_969@hotmail.com