Voltage drop & resistivity calculation

resistanceresistivityvoltage

I wanted to implement below formula into excel sheet. can someone suggest me with example.

cable equation
example : system voltage =12v, sys current=8A, length in feet=50.

Resistance = resistivity* length/ area

length = 50 feet

if we consider 26 gauge wire

diameter of wire =0.0159 inch =0.001325 feet

radius =0.01325/2 =0.006625

a = pi* radius^2= 0.000137090

resistivity =1.68*10^-8

therefore wire resistance= 0.0060

but data i got is not matching with value in table mention. can you some one suggest what mistake i am doing

voltage drop

wire gauge calculation


I am not saying my answer is correct . If you check the online calculator i posted it gives right choise of wire gauge.

i am trying to impliment same thing in excel sheet.

Help i need is example to explain the choose correct value & get answer similar to the online

length of cable= 50 feet

load current=6A

source voltage =12v

my intension to calculate re

  1. resistance per length in ohm
  2. voltage drop
  3. % voltage drop
  4. % loss
  5. select area which is good for the application

wire resistance calculator

Best Answer

26 AWG is 40 ohms / 1000 foot as per this table: -

enter image description here

A 50 foot length of this wire (2 ohms) with 8A will dissipate 128 watts i.e. it doesn't sound a sensible choice. The volt drop at 8A will be 16 volts.

As for your formula I can't tell whether it agrees or disagrees with whatever reference you have.