User Manual

Technical Specification Sheet
Rev. 7, March 2016
Document No. 149-198P25
Page 1 of 4
Spreadsheet for InfoCenter Suite
Description
Today's building automation systems are capable of
providing extensive amounts of data that hold
valuable information about a facility’s operation.
Many times this valuable information is overlooked
because of the difficulty in extracting it from
overwhelmingly large data sets. InfoCenter Suite®
is the first step in solving this problem by providing
a means to automatically collect and manage these
data sets. The next step is to turn this data into
valuable information. InfoCenter Spreadsheet is
designed to meet the ongoing facility needs for data
analysis and reporting by allowing you to effectively
turn raw data into meaningful answers.
InfoCenter Spreadsheet integrates the power of
Microsoft® Excel® and InfoCenter Server® to
provide an effective data analysis and reporting
option for the InfoCenter Suite family of software.
InfoCenter Spreadsheet is an add-in to Microsoft
Excel that allows you to dynamically query
InfoCenter-based data. Once the data is made
available to Microsoft Excel, you can take
advantage of the powerful Excel capabilities to find
the answers you need.
As an InfoCenter Suite application, InfoCenter
Spreadsheet benefits from InfoCenter’s data
management capabilities. Specifically designed to
archive, preprocess, manage and retrieve large
amounts of data, InfoCenter Suite provides a solid
foundation for data management. This foundation
allows you to benefit by using Microsoft Excel for
data analysis and reporting, not data management
or archiving. Standard Windows security protocols
combined with InfoCenter Server features ensure
the integrity of the data provided to InfoCenter
Spreadsheet. Advanced point security features in
InfoCenter Server not only ensure accurate data
storage, but also allow system administrators to
manage access to each point.
System Architecture
• InfoCenter Spreadsheet — A Microsoft Excel
add-in designed to convert Excel into an
InfoCenter client application that can
dynamically query the InfoCenter database
and retrieve point data on request. Once data
has been retrieved it can be processed using
any of Excel features and functions.
• InfoCenter Server Advanced or InfoCenter
Server Base — InfoCenter Server is the
application that interfaces with Microsoft SQL
Server to provide automated data collection,
data archiving, data security and advanced
data processing to turn raw data into useful
Information. InfoCenter Server is the engine
behind InfoCenter Spreadsheet.
• Microsoft Excel — InfoCenter Spreadsheet
requires Microsoft Excel (not included with
InfoCenter Spreadsheet). Excel provides
comprehensive tools to help users create,
analyze and share spreadsheets.