Solar bill of quantities calculator: cable and pile rollup

Enter a ground-mount layout and your wastage. It returns net quantities by section and the quantity with wastage for piles and cable.

Assumed inputs only. Every value is a placeholder you replace, not a design or an industry figure. The model has one straight row of tables per inverter and an inverter at the row end. It does not check spans, voltage drop, cable size or soil. It holds no prices.
Examples:

Array (assumed)

Cable and trench (assumed)

Wastage (yours)

RefItemUnitNet quantityWastageWith wastage

Quantity with wastage = net quantity x (1 + wastage), rounded up to a whole unit. Lines with no wastage show the net quantity. DC cable counts single conductors. Do not add DC and AC cable together: they are different cable types.