Transcript
1. DATA COLLECTION A. There shall be a system in place to collect historical trend data from all relevant systems into a single integrated database. B. The system should be able to be run on any current Windows platform, server or workstation. C. The data shall be stored in a single Microsoft SQL Server database, locally or remotely. D. The system shall be able to collect data from various platforms, including Tridium R2 and Ax systems, Schneider Electric SmartStruxure, and NOAA Weather data and forecasts. E. The system shall allow data to be entered manually for purposes of infrequently changing values, such as utility costs. F. The system shall be capable of generating a backup of the SQL database easily from within its own user interface. G. The system shall be capable of being configured to run its data collections on a regular (e.g. nightly) basis without user interaction. The results of those collections, success or error, shall be automatically emailed to an appropriate person after each collection. The scheduled tasks must run properly even if the workstation is in a locked mode. H. A minimum of a three-year service, support and upgrade plan should be included at no additional fee. 2. REPORTING A. The system shall be capable of generating any number of custom trend reports on an interactive basis, to the screen and to a Microsoft Excel workbook. B. Each report shall be able to include many tabs, each with many columns of points aggregated from any system from which data is collected on the same tab. C. Data shall be able to be presented in both tabular and chart formats. D. Reports shall be easy to create and configure without using SQL programming or any other type of macro or scripting language. E. The system shall be capable of being configured to run the reports on a regular (e.g. nightly) basis without user interaction, emailing the Microsoft Excel workbook to any number of people. F. Data shown in the reports shall include proper formatting, including engineering units, displayed in such a way that they do not render the values in the workbook as text strings instead of numeric values that can be used in calculations and analysis. G. It shall be easy to add aggregate rows to reports, including values for totals, averages, minimum, maximum, and time of minimum and maximum values. H. Reports shall be easily configured to aggregate their data into reports showing only hourly, daily, weekly and monthly totals and averages. I. Reports shall have the ability for the user to create custom calculated columns in a manner similar to Microsoft Excel’s formulas.
J.
It shall be possible to generate the reports onto custom predefined Excel template worksheets. K. It shall be possible to create reports that consist of only exceptions to user-defined conditions, generating and delivering the report only in cases where such exceptions have occurred. L. A minimum of a three-year service, support and upgrade plan should be included at no additional fee.
3. BUILDING PERFORMANCE DASHBOARD A. The system shall be capable of displaying customizable web-based dashboard pages of any of the information collected by the system. The dashboards shall include a choice of display elements, such as gauges, thermometers, images, text and marquees. B. The creation of the dashboards shall be interactive and visual, and require no programming or scripting. C. The dashboards shall be available as a hosted subscription service, requiring no web server or other equipment from the user. D. The dashboards shall be able to be viewed properly on all desktop and mobile devices, including Android and iOS (iPad and iPhone). They should be rendered primarily through HTML5 and JavaScript constructs and shall not require any Adobe technologies to display properly. E. There shall be the ability to cycle through a number of dashboard screens automatically, including logic to redirect the order based on system values.
