Cable Tray Size Calculation Formula Excel

Download free excel program for cable sizing calculation the spreadsheet calculates cable size according to length amperage temperature and number group cables.

Cable tray size calculation formula excel.

Not required outside diameter cable qty cable size weight lbs ft total cable weight. Has anyone made up an excel spreadsheet for sizing cable. Cable id cable o d. Minimum allowable tray.

9 to begin a new calculation return to the input screen and select the clear button. 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. Transient motor for starting large motors largest motor at each. For heavily loaded and or long circuits to confirm operation within nec recommendations min skm ptw dapper spreadsheets hand calcs.

Nec tables cablematic plus. All the calculations are subjected to the requirements of the national electrical code nec. Distance between each cable is 10mm. 60 and 90.

60 and 90. Calculate size of cable tray for following cable schedule. This excel sheet contains formulas for calculating cable tray size and conduit size. Download also cable tray and conduit sizing excel sheet.

December 2 2014 at 3 38 pm. Cable tray sizing program cooper b line 509 west monroe st. Wire mesh cable tray fill ratio fill ratio cross section of cable cross section of tray according to nec 392 9 b when using ventilated tray with multiconductor control cable the sum of the cross sectional areas shall not exceed 50 percent of the interior cross section of the tray. 2 fill in all pertinent project information.

Cable are laying in single layer in cable tray. Based on number of cables cable tray size and bracket type. To size conduit and cable tray per nec. I have amtech but its only the basic single cable version which wont size three phase or anything 100amp.

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. 1 2 no s of 3 5cx300 sq mm xlpe cable having 59 7mm outer diameter and 5 9 kg meter weight 2 2 no s of 3 5cx400 sq mm. Cable sizing excel formula. Cable tray should be perforated and 20 spare capacity.

Can you send me the calculation spreadsheet for cable size. Lbs ft inside tray depth. 13 responses to calculate size of cable tray excel sheet atta khan says. Three phase circuits formula wire circular mils 2 x 0 866 x specific resistance x amperes x distance voltage drop source voltage where specific resistance 11 2 for copper cable specific resistance 17 4 for aluminium cable.

Highland il 62249.