Structured Cabling BoQ & Cable Quantity Estimator (Excel)

This Excel workbook estimates typical horizontal structured-cabling quantities and prices them on a linked bill of quantities. It is intended for ELV / SCS designers and estimators who need a clear, formula-driven take-off before a measured route survey is finished.

On the Inputs sheet you enter project details and assumptions: floors, outlets per floor, average run length, slack percentage, box or drum length (default 305 m), rack count, patch-panel size (24 or 48 ports), modules per outlet, spare panel capacity and patch cords per outlet. An optional floor-by-floor table overrides the simple floors × outlets model when counts or run lengths differ by level.

The Estimator calculates total outlets, raw and slack-adjusted cable length, cable boxes (using ROUNDUP so a part-used box still counts as one), faceplates, keystones, patch panels, patch cords, cable managers and racks. The BoQ sheet links those quantities, lets you type unit rates, and calculates line amounts, category subtotals, contingency, tax and a grand total. Spare rows are provided for site-specific items.

Yellow cells are inputs; blue cells are formulas. No macros. Works in Microsoft Excel, LibreOffice Calc, Google Sheets and WPS. Sample quantities and rates for a four-floor office example are placeholders only and are not price advice. The workbook does not design cable routes or certify link lengths. Confirm box counts, pathway, testing and products against local codes and manufacturer specifications.

Prepared by Chen Yu, an ELV / intelligent-building engineer with 25+ years of design, BoQ and tendering experience.