Convika

Още не е на български, затова е на английски.

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.

A working example: change any value. It computes in your browser and sends nothing.

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.

Say what yours needs: your voltages, copper or aluminum, your conduit, your limit, your company's name. Up to 8,000 characters.

You don't need an account to try it. The preview works for 3 minutes once it's ready.

On this page

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.

CircuitVolts droppedUnitsUse it whenSource
Single-phase, 2 wires, or DCVD = 2 × I × R × LI 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 1Mike Holt, EC&M; IAEI
Three-phase, balancedVD = √3 × I × R × Las above; VD line to lineSame as aboveMike Holt, EC&M; IAEI
Any AC circuit, with reactanceVD = 2 (or √3) × I × (R cos φ + X sin φ) × LX in Ω per length; cos φ the load's power factorLarger conductors, motors, steel conduitNEC Chapter 9 Table 9 Note 2; Schneider Electric's guide
Circular-mil formVD = 2 (or 1.732) × K × I × L / CMK in Ω·cmil/ft; L one-way in ft; CM the conductor's area in circular milsAC up to 1/0, or DC; 75 °C conductorsMike Holt, EC&M; IAEI
PercentVD% = 100 × VD / VV the circuit's nominal voltage, line to line for three-phaseEvery 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 installationLighting circuitsOther uses (heating and power)
Low voltage installations supplied directly from a public low voltage distribution system3%5%
Low voltage installation supplied from private LV supply6%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, copperK, aluminum
144,1103.145.1712.9121.25
126,5301.983.2512.9321.22
1010,3801.242.0412.8721.18
816,5100.7781.2812.8421.13
626,2400.4910.80812.8821.20
441,7400.3080.50812.8621.20
352,6200.2450.40312.8921.21
266,3600.1940.31912.8721.17
183,6900.1540.25312.8921.17
1/0105,6000.1220.20112.8821.23
2/0133,1000.09670.15912.8721.16
3/0167,8000.07660.12612.8521.14
4/0211,6000.06080.10012.8721.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.512.113.3—
2.57.417.98—
44.614.95—
63.083.30—
101.831.913.08
161.151.211.91
250.7270.7801.20
350.5240.5540.868
500.3870.3860.641
700.2680.2720.443
950.1930.2060.320
1200.1530.1610.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.

CaseFormulaResult herePublished
12 AWG Cu, 16 A, 100 ft, 120 V, single-phase2 × I × R × L, R = 1.986.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-phase2 × K × I × L / CM6.92 V, 2.88%6.9 V, 2.9% (Holt)
1 AWG Al, 100 A, 80 ft, 208 V, three-phase1.732 × K × I × L / CM3.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 φ) × L8.418 V, 1.75%8.418 V, 1.753% (PDHonline)
10 AWG, 10 A, 100 ft, 120 V, single-phase, PF 0.92 × I × (R cos φ + X sin φ) × L, R 1.2, X 0.0632.215 V, 1.85%2.215 V, 1.845% (PDHonline)
2.5 mm² Cu, 20 A, 20 m, 230 V, lighting, cos φ 12 × I × R × L, R = 23.7 / 2.57.58 V7.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.085.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 fromInputsExpected dropExpected percent
1US, tableSingle-phase 120 V, 12 AWG copper, 16 A, 100 ft, PF 1; at 75 °C, then at 90 °C6.34 V; 6.64 V at 90 °C5.28%; 5.54%
2US, KSingle-phase 240 V, 6 AWG copper (26,240 cmil), 44 A, 160 ft6.92 V2.88%
3US, KThree-phase 208 V, 1 AWG aluminum (83,690 cmil), 100 A, 80 ft3.51 V1.69%
4US, enteredThree-phase 480 V, R 2.0, X 0.068 Ω per 1,000 ft, PF 0.85, 14 A, 200 ft8.42 V1.75%
5Metric, enteredSingle-phase 230 V, R 9.48, X 0 Ω/km, 20 A, 20 m7.58 V3.30%
6Metric, enteredThree-phase 400 V, R 0.677, X 0.08 Ω/km, PF 0.8, 100 A, 50 m5.11 V1.28%
7Metric, tableDC 12 V, 4 mm² copper, class 1 (4.61 Ω/km), 10 A, 10 m, at 20 °C0.92 V7.68%
8US, tableSize search: single-phase 240 V, copper, 75 °C, 44 A, 160 ft, 3% allowed6 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.

OptionWhose formulas and tablesCan the people who use it see or change your formulas?Where it runsUpdating it
The workbook in Excel on the phoneYoursYes: whoever has the file has the formulasExcel for iOS runs no VBA macros (Microsoft's platform table)Send the file again
Southwire's voltage drop calculator, web and appSouthwire's: "designed for applications using AWG and KCMIL sizes only"Not your formulasSouthwire's site, Android and iOS appsSouthwire's
CalcappYours, 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
AppizyYours: you upload the Excel fileThey 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 ConvikaYours, rewritten as JavaScriptThey can read them in the page source; only you can change themThe phone's browser, from a linkA 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.

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.

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

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

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⁠

AI Skill Pod is made by the team behind Convika.

Share this article

Put your voltage drop sheet on your crew's phones

Say what your crew's version needs: your voltages, your conductors and conduit, your limit. The AI rewrites the calculator above, you run your test cases on your phone, then keep it with a free account and send one link.

Make my team's version

Free plan: no credit card. A private link or a password comes with Pro, $12 a month.