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.
| Sheet | What it holds | You type |
|---|---|---|
| Read me | How to fill it, what the cell colours mean, what the formulas do, and what they leave to you. | Nothing |
| Rules | The 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 floor | Ten 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 floor | Card 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 floor | Single, 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 |
| BOQ | Item, 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.
| Floor | Floors covered | Dome, obs. | Dome, ID | Bullet IP66 | PTZ | Other types | Cameras | Ports with spare | PoE switches | Patch panels | Cable (m) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Basement 1 (car park) | 1 | 18 | 2 | 0 | 0 | 2 | 22 | 28 | 2 | 1 | 1,035 |
| Ground floor | 1 | 10 | 4 | 6 | 2 | 3 | 25 | 33 | 2 | 2 | 1,215 |
| Level 01 | 1 | 8 | 1 | 0 | 0 | 1 | 10 | 14 | 1 | 1 | 495 |
| Level 02 to 08 (typical) | 7 | 6 | 1 | 0 | 0 | 0 | 7 | 10 | 1 | 1 | 360 |
| Roof | 1 | 0 | 0 | 2 | 0 | 0 | 2 | 4 | 1 | 1 | 135 |
| Site and external works | 1 | 0 | 0 | 4 | 1 | 2 | 7 | 9 | 1 | 1 | 315 |
| Total, floors covered applied | 115 | · | 14 | 13 | 5,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.
| Rule | Default | Drives |
|---|---|---|
| Average route on plan, security and data | 35 m, 30 m | Run length |
| Cable route slack | 10% | Run length: route × (1 + slack) |
| Vertical drop and service loops, per run | 6.5 m | Run length, added once per run |
| Maximum permanent link | 90 m | The run length check on every sheet |
| Cable box length | 305 m | Whole runs per box, boxes to order |
| Waste on total length | 10% | Boxes by total length plus waste |
| Spare ports | 20% | Ports with spare, per floor |
| Ports per switch, security (PoE) and data | 24, 48 | Switches per floor |
| Ports per patch panel | 24 | Patch panels per floor, from cable runs |
| Cable organisers per patch panel | 1 | Organisers per floor |
| Network ports per door controller | 1 | Security switch ports |
| Data points per floor box | 2 | Data 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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 job | In this template | In TrueQty |
|---|---|---|
| The counts | Typed 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 them | Whoever 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 from | A 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 floors | Floors 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 layout | The 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 rules | Formulas 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. |
| Prices | Rates 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 copy | Hide 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.
- How to build an ELV BOQ from drawings: a worked example
- ELV estimating rules: standardise the BOQ assumptions
- How many PoE switches for CCTV: the calculation
- ELV cable calculation: the formula and a worked example
- Access control take-off: assembling the door
- ELV quantity take-off: the complete GCC guide
- CCTV take-off software for GCC tenders
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.
