Electrical Excel Tools

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

Cable Designing Program

FREE DOWNLOAD

  • Calculate Voltage drop of Cable.
  • Calculate  Size of Cable.
  • Calculate Current Capacity of Cable.

Conduit Size Selection Program

FREE DOWNLOAD

  • Calculate Size of Conduit for LT Cable/CAT-5 Cable/Fiber Optical Cable.

Selection of  MCCB,ELCB  For Main /Branch Circuit.

FREE DOWNLOAD

  • 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

FREE DOWNLOAD

  • Calculate Size of Fuse for Electrical Circuit.

Size of Capacitor  For Power Factor Improvements

FREE DOWNLOAD

  • 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).

FREE DOWNLOAD

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

FREE DOWNLOAD

  • Calculate  Tripping Setting of Circuit Breaker.
  • 

Motor Specifications

FREE DOWNLOAD

  • Calculate Various Specification of Motor.
  • 

Calculate  Home Electrical Load & Electrical Bill.

FREE DOWNLOAD

  • 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

FREE DOWNLOAD

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

FREE DOWNLOAD

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

FREE DOWNLOAD

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

FREE DOWNLOAD

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

FREE DOWNLOAD

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

FREE DOWNLOAD

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

FREE DOWNLOAD

  • 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:

FREE DOWNLOAD

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

FREE DOWNLOAD

  • 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.
Advertisements

About Jignesh.Parmar
Jignesh Parmar has completed M.Tech (Power System Control), B.E(Electrical) from Gujarat University. He has more than 14 years experience in Power Transmission-Power Distribution-Electrical energy theft detection-Electrical Maintenance-Electrical Projects(Planning-Designing-coordination-Execution). He is Presently associate with one of the leading business group as a Deputy Manager at Ahmedabad,India. He is Freelancer Programmer of Advance Excel and design useful Excel Sheets of Electrical Engineering as per IS,NEC,IEC,IEEE codes. He is technical Author for "Electrical Mirror" and "Electrical India" Magazines. He is Technical Blogger and Familiar with English, Hindi, Gujarati, French languages. He wants to Share his experience & knowledge and help technical enthusiasts to find suitable solutions and updating themselves on various Engineering Topics.

41 Responses to Electrical Excel Tools

  1. aniel says:

    Congratulations for the hard word,

    Thank you for making this fine work.

  2. sirvat says:

    Thanks for making this blog, its really helpful.

  3. Sandeep says:

    I get the lots of help from excel tool.

    thanx for making these type of blog.

  4. karthik says:

    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

  5. deepak jha says:

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

  6. gilbert says:

    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

  7. justin says:

    File not found

    I cannot download all files .

  8. deden says:

    many many thanksss bro….

  9. anandan says:

    I couldnt download many of the excel. pl help
    e anandan

  10. aravindan says:

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

  11. Jaymin Patel says:

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

  12. abhay says:

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

  13. joko says:

    Dear Sir,

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

  14. mihamed says:

    thank you very much
    it is really helpful..

  15. SHAZIM says:

    EXCELLENT AND OUTSTANDING DATA

  16. dhan says:

    Please re-upload the file sir, thank you

  17. HARSHAVARDHAN KULKARNI says:

    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

  18. ali says:

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

  19. Mithona says:

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

  20. Jagmohan Singh says:

    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

  21. rajarao says:

    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.

  22. sanjib says:

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

      ________________________________

      • Yehya Mohamed says:

        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

  23. Vinoth says:

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

  24. Ramu says:

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

  25. rajesh kumar rajagopal says:

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

  26. Brahmanandam says:

    Dear Jignesh,

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

  27. Anonymous says:

    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.

  28. prashant patil says:

    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

  29. Thushi says:

    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

  30. Abishake says:

    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.

  31. Hafiz Ghulam Muhammad says:

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

  32. Faton says:

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: