This is the archive of the data files from the original energy and environmental monitoring system installed in Regents Hall of Natural Sciences. It was operational from September, 2008 through November 2018. It consisted of a Windows 2003 Server running Schneider Electric’s ION Enterprise and ION EEM software. Data was retrieved by ION Enterprise via modbus. Some calculations were performed in ION Enterprise to compute data where there were no meters: a typical floor has meters on the feed to the floor’s switchboard (Category = Feeder), and meters for the lighting (Category = Lighting) and receptacle panels (Category = Receptacle). The computed electrical energy used for mechanical (HVAC) systems would then be: Mechanical = Feeder – (Lighting + Receptacle).
Old Data Files
Exports from this original system are available below. They are broken into files by year and are provided in comma-separated value (csv) format.
Columns
- TimestampUTC – the timestamp in Coordinated Universal Time (UTC) that the observation was made
- Source – the original source name in the monitoring system.
- Location – the location within Regents Hall of Natural Sciences (RNS) that the observation was made
- Category – the type of observation recorded
- Environmental – an observation about the external environment. Sources include the weather station on the roof of RNS, the bump pond below RNS and the bore hole to the north of RNS. Units vary by measurement.
- Feeder – electrical energy provided to the entire building or to one of the floors of the building, in kWh.
- Lighting – electrical energy used to provide lighting, in kWh.
- Receptacle – electrical energy used to power, in kWh.
- Mechanical – electrical energy used to power the RNS mechanical systems, including heating, ventilation and air conditioning (HVAC), in kWh. Note that this is the electrical energy used to distribute the heating and cooling, not the heating and cooling itself. It is primarily circulation pumps, air handlers and similar. Note that this is a calculated value computed by subtracting the lighting and receptacle values from the feeder value. (See disclaimer below.)
- Steam – the energy required to heat RNS in lbs of steam.
- Chilled Water – the energy required to cool RNS in Ton-Hr.
- Measurement – for electrical observations, this is simply kWh delivered – the kilowatt hours delivered in a given interval of time (15 minutes). For environmental observations, this is a human-understandable description of the measurement.
- Value – the actual value of the observation.
Data FILES
Available to St. Olaf users. Read-only.
- stolaf-rns-enviromon-2008.csv (40MB)
- stolaf-rns-enviromon-2009.csv (175MB)
- stolaf-rns-enviromon-2010.csv (383 MB)
- stolaf-rns-enviromon-2011.csv (408 MB)
- stolaf-rns-enviromon-2012.csv (418 MB)
- stolaf-rns-enviromon-2013.csv (422 MB)
- stolaf-rns-enviromon-2014.csv (404 MB)
- stolaf-rns-enviromon-2015.csv (391 MB)
- stolaf-rns-enviromon-2016.csv (404 MB)
- stolaf-rns-enviromon-2017.csv (392 MB)
- stolaf-rns-enviromon-2018.csv (364 MB)
- stolaf-rns-enviromon2020.csv (6.1 MB)
- stolaf-rns-enviromon-2021.csv (10.8 MB)
- stolaf-rns-enviromon-2022.csv (9.0 MB)
Disclaimer about the calculations
A small number the values for the mechanical (HVAC) electrical use show negative numbers. These calculations were performed in the old energy monitoring system. It is unknown why they are negative. For analysis purposes, use the actual observations (Category = Feeder | Electrical | Receptacle) and perform any required calculations at analysis time.