Still Counting KNX Points Manually in Excel? Try Forward BIM Design, One-Click Data Link from Revit to ETS 📐

Are you still tallying KNX device points with Excel and CAD in conventional KNX projects? Cross-checking drawings against equipment schedules will inevitably lead to rework if even one switch is omitted. The core advantage of forward BIM design is directly converting building models into the ETS device library, eliminating errors by ensuring data consistency from the source.

These are not generic electrical families; they are intelligent families embedded with communication parameters.

• Switch panel families shall contain circuit numbers, group numbers, affiliated zones, and reserved slots for KNX physical addresses.
• Actuator families shall specify channel quantity, load type, and associated line coupler.

  It is recommended to adopt a standardized naming convention sorted by floor and functional zone: for example, A-1F-L1-001 represents the first module on Line 1, 1st Floor, Zone A. This machine-readable naming rule prevents human sorting confusion.

Revit cannot directly generate KNX schedules, so visual programming with Dynamo is required.

Dynamo nodes extract parameters from device families and export data into Excel or CSV files.

The exported schedule shall include a minimum of seven columns: Zone, Line, Physical Address, Module Type, Channel No., Linked Group Address, Remarks.

This step acts as the data bridge between the BIM model and ETS, and the configured script can be reused repeatedly after initial setup.

ETS has a native CSV import function. After formatting the Dynamo-exported file to match the ETS template, complete the import operation.

Upon import, modules will be automatically positioned, parameters populated, and group addresses hierarchically organized following predefined naming rules.

This approach not only saves man-hours but also avoids disputes and rework caused by manual data entry errors in later stages.

Design Phase: Cost estimators generate bill of quantities directly from Revit models

Construction Phase: Installers route conduits and cables per model positioning instead of referencing hard-copy drawings

Operation & Maintenance Phase: Property teams use integrated models and ETS group address schedules as official maintenance drawings

Renovation Phase: Point modifications updated in Revit automatically synchronize to the ETS schedule

Initial Investment: Family creation plus Dynamo script development takes approximately 2–3 person-weeks for the first deployment.

Return on Benefit: Cuts over 60% of man-hours spent on point tallying and cross-verification for a single project, with greater cost advantages across multiple projects.

BIM is not merely a technical gimmick; it is a tool to bridge fragmented information, delivering the most prominent value on complex-scale projects.