Batch Voltage Drop Tool

Voltage Drop BatchCalculator

Paste rows from Excel, Google Sheets, or CSV to calculate voltage drop for multiple AC and DC circuits in one pass.

Paste spreadsheet rows

Excel, Google Sheets, CSV, or tab-delimited input

Target drop %Default power factorDefault conduit

One-way length input, line-to-load output

Valid rows

Within target

Over target

Average drop

3.50%

Worst row: Battery string A at 5.29% drop.

Circuit	System	Wire	Length	Drop	Drop %	Load V	Method	Status
Parking lot pole 1 16A at 120V	AC 1-phase	8 Cu	180 ft	4.36 V	3.63%	115.6 V	Table 9 Z_eff, PF 0.95, pvc	Over target
Rooftop RTU-3 42A at 480V	AC 3-phase	6 Cu	260 ft	8.61 V	1.79%	471.4 V	Table 9 Z_eff, PF 0.88, steel	Within target
Battery string A 55A at 48V	DC	4 Cu	75 ft	2.54 V	5.29%	45.5 V	DC loop resistance	Over target
Gate operator feeder 24A at 240V	AC 1-phase	4 Al	340 ft	7.83 V	3.26%	232.2 V	Table 9 Z_eff, PF 0.90, pvc	Over target

Expected columns

Header names can be flexible. The parser accepts aliases like name, amps, distance, awg, and pf.

circuit, system, voltage, current, length_ft, wire_size, material, power_factor, conduit, parallel

Method notes

DC rows use the site’s Chapter 9 Table 8 resistance values and assume one-way length with return-path doubling in the formula.
AC rows use Chapter 9 Table 9 resistance and reactance with the supplied or default power factor and conduit type.
This tool checks voltage drop only. Use the wire sizing and NEC reference pages to verify ampacity, temperature correction, and conduit fill.
AC spreadsheet rows currently support 14 AWG through 500 kcmil because larger Table 9 values are not loaded in this page.

Related tools