2 - Configuration Spreadsheet

Owned by Gary Cane
Last updated: Oct 23, 2023
2 min read

Microsoft Excel™ is used as the primary mechanism to define the configuration of the Overwatch Fire System.  This video below provides an overview of the spreadsheet functionality and description of the sheets, fields, and buttons included in the spreadsheet.  The following topics are covered:

  • Overview of the Spreadsheet Layout and Functionality

    • Reserved Names and Locked Cells

    • Navigation Buttons

    • Find / Replace

    • Template Version

    • Help Pop-up

  • System Details (3:15)

    • Name, Revision, Notes, Time Zone

    • System Normal and Diagram Images

    • System IDs

  • Defining Panels (7:10)

    • Type, Name, Location

    • Display, Acknowledge, Read, Reset, and Sort Modes

    • Network Time Protocol (NTP)

    • System Diagram Pins

    • Battery Type and Display Brightness on Battery

    • Add, Delete, Go To Buttons

  • Adding Panel Details (16:37)

    • Configuring Panel Hardware Components

      • SLC loops

      • Notification Appliance Circuit

      • Releasing Actuation Circuit

      • Ethernet Interface

    • Adding Devices to SLC Loops (24:20)

      • Selecting Model

      • SLC Address and Position in Loop

      • Device Information 1 and 2 (Name and Location)

      • Activation Mode / Custom Thresholds

      • System Diagram Pin Location

      • Fire Related

  • Defining Zones (33:40)

    • Name, Type

    • Activation Mode and Delay

    • Silencing Mode

    • Priority

    • Latching Modes

    • Walk Test

    • NAC Patterns

    • SLC Notification Patterns

    • Add, Delete, Go To Buttons

  • Adding Zone Details (44:00)

    • Warning and Alarm Input and Output ID

    • Adding Individual IDs 

    • Show / Hide Description

    • Zone Association 

    • Adding Groups of IDs with Clipboard

    • 2nd Function System IDs

  • Adding Second Panel (53:15)

    • Adding Annunciator

    • Setting up Local NTP Server

A blank starting spreadsheet (called 'FireSystemExcelDataTemplate.xlsm') can be found in your Design Pad G5 program installation folder and can be used as the starting point for any new configuration.

A copy of the files used to complete configuration shown in the tutorial can be downloaded here (click on each):