VOLTAGE DROP CALCULATOR FOR INSTRUMENT CABLE This spreadsheet calculates the approximate voltage drop at 20 mA, 350 mA, and 1/2A for various sized instrument cables. The only user input in in cell f5. Set Cable Length
250
meters
mm2
AWG
Ω/meter (approx)
Length (m)
R (Ω)
ΔE (V) for I=20mA
ΔE (V) for I=350mA
ΔE (V) for I=500mA
1.650 1.310 1.040 0.823 0.653 0.518 0.410 0.326 0.258 0.205 0.162 0.129 0.102 0.081
15 16 17 18 19 20 21 22 23 24 25 26 27 28
0.010 0.013 0.017 0.020 0.027 0.033 0.040 0.053 0.067 0.080 0.107 0.133 0.160 0.213
250 250 250 250 250 250 250 250 250 250 250 250 250 250
2.5 3.3 4.2 5.0 6.7 8.3 10.0 13.3 16.7 20.0 26.7 33.3 40.0 53.3
0.05 0.07 0.08 0.10 0.13 0.17 0.20 0.27 0.33 0.40 0.53 0.67 0.80 1.07
0.88 1.17 1.46 1.75 2.33 2.92 3.50 4.67 5.83 7.00 9.33 11.67 14.00 18.67
1.25 1.67 2.08 2.50 3.33 4.17 5.00 6.67 8.33 10.00 13.33 16.67 20.00 26.67
V V V V V V V V V V V V V V
V V V V V V V V V V V V V V
V V V V V V V V V V V V V V