Skip to content
SHEET T1TemplatesELV BOQ

A free ELV BOQ template, laid out by floor.

CCTV, access control and structured cabling counted floor by floor in the layout main contractors ask for, the rules that turn devices into switches and cable boxes, and a BOQ priced in AED. One Excel workbook with the formulas in it. No sign-up.

.xlsx · 6 sheets · sample figures included · version 1.0, November 2026

Six sheets, in the order you fill them.

Blue cells on yellow are yours to type in. Black cells are worked out by formula, green cells are brought from another sheet. Every derived quantity traces back to one cell on Rules.

Read meRulesCCTV by floorAccess control by floorData by floorBOQ
SheetWhat it holdsYou type
Read meHow to fill it, what the cell colours mean, what the formulas do, and what they leave to you.Nothing
RulesThe project, the floors and how many floors each typical drawing covers, and every assumption the formulas use: route lengths, cable route slack, drops and loops, the 90 m permanent link, the 305 m box, waste, spare ports, ports per switch and per patch panel, organisers, ports per door controller, points per floor box, currency and VAT.Floors and values
CCTV by floorTen camera types across, floors down. Per floor: cameras, door controller ports, switch ports with spare, PoE switches, cable runs, patch panels, organisers and cable metres. Below: cable boxes and the 90 m check.Counts
Access control by floorCard readers, face recognition readers, door contacts, locks, exit buttons, break glasses and door controllers. Each controller’s network port is added to the security switch ports on the CCTV sheet.Counts
Data by floorSingle, dual, voice and data and quad outlets, floor boxes and access points, with the data points each takes. Per floor: points, ports with spare, data switches, runs, panels, organisers and cable.Counts, points each
BOQItem, description, unit, quantity by formula, rate and amount, in four sections with subtotals, totals excluding and including VAT, and a count of the lines with a quantity and no rate.Rates

Floors down the side, device types across, the working beside them.

A typical floor is counted once and multiplied by Floors covered in every total, so the sum is on the sheet instead of an unexplained figure. To the right of the counts, each floor’s switch ports, switches, patch panels and cable are worked out from Rules.

CCTV by floor · the template’s sample figures · some columns left out
FloorFloors coveredDome, obs.Dome, IDBullet IP66PTZOther typesCamerasPorts with sparePoE switchesPatch panelsCable (m)
Basement 1 (car park)11820022228211,035
Ground floor11046232533221,215
Level 01181001101411495
Level 02 to 08 (typical)76100071011360
Roof1002002411135
Site and external works1004127911315
Total, floors covered applied115·14135,715

Worked through for the typical floor: 7 cameras and 1 door controller make 8 ports; 8 × 1.2 = 9.6, so 10 with spare; 10 / 24, rounded up, is 1 PoE switch; 8 runs of 45.0 m (35 × 1.1 + 6.5) make 360 m. Seven floors: 7 switches and 2,520 m. Below each sheet, the cable becomes boxes: the larger of whole runs per box and total length plus waste.

Every assumption in one place, each one named.

The derived lines of an ELV bill are decided by a dozen numbers that are habits, not standards. The template writes them down, so two estimators pricing the same drawings get the same bill, and a reviewer can see why. The only hard number is the 90 m permanent link, from TIA-568 and ISO/IEC 11801.

Why these defaults: ELV estimating rules for GCC contractors.

RuleDefaultDrives
Average route on plan, security and data35 m, 30 mRun length
Cable route slack10%Run length: route × (1 + slack)
Vertical drop and service loops, per run6.5 mRun length, added once per run
Maximum permanent link90 mThe run length check on every sheet
Cable box length305 mWhole runs per box, boxes to order
Waste on total length10%Boxes by total length plus waste
Spare ports20%Ports with spare, per floor
Ports per switch, security (PoE) and data24, 48Switches per floor
Ports per patch panel24Patch panels per floor, from cable runs
Cable organisers per patch panel1Organisers per floor
Network ports per door controller1Security switch ports
Data points per floor box2Data points per floor

Seven steps, from the drawing register to a priced total.

Clear the sample figures first: they describe an illustrative building, not a project. The counting method for cameras is in CCTV take-off from drawings, and for doors in the access control take-off.

  1. 01

    Register the drawings

    List every floor layout for each system with its revision. Set the riser and the schematics aside as reference: you check the count against them, you do not count from them.

  2. 02

    Set the floors on Rules

    Name each floor, and for a typical floor drawing set Floors covered to the number of identical floors it stands for. Then check every rule against the specification and your firm’s standard.

  3. 03

    Rename the columns to the legend

    Give each device column the consultant’s type, and keep each performance class as its own column. The BOQ line takes its description from the column heading.

  4. 04

    Count one type at a time, one floor per row

    Leave out the legend panel and the coverage wedges. On access control, count each part at the door, not the door.

  5. 05

    Check against the printed totals

    Where the drawings or the schedule print a total, type it in the Printed row. The Difference row shows what to query before you price.

  6. 06

    Read the run length check

    The check passes on the average run. Measure the farthest device on each floor as well: a run over 90 m needs a nearer rack or a consolidation point.

  7. 07

    Price the BOQ

    Type a rate in each blue cell, fill the lines left to you (recorder and storage, UPS, racks, backbone, access control field cabling), and check that Lines with a quantity and no rate reads 0.

The same BOQ, with the counts read from the drawings and checked.

A template is only as good as the counts typed into it, and nobody can see who checked them. This is where TrueQty does each part of the job instead. Press R to see what each line was checked against.

The jobIn this templateIn TrueQty
The countsTyped in by hand, floor by floor.Read from the tender drawings by device type and floor. A floor layout is counted; a riser or a schematic is kept for reference.
Who checked themWhoever typed them.A person checks every device type, each device ringed where it was drawn, and a team lead approves the drawing before anything is priced.
Where a number came fromA drawing number on each row.Click a number in BOQ by floor and the drawings behind it are listed, each opening with only those devices shown.
Typical floorsFloors covered, typed on Rules.Marked on the drawing with the floors it covers, and multiplied only once a team lead approves it.
The by-floor layoutThe six sheets above.BOQ by floor, in the column wording main contractors use, exported to Excel with live totals and a sheet of the source drawings.
The rulesFormulas on this file.Your firm’s rules, changed for one project where its specification differs, kept with every BOQ version, with how each line was worked out shown under it. A run over 90 m is flagged.
PricesRates typed in.A price request for your suppliers, read back from their quotes, or a match from saved price lists to the cheapest vendor who stocks the line, in date.
The client’s copyHide the cost columns yourself.A markup on the BOQ or a line; the client’s Excel at sell price with no cost or vendor in it; the proposal at sell, as a PDF and an editable Word file.

About the template.

What is an ELV BOQ template?

A spreadsheet that turns ELV device counts into a bill of quantities: a line for each device type, the cable and network lines those devices imply, and a priced total. This one is laid out by floor, the way GCC main contractors ask for it, with the rules behind the derived lines written as formulas.

Is the template free to use on commercial tenders?

Yes. Download it, change it and use it on any project, with no sign-up. It carries no warranty: check every quantity before you price it.

Does it open in Google Sheets or LibreOffice?

It is made for Excel and uses only common functions (SUM, SUMPRODUCT, ROUNDUP, ROUND, IF) and named cells, which Google Sheets and LibreOffice also read. After importing, check one total against the sample before you rely on it.

How does the template work out switches and patch panels?

Per floor. Switch ports are the cameras and door controllers on the security network, and the data points on the data network. Ports with spare are the ports times one plus the spare percentage, rounded up; switches are the ports with spare divided by the ports per switch, rounded up. Patch panels are the cable runs divided by the ports per panel, rounded up.

How many 305 m cable boxes does it order?

The larger of two figures: the runs divided by the whole runs that fit in one box, rounded up, and the total length plus waste divided by the box length, rounded up. A horizontal run cannot be spliced from two boxes, so the whole-runs figure usually governs.

Can I add floors or device types?

Six spare floor rows are ready on Rules: name one to use it. Rename any device column to the consultant's type, including the Other column. A column inserted inside a device range is included in that sheet's totals, but needs its own BOQ line.

Does the template size the PoE budget, recorders or the UPS?

No. Those depend on the specification and the equipment chosen, so the BOQ has a line for each to fill in. Check each switch's PoE budget against its data sheet, and in Dubai size recording, storage and the UPS to SIRA's requirements.

Or let the drawings fill it.

Upload one floor layout from a tender you are pricing now, check what TrueQty counted, and read the BOQ by floor that comes out of it, every line with its working.

Priced in AED on tenders and seats, every ELV discipline included. See the plans.

Start free trialBring a real drawing. 14 days free, no card.Download the template