← Busbar Calculator☰ Menu

Electrical Panel Busbar Cost Calculator

Import the busbar list straight from EPLAN, subtract cutting waste and offcuts, and see what the copper in your panel really costs — at live market prices. Your file is parsed in the browser and never uploaded.

  1. 1Import
  2. 2Map
  3. 3Review
  4. 4Results

Export your copper parts list from EPLAN and drop it here — it never leaves your device.

File guide — a perfect import, every time

Pick the format you have. Each one shows exactly how to get it out of EPLAN and what it must contain.

CSV / TXTEPLAN’s standard text export

Get it from EPLAN: Utilities → Reports → Copper / busbar parts list → output as file → CSV (semicolon).

  • Semicolon ; comma , or tab — detected automatically
  • UTF-8 and UTF-16 encodings both open correctly
  • German 1.250,5 and English 1250.5 decimals both work
  • A missing header row is fine — you map the columns manually
Menge;Bezeichnung;Breite;Höhe;Länge
4;Sammelschiene L1;40;10;1.250,5
2;Abgang Q1;30;5;445,25
XLSXExcel workbook

Get it from EPLAN: export the parts list as Excel, or open any export in Excel and save as .xlsx.

  • The first worksheet is read; the first row becomes the headers
  • Formulas are fine — their calculated values are used
  • Legacy .xls (pre-2007) is not supported — re-save as .xlsx or CSV
PasteCopy rows straight from Excel / EPLAN

Select the table in Excel or the EPLAN preview, copy, switch to Paste from Excel/EPLAN above and paste. Include the header row if you have one — mapping gets guessed for you.

The columns we need

Quantity *Menge · Stück · Anzahl · Qty
4
Length *Länge [mm] · Zuschnittslänge · Length
1.250,5
WidthBreite · Schienenbreite · Width
40
ThicknessHöhe · Dicke · Materialdicke · Thickness
10
…or one combined columnQuerschnitt · Cross-section · Profil
40x10

* required · Width + Thickness can be replaced by the combined column · anything unreadable is flagged with its exact line number and a fix — nothing is dropped silently.

How to export from EPLAN

EPLAN Pro Panel: Utilities → Reports → Copper parts list → output as file → choose CSV (semicolon). EPLAN Electric P8: export the busbar BOM via Utilities → Reports → Generate → Parts list, then save/export the table as CSV. Columns like Menge / Breite / Höhe / Länge are detected automatically.

From EPLAN parts list to a priced panel in one minute

EPLAN Pro Panel and Electric P8 export the busbar bill of materials with German or English headers — Menge, Breite, Höhe, Länge or Quantity, Width, Thickness, Length. This tool reads either, groups the pieces by cross-section and packs them into stock bars to find the real offcut scrap.

Waste is where panel budgets die

Every saw cut eats a kerf (estimated at 1.5% of the blade diameter, never below 0.5 mm), every punched hole removes a slug, and every stock bar leaves an unusable end. All three are computed separately, weighed with the exact alloy density and priced — so quotes include the metal you buy, not just the metal you ship. Also try the single-cut waste calculator and the live busbar price calculator.