Overview
Cables (XLS) writes every cable of the design to one Excel workbook: string cables, DC box to inverter cables and inverter to transformer cables, with their lengths, sizes and voltage drop. Use it for the bill of quantities, procurement and the electrical review.
Prerequisites
Cabling generated. See DC and AC Cabling.
Step-by-Step Guide
1. Start the export
On the PVX.AI ribbon, open the Export menu and click Cables (XLS).
2. Save the file
Choose a file name and folder. Close the file in Excel first if you are overwriting an earlier export.
3. Read the sheets
- DC Cables: one row per string with its transformer, inverter, DC combiner, the + and – cable lengths and their total, cable size, voltage drop in volts and percent, and the group color.
- DCB-Inverter Cables: one row per DC box with its cable length, size and voltage drop. Only present on designs with DC boxes.
- AC Cables: one row per inverter with its AC cable length to the transformer, size and voltage drop.
4. Multi-area sites and feet drawings
On a drawing with two or more PV areas, each sheet is written once per area: DC Cables (PV-1), DC Cables (PV-2), AC Cables (PV-1) and so on. Cables that belong to no PV area go to a separate “no area” sheet, so nothing is dropped. A single-area drawing keeps the plain sheet names. On a drawing in feet, lengths are in feet and an AWG (approx) column sits next to each mm² size.
Tips & Recommendations
- Sum the total length per cable size to get quantities for the BoQ.
- N/A in the size column means no size met both the ampacity and the voltage-drop target. Check that cable’s length and the settings in Voltage Drop in Cabling.
- Export again after moving devices or regenerating cabling; the file is a snapshot of the drawing at export time.
- The same tables can be drawn into the drawing with Information > Cable Information Table.
