Description

A complete control system BOQ template in Excel for PLC, DCS and SCADA projects. It covers controllers, I/O, remote I/O, panels, power supplies, networks, servers, HMI hardware, software licences, engineering, FAT, site commissioning, training, documentation, spares and support. Use it as a client, QS or engineer to issue a control system tender, or as a system integrator to price one.

Control system quotes are hard to compare when every bidder groups hardware, software and engineering differently. This BOQ gives every bidder the same structure, line by line, so offers can be compared like for like.

What’s included in the control system BOQ

• 137 line items across 13 bills and 27 sections
• Bill 1 Preliminaries & Project Management: fixed and time-related items
• Controllers: process controllers and safety controllers (SIS) where specified
• I/O modules and remote I/O: DI, DO, AI, AO, intrinsically safe and SOE modules, head stations and field interface
• Panels, enclosures and power supplies, including UPS and power distribution
• Networks and communications: switches, firewalls, fibre, third-party interfaces and accessories
• Servers, workstations and HMI hardware: SCADA / HMI, historian, asset management, domain and remote access servers, operator and engineering clients
• Software and licences: runtime licences, engineering and system software
• Engineering and application development: design documents, controller and sequence programming, screens, trends, reports, alarms, historian and interface configuration
• Factory acceptance test (FAT), delivery, site services and commissioning
• Training, documentation, spares, warranty and support
• Provisional sums and daywork rates

Built for real tenders

• Supply rate, install rate and S&I rate on every line, with supply, install and total amounts. Engineering and services lines price as install only.
• Supply By and Install By columns. Free-issue and “by others” items drop out of the totals automatically.
• A scope of work under every bill and a reference documents line under every section, plus a drawing register sheet.
• Cost by area or building on the Summary.
• Pricing checks flag lines with a quantity but no rate before you issue or submit.
• Contingency, tax and tender sum carry to a signed tenderer’s declaration on the cover.

Works with the rest of the set

I/O module quantities come straight from the Tender and Claim Control System I/O Counter, which sizes cards, spares and remote I/O stations per panel and controller. For the field side, pair it with the Instrumentation BOQ.

File details

• Microsoft Excel (.xlsx) for Excel 2016 or later, Microsoft 365 and LibreOffice 7 or later. No macros.
• Choose your country: currency labels and tax (GST, VAT or sales tax) update across the file. 17 countries built in, including Australia, South Africa, the UK, the USA and the eurozone.
• Yellow cells are inputs. Formulas on the summary sheets are protected without a password, so they can’t be overwritten by accident.
• Instructions sheet in every file, plus a Read Me PDF with a one-minute quick start.
• Instant download after purchase. Re-download any time from My Account.
• Licensed for use on your own projects. Not for resale or redistribution.

This template is a tool to save you time. It is not legal, quantity surveying or engineering advice. Always check quantities, rates and scope against your contract documents and the selected control platform.