When you are sizing wire for a 12V solar array or a 120V workshop branch circuit, guessing the gauge leads to melted insulation, tripped breakers, and starved motors. You need a reliable calculator with copy paste functionality built directly into your workflow so you can run scenarios in seconds without hunting through web apps that hide their math. By setting up a custom spreadsheet using the fundamental DC and single-phase AC voltage drop formula, you gain total control over your circuit design.

This guide provides the exact algebraic formulas, the spreadsheet syntax to copy-paste into Excel or Google Sheets, and a strict decision matrix to terminate your calculations in a concrete wire purchase.

The Core Voltage Drop Formula and Symbol Definitions

The standard approximate formula for voltage drop in DC and single-phase AC circuits (ignoring AC reactance and skin effect for wires smaller than 1/0 AWG) is derived directly from Ohm's Law ($V = I \times R$). Because a circuit requires a return path, we multiply the one-way resistance by two.

Vd = (2 × K × I × L) / CM

Spec Sheet: Formula Symbols and Assumptions
Symbol Definition Standard Units Realistic Magnitude / Value
Vd Voltage Drop Volts (V) 1.5V to 3.6V for a 120V circuit (1.25% to 3% drop). If your calculator outputs 45V, you have a unit error.
K Specific Resistance (Resistivity) Ω·cmil/ft 12.9 for Copper at 75°C. 21.2 for Aluminum at 75°C. (Use 10.8 for Cu at 20°C bench testing).
I Load Current Amperes (A) 15A or 20A for standard residential branch circuits; 8A to 15A for off-grid solar strings.
L One-Way Circuit Length Feet (ft) 50 ft to 200 ft for typical home runs. Note: This is the distance from panel to load, NOT the total wire length.
CM Cross-Sectional Area Circular Mils (cmil) 6,530 cmil for 12 AWG; 10,380 cmil for 10 AWG; 16,510 cmil for 8 AWG.
When This Formula Applies: This equation is valid for steady-state DC loads and single-phase 60Hz AC loads using conductors 1/0 AWG and smaller. It assumes a constant operating temperature (we use the 75°C column per Cerrowire's standard ampacity tables). For 3-phase AC, replace the '2' in the numerator with '1.732' (√3).

Rearranged Forms for Your Calculator with Copy Paste

To build a truly useful calculator with copy paste capabilities, you need more than just the formula to find voltage drop. You need to solve for the wire size (CM), the maximum current (I), or the maximum distance (L). Below are the rearranged algebraic forms and the exact syntax to paste into cell B5 of your spreadsheet, assuming your inputs are in B1 (K), B2 (I), B3 (L), and B4 (Target Vd).

1. Solving for Wire Size (CM)

Use this when you know your load and distance, and need to buy the right wire.

  • Algebra: CM = (2 × K × I × L) / Vd
  • Spreadsheet Formula: =(2 * B1 * B2 * B3) / B4

2. Solving for Maximum Current (I)

Use this when you have an existing wire run and want to know how much load you can safely add without exceeding a 3% drop.

  • Algebra: I = (Vd × CM) / (2 × K × L)
  • Spreadsheet Formula: =(B4 * B5) / (2 * B1 * B3) (Assuming B5 holds your wire's CM value)

3. Solving for Maximum Length (L)

Use this when placing a subpanel or solar inverter to find the absolute maximum distance before you must upsize the wire.

  • Algebra: L = (Vd × CM) / (2 × K × I)
  • Spreadsheet Formula: =(B4 * B5) / (2 * B1 * B2)

Worked Examples with Strict Unit Tracking

Abstract formulas fail on the jobsite without rigorous unit tracking. Here are two solved problems demonstrating exactly how the math flows.

Example 1: 12V DC Off-Grid Solar Array

Scenario: You are wiring a solar charge controller to a 12V battery bank. The continuous current is 30A. The one-way distance is 8 feet. You want to keep the voltage drop under 1% (0.12V) to ensure the MPPT controller tracks efficiently.

  1. Identify Variables: K = 12.9 (Copper, 75°C), I = 30A, L = 8 ft, Vd = 0.12V.
  2. Select Formula: We need to find the wire size, so we use CM = (2 × K × I × L) / Vd.
  3. Substitute Values: CM = (2 × 12.9 × 30 × 8) / 0.12
  4. Calculate Numerator: 2 × 12.9 = 25.8.   25.8 × 30 = 774.   774 × 8 = 6,192.
  5. Divide by Denominator: 6,192 / 0.12 = 51,600 CM.
  6. Result: 51,600 CM falls between 2 AWG (66,360 CM) and 4 AWG (41,740 CM). You must purchase 2 AWG THHN copper wire.

Example 2: 120V AC Workshop Receptacle Branch

Scenario: You are running a 120V, 20A dedicated circuit to a table saw at the back of a detached garage. The one-way run is 150 feet. The NEC recommends a maximum 3% drop for branch circuits (3.6V). Will 10 AWG copper wire suffice?

  1. Identify Variables: K = 12.9, I = 20A, L = 150 ft, CM = 10,380 (Standard value for 10 AWG).
  2. Select Formula: We need to find the voltage drop to verify the wire, so we use Vd = (2 × K × I × L) / CM.
  3. Substitute Values: Vd = (2 × 12.9 × 20 × 150) / 10,380
  4. Calculate Numerator: 2 × 12.9 × 20 × 150 = 77,400.
  5. Divide by Denominator: 77,400 / 10,380 = 7.45V.
  6. Result: A 7.45V drop is 6.2% of 120V. This exceeds the 3% limit and will cause the table saw motor to overheat under load. 10 AWG fails. You must recalculate using 8 AWG (16,510 CM), which yields a 4.68V drop (3.9% - still too high). You must step up to 6 AWG copper (26,240 CM), yielding a 2.95V drop (2.45%), which passes.

Unit Mistakes That Will Break Your Calculations

When building your calculator with copy paste templates, a single unit mismatch will silently output dangerous wire sizes. Watch for these three fatal errors:

The Mistake Why It Breaks the Math The Fix
Using Total Loop Length Plugging in 300 ft for a 150 ft run because 'there are two wires'. The '2' in the formula's numerator already accounts for the return path. Always input the physical one-way distance from the breaker to the outlet.
Using AWG Number for CM Typing '10' into the CM cell instead of '10,380'. This inflates your calculated voltage drop by a factor of 1,000. Create a VLOOKUP table in your spreadsheet that automatically converts an AWG input into its corresponding Circular Mils value.
Mixing Metric and Imperial Using the metric resistivity of copper ($1.72 \times 10^{-8} \Omega\cdot m$) alongside Imperial Circular Mils and feet. Stick strictly to K=12.9, Feet, and CM for US jobsites. If using metric, switch the entire formula to $V_d = (2 \times \rho \times I \times L) / A$ using meters and $mm^2$.

Decision Tree: Picking the Right Wire Based on Calculator Output

Once your spreadsheet spits out a required Circular Mils (CM) value, you need a hard rule to translate that number into a physical spool of wire at the supply house. Use this decision path to terminate your design process.

Wire Sizing Decision Matrix (Copper, 75°C THHN)
Calculated CM Requirement Standard AWG Pick Actual CM of Pick Max Ampacity (75°C Column)
≤ 4,110 12 AWG 6,530 25A
4,111 to 6,530 10 AWG 10,380 35A
6,531 to 10,380 8 AWG 16,510 50A
10,381 to 16,510 6 AWG 26,240 65A
16,511 to 26,240 4 AWG 41,740 85A
The Final Concrete Rule: If your calculated CM falls between standard sizes, your concrete pick is always the next largest standard AWG. For example, if your calculator outputs a requirement of 7,200 CM, you must buy 8 AWG THHN (16,510 CM). Never round down to 10 AWG, even if the math looks 'close enough.' Furthermore, if your one-way run exceeds 200 feet, bump one more AWG size up from the table to mitigate transient voltage sags during motor startup. For authoritative verification of these ampacity limits, always cross-reference the Southwire Voltage Drop Calculator and local NEC guidelines before pulling wire.