Turn a voltage drop spreadsheet into a calculator electricians open on a phone
Quick answer
A voltage drop calculator needs a conductor table and three formulas: 2 × I × R × L for single-phase and DC, √3 × I × (R cos φ + X sin φ) × L for three-phase, or 2 × K × I × L / CM with K = 12.9 for copper and 21.2 for aluminum. An AI can rewrite your sheet as one HTML file that you test and publish at a link.
For your team only, publish it on a private link or behind a password, both with Pro.
Make your team's version
Convika's AI rewrites this calculator from what you write. You try it on your phone before you keep it, with no account.
On this page
- The voltage drop formulas, with units and sources
- The conductor table goes into the file
- Worked examples, checked against published ones
- Fire alarm circuits: the voltage at the last appliance
- The prompt for ChatGPT, Claude, or Gemini
- Test cases to check the page against your sheet
- Where a sheet and its JavaScript drift apart
- Ways to put a voltage drop calculator on your crew's phones
- Publish the calculator for your crew in 5 steps
- Frequently asked questions
- Sources
The voltage drop workbook on the office PC works. The electrician pulling wire on the third floor can't open it: the phone has no macros, the cell references mean nothing at 6 inches wide, and someone overwrote the K value last month. This guide gives you every formula such a sheet uses, with its units, limits, and source, the conductor table to put in the file, worked examples checked against published ones, the prompt that turns your sheet into one HTML file, the test cases to check it against the sheet, and how to give your crew the link. Sources were read on November 6, 2026.
The formulas below are standard, but your sheet may use different tables or limits. Check the page's results against your own sheet and the code your job is built to before anyone relies on it.
The voltage drop formulas, with units and sources
Every voltage drop sheet comes down to Ohm's law: the drop is the current times the resistance of the wire it flows through, counted for the way the current returns.
| Circuit | Volts dropped | Units | Use it when | Source |
|---|---|---|---|---|
| Single-phase, 2 wires, or DC | VD = 2 × I × R × L | I in A; R in Ω per 1,000 ft (or Ω/km) of one conductor; L one-way, in 1,000 ft (or km) | Reactance is small: DC, conductors up to about 1/0, power factor near 1 | Mike Holt, EC&M; IAEI |
| Three-phase, balanced | VD = √3 × I × R × L | as above; VD line to line | Same as above | Mike Holt, EC&M; IAEI |
| Any AC circuit, with reactance | VD = 2 (or √3) × I × (R cos φ + X sin φ) × L | X in Ω per length; cos φ the load's power factor | Larger conductors, motors, steel conduit | NEC Chapter 9 Table 9 Note 2; Schneider Electric's guide |
| Circular-mil form | VD = 2 (or 1.732) × K × I × L / CM | K in Ω·cmil/ft; L one-way in ft; CM the conductor's area in circular mils | AC up to 1/0, or DC; 75 °C conductors | Mike Holt, EC&M; IAEI |
| Percent | VD% = 100 × VD / V | V the circuit's nominal voltage, line to line for three-phase | Every circuit |
Single-phase and DC circuits
The 2 is the trip out and back: current flows to the load on one conductor and returns on the other, so the wire length in the circuit is twice the one-way distance. Mike Holt's article for EC&M puts it as volts dropped equal to the current times "the total resistance of the circuit conductors" and works this example: two 12 AWG conductors, a 16 A load at 120 V, 100 ft from the supply. With 12 AWG stranded copper at 1.98 Ω per 1,000 ft from NEC Chapter 9 Table 8, 2 × 16 × 1.98 × 100 / 1,000 = 6.34 V, or 5.3% of 120 V. The article gets 6.4 V because it takes 2 Ω per 1,000 ft from Table 9.
DC circuits, such as 12 V and 24 V battery, solar, and controls wiring, use the same formula. A 10 A load 10 m from a 12 V battery on 4 mm² copper (4.61 Ω/km at 20 °C) drops 2 × 10 × 4.61 × 0.010 = 0.92 V: 7.7% of 12 V, where the same 0.92 V would be 0.4% of 230 V. Low voltages need bigger conductors for the same percentage.
Three-phase circuits and reactance
On a balanced three-phase circuit the line-to-line drop is √3 times the drop in one conductor. Where the conductor's reactance matters, the drop per conductor uses the effective impedance that Note 2 to NEC Chapter 9 Table 9 defines, Effective Z = R cos θ + X sin θ, with θ the angle of the load's power factor. PDHonline's course on voltage drop by David A. Snyder, PE, quotes the note and works a 10 hp motor at 480 V three-phase: 14 A on 200 ft of 12 AWG in steel conduit, R = 2.0 and X = 0.068 Ω per 1,000 ft from Table 9, power factor 0.85. Effective Z = 2.0 × 0.85 + 0.068 × 0.527 = 1.736 Ω per 1,000 ft, and √3 × 14 × 1.736 × 0.2 = 8.42 V, or 1.75%. The course's exact phasor calculation gives 8.443 V, so the shortcut is within 0.3% there. Using the DC resistance alone (√3 × 14 × 1.98 × 0.2) gives 9.60 V, 14% high.
Schneider Electric's Electrical Installation Guide gives the same pair of formulas for IEC installations: ΔU = 2 I_B (R cos φ + X sin φ) L for a single-phase circuit and √3 I_B (R cos φ + X sin φ) L for a balanced three-phase one, with L in km. It adds three rules of thumb: take X as 0.08 Ω/km when you have no other figure, treat X as negligible below 50 mm², and treat R as negligible above 500 mm². Its own 35 mm² motor example still counts X, and at cos φ 0.8 it adds 9% there (worked below), so keep X wherever the power factor is well under 1. For cos φ it lists 0.8 for a motor in normal service, 0.35 for a motor starting, and 1 for incandescent lighting.
The circular-mil form and K
The circular-mil form, the one Mike Holt's and IAEI's articles use, replaces R with K / CM:
- VD = 2 × K × I × L / CM for single-phase, and VD = 1.732 × K × I × L / CM for three-phase.
- K is "the direct current resistance for a 1000 circular mils conductor that's 1000 ft long, at an operating temperature of 75°C": 12.9 Ω for copper and 21.2 Ω for aluminum, in Holt's words. He adds that K "is suitable for alternating current circuits, where the conductors do not exceed No. 1/0"; for 2/0 and larger, multiply by Table 9's AC resistance over Table 8's DC resistance.
- L is the one-way distance to the load in feet, "not the total length of the circuit conductors."
- I is the load at 100%, "not 125% for motors or continuous loads."
- CM is the conductor's area in circular mils from Table 8.
K isn't a separate constant: it's each conductor's resistance times its area. IAEI's article multiplies 1,000 kcmil copper's 0.0129 Ω per 1,000 ft by its 1,000,000 circular mils to get 12.9. Doing the same for every size from 14 AWG to 4/0 in Table 8 gives 12.84 to 12.93 for copper (mean 12.88) and 21.13 to 21.25 for aluminum (mean 21.19), so K = 12.9 and 21.2 are within half a percent of the table for any size. Holt's two published examples check out with it:
- 6 AWG copper (26,240 cmil), 44 A, 160 ft, 240 V single-phase: 2 × 12.9 × 44 × 160 / 26,240 = 6.92 V, or 2.9%. Holt: 6.9 V, 2.9%.
- 1 AWG aluminum (83,690 cmil), 100 A, 80 ft, 208 V three-phase: 1.732 × 21.2 × 100 × 80 / 83,690 = 3.51 V, or 1.7%. Holt: 3.5 V, 1.7%.
Turned around, the same formula gives the smallest conductor and the longest run. IAEI lists both: CM = 2 × K × I × L / VD, and maximum length = CM × VD / (2 × K × I). For the 44 A load above at 3% of 240 V (7.2 V), CM must be at least 2 × 12.9 × 44 × 160 / 7.2 = 25,227, so 6 AWG at 26,240 is the first size that passes, and 6 AWG reaches 166 ft before the drop passes 7.2 V.
Percent drop and the 3% and 5% figures
Percent drop is 100 × VD / V, with V the circuit's nominal voltage. For three-phase, divide the line-to-line drop by the line-to-line voltage.
US (NEC). The numbers come from informational notes, not rules. As Mike Holt quotes the note to 210.19(A) for EC&M: "Conductors for branch circuits defined in Art. 100, sized to prevent a voltage drop exceeding 3% at the farthest outlet of power, heating, and lighting loads, or combinations of such loads, and where the maximum total voltage drop on both feeders and branch circuits to the farthest outlet does not exceed 5%, provide reasonable efficiency of operation." A matching note follows 215.2(A) for feeders. IAEI's article states the status plainly: "Informational notes are not mandatory Code requirements, but are explanatory material intended for informational purposes only [see 90.5(C)]." The notes' numbers have moved between editions (Note No. 4 in the 2014 edition, for example), so cite the edition your job uses. Three things can still make a limit binding:
- Equipment instructions, which 110.3(B) requires you to follow, "often require a minimum voltage rating to be maintained" (IAEI).
- A few sections are mandatory: 647.4(D) for sensitive electronic equipment (1.5% on the branch circuit, 2.5% in total, per the PDHonline course) and 695.7 for fire pumps.
- A local amendment or the job's specification.
You can read the current NFPA 70 free on NFPA's free access site, after signing in; it's "a read-only site," and documents "cannot be downloaded or printed."
IEC. Schneider Electric's guide prints the limits of IEC 60364-5-52 Table G.52.1 as its Figure G27, as the maximum drop "between the origin of an installation and any load point":
| Type of installation | Lighting circuits | Other uses (heating and power) |
|---|---|---|
| Low voltage installations supplied directly from a public low voltage distribution system | 3% | 5% |
| Low voltage installation supplied from private LV supply | 6% | 8% |
The guide adds that "Maximum allowable voltage-drop vary from one country to another," and that the limits apply in steady state, "not at times of motor starting." Put the limit in your calculator as an input with a default, not as a constant: the page then works for a branch circuit, a feeder, a 1.5% sensitive-equipment circuit, or a country with its own figure.
The conductor table goes into the file
The calculator computes from a table written into the HTML file, in the phone's browser, with no spreadsheet or server behind it. These are the NEC Chapter 9 Table 8 values for stranded conductors, DC resistance at 75 °C, from a copy of the table posted by NECA-IBEW Electricians; check them against the edition your job uses.
| Size (AWG or kcmil) | Area (circular mils) | Copper, uncoated (Ω per 1,000 ft) | Aluminum (Ω per 1,000 ft) | K, copper | K, aluminum |
|---|---|---|---|---|---|
| 14 | 4,110 | 3.14 | 5.17 | 12.91 | 21.25 |
| 12 | 6,530 | 1.98 | 3.25 | 12.93 | 21.22 |
| 10 | 10,380 | 1.24 | 2.04 | 12.87 | 21.18 |
| 8 | 16,510 | 0.778 | 1.28 | 12.84 | 21.13 |
| 6 | 26,240 | 0.491 | 0.808 | 12.88 | 21.20 |
| 4 | 41,740 | 0.308 | 0.508 | 12.86 | 21.20 |
| 3 | 52,620 | 0.245 | 0.403 | 12.89 | 21.21 |
| 2 | 66,360 | 0.194 | 0.319 | 12.87 | 21.17 |
| 1 | 83,690 | 0.154 | 0.253 | 12.89 | 21.17 |
| 1/0 | 105,600 | 0.122 | 0.201 | 12.88 | 21.23 |
| 2/0 | 133,100 | 0.0967 | 0.159 | 12.87 | 21.16 |
| 3/0 | 167,800 | 0.0766 | 0.126 | 12.85 | 21.14 |
| 4/0 | 211,600 | 0.0608 | 0.100 | 12.87 | 21.16 |
- Solid conductors have their own rows: 14 AWG solid copper is 3.07 Ω and 12 AWG solid is 1.93 Ω per 1,000 ft.
- Coated copper (tinned strands) has a higher resistance in its own column. IAEI's advice: use the "uncoated copper" column, "as most copper conductors are uncoated," unless the conductor is coated.
- Reactance isn't in Table 8. Table 9 lists AC resistance and reactance by conduit type. In steel conduit, the PDHonline course reads X = 0.068 Ω per 1,000 ft for 12 AWG, 0.063 for 10 AWG, 0.060 for 4 AWG, 0.057 for 2 AWG, and 0.055 for 1/0. If your sheet has an X column, copy it with the conduit type it belongs to.
Metric conductors. IEC 60228 gives the maximum resistance at 20 °C. As Cembre's catalogue reproduces it (IEC 60228:2004), in Ω/km:
| Area (mm²) | Copper, class 1 (solid) | Copper, class 5 (flexible) | Aluminum, class 1 |
|---|---|---|---|
| 1.5 | 12.1 | 13.3 | — |
| 2.5 | 7.41 | 7.98 | — |
| 4 | 4.61 | 4.95 | — |
| 6 | 3.08 | 3.30 | — |
| 10 | 1.83 | 1.91 | 3.08 |
| 16 | 1.15 | 1.21 | 1.91 |
| 25 | 0.727 | 0.780 | 1.20 |
| 35 | 0.524 | 0.554 | 0.868 |
| 50 | 0.387 | 0.386 | 0.641 |
| 70 | 0.268 | 0.272 | 0.443 |
| 95 | 0.193 | 0.206 | 0.320 |
| 120 | 0.153 | 0.161 | 0.253 |
The catalogue's footnotes limit some of these sizes to particular cable types, so use your cable maker's data sheet where you have one. Schneider Electric's guide takes the simpler route of R = 23.7 Ω·mm²/km ÷ area for copper and 37.6 for aluminum, values it attributes to IEC 60909-0 and CENELEC TR 50480. For 2.5 mm² that gives 9.48 Ω/km, higher than the 7.41 at 20 °C, so it errs toward a larger drop.
Copper or aluminum
Table 8's notes give the conductivities used: "bare copper = 100%, aluminum = 61%." Aluminum's resistance is about 1 / 0.61 = 1.64 times copper's for the same area, which is also 21.2 / 12.9. In practice aluminum runs about two gauge numbers heavier for the same drop: 10 AWG aluminum (2.04 Ω) is close to, and slightly above, 12 AWG copper (1.98 Ω). Keep the metal as an input that picks the column, never as a second copy of the formulas.
Temperature
Table 8's resistances hold at 75 °C. Its Note 2 gives the correction: R2 = R1 × [1 + α × (T2 − 75)], with α = 0.00323 for copper and 0.00330 for aluminum. At 60 °C a copper conductor's resistance is 0.952 times the table value, about 5% lower; at 90 °C it's 1.048 times, about 5% higher. The PDHonline course points out that the note is meant for the conductor's operating and termination temperature, not the air around it.
For a 20 °C table such as IEC 60228, use R_T = R_20 × [1 + α_20 × (T − 20)]. NBS Handbook 100 gives the copper coefficient: the International Electrotechnical Commission "specified the temperature coefficient of standard copper to be 0.00393 at 20 °C." For aluminum, the NEC's 0.00330 at 75 °C works out to 0.00403 at 20 °C (α_20 = α_75 / (1 − 55 × α_75)); the same conversion turns the NEC's copper figure back into 0.00393. So 2.5 mm² copper at 7.41 Ω/km and 20 °C is 8.87 Ω/km at 70 °C.
Worked examples, checked against published ones
A short Node.js script computed each case on this page with the formulas above. The right-hand column is the published answer for the same inputs.
| Case | Formula | Result here | Published |
|---|---|---|---|
| 12 AWG Cu, 16 A, 100 ft, 120 V, single-phase | 2 × I × R × L, R = 1.98 | 6.34 V, 5.28% | 6.4 V with R = 2.0 from Table 9 (Holt) |
| 6 AWG Cu, 44 A, 160 ft, 240 V, single-phase | 2 × K × I × L / CM | 6.92 V, 2.88% | 6.9 V, 2.9% (Holt) |
| 1 AWG Al, 100 A, 80 ft, 208 V, three-phase | 1.732 × K × I × L / CM | 3.51 V, 1.69% | 3.5 V, 1.7% (Holt) |
| 12 AWG, 14 A, 200 ft, 480 V, three-phase, PF 0.85, steel conduit | √3 × I × (R cos φ + X sin φ) × L | 8.418 V, 1.75% | 8.418 V, 1.753% (PDHonline) |
| 10 AWG, 10 A, 100 ft, 120 V, single-phase, PF 0.9 | 2 × I × (R cos φ + X sin φ) × L, R 1.2, X 0.063 | 2.215 V, 1.85% | 2.215 V, 1.845% (PDHonline) |
| 2.5 mm² Cu, 20 A, 20 m, 230 V, lighting, cos φ 1 | 2 × I × R × L, R = 23.7 / 2.5 | 7.58 V | 7.6 V (Schneider, example 2) |
| 35 mm² Cu, 100 A, 50 m, 400 V, motor, cos φ 0.8 | √3 × I × (R cos φ + X sin φ) × L, X = 0.08 | 5.11 V, 1.28% | 5 V from its table of 1 V/A/km (Schneider, example 1) |
The last row differs because Schneider's example reads a rounded table: 1 V per ampere per km × 100 A × 0.05 km. Leaving X out gives 4.69 V, so the reactance adds about 9% on that cable.
Fire alarm circuits: the voltage at the last appliance
A notification appliance circuit is DC, so the formula is 2 × I × R × L, but the question is different: what voltage reaches the last horn or strobe, with the panel running on a fully depleted battery. California's HCAI (then OSHPD) sets out one published method in PIN 63, "Fire Alarm Voltage Drop and Testing," effective April 28, 2016, for the health facility drawings it reviews:
- Start from "the control unit's output voltage with a fully depleted battery." For "a typical control panel that has a nominal output voltage of 24 VDC," that "would typically be 20.4 VDC."
- The voltage at each appliance must not drop below "its listed minimum operating voltage. This would typically be 16.0 VDC."
- Keep 10% spare for visible appliances added later. The notice's arithmetic: 20.4 − 16.0 = 4.4 V, less 0.4 V of spare, gives a 4.0 V maximum drop.
- In the field, "Remove the end-of-line appliance, keeping the wiring intact," activate the alarm so the circuit operates, measure the voltage at the panel, subtract the 4.0 V, and check the voltage measured at the end-of-line appliance against that.
Your panel's manual, the appliances' data sheets, and your authority having jurisdiction set the numbers for your job; the notice is a worked public example.
Take each appliance's current from its install sheet, not one nominal figure. Cooper Wheelock's sheet for its Exceder horn strobes (P85066C, 2012), for example, says "Candela setting, horn setting and voltage will determine the current draw of the product" and tells you to "use Tables 3-5 to determine the highest value of RMS current for an individual appliance."
How you add up the drop matters. Take 10 appliances drawing 0.15 A each on 14 AWG solid copper (3.07 Ω per 1,000 ft), the first 100 ft from the panel and the rest 40 ft apart, 460 ft in all:
- All current at the far end (the quick check): 2 × 1.5 A × 3.07 × 0.46 = 4.24 V, so 16.16 V at the last appliance. That's over PIN 63's 4.0 V.
- Appliance by appliance: each 40 ft segment carries only the current of the appliances beyond it. The drop adds up to 2.58 V, so 17.82 V at the last appliance. It passes.
In a spreadsheet, the second method is a row per appliance. In the page, it's a loop over a list of appliances, each with its current and its distance from the one before. Ask for both results side by side, and for the voltage at every appliance, not only the last.
The prompt for ChatGPT, Claude, or Gemini
Two limits of a page on Convika shape the prompt. It runs the page's own scripts, inline or from an https:// address, but not eval or new Function, so a formula-parser library that turns text into code won't run: ask for plain functions. And its scripts' fetch and XHR requests reach only the page's own address on Free; Pro and MAX add the analytics tools Convika supports and up to 20 hosts you list for your own ad network. So the page can't read a live spreadsheet or a supplier's table: the tables go into the file.
Paste the prompt with your own inputs, formulas, and tables. It builds one calculator with three choices, so the same page runs every test case below: US or metric units; resistance from the table, from K, or typed in; and the circuit type. Name every input with its unit: most mismatches between a sheet and its rewrite start with feet against thousands of feet, or one-way length against wire length.
Rewrite my voltage drop spreadsheet as one HTML file that works on a phone.
Inputs (name, unit, default):
- Units: US (AWG or kcmil, ft, ohms per 1,000 ft) or metric (mm², m, ohms per km)
- System: single-phase AC, three-phase AC, or DC
- Voltage, V (line to line for three-phase): 240
- Load current, A: 44
- One-way length (distance to the load, not wire length): 160 ft
- Metal: copper or aluminum
- Size: from the table for the chosen units
- Resistance from: the table (default), K (US only), or "enter R and X",
which adds two fields in ohms per 1,000 ft (US) or per km (metric)
- Power factor (AC only): 1.00
- Conductor temperature, °C: 75 for US, 20 for metric
- Allowed drop, %: 3
Formulas (keep them exactly as written):
- US table R at temperature T: R = R75 × (1 + a × (T − 75));
a = 0.00323 copper, 0.00330 aluminum
- Metric table R at temperature T: R = R20 × (1 + a × (T − 20));
a = 0.00393 copper, 0.00403 aluminum
- K: R = K × 1000 / CM ohms per 1,000 ft, K = 12.9 copper, 21.2 aluminum,
CM from the US table; no temperature correction
- Entered R and X: used exactly as entered, no temperature correction
- X = 0 unless it is entered (or my table has an X column)
- Single-phase and DC: VD = 2 × I × (R × PF + X × sin(acos(PF))) × L / 1000
- Three-phase: VD = 1.732 × I × (R × PF + X × sin(acos(PF))) × L / 1000
(US: L in ft, R per 1,000 ft. Metric: L in m, R per km.)
- DC: PF = 1 and X = 0
- Percent = 100 × VD / voltage
- Smallest size that passes: the first size, going up the table, whose percent
is at or under the allowed drop, with the resistance taken the same way
Tables (write them into the file as constants):
- US: size, circular mils, R copper, R aluminum (ohms per 1,000 ft at 75 °C): [paste]
- Metric: size in mm², R copper, R aluminum (ohms per km at 20 °C): [paste]
Rules:
- Plain JavaScript functions inside the file. No eval, no new Function, no formula
parser library, no fetch or other network requests.
- Refuse a blank input with a message, instead of computing with 0. Voltage, current,
length, allowed drop, an entered R, and (AC only) the power factor must be above
zero, the power factor at most 1. X may be 0, and the temperature may be 0 or below.
- Under the result, show R and X used, the drop in volts, the percent, pass or fail
against the allowed drop, and the smallest size that passes.
- Label every input with its unit; use inputmode="decimal" on number fields.
- Show "v1, checked against [sheet name] on [date]" at the bottom of the page.
- Add a "Run test cases" button that runs the cases below and shows pass or fail
for each, to 0.01 V.
Test cases:
[paste the test table]
If the sheet has a fire alarm tab, add: "A second tab for notification appliance circuits: starting voltage (default 20.4 V), minimum appliance voltage (default 16.0 V), a list of appliances with current in A and distance from the previous one in ft, and the conductor's ohms per 1,000 ft. Show the voltage at each appliance, both appliance by appliance and with all current at the end." Its check: 10 appliances at 0.15 A on 14 AWG solid copper (3.07 Ω per 1,000 ft), the first 100 ft out and the rest 40 ft apart, give 16.16 V at the last appliance with all current at the end and 17.82 V appliance by appliance.
Test cases to check the page against your sheet
Run these in the sheet and in the page. Each row names the units and where the resistance comes from, so the calculator above runs all of them. They use the table values on this page; if your sheet's table differs, recompute the table rows from your sheet first, then compare the page to the sheet.
| # | Units, resistance from | Inputs | Expected drop | Expected percent |
|---|---|---|---|---|
| 1 | US, table | Single-phase 120 V, 12 AWG copper, 16 A, 100 ft, PF 1; at 75 °C, then at 90 °C | 6.34 V; 6.64 V at 90 °C | 5.28%; 5.54% |
| 2 | US, K | Single-phase 240 V, 6 AWG copper (26,240 cmil), 44 A, 160 ft | 6.92 V | 2.88% |
| 3 | US, K | Three-phase 208 V, 1 AWG aluminum (83,690 cmil), 100 A, 80 ft | 3.51 V | 1.69% |
| 4 | US, entered | Three-phase 480 V, R 2.0, X 0.068 Ω per 1,000 ft, PF 0.85, 14 A, 200 ft | 8.42 V | 1.75% |
| 5 | Metric, entered | Single-phase 230 V, R 9.48, X 0 Ω/km, 20 A, 20 m | 7.58 V | 3.30% |
| 6 | Metric, entered | Three-phase 400 V, R 0.677, X 0.08 Ω/km, PF 0.8, 100 A, 50 m | 5.11 V | 1.28% |
| 7 | Metric, table | DC 12 V, 4 mm² copper, class 1 (4.61 Ω/km), 10 A, 10 m, at 20 °C | 0.92 V | 7.68% |
| 8 | US, table | Size search: single-phase 240 V, copper, 75 °C, 44 A, 160 ft, 3% allowed | 6 AWG at 6.91 V (8 AWG fails at 10.95 V, 4.56%) | 2.88% |
Add your own cases at the edges: the longest run you ever wire, a load that lands exactly on the allowed drop, a size at the end of the table, and a blank input. How to check that an AI-made page is right before you send it covers the rest of the page: buttons, links, text, and phone layout.
Where a sheet and its JavaScript drift apart
- Length. The formulas take the one-way distance. Some sheets ask for wire length, and IAEI's own ampere-feet example uses "620 feet (310 feet x 2 = to the load and back)". Say which one your sheet means, in the input's label.
- The next size up. A lookup decides which size passes. Microsoft's MATCH with match type 1 "finds the largest value that is less than or equal to lookup_value," so a sheet that looks up the required circular mils that way lands on the size below. XLOOKUP's match mode 1 returns "the next larger item." Tell the AI which lookup the sheet uses, and test with a requirement that falls between two sizes (case 8).
- Percent cells. A cell that shows 3% holds 0.03. If the page asks for "3", it must divide by 100 once, not twice.
- Blank cells. Excel reads a blank power factor as 0, which makes R cos φ zero and the drop far too small. In JavaScript, Number("") is also 0. Ask the page to refuse blanks.
- Rounding. Round only what's shown. A sheet that rounds R or the current in a helper cell gives slightly different volts; copy that rounding into the page or take it out of both.
- Constants. 1.732 against Math.sqrt(3), or K = 12.9 against R × CM from the table, differ by up to half a percent. Use the sheet's own constants while you test, so a mismatch means a real error.
Ways to put a voltage drop calculator on your crew's phones
Each cell comes from the vendor's own page, read on November 6, 2026.
| Option | Whose formulas and tables | Can the people who use it see or change your formulas? | Where it runs | Updating it |
|---|---|---|---|---|
| The workbook in Excel on the phone | Yours | Yes: whoever has the file has the formulas | Excel for iOS runs no VBA macros (Microsoft's platform table) | Send the file again |
| Southwire's voltage drop calculator, web and app | Southwire's: "designed for applications using AWG and KCMIL sizes only" | Not your formulas | Southwire's site, Android and iOS apps | Southwire's |
| Calcapp | Yours, rebuilt with Calcapp formulas that "use names instead of cell references" | They can't change them: "Nobody can mess up your formulas" | A Calcapp app, "installed on your phone or embedded in your website" | In Calcapp's designer |
| Appizy | Yours: you upload the Excel file | They can't see them: "Your formulas execute server-side" | Appizy's servers | "Upload a new version of your Excel file and republish" |
| An HTML file your AI writes, on Convika | Yours, rewritten as JavaScript | They can read them in the page source; only you can change them | The phone's browser, from a link | A new version at the same link |
Pick by what matters most. Southwire's calculator is ready now and needs no sheet, but it's Southwire's method and tables, not yours. Appizy keeps the workbook as the engine and keeps the formulas on its servers. Calcapp has you rebuild the logic in its own designer. The HTML route keeps your tables and your formulas, costs nothing to try, and puts the math in the page itself, so anyone who opens it can read it: put a markup or a client's numbers behind a password, or leave them out.
Publish the calculator for your crew in 5 steps
1. Put the file in your account
Sign up at app.convika.com with no credit card, click Upload an HTML file, drop the .html file the AI gave you (up to 2 MB), and click Create my preview. The box below works without an account, but its preview turns scripts off, so the buttons won't calculate there. Click Keep this page — free, no card under it to move the file into an account, where the preview runs scripts.
2. Run the test cases on the preview
Open the preview on your own phone, run the test table, and compare each result with the sheet. Then try the phone itself: the number pad comes up, the units are readable, and the result sits where a thumb can reach it. If something is off, send the AI the case that failed with both answers, and upload the corrected file as a new version.
3. Choose who can open it and publish
Click Publish page. Under Who can open this page?, pick one:
- Public: "Anyone with the link can open it. It may show up in search results and in Convika's gallery." Free, with the Convika bar. The first time, click Publish free.
- Private link (Pro): "Anyone with the link can open it, with no password or account. It stays out of search results and out of the gallery." A forwarded link opens it too: it keeps the page out of search results, not out of reach.
- Only people with the password (Pro): Convika's server checks the password before it sends the page, so the formulas and tables stay out of reach until it's entered. Read how a page password works.
A private link or a password opens an order for Pro monthly: free for 1 day with a card, then $12 a month. Pro also has 3 members in a workspace.
4. Send the link
Send the live address in your crew's group chat or by email, or print its QR code for the site office. Each electrician can add it to the home screen so it opens like an app. It opens from its link, so the phone needs a connection to load it; Convika doesn't make a page work offline.
5. Publish each new version at the same link
When the sheet changes (a new table edition, an aluminum column, a fire alarm tab), have the AI change the file, run the test cases again, and upload it on the page's screen with Upload a new version. Click Publish v2 at the same link (with your number). Everyone with the link gets the new version, and the old one stays in the page's history in case you need to go back. Keep one address per tool and put the version number in the page, as the prompt asks. Updating a page without changing its link walks through it.
A new Free workspace keeps 1 live page at a time. A second tool, such as a duct sizing calculator, is a different page: Light, an add-on to Free, keeps up to 5 live pages for $3 a month through Publish this page too, with Light, and Pro keeps 100. Each page has its own visitor stats, so you can see whether the crew opens it.
Frequently asked questions
What is the voltage drop formula in an Excel sheet?
For single-phase or DC, =2*I*R*L/1000, with R in ohms per 1,000 ft from NEC Chapter 9 Table 8 and L the one-way length in feet. For three-phase, replace 2 with 1.732. In circular mils, =2*K*I*L/CM, with K = 12.9 for copper and 21.2 for aluminum. Divide by the voltage and multiply by 100 for the percent.
Can ChatGPT turn my voltage drop spreadsheet into a calculator for my phone?
Yes. Paste the inputs, formulas, and conductor table, and ask for one HTML file with plain JavaScript and the table inside, as in the prompt above. Then run the same test cases in the sheet and in the page before anyone uses it, and put the file at a link the crew opens in their browser.
Is the 3% voltage drop rule in the NEC mandatory?
No. The 3% branch-circuit and 5% total figures are informational notes to 210.19(A) and 215.2(A), and informational notes "are not mandatory Code requirements" (90.5(C)). Equipment instructions under 110.3(B), the mandatory limits in sections such as 647.4(D), a local amendment, or the job's specification can still bind you.
What K value do I use for copper and aluminum?
K = 12.9 for copper and 21.2 for aluminum, at 75 °C. Each is a conductor's resistance per 1,000 ft times its circular mils; across Table 8 from 14 AWG to 4/0, copper ranges from 12.84 to 12.93 and aluminum from 21.13 to 21.25. For AC conductors of 2/0 and larger, adjust by Table 9's AC resistance.
How do I calculate DC voltage drop for a 12 V or 24 V system?
Use VD = 2 × I × R × L with R per meter or per foot of one conductor and L the one-way length. 10 A over 10 m of 4 mm² copper drops 0.92 V, which is 7.7% of 12 V. Low voltages need larger conductors, so give the calculator a size search, not only a single answer.
How do I do a fire alarm voltage drop calculation?
Start from the panel's voltage on a depleted battery (20.4 V is the typical figure for a 24 V panel in HCAI's PIN 63), subtract the drop to each appliance, and check it against the appliance's listed minimum (typically 16.0 V). Calculating appliance by appliance gives a smaller drop than putting all the current at the end of the line.
Why doesn't my calculator match Southwire's or my old sheet?
Usually the inputs differ, not the math: K = 12.9 against Table 8 or Table 9 resistances, DC resistance against AC with reactance, 75 °C against another temperature, or wire length against one-way length. Line up those four first, then compare.
Can I stop electricians from seeing the formulas or the table?
Not inside the page: a calculator that runs in the browser carries its formulas and tables to the phone, and anyone can read the page source. You can choose who opens it: on Pro, Only people with the password keeps the page behind a password that Convika's server checks. If the formulas themselves must stay secret, a server-side tool such as Appizy runs them away from the browser.
Sources
- Code Calculations (Mike Holt, EC&M, February 1, 2000, based on the 1999 NEC), read on November 6, 2026
- Voltage Drop Limitations on Branch Circuits (Mike Holt, EC&M, May 5, 2015), read on November 6, 2026
- Voltage Drop Calculations (IAEI Magazine, September/October 2019), read on November 6, 2026
- NEC Chapter 9, Table 8, Conductor Properties (copy posted by NECA-IBEW Electricians), read on November 6, 2026
- Voltage Drop Calculations, course E426, tables (David A. Snyder, PE, PDHonline) and course text, read on November 6, 2026
- Free access to NFPA codes and standards (NFPA), read on November 6, 2026
- Maximum voltage drop limit (Schneider Electric, Electrical Installation Guide, chapter G), read on November 6, 2026
- Calculation of voltage drop in steady load conditions (Schneider Electric, Electrical Installation Guide, chapter G), read on November 6, 2026
- IEC 60228:2004 conductor tables (Cembre general catalogue, page 204) and page 205, read on November 6, 2026
- Copper Wire Tables, NBS Handbook 100 (National Bureau of Standards, 1966), read on November 6, 2026
- PIN 63, Fire Alarm Voltage Drop and Testing (HCAI, effective April 28, 2016), read on November 6, 2026
- Exceder ceiling horn strobe installation sheet, P85066C (Cooper Wheelock, 2012; copy posted by a distributor), read on November 6, 2026
- MATCH function and XLOOKUP function (Microsoft Support), read on November 6, 2026
- Differences between Office Scripts and VBA macros (Microsoft Learn, last updated April 11, 2023), read on November 6, 2026
- Calculate Your Voltage Drop (Southwire), read on November 6, 2026
- Calcapp and Appizy, Excel to App Converter, read on November 6, 2026
Next step
How to check that an AI-made calculator matches your Excel sheet
Run the same input sets through Excel and the AI's page, compare to a stated tolerance, and find the places where Excel and JavaScript round differently.
Related articles
- Turn an HVAC duct sizing spreadsheet into a phone calculatorEqual friction duct sizing with Darcy-Weisbach, Colebrook or Altshul-Tsal, Huebscher's rectangle, a solver for Goal Seek, SI and IP tests, and the AI prompt.
- Turn an Excel calculator into a web app your team opens on a phoneHave ChatGPT, Claude, or Gemini rewrite your sheet's formulas as one HTML file, test it against Excel, and share a link. Or keep the sheet as the engine.
- What should I check on an AI-made page before I share the link?AI-made pages fail where you don't look: a form that sends nowhere, a dead button, a made-up fact. A 5-step check on a phone, and a prompt for it.
- How to password protect an HTML page without code, on your own domainJavaScript passwords sit in the page code. Put an HTML page from ChatGPT or Claude behind a server-checked password on your own domain.
- How to share an HTML file as a link that opens on any phoneUpload the file to a host and send its link; email and Google Drive send the code. 8 hosts compared, from Netlify Drop to Convika, with 4 steps.
More calculators built from Excel sheets
AI Skill Pod
Share AI skills with your team, the easy way
Everyone uses your team's skills in their own ChatGPT, Claude or Gemini, on any plan. Send one invite link. Free to start.
Start free on AI Skill Pod