Cable Size Calculations Spreadsheet

Cable Size Calculations Calculations Based On Motor HP Input Data

Calculated Values

Motor Voltage (V L-L)

230

Operating Current (A)

15.2

Motor HP

5.00

125% Current per NEC (A)

19.0

Cable Temperature Rating (°C)

75

"Zero Length" Cable Size

Ambient Temperature (°C)

26-30 (std)

Acceptable Voltage Drop (V)

Cable Length (ft)

500 Recommended Cable Size

Acceptable Voltage Drop (%)

14 AWG 3.98

6 AWG

3.0% Actual Voltage Drop (V)

3.42

Actual Voltage Drop (%)

2.6%

Calculations Based On Specified Current Input Data

Calculated Values

Operating Voltage (V L-L)

230 "Zero Length" Cable Size

Specified Current (A) Cable Temperature Rating (°C) Ambient Temperature (°C) Cable Length (ft) Acceptable Voltage Drop (%)

File: 343127108.xls, Sheet: Calculations

7.6 Acceptable Voltage Drop (V) 75

Recommended Cable Size

26-30 (std)

14 AWG 3.98

8 AWG

Actual Voltage Drop (V)

2.66

500 Actual Voltage Drop (%)

2.0%

3.0%

1 of 4

Print Date: 01/20/2017

Rated Currents Vs. HP and Voltage HP 0.50 0.75 1.00 1.50 2.00 3.00 5.00 7.50 10.00 15.00 20.00 25.00 30.00 40.00 50.00 60.00 75.00 100.00 125.00 150.00 200.00 250.00 300.00 350.00 400.00 450.00 500.00

Voltage 208 2.4 3.5 4.6 6.6 7.5 10.6 16.7 24.2 30.8 46.2 59.4 74.8 88 114 143 169 211 273 343 396 528 #N/A #N/A #N/A #N/A #N/A #N/A

230 2.2 3.2 4.2 6 6.8 9.6 15.2 22 28 42 54 68 80 104 130 154 192 248 312 360 480 #N/A #N/A #N/A #N/A #N/A #N/A

File: 343127108.xls, Sheet: Motor Table

460 1.1 1.6 2.1 3 3.4 4.8 7.6 11 14 21 27 34 40 52 65 77 96 124 156 180 240 302 361 414 477 515 590

575 0.9 1.3 1.7 2.4 2.7 3.9 6.1 9 11 17 22 27 32 41 52 62 77 99 125 144 192 242 289 336 382 412 472

2 of 4

Print Date: 01/20/2017

Cable Ampacity (Table 310-16)

AWG or kcmil 4 x 350 3 x 500 4 x 250 3 x 350 2 x 500 3 x 4/0 2 x 350 2 x 250 2 x 4/0 500 350 250 4/0 3/0 2/0 1/0 1 2 4 6 8 10 12 14

75 1240 1140 1020 930 760 690 620 510 460 380 310 255 230 200 175 150 130 115 85 65 50 35 25 20

Motor HP with 75 De-rate 1240.0 1140.0 1020.0 930.0 760.0 690.0 620.0 510.0 460.0 380.0 310.0 255.0 230.0 200.0 175.0 150.0 130.0 115.0 85.0 65.0 50.0 35.0 25.0 20.0

Specified Current with 75 De-rate 1240.0 1140.0 1020.0 930.0 760.0 690.0 620.0 510.0 460.0 380.0 310.0 255.0 230.0 200.0 175.0 150.0 130.0 115.0 85.0 65.0 50.0 35.0 25.0 20.0

1.00

1.00

Applied De-rate factor

De-rate factors 21-25 26-30 (std) 31-35 36-40 41-45 46-50 51-55

75

90 1400 1290 1160 1050 860 780 700 580 520 430 350 290 260 225 195 170 150 130 95 75 55 40 30 25

Motor HP with 90 De-rate 1400.0 1290.0 1160.0 1050.0 860.0 780.0 700.0 580.0 520.0 430.0 350.0 290.0 260.0 225.0 195.0 170.0 150.0 130.0 95.0 75.0 55.0 40.0 30.0 25.0

Specified Current with 90 De-rate 1400.0 1290.0 1160.0 1050.0 860.0 780.0 700.0 580.0 520.0 430.0 350.0 290.0 260.0 225.0 195.0 170.0 150.0 130.0 95.0 75.0 55.0 40.0 30.0 25.0

1.00

1.00

90 1.05 1.00 0.94 0.88 0.82 0.75 0.67

File: 343127108.xls, Sheet: Conductor Tables

1.04 1.00 0.96 0.91 0.87 0.82 0.76

3 of 4

Print Date: 01/20/2017

AWG or kcmil 4 x 350 3 x 500 4 x 250 3 x 350 2 x 500 3 x 4/0 2 x 350 2 x 250 2 x 4/0 500 350 250 4/0 3/0 2/0 1/0 1 2 4 6 8 10 12 14

60Hz Voltage Drop Impedance Based On per 1000 ft Motor HP 0.0150 0.11 0.0167 0.13 0.0183 0.14 0.0200 0.15 0.0250 0.19 0.0267 0.20 0.0300 0.23 0.0365 0.28 0.0400 0.30 0.0500 0.38 0.0600 0.46 0.0730 0.55 0.0800 0.61 0.0940 0.71 0.1100 0.84 0.1300 0.99 0.1600 1.22 0.2000 1.52 0.3000 2.28 0.4500 3.42 0.7000 5.32 1.1000 8.36 1.7000 12.92 2.7000 20.52

File: 343127108.xls, Sheet: Conductor Tables

4 of 4

Voltage Drop Based On Operating Current 0.06 0.06 0.07 0.08 0.10 0.10 0.11 0.14 0.15 0.19 0.23 0.28 0.30 0.36 0.42 0.49 0.61 0.76 1.14 1.71 2.66 4.18 6.46 10.26

Label kcmil kcmil kcmil kcmil kcmil AWG kcmil kcmil AWG kcmil kcmil kcmil AWG AWG AWG AWG AWG AWG AWG AWG AWG AWG AWG AWG

Print Date: 01/20/2017