Spreadsheet: 874931d1721447612-iferror-or-ifna-help-cable-schedule-dev
Sheet: Lookup Tables

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AC RESISTANCE (OHMS/1000 FT) |  |  |  |  |  |  | DC RESISTANCE (OHMS/1000 FT)
 |  |  |  |  |  | SPEC | MANUFACTURER | [NAME] | COND SIZE | COND PER CBL | # [NAME] | INSULATION THICKNESS MILS | JACKET THICKNESS MILS | GROUND WIRE SIZE | OVERALL JACKET THICKNESS MILS | OD INCHES | LBS/FT | WIRE MAT |  | WIRE SIZE | CU IN PVC | AL IN PVC | CU IN AL | AL IN AL | CU IN RGS | AL IN RGS | CU | AL | CM | NEC LUGS AMPACITY | THERMAL AMPACITY
 |  | RUNTIME |  | MATERIAL |  | TC-P | HOUSTON | [NAME] | 14 AWG | 3 | 7 | 15 | 4 | 14 | 45 | 0.36 | 0.091 | CU |  | 14 AWG | 3.1 | N/A | 3.1 | N/A | 3.1 | N/A | 3.14 | 5.17 | 4110 | 15 | 25
 |  | ≥3 HRS |  | CU |  | TC-P | HOUSTON | [NAME] | 12 AWG | 3 | 7 | 15 | 4 | 12 | 45 | 0.41 | 0.126 | CU |  | 12 AWG | 2 | 3.2 | 2 | 3.2 | 2 | 3.2 | 1.98 | 3.25 | 6530 | 20 | 30
 |  | <3 HRS |  | AL |  | TC-P | HOUSTON | [NAME] | 10 AWG | 3 | 7 | 20 | 4 | 10 | 45 | 0.46 | 0.191 | CU |  | 10 AWG | 1.2 | 2 | 1.2 | 2 | 1.2 | 2 | 1.24 | 2.04 | 10380 | 30 | 40
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 8 AWG | 3 | 7 | 30 | 5 | 10 | 60 | 0.58 | 0.22 | CU |  | 8 AWG | 0.78 | 1.3 | 0.78 | 1.3 | 0.78 | 1.3 | 0.778 | 1.28 | 16510 | 40 | 55
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 8 AWG | 4 | 7 | 30 | 5 | 10 | 60 | 0.61 | 0.286 | CU |  | 6 [NAME] | 0.49 | 0.81 | 0.49 | 0.81 | 0.49 | 0.81 | 0.491 | 0.808 | 26240 | 55 | 75
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 6 [NAME] | 3 | 7 | 30 | 5 | 8 | 60 | 0.69 | 0.386 | CU |  | 4 AWG | 0.31 | 0.51 | 0.31 | 0.51 | 0.31 | 0.51 | 0.308 | 0.508 | 41740 | 70 | 95
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 6 [NAME] | 4 | 7 | 30 | 5 | 8 | 60 | 0.76 | 0.505 | CU |  | 3 [NAME] | 0.25 | 0.4 | 0.25 | 0.41 | 0.25 | 0.4 | 0.245 | 0.403 | 52620 | 85 | 115
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 4 AWG | 3 | 7 | 40 | 6 | 8 | 60 | 0.89 | 0.63 | CU |  | 2 AWG | 0.19 | 0.32 | 0.2 | 0.32 | 0.2 | 0.32 | 0.194 | 0.319 | 66360 | 95 | 130
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 4 AWG | 4 | 7 | 40 | 6 | 8 | 80 | 0.97 | 0.828 | CU |  | 1 AWG | 0.15 | 0.25 | 0.16 | 0.26 | 0.16 | 0.25 | 0.154 | 0.253 | 83690 | 130 | 145
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 2 AWG | 3 | 7 | 40 | 6 | 6 | 80 | 1.03 | 0.93 | CU |  | 1/0 AWG | 0.12 | 0.2 | 0.13 | 0.21 | 0.12 | 0.2 | 0.122 | 0.201 | 105600 | 150 | 170
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 2 AWG | 4 | 7 | 40 | 6 | 6 | 80 | 1.13 | 1.213 | CU |  | 2/0 AWG | 0.1 | 0.16 | 0.1 | 0.16 | 0.1 | 0.16 | 0.0967 | 0.159 | 133100 | 175 | 195
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 1 AWG | 3 | 19 | 50 | 7 | 6 | 80 | 1.15 | 1.252 | CU |  | 3/0 [NAME] | 0.077 | 0.13 | 0.082 | 0.13 | 0.079 | 0.13 | 0.0766 | 0.126 | 167800 | 200 | 225
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 1/0 AWG | 3 | 19 | 50 | 7 | 6 | 80 | 1.22 | 1.423 | CU |  | 4/0 AWG | 0.062 | 0.1 | 0.067 | 0.11 | 0.063 | 0.1 | 0.0608 | 0.1 | 211600 | 230 | 260
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 1/0 AWG | 4 | 19 | 50 | 7 | 6 | 80 | 1.34 | 1.832 | CU |  | 250 KCMIL | 0.052 | 0.085 | 0.057 | 0.09 | 0.054 | 0.086 | 0.0515 | 0.0847 | 200000 | 255 | 290
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 2/0 AWG | 3 | 19 | 50 | 7 | 6 | 80 | 1.32 | 1.718 | CU |  | 300 KCMIL | 0.044 | 0.071 | 0.049 | 0.076 | 0.045 | 0.072 | 0.0429 | 0.0707 | 300000 | 285 | 320
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 2/0 AWG | 4 | 19 | 50 | 7 | 6 | 80 | 1.45 | 2.223 | CU |  | 350 KCMIL | 0.038 | 0.061 | 0.043 | 0.066 | 0.039 | 0.063 | 0.0367 | 0.0605 | 350000 | 310 | 350
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 3/0 [NAME] | 3 | 19 | 50 | 7 | 4 | 80 | 1.42 | 2.131 | CU |  | 400 KCMIL | 0.033 | 0.054 | 0.038 | 0.059 | 0.035 | 0.055 | 0.0321 | 0.0529 | 400000 | 335 | 380
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 3/0 [NAME] | 4 | 19 | 50 | 7 | 4 | 80 | 1.58 | 2.756 | CU |  | 500 KCMIL | 0.027 | 0.043 | 0.032 | 0.048 | 0.029 | 0.045 | 0.0258 | 0.0424 | 500000 | 380 | 430
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 4/0 AWG | 3 | 19 | 50 | 7 | 4 | 80 | 1.54 | 2.592 | CU |  | 600 KCMIL | 0.023 | 0.036 | 0.028 | 0.041 | 0.025 | 0.038 | 0.0214 | 0.0353 | 600000 | 420 | 475
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 4/0 AWG | 4 | 19 | 50 | 7 | 4 | 80 | 1.77 | 3.457 | CU |  | 750 KCMIL | 0.019 | 0.029 | 0.024 | 0.034 | 0.021 | 0.031 | 0.0171 | 0.0282 | 750000 | 475 | 535
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 250 KCMIL | 3 | 37 | 60 | 8 | 3 | 110 | 1.75 | 3.123 | CU |  | 1000 KCMIL | 0.015 | 0.023 | 0.019 | 0.027 | 0.018 | 0.025 | 0.0129 | 0.0212 | 1000000 | 545 | 615
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 250 KCMIL | 4 | 37 | 60 | 8 | 3 | 110 | 1.94 | 4.046 | CU
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 350 KCMIL | 3 | 37 | 60 | 8 | 3 | 110 | 1.97 | 4.204 | CU
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 350 KCMIL | 4 | 37 | 60 | 8 | 3 | 110 | 2.18 | 5.469 | CU
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 500 KCMIL | 3 | 37 | 60 | 8 | 2 | 110 | 2.26 | 5.792 | CU
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 500 KCMIL | 4 | 37 | 60 | 8 | 2 | 110 | 2.49 | 7.556 | CU
 |  |  |  |  |  | TC-P | HOUSTON | [NAME] | 750 KCMIL | 3 | 61 | 60 | 9 | 1 | 110 | 2.82 | 9.06 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 14 AWG | 1 | 19 | 15 | 4 |  |  | 0.11 | 0.16 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 12 AWG | 1 | 19 | 15 | 4 |  |  | 0.13 | 0.024 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 10 AWG | 1 | 19 | 20 | 4 |  |  | 0.17 | 0.039 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 8 AWG | 1 | 19 | 30 | 5 |  |  | 0.22 | 0.063 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 6 [NAME] | 1 | 19 | 30 | 5 |  |  | 0.26 | 0.098 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 4 AWG | 1 | 19 | 40 | 6 |  |  | 0.33 | 0.157 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 3 [NAME] | 1 | 19 | 40 | 6 |  |  | 0.36 | 0.193 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 2 AWG | 1 | 19 | 40 | 6 |  |  | 0.39 | 0.24 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 1 AWG | 1 | 19 | 50 | 7 |  |  | 0.43 | 0.3 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 1/0 AWG | 1 | 19 | 50 | 7 |  |  | 0.47 | 0.376 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 2/0 AWG | 1 | 19 | 50 | 7 |  |  | 0.52 | 0.467 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 3/0 [NAME] | 1 | 19 | 50 | 7 |  |  | 0.57 | 0.581 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 4/0 AWG | 1 | 19 | 50 | 7 |  |  | 0.64 | 0.724 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 250 KCMIL | 1 | 37 | 60 | 8 |  |  | 0.69 | 0.855 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 300 KCMIL | 1 | 37 | 60 | 8 |  |  | 0.76 | 1.022 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 350 KCMIL | 1 | 37 | 60 | 8 |  |  | 0.79 | 1.191 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 400 KCMIL | 1 | 37 | 60 | 8 |  |  | 0.85 | 1.345 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 500 KCMIL | 1 | 37 | 60 | 8 |  |  | 0.94 | 1.668 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 600 KCMIL | 1 | 61 | 70 | 9 |  |  | 1.1 | 1.994 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 750 KCMIL | 1 | 61 | 70 | 9 |  |  | 1.16 | 2.465 | CU
 |  |  |  |  |  | THHN | HOUSTON | HW001 | 1000 KCMIL | 1 | 61 | 70 | 9 |  |  | 1.32 | 3.3 | CU