Cable-size-calculations-spreadsheet.xls
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Cable-size-calculations-spreadsheet.xls as PDF for free.
More details
- Words: 735
- Pages: 4
Cable Size Calculations Calculations Based On Motor HP Input Data
Calculated Values
Motor Voltage (V L-L)
460
Operating Current (A)
7.6
Motor HP
5.00
125% Current per NEC (A)
9.5
Cable Temperature Rating (°C)
75
"Zero Length" Cable Size
14 AWG
Ambient Temperature (°C)
26-30 (std)
Acceptable Voltage Drop (V)
Cable Length (ft)
500 Recommended Cable Size
Acceptable Voltage Drop (%)
7.97
12 AWG
3.0% Actual Voltage Drop (V)
6.46
Actual Voltage Drop (%)
2.4%
Calculations Based On Specified Current Input Data
Calculated Values
Operating Voltage (V L-L)
460 "Zero Length" Cable Size
Specified Current (A) Cable Temperature Rating (°C) Ambient Temperature (°C) Cable Length (ft) Acceptable Voltage Drop (%)
File: 415278075.xls, Sheet: Calculations
7.6 Acceptable Voltage Drop (V) 75
Recommended Cable Size
26-30 (std)
14 AWG 7.97
12 AWG
Actual Voltage Drop (V)
6.46
500 Actual Voltage Drop (%)
2.4%
3.0%
1 of 4
Print Date: 04/05/2019
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: 415278075.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: 04/05/2019
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: 415278075.xls, Sheet: Conductor Tables
1.04 1.00 0.96 0.91 0.87 0.82 0.76
3 of 4
Print Date: 04/05/2019
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.06 0.0167 0.06 0.0183 0.07 0.0200 0.08 0.0250 0.10 0.0267 0.10 0.0300 0.11 0.0365 0.14 0.0400 0.15 0.0500 0.19 0.0600 0.23 0.0730 0.28 0.0800 0.30 0.0940 0.36 0.1100 0.42 0.1300 0.49 0.1600 0.61 0.2000 0.76 0.3000 1.14 0.4500 1.71 0.7000 2.66 1.1000 4.18 1.7000 6.46 2.7000 10.26
File: 415278075.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: 04/05/2019
Calculated Values
Motor Voltage (V L-L)
460
Operating Current (A)
7.6
Motor HP
5.00
125% Current per NEC (A)
9.5
Cable Temperature Rating (°C)
75
"Zero Length" Cable Size
14 AWG
Ambient Temperature (°C)
26-30 (std)
Acceptable Voltage Drop (V)
Cable Length (ft)
500 Recommended Cable Size
Acceptable Voltage Drop (%)
7.97
12 AWG
3.0% Actual Voltage Drop (V)
6.46
Actual Voltage Drop (%)
2.4%
Calculations Based On Specified Current Input Data
Calculated Values
Operating Voltage (V L-L)
460 "Zero Length" Cable Size
Specified Current (A) Cable Temperature Rating (°C) Ambient Temperature (°C) Cable Length (ft) Acceptable Voltage Drop (%)
File: 415278075.xls, Sheet: Calculations
7.6 Acceptable Voltage Drop (V) 75
Recommended Cable Size
26-30 (std)
14 AWG 7.97
12 AWG
Actual Voltage Drop (V)
6.46
500 Actual Voltage Drop (%)
2.4%
3.0%
1 of 4
Print Date: 04/05/2019
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: 415278075.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: 04/05/2019
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: 415278075.xls, Sheet: Conductor Tables
1.04 1.00 0.96 0.91 0.87 0.82 0.76
3 of 4
Print Date: 04/05/2019
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.06 0.0167 0.06 0.0183 0.07 0.0200 0.08 0.0250 0.10 0.0267 0.10 0.0300 0.11 0.0365 0.14 0.0400 0.15 0.0500 0.19 0.0600 0.23 0.0730 0.28 0.0800 0.30 0.0940 0.36 0.1100 0.42 0.1300 0.49 0.1600 0.61 0.2000 0.76 0.3000 1.14 0.4500 1.71 0.7000 2.66 1.1000 4.18 1.7000 6.46 2.7000 10.26
File: 415278075.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: 04/05/2019
More Documents from "erwin pumay"
Cable-size-calculations-spreadsheet.xls
October 2019 2
Tht Soal Erwin.docx
June 2020 30
Abstrak.docx
November 2019 50
Hidroterapi.docx
June 2020 32
Reflective Ppt.pptx
June 2020 35