Excel Electrical Cable Size Calculation Formula Pdf

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.

Calculate copper aluminium wire size in electrical circuit source voltage select source voltage 120 volt 240 volt 480 volt. Choose the cable size whichever is greater in step 1 or step 2. 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. Online electrical calculator which helps you to calculate the size of copper aluminium wires in an electrical circuit.

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. On tue dec 2 2014 at 7 52 pm electrical notes articles wrote. Vlookup index match rank average small large lookup round countifs sumifs find date and many more. Check for voltage drop with the cable size chosen.

Below is the formula to calculate the voltage drop of an electrical circuit based on the wire size and load current. Design calculations may be made either manually or by spu approved computer programs. Cable size calculations calculations based on motor horse power hp and specified current. Motor voltage v l l motor horsepower cable temperature rating c ambient temperature c cable length ft and acceptable voltage drop.

These formulas we can use in excel 2013. The number of cores in the cable. The excel functions covered here are. 2016 as well as 2019.

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. Operating current a 125 current per nec a zero length cable size acceptable voltage drop v actual. Excel formulas pdf is a list of most useful or extensively used excel formulas in day to day working life with excel. This section is dedicated to tools every electrical engineer can use in daily work.

Ignore the neutral and earth conductor in three phase cables. Electrical calculations should be made for all spu projects that include electrical components and should be filed in the project notebook. 20 electrical ms excel spreadsheets. Just to mention that all calculation spreadsheets.

Auto will automatically select the smallest cable that meets the three criteria for current rating voltage drop and fault current rating. 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.