Table 4 Identification of outlier values and gap-filling strategies for all data points, and their missing rates.

From: A three-year dataset supporting research on building energy management and occupancy analytics

Data

File name

Column name

Description

Number of data points

Unit

Sampling frequency

Missing rate for 3 years measurement

Specific available time period (if not Jan 2018–Dec 2020)

Gap filling strategy

Outlier criteria

Energy use data

ele.csv

mels_S

Miscellaneous electric load for the South Wing

1

kW

15 min

0.33

 

<10 hours: Linear 10 hours to 1 day: KNN >1 day: MF

<0

mels_N

Miscellaneous electric load for the North Wing

1

kW

15 min

0.20

 

lig_S+

Lighting load for the South Wing

1

kW

15 min

0.18

 

hvac_S

Heating Ventilation and Air Conditioning load for the Sorth Wing

1

kW

15 min

0.08

 

hvac_N

Heating Ventilation and Air Conditioning load for the Nouth Wing

1

kW

15 min

0.08

 

Outdoor environmental data

site_weather.csv

air_temp_set_1

Outdoor air temperature from sensor 1

1

°C

15 min

0.003

 

<0 °C or >50 °C

air_temp_set_2

Outdoor air temperature from sensor 2

1

°C

15 min

0.005

 

dew_point_temperature

Outdoor air dew temperature of sensor 2

1

°C

15 min

0.011

 

relative_humidity_set_1

Outdoor air relative humidity from sensor 1

1

%

15 min

0.009

 

<0

solar_radiation_set_1

Outdoor solar radiation from sensor 1

1

W/m2

15 min

0.009

 

Indoor environmetnal data

zone_temp_sp_c.csv

zone_*_cooling_sp

Cooling temperature setpoint of Zone *

41

°F

5 min

0.05–0.07

Sep 2018–Dec 2020

<32°F or >122°F

zone_temp_sp_h.csv

zone_*_heating_sp

Heating temperature setpoint of Zone *

41

°F

5 min

0.05–0.06

zone_temp_interior.csv

cerc_templogger_*

Zone temperature of interior zone

16

°F

10 min

0.01–0.21

Feb 2018–Dec 2020

zone_temp_exterior.csv

zone_*_temp

Zone temperature of exterior zone

51

°F

1 min

0.15–0.20

 

<1 hour: Linear 1 hour to 10 hours: KNN >10 hours: MF

zone_co2.csv

zone_*_co2

CO2 concentration of each zone

13

ppm

1 min

0–0.1

Aug–Dec 2019, Apr–Dec 2020

<0

HVAC operational data

hp_hws_temp.csv

hp_hws_temp

Heat pump heating water supply temperature

1

°F

1 min

0.14

 

<32°F or >122°F

rtu_sa_t_sp.csv

rtu_*_sat_sp_tn

Roof Top Unit * supply air temperature setpoint (*: 001, 002, 003, 004)

4

°F

1 min

0.15

 

rtu_sa_t.csv

rtu_*_sa_temp

Roof Top Unit * supply air temperature (*: 001, 002, 003, 004)

4

°F

1 min

0.14

 

rtu_ra_t.csv

rtu_*_ra_temp

Roof Top Unit * return air temperature (*: 001, 002, 003, 004)

4

°F

1 min

0.14

 

rtu_ma_t.csv

rtu_*_ma_temp

Roof Top Unit * mixed air temperature (*: 001, 002, 003, 004)++

4

°F

1 min

0.14

 

rtu_oa_t.csv

rtu_*_oa_temp

Roof Top Unit * outdoor air temperature (*: 001, 002, 003, 004)

4

°F

1 min

0.14

 

rtu_sa_fr.csv

rtu_*_fltrd_sa_flow_tn

Roof Top Unit * filtered supply air flow rate (*: 001, 002, 003, 004)

4

CFM+++

1 min

0.14

 

<0

rtu_oa_fr.csv

rtu_*_oa_flow_tn

Roof Top Unit * outdoor air flow rate (*: 001, 002, 003, 004)

4

CFM+++

1 min

0.02

Apr–Dec 2020

rtu_oa_damper.csv

rtu_*_oadmpr_pct

Roof Top Unit * outdoor air damper position (*: 001, 002, 003, 004)

4

%

1 min

0.15

 

rtu_econ_sp.csv

rtu_*_econ_stpt_tn

Roof Top Unit * economizer setpoint (*: 001, 002, 003, 004)

4

°F

1 min

0.14

 

<32°F or >122°F

rtu_sa_p_sp.csv

rtu_*_pa_static_stpt_tn

Roof Top Unit * air pressure static setpoint (*: 001, 002, 003, 004)

4

psi++++

1 min

0.15

 

<0

rtu_plenum_p.csv

rtu_*_fltrd_**_plenum_press_tn

Roof Top Unit * plenum air pressure at floor ** (*: 001, 002, 003, 004; **: gnd_lvl, lvl2)

8

psi++++

1 min

0.14

 

rtu_fan_spd.csv

rtu_*_sf_vfd_spd_fbk_tn

Roof Top Unit * supply fan speed (*: 001, 002, 003, 004)

4

%

1 min

0.14

 

rtu_*_rf_vfd_spd_fbk_tn

Roof Top Unit * return fan speed (*: 001, 002, 003, 004)

4

%

1 min

0.14

 

ashp_meter.csv

aru_001_power_mbtuph

Heat meter for air source heat pump

1

mbtuph+++++

5 min

0.29

Aug–Dec 2020

<10 hours: Linear 10 hours to 1 day: KNN >1 day: MF

ashp_cw.csv

aru_001_cws_temp

Evaporator/Cold water supply temperature

1

°F

5 min

0.01

<32°F or >122°F

aru_001_cwr_temp

Evaporator/Cold water return temperature

1

°F

5 min

0.01

aru_001_cws_fr_gpm

Evaporator/Cold water fow rate

1

CFM+++

5 min

0.02

<0

ashp_hw.csv

aru_001_hws_temp

Condenser/Hot water supply temperature

1

°F

5 min

0.16

Oct 2019–Dec 2020

<32°F or >212°F

aru_001_hwr_temp

Condenser/Hot water return temperature

1

°F

5 min

0.16

aru_001_hws_fr_gpm

Condenser/Hot water fow rate

1

CFM+++

5 min

0.01

<0

uft_fan_spd.csv

zone_*_fan_spd

Supply air fan speed of Zone *

44

%

1 min

0.15–0.23

 

<1 hour: Linear 1 hour to 10 hours: KNN >10 hours: MF

uft_hw_valve.csv

zone_*_hw_valve

Heating water valve position of Zone *

51

%

1 min

0.15–0.25

 

Occupant data

occ.csv

occ_third_south

Occupant counts in the south half of third floor

1

/

1 min

0.0004

May 2018–Feb 2019

occ_fourth_south

Occupant counts in the south half of forth floor

1

/

1 min

0.0004

wifi.csv

wifi_first_south

Wifi connection counts in the south half of first floor

1

/

10 min

0

May–July 2018, Feb–Dec 2020

<10 hours: Linear 10 hours to 1 day: KNN >1 day: MF

wifi_second_south

Wifi connection counts in the south half of second floor

1

/

10 min

0

wifi_third_south

Wifi connection counts in the south half of third floor

1

/

10 min

0

wifi_fourth_south

Wifi connection counts in the south half of forth floor

1

/

10 min

0

  1. +No record for the lighting electricity in the north wing. Note that north and south wings are similar in both floor area and lighting systems.
  2. ++The Mixed Air Temp sensors on the RTUs were proven to be inaccurate due to poor installation and were replaced in early 2021.
  3. +++1 CFM ~ 1.699 m3/h
  4. ++++1 psi ~ 6895 Pa
  5. +++++1 btuph ~ 0.293 W
Back to article page