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.

Motor voltage v l l motor horsepower cable temperature rating c ambient temperature c cable length ft and acceptable voltage drop. Ignore the neutral and earth conductor in three phase cables. 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.

Cable size calculations calculations based on motor horse power hp and specified current. 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. Calculate copper aluminium wire size in electrical circuit source voltage select source voltage 120 volt 240 volt 480 volt. These formulas we can use in excel 2013.

The excel functions covered here are. Operating current a 125 current per nec a zero length cable size acceptable voltage drop v actual. 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. 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. Auto will automatically select the smallest cable that meets the three criteria for current rating voltage drop and fault current rating. The number of cores in the cable. Select a cable size or select auto.

On tue dec 2 2014 at 7 52 pm electrical notes articles wrote. Electrical calculations should be made for all spu projects that include electrical components and should be filed in the project notebook. Choose the cable size whichever is greater in step 1 or step 2. Just to mention that all calculation spreadsheets.

20 electrical ms excel spreadsheets. Step 3 check calculate voltage drop. 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.

Design calculations may be made either manually or by spu approved computer programs. 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.