Device count calculators that price the proposal
Cameras, sensors, readers and detectors counted per zone, cable runs worked out, and the monitoring tier chosen, in a Spreadsheet block whose cells set the price lines.
- 5/5 on G2
- 4.2 on Capterra
- Building QuoteCloud since 2013
In QuoteCloud your device count becomes a Spreadsheet block in the proposal template: counts per zone, cable runs and monitoring tiers with your own formulas and rates. Connect any cell to a price line's description and unit price, and bring a price table total back into a cell. Spreadsheet block: Essentials and up.
Last reviewed by the QuoteCloud team
A device-count spreadsheet for the fictional Penrose Cold Stores depot: five zones (office and reception, loading dock, cold rooms, warehouse floor, perimeter and yard) with counts of cameras, sensors, readers and detectors. One column at a time lights: its total (27 cameras, 12 sensors, 7 readers, 22 detectors), the same devices drawn on five engineered zone plinths, and the connected price line, for example 27 IP cameras, turret and dome at $11,340, its description from cell Zones!B9 and its unit price from Zones!B10, quantity 1. Last, the cable run of 1,920 metres through every zone sets the cabling line at $8,064 from Cable!D8 and D9.
Try it: change a count, and the proposal re-prices
Marcus's device count for Penrose Cold Stores, connected to the proposal's price table. Change any count and watch the connected lines, the cable run, the total and the deposit follow, then the total come back into the sheet.
Device count Spreadsheet block · Penrose device count.xlsx Demo · fictional data
Change any blue count. The connected lines, the total and the cell it comes back to follow.
| A · Zone | B · Cameras | C · Sensors | D · Readers | E · Detectors |
|---|---|---|---|---|
| Office & reception | ||||
| Loading dock | ||||
| Cold rooms (3) | ||||
| Warehouse floor | ||||
| Perimeter & yard | ||||
| Total devices | 27 | 12 | 7 | 22 |
| Unit price Rates tab | $420 | $85 | $640 | $96 |
| Line description | 27 IP cameras, turret & dome | 12 intruder sensors | 7 access-control readers | 22 smoke & heat detectors |
| Line unit price | $11,340 | $1,020 | $4,480 | $2,112 |
| Cable run, metres Cable!D6 | 1,920 m → $8,064 | |||
| Price per device = price table total ÷ B7:E7 | $633.32 ← Price table total | |||
- Counted on the survey
- Your rate
- Connected to a price line
System price what Leila and Dominic see
- 27 IP cameras, turret & dome Zones!B9 · B101$11,340.00
- 12 intruder sensors Zones!C9 · C101$1,020.00
- 7 access-control readers Zones!D9 · D101$4,480.00
- 22 smoke & heat detectors Zones!E9 · E101$2,112.00
- Cabling, 1,920 m installed Cable!D8 · D91$8,064.00
- 32-channel network video recorder, 30 days storageRack-mounted in the comms room1$3,200.00
- Intruder alarm panel & 3 keypadsOffice, dock and cold-room lobby1$1,850.00
- Installation, programming & commissioningTwo technicians, 8 days1$9,600.00
- Project management, as-built drawings & handoverIncluding user training1$1,400.00
Options tick to add
- Reads plates at the gate1$1,150.00
- 60 days in total1$780.00
- Subtotal
- $43,066.00
- Tax (10%)
- $4,306.60
- Total
- $47,372.60
- Deposit on signing (30%)
- $14,211.78
- Monitoring: alarm + video verification
- $129 a month, shown in the agreement
A demo with a fictional business. In QuoteCloud, the Spreadsheet block (Essentials and up) is a full spreadsheet: any cell can be connected to a price line's description and unit price, and a price table total can be brought back into a cell. Quantities stay on the price table: each connected line here is one lot.
Four tabs, one calculator, built once
Zones holds the survey counts; Cable works out the runs from the counts and your average run lengths; Monitoring picks the tier with XLOOKUP; Rates holds your supplied-and-fitted prices. Click any cell to see its formula.
Import your existing .xlsx to start, then connect the cells that set each line. Every proposal from the template is priced the same way, whoever builds it.
- Formulas, tabs and cross-tab references
- Import your .xlsx
- Your rates on their own tab
Spreadsheet block: Essentials and up
System design proposalsDevice count Spreadsheet block
=B7&" IP cameras, turret & dome"| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Zone | Cameras | Sensors | Readers | Detectors |
| 2 | Office & reception | 4 | 6 | 2 | 8 |
| 3 | Loading dock | 6 | 2 | 1 | 4 |
| 4 | Cold rooms (3) | 3 | 0 | 3 | 0 |
| 5 | Warehouse floor | 8 | 4 | 0 | 10 |
| 6 | Perimeter & yard | 6 | 0 | 1 | 0 |
| 7 | Total devices | 27 | 12 | 7 | 22 |
| 8 | Unit price, supplied & fitted | $420 | $85 | $640 | $96 |
| 9 | Line description | 27 IP cameras, turret & dome | 12 intruder sensors | 7 access-control readers | 22 smoke & heat detectors |
| 10 | Line unit price | $11,340 | $1,020 | $4,480 | $2,112 |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Run | Devices | Avg run (m) | Metres |
| 2 | Camera runs | 27 | 38 | 1,026 |
| 3 | Sensor runs | 12 | 22 | 264 |
| 4 | Reader & lock runs | 7 | 30 | 210 |
| 5 | Detection loop | 420 | ||
| 6 | Total metres | 1,920 | ||
| 7 | Rate per metre, installed | $4.20 | ||
| 8 | Line description | Cabling, 1,920 m installed | ||
| 9 | Line unit price | $8,064 |
| A | B | C | |
|---|---|---|---|
| 1 | Tier | Per month | Chosen |
| 2 | Monitored alarm | $69 | |
| 3 | Alarm + video verification | $129 | ✓ |
| 4 | Video verification + patrol response | $189 | |
| 5 | Line description | Monitoring: alarm + video verification | |
| 6 | Line monthly price | $129 |
| A | B | |
|---|---|---|
| 1 | Item | Supplied & fitted |
| 2 | IP camera, average | $420 |
| 3 | Intruder sensor | $85 |
| 4 | Door reader & lock | $640 |
| 5 | Smoke or heat detector | $96 |
| 6 | Cable per metre, installed | $4.20 |
- Counted on the survey
- Your rate
- Connected to a price line
The spreadsheet functions security designers use
A full spreadsheet inside the proposal, not a fixed calculator.
SUM
Devices per type across the zones.
Runs × metres
Cable metres from the counts and your average run lengths.
XLOOKUP
The monitoring tier's name and monthly price from a choice.
ROUND, ROUNDUP
Whole drums of cable, whole days of labour.
IF
A reader line only where a zone has controlled doors.
Several tabs
Zones, cable, monitoring and rates, referencing each other.
Connected cells
A cell sets a line's description and unit price.
Total back in
The price table total returns to a cell, such as price per device.
Bring your device count into QuoteCloud
Free for 14 days, no credit card required. Send us your current spreadsheet and proposal and we'll convert one template for you during the trial.
Cable runs priced from the count, not guessed
The Cable tab multiplies each device count by your average run length for that kind of device, adds the detection loop, and prices the metres at your installed rate. Cable!D8 writes "Cabling, 1,920 m installed" into the line and D9 its price.
Your survey counts can also arrive from a site form through Zapier, which can write values into spreadsheet cells. The designer checks them before the proposal goes out.
- Average runs as your own assumptions
- Cable!D8 → description, D9 → unit price
- Zapier can write survey counts into cells
Cable tab Spreadsheet block
=D6*D7| A | B | C | D | |
|---|---|---|---|---|
| 1 | Run | Devices | Avg run (m) | Metres |
| 2 | Camera runs | 27 | 38 | 1,026 |
| 3 | Sensor runs | 12 | 22 | 264 |
| 4 | Reader & lock runs | 7 | 30 | 210 |
| 5 | Detection loop | 420 | ||
| 6 | Total metres | 1,920 | ||
| 7 | Rate per metre, installed | $4.20 | ||
| 8 | Line description | Cabling, 1,920 m installed | ||
| 9 | Line unit price | $8,064 |
- Counted on the survey
- Your rate
- Connected to a price line
Connected cells editor view
-
Cable!D8DescriptionCable!D9Unit price Cabling, 1,920 m installed1 × $8,064
Build your device calculator in five steps
Done once, in the proposal template.
Import
Import your existing .xlsx into a Spreadsheet block in the proposal template.
Label
Mark the typed counts, your rates and your assumptions so they're easy to check.
Connect
Connect each total's description and price cells to its equipment line (quantity 1).
Bring back
Bring the price table total back into a cell, such as price per device.
Lock
Lock the blocks designers shouldn't change (Business), and check a test proposal.
Device calculator questions
What can a spreadsheet cell change in the proposal?
A cell can be connected to a price line's description and unit price, and a price table total can be brought back into a cell. Quantities, optional items and choices stay on the price table as usual, so connected lines are usually quantity 1.
Is the Spreadsheet block a full spreadsheet?
Yes. It works like Google Sheets: formulas such as SUM, ROUND, ROUNDUP, IF and XLOOKUP, several tabs with cross-tab references, number formats and .xlsx import. It's available on the Essentials plan and up.
Can we import our existing device count spreadsheet?
Yes. Import your .xlsx into the Spreadsheet block, then connect the cells that should set each price line. Your formulas and tabs come with it.
Can survey counts fill the sheet automatically?
Zapier can write values into Spreadsheet block cells, for example counts from a site survey form, and the connected lines follow. Writing cells through the API isn't confirmed, so use Zapier for this.
Can we stop designers changing the formulas?
On the Business plan, content locking locks whole blocks in a template, such as your rates or terms. Locking is by block, not by individual cell.
Does QuoteCloud design the system for us?
No. The counts are your designer's survey and the rates are your own price book. QuoteCloud runs your spreadsheet inside the proposal and connects it to the price table.
Everything a security & fire business sends
From the calculator to the system proposal and the monitoring agreement.
-
CCTV, alarm, access & fire detection proposalsNew systems proposed zone by zone: equipment, cabling, installation and options the client chooses, with a deposit on signing.Explore
-
Monitoring & service agreementsMonitoring tiers and scheduled servicing as repeating charges in the agreement, with an expiry date and a renewal you send.Explore
-
Security & fire templatesReal QuoteCloud templates to start your test reports, defect quotes, installation proposals and service agreements from.Explore
- Inspection & test reportsEach site's routine inspection as a branded report: results by system, the defects found, and the building manager's acknowledgement.
- Defect rectification quotesEvery defect from the inspection as a priced line the building manager ticks to approve, then signs.
- Inspection results to report and quote with MCPAn AI assistant connected through QuoteCloud's MCP service drafts the report and the defect quote from your inspection app's results.
- Annual statements for building ownersYour own year-end summary of every visit, defect and fix at a site, sent for the owner to acknowledge.
- Multi-site & property portfolio quotesOne service agreement per building for a property manager's portfolio, bulk-sent and tracked to signature.
- Building manager sign-off, approvals & depositsApproval rules before big quotes go out, several signers on the client side, and a deposit on signing for new installs.
- Inspection apps, job systems & accountingYour inspection app, job system, CRM and accounts, connected the way each one really connects: MCP, the API, Zapier, Make or natively.
- QuoteCloud implementation for security & fire contractorsYour report and quote templates, defect price book, device calculator and assistant connection set up, and your team trained.
- FAQAnswers to the questions fire services, CCTV, alarm and access control contractors ask most.
Count once, and the proposal prices itself
Free for 14 days. No credit card required.