Cable Tray Size Calculation Formula Excel

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 tray size calculation formula excel.

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. Cable tray sizing program cooper b line 509 west monroe st. 9 to begin a new calculation return to the input screen and select the clear button. To size conduit and cable tray per nec.

This excel sheet contains formulas for calculating cable tray size and conduit size. Has anyone made up an excel spreadsheet for sizing cable. 60 and 90. All data used in this excel sheet are according to iee.

Nec tables cablematic plus. 2 fill in all pertinent project information. For heavily loaded and or long circuits to confirm operation within nec recommendations min skm ptw dapper spreadsheets hand calcs. December 2 2014 at 3 38 pm.

60 and 90. 13 responses to calculate size of cable tray excel sheet atta khan says. Cable tray size includes tray width tray length tray weight and tray area. Based on number of cables cable tray size and bracket type.

Download also cable tray and conduit sizing excel sheet. Highland il 62249. Can you send me the calculation spreadsheet for cable size. 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.

Minimum allowable tray. Transient motor for starting large motors largest motor at each. All the calculations are subjected to the requirements of the national electrical code nec. Cable tray should be perforated and 20 spare capacity.

I have amtech but its only the basic single cable version which wont size three phase or anything 100amp. Cable id cable o d. This will clear both the input and output pages. Cable are laying in single layer in cable tray.

Cable sizing excel formula. Calculate size of cable tray for following cable schedule. Distance between each cable is 10mm. Download free excel program for cable sizing calculation the spreadsheet calculates cable size according to length amperage temperature and number group cables.

Lbs ft inside tray depth.