What Do I Upload? The Excel Template That FrameAI Reads
FrameAI accepts electrical panel load data as Excel (.xlsx) or CSV. The upload feeds the automated load analysis engine: demand factors, cable sizing checks, fault level calculations, and board schedule generation. The file must follow the column structure below. FrameAI validates the format on upload and reports any missing required columns immediately — so you know before you submit.
These columns must be present with exact names. FrameAI will reject uploads missing any of these.
| Column | Description |
|---|---|
| REQ panel_name | Name of the panel or distribution board (e.g. MDB-01, DB-A). Used to group circuits. |
| REQ circuit | Circuit identifier within the panel (e.g. C01, C1, L1). Unique per panel. |
| REQ load_type | Type of load — Lighting, Socket Outlet, HVAC, Motor, Boiler, Pump, Other. |
| REQ watts | Connected load in watts (W). Use the nameplate rating. |
| REQ voltage | Nominal voltage in volts (V). Typically 230 V (single-phase) or 400 V (three-phase). |
These columns enhance the analysis. FrameAI uses them when present and falls back to defaults when absent.
| Column | Description |
|---|---|
| OPT phase | Phase count: 1 (single-phase) or 3 (three-phase). Default: 1. |
| OPT power_factor | Power factor (0–1). Used for three-phase apparent power. Default: 0.9. |
| OPT demand_factor | Diversity/demand factor (0–1). Applied to connected load for billing design. Default: 1.0. |
| OPT length_m | Cable length in metres. Used for voltage drop calculation. |
| OPT cable_size_mm2 | Proposed or existing cable cross-section in mm². FrameAI checks against BS 7671 limits. |
| OPT notes | Free-text notes — location, equipment description, engineer initials. |
Here is what a correctly-formatted upload looks like. Four circuits from a Main Distribution Board.
| panel_name | circuit | load_type | watts | voltage | phase | power_factor | demand_factor | length_m | cable_size_mm2 | notes |
|---|---|---|---|---|---|---|---|---|---|---|
| MDB-01 | C01 | Lighting | 2400 | 230 | 1 | 0.9 | 1.0 | 15 | 2.5 | LED office lighting |
| MDB-01 | C02 | Socket Outlet | 3600 | 230 | 1 | 0.85 | 0.8 | 22 | 2.5 | General receptacles |
| MDB-01 | C03 | HVAC | 12000 | 400 | 3 | 0.8 | 1.0 | 8 | 6 | Split AC unit 12 kW |
| MDB-01 | C04 | Motor | 7500 | 400 | 3 | 0.75 | 0.9 | 30 | 10 | Elevator motor |
Pre-formatted .xlsx with the correct column headers and 4 sample rows. Open in Excel, replace with your panel data, and upload.
Pre-formatted .xlsx with correct column headers and 4 sample rows from a typical MDB.
Drag your Excel file here, or click to browse. FrameAI will validate the format and show you which columns it found.
Drop .xlsx or .csv here — or click to browse
.xlsx · .xls · .csv
Upload your Excel file and get panel load analysis in under 2 minutes.