Electrical Panel Quotation System v7

⚡

Electrical Panel Quotation System

Elektrik Pano Teklif Sistemi v7

DB: Not Loaded

No Project

🗄️ Data Source / Veri Kaynağı

Connect Google Sheets as Database ⏳ Not Connected

ℹ️Connect Google Sheets or load an Excel file to get started.

🏢 Manufacturer Info (Static)

Company Name / Firma Adı

Logo (URL)

🏭

Phone

Website

Address

📝 Project Info

Project Name / Proje Adı

Client / Müşteri

Offer No / Teklif No

Date / Tarih

Validity (days)

KDV %

Profit Margin %

Markup Effect (example)

Delivery Terms

Project Notes

✍️ Signatory Names

Offer Preparer / Teklifi Hazırlayan

Approver / Onaylayan

⚙️ Discount Rates / İskonto Oranları

⚙️

Load data first

🔲 Electrical Panels / Panolar

🔲

No panels.
Click Add Panel to start.

Your Company Name

Client: —

Project: —

Offer No: —

Date: —

Validity: 2 day(s)

#	Panel Name / Pano Adı	Dimensions (mm)	Type	Qty	Unit Price (USD)	Total (USD)

📤 Export Project

ℹ️All prices in USD. Make sure to save the project first.

📋

Project File (.json)

Full save — can be opened and edited on any device

📊

Full Excel

Quotation + costs + sheet metal, copper and component details

🏭

Order Lists

Separate table per brand with quantity totals

📥 Import Project

⚠️Importing will replace the current project data. Save first.

📌 Excel import templates inside the panel window: Column A = Code | Column B = Qty | Column C = Optional description | First row = headers

🗄️ Materials Database (Sayfa2)

🗄️

Load data from Google Sheets or Excel

📁 Archive

📁

No saved projects.

🗂️ Project Index & Archive

🗂️

No project indexes yet.
Click New Project Index to create one.

Basic Information

Panel Name * / Pano Adı

Description / Açıklama

Panel Type / Pano Tipi

Quantity / Adet

Dimensions / Boyutlar (mm)

For multi-section panels: 600+800+1000

Width / Genişlik

Height / Yükseklik (mm)

Depth / Derinlik (mm)

Operation Level (multiplied by area)

Labor Level / İşçilik

Consumables Level / Sarf

🟩 Sheet Metal Parts / Sac Malzeme

📌 Front door, side panel, mounting platform, frames, espagnolette... Prices taken directly from Sayfa2.

📄 Format: Column A = Code | Column B = Qty | First row = headers

Brand	Code	Description	Qty	Unit	List Price	Disc%	Unit Price	Total
No sheet metal parts yet

➕ Add sheet metal part manually

🟩 Sheet Metal Parts Total: 0.00 USD

🔶 Copper / Bakır Malzeme

📌 Busbars, copper bars, connectors, lugs... Prices taken directly from Sayfa2.

📄 Format: Column A = Code | Column B = Qty(cm) | First row = headers

Brand	Code	Description	Qty	Unit(cm)	List Price	Disc%	Unit Price	Total
No copper parts yet

➕ Add copper part manually

🔶 Copper Parts Total: 0.00 USD

Cost Summary

0.00

Area (m²)

Sheet Metal USD

Copper USD

Labor USD

Consumables USD

Shell Total

Components

Panel Costs

Additional Costs

Panel Total USD

Formula: Shell = Sheet Metal + Copper + Labor + Consumables | Panel Costs = Shell + Components | Additional Costs = Costs × Markup% | Total = Costs + Additional

⚡ Electrical Components / Şalt Malzeme

📄 Format: Column A = Code | Column B = Qty | Column C = Optional description | First row = headers

Brand	Code	Description	Qty	Unit	List Price	Disc%	Unit Price	Total
No components — search above or import from Excel

➕ Add component manually

⚡ Components Cost: 0.00 USD 🔲 Panel Total: 0.00 USD