CCTV System Design & Commissioning Checklist (Excel)

This Excel workbook is a working aid for CCTV / IP video surveillance projects. It helps an ELV designer, supervisor or commissioning engineer review a design, keep a camera schedule, and record handover tests in one file.

The Design Review sheet covers ten areas of generic best practice: camera coverage and DORI targets, lens and field of view, lighting and IR, mounting height and hardware, cabling and PoE, NVR storage and retention, network and VLAN, power and UPS, cybersecurity basics, and compliance and handover notes. Each item has a status dropdown (OK, Issue or N/A), a comments column and short guidance. Completed items, open issues and percent complete update automatically.

The Camera Schedule records ID, location, type, resolution, lens, PoE class and watts, switch port, NVR channel and mounting height, with totals for camera count and PoE load.

The Commissioning sheet records system-level tests and per-camera checks (image, focus / FOV, day / night, recording, labelling) as Pass, Fail or N/A, and summarises outstanding snags and handover status. Camera IDs and locations are linked from the schedule.

Yellow cells are inputs; blue cells are formulas. No macros. Works in Microsoft Excel, LibreOffice Calc, Google Sheets and WPS. Sample data for an example office is included; replace it with your own project. This is a working aid, not a certified design. Confirm decisions against the project brief, local codes and manufacturer specifications.

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