Electrical tools ms excel spreadsheets this section is dedicated to tools every electrical engineer can use in daily work these spreadsheets below will make your job much more easier alowing you to shorten the time used for endless calculations of cables voltage drop various selections of circuit breakers capacitors cable size and so on.
Excel electrical cable size calculation formula pdf.
The excel functions covered here are.
Auto will automatically select the smallest cable that meets the three criteria for current rating voltage drop and fault current rating.
2016 as well as 2019.
Step 3 check calculate voltage drop.
Choose the cable size whichever is greater in step 1 or step 2.
Below is the formula to calculate the voltage drop of an electrical circuit based on the wire size and load current.
These formulas we can use in excel 2013.
Cable size calculations calculations based on motor horse power hp and specified current.
The number of cores in the cable.
This section is dedicated to tools every electrical engineer can use in daily work.
Today we are here with another comprehensive copper and aluminum wire size calculator as we have discussed in detail the topic of how to calculate the proper wire size for electrical wiring.
Ignore the neutral and earth conductor in three phase cables.
Online electrical calculator which helps you to calculate the size of copper aluminium wires in an electrical circuit.
Check for voltage drop with the cable size chosen.
Vlookup index match rank average small large lookup round countifs sumifs find date and many more.
These spreadsheets below will make your job much more easier alowing you to shorten the time used for endless calculations of cables voltage drop various selections of circuit breakers capacitors cable size and so on.
Now you can take the advantage of this calculator to do this job j you can also check the classical wire cable size calculator in awg calculating wire cable size formula for single phase circuits.
20 electrical ms excel spreadsheets.
Electrical calculations should be made for all spu projects that include electrical components and should be filed in the project notebook.
Calculate copper aluminium wire size in electrical circuit source voltage select source voltage 120 volt 240 volt 480 volt.
Operating current a 125 current per nec a zero length cable size acceptable voltage drop v actual.
Design calculations establish minimum guidelines and requirements for generating electrical calculations on projects.
Calculate cable tray width calculate cable tray area calculate cable tray length calculate cable tray weight calculate remaining width of cable tray calculate remaining area of cable tray free download.
Just to mention that all calculation spreadsheets.
Excel formulas pdf is a list of most useful or extensively used excel formulas in day to day working life with excel.
Select a cable size or select auto.